NTSB investigations: Ercoupe 415-C
12 cases on aircraft the registry lists as Ercoupe 415-C, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2005 | 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.\"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\" = 250))
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" = 250))
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 DFW05FA065Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Alexandria, LAThe pilot's loss of control while maneuvering to land.NTSB DEN00LA183Accident · 2 fatalLimited investigationFinal reportErcoupe 415-C · Tucumcari, NMloss of control during initial climb following takeoff by an unqualified person.NTSB CHI98LA094Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Wood Lake, NEthe pilot's intentional flight into adverse weather conditions, the wing ice, and the inadvertent stall. Factors contributing to this accident were the rain, freezing rain and low ceilings.NTSB CHI96LA311Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cambridge, ILThe pilot's failure to maintain control of the airplane while landing. A factor associated with the accident was the downdraft reported by the pilot.NTSB NYC94LA153Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Scriba, NYThe pilot's failure to maintain adequate airspeed which resulted in a stall and inflight collision with trees.NTSB LAX92LA335Accident · Serious injuriesLimited investigationFinal reportErcoupe 415C · Dunsmuir, CAThe pilot's failure to perform any preflight planning or preparation and selected the wrong runway. Factors relating to this accident was the existing tailwind, high density altitude.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.NTSB CHI91DEM01Accident · 1 fatalFinal reportErcoupe 415C · Shelby, MIThe pilot's continued flight into IMC.NTSB DEN90LA137Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Truth/Consequen, NMThe pilot's failure to maintain proper airspeed and obtain a proper climb rate after takeoff.NTSB LAX83FUG23Accident · No injuriesFinal reportErcoupe 415C · Hesperia, CAThe pilot reported that he was departing the apt, using the two preceding acft as referenced, as his acft had no taxi or landing lights. His acft was caught in the wake of the acft ahead, causing the pilot to lose control. The acft struck a bush aprx 100 feet…NTSB DEN83LA117Accident · Minor injuriesLimited investigationFinal reportAircoupe 415-C · Big Piney, WYThe pilot was practicing a short field takeoff. However, he held the elevator full back during the takeoff roll until the acft was 50 ft AGL, and then only released it slightly. According to the pilot, airspeed was 47 mph at 50 ft and about 57 mph at 70 ft.…NTSB MKC82FCG17Accident · 1 fatalFinal reportErcoupe 415-C · Topeka, KSThe aircraft crashed and burned during takeoff at 1303 CST. The pilot received second degree burns over 20 per cent of his body and expired on 3/9/82. Two sailplanes were damaged by impact and fire, and a third sailplane received fire damage. The pilot…