NTSB investigations, 2020, Outside the U.S.
6 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 11 |
| 2013 | 12 |
| 2014 | 5 |
| 2015 | 12 |
| 2016 | 10 |
| 2017 | 7 |
| 2018 | 11 |
| 2019 | 10 |
| 2020 | 6 |
| 2021 | 10 |
| 2022 | 18 |
| 2023 | 20 |
| 2024 | 19 |
| 2025 | 32 |
| 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 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\" = '900' 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" = '900' 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 DCA21WA065IncidentClass 5 · ForeignBoeing 737 · Khartoum, SudanNTSB DCA20WA144Incident · No injuriesForeign investigationBoeing 737 · West Midland, United KingdomThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…NTSB DCA20WA078Incident · No injuriesForeign investigationBoeing 737 · East Midlands, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 09, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…NTSB DCA20WA068Incident · No injuriesForeign investigationBoeing 737 · Madrid, SpainThe Comision de Investigacion de Accidentes y Incidentes de Aviacion Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Boeing 737-300, which occurred on February 2, 2020. The NTSB has appointed a U.S Accredited Representative to assist…NTSB DCA20WA063Incident · No injuriesForeign investigationAirbus A300 · Bogota, ColombiaThe government of Colombia has notified the NTSB of an incident involving a AIRBUS A300 airplane that occurred on January 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB WPR20WA129Accident · Minor injuriesClass 5 · ForeignCessna U206G · Happy Valley, Australia