Skip to content

NTSB investigations, 2012

20 cases where NTSB found Animal(s)/bird(s).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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 year(c."eventDate") = 2012 AND 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

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 year(c.\"eventDate\") = 2012
    AND 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 year(c."eventDate") = 2012
  AND 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 DCA13CA066Accident · No injuriesData collectionFinal reportBombardier CL-600-2B19 · New York, NYan inadvertant birdstrike on approach.Dec 5, 2012 · N411ZW · Substantial damage 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.Nov 17, 2012 · N6763L · Substantial damage NTSB CEN13CA031Accident · No injuriesData collectionFinal reportCessna 150 · Carrollton, OHThe airplane’s collision with two deer during the takeoff roll.Oct 24, 2012 · N5978E · Substantial damage NTSB ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…Oct 20, 2012 · N80823 · Substantial damage NTSB ERA12CA592Accident · No injuriesData collectionFinal reportLearjet 36A · New Haven, CTAn inadvertent collision with a deer during the takeoff roll.Sep 20, 2012 · C-FEMT · Substantial damage NTSB ERA12LA557Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Washington, PAThe airplane’s encounter with a flock of geese during takeoff, which resulted in the airplane’s hard impact with the runway while the pilot maneuvered in an attempt to avoid the geese.Sep 9, 2012 · N3591P · Substantial damage 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.Aug 28, 2012 · N3082E · Substantial damage NTSB CEN12IA502Incident · No injuriesIncident investigationFinal reportBoeing 737-924ER · Denver, COAn in-flight collision with a bird during descent to land, which resulted in damage to the left pitot tube and loss of airspeed information to the left and right primary flight displays (PFD). The reason for the total loss of indications on the left PFD could…Jul 31, 2012 · N37420 · Minor damage 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.Jul 7, 2012 · N26181 · Substantial damage NTSB ANC12CA063Accident · No injuriesData collectionFinal reportPiper PA-32-301 · King Salmon, AKAn in-flight collision with a bird during cruise flight.Jun 28, 2012 · N8470Y · Substantial damage NTSB CEN12IA383Incident · No injuriesIncident investigationFinal reportCessna 560 · Ozark, MOThe airplane’s collision with a deer during the landing roll.Jun 15, 2012 · N305LX · Minor damage NTSB ERA12LA379Accident · Minor injuriesLimited investigationFinal reportBell 427 · Indiantown, FLThe inflight collision with birds, resulting in damage to the rotor head assembly and a subsequent forced landing and rollover.Jun 4, 2012 · N427AL · Substantial damage 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.May 20, 2012 · N456MB · Substantial damage NTSB CEN12CA328Accident · No injuriesData collectionFinal reportShiver Tailwind W-10 · Pipe Creek, TXAn inadvertent collision with a deer during takeoff and the airplane’s subsequent departure from the runway and impact with a tree.May 17, 2012 · N625JS · Substantial damage NTSB CEN12CA305Accident · No injuriesData collectionFinal reportCessna A185F · Crystal Falls, MIThe pilot's abrupt maneuver to avoid deer that unexpectedly ran into the airplane's path during the landing roll.May 16, 2012 · N4742E · Substantial damage NTSB CEN12CA270Accident · No injuriesData collectionFinal reportCessna 172M · Three Rivers, MICollision with a deer during the takeoff roll.May 1, 2012 · N30380 · Substantial damage NTSB ERA12CA236Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 42 · New Smyrna, FLAn inadvertent encounter with a bird during cruise flight.Mar 12, 2012 · N915ER · Substantial damage NTSB ERA12CA218Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Atlanta, GAAn in-flight collision with birds during cruise flight.Mar 7, 2012 · N4083Y · Substantial damage NTSB ERA12CA185Accident · No injuriesData collectionFinal reportCessna 172S · Eufaula, ALAn inadvertent collision with a deer during a night landing.Feb 14, 2012 · N6194V · Substantial damage NTSB WPR12CA073Accident · No injuriesData collectionFinal reportMcadam W E Christen Eagle II · Eureka, CAA collision with a deer while landing.Jan 2, 2012 · N45WM · Substantial damage