NTSB investigations: Ercoupe 415-C, IN
15 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.
Cases per year
| 1964 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1978 | 1 |
| 1994 | 1 |
| 2019 | 1 |
| 2022 | 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\" = 'IN' 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" = 'IN' 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" 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 CEN22LA210Accident · No injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Angola, INThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard landing and the nose landing gear collapse.NTSB GAA19CA329Accident · No injuriesData collectionFinal reportErcoupe 415 · Lafayette, INThe flight instructor's failure to maintain pitch control and his improper landing flare, which resulted in a hard landing.NTSB CHI95LA004Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cloverdale, INthe total loss of engine power due to a blocked orifice in the fuel pump. A related factor is the rough/uneven terrain encountered during the forced landing.NTSB CHI79FEX04Accident · Minor injuriesClosedErco 415-D · Kirklin, INNTSB CHI77FET02Accident · Serious injuriesClosedErco 415-C · E.Syracuse, INNTSB CHI76FET44Accident · No injuriesClosedErco 415-C · Lucerne, INNTSB CHI74FEA40Accident · No injuriesClosedErco 415-C · Greenfield, INNTSB CHI73DEA15Accident · No injuriesClosedErco 415-C · Greentown, INNTSB CHI69F0017Accident · Serious injuriesClosedErcoupe 415-C · Lafayette, INNTSB CHI68F0141Accident · Minor injuriesClosedErco 415-C · Greencastle.Ind, INNTSB CHI68F0142Accident · Minor injuriesClosedErco 415-C · Hartford City, INNTSB CHI67D0139Accident · No injuriesClosedErcoupe 415-D · Cloverdale, INNTSB CHI66F0070Accident · No injuriesClosedErcoupe 415C · Mooresville, INNTSB UNK64X3893Accident · No injuriesClosedErcoupe 415C · Anderson, INNTSB UNK64X3803Accident · 1 fatalClosedErcoupe 415C · Columbus, IN