NTSB investigations, Outside the U.S.
68 cases where the sequence of events included Hard landing.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR14WA128Accident · No injuriesForeign investigationHughes 369D · Moonlight Creek, New Zealand, New ZealandOn February 25, 2014, at 2055 universal coordinated time, a Hughes 369D, ZK-IQQ, was substantially damaged when the main rotor blades contacted and severed the tailboom at the conclusion of an autorotation and landing near Moonlight Creek, New Zealand. The…NTSB DCA14WA056Accident · Serious injuriesForeign investigationBoeing 737-900 · Surabaya, IndonesiaThe Indonesian National Transportation Safety Committee (NTSC) has notified the NTSB of an accident involving a Boeing 737-900 that occurred on February 1, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC investigation under…NTSB DCA14WA059Incident · No injuriesForeign investigationBoeing 737 · Grand Cayman, Cayman IslandsThe Air Accidents Investigation Branch of the UK (AAIB-UK) has notified the NTSB of an accident involving a Boeing 737 that occurred on January 15, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB-UK's investigation under the…NTSB CEN14WA068Accident · No injuriesForeign investigationBell 407 · Rio Ablajo, HondurasOn November 16, 2013, approximately 1030 central standard time, a Bell 407 helicopter, HR-AXO, sustained substantial damage during a hard landing for undetermined reasons near Rio Ablajo, Honduras. The pilot and six passengers were not injured. Visual…NTSB ERA13WA439Accident · No injuriesForeign investigationBell 206B · Matoes do Norte, BrazilOn August 30, 2013, at 1555 coordinated universal time (1255 local time), a Bell 206B, Brazilian registration PT-HUE, was substantially damaged following a loss of engine power and a subsequent forced landing in Matões do Norte, Maranhão, Brazil. The pilot…NTSB DCA13WA110Accident · No injuriesForeign investigationSaab 340 · Mangrove Cay, BahamasThe Air Accident Investigation and Prevention Unit (AAIPU) of the Bahamas, has notified the NTSB of an accident involving a SAAB 340 that occurred on June 13, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIPU investigation…NTSB DCA13CA008Accident · No injuriesData collectionFinal reportBombardier DHC-8-315 · Kabul, Afghanistanthe captains ineffective management of the airplanes energy state during final approach and flare that resulted in a hard landing and tail strike at touchdown.NTSB DCA12WA097Accident · No injuriesForeign investigationBoeing 767 · Tokyo, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 767-300 that occurred on June 20, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex…NTSB DCA12CA023Accident · No injuriesData collectionFinal reportUniversity Of Kansas Meridian · McMurdo, AYan aerodynamic stall induced by an inadvertent autopilot Home command. The Home command was entered following a loss of the direct radio link due to improperly set failsafe settings, and an unintentional latching of Home mode from an earlier functionality…NTSB WPR11WA285Accident · Serious injuriesForeign investigationBell 407 · Ladpur, India, IndiaOn June 19, 2011, at 0854 universal coordinated time, a Bell 407, VT-SWA, crashed during landing at Ladpur, Dehradun, India. The pilot and passenger were seriously injured and the helicopter was substantially damaged. The helicopter was operated by M/s Swajas…NTSB DCA11WA079Accident · No injuriesForeign investigationAirbus Airbus A330 · Caracas, VenezuelaOn April 13, 2011, about 1855 UTC, an Airbus A330-200, F-GZCB, experienced a hard landing at Simon Bolivar International Airport (CCS), Caracas, Venezuela. No injuries occurred. The flight was registered to and operated by Air France. Visual meteorological…NTSB DCA11WA002Accident · No injuriesForeign investigationBoeing 767 · Bristol, United KingdomOn October 3, 2010, at 0541 UTC, a Thompson Airways Boeing 767 experienced a hard landing at Bristol International Airport (BRS), Bristol, England. The aircraft was completing a flight from Cancun International Airport (CUN), Cancun, Mexico. Upon parking,…NTSB DCA10RA085Accident · 1 fatalForeign investigationBoeing 737 · San Andres Island, ColombiaOn August 16, 2010, at 0150 UTC, an Aires B737-700, registration HK4682, crashed on approach to the San Andres Island Airport in San Andres Island, Colombia. Of the 121 passengers and 6 crew on board, preliminary reports indicate that there was one fatality…NTSB WPR10WA114Accident · No injuriesClass 5 · ForeignCessna 182 · Palau International Airport, PalauOn January 4, 2010, about 1300 Palau standard time, a Cessna 182P, registered T8A182P, with amphibian floats, landed hard on runway 09 at Palau International Airport, Republic of Palau. The airplane was registered to, and operated by, ABA Sky, Inc. The…NTSB WPR10WA148Accident · Serious injuriesForeign investigationRobinson R-44 · Montreal, Canada, CanadaOn December 16, 2009, at 0720 eastern standard time, a Robinson R-44, Canadian registered C-GDSF, executed an emergency landing near the Bonaventure Highway, in Montreal, Canada. The pilot and passenger were seriously injured, and the helicopter was…NTSB WPR10CA077Accident · No injuriesData collectionFinal reportPilatus Britten-Norman BN-2B-26 · Pago Pago, AntarcticaThe pilot's action to maneuver the airplane to avoid a collision with a flock of birds while on final approach, resulting in a hard landing. Contributing to the accident were the birds.NTSB DCA09WA078Accident · No injuriesForeign investigationRobinson R44 · Annerdale, South AfricaOn September 25, 2009, about 2100 UTC, ZS-RMN, a Robinson R44, operated by National Airways Corporation, landed hard during an autorative landing near Annerdale, South Africa. The pilot and passenger were not injured. The helicopter was substantially damaged.…NTSB ERA09WA153Accident · Minor injuriesForeign investigationCessna 421B · Nassau, BahamasOn January 29, 2009, at 2130 eastern daylight time, a Cessna 421B, Bahamian registration C6-DXL, operated by a private individual as an air ambulance, experienced a loss of engine power while on approach to the Lynden Pindling International Airport (MYNN),…