Two tourists and a pilot have died after a plane crashed into the sea near a tourism hotspot.