NTSB investigations: Ercoupe 415-C, CO

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, CO per year, 1964–2026: 11 cases
1964	1
1966	1
1967	1
1968	1
1970	1
1976	1
1978	1
1980	1
1981	1
1987	1
1997	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" = '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

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

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" = '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

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 FTW97LA172Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Canon City, COThe pilot's failure to maintain an adequate visual lookout. A factor was the pilot's attention being diverted.Apr 27, 1997 · N2326H · Destroyed NTSB DEN87LA078Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Englewood, COThe 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.Apr 1, 1987 · N114PA · Substantial damage NTSB DEN81DTE74Accident · No injuriesClosedErco 415-C · Aurora, COSep 21, 1981 · N93682 · Substantial damage NTSB DEN81DTE11Accident · Minor injuriesClosedErco 415-C · Colorado Spgs, CODec 14, 1980 · N99445 · Substantial damage NTSB DEN78FTE40Accident · Serious injuriesClosedErco 415-C · Broomfield, COMar 21, 1978 · N99227 · Destroyed NTSB DEN76FTE98Accident · No injuriesClosedErco 415-C · Ft.Collins, COSep 22, 1976 · N99107 · Substantial damage NTSB DEN70AD047Accident · 1 fatalClosedErco 415-C · Akron, COFeb 20, 1970 · N93444 · Destroyed NTSB DEN69D0133Accident · No injuriesClosedErco 415-C · Littleton, COOct 17, 1968 · N99905 · Substantial damage NTSB DEN67D0265Accident · No injuriesClosedErcoupe 415C · Boulder, COApr 29, 1967 · N99905 · Substantial damage NTSB DEN67F0132Accident · Minor injuriesClosedErcoupe 415-C · Aurora, COSep 24, 1966 · N2839H · Substantial damage NTSB UNK64X2367Accident · No injuriesClosedErcoupe C7512 · Florence, COJun 19, 1964 · N99897 · Destroyed