NTSB investigations, 2020, Outside the U.S.
9 cases where the sequence of events included Controlled flight into terr/obj (CFIT).
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 10 |
| 2010 | 8 |
| 2011 | 27 |
| 2012 | 21 |
| 2013 | 23 |
| 2014 | 10 |
| 2015 | 20 |
| 2016 | 17 |
| 2017 | 13 |
| 2018 | 13 |
| 2019 | 17 |
| 2020 | 9 |
| 2021 | 11 |
| 2022 | 11 |
| 2023 | 8 |
| 2024 | 13 |
| 2025 | 9 |
| 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\" = '120' 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" = '120' 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 GAA20WA133Accident · 4 fatalForeign investigationCommander 114 · Fur airport, DenmarkThe government of Denmark has notified the NTSB of an accident involving a COMMANDER 114 airplane that occurred on August 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the…NTSB CEN20WA376Accident · 1 fatalForeign investigationCanadair CL215 1A10 · Lobios (Ourense), PortugalThe Comision de Investigacion de Accidentes y Incidentes de Aviacion Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Canadair CL-215-1A10 airplane, which occurred on August 8, 2020. The NTSB has appointed a U.S Accredited…NTSB GAA20WA126Accident · 4 fatalForeign investigationCessna 172 · Blatten - VS, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on July 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB GAA20WA113Accident · 2 fatalForeign investigationRobinson R22 · Strzegom city, PolandThe government of Poland has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on June 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Poland's investigation under the provisions…NTSB GAA20WA112Accident · 1 fatalForeign investigationPiper PA25 · Vereda Brisas de Guaiquitia, ColombiaNTSB CEN20WA135Accident · 1 fatalForeign investigationPiper PA25 · Tepalcatepec, Michoacán, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on March 15, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN20WA124Accident · 2 fatalForeign investigationCessna 150 · Les Cedres, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on February 17, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB CEN20WA102Accident · 1 fatalForeign investigationRobinson R44 · Tuzantan, MexicoOn January 25, 2020, about 1858 hours universal coordinated time, a Robinson R-44II helicopter, Mexican registration XB-KQV, impacted terrain near Tuzantan, Chiapas, Mexico. The pilot was fatally injured. The flight departed Ángel Albino Corzo / Tuxtla…NTSB WPR20WA083Accident · 2 fatalForeign investigationCessna 182 · Tangalooma, AustraliaThe government of Australia has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…