NTSB investigations: Engineering & Research ERCOUPE 415-C, TX
13 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 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1969 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1996 | 1 |
| 2019 | 1 |
| 2020 | 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\" = 'TX' 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" = 'TX' 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 CEN20LA170Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Hallettsville, TXThe partial loss of engine power due to contaminated fuel and carburetor ice.NTSB GAA20CA031Accident · No injuriesData collectionFinal reportErcoupe 415 · Alvin, TXThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport landing, during which the airplane landed hard and then ground looped.NTSB FTW97LA063Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Amarillo, TXfailure of the #1 exhaust valve, which resulted in loss of engine power and a forced landing on rough/uneven terrain. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW80DPD31Accident · No injuriesClosedErco 415-C · Electra, TXNTSB FTW80FRG13Accident · 1 fatalClosedErco 415-C · Troy, TXNTSB FTW78FPD16Accident · Minor injuriesClosedErco 415-C · Margaret, TXNTSB FTW76FRG18Accident · No injuriesClosedErco 415-C · Pearsall, TXNTSB FTW74FRG70Accident · Minor injuriesClosedErco 415-C · Alice, TXNTSB FTW69F0478Accident · No injuriesClosedErcoupe 415-C · Cleveland, TXNTSB FTW68F0280Accident · No injuriesClosedErco 415-C · El Paso, TXNTSB FTW67D0310Accident · No injuriesClosedErcoupe 415-C · Crosbyton, TXNTSB FTW66D0655Accident · No injuriesClosedErcoupe 415-C · Abilene, TXNTSB UNK64X2495Accident · No injuriesClosedErcoupe 415C · Sunray, TX