NTSB investigations, MI
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 CHI07CA001Accident · No injuriesData collectionFinal reportCessna 180K · Barton City, MIThe pilot's failure to attain a proper touchdown point and his inadvertent selection of a downwind runway, which resulted in the overrun. A contributing factor was the tailwind encountered during landing. Additional factors were the wet, turf runway, and the…NTSB CHI06CA274Accident · No injuriesData collectionFinal reportBeech B19 · Pontiac, MIThe pilot's failure to perform a go-around when he noticed the airplane was not on a stabilized final approach. Contributing factors to the accident were the hard landing, the subsequent pilot-induced oscillation (porpoise) which resulted in the collapse of…NTSB CHI06LA260Accident · No injuriesLimited investigationFinal reportEndless Skies L164 · Durand, MIThe kit builder's improper installation of the aileron bracket leading to the aileron flutter during cruise that resulted in the wing spars' failure.NTSB CHI06CA251Accident · No injuriesData collectionFinal reportLuscombe 8A · Elwell, MIThe airplane nosed over as a result of the pilot's excessive braking after he failed to attain the proper touchdown point and failed to perform a go-around.NTSB CHI06LA243Accident · 1 fatalLimited investigationFinal reportFrick Questair Q20 · Big Rapids, MIThe pilot's failure to ensure an adequate fuel supply, which resulted in the exhaustion of the fuel supply and the subsequent loss of engine power. The trees that the airplane struck during the forced landing were a factor.NTSB CHI06CA239Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Napoleon, MIThe pilot's failure to maintain a proper glidepath during the landing approach, and his excessive airspeed during the landing which resulted in the overrun. A factor was the fence that the airplane impacted.NTSB CHI06FA232Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Sault Ste Marie, MIThe pilot's failure to maintain aircraft control during the circling approach and his failure to perform a missed approach when the airplane was no longer in a position to land using normal flight maneuvers. Contributing to the accident was the pilot's…NTSB CHI06LA230Accident · 1 fatalLimited investigationFinal reportDix Acro Sport II · Coldwater, MIThe loss of engine power for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the resulting forced landing which resulted in the inadvertent stall and subsequent impact with the ground. The rising terrain was a factor.NTSB CHI06CA226Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Hillsdale, MIThe pilot's misjudged flare which resulted in the hard landing and his improper recovery from the bounced landing which resulted in the overload failure of the nose landing gear and subsequent nose over. The overload failure of the nose landing gear was a…NTSB CHI06CA279Accident · No injuriesData collectionFinal reportMeyers MAC-145 · Manistique, MIThe pilot not verifying the landing gear selector position prior to starting the taxi.NTSB CHI06CA217Accident · No injuriesData collectionFinal reportVeltman CH701 · Owosso, MIThe pilot's inadequate preflight planning and inadequate compensation for the tailwind condition. Factors included the tailwind and the power lines.NTSB CHI06CA201Accident · Minor injuriesData collectionFinal reportBeech A36 · Mason, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush on takeoff. Factors associated with the accident were the building and vehicles that were contacted.NTSB CHI06CA198Accident · Minor injuriesData collectionFinal reportSargent Bushby Mustang II · Troy, MIThe pilot's delayed decision to go-around leading to the impact with the fence during the go-around. A factor was the fence.NTSB CHI06CA195Accident · No injuriesData collectionFinal reportGrumman G-164A · Lakeview, MIA loss of engine power for undetermined reasons. A factor associated with the accident was the low altitude at which the airplane was being operated when the loss of engine power occurred.NTSB CHI06CA194Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Marine City, MIA loss of engine power due to the partial blocked carburetor fuel screen which resulted in partial fuel starvation and the pilot's failure to maintain adequate airspeed during the forced landing which resulted in an inadvertent stall. A factor associated with…NTSB CHI06CA203Accident · No injuriesData collectionFinal reportCessna 182 · Napoleon, MIThe pilot failed to perform a go-around which resulted in landing long on the airstrip. Factors associated with the accident were the tailwind, the pilot's selection of runway direction, the fence posts, the fence, and the trees which were contacted.NTSB CHI06LA190Accident · 1 fatalLimited investigationFinal reportArmpriest Breezy · South Haven, MIThe inadvertent stall by pilot during climb following propeller blade damage from the compartment door separation after takeoff. The low altitude and airspeed not maintained by the pilot were additional causes. Contributing factors were the compartment door…NTSB CHI06CA189Accident · No injuriesData collectionFinal reportCessna 172R · Waterford, MIThe directional control not obtained/maintained, the inadequate compensation for wind conditions, and the go-around not performed during landing by the pilot. An additional cause was the lack of experience by the pilot. A contributing factor was the crosswind.NTSB CHI06CA179Accident · No injuriesData collectionFinal reportAviat A-1 · Watervliet, MIThe presence of the deer on the runway which resulted in the pilot taking evasive action leading to the nose-over. A factor was the excessive braking by the pilot.NTSB CHI06CA176Accident · Minor injuriesData collectionFinal reportCessna 182A · Jackson, MIThe pilot's improper preflight planning which led to the exhaustion of the fuel supply during the flight. The overload failure of the nose landing gear was a factor.NTSB CHI06FA152Accident · 1 fatalField investigationFinal reportBeech B36TC · Gregory, MIThe non-mechanical loss of engine power for undetermined reasons during cruise flight and the unsuitable terrain the pilot selected for the forced landing. A factor was the tree that was impacted during the forced landing. An additional factor was the…NTSB CHI06CA140Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Jackson, MIThe pilot's inadvertent wheels up landing.NTSB CHI06LA149Accident · No injuriesLimited investigationFinal reportBeech A23 · Troy, MIThe improper flare and improper recovery from a bounced landing by the unknown pilot.NTSB CHI06LA137Accident · No injuriesLimited investigationFinal reportMaule MT-7-235 · Flushing, MIThe pilot's selection of unsuitable terrain for landing, which resulted in the collapse of the amphibian float's nose wheels, and a nose over during the landing roll. Factors associated with the accident were the soft grass runway, and the collapse of the…NTSB CHI06LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hale, MIThe pilot's inadequate compensation for the crosswind condition and failure to maintain clearance from the tree. Factors were the crosswind and the tree.NTSB CHI06CA116Accident · No injuriesData collectionFinal reportPalulis John Exec 162F · Kalkaska, MIThe compensation for wind conditions not performed by the pilot during hover. An additional cause was the tailwind.NTSB CHI06FA109Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Chelsea, MIThe pilot's inadequate preflight inspection of the helicopter that failed to discover water in the fuel, resulting in a loss of engine power while maneuvering, and an in-flight collision with trees and terrain. Factors associated with the accident were…NTSB CHI06CA111Accident · No injuriesData collectionFinal reportLee SQ 2000 · Berrien Springs, MIFailure of the right main landing gear assembly during landing and the pilot's subsequent inability to maintain directional control of the airplane. Contributing factors were the collapse of the left and right main landing gear and the gusty, crosswind…NTSB CHI06CA106Accident · No injuriesData collectionFinal reportWaco EQC-6 · Battle Creek, MIThe maintenance facility failed to properly install and inspect the rudder cable system resulting in the reversed rudder condition which made directional control not possible during the aborted takeoff. A contributing factor was an inadequate preflight…NTSB CHI06CA102Accident · No injuriesData collectionFinal reportMartin Rans S-7 Courier · Ray, MIThe loss of engine power and fire for undetermined reasons.NTSB CHI06LA092Accident · No injuriesLimited investigationFinal reportSaab-Scania 340B · Alpena, MIThe station agent's inability to maintain control of the stroller when he lost his balance exiting the airplane's cargo compartment, allowing it to be blown into the operating right propeller. A factor was the high, gusty winds.NTSB CHI06FA090Accident · 2 fatalField investigationFinal reportBeech J35 · Holland, MIA lossof engine power due to fuel starvation as a result of the pilot's improper fuel system management and failure to select a tank containing fuel. A factor was the dark night conditions.NTSB CHI06CA098Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Holly, MIA loss of engine power due to undetermined reasons. Factors associated with the accident were the guard rail and the ditch which the airplane contacted during the forced landing.NTSB CHI06CA091Accident · No injuriesData collectionFinal reportBalkema Stol Aircraft · Scotts, MIThe in-flight loss of engine power on downwind for undetermined reasons and the post-impact ground fire that burned the airplane while it was standing.NTSB CHI06CA083Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe solo student pilot's failure to properly compensate for the crosswind, resulting in his failure to maintain directional control during landing. Factors were the crosswind and the snow bank.NTSB CHI06LA073Accident · 2 fatalLimited investigationFinal reportBellanca 7ECA · Pontiac, MIThe excessive bank angle executed by the flight crew and their failure to maintain airspeed during the turn, which led to the inadvertent stall and subsequent impact with the ground. A factor was the low altitude.NTSB CHI06LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Jackson, MIthe blocked induction air filter due to ice accumulation which resulted in a loss of engine power. The pilot's improper weather evaluation, trees, snow, fog, and icing conditions were factors.NTSB CHI06LA070Accident · 1 fatalLimited investigationFinal reportCessna 172 · Harrison, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor associated with the accident was the pilot's impairment due to drugs.NTSB CHI06CA065Accident · No injuriesData collectionFinal reportPiper PA-28-161 · West Branch, MIAn encounter with a deer during landing.NTSB CHI06LA281Accident · No injuriesLimited investigationFinal reportUnivar Ercoupe · Howell, MIThe student pilot's improper landing flare and lack of total experience.NTSB CHI06LA062Accident · No injuriesLimited investigationFinal reportBeech A100 · Sault Ste Marie, MIThe inadequate in-flight decision to continue the approach to land, directional control not maintained, and the contaminated runway. Contributing factors were flight to destination alternate not performed, a notice to airman not issued by airport personnel…NTSB CHI06FA032Accident · 1 fatalField investigationFinal reportAero Commander 500B · Gaylord, MIThe clearance not maintained with terrain during a nonprecision approach. Contributing factors were the ceiling, visibility, night conditions, and trees.NTSB CHI06LA023Accident · Serious injuriesLimited investigationFinal reportMcClintock Glasair SH-2 · Port Huron, MIThe pilot not maintaining airplane control during landing.NTSB CHI06CA024Accident · Minor injuriesData collectionFinal reportColson/Goodbread Rans S-12 · Flushing, MIThe loss of engine power on initial climb for undetermined reasons. A factor was the tree the airplane impacted during the forced landing.NTSB CHI06CA009Accident · No injuriesData collectionFinal reportCessna U206G · Hanover, MIThe pilot misjudged the landing flare which resulted in the bounced landing and subsequent overload failure of the nose landing gear wheel. A factor associated with the accident was the grass airstrip.NTSB CHI06LA006Accident · No injuriesLimited investigationFinal reportBeech 19A · Jackson, MIThe student pilot's inadvertent porpoise during landing, which resulted in a loss of control and a collision with a sign.NTSB CHI06CA001Accident · No injuriesData collectionFinal reportPyramid Aventura II · Lake City, MIThe pilot's failure to obtain or maintain airspeed which resulted in the encountered stall/mush. An additional cause was the pilot's failure to maintain clearance from trees during his precautionary landing. The trees were a factor.NTSB CHI05CA265Accident · No injuriesData collectionFinal reportAviat A-1B · Drummond Island, MIThe pilot's failure to adequately compensate for the wind conditions, his failure to perform a go-around, and he flared improperly. Factors included the downdraft and the shoreline.NTSB CHI05CA263Accident · Minor injuriesData collectionFinal reportKeith Avid Amphibian · Buchanan, MIThe loss of engine power for undetermined reasons and the unsuitable terrain for landing encountered by the pilot. A factor was the power lines.NTSB CHI05CA267Accident · No injuriesData collectionFinal reportWest Revolution Mini 500 · Ida, MIThe pilot's abrupt (improper) control action which resulted in the main rotor contacting the tail boom. Contributing factors were the false indication provided by the engine tachometer, the pilot's decision to immediately initiate an autorotation instead of…