Skip to content

NTSB investigations: Aeronca 11AC, CA

28 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

19652026

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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 WPR24LA261Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Winchester, CAA total loss of engine power due to a fatigue fracture of the crankshaft.Jul 27, 2024 · N86270 · Substantial damage NTSB WPR22LA099Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Napa, CAThe loss of engine power for undetermined reasons, which resulted in an off-airport landing on unimproved terrain.Feb 8, 2022 · N9500E · Substantial damage NTSB WPR20CA058Accident · No injuriesData collectionFinal reportAeronca 11AC · San Diego, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind, which resulted in a collision with an airport sign and subsequent ground-loop.Nov 25, 2019 · N9510E · Substantial damage NTSB WPR12LA367Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Pacoima, CAA total loss of engine power on approach for landing due to a combination of the low fuel level and fuel contamination.Aug 25, 2012 · N9409E · Substantial damage NTSB LAX91LA201Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Madera, CAThat the pilot failed to properly recover from a bounced landing. Contributing to this accident was the pilot's lack of experience in the airplane.May 6, 1991 · N86295 · Substantial damage NTSB LAX90LA003Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Penn Valley, CAFailure of the pilot to maintain directional control during the landing roll-out, which resulted in an inadvertent ground swerve. Uneven terrain beside the runway was a factor.Oct 5, 1989 · N85837 · Substantial damage NTSB LAX88LA092Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lakeport, CADuring ldg rollout the acft veered off the rwy, went into a ditch & collided with terrain causing substantial damage. The surface winds were estimated at only 5 KTS. The plt acknowledged that the accident might have been prevented if he had been less…Jan 20, 1988 · N9416E · Substantial damage NTSB LAX82IA086Incident · Minor injuriesIncident investigationFinal reportAeronca 11AC · Weldon, CAPilot stated that while at cruise, the engine began running rough and a precautionary landing was executed. During the touchdown, the aircraft struck a bump disconnecting the steering springs. He then lost directional control, striking a tree and fence on the…Feb 27, 1982 · N9361E · Minor damage NTSB LAX78DVA44Accident · No injuriesClosedAeronca 11AC · Shafter, CAMay 20, 1978 · N9716E · Substantial damage NTSB OAK76DVD49Accident · No injuriesClosedAeronca 11AC · Willits, CAAug 25, 1976 · N9332E · Substantial damage NTSB OAK76AP025Accident · 2 fatalClosedAeronca 11AC · Lincoln, CANov 2, 1975 · N3191E · Destroyed NTSB OAK74DVA60Accident · No injuriesClosedAeronca 11AC · Oakdale, CAApr 11, 1974 · N85838 · Substantial damage NTSB LAX74DVA43Accident · No injuriesClosedAeronca 7AC · Taft, CAFeb 3, 1974 · N9716E · Substantial damage NTSB LAX72AL056Accident · 2 fatalClosedAeronca 11AC · Carpinteria, CAMay 17, 1972 · N86050 · Destroyed NTSB OAK72FVG18Accident · Serious injuriesClosedAeronca 11AC · Sacramento, CAAug 18, 1971 · N9285E · Substantial damage NTSB LAX71DUG96Accident · No injuriesClosedAeronca 11AC · Upland, CAApr 4, 1971 · N9080E · Substantial damage NTSB LAX71DVA42Accident · No injuriesClosedAeronca 11AC · Lone Pine, CADec 5, 1970 · N86312 · Substantial damage NTSB OAK71AP011Accident · 1 fatalClosedAerona 11AC · Mt.Hamilton, CAAug 24, 1970 · N9384E · Destroyed NTSB OAK70DVG05Accident · No injuriesClosedAeronca 11AC · Loomis, CAMar 20, 1970 · N9231E · Substantial damage NTSB OAK69D0167Accident · Minor injuriesClosedAeronca 11AC · Schellville, CAOct 7, 1968 · N9214E · Substantial damage NTSB OAK68F0037Accident · No injuriesClosedAeronca 11AC · Lake Tahoe, CAJul 20, 1967 · N9730E · Substantial damage NTSB LAX67D0435Accident · No injuriesClosedAeronca 11AC · Nipton, CAMar 18, 1967 · N85833 · Substantial damage NTSB LAX67D0431Accident · Serious injuriesClosedAeronca 11AC · Corona, CAMar 12, 1967 · N86337 · Substantial damage NTSB OAK67D0179Accident · Minor injuriesClosedAeronca 11AC · Hilt, CADec 15, 1966 · N3509E · Substantial damage NTSB OAK66D0301Accident · No injuriesClosedAeronca 11AC · Hanford, CAMay 30, 1966 · N86150 · Substantial damage NTSB LAX66D0261Accident · No injuriesClosedAeronca 11AC · Santa Susana, CAFeb 20, 1966 · N9669E · Substantial damage NTSB OAK66D0103Accident · No injuriesClosedAeronca 11AC · Loma Prieta, CAAug 22, 1965 · N86356 · Substantial damage NTSB OAK66F0064Accident · No injuriesClosedAeronca 11AC · Vacaville, CAJul 3, 1965 · N3191E · Substantial damage