Final NTSB investigations: Aeronca 7FC
16 cases on aircraft the registry lists as 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
| 1964 | 4 |
|---|---|
| 1965 | 3 |
| 1966 | 2 |
| 1967 | 2 |
| 1970 | 1 |
| 1986 | 1 |
| 2018 | 1 |
| 2025 | 1 |
| 2026 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110124'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110124'))
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 WPR26LA165Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7FC · Bend, ORThe pilot’s failure to maintain directional control during landing roll. Contributing to the accident was the rotor wash from a nearby helicopter.NTSB ERA25LA340Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Jackson, OHThe pilot’s failure to maintain directional control of the airplane during a touch-and-go landing.NTSB ERA19CA002Accident · Serious injuriesData collectionFinal reportChampion 7FC · Myakka City, FLThe pilot's failure to maintain clearance from an obstacle during takeoff.NTSB MKC86LA068Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Lake City, ARThe flight instructor and his student touched down on the newly constructed private dirt strip in the airplane and rolled for 610 feet before the main gear bogged down. The nosewheel then cocked sideways and the airplane rolled forward to the inverted…NTSB SEA70AS032Accident · 1 fatalClosedAeronca 7AC · Snohomish, WANTSB SEA68F0116Accident · No injuriesClosedChampion 7FC · Billings, MTNTSB CHI67F0480Accident · Minor injuriesClosedAeronca 7FC · Walbridge, OHNTSB MKC67F0330Accident · 1 fatalClosedChampion 7FC · Forest Lake, MNNTSB CHI66F0607Accident · No injuriesClosedChampion 7FC · Circleville, OHNTSB NYC66D0159Accident · Minor injuriesClosedChampion 7FC · Easton, MDNTSB LAX66D0023Accident · No injuriesClosedChampion 7FC · San Diego, CANTSB NYC66D0111Accident · No injuriesClosedChampion 7FC · Laytonsville, MDNTSB UNK64X4058Accident · Minor injuriesClosedChampion 7FC · Humacao, PRNTSB UNK64X2729Accident · Minor injuriesClosedChampion 7FC · Blaine, MNNTSB UNK64X1316Accident · No injuriesClosedChampion 7FC · Miamisburg, OHNTSB UNK64X1267Accident · 2 fatalClosedChampion 7FC · Tortugas, NM