NTSB investigations, 2018
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\") = 2018
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."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 DCA18WA278Incident · No injuriesForeign investigationAirbus A321-271N · Tapachula, MexicoThe government of Mexico has notified the NTSB of an accident involving a AIRBUS A321-271N airplane that occurred on August 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…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 DCA18WA308Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB DCA18WA154Incident · No injuriesForeign investigationEmbraer S A ERJ170-200LR · MexicoThe government of Mexico has notified the NTSB of an incident involving a EMBRAER S A ERJ170-200LR airplane that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…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.