NTSB investigations, IL
6 cases where NTSB found Animal(s)/bird(s).
Cases per year
| 2013 | 2 |
|---|---|
| 2015 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 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\", '03022045'))
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", '03022045')) 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 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 CEN22LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Pinckneyville, ILThe airplane’s collision with a deer on the runway during 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 CEN15IA385Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Joliet, ILA bird strike.NTSB CEN13CA495Accident · No injuriesData collectionFinal reportCessna 172 · Kankakee, ILThe airplane struck a deer during takeoff. Contributing to the accident was the perimeter fence being less than FAA's recommended 10 feet high.NTSB CEN13CA169Accident · No injuriesData collectionFinal reportCessna 152 · Murphysboro, ILAn inadvertent encounter with birds while on the downwind leg in the traffic pattern.