NTSB investigations, TX
26 cases where NTSB found Animal(s)/bird(s).
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 2 |
| 2019 | 3 |
| 2021 | 2 |
| 2023 | 4 |
| 2025 | 2 |
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\" = 'TX' 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" = 'TX' 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 CEN26LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Conroe, TXThe collision with a deer during takeoff.NTSB CEN25LA362Accident · No injuriesClass 4 · LimitedFinal reportCessna 414 · New Braunfels, TXA in-flight collision with a bird during the descent for landing.NTSB CEN24LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Riesel, TXAn in-flight collision with a bird.NTSB CEN23LA379Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Houston, TXAn in-flight collision with a bird.NTSB CEN23LA207Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Fort Worth, TXAn in-flight collision with a bird.NTSB CEN23LA131Accident · No injuriesClass 4 · LimitedFinal reportBeech E-55 · Tomball, TXAn inflight collision with a bird.NTSB CEN22LA057Accident · No injuriesClass 4 · LimitedFinal reportLeonardo AW169 · Austin, TXThe helicopter’s impact with a bird during cruise flight.NTSB CEN21LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150H · Paris, TXThe pilot’s decision to takeoff with known obstacles on the runway and his subsequent failure to avoid the windsock on takeoff.NTSB CEN20CA048Accident · No injuriesData collectionFinal reportVans RV 10 · Granbury, TXThe airplane’s impact with a bird while on approach.NTSB GAA20CA054Accident · Serious injuriesData collectionFinal reportBeech 200 · New Braunfels, TXThe airplane’s in-flight collision with a bird.NTSB GAA19CA400Accident · Minor injuriesData collectionFinal reportBeech 95 · Navasota, TXThe airplane’s impact with a bird.NTSB GAA19CA004Accident · No injuriesData collectionFinal reportCessna 310 · Marathon, TXThe pilot's failure to see and avoid a cow on the airstrip during landing.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.NTSB CEN17LA136Accident · No injuriesLimited investigationFinal reportCessna 550 · Port Aransas, TXAn in-flight collision with multiple birds, which resulted in separation of the right engine's fan rotor and subsequent total loss of power of the right engine.NTSB GAA16CA095Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Fort Worth, TXAn inadvertent collision with a bird while on downwind in the airport pattern.NTSB CEN15CA086Accident · No injuriesData collectionFinal reportWilliams Glenn RV 8A · San Antonio, TXUnintentional collision with a deer at night.NTSB CEN14CA378Accident · Serious injuriesData collectionFinal reportPiper PA 28-140 · Fort Worth, TXThe pilot's improper recovery from a bounced landing. Contributing to the accident was the deer on the runway and the pilot's mismanagement of airspeed which resulted in an aerodynamic stall.NTSB CEN12CA328Accident · No injuriesData collectionFinal reportShiver Tailwind W-10 · Pipe Creek, TXAn inadvertent collision with a deer during takeoff and the airplane’s subsequent departure from the runway and impact with a tree.NTSB CEN11CA391Accident · No injuriesData collectionFinal reportBeech F33A · Houston, TXAn in-flight collision with a bird during initial climb.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 CEN10TA006Accident · No injuriesFinal reportBeech E18S · Jones Creek, TXThe pilot's failure to see and avoid the radio tower.NTSB CEN09IA481Incident · No injuriesIncident investigationFinal reportRaytheon BE-400A · Sugar Land, TXThe failure of the spinner following an unavoidable bird strike. Contributing to the incident were the inadequate engine bird strike certification requirements in place at the time the engine was certified.NTSB CEN09CA365Accident · No injuriesData collectionFinal reportCessna 172RG · Brownwood, TXAn in-flight collision with a large bird while on the downwind leg of a traffic pattern.NTSB DEN08IA143Incident · No injuriesIncident investigationFinal reportRaytheon C90A · Jasper, TXThe impact with a bird during initial takeoff climb.NTSB DEN08LA109Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Von Ormy, TXThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing to the accident were a proper touchdown point was not possible and the inadequate display of the fuel quantity indicator.NTSB DFW08IA073Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Austin, TXThe airplane struck a large bird while making a visual approach to the airport.