NTSB investigations: Aeronca 7CCM
5 cases on aircraft the registry lists as Aeronca 7CCM, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1994 | 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 ('2110110')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 ('2110110')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 NYC94LA099Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Taunton, MAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was unfavorable winds.NTSB NYC90LA113Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Rumford, METhe pilot made a steep turn to avoid the shore line and inadvertently stalled. Factors related to the accident were: the pilots decision to takeoff with a canoe strapped to one of the floats and his lack of experience in carrying a canoe on the floats.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…