NTSB investigations
359 cases where NTSB found Animal(s)/bird(s).
Cases per year
| 2008 | 21 |
|---|---|
| 2009 | 18 |
| 2010 | 21 |
| 2011 | 9 |
| 2012 | 20 |
| 2013 | 22 |
| 2014 | 15 |
| 2015 | 11 |
| 2016 | 19 |
| 2017 | 26 |
| 2018 | 22 |
| 2019 | 24 |
| 2020 | 9 |
| 2021 | 19 |
| 2022 | 21 |
| 2023 | 24 |
| 2024 | 27 |
| 2025 | 19 |
| 2026 | 12 |
Where
Open the mapLatest 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.\"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 ERA26LA293Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Carlisle, PAA collision with a deer during landing.NTSB CEN26LA291Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Linden, MIThe collision with a deer during touch-and-go landings.NTSB ERA26LA299Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Lakeland, FLAn in-flight collision with a bird while on approach.NTSB WPR26LA220Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Morgan Hill, CAAn in-flight collision with a bird.NTSB ANC26LA038Accident · No injuriesClass 4 · LimitedFinal reportTextron B300C · Salcha, AKAn in-flight collision with a bird during cruise flight.NTSB ERA26LA161Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Fellsmere, FLAn in-flight collision with a bird while descending to land at an airport.NTSB ERA26LA155Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Greenville, SCAn in-flight collision with a bird during cruise flight.NTSB ERA26LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Daytona Beach, FLAn in-flight collision with a bird while enroute.NTSB ERA26LA149Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Sanford, FLAn in-flight collision with a bird during initial climb.NTSB ERA26LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Chuluota, FLAn in-flight collision with a bird while enroute.NTSB CEN26LA116Accident · No injuriesClass 4 · LimitedFinal reportBeech C90 · Guymon, OKThe collision with a white-tailed deer during the takeoff in night visual conditions.NTSB ERA26LA111Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Thomson, GAAn in-flight collision with a bird while maneuvering.NTSB ERA26LA082Accident · No injuriesClass 4 · LimitedFinal reportPiper PA44 · Pembroke Pines, FLAn in-flight collision with a bird while on approach to the destination airport.NTSB CEN26LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Conroe, TXThe collision with a deer during takeoff.NTSB CEN26LA054Accident · Minor injuriesClass 4 · LimitedFinal reportLou Malinchak Titan T-51D · Bristow, OKThe collision with two deer during takeoff which resulted in a loss of control and impact with terrain.NTSB ERA26LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Lynchburg, VAAn in-flight collision with a bird.NTSB CEN26LA036Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Gueydan, LAThe pilot’s failure to maintain situational awareness and clearance from terrain while maneuvering to avoid birds.NTSB CEN26LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Grantsburg, WIThe collision with a white-tail deer during the landing in dark night visual conditions.NTSB ERA25LA375Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Punxsutawney, PAThe airplane’s collision with a deer on a runway during landing roll.NTSB ERA25LA377Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Okeechobee, FLCollision with a bird during cruise flight.NTSB ERA25LA360Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Linden, NJAn in-flight collision with a bird while on approach.NTSB CEN25LA362Accident · No injuriesClass 4 · LimitedFinal reportCessna 414 · New Braunfels, TXA in-flight collision with a bird during the descent for landing.NTSB CEN25LA353Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Pittsfield, ILThe collision with a deer during the aborted landing in night visual meteorological conditions.NTSB WPR25LA247Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Etna, WYThe pilot’s premature rotation at insufficient airspeed during takeoff to avoid an unexpected animal on the runway, which resulted in a loss of control and subsequent nose-over during the aborted takeoff. Contributing to the accident was the pilot’s excessive…NTSB CEN25LA294Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Stanwood, MIThe collision with a deer during takeoff.NTSB ERA25LA233Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Knoxville, TNA collision with a deer during the landing roll.NTSB CEN25LA180Accident · No injuriesClass 4 · LimitedFinal reportExcalibur Excalibur · Mountain View Airport, MOAn in-flight collision with a bird while enroute.NTSB ERA25LA206Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Tiffin, OHThe airplane’s collision with a deer on the runway during takeoff.NTSB WPR25LA113Accident · Minor injuriesClass 4 · LimitedFinal reportBeech E-55 · Van Nuys, CAAn in-flight collision with a bird during an approach to land.NTSB WPR25LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Ramona, CAAn in-flight collision with a bird in the airport traffic pattern.NTSB CEN25LA070Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2B19 · Stringtown, MSBird strike.NTSB CEN25LA066Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Monticello, IAThe on-ground collision with a deer on the runway during the landing roll.NTSB ANC25LA013Accident · No injuriesClass 3 · LimitedFinal reportCessna 182B · Waimea, HIThe pilot’s inadequate monitoring of the fuel status while en route, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA25LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Jefferson, GAThe airplane’s collision with a deer on the runway during landing.NTSB ERA25LA027Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Canal Winchester, OHAn in-flight collision with a bird while in cruise flight.NTSB ERA25LA026Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sebring, FLA birdstrike during descent to the destination airport.NTSB CEN24LA372Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Eden Prairie, MNThe bird strike during cruise flight that resulted in substantial damage to the airplane.NTSB WPR24LA308Accident · No injuriesClass 4 · LimitedFinal reportRaytheon B200 · Las Vegas, NMThe airplane’s collision with an elk during landing.NTSB WPR24LA305Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20F · Cottonwood, AZThe pilot’s evasive maneuver to avoid birds while on final approach at a low altitude, which resulted in the airplane colliding with a tree.NTSB CEN24LA273Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Blaine, MNThe airplane’s collision with a deer on the runway during takeoff.NTSB WPR24LA244Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lakeport, CAA collision with a deer during takeoff.NTSB CEN24LA267Accident · No injuriesClass 4 · LimitedFinal reportCovington Edward L SHA-GLASAIR · Saint James, MNAn in-flight bird strike which resulted in an engine compartment fire that ultimately destroyed the airplane.NTSB ANC24LA066Accident · No injuriesClass 4 · LimitedFinal reportCurtiss Wright C-46R · Kenai, AKAn in-flight collision with birds during takeoff.NTSB ERA24LA306Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Cochran, GAThe airplane’s impact with a bird resulting in substantial damage to the right wing.NTSB ERA24LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Clearwater, FLAn in-flight collision with a bird while flying in the airport traffic pattern.NTSB ERA24LA273Accident · No injuriesClass 4 · LimitedFinal reportConstruzioni Aeronautiche Tecn P2004 Bravo · Laurens, SCAn in-flight collision with a bird while in cruise flight.NTSB CEN24LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Crete, NEThe airplane’s collision with a deer on the runway during a touch-and-go landing.NTSB CEN24LA229Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander S2R · White, SDA low-level collision and engine ingestion with ducks, which resulted in a total loss of engine power, a forced landing, and a subsequent nose over.NTSB ERA24LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Fayetteville, TNA collision with a deer during the takeoff roll.NTSB ERA24LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Vero Beach, FLAn in-flight collision with a bird while on approach.