NTSB investigations, 1992, IL
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 | 2 |
|---|---|
| 1963 | 3 |
| 1964 | 182 |
| 1965 | 166 |
| 1966 | 229 |
| 1967 | 239 |
| 1968 | 199 |
| 1969 | 168 |
| 1970 | 175 |
| 1971 | 158 |
| 1972 | 144 |
| 1973 | 146 |
| 1974 | 143 |
| 1975 | 152 |
| 1976 | 129 |
| 1977 | 139 |
| 1978 | 171 |
| 1979 | 133 |
| 1980 | 121 |
| 1981 | 121 |
| 1982 | 97 |
| 1983 | 109 |
| 1984 | 94 |
| 1985 | 74 |
| 1986 | 70 |
| 1987 | 68 |
| 1988 | 79 |
| 1989 | 72 |
| 1990 | 62 |
| 1991 | 63 |
| 1992 | 64 |
| 1993 | 64 |
| 1994 | 62 |
| 1995 | 47 |
| 1996 | 46 |
| 1997 | 46 |
| 1998 | 37 |
| 1999 | 53 |
| 2000 | 47 |
| 2001 | 51 |
| 2002 | 43 |
| 2003 | 54 |
| 2004 | 31 |
| 2005 | 33 |
| 2006 | 35 |
| 2007 | 46 |
| 2008 | 50 |
| 2009 | 31 |
| 2010 | 42 |
| 2011 | 49 |
| 2012 | 30 |
| 2013 | 29 |
| 2014 | 31 |
| 2015 | 30 |
| 2016 | 32 |
| 2017 | 27 |
| 2018 | 27 |
| 2019 | 22 |
| 2020 | 27 |
| 2021 | 18 |
| 2022 | 30 |
| 2023 | 30 |
| 2024 | 16 |
| 2025 | 37 |
| 2026 | 15 |
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\") = 1992
AND c.\"eventStateOrRegion\" = 'IL' 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") = 1992 AND c."eventStateOrRegion" = 'IL' 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 CHI93LA058Accident · No injuriesLimited investigationFinal reportBeech 90 · Dixon, ILThe instructor pilot not maintaining directional control following engine shut down and not performing remedial action of a power reduction to regain directional control, as prescribed by his company's training manual, once the airplane began to yaw/turn to…NTSB CHI93LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake In The Hls, ILThe student pilot's failure to maintain directional control.NTSB CHI93LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Frankfort, ILFailure of the pilot in command to maintain an airspeed above stall during a landing flare.NTSB CHI93LA043Accident · Serious injuriesLimited investigationFinal reportBoeing 727-232 · Chicago, ILThe captain's inadequate coordination with the ground and flight crew. Factors related to the accident were: the passenger's perception that the APU exhaust was a fire, which resulted in action that initiated an evacuation.NTSB CHI93LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manhattan, ILInadequate compensation for wind conditions by the pilot.NTSB CHI93LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Kankakee, ILThe pilot-in-command not obtaining directional control prior to landing touch down in a crosswind condition.NTSB CHI93LA031Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Marshall, ILAn inadequate preflight inspection of the airplane by the pilot.NTSB CHI93IA035Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71 · Chicago, ILAn improper repair of the retract pin boss area by the overhaul facility.NTSB CHI93FA029Accident · 2 fatalField investigationFinal reportCessna 150L · Elwood, ILThe pilot-in-command's failure to maintain a proper adequate altitude to avoid obstructions. Factors contributing to the accident was the pilot's impairment of efficiency and judgement due to alcohol, and the dark night condition.NTSB CHI93IA019Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Chicago, ILThe failure of the midway arsa controller to coordinate use of the airspace with the Chicago north local controller which resulted in an operational deviation. A factor related to the incident was the pilot's failure to follow his assigned heading.NTSB CHI92LA288Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belvidere, ILThe pilot's failure to maintain adequate clearance from obstacles during the aborted landing. Related factors are the failure to maintain directional control, and the pilot's lack of total experience in the type of operation.NTSB CHI92LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Peoria, ILThe private pilot's misjudged touchdown. Related factors are the reduced visibility due to sunglare, ongoing runway construction, and the pilot's inattention to atc/communications/information.NTSB CHI92FA290Accident · No injuriesField investigationFinal reportBeech B55 · Joliet, ILThe pilot's inadvertent wheels up landing.NTSB CHI92FA282Accident · 1 fatalField investigationFinal reportCessna 152 · Ottawa, ILPilot did not maintain a proper airspeed which led to an inadvertent stall/spin at a low altitude where the pilot could not perform a recovery.NTSB CHI92FA279Accident · 4 fatalField investigationFinal reportCessna 177 · Manlius, ILThe pilot-in-command's failure to maintain control of the airplane during a forced landing, and his inadequate preflight which resulted in fuel exhaustion and power loss.NTSB CHI92LA277Accident · No injuriesLimited investigationFinal reportCessna 172N · Geneseo, ILThe pilot's attempted operation of the airplane with a known defficiency in the equipment.NTSB CHI92LA286Accident · No injuriesLimited investigationFinal reportCessna 210C · Peoria, ILThe pilot-in-command's not compensating for wind conditions and his not maintaining directional control.NTSB CHI92LA272Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Ottawa, ILThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control. Factors were the crosswind and wind gusts.NTSB CHI92LA268Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Harvard, ILFailure of the pilot in command to align the accident airplane with the centerline of the runway during landing.NTSB DCA92MA048Accident · 12 fatalMajor investigationFinal reportBeech C-45H · Hinckley, ILInadequate maintenance and inspection by the operator which resulted in an engine power loss during the critical takeoff phase of flight. In addition, the pilot did not, or was unable to, attain a full-feather position on the left engine propeller, which…NTSB CHI92LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wheeling, ILMain landing gear collapse as a result of the failure of a landing gear hydraulic pump seal.NTSB CHI92DEE04Accident · No injuriesFinal reportWeatherly 201B · Chana, ILFracture of a connecting rod resulting in loss of engine power.NTSB CHI92LA259Accident · No injuriesLimited investigationFinal reportMooney 20F · Lacon, ILThe pilot's failure to recognize that the runway he selected for landing was closed. Factors which contributed to the accident were: the pilot's anxiety following the near-collision, and his limited ability to detect the orange-colored marking.NTSB CHI92LA258Accident · Minor injuriesLimited investigationFinal reportChristen Industries S2B · Alton, ILThe pilot's failure to accomplish refueling.NTSB CHI92IA260Incident · No injuriesIncident investigationFinal reportDouglas DC-8-61 · Morton Grove, ILFailure of the right main landing gear door actuator.NTSB CHI92LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marseilles, ILThe pilot-in-command's failure to abort the takeoff. A factor was the partial loss of engine power.NTSB CHI92LA250Accident · 1 fatalLimited investigationFinal reportBoeing 747-300 · Chicago, ILAn unsafe/hazardous condition that was not identified by the vehicle driver, and an inadequate distance between the airplane and vehicle as the driver drove the vehicle behind the airplane.NTSB CHI92LA248Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILA premature liftoff and failure to maintain directional control during a takeoff ground run by the pilot in command. A delay in taking remedial action by the designated pilot examiner is an additional cause.NTSB CHI92LA252Accident · Serious injuriesLimited investigationFinal reportCameron N-90 · Centralia, ILAbrupt touchdown.NTSB CHI92LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Xenia, ILImproper engine overhaul and noncompliance with an airworthiness directive by other maintenance personnel.NTSB CHI92LA222Accident · No injuriesLimited investigationFinal reportHughes 269C · Aurora, ILFatigue fracture of the engine crankshaft resulting in loss of power. Factors were the pilot's excessive descent and his lack of total experience.NTSB CHI92LA212Accident · No injuriesLimited investigationFinal reportCessna 172H · Chenoa, ILInadequate preflight planning and preparation on the part of the pilot. Factors associated with this accident were a lack of recent experience in the type of operation the pilot was undertaking, a proper climb rate not obtained by the pilot and remedial…NTSB CHI92LA202Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILThe student pilot's failure to maintain airplane directional control. Related factors are the student's lack of total flight experience, and improper aircraft control.NTSB CHI92LA203Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Harvard, ILThe pilot's failure to understand wind information as presented by the windsock, selecting the wrong runway for landing, and delaying the aborted landing.NTSB CHI92LA198Accident · 1 fatalLimited investigationFinal reportCessna 177B · Dwight, ILThe passenger's inattention to the propeller arc and the pilot's improper procedure in disembarking a passenger while the engine was running.NTSB CHI92LA192Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Erie, ILThe pilot's failure to maintain a proper glidepath.NTSB CHI92LA187Accident · No injuriesLimited investigationFinal reportBeech M35 · Dekalb, ILThe pilot's failure to use proper nose wheel steering which resulted in a loss of directional control.NTSB CHI92LA179Accident · No injuriesLimited investigationFinal reportCessna 210B · Belleville, ILThe improper fuel pump high end discharge adjustment. A related factor is improper maintenance/annual inspection.NTSB CHI92LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rockford, ILThe flight instructor's premature liftoff. Related factors are the instructor's lack of total experience in the accident make and model airplane, and the unsuitable terrain encountered during the roll-out.NTSB CHI92LA172Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILThe pilot's improper approach to landing. Related factors are the thunderstorm and the excessive airspeed.NTSB CHI92DEE02Accident · Serious injuriesFinal reportVandenbos/Thorp T-18 · Schaumburg, ILShorting of condensers on both magnetos. A factor was inadequate maintenance servicing of the airplane by other maintneance personnel.NTSB CHI92FA169Accident · 1 fatalField investigationFinal reportMooney M20J · Bloomington, ILThe pilot's failure to maintain aircraft control during the turn from base leg to final approach.NTSB CHI92LA160Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Round Lake, ILThe pilot-in-command's failure to follow emergency procedures, and the fire in the electrical system for reasons undetermined.NTSB CHI92DEV02Accident · Minor injuriesFinal reportSchweitzer Mustang II · Decatur, ILThe pilot's delay in initiating a go-around.NTSB CHI92LA156Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Greenwood, ILExcessive application of the brakes during landing roll.NTSB CHI92LA155Accident · No injuriesLimited investigationFinal reportCessna 172RG · Dekalb, ILThe pilot not maintaining a proper glidepath to the landing runway.NTSB CHI92LA159Accident · No injuriesLimited investigationFinal reportBeech 77 · Moline, ILThe student pilot's failure to maintain directional control.NTSB CHI92LA154Accident · 1 fatalLimited investigationFinal reportCessna 150H · Robinson, ILPoor judgement by the pilot in intentionally proceeding to the airport in instrument meteorological conditions. The weather conditions were a factor.NTSB CHI92FA142Accident · 2 fatalField investigationFinal reportTaylorcraft F19 · Harvard, ILThe pilot's failure to maintain control of the aircraft during the initial climb out. A related factor is the pilot's lack of recent experience.NTSB CHI92LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140D · Markham, ILThe result of an inadequate annual inspection by other maintenance personnel and, as a result, a total failure of the throttle linkage. A factor was the pilot overshot his intended emergency landing area, due to excessive speed.