OpenAirDocs.org

NTSB investigations, 2009

14 cases where the sequence of events included Birdstrike.

Cases per year

20082026

Where

Open the map

Latest 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 year(c.\"eventDate\") = 2009
    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.

NTSB CEN10IA053Incident · No injuriesIncident investigationFinal reportAirbus A319-111 · Kansas City, MOThe in-flight engine ingestion of one or more Lesser Snow Geese (Chen caerulescens caerulescens).Nov 15, 2009 · N924FR · Minor damageNTSB WPR10IA045Incident · Minor injuriesIncident investigationFinal reportBeech C-99 · Show Low, AZAn in-flight collision with a bird during initial descent.Nov 4, 2009 · N330AV · Minor damageNTSB WPR10LA044Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas MD-90-30 · Phoenix, AZAn in-flight collision with birds.Nov 2, 2009 · N909DA · Substantial damageNTSB ANC10CA003Accident · No injuriesData collectionFinal reportCessna U206F · Homer, AKAn in-flight collision with a bird.Oct 8, 2009 · N7138Q · Substantial damageNTSB CEN09IA481Incident · No injuriesIncident investigationFinal reportRaytheon BE-400A · Sugar Land, TXThe failure of the spinner following an unavoidable bird strike. Contributing to the incident were the inadequate engine bird strike certification requirements in place at the time the engine was certified.Jul 31, 2009 · N679SJ · Minor damageNTSB ERA09LA384Accident · No injuriesLimited investigationFinal reportLancair LC42-550FG · Ocean City, NJAn in-flight collision with birds during landing. Contributing to the accident was the airport's lack of a wildlife mitigation program.Jul 4, 2009 · N6502A · Substantial damageNTSB CEN09CA365Accident · No injuriesData collectionFinal reportCessna 172RG · Brownwood, TXAn in-flight collision with a large bird while on the downwind leg of a traffic pattern.Jun 10, 2009 · N6393R · Substantial damageNTSB CEN09CA418Accident · No injuriesData collectionFinal reportCessna 550 · Sellersburg, INAn in-flight collision with a large bird during the airplane's initial climb.Jun 5, 2009 · N73HH · Substantial damageNTSB WPR09CA182Accident · No injuriesData collectionFinal reportCessna 172S · Snohomish, WAAn in-flight collision with a crow.Apr 4, 2009 · N4915F · Substantial damageNTSB ERA09IA186Incident · Minor injuriesIncident investigationFinal reportAgusta A109E · Gainesville, FLAn inadvertent in-flight collision with a duck.Mar 6, 2009 · N911UF · Minor damageNTSB ERA09CA195Accident · No injuriesData collectionFinal reportCessna 172P · Cleveland, MSThe inadvertent encounter with a bird in flight.Mar 6, 2009 · N6089K · Substantial damageNTSB CEN09CA151Accident · No injuriesData collectionFinal reportSchweizer G-164B · Ferriday, LAThe pilot's loss of control following an impact with birds.Feb 1, 2009 · N3628T · Substantial damageNTSB DCA09MA026Accident · Serious injuriesClass 1 · MajorFinal reportAirbus A320 · Weehawken, NJThe ingestion of large birds into each engine, which resulted in an almost total loss of thrust in both engines and the subsequent ditching on the Hudson River. Contributing to the fuselage damage and resulting unavailability of the aft slide/rafts were (1)…Jan 15, 2009 · N106US · Substantial damageNTSB CEN09MA117Accident · 8 fatalMajor investigationFinal reportSikorsky S-76C · Morgan City, LA(1) the sudden loss of power to both engines that resulted from impact with a bird (red-tailed hawk), which fractured the windshield and interfered with engine fuel controls, and (2) the subsequent disorientation of the flight crewmembers, which left them…Jan 4, 2009 · N748P · Destroyed