NTSB investigations, 2014, 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\") = 2014
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") = 2014 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 CEN15IA079Incident · No injuriesIncident investigationFinal reportCessna T182T · Cahokia, ILThe mechanic’s improper installation of the elevator trim actuator, which resulted in reversed elevator trim control, and his subsequent failure to detect the misrigging of the elevator cables during the postmaintenance inspection.NTSB CEN15IA076Incident · No injuriesIncident investigationFinal reportCessna 182S · Springfield, ILThe improper installation of a doubler patch, which prevented the right flap from actuating and moving properly and led to the subsequent interference with the aileron.NTSB CEN15LA068Accident · Serious injuriesLimited investigationFinal reportRans S-14 · Kewanee, ILThe pilot’s failure to maintain airspeed during the final approach, which resulted in a stall/mush. Contributing to the accident was the pilot’s failure to obtain training in the pusher-type airplane.NTSB CEN15FA048Accident · 1 fatalField investigationFinal reportAero Commander 500 B · Chicago, ILThe pilot's failure to maintain airspeed while attempting to return to the airport after a reported engine problem, which resulted in an aerodynamic stall/spin.NTSB CEN15CA037Accident · No injuriesData collectionFinal reportCessna 162 · Hinckley, ILThe student pilot's relaxing of elevator back pressure during the landing roll that induced a porpoise, loss of control, and collapsing of the nose wheel.NTSB CEN15LA028Accident · 1 fatalLimited investigationFinal reportHuebbe Sonex HB · Plainview, ILThe loss of engine power during cruise flight due to a fatigue fracture of the crankshaft, which resulted in a forced landing on unsuitable terrain.NTSB CEN15CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Quincy, ILThe pilot's improper fuel management, which resulted in the total loss of power to both engines due to fuel exhaustion and the subsequent forced landing in a field. Also causal to the accident was the pilot's decision to use the slower emergency hand-pump to…NTSB CEN15FA009Accident · 3 fatalField investigationFinal reportRaytheon 58 · Palos Hills, ILThe pilot's loss of airplane control due to spatial disorientation while operating in night, instrument meteorological conditions.NTSB CEN15CA011Accident · No injuriesData collectionFinal reportBeech 35-B33 · Effingham, ILThe pilot's failure to lower the landing gear.NTSB CEN15LA021Accident · No injuriesLimited investigationFinal reportRaytheon 58 · Dixon, ILThe pilots’ improper decision to continue flight in icing conditions after the deicing boots could not shed accumulated ice, which resulted in a temporary loss of airplane control.NTSB CEN14FA522Accident · 1 fatalField investigationFinal reportCessna T337G · Plano, ILThe pilot’s failure to recognize the airplane’s low altitude and arrest the airplane’s descent on approach to the airport in dark night conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s degraded night…NTSB CEN14LA517Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Cahokia, ILThe pilot’s poor decision to take off with the clutch warning light illuminated, which resulted in the total failure of the fan assembly due to a lack of lubrication. Contributing to the accident was the mechanic’s failure to lubricate the lower actuator…NTSB DCA14CA170Accident · Minor injuriesData collectionFinal reportEmbraer EMB 145XR · Chicago, ILThe tractor driver's failure to give way to the taxiing airplane.NTSB CEN14CA499Accident · Serious injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Newark, ILThe student pilot did not maintain proper airspeed during the simulated emergency landing and failed to relinquish control to the flight instructor when the flight instructor attempted to intervene, which resulted in the loss of control. Contributing was the…NTSB CEN14CA490Accident · Serious injuriesData collectionFinal reportBuckeye Dream · Monee, ILThe pilot's failure to see and avoid power lines while maneuvering low to the ground, which resulted in a collision and loss of control.NTSB CEN14CA464Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Colusa, ILThe pilot did not maintain control of the airplane during takeoff from a grass strip. Contributing was the airplane being loaded beyond its capability for the runway.NTSB CEN14LA423Accident · 1 fatalLimited investigationFinal reportBell 47G 5 · Mansfield, ILThe pilot's failure to maintain clearance from power lines during low-altitude flight in gusting wind conditions following his use of a sedating medication.NTSB CEN14LA408Accident · No injuriesLimited investigationFinal reportRaytheon B36TC · Decatur, ILDebris in the fuel system, which resulted in fuel starvation and a subsequent loss of engine power.NTSB CEN14CA457Accident · No injuriesData collectionFinal reportCessna 172N · Murphysboro, ILA hard landing by person(s) unknown.NTSB CEN14LA349Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Carthage, ILThe airplane’s inability to climb out of ground effect, which resulted from the pilot using a lower power setting than needed for takeoff due to the mechanic’s installation of the wrong engine torque gauge.NTSB CEN14CA352Accident · No injuriesData collectionFinal reportBeech 35 33 · Mt. Vernon, ILThe pilot's failure to ensure the landing gear was extended into the fully locked position.NTSB CEN14CA365Accident · Minor injuriesData collectionFinal reportCessna 182A · Geneseo, ILThe pilot's mismanagement of the available fuel supply, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN14LA316Accident · 1 fatalLimited investigationFinal reportGrazhopper Trike · Ottawa, ILThe noncertificated pilot’s improper decision to operate the powered-parachute at low altitude through mist in a confined area while he was impaired by multiple sedating medications, which resulted in his loss of control of the parachute and subsequent impact…NTSB CEN14LA309Accident · No injuriesLimited investigationFinal reportSchumacher Challenger II · St. Joesph, ILThe total loss of engine power due to a lack of lubrication following the in-flight failure of the mechanical oil injection pump. Contributing to the accident was the temporary obscuration of the pilot's forward visibility due to sun glare during the forced…NTSB CEN14CA289Accident · No injuriesData collectionFinal reportCessna 182A · Valmeyer, ILThe inadvertent deployment of the skydiver's drogue chute when he exited the airplane, resulting in it contacting and damaging the horizontal stabilizer.NTSB CEN14LA235Accident · Minor injuriesLimited investigationFinal reportPazmany PL 4 · Yates City, ILA loss of propeller thrust due to a failure of the reduction drive unit resulting from the improper installation of the unit. Contributing to the accident was a lack of documentation for the reduction drive unit installation.NTSB CEN14LA196Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · West Chicago, ILThe failure of the nose gear actuator attachment to the engine mount due to overstress, which resulted in the loss of directional control during landing.NTSB CEN14LA127Accident · No injuriesLimited investigationFinal reportPiaggio P180 - Avanti II · Springfield, ILThe pilot's decision to reengage the hydraulic system following the successful extension of the landing gear using the emergency extension procedures. Contributing to the accident was the failure of the directional control valve in the gear-up position and…NTSB CEN14LA134Accident · No injuriesLimited investigationFinal reportCessna 172K · Milan, ILThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during a short final approach.NTSB CEN14CA124Accident · Minor injuriesData collectionFinal reportCessna R182 · Mt. Morris, ILThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate pre-flight planning and decision-making.NTSB CEN14IA121Incident · No injuriesIncident investigationFinal reportCessna 680 · Wheeling, ILThe disconnection of the left elevator trim driveshaft from the trim actuator due to the elevator trim tab drive pin becoming dislodged, which resulted in full nose-down elevator trim.