# NTSB investigations: Engineering & Research ERCOUPE 415-C, CA

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 LAX88LA151](https://openairdocs.org/ntsb/LAX88LA151.md): Ercoupe 415-C · Palo Alto, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 1988 · N99373 · Substantial damage
  > During a local flight in the pattern, the engine experienced a loss of power and a forced landing was made short of the runway. Inspection of the engine revealed that water was in the fuel pump bowl and rust was present on the cylinders.
- [NTSB LAX83FA397](https://openairdocs.org/ntsb/LAX83FA397.md): Ercoupe 415-C · Kernville, CA · Accident · 1 fatal · Field investigation · Final report · Aug 13, 1983 · N94369 · Destroyed
  > The acft crashed in rising terrain 6 mi west of the departure arpt at 5,000 ft MSL. The alta sierra pass is 6,500 ft mslwith mountain tops at 8,320 ft MSL. The plt was issued a student certificate on 8/22/80 which was not renewed.
- [NTSB LAX80FA082](https://openairdocs.org/ntsb/LAX80FA082.md): Erco 415-C · Volcanoville, CA · Accident · 1 fatal · Closed · Apr 20, 1980 · N2211H · Destroyed
- [NTSB LAX80FUG27](https://openairdocs.org/ntsb/LAX80FUG27.md): Erco 415-C · Landers, CA · Accident · Serious injuries · Closed · Mar 25, 1980 · N2657H · Substantial damage
- [NTSB LAX79FUQ35](https://openairdocs.org/ntsb/LAX79FUQ35.md): Erco 415-C · Agua Dulce, CA · Accident · No injuries · Closed · Jun 9, 1979 · N87063 · Substantial damage
- [NTSB OAK7LDVD05](https://openairdocs.org/ntsb/OAK7LDVD05.md): Erco 415-C · Sonoma, CA · Accident · Serious injuries · Closed · Aug 24, 1975 · N2049H · Substantial damage
- [NTSB OAK75FVG43](https://openairdocs.org/ntsb/OAK75FVG43.md): Forney 415-C · Vacaville, CA · Accident · No injuries · Closed · Jan 9, 1975 · N99661 · Substantial damage
- [NTSB LAX73FUA05](https://openairdocs.org/ntsb/LAX73FUA05.md): Erco 415-C · Torrance, CA · Accident · No injuries · Closed · Jul 30, 1972 · N99389 · Substantial damage
- [NTSB OAK72DVA47](https://openairdocs.org/ntsb/OAK72DVA47.md): Erco 415-C · Merced, CA · Accident · No injuries · Closed · Nov 20, 1971 · N2601H · Substantial damage
- [NTSB OAK72DVM09](https://openairdocs.org/ntsb/OAK72DVM09.md): Erco 415-C · Morgan Hill, CA · Accident · No injuries · Closed · Oct 30, 1971 · N2861H · Destroyed
- [NTSB OAK70DVG17](https://openairdocs.org/ntsb/OAK70DVG17.md): Erco 415-C · Pope Valley, CA · Accident · No injuries · Closed · Apr 25, 1970 · N99373 · Substantial damage
- [NTSB LAX69A0024](https://openairdocs.org/ntsb/LAX69A0024.md): Erco 415-C · Calipatria, CA · Accident · 4 fatal · Closed · Oct 27, 1968 · N3280H · 2 aircraft · Destroyed
- [NTSB LAX67D0261](https://openairdocs.org/ntsb/LAX67D0261.md): Ercoupe 415-C · Joshua, CA · Accident · No injuries · Closed · Jan 19, 1967 · N87317 · Substantial damage
- [NTSB LAX67D0184](https://openairdocs.org/ntsb/LAX67D0184.md): Ercoupe 415-C · Agua Dulce, CA · Accident · No injuries · Closed · Oct 22, 1966 · N2921H · Substantial damage
- [NTSB LAX66D0095](https://openairdocs.org/ntsb/LAX66D0095.md): Ercoupe 415-C · Huntington Bc, CA · Accident · No injuries · Closed · Aug 21, 1965 · N87063 · Substantial damage
- [NTSB OAK66F0010](https://openairdocs.org/ntsb/OAK66F0010.md): Ercoupe 415C · Concord, CA · Accident · Minor injuries · Closed · Jun 4, 1965 · N99373 · Substantial damage
- [NTSB UNK65X0386](https://openairdocs.org/ntsb/UNK65X0386.md): Ercoupe 415C · Santa Monic, CA · Accident · No injuries · Closed · Oct 23, 1964 · N2317H · 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" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0420312'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=0420312&state=CA

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