NTSB investigations, IL
104 cases where NTSB found Conditions/weather/phenomena.
Cases per year
| 2008 | 11 |
|---|---|
| 2009 | 4 |
| 2010 | 10 |
| 2011 | 8 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 6 |
| 2015 | 9 |
| 2016 | 8 |
| 2017 | 6 |
| 2018 | 5 |
| 2019 | 5 |
| 2020 | 6 |
| 2021 | 3 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 3 |
| 2025 | 5 |
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 c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0303'))
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' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0303')) 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 DCA26LA047Accident · No injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Chicago, ILUnited Airlines flight crew’s failure to maintain adequate clearance from the parked Envoy Airlines airplane while taxiing in winter weather conditions.NTSB CEN26LA007Accident · Serious injuriesClass 4 · LimitedFinal reportCessna R172 · Mount Carroll, ILThe pilot’s failure to maintain aircraft control during a go around in gusty wind conditions.NTSB CEN25LA397Accident · No injuriesClass 4 · LimitedFinal reportDe Havilland DH82 · Harvard, ILThe pilot’s failure of the pilot to maintain directional control during takeoff which resulted in a collision with cornstalks. Contributing to the accident was the pilot’s partially obscured vision due to sun glare.NTSB CEN25LA283Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Hartsburg, ILThe pilot’s failure to maintain control of the airplane during takeoff with a tailwind from a wet turf airstrip.NTSB CEN25LA238Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Joliet, ILThe pilot’s failure to maintain directional control during the crosswind landing.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 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 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 DCA23LA411Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ170 · Eleroy, ILAn encounter with clear air turbulence.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 DCA23LA305Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Chicago, ILAn encounter with convectively-induced turbulence (CIT).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 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 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 CEN22LA370Accident · Serious injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Highland, ILThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB DCA22LA131Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2012 Traveller · Chicago, ILThe accident airplane encountered jet blast from a departing Boeing 737.NTSB CEN22LA143Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Taylorville, ILThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB CEN22LA120Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Murphysboro, ILThe pilot’s failure to maintain clearance from power lines during approach for landing.NTSB CEN21LA421Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Reynoldsville, ILThe pilot’s failure to maintain clearance from the wire during low altitude operations in windy conditions.NTSB DCA21LA209Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus 319-132 · Chicago, ILAn encounter with clear air turbulence.NTSB CEN21LA185Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot’s failure to maintain directional control during the rejected takeoff with a left quartering crosswind that shifted to a tailwind.NTSB CEN21LA095Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Morris, ILThe pilot's inadequate pedal application during liftoff with a tailwind, which resulted in a loss of yaw control and a subsequent impact with terrain.NTSB CEN21LA058Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Waukegan, ILThe pilot’s failure to maintain directional control during takeoff with a crosswind that resulted in a ground loop and impact with terrain.NTSB CEN20CA405Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Huntley, ILThe pilot’s decision to land at night without runway lighting, which resulted in a collision with an object.NTSB CEN20LA367Accident · 1 fatalClass 3 · LimitedFinal reportCirrus SR22 · Lawrenceville, ILThe pilot’s controlled flight into terrain as a result of his failure to properly execute an instrument approach and maintain clearance from trees in night instrument meteorological conditions. Contributing to the accident was the pilot’s unfamiliarity with a…NTSB DCA20CA122Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer ERJ170 · Plainfield, ILan encounter with convective turbulence.NTSB CEN20CA182Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Chatham, ILThe pilot's decision to continue flight in instrument meteorological conditions in an airplane not equipped for instrument flight, which forced her to perform a precautionary landing to a muddy field resulting in the airplane nosing over.NTSB DCA20LA013Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB145 · Chicago, ILThe flight crew’s inability to maintain the airplane on the runway centerline after touchdown due to the reduced braking action resulting from the deteriorating weather conditions, which caused the airplane’s departure from the runway surface. Contributing to…NTSB DCA19CA208Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD88 · Chicago, ILan encounter with convective turbulence during descent.NTSB CEN19LA216Accident · Minor injuriesClass 3 · LimitedFinal reportRutan Varieze · Kaneville, ILThe pilot's failure to use carburetor heat while operating at low power settings in conditions conducive to the development of carburetor ice, and the subsequent total loss of engine power due to carburetor icing.NTSB GAA19CA149Accident · No injuriesData collectionFinal reportZenair Zenith Stol CH 701 · Springfield, ILThe pilot's improper crosswind correction during taxi operations in gusting crosswind conditions.NTSB GAA19CA145Accident · No injuriesData collectionFinal reportPiper PA32 · Lacon, ILThe pilot's failure to maintain directional control during landing with gusting crosswind conditions, which resulted in a subsequent impact with a snowbank.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 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 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 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 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 GAA18CA069Accident · No injuriesData collectionFinal reportWeaver David A Pulsar 912XP · Plato Center, ILThe pilot’s decision to continue to land without visual reference to the airport in low light conditions. Contributing to the accident was the pilot’s inability to activate the private airport’s pilot-controlled lighting system due to its configuration.NTSB GAA17CA499Accident · No injuriesData collectionFinal reportCessna 170 · Rochelle, ILThe pilot’s failure to maintain directional control during landing with a tailwind.NTSB GAA17CA452Accident · No injuriesData collectionFinal reportPiper PA28 · St. Joseph, ILThe pilot’s improper landing flare, which resulted in the nose landing gear collapsing and subsequent loss of directional control.NTSB GAA17CA461Accident · No injuriesData collectionFinal reportCessna A188B · Kankakee, ILThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent incorrect brake application, which led to the loss of directional control.NTSB CEN17LA223Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX7 77B · Chatsworth, ILThe balloon’s encounter with unexpected wind gusts during inflation, which resulted in the balloon becoming prematurely airborne and subsequently the pilot being ejected from the basket and one passenger receiving serious injuries while attempting to egress…NTSB CEN17LA145Accident · No injuriesLimited investigationFinal reportCessna 120 · Columbia, ILThe partial loss of engine power due to carburetor icing.NTSB CEN17FA064Accident · 4 fatalField investigationFinal reportPiper PA 28R-200 · Vienna, ILThe non-instrument rated pilot's decision to descend through an overcast layer of weather during dark night conditions, which resulted in the airplane impacting trees.NTSB GAA17CA109Accident · No injuriesData collectionFinal reportPiper PA28R · Kewanee, ILThe pilot’s failure to extend the landing gear during the approach to land.NTSB GAA17CA007Accident · No injuriesData collectionFinal reportCessna T182 · Galesburg, ILThe pilot's improper landing flare, which resulted in a bounced, hard landing.NTSB CEN16FA276Accident · 1 fatalField investigationFinal reportPiper PA 30 · Plainfield, ILThe pilot's failure to maintain airplane control during an en route climb near convective activity, which resulted in an aerodynamic stall, an uncontrolled descent, and a subsequent in-flight breakup due to an exceedance of the airplane's design load…NTSB CEN16LA299Accident · No injuriesLimited investigationFinal reportEngineering & Research 415 C · Mt Morris, ILThe pilot's loss of airplane control during a forced landing in gusting crosswind conditions and the airplane’s subsequent bounce on the runway following a loss of engine power. Contributing to the accident was the loss of engine power due to carburetor icing.NTSB GAA16CA296Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Cahokia/St. Louis, ILThe flight instructor's delayed remedial action and his failure to remain vigilant as the helicopter entered the weathercock stability region, in gusting wind conditions, resulting in loss of tail rotor effectiveness and ground impact.