NTSB investigations, 2018, 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\") = 2018
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") = 2018 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 DCA19CA038Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Chicago, ILan object which fell from an overhead bin struck a flight attendant resulting in a serious injury.NTSB GAA18CA531Accident · No injuriesData collectionFinal reportPiper PA44 · Centralia, ILThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended before landing. Contributing to the accident was the flight instructor’s delayed remedial action and…NTSB CEN18LA328Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · South Beloit, ILThe pilot’s failure to maintain airspeed after being startled and distracted when the engine cowling opened during takeoff, which led to a subsequent impact with terrain.NTSB CEN18LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Columbia, ILThe airplane's inability to climb due to reduced engine power as a result of insufficient compression in all cylinders and fouled spark plugs in the No. 2 cylinder while operating near its maximum gross weight.NTSB GAA18CA588Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe student pilot's failure to maintain clearance from a truck while taxiing.NTSB CEN18LA270Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Bismarck, ILA loss of control for reasons that could not be determined based on the available information.NTSB GAA18CA421Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, ILThe pilot’s improper preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB GAA18CA415Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · De Land, ILThe pilot’s selection of unsuitable terrain for landing in crosswind conditions, which resulted in the airplane inadvertently becoming airborne and a subsequent hard landing and loss of directional control.NTSB GAA18CA430Accident · No injuriesData collectionFinal reportRobinson R44 · Okawville, ILThe pilot's improper preflight weight and balance calculation, which resulted in his operating the helicopter over its maximum gross takeoff weight and in its subsequent failure to climb.NTSB CEN18FA259Accident · Serious injuriesField investigationFinal reportEurocopter Deutschland EC135 P1 · Chicago, ILThe pilot's inadvertent disabling of the No. 1 and No. 2 engines' electronic engine control systems, which resulted in engine and rotor overspeed conditions, a subsequent autorotation, and a hard landing. Contributing to the accident were the pilot's…NTSB CEN18LA260Accident · No injuriesLimited investigationFinal reportBell 206 · Bentley, ILThe pilot's failure to ensure that adequate fuel was on board for the maneuvering flight, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA18CA401Accident · No injuriesData collectionFinal reportGrumman G164 · Rochelle, ILThe pilot’s failure to move the power lever to the proper position before takeoff, which resulted in insufficient airspeed and a subsequent aerodynamic stall.NTSB GAA18CA409Accident · No injuriesData collectionFinal reportCessna 208 · Chicago, ILThe service truck driver’s evasive maneuver to avoid a bag cart tug, which resulted in the truck impacting a parked airplane.NTSB GAA18CA397Accident · Minor injuriesData collectionFinal reportRobert Miles Smith Trike · Lewiston, ILA total loss of engine power due to the pilot's failure to apply carburetor heat in conditions conducive to carburetor icing and his subsequent failure to maintain directional control during a forced landing.NTSB CEN18FA235Accident · 2 fatalField investigationFinal reportErcoupe 415 D · Monmouth, ILA loss of engine power for reasons that could not be determined based on the available information.NTSB OPS18IA015Incident · No injuriesClass 3 · IncidentFinal reportBoeing 747 · Chicago, ILInterference with the localizer signal resulting in a Multipath condition experienced by CAL5148 while conducting an ILS CAT III (autoland) approach. This condition resulted in a runway excursion and subsequent go-around. The interference was most likely…NTSB CEN18LA228Accident · Minor injuriesLimited investigationFinal reportRGJ Johnson AIR CAM · Greenwood, ILThe pilot's decision to take off with insufficient runway available and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA18CA354Accident · No injuriesData collectionFinal reportBoeing B75 · Waukegan, ILThe flight instructor’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control.NTSB GAA18CA360Accident · No injuriesData collectionFinal reportCessna 172 · Salem, ILThe student pilot’s failure to maintain clearance from a pole while taxiing the airplane on the ramp.NTSB GAA18CA305Accident · Minor injuriesData collectionFinal reportZS Delta-Bielsko Wroclaw SZD 36 A Cobra 15 · Hammond, ILThe pilot’s loss of directional control during an off-airport landing and his subsequent failure to maintain clearance from power pole guy wires.NTSB CEN18LA205Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Union, ILThe pilot’s medical impairment at the time of the accident, which resulted in a collision with power lines off the end of the runway.NTSB CEN18LA181Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV7A · Hanover Park, ILA partial loss of engine power shortly after takeoff due to water contamination of the fuel system.NTSB GAA18CA255Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Dekalb, ILThe pilot’s improper landing flare during gusting wind conditions, and the flight instructor’s delayed remedial action.NTSB GAA18CA157Accident · No injuriesData collectionFinal reportCessna 182 · Rockford, ILThe pilot’s unnecessary action during the approach, which resulted in a hard landing.NTSB CEN18LA092Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172M · Centralia, ILThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall/spin.NTSB GAA18CA110Accident · Minor injuriesData collectionFinal reportHelicopteres Guimbal Cabri G2 · Cahokia, ILThe student pilot's failure to maintain yaw control while landing in gusting crosswind conditions and the flight instructor's delayed remedial action.NTSB CEN18LA082Accident · Serious injuriesLimited investigationFinal reportMatheny Larry E Christavia MK 1 · Grand Detour, ILThe pilot's failure to see and avoid the power line. Contributing to the accident was the pilot’s intentional flight at low altitude.