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 CHI07FA184Accident · No injuriesField investigationFinal reportBoeing 777-222 · Chicago, ILThe 777-222's flight crew not maintaining clearance from the parked/standing MD 83 and the airport not coordinating the taxi chart instructions with air traffic control. Contributing to the accident was the MD 83's flight crew not following the taxi chart…NTSB CHI07FA182Accident · 2 fatalField investigationFinal reportNorth American Navion · Colona, ILThe non-instrument rated pilot's continued flight into instrument meteorological conditions.NTSB CHI07LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Columbia, ILThe certified flight instructor's (CFI's) inadequate preflight planning/preparation of a test altitude that would afford an on airport landing in the event of engine power loss. Additional causes were the CFI not flying a traffic pattern that would allow for…NTSB CHI07LA170Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Lansing, ILThe loss of engine power during takeoff-initial climb due to a bent exhaust valve and fouled spark plugs.NTSB CHI07CA171Accident · No injuriesData collectionFinal reportLuscombe 8A · Columbia, ILThe pilot's failure to maintain directional control of the airplane, causing a ground loop, subsequent runway excursion, and left main gear collapse. Factors in the accident include the ground loop encountered and the depression.NTSB CHI07CA165Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Manito, ILThe pilot's failure to maintain proper airspeed and his decision to attempt flight over maximum gross weight. A factor to the accident was the stall encountered while attempting to avoid obstacles.NTSB CHI07LA157Accident · 1 fatalLimited investigationFinal reportPurvis Rans S6S · Newark, ILThe pilot's failure to maintain control of the airplane which resulted in inadequate airspeed and a subsequent stall. Contributing to the accident were the pilot's improper installation of the altimeter and airspeed indicator which rendered them inoperative…NTSB CHI07CA153Accident · No injuriesData collectionFinal reportCessna 182S · Harvard, ILThe pilot's misjudged flare and improper recovery from a bounced landing, which caused the nose gear to collapse and subsequent damage to the propellor and underside of the airplane.NTSB CHI07CA128Accident · No injuriesData collectionFinal reportCessna 172P · West Chicago, ILThe instructor's inadequate remedial action following the student pilot's loss of control during the crosswind landing and the instructor's failure to compensate for the wind conditions. Contributing factors were, the crosswind, the gusting wind conditions…NTSB CHI07LA106Accident · Minor injuriesLimited investigationFinal reportBrowns Vans RV-7A · Gardner, ILEngine failure during cruise flight for undetermined reasons. A factor was the rough/uneven terrainNTSB ENG07WA026Incident · No injuriesForeign investigationBoeing B747-400 · Chicago, ILNTSB CHI07LA108Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Wheeling, ILPartial failure of the left engine propeller governor during the takeoff ground roll. Factors included that directional control was not possible by the pilot which subsequently led to a collision with an airport sign.NTSB CHI07CA094Accident · No injuriesData collectionFinal reportMcCall Rotorway 162F · Malta, ILThe pilot's improper use of the rotorcraft flight controls resulting in a dynamic rollover during takeoff. A factor was the soft ground that the left skid encountered.NTSB CHI07LA093Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Chicago, ILThe contained fan blade tip separation following the ingestion of several birds into the left engine during takeoff and the lack of an adequate response time available to crew to avert the bird strike.NTSB CHI07LA080Accident · 1 fatalLimited investigationFinal reportWood Quickie Q-2 · Edwardsville, ILThe loss of engine power during cruise due to loose cylinder head bolts/loose cylinders.NTSB CHI07LA078Accident · Serious injuriesLimited investigationFinal reportBoeing 777 · Chicago, ILAn in-flight encounter with turbulence during cruise flight.NTSB CHI07CA082Accident · No injuriesData collectionFinal reportCessna 172N · Pinckneyville, ILPresence of a deer on the runway resulting in an inadvertent collision during the landing roll.NTSB ENG07IA009Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-36 · Chicago, ILComplete loss of No. 2 engine power due to a partial rim failure of the 2nd stage turbine wheel, resulting in No. 2 engine shutdown and turbine debris exiting the side of the engine. The wheel failure mechanism could not be determined due to missing turbine…NTSB CHI07CA054Accident · No injuriesData collectionFinal reportCessna 172S · Alton, ILThe student pilot's inadequate recovery from a bounced landing, which resulted in the airplane impacting a runway sign. A factor in the accident was the student pilot's misjudged landing flare.NTSB CHI07LA056Accident · No injuriesLimited investigationFinal reportPiper PA-24-260B · Belleville, ILThe failure of the torque link bolt which resulted in the right main landing gear strut scissors separating and becoming jammed in the wheel well. Contributing to the accident was the seized torque link bolt due to surface corrosion.NTSB CHI07LA038Accident · No injuriesLimited investigationFinal reportBeech B36TC · Peoria, ILThe loss of engine power due to a fatigue fracture of the exhaust valve as a result of maintenance not performed by the aircraft owner, and the unsuitable terrain encountered during the forced landing.NTSB CHI07CA075Accident · No injuriesData collectionFinal reportBombardier BD-100-1A10 · Waukegan, ILThe bird strike during initial climb after takeoff from the departure airport.NTSB CHI07LA034Accident · No injuriesLimited investigationFinal reportCessna 172R · Lake in the Hil, ILThe directional control not maintained/obtained by the pilot, and the lack of recent experience by the pilot. The snow bank was a contributing factor.NTSB CHI07CA028Accident · No injuriesData collectionFinal reportCessna 421C · Moline, ILThe incorrect installation of the torque link scissor assembly by maintenance personnel, which resulted in the collapse of the right main landing gear during landing.NTSB CHI07FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Wellington, ILSpatial disorientation experienced by the pilot while attempting to visually locate traffic during cruise flight, which resulted in a loss of aircraft control. Contributing factors were the inadvertent overload failure of the wing spar and stabilator, and the…NTSB CHI07FA020Accident · No injuriesField investigationFinal reportAirbus A-320-200 · Chicago, ILThe pilot-in-command of the other airplane failed to maintain clearance with the parked airplane during taxi for takeoff.NTSB CHI07LA018Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Chester, ILThe fatigue failure of the turbocharger shroud which resulted in oil starvation to the engine. A factor was the muddy field.NTSB CHI07FA009Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Lawrenceville, ILThe improper judgment by the pilot to conduct a flight to, and execute an approach to, an airport with weather conditions that were below the required minimums. Also causal was the pilot's continued descent below the approach minimum descent altitude.…NTSB CHI07IA017Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Sherman, ILThe loose connecting rod bolt due to a loss of torque and subsequent failure of the connecting rod during cruise flight.NTSB CHI06LA263Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Prospect Height, ILThe partial loss of engine power during takeoff due to the flight crews failure to use carburetor heat and the flight instructor's inadequate planning/decision. A factor was the unsuitable terrain for a forced landing.NTSB CHI06CA252Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Hampshire, ILThe pilot's inadequate approach for landing and his failure to attain a proper descent rate.NTSB CHI06FA224Accident · 1 fatalField investigationFinal reportAmerican Legend AL11C · Chicago, ILThe failure of both pilots to assure that the fuel cap was securely in place prior to takeoff which resulted in fuel siphoning and untimately fuel exhaustion. An additional cause was the decision to fly over the lake outside of gliding distance to shore along…NTSB CHI06LA220Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Harmon, ILThe exhaustion of the fuel supply due to the pilot's failure to ensure an adequate suppy of fuel for the flight.NTSB OPS06IA008Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILThe failure of the ORD tower south local controller to monitor Atlas Air flight 6972 on arrival to runway 14R and subsequently clearing United Airlines flight 1015 for takeoff on intersecting runway 27L causing a loss of separation between the two aircraft.NTSB CHI06CA214Accident · No injuriesData collectionFinal reportRobinson R-44 · Wadsworth, ILThe pilot inadvertently pulled back on the cyclic when birds flew into the windscreen. A factor associated with the accident were the birds.NTSB CHI06CA227Accident · No injuriesData collectionFinal reportCessna 172M · Cahokia, ILThe pilot's inadequate flare. A factor was the night light conditions.NTSB CHI06LA178Accident · 1 fatalLimited investigationFinal reportMoon Rans S-14 · Berlin, ILThe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB CHI06CA185Accident · Minor injuriesData collectionFinal reportCessna 172K · Sullivan, ILThe pilot's misjudged flare and his improper recovery from the bounced landing which led to a loss of directional control and subsequent collision with crops and the ground.NTSB CHI06CA177Accident · Minor injuriesData collectionFinal reportCessna T210G · Pontiac, ILA loss of engine power due to the pilot's improper in-flight planning which led to fuel exhaustion and his failure to maintain an adequate airspeed during the landing approach which resulted in an inadvertent stall. The road embankment was a factor.NTSB CHI06GA174Accident · Minor injuriesFinal reportBell UH-1H · Chicago, ILThe in-flight separation of a tail rotor driveshaft hanger bearing due to inadequate maintenance performed by maintenance personnel. Contributing to the accident was the inability to maintain directional control due to the lack of tail rotor thrust.NTSB CHI06CA167Accident · Minor injuriesData collectionFinal reportCessna 170A · Atwood, ILThe loss of engine power during approach due to carburetor ice and the uneven terrain encountered during the forced landing which caused the airplane to nose over. Weather conducive to carburetor icing was a contributing factor.NTSB CHI06FA158Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-83 · Chicago, ILThe jammed nose landing gear due to a failure of the nose landing gear spray deflector for undetermined reasons.NTSB CHI06LA157Accident · 1 fatalLimited investigationFinal reportGood RV-6A · Peru, ILFailure of the pilot of the second airplane in the formation to maintain clearance with the lead airplane during the overhead recovery maneuver prior to landing.NTSB CHI06LA278Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Lawrenceville, ILThe visual separation from the glider attempted by the tow pilot and traffic advisories from the glider not received by the tow pilot. The airport sign/marker was a contributing factor.NTSB CHI06CA136Accident · No injuriesData collectionFinal reportMiller Rutan Long-Ez · Morris, ILThe partial loss of engine power during the final approach to landing for undetermined reasons, and the unsuitable terrain for landing encountered by the pilot. The tall grass was a factor.NTSB CHI06CA129Accident · No injuriesData collectionFinal reportPiper PA-30 · Dongola, ILThe pilot's intentional maneuver to avoid obstructions at the end of the runway which resulted in the airplane impacting a ditch. The wet grass runway and the ditch were factors.NTSB CHI06CA134Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Grayslake, ILThe student pilot's failure to maintain clearance from the parked vehicle during taxi and the flight instructor's inadequate operational oversight. A factor to the accident was the parked vehicle.NTSB CHI06CA126Accident · No injuriesData collectionFinal reportHelmetag Glassair III · Aurora, ILThe pilot's failure to maintain directional control during the takeoff roll. A contributing factor was the airport sign impacted during the runway excursion.NTSB CHI06CA103Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Grayslake, ILThe pilot failed to compensate adequately for the crosswind condition and failed to maintain directional control during the landing roll. Contributing factors included the crosswind, the narrow runway, soft ground, and the ditch.NTSB OPS06IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Chicago, ILThe probable cause of this incident was the ORD tower local controller's failure to provide sufficient separation between two aircraft departing intersecting runways. Contributing to the incident was the ORD local monitor's failure to monitor the situating…