NTSB investigations, 2019, MI
4 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2009 | 3 |
|---|---|
| 2010 | 1 |
| 2011 | 7 |
| 2012 | 5 |
| 2013 | 2 |
| 2014 | 1 |
| 2016 | 3 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 3 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 2 |
Where
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\") = 2019
AND c.\"eventStateOrRegion\" = 'MI' 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\" = '241' 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") = 2019 AND c."eventStateOrRegion" = 'MI' 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" = '241' 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 CEN20LA017Accident · Serious injuriesClass 3 · LimitedFinal reportSocata TB 30 Epsilon · Kalamazoo, MIA total loss of engine power for undetermined reasons, which resulted in an aerodynamic stall during the pilot’s attempted forced landing at low altitude and impact with terrain.NTSB CEN20FA001Accident · 5 fatalClass 3 · FieldFinal reportSocata TBM 700 · Lansing, MIThe pilot’s failure to maintain airspeed during final approach, which resulted in a loss of control and an aerodynamic stall at a low altitude, and his decision to operate the airplane outside of the approved weight and balance envelope.NTSB CEN19LA242Accident · Serious injuriesLimited investigationFinal reportIcon A5 · Lake, MIThe pilot's improper decision to operate the airplane in exceedance of the airplane manufacturer’s operating limitations, which led to an aerodynamic stall. Contributing to the accident was the pilot's improper decision to continue attempting the takeoff…NTSB CEN19LA214Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA18 · Bay City, MIThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack during a banner drop and pickup, which resulted in an aerodynamic stall and a subsequent loss of control.