# NTSB investigations: Ercoupe 415-C, CO

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 FTW97LA172](https://openairdocs.org/ntsb/FTW97LA172.md): Ercoupe 415-C · Canon City, CO · Accident · No injuries · Limited investigation · Final report · Apr 27, 1997 · N2326H · Destroyed
  > The pilot's failure to maintain an adequate visual lookout. A factor was the pilot's attention being diverted.
- [NTSB DEN87LA078](https://openairdocs.org/ntsb/DEN87LA078.md): Ercoupe 415C · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Apr 1, 1987 · N114PA · Substantial damage
  > The student plt said the acft ballooned during the flare and he applied forward stick. The acft touched down nose wheel first and the nose gear collapsed. The acft then settled hard on main gear resulting in additional damage.
- [NTSB DEN81DTE74](https://openairdocs.org/ntsb/DEN81DTE74.md): Erco 415-C · Aurora, CO · Accident · No injuries · Closed · Sep 21, 1981 · N93682 · Substantial damage
- [NTSB DEN81DTE11](https://openairdocs.org/ntsb/DEN81DTE11.md): Erco 415-C · Colorado Spgs, CO · Accident · Minor injuries · Closed · Dec 14, 1980 · N99445 · Substantial damage
- [NTSB DEN78FTE40](https://openairdocs.org/ntsb/DEN78FTE40.md): Erco 415-C · Broomfield, CO · Accident · Serious injuries · Closed · Mar 21, 1978 · N99227 · Destroyed
- [NTSB DEN76FTE98](https://openairdocs.org/ntsb/DEN76FTE98.md): Erco 415-C · Ft.Collins, CO · Accident · No injuries · Closed · Sep 22, 1976 · N99107 · Substantial damage
- [NTSB DEN70AD047](https://openairdocs.org/ntsb/DEN70AD047.md): Erco 415-C · Akron, CO · Accident · 1 fatal · Closed · Feb 20, 1970 · N93444 · Destroyed
- [NTSB DEN69D0133](https://openairdocs.org/ntsb/DEN69D0133.md): Erco 415-C · Littleton, CO · Accident · No injuries · Closed · Oct 17, 1968 · N99905 · Substantial damage
- [NTSB DEN67D0265](https://openairdocs.org/ntsb/DEN67D0265.md): Ercoupe 415C · Boulder, CO · Accident · No injuries · Closed · Apr 29, 1967 · N99905 · Substantial damage
- [NTSB DEN67F0132](https://openairdocs.org/ntsb/DEN67F0132.md): Ercoupe 415-C · Aurora, CO · Accident · Minor injuries · Closed · Sep 24, 1966 · N2839H · Substantial damage
- [NTSB UNK64X2367](https://openairdocs.org/ntsb/UNK64X2367.md): Ercoupe C7512 · Florence, CO · Accident · No injuries · Closed · Jun 19, 1964 · N99897 · 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."eventStateOrRegion" = 'CO' 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=CO

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