NTSB investigations, 2015, Outside the U.S.
3 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\") = 2015
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") = 2015 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 DCA16WA081Accident · No injuriesForeign investigationGulfstream G1159 · Kinshasa, Congo - KinshasaThe government of Democratic Republic of Congo (DRC) has notified the NTSB of an accident involving a Gulfstream G1159 airplane that occurred on November 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of DRC's…NTSB CEN15WA393Accident · No injuriesForeign investigationBeech C90 · Helsinki, FinlandOn August 26, 2015, at 0535 universal coordinated time, a Beechcraft C90 airplane, Finnish registration OH-BEX, owned and operated by Scanwings Oy, sustained substantial damage when the nose landing gear collapsed during landing at the Helsinki-Vantaa…NTSB DCA15WA123Incident · No injuriesForeign investigationBoeing 737 - 8B6 · Madrid, SpainThe Director General of Civil Aviation of Morocco has notified the NTSB of an incident involving a Boeing 737-800 airplane, which occurred on April 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Director General of Civil…