Skip to content

NTSB investigations: Aeronca 11AC, AK

17 cases on aircraft the registry lists as Aeronca 11AC. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'AK' 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 ('0191102')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'AK' 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 ('0191102'))
  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" = 'AK' 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 ('0191102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ANC13CA062Accident · No injuriesData collectionFinal reportAeronca 11AC · Kodiak, AKThe loss of engine power due to carburetor icing and the pilot's failure to continue the use of carburetor heat after experiencing carburetor ice.Jul 6, 2013 · N9118E · Substantial damage NTSB ANC00LA089Accident · Minor injuriesLimited investigationFinal reportAeronca 11BC · Wasilla, AKA loss of engine power due to the pilot's failure to use carburetor heat, and an inadvertent stall. A factor associated with the accident was the existence of carburetor icing conditions.Jul 15, 2000 · N9359E · Substantial damage NTSB ANC95LA074Accident · Serious injuriesLimited investigationFinal reportChampion 11BC-S · Anchorage, AKThe pilot's improper compensation for the wind conditions. Factors associated with the accident are gusty winds and associated downdrafts.Jun 11, 1995 · N86135 · Substantial damage NTSB ANC94LA003Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Kenney Lake, AKThe pilot's intentional VFR takeoff into instrument meteorological conditions which resulted in spatial disorientation and a loss of control. Factors in the accident were the weather and low light conditions.Oct 5, 1993 · N9230E · Destroyed NTSB ANC93LA150Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Galena, AKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain on which to make a forced landing.Aug 16, 1993 · N86361 · Substantial damage NTSB ANC91LA051Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Kahiltna Glac., AKA downdraft and the pilot's inadequate remedial action.Apr 9, 1991 · N3436E · Substantial damage NTSB ANC90FA052Accident · No injuriesField investigationFinal reportAeronca 11AC · Chugiak, AKFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind and snow covered terrain beside the runway.Apr 8, 1990 · N86060 · Substantial damage NTSB ANC85LA161Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Dillingham, AKThe pilot stated that approximately 200 ft into the rollout the right wing lifted into the air, veering the plane to the right losing directional control of the aircraft causing the aircraft to exit the runway into a gravel pit.Aug 25, 1985 · N86090 · Substantial damage NTSB ANC82DA077Accident · No injuriesFinal reportAeronca 11AC · Soldotna, AKThe student pilot was practicing takeoffs and landings. He stated that during a landing, the aircraft ground looped to the left, went off the runway and went into soft dirt. When the soft dirt was encountered, the landing gear and propeller were damage.Aug 28, 1982 · N9804E · Substantial damage NTSB ANC81DA115Accident · 2 fatalClosedAeronca 11AC · Haines, AKSep 20, 1981 · N86062 · Destroyed NTSB ANC78DAG23Accident · No injuriesClosedAeronca 11AC · Gulkana, AKJan 7, 1978 · N3178E · Substantial damage NTSB ANC76DAH09Accident · No injuriesClosedAeronca 11AC · Glennallen, AKMay 8, 1976 · N3183E · Substantial damage NTSB ANC76DAG28Accident · Minor injuriesClosedAeronca 11AC · Telida, AKDec 21, 1975 · N9015E · Substantial damage NTSB ANC71AA030Accident · 2 fatalClosedAeronca 11AC · Northway, AKNov 23, 1970 · N9192E · Substantial damage NTSB UNK68X0158Accident · No injuriesClosedAeronca 11BC · Nenana, AKAug 2, 1968 · N3458E · Substantial damage NTSB ANC68F0039Accident · Serious injuriesClosedAeronca 11AC · Dillingham, AKJul 21, 1967 · N9097E · Destroyed NTSB UNK64X3238Accident · No injuriesClosedAeronca 11AC · Eagle River, AKAug 6, 1964 · N3178E · Substantial damage