NTSB investigations, 2005, 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\") = 2005
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") = 2005 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 CHI06CA053Accident · No injuriesData collectionFinal reportCessna 172R · Morris, ILThe pilot's improper in-flight decision to land with a quartering tailwind and not maintaining directional control. Factors were the quartering tailwind and the snowdrift.NTSB CHI06CA059Accident · No injuriesData collectionFinal reportCessna 150F · Poplar Grove, ILThe student pilot's inadequate recovery from the bounced landing, and not maintaining airplane control during the landing.NTSB DCA06MA009Accident · 1 fatalClass 1 · MajorFinal reportBoeing 737-700 · Chicago, ILThe pilots' failure to use available reverse thrust in a timely manner to safely slow or stop the airplane after landing, which resulted in a runway overrun. This failure occurred because the pilots' first experience and lack of familiarity with the…NTSB CHI06CA054Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Rockford, ILFailure of the commercial pilot (dual student) to maintain a proper descent rate and a safe airspeed during the simulated forced landing. Additional causes were the failure of the flight instructor and the dual student to initiate a go-around in sufficient…NTSB CHI06LA038Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-10 · Chicago, ILThe failure of the flight crew to see and avoid the crew stairs and the failure of unknown persons to properly secure the stairs after use. Factors associated with the accident were the dark light conditions and the gusty winds.NTSB CHI06FA030Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Bloomington, ILThe aircraft control not possible by the pilot during a visual approach to the runway due to the physical impairment of the pilot.NTSB CHI06CA025Accident · Minor injuriesData collectionFinal reportPiper PA22-150 · Canton, ILThe fire for undetermined reasons.NTSB CHI06CA014Accident · No injuriesData collectionFinal reportCessna 210C · Kankakee, ILA hydraulic line leak causing a loss of hydraulic fluid and subsequent failure of the hydraulic system. An additional cause was the inoperative landing gear extension system, both normal and emergency, due to a complete loss of the hydraulic system.NTSB CHI06CA013Accident · Minor injuriesData collectionFinal reportCessna 152 · Peoria, ILThe student pilot's failure to maintain adequate airspeed during a go-around which resulted in the airplane stalling.NTSB CHI05CA259Accident · Minor injuriesData collectionFinal reportDixon RV-4 · Grafton, ILThe loss of engine power due to contamination of the fuel system, gascolator and carburetor inlet screen. A factor to the accident was the soybean crop.NTSB CHI05CA256Accident · No injuriesData collectionFinal reportBoeing A75N1 · Ellisville, ILThe loss of engine power due to the failure of the number four connecting rod. A factor to the accident was the soybean crop.NTSB CHI05CA253Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Rockton, ILThe pilot's excessive descent rate on approach for landing and the settling with power condition subsequently encountered. Contributing factors were the pilot's failure to reduce the descent rate prior to entering the settling with power condition and his…NTSB CHI05LA243Accident · 1 fatalLimited investigationFinal reportAllensworth Baby Belle · El Dara, ILThe manufacturer failed to specify a relief radius on the tail rotor spindle drawings, which resulted in the spindle being manufactured with an inadequate relief radius at the point of fatigue failure.NTSB CHI05CA248Accident · No injuriesData collectionFinal reportPiper PA-28-180 · McConnell, ILThe pilot's inadequate preflight/planning which resulted in the attempted takeoff on the soft airstrip. Factors associated with the accident were the soft terrain, the corn crop, and the inadequate airspeed achieved during the takeoff roll.NTSB CHI05LA238Accident · No injuriesLimited investigationFinal reportBoeing 757-33N · Chicago, ILThe flightcrew's failure to maintain clearance from a fence while taxiing.NTSB CHI05CA222Accident · No injuriesData collectionFinal reportCessna 150L · Hillsboro, ILThe improper preflight planning/preparation by the pilot and fuel exhaustion during cruise flight.NTSB CHI05LA220Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · New Boston, ILThe loss of engine power due to a cylinder failure and the unsuitable terrain encountered by the pilot during the forced landing.NTSB CHI05CA172Accident · No injuriesData collectionFinal reportWaco CTO · Shelbyville, ILThe loss of engine power during cruise due to carburetor ice. A factor was conditions conducive to carburetor icing.NTSB CHI05FA212Accident · Minor injuriesField investigationFinal reportCessna 421C · Wheeling, ILThe pilot's improper in-flight decision to execute a go-around without raising the landing gear and raising the flaps to the full UP position, resulting in low airspeed and the airplane stalling. Contributing factors to the accident included the pilot's…NTSB CHI05GA198Accident · Serious injuriesFinal reportBell 206L-3 · Justice, ILThe pilot's improper in-flight decision while maneuvering which resulted in a tailwind during low airspeed helicopter flight and subsequent loss of tail rotor effectiveness. The struck sign and fence were factors in the accident.NTSB CHI05CA185Accident · Minor injuriesData collectionFinal reportAero Commander S2R · Walnut, ILFuel exhaustion due to the pilot's inadequate in-flight planning/decision. A contributing factor was the corn field.NTSB CHI05LA179Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · Chicago, ILThe pushback tow driver not maintaining visual lookout for the wing walker's visual signal, and the driver not maintaining clearance from the vehicle during the pushback for taxi. Factors to the accident were the standing vehicle behind the airplane, the…NTSB CHI05CA169Accident · Minor injuriesData collectionFinal reportKelley Volmer Amphibian B · Nauvoo, ILThe pilot's failure to maintain appropriate airspeed during landing, which resulted in a stall/mush condition and hard landing.NTSB CHI05LA173Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Crete, ILThe separation of the drive belt, during cruise, leading to the puncturing of the oil cooler and subsequent fire. An additional cause was the pilot's restricted lookout during the emergency landing resulting in the hard landing.NTSB CHI05CA157Accident · Minor injuriesData collectionFinal reportCessna 195 · Peru, ILThe pilot not maintaining directional control during the landing and the ground loop he encountered.NTSB CHI05CA151Accident · No injuriesData collectionFinal reportKirby Christen Eagle · Wheeling, ILThe pilot's inadequate compensation for the wind conditions, and his failure to maintain obstacle clearance, which resulted in the airplane drifting during the landing flare and impacting the taxiway light.NTSB CHI05LA136Accident · No injuriesLimited investigationFinal reportCessna 182TR · Wheeling, ILThe pilot failed to verify that the landing gear were fully extended and failed to perform the emergency landing gear extention procedures. Factors to the accident included the low hydraulic fluid level, and the weak battery that resulted in a partial…NTSB DCA05MA071Accident · Serious injuriesMajor investigationFinal reportBombardier CL-600-2B19 · Chicago O'Hare, ILThe opening of the service door when the airplane was pressurized. Contributing to the accident was the captain's failure to ensure that one of the airplane doors was open while a ground-cooling cart was connected, which resulted in pressurizing the airplane…NTSB CHI05CA134Accident · No injuriesData collectionFinal reportTemco GC-1B · Morris, ILMalfunction of the pilot seat positioning mechanism for undetermined reasons resulting in a loss of aircraft control. The runway light struck when the airplane departed the pavement was a contributing factor.NTSB CHI05LA125Accident · 1 fatalLimited investigationFinal reportHurley Searey · South Beloit, ILIn-flight collision with the ground for undetermined reasons.NTSB CHI05CA126Accident · No injuriesData collectionFinal reportYoung Zodiac 601XL · Mattoon, ILThe pilot's failure to maintain control of the airplane during the landing flare resulting in an in-flight collision with the runway pavement.NTSB CHI05LA122Accident · Serious injuriesLimited investigationFinal reportCessna R182 · Vandalia, ILThe pilot's failure to maintain control of the airplane due to undetermined reasons.NTSB CHI05LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Buffalo Grove, ILA loss of engine power due to fuel exhaustion during approach, inadequate preflight planning/preparation by the certified flight instruction (CFI), and the unsuitable terrain encountered by the CFI during the forced landing. An additional cause was the…