NTSB investigations, 2012, MI
10 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 9 |
| 2010 | 7 |
| 2011 | 8 |
| 2012 | 10 |
| 2013 | 10 |
| 2014 | 8 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 1 |
| 2018 | 6 |
| 2019 | 8 |
| 2020 | 2 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 4 |
| 2024 | 2 |
| 2025 | 8 |
| 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\" = '240' 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" = '240' 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 CEN13FA069Accident · 1 fatalField investigationFinal reportCessna 310B · Mancelona, MIThe pilot's failure to maintain control of the airplane after a loss of right engine power for reasons that could not be determined because postaccident examination revealed no preimpact malfunction or anomaly that would have precluded normal operation.NTSB CEN12FA601Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brighton, MIThe pilot’s failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the severity of…NTSB CEN12CA603Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Pittsford, MIThe student pilot’s failure to maintain directional control of the airplane while maneuvering at a low altitude.NTSB CEN12LA626Accident · No injuriesLimited investigationFinal reportIson Eros · Schoolcraft, MIThe operation of an airplane by a non-certificated pilot and his failure to maintain airplane control during the initial climb, which resulted in an uncontrolled decent.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 CEN12LA324Accident · 1 fatalLimited investigationFinal reportNorth American T-6G · Perry, MIThe pilot’s failure to maintain control while maneuvering at low altitude after takeoff, resulting in a collision with a barn.NTSB CEN12IA385Incident · No injuriesIncident investigationFinal reportCessna 182 · Fowlerville, MIThe airplane’s encounter with clear air turbulence, which caused a momentary loss of control and minor damage to the airplane.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 CEN12LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Frankenmuth, MIA partial loss of engine power for undetermined reasons and the pilot’s failure to maintain airspeed, which resulted in an aerodynamic stall.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.