NTSB investigations: Aeronca 11AC
9 cases on aircraft the registry lists as Aeronca 11AC, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 2004 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0191102')
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\" = 250))
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 ('0191102')
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" = 250))
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 MIA04LA096Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Williston, FLThe pilot's failure to maintain airspeed (Vso) while maneuvering, which resulted in a stall/mush, an uncontrolled descent, and impact with terrain.NTSB NYC94LA152Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Schuylerville, NYthe pilots failure to maintain adequate airspeed, which resulted in a stall/mush.NTSB NYC94LA088Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Berwick, METhe pilot's inadequate preflight which fail to detect proper operation of the elevator which resulted in the loss of control inflight. A factor is inadequate maintenance which consisted of misrigging of the elevator flight controls.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.NTSB CHI91DEM06Accident · 1 fatalFinal reportAeronca 11-AC · Central Lake, MIA result of the pilot in command not maintaining aircraft control and not performing remedial action after the airplane entered the steep descent. A factor contributing to this accident was the pilot in command's lack of recent experience.NTSB NYC89FA003Accident · Serious injuriesField investigationFinal reportAeronca 11AC · Barnstead, NHThe Aeronca 11AC was maneuvering downwind for landing. The pilot made a left turn towards the runway to tighten the pattern. While in close proximity to a house and the runway, at a low altitude the pilot elected to make a steep left 270 degree turn, opposite…NTSB MKC87FA083Accident · Serious injuriesField investigationFinal reportAeronca 11AC · Stillwell, KSThe pilot stated that this flight was to be a photographic, pleasure trip involving two aircraft. After several aerial photos were taken of each other's aircraft, both airplanes landed at the accident airport. The PIC and his passenger then took-off while the…NTSB ATL86LMG02Accident · Serious injuriesFinal reportAeronca 11AC · Wallace, NCThe acft collided with the terrain following a loss of control during initial takeoff climb. The plt reported that after clearing trees at an alt of aprx 200 ft the acft drifted to the right. The tail of the acft then rose pushing the nose down until the acft…NTSB NYC84FA310Accident · 2 fatalField investigationFinal reportAeronca 11AC · Newbury, MAThe student plt had logged approximately 240 hrs of flying time. He was not certificated to carry pax. Witnesses stated that they observed the acft descend at a slow airspeed to an alt of 100 ft. the acft then made a steep bank turn to the right and impacted…