NTSB investigations: Engineering & Research ERCOUPE 415-C, CA
17 cases on aircraft the registry lists as Engineering & Research 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1975 | 2 |
| 1979 | 1 |
| 1980 | 2 |
| 1983 | 1 |
| 1988 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'CA' 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 ('0420312'))
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" = 'CA' 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 ('0420312'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 LAX88LA151Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Palo Alto, CADuring a local flight in the pattern, the engine experienced a loss of power and a forced landing was made short of the runway. Inspection of the engine revealed that water was in the fuel pump bowl and rust was present on the cylinders.NTSB LAX83FA397Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Kernville, CAThe acft crashed in rising terrain 6 mi west of the departure arpt at 5,000 ft MSL. The alta sierra pass is 6,500 ft mslwith mountain tops at 8,320 ft MSL. The plt was issued a student certificate on 8/22/80 which was not renewed.NTSB LAX80FA082Accident · 1 fatalClosedErco 415-C · Volcanoville, CANTSB LAX80FUG27Accident · Serious injuriesClosedErco 415-C · Landers, CANTSB LAX79FUQ35Accident · No injuriesClosedErco 415-C · Agua Dulce, CANTSB OAK7LDVD05Accident · Serious injuriesClosedErco 415-C · Sonoma, CANTSB OAK75FVG43Accident · No injuriesClosedForney 415-C · Vacaville, CANTSB LAX73FUA05Accident · No injuriesClosedErco 415-C · Torrance, CANTSB OAK72DVA47Accident · No injuriesClosedErco 415-C · Merced, CANTSB OAK72DVM09Accident · No injuriesClosedErco 415-C · Morgan Hill, CANTSB OAK70DVG17Accident · No injuriesClosedErco 415-C · Pope Valley, CANTSB LAX69A0024Accident · 4 fatalClosedErco 415-C · Calipatria, CANTSB LAX67D0261Accident · No injuriesClosedErcoupe 415-C · Joshua, CANTSB LAX67D0184Accident · No injuriesClosedErcoupe 415-C · Agua Dulce, CANTSB LAX66D0095Accident · No injuriesClosedErcoupe 415-C · Huntington Bc, CANTSB OAK66F0010Accident · Minor injuriesClosedErcoupe 415C · Concord, CANTSB UNK65X0386Accident · No injuriesClosedErcoupe 415C · Santa Monic, CA