NTSB investigations: Ercoupe 415-C, KS
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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1982 | 2 |
| 1984 | 1 |
| 1993 | 1 |
| 2000 | 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\" = 'KS' 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" = 'KS' 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 CHI00LA273Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Parsons, KSthe pilot not maintaining clearance from the fence post and not attaining the proper touchdown point. A factor was the fence post.NTSB CHI93LA186Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Derby, KSThe pilot in command's misjudged approach to landing.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 MKC82DA172Accident · No injuriesFinal reportErcoupe 415C · Andover, KSPilot reported he was taxiing and turned to avoid animals. Aircraft then collided with a tree. He had given two other versions verbally of how the damage occurred.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…NTSB MKC76FCQQ1Accident · No injuriesClosedErco 415-C · St Marys, KSNTSB MKC75DCQ34Accident · No injuriesClosedErco 415-C · Dodge City, KSNTSB MKC75DCQ17Accident · No injuriesClosedErco 415-C · Hill City, KSNTSB MKC72DCQ45Accident · Minor injuriesClosedErcoupe 415C · Minneapolis, KSNTSB MKC72AK027Accident · 2 fatalClosedErco 415-C · Topeka, KSNTSB MKC70A0004Accident · 1 fatalClosedErco 415-C · Paola, KSNTSB MKC69F0223Accident · No injuriesClosedErcoupe 415-C · South Haven, KSNTSB MKC67F0083Accident · No injuriesClosedErcoupe 415-C · Tribune, KSNTSB MKC66F0019Accident · No injuriesClosedErcoupe 415C · Wellington, KS