NTSB investigations: Aeronca 7AC, KY
16 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 |
|---|---|
| 1965 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1977 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 2001 | 1 |
| 2008 | 1 |
| 2022 | 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\" = 'KY' 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" = 'KY' 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 ERA23LA002Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 7AC · Murray, KYThe incorrect (reverse) rigging of the elevator cables by maintenance personnel and their subsequent failure to verify that the rigging was correct during post-maintenance checks and the pilot's inadequate preflight check.NTSB MIA08CA145Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Greensburg, KYThe pilot's failure to maintain clearance from trees while maneuvering. Contributing to the accident was the low altitude maneuvers.NTSB NYC01FA145Accident · 2 fatalField investigationFinal reportAeronca 7DC · Fulton, KYThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/spin to the ground. A factor was the pilot's decision to fly from the rear seat, which reduced his visibility of critical flight instruments, including the…NTSB ATL85LA144Accident · No injuriesLimited investigationFinal reportBellanca 7AC · Germantown, KYDuring cruise flt over hilly terrain, the plt noted a power loss that he described as the eng 'dying back and then catching again.' He was unable to maintain alt & selected a field for a landing. During the apch, the left main gear & prop hit 2 power lines.…NTSB ATL84LA202Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Hogdenville, KYAccording to the plt, during a low turn to final a power loss occurred. The acft landed short in a plowed field and nosed over. Examination of the engine revealed no mechanical malfunctions.NTSB IAD77FLQ07Accident · Minor injuriesClosedAeronca 7AC · Elizabethtown, KYNTSB IAD74FLQ42Accident · 1 fatalClosedAeronca 7GCA · Allensville, KYNTSB IAD74FLQ06Accident · No injuriesClosedAeronca 7AC · Cromwell, KYNTSB IAD73FLQ30Accident · Minor injuriesClosedAeronca 7AC · Murray, KYNTSB CHI73AC051Accident · 2 fatalClosedAeronca 7AC · Georgetown, KYNTSB CHI72DLQ12Accident · Serious injuriesClosedAeronca 7AC · Baxter, KYNTSB CHI71FLQ17Accident · Minor injuriesClosedAeronca 7AC · Stanton, KYNTSB CHI70AC068Accident · 1 fatalClosedAeronca 7AC · Whitesburg, KYNTSB CHI68D0597Accident · No injuriesClosedAeronca 7AC · Princeton, KYNTSB CHI65F0125Accident · No injuriesClosedAeronca 7AC · Buffalo, KYNTSB UNK64X1552Accident · No injuriesClosedAeronca 7AC · Harlan, KY