NTSB investigations, 2020, Outside the U.S.
6 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\") = 2020
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") = 2020 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 DCA21WA019Incident · No injuriesClass 5 · ForeignFairchild 227 · Mendoza, ArgentinaNTSB WPR21WA026AccidentClass 4 · ForeignPiper PA46 · Limpopo Province, South AfricaNTSB DCA20WA140Accident · No injuriesClass 5 · ForeignBoeing 767 · Bucure?ti, RomaniaNTSB CEN20WA243Incident · No injuriesForeign investigationCessna P210 · Wevelgem, BelgiumThe government of Belgium has notified the NTSB of an accident involving a Cessna P210 airplane that occurred on June 03, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions of…NTSB DCA20WA073Incident · No injuriesForeign investigationBoeing 757 · Keflavik, IcelandThe Icelandic Transportation Safety Board (ITSB) has informed the NTSB of an incident involving a Boeing 757-200, which occurred on February 7, 2020. The NTSB has appointed a U.S Accredited Representative to assist the ITSB investigation under the provisions…NTSB GAA20WA105Accident · Minor injuriesForeign investigationCessna 172 · Cork, IrelandThe government of Ireland has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on January 06, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…