# NTSB investigations: Continental E225 series, NY

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 ERA11LA099](https://openairdocs.org/ntsb/ERA11LA099.md): Beech F35 · Syracuse, NY · Accident · No injuries · Limited investigation · Final report · Dec 24, 2010 · N3448B · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during landing with airframe structural icing, resulting in an aerodynamic stall and subsequent hard landing. Contributing to the accident was the pilot’s continued flight into known icing conditions.
- [NTSB ERA09LA532](https://openairdocs.org/ntsb/ERA09LA532.md): Ryan Navion · Fire Island, NY · Accident · No injuries · Limited investigation · Final report · Sep 20, 2009 · N4467K · Substantial damage
  > A total loss of engine power during cruise flight due to fuel starvation as a result of a deteriorated fuel gasket.
- [NTSB NYC86LA245](https://openairdocs.org/ntsb/NYC86LA245.md): Ryan-Navion A · Lakeport, NY · Accident · No injuries · Limited investigation · Final report · Sep 14, 1986 · N5146K · Substantial damage
  > The rocker box cover on the #6 cylinder had the top and bottom screws loose and the center screw missing, causing oil to leak from the bottom of the rocker box cover.
- [NTSB NYC77FFA25](https://openairdocs.org/ntsb/NYC77FFA25.md): Beech D35 · Bloomingburg, NY · Accident · Minor injuries · Closed · May 17, 1977 · N2179D · Destroyed
- [NTSB NYC74FFJ31](https://openairdocs.org/ntsb/NYC74FFJ31.md): Beech G35 · Nedrow, NY · Accident · No injuries · Closed · May 4, 1974 · N318B · Substantial damage
- [NTSB NYC66A0063](https://openairdocs.org/ntsb/NYC66A0063.md): Navion NAV-A · Fort Ann, NY · Accident · 2 fatal · Closed · Dec 3, 1965 · N4053K · Destroyed
- [NTSB NYC66D0357](https://openairdocs.org/ntsb/NYC66D0357.md): Beechcraft G35 · Olean, NY · Accident · No injuries · Closed · Oct 31, 1965 · N4219D · Substantial damage

## 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 c."eventStateOrRegion" = 'NY' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17015'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17015&state=NY

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