NTSB investigations: Continental A&C65 series, 1985

56 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.

Cases, newest first

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 year(c.\"eventDate\") = 1985
    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.

NTSB SEA85LA064Accident · No injuriesLimited investigationFinal reportLyoyd Thompson Pober Pixie · Nampa, IDLeft main gear contacted runway-taxiway intersection lights during a landing roll. Acft then nosed over. Rwy width is 75 ft.Feb 23, 1985 · N263LT · Substantial damageNTSB DEN85FA084Accident · 2 fatalField investigationFinal reportTaylorcraft BC-65 · Chinook, MTThe airplane was observed to enter a shallow right climbing turn at about 200 feet AGL after making a low pass over friends. Witnesses said the airplane then stalled and dove to the ground. There was no evidence of airframe, eng, prop, flt control, or syst…Feb 22, 1985 · N26580 · DestroyedNTSB SEA85LYE01Accident · No injuriesFinal reportLuscombe 8A · Cheney, WAAcft was found abandoned after sustaining substantial damage in apparent lndg attempt in snow-covered marsh. Presumed pilot had expired student certificate and had registered acft to self under an alias. Circumstances of mishap unknown.Feb 16, 1985 · N28833 · Substantial damageNTSB MIA85LA092Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · St.Augustine, FLThe acft collided with a wind direction indicator support pole during a recovery from a bounced landing. The CFI on board stated he turned his head to advise the student in the back seat to keep the left wing down because of the x-wind condition when he…Feb 10, 1985 · N92668 · Substantial damageNTSB FTW85FA094Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Ferriday, LAAcft was observed in slow flt aprx 40 ft AGL just above stall speed with the eng operating smoothly. The acft then stalled and impacted in an aprx 90 deg nose down attitude. The plt was flying from the front seat. The acft was not equipped with shoulder…Jan 8, 1985 · N1474N · Substantial damageNTSB LAX85LA099Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Chandler, AZThe PIC reported the 2nd plt was flying the acft at the time of the accident while they were practicing off arpt landings. On the second takeoff, the 2nd plt executed a course reversal turn to land opposite the direction of takeoff. The initial turn was to…Jan 7, 1985 · N84096 · Substantial damage