NTSB investigations, 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, newest first
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 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 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 CEN09LA488Accident · Serious injuriesLimited investigationFinal reportPiontkowski Challenger · Kankakee, ILThe pilot's failure to maintain clearance from the telephone line and his poor judgment to fly while under the influence of alcohol. Contributing to the accident was the pilot's impairment due to the alcohol consumption.NTSB CEN09CA500Accident · No injuriesData collectionFinal reportCessna P210N · Wheeling, ILThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN09LA466Accident · 1 fatalLimited investigationFinal reportLuscombe 8C · Mount Carmel, ILThe reason for this accident was not determined.NTSB CEN09LA494Accident · No injuriesLimited investigationFinal reportCrisman Flightstar Iisc · Malta, ILThe loss of engine power due to the separation of the flywheel, resulting in a high-cycle fatigue fracture of the crankshaft following takeoff, which resulted in a forced landing on an agricultural field.NTSB CEN09IA456Incident · No injuriesIncident investigationFinal reportCessna 172R · West Chicago, ILA partial loss of engine power due to the detachment of the throttle control cable from the throttle assembly during a landing approach. Contributing to the accident was the lack of a redundant means to preclude the detachment of the cable from the throttle…NTSB CEN09CA448Accident · No injuriesData collectionFinal reportCessna C-182 · Fox Lake, ILThe pilot's inadequate flight planning and continued flight into adverse weather resulting in the collision with the pier during landing.NTSB CEN09LA446Accident · No injuriesLimited investigationFinal reportBeech S35 · Tuscola, ILThe pilot failure to maintain proper speed and distance during approach to land which resulted in landing long and subsequent runway excursion.NTSB CEN09CA439Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · West Chicago, ILThe pilot's failure to extend the landing gear resulting in a wheels-up landing. Contributing to the accident was the pilot being distracted by mowers near the approach end of the runway.NTSB CEN09CA421Accident · No injuriesData collectionFinal reportPitts S-2A · Springfield, ILThe pilot's inability to maintain directional control while landing due to the unintentional obstruction of the rudder by the passenger.NTSB CEN09CA410Accident · No injuriesData collectionFinal reportCessna 150 · Bloomington, ILThe complete loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight.NTSB CEN09IA618Incident · No injuriesIncident investigationFinal reportBell 230 · Peoria, ILThe loss of the number one hydraulic system fluid and hydraulic pressure during cruise due to the failure of the bolts that secure the hydraulic pump's cover.NTSB CEN09LA355Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Cordova, ILThe pilot’s failure to maintain clearance with terrain after clearing an obstacle during an agricultural application pass.NTSB OPS09IA006Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD80 · Chicago, ILThe Chicago TRACON West Arrival controller's omission of a required clearance, resulting in AAL 879 overshooting the final for runway 28 and losing separation with AAL 93.NTSB CEN09CA323Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Mendota, ILThe pilot's inadequate preflight planning and preparation and his failure to perform an aborted takeoff.NTSB CEN09CA303Accident · No injuriesData collectionFinal reportAirborne XT912 · Newark, ILThe pilot's inadequate preflight preparation, which led to the inability to accelerate to takeoff speed after encountering wet and soft runway conditions.NTSB CEN09LA285Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Metropolis, ILA total loss of engine power for undetermined reasons.NTSB CEN09LA265Accident · Serious injuriesLimited investigationFinal reportT Bird T Bird II · Carlock, ILThe pilot's failure to gain sufficient altitude during the takeoff in order to avoid contacting the cameraman. Contributing to the accident was the pilot's lack of experience.NTSB CEN09FA243Accident · 2 fatalField investigationFinal reportEngineering and Research 415C · Sandwich, ILThe pilot's failure to execute an immediate forced landing to a suitable field and the engine's partial loss of power for an undetermined reason.NTSB CEN09IA222Incident · No injuriesIncident investigationFinal reportBell 206 · Springfield, ILThe pilot's failure to maintain clearance from the parked helicopter.NTSB CEN09CA215Accident · Minor injuriesData collectionFinal reportMcCurdy Pro Star PT-2 · Springfield, ILThe pilot's failure to maintain directional control during the landing roll.NTSB CEN09IA172Incident · No injuriesIncident investigationFinal reportCessna 150 · Grayslake, ILThe failure of the number 1 cylinder intake valve which resulted in a partial loss of engine power. Contributing to the incident was the failure of the operator to maintain the engine per manufacturer's recommendations.NTSB CEN09CA139Accident · No injuriesData collectionFinal reportCessna 172I · Rockford, ILThe pilot's inability to maintain directional control during the landing roll after contacting a low-lying snow bank that was obscured by drifting snow.NTSB CEN09FA111Accident · 2 fatalField investigationFinal reportLantzair Flyers Lancair 360 · Joliet, ILThe pilot’s failure to maintain adequate flying speed during the night takeoff for undetermined reasons, which resulted in an inadvertent aerodynamic stall and subsequent loss of controlNTSB CEN09LA114Accident · No injuriesLimited investigationFinal reportBoeing 747-212B · Rockford, ILThe ground crew's failure to maintain clearance from the light pole while directing the airplane to parking.NTSB CEN09FA094Incident · No injuriesField investigationFinal reportBombardier CL-600-2C10 · Chicago, ILThe failure of the left landing gear to extend due to improper maintenance when the landing gear door was replaced. Contributing to the incident was the manufacturer's inadequate maintenance manual instructions.NTSB CEN09CA081Accident · No injuriesData collectionFinal reportCessna A185F · Alton, ILThe pilot's failure to compensate for the crosswind during landing, resulting in loss of control of the aircraft and the subsequent nose-over of the airplane. Contributing to the accident was the crosswind.NTSB CEN09CA089Accident · No injuriesData collectionFinal reportCessna 182 · Gillespie, ILThe pilot's decision to take off with a known obstacle on the runway.NTSB CEN09LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Downers Grove, ILThe pilot's failure to maintain a proper glidepath while on final approach in night conditions, due to his impairment from recent use of alcohol, cocaine, and over-the-counter and prescription medications.NTSB CEN09CA028Accident · No injuriesData collectionFinal reportHoward Super Sky Raider · Tuscola, ILThe pilot failed to maintain directional control during takeoff roll. A contributing factor was the cornfield and the pilot's lack of recent experience.NTSB CEN09MA019Accident · 4 fatalMajor investigationFinal reportBell 222 · Aurora, ILThe pilot's failure to maintain clearance from the 734-foot-tall lighted tower during the visual night flight due to inadequate preflight planning, insufficient altitude, and a flight route too low to clear the tower. Contributing to the accident was the air…NTSB CEN09CA002Accident · No injuriesData collectionFinal reportCessna 172 · Alton, ILThe student pilot's failure to maintain directional control during landing. A contributing factor was the presence of the sign struck during the runway excursion.NTSB ENG08IA042IncidentIncident investigationFinal reportBoeing 737 · Chicago, ILThe right nose landing gear axle's failure from intergranular and fatigue cracking due to an earlier bearing failure.NTSB OPS09IA001Incident · No injuriesIncident investigationFinal reportPeoria, ILThe tower local controller's failure to provide adequate separation between EGF4075 and SKW5961 that landed on intersecting runways.NTSB CHI08IA292Incident · No injuriesIncident investigationFinal reportBoeing 757-223 · Chicago, ILThe failure of an electrical relay due to eroded contacts and the flight crew's decision to continue a flight that was operating on battery power.NTSB CHI08CA283Accident · Minor injuriesData collectionFinal reportMooney M20C · Bolingbrook, ILThe non-mechanical loss of engine power due to the pilot's incorrect positioning of the fuel tank selector prior to takeoff and the subsequent fuel starvation during takeoff.NTSB CHI08CA281Accident · Serious injuriesData collectionFinal reportFirefly Balloons 8B-15 · Springfield, ILThe failure of the passenger to follow the pilot's instructions by not steadying herself during the landing.NTSB CHI08CA276Accident · Minor injuriesData collectionFinal reportCessna 150J · Spring Grove, ILThe pilot's inadequate preflight planning and his failure to maintain clearance from the trees. Contributing factors were the trees and the high density altitude.NTSB CHI08LA273Accident · No injuriesLimited investigationFinal reportBeech C23 · Grayslake, ILThe inadequate flare by the student pilot and the inadequate supervision and delayed go-around performed by the flight instructor. Contributing to the accident were the student pilot's failure to attain/maintain a stabilized approach.NTSB CHI08CA255Accident · No injuriesData collectionFinal reportCessna 182C · Sparta, ILThe pilot's inadequate preflight/planning which resulted in the failure to assure an adequate fuel supply for the flight and the improper flare during the landing. Contributing to the accident was the ditch that the airplane contacted.NTSB CHI08CA247Accident · No injuriesData collectionFinal reportBellanca 17-30A · Waukegan, ILThe pilot's inability to maintain directional control of the airplane following a failure of the right brake.NTSB CHI08CA237Accident · Serious injuriesData collectionFinal reportPowrachute PC 2000 · Goodfield, ILThe insufficient aircraft performance data available to the pilot and the inadequate preflight planning/preparation by the pilot. Contributing to the accident were the trees and density altitude.NTSB CHI08CA234Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Lawrenceville, ILThe pilot's misjudged application of the brakes during landing.NTSB CHI08CA231Accident · No injuriesData collectionFinal reportWeatherly 201B · Creston, ILThe pilot's selection of the unsuitable terrain next to the runway to avoid the landing traffic. Contributing to the accident was the hill in the middle of the runway that blocked the pilot's view of the other traffic and the high vegetation near the runway.NTSB CHI08CA212Accident · No injuriesData collectionFinal reportAyres S2R-T34 · Clinton, ILThe inadequate in-flight planning/decision making and the altitude/clearance not maintained by the pilot during the aerial application. A contributing factor was the guy wire.NTSB OPS08IA011Incident · No injuriesIncident investigationFinal reportLearjet 60 · Chicago, ILThe LC-10 controller's failure to ensure the appropriate separation between two airplanes operating on runways where flight paths intersect.NTSB CHI08FA196Accident · 1 fatalField investigationFinal reportCzech Aircraft Works Sport Cruiser · Newark, ILThe pilot's failure to maintain control of the airplane in the landing pattern. Contributing to the severity of injuries was the failure of the pilot's shoulder harness.NTSB CHI08CA198Accident · No injuriesData collectionFinal reportRockwell S2R · Carthage, ILThe pilot failed to maintain directional control during the takeoff roll. Contributing to the accident were the uneven runway, the runway edge, and the cornfield.NTSB CHI08IA200Incident · No injuriesIncident investigationFinal reportEclipse EA500 · Rockford, ILThe improper installation of the forward edge of the left-hand wing-to-body panel, causing the fairing to separate from the airplane during an in-flight encounter with light turbulence. Contributing to the event was the use of small-head screws and grommets…NTSB CHI08CA193Accident · No injuriesData collectionFinal reportAyres S2R-G6 · Kilbourne, ILThe inadequate preflight planning and preparation and the aborted takeoff not performed by the pilot. Contributing to the accident were the trees and transmission wire.NTSB CHI08CA184Accident · No injuriesData collectionFinal reportHuebner RV6-A · Jerseyville, ILThe muddy, unsuitable terrain encountered during the landing.