NTSB investigations, 2013, 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
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\") = 2013
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") = 2013 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 CEN13LA555Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine · St. Joseph, MIThe pilot's failure to maintain control of the powered-parachute during takeoff.NTSB CEN13LA546Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Rothbury, MIThe pilot’s failure to maintain helicopter control while turning to avoid trees during an aborted takeoff in gusting wind conditions.NTSB CEN13CA501Accident · No injuriesData collectionFinal reportMcdonnell Douglas Heli 369FF · Reese, MIThe failure of the temporary hoist holding the powerline wire which resulted in a brief loss of control and main rotor blade impacts with the tower.NTSB CEN13LA493Accident · Serious injuriesLimited investigationFinal reportTrick Trikes Storm Trooper · Covert, MIThe student pilot’s loss of control while maneuvering at low altitude over a congested beach area. Contributing to the accident was the pilot’s ostentatious display.NTSB CEN13CA510Accident · No injuriesData collectionFinal reportErcoupe 415-C · Mackinac Island, MIThe pilot's failure to maintain aircraft control while on final approach.NTSB CEN13CA474Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Clare, MIThe flight instructor's failure to adequately monitor the landing approach, his delayed corrective action and his failure to maintain directional control that resulted in the airplane's collision with a ditch adjacent to the runway. The student pilot's…NTSB CEN13LA422Accident · Serious injuriesLimited investigationFinal reportGrumman Aircraft Cor-Schweizer G-164A · Elmira, MIThe pilot's failure to maintain clearance from a line of trees while applying agricultural product to a field.NTSB CEN13LA401Accident · 1 fatalLimited investigationFinal reportJDT 1600R · Chesaning, MIThe failure of the propeller reduction gearbox and the pilot’s subsequent failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall and spin. Contributing to the accident were…NTSB CEN13FA364Accident · 4 fatalField investigationFinal reportCessna 172M · Waterford, MIThe pilot's failure to retract the wing flaps before attempting to take off, due to his lack of familiarity with the airplane make and model, which prevented the airplane from maintaining adequate altitude for takeoff.NTSB CEN13CA333Accident · No injuriesData collectionFinal reportCessna 172P · Pontiac, MIThe student pilot's failure to maintain aircraft control during the takeoff and his interference with the flight instructor's ability to provide remedial action.