Skip to content

NTSB investigations: Continental A&C65 series, NM

25 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

19662026

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" = 'NM' 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\" = 'NM' 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" = 'NM' 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 WPR23LA198Accident · Minor injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · Clovis, NMThe airplane’s uncontrollable descent and forced landing for reasons that could not be determined.May 20, 2023 · N71983 · Substantial damage NTSB WPR23LA100Accident · No injuriesClass 4 · LimitedFinal reportAeronca 65-CA · Deming, NMThe occupant’s improper throttle movement during the start procedure, which resulted in forward movement and loss of airplane control.Dec 15, 2022 · N29447 · Substantial damage NTSB CEN18LA222Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12 D · Santa Teresa, NMThe pilot's loss of directional control during landing in gusting crosswind conditions for reasons that could not be determined based on the available information.Jun 10, 2018 · N43443 · Substantial damage NTSB CEN10CA407Accident · No injuriesData collectionFinal reportAeronca 7AC · Santa Fe, NMThe pilot's failure to maintain directional control of the airplane while landing with gusting winds.Jul 10, 2010 · N84723 · Substantial damage NTSB DEN06CA025Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Los Lunas, NMthe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground loop.Dec 23, 2005 · N96924 · Minor damage NTSB DEN00LA107Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Santa Fe, NMThe pilot's failure to maintain control of the aircraft. A factor was gusty wind conditions.Jun 11, 2000 · N25222 · Substantial damage NTSB FTW97FA099Accident · 2 fatalField investigationFinal reportAeronca 65-TC · Moriarty, NMThe pilot's failure to maitain airspeed resulting in an inadvertent stall/spin. Factors were gusty winds, turbulence, a high density altitude, and the pilot's lack of total experience in the make and model of aircraft.Feb 3, 1997 · N31794 · Substantial damage NTSB DEN89LA032Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Carrizozo, NMThe private plt said his Taylorcraft was secured to the ramp by 3 chains. He tried to hand start the engine, with no one at the controls, and the throttle full open. The engine started, the acft broke the right wing tie down ring, and straightened an 's' hook…Nov 13, 1988 · N43603 · Substantial damage NTSB DEN86LA109Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Santa Teresa, NMThe plt stated that he was performing touch & go landings. When the accident occurred. On the first landing a wind gust raised the right wing. The plt stated he 'tried to straighten out' the acft when it went off the right side of the rwy. The left main…Mar 30, 1986 · N43139 · Substantial damage NTSB DEN86LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Santa Rosa, NMAccording to the plt, the eng quit during the initial climbout and the acft was substantially damaged during the subsequent forced landing. Post accident inspection disclosed the gascolator was broken which resulted in fuel starvation to the engine.Mar 2, 1986 · N85255 · Substantial damage NTSB FTW81FQA12Accident · Serious injuriesClosedTaylorcraft BC-65 · Albuquerque, NMJan 2, 1981 · N29567 · Substantial damage NTSB DEN78FA052Accident · 2 fatalClosedLuscombe 8A · Farmington, NMJul 20, 1978 · N45694 · Substantial damage NTSB DEN76FQA29Accident · No injuriesClosedTaylorcraft BC12-D · Farmington, NMNov 19, 1975 · N95313 · Substantial damage NTSB DEN75FQA20Accident · Serious injuriesClosedTaylorcraft DCO-65 · Raton, NMNov 10, 1974 · N49040 · Substantial damage NTSB DEN73FQA35Accident · Minor injuriesClosedTaylorcraft BC12-D · Albuquerque, NMApr 22, 1973 · N39969 · Substantial damage NTSB DEN73FQA15Accident · Serious injuriesClosedPiper PA-17 · Gallup, NMAug 22, 1972 · N4657H · Destroyed NTSB DEN69F0169Accident · Serious injuriesClosedPiper J3C-65 · Silver City, NMJan 13, 1969 · N98882 · Substantial damage NTSB DEN69F0124Accident · No injuriesClosedLuscombe 8A · Anapra, NMOct 19, 1968 · N71363 · Substantial damage NTSB DEN68F0242Accident · No injuriesClosedAeronca 7AC · Aztec, NMMar 18, 1968 · N85057 · Substantial damage NTSB DEN68F0201Accident · Serious injuriesClosedTaylorcraft BC12-D · Truth-Consq, NMJan 16, 1968 · N43819 · Substantial damage NTSB DEN68F0187Accident · No injuriesClosedTaylorcraft BC12-D · Albuquerque, NMJan 1, 1968 · N95810 · Substantial damage NTSB DEN68F0129Accident · Minor injuriesClosedTaylorcraft BC-65 · Aztec, NMOct 12, 1967 · N29810 · Substantial damage NTSB DEN67D0224Accident · No injuriesClosedAeronca 11AC · Las Cruces, NMFeb 11, 1967 · N85862 · Substantial damage NTSB DEN67D0034Accident · No injuriesClosedLuscombe 8A · Santa Rosa, NMJun 25, 1966 · N28567 · Substantial damage NTSB DEN66D0208Accident · No injuriesClosedLuscombe 8A · Quemado, NMJan 15, 1966 · N45460 · Substantial damage