NTSB investigations, 2016
19 cases where NTSB found Animal(s)/bird(s).
Cases per year
| 2008 | 21 |
|---|---|
| 2009 | 18 |
| 2010 | 21 |
| 2011 | 9 |
| 2012 | 20 |
| 2013 | 22 |
| 2014 | 15 |
| 2015 | 11 |
| 2016 | 19 |
| 2017 | 26 |
| 2018 | 22 |
| 2019 | 24 |
| 2020 | 9 |
| 2021 | 19 |
| 2022 | 21 |
| 2023 | 24 |
| 2024 | 27 |
| 2025 | 19 |
| 2026 | 12 |
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 year(c.\"eventDate\") = 2016
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 year(c."eventDate") = 2016 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 CEN17LA136Accident · No injuriesLimited investigationFinal reportCessna 550 · Port Aransas, TXAn in-flight collision with multiple birds, which resulted in separation of the right engine's fan rotor and subsequent total loss of power of the right engine.NTSB GAA17CA079Accident · No injuriesData collectionFinal reportCessna 172 · Dayton, TNThe student pilot’s inability to maintain pitch and bank control during the landing after the airplane was struck by a deer.NTSB GAA17CA086Accident · Minor injuriesData collectionFinal reportBeech A36 · Ft. Myers, FLAn in-flight collision with a flock of birds.NTSB GAA17CA060Accident · No injuriesData collectionFinal reportCessna 172 · Englewood, COAn in-flight collision with multiple birds.NTSB GAA17CA074Accident · No injuriesData collectionFinal reportRaytheon 58 · Lancaster, PAA collision with deer on the runway during the takeoff roll.NTSB ANC16CA051Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Homer, AKAn in-flight collision with a bird resulting in damage to a tail rotor blade, which required replacement.NTSB GAA16CA396Accident · Minor injuriesData collectionFinal reportCessna 150 · Williamsburg, VAAn evasive maneuver during the landing flare to avoid deer on the runway, which resulted in a collision with trees and terrain during a go-around. Contributing to the accident was the lack of an airport perimeter fence.NTSB GAA16CA369Accident · No injuriesData collectionFinal reportStinson 108 · Red Lodge, MTA deer running across the runway and impacting the left side of the airplane, resulting in a loss of directional control, a runway excursion, and a ground loop.NTSB ERA16LA242Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Laurel, DEA total loss of engine power due to an encounter with a bird, which collided with the spray pump fan assembly and subsequently sent blade fragments into the engine compartment, damaging the throttle linkage.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 ANC16LA034Accident · No injuriesLimited investigationFinal reportDe Havilland DHC3 · Homer, AKAn in-flight collision with a bald eagle, which resulted in substantial damage to the left wing.NTSB GAA16CA304Accident · No injuriesData collectionFinal reportCessna 120 · Climax, NCAn evasive maneuver during the landing roll to avoid deer on the runway, which resulted in a runway excursion and a nose over. Contributing to the accident was the lack of an airport perimeter fence.NTSB GAA16CA314Accident · No injuriesData collectionFinal reportPiper PA 32 · Lincoln Park, NJThe airplane struck a deer during the landing flare resulting in substantial damage.NTSB GAA16CA230Accident · Minor injuriesData collectionFinal reportGrenier Raymond Vans Aircraft · Keene, NHThe airplane striking a deer during the landing roll, resulting in a loss of directional control, runway excursion, and subsequent nose over.NTSB ANC16FA019Accident · 4 fatalField investigationFinal reportCessna 172 · Chugiak, AKThe in-flight collision with one or more large birds (Bald Eagle), which resulted in a loss of airplane control.NTSB GAA16CA196Accident · Minor injuriesData collectionFinal reportCessna 182 · Moorestown, MIAn in-flight bird strike, which resulted in wind screen damage.NTSB GAA16CA126Accident · No injuriesData collectionFinal reportPiper PA31 · Newport, RIAn inadvertent collision with birds during final approach at night.NTSB GAA16CA129Accident · No injuriesData collectionFinal reportPilatus PC12 · Lawrenceville, GAAn unintentional collision with a white-tailed deer during the takeoff roll in night visual conditions.NTSB GAA16CA101Accident · No injuriesData collectionFinal reportCessna 182 · Baton Rouge, LAAn inadvertent collision with a bird while maneuvering during an aerial observation flight.