# Fatal NTSB investigations: Engineering & Research 415-C

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 GAA23WA146](https://openairdocs.org/ntsb/GAA23WA146.md): Engineering & Research 415-C · St. Mary, Jamaica · Accident · 2 fatal · Class 5 · Foreign · May 5, 2023 · N3254B · Substantial damage
- [NTSB CEN09FA243](https://openairdocs.org/ntsb/CEN09FA243.md): Engineering and Research 415C · Sandwich, IL · Accident · 2 fatal · Field investigation · Final report · Apr 11, 2009 · N87384 · Destroyed
  > The pilot's failure to execute an immediate forced landing to a suitable field and the engine's partial loss of power for an undetermined reason.
- [NTSB DEN03FA087](https://openairdocs.org/ntsb/DEN03FA087.md): Ercoupe 415D · Los Lunas, NM · Accident · 2 fatal · Field investigation · Final report · May 25, 2003 · N93971 · Destroyed
  > the pilot's failure to maintain clearance from the transmission wire. Contributing factors were the high wind, the pilot's decision to make a low-altitude turn onto the crosswind leg, and the power line.
- [NTSB NYC98FA107](https://openairdocs.org/ntsb/NYC98FA107.md): Ercoupe ERCO-415C · New Lisbon, NY · Accident · 2 fatal · Field investigation · Final report · May 16, 1998 · N3230H · Destroyed
  > Detonation within the No. 2 cylinder resulting in melting and breaching of the piston, and the pilot's selection of unsuitable terrain for landing. Contributing factors were the uphill terrain encountered during the landing and the visual perception…
- [NTSB FTW98FA203](https://openairdocs.org/ntsb/FTW98FA203.md): Ercoupe 415-C · Olustee, OK · Accident · 1 fatal · Field investigation · Final report · May 6, 1998 · N87125 · Substantial damage
  > The student pilot's improper decision to attempt an 180 degree turn to return to the takeoff runway.
- [NTSB MIA90FA168](https://openairdocs.org/ntsb/MIA90FA168.md): Erco 415-C · Huntersville, NC · Accident · 2 fatal · Field investigation · Final report · Aug 11, 1990 · N2436H · Destroyed
  > Failure of the pilot in command to maintain airspeed.
- [NTSB LAX81FA128](https://openairdocs.org/ntsb/LAX81FA128.md): Erco 415-D · Carefree, AZ · Accident · 2 fatal · Closed · Sep 19, 1981 · N3123H · Destroyed
- [NTSB MIA73AM032](https://openairdocs.org/ntsb/MIA73AM032.md): Erco 415-C · Sebastion, FL · Accident · 2 fatal · Closed · Sep 17, 1972 · N94015 · Destroyed
- [NTSB SEA72AS006](https://openairdocs.org/ntsb/SEA72AS006.md): Erco 415-C · Cle Elum, WA · Accident · 2 fatal · Closed · Aug 14, 1971 · N99265 · Destroyed
- [NTSB CHI67A0076](https://openairdocs.org/ntsb/CHI67A0076.md): Erco 415C · Pekin, IL · Accident · 2 fatal · Closed · Dec 16, 1966 · N3725H · Destroyed
- [NTSB NYC66A0156](https://openairdocs.org/ntsb/NYC66A0156.md): Erco 415C · Topping, VA · Accident · 1 fatal · Closed · Jun 24, 1966 · N93484 · Destroyed
- [NTSB LAX66A0009](https://openairdocs.org/ntsb/LAX66A0009.md): Ercoupe 415C · Santa Rosa, CA · Accident · 1 fatal · Closed · Jul 19, 1965 · N3599H · Destroyed
- [NTSB UNK64X3058](https://openairdocs.org/ntsb/UNK64X3058.md): Forney 415C · Stanardsville, VA · Accident · 2 fatal · Closed · Jul 26, 1964 · N87002 · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=0420302

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