NTSB investigations, 2012, MI
5 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
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\") = 2012
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") = 2012 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 CEN12LA490Accident · Serious injuriesLimited investigationFinal reportSmith Applebay Zuni II · Gregory, MIThe glider pilot’s failure to maintain sufficient altitude and airspeed while turning to the base leg of the traffic pattern, which resulted in a stall/spin and impact with trees and terrain.NTSB CEN12LA330Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-27 · Ionia, MIThe pilot's failure to maintain a proper airspeed in gusting wind conditions, which resulted in an inadvertent stall while maneuvering at an altitude that did not provide a margin for recovery.NTSB CEN12LA318Accident · Serious injuriesLimited investigationFinal reportAeros Ltd/Skyranger Skyranger II · Saline, MIThe pilot did not maintain proper control of the airplane while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB CEN12CA294Accident · Serious injuriesData collectionFinal reportBeckert Bruce A RV-6 · Au Gres, MIThe pilot’s low altitude maneuvering, which resulted in an inadvertent stall and subsequent impact with the water.NTSB CEN12LA231Accident · Serious injuriesLimited investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Ann Arbor, MIThe student pilot's failure to maintain airplane control on takeoff, which resulted in an aerodynamic stall and collision with terrain.