NTSB investigations: Aeronca 7AC
14 cases on aircraft the registry lists as Aeronca 7AC, where the first occurrence was “Loss of engine power”. 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
| 1982 | 1 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2005 | 3 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110102')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2110102')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 SEA06CA014Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Yelm, WAThe complete loss of engine power during the initial climb for undetermined reasons, and the excessive descent rate during the ensuing forced landing.NTSB DEN06LA003Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Berthoud, COthe pilot's improper in-flight decision making which resulted in loss of engine power due to fuel exhaustion. Contributing factors are the transmission wires and the metal pole.NTSB LAX05CA320Accident · No injuriesData collectionFinal reportAeronca 7AC · Snelling, CAthe loss of engine power for undetermined reasons.NTSB NYC00LA091Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Pawling, NYLoss of engine power for undetermined reasons.NTSB BFO95LA083Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Warren, OHa loss of engine power/performance for undetermined reasons. Related factors were: the pilot exceeding the airplane's maximum takeoff weight, carburetor icing conditions, a tailwind, and high temperature.NTSB MIA95LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Venice, FLThe loss of engine power for undetermined cause. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB CHI92LA225Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Whitman, NEWater contamination in the fuel and low magneto output.NTSB ANC91LA101Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Chataniak Vly, AKPartial loss of engine power for an undetermined reason.NTSB NYC86FA182Accident · 1 fatalField investigationFinal reportAeronca 7AC · Durhamville, NYAircraft departed rwy 35 at kamp airport, climbed to about 200 feet, turned right, stalled and crashed vertically into the ground. A witness said that the aircraft climbed, the engine sputtered, and then stopped. No preimpact malfunction/failure was…NTSB NYC86FA140Accident · 2 fatalField investigationFinal reportAeronca 7AC · Chaumont, NYThe pilot departed his private strip and crashed about 5 minutes later in a steep nose down attitude. Over 50 per cent of the fluid in the carburetor was a contaminant.NTSB ATL85LA187Accident · No injuriesLimited investigationFinal reportChampion 7AC · Barnardsville, NCDuring a supervised solo x-country flt, the student acft experienced a loss of pwr at cruise. After reaching his first check point, the student reversed course because he departed on the wrong heading. Before reaching the first check point for the second…NTSB MKC85LA004Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Carlisle, ARThe acft collided with a piece of farm equipment during a force landing following engine failure. Investigation revealed that the plt was flying the acft to hazen, AR, to show it to his father when the engine failed. Examination of the wreckage failed to…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 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…