NTSB investigations: Aeronca 7AC, 1982
11 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\") = 1982
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") = 1982
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 LAX83LA065Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Calistoga, CAInitial information indicated that the acft landed with a quartering tailwind, ground looped & collided with a parked glider. A pilot/operator accident report was not received.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 SEA82DA128Accident · Serious injuriesFinal reportAeronca 7AC · Kent, WADuring practice steep turns the aircraft encountered its wake turbulence. Manuevers to regain control were not effective. The aircraft contacted trees in a nose low attitude.NTSB CHI82FA255Accident · 2 fatalField investigationFinal reportAeronca 7AC · Pine Valley Tow, WIThe acft was observed flying at a low altitude to a point 1/4 mi NE of the town over a wooded area & began a turn to the left. During the turn the bank continued to increase & then the nose dropped & the acft descended steeply into the trees. The police…NTSB FTW82DA277Accident · Serious injuriesFinal reportChampion 7AC · Justin, TXThe aerial application aircraft was returning to land when it collided with another aircraft that was on a straight-in final approach. The pilot of the other aircraft stated that he was below and ahead at about 150 feet AGL when the collision occurred. Both…NTSB MIA82DA149Accident · No injuriesFinal reportAeronca Champion 7AC · St. Petersburg, FLWhen the pilot tookoff to practice touch and go landings, he noticed a storm across the bay over tampa. He changed from runway 24 to runway 18 when he noticed a change in the wind direction. After completing three more touch and go landings, he elected to…NTSB LAX82DA233Accident · No injuriesFinal reportAeronca 7AC · Porterville, CAThe student pilot was on a local flight with two passengers. He reported that he was flying at about 600 ft AGL with 2100 RPM when he throttled back to 1500 RPM for about 10 seconds. He stated that when he advanced the throttle back to cruise power, the…NTSB CHI82FER22Accident · Serious injuriesFinal reportAeronca 7AC · Maple Plain, MNThe pilot reported that he circled the farm area several times to find a suitable landing site. He decided on a portion of the farmer's field next to the house and made a final pass to inspect the area. During the pass, he saw some trees and reportedly…NTSB FTW82FPG14Accident · 2 fatalFinal reportAeronca 7AC · Lehi, ARThe acft was believed to have departed the west memphis arpt at approximately 1900. The acft was found at approximately 2000 in an open field 2 mi sw of the arpt. The acft had collided with the ground very hard in a nose down condition. Neither occupant…NTSB ATL82FKG15Accident · 1 fatalFinal reportAeronca 7AC · Cedartown, GAThe acft stalled & crashed into trees from an altitude of approximately 60 feet AGL. The elevator trim tab control was found in the full nose up position.NTSB LAX82DVG15Accident · No injuriesFinal reportAeronca 7AC · Redding, CAWhen the pilot hand propped the aircraft to start the engine, it began rolling and struck Cessna 206, N732TQ.