NTSB investigations, MI
195 cases where NTSB found Environmental issues.
Cases per year
| 2008 | 19 |
|---|---|
| 2009 | 8 |
| 2010 | 10 |
| 2011 | 11 |
| 2012 | 13 |
| 2013 | 8 |
| 2014 | 18 |
| 2015 | 12 |
| 2016 | 11 |
| 2017 | 12 |
| 2018 | 10 |
| 2019 | 10 |
| 2020 | 9 |
| 2021 | 8 |
| 2022 | 8 |
| 2023 | 11 |
| 2024 | 7 |
| 2025 | 6 |
| 2026 | 4 |
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\", '03'))
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", '03')) 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 CEN26LA291Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Linden, MIThe collision with a deer during touch-and-go landings.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 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 CEN25LA369Accident · Minor injuriesClass 4 · LimitedFinal reportZodiac CH 650B · Sturgis, MIThe pilot’s failure to maintain control while landing.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 CEN25LA294Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Stanwood, MIThe collision with a deer during takeoff.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 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 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 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 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 CEN24LA023Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-201T · Mount Pleasant, MIThe airplane’s collision with a deer on the runway during landing.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 CEN23LA287Accident · No injuriesClass 4 · LimitedFinal reportAerofab LA-4 · Big Prairie, MIThe airplane’s collision with a submerged log during a water landing.NTSB CEN23LA266Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Howell, MIA loss of engine power due to the formation of carburetor ice that resulted from the pilot’s delayed use of carburetor heat during the landing approach.NTSB CEN23FA257Accident · 1 fatalClass 3 · FieldFinal reportAvid Magnum · Beaver Island, MIThe pilot’s failure to maintain clearance from the water while maneuvering in low visibility conditions due to smoke and haze.NTSB CEN23LA219Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Pontiac, MIThe flight crew’s inadequate compensation for gusting wind, and the flight instructor’s delayed remedial action, which resulted in impact with the ground.NTSB CEN23LA200Accident · No injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Gregory, MIThe pilot’s improper landing flare that resulted in a hard, bounced landing and subsequent overstress failure of the nose landing gear.NTSB CEN23LA213Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ray, MIThe flight instructor’s failure to maintain airplane control during simulated engine-out procedures. Contributing to the accident was the flight instructor’s decision to land with a tailwind.NTSB CEN23LA161Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Flint Township, MIThe pilot’s failure to apply carburetor heat during the landing approach, which resulted in a loss of engine power from carburetor ice.NTSB CEN23LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Manchester, MIA partial loss of engine power as a result of carburetor ice.NTSB CEN23LA286Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Holland, MIThe pilot’s failure to maintain directional control during the landing roll with gusty wind which exceeded the maximum crosswind of the airplane.NTSB DCA22LA191Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 717-200 · Detroit, MIAn encounter with moderate turbulence during descent.NTSB CEN22LA385Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Sparta, MIThe pilot’s delayed decision to reject the takeoff, resulting in a runway excursion and impact with a fence.NTSB CEN22LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Mecosta, MIThe pilot’s decision to depart on inadequate runway surface conditions that resulted in a loss of control after attempting to abort the takeoff, a runway excursion, and a nose over.NTSB ERA22FA314Accident · 2 fatalClass 3 · FieldFinal reportCessna 210C · Shelby, MIThe non-instrument rated pilot’s decision to commence the flight in instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s self-induced pressure to…NTSB CEN22LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Eaton Rapids, MIThe pilot’s failure to maintain airspeed in the climb with a quartering tailwind which resulted in an aerodynamic stall and subsequent impact with trees.NTSB CEN22LA126Accident · No injuriesClass 4 · LimitedFinal reportEmbraer Executive EMB-500 · Detroit, MIThe pilot’s decision to land on the contaminated runway with previous reports of unfavorable braking action.NTSB CEN22LA052Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Marshall, MIThe airplane’s collision with a deer during takeoff.NTSB CEN22FA032Accident · 2 fatalClass 3 · FieldFinal reportBeech E-90 · Boyne City, MIThe pilot’s failure to maintain sufficient airspeed and his exceedance of the airplane’s critical angle of attack while in icing conditions, which resulted in an aerodynamic stall and subsequent ground impact.NTSB CEN21LA430Accident · No injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Battle Creek, MIThe pilot’s failure to maintain directional control of the tailwheel equipped airplane during a crosswind landing and the flight instructor’s inadequate remedial action.NTSB CEN21LA384Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Lansing, MIThe pilot’s decision to depart with a tailwind as a thunderstorm approached, which resulted in a loss of airplane performance due to an encounter with a significant tailwind gust and a subsequent runway excursion.NTSB CEN21LA283Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Edwardsburg, MIThe pilot’s failure to identify rising terrain and to maintain terrain clearance from trees during an aerial application pass that resulted in an in-flight collision with trees and terrain.NTSB CEN21LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Caro, MIThe pilot's inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN21LA123Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-50 · Weidman, MIThe pilot’s failure to maintain clearance from terrain during a low approach over a snow-covered runway. Contributing to the accident was the loss of depth perception due to the bright sunlight and snow.NTSB CEN21LA104Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA-24-250 · New Hudson, MIThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of an instrument rating and the low visibility at the time…NTSB CEN20LA431Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Big Rapids, MIThe airplane’s impact with a deer during takeoff.NTSB CEN20LA399Accident · 2 fatalClass 3 · LimitedFinal reportVans RV9 · Zeeland, MIThe pilot’s failure to maintain airspeed during a visual approach in dark night conditions, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the pilot’s lack of recent flight experience at night.NTSB CEN20CA358Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 8GCBC · Three Rivers, MIThe pilot's failure to maintain clearance from a taxiway sign after landing.NTSB CEN20CA387Accident · Serious injuriesClass 4 · Data collectionFinal reportPowrachute Airwolf · Casco, MIThe pilot's decision to takeoff towards known obstacles which resulted in an impact with a power line.NTSB CEN20LA272Accident · 1 fatalClass 3 · LimitedFinal reportGolden Circle Air T-Bird · Grosse Ile, MIThe noncertificated pilot’s failure to maintain clearance from trees while maneuvering at low altitude in gusting wind conditions. Contributing to the accident was the pilot’s lack of flight experience.NTSB CEN20CA213Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18 · Cadillac, MIThe pilot’s failure to maintain control of the float-equipped airplane after the float became caught on the trailer used for takeoff.