NTSB investigations, 2007, 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\") = 2007
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") = 2007 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 CHI08CA056Accident · No injuriesData collectionFinal reportErcoupe 415D · Abingdon, ILThe loose clamp on the throttle cable which prevented application of engine power. A factor in the accident was the low altitude when the throttle cable slipped.NTSB CHI08FA053Accident · 3 fatalField investigationFinal reportBeech V35B · Springfield, ILThe loss of control during an instrument approach due to spatial disorientation.NTSB CHI08LA051Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Chicago, ILThe tug driver's failure to yield the right-of-way to the airplane prior to crossing the active taxiway as required by airport procedures, and his subsequent failure to maintain clearance with the airplane. A contributing factor was the presence of the tug on…NTSB CHI08FA050Accident · Serious injuriesField investigationFinal reportBoeing 777-222 · Chicago, ILEmergency evacuation due to dense smoke in the cabin and the possibility of an on-board fire, which resulted in a serious injury to one of the 264 passengers and crew. An additional cause was the failure of an engine bearing, allowing oil to migrate into the…NTSB CHI08LA046Accident · 1 fatalLimited investigationFinal reportSwearingen T R/Masters W Rand KR 2 · Benton, ILThe reason for this accident is undetermined.NTSB CHI08LA041Accident · 1 fatalLimited investigationFinal reportHerink H R/Herink R W Challenger · Apple River, ILThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the low altitude and the gusty wind conditions.NTSB CHI08LA040Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Waukegan, ILThe pilot's failure to assure that all of his tools were accounted for prior to takeoff which resulted in the foreign object jamming the control stick and the pilot's inability to maintain control of the airplane. A factor associated with the accident was the…NTSB CHI08CA038Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plato Center, ILThe excessive airspeed used by the pilot which resulted in an overrun, impact with a ditch and subsequent nose over. The ditch was a factor.NTSB CHI08IA026Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Chicago, ILThe misrouted and reversed antiskid wiring by vendor maintenance personnel leading to the runway excursion. Contributing to the incident were the runway sign, the vendor's maintenance personnel not understanding the entire maintenance procedures in the dual…NTSB CHI08CA011Accident · No injuriesData collectionFinal reportCessna 172P · Belleville, ILthe design limits of the aircraft being exceeded by a previous pilot during an unknown phase of flight.NTSB CHI07CA303Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Bloomington, ILThe pilot's failure to maintain directional control during takeoff roll which resulted in a ground loop.NTSB CHI07FA286Accident · 2 fatalField investigationFinal reportYakovlev Yak 52 · Lake-in-Hills, ILThe airplane descended and impacted terrain during initial climb for undetermined reasons. Contributing to the accident was the soft, uphill terrain.NTSB CHI07CA275Accident · Minor injuriesData collectionFinal reportWeaver, David A Pulsar 912XP · Plato Center, ILthe pilot's failure to maintain airspeed. Factors were the pilot's lack of familiarity with the aircraft and pilot's failure to maintain altitude.NTSB NYC07IA199Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301T · Alton, ILThe component manufacturer's inadequate fabrication of the transient voltage suppressor.NTSB CHI07CA268Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Cooksville, ILThe partial loss of engine power during the takeoff roll for undetermined reasons and the pilot's unsuccessful compensation for the tailwind conditions. Factors contributing to the accident were the tailwind and the corn crop.NTSB CHI07CA276Accident · No injuriesData collectionFinal reportGolden Eagle Chief · Hindsboro, ILThe loss of engine power due to the number seven cylinder's separation during cruise and the crops encountered during the forced landing leading to the airplane nosing over.NTSB CHI07LA240Accident · No injuriesLimited investigationFinal reportAircoupe F-1A · Greenwood, ILThe loss of engine power due to carburetor icing, which resulted in the pilot having to perform a forced landing to unsuitable terrain. Factors contributing to the accident were the carburetor icing conditions and the broken carbuerator heat lever.NTSB CHI07CA242Accident · No injuriesData collectionFinal reportMarcellus Starduster SA-300 · Columbia, ILThe pilot's improper flare, which resulted in a hard landing and subsequent left main landing gear collapse.NTSB CHI07CA227Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Prophetstown, ILThe pilot's failure to accurately monitor fuel consumption during flight, which resulted in a loss of engine power due to fuel starvation/exhaustion. A contributing factor was the cornfield encountered during the forced landing.NTSB CHI07LA221Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Moline, ILFatigue failure of the engine cylinder during cruise flight resulting in a loss of engine power. Additional causes were the pilot's failure to maintain sufficient airspeed and the resulting inadvertent stall during the forced landing. A contributing factor…NTSB CHI07LA224Accident · No injuriesLimited investigationFinal reportBeech V35B · Rockford, ILA loss of engine power for undetermined reasons, which resulted in a forced landing. A contributing factor was the unsuitable terrain (corn field) encountered during the landing.NTSB CHI07CA214Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Sheldon, ILThe pilot's inability to maintain a proper rate of climb during takeoff. Factors associated with the accident were the pilot's failure to dump the chemical load and the ditch which the airplane contacted.NTSB CHI07LA207Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Wyoming, ILThe pilot's failure to maintain clearance with the power lines during the aerial application flight. Contributing to the accident were the power lines and the low altitude.NTSB CHI07CA200Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lake in the Hil, ILThe pilot's failure to achieve a proper touchdown point and delayed decision to abort the landing. Factors contributing to the accident include the chain link fence and the trees.NTSB CHI07CA202Accident · No injuriesData collectionFinal reportCessna 172N · Yorkville, ILThe inadequate fuel consumption calculations by the pilot, the fuel exhaustion during cruise flight, and the unsuitable landing area encountered by the pilot. Contributing factors were the night light conditions and trees.NTSB CHI07CA188Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Walkerville, ILThe altitude/clearance not maintained by the pilot during the aerial application flight. The corn was a contributing factor.NTSB CHI07CA190Accident · No injuriesData collectionFinal reportCessna 150L · Salem, ILThe loss of engine power due to fuel exhaustion which resulted in a forced landing. Additional causes were the certified flight instructor's inadequate preflight supervision. Factors contributing to the accident were the disorientation encountered by the…NTSB CHI07FA184Accident · No injuriesField investigationFinal reportBoeing 777-222 · Chicago, ILThe 777-222's flight crew not maintaining clearance from the parked/standing MD 83 and the airport not coordinating the taxi chart instructions with air traffic control. Contributing to the accident was the MD 83's flight crew not following the taxi chart…NTSB CHI07FA182Accident · 2 fatalField investigationFinal reportNorth American Navion · Colona, ILThe non-instrument rated pilot's continued flight into instrument meteorological conditions.NTSB CHI07LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Columbia, ILThe certified flight instructor's (CFI's) inadequate preflight planning/preparation of a test altitude that would afford an on airport landing in the event of engine power loss. Additional causes were the CFI not flying a traffic pattern that would allow for…NTSB CHI07LA170Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Lansing, ILThe loss of engine power during takeoff-initial climb due to a bent exhaust valve and fouled spark plugs.NTSB CHI07CA171Accident · No injuriesData collectionFinal reportLuscombe 8A · Columbia, ILThe pilot's failure to maintain directional control of the airplane, causing a ground loop, subsequent runway excursion, and left main gear collapse. Factors in the accident include the ground loop encountered and the depression.NTSB CHI07CA165Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Manito, ILThe pilot's failure to maintain proper airspeed and his decision to attempt flight over maximum gross weight. A factor to the accident was the stall encountered while attempting to avoid obstacles.NTSB CHI07LA157Accident · 1 fatalLimited investigationFinal reportPurvis Rans S6S · Newark, ILThe pilot's failure to maintain control of the airplane which resulted in inadequate airspeed and a subsequent stall. Contributing to the accident were the pilot's improper installation of the altimeter and airspeed indicator which rendered them inoperative…NTSB CHI07CA153Accident · No injuriesData collectionFinal reportCessna 182S · Harvard, ILThe pilot's misjudged flare and improper recovery from a bounced landing, which caused the nose gear to collapse and subsequent damage to the propellor and underside of the airplane.NTSB CHI07CA128Accident · No injuriesData collectionFinal reportCessna 172P · West Chicago, ILThe instructor's inadequate remedial action following the student pilot's loss of control during the crosswind landing and the instructor's failure to compensate for the wind conditions. Contributing factors were, the crosswind, the gusting wind conditions…NTSB CHI07LA106Accident · Minor injuriesLimited investigationFinal reportBrowns Vans RV-7A · Gardner, ILEngine failure during cruise flight for undetermined reasons. A factor was the rough/uneven terrainNTSB ENG07WA026Incident · No injuriesForeign investigationBoeing B747-400 · Chicago, ILNTSB CHI07LA108Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Wheeling, ILPartial failure of the left engine propeller governor during the takeoff ground roll. Factors included that directional control was not possible by the pilot which subsequently led to a collision with an airport sign.NTSB CHI07CA094Accident · No injuriesData collectionFinal reportMcCall Rotorway 162F · Malta, ILThe pilot's improper use of the rotorcraft flight controls resulting in a dynamic rollover during takeoff. A factor was the soft ground that the left skid encountered.NTSB CHI07LA093Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Chicago, ILThe contained fan blade tip separation following the ingestion of several birds into the left engine during takeoff and the lack of an adequate response time available to crew to avert the bird strike.NTSB CHI07LA080Accident · 1 fatalLimited investigationFinal reportWood Quickie Q-2 · Edwardsville, ILThe loss of engine power during cruise due to loose cylinder head bolts/loose cylinders.NTSB CHI07LA078Accident · Serious injuriesLimited investigationFinal reportBoeing 777 · Chicago, ILAn in-flight encounter with turbulence during cruise flight.NTSB CHI07CA082Accident · No injuriesData collectionFinal reportCessna 172N · Pinckneyville, ILPresence of a deer on the runway resulting in an inadvertent collision during the landing roll.NTSB ENG07IA009Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-36 · Chicago, ILComplete loss of No. 2 engine power due to a partial rim failure of the 2nd stage turbine wheel, resulting in No. 2 engine shutdown and turbine debris exiting the side of the engine. The wheel failure mechanism could not be determined due to missing turbine…NTSB CHI07CA054Accident · No injuriesData collectionFinal reportCessna 172S · Alton, ILThe student pilot's inadequate recovery from a bounced landing, which resulted in the airplane impacting a runway sign. A factor in the accident was the student pilot's misjudged landing flare.