A German naval frigate taking part in a European mission in the Red Sea has mistakenly opened fire on an American MQ-9 Reaper drone, nearly shooting it down.