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 CHI03LA292Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Macon, MOThe pilot's improper use of the rudder, which resulted in directional control not being maintained during the landing. A factor to the accident was the crosswind gust.NTSB CHI03LA268Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Tocsin, INThe pilot attempting the low altitude turn and his failure to maintain clearance from the corn crop. A factor to the accident was the corn crop.NTSB CHI03LA244Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Chadron, NEInadequate preflight planning by the pilot to ensure the required takeoff distance was utilized, as well as a failure to abort the takeoff. Contributing factors were the uphill gradient and the hangar.NTSB CHI03LA235Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Brighton, MIThe pilot's directional control not possible resulting from the rudder control assembly separation during the landing. A factor was the construction vehicle that the airplane impacted.NTSB ATL03LA116Accident · 1 fatalLimited investigationFinal reportButler Bowers Fly Baby 1A · Lincoln, ALThe pilot's failure to maintain airspeed while maneuvering resulting in a stall.NTSB FTW03LA200Accident · Serious injuriesLimited investigationFinal reportChampion 7AC · San Antonio, TXThe pilot's failure to maintain minimum required airspeed while maneuvering, resulting in an inadvertent stall of the airplane.NTSB CHI03LA189Accident · Serious injuriesLimited investigationFinal reportBowers Fly Baby · Altus, ARA loss of engine power for undetermined reasons. Factors associated with the accident were the tree and evasive maneuver performed during the forced landing.NTSB SEA03LA081Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Colville, WAThe pilot's inadequate compensation for wind conditions on landing. A contributing factor was a crosswind.NTSB IAD03LA052Accident · Minor injuriesLimited investigationFinal reportAeronca AR-58-058B · Brattleboro, VTThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and a subsequent descent into trees. A factor in the accident was the downdrafts.NTSB DEN03LA066Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · West Jordan, UTthe dual student's failure to maintain aircraft control and the flight instructor's inadequate supervision of the student. A contributing factor was the unfavorable wind gust.NTSB MIA03LA092Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Pahokee, FLThe instructor's inadequate in-flight decision and his delay in taking remedial actions. Also causal was the student pilot's failure to maintain airspeed which resulted in a stall. Low altitude flight is a contributing factor.NTSB NYC03LA078Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Taunton, MAThe pilot's inadequate compensation for the winds, and his failure to maintain airspeed which resulted in the inadvertent stall. A factor in the accident was the tailwind.NTSB CHI03LA093Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Sturtevant, WIThe student pilot's abrupt liftoff resulting in his failure to maintain adequate airspeed followed by a stall. Also causal was the instructor's inadequate supervision.NTSB ATL03LA059Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Gordo, ALFatigue failure of the crankshaft.NTSB ATL03LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain airspeed during an approach to land that resulted in an inflight collision with the runway. A factor was the crosswind condition.NTSB CHI03CA022Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Albion, MIA failure by the pilot to maintain sufficient airspeed while maneuvering. Contributing factors were the resulting stall/spin, the relatively low altitude and the soft terrain encountered.NTSB ANC03LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fairbanks, AKThe pilot's excessive use of brakes during the landing roll, which resulted in the nose over of the airplane.NTSB ATL03LA013Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Warner Robins, GAThe pilot's failure to follow engine start procedures for a overprimed engine, and his improper use of the throttle control during an attempted start.NTSB CHI02LA298Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Little Falls, MNThe inadequate starting procedure by the pilot.NTSB IAD02LA097Accident · Serious injuriesLimited investigationFinal reportAeronca 65-C · Front Royal, VAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the airplane's proximity to the ground when the spin commenced.NTSB CHI02LA244Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Hillman, MIThe pilot's failure to maintain terrain clearance.NTSB CHI02FA228Accident · 1 fatalField investigationFinal reportAeronca 7AC · Caro, MIThe passenger became incapacitated as a result of a stroke which lead to the inadvertent interference with the flight controls.NTSB ANC02LA080Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Cordova, AKThe pilot's selection of an unsuitable runway for takeoff, which precipitated an in-flight loss of control and subsequent collision with terrain.NTSB CHI02CA250Accident · No injuriesData collectionFinal reportPiper PA-J3-C65 · Sparta, ILThe CFI's failure to maintain directional control during landing roll and the unsuccessful attempt at a go around. A factor was the ditch.NTSB NYC02LA133Accident · Serious injuriesLimited investigationFinal reportPiper J3-C65 · Andover, NJThe flight instructor's delayed remedial action, and the private pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin.NTSB NYC02LA127Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · McConnelsville, OHThe pilot's failure to maintain aircraft control while landing. A factor was the pilot's lack of experience.NTSB CHI02LA171Accident · No injuriesLimited investigationFinal reportHulle Horizon 1 · Niles, MIThe pilot's improper recovery from a bounced landing. A factor was the pilot's lack of experience in tailwheel airplanes.NTSB LAX02FA188Accident · 2 fatalField investigationFinal reportFisher Celebrity · Chandler, AZfailure of the wing spars and the in-flight separation of the aircraft wing due to the builder's inadequate manufacture of this experimental aircraft. Also causal was the current owner/pilot's continued flight with known mechanical discrepancies.NTSB CHI02LA155Accident · Serious injuriesLimited investigationFinal reportAeronca O-58B · Alexandria, INThe pilot's failure to maintain adequate airspeed which resulted in a stall. A factor was the low altitude.NTSB NYC02LA103Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Roxbury, NYThe airplane encountering an unanticipated downdraft that exceeded the climb performance of the airplane.NTSB SEA02LA082Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gaston, ORThe pilot's failure to maintain clearance from object(s) while executing a forced landing following a total loss of power for undetermined cause(s). Contributing factors where the pole impacted during the emergency landing and the pilot's diverted attention.NTSB CHI02LA105Accident · 2 fatalLimited investigationFinal reportBozeman Pietenpol Aircamper · Rocky Comfort, MOThe pilot not maintaining aircraft control while maneuvering, and his failure to maintain airspeed resulting in a stall. Low altitude flight was a contributing factor.NTSB LAX02FA120Accident · 2 fatalField investigationFinal reportPiper J3F-65 · Parker, AZThe failure of the student to attain and maintain an adequate airspeed following liftoff, which resulted in a stall/mush condition. Also causal was the certified flight instructor's inadequate supervision of the flight and failure to take timely remedial…NTSB NYC02LA077Accident · No injuriesLimited investigationFinal reportPiper J4A · Cincinnati, OHThe maintenance technician's failure to properly adjust the carburetor float. Factors were the unsuitable terrain.NTSB CHI02LA064Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Wahoo, NEThe student, who was a private pilot, used excessive braking during the landing roll.NTSB CHI02LA057Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lake Leelanau, MIThe improper planning/decision in runway selection. The soft runway condition and wet snow were contributing factors.NTSB LAX02LA058Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Winters, CAThe failure of the pilot to retard the engine throttle to idle while hand-propping the engine, which resulted in the engine starting at full (takeoff) power and the airplane taking off with no one aboard.NTSB IAD02LA019Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Livermore Falls, METhe pilot's failure to maintain proper altitude clearance while landing, which resulted in a collision with trees. A factor was the crosswind.NTSB NYC02LA034Accident · Serious injuriesLimited investigationFinal reportGillette Baby Ace · Spencerport, NYThe pilot's failure to maintain aircraft control during approach to the airport, which resulted in an inadvertent stall.NTSB CHI02LA039Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Harrisonville, MOdirectional control not maintained be the pilot during landing rollout. The ditch was a contributing factor.NTSB LAX02LA024Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Copperopolis, CAThe pilot's misjudgment of speed and altitude on final approach to landing, which resulted in a low approach and impact with a fence at the runway threshold. The impact lead to a subsequent loss of control and nose over.NTSB NYC02LA020Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Farmville, VAThe CFI's failure to maintain directional control during the takeoff. A factor in the accident was the CFI's decision to conduct the flight from the airplane's right seat, which was not equipped with brakes.NTSB MIA02FA001Accident · 1 fatalField investigationFinal reportChampion 7AC/BCM · Woodstock, ALThe failure of the pilot to maintain aircraft control while maneuvering at a low altitude, resulting in an uncontrolled descent and inflight collision with the terrain.NTSB ATL01LA113Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Punta Gorda, FLThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the landing gear..NTSB SEA01LA164Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Winston, ORThe pilot's failure to maintain clearance from a fence during the initial takeoff. A fence was a factor.NTSB MIA01LA220Accident · 1 fatalLimited investigationFinal reportPiper J-4A · Mosheim, TNThe failure of the student pilot to maintain altitude clearance during a balked landing go-around resulting in the collision with a utility pole, transmission wires, and a ground borne vehicle.NTSB NYC01LA208Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Gasport, NYThe pilot's failure to obtain a proper climb airspeed which resulted in an inadvertent stall and subsequent impact with a hangar.NTSB LAX01LA269Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Fort Bragg, CAthe pilot's failure to maintain airspeed while making a precautionary landing resulting in an inadvertent stall.NTSB ANC01LA092Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Skwentna, AKThe pilot's excessive use of brakes during the landing roll.NTSB CHI01LA254Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Wall, SDThe student pilot failed to maintain a proper glidepath, failed to obtain proper climb rate, and executed the go-around improperly. Additional factors included the pilot's lack of experience, the crop, and the soft, wet ground.