NTSB investigations: Ercoupe 415-C, PA
14 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1968 | 2 |
| 1969 | 1 |
| 1971 | 3 |
| 1972 | 1 |
| 1974 | 2 |
| 1987 | 2 |
| 2017 | 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\" = 'PA' 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" = 'PA' 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 ERA18LA007Accident · No injuriesLimited investigationFinal reportErcoupe 415 · Centre Hall, PAThe partial loss of engine power due to the No. 2 cylinder exhaust valve being stuck.NTSB NYC87LA224Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · York, PAThe Ercoupe model 415 experienced a loss of power in flight. The pilot made a forced landing in a field. He went under some power lines, however, he could not avoid the telephone lines and went through them. The pilot received serious injuries and the…NTSB NYC87LA177Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Quakertown, PAThe pilot came in high and fast on the approach. He reduced pwr initially to increase rate of descent. As he apched trees, he applied power to stop the descent, but collided with the tops of the trees. The acft yawed to the right about 30 degrees and touched…NTSB NYC75FHD27Accident · Minor injuriesClosedErco 415-C · West Chester, PANTSB NYC74FGM42Accident · Serious injuriesClosedErco 415-D · Bethel Park, PANTSB NYC73AN003Accident · 1 fatalClosedErco 415-C · Mcdonald, PANTSB NYC72FHA14Accident · No injuriesClosedErco 415-C · Doylestown, PANTSB NYC72FGM09Accident · Serious injuriesClosedErco 415C · Irwin, PANTSB NYC71FHA46Accident · Minor injuriesClosedErco 415-C · Warrington, PANTSB NYC70D0047Accident · No injuriesClosedErco 415-C · Bradford, PANTSB NYC69D0110Accident · Minor injuriesClosedErco 415-C · Tarentum, PANTSB NYC69D0024Accident · No injuriesClosedErcoupe 415-C · Tunkhannock, PANTSB NYC66D0453Accident · Minor injuriesClosedErcoupe 415-C · Londonderry Tp, PANTSB UNK64X3883Accident · Minor injuriesClosedErcoupe 415C · Easton, PA