Skip to content

NTSB investigations: Ercoupe 415-C, FL

26 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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 ('0420322')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('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" = '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 ('0420322'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA21LA293Accident · Minor injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Frostproof, FLThe pilot’s loss of directional control during takeoff as a result of a child reaching for and manipulating the flight controls.Jul 18, 2021 · N3044H · Substantial damage NTSB ERA12CA111Accident · No injuriesData collectionFinal reportErcoupe 415-C · Panacea, FLThe pilot did not attain the proper touchdown point during landing, which resulted in a runway overrun.Dec 16, 2011 · N99576 · Substantial damage NTSB ERA12LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Mulberry, FLThe pilot’s failure to abort the takeoff after recognizing the airplane’s poor performance during the takeoff roll. Contributing to the passenger’s injuries was the pilot’s failure to provide a briefing on the use of the lapbelt, which delayed the passenger’s…Nov 19, 2011 · N99168 · Substantial damage NTSB NYC08CA297Accident · No injuriesData collectionFinal reportErcoupe 415-C · Sebring, FLA bird strike which substantially damaged the propeller and required the engine to be secured. Contributing to the accident was the damaged propeller.Aug 29, 2008 · N87376 · Substantial damage NTSB MIA08LA164Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Arcaida, FLThe pilot's failure to maintain a proper climb rate after takeoff.Aug 13, 2008 · N94339 · Substantial damage NTSB NYC08LA019Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stuart, FLA partial loss of engine power during cruise flight due to a partially blocked fuel line.Oct 24, 2007 · N94320 · Substantial damage 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.Jun 22, 2006 · N99355 · Destroyed NTSB MIA91LA118Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Green Cove Spgs, FLLoss of control while on approach to land due to failure of the pilot to maintain vs resulting in the airplane stalling and impacting the ground nose low.Apr 7, 1991 · N3025H · Substantial damage NTSB MIA87LA095Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Clearwater, FLThe private pilot attempted to reduce throttle and land but the throttle control did not reduce the power. He then landed and attempted to use the brakes to stop the aircraft but it slid off the end of the runway into a ditch. Post accident examination of the…Feb 26, 1987 · N93977 · Substantial damage NTSB MIA83LA188Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Melrose, FLThe plt took off on rwy 11 (elev 150 ft MSL) with a density alt of 1500 ft. he reported the wind was calm, but aprx 14 mi west at gainsville, FL, the 2052 EDT wind was from 250 deg at 9 KTS. During takeoff, the acft climbed aprx 75 ft, then settled into trees…Jul 24, 1983 · N99474 · Substantial damage NTSB MIA83LA118Accident · No injuriesLimited investigationFinal reportErcoupe G · Pempbroke Pines, FLThe acft collided with a tree during a forced landing after the engine lost power. Post accident investigation revealed that the fuel strainer was full of water and that the carburetor bowl contained one or two ounces of water. Draining of this water allowed…Apr 5, 1983 · N2175H · Substantial damage NTSB MIA82DA095Accident · No injuriesFinal reportErcoupe 415-C · Merritt Island, FLThe pilot suspected a partial loss of engine power shortly after lift-off. He cut the power to land on the remaining runway. The plane touched down on the right main and nose gear, and the nose gear collapsed. The plane skidded about 100 ft before coming to…Mar 29, 1982 · N94067 · Substantial damage NTSB MIA81FA027Accident · 2 fatalClosedErco 415-C · Lakeland, FLDec 21, 1980 · N2106H · 2 aircraft · Substantial damage NTSB MIA80FLD48Accident · No injuriesClosedErco 415-C · Lakeland, FLMar 22, 1980 · N3690H · Substantial damage NTSB MIA78FLA21Accident · No injuriesClosedErco 415-C · Live Oak, FLMar 21, 1978 · N87296 · Substantial damage NTSB MIA78FLA03Accident · No injuriesClosedErco 415-C · Lake City, FLOct 16, 1977 · N99166 · Substantial damage NTSB MIA77FLA33Accident · Minor injuriesClosedErco 415-C · Panama City, FLJun 2, 1977 · N86999 · Substantial damage NTSB MIA76DKT98Accident · No injuriesClosedErco 415-C · Opalocka, FLSep 26, 1976 · N365D · Substantial damage NTSB MIA76FKT92Accident · No injuriesClosedErco 415-C · Hialeah, FLAug 20, 1976 · N3101H · Substantial damage NTSB MIA76FLA62Accident · Minor injuriesClosedErco 415-C · Quincy, FLAug 11, 1976 · N99731 · Destroyed NTSB MIA76AM077Accident · 1 fatalClosedErco 415-C · Plant City, FLApr 10, 1976 · N2931H · Destroyed NTSB MIA74DKT24Accident · Minor injuriesClosedErco 415-C · P.Beach Grdn, FLSep 25, 1973 · N99241 · Substantial damage NTSB MIA71FLD39Accident · Serious injuriesClosedErco 415-C · Plymouth, FLDec 26, 1970 · N2931H · Substantial damage NTSB MIA70F0131Accident · No injuriesClosedErcoupe 415-D · Ft Lauderdale, FLAug 30, 1969 · N3271H · Substantial damage NTSB MIA69D0386Accident · No injuriesClosedErco 415-C · Fernandna Bch, FLJan 12, 1969 · N2095H · Substantial damage NTSB MIA66F0382Accident · No injuriesClosedErcoupe 415-C · Oveida, FLJan 3, 1966 · N2857H · Substantial damage