Final NTSB investigations
219 cases where the sequence of events included Birdstrike.
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '901' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '901' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN23LA379Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Houston, TXAn in-flight collision with a bird.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 WPR23LA066Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters EC 130 T2 · Yuba City, CAAn in-flight collision with a bird while in cruise flight.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 ERA23LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Dacula, GAAn in-flight collision with a bird while on approach.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 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 ERA22LA178Accident · No injuriesClass 4 · LimitedFinal reportExtra 300 · Rome, GAAn inflight collision with a bird while conducting low level aerobatics.NTSB ERA22LA124Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Rocky Mount, NCAn inflight collision with a bird, which resulted in substantial damage to the left wing.NTSB ERA22LA110Accident · Serious injuriesClass 4 · LimitedFinal reportMiller Roger Thatcher CX4 · Angier, NCThe pilot’s encounter with a flock of birds on final approach, which resulted in a loss of control, an aerodynamic stall and spin, and impact with trees and terrain.NTSB ERA22LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Berlin, NJAn inadvertent in-flight collision with a goose while on approach.NTSB CEN22LA084Accident · No injuriesClass 4 · LimitedFinal reportTextron 525 · Dubuque, IAAn inflight collision with a flock of geese that resulted in substantial damage to the vertical stabilizer.NTSB ERA22LA090Accident · 2 fatalClass 3 · LimitedFinal reportAerofab Lake LA-4-250 · Auburndale, FLA bird strike, which resulted in a loss of control while flying at low altitude over a lake.NTSB ERA22LA084Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, VACollision with a bird in flight, which resulted in damage to the right-wing leading-edge spar.NTSB CEN22LA057Accident · No injuriesClass 4 · LimitedFinal reportLeonardo AW169 · Austin, TXThe helicopter’s impact with a bird during cruise flight.NTSB ERA22LA044Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stevensville, MDAn in-flight collision with a bird during initial climb.NTSB ERA22LA073Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Wheeler Heights, GAThe airplane’s impact with a bird while in the traffic pattern.NTSB ENG22LA002Incident · Minor injuriesClass 3 · LimitedFinal reportAirbus A320-271N · Atlantic City, NJThe ingestion of a bird into the right engine during the takeoff roll caused a fan blade to fracture near the blade platform resulting in high fan blade off loads and engine vibrations sufficient to result in an eventual failure of a fuel tube in the right…NTSB ERA21LA376Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Unadilla, GAThe airplane's impact by a bird during the enroute portion of the flight.NTSB CEN21LA417Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Olive Branch, MSThe airplane’s impact with a bird while on approach.NTSB WPR21LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 560XL · Salt Lake City, UTThe airplane’s impact with birds during approach.NTSB ERA21LA197Accident · No injuriesClass 4 · LimitedFinal reportCessna 402C · New Bedford, MAAn inadvertent collision with a bird during descent, resulting in substantial damage to the vertical stabilizer.NTSB DCA21LA120Accident · No injuriesClass 4 · LimitedFinal reportVans RV-7 · Boulder, COa bird strike.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 WPR20LA256Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · San Jose, CAThe airplane’s collision with a bird while maneuvering in the airport traffic pattern.NTSB CEN20CA048Accident · No injuriesData collectionFinal reportVans RV 10 · Granbury, TXThe airplane’s impact with a bird while on approach.NTSB DCA20CA050Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · Kansas City, MOa bird strike during descentNTSB ERA20CA058Accident · Minor injuriesData collectionFinal reportCessna P210 · Gainesville, FLThe airplane's impact by a bird during the initial climb.NTSB GAA20CA054Accident · Serious injuriesData collectionFinal reportBeech 200 · New Braunfels, TXThe airplane’s in-flight collision with a bird.NTSB DCA20CA010Accident · No injuriesData collectionFinal reportDe Havilland DHC8 · Boise, IDa bird strike during climb out.NTSB GAA20CA038Accident · No injuriesData collectionFinal reportPiper PA28 · Wedgefield, FLAn in-flight collision with a bird.NTSB GAA19CA557Accident · No injuriesData collectionFinal reportBeech 35 · Fort Myers, FLThe airplane’s impact with a bird during approach.NTSB GAA19CA451Accident · No injuriesData collectionFinal reportCessna 402 · St. Louis, MOThe airplane’s collision with a bird during short final.NTSB GAA19CA467Accident · No injuriesData collectionFinal reportCessna 525 · Orlando, FLThe airplane’s impact with a bird during approach.NTSB GAA19CA400Accident · Minor injuriesData collectionFinal reportBeech 95 · Navasota, TXThe airplane’s impact with a bird.NTSB ERA19FA170Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 30 · Naples, FLIncapacitation of the pilot due to a birdstrike through the windshield in front of the pilot's position, while on approach to land.NTSB WPR19FA124Accident · 2 fatalClass 3 · FieldFinal reportVans RV 6 · Ridgefield, WAThe pilots' inadvertent exceedance of the airplane's critical angle of attack following an inflight collision with a bird.NTSB GAA19CA268Accident · No injuriesData collectionFinal reportPiper PA32 · SaipanThe airplane’s collision with a bird during the initial climb, which resulted in the engine cowling separating and impacting the empennage.NTSB DCA19CA130Accident · No injuriesData collectionFinal reportBoeing 737 · Nashville, TNa collision with a bird.