NTSB investigations: Aeronca 7AC, 1993
9 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\") = 1993
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") = 1993
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 ANC94LA025Accident · Serious injuriesLimited investigationFinal reportAeronca BL-7AC · Circle City, AKThe pilot in commands intentional flight into known adverse weather conditions which lead to an inadvertent aerodynamic stall of the aircraft. Factors contributing to the accident were the ice fog and the icing conditions.NTSB ANC94LA024Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Juneau, AKThe pilot in command's selection of a sight unsuitable for landing. A factor in the accident was the ditch on the beach.NTSB NYC93LA172Accident · 1 fatalLimited investigationFinal reportBellanca 7ECA · Ashland, NHThe pilot's improper decision to leave the airplane unattended with the engine operating.NTSB NYC93LA149Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Portsmouth, OHThe pilot's inadequate start procedure which resulted in the airplane taxiing unmanned and its subsequent collision with a building. A factor is the pilot's failure to obtain assistance.NTSB CHI93LA293Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Oshkosh, WIThe pilot-in-command's not maintaining directional control. Factors include a crosswind, the pilot-in-command's not attaining compensation for wind conditions, and his lack of experience in this type of airplane.NTSB CHI93LA239Accident · Serious injuriesLimited investigationFinal reportAeronca AC7B · Kearney, MOThe pilot in command's failure to maintain adequate airspeed and the aircraft exceeding maximum allowable gross weight.NTSB CHI93LA236Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Waukesha, WIThe pilot's failure to maintain airspeed above a stall.NTSB DEN93LA071Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Watkins, COTotal loss of power resulting from a blocked carburetor fuel filter. A factor was: soft terrain encountered during the forced landing.NTSB SEA93LA111Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Walla Walla, WAThe premature landing flare by the pilot which resulted in a hard landing and the pilot's failure to maintain airspeed above stall speed during the balked landing.