Skip to content

NTSB investigations, 2017

18 cases where the sequence of events included Birdstrike.

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") = 2017 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

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\") = 2017
    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 year(c."eventDate") = 2017
  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 GAA18CA071Accident · No injuriesData collectionFinal reportCessna 402 · Hyannis, MAEncounter with a flock of birds during takeoff at night, resulting in multiple bird strikes and structural damage.Dec 4, 2017 · N2748Y · Substantial damage NTSB GAA18CA063Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAAn in-flight collision with a bird.Nov 20, 2017 · N172SX · Substantial damage NTSB CEN18FA033Accident · 3 fatalField investigationFinal reportBell Helicopter Textron Canada 407 · Stuttgart, ARAn in-flight loss of control due to bird strikes.Nov 20, 2017 · N620PA · Destroyed NTSB GAA18CA048Accident · Minor injuriesData collectionFinal reportCessna 172M · Chico, CAAn in-flight collision with a bird.Nov 19, 2017 · N9678Q · Substantial damage NTSB WPR18FA011Accident · 1 fatalField investigationFinal reportPeterson Lancair Legacy · Bowie, AZAn in-flight loss of control due to a bird strike.Oct 19, 2017 · N259L · Substantial damage NTSB GAA17CA553Accident · No injuriesData collectionFinal reportAerotrike Safari · Bridgeton, NJThe pilot’s improper landing flare, which resulted in a hard landing while conducting an off-airport precautionary landing after a bird strike.Sep 24, 2017 · N7675K · Substantial damage NTSB GAA17CA573Accident · No injuriesData collectionFinal reportCessna 172 · Chino, CAAn in-flight collision with a bird while on downwind.Sep 22, 2017 · N520KS · Substantial damage NTSB DCA17WA196Incident · No injuriesForeign investigationBoeing 737 · Leon, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…Sep 3, 2017 · XA-MAI NTSB GAA17CA570Accident · No injuriesData collectionFinal reportPiper PA 31 · SaipanImpact with multiple birds while retracting the landing gear, which resulted in the subsequent failure of the right inboard main landing gear door actuator hose and prevented the pilot from being able to extend the landing gear.Aug 30, 2017 · N4078J · Substantial damage NTSB GAA17CA429Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Edgartown, MAThe airplane’s collision with geese during the takeoff roll.Jul 23, 2017 · N831SR · Substantial damage NTSB ERA17CA251Accident · No injuriesData collectionFinal reportWeatherly 620 · Pemberton Twp, NJAn in-flight collision with a bird during takeoff, which resulted in a partial loss of engine power and subsequent collision with trees and terrain.Jul 19, 2017 · N9270W · Substantial damage NTSB WPR17FA134Accident · 2 fatalField investigationFinal reportJordan John RV7 · Arlington, AZThe inflight overstress separation of the vertical stabilizer and rudder during flight which resulted in the pilot's inability to maintain airplane control. Contributing to the accident was an inflight collision with a bird.Jun 27, 2017 · N731RV · Destroyed NTSB GAA17CA373Accident · No injuriesData collectionFinal reportCessna 172 · Roseburg, ORAn in-flight collision with a bird during the approach.Jun 25, 2017 · N79938 · Substantial damage NTSB GAA17CA311Accident · No injuriesData collectionFinal reportCessna 208 · Skagway, AKAn in-flight collision with a goose.May 22, 2017 · N754KP · Substantial damage NTSB GAA17CA244Accident · No injuriesData collectionFinal reportBeech 99 · Waukesha, WIAn in-flight collision with a bird during the approach.Apr 24, 2017 · N899CZ · Substantial damage NTSB GAA17CA207Accident · No injuriesData collectionFinal reportCessna 550 · Salt Lake City, UTAn in-flight collision with a goose during approach.Mar 24, 2017 · N551BC · Substantial damage NTSB GAA17CA161Accident · No injuriesData collectionFinal reportPiper PA 28R · Phoenix, AZAn in-flight collision with a bird.Feb 20, 2017 · N962WW · Substantial damage NTSB DCA17WA053Incident · No injuriesForeign investigationBoeing Boeing 737-8K5 · Bournemouth, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BOEING COMPANY BOEING 737-8K5 airplane that occurred on January 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's…Jan 10, 2017 · G-FDZY · Minor damage