NTSB investigations: Ercoupe 415-C
10 cases on aircraft the registry lists as Ercoupe 415-C, where the first occurrence was “Loss of engine power”. 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 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 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\" = 350))
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" = 350))
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 SEA05LA087Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Roseburg, ORLoss of engine power for undetermined reasons. High vegetation was a factor.NTSB FTW03LA123Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Ranger, TXThe loss of engine power for an undetermined reason.NTSB FTW02LA160Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Hinton, OKFuel exhaustion due to a fuel cap leak. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI00LA162Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Joliet, ILthe engine failure for undetermined reasons. Factors were the low altitude, remedial action not possible by the pilot, and the ditch.NTSB CHI95LA004Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cloverdale, INthe total loss of engine power due to a blocked orifice in the fuel pump. A related factor is the rough/uneven terrain encountered during the forced landing.NTSB LAX91LA196Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · King City, CAThe total loss of engine power which resulted from the drain valve fitting on a newly installed gascolator dislodging during cruise flight.NTSB NYC85LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Sussex, NJThe acft experienced a loss of eng pwr during climb shortly after takeoff and was substantially damaged during the forced landing which resulted. The plt reported the eng coughed and lost pwr, however, when the throttle was pumped, pwr returned. Pwr was then…NTSB ANC84LA098Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Healy, AKShortly after lifting off from an airstrip, the eng lost power. The plt tried to make an emergency landing on a highway, but was unable to reach it. The acft was damaged when he landed in the tops of trees. The reason for the power loss was not found.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…