NTSB investigations: Aeronca 11AC, TX
14 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1989 | 1 |
| 1999 | 2 |
| 2012 | 1 |
| 2018 | 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\" = 'TX' 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" = 'TX' 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 GAA18CA536Accident · No injuriesData collectionFinal reportAeronca 11AC · Midland, TXThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB CEN12CA595Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Comfort, TXThe pilot did not maintain control of the airplane after takeoff, which resulted in an inadvertent stall.NTSB FTW99LA267Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Van Horn, TXA restriction within the auxiliary fuel supply system and the rough terrain during the subsequent precautionary landing resulting on main gear collapse.NTSB FTW99LA227Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Rockwall, TXThe mechanic's improper machining of the crankshaft during a major overhaul, which resulted in a fatigue crack and subsequent failure of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB FTW89FA091Accident · 2 fatalField investigationFinal reportAeronca 11AC · Paradise, TXLoss of engine power for an undetermined reason, and failure of the pilot to maintain sufficient airspeed during the forced landing, which resulted in an inadvertent stall.NTSB FTW75DRG09Accident · No injuriesClosedAeronca 11AC · San Antonio, TXNTSB FTW74DRG10Accident · Minor injuriesClosedAeronca 11AC · Port Aransas, TXNTSB FTW71DPD11Accident · No injuriesClosedAeronca 11AC · Anson, TXNTSB FTW70D0233Accident · No injuriesClosedAeronca 11AC · Baytown, TXNTSB FTW69F0221Accident · No injuriesClosedAeronca 11AC · Victoria, TXNTSB FTW68D0604Accident · No injuriesClosedAeronca 11AC · Waco, TXNTSB FTW68F0248Accident · No injuriesClosedAeronca 11AC · Alvin, TXNTSB FTW66D0275Accident · No injuriesClosedAeronca 11AC · Pampa, TXNTSB UNK65X1125Accident · No injuriesClosedAeronca 11AC · Alanreed, TX