NTSB investigations, Outside the U.S.
62 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '092') 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 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 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 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.