NTSB investigations: Aeronca 11AC, AZ
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.
Cases per year
| 1970 | 2 |
|---|---|
| 1973 | 1 |
| 1986 | 1 |
| 1994 | 1 |
| 1999 | 1 |
| 2007 | 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.\"eventStateOrRegion\" = 'AZ' 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" = 'AZ' 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" 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 LAX07CA161Accident · No injuriesData collectionFinal reportAeronca 11AC · Glendale, AZThe private pilot's unstabilized approach and failure to maintain directional control during the landing roll, which resulted in a ground loop. Also causal was the instructor's inadequate supervision and failure to take remedial action.NTSB LAX00LA046Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Sedona, AZThe pilot's inadequate compensation for the crosswind conditions and subsequent failure to maintain directional control of the airplane.NTSB LAX94LA267Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Wickenburg, AZLoss of engine power for an unknown reason, and failure of the pilot to maintain airspeed, which resulted in an inadvertent stall and collision with the ground.NTSB LAX86LA132Accident · No injuriesLimited investigationFinal reportAeronca 11-AC · Standfield, AZAn Aeronca chief collided with a telephone pole on landing roll on a dirt road after a forced landing due to fuel exhaustion. The pilot reported that he was delayed approximately 45 minutes awaiting takeoff clearance by ground control with the engine running.…NTSB LAX74DUJ17Accident · No injuriesClosedAeronca 11AC · Scottsdale, AZNTSB LAX71DUJ26Accident · No injuriesClosedAeronca 11AC · Scottsdale, AZNTSB LAX70DUJ23Accident · No injuriesClosedAeronca 11AC · Tucson, AZ