NTSB investigations: Ercoupe 415-C, MI
17 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 3 |
| 1969 | 2 |
| 1973 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1982 | 1 |
| 1990 | 1 |
| 2004 | 1 |
| 2010 | 1 |
| 2013 | 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\" = 'MI' 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" = 'MI' 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 CEN13CA510Accident · No injuriesData collectionFinal reportErcoupe 415-C · Mackinac Island, MIThe pilot's failure to maintain aircraft control while on final approach.NTSB CEN10LA203Accident · No injuriesLimited investigationFinal reportUnivair 415-C · Columbiaville, MIThe pilot misjudged his speed and distance while landing, which resulted in an overrun and subsequent collision with terrain.NTSB CHI04CA175Accident · Minor injuriesData collectionFinal reportErcoupe 415C · Lake City, MIThe pilot selecting the wrong runway for the wind conditions and his delay in executing an aborted takeoff resulting in the airplane running off the departure end of the runway and into a ditch. The tailwind and the ditch were contributing factors.NTSB CHI91DEM01Accident · 1 fatalFinal reportErcoupe 415C · Shelby, MIThe pilot's continued flight into IMC.NTSB CHI82DA275Accident · Minor injuriesFinal reportErcoupe 415C · Port Sheldon Tw, MIDuring a VFR flight along lake Michigan shoreline the pilot encountered a decrease in ceiling height. The pilot chose to make a 180 degrees maneuver and return to the airport but during the turn encountered a fog bank. The pilot decended to avoid the fog bank…NTSB CHI78FEM02Accident · No injuriesClosedErco 415-C · Beaverton, MINTSB CHI77FET25Accident · No injuriesClosedErco 415-C · Edwardsburg, MINTSB CHI77FA016Accident · 1 fatalClosedErco 415-C · Palo, MINTSB CHI73FEM49Accident · Minor injuriesClosedErco 415-C · Sand Lake, MINTSB CHI70F0160Accident · No injuriesClosedErco 415-C · Mt.Clemens, MINTSB CHI69F0526Accident · No injuriesClosedErco 415-C · Charlotte, MINTSB CHI69F0368Accident · No injuriesClosedErco 415-C · Lawton, MINTSB CHI69D0102Accident · No injuriesClosedErcoupe 415-C · Sparta, MINTSB CHI68F0764Accident · No injuriesClosedErco 415-C · Ypsilanti, MINTSB CHI68F0086Accident · Minor injuriesClosedErco 415-C · Newport, MINTSB CHI67F0264Accident · No injuriesClosedErcoupe 415-C · Plymouth, MINTSB CHI66F0419Accident · No injuriesClosedErcoupe 415C · Three Oaks, MI