NTSB investigations, 2011
9 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\") = 2011
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") = 2011 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 DCA12CA043Accident · No injuriesData collectionFinal reportAirbus Industrie A320 211 · Minneapolis, MNIn-flight collision with birds during initial climb, which resulted in substantial damage to the aircraft.NTSB ENG11IA051Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Denver, CO**This probable cause was modified on 4/5/2012. Please see the public docket for this accident to view the original probable cause.** The initial damage to the fan blades was caused by the ingestion of a Red-Tailed Hawk that caused one or more fan blades to…NTSB WPR11FA450Accident · 1 fatalField investigationFinal reportCone James A RV-6A · West Jordan, UTThe pilot’s execution of an abrupt maneuver, likely to avoid birds, which resulted in a stall and spin.NTSB WPR11CA439Accident · No injuriesData collectionFinal reportCessna 182D · Roundup, MTThe pilot's failure to maintain clearance from an obstacle during the landing flare.NTSB CEN11CA586Accident · Minor injuriesData collectionFinal reportCessna TU206G · Shawno, WIThe pilot's loss of control on final approach, while maneuvering to avoid birds.NTSB CEN11CA501Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Bolivar, MOThe collision with a deer during landing at an airport with known wildlife activity.NTSB WPR11CA299Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Casper, WYAn in-flight collision with a bird at low altitude.NTSB CEN11CA391Accident · No injuriesData collectionFinal reportBeech F33A · Houston, TXAn in-flight collision with a bird during initial climb.NTSB CEN11CA378Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Wagoner, OKThe airplane's collision with a deer during the landing flare and touchdown.