NTSB investigations, MI
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 CHI90LA136Accident · No injuriesLimited investigationFinal reportCessna 182F · Clare, MIImproper maintenance by maintenance personnel resulting in a sticking carburetor float. Inadequate planning by the pilot in command during the approach is a factor in the accident.NTSB CHI90DEM03Accident · No injuriesFinal reportCessna T188 · Williamsburg, MIA loss of engine power for undetermined reasons. The lack of suitable terrain for landing was a factor related to the accident.NTSB CHI90FA130Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · East Lansing, MIThe failure of the pilot to maintain aircraft control while flying in clouds during an instrument approach. Factors were: instrument meteorological conditions, self-induced pressure, operation with known deficiencies in equipment, and anxiety/apprehension.NTSB CHI90LA119Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lambertville, MIThe pilot's failure to maintain aircraft control during the aborted landing.NTSB CHI90DEC01Accident · 2 fatalFinal reportMoore Acroduster II SA750 · New Haven, MIThe pilot's the improper execution and/or recovery from an aerobatic maneuver (inverted flat spin), which resulted in a collision with the terrain.NTSB CHI90FA118Accident · 1 fatalField investigationFinal reportSikorsky S-58F · Southfield, MIA loss of control due to physical incapacitation for unknown reason(s).NTSB CHI90LA126Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Bad Axe, MITotal failure of the powerplant during the final approach for undetermined reasons.NTSB CHI90FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-30B · Charlevoix, MIThe probable cause of this accident is undetermined.NTSB CHI90LA112Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Manistique, MIThe pilot allowing the airplane to run out of fuel.NTSB CHI90FA108Accident · 1 fatalField investigationFinal reportBeech M35 · Romeo, MIA loss of control due to physical incapacitation (heart attack).NTSB CHI90LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Alpena, MIStudent pilot's failure to maintain positive directional control during the takeoff roll. The student pilot's lack of flight experience was a contributing factor in this accident.NTSB CHI90IA089Incident · No injuriesIncident investigationFinal reportFokker F-27-200 · Marquette, MIThe pilot-in-command's failure to maintain directional control of the aircraft during touchdown and rollout.NTSB CHI90LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pontiac, MIOverload failure of the left main landing gear attach bolts for an undetermined reason.NTSB CHI90LA083Accident · No injuriesLimited investigationFinal reportCessna 150H · Plainwell, MIForeign object (ice), which jammed the right wheel. A factor related to the accident was: the snowbank.NTSB CHI90LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harbor Springs, MIThe student pilot's failure to maintian adequate directional control of the aircraft. The unfavorable wind was a related factor.NTSB CHI90TF#01Accident · No injuriesClass 3Final reportNorth American NA-265-40 · Detroit, MINTSB CHI90LA073Accident · No injuriesLimited investigationFinal reportBell 222 · Middleville, MIThe pilot's inadequate visual lookout and failure to maintain proper altitude and clearance from the tv tower. The tv tower (guy wire) was a related factor.NTSB CHI90DEM02Accident · Serious injuriesFinal reportMaxair MU532 · Vicksburg, MIThe pilot's failure to maintain adequate airspeed while performing manuevers.NTSB CHI90LA071Accident · No injuriesLimited investigationFinal reportCessna 177B · Acme, MIThe student pilot misjudged distance and altitude to the runway, and the instructor pilot (CFI) failed to attain remedial action, which resulted in their failure to attain the proper touchdown point. Factors related to the accident were: the cfi's lack of…NTSB CHI90IA064Incident · No injuriesIncident investigationFinal reportBoeing 747-151 · Detroit, MIA fire in the aft cargo compartment for undetermined reasons(s).NTSB CHI90LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · Traverse City, MIImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB CHI90LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jenison, MIThe pilot's failure to maintain adequate airspeed during the approach. A contributing factor was the icing condition that existed at the time of the accident.NTSB CHI90LA048Accident · No injuriesLimited investigationFinal reportCessna 310Q · Grand Rapids, MIThe undetermined engine compartment fire during the initial climbout. A factor was the failure of the pilot to shut off the fuel supply to the engine.NTSB CHI90FA040Accident · 4 fatalField investigationFinal reportCessna 172M · Linden, MIThe failure of the pilot to maintain sufficient speed for flight. A factor associated with the accident was the pilot's operation of the airplane above the maximum allowable gross weight.NTSB CHI90LA280Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Engadine, MIA collision with trees and the terrain for undetermined reasons.NTSB CHI90LA032Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Howell, MIFailure of the mixture control cable, which resulted in a loss of power due to fuel starvation during a climb after takeoff. A factor related to the accident was: rough terrain in the emergency landing area.NTSB CHI90LA031Accident · No injuriesLimited investigationFinal reportHelio H-391B · Plainwell, MIFailure of the crosswind landing gear system to engage on the left main gear due to improper rigging adjustment by maintenance personnel. Factors related to the accident were: unfavorable wind conditions (gusts and quartering crosswind) and soft terrain in…NTSB CHI90LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Detroit, MIInadequate preflight planning/preparation which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB CHI90FA019Accident · 1 fatalField investigationFinal reportBeech B35 · Clare, MIImproper preflight by the pilot by not assuring that the fuel selector was properly positioned, which resulted in fuel starvation, and the pilot's failure to maintain airspeed, which resulted in a stall/spin.NTSB CHI90LA013Accident · No injuriesLimited investigationFinal reportCessna 172H · Bay City, MIThe pilot's failure to execute a go-around in a timely manner.NTSB CHI90LA011Accident · 1 fatalLimited investigationFinal reportCessna 152 · Hillsdale, MIPoor judgement of the student pilot by not following his flight instructor's directions on his first supervised solo flight and by not maintaining a safe altitude, which resulted in a collision with the terrain. Related factors were: unauthorized low flight…NTSB CHI90LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MIInadequate supervision of the flight by the flight instructor (CFI), failure of both the student and the CFI to see-and-avoid the static line, and failure of the pilots to maintain adequate clearance from the power line/static wire. The static wire was a…NTSB CHI90DEM01Accident · 1 fatalFinal reportCessna 150E · Grayling, MIA loss of aircraft control for undetermined reasons.NTSB CHI90FA003Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Ann Arbor, MIFailure of the pilot to maintain sufficient airspeed, which resulted in an inadvertent stall. A factor related to the accident was the pilot's lack of experience in the aircraft.NTSB CHI90LA002Accident · No injuriesLimited investigationFinal reportCessna T182 · Sodus, MIThe pilot-in-command's failure to maintain a proper angle of climb, resulting in a stall.NTSB CHI90LA001Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Manistique, MIA delayed by the pilot in going around and his failure to obtain adequate airspeed before fully retracting the flaps, which allowed the aircraft to mush. The contributing factors were: the pilot's failure to attain the proper touchdown point during the…NTSB CHI89DEM10Accident · 1 fatalFinal reportFletcher SONERAI-2L · Interlochen, MILoose cylinder due to improper maintenance by the pilot/owner, which resulted in overheating and failure of the aluminum cylinder head. The presence of trees was considered to be a factor.NTSB CHI89DEM09Accident · Minor injuriesFinal reportHiller UH-12E · Hudsonville, MIThe fatigue failure of one of the tension-torsion pins.NTSB CHI89DEC08Accident · 1 fatalFinal reportWesley Striplin Ranger · Smith Creek, MIThe improper installation of the wingtip fuel tank which resulted in its inflight separation and the subsequent loss of control.NTSB CHI89LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Ypsilanti, MIThe failure of the plt to maintain directional control during the takeoff ground roll. Rain softened terrain adjacent to the runway surface is a contributing factor to the accident.NTSB CHI89LA185Accident · No injuriesLimited investigationFinal reportCessna C172R · Frankenmuth, MIThe pilot's failure to maintain control of the aircraft during takeoff as a result of a diversion of attention due to a possible engine problem.NTSB CHI89TL#05Accident · No injuriesClass 3Final reportBeech D45 (T-34B) · Gaylord, MINTSB CHI89LA181Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · South Haven, MIImproper flare by the pilot, which resulted in a hard landing.NTSB CHI89DEM08Accident · No injuriesFinal reportMooney M20 · West Branch, MIThe pilot's decision to hand prop the engine with a non-pilot at the controls and the passenger's application to full throttle. A factor related to the accident was panic of the passenger.NTSB CHI89DEC07Accident · Serious injuriesFinal reportRayne VARI-EZE · Clinton, MIUndetermined loss of engine power during initial climbout. The lack of suitable terrain for an emergency landing was a related factor.NTSB CHI89LA178Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Brooklyn, MIFailure of the pilot to see-and-avoid power lines in his flight path during a go-around. The power lines and his lack of familiarity with the airport were contributing factors.NTSB CHI89DEM07Accident · Minor injuriesFinal reportBradley S-1D · Mt Pleasant, MIThe tail wheel spring becoming disconnected resulting in the pilot's inability to maintain directional control of the airplane.NTSB CHI89DEC06Accident · 1 fatalFinal reportFeil BD-5 · Pontiac, MIThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall/spin. Contributing to the accident was the excessive pull-up maneuver and the pilot's lack of total experience in the aircraft.NTSB CHI89LA175Accident · Minor injuriesLimited investigationFinal reportCessna 182A · East Lansing, MIImproper corrective action on the part of the pilot to correct an excessive sink rate prior to landing touchdown.NTSB CHI89LA172Accident · No injuriesLimited investigationFinal reportCessna T-337D · Howell, MIThe pilot's poor preflight planning and inaccurate fuel consumption calculations. Contributing factor was maintenance personnel's not performing correct calibration of fuel gages.