NTSB investigations, 2015
4 cases where the sequence of events included Inflight upset.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 7 |
| 2011 | 5 |
| 2012 | 9 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 4 |
| 2017 | 5 |
| 2018 | 7 |
| 2019 | 6 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 7 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '271' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '271' 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 ERA16FA006Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · Erwin, TNThe pilot's decision to fly into a known area of adverse weather, which resulted in the airplane entering a severe thunderstorm and a subsequent loss of control.NTSB CEN15FA268Accident · 1 fatalField investigationFinal reportPiper PA 32 · Cuba, MOThe pilot's continued flight into thunderstorm activity, which resulted in his loss of airplane control, the exceedance of the airplane's design limits, and its subsequent in-flight breakup. Contributing to the accident was the pilot's reliance on onboard…NTSB GAA15CA051Accident · No injuriesData collectionFinal reportPiper PA 32R-300 · Gatlinburg, TNThe pilot's encounter with extreme turbulence during descent over mountainous terrain, which resulted in a loss of control, and structural damage in flight.NTSB CEN15FA126Accident · 2 fatalField investigationFinal reportEnstrom 280FX · Erie, COAn in-flight failure of the helicopter's #2 main rotor spindle due to undetected fatigue cracking, which resulted in an in-flight breakup. Contributing to failure were the nonconforming thread root radius of the spindle and the manufacturer's failure to…