# NTSB investigations: Ercoupe 415-C, 2019

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 WPR19LA253](https://openairdocs.org/ntsb/WPR19LA253.md): Ercoupe 415 · Maricopa, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 10, 2019 · N3816H · Substantial damage
  > The flight instructor’s failure to prevent the student pilot from exceeding the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent spin. Contributing to the accident was the student pilot’s failure to make a positive…
- [NTSB GAA19CA329](https://openairdocs.org/ntsb/GAA19CA329.md): Ercoupe 415 · Lafayette, IN · Accident · No injuries · Data collection · Final report · Jun 7, 2019 · N3667H · Substantial damage
  > The flight instructor's failure to maintain pitch control and his improper landing flare, which resulted in a hard landing.

## 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 year(c."eventDate") = 2019
  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&year=2019

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