NTSB investigations: Aeronca 65-TAC
13 cases on aircraft the registry lists as Aeronca 65-TAC. 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
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1969 | 2 |
| 1970 | 2 |
| 1972 | 1 |
| 1989 | 1 |
| 1998 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2024 | 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 ('0190910'))
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 ('0190910'))
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 ERA24LA363Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 65-TAC · Clearwater, FLThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the outcome, was the pilot’s inability to control the engine following the loss of directional control due to the separation of a knob from the engine’s throttle…NTSB DFW07CA013Accident · No injuriesData collectionFinal reportAeronca 65-TAC · Fredricksburg, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB IAD05LA063Accident · 2 fatalLimited investigationFinal reportAeronca 65-TAC · Harrisonburg, VAA total loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with the ground.NTSB LAX04CA185Accident · No injuriesData collectionFinal reportAeronca 65-TAC · Grass Valley, CAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Factors in the accident were wind gusts and tailwind/crosswind conditions.NTSB ATL98LA126Accident · No injuriesLimited investigationFinal reportAeronca 65-TAC (L-3) · Dalton, GAThe pilots failure to maintain directional control of the airplane during landing. A factor was the pilot's lack of experience in the same make and model airplane.NTSB FTW89LA095Accident · Serious injuriesLimited investigationFinal reportAeronca 65-TAC · Pryor, OKThe failure of the pilot to maintain airspeed during a low pass over the airport after pulling up to clear wires which resulted in a stall.NTSB DEN72DQA29Accident · No injuriesClosedAeronca 65-TAC · Lemitar, NMNTSB NYC71FGM01Accident · Minor injuriesClosedAeronca 65-TAC · Belle Vernon, PANTSB CHI70FGJ15Accident · Serious injuriesClosedAeronca 65-TAC · Lebanon, KYNTSB FTW70F0302Accident · No injuriesClosedAeronca 65-TAC · Goldthwaite, TXNTSB CHI69A0065Accident · 2 fatalClosedAeronca 65-TAC · Shelbyville, INNTSB NYC67D0633Accident · No injuriesClosedAeronca 65-TAC · Turner, MENTSB CHI67F0340Accident · No injuriesClosedAeronca 65-TAC · Plainwell, MI