NTSB investigations, 2020, Outside the U.S.
7 cases where the sequence of events included Flight control sys malf/fail.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 6 |
| 2017 | 3 |
| 2018 | 5 |
| 2019 | 2 |
| 2020 | 7 |
| 2021 | 12 |
| 2022 | 6 |
| 2023 | 5 |
| 2024 | 9 |
| 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\" = '333' 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" = '333' 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 DCA21WA033IncidentClass 5 · ForeignBoeing 737 · Capetown, South AfricaNTSB DCA20WA151Incident · No injuriesClass 5 · ForeignBombardier CL600 2D24 · Gallivare, SwedenNTSB CEN20WA434IncidentClass 5 · ForeignRaytheon Hawker · Le Bourget, FranceNTSB DCA20LA100Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S61 · Camp Dwyer, AfghanistanFatigue cracking of the auxiliary servo cylinder’s pedal damper check valve housing and its bolts, which caused the sudden and uncommanded movement of the helicopter’s left pedal and a subsequent left yaw that continued until ground impact. Contributing to…NTSB WPR20WA317Accident · No injuriesClass 5 · ForeignRobinson R44 · Mareeba Aerodrome, AustraliaNTSB DCA20WA074Incident · No injuriesForeign investigationBoeing 757 · San Jose, Costa RicaThe Consejo Technico de Aviacion Civil (CTAC)of Costa Rica notified the NTSB of an incident involving a Boeing 757-2B7, which occurred on February 9, 2020. The NTSB has appointed a U.S. Accredited Representative to assist under the provisions of ICAO Annex 13…NTSB ENG20WA034Incident · No injuriesForeign investigationBombardier CL600 2C10 · Lyon Saint Exupéry Airport, FranceThe BEA of France has notified the NTSB of an incident involving a Bombardier CL600-2C10 airplane that occurred on January 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the BEA of France's investigation under the provisions of…