NTSB investigations, 2020, Outside the U.S.
7 cases where the sequence of events included Sys/Comp malf/fail (non-power).
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 7 |
| 2013 | 1 |
| 2014 | 5 |
| 2015 | 3 |
| 2016 | 10 |
| 2017 | 8 |
| 2018 | 5 |
| 2019 | 6 |
| 2020 | 7 |
| 2021 | 14 |
| 2022 | 13 |
| 2023 | 20 |
| 2024 | 10 |
| 2025 | 18 |
| 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\" = '330' 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" = '330' 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 CEN21WA038Incident · No injuriesClass 5 · ForeignCessna 208 · Pickle Lake, CanadaNTSB ENG21WA005IncidentClass 5 · ForeignATR ATR72 · Makassar, IndonesiaNTSB CEN20WA418Incident · No injuriesClass 4 · ForeignSikorsky S92 · Sola, NorwayNTSB DCA20WA141Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…NTSB GAA20WA115Incident · No injuriesForeign investigationBeech 900XP · Paris, FranceThe government of France has notified the NTSB of an accident involving a BEECH 900XP airplane that occurred on June 26, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB DCA20WA094Incident · No injuriesForeign investigationBoeing 737 · Monterrey, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 27, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…NTSB WPR20WA106Incident · No injuriesForeign investigationAerospatiale AS350 · Bankstown Aerodrome, AustraliaThe government of Australia has notified the NTSB of an accident involving a Aerospatiale AS350 helicopter that occurred on February 05, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…