NTSB investigations
359 cases where NTSB found Animal(s)/bird(s).
Cases, newest first
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.\"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."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 GAA17CA162Accident · No injuriesData collectionFinal reportCessna T337 · Linden, NJThe pilot’s abrupt maneuver to avoid birds during short final approach, which resulted in a hard, bounced landing.NTSB GAA17CA161Accident · No injuriesData collectionFinal reportPiper PA 28R · Phoenix, AZAn in-flight collision with a bird.NTSB DCA17CA064Accident · No injuriesData collectionFinal reportBombardier CL 600 2C10 · Charlotte, NCcollision with a deer during takeoff.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 GAA17CA079Accident · No injuriesData collectionFinal reportCessna 172 · Dayton, TNThe student pilot’s inability to maintain pitch and bank control during the landing after the airplane was struck by a deer.NTSB GAA17CA086Accident · Minor injuriesData collectionFinal reportBeech A36 · Ft. Myers, FLAn in-flight collision with a flock of birds.NTSB GAA17CA060Accident · No injuriesData collectionFinal reportCessna 172 · Englewood, COAn in-flight collision with multiple birds.NTSB GAA17CA074Accident · No injuriesData collectionFinal reportRaytheon 58 · Lancaster, PAA collision with deer on the runway during the takeoff roll.NTSB ANC16CA051Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Homer, AKAn in-flight collision with a bird resulting in damage to a tail rotor blade, which required replacement.NTSB GAA16CA396Accident · Minor injuriesData collectionFinal reportCessna 150 · Williamsburg, VAAn evasive maneuver during the landing flare to avoid deer on the runway, which resulted in a collision with trees and terrain during a go-around. Contributing to the accident was the lack of an airport perimeter fence.NTSB GAA16CA369Accident · No injuriesData collectionFinal reportStinson 108 · Red Lodge, MTA deer running across the runway and impacting the left side of the airplane, resulting in a loss of directional control, a runway excursion, and a ground loop.NTSB ERA16LA242Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Laurel, DEA total loss of engine power due to an encounter with a bird, which collided with the spray pump fan assembly and subsequently sent blade fragments into the engine compartment, damaging the throttle linkage.NTSB GAA16CA346Accident · No injuriesData collectionFinal reportCessna 172 · Flushing, MIThe collision with a deer during touchdown of a night landing, which resulted in substantial damage to the horizontal stabilizer and elevator of the airplane.NTSB ANC16LA034Accident · No injuriesLimited investigationFinal reportDe Havilland DHC3 · Homer, AKAn in-flight collision with a bald eagle, which resulted in substantial damage to the left wing.NTSB GAA16CA304Accident · No injuriesData collectionFinal reportCessna 120 · Climax, NCAn evasive maneuver during the landing roll to avoid deer on the runway, which resulted in a runway excursion and a nose over. Contributing to the accident was the lack of an airport perimeter fence.NTSB GAA16CA314Accident · No injuriesData collectionFinal reportPiper PA 32 · Lincoln Park, NJThe airplane struck a deer during the landing flare resulting in substantial damage.NTSB GAA16CA230Accident · Minor injuriesData collectionFinal reportGrenier Raymond Vans Aircraft · Keene, NHThe airplane striking a deer during the landing roll, resulting in a loss of directional control, runway excursion, and subsequent nose over.NTSB ANC16FA019Accident · 4 fatalField investigationFinal reportCessna 172 · Chugiak, AKThe in-flight collision with one or more large birds (Bald Eagle), which resulted in a loss of airplane control.NTSB GAA16CA196Accident · Minor injuriesData collectionFinal reportCessna 182 · Moorestown, MIAn in-flight bird strike, which resulted in wind screen damage.NTSB GAA16CA126Accident · No injuriesData collectionFinal reportPiper PA31 · Newport, RIAn inadvertent collision with birds during final approach at night.NTSB GAA16CA129Accident · No injuriesData collectionFinal reportPilatus PC12 · Lawrenceville, GAAn unintentional collision with a white-tailed deer during the takeoff roll in night visual conditions.NTSB GAA16CA101Accident · No injuriesData collectionFinal reportCessna 182 · Baton Rouge, LAAn inadvertent collision with a bird while maneuvering during an aerial observation flight.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 GAA16CA044Accident · No injuriesData collectionFinal reportCessna 172G · Newfane, NYAn evasive maneuver during landing to avoid deer on the runway, which resulted in a runway overrun and collision with trees.NTSB GAA16CA078Accident · No injuriesData collectionFinal reportCessna 525 · Monroeville, ALAn inadvertent collision with a bird during takeoff enroute climb, which resulted in substantial damage to the right wing.NTSB GAA15CA278Accident · No injuriesData collectionFinal reportCessna 182A · Ama, LAThe pilot's decision to takeoff on a partially obstructed runway, which resulted in a collision with trees.NTSB CEN15IA385Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Joliet, ILA bird strike.NTSB GAA15CA218Accident · No injuriesData collectionFinal reportCessna 170A · East Haddam, CTThe pilot's failure to maintain directional control during the landing roll, and excessive use of brakes, which resulted in a runway excursion and nose over.NTSB GAA15CA220Accident · No injuriesData collectionFinal reportCessna 150M · Apopka, FLFollowing a bird strike during takeoff, the pilot's decision to land without sufficient runway remaining to safely stop the airplane, which resulted in an over-run, collision with terrain, and nose over.NTSB GAA15CA241Accident · No injuriesData collectionFinal reportCessna 172 · Upperville, VAAn inflight bird strike, which resulted in wing spar damage.NTSB GAA15CA163Accident · No injuriesData collectionFinal reportGates Learjet 35A · Grosse Ile, MIThe airplane's collision with a deer on the unfenced runway during the takeoff roll. Contributing to the accident is the airport's failure to establish a continuous fence between the runway and the nature conservancy.NTSB GAA15CA108Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5B · Springhill, LAUnintentional collision with a deer during landing in dusk visual conditions.NTSB DCA15CA108Accident · No injuriesData collectionFinal reportEmbraer EMB 145LR · Springfield, MOan in-flight collision with a bird.NTSB DCA15CA037Accident · No injuriesData collectionFinal reportBoeing 737 · Baltimore, MDan inadvertent encounter with birds during approach to land that resulted in substantial damage.NTSB CEN15CA086Accident · No injuriesData collectionFinal reportWilliams Glenn RV 8A · San Antonio, TXUnintentional collision with a deer at night.NTSB CEN15CA039Accident · No injuriesData collectionFinal reportRobinson Helicopter R66 · Baton Rouge, LAAn in-flight bird strike.NTSB CEN15CA041Accident · No injuriesData collectionFinal reportCessna 510 · Faribault, MNAn inflight collision with a goose while descending to land at the destination airport.NTSB CEN15CA013Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Ann Arbor, MIThe collision with a deer during a night takeoff.NTSB ERA14CA412Accident · No injuriesData collectionFinal reportCessna 140 · Luray, VAA loss of control and subsequent runway excursion while attempting to avoid a collision with a deer on takeoff.NTSB ERA14CA419Accident · No injuriesData collectionFinal reportDehavilland DHC 6 Twin Otter · Pepperell, MAAn inadvertent collision with a bird, which resulted in substantial damage to the left wing.NTSB DCA14CA147Accident · No injuriesData collectionFinal reportDehavilland DHC 8 102 · Harrisburg, PAthe airplanes collision with geese during the takeoff roll.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 WPR14CA276Accident · No injuriesData collectionFinal reportChristen Industries A 1 · Moses Lake, WAThe airplane impacted a bird during low level flight.NTSB CEN14LA262Accident · No injuriesLimited investigationFinal reportEmbraer EMB 135KL · Traverse City, MIAn in-flight collision with a bird during the descent to land, which resulted in substantial damage to the airplane.NTSB ERA14CA214Accident · No injuriesData collectionFinal reportBeech A36 · Hazlehurst, GAAn inadvertent collision with wildlife while landing.NTSB CEN14CA209Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Put in Bay, OHAn inflight collision with a goose while on an approach.NTSB ERA14CA172Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Saluda, SCAn inadvertent encounter with a deer during the takeoff roll.NTSB ERA14CA097Accident · No injuriesData collectionFinal reportCessna 195B · Winchester, VAThe pilot's attempt to avoid a deer on the runway, which resulted in loss of aircraft control, a runway excursion, and collision with a runway sign.NTSB CEN14CA095Accident · No injuriesData collectionFinal reportCessna 182N · Paradis, LAThe collision with a bird which resulted in substantial damage to the airplane.NTSB ENG14IA005Incident · No injuriesIncident investigationFinal reportBoeing 737 3H4 · St. Louis, MOThe initial damage to the fan blades was caused by the ingestion of two mallard ducks that caused one or more fan blades to fracture, striking the fan shroud, as well as other passing fan blades, producing various sized blades fragments that created a…