NTSB investigations: Aeronca 7AC, 2004
7 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 | 79 |
|---|---|
| 1965 | 69 |
| 1966 | 49 |
| 1967 | 44 |
| 1968 | 48 |
| 1969 | 44 |
| 1970 | 34 |
| 1971 | 33 |
| 1972 | 37 |
| 1973 | 23 |
| 1974 | 32 |
| 1975 | 24 |
| 1976 | 20 |
| 1977 | 26 |
| 1978 | 20 |
| 1979 | 16 |
| 1980 | 9 |
| 1981 | 17 |
| 1982 | 11 |
| 1983 | 12 |
| 1984 | 12 |
| 1985 | 12 |
| 1986 | 12 |
| 1987 | 7 |
| 1988 | 10 |
| 1989 | 10 |
| 1990 | 4 |
| 1991 | 9 |
| 1992 | 6 |
| 1993 | 9 |
| 1994 | 8 |
| 1995 | 10 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 5 |
| 1999 | 1 |
| 2000 | 7 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 5 |
| 2004 | 7 |
| 2005 | 6 |
| 2006 | 3 |
| 2007 | 8 |
| 2008 | 4 |
| 2009 | 9 |
| 2010 | 5 |
| 2011 | 8 |
| 2012 | 5 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 5 |
| 2019 | 2 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 9 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 6 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 2004
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 year(c."eventDate") = 2004
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 ATL04CA169Accident · No injuriesData collectionFinal reportAeronca 7AC · Spring Hope, NCThe binding of the right aileron control cable, which resulted in a loss in aileron control, and subsequent collision with trees and terrain.NTSB DEN04CA100Accident · No injuriesData collectionFinal reportAeronca 7AC · Limon, COthe pilot's inadequate preflight planning/preparation. A contributing factor was the soft terrain in the takeoff area.NTSB FTW04LA124Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Fort Stockton, TXThe pilot's improper leaning of the fuel/air mixture in-flight, which resulted in a loss of engine power. Factor were the wind gusts and the crosswind.NTSB CHI04CA109Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Flushing, MIThe pilot's failure to maintain airspeed while on final approach, resulting in an inadvertent stall at a low altitude.NTSB LAX04LA192Accident · No injuriesLimited investigationFinal reportAeronca Champ 7AC · Hayward, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB ATL04CA095Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Carthage, TNThe pilot's failure to maintain visual lookout and clearance while maneuvering resulting in an in-flight collision with wires and subsequent collision with water.NTSB CHI04LA061Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Prairieville, MIThe pilot's failure to maintain altitude/clearance from the transmission wires during final approach. Factors to the accident were the unmarked transmission wires and their support poles.