NTSB investigations, IL
19 cases where the defining event was Unknown or undetermined.
Cases per year
| 2015 | 2 |
|---|---|
| 2017 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 5 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 2 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '000')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '000') 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 CEN26FA141Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-140 · Rock Falls, ILOn March 20, 2026, about 1503 central daylight time, a Piper PA-28-140 airplane, N9913W, was destroyed when it was involved in an accident near Rock Falls, Illinois. The student pilot sustained fatal injuries. The airplane was being operated as a Title 14…NTSB CEN26FA132Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T210M · Deerfield, ILOn March 4, 2026, about 2145 central standard time, a Cessna T210M airplane, N19FB sustained substantial damage when it was involved in an accident near Deerfield, Illinois. The pilot was fatally injured. The airplane was operated under Title 14 Code of…NTSB CEN25LA116Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Chicago, ILOn March 10, 2025, about 18:30 central daylight time, a Robinson Helicopter R44 II, N128AF was substantially damaged when it was involved in an accident near Chicago, Illinois. The pilot and both passengers were not injured. The helicopter was operated under…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 CEN24LA203Accident · No injuriesClass 3 · LimitedFinal reportPulsar Super Pulsar · Rochelle, ILA partial loss of engine power for undetermined reasons.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 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 CEN23LA145Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Lincoln, ILA total loss of engine power during an approach for landing for undetermined reasons.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 CEN22LA361Accident · No injuriesClass 3 · LimitedFinal reportVans RV-10 · Hurst, ILA loss of engine power for reasons that could not be determined.NTSB CEN22LA323Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Verona, ILA loss of rotor rpm for reasons that could not be determined.NTSB CEN21LA369Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Wheeling, ILA partial loss of engine power for reasons that could not be determined based on available information.NTSB CEN21LA100Accident · Serious injuriesClass 3 · LimitedFinal reportWalton Daniel J Sonex · Pecatonica, ILA total loss of engine power for reasons that could not be determined based on the available information, and the pilot’s exceedance of the airplane’s critical angle of attack following the loss of engine power, which resulted in an aerodynamic stall/spin and…NTSB CEN21FA024Accident · 1 fatalClass 3 · FieldFinal reportGlasair III · Ford Heights, ILThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN20LA342Accident · Minor injuriesClass 3 · LimitedFinal reportSiebel Auriga · Rockford, ILThe total loss of engine power for reasons that could not be determined based on available information.NTSB CEN17CA140Accident · No injuriesData collectionFinal reportCessna 172R · Cahokia, ILA hard landing for reasons that could not be determined based on the available evidence.NTSB CEN15FA289Accident · 1 fatalField investigationFinal reportCessna 172P · Bartlett, ILThe pilot’s loss of airplane control for reasons that could not be determined because an examination of the airplane did not reveal any preimpact abnormalities.NTSB GAA15CA161Accident · No injuriesData collectionFinal reportCessna 172S · Galesburg, ILFirewall damage reported by maintenance personnel that occurred during an unknown phase of flight, because the accident flight and pilot could not be determined.