NTSB investigations, 2002, MI
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 145 |
| 1965 | 153 |
| 1966 | 169 |
| 1967 | 193 |
| 1968 | 174 |
| 1969 | 182 |
| 1970 | 176 |
| 1971 | 159 |
| 1972 | 150 |
| 1973 | 149 |
| 1974 | 141 |
| 1975 | 115 |
| 1976 | 131 |
| 1977 | 106 |
| 1978 | 121 |
| 1979 | 118 |
| 1980 | 98 |
| 1981 | 116 |
| 1982 | 87 |
| 1983 | 101 |
| 1984 | 91 |
| 1985 | 82 |
| 1986 | 86 |
| 1987 | 57 |
| 1988 | 63 |
| 1989 | 69 |
| 1990 | 86 |
| 1991 | 65 |
| 1992 | 66 |
| 1993 | 60 |
| 1994 | 52 |
| 1995 | 56 |
| 1996 | 58 |
| 1997 | 52 |
| 1998 | 51 |
| 1999 | 50 |
| 2000 | 46 |
| 2001 | 62 |
| 2002 | 44 |
| 2003 | 50 |
| 2004 | 39 |
| 2005 | 43 |
| 2006 | 48 |
| 2007 | 36 |
| 2008 | 32 |
| 2009 | 35 |
| 2010 | 30 |
| 2011 | 34 |
| 2012 | 38 |
| 2013 | 29 |
| 2014 | 31 |
| 2015 | 26 |
| 2016 | 24 |
| 2017 | 22 |
| 2018 | 28 |
| 2019 | 23 |
| 2020 | 22 |
| 2021 | 29 |
| 2022 | 17 |
| 2023 | 21 |
| 2024 | 21 |
| 2025 | 26 |
| 2026 | 19 |
Where
Latest cases
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 year(c.\"eventDate\") = 2002
AND 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 year(c."eventDate") = 2002 AND 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 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.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.NTSB CHI03LA037Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Frankenmuth, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.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.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…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.NTSB CHI03FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 175 · MIUndetermined. Missing aircraft.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…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.NTSB CHI03LA002Accident · No injuriesLimited investigationFinal reportTanner Kitfox · Coldwater, MIThe low altitude at which an undetermined loss of engine power occurred following takeoff.NTSB CHI02LA291Accident · No injuriesLimited investigationFinal reportCessna 172S · Boyne Falls, MIThe pilot's improper flare during landing.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.NTSB CHI02IA275Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Detroit, MIA malfunctioning yaw damper.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.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.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.NTSB CHI02LA244Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Hillman, MIThe pilot's failure to maintain terrain clearance.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.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…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.NTSB CHI02LA220Accident · No injuriesLimited investigationFinal reportCessna R172K · Flushing, MIA loss of engine power for undetermined reasons. Contributing to the accident was the wet runway.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…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.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.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.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…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…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.