NTSB investigations: Aeronca 7AC, OR
15 cases on aircraft the registry lists as Aeronca 7AC. 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 | 3 |
|---|---|
| 1966 | 1 |
| 1971 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1992 | 2 |
| 2017 | 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\" = 'OR' 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 ('2110102'))
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" = 'OR' 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 ('2110102'))
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 GAA17CA288Accident · No injuriesData collectionFinal reportAeronca 7AC · Lebanon, ORThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB SEA93FA029Accident · 2 fatalField investigationFinal reportAeronca 7AC · Medford, ORThe failure of the pilot to maintain clearance from wires while buzzing.NTSB SEA92LA182Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Miltonfreewater, ORAn inadvertent stall while maneuvering in mountainous terrain. Factors include lack of experience in this type of operation.NTSB SEA88LA062Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Umpqua, ORWhile flying low over a river the aircraft struck unmarked telephone wires. An off-airport landing was made onto a cow pasture. During the landing the aircraft struck the ground nose first. Post acc inspection revealed telephone wire insulation wedged near…NTSB SEA83LA078Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Near Sisters, ORAccording to the plt, he began climbing after making a pass over a frozen lake & Near a youth camp. He reported that the acft entered a stall, then began to spin to the right at aprx 1000 ft AGL. He initiated corrective action, but the main gear hit the lake…NTSB SEA82DA151Accident · No injuriesFinal reportAeronca 7AC · 7nm So. Of Sale, ORImmediately after a soft field takeoff the pilot executed a right turn into a quartering tailwind condition in an effort to avoid trees beyond the upwind end of the field. The pilot reported that during this turn the aircraft stalled and struck the ground in…NTSB SEA81FA056Accident · 2 fatalClosedAeronca 7AC · Myrtle Creek, ORNTSB SEA79FYM67Accident · No injuriesClosedAeronca 7AC · Tigard, ORNTSB SEA78FYM31Accident · Minor injuriesClosedAeronca 7AC · Estacada, ORNTSB SEA77DYK10Accident · No injuriesClosedAeronca 7AC · Gold Beach, ORNTSB SEA71DYI24Accident · Minor injuriesClosedAeronca 7AC · Central Pt, ORNTSB SEA67F0146Accident · No injuriesClosedAeronca 7AC · North Bend, ORNTSB UNK64X3583Accident · Minor injuriesClosedAeronca 7AC · Chiloquin, ORNTSB UNK64X3549Accident · 1 fatalClosedAeronca 7AC · Tillamook, ORNTSB UNK64X1961Accident · Minor injuriesClosedAeronca 7AC · Burns, OR