NTSB investigations: Ercoupe 415-C, IL
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 | 3 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2007 | 1 |
| 2015 | 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\" = 'IL' 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" = 'IL' 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 CEN15LA177Accident · No injuriesLimited investigationFinal reportErcoupe 415 C · St Jacob, ILThe loss of engine power during the go-around due to fuel contamination.NTSB CHI08CA056Accident · No injuriesData collectionFinal reportErcoupe 415D · Abingdon, ILThe loose clamp on the throttle cable which prevented application of engine power. A factor in the accident was the low altitude when the throttle cable slipped.NTSB CHI00LA162Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Joliet, ILthe engine failure for undetermined reasons. Factors were the low altitude, remedial action not possible by the pilot, and the ditch.NTSB CHI96LA311Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cambridge, ILThe pilot's failure to maintain control of the airplane while landing. A factor associated with the accident was the downdraft reported by the pilot.NTSB CHI85LA355Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Ashkum, ILThe left wing of the acft contacted crops during an attempted takeoff. The plt reported liftoff was too soon and the acft veered left contacted crops. The plt stated that he should have stayed on rwy longer.NTSB CHI77DEE29Accident · No injuriesClosedErco 415-C · Sterling, ILNTSB CHI76FEV63Accident · Minor injuriesClosedErco 415-C · Cisco, ILNTSB CHI74DEE70Accident · Minor injuriesClosedErco 415-CD · Dekalb, ILNTSB CHI73FEV03Accident · No injuriesClosedErcoupe 415C · Champaign, ILNTSB CHI71FBQ23Accident · Minor injuriesClosedErco 415-C · Loda, ILNTSB CHI67F0444Accident · No injuriesClosedErcoupe 415-C · Chicago, ILNTSB CHI66F0684Accident · No injuriesClosedErco 415-C · Danville, ILNTSB UNK64X3379Accident · Minor injuriesClosedErcoupe 415C · Lansing, ILNTSB UNK64X3054Accident · No injuriesClosedErcoupe 415C · Chicago, ILNTSB UNK64X2968Accident · No injuriesClosedPiper J3 · Wheeling, IL