Final NTSB investigations, 2010
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\") = 2010
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") = 2010 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 CEN11LA072Accident · No injuriesLimited investigationFinal reportEmbraer ERJ 170-200 LR · Minneapolis, MNThe in-flight collision with a flock of birds during climb.NTSB WPR11LA042Accident · No injuriesLimited investigationFinal reportBombardier DHC-8-402 · Los Angeles, CAAn in-flight collision with a bird.NTSB CEN11TA027Accident · No injuriesFinal reportBeech A100 · Palestine, TXAn in-flight collision with a flock of birds while the airplane was descending through a cloud layer.NTSB ERA11CA012Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLAn inadvertent in-flight collision with a bird.NTSB WPR10CA434Accident · Minor injuriesData collectionFinal reportPiper PA-15 · Duvall, WAAn in-flight collision with a bird while maneuvering.NTSB ANC10CA078Accident · No injuriesData collectionFinal reportCessna U206F · Aleknagik, AKA bird strike which penetrated the airplane's windscreen.NTSB WPR10LA395Accident · No injuriesLimited investigationFinal reportEmbraer EMB-145XR · Salt Lake City, UTAn in-flight collision with a bird while on the downwind leg of the traffic pattern during a visual approach.NTSB ANC10CA031Accident · Minor injuriesData collectionFinal reportPiper PA-31-350 · Eek, AKAn in-flight collisions with two Cackling Geese (Branta Hutchinsii).NTSB CEN10CA209Accident · No injuriesData collectionFinal reportTrue Flight Holdings AA-5B · Muskegon, MIThe inadvertent in-flight collision with a goose.NTSB CEN10CA202Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Middlefield, OHThe inadvertent in-flight collision with a bird.NTSB CEN10TA194Accident · Serious injuriesFinal reportBeech 95-B55 · Center, NDThe inadvertent in-flight collision with several Mallard ducks.NTSB WPR10CA157Accident · No injuriesData collectionFinal reportPiper PA-28-161 · El Cajon, CAAn in-flight collision with a bird in the downwind leg of the airport's traffic pattern.NTSB WPR10LA141Accident · No injuriesLimited investigationFinal reportCessna 208B · Sacramento, CAAn in-flight collision with a bird while on final approach.