# NTSB investigations, 2018, FL: 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 ERA19LA091](https://openairdocs.org/ntsb/ERA19LA091.md): Czech Sport Sportcruiser · Naples, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 2018 · N564SC · Substantial damage
  > Collision with a bird in flight, which resulted in damage to the engine, a fuel leak, and a subsequent total loss of engine power due to fuel exhaustion.
- [NTSB GAA18CA308](https://openairdocs.org/ntsb/GAA18CA308.md): Cirrus Design SR22 · Cedar Key, FL · Accident · No injuries · Data collection · Final report · May 28, 2018 · N269DW · Substantial damage
  > The airplane’s collision with multiple birds during initial climb, which damaged the propeller and resulted in a subsequent aerodynamic stall because the airspeed could not be maintained.
- [NTSB GAA18CA162](https://openairdocs.org/ntsb/GAA18CA162.md): Aeropro CZ Eurofox LSA · Punta Gorda, FL · Accident · Minor injuries · Data collection · Final report · Mar 13, 2018 · N989G · Substantial damage
  > A collision with a large bird during approach.

## 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") = 2018
  AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  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?state=FL&year=2018

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
