NTSB investigations, 2016, Outside the U.S.
6 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 | 8 |
| 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\") = 2016
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") = 2016 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 DCA17WA056Incident · No injuriesForeign investigationBoeing 737 · Paris, FranceThe Bureau d'Enquêtes et d'Analyses (BEA) of France has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on December 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's…NTSB WPR17WA039Accident · 1 fatalForeign investigationRobinson R44 · Juhu, IndiaNTSB DCA16WA229Incident · No injuriesForeign investigationPulse Vapor 55 · Ballina, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Pulse Vapor 55 unmanned helicopter that occurred on September 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation…NTSB DCA16WA104Incident · No injuriesForeign investigationBoeing 747 · Jeddah, Saudi ArabiaThe government of Saudi Arabia has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on March 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Saudi Arabia's investigation under the…NTSB CEN16WA110Accident · No injuriesForeign investigationPiper PA23 · Saint François, GuadeloupeOn February 22, 2016, a Piper PA-23-250 airplane, N539EG, sank after ditching near the Saint François Airport (TFFC), Saint François, Guadeloupe (France). The pilot was not injured.This investigation is under the jurisdiction and control of the French…NTSB ANC16WA070Accident · No injuriesForeign investigationPiper PA-28-140 · St Andrews, CanadaOn February 13, 2016, about 2039 Coordinated Universal Time (UTC), a Piper PA-28-140 airplane, (Canadian Registration C-GQPN) was on approach to St. Andrews, MB (CYAV) with an instructor and a student on board. Prior to touch down at approximately 50 feet…