# NTSB investigations: Ercoupe 415-C, SC

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 ATL88LA093](https://openairdocs.org/ntsb/ATL88LA093.md): Ercoupe 415C · Spartanburg, SC · Accident · No injuries · Limited investigation · Final report · Feb 17, 1988 · N3631H · Substantial damage
  > When the pilot was unable to find assistance to remove the nose wheel chock from the aircraft, he applied enough power to jump the chock. He was unable to retard the throttle before colliding with a parked aircraft and striking a concrete wall.
- [NTSB MIA80FA010](https://openairdocs.org/ntsb/MIA80FA010.md): Erco 415-C · Bishopville, SC · Accident · 2 fatal · Closed · Nov 18, 1979 · N99484 · Destroyed
- [NTSB MIA74FLG04](https://openairdocs.org/ntsb/MIA74FLG04.md): Erco 415-C · Carlisle, SC · Accident · No injuries · Closed · Jul 17, 1974 · N93967 · Substantial damage
- [NTSB MIA68F0187](https://openairdocs.org/ntsb/MIA68F0187.md): Erco 415-C · Barnwell, SC · Accident · No injuries · Closed · Aug 22, 1967 · N99047 · Substantial damage
- [NTSB MIA68F0203](https://openairdocs.org/ntsb/MIA68F0203.md): Erco 415-C · Pelion, SC · Accident · Minor injuries · Closed · Aug 1, 1967 · N99019 · Substantial damage
- [NTSB MIA67F0255](https://openairdocs.org/ntsb/MIA67F0255.md): Ercoupe 415-C · Lancaster, SC · Accident · No injuries · Closed · Sep 21, 1966 · N2249H · Substantial damage
- [NTSB MIA66F0506](https://openairdocs.org/ntsb/MIA66F0506.md): Erco 415-C · St Stephen, SC · Accident · Minor injuries · Closed · Mar 20, 1966 · N93538 · Substantial damage
- [NTSB UNK64X1831](https://openairdocs.org/ntsb/UNK64X1831.md): Ercoupe 415C · Harleyville, SC · Accident · No injuries · Closed · May 18, 1964 · N3333H · 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" = 'SC' 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 ('0420322'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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