NTSB investigations: Ercoupe 415-C, OH

11 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, OH per year, 1964–2026: 11 cases
1964	1
1966	2
1967	2
1968	2
1969	1
1972	1
1975	1
1987	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" = 'OH' 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\" = 'OH' 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" = 'OH' 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 ATL88LA058Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Marlboro, OHThe student plt rptd that he flew a flat final apch to remain clear of trees. The airspeed began to drop, and the airplane subsequently landed hard after clearing the trees.Dec 10, 1987 · N87102 · Substantial damage NTSB CHI76FEI03Accident · No injuriesClosedErco 415-C · Chardon, OHJul 11, 1975 · N2970H · Substantial damage NTSB CHI72AC101Accident · 1 fatalClosedErco 415-C · Fremont, OHJun 20, 1972 · N87094 · Destroyed NTSB CHI70F0295Accident · Serious injuriesClosedErco 415C · Germantown, OHOct 12, 1969 · N99522 · Substantial damage NTSB CHI69F0427Accident · Minor injuriesClosedErco 415-C · Clyde, OHDec 1, 1968 · N93538 · Substantial damage NTSB CHI69D0255Accident · No injuriesClosedErco 415-C · Brookville, OHSep 21, 1968 · N93590 · Substantial damage NTSB CHI68A0014Accident · 2 fatalClosedErco 415-C · Madison, OHJul 31, 1967 · N2913H · Destroyed NTSB CHI67F0541Accident · No injuriesClosedErcoupe 415-C · New Carlisle, OHMar 16, 1967 · N94068 · Substantial damage NTSB CHI67F0242Accident · No injuriesClosedErco 415-C · Dayton, OHOct 9, 1966 · N37115 · Substantial damage NTSB CHI66F0657Accident · No injuriesClosedErco 415-C · Dayton, OHApr 9, 1966 · N99919 · Substantial damage NTSB UNK64X1308Accident · No injuriesClosedErcoupe 415C · Springfield, OHApr 14, 1964 · N2475H · Substantial damage