NTSB investigations, PA
9 cases where NTSB found Animal(s)/bird(s).
Cases per year
| 2008 | 1 |
|---|---|
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2022 | 2 |
| 2025 | 1 |
| 2026 | 1 |
Where
Latest 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 c.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022045'))
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 c."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03022045')) 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 ERA26LA293Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Carlisle, PAA collision with a deer during landing.NTSB ERA25LA375Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Punxsutawney, PAThe airplane’s collision with a deer on a runway during landing roll.NTSB ERA22LA403Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Toughkenamon, PAThe airplane’s impact with a bird while entering the traffic pattern.NTSB ERA22LA208Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24 · Honesdale, PAThe pilot’s failure to maintain clearance with the edge of the asphalt, which resulted in a runway excursion. Contributing to the accident was the pilot’s distraction due to a goose.NTSB GAA17CA074Accident · No injuriesData collectionFinal reportRaytheon 58 · Lancaster, PAA collision with deer on the runway during the takeoff roll.NTSB DCA14CA147Accident · No injuriesData collectionFinal reportDehavilland DHC 8 102 · Harrisburg, PAthe airplanes collision with geese during the takeoff roll.NTSB DCA14CA031Accident · No injuriesData collectionFinal reportDe Havilland DHC8 - 102 · Philadelphia, PAan inadvertent encounter with several birds during approach that resulted in substantial damage to the airplane.NTSB ERA12LA557Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Washington, PAThe airplane’s encounter with a flock of geese during takeoff, which resulted in the airplane’s hard impact with the runway while the pilot maneuvered in an attempt to avoid the geese.NTSB MIA08CA198Accident · No injuriesData collectionFinal reportMooney M20S · New Castle, PAThe on-ground collision with a deer during the takeoff roll. A contributing factor in the accident was the failure to completely secure the airport perimeter.