Skip to content

NTSB investigations: Continental A&C65 series, ID

29 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

19652026

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" = 'ID' 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\" = 'ID' 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" = 'ID' 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 WPR22LA103Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-65 · Murphy, IDThe pilot's failure to maintain directional control during the landing roll.Feb 18, 2022 · N36430 · Substantial damage NTSB GAA19CA240Accident · No injuriesData collectionFinal reportLuscombe 8 · Orofino, IDThe pilot's improper brake application during the landing roll, which resulted in a nose-over. Contributing to the accident was the pilot's lack of recent experience using heel brakes.May 3, 2019 · N22052 · Substantial damage NTSB GAA18CA188Accident · No injuriesData collectionFinal reportPiper J3C · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.Mar 30, 2018 · N24751 · Substantial damage NTSB WPR14CA288Accident · No injuriesData collectionFinal reportPiper PA 17 · Sand Point, IDThe pilot's failure to maintain directional control of the airplane during taxi.Jul 8, 2014 · N4842H · Substantial damage NTSB SEA05CA116Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Yellow Pine, IDThe pilot's delay in executing a go-around which resulted in his failure to obtain altitude/clearance with trees.Jun 13, 2005 · N96156 · Substantial damage NTSB SEA04CA174Accident · No injuriesData collectionFinal reportLuscombe 8A · Nampa, IDThe pilot's failure to maintain directional control during the landing roll. Factors include the pilot's very low total time in this make and model aircraft (one hour), and the soft terrain the aircraft encountered along the side of the runway.Aug 27, 2004 · N1983B · Substantial damage NTSB SEA96LA143Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sun Valley, IDthe pilot's inadequate compensation for wind conditions and failure to obtain/maintain adequate airspeed for the go-around. The crosswind, downdraft, and high density altitude were related factors.Jul 5, 1996 · N95658 · Substantial damage NTSB SEA94LA239Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Nampa, IDDirectional control was not maintained. A factor to the accident was: inadequate supervision.Sep 13, 1994 · N85564 · Substantial damage NTSB SEA89LA185Accident · No injuriesLimited investigationFinal reportAeronca 65-C · New Meadows, IDImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.Jun 26, 1989 · N22137 · Substantial damage NTSB SEA88LA185Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Coeur D'Alene, IDWhen pax became ill, plt elected to land in a pasture. Gear contacted dirt mound hidden by tall grass, separating gear.Sep 23, 1988 · N3647N · Substantial damage NTSB SEA85LA144Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Orofino, IDDuring strong gusting winds the private plt was attempting to give dual instruction. During short final for rwy 27 and the wind from 270 at 8 to 12 knots gusting to 18 knots an approach stall was entered into a about 50 feet AGL. Although an attempted…Jun 23, 1985 · N25231 · Substantial damage 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 damage NTSB SEA84LA074Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Hailey, IDThe student plt attempted to taxi back on the active rwy after landing and groundlooped. During the swerve the left wingcontacted a snow bank. The student plt recommended no tail-up taxiing.Mar 22, 1984 · N85763 · Substantial damage NTSB SEA80FA012Accident · 2 fatalClosedAeronca 65-CA · Mountain Home, IDDec 8, 1979 · N31929 · Substantial damage NTSB SEA78FA060Accident · 2 fatalClosedPiper J3C · Mccall, IDSep 3, 1978 · N88185 · Destroyed NTSB SEA78FA031Accident · 1 fatalClosedBuhl Acft LA1 · Kimberly, IDMay 21, 1978 · N12106 · Destroyed NTSB SEA77DYP28Accident · Serious injuriesClosedAeronca 7AC · Athol, IDApr 24, 1977 · N1363E · Substantial damage NTSB SEA77DYA13Accident · No injuriesClosedTaylorcraft BC12D · American Falls, IDMar 15, 1977 · N44280 · Substantial damage NTSB SEA76FYA28Accident · Serious injuriesClosedTaylorcraft BC12-D · Mountain Home, IDJun 23, 1976 · N36430 · Substantial damage NTSB SEA72DYA23Accident · No injuriesClosedTaylorcraft DCO-65 · Boise, IDFeb 5, 1972 · N49122 · Substantial damage NTSB SEA71DYG61Accident · No injuriesClosedTaylorcraft BC12-D · Priest Lake, IDJun 27, 1971 · N44445 · Substantial damage NTSB SEA70AS037Accident · 2 fatalClosedTaylorcraft BC12-D · Middleton, IDMar 20, 1970 · N95088 · Destroyed NTSB SEA40D0135Accident · Serious injuriesClosedPiper J-3 · Nez Perce, IDDec 16, 1969 · N33593 · Substantial damage NTSB SEA68D0162Accident · Minor injuriesClosedTaylorcraft BC12-D · Ketchum, IDOct 6, 1967 · N95561 · Substantial damage NTSB SEA67D0198Accident · No injuriesClosedTaylorcraft BC12-D · Jerome, IDNov 20, 1966 · N39230 · Substantial damage NTSB SEA67D0016Accident · No injuriesClosedTaylorcraft BC12-D · Hailey, IDJul 3, 1966 · N39230 · Substantial damage NTSB SEA66D0170Accident · No injuriesClosedPiper J-3 · Carey, IDOct 30, 1965 · N32949 · Substantial damage NTSB SEA65F0045Accident · Serious injuriesClosedPiper J-3 · Meadows, IDApr 7, 1965 · N69081 · Substantial damage NTSB SEA65D0034Accident · No injuriesClosedMooney M18C · Idaho Falls, IDMar 20, 1965 · N4073 · Destroyed