NTSB investigations: Champion 7ECA, OH
12 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 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1969 | 1 |
| 1970 | 2 |
| 1971 | 2 |
| 1974 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1986 | 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\" = 'OH' 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" = 'OH' 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 ATL86LA209Accident · Minor injuriesLimited investigationFinal reportChampion 7E6A · Alliance, OHDuring the second landing attempt, the pilot lost directional control and ground looped. The aircraft was substantially damaged and the pilot received minor injuries. The pilot did not report any aircraft problems. The pilot had completed a student pilot solo…NTSB CHI81FEG16Accident · Minor injuriesClosedBellanca 7ECA · Cedarville, OHNTSB CHI79FEI05Accident · No injuriesClosedChampion 7ECA · Auburn Corners, OHNTSB CHI74AC080Accident · 2 fatalClosedChampion 7ECA · Xenia, OHNTSB CHI72DEG14Accident · No injuriesClosedChampion 7ECA · Dayton, OHNTSB CHI72FEG11Accident · No injuriesClosedChampion 7ECA · Dayton, OHNTSB CHI71FGA12Accident · No injuriesClosedChampion 7ECA · Dayton, OHNTSB CHI71FGG06Accident · No injuriesClosedPiper PA-12 · New Lexingtn, OHNTSB CHI70F0075Accident · Minor injuriesClosedChampion 7ECA · W Carrollton, OHNTSB CHI68D0093Accident · Serious injuriesClosedChampion 7ECA · Wintersville, OHNTSB CHI67F0018Accident · No injuriesClosedChampion 7EC · Columbus, OHNTSB CHI66D0187Accident · No injuriesClosedChampion 7ECA · Dayton, OH