NTSB investigations: Champion AERONCA 7FC
14 cases on aircraft the registry lists as Champion AERONCA 7FC. 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 | 2 |
|---|---|
| 1966 | 5 |
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1980 | 1 |
| 1987 | 1 |
| 2020 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110162'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110162'))
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 CEN20CA138Accident · No injuriesData collectionFinal reportChampion Aeronca 7FC · Hessel, MIThe pilot's loss of directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and impact with a snowbank.NTSB SEA87LA043Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7FC · Athol, IDThe pilot lost control of the aircraft during landing with the aircraft veering to the left of the runway centerline. The plt then elected to go-around and on the go-around the aircrafts main gear caught on a snow berm causing a loss of control in flight. The…NTSB SEA80DYP32Accident · No injuriesClosedAeronca 7FC · Grangeville, IDNTSB FTW76FPD16Accident · No injuriesClosedAeronca 7FC · Ft Worth, TXNTSB FTW73DPA22Accident · No injuriesClosedChampion 7FC · Denison, TXNTSB MIA72FKQ11Accident · Minor injuriesClosedAeronca 7FC · Collins, MSNTSB SEA70D0009Accident · No injuriesClosedChampion 7EC · Eagle Point, ORNTSB FTW67D0395Accident · Minor injuriesClosedAeronca 7FC · Houston, TXNTSB SEA67D0181Accident · No injuriesClosedAeronca 7FC · Blachly, ORNTSB SEA67D0063Accident · No injuriesClosedAeronca 7FC · Twin Falls, IDNTSB NYC66D0692Accident · Minor injuriesClosedChampion 7FC · Sharpsville, PANTSB LAX66F0256Accident · No injuriesClosedChampion 7FC · Santa Monica, CANTSB NYC66D0137Accident · Minor injuriesClosedAeronca 7FC · Sand Lake, NYNTSB MKC66F0152Accident · Minor injuriesClosedChampion 7FC · Farmington, MO