The shooting down of a U.S. F/A-18 Super Hornet by its own Navy cruiser highlights the inherent risks involved in military operations, especially in volatile regions like the Red Sea.