# NTSB investigations, 2017: Birdstrike

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB GAA18CA071](https://openairdocs.org/ntsb/GAA18CA071.md): Cessna 402 · Hyannis, MA · Accident · No injuries · Data collection · Final report · Dec 4, 2017 · N2748Y · Substantial damage
  > Encounter with a flock of birds during takeoff at night, resulting in multiple bird strikes and structural damage.
- [NTSB GAA18CA063](https://openairdocs.org/ntsb/GAA18CA063.md): Cessna 172N · San Diego, CA · Accident · No injuries · Data collection · Final report · Nov 20, 2017 · N172SX · Substantial damage
  > An in-flight collision with a bird.
- [NTSB CEN18FA033](https://openairdocs.org/ntsb/CEN18FA033.md): Bell Helicopter Textron Canada 407 · Stuttgart, AR · Accident · 3 fatal · Field investigation · Final report · Nov 20, 2017 · N620PA · Destroyed
  > An in-flight loss of control due to bird strikes.
- [NTSB GAA18CA048](https://openairdocs.org/ntsb/GAA18CA048.md): Cessna 172M · Chico, CA · Accident · Minor injuries · Data collection · Final report · Nov 19, 2017 · N9678Q · Substantial damage
  > An in-flight collision with a bird.
- [NTSB WPR18FA011](https://openairdocs.org/ntsb/WPR18FA011.md): Peterson Lancair Legacy · Bowie, AZ · Accident · 1 fatal · Field investigation · Final report · Oct 19, 2017 · N259L · Substantial damage
  > An in-flight loss of control due to a bird strike.
- [NTSB GAA17CA553](https://openairdocs.org/ntsb/GAA17CA553.md): Aerotrike Safari · Bridgeton, NJ · Accident · No injuries · Data collection · Final report · Sep 24, 2017 · N7675K · Substantial damage
  > The pilot’s improper landing flare, which resulted in a hard landing while conducting an off-airport precautionary landing after a bird strike.
- [NTSB GAA17CA573](https://openairdocs.org/ntsb/GAA17CA573.md): Cessna 172 · Chino, CA · Accident · No injuries · Data collection · Final report · Sep 22, 2017 · N520KS · Substantial damage
  > An in-flight collision with a bird while on downwind.
- [NTSB DCA17WA196](https://openairdocs.org/ntsb/DCA17WA196.md): Boeing 737 · Leon, Mexico · Incident · No injuries · Foreign investigation · Sep 3, 2017 · XA-MAI
  > The 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…
- [NTSB GAA17CA570](https://openairdocs.org/ntsb/GAA17CA570.md): Piper PA 31 · Saipan · Accident · No injuries · Data collection · Final report · Aug 30, 2017 · N4078J · Substantial damage
  > Impact 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.
- [NTSB GAA17CA429](https://openairdocs.org/ntsb/GAA17CA429.md): Cirrus Design SR22 · Edgartown, MA · Accident · No injuries · Data collection · Final report · Jul 23, 2017 · N831SR · Substantial damage
  > The airplane’s collision with geese during the takeoff roll.
- [NTSB ERA17CA251](https://openairdocs.org/ntsb/ERA17CA251.md): Weatherly 620 · Pemberton Twp, NJ · Accident · No injuries · Data collection · Final report · Jul 19, 2017 · N9270W · Substantial damage
  > An in-flight collision with a bird during takeoff, which resulted in a partial loss of engine power and subsequent collision with trees and terrain.
- [NTSB WPR17FA134](https://openairdocs.org/ntsb/WPR17FA134.md): Jordan John RV7 · Arlington, AZ · Accident · 2 fatal · Field investigation · Final report · Jun 27, 2017 · N731RV · Destroyed
  > The 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.
- [NTSB GAA17CA373](https://openairdocs.org/ntsb/GAA17CA373.md): Cessna 172 · Roseburg, OR · Accident · No injuries · Data collection · Final report · Jun 25, 2017 · N79938 · Substantial damage
  > An in-flight collision with a bird during the approach.
- [NTSB GAA17CA311](https://openairdocs.org/ntsb/GAA17CA311.md): Cessna 208 · Skagway, AK · Accident · No injuries · Data collection · Final report · May 22, 2017 · N754KP · Substantial damage
  > An in-flight collision with a goose.
- [NTSB GAA17CA244](https://openairdocs.org/ntsb/GAA17CA244.md): Beech 99 · Waukesha, WI · Accident · No injuries · Data collection · Final report · Apr 24, 2017 · N899CZ · Substantial damage
  > An in-flight collision with a bird during the approach.
- [NTSB GAA17CA207](https://openairdocs.org/ntsb/GAA17CA207.md): Cessna 550 · Salt Lake City, UT · Accident · No injuries · Data collection · Final report · Mar 24, 2017 · N551BC · Substantial damage
  > An in-flight collision with a goose during approach.
- [NTSB GAA17CA161](https://openairdocs.org/ntsb/GAA17CA161.md): Piper PA 28R · Phoenix, AZ · Accident · No injuries · Data collection · Final report · Feb 20, 2017 · N962WW · Substantial damage
  > An in-flight collision with a bird.
- [NTSB DCA17WA053](https://openairdocs.org/ntsb/DCA17WA053.md): Boeing Boeing 737-8K5 · Bournemouth, United Kingdom · Incident · No injuries · Foreign investigation · Jan 10, 2017 · G-FDZY · Minor damage
  > The 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…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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
```

This list as a web page: https://openairdocs.org/ntsb-events/901/sequence?year=2017

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
