NTSB investigations, 2019
16 cases where the sequence of events included Birdstrike.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 14 |
| 2010 | 14 |
| 2011 | 5 |
| 2012 | 8 |
| 2013 | 16 |
| 2014 | 10 |
| 2015 | 7 |
| 2016 | 12 |
| 2017 | 18 |
| 2018 | 16 |
| 2019 | 16 |
| 2020 | 4 |
| 2021 | 14 |
| 2022 | 16 |
| 2023 | 22 |
| 2024 | 19 |
| 2025 | 13 |
| 2026 | 19 |
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\") = 2019
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '901' 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 year(c."eventDate") = 2019 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '901' 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 CEN20CA048Accident · No injuriesData collectionFinal reportVans RV 10 · Granbury, TXThe airplane’s impact with a bird while on approach.NTSB DCA20CA050Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · Kansas City, MOa bird strike during descentNTSB ERA20CA058Accident · Minor injuriesData collectionFinal reportCessna P210 · Gainesville, FLThe airplane's impact by a bird during the initial climb.NTSB GAA20CA054Accident · Serious injuriesData collectionFinal reportBeech 200 · New Braunfels, TXThe airplane’s in-flight collision with a bird.NTSB DCA20CA010Accident · No injuriesData collectionFinal reportDe Havilland DHC8 · Boise, IDa bird strike during climb out.NTSB GAA20CA038Accident · No injuriesData collectionFinal reportPiper PA28 · Wedgefield, FLAn in-flight collision with a bird.NTSB GAA19CA557Accident · No injuriesData collectionFinal reportBeech 35 · Fort Myers, FLThe airplane’s impact with a bird during approach.NTSB GAA19CA451Accident · No injuriesData collectionFinal reportCessna 402 · St. Louis, MOThe airplane’s collision with a bird during short final.NTSB GAA19CA467Accident · No injuriesData collectionFinal reportCessna 525 · Orlando, FLThe airplane’s impact with a bird during approach.NTSB GAA19CA400Accident · Minor injuriesData collectionFinal reportBeech 95 · Navasota, TXThe airplane’s impact with a bird.NTSB ERA19FA170Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 30 · Naples, FLIncapacitation of the pilot due to a birdstrike through the windshield in front of the pilot's position, while on approach to land.NTSB WPR19FA124Accident · 2 fatalClass 3 · FieldFinal reportVans RV 6 · Ridgefield, WAThe pilots' inadvertent exceedance of the airplane's critical angle of attack following an inflight collision with a bird.NTSB GAA19CA268Accident · No injuriesData collectionFinal reportPiper PA32 · SaipanThe airplane’s collision with a bird during the initial climb, which resulted in the engine cowling separating and impacting the empennage.NTSB DCA19CA130Accident · No injuriesData collectionFinal reportBoeing 737 · Nashville, TNa collision with a bird.NTSB GAA19CA180Accident · No injuriesData collectionFinal reportPiper PA23 · Tampa, FLAn in-flight collision with a bird during the approach, which resulted in damage to the vertical stabilizer.NTSB GAA19CA168Accident · No injuriesData collectionFinal reportHughes TH 55 · Keene, NHThe helicopter’s collision with a bird during cruise flight.