Fatal NTSB investigations: Aeronca 65-CA

9 cases on aircraft the registry lists as Aeronca 65-CA. 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

19672026

Fatal NTSB investigations: Aeronca 65-CA per year, 1967–2026: 9 cases
1967	1
1968	2
1969	1
1971	1
1979	1
1996	1
2003	1
2017	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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0190922')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0190922'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0190922'))
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 CEN17LA234Accident · 1 fatalLimited investigationFinal reportAeronca 65 CA · Mount Vernon, OHThe pilot's improper starting procedure before hand propping the engine, and his subsequent attempt to stop the moving airplane, which resulted in him being struck by the propeller.Jun 17, 2017 · N33778 · Minor damage NTSB SEA03LA185Accident · 1 fatalLimited investigationFinal reportAeronca 65-CA · Polson, MTThe pilot's failure to maintain clearance from an object while maneuvering and alcohol impairment. Transmission wires, dark night conditions, and drug impairment were factors.Sep 4, 2003 · N33865 · Substantial damage NTSB FTW96FA243Accident · 1 fatalField investigationFinal reportAeronca 65-CA · Lonoke, ARThe pilot's failure to maintain aircraft control.Jun 10, 1996 · N36513 · Substantial damage NTSB SEA80FA012Accident · 2 fatalClosedAeronca 65-CA · Mountain Home, IDDec 8, 1979 · N31929 · Substantial damage NTSB FTW72FPJ18Accident · 1 fatalClosedAeronca 11AC · Adams, OKOct 9, 1971 · N36605 · Substantial damage NTSB NYC69A0092Accident · 1 fatalClosedAeronca 65-C · Phelps, NYApr 9, 1969 · N31938 · Destroyed NTSB FTW69A0027Accident · 1 fatalClosedAeronca 65-CA · Joshua, TXOct 19, 1968 · N31846 · Destroyed NTSB CHI69A0029Accident · 1 fatalClosedAeronca 65-CA · New London, OHSep 14, 1968 · N36659 · Destroyed NTSB DIA67A0007Accident · 2 fatalClosedAeronca 65-CA · Fruitland, MDJan 23, 1967 · N31932 · Destroyed