NTSB investigations: Ercoupe 415-C, AZ

12 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, AZ per year, 1964–2026: 12 cases
1964	1
1967	2
1968	1
1969	1
1973	3
1975	1
1980	1
1996	1
2019	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" = 'AZ' 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\" = 'AZ' 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" = 'AZ' 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 WPR19LA253Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Maricopa, AZThe 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…Sep 10, 2019 · N3816H · Substantial damage NTSB LAX96LA282Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Page, AZdecision of the pilot to operate the airplane with an inoperative transfer pump and inaccurate fuel consumption calculations.Jul 20, 1996 · N2915H · Substantial damage NTSB LAX80FUJ48Accident · No injuriesClosedErco 415-C · Tonopah, AZApr 18, 1980 · N87351 · Substantial damage NTSB LAX76DUJ22Accident · No injuriesClosedErco 415-C · Camp Verde, AZAug 24, 1975 · N2723H · Substantial damage NTSB LAX73DUJ91Accident · No injuriesClosedErco 415-C · Cottonwood, AZJun 16, 1973 · N87311 · Destroyed NTSB LAX73FUJ78Accident · Minor injuriesClosedErco 415-CD · Casa Grande, AZMay 9, 1973 · N99644 · Substantial damage NTSB LAX73DUJ70Accident · Minor injuriesClosedErco 415-D · Catalina, AZMar 31, 1973 · N3737H · Substantial damage NTSB LAX70D0234Accident · No injuriesClosedErco 415-CD · Kearney, AZDec 26, 1969 · N99644 · Substantial damage NTSB LAX69D0073Accident · No injuriesClosedErcoupe 415-C · Phoenix, AZJul 13, 1968 · N2253H · Substantial damage NTSB LAX67F0379Accident · Minor injuriesClosedErcoupe 415-C · Mesa, AZApr 6, 1967 · N2774H · Substantial damage NTSB LAX67D0247Accident · No injuriesClosedErcoupe 415-C · Glendale, AZJan 2, 1967 · N3660H · Substantial damage NTSB UNK64X1347Accident · No injuriesClosedErcoupe 415C · Phoenix, AZApr 17, 1964 · N93581 · Substantial damage