NTSB investigations, MI
14 cases where the sequence of events included Wildlife encounter (non-bird).
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 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\" = 'MI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '310' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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" = 'MI' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '310' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN26LA320Accident · No injuriesClass 4 · LimitedInvestigation openDiamond Aircraft Ind DA20-C1 · Howell, MINTSB CEN26LA291Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Linden, MIThe collision with a deer during touch-and-go landings.NTSB CEN25LA294Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Stanwood, MIThe collision with a deer during takeoff.NTSB CEN24LA023Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-201T · Mount Pleasant, MIThe airplane’s collision with a deer on the runway during landing.NTSB CEN22LA052Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Marshall, MIThe airplane’s collision with a deer during takeoff.NTSB CEN20LA431Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Big Rapids, MIThe airplane’s impact with a deer during takeoff.NTSB GAA18CA155Accident · No injuriesData collectionFinal reportLearjet 31 · Mount Pleasant, MIThe airplane’s collision with deer during the landing roll.NTSB GAA16CA346Accident · No injuriesData collectionFinal reportCessna 172 · Flushing, MIThe collision with a deer during touchdown of a night landing, which resulted in substantial damage to the horizontal stabilizer and elevator of the airplane.NTSB GAA15CA163Accident · No injuriesData collectionFinal reportGates Learjet 35A · Grosse Ile, MIThe airplane's collision with a deer on the unfenced runway during the takeoff roll. Contributing to the accident is the airport's failure to establish a continuous fence between the runway and the nature conservancy.NTSB CEN15CA013Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Ann Arbor, MIThe collision with a deer during a night takeoff.NTSB CEN14CA026Accident · No injuriesData collectionFinal reportCessna 310R · Onaway, MIAn inadvertent collision with a deer during landing.NTSB CEN12CA419Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Ray Township, MIThe airplane’s collision with a deer that ran in front of the airplane during the landing roll.NTSB CEN11CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Sparta, MIAn inadvertent collision with a deer during a night takeoff.NTSB CHI08CA178Accident · No injuriesData collectionFinal reportMooney M20K · Howell, MIThe collision with a deer during the takeoff roll. Contributing to the accident was the dusk light condition.