NTSB investigations: Ercoupe 415-C, MO
9 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.
Cases per year
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1998 | 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\" = 'MO' 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" = 'MO' 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" 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 CHI98LA248Accident · Serious injuriesLimited investigationFinal reportForney 415-C · Laurie, MOthe jammed aileron and elevator controls for undetermined reasons.NTSB CHI93LA306Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Liberty, MOThe pilot's failure to maintain adequate aircraft control during the emergency landing. A factor is the pilot's lack of experience in the aircraft.NTSB CHI90LA207Accident · No injuriesLimited investigationFinal reportAircoupe F-1 · Washington, MOFailure of the other aircraft's pilot to maintain an adequate visual lookout prior to turning to final. A factor in the accident was the restricted visual lookout for this aircraft's pilot.NTSB MKC88LA113Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Florence, MOWhile on a personal flight, PIC said he began to lose engine power. He elected to make a precautionary ldg in a farm field, and during the roll out, the nose wheel struck a ditch. Post flt examination failed to reveal any cause for the partial power loss.NTSB MKC86LA066Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Versailles, MOThe plt reports that he was hand propping the eng. He said the eng did not start on the first attempt and he primed it a second time. On the second try the eng started and the acft got away from the plt, taxied about 75 ft and collided with trees. The plt…NTSB MKC76AK080Accident · 1 fatalClosedErco 415-C · Saint James, MONTSB MKC75AK049Accident · 1 fatalClosedErco 415-C · Fulton, MONTSB MKC70F0238Accident · Minor injuriesClosedErco 415-C · Oakville, MONTSB MKC69F0150Accident · Serious injuriesClosedErcoupe 415-C · New London, MO