NTSB investigations, MI
381 cases where NTSB found Aircraft.
Cases per year
| 2008 | 20 |
|---|---|
| 2009 | 30 |
| 2010 | 21 |
| 2011 | 30 |
| 2012 | 28 |
| 2013 | 21 |
| 2014 | 27 |
| 2015 | 21 |
| 2016 | 17 |
| 2017 | 18 |
| 2018 | 21 |
| 2019 | 20 |
| 2020 | 17 |
| 2021 | 18 |
| 2022 | 12 |
| 2023 | 17 |
| 2024 | 19 |
| 2025 | 16 |
| 2026 | 8 |
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 c.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
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 c."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01')) 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 WPR26LA308Accident · No injuriesClass 4 · LimitedFinal reportMitsubishi MU-2B-40 · Norton Shores, MIThe pilot’s failure to extend the landing gear before landing.NTSB CEN26LA240Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Traverse City, MIThe pilot’s failure to extend the landing gear before landing.NTSB CEN26LA226Accident · No injuriesClass 4 · LimitedFinal reportBeech A36TC · Kingsford, MIThe pin on the nose gear brace assembly that engages with the cam on the nose landing gear door actuator shaft was not seated inside the cam, which rendered the nose landing gear inoperative.NTSB CEN26LA233Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Gregory, MIThe flight instructor’s improper planning during the simulated aborted launch which resulted in a touchdown on unsuitable terrain.NTSB CEN26LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Naubinway, MIThe pilot’s improper engine power application during the landing flare, which resulted in a hard, bounced landing and nose over.NTSB CEN26LA216Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Northport, MIThe pilot's decision to resume taxiing on a turf runway that was unable to adequately support the airplane's weight, which resulted in the nose landing gear sinking into the soft ground and the propeller striking the terrain.NTSB ANC26LA031Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Lapeer, MIThe flight instructor’s failure to maintain airplane control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and on ground collision with an object. Contributing to the accident was the flight instructor’s decision to…NTSB CEN26LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Bay City, MIThe pilot's failure to ensure the landing gear was down and locked before landing.NTSB CEN25LA383Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger · Crystal Mountain, MIThe pilot’s failure to maintain aircraft control during initial climb.NTSB CEN25LA401Accident · No injuriesClass 3 · LimitedFinal reportCubCrafters CCK-2000 · Thompsonville, MIA total loss of engine power due to a lack of ignition resulting from a fractured alternator ring terminal and the builder’s incorrect installation of the wire connecting to the alternator. Contributing to the total loss of engine power was the failure of the…NTSB CEN25LA361Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Caro, MIThe pilot’s failure to remove the tow bar before flight.NTSB CEN25LA337Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58A · Caseville, MIThe front seat passenger’s inadvertent movement of the cyclic control resulting in a dynamic rollover after landing. Contributing to the accident was the pilot’s decision to leave the dual flight controls installed with a non-pilot passenger in the front seat.NTSB CEN25LA325Accident · No injuriesClass 4 · LimitedFinal reportHelio H-391B · Monroe, MIThe pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB CEN25LA319Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Lowell, MIThe pilot’s failure to extend the landing gear before landing.NTSB CEN25LA284Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · New Hudson, MIThe student pilot’s improper landing flare and the flight instructor’s delayed remedial action during landing that resulted in a loss of control and impact with terrain.NTSB CEN25LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Lansing, MIThe pilot’s improper landing flare and subsequent failure to maintain directional control during the landing in a crosswind condition.NTSB CEN25LA244Accident · Minor injuriesClass 4 · LimitedFinal reportCessna LC41-550FG · Lambertville, MIThe pilot’s failure to land at the manufacturer’s recommended approach speed, which resulted in a runway excursion, and impact with trees.NTSB CEN25LA241Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Jenison, MIThe pilot’s failure to maintain airplane control and clearance from trees during takeoff.NTSB CEN25LA239Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Newaygo, MIThe pilot’s inadequate fuel planning and his failure to adequately monitor the fuel level during the flight which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA213Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters EC130 · Clay Township, MIThe pilot’s failure to maintain control of the helicopter during landing.NTSB CEN25LA195Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Charlevoix, MIThe pilot’s failure to maintain pitch control during the takeoff that resulted in multiple bounces and substantial damage to the fuselage.NTSB CEN25LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Zeeland, MIThe flight instructor’s failure to maintain control of the airplane during the go-around which led to the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall at a low altitude. Contributing to the accident was the flight…NTSB CEN25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · Romeo, MIThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the soft, wet grass.NTSB CEN25LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Iron River, MIThe airplane’s collision with runway lights during takeoff due to reduced airplane climb performance. Contributing to the accident was the shifting winds during takeoff which likely developed into a tailwind.NTSB CEN25LA050Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Mason, MIThe pilot’s failure to maintain aircraft control during landing rollout that resulted in a nose over and an impact with the runway.NTSB CEN25LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Willis, MIThe pilot’s failure to maintain a stabilized approach, that resulted in a runway excursion and subsequent collision with trees. Contributing to the accident, was the pilot’s decision to attempt to land to a closed runway.NTSB CEN24LA378Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Caro, MIA total loss of engine power due to maintenance personnel’s failure to properly tighten the fuel supply line B-nut at the fuel servo.NTSB CEN24LA358Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Canton, MIFatigue cracking of the main rotor blade that occurred at an undetermined time.NTSB CEN24LA336AccidentClass 4 · LimitedFinal reportCessna 182D · Coopersville, MIThe loss of airplane control while landing.NTSB CEN24LA307Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Kalamazoo, MIThe pilot’s failure to extend the landing gear before landing.NTSB CEN24LA280Accident · No injuriesClass 4 · LimitedFinal reportCessna 195A · Greenville, MIThe pilot’s loss of directional control during landing which led to a ground-loop.NTSB CEN24LA265Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Le Roy, MIThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an inflight collision with trees.NTSB CEN24LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Dowagiac, MIThe pilot and flight instructor’s failure to maintain directional control during the landing roll, which resulted in a ground loop with the left main landing gear axle failing, a runway excursion, and impact with the ground.NTSB CEN24LA249Accident · No injuriesClass 3 · LimitedFinal reportRotorway 162 F · Maybee, MIA partial loss of engine power for undetermined reasons.NTSB CEN24LA318Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Stanwood, MIThe pilot’s failure to maintain terrain clearance during a low-level aerial application flight, which resulted in impact with terrain and a subsequent forced landing. Contributing to the accident was the location of the spray boom pressure gauge, which…NTSB CEN24FA215Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Clinton, MIThe flight instructor’s failure to maintain airplane control while maneuvering for a forced landing. Contributing to the accident was the student pilot’s or flight instructor’s inadvertent positioning of the fuel selector valve between the Left Tank and Off…NTSB CEN24LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Oscoda, MIThe pilot’s failure to maintain directional control during landing rollout with a gusting crosswind that resulted in the airplane nosing over and impacting on the runway.NTSB CEN24LA185Accident · Serious injuriesClass 3 · LimitedFinal reportTitan T51 · Novi, MIA failure of the electrical system, resulting in a loss of fuel injection and subsequent loss of engine power.NTSB CEN24LA181Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Chesaning, MIThe pilot’s failure to maintain control while landing on a wet turf runway, which resulted in a runway excursion and impact with trees. Contributing to the accident was the pilot’s failure to ensure the passenger’s proper use of seatbelts before the landing.NTSB CEN24LA176Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Watervliet, MIThe pilot’s failure to maintain control during the landing roll on a soft turf runway.NTSB CEN24LA136Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Grind Stone City, MIThe pilot's failure to maintain directional control during the landing roll on a wet turf runway with a quartering tailwind.NTSB CEN24LA134Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T182T · Lapeer, MIThe pilot’s failure to maintain aircraft control while landing in a gusting crosswind condition.NTSB CEN24LA113Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · South Lyon, MIThe pilot’s failure to maintain clearance from trees during the landing approach.NTSB CEN24LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46-500TP · Ann Arbor, MIThe airplane’s encounter with unexpected wind shear during final approach, which resulted in a hard landing short of the runway.NTSB CEN24FA046Accident · 2 fatalClass 3 · FieldFinal reportSocata TBM 700 · Ludington, MIThe pilot’s decision to take off with ice/snow contamination on the airplane’s wings, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN24LA033Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 500-B · Jackson, MIA loss of engine power to both engines as a result of the pilot’s improper fuel management. Contributing was the inoperative fuel quantity sending unit.NTSB CEN24LA014Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Saginaw, MIThe failure of the right brake assembly due to excessive brake lining wear, which resulted in a thermally damaged piston O-ring, hydraulic fluid leak, and subsequent fire.NTSB CEN23FA410Accident · 1 fatalClass 3 · FieldFinal reportSonex Sonex · Dowagiac, MIThe total loss of engine power due to the failure of the ignition distributor rotor.NTSB CEN23LA374Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A188B · Bay Port, MIThe pilot’s decision to takeoff from a soft wet runway with a quartering tailwind which resulted in a lack of climb performance and impact with terrain.NTSB CEN23LA371Accident · Minor injuriesClass 3 · LimitedFinal reportRutan Longez · Genoa Township, MIA total loss of engine power for undetermined reasons.