NTSB investigations
107 cases where the sequence of events included Wildlife encounter (non-bird).
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '310' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '310' 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 GAA19CA004Accident · No injuriesData collectionFinal reportCessna 310 · Marathon, TXThe pilot's failure to see and avoid a cow on the airstrip during landing.NTSB GAA18CA420Accident · No injuriesData collectionFinal reportCirrus SR22 · Hudson, NYCollision with a deer during landing.NTSB GAA18CA402Accident · No injuriesData collectionFinal reportPiper PA28 · Rolla, MOA collision with a deer on the runway during the takeoff roll at night.NTSB GAA18CA349Accident · No injuriesData collectionFinal reportBeech F33A · Martinsville, VAThe airplane’s collision with a deer during takeoff.NTSB GAA18CA155Accident · No injuriesData collectionFinal reportLearjet 31 · Mount Pleasant, MIThe airplane’s collision with deer during the landing roll.NTSB GAA18CA150Accident · No injuriesData collectionFinal reportCessna 172 · Kent, OHA deer collided with aircraft during landing at night.NTSB GAA18CA032Accident · No injuriesData collectionFinal reportPiper PA28 · West Seneca, NYThe airplane's collision with a deer during the landing roll.NTSB GAA18LA062Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Mesa, AZA coyote strike and the subsequent operation of the airplane, which led to internal composite wing structure damage.NTSB GAA17CA541Accident · No injuriesData collectionFinal reportRudberg Todd W Vans Acft RV8 · Manzanita, ORThe airplane’s collision with two elks during landing.NTSB GAA17CA532Accident · No injuriesData collectionFinal reportCessna 177 · Harrisonville, MOA collision with a deer on the runway during the takeoff roll.NTSB GAA17CA446Accident · No injuriesData collectionFinal reportPiper PA46 · Franklin, VAA collision with a deer during the landing roll, which resulted in a runway excursion.NTSB DCA17CA064Accident · No injuriesData collectionFinal reportBombardier CL 600 2C10 · Charlotte, NCcollision with a deer during takeoff.NTSB CEN17WA109Accident · 3 fatalForeign investigationCessna TU206G · Tamazula, MexicoOn February 10, 2017, about 1850 hours universal coordinated time, a Cessna model TU206G single-engine airplane, serial number U20605373, Mexican registration XA-UIL, crashed shortly after takeoff from Alizal Airport (MX-0092), located near Tamazula, Durango,…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 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 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 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 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 GAA16CA129Accident · No injuriesData collectionFinal reportPilatus PC12 · Lawrenceville, GAAn unintentional collision with a white-tailed deer during the takeoff roll in night visual conditions.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 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 DCA15WA181Accident · No injuriesForeign investigationSwearingen SA227 · Thangool, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Fairchild SA227 airplane, which occurred on September 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the…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 CEN15CA086Accident · No injuriesData collectionFinal reportWilliams Glenn RV 8A · San Antonio, TXUnintentional collision with a deer at night.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 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 ERA14CA214Accident · No injuriesData collectionFinal reportBeech A36 · Hazlehurst, GAAn inadvertent collision with wildlife while landing.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 CEN14CA063Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Burwell, NEAn inadvertent collision with a deer during landing.NTSB CEN14CA026Accident · No injuriesData collectionFinal reportCessna 310R · Onaway, MIAn inadvertent collision with a deer during landing.NTSB ERA13CA414Accident · No injuriesData collectionFinal reportCessna 172B · Shellman Bluff, GAAn inadvertent collision with a deer during landing.NTSB CEN13CA337Accident · No injuriesData collectionFinal reportStiegelmeyer John R Vans RV-7A · Vinton, IAThe inadvertent collision with a deer during landing.NTSB ERA13LA061Accident · No injuriesLimited investigationFinal reportCessna 550 · Greenwood, SCCollision with a deer during the landing roll, which resulted in a compromised fuel tank and a postimpact fire.NTSB ERA12CA592Accident · No injuriesData collectionFinal reportLearjet 36A · New Haven, CTAn inadvertent collision with a deer during the takeoff roll.NTSB WPR12CA375Accident · No injuriesData collectionFinal reportCessna 172 · Sand Point, IDA deer strike during the landing flare. Contributing to the accident was the airport’s lack of any deer incursion prevention measures, such as an airport perimeter fence.NTSB CEN12CA419Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Ray Township, MIThe airplane’s collision with a deer that ran in front of the airplane during the landing roll.NTSB CEN12IA383Incident · No injuriesIncident investigationFinal reportCessna 560 · Ozark, MOThe airplane’s collision with a deer during the landing roll.NTSB ERA12CA347Accident · No injuriesData collectionFinal reportCessna 172R · Crossville, TNThe pilot's attempt to avoid a deer on the runway, which resulted in a runway excursion.NTSB ERA12CA185Accident · No injuriesData collectionFinal reportCessna 172S · Eufaula, ALAn inadvertent collision with a deer during a night landing.NTSB ERA11CA072Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Andover, NJAn inadvertent collision with a deer on the runway during a night landing.NTSB ERA11CA027Accident · No injuriesData collectionFinal reportPiper PA28 · Titusville, FLAn inadvertent collision with a deer during a night takeoff.NTSB CEN11CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Sparta, MIAn inadvertent collision with a deer during a night takeoff.NTSB WPR10CA409Accident · No injuriesData collectionFinal reportCessna TP206B · Saint Maries, IDA loss of aircraft control during takeoff due to an inadvertent collision with a deer that ran onto the runway.NTSB CEN10CA460Accident · No injuriesData collectionFinal reportCessna T210M · Shell Lake, WIThe collision with the deer during landing roll.NTSB ERA10LA247Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Clemson, SCThe airplane's inadvertent collision with deer during a night takeoff. Contributing to the accident was the lack of a deer barrier between the airport and an adjacent wooded area.NTSB WPR09CA456Accident · No injuriesData collectionFinal reportAviat A-1C · McArthur, CAThe pilot's failure to maintain aircraft control during landing due to animals unexpectedly running onto the runway.