NTSB investigations, 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, 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 CEN25LA078Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH750 · Byron, ILThe pilot inadvertently moved the ignition key to the off position and broke the key, which resulted in a loss of engine power and subsequent forced landing.NTSB CEN25LA072Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182H · Harvard, ILThe pilot’s failure to control the airplane during the engine start which resulted in a collision with the hangar.NTSB CEN25FA056Accident · Serious injuriesClass 3 · FieldFinal reportZenith Zodiac CH601 · Columbia, ILThe pilot’s failure to secure the engine oil filter following maintenance, which resulted in oil starvation, a total loss of engine power, and impact with terrain.NTSB CEN25LA032Accident · No injuriesClass 4 · LimitedFinal reportRyan Navion A · Belleville, ILThe pilot’s failure to maintain airplane control during the takeoff.NTSB CEN25LA022Accident · No injuriesClass 4 · LimitedFinal reportMagniflight M24 Orion · Valmeyer, ILThe pilot’s loss of control due to flight control interference by the passenger during takeoff.NTSB DCA24LA318Incident · No injuriesClass 3 · LimitedFinal reportEmbraer ERJ 170-100 LR · Chicago, ILThe flight crew’s misidentification of the intended landing runway, which resulted in an approach to and landing on the wrong runway due to their planned continuation bias. Contributing to the incident was the flight crew’s decision to continue the approach…NTSB CEN24LA351Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Schaumburg, ILThe flight crew’s fuel mismanagement resulting in the loss of engine power due to fuel starvation.NTSB CEN24LA324Accident · No injuriesClass 4 · LimitedFinal reportRans RV8 · Morris, ILThe student pilot’s failure to maintain directional control and the flight instructors delayed remedial action while landing with a gusty crosswind.NTSB CEN24FA312Accident · 1 fatalClass 3 · FieldFinal reportEngineering & Research Ercoupe 415-C · Elkhart, ILAn off-airport landing in a soybean field for reasons that could not be determined. Contributing to the severity of the pilot’s injuries and airplane damage was a fire that occurred at an unknown time.NTSB DCA24WA250OccurrenceClass 5 · ForeignBoeing 737 · Chicago, ILNTSB CEN24LA283Accident · No injuriesClass 4 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Cahokia Heights, ILThe student pilot’s failure to maintain directional control during landing rollout that resulted in a lateral runway excursion and impact with a runway sign.NTSB CEN24LA279Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Rochelle, ILThe pilot’s failure to maintain terrain clearance during a low-level turn, that resulted in an impact with the ground.NTSB CEN24LA276Accident · No injuriesClass 4 · LimitedFinal reportBell 206 · Cornland, ILThe pilot was unable to see a wire due to the setting sun and the helicopter subsequently struck the wire.NTSB CEN24LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Mount Vernon, ILThe pilot’s failure to lower the landing gear, resulting in a wheel up landing. Contributing to the accident was the intermittent warning horn which likely did not sound to warn the pilot about the misconfigured landing gear.NTSB CEN24LA261Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT602 · Decatur, ILThe pilot’s inability to maintain directional control during the landing roll due to the malfunction of the tail wheel locking mechanism.NTSB CEN24LA233Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Murphysboro, ILThe pilot’s failure to maintain directional control during landing.NTSB CEN24LA203Accident · No injuriesClass 3 · LimitedFinal reportPulsar Super Pulsar · Rochelle, ILA partial loss of engine power for undetermined reasons.NTSB CEN24LA174Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · West Chicago, ILThe flight instructor’s failure to maintain control of the airplane during an encounter with wind while holding short of the runway.NTSB CEN24LA026Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Savoy, ILThe pilot’s failure to extend the landing gear before landing and the flight instructor’s inadequate supervision to ensure that the landing gear was extended.NTSB DCA24LA043Incident · No injuriesClass 4 · LimitedFinal reportBoeing 787 · Chicago, ILThe flight crew’s misperception of the distance required to safely pass the hangar and failure to request additional ground handling support while taxiing, which resulted in a collision with a hangar. Contributing to the accident was United Airlines…NTSB CEN24LA013Accident · No injuriesClass 3 · LimitedFinal reportMagni M24 · Mount Sterling, ILThe pilot’s failure to maintain gyroplane control on the downwind leg, which resulted in impact with terrain. Contributing to the accident was the pilot’s distraction.NTSB CEN24LA005Accident · No injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Cahokia Heights, ILThe student pilot’s failure to maintain helicopter control which resulted in impact with the ground.NTSB CEN23LA406Accident · Serious injuriesClass 4 · LimitedFinal reportBeech B200 · Elk Grove Village, ILThe pilot’s improper fuel planning, that resulted in a total loss of engine power due to fuel exhaustion, and a subsequent forced landing. Also causal was the pilot’s decision to go around with minimum fuel.NTSB CEN23LA403Accident · No injuriesClass 3 · LimitedFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Wheeling, ILA loss of braking effectiveness during landing for reasons that could not be determined, which resulted in a runway excursion.NTSB CEN23LA372Accident · No injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Hanover, ILThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall during an attempted forced landing at low altitude. Contributing to the accident was the loss of engine power for undetermined reasons.NTSB DCA23LA411Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ170 · Eleroy, ILAn encounter with clear air turbulence.NTSB CEN23FA359Accident · 1 fatalClass 3 · FieldFinal reportVans RV14 · Virden, ILThe pilot/builder’s improper configuration of the canopy latch micro switch, which incorrectly signaled a closed canopy before flight that resulted in an inflight opening of the airplane’s canopy, an upset of the airplane, and a loss of control from which the…NTSB CEN23LA362Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Harvard, ILThe pilot’s failure to maintain directional control during takeoff that resulted in a runway excursion and an impact with the cornfield.NTSB CEN23LA350Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Carthage, ILA collision with a fence during landing due to the crew’s reduced distance estimation and depth perception while using night vision goggles. Contributing to the accident was the low moon angle, which made viewing the fence more challenging.NTSB CEN23LA341Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Arthur, ILThe pilot’s failure to maintain clearance from trees during a low-level aerial application flight.NTSB CEN23FA340Accident · 1 fatalClass 3 · FieldFinal reportRichards Heavylift Helo UH-1H · Oakdale, ILAn in-flight loss of control for undetermined reasons.NTSB CEN23LA330Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cortland, ILThe pilot’s improper fuel planning, that resulted in a total loss of engine power due to fuel exhaustion, and a subsequent forced landing.NTSB CEN23LA317Accident · No injuriesClass 3 · LimitedFinal reportGrumman G-164A · Patoka, ILA partial loss of engine power due to the failure of two compressor turbine blades as a result of the engine operating near or above the engine’s operating limits for an undetermined amount of time beyond the recommended engine’s TBO limit, which led to…NTSB CEN23LA306Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Pocahontas, ILA reported loss of engine power for undetermined reasons.NTSB CEN23LA295Accident · No injuriesClass 3 · LimitedFinal reportBell UH-1H · Woodlawn, ILThe separation of the tail boom from the fuselage for reasons that could not be determined.NTSB CEN23LA288Accident · No injuriesClass 4 · LimitedFinal reportAirborne XT 582 · Oregon, ILThe pilot’s failure to maintain directional control after a bounced landing.NTSB DCA23LA305Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Chicago, ILAn encounter with convectively-induced turbulence (CIT).NTSB CEN23LA216Accident · No injuriesClass 4 · LimitedFinal reportRemos G-3/600 · Sugar Grove, ILThe student pilot’s improper flight control inputs and the flight instructor’s delayed remedial action during takeoff, which resulted in a runway excursion and impact with terrain.NTSB CEN23LA256Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Romeoville, ILThe student pilot’s failure to attain/maintain a proper landing flare and failure to perform a go-around that resulted in an impact with the runway.NTSB CEN23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32RT · DeKalb, ILThe pilot’s failure to maintain aircraft control during a go-around in gusting winds. Contributing was the presence of windshear.NTSB CEN23LA191Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Genoa, ILThe pilot’s failure to maintain airplane control during a go-around.NTSB CEN23LA218Incident · No injuriesClass 3 · LimitedFinal reportPiper J3C · Romeoville, ILThe inflight failure of the propeller blade due to fatigue cracking from corrosion pits, initiating at the midpoint of the cambered face.NTSB CEN23LA150Accident · Minor injuriesClass 3 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Cahokia, ILThe lack of proper attachment of the cyclic control that resulted in a loss of control during a landing approach and impact with terrain. Contributing to the accident was the improper maintenance performed.NTSB CEN23LA145Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Lincoln, ILA total loss of engine power during an approach for landing for undetermined reasons.NTSB CEN23LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Moline, ILThe student pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB CEN23LA115Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Cahokia, ILThe pilot’s failure to extent the landing gear before landing.NTSB CEN23LA106Accident · No injuriesClass 3 · LimitedFinal reportJabiru USA Sport J250-SP · Cortland, ILA total loss of engine power for reasons that could not be determined.NTSB CEN23LA080Accident · No injuriesClass 4 · LimitedFinal reportBeech G33 · Bolingbrook, ILThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN23FA046Accident · 1 fatalClass 3 · FieldFinal reportExtra EA300 · Wonder Lake, ILThe pilot’s failure to maintain a proper descent path to the runway after he became disorientated by sun glare while on final approach, which resulted in a collision with trees and terrain.NTSB CEN23LA025Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Greenville, ILThe mechanic’s failure to inspect and clean the entire fuel nozzle assembly in accordance with the engine maintenance manual, which resulted in fuel starvation and a partial loss of engine power, an autorotation, and a hard landing.