NTSB investigations, MI
20 cases where NTSB found Animal(s)/bird(s).
Cases per year
| 2008 | 2 |
|---|---|
| 2010 | 2 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2018 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2025 | 1 |
| 2026 | 1 |
Where
Latest 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 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" = 'MI' 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 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 CEN18LA365Accident · Serious injuriesLimited investigationFinal reportMD Helicopters MD-369 · Orchard Lake, MIThe pilot's failure to maintain helicopter control and terrain clearance while in a hover after performing an evasive maneuver to avoid wildlife.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 GAA16CA196Accident · Minor injuriesData collectionFinal reportCessna 182 · Moorestown, MIAn in-flight bird strike, which resulted in wind screen damage.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 CEN14LA262Accident · No injuriesLimited investigationFinal reportEmbraer EMB 135KL · Traverse City, MIAn in-flight collision with a bird during the descent to land, which resulted in substantial damage to the airplane.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 CEN12CA305Accident · No injuriesData collectionFinal reportCessna A185F · Crystal Falls, MIThe pilot's abrupt maneuver to avoid deer that unexpectedly ran into the airplane's path during the landing roll.NTSB CEN12CA270Accident · No injuriesData collectionFinal reportCessna 172M · Three Rivers, MICollision with a deer during the takeoff roll.NTSB CEN11CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Sparta, MIAn inadvertent collision with a deer during a night takeoff.NTSB CEN10CA209Accident · No injuriesData collectionFinal reportTrue Flight Holdings AA-5B · Muskegon, MIThe inadvertent in-flight collision with a goose.NTSB CHI08CA263Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Greenville, MIThe deer that ran onto the runway contacting the airplane. A factor associated with the accident was the dark night conditions.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.