NTSB investigations: Aeronca 7AC, 1989
10 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\") = 1989
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") = 1989
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 NYC90LA023Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Friendsville, PAThe pilot failed to maintain airspeed and stalled the aircraft.NTSB ATL89LA215Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Semmes, ALImproper replacement of the fuel cap gasket by the pilot, which resulted in a blocked fuel cap vent and fuel starvation. Trees in the emergency landing area contributed to aircraft damage.NTSB ATL89LA211Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Screven, GAFailure of maintenance personnel to correct right brake adjustment problems during brake repairs which led to a failure of the right brake, and the pilot's delay in taking remedial action to correct the veering initiated by the brake failure.NTSB LAX89LA261Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Rio Linda, CAFailure of the pilot to maintain proper runway alignment during an aborted landing. Related factors were: a false airspeed indication, the pilot's lack of familiarity with the aircraft, his improper use of carburetor heat, his diverted attention, and the…NTSB MIA89LA208Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Homestead, FLImproper repair of the fuel cap (seal) by the pilot, which resulted in a blocked fuel system (cap) vent and subsequent fuel starvation, and his failure to see-and-avoid the telephone line. The telephone (transmission) line was a contributing factor.NTSB FTW89LA140Accident · 2 fatalLimited investigationFinal reportAeronca 7AC · Gueydan, LAThe pilot's inadvertent spin entry at pattern altitude which resulted in ground collision.NTSB SEA89LA133Accident · No injuriesLimited investigationFinal reportAeronca 7AC · American Falls, IDAn engine failure due to stripped and broken teeth on a magneto drive gear in the accessory gear box. A soft field caused the nose over during the forced landing.NTSB MKC89LA120Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Alexandria, MNThat proper starting procedures were not followed by the pilot in command and the aircraft was not tied down.NTSB BFO89LA034Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Indian Head, MDPilot failed to maintained directional control during recovery from a hard landing.NTSB FTW89LA069Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Catoosa, OKCarburetor ice and improper use of carburetor heat. Factors related to the occurrence were: carburetor icing conditions and rough/uneven terrain.