NTSB investigations: Ercoupe 415-C, 2006
5 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\") = 2006
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") = 2006
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 MIA06LA118Accident · 2 fatalLimited investigationFinal reportErcoupe 415C · Panacea, FLA loss of engine power for undetermined reasons, which resulted in the airplane descending and impacting trees during the approach. A possible contributing factor was the pilot's pre-existing cardiovascular condition.NTSB NYC06CA211Accident · No injuriesData collectionFinal reportErcoupe 415-C · Harrisonburg, VAThe pilot's improper engine starting procedure, resulting in an uncontrolled taxi, and collision with trees.NTSB SEA06CA101Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Vaughn, WAThe loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL06CA082Accident · Minor injuriesData collectionFinal reportErcoupe 415C · Crossville, TNInadequate maintenance inspection resulting in fuel system contamination going undetected resulting in a total loss of engine power while on final approach to land.NTSB SEA06CA051Accident · No injuriesData collectionFinal reportErcoupe 415-C · Arlington, WAThe pilot's excessive descent rate and his delay in taking action to reduce the descent rate which resulted in an in-flight collision with the runway during an emergency landing. Contributing factors were the total loss of engine oil pressure and the pilot's…