Skip to content

NTSB investigations: Continental A&C65 series, KY

27 cases on aircraft whose registry engine model is Continental A&C65 series. 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

19642026

Where

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" = 'KY' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003')) 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\" = 'KY' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003'))
  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" = 'KY' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003'))
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 ERA22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Cynthiana, KYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while maneuvering to land with approaching convective activity.Aug 3, 2022 · N88550 · Substantial damage NTSB ERA14LA253Accident · Serious injuriesLimited investigationFinal reportPiper J3C - 65 · Hopkinsville, KYThe failure of the pilot to identify poor engine performance during the engine run-up before takeoff. Also causal to the accident was the mistimed right magneto and the poor condition of the spark plugs in the No. 4 cylinder.May 22, 2014 · N46777 · Substantial damage NTSB ERA11CA453Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · West Liberty, KYThe pilot's failure to obtain the proper touchdown point during landing, which resulted in a runway excursion.Aug 13, 2011 · N5080M · Substantial damage NTSB ERA11CA007Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Taylorsville, KYThe pilot’s failure to maintain clearance from an unmarked power line during the final approach to land.Oct 4, 2010 · N85888 · Substantial damage NTSB MIA08CA145Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Greensburg, KYThe pilot's failure to maintain clearance from trees while maneuvering. Contributing to the accident was the low altitude maneuvers.Jul 19, 2008 · N3624E · Substantial damage NTSB NYC01FA145Accident · 2 fatalField investigationFinal reportAeronca 7DC · Fulton, KYThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/spin to the ground. A factor was the pilot's decision to fly from the rear seat, which reduced his visibility of critical flight instruments, including the…Jun 15, 2001 · N82562 · Destroyed NTSB ATL87LA246Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Greenville, KYThe flt was being conducted as part of a 'clown act' at an air show. The eng lost pwr shortly after takeoff as the plt was performing pitching maneuvers. He unsuccessfully attempted to regain pwr by 'pumping' the throttle. The airplane subsequently impacted…Aug 30, 1987 · N92191 · Substantial damage NTSB ATL85LA144Accident · No injuriesLimited investigationFinal reportBellanca 7AC · Germantown, KYDuring cruise flt over hilly terrain, the plt noted a power loss that he described as the eng 'dying back and then catching again.' He was unable to maintain alt & selected a field for a landing. During the apch, the left main gear & prop hit 2 power lines.…Apr 21, 1985 · N85652 · Substantial damage NTSB ATL84LA202Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Hogdenville, KYAccording to the plt, during a low turn to final a power loss occurred. The acft landed short in a plowed field and nosed over. Examination of the engine revealed no mechanical malfunctions.Jun 18, 1984 · N82989 · No damage NTSB IAD78FLQ18Accident · No injuriesClosedLuscombe 8A · Louisville, KYMay 11, 1978 · N71328 · Substantial damage NTSB IAD77FLQ07Accident · Minor injuriesClosedAeronca 7AC · Elizabethtown, KYFeb 20, 1977 · N82244 · Destroyed NTSB IAD76DLQ28Accident · No injuriesClosedCessna 150 · Cynthiana, KYJun 26, 1976 · N8621J · 2 aircraft · Minor damage NTSB IAD76AI001Accident · 2 fatalClosedAeronca 058B · Pikeville, KYJul 5, 1975 · N52354 · Destroyed NTSB IAD74FLQ06Accident · No injuriesClosedAeronca 7AC · Cromwell, KYAug 21, 1973 · N84156 · Substantial damage NTSB IAD73FLQ30Accident · Minor injuriesClosedAeronca 7AC · Murray, KYMay 13, 1973 · N81941 · Substantial damage NTSB CHI72DLQ12Accident · Serious injuriesClosedAeronca 7AC · Baxter, KYAug 22, 1971 · N84852 · Substantial damage NTSB CHI71FLQ17Accident · Minor injuriesClosedAeronca 7AC · Stanton, KYFeb 14, 1971 · N82873 · Substantial damage NTSB CHI70DGJ18Accident · Serious injuriesClosedPiper J-3 · Whitesburg, KYJun 28, 1970 · N6768H · Substantial damage NTSB CHI70FGJ15Accident · Serious injuriesClosedAeronca 65-TAC · Lebanon, KYJun 14, 1970 · N39563 · Substantial damage NTSB CHI70AC068Accident · 1 fatalClosedAeronca 7AC · Whitesburg, KYApr 3, 1970 · N83241 · Destroyed NTSB CHI70D0021Accident · No injuriesClosedPiper J3C-65 · Shepherdsville, KYJun 4, 1969 · N6719H · Substantial damage NTSB CHI69F0322Accident · Minor injuriesClosedPiper J3C-65 · Nicholasville, KYOct 27, 1968 · N68928 · Substantial damage NTSB CHI68D0597Accident · No injuriesClosedAeronca 7AC · Princeton, KYFeb 13, 1968 · N85783 · Substantial damage NTSB CHI67D0074Accident · No injuriesClosedPiper J-3 · Columbia, KYJul 9, 1966 · N6104H · Substantial damage NTSB CHI66F0210Accident · No injuriesClosedTaylorcraft BC12-D · Richardville, KYSep 6, 1965 · N44133 · Substantial damage NTSB UNK65X0794Accident · No injuriesClosedChampion 116 · Ano, KYNov 22, 1964 · N5498N · Substantial damage NTSB UNK64X1552Accident · No injuriesClosedAeronca 7AC · Harlan, KYMay 1, 1964 · N1847E · Substantial damage