NTSB investigations: Ercoupe 415-C
18 cases on aircraft the registry lists as Ercoupe 415-C, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 2 |
| 1992 | 3 |
| 1996 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0420322')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0420322')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 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 IAD04LA039Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Pemberton, NJA total loss of engine power for undetermined reasons.NTSB ATL03FA128Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Rome, GAA loss of engine power due to fuel system contamination (water). Also causal was the pilot's loss of control for undetermined reasons.NTSB LAX02FA157Accident · Serious injuriesField investigationFinal reportErcoupe 415C · El Cajon, CAfuel starvation due to the mechanic's failure to properly tighten a fuel line fitting on the engine driven fuel pump, which led to a depletion of the fuel in the header tank. The mechanic's self induced pressure to complete the job prior to leaving on…NTSB DEN01LA065Accident · No injuriesLimited investigationFinal reportErco 415-C · Ivins, UTThe unsuitable terrain on which to make a forced landing. A contributing factors was the carburetor icing conditions.NTSB LAX96LA282Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Page, AZdecision of the pilot to operate the airplane with an inoperative transfer pump and inaccurate fuel consumption calculations.NTSB CHI93LA005Accident · Minor injuriesLimited investigationFinal reportUnivair 415C · Waukesha, WIThe pilot's inadequate remedial actions and his misjudged emergency procedure (approach to landing).NTSB LAX92LA272Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Santa Clarita, CAFuel starvation caused by the inflight separation of the fuel gascolator bowl due to improper component installation.NTSB FTW92LA083Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Whitehouse, TXThe pilot's inadequate preflight inspection and the engine power loss due to fuel contamination with water. A factor was the lack of suitable terrain available for the forced landing.NTSB LAX91FA334Accident · 1 fatalField investigationFinal reportErcoupe 415C · Rubidoux, CAThe mechanic's improper installation of the magnetos and the pilot's failure to maintain flying speed. Factors related to this accident are the pilot's inadvertent stall and the residential area.NTSB LAX91LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Pixley, CAThe failure of the pilot to use carburetor heat in carburetor icing conditions. Contributing to the accident was the lack of experience in the accident airplane make and model.NTSB SEA90LA017Accident · No injuriesLimited investigationFinal reportErcoupe 415D · Vancouver, WAThe pilot's inadvertant leaning of the fuel mixture to near idle cutoff, causing the engine to quit.NTSB ATL88LA183Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Whiteville, NCThe student plt reported that the engine began to skip and lose pwr about 20 minutes after departure. The engine subsequently lost all pwr and the student made a forced ldg in a plowed field. The airplane nosed over during the ldg. Post-crash exam of the…NTSB LAX86LA266Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Planada, CAThe plt reported the eng coughed during cruise flt at an alt of 2000 ft AGL. He applied carburetor heat and the eng coughed again and lost power. The plt made a forced landing in a plowed field. The landing gear dug into the terrain and the acft nosed over.…NTSB MKC84LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415C · N. Stillwell, KSAfter an eng power loss during takeoff climb, the plt landed the acft on the remaining runway. The hard landing resultedin a nose gear collapse. Post accident investigation revealed that the acft had only flown once in 7 months. The old automotive fuel had…NTSB FTW83LA206Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Prague, OKAfter purchasing the acft, the new owner (a student plt) had asked his uncle (reportedly an experienced plt) to fly his acft home. During the flt, the eng lost power shortly after the plt leveled off at 4000 ft MSL (aprx 3000 ft AGL). There was no suitable…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…