NTSB investigations: Aeronca 7CCM, AK
8 cases on aircraft the registry lists as Aeronca 7CCM. 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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1972 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 2018 | 1 |
| 2025 | 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\" = 'AK' 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 ('2110110'))
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" = 'AK' 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 ('2110110'))
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 ANC25LA026Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7CCM · Kenai, AKA total loss of engine power due to carburetor icing as a result of the pilot’s inadequate use of carburetor heat.NTSB GAA18CA398Accident · No injuriesData collectionFinal reportAeronca 7CCM · Palmer, AKThe pilot's improper landing flare, which resulted in a hard landing, an attempted go-around, and a subsequent nose-over.NTSB ANC87LA096Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Mcneil Cove, AKThe pilot and his passenger were flying at approximately 150 feet above the water near the shoreline when the pilot made a steep left climbing turn. The airplane stalled and crashed into the water. The pilot was not rated to fly seaplanes. No mechanical…NTSB ANC84FA132Accident · 2 fatalField investigationFinal reportAeronca 7CCM · Kotzebue, AKThe plt & one pax departed on a pleasure flt from kiana, AK on 8/1/84. Four days later, the plt's mother traveled to Kotzebue, AK, to look for her son. She was unable to locate him & notified the FAA. A search was initiated, & on 8/6/84,the acft was located…NTSB ANC83LA163Accident · No injuriesLimited investigationFinal reportAeronca 7AC Champ · Seldovia, AKThe acft overturned on takeoff due to turbulent wind conditions. The pilot reported the wind was from 243 degrees at 16 KTS. No gusts. He stated also that severe turbulence existed and contributed to the accident. The arpt manager said thatthe acft took off…NTSB ANC73DAG72Accident · No injuriesClosedAeronca 7CCM · Anchorage, AKNTSB ANC72FAG01Accident · No injuriesClosedAeronca 7CCM · Kodiak, AKNTSB ANC71DAG61Accident · No injuriesClosedAeronca 7CCM · Willow, AK