NTSB investigations, 2011, Outside the U.S.
2 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\") = 2011
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") = 2011 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 DCA13WA052Incident · No injuriesForeign investigationBeech 1900 · Goose Bay, CanadaOn 10 December 2011, at 1028 Newfoundland Standard Time, an Exploits Valley Air Services Hawker Beechcraft 1900D aircraft (registration C-GLHO, serial number UE-266), operating as Air Canada Express flight EV7645, was conducting a scheduled passenger flight…NTSB DCA12WA007Accident · No injuriesForeign investigationBoeing 737 - 800 · Faro, PortugalTheAir AccidentInvestigation Unit (AAIU) ofIrelandhas notified the NTSB of an accidentinvolving a B737-8AS that occurred on October 20, 2011. The NTSBhas appointed a U.S. Accredited Representative to assist the AAIU investigationunder the provisions of ICAO…