NTSB investigations, 2020
4 cases where the defining event was Birdstrike.
Cases per year
| 2008 | 11 |
|---|---|
| 2009 | 14 |
| 2010 | 14 |
| 2011 | 5 |
| 2012 | 7 |
| 2013 | 15 |
| 2014 | 8 |
| 2015 | 7 |
| 2016 | 11 |
| 2017 | 16 |
| 2018 | 16 |
| 2019 | 15 |
| 2020 | 4 |
| 2021 | 14 |
| 2022 | 16 |
| 2023 | 23 |
| 2024 | 18 |
| 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\") = 2020
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '901')
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") = 2020 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '901') 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 ERA21LA053Accident · 1 fatalClass 3 · LimitedFinal reportBeech V35 · Deltaville, VAAn uncontrolled descent and impact with terrain following an in-flight collision with seagulls.NTSB ERA21LA047Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Greenville, NCThe airplane’s collision with a bird during initial climb, which resulted in a forced landing.NTSB DCA20WA142Accident · No injuriesForeign investigationBoeing 737 · Tokyo, JapanThe JTSB of Japan has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 29, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex 13.All…NTSB WPR20LA256Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · San Jose, CAThe airplane’s collision with a bird while maneuvering in the airport traffic pattern.