NTSB investigations: Aeronca 7AC, ME
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 | 1 |
|---|---|
| 1968 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1991 | 1 |
| 2009 | 1 |
| 2024 | 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\" = 'ME' 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" = 'ME' 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 ERA24LA334Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Topsham, MEA total loss of engine power due to carburetor icing as a result of the pilot’s delayed application of carburetor heat.NTSB ERA09LA397Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Auburn, MEA loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance inspection of the airplane and engine's fuel system.NTSB NYC91FA154Accident · 2 fatalField investigationFinal reportAeronca 7BCM · Millinocket, MEFailure of the pilot to maintain adequate airspeed, while maneuvering for a precautionary landing on a road, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's improper replacement of an oil temperature gage, and a…NTSB NYC83LNC02Accident · Serious injuriesFinal reportAeronca 7AC · Johnson Pond, METhe acft lifted off from the surface of Johnson Pond and was climbing over trees when the plt made a sharp turn and the acft struck a tree. The acft then impacted the ground and was destroyed by impact and fire.NTSB NYC81FNC17Accident · Minor injuriesClosedAeronca 7BCM · Dexter, MENTSB NYC73DNC36Accident · Minor injuriesClosedAeronca 7AC · Northeast Hbr, MENTSB NYC71DNC31Accident · No injuriesClosedAeronca 7DC · Berwick, MENTSB NYC68D0402Accident · No injuriesClosedAeronca 7AC · Madawaska, MENTSB UNK64X3975Accident · No injuriesClosedAeronca 7AC · West Newfield, ME