NTSB investigations: Ercoupe G

7 cases on aircraft the registry lists as Ercoupe G. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19692026

NTSB investigations: Ercoupe G per year, 1969–2026: 7 cases
1969	2
1971	1
1978	1
1992	1
1997	1
2002	1

Where

Open the map

Latest cases

Query with 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0420722')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0420722'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CHI02LA230Accident · No injuriesLimited investigationFinal reportErcoupe G · Palmyra, WIFailure by the pilot-in-command to properly compensate for the wind conditions, as well as an improper landing flare. Contibuting factors were the inadequate supervision by the flight instructor and the wind gusts.Aug 3, 2002 · N94431 · Substantial damage NTSB IAD97LA083Accident · 1 fatalLimited investigationFinal reportErcoupe G · Dalton, NYthe pilot's delay in aborting the landing after allowing the airplane to touchdown long. His failure to attain a proper touchdown point was a related factor.Jun 8, 1997 · N94435 · Destroyed NTSB FTW92LA235Accident · No injuriesLimited investigationFinal reportErcoupe 415-G · Gallup, NMThe instructor pilot's lack of familiarity with the performance capability of the aircraft. Factors were the rising terrain and high density altitude.Sep 30, 1992 · N94424 · Substantial damage NTSB DEN78DQD24Accident · Minor injuriesClosedErco 415-G · Las Cruces, NMJul 10, 1978 · N94423 · Substantial damage NTSB MIA72FKG41Accident · Serious injuriesClosedErco 415-C · Allenhurst, GASep 14, 1971 · N94889 · Destroyed NTSB OAK70D0120Accident · No injuriesClosedErco 415G · Lone Pine, CASep 19, 1969 · N94408 · Substantial damage NTSB MKC70D0052Accident · No injuriesClosedErcoupe 415-G · S.Sioux City, NEJul 4, 1969 · N94421 · Substantial damage