NTSB investigations, 1999, 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 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\") = 1999
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") = 1999 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 CHI00LA056Accident · No injuriesLimited investigationFinal reportCessna 210 · South Lyon, MIthe failure of the throttle and the unsuitable terrain encountered by the pilot in the taxi area. Factors were the collapsed nose gear and the rough terrain,NTSB CHI00LA048Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hanover, MIfuel starvation and the pilot's improper fuel tank selector position. A factor was the swampy terrain.NTSB CHI00LA029Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Romulus, MIthe inadvertent wheels-up landing by the pilot.NTSB CHI00FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 175 · MIundetermined.NTSB CHI00LA015Accident · Serious injuriesLimited investigationFinal reportWelch Murphy Rebel · Saint Johns, MIthe pilot not maintaining altitude and clearance. Factors were the trees, the flap control not fully engaged, and the pilot's lack of total experience in the kind of airplane flown.NTSB CHI00LA011Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Grand Ledge, MIthe pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind and the tree which the airplane contacted.NTSB CHI00FA006Accident · Serious injuriesField investigationFinal reportDassault DA-900B · Holland, MIThe copilot's improper use of the autopilot system while leveling the flight from descent, resulting in an inadvertent pilot-induced pitch oscillation of the airplane. A factor was the flight attendant not wearing a seat belt at the time of the occurrence.NTSB CHI99LA349Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Detroit, MIthe pilot's failure to maintain control of the airplane which resulted in the inadvertent spin. A factor was the pilot snagged the banner pole.NTSB CHI99LA339Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Ann Arbor, MIThe pilot's improper touchdown during a water landing.NTSB CHI99LA337Accident · 1 fatalLimited investigationFinal reportReichert MJ-77 · Owosso, MIthe pilot's improper preflight which resulted in a takeoff with the oil cap not secured and the subsequent loss of engine power.NTSB CHI99LA354Accident · No injuriesLimited investigationFinal reportCessna 150L · Midland, MIthe student pilot's failure to maintain control of the airplane during an attempted go-around.NTSB CHI99FA332Accident · 1 fatalField investigationFinal reportPiper PA-12 · Neguanee, MIthe pilot failed to maintain clearance from the tower.NTSB CHI99LA318Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Watervliet, MIthe pilot not maintaining aircraft control during takeoff, and the pilot not correcting for the porpoise.NTSB CHI99LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Harsens Island, MIthe loss of engine power for undetermined reasons. Factors were the berm and the pond.NTSB CHI99LA299Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Lambertville, MIthe inadequate aircraft preflight by the pilot and the pilot's failure to remove the aileron gust lock before flight. Factors to the accident were the soft terrain adjacent to the runway and the collapse of the nose gear.NTSB CHI99LA292Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Hudson, MIwas an inadequate preflight and misjudged flare to landing during the autorotation by the pilot. A factor in this accident was a totally blocked fuel tank vent system.NTSB CHI99FA290Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Paw Paw, MIthe pilot flew into known adverse weather, the pilot's lack of total instrument flight experience, and the pilot exceeded the design limits of the airplane. Factors included the pilot's total lack of experience in the type of operation and the pilot's…NTSB CHI99LA291Accident · No injuriesLimited investigationFinal reportCessna 182 · Tecumseh, MIfracture of the right main landing gear strut.NTSB CHI99MA269Accident · 10 fatalMajor investigationFinal reportBeech 65-A90 · Marine City, MIThe pilot's failure to maintain adequate airspeed, which resulted in a stall, inflight loss of contol, and collision with the ground.NTSB CHI99LA251Accident · No injuriesLimited investigationFinal reportCessna 180 · Frankfort, MIthe inadequate flare and the go-around not performed by the pilot.NTSB CHI99LA249Accident · No injuriesLimited investigationFinal reportCessna 152 · Berrien Springs, MIFailure to obtain a proper climb rate and the delayed remedial action by the certified flight instructor. Contributing factors were the uphill terrain and trees.NTSB CHI99LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, MIthe student pilot's inadequate use of the rudder which resulted in a loss of directional control during an aborted landing. A factor associated with the accident was the student's lack of total experience and the segmented circle which the airplane contacted.NTSB CHI99LA239Accident · No injuriesLimited investigationFinal reportCessna 411 · Troy, MIEngine explosion/fire during start for undetermined reason.NTSB CHI99FA221Accident · 1 fatalField investigationFinal reportCessna 150 · Hubbard Lake, MIthe failure of the pilot to maintain aircraft control after executing the low pass and steep nose up climb.NTSB CHI99LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rogers City, MIThe pilot's inadequate compensation for the crosswind.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.