NTSB investigations, 2016, Outside the U.S.
12 cases where the sequence of events included Landing gear collapse.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 2 |
| 2011 | 6 |
| 2012 | 6 |
| 2013 | 3 |
| 2014 | 7 |
| 2015 | 9 |
| 2016 | 12 |
| 2017 | 10 |
| 2018 | 10 |
| 2019 | 11 |
| 2020 | 6 |
| 2021 | 13 |
| 2022 | 13 |
| 2023 | 12 |
| 2024 | 14 |
| 2025 | 12 |
| 2026 | 7 |
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 year(c.\"eventDate\") = 2016
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '094' 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 year(c."eventDate") = 2016 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '094' 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 DCA17WA078Accident · No injuriesForeign investigationBoeing 737 · Kabul, AfghanistanThe government of Afghanistan has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on December 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Afghanistan's investigation under the…NTSB GAA17WA583Incident · No injuriesClass 5 · ForeignBellanca 7GCBC · Budaors, HungaryNTSB CEN17WA141Accident · No injuriesForeign investigationReims 406 · Oulu, FinlandOn October 3, 2016, a Reims F406 Caravan II aircraft, registered OH-OTL, experienced a landing gear failure while landing at Oulu Airport, Finland. The airplane was substantially damaged. The two pilots onboard were uninjured. The accident is being…NTSB ENG17WA001Accident · No injuriesForeign investigationBoeing 737 · Aldergrove, United KingdomOn October 4, 2016, a Boeing 737-400 experienced a partial right main gear failure during the landing roll at Belfast International Airport (EGAA), Aldergrove, Northern Ireland, United Kingdom. The flight originated from East Midlands Airport (EGNX),…NTSB ERA17WA004Accident · No injuriesForeign investigationCessna 208 · Contamana, PeruOn October 3, 2016, about 1530 universal coordinated time, a Cessna 208B, Peruvian registration OB-1998-P, was substantially damaged when the left main landing gear separated from the airplane while taxiing at Contamana Airport (SPCM), Contamana, Peru. The…NTSB DCA16WA225Accident · No injuriesForeign investigationBoeing 737 · Papua, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…NTSB ERA16WA335Incident · No injuriesForeign investigationPiper PA34 · Yurimaguas, PeruOn June 4, 2016, at 1712 universal coordinated time, a Piper PA-34-200T, Peruvian registration OB-1564, was substantially damaged when the nose landing gear collapsed during landing at Moises Benzaquen Rengifo Airport (SPMS), Yurimaguas, Peru. The pilot and…NTSB ENG16WA022Accident · Minor injuriesForeign investigationBeech 1900 · Gander, CanadaThe Transportation Safety Board of Canada has notified the NTSB of an accident involving a Beechcraft 1900D, which occurred on April 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Transportation Safety Board of Canada…NTSB ANC16WA026Incident · No injuriesForeign investigationCirrus SR22 · Kagoshima, JapanOn March 21, 2016 , about 1320 Local Time, a Cirrus SR22 airplane, Japan registration number JA01YK, operated by the pilot, sustained minor damage following a fracture of the nose landing gear strut during landing at the Kagoshima Airport, Japan. The pilot…NTSB ENG16RA017Accident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Jet Airways Boeing 737, which occurred on March 3, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accident Investigation…NTSB ENG16WA019Incident · No injuriesForeign investigationBoeing 767 · Domodedovo, RussiaInitial Notification sent to NTSB by the Ministry of Transport of the Russian Federation. The Ministry of Transport of the Russian Federation has appointed Federal Air Transport Agency (FATA) to investigate the incident of an Azurair Airlines B767-300…NTSB CEN16WA148Accident · No injuriesForeign investigationCessna 402 · Leicestershire, United KingdomThe Air Accidents Investigation Branch (AAIB) United Kingdom has notified the NTSB of an accident involving a Cessna 402B, Registration G-MAPP, that occurred on January 14, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…