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 CHI99LA225Accident · No injuriesLimited investigationFinal reportMooney M20J · Harbor Springs, MIthe pilot's inadequate compensation for the wind conditions and his failure to maintain clearance with the trees. Factors associated with the accident were the gusty winds, wind shear, and the trees.NTSB CHI99LA199Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Kalamazoo, MIThe pilot's failure to maintain directional control of the airplane during landing. A factor was the variable wind condition.NTSB CHI99LA197Accident · Minor injuriesLimited investigationFinal reportPorter Searey · Morenci, MIthe pilots inadequate preflight planning and his failure to maintain airspeed. Factors to the accident were the high trees at the departure end of the runway, and the stall encountered.NTSB CHI99FA174Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Drummond Island, MIthe altitude/clearance not obtained/maintained and the inadequate planning/decision by the pilot-in-command. The exceeded aircraft performance was an additional cause. The unfavorable wind and trees were contributing factors.NTSB CHI99LA170Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Kalamazoo, MIthe excessive airspeed, the proper touchdown point not obtained and the aborted landing not performed by the pilot. The fence and automobile were contributing factors.NTSB CHI99LA142Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · Houghton Lake, MIThe loss of engine power for undetermined reasons.NTSB CHI99FA140Accident · 3 fatalField investigationFinal reportPiper PA-28R-201 · Curran, MIthe inadvertent stall/mush. Factor which contributed to this accident were the pilot's inadequate preflight planning, the premature lift-off during the takeoff, the airplane's low airspeed following lift-off, and the trees.NTSB CHI99LA141Accident · Minor injuriesLimited investigationFinal reportBarrett Bensen B-8 · Mt. Pleasant, MIthe inadequate rotor rpm by the pilot.NTSB CHI99LA134Accident · Minor injuriesLimited investigationFinal reportDawe Arnet Pereyra AV II · Fremont, MIthe seizure of the powerplant.NTSB CHI99LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Flint, MIThe loss of engine power for undetermined reasons. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB CHI99FA227Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · St. Clair Shore, MIUndetermined as the aircraft was not recovered.NTSB CHI99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marquette, MIthe pilot's inadequate compensation for the wind conditions which resulted in his failure to maintain directional control. Factors associated with the accident were the gusty crosswind conditions and the taxiway sign which the airplane contacted.NTSB CHI99LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · New Hudson, MIThe pilot's misjudgment of speed and distance and his failure to execute a go-around. A related factor was the crosswind.NTSB CHI99IA115Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-14 · Grand Rapids, MIthe frozen elevator control. Factors were the rain and the low temperatures.NTSB CHI99LA113Accident · No injuriesLimited investigationFinal reportDelong Glastar GS-1 · Lapeer, MIThe failure of the pilot to maintain compensation for wind conditions. Factors to the accident were the crosswind condition and the presence of trees along the runway.NTSB CHI99LA107Accident · No injuriesLimited investigationFinal reportPiper J4A · Howell, MIthe pilot's failure to maintain clearance with the snow covered terrain off the side of the runway while turning the airplane around on the runway. A factor associated with the accident was the snow covered terrain.NTSB CHI99FA105Accident · 1 fatalField investigationFinal reportBeech C-45G · Romulus, MIthe aircraft control not maintained and the inadvertent stall by the pilot while maneuvering to the landing area. The open door was a contributing factor.NTSB CHI99LA103Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIThe pilot's improper flare and failure to maintain directional control. Related factors were the snowbank and lack of total experience.NTSB CHI99LA091Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIthe loss of directional control by the pilot. Factors to the accident were the lack of total experience of the pilot, the snow covered runway condition, the snowbank, and the flight instructor not verifying the runway snow removal with the Duty Instructor…NTSB CHI99LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Grand Ledge, MIthe flight instructor's failure to successfully take remedial action to maintain directional control of the airplane during the landing roll out. Factors were the crosswinds and snowbank.NTSB CHI99LA088Accident · No injuriesLimited investigationFinal reportCessna 150G · Hillman, MIthe pilot's misjudging crosswinds during landing roll. Factors were crosswinds and a snow and ice covered runway, and the snowbank.NTSB CHI99LA086Accident · No injuriesLimited investigationFinal reportBeech 58 · Gaylord, MIthe pilot not obtaining proper runway centerline alignment during landing. Associated factors were the pilot's obscured view through the iced windshield, the runway lights not activating simultaneously with the approach lights, incomplete visual detection of…NTSB CHI99FA072Accident · 3 fatalField investigationFinal reportBeech 95-C55 · Pellston, MIthe pilot's failure to maintain proper altitude/clearance on the approach and his flight into known icing conditions. Factors relating to this accident were the pilot flying with known equipment deficiencies, the pilot's physical impairment (alcohol), the…NTSB CHI99LA074Accident · No injuriesLimited investigationFinal reportCessna 150F · Hillsdale, MIthe pilot's disregarding preparation for the flight. Factors were a frozen landing gear wheel, and the snowbank.NTSB CHI99LA058Accident · No injuriesLimited investigationFinal reportCessna 172P · Lambertville, MIthe pilot-in-command's loss of directional control during landing roll. Factors to the accident were the icy terrain condition, crosswind, and the snow bank.NTSB CHI99LA055Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Traverse City, MIThe crew's failure to execute a missed approach and the flying pilot's (captain) failure to maintain directional control upon touchdown with a seven degree left bank and a right quartering tailwind. Factor's were the snow covered runway/landing area and the…NTSB CHI99FA047Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Waterford, MIthe pilot's descent below the decision height for the instrument approach.NTSB CHI99LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mason, MIthe pilot's inattention to fuel management in that he failed to switch fuel tanks in a timely manner which resulted in fuel starvation. A factor related to the accident was the low altitude at which the loss of engine power occurred.NTSB CHI99LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hancock, MIthe pilot became disoriented while taxiing at an unfamiliar airport and his failure to reduce engine power when the airplane departed the paved surface. Factors associated with the accident were the dark night condition, the pilot did not follow the correct…NTSB CHI99LA031Accident · Serious injuriesLimited investigationFinal reportCessna 337C · New Hudson, MIthe instructor pilot's not maintaining control of the airplane. A factor was the landing gear doors extended.NTSB CHI99LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-150 · Mason, MIwas the pilot not maintaining control of the airplane. A factor in this accident was the pilots lack of total experience in the airplane.NTSB CHI99LA013Accident · 1 fatalLimited investigationFinal reportC.B. Withun T-BIRD II · New Haven, MIthe improper installation of the propeller by the owner/pilot- mechanic and the pilot not maintaining the airplane's airspeed while approaching the trees along the airplane's flight path. A factor in this accident was the stall encountered by the pilot.NTSB CHI99LA004Accident · No injuriesLimited investigationFinal reportCessna 182N · Genesee, MIthe pilot's failure to maintain directional control and the subsequent failure to attain clearance with the trees during takeoff. Factors associated with the accident were the trees, dark night conditions, and fog which resulted in the lack of visual…NTSB CHI99FA003Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Howell, MIThe pilot's failure to maintain/exceed the Vmc airspeed during a go-around maneuver. Contributing factors were the shutting down of the left engine and the lack of recent experience in the type operation.NTSB CHI99LA009Accident · No injuriesLimited investigationFinal reportCessna 150F · Muskegon, MIpoor in-flight planning by an unqualified person which resulted in fuel exhaustion. A factor was the swamp in which the forced landing was made.NTSB CHI99LA001Accident · 2 fatalLimited investigationFinal reportPiper PA-28-140 · Bad Axe, MIThe pilot's failure to maintain adequate altitude/clearance from the wires.NTSB CHI98LA364Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Marshall, MIthe pilot-in-command (CFI)'s inadequate supervision of the student, his not obtaining control of the airplane, and his lack of total experience in the type of operation. A factor was the dual student's not maintaining control of the airplane.NTSB CHI98LA352Accident · No injuriesLimited investigationFinal reportFieseler Flugzeugbau F-156C-1 · Irish Hills, MIthe pilot selected to operate the airplane with a known deficiency. A factor in this accident was the vapor lock experienced by the engine's carburetor.NTSB CHI98LA336Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Eaton Rapids, MIthe pilot's improper decision to abort the takeoff while in the air and beyond the point where the pilot could execute a landing on the remaining airstrip runway area. A factor which contributed to this accident was the soybean crop.NTSB CHI98LA333Accident · No injuriesLimited investigationFinal reportCessna 150E · Cadillac, MIthe pilot's inadequate evaluation of the wind condition which resulted in landing on the wrong runway. A factor associated with the accident was the tailwind.NTSB CHI98LA330Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sault Ste Marie, MIthe pilot's failure to maintain clearance between the airplane and the runway marker. A factor contributing to this accident was the runway marker.NTSB CHI98LA341Accident · No injuriesLimited investigationFinal reportCessna 210D · Sturgis, MIthe cracked left main landing gear saddle, resulting in the pilot's inability to get the gear into the down and locked position.NTSB CHI98LA345Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Grosse Ile, MIthe pilot in command (CFI)'s diverted attention and his failure to select landing gear extension.NTSB CHI98LA340Accident · No injuriesLimited investigationFinal reportCessna 172N · Traverse City, MIthe inadvertent stall/mush. Factors contributing to this accident were the pilot's improper compensation for the wind conditions, and his excessively high flare.NTSB CHI98FA313Accident · 1 fatalField investigationFinal reportHiller FH-1100 · Dewitt, MIThe rotor failure/malfunction due to debonding of the tail rotor blade. Also causal was the inadequate maintenance inspection of the aircraft by the company and the improper maintenance procedure by other maintenance personnel.NTSB CHI98LA290Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Mentha, MIthe pilot's improper inflight decision to land the airplane on the gravel covered road with an uneven surface that had corn growing next to its edge. A factor in this accident was the pilot selecting an unsuitable landing area.NTSB CHI98LA279Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Muskegon, MIA loss of engine power due to a broken number 4 cylinder connecting rod for undetermined reasons. Contributing to this accident was the road embankment.NTSB CHI98LA281Accident · No injuriesLimited investigationFinal reportLuckey Dragonfly II · Caro, MIan improper inflight decision when he mistook the road for the runway of the nearby airport to land on. A factor in this accident was the total failure of the engine's crankshaft.NTSB CHI98FA274Accident · 1 fatalField investigationFinal reportCessna 172M · Brooklyn, MIThe proper touchdown point was not attained and the visual lookout not being maintained by the pilot-in-command. Contributing factors to the accident were the unmarked static and transmission wires.NTSB CHI98LA280Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, MIthe student pilot's delay in performing the abort, and the instructor pilot's failure to take control of the airplane before passing the end of the runway. A factor contributing to this accident was the ditch.