NTSB investigations: Continental A&C65 series
3,024 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 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."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" DESCRun 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 LAX90LA285Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DC-65 · Morgan Hill, CAFuel exhaustion, due the certified flight instructors improper preflight inspection.NTSB CHI90LA210Accident · No injuriesLimited investigationFinal reportPiper J-3 CUB · Clay Banks, WIPilot's failure to maintain an adequate visual lookout during the descent. Contributing factors are the pilot's poor weather evaluation, and continued VFR flight into IFR conditions.NTSB CHI90DCG01Accident · Serious injuriesFinal reportGeorge R. Losey J6-KARATOO · Grain Valley, MOThe propeller blade separation during initial climb, and the failure of the pilot in command to maintain flying speed during the emergency descent.NTSB DEN90LA162Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Logan, UTThe pilot's failure to maintain directional control and his improper use of the wheel brakes. A factor related to the accident was: the pilot's lack of experience in the make and model of aircraft.NTSB MKC90LA140Accident · No injuriesLimited investigationFinal reportPiper J-3 · Clarksville, ARFailure of the pilot to maintain flying speed.NTSB MKC90LA121Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Deer River, MNAirspeed not maintained and stall/spin encountered by the pilot in command.NTSB DEN90LA128Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wahpeton, NDInadequate compensation for the wind conditions by the pilot. A factor was a strong cross wind, with gusts.NTSB DEN90DTG01Accident · No injuriesFinal reportAdams Boredom Fighter · Finley, NDA power loss due to fuel exahustion and the pilot's inadequate fuel planning. A factor was the ditch in which touchdown occurred.NTSB NYC90LA098Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Kutztown, PAThe student pilot's improper control input and the instructior's inadequate response. The student's interference with the flight controls as the instructor attempted recovery was a factor in the accident.NTSB NYC90LA101Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Meadville, PALoss of directional control by the pilot during landing. Contributing factor was gusty wind conditions.NTSB ANC90LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Knik Clacier, AKA foreign object (tool) had jammed the aileron controls to the right as the pilot was maneuvering the aircraft for a low approach to a strip.NTSB ANC90FA052Accident · No injuriesField investigationFinal reportAeronca 11AC · Chugiak, AKFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind and snow covered terrain beside the runway.NTSB FTW90FA091Accident · 1 fatalField investigationFinal reportLuscombe 8-A · Baytown, TXThe pilot's inadvertent stall of the airplane while maneuvering after a partial power loss during initial climb and a partially blocked exhaust system which had been inadequately maintained.NTSB LAX90LA151Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Creston, CAThe inadvertent intrusion of wildlife on the runway environment and the pilot's application of brakes resulting in a nose down attitude and propeller strike.NTSB LAX90LA114Accident · No injuriesLimited investigationFinal reportPiper J3 · Palo Alto, CAThe failure of the pilot to maintain directional control by not compensating for changing wind conditions.NTSB CHI90LA058Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Chillicothe, OHImproper planning/decision by the student pilot, which resulted in a landing on a slick runway, and his failure to maintain directional control during the landing, which resulted in his inability to maintain runway alignment. Contributing factors were: the…NTSB MKC90FA038Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Lynch, NEAirspeed was not maintained by the pilot resulting in a stall/spin.NTSB CHI90LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Millbury, OHFailure of the pilot to properly secure the aircraft and/or adequately brief the passenger (student pilot), and inadvertent bumping of the throttle by the passenger.NTSB NYC90LA019Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Windham, CTThe pilot's failure to achieve proper lift-off speed.NTSB LAX90LA006Accident · No injuriesLimited investigationFinal reportPiper J-2 · Santa Ynez, CAFailure of the pilot to adequately secure the aircraft before hand propping the engine.NTSB LAX90LA003Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Penn Valley, CAFailure of the pilot to maintain directional control during the landing roll-out, which resulted in an inadvertent ground swerve. Uneven terrain beside the runway was a factor.NTSB ATL89LA211Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Screven, GAFailure of maintenance personnel to correct right brake adjustment problems during brake repairs which led to a failure of the right brake, and the pilot's delay in taking remedial action to correct the veering initiated by the brake failure.NTSB MKC89LA192Accident · Minor injuriesLimited investigationFinal reportPietenpol AIR Camper B4A · Horatio, ARImproper use of carburetor heat by the pilot, which resulted in carburetor ice. A factor related to the accident was: carburetor icing conditions.NTSB ANC89LA157Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Igushik, AKThe pilot selected unsuitable terrain for a landing. Soft terrain was a contributing factor.NTSB SEA89LA158Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Independence, ORFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground loop and subsequent overload failure of the left main gear. A factor related to the accident was: improper flare by the pilot.NTSB BFO89LA077Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Leonardtown, MDInadequate preflight planning/preparation by the pilot by not assuring that the acft was properly secured, or that someone was at the controls while he was hand propping the engine. A related factor was the pilot's improper adjustment of the throttle cable.NTSB MIA89LA208Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Homestead, FLImproper repair of the fuel cap (seal) by the pilot, which resulted in a blocked fuel system (cap) vent and subsequent fuel starvation, and his failure to see-and-avoid the telephone line. The telephone (transmission) line was a contributing factor.NTSB NYC89LA170Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ithaca, NYA loss of control on takeoff due to improper takeoff techniques.NTSB ANC89LA121Accident · No injuriesLimited investigationFinal reportPiper J-3 · Parker Lake, AKImproper preflight planning by the pilot and his failure to attain and/or maintain adequate speed, which resulted in a stall/mush after lift-off.NTSB LAX89LA335Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Napa, CASuicide.NTSB MKC89LA151Accident · Minor injuriesLimited investigationFinal reportPiper J3 "CUB" · Morrilton, ARThe abrupt handling of the airplane by the pilot. He failed to maintain airspeed and inadvertantly stalled and spun the airplane at an altitude insufficient for recovery.NTSB NYC89LA153Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Newport, METhe aircraft fuel supply was contaminated by water and the pilot's inadequate preflight.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.NTSB SEA89LA101Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Vancouver, WAThe pilot's failure to maintain directional control during landing ground roll, resulting in a ground loop and nose over. The crosswind is considered to be a contributing factor to the accident.NTSB MKC89LA120Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Alexandria, MNThat proper starting procedures were not followed by the pilot in command and the aircraft was not tied down.NTSB LAX89LA209Accident · No injuriesLimited investigationFinal reportAeronca 50F · Ontario, CAThe pilot's inability to compensate for existing wind conditions, resulting in the inability to maintain a climb.NTSB SEA89LA090Accident · No injuriesLimited investigationFinal reportStits SA-3A · Jackpot, NVInadequate wind compensation by the pilot. Contributing to the accident were gusty grosswinds.NTSB BFO89LA034Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Indian Head, MDPilot failed to maintained directional control during recovery from a hard landing.NTSB SEA89LA089Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Copalis Beach, WAThe pilot's failure to perform the necessary preflight planning and preparation which resulted in the selection of unsuitable terrain for landing. Contributing to the accident was the soft sand bar.NTSB SEA89LA084Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Battle Mountain, NVInadequate compensation for wind condition by the pilot. Contributing to the accident were wind gusts encountered during landing flare.NTSB CHI89LA086Accident · No injuriesLimited investigationFinal reportPorterfield CP-55 · Tecumseh, MIPilot's inadequate preflight operatins, which failed to detect the presence of water contamination in the fuel system, and resulted in the substantial loss of power and subsequent forced landing. The aircraft encountered soft, loose soil during the forced…NTSB FTW89FA091Accident · 2 fatalField investigationFinal reportAeronca 11AC · Paradise, TXLoss of engine power for an undetermined reason, and failure of the pilot to maintain sufficient airspeed during the forced landing, which resulted in an inadvertent stall.NTSB LAX89LA162Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Santa Paula, CAThe pilots improper use of carburetor heat in conditions that were conducive to the formation of carburetor ice.NTSB MIA89LA129Accident · No injuriesLimited investigationFinal reportLuscombe 8A · St Augustine, FLFuel contamination. A related factor was the tree.NTSB NYC89LA045Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gorham, MEFailure of the pilot to maintain adequate airspeed when he diverted his attention during a low pass and allowed the aircraft to enter a stall/spin. The unfavorable wind was a factor.NTSB ANC89LA064Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Beluga Mountain, AKPilot's selection of unsuitable terrain for an off-airport landing and takeoff. The uneven terrain (with a snow berm) was a related factor.NTSB FTW89LA069Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Catoosa, OKCarburetor ice and improper use of carburetor heat. Factors related to the occurrence were: carburetor icing conditions and rough/uneven terrain.NTSB NYC89LA090Accident · Minor injuriesLimited investigationFinal reportTaylorcraft L-2M · Olcott, NYThe inattentiveness of the pilot to maintain airspeed while turning base leg for landing which resulted in a stall and subsequent collision with a hangar.NTSB FTW89LA045Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Richards, TXThe pilot's inadequate preflight planning/preparation in disregarding wind information. Contributing to the accident were the gusting crosswind conditions and the pilot's overconfidence in personal ability.NTSB SEA89FA041Accident · 2 fatalField investigationFinal reportAeronca O-58B · Minden, NVThe failure of the pilot to maintain adequate airspeed and airplane control. Contributing to the accident was the mountainous terrain and mountain wave conditions.