Final NTSB investigations, 2018
13 cases where the sequence of events included Birdstrike.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 14 |
| 2010 | 13 |
| 2011 | 4 |
| 2012 | 7 |
| 2013 | 15 |
| 2014 | 9 |
| 2015 | 6 |
| 2016 | 10 |
| 2017 | 16 |
| 2018 | 13 |
| 2019 | 16 |
| 2020 | 3 |
| 2021 | 13 |
| 2022 | 13 |
| 2023 | 20 |
| 2024 | 18 |
| 2025 | 10 |
| 2026 | 9 |
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\") = 2018
AND c.\"completionStatus\" = 'Completed'
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") = 2018 AND c."completionStatus" = 'Completed' 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 WPR19CA052Accident · No injuriesData collectionFinal reportRobinson R22 · Hayward, CAAn in-flight collision with a bird during low-altitude maneuvering, which resulted in a hard landing.NTSB ERA19LA091Accident · Serious injuriesLimited investigationFinal reportCzech Sport Sportcruiser · Naples, FLCollision with a bird in flight, which resulted in damage to the engine, a fuel leak, and a subsequent total loss of engine power due to fuel exhaustion.NTSB GAA19CA086Accident · No injuriesData collectionFinal reportCessna 182 · Reno, NVThe airplane’s collision with a bird during a practice instrument approach.NTSB GAA19CA054Accident · No injuriesData collectionFinal reportCessna 206 · Boise, IDThe airplane’s impact with a bird during the approach.NTSB GAA18CA541Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Northway, AKThe airplane’s collision with a bird during straight-and-level flight.NTSB GAA18CA475Accident · No injuriesData collectionFinal reportBeech B300 · Wilmington, NCThe airplane’s collision with a bird during approach.NTSB GAA18CA435Accident · No injuriesData collectionFinal reportCessna 560 · Tulsa, OKThe airplane’s collision with a bird during approach.NTSB WPR18FA195Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Deer Park, WAAn in-flight breakup as a result of the airplane exceeding the structural strength of the airplane during a rapid descent that the flight instructor was unable to recover from following a collision with a large bird.NTSB GAA18CA345Accident · No injuriesData collectionFinal reportCessna 172 · Danbury, CTA collision with a bird during initial climb.NTSB GAA18CA357Accident · No injuriesData collectionFinal reportBellanca 7ECA · Fairbanks, AKThe airplane’s collision with a bird while maneuvering.NTSB GAA18CA308Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Cedar Key, FLThe airplane’s collision with multiple birds during initial climb, which damaged the propeller and resulted in a subsequent aerodynamic stall because the airspeed could not be maintained.NTSB GAA18CA162Accident · Minor injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Punta Gorda, FLA collision with a large bird during approach.NTSB GAA18CA128Accident · No injuriesData collectionFinal reportCessna 140 · Keller, TXThe pilot's inability to gain altitude normally in order to avoid a flock of ducks flying overhead during takeoff, which resulted in the airplane striking a fence.