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 CEN24LA190Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Shreveport, LAThe airplane’s collision with a deer on the runway during landing.NTSB CEN24LA153Accident · No injuriesClass 4 · LimitedFinal reportBeech B300 · Oklahoma City, OKAn in-flight collision with a bird during the initial climb.NTSB CEN24LA143Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 407 · Moran, KSAn in-flight collision with birds while in cruise flight.NTSB ERA24LA173Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pembroke Pines, FLAn inflight collision with a bird while approaching the destination airport.NTSB CEN24LA129Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · Fort Morgan, COAn inflight collision with birds while on approach.NTSB ERA24LA137Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Leesburg, VAAn in-flight collision with a bird while on the downwind leg of the airport traffic pattern.NTSB ERA24LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Smyrna, TNAn in-flight collision with a bird during initial climb.NTSB CEN24FA094Accident · 3 fatalClass 3 · FieldFinal reportBell 206 · Hydro, OKThe helicopter’s inflight collision with cackling geese, resulting in an inflight breakup.NTSB DCA24LA330IncidentClass 2 · LimitedFinal reportBoeing 737-8 · Kenner, LAA partial loss of engine power due to bird ingestion in the No. 1 (left) engine, which resulted in the activation of the load reduction device to prevent vibration. The load reduction device activation resulted in smoke and fumes entering the cockpit.NTSB DCA24LA051Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · St. Louis, MOA bird strike during climbout.NTSB ERA24LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Newport News, VAAn inflight collision with a bird during initial climb.NTSB WPR24LA049Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Watsonville, CAAn in-flight collision with a bird while in the initial climb.NTSB ERA24LA061Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Manassas, VAAn in-flight collision with a bird during initial climb.NTSB CEN24LA051Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Glencoe, MNThe collision with deer during the landing rollout.NTSB CEN24LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna 560XL · Council Bluffs, IAAn in-flight collision with a bird during decent.NTSB CEN24LA053Accident · Minor injuriesClass 4 · LimitedFinal reportAirbus Helicopters Deutschland EC135T3 · Dodge Center, MNAn in-flight collision with a flock of birds.NTSB ERA24LA025Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 305 · Williamston, NCLoss of directional control to avoid a deer during landing, which resulted in a runway excursion and collision with a culvert.NTSB CEN24LA023Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-201T · Mount Pleasant, MIThe airplane’s collision with a deer on the runway during landing.NTSB CEN24LA017Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Mitchell, INThe inflight collision with a bird while in cruise flight.NTSB CEN24LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Riesel, TXAn in-flight collision with a bird.NTSB CEN23LA394Accident · Minor injuriesClass 4 · LimitedFinal reportTextron 172S · Englewood, COAn in-flight collision with multiple geese during initial climb.NTSB CEN23LA387Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Henderson, KYAn in-flight collision with a bird shortly after takeoff.NTSB CEN23LA384Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · West Lafayette, INAn in-flight collision with a bird during initial climb.NTSB CEN23LA379Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Houston, TXAn in-flight collision with a bird.NTSB ERA23LA368Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Culpeper, VAThe airplane’s impact with a deer while performing a takeoff at night.NTSB ERA23LA305Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Gray, GAAn in-flight collision with a bird.NTSB ERA23LA303Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-201 · Macon, GAAn inflight collision with a bird.NTSB ERA23LA257Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 402 · Charlotte Amalie, CBAn in-flight collision with a bird while entering the traffic pattern.NTSB CEN23LA203Accident · No injuriesClass 4 · LimitedFinal reportNanchang CJ6 · Windsor, COAn inflight collision with a bird while on initial climb.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 ERA23LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kinston, NCThe airplane’s impact with two deer while performing a takeoff at night.NTSB WPR23LA066Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters EC 130 T2 · Yuba City, CAAn in-flight collision with a bird while in cruise flight.NTSB CEN23LA055Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Guthrie, OKThe airplane’s collision with a deer on the runway during landing.NTSB DCA23LA067Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320 · Red Oak, IAMultiple bird strikes during descent.NTSB ERA23LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 402 · Mashpee, MAThe airplane’s impact with a bird while enroute.NTSB CEN23LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Olathe, KSThe inflight collision with multiple geese during initial climb.NTSB ERA23LA044Accident · No injuriesClass 3 · LimitedFinal reportRobinson R44 · Sarasota, FLAn in-flight collision with a bird, which resulted in damage to a tail rotor blade, a subsequent vibration, and the pilot’s decision to conduct a precautionary landing to unsuitable terrain.NTSB ERA23LA039Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Kingstree, SCThe airplane’s impact with two deer during the landing roll.NTSB ERA23LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Dacula, GAAn in-flight collision with a bird while on approach.NTSB WPR22LA365Accident · Minor injuriesClass 4 · LimitedFinal reportMary Alexander JA30 Superstol · Groveland, CAThe pilot's excessive application of brake during an attempt to avoid wildlife while taxing resulted in a nose over.NTSB CEN22LA441Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Shell Lake, WIA collision with a deer during landing, which resulted in substantial damage to the left wing.NTSB WPR22LA358Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · South Jordan, UTThe pilot’s inability to see and avoid a bird while landing in dark night conditions.NTSB ERA22LA403Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Toughkenamon, PAThe airplane’s impact with a bird while entering the traffic pattern.NTSB ERA22LA371Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Talladega, ALA collision with a deer during takeoff.NTSB ERA22LA325Accident · No injuriesClass 4 · LimitedFinal reportRaytheon 400A · Brunswick, GAAn in-flight collision with a bird.NTSB ERA22LA238Accident · No injuriesClass 4 · LimitedFinal reportMX MXS · Bealeton, VAAn inflight collision with a bird while conducting low level aerobatics.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 WPR22LA180Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-400 · Benson, AZThe pilot’s failure to lower the landing gear on approach due to distraction.NTSB ERA22LA178Accident · No injuriesClass 4 · LimitedFinal reportExtra 300 · Rome, GAAn inflight collision with a bird while conducting low level aerobatics.