NTSB investigations: Aeronca 11AC, WA

7 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

NTSB investigations: Aeronca 11AC, WA per year, 1965–2026: 7 cases
1965	1
1976	2
1977	1
1991	1
2014	1
2016	1

Where

Open the map

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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 GAA16CA410Accident · No injuriesData collectionFinal reportAeronca 11AC · Gig Harbor, WAThe pilot's failure to maintain directional control during landing, and subsequent wing tip strike, which resulted in substantial damage to the rear spar.Jul 26, 2016 · N9791E · Substantial damage NTSB WPR14CA229Accident · No injuriesData collectionFinal reportAeronca 11AC · Tacoma, WAThe student pilot's improper application of rudder resulted in a loss of control during the landing roll and the flight instructor's inadequate oversight.Jun 4, 2014 · N9791E · Substantial damage NTSB SEA91LA083Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Port Orchard, WAThe loss of engine power due to contaminated fuel system.Apr 12, 1991 · N85948 · Substantial damage NTSB SEA77FYP17Accident · Minor injuriesClosedAeronca 11AC · Harrah, WAJan 20, 1977 · N9791E · Substantial damage NTSB SEA77DA001Accident · 1 fatalClosedAeronca 11AC · Medical Lake, WAOct 8, 1976 · N9053E · Destroyed NTSB SEA76DYE27Accident · No injuriesClosedAeronca 11AC · Waldron Island, WAMar 1, 1976 · N9448E · Substantial damage NTSB SEA66F0115Accident · No injuriesClosedAeronca 11AC · Bellevue, WAAug 22, 1965 · N9500E · Substantial damage