NTSB investigations, 2017, Outside the U.S.
10 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\") = 2017
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") = 2017 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 DCA18WA054Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe government of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on December 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of…NTSB DCA18WA029Accident · No injuriesForeign investigationCanadair CL 600 2A12 · Caracas, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CANADAIR LTD CL 600 2A12 airplane that occurred on December 04, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation…NTSB DCA17WA200Incident · No injuriesForeign investigationBoeing Boeing 737-8AS · London, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO…NTSB CEN17WA299Accident · No injuriesForeign investigationPiper PA23 · West Sussex, United KingdomOn June 30, 2017, at 1542 hours universal coordinated time, a Piper PA-23-250, United Kingdom registration G-BCCE, experienced a landing gear system failure while landing at the Shoreham Airport, West Sussex, United Kingdom. The two occupants on-board were…NTSB ERA17WA255Accident · No injuriesForeign investigationCessna 210 · Germiston, South AfricaOn June 29, 2017, about 0602 coordinated universal time, Cessna 210A, South African registration ZS-SOK, was substantially damaged after the left main landing gear collapsed during landing at Rand Airport (FAGM), Germiston, South Africa. The pilot and a…NTSB DCA17WA132Incident · No injuriesForeign investigationBoeing 737 · Santa Cruz, BoliviaThe government of Bolivia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 25, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the provisions of…NTSB ERA17WA200Accident · No injuriesForeign investigationPiper PA34 · San Lorenzon, PeruThe government of Peru has notified the NTSB of an accident involving a PIPER PA34 airplane that occurred on May 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…NTSB CEN17WA159Accident · No injuriesForeign investigationGulfstream Aerospace GIV X (G450) · Salzburg, AustriaOn April 11, 2017, about 0830 hours universal coordinated time, a Gulfstream Aerospace GIV-X (G450) airplane, United States registration N667HS, was substantially damaged when the nose landing gear collapsed after landing at the Salzburg Airport (LOWS),…NTSB DCA17WA080Accident · No injuriesForeign investigationBoeing 737 · Ardabil, IranThe government of Iran has notified the NTSB of an accident involving a BOEING 737-400 airplane that occurred on March 27, 2017. The Aircraft Accident Investigation Board of the Civil Aviation Organization of the Islamic Republic of Iran is conducting an…NTSB ERA17WA111Accident · No injuriesForeign investigationSaab 340 · Freeport, BahamasThe government of Bahamas has notified the NTSB of an accident involving a SAAB 340 airplane that occurred on February 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…