NTSB investigations: Aeronca 7AC, OK
15 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 | 1 |
|---|---|
| 1967 | 4 |
| 1969 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1994 | 1 |
| 2021 | 1 |
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 c.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA'
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 CEN21LA338Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Harrah, OKThe pilot’s decision to fly the airplane without a carburetor heat control in atmospheric conditions conducive to the development of serious carburetor icing, which resulted in a partial loss of engine power.NTSB FTW94FA074Accident · 1 fatalField investigationFinal reportAeronca 7AC · Tulsa, OKWas the inadvertent stall. Factors were the pilots failure to use carburetor heat when weather conditions existed that were conducive to carburetor icing, and his abrupt maneuver to avoid a light pole.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.NTSB FTW86FA086Accident · 1 fatalField investigationFinal reportCessna 172G · Blackwell, OKThe pilot of N5878R, a Cessna 172G, had no previous experience in formation flying. The pilot of N2603E, an Aeronca 7AC, stated he had many hours of formation flying in the military during world war ii and has made an occasional formation flight since that…NTSB FTW83LA256Accident · No injuriesLimited investigationFinal reportAeronca 7AC · El Reno, OKThe acft nosed over during a forced landing after the engine quit. The plt stated that when about 4 miles from the arpt at 200 ft the engine began losing power with the dropping from 2000 to 1500 RPM. He also stated that application of carburetor heat did not…NTSB FTW74FPM21Accident · Minor injuriesClosedAeronca 7AC · Madill, OKNTSB FTW74FPJ13Accident · Minor injuriesClosedAeronca 7AC · Wynnewood, OKNTSB FTW73DPJ04Accident · No injuriesClosedAeronca 7AC · Ponca City, OKNTSB FTW72FPM19Accident · No injuriesClosedAeronca 7AC · Tulsa, OKNTSB FTW70F0262Accident · No injuriesClosedAeronca 7AC · Tulsa, OKNTSB FTW68F0329Accident · Serious injuriesClosedAeronca 7AC · Kingfisher, OKNTSB FTW67F0644Accident · No injuriesClosedAeronca 7AC · Bartelesvile, OKNTSB FTW67F0623Accident · No injuriesClosedAeronca 7AC · Turley, OKNTSB FTW67D0440Accident · No injuriesClosedAeronca 7AC · Yukon, OKNTSB UNK64X2339Accident · Minor injuriesClosedAeronca 7AC · Calumet, OK