NTSB investigations: Champion 7ECA, VA
9 cases on aircraft the registry lists as Champion 7ECA. 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 |
|---|---|
| 1967 | 1 |
| 1970 | 2 |
| 1971 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1996 | 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\" = 'VA' 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 ('21101NN'))
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" = 'VA' 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 ('21101NN'))
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 IAD98LA038Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Castlewood, VAThe pilot's failure to achieve the proper touchdown point and the delayed execution of the go around. A contributing factor was the fence.NTSB IAD96LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Ashland, VAan undetermined braking anomaly and/or failure of the pilot to maintain directional control of the airplane during the landing.NTSB ATL83FA086Accident · Minor injuriesField investigationFinal reportChampion 7ECA · Quinton, VAThe acft crashed shortly after takeoff following an engine malfunction. The student was taking basic instruction in tailwheel acft and had made one landing. Following the 2nd takeoff, at 150-200 feet AGL, the engine lost power with the RPM dropping to the…NTSB ATL82DA259Accident · No injuriesFinal reportChampion 7ECA · Middletown, VADuring approach to an uphill & narrow strip, animals crossed the rwy. A go-around was initiated & the acft drifted into trees.NTSB IAD71DID27Accident · No injuriesClosedChampion 7ECA · Clarksville, VANTSB IAD71AI015Accident · 1 fatalClosedChampion 7ECA · Coles Point, VANTSB IAD70FID07Accident · Minor injuriesClosedChampion 7ECA · Milford, VANTSB DIA68A0010Accident · 2 fatalClosedCessna 182 · Tangier, VANTSB NYC66F0224Accident · No injuriesClosedChampion 7ECA · Foxwells, VA