NTSB investigations: Aeronca 7AC, 2006
3 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\") = 2006
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") = 2006
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 DEN06LA099Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Parker, COthe flight instructor's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and subsequent impact with terrain. Contributing factors were the high density altitude, rising terrain, and improper in-flight planning.NTSB SEA06LA130Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Snohomish, WAThe loss of engine power for undertermined reasons. Conditions for carburetor icing were present at the time of the accident. Factors included the fence and the berm.NTSB NYC06CA096Accident · No injuriesData collectionFinal reportAeronca 7AC · Haverhill, NHThe flight instructor's inadequate preflight planning, which resulted in a forced landing and subsequent impact with a sign.