NTSB investigations, IL
124 cases where NTSB found Physical environment.
Cases per year
| 2008 | 25 |
|---|---|
| 2009 | 10 |
| 2010 | 9 |
| 2011 | 6 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 7 |
| 2015 | 6 |
| 2016 | 6 |
| 2017 | 8 |
| 2018 | 9 |
| 2019 | 6 |
| 2020 | 8 |
| 2021 | 2 |
| 2022 | 8 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 1 |
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\", '0302'))
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", '0302')) 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 CEN26LA083Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Round Lake Park, ILThe student pilot’s failure to maintain directional control during a soft-field takeoff and the flight instructor’s delayed remedial action.NTSB CEN26LA074Accident · Minor injuriesClass 3 · LimitedFinal reportPitts S1S · Carbondale, ILA loss of engine power due to fuel starvation resulting from an uncommanded change to the fuel servo mixture position due to the improperly installed mixture cable.NTSB CEN25LA353Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Pittsfield, ILThe collision with a deer during the aborted landing in night visual meteorological conditions.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 CEN25LA266Accident · Minor injuriesClass 4 · LimitedFinal reportBell B206-B · Bloomington, ILThe pilot’s failure to avoid power lines during an aerial application flight.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 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 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 CEN23LA002Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Danville, ILThe pilot decision to perform a precautionary landing to a field with obstacles which resulted in a ground loop. Contributing was the pilot’s inadequate fuel planning.NTSB DCA22LA201Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Chicago, ILSouthwest Airlines flight crew’s misjudgment of the distance required to safely pass the American Airlines airplane.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 CEN22LA328Accident · No injuriesClass 4 · LimitedFinal reportEurocopter Deutschland EC 135 · Mount Vernon, ILThe inadequate securement of the cloth fire extinguisher cover, which resulted in it being blown off the fire extinguisher and ingested into the helicopter’s fenestron during the landing.NTSB CEN22LA329Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Saint Joseph, ILThe pilot’s failure to remain clear of obstacles while landing.NTSB CEN22LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Pinckneyville, ILThe airplane’s collision with a deer on the runway during landing.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 CEN21LA189Accident · No injuriesClass 4 · LimitedFinal reportBeech P35 · Poplar Grove, ILThe pilot's distraction and his failure to maintain a proper glidepath on the approach, which resulted in him landing short of the runway and impacting a snowbank.NTSB CEN20CA406Accident · Minor injuriesClass 4 · Data collectionFinal reportPik PIK-20D · Union, ILThe pilot’s failure to maintain directional control during takeoff that resulted in a collision with another glider that was parked close to the departure runway, and the pilot’s improper decision to attempt a takeoff without ensuring he had safe clearance…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 CEN20LA403Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Palatine, ILThe loss of partial engine power due to fuel starvation during departure which resulted in a forced landing and collision with a utility pole.NTSB CEN20CA313Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Dakota, ILThe pilot’s failure to maintain main rotor clearance from a ground obstacle during a landing.NTSB CEN20CA308Accident · Serious injuriesClass 4 · Data collectionFinal reportMaule MXT7 · Hillsboro, ILThe pilot's exceedance of the airplane's critical angle of attack while attempting to avoid a deer during landing, resulting in an aerodynamic stall.NTSB CEN20CA302Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA28 · Grayslake, ILThe pilot’s application of the left brake during landing resulting in a runway excursion.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 CEN20CA181Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 172 · Colchester, ILThe pilot's inadequate preflight of the fuel quantity which resulted in a loss of engine power due to fuel starvation during cruise flight.NTSB GAA19CA481Accident · No injuriesData collectionFinal reportRobinson R66 · Vandalia, ILThe pilot's failure to maintain clearance from power lines during an agricultural application flight.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 GAA19CA279Accident · No injuriesData collectionFinal reportGuimbal Cabri · St. Louis, ILThe flight instructor's improper emergency procedure instruction to the student pilot, which resulted in the student improperly using the throttle to correct the loss of yaw control, which resulted in ground impact and a dynamic rollover.NTSB GAA19CA278Accident · Minor injuriesData collectionFinal reportBell 206 · Pittsfield, ILThe pilot's failure to maintain clearance from rising terrain during agricultural application operations.NTSB CEN19LA142Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA44 · Centralia, ILThe failure of the nose landing gear to extend for reasons that could not be determined based on the available information.NTSB CEN19LA123Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R66 · St Jacob, ILThe pilot's in-flight collision with an unmarked wire during an aerial application flight; the wire lacked contrast with the surrounding environment.NTSB CEN18LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Columbia, ILThe airplane's inability to climb due to reduced engine power as a result of insufficient compression in all cylinders and fouled spark plugs in the No. 2 cylinder while operating near its maximum gross weight.NTSB GAA18CA588Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe student pilot's failure to maintain clearance from a truck while taxiing.NTSB GAA18CA421Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, ILThe pilot’s improper preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.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 GAA18CA409Accident · No injuriesData collectionFinal reportCessna 208 · Chicago, ILThe service truck driver’s evasive maneuver to avoid a bag cart tug, which resulted in the truck impacting a parked airplane.NTSB GAA18CA360Accident · No injuriesData collectionFinal reportCessna 172 · Salem, ILThe student pilot’s failure to maintain clearance from a pole while taxiing the airplane on the ramp.NTSB GAA18CA305Accident · Minor injuriesData collectionFinal reportZS Delta-Bielsko Wroclaw SZD 36 A Cobra 15 · Hammond, ILThe pilot’s loss of directional control during an off-airport landing and his subsequent failure to maintain clearance from power pole guy wires.NTSB CEN18LA205Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Union, ILThe pilot’s medical impairment at the time of the accident, which resulted in a collision with power lines off the end of the runway.NTSB CEN18LA082Accident · Serious injuriesLimited investigationFinal reportMatheny Larry E Christavia MK 1 · Grand Detour, ILThe pilot's failure to see and avoid the power line. Contributing to the accident was the pilot’s intentional flight at low altitude.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 GAA18CA012Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB BK 117 · Canton, ILThe flight instructor's incorrect cyclic control during a hover, which resulted in a hard landing.NTSB GAA17CA566Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Hampshire, ILThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.NTSB GAA17CA450Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Dunlap, ILThe pilot’s failure to visually confirm that the helicopter was disconnected from hoses during refueling operations. Contributing to the accident was the pilot’s and ground crew’s misunderstanding of the hand signals.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 GAA17CA398Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Pocahontas, ILThe helicopter pilot’s miscommunication with the ground crewmember during reloading operations, which resulted in a takeoff with the filler hose attached to the helicopter and subsequent impact with a truck.NTSB GAA17CA265Accident · No injuriesData collectionFinal reportRotorcraft Development OH-58A+ · Waterloo, ILThe pilot’s failure to see and avoid transmission wires while maneuvering at a low altitude.NTSB CEN17LA145Accident · No injuriesLimited investigationFinal reportCessna 120 · Columbia, ILThe partial loss of engine power due to carburetor icing.