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 CHI92FA161Accident · 2 fatalField investigationFinal reportCessna 177B · Almont, MIThe pilot's failure to maintain control of the airplane during takeoff while physically impaired by alcohol.NTSB CHI92DEC01Accident · No injuriesFinal reportCessna 188A · Imlay City, MIThe pilot induced premature liftoff which resulted in inadequate airspeed and the resulting stall.NTSB CHI92LA150Accident · No injuriesLimited investigationFinal reportBeech C23 · Saginaw, MIThe first pilot's improper recovery from a bounced landing. A factor in the accident was the first pilot's lack of experience in the aircraft type.NTSB CHI92LA143Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Ionia, MIThe pilot-in-command's improper preflight and decision to close the glider's canopy at low altitude.NTSB CHI92DEM02Accident · No injuriesFinal reportGillespie/Pitts S1C · Freeland, MIA total failure of the rudder control cable and unavailability of rudder to control the airplane during its landing process. Factors which contributed to the accident were directional control and remedial action not being possible on behalf of the pilot.NTSB CHI92LA132Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-8F-55 · Ypsilanti, MIThe pilot-in-command's misjudging of the touchdown point. Factors include (aircraft performance) hydroplaning condition, and the pilot-in-command's poor evaluation of weather conditions.NTSB CHI92DEM01Accident · No injuriesFinal reportRose Wesley Rotorway WR Exec · Hudsonville, MIThe failure of an intake valve spring. Factors related to the accident were the low altitude at which the autorotation was initiated and the soft terrain on which the helicopter was landed.NTSB CHI92LA129Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Iron Mountain, MIThe presence of water in the air induction system.NTSB CHI92LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Munising, MIThe inadequate maintenance inspection to remove water from the fuel system, and the pilot's inadequate preflight inspection.NTSB CHI92FA104Accident · 3 fatalField investigationFinal reportCessna 414 · Freeland, MIThe pilot's poor judgement in attempting flight after the airplane's fuselage was damaged during a loading operation. Factors which contributed to the accident were: the operator's failure to provide proper weight and balance data for the airplane, the…NTSB CHI92LA097Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Alpena, MIThe student pilot's failure to attain the proper touchdown point. Related factors are his misjudged approach and failure to take remedial action.NTSB CHI92LA092Accident · No injuriesLimited investigationFinal reportCessna 340A · Lapeer, MIThe pilot's failure to maintain directional control.NTSB CHI92LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe pilot's improper use of carburetor heat. An associated factor is weather conducive to carburetor icing.NTSB CHI92FAMS1Accident · 2 fatalMissing aircraftFinal reportBeech 95-BE55 · Benton Harbor, MIUndetermined.NTSB CHI92LA087Accident · No injuriesLimited investigationFinal reportCessna 170 · Howell, MIDirectional control was not maintained by the pilot. A factor related to the accident was: a cross wind.NTSB CHI92LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Lansing, MIFailure of the pilot to maintain directional control of the airplane during a takeoff ground run. Factors associated with the accident are the pilot's diverted attention, his lack of total experience, and the soft terrain.NTSB CHI92IA079Incident · No injuriesIncident investigationFinal reportAerospatiale AS-355F1 · Lansing, MIA fatigue failure of a fuel system line fitting during cruise flight.NTSB CHI92LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · New Haven, MIDirectional control was not maintained by the dual student and remedial action was delayed by the CFI. A factor related to the accident was the icy runway conditions.NTSB CHI92LA076Accident · No injuriesLimited investigationFinal reportCessna 414 · Gaylord, MIDirectional control was not maintained by the pilot. Factors related to the accident were: airport snow removal had not been performed by the airport personnel, a dark night with falling snow and the snowbank on the runway.NTSB CHI92LA074Accident · No injuriesLimited investigationFinal reportCessna 175 · Warren, MIA loss of engine power as a result of a connecting rod failure. Factors related to the accident were the power lines and trees in the path of the selected emergency landing site.NTSB CHI92FA062Accident · 2 fatalField investigationFinal reportCessna 172M · Sanford, MIThe pilot-in-command's failure to maintain a visual lookout to avoid a wire strike. Factors were the pilot-in-command's intentional low level flight, his failure to maintain proper altitude, and the transmission wires.NTSB CHI92FA053Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Berrien Springs, MIThe pilot-in-command's (cfi's) poor in-flight planning/decision-making and misjudged fuel supply/consumption. A related factor is overconfidence in personal ability.NTSB CHI92LA047Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mt Pleasant, MIWater in the fuel, and an inadequate preflight by the pilot.NTSB CHI92LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Marquette, MIFlight into known adverse weather conditions by the pilot, which resulted in airframe (wing) icing and the inability to maintain altitude. The adverse weather conditions and darkness were related factors.NTSB CHI92FA032Accident · 3 fatalField investigationFinal reportBeech B100 · Romeo, MIThe pilot in command's improper inflight decision and the minimum descent altitude disregarded during an instrument approach.NTSB CHI92LA029Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Howell, MIProper glidepath was not maintained resulting in an undershoot. A factor related to the accident was dark night flying conditions.NTSB CHI92LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bellaire, MIThe pilot's improper remedial action after ballooning during a landing flare. Factors associated with the accident are gusty crosswinds and the pilot's lack of total experience.NTSB CHI92LA012Accident · No injuriesLimited investigationFinal reportRockwell 112YC · Detroit, MIThe pilot's failure to perform a major repair and continued operation of the airplane with known deficiencies.NTSB CHI92LA006Accident · No injuriesLimited investigationFinal reportCessna 421B · Battle Creek, MIThe total failure of the right main landing gear's downlock link assembly.NTSB CHI91FA305Accident · 1 fatalField investigationFinal reportErcoupe Ercoupe 415-D · Emmett, MIThe pilot's exceeding the design limits of the aircraft, which resulted in an inflight breakup.NTSB CHI91FA302Accident · 2 fatalField investigationFinal reportCessna A150L · Bellaire, MIThe instructor pilot's inadequate supervision which resulted in an inaverent stall and uncontrolled descent into terrain. A related factor is the insufficient altitude.NTSB CHI91LA296Accident · No injuriesLimited investigationFinal reportCessna 150H · New Hudson, MIFailure of the pilot to maintain directional control during landing roll in a crosswind.NTSB CHI91IA297Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Detroit, MIInadequate maintenance inspection of the main landing gear actuator assembly by company maintenance personnel. A factor in the incident is inadequate design of the landing gear actuator by the manufacturer.NTSB CHI91LA300Accident · Serious injuriesLimited investigationFinal reportATR ATR 42-300 · Muskegon, MIThe failure, for reasons unknown, of the number four bearing in the high pressure spool of the engine.NTSB CHI91LA277Accident · No injuriesLimited investigationFinal reportClassic YMF5 · Hart, MIFailure of the pilot to maintain directional control of the airplane during a takeoff ground run.NTSB CHI91LA275Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Jenison, MIFailure of the pilot to perform remedial action during fuel system carburetor icing.NTSB CHI91LA274Accident · No injuriesLimited investigationFinal reportCessna 150 · Camden, MIPartial power loss due to improper use of the carburetor heat control by the pilot. Factors related to the accident were inadequate visual lookout by the pilot and presence of static power lines.NTSB CHI91LA271Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Saginaw, MIDirectional control was not maintained by the pilot which resulted in a ground loop. A factor related to the accident was a crosswind.NTSB CHI91LA269Accident · No injuriesLimited investigationFinal reportCessna 172E · Harbor Springs, MIThe pilot's failure to adequately compensate for wind conditions. A factor associated with the accident was his delay in initiating the go-around.NTSB CHI91DEM08Accident · Serious injuriesFinal reportFisher FT101 · Sparta, MIAn improper preflight inspection by the pilot. Factors contributing to this accident were inadequate altitude for the turn back towards the runway and the stall/spin encountered by the pilot.NTSB CHI91FA266Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boyne City, MIThe pilot in command's failure to maintain proper altitude. A factor contributing to the accident was the pilot in command's diverted attention..NTSB CHI91LA252Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mount Pleasant, MIDirectional control was not maintained by the pilot. Factors related to the accident were a wet, grass runway and buildings adjacent the runway.NTSB CHI91LA238Accident · No injuriesLimited investigationFinal reportCessna 140 · Cadillac, MIImproper compensation for wind conditions resulting in aircraft control not being maintained. Factors related to the accident were a gusty crosswind condition and lack of total experience by the pilot.NTSB CHI91DEC03Accident · 1 fatalFinal reportAL White Breezy AWY · Leslie, MIThe pilot's failure to adequately maintain control of the aircraft. A factor was the exessive descent rate.NTSB CHI91LA231Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIA collision with wires after the glider overshot the landing area due to inadvertent lowering of the flaps and no use of spoilers.NTSB CHI91MA224Accident · 3 fatalMajor investigationFinal reportLearjet 23 · Detroit, MIImproper preflight by the pilot, his failure to abort the takeoff while there was sufficient runway remaining, and his failure to assure that the aircraft attained sufficient airspeed for lift-off and climb. Factors related to the accident were: the pilot's…NTSB CHI91DEM07Accident · No injuriesFinal reportCessna 188B · Munger, MIA premature liftoff by the pilot. A factor contributing to this accident was the soft runway surface and a stall/mush.NTSB CHI91LA218Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Flint, MIPropeller pitch change mechanism sheared. Factors related to the accident were powerplant vibration and proper touchdown point not possible.NTSB CHI91FA208Accident · 1 fatalField investigationFinal reportTemco D-16A · Eau Claire, MIThe improper replacement of the fuel selector lever which resulted in loss of engine power due to fuel staration.NTSB CHI91DEM06Accident · 1 fatalFinal reportAeronca 11-AC · Central Lake, MIA result of the pilot in command not maintaining aircraft control and not performing remedial action after the airplane entered the steep descent. A factor contributing to this accident was the pilot in command's lack of recent experience.