NTSB investigations: Ercoupe 415-C, NJ

9 cases on aircraft the registry lists as Ercoupe 415-C. 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

19642026

NTSB investigations: Ercoupe 415-C, NJ per year, 1964–2026: 9 cases
1964	2
1967	1
1968	1
1971	1
1978	1
1985	1
2004	1
2016	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."eventStateOrRegion" = 'NJ' 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

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.\"eventStateOrRegion\" = 'NJ' 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"

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."eventStateOrRegion" = 'NJ' 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

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 ERA17LA023Accident · Serious injuriesLimited investigationFinal reportErcoupe 415 · Lindenwold, NJA partial loss of engine power for reasons that could not be determined based on the available information.Oct 19, 2016 · N415WE · Substantial damage NTSB IAD04LA039Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Pemberton, NJA total loss of engine power for undetermined reasons.Aug 17, 2004 · N3771H · Substantial damage NTSB NYC85LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Sussex, NJThe acft experienced a loss of eng pwr during climb shortly after takeoff and was substantially damaged during the forced landing which resulted. The plt reported the eng coughed and lost pwr, however, when the throttle was pumped, pwr returned. Pwr was then…Mar 23, 1985 · N99677 · Substantial damage NTSB NYC79FHD21Accident · Minor injuriesClosedErcoupe 415 · Manahawkin, NJJul 18, 1978 · N93677 · Substantial damage NTSB NYC72FHD14Accident · No injuriesClosedErco 415-C · Pemberton, NJAug 28, 1971 · N3771H · Substantial damage NTSB NYC68F0481Accident · 1 fatalClosedErcoupe 415-C · Williamstown, NJApr 28, 1968 · N93331 · Destroyed NTSB NYC67A0190Accident · 2 fatalClosedErcoupe 415C · Berlin, NJJun 28, 1967 · N99035 · Destroyed NTSB UNK64X2926Accident · No injuriesClosedErcoure 415C · Hanover, NJJul 19, 1964 · N99288 · Substantial damage NTSB UNK64X2292Accident · No injuriesClosedErcoupe 415C · S Plainfield, NJJun 14, 1964 · N94088 · Substantial damage