NTSB investigations, 2005, 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
Open the mapLatest 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\") = 2005
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") = 2005 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 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…NTSB CHI05CA247Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Ypsilanti, MIThe pilot's failure to maintain adequate airspeed which resulted in his inability to properly flare the airplane and the subsequent hard landing.NTSB CHI05CA244Accident · No injuriesData collectionFinal reportCessna 414 · Drummond Island, MIThe right main gear collapsed due to undetermined reasons. A factor associated with the accident was the fence that the airplane contacted.NTSB CHI05CA236Accident · No injuriesData collectionFinal reportYamokoski Glastar · Marcellus, MIThe in-flight loss of engine power during cruise for undetermined reasons and the unsuitable terrain the pilot encountered during the forced landing. A factor was the tall corn he encountered.NTSB CHI05CA239Accident · No injuriesData collectionFinal reportBeech 36 · Holland, MIThe failure of the pilot to extend the landing gear prior to landing. A factor to the accident was the pilot becoming distracted by his passengers during landing.NTSB CHI05LA233Accident · Serious injuriesLimited investigationFinal reportNorth American Navion A (L-17B) · Zeeland, MIThe loss of engine power after takeoff due to a fuel selector valve leak and low altitude and low airspeed at the time of power loss. A factor was the recommended maintenance service for the fuel selector not performed by the airplane owner/pilot.NTSB CHI05LA227Accident · No injuriesLimited investigationFinal reportCessna 172S · Zeeland, MIThe inadequate flare by the pilot during landing.NTSB CHI05CA207Accident · No injuriesData collectionFinal reportAllied Ag Cat Productions G-164A · Trufant, MIThe pilot's inadequate visual lookout and not maintaining clearance from the watering pivot during the aerial application maneuver and the unsuitable terrain he encountered during the emergency landing. A factor was the sunglare encountered.NTSB CHI05CA205Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with trees. Contributing to the accident were the trees.NTSB CHI05CA193Accident · Minor injuriesData collectionFinal reportPiper PA-22 · Plainwell, MIThe loss of engine power on downwind due to carburetor icing, and the unsuitable terrain the pilot encountered during the forced landing. A factor was the soft terrain.NTSB CHI05LA190Accident · No injuriesLimited investigationFinal reportMooney M20M · White Cloud, MIA loss of engine power during cruise flight due to the mechanic's improper maintenance, the disconnected oil line, the oil leak from the disconnected line, and the unsuitable terrain the pilot encountered during the forced landing. Factors were the outside…NTSB CHI05LA163Accident · 1 fatalLimited investigationFinal reportBecker RAF 2000 · Gladwin, MIThe pilot's failure to maintain control of the gyrocopter while in the traffic pattern. A factor associated with the accident was the pilot's lack of gyrocopter experience.NTSB CHI05CA181Accident · Minor injuriesData collectionFinal reportPiper PA-31-310 · Lake Huron, MIThe fuel exhaustion during cruise flight, the inadequate in-flight planning/decision by the pilot, and the unsuitable terrain encountered by the pilot during the forced landing.NTSB CHI05CA175Accident · No injuriesData collectionFinal reportCessna A185F · Elk Lake, MIThe gear retraction not performed by the pilot.NTSB CHI05CA166Accident · Minor injuriesData collectionFinal reportCessna 182F · Lapeer, MIThe pilot's inadequate preflight inspection due to his failure to physically verify the security of the fuel tank caps, the unsecured fuel tank cap and fuel exhaustion.NTSB CHI05LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Allegan, MIThe inadequate aircraft control by the PA-28-180 pilot while the airplane was stopped.NTSB CHI05CA156Accident · Minor injuriesData collectionFinal reportBell 206L-3 · Algonac, MIThe pilot not maintaining helicopter control, the loss of tail rotor effectiveness he encountered, and his not maintaining clearance from objects during the approach. Factor were the low altitude, the transmission lines, and the garage.NTSB CHI05CA155Accident · No injuriesData collectionFinal reportCessna 172 · Willis, MIThe pilot's inability to maintain directional control of the airplane due to undetermined reasons. A factor associated with the accident were the trees that the airplane contacted during the aborted takeoff.NTSB CHI05CA144Accident · Serious injuriesData collectionFinal reportCessna 150M · Marcelles, MIThe total loss of engine power due to fuel exhaustion as a result of the CFI's inadequate supervision and inadequate planning/decision. The student pilot's inadequate preflight planning was a contributing factor.NTSB CHI05LA143Accident · No injuriesLimited investigationFinal reportThomas Zenith CH701 · Redford, MIThe total loss of engine thrust was the result of the propeller blades overstress separation from the propeller hub for an undetermined reason. An additional cause was the unsuitable terrain encountered during the forced landing.NTSB CHI05LA140Accident · Serious injuriesLimited investigationFinal reportCessna 310C · Ray, MIThe loss of power on the left engine for undetermined reasons and the flightcrew's failure to maintain aircraft control following the loss of power.NTSB CHI05CA139Accident · Minor injuriesData collectionFinal reportGrimes SNS-9 · Niles, MIThe pilot's failure to maintain airspeed which led to the inadvertent stall/mush, and subsequent impact with the ground.NTSB CHI05CA131Accident · Minor injuriesData collectionFinal reportCessna TU206G · West Bloomfield, MIThe pilot's inadvertent water landing with the amphibious-float wheels extended causing the airplane to nose over.NTSB CHI05LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Mt. Pleasant, MIThe pilot's misjudged distance/speed which led to an overrun and collision with a vehicle. Contributing to the accident was the flight instructor's delayed remedial action in executing a go-around.NTSB CHI05CA124Accident · No injuriesData collectionFinal reportCessna 172S · Port Huron, MIThe pilot not performing a go-around and misjudging the flare leading to a hard landing.NTSB CHI05CA120Accident · No injuriesData collectionFinal reportBrantly Helicopter B-2B · Lakeview, MIThe dual student failed to maintain adequate rotor rpm during the practice autorotation and the instructor's delay in attempting remedial action. A factor associated with the accident was the soft terrain that was encountered.NTSB CHI05CA118Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Ypsilanti, MIThe pilot's inability to maintain directional control of the airplane due to undetermined reasons. Factors associated with the accident were the crosswind condition and the taxiway sign which was contacted. This case was modified October 12, 2006!!NTSB CHI05LA099Accident · No injuriesLimited investigationFinal reportCessna 195A · Jackson, MIThe fracture of the left brake master cylinder piston rod, which resulted in the total failure of the left-side brake system and the subsequent loss of directional control during landing roll. An additional cause was the encountered ground-loop.NTSB CHI05CA095Accident · No injuriesData collectionFinal reportCessna 172P · Ann Arbor, MIThe failure of the carburetor nozzle resulting in loss of engine power and the unsuitable terrain encountered during the forced landing. A factor was the low altitude.NTSB CHI05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Kalamazoo, MIThe pilot's failure to maintain directional control and the excessive taxispeed.NTSB CHI05CA089Accident · Serious injuriesData collectionFinal reportFranz RV-6 · Howell, MIThe pilot's failure to maintain directional control during the landing rollout which resulted in the aircraft departing the runway pavement and nosing over. An additional cause was the pilot's inadequate compensation for the crosswind condition. Contributing…NTSB CHI05LA079Accident · No injuriesLimited investigationFinal reportCessna 210E · Bronson, MIThe pilot's inadequate preflight preparation which failed to detect contaminated fuel that led to a loss of engine power. The unsuitable terrain encountered was a factor.NTSB CHI05FA063Accident · 4 fatalField investigationFinal reportBeech BE-58 · Niles, MIThe steep nose down descent from cruise for undetermined reasons and the subsequent collision with terrain in a steep nose down attitude.NTSB CHI05CA060Accident · No injuriesData collectionFinal reportCessna 172RG · Berrien Springs, MIThe pilot not maintaining airspeed leading to an excessive sink rate during a simulated emergency landing after takeoff. An additional cause was the certified flight instructor's inadequate supervision.NTSB CHI05CA051Accident · No injuriesData collectionFinal reportCessna 414A · Harbor Springs, MIThe pilot's inadequate preflight planning/preparation by his failure to remove the accumulated airframe ice which resulted in deteriorated aircraft takeoff performance. Airframe ice, the snow bank and the fence were contributing factors.