Skip to content

NTSB investigations: Continental A&C65 series, CT

20 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" = 'CT' 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\" = 'CT' 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" = 'CT' 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 ERA17LA275Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Salisbury, CTAn improper replacement of the crankshaft by maintenance personnel, which resulted in a failure of the crankshaft gear and total loss of engine power.Aug 13, 2017 · N98550 · Substantial damage NTSB NYC96LA121Accident · No injuriesLimited investigationFinal reportPiper J-3 · Chester, CTthe pilot's improper use of rudder control to maintain directional control during landing.Jun 6, 1996 · N68952 · Substantial damage NTSB NYC94LA140Accident · Serious injuriesLimited investigationFinal reportAces High Cuby B · Waterbury, CTA loss of engine power for undetermined reasons.Jul 24, 1994 · N2282Z · Substantial damage NTSB NYC93LA147Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Stonington, CTThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin, and the pilot's improper use of the carburetor heat which resulted in the accretion of carburetor ice. A factor was carburetor icing conditions.Aug 11, 1993 · N98382 · Substantial damage NTSB BFO93FA128Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-65 · Danbury, CTUndetermined.Jul 18, 1993 · N34009 · Destroyed NTSB NYC90LA019Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Windham, CTThe pilot's failure to achieve proper lift-off speed.Oct 29, 1989 · N1160K · Substantial damage NTSB NYC84LA325Accident · No injuriesLimited investigationFinal reportPiper J-3 · Durham, CTThe plt attempted to land on a grass strip. The wind was reported to be from 270 degrees at 10 KTS. The plt stated that he experienced a change in wind direction and a gust. The acft then veered and collided with a stone wall.Sep 19, 1984 · N7456H · Substantial damage NTSB NYC80FNE20Accident · No injuriesClosedPiper J3C-65 · Windham, CTJul 4, 1980 · N98467 · Substantial damage NTSB NYC77FNE04Accident · No injuriesClosedLuscombe 8A · Burlington, CTOct 22, 1976 · N1170K · Substantial damage NTSB NYC76FNE23Accident · Minor injuriesClosedTaylorcraft BC12-D · Norfolk, CTJun 6, 1976 · N95148 · Substantial damage NTSB NYC72FNE34Accident · Minor injuriesClosedAeronca 11AC · Easton, CTApr 21, 1972 · N85810 · Substantial damage NTSB NYC70D0248Accident · No injuriesClosedAeronca 7AC · Greenwich, CTNov 25, 1969 · N3044E · Substantial damage NTSB NYC70D0137Accident · No injuriesClosedLuscombe 8A · Ellington, CTAug 21, 1969 · N71615 · Substantial damage NTSB NYC70F0054Accident · No injuriesClosedPiper PA-17 · Madison, CTJul 9, 1969 · N4811H · Substantial damage NTSB NYC69D0468Accident · Minor injuriesClosedPiper J3C-65 · New Milford, CTMay 4, 1969 · N3314N · Substantial damage NTSB NYC69D0160Accident · Minor injuriesClosedPiper J3C-65 · Woodstock, CTSep 1, 1968 · N42392 · Substantial damage NTSB NYC67D0195Accident · No injuriesClosedAeronca 7AC · Monroe, CTAug 19, 1966 · N83091 · Substantial damage NTSB NYC66F0032Accident · Serious injuriesClosedPiper J3 · East Windsor, CTJul 2, 1965 · N92699 · Substantial damage NTSB UNK64X3315Accident · No injuriesClosedAeronca 7AC · Danielson, CTAug 10, 1964 · N4592E · Substantial damage NTSB UNK64X1589Accident · No injuriesClosedAeronca 11AC · Enfield, CTMay 3, 1964 · N86327 · Substantial damage