NTSB investigations, MI
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 CHI98LA265Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Ironwood, MIthe pilot's not compensating for wind conditions and his allowing an inadvertent stall. A factor was wind gusts.NTSB CHI98LA303Accident · Minor injuriesLimited investigationFinal reportCook Teenie TWO · Stevensville, MIThe pilot's inadequate preflight planning and preparation which resulted in fuel exhaustion and subsequent loss of engine power.NTSB CHI98LA257Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Napoleon, MIthe pilot inadequate pre-flight planning. Factors in this accident were the airplane's weight and balance limitations had been exceeded by the pilot and an improper top overhaul of the engine's cylinder by the mechanic.NTSB CHI98LA253Accident · Serious injuriesLimited investigationFinal reportCameron A105 · Howell, MIThe pilot's failure to visually recognize hazards associated with meteorological phenomenon. A contributing factor was the weather condtion.NTSB CHI98LA249Accident · No injuriesLimited investigationFinal reportCessna 190 · Pontiac, MIimproper procedures used during the replacement of the landing gear which resulted in pitting and corrosion of the gear spring.NTSB CHI98LA246Accident · No injuriesLimited investigationFinal reportCessna 182L · Mackinac Island, MIThe pilot's failure to attain a stabilized approach and a touchdown point. The factors contributing to the accident were the pilot in command's improper use of flaps and his not performing a go-around. An additional factor was the pilot in command not using…NTSB CHI98FAMS1Accident · 2 fatalMissing aircraftFinal reportAero Vodochody Aero. Works L-39C · Traverse City, MIUndetermined.NTSB CHI98LA233Accident · Minor injuriesLimited investigationFinal reportWicks FLY Baby · Blissfield, MIthe pilot's misjudging of the fuel supply and his inadequate aircraft preflight. A factor was fuel exhaustion,NTSB CHI98LA231Accident · No injuriesLimited investigationFinal reportKerr Startduster TOO · Bay City, MIthe pilot's failure to assure the tailwheel tire had adequate pressure which resulted in his inability to maintain directional control of the airplane during a landing. Factors associated with the accident were the inadequate pressure and the uneven terrain…NTSB CHI98LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Flushing, MIwas a delayed go-around maneuver by the pilot. Factors associated with this accident were the pilot misjudging his final approach altitude and glide path, having inadequate altitude to clear the trees at the end of the runway, and inadequate training on how…NTSB CHI98LA214Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIthe pilot misjudging his distance and not maintaining the proper altitude. A factor was trees.NTSB CHI98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Bay City, MIa fatigue failure of the left nose gear caster bolt which resulted in a separation of the nose gear during landing.NTSB CHI98LA209Accident · 1 fatalLimited investigationFinal reportTillman Christen II · Howell, MIthe pilot not maintaining aircraft control during the go-around maneuver. A factor in this accident was the pilot s lack of recent experience in the accident airplane.NTSB CHI98LA200Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Albion, MIthe pilot's improper preflight planning/preparation and his not refueling the airplane to avoid fuel exhaustion. Factors were the pilot's lack of certification, his not feathering the engine, and the trees.NTSB CHI98LA194Accident · Serious injuriesLimited investigationFinal reportLeone Smith Mini Plane · Northport, MIthe pilot's not maintaining airspeed, and his lack of total experience in this type of aircraft.NTSB CHI98LA183Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Montague, MIthe pilot's improper use of carburetor heat which resulted in the formation of carburetor ice and the loss of engine power. Factors to the accident were the carburetor icing conditions and the trees.NTSB CHI98LA151Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Monroe, MIthe pilot-in-command's inability to rotate during takeoff due to restricted movement of the elevator controls for undetermined reasons.NTSB CHI98LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Clarkston, MIthe pilot selected unsuitable terrain on which to make the precautionary landing due to weather. Factors associated with the accident were the fog, low ceiling, poor in-flight planning, the precautionary landing, the loose wet gravel on which the…NTSB CHI98LA146Accident · No injuriesLimited investigationFinal reportDangremond Challenger II · Wayland, MIthe pilot's improper installation of the right wing forward strut attachment bolt.NTSB CHI98FA130Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Kalamazoo, MIThe pilot's failure to maintain adequate flying airspeed resulting in a stall condition. Contributing factors were the tailwind condition and the pilot's exceeding the gross weight of the airplane on takeoff.NTSB CHI98LA129Accident · 1 fatalLimited investigationFinal reportGood Velocity · Romulus, MIimproper planning/decision by the pilot, by using the airplane in an illegal activity and allowing the fuel to be exhausted before landing. Factors relating to this accident were: the pilot being under pressure to reach his destination with his illegal cargo,…NTSB CHI98LA131Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Canton, MIThe undetermined loss of power reported by the pilot. Contributing factors were the residential nature of the landing area and unsuitable landing terrain.NTSB CHI98LA132Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tecumseh, MIThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control. A contributing factors were wind gusts and crosswind.NTSB CHI98LA100Accident · No injuriesLimited investigationFinal reportCessna 650 · Manistee, MIthe pilots excessive airspeed during landing, exceeding the proper touchdown point, and failure to execute a missed approach.NTSB CHI98LA090Accident · No injuriesLimited investigationFinal reportCessna 150M · Troy, MIthe student pilot's failure to maintain direction control of the airplane. Factors relating to this accident were: the crosswind, and wet/soft terrain (mud) beside the runway.NTSB CHI98LA078Accident · No injuriesLimited investigationFinal reportCessna 150J · Gaylord, MIthe pilot's misjudging the flare leading to a hard landing, and the kit manufacturer's (Supplemental Type Certificate holder's) inadequate design leading to a corrosion stress fracture of the landing gear attachment. A factor was the landing gear attachment…NTSB CHI98LA067Accident · Serious injuriesLimited investigationFinal reportBeech 35-B33 · Troy, MIloss of engine power for undetermined reason(s). Factors associated with the accident were: the lack of a suitable forced landing site, and the embankment (dirt bank), which the airplane contacted.NTSB CHI98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hillsdale, MIThe student pilot's failure to maintain. Contributing were icy conditions on the runway and a snowbank.NTSB CHI98LA052Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Vicksburg, MIthe pilot's inadequate preflight preparation and his failure to maintain directional control during takeoff. A factor was the uneven runway at the grass airstrip.NTSB CHI98LA013Accident · Minor injuriesLimited investigationFinal reportSchweizer FGS-233 · Ionia, MIthe pilot misjudged the landing approach which resulted in his failure to attain a proper touchdown point. A factor was the trees.NTSB CHI98LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Charlotte, MIimproper positioning of the fuel selector by the second pilot, which resulted in fuel starvation; inadequate supervision by the pilot-in-command; and failure of the flight crew to follow the published emergency procedures for loss of engine power.NTSB CHI98LA002Accident · Serious injuriesLimited investigationFinal reportMikowski Challenger II S · Lake City, MIthe improper oil to gas mixture in the fuel during refueling and the pilot did not follow the written instructions from the kit manufacturer. Factors contributing to the accident were the pilot could not maintain directional control and the low altitude.NTSB CHI97LA304Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Brooklyn, MIfailure of the pilot to see-and-avoid the transmission wires (inadequate visual lookout, and failing to maintain sufficient altitude and clearance from the obstruction).NTSB CHI97LA301Accident · No injuriesLimited investigationFinal reportUniversal D-16 · Howell, MIthe emergency landing gear extension system being impeded by flap extension. Factors contributing to this accident are the instructor pilot's intentional feathering of the airplane's left propeller, the instructor pilot's lack of familiarity with the…NTSB CHI97FA300Accident · 2 fatalField investigationFinal reportBeech T34B · Fremont, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall. Also causal was the pilot's ostentatious display.NTSB CHI97FA308Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · St. Ignaces, MIThe noninstrument-rated pilot's improper decision to depart in instrument meteorological conditions, which resulted in impact with terrain.NTSB CHI97LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grant, MIthe pilot's fixation on the end of the runway, his failure to place the airplane in an attitude to land (flare) which resulted in a hard landing, and the pilot's failure to recover from the subsequent bounced landing.NTSB CHI97FA283Accident · 1 fatalField investigationFinal reportCessna 177B · Crump, MIContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC) and her failure to maintain control of the airplane, due to spatial disorientation. Related factors were the low ceiling, and the pilot's lack of instrument…NTSB CHI97LA284Accident · 2 fatalLimited investigationFinal reportNorth American-Aero Classics P-51D · Monroe, MIthe pilot operating the airplane with a known coolant leak, coolant exhaustion, overheating of the engine, and subsequent failure of a connecting rod, which resulted in a partial loss of engine power; and failure of the pilot to see the powerline. The…NTSB CHI97LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Romeo, MIthe pilot's improper use of carburetor heat, which resulted in carburetor ice and loss of engine power. Factors relating to the accident were: carburetor icing conditions, and the crop (corn) in the emergency landing area.NTSB CHI97LA274Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Flushing, MIthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the tailwind, the pilot's runway selection, and the hangar.NTSB CHI97LA273Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIfailure of a connecting rod in the engine assembly, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: lack of a recommended engine overhaul, and the lack of suitable terrain for an emergency landing.NTSB CHI97LA267Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Coopersville, MIthe pilot inadequate fuel system management which led to a fuel starvation.NTSB CHI97LA268Accident · No injuriesLimited investigationFinal reportBeech G35 · Belleville, MIthe pilot's improper planning/decision by failing to assure that the airplane was either tied down or chocked prior to pulling the propeller through, which started the engine with no one at the controls.NTSB CHI97LA241Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Eagle, MIthe pilot's inaccurate fuel consumption calculations, his decision to switch fuel tanks too late, and fuel starvation.NTSB CHI97LA234Accident · Minor injuriesLimited investigationFinal reportRutan Defiant · Alma, MIthe pilot did not perform an adequate preflight check and he did not perform the takeoff checklist. Factors included the pilot's inadequate design of the safety latch and the canopy inadvertently deploying.NTSB CHI97LA233Accident · 1 fatalLimited investigationFinal reportAlbrecht SEA REY · Brighton, MILoss of engine power due to a failed exhaust valve oil seal, and fouled spark plugs.NTSB CHI97LA231Accident · 1 fatalLimited investigationFinal reportStratton Challenger II · Bellaire, MIfailure of the pilot to maintain control of the airplane during takeoff. The gusty wind condition was a related factor.NTSB CHI97LA203Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Cadillac, MIthe pilot failed to maintain control of the airplane during an attempted go-around and the pilot's lack of recent flight experience.NTSB CHI97LA197Accident · 2 fatalLimited investigationFinal reportPiper PA-18 · Middleville, MIfuel contamination, due to improper servicing of the aircraft; and failure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in a inadvertent stall and collision with the terrain. The pilot's failure to ensure a proper…