NTSB investigations, IL
37 cases where NTSB found Altitude.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 2 |
| 2013 | 4 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 3 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 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\", '01062012'))
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", '01062012')) 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 CEN25LA202Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26C · Hampshire, ILThe pilot’s failure to maintain a proper altitude during the approach, which resulted in overshooting the landing area, a runway excursion, and impact with terrain.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 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 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 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 CEN20LA352Accident · 1 fatalClass 3 · LimitedFinal reportBeech 200 · Rockford, ILThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined based on the available evidence.NTSB CEN20LA168Accident · 1 fatalClass 3 · LimitedFinal reportYakovlev YAK 52 · Palmyra, ILA loss of control during a low-altitude aerobatic maneuver.NTSB GAA19CA481Accident · No injuriesData collectionFinal reportRobinson R66 · Vandalia, ILThe pilot's failure to maintain clearance from power lines during an agricultural application flight.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 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 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 CEN16LA387Accident · Minor injuriesLimited investigationFinal reportPahnke Vernon A Vans RV 9A · Newark, ILThe pilot's failure to properly assemble the fuel pump, which resulted in the loss of fuel pressure and the subsequent partial loss of engine power.NTSB GAA16CA212Accident · No injuriesData collectionFinal reportCessna 140 · Poplar Grove, ILThe pilot's visual disorientation and failure to monitor the altimeter during a night approach, which resulted in controlled flight into terrain.NTSB CEN15FA378Accident · 1 fatalField investigationFinal reportCessna 172 · Martinville, ILThe non-certificated pilot's failure to maintain clearance from terrain.NTSB CEN15FA347Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 5A · Harrisburg, ILThe student pilot's improper decision to conduct a flight in dark, night conditions and his subsequent controlled flight into terrain.NTSB CEN15LA341Accident · Serious injuriesLimited investigationFinal reportHughes 269B · Atkinson, ILThe pilot's improper decision to intentionally fly the helicopter at a low altitude and his subsequent failure to maintain clearance from a power line.NTSB CEN14FA522Accident · 1 fatalField investigationFinal reportCessna T337G · Plano, ILThe pilot’s failure to recognize the airplane’s low altitude and arrest the airplane’s descent on approach to the airport in dark night conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s degraded night…NTSB CEN14LA423Accident · 1 fatalLimited investigationFinal reportBell 47G 5 · Mansfield, ILThe pilot's failure to maintain clearance from power lines during low-altitude flight in gusting wind conditions following his use of a sedating medication.NTSB CEN14LA309Accident · No injuriesLimited investigationFinal reportSchumacher Challenger II · St. Joesph, ILThe total loss of engine power due to a lack of lubrication following the in-flight failure of the mechanical oil injection pump. Contributing to the accident was the temporary obscuration of the pilot's forward visibility due to sun glare during the forced…NTSB CEN14CA017Accident · No injuriesData collectionFinal reportRobinson R22 - Beta · Chicago, ILThe flight instructor's failure to take remedial action in a timely manner.NTSB CEN13FA558Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Bolingbrook, ILThe pilot’s failure to maintain control of the airplane during a go-around.NTSB CEN13LA442Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M74A · Streator, ILThe pilot's diverted attention during an agricultural application maneuver, which resulted in the helicopter impacting a corn field.NTSB CEN13LA447Accident · No injuriesLimited investigationFinal reportBell 206B · Tamaroa, ILThe pilot's failure to maintain clearance from terrain during an agricultural application maneuver.NTSB CEN11FA337Accident · 1 fatalField investigationFinal reportBell OH-58C · New Athens, ILThe pilot’s failure to attain sufficient altitude to clear terrain while maneuvering.NTSB CEN11LA317Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · New Columbia, ILThe pilot's failure to maintain adequate clearance from the wheat crop during takeoff.NTSB CEN10CA411Accident · Minor injuriesData collectionFinal reportContinental Copters Tomcat MK6B · Blackstone, ILThe helicopter encountered a dust devil at a low altitude during the aerial application flight.NTSB CEN10FA108Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Sugar Grove, ILThe pilot's spatial disorientation and subsequent failure to maintain airplane control.NTSB CEN10FA057Accident · 1 fatalField investigationFinal reportCessna 182P · Kewanee, ILThe pilot's decision to initiate a visual night flight without recent night flight experience and his failure to maintain altitude during departure.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 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 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 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 CHI08CA177Accident · No injuriesData collectionFinal reportRobinson R44 II · Ottawa, ILThe pilot's failure to maintain clearance from the power transmission lines. Contributing to the accident was the unmarked power transmission lines.NTSB CHI08CA112Accident · No injuriesData collectionFinal reportPierson RV-6 · Newark, ILThe partial loss of engine power due to the fracture of the number 4 exhaust valve, and the pilot's decision to shut-down the engine without sufficient altitude to ensure a safe glide path to the runway. Contributing to the accident was the barbed wire fence…NTSB CHI08CA081Accident · No injuriesData collectionFinal reportCessna 425 · Cahokia, ILThe pilot not maintaining clearance from the runway sign during taxi for takeoff. A factor contributing to the accident was an icy taxiway.NTSB CHI08CA079Accident · No injuriesData collectionFinal reportCessna 172RG · Litchfield, ILThe pilot's intentional low altitude flight and his failure to maintain clearance from the static wire. Contributing to the accident were the static wire, the partial loss of engine power due to propeller vibration, and the muddy field in which the forced…