NTSB investigations: Ercoupe 415-C, 1985
2 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 | 26 |
|---|---|
| 1965 | 19 |
| 1966 | 28 |
| 1967 | 28 |
| 1968 | 26 |
| 1969 | 19 |
| 1970 | 16 |
| 1971 | 15 |
| 1972 | 11 |
| 1973 | 14 |
| 1974 | 12 |
| 1975 | 11 |
| 1976 | 21 |
| 1977 | 9 |
| 1978 | 11 |
| 1979 | 9 |
| 1980 | 13 |
| 1981 | 4 |
| 1982 | 8 |
| 1983 | 5 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 6 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 5 |
| 1991 | 5 |
| 1992 | 5 |
| 1993 | 6 |
| 1994 | 3 |
| 1996 | 3 |
| 1997 | 4 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 6 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 5 |
| 2007 | 2 |
| 2008 | 5 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 3 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2025 | 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\") = 1985
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 year(c."eventDate") = 1985
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 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 NYC85LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Sussex, NJThe acft experienced a loss of eng pwr during climb shortly after takeoff and was substantially damaged during the forced landing which resulted. The plt reported the eng coughed and lost pwr, however, when the throttle was pumped, pwr returned. Pwr was then…