NTSB investigations: Engineering & Research ERCOUPE 415-C, 1988
4 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 | 8 |
|---|---|
| 1965 | 15 |
| 1966 | 12 |
| 1967 | 9 |
| 1968 | 7 |
| 1969 | 4 |
| 1970 | 5 |
| 1971 | 5 |
| 1972 | 6 |
| 1973 | 4 |
| 1974 | 5 |
| 1975 | 5 |
| 1976 | 3 |
| 1977 | 5 |
| 1978 | 2 |
| 1979 | 5 |
| 1980 | 5 |
| 1981 | 1 |
| 1982 | 4 |
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 4 |
| 1989 | 2 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2000 | 2 |
| 2003 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 3 |
| 2009 | 1 |
| 2010 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2022 | 1 |
| 2024 | 2 |
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 year(c.\"eventDate\") = 1988
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 year(c."eventDate") = 1988
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 FTW89DPJ02Accident · 2 fatalFinal reportErcoupe 415C · Oklahoma City, OKDuring flight, the airplane appeared to go into a steep banked spiral from which it did not recover. It struck a two-car detached garage and then the ground. Inspection revealed that the fabric of both wings had been installed improperly, and part of the…NTSB MKC88LA157Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Springfield, MOWhile attempting to depart a 1600 ft sod runway, the PIC said he was unable to get airborne and elected to abort the takeoff. Unable to stop, he went through a fence, substantially damaging both wings. The plt recommended not trying to takeoff from a short…NTSB NYC88LA197Accident · Serious injuriesLimited investigationFinal reportErco 415C · W. Bloomfield, NYShorlty after takeoff at about 150 feet a.g.l., the pilot lost control of the airplane and crashed in a corn field about 0.5 mile from airport. A passenger reported that they encountered a wind gust and the pilot was unable to control the airplane.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.