NTSB investigations, 2004, 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
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\") = 2004
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") = 2004 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 CHI05LA033Accident · No injuriesLimited investigationFinal reportCessna 150H · Columbia, ILA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. Factors were the unsuitable field encountered during the forced landing, the muddy field, and the dark night.NTSB CHI05CA022Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Morris, ILThe pilot's inadequate preflight planning in that he failed to assure that the airplane was properly secured prior to hand propping the engine. Factors associated with the accident were the broken tie down rope and the other airplanes which were contacted.NTSB CHI05CA027Accident · No injuriesData collectionFinal reportCessna T182T · Morris, ILThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control. Factors associated with the accident were the gusty crosswind condition and the runway sign which the airplane contacted.NTSB CHI05LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo Grove, ILFatigue fracture of the engine crankshaft during initial climb after takeoff resulting in a complete loss of engine power. Contributing factors were the trees and the highway.NTSB CHI05LA018Accident · No injuriesLimited investigationFinal reportKramer Glasair III · Schaumburg, ILFuel starvation for undetermined reasons during initial climb after takeoff. Contributing factors were the fence and fence post impacted during the forced landing.NTSB CHI05LA014Accident · 1 fatalLimited investigationFinal reportCessna P206B · Taylorville, ILAircraft control not possible by the pilot following a premature deployment of a parachute as a parachutist exited the jump airplane during cruise flight. The inverted spin encountered by the pilot was an additional cause.NTSB CHI05LA004Accident · 1 fatalLimited investigationFinal reportMalone Vans RV-6A · Joliet, ILThe total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and inadequate fuel consumption calculations, also causal was the pilot's failure to maintain aircraft control during the forced landing. A factor was the…NTSB CHI04LA298Accident · No injuriesLimited investigationFinal reportCessna 208B · Decatur, ILThe pilot's inadequate preflight preparation, and his subsequent selection of a runway for takeoff that was listed as out of service, resulting in a collision with barricades and uneven terrain during takeoff.NTSB CHI04IA260Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Chicago, ILAn in-flight collision with a flock of birds during climb out after takeoff, which damaged the left engine fan module and ruptured a fuel line to the fuel-oil cooler causing an engine fire.NTSB CHI04LA254Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ancona, ILThe pilot became incapacitated (unconscious) for undetermined reasons which resulted in his inability to maintain altitude.NTSB CHI04CA251Accident · No injuriesData collectionFinal reportCessna 182T · Lake In The Hil, ILthe excessive descent rate resulting in a hard landing.NTSB CHI04CA236Accident · No injuriesData collectionFinal reportCessna 182 · Crystal Lake, ILEngine failure due to fuel exhaustion as a result of the pilot's failure to secure the left wing fuel cap during preflight. A factor was the trees.NTSB CHI04LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164-B · Bradford, ILThe pilot's misjudgment of speed and distance, and his failure to perform a go-around. Additional factors were the wet runway and the ditch.NTSB CHI04CA206Accident · No injuriesData collectionFinal reportTjerrild Rotorway Exec · Eureka, ILThe in-flight loss of engine power due to the disconnection of the high tension wire from its ignition coil during cruise flight and the unsuitable terrain the pilot encountered during his forced landing. A factor was the low altitude the helicopter was…NTSB CHI04FA198Accident · 2 fatalField investigationFinal reportMooney M20J · Fox Lake, ILThe flight crew's failure to maintain airspeed which led to an inadvertent stall/spin. An additional cause was the flight instructor's unsuccessful remedial action during the course of the accident sequence. The slow flight performed was a factor.NTSB CHI04LA196Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Sheridan, ILThe convection induced turbulence and the flight attendant not being restrained.NTSB CHI04CA179Accident · No injuriesData collectionFinal reportWaco YMF-FSC · Lansing, ILThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. The crosswind and the ditch were contributing factors.NTSB CHI04CA164Accident · No injuriesData collectionFinal reportCessna 401 · Mt. Vernon, ILThe pilot's misjudgment of the landing flare. Contributing factors were the pilot's failure to execute a stabilized approach for landing. An additional factor was the presence of the runway lights.NTSB CHI04CA160Accident · Minor injuriesData collectionFinal reportChampion 7FC · Carmi, ILThe pilot's failure to maintain directional control during the takeoff roll, his decision to continue the takeoff when the aircraft had left the runway surface, and his selection of unsuitable terrain for the continued takeoff. An additional cause was the…NTSB CHI04LA155Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · Waukegan, ILThe pilot's misjudgment of the landing flare which resulted in a hard landing. Contributing factors were the subsequent overload and collapse of the nose landing gear.NTSB CHI04CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Joliet, ILThe pilot's selection of unsuitable terrain for takeoff and the subsequent failure to maintain aircraft control during the encounter with the standing water. Contributing factors were the standing water and the soft runway condition.NTSB CHI04LA131Accident · 1 fatalLimited investigationFinal reportZorn EAA Sport Bi-Plane · Mazon, ILThe pilot's failure to maintain airspeed while maneuvering which resulted in a stall. A factor associated with the accident was the pilot's unfamiliarity with the handling characteristics of the airplane.NTSB CHI04GA130Accident · 1 fatalFinal reportCessna T206H · Homer Glen, ILThe seized turbocharger, the altitude/clearance not maintained/obtained during approach to a forced landing on an agricultural field, and the unsuitable landing area encountered by the pilot. Contributing factors were the inadequate emergency procedures by…NTSB CHI04CA117Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · DeKalb, ILThe failure of the pilot and his flight instructor to identify the location of the relocated threshold and proper touchdown point, which resulted in the airplane striking the construction barricade while on approach. A factor to the accident was the…NTSB CHI04CA114Accident · No injuriesData collectionFinal reportCessna 172P · Schaumburg, ILThe student pilot not maintaining directional control during the takeoff roll and his inadequate remedial action.NTSB CHI04CA095Accident · No injuriesData collectionFinal reportBeech C23 · Lake in the Hil, ILThe dual student pilot not maintaining airplane control during the go-around and the flight instructor pilot's inadequate remedial action resulting in the airplane's uncontrolled descent.NTSB CHI04LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Peru, ILThe inadvertent landing gear retraction by the dual student during the landing roll.NTSB CHI04LA070Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casey, ILThe pilot not maintaining aircraft control during the loss of engine power and his improper remedial action during the encountered uncommanded roll (VMC roll). An additional cause was the pilot's failure to obtain a maintenance inspection by a qualified…NTSB CHI04LA063Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Lansing, ILThe improper flare by the pilot due to his diverted attention during landing. Factors were the pilot's failure to execute a go-around, the overload of the right main landing gear, and the snowbank.NTSB CHI04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Cahokia, ILThe inadequate supervision by the certified flight instructor which lead to the student pilot's failure to maintain clearance from the snowbank during the landing. The snowbank was a factor.NTSB CHI04LA053Accident · No injuriesLimited investigationFinal reportBeech E-90 · Galesburg, ILThe pilot's inadequate preflight by not complying with the airplane's before takeoff checklist to verify that the cabin door was secured leading to its in-flight separation from the airplane. A factor was that the door was not secured.