Skip to content

NTSB investigations, MI

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 CHI03LA194Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Roscommon, MIThe pilot's failure to maintain aircraft control during a water landing. A factor contributing to the accident was the rough water.Jul 2, 2003 · N172DE · Substantial damage NTSB CHI03LA191Accident · No injuriesLimited investigationFinal reportCessna 140 · Ludington, MIThe maintenance personnel's improper installation of the landing gear axle, which resulted in the separation of the axle from the landing gear.Jul 2, 2003 · N89360 · Substantial damage NTSB CHI03LA184Accident · No injuriesLimited investigationFinal reportBell 47G-5A · Sandusky, MIThe failure of the ignition switch leading to an engine power loss in cruise flight and the subsequent high flare during autorotation. Factors contributing to the accident were the pilot's misjudgment of the landing flare and the unsuitable terrain…Jun 28, 2003 · N8413D · Substantial damage NTSB CHI03LA290Accident · No injuriesLimited investigationFinal reportCessna 172N · Romeo, MIThe pilot not maintaining directional control during landing. A factor to the accident was the parked airplane.Jun 27, 2003 · N739NW · Substantial damage NTSB CHI03LA177Accident · No injuriesLimited investigationFinal reportWaco ARE · Battle Creek, MIThe inadequate material used in the landing gear cross supports leading to its collapse during the landing roll.Jun 22, 2003 · N20953 · Substantial damage NTSB CHI03LA170Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Covert, MIFailure of the pilot to verify fuel quantity prior to the accident flight, and fuel exhaustion resulting in a loss of engine power. Contributing factors were the soft, rough, unsuitable terrain for a forced landing.Jun 20, 2003 · N3659T · Substantial damage NTSB CHI03LA183Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · West Branch, MIThe loss of engine power due to the fatigue failure of the connecting rod cap. A related factor was the unsuitable terrain the pilot encountered.Jun 15, 2003 · N5695D · Substantial damage NTSB CHI03FA149Accident · 1 fatalField investigationFinal reportCessna 172S · Sidnaw, MIThe improper short/soft field landing procedure by the pilot and his lack of recent experience in type of operation. Contributing factors were the short/soft field runway, the trees and his delay in aborting the takeoff.Jun 6, 2003 · N975SP · Destroyed NTSB CHI03LA145Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Jenison, MIThe pilot not maintaining directional control of the airplane during landing. A factor to the accident was the overload of the right main landing gear.Jun 2, 2003 · N8278K · Substantial damage NTSB CHI03LA140Accident · No injuriesLimited investigationFinal reportCessna 172M · Midland, MIThe pilot misjugded the flare and his improper recovery from a bounced landing.May 27, 2003 · N61635 · Substantial damage NTSB CHI03LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Blaney Park, MIThe pilot's failure to maintain clearance with the tree line. Factors contributing to this accident were the wind gusts and the trees.May 19, 2003 · N9181P · Substantial damage NTSB CHI03LA126Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cedar Springs, MIThe pilot's inadequate glidepath and his failure to maintain obstacle clearance. A factor to the accident was the semi-trailer.May 15, 2003 · N1528Q · Substantial damage NTSB CHI03LA111Accident · No injuriesLimited investigationFinal reportCessna 150F · Three Rivers, MIThe directional control not maintained by the student pilot. The student pilot's lack of experience was a contributing factor.Apr 23, 2003 · N8082F · Substantial damage NTSB CHI03LA110Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Ironwood, MIThe pilot's inadvertent ground loop on landing. A contributing factor was the ditch.Apr 23, 2003 · N9014A · Substantial damage NTSB CHI03LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · South Haven, MIThe inadequate fuel consumption calculations by the pilot and the fuel exhaustion. The inadequate traffic pattern distance from the runway, which precluded his reaching the runway.Mar 24, 2003 · N43456 · Substantial damage NTSB CHI03IA096Incident · Minor injuriesIncident investigationFinal reportCessna 208B · Saginaw, MIFailure of the engine bleed air pressure regulator. A contributing factor was the anti-chaffing tape on the air supply line.Mar 19, 2003 · N1114N · Minor damage NTSB CHI03LA084Accident · No injuriesLimited investigationFinal reportBell 430 · Highland, MIThe pilot's failure to maintain clearance to the roadway sign. Contributing factors were the failure of the tail rotor gearbox, the roadway sign and the low lighting conditions (night).Mar 17, 2003 · N431UM · Substantial damage NTSB CHI03FA080Accident · 2 fatalField investigationFinal reportMooney M20J · Tower, MIThe pilot's failure to maintain aircraft control during cruise flight. A factor to the accident was the clouds and night conditions.Mar 10, 2003 · N201ZM · Destroyed NTSB CHI03LA076Accident · Minor injuriesLimited investigationFinal reportCessna T210L · New Hudson, MIThe pilot's failure to maintain aircraft control which resulted in the airplane stalling while on final approach.Mar 1, 2003 · N123JL · Substantial damage NTSB CHI03LA072Accident · No injuriesLimited investigationFinal reportBeech V35 · Sparta, MIThe pilots improper decision to fly into known adverse weather, and his failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was airframe icing.Feb 18, 2003 · N9439S · Substantial damage NTSB CHI03LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Clare, MIThe student pilot failed to maintain directional control of the airplane during takeoff roll. A factor was the snow bank.Feb 14, 2003 · N693SA · Substantial damage NTSB CHI03LA063Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot's failure to maintain aircraft control which resulted in the overload of the aircraft. Spatial disorientation, an inoperative turn coordinator, and the pilot's misinterpretation of the flight instruments were contributing factors.Feb 1, 2003 · N5677X · Substantial damage NTSB CHI03LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Traverse City, MIThe student pilot's improper rerecovery from a bounced landing and his improper flare. Factors were the gusting crosswinds, the misjudged flare and the collapse of the nose landing gear.Jan 8, 2003 · N757LE · Substantial damage NTSB CHI03LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Carleton, MIThe #2 cylinder exhaust valve failed due to undetermined reasons. A factor associated with the accident was the soft terrain encountered during the forced landing.Dec 22, 2002 · N8555W · Substantial damage NTSB CHI03LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Jackson, MIThe pilot's failure to follow the checklist and extend the landing gear resulting in a gear up landing.Dec 15, 2002 · N948SB · Substantial damage NTSB CHI03LA037Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Frankenmuth, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Dec 12, 2002 · N8469K · Destroyed NTSB CHI03LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Holland, MIThe student pilot failed to maintain directional control during landing roll. Additional factors include the student pilot's lack of total flight experience, the CFI's inadequate supervision, and the ice and snow on the runway.Dec 4, 2002 · N5321D · Substantial damage NTSB CHI03LA029Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Stalwart, MIThe pilot's improper fuel management during the flight and the pilot's improper decision not to select the outboard fuel tank when a loss of engine power was experienced, resulting in fuel starvation, a sustained loss of engine power, and subsequent forced…Nov 23, 2002 · N5985Y · Substantial damage NTSB CHI03CA022Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Albion, MIA failure by the pilot to maintain sufficient airspeed while maneuvering. Contributing factors were the resulting stall/spin, the relatively low altitude and the soft terrain encountered.Nov 17, 2002 · N5066M · Substantial damage NTSB CHI03FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 175 · MIUndetermined. Missing aircraft.Nov 11, 2002 · N7091M · Substantial damage NTSB CHI03LA011Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Plymouth, MIThe pilot not maintaining directional control during landing and the inoperative right main landing gear brake. Contributing factors were the failed brake master cylinder seal, resulting in a hydraulic leak, the inadequate preflight by the pilot, the fuel…Oct 20, 2002 · N56655 · Substantial damage NTSB CHI03LA006Accident · No injuriesLimited investigationFinal reportWolf Rotorway Exec-162F · Gregory, MIFailure of the secondary drive shaft, which resulted in a complete loss of power to the main rotor, and a high forward airspeed on touchdown, causing the helicopter to flip forward.Oct 7, 2002 · N1955Z · Substantial damage NTSB CHI03LA002Accident · No injuriesLimited investigationFinal reportTanner Kitfox · Coldwater, MIThe low altitude at which an undetermined loss of engine power occurred following takeoff.Oct 2, 2002 · N633KF · Substantial damage NTSB CHI02LA291Accident · No injuriesLimited investigationFinal reportCessna 172S · Boyne Falls, MIThe pilot's improper flare during landing.Sep 21, 2002 · N784SA · Substantial damage NTSB CHI02LA277Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Martin, MIThe pilot's inadequate aircraft preflight and his inability to abort the takeoff due to the obscured windshield. Contributing to the accident was the bent hopper latch and the pilot's failure to maintain directional control.Sep 6, 2002 · N48417 · Substantial damage NTSB CHI02IA275Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Detroit, MIA malfunctioning yaw damper.Sep 4, 2002 · N110XJ · No damage NTSB CHI02FA262Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Newaygo, MIThe altitude/clearance disregarded by the pilot and his ostentatious display. The wire and low altitude flight were a contributing factor.Aug 28, 2002 · N4988J · Destroyed NTSB CHI02LA266Accident · No injuriesLimited investigationFinal reportSchweizer SGS-126E · Ionia, MIThe pilot's failure to maintain clearance from the runway end identifier light (REIL). A factor to the accident was the REIL.Aug 27, 2002 · N126CR · Substantial damage NTSB CHI02LA256Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Coopersville, MIThe pilot's failure to maintain clearance from the transmission wires. Additional factors were the transmission wires and the sunglare.Aug 25, 2002 · N51689 · Substantial damage NTSB CHI02LA244Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Hillman, MIThe pilot's failure to maintain terrain clearance.Aug 12, 2002 · N6658H · Destroyed NTSB CHI02LA238Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Sturgis, MIThe failure of the turbine section of the engine, and the unsuitable terrain encountered for the forced landing. The low altitude was a factor.Aug 7, 2002 · N8444K · Substantial damage NTSB CHI02FA231Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Benton Harbor, MIThe pilot's failure to maintain airspeed above stall speed resulting in a stall/spin. Additional causes were the pilot not maintaining best glide airspeed and optimal glidepath following the loss of engine power. A factor to the accident was the engine…Aug 4, 2002 · N316PM · Substantial damage NTSB CHI02FA228Accident · 1 fatalField investigationFinal reportAeronca 7AC · Caro, MIThe passenger became incapacitated as a result of a stroke which lead to the inadvertent interference with the flight controls.Aug 3, 2002 · N84546 · Substantial damage NTSB CHI02LA220Accident · No injuriesLimited investigationFinal reportCessna R172K · Flushing, MIA loss of engine power for undetermined reasons. Contributing to the accident was the wet runway.Jul 28, 2002 · N1086V · Substantial damage NTSB CHI02LA218Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Copemish, MIThe in-flight engine and cabin fire caused by a fatigue fracture of the left exhaust stack assembly. An additional cause was the part's inadequate design by the aftermarket part manufacturer. A factor to the accident was the soft field in which the emergency…Jul 27, 2002 · N756CS · Destroyed NTSB CHI02FA234Accident · No injuriesField investigationFinal reportPiper PA-28-180 · Macomb, MIThe cracked vertical stabilizer and the unapproved maintenance modification to the rudder by company maintenance personnel.Jul 20, 2002 · N16319 · Substantial damage NTSB CHI02CA202Accident · Minor injuriesData collectionFinal reportEckstein RV-6A · Mattawan, MIFailure by the pilot in command to attain a proper touchdown point considering the available runway length. The rough, uneven runway surface and the soft area at the far end of the runway were contributing factors.Jul 19, 2002 · N747BS · Substantial damage NTSB CHI02CA191Accident · No injuriesData collectionFinal reportCessna 150H · Mecosta, MIThe airplane encountered unsuitable terrain and the pilot applied excessive braking during the aborted takeoff. A factor contributing to the accident was the sandy terrain.Jul 13, 2002 · N6912S · Substantial damage NTSB CHI02LA188Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Jackson, MIThe pilot's improper management of the fuel system, including his failure to reposition the fuel selectors to the main fuel tanks prior to landing, as directed in the pilot operating handbook. Additional causes to the accident were the pilot not maintaining…Jul 11, 2002 · N5061J · Substantial damage NTSB CHI02LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Gregory, MIAn improper decision by the pilot due to a failure to land at an intermediate airport, and the unsuitable terrain for a forced landing encountered. Contributing factors were the pilot's disorientation (becoming lost), fuel exhaustion, soft terrain encountered…Jul 10, 2002 · N621AF · Substantial damage