NTSB investigations: Engineering & Research ERCOUPE 415-C, FL
12 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1975 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1990 | 1 |
| 2005 | 1 |
| 2007 | 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\" = 'FL' 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 ('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 c."eventStateOrRegion" = 'FL' 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 ('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 MIA07CA128Accident · Minor injuriesData collectionFinal reportEngineering & Research Ercoupe 415-C · Valkaria, FLThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent collision with the runway.NTSB MIA06CA027Accident · No injuriesData collectionFinal reportErcoupe 415C · Wiersdale, FLThe pilot's improper planning and failure to abort the takeoff in sufficient time which resulted in the airplane overrunning the runway and nosing over.NTSB MIA90FA191Accident · Serious injuriesField investigationFinal reportErco 415 · Titusville, FLWas partial loss of engine power due to foreign object obstruction of the inlet of the carburetor.NTSB MIA83LA166Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Yulee, FLThe plt stated that during takeoff, the acft entered a 'right turn' after it had climbed appx 25 ft above the rwy. Reportedly, full control inputs to the left failed to correct the right bank. When the plt saw the acft heading for trees to the right, he…NTSB MIA82DA171Accident · No injuriesFinal reportEngineering & Research 415-C · Clearwater, FLThe pilot reported that after he took off on runway 35R, he turned out to the northeast. He reported that when he reached 900 ft, the engine stalled and restarted. He notified the tower and was cleared to land on runway 09. A witness reported observing the…NTSB MIA80FLD47Accident · Minor injuriesClosedErco 415-C · Sarasota, FLNTSB MIA76DLA09Accident · No injuriesClosedErco 415-C · Pensacola, FLNTSB MIA72FLA33Accident · No injuriesClosedErco 415-C · Keystone Hts, FLNTSB MIA72DLD44Accident · No injuriesClosedErco 415-C · Chuluota, FLNTSB MIA72FKT19Accident · No injuriesClosedErco 415-C · Punta Gorda, FLNTSB MIA67D0228Accident · No injuriesClosedErcoupe 415-C · Zephyrhills, FLNTSB MIA66F0024Accident · Minor injuriesClosedErcoupe 415C · St Petersburg, FL