NTSB investigations, Outside the U.S.
68 cases where the sequence of events included Hard landing.
Cases per year
| 2009 | 4 |
|---|---|
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 11 |
| 2016 | 7 |
| 2017 | 2 |
| 2018 | 1 |
| 2020 | 5 |
| 2021 | 8 |
| 2022 | 3 |
| 2023 | 5 |
| 2024 | 1 |
| 2025 | 3 |
| 2026 | 4 |
Latest cases
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 DCA26WA336Incident · No injuriesClass 5 · ForeignBoeing 737 · Kuching, MalaysiaNTSB DCA26WA235IncidentClass 5 · ForeignAirbus A321 · Horley, United KingdomNTSB GAA26WA287Incident · No injuriesClass 5 · ForeignCessna 182 · San Antonio, ColombiaNTSB GAA26WA182IncidentClass 5 · ForeignPiper PA60 · Villavicencio, ColombiaNTSB GAA25WA235AccidentClass 5 · ForeignRaytheon B36TC · Norwich, United KingdomNTSB DCA25WA192Incident · No injuriesClass 5 · ForeignBoeing 737 · Ras Al Khaimah, United Arab EmiratesNTSB DCA25WA181IncidentClass 5 · ForeignBoeing 737 · Mexico City, MexicoNTSB GAA24WA111Accident · No injuriesClass 5 · ForeignMooney M20R · Eschbach, GermanyNTSB DCA23WA467OccurrenceClass 5 · ForeignBoeing 767 · Beirut, LebanonNTSB GAA23WA219Accident · Serious injuriesClass 5 · ForeignCessna 206 · Tuzla, RomaniaNTSB GAA23WA131Accident · 1 fatalClass 5 · ForeignCirrus SR22 · Bankstown, AustraliaNTSB GAA23WA079Accident · No injuriesClass 5 · ForeignAMD CH2000 · La Isabela, Dominican RepublicNTSB GAA23WA070Accident · No injuriesClass 5 · ForeignLearjet 60 · North Eleuthera, BahamasNTSB DCA23WA001Accident · No injuriesClass 5 · ForeignBoeing 737 · Nantes, FranceNTSB GAA22WA260Accident · No injuriesClass 5 · ForeignCessna 172 · Malloca, SpainNTSB GAA22WA224Accident · No injuriesClass 5 · ForeignRobinson R44 · Novy township, RussiaNTSB GAA22WA047Accident · No injuriesClass 5 · ForeignMooney M20B · La Aurora, GuatemalaNTSB DCA22WA023IncidentClass 5 · ForeignAirbus A320-214 · Ibague, ColombiaNTSB GAA21WA255AccidentClass 5 · ForeignPiper PA28 · Buckinghamshire, United KingdomNTSB GAA21WA216Accident · No injuriesClass 5 · ForeignCessna 172 · Timisoara, RomaniaNTSB GAA21WA202Accident · No injuriesClass 5 · ForeignRobin HR200 · Proudfootstown, IrelandNTSB GAA21WA157Accident · No injuriesClass 5 · ForeignRobinson R44 · Yalta, RussiaNTSB GAA21WA148AccidentClass 5 · ForeignGulfstream GULFSTREAM200 · Geneva, SwitzerlandNTSB DCA21WA068AccidentClass 5 · ForeignBoeing 737 · Exeter, United KingdomNTSB GAA21WA135Accident · No injuriesClass 5 · ForeignEmbraer EMB-550 · Mérida, MexicoNTSB GAA20WA145Accident · Minor injuriesClass 5 · ForeignPiper PA34 · Cork, IrelandNTSB DCA20WA119Incident · No injuriesForeign investigationBoeing 737 · Banjarmasin, IndonesiaThe government of Indonesia has notified the NTSB of an incident involving a Boeing 737-800 airplane that occurred on June 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the…NTSB DCA20WA093Accident · No injuriesClass 5 · ForeignBoeing 767 · Shannon, IrelandNTSB ENG20WA020Incident · No injuriesForeign investigationAirbus A321 · Antalya, TürkiyeThe NTSB has received notification of an incident investigation by the Interstate Aviation Committee (MAK) of Russia of an Airbus A321, Registration VQ-BRS, that experienced a nose landing gear (NLG) failure while landing at the Antalya airport (LTAI) on…NTSB CEN18WA379Accident · No injuriesForeign investigationPiper PA32 · Belize City, BelizeOn August 29, about 1804 local time (LCL), a Piper PA32 300 airplane, N3073W, operated by Wings of Hope, had a hard landing at the Sir Barry Bowen Municipal Airport, in Belize City, Belize. The airplane originated from the San Pedro Airport.This investigation…NTSB ENG17WA035Accident · Minor injuriesForeign investigationSikorsky 300 · Herzelia, IsraelThe Ministry of Transport of the State of Israel, has notified the NTSB of an accident involving a Sikorsky S-300C, registration 4X-BIM, that occurred on August 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the investigation…NTSB DCA17WA160Accident · No injuriesForeign investigationBoeing 737 · Wamena, IndonesiaThe KNKT of Indonesia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 18, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions of…NTSB DCA17WA048Incident · No injuriesForeign investigationBoeing 737 · Addis Ababa, EthiopiaThe Ethiopia Accident Investigation Bureau (AIB) has notified the NTSB of an incident involving a Boeing 737-800 airplane that occurred on December 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist AIB's investigation under the…NTSB CEN17WA056Accident · No injuriesForeign investigationRobinson R22 · Cannes, FranceOn December 12, 2016, at 1300 Coordinated Universal Time (UTC), a Robinson R-22 helicopter, French registration F-HALD, was destroyed following impact with terrain during a practice autorotation near Cannes-Mandelieu Airport (LFMD), France. The two occupants…NTSB ERA16WA292Accident · Serious injuriesForeign investigationEurocopter AS355 · Santo Domingo, Dominican RepublicOn August 14, 2016, about 2040 coordinated universal time, a Eurocopter AS355 F2, Dominican registration HI-861, was substantially damaged during a hard landing at the La Isabela International Airport (MDJB), Santo Domingo, Dominican Republic. The pilot was…NTSB DCA16WA219Accident · No injuriesForeign investigationRobinson R66 · Drakensburg Mountain, South AfricaThe government of South Africa has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on August 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…NTSB DCA16WA216Incident · No injuriesForeign investigationBoeing 737 · Mbuji Mayi, Congo - KinshasaThe government of Democratic Republic of Congo (DRC) has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on August 02, 2016. The NTSB has appointed a U.S. Accredited Representative to DRC under the provisions of ICAO Annex 13 as…NTSB DCA16WA244Incident · No injuriesForeign investigationBoeing 737 · Apia, AntarcticaThe government of American Samoa has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of American Samoa's investigation under the…NTSB CEN16WA152Accident · Minor injuriesForeign investigationPiper PA32R · Hampshire, United KingdomOn April 12, 2016, at 1300 coordinated universal time, a Piper PA-32R-301T airplane, G-MAIE, experienced a hard landing at the Daedalus Airfield (EGHF), Hampshire, United Kingdom. The pilot was not seriously injured, and the airplane sustained damage to the…NTSB DCA16WA024Accident · No injuriesForeign investigationBoeing 737 · Osh, KyrgyzstanThe government of Kyrgyzstan has notified the NTSB of an accident involving a Boeing 737-300 airplane that occurred on November 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Kyrgyzstan's investigation under the…NTSB ERA16WA048Accident · No injuriesForeign investigationRobinson R66 · Sirinhaem Municipality, BrazilOn November 11, 2015, about 1755 coordinated universal time, a Robinson R66, Brazilian registration PR-EDL, was substantially damaged during an emergency autorotation near Sirinhaem, State of Pernambuco, Brazil, when the main rotor blades contacted and…NTSB DCA15WA189Incident · No injuriesForeign investigationBritish Aerospace Civil Aircr BAe 146-200 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a British Aerospace BAe-146, which occurred on August 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…NTSB CEN15WA372Accident · No injuriesForeign investigationBeech A100 · Margaree, CanadaOn August 16, 2015, at 1910 UTC, a Beechcraft A100, Canadian registration C-FDOR, was substantially damaged following a hard landing at Margaree, Nova Scotia, Canada (CCZ4). The four people onboard were not injured. The accident investigation is under the…NTSB CEN15WA438Accident · Minor injuriesForeign investigationHughes 369 · Ramatuelle, France, FranceOn August 4, 2015, a Hughes 369 helicopter, D-HBRM, was substantially damaged after impact with terrain near Ramatuelle, France. The pilot and passenger suffered minor injuries. This investigation is under the jurisdiction and control of the French…NTSB ERA15WA284Accident · Serious injuriesForeign investigationRobinson R66 · Baykalsk, RussiaNTSB ERA15WA211Accident · Minor injuriesForeign investigationBell 430 · Aydin, TürkiyeOn April 26, 2015, at 1322 coordinated universal time, a Bell 430, Turkish-registered TC-HSZ, was substantially damaged following a hard landing near Aydin, Turkey. The pilot and co-pilot were not injured. Two passengers sustained minor injuries, and three…NTSB DCA15WA107Accident · No injuriesForeign investigationBoeing 737 - 804 · Khajuraho, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a BOEING 737 that occurred on April 13, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…NTSB WPR15WA171Accident · Serious injuriesForeign investigationSikorsky S76 - C · East Kalimantan, IndonesiaOn March 21, 2015, about 1030 local time, a Sikorsky S-76C+ helicopter, registration PK-FUP, sustained substantial damage following an emergency landing near East Kalimantan, Indonesia. Reports indicate that the two pilots received serious injuries and five…NTSB CEN15WA110Incident · No injuriesForeign investigationGulfstream G200 · Luton, United Kingdom, United KingdomOn January 14, 2015, about 2127 universal time (UTC), a Spanish registered Gulfstream G200, EC-KRN, sustained minor damage during landing at London Luton Airport, Luton, United Kingdom. The pilot, copilot, and six passengers were not injured. The four main…NTSB DCA15WA049Accident · Minor injuriesForeign investigationBoeing 737 · Accra, Ghana