NTSB investigations, 1997, IL
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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
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\") = 1997
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") = 1997 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 CHI98FA074Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-30 · Wayne, ILthe pilot in command failed to maintain control of the aircraft. A factor was the lack of experience of the pilot and copilot in the type and model of aircraft. An additional factor was the pilot did not follow the proper procedure when the flaps were raised…NTSB CHI98FA070Accident · 4 fatalField investigationFinal reportPiper PA-32-301 · Hampshire, ILthe pilot's intentional flight into known icing conditions, and the accumulation of ice on the leading edges of the airplane's empennage and wings leading to the inadvertent stall/mush. A factor contributing to this accident was the icing conditions.NTSB CHI98LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILthe pilot's not identifying unsuitable terrain (snowbank) in the landing area, and his not selecting the proper touchdown point. A factor was the snowbank.NTSB CHI98LA063Accident · No injuriesLimited investigationFinal reportBeech 1900C · Rockford, ILimproper installation of aileron cables by the maintenance personnel, inadequate inspection by the company's maintenance personnel of maintenance performed, and inadequate preflight by the pilot.NTSB CHI98LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodstock, ILthe pilot's failure to see-and-avoid the powerlines on short final. The location of the powerlines was a related factor.NTSB CHI98LA033Accident · Minor injuriesLimited investigationFinal reportBeech C90A · Chicago, ILthe driver of the vehicle failed to yield the right-of-way to an airplane taxiing in a designated airport taxiway.NTSB CHI98LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Robinson, ILthe pilot's improper decision to continue flight into adverse weather conditions The low ceiling and the heavy rain were factors.NTSB CHI98GA025Accident · 2 fatalFinal reportAerospatiale AS350B · Frankfort, ILthe pilot in command misjudged the clearance with the terrain during a dark night maneuvering approach to a runway. A related factor was the dark night conditions.NTSB CHI98FA028Accident · 6 fatalField investigationFinal reportBeech BE 58 · New Berlin, ILA loss of engine power due to separation of the left engine's number 2 connecting rod as a result of fatigue failure. Also causal was the pilot's failure to maintain adequate airspeed which resulted in a stall/spin. Contributing to the accident was the…NTSB CHI98LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Quincy, ILimproper in-flight planning/decision by the flight instructor (CFI), by switching 'OFF' the fuel selector valve of the single-engine airplane (starving the engine of fuel) to 'simulate' an emergency. Factors relating to the accident were: the soft and uneven…NTSB CHI98FA017Accident · No injuriesField investigationFinal reportBeech G35 · Poplar Grove, ILflutter for an undetermined reason, which resulted in structural damage to the aft fuselage.NTSB CHI98LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Sandwich, ILthe pilot's inability to maintain flying airspeed resulting in an inadvertent stall/mush. A factor contributing to this accident was the wind gust.NTSB CHI98IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Chicago, ILan improper repair to a crack in a brake flange hole on the left main landing gear outboard axle, and subsequent fatigue failure of the axle.NTSB CHI97LA299Accident · No injuriesLimited investigationFinal reportBeech C23 · Champaign, ILan undetermined engine and/or oil system failure that resulted in an oil leak and subsequent loss of engine power. A related factor was: high vegetation (corn crop) in the emergency landing area.NTSB CHI97LA298Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Chicago, ILthe pilot's selection of the wrong taxi route (service road) and not maintaining clearance between his airplane's wing and a bus.NTSB CHI97LA296Accident · No injuriesLimited investigationFinal reportCessna 150M · Salem, ILthe student pilot's improper flare and improper recovery from a bounced landing.NTSB CHI97FA293Accident · 2 fatalField investigationFinal reportKeaggy-David Skybolt · Adeline, ILThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CHI97LA285Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace BAE-ATP · Peru, ILsudden/unexpected encounter with clear air turbulence.NTSB CHI97LA287Accident · Serious injuriesLimited investigationFinal reportHiggens Rans S-12 XL · Tuscola, ILthe pilot's failure to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall.NTSB CHI97LA265Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Grayslake, ILexcessive airspeed and the pilot's failure to attain the proper touchdown point during landing. Factors associated with the accident were inadequate aircraft preflight and the ditch.NTSB CHI97LA261Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Hinckley, ILthe failure of the glider pilot to properly handle his airplane during the initial takeoff climb which resulted in the tow pilot's inability to maintain control of his airplane.NTSB CHI97LA247Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Hampshire, ILthe pilot's failure to maintain directional control of the airplane during landing, and his excessive use of brakes, which resulted in a nose over. Factors relating to the accident were: the crosswind condition, and the pilot's lack of experience in the make…NTSB CHI97LA227Accident · Minor injuriesLimited investigationFinal reportKearns RV-6 · Harrisburg, ILThe pilot's failure to maintain adequate clearance. A factor was the marked transmission wire.NTSB CHI97FA218Accident · 7 fatalField investigationFinal reportCessna 172P · Chicago, ILthe pilots not maintaining visual separation between their airplanes. A factor in this accident was the pilot of the southbound airplane not reporting her position abeam the airport as directed by the ATC controller.NTSB CHI97LA211Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Springfield, ILfailure of the pilot to maintain safe altitude/clearance from the terrain. Factors relating to this accident were: the hazy weather condition, the resultant difficulty in keeping the other airplane in sight, and the pilot's diverted attention, while looking…NTSB CHI97TA198Accident · Minor injuriesFinal reportCessna 182R · Peoria, ILthe pilot's improper use of carburetor heat and the carburetor icing conditions which existed at the time of the accident. Factors were the ditch and poles which the airplane contacted.NTSB CHI97LA199Accident · No injuriesLimited investigationFinal reportSnow S2C · Viola, ILthe pilot's inadequate preflight planning/preparation by failing to ensure there was an inadequate supply of fuel for the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Uneven terrain in the emergency landing area was a…NTSB CHI97LA185Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Manito, ILloss of engine power for undetermined reason(s).NTSB CHI97LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lansing, ILthe pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to flare during the landing. The crosswind was a related factor.NTSB CHI97LA180Accident · No injuriesLimited investigationFinal reportCessna 172RG · Chicago, ILthe pilot inadvertently executed a wheels up landing.NTSB CHI97IA164Incident · No injuriesIncident investigationFinal reportDouglas DC-10-30F · Chicago, ILthe lack of communications to assure safe operations between aircraft on a non-movement area.NTSB CHI97LA150Accident · Serious injuriesLimited investigationFinal reportGrumman G164 · Illinois City, ILfailure of the pilot to see and maintain clearance from a static wire. The proximity of the wire was a related factor.NTSB CHI97LA145Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-G · Colusa, ILimproper installation of the rocker arm assembly by maintenance personnel which led to the failure of the rocker arm. A factor was the soft terrain.NTSB CHI97LA142Accident · No injuriesLimited investigationFinal reportMooney M20F · Wheeling, ILbinding of the number four exhaust valve, which resulted in a partial power loss. A factor was the ravine.NTSB CHI97FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Savoy, ILthe pilot's improper preflight planning/preparation and her not maintaining airspeed. Factors were fuel exhaustion and entering an inadvertent stall.NTSB CHI97LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grayslake, ILthe pilot's misjudgment of the aircraft's speed and runway distance available. Factors were an off-field ditch and a tailwind condition.NTSB CHI97LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochelle, ILthe student pilot's delay in aborting the takeoff and the use of excessive braking after deciding to abort the takeoff. A factor was the pilot's failure to maintain runway alignment during the landing.NTSB CHI97LA121Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILthe pilot-in-command's inadequate compensation for the wind conditions. A factor associated with the accident was the gusty crosswind condition.NTSB CHI97IA117Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200 · Chicago, ILinadequate nickel plating was applied to the compressor disk during the rework process at the operator's overhaul facility, which resulted in a brittle fracture in the disk and an uncontained engine failure. A factor was the operator's lack of written…NTSB CHI97LA111Accident · No injuriesLimited investigationFinal reportCessna 177 · Rantoul, ILthe student pilot's improper flare and improper recovery from a bounced landing.NTSB CHI97LA104Accident · No injuriesLimited investigationFinal reportCessna 177 · Harrisburg, ILthe loss of engine power followed by an engine fire for reason or reasons undetermined.NTSB CHI97LA078Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2Q8 · Chicago, ILClear air turbulence.NTSB CHI97LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · West Chicago, ILfuel starvation due to the pilot's improper fuel tank selection.NTSB CHI97LA077Accident · No injuriesLimited investigationFinal reportBeech A36 · Matherville, ILa loss of engine as a result of the pilot-in-command's improper positioning of the fuel tank selector. A factor was the rough terrain.NTSB CHI97FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna T210N · Chicago, ILUndetermined.NTSB CHI97LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILThe loss of power for undetermined reasons.