NTSB investigations, 2024
19 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\") = 2024
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") = 2024 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 ERA25LA027Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Canal Winchester, OHAn in-flight collision with a bird while in cruise flight.NTSB ERA25LA026Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sebring, FLA birdstrike during descent to the destination airport.NTSB CEN24LA372Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Eden Prairie, MNThe bird strike during cruise flight that resulted in substantial damage to the airplane.NTSB WPR24LA305Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20F · Cottonwood, AZThe pilot’s evasive maneuver to avoid birds while on final approach at a low altitude, which resulted in the airplane colliding with a tree.NTSB CEN24LA267Accident · No injuriesClass 4 · LimitedFinal reportCovington Edward L SHA-GLASAIR · Saint James, MNAn in-flight bird strike which resulted in an engine compartment fire that ultimately destroyed the airplane.NTSB ANC24LA066Accident · No injuriesClass 4 · LimitedFinal reportCurtiss Wright C-46R · Kenai, AKAn in-flight collision with birds during takeoff.NTSB ERA24LA306Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Cochran, GAThe airplane’s impact with a bird resulting in substantial damage to the right wing.NTSB ERA24LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Clearwater, FLAn in-flight collision with a bird while flying in the airport traffic pattern.NTSB ERA24LA273Accident · No injuriesClass 4 · LimitedFinal reportConstruzioni Aeronautiche Tecn P2004 Bravo · Laurens, SCAn in-flight collision with a bird while in cruise flight.NTSB CEN24LA229Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander S2R · White, SDA low-level collision and engine ingestion with ducks, which resulted in a total loss of engine power, a forced landing, and a subsequent nose over.NTSB ERA24LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Vero Beach, FLAn in-flight collision with a bird while on approach.NTSB GAA24WA165Accident · 1 fatalClass 5 · ForeignExtra EA-330SC · Alcázar de San Juan, SpainNTSB CEN24LA153Accident · No injuriesClass 4 · LimitedFinal reportBeech B300 · Oklahoma City, OKAn in-flight collision with a bird during the initial climb.NTSB CEN24LA143Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Moran, KSAn in-flight collision with birds while in cruise flight.NTSB ERA24LA173Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pembroke Pines, FLAn inflight collision with a bird while approaching the destination airport.NTSB CEN24LA129Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · Fort Morgan, COAn inflight collision with birds while on approach.NTSB ERA24LA137Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Leesburg, VAAn in-flight collision with a bird while on the downwind leg of the airport traffic pattern.NTSB ERA24LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Smyrna, TNAn in-flight collision with a bird during initial climb.NTSB CEN24FA094Accident · 3 fatalClass 3 · FieldFinal reportBell 206 · Hydro, OKThe helicopter’s inflight collision with cackling geese, resulting in an inflight breakup.