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.
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 CHI02CA184Accident · No injuriesData collectionFinal reportPiper PA-34 · Lowell, MIThe probable cause of this accident was a failure to properly compensate for the current wind conditions. Excessive use of brakes was a contributing factor.NTSB CHI02LA181Accident · No injuriesLimited investigationFinal reportBell 206B · Three Rivers, MIA loss of tail rotor effectiveness.NTSB CHI02CA182Accident · No injuriesData collectionFinal reportBeech A-23-23 · Monroe, MIThe pilot misjudging the flare, and his loss of directional control during landing. The soft terrain was a factor.NTSB CHI02LA171Accident · No injuriesLimited investigationFinal reportHulle Horizon 1 · Niles, MIThe pilot's improper recovery from a bounced landing. A factor was the pilot's lack of experience in tailwheel airplanes.NTSB CHI02FA172Accident · 1 fatalField investigationFinal reportCessna 182A · Foster City, MIThe incapacitation of the pilot. A contributing factor was the pilot and medical examiner providing false information on the pilot's medical applications.NTSB CHI02FA233Accident · No injuriesField investigationFinal reportPiper PA-28-180 · Macomb, MIThe cracked vertical stabilizer and the unapproved maintenance modification to the rudder by company maintenance personnel.NTSB CHI02LA144Accident · No injuriesLimited investigationFinal reportMitsubishi MU2B-20 · Belleville, MIThe pilot's failure to verify the extension of the landing gear prior to landing, and his failure to perform the emergency landing gear extension procedure. The popped circuit breaker was a factor.NTSB CHI02LA139Accident · No injuriesLimited investigationFinal reportWattier Tornado · Grant, MIThe disregarded replacement of the airplane's fuel lines, the operation of the aircraft with known deficiencies, and the turn back to the departure airport by the owner/pilot. The inadequate condition inspection by the mechanic, the cracked fuel line, the…NTSB CHI02LA121Accident · 2 fatalLimited investigationFinal reportYoder GP-4 · Mount Pleasant, MIThe inadvertent stall/spin by the pilot-in-command.NTSB CHI02LA127Accident · No injuriesLimited investigationFinal reportCessna 310L · Detroit, MIThe total failure of the electrical system, the landing gear indicating system not operating, and the unsuccessful emergency landing gear extension.NTSB CHI02LA122Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hastings, MIThe failure to attain airspeed, inadequate supervision of the flight, and delayed remedial action which resulted in a stall.NTSB CHI02IA110Incident · No injuriesIncident investigationFinal reportPiper PA-34-220T · Sturgis, MIThe flightcrew not following the landing checklist, the flightcrew not lowering the landing gear, and the flight examiner's inadequate supervision of the flight.NTSB CHI02FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Niles, MIFlight into known adverse weather conditions by the pilot and the spatial disorientation of pilot. Contributing factors were the lack of certification by the pilot and the weather conditions.NTSB CHI02LA078Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dowagiac, MIThe pilot's inadequate compensation for the wind conditions that resulted in directional control not being maintained during the landing roll. Factors to the accident were the pilot's inadequate in-flight decision to attempt the landing with a gusting 20 knot…NTSB CHI02FA067Accident · 1 fatalField investigationFinal reportCessna 402B · Bronson, MIThe maneuver to avoid the utility wire while maneuvering resulting in an inadvertent stall and subsequent impact with the ground. Factors were the pilot's inadvertent activation of the elevator trim, resulting in a loss of control during flight in instrument…NTSB CHI02LA060Accident · Serious injuriesLimited investigationFinal reportCessna 414A · Sturgis, MIthe inadequate in-flight emergency planning/decision, the checklist not followed and excessive approach altitude by the pilot. Contributing factors were the loose oil return line and weather.NTSB CHI02LA057Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lake Leelanau, MIThe improper planning/decision in runway selection. The soft runway condition and wet snow were contributing factors.NTSB CHI02LA054Accident · No injuriesLimited investigationFinal reportCessna 182K · Nashville, MIthe pilot exceeding the proper touchdown point on the runway during the landing and his improper in-flight planning and decision. Factors relating to the accident were the pilot misjudging his speed and distance during the landing and the ditch.NTSB CHI02LA046Accident · No injuriesLimited investigationFinal reportMiller Lancair 235 · Tecumseh, MIThe pilot's failure to maintain aircraft control during the takeoff. Factors relating to the accident were the crosswind and the wind gusts.NTSB CHI02LA043Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Romulus, MIThe turbulence encountered in-flight and the passenger not complying with the flight and cabin crew’s warning of the turbulance.NTSB CHI02LA021Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lambertville, MIThe pilot's improper flare during landing.NTSB CHI02LA017Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-E · Bellaire, MIthe unsuitable terrain for landing selected by the pilot. A factor was the soft terrain.NTSB CHI02LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lapeer, MIthe touchdown aim point not attained by the pilot rated student and the remedial action not performed by the flight instructor.NTSB CHI02LA011Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Ann Arbor, MIThe pilots failure to maintain directional control during the landing. Factors were the gusty crosswind and the terrain drop-off.NTSB CHI02LA004Accident · No injuriesLimited investigationFinal reportCessna 172N · Beaver Island, MIThe pilot not maintaining directional control of the airplane during landing. The gusty crosswind and the berm were factors.NTSB CHI02FA001Accident · 1 fatalField investigationFinal reportEnstrom F-28A · Attica, MIThe reported loss of engine power due to fuel exhaustion during cruise flight, the pilot not performing an autorotation, the pilot not maintaining rotor RPM during his emergency descent, and the pilot not maintaining control of the helicopter. A factor was…NTSB CHI01LA332Accident · Serious injuriesLimited investigationFinal reportAviaStrottel AC 4C · Marshfield, MIThe pilot's decision to release from the tow plane during the takeoff. A factor associated with the accident was the pilot's vision was restricted by his hat during the takeoff.NTSB CHI01LA325Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Grand Haven, MIAircraft control not maintained by the pilot.NTSB CHI01LA322Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Petoskey, MIThe pilot's inadequate preflight planning, the pilot's improper in-flight decisions, and the unsuitable terrain for landing. A factor relating to this accident was fuel exhaustion.NTSB CHI01LA310Accident · No injuriesLimited investigationFinal reportMooney M20K · Croswell, MIThe pilots failure to abort the takeoff. Factors were the pole and the trees.NTSB CHI01LA304Accident · No injuriesLimited investigationFinal reportBeech C23 · St. Helen, MIThe pilot's failure to attain the proper airspeed which resulted in a premature lift-off and subsequent stall/mush. A factor to the accident was the fence.NTSB CHI01LA296Accident · No injuriesLimited investigationFinal reportDassault/SUD Fan Jet Falcon · Detroit, MIThe wheels up landing performed by the flightcrew during the emergency landing and improper aircraft preflight by the pilot in command. Factors were the unsecured cargo door, the cemetery fence, and the lack of crew coordination during the flight.NTSB CHI01LA295Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Romeo, MIthe reason for the loss of engine power is undetermined.NTSB CHI01LA293Accident · No injuriesLimited investigationFinal reportHughes 269B · Pontiac, MIthe checklist not compiled with by the operator and not verified by the operator’s pilot and the operator's flight instructor. An additional cause was the improper autorotation by the pilot in command. The out of calibration engine idle speed was a…NTSB CHI01FA290Accident · 1 fatalField investigationFinal reportNavion L-17B · Newaygo, MIThe pilot inadvertently positioning the fuel selector in an intermediate position, resulting in a loss of engine power. An additional cause was the pilot's failure to verify the fuel selector position during the engine restart attempt. Factors to the accident…NTSB CHI01LA285Accident · Serious injuriesLimited investigationFinal reportWaters Avid Bandit · Northville, MIfuel starvation due to the pilot's improper fuel calculations. A factor was the concrete building.NTSB CHI01LA289Accident · No injuriesLimited investigationFinal reportCessna 177 · South Haven, MIThe pilot not maintaining aircraft control during the landing. Factors to the accident were the pilot not performing a go-around and the ditch.NTSB CHI01LA280Accident · No injuriesLimited investigationFinal reportCessna 182A · Grosse Ile, MIBoth the CFI and the student pilot on board improperly flared the airplane and the CFI's failure to perform remedial action during the landing.NTSB CHI01LA279Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Traverse City, MIThe pilot not following the emergency landing gear extension procedures. Factors were the failure of the hydraulic motor, and the landing gear locks not engaged.NTSB CHI01LA269Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Mackinac Island, MIThe pilot's failure to maintain proper glidepath during the landing approach resulting in the pilot not maintaining clearance from the trees. Factors were the haze, the gusty winds, and the trees.NTSB CHI01LA266Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Beaver Island, MIThe pilot misjudged the approach and landing, and his failure to abort the landing. Factors associated with the accident were the trees at the approach end of the runway and the sand/gravel pit that the airplane traveled into.NTSB CHI01LA277Accident · Serious injuriesLimited investigationFinal reportBlanik L-13 · Marlette, MIGround crew personnel improperly connected the tow winch cable prior to takeoff which resulted in one side of the winch cable coming disconnected. Factors associated with the accident were the ditch and the tree branch which the airplane contacted.NTSB CHI01LA245Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Detroit, MIThe passenger (an off duty flight attendant) disregarded the flight crews warning regarding turbulence along with the seat belt sign which had been turned on.NTSB CHI01LA236Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Brooklyn, MIThe forced landing for undetermined reasons. A factor to the accident was the corn crop.NTSB CHI01LA226Accident · No injuriesLimited investigationFinal reportCessna 182T · Fowlerville, MIThe student pilot's failure to maintain aircraft control during landing. Factors relating to this accident were the misjudged flare, the exceeded proper touchdown point, the delayed go-around, the student pilot's improper in-flight decisions, and the pond.NTSB CHI01LA224Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Houghton Lake, MIThe pilot's failure to maintain directional control during the takeoff run. A factor relating to this accident was the trees.NTSB CHI01LA225Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Freemont, MIThe broken throttle cable during cruise flight and the pilot's inadequate flare during the forced landing attempt. Factors relating to this accident were the low airspeed during the forced landing attempt and the short, corn stubble field.NTSB CHI01LA268Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Gladwin, MIThe pilot's poor decision to exit the airplane onto the wing while the propeller was running.NTSB CHI01LA213Accident · Serious injuriesLimited investigationFinal reportLaPorte MXL II Sport · Gaines Twp., MIThe pilot's poor planning which resulted in foreign object damage to the propeller, and the low altitude at which the loss of power occurred which resulted in the pilot not being able to properly flare the airplane. Factors associated with the accident were…NTSB CHI01LA207Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Ionia, MIThe pilot not maintaining clearance from the tall grass during his recovery from the bounced landing. A factor was the tall grass.