Shock footage has captured the terrifying moment a plane corkscrewed and then nosedived into the sea, leaving the pilot ...