NTSB investigations: Continental A&C65 series
169 cases on aircraft whose registry engine model is Continental A&C65 series, where the first occurrence was “Loss of control - on ground/water”. 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 ANC99LA080Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · North Pole, AKThe pilot's inadvertent ground loop during a high speed taxi. A factor associated with the accident is the pilot's decision to taxi the airplane at an excessive taxi speed.NTSB ATL99LA039Accident · No injuriesLimited investigationFinal reportLuscombe 8-A · Palmetto, FLThe failure of the wheel fairing attach bolts that resulted in the loss of control during the landing roll when the fairing became lodged under the left wheel.NTSB NYC99FA037Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Greenville, PAThe pilot's failure to maintain directional control during touch-and-go landing, and his failure to maintain obstacle clearance. A factor was the tree.NTSB ATL98LA126Accident · No injuriesLimited investigationFinal reportAeronca 65-TAC (L-3) · Dalton, GAThe pilots failure to maintain directional control of the airplane during landing. A factor was the pilot's lack of experience in the same make and model airplane.NTSB CHI98LA232Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Chillicothe, MOthe improper use of the engine starting procedure. Factors contributing to the accident were the pilot in command's lack of recent experience, the aircraft not being tied down, the utility pole and guy wire.NTSB LAX98LA217Accident · No injuriesLimited investigationFinal reportAeronca Chief 65-CA · Phoenix, AZThe failure of the pilot to maintain directional control of the aircraft during the landing rollout.NTSB FTW98LA233Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Sheridan, ARThe inadvertent engine start due to the pilot's failure to ensure that the magneto switch was in the OFF position when he was attempting to clear the flooded engine. A factor was the pilot's improper starting procedure, which resulted in flooding the engine.NTSB FTW98LA228Accident · Minor injuriesLimited investigationFinal reportAeronca 65-C · Ozark, ARThe pilot's failure to maintain aircraft control.NTSB SEA98LA036Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Bozeman, MTThe pilot's failure to maintain directional control during takeoff.NTSB ATL98LA028Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Eustis, FLfailure of the pilot to maintain directional control of the airplane during the landing roll, which resulted in a ground swerve and subsequent collision with a parked airplane. Related factors were: the pilot's lack of experience in tailwheel aircraft, the…NTSB NYC98LA031Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Tiverton, OHthe pilot's failure to properly set the airplane controls prior to hand propping. Factors in the accident were the pilot's failure to properly chock the wheels and his decision to leave the cockpit unmanned during start.NTSB CHI97LA203Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Cadillac, MIthe pilot failed to maintain control of the airplane during an attempted go-around and the pilot's lack of recent flight experience.NTSB NYC97LA052Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cincinnati, OHThe flight instructor's inadequate supervision and delayed remedial reaction which resulted in the loss of directional control by the student pilot during the landing roll out.NTSB NYC96LA159Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Alexandria, NJfailure of the commercial pilot to ensure that directional control was maintained during takeoff, which led to a ground swerve and collision with a fence.NTSB IAD96LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cambridge, MDthe pilot's failure to maintain control of the airplane during landing. The crosswind was a factor.NTSB SEA96LA135Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Vancouver, WAfailure of the pilot to maintain directional control of the airplane during take-off, which resulted in an inadvertent ground swerve and subsequent dragging of the right wing. The pilot's lack of experience in the make/model of aircraft was a related factor.NTSB NYC96LA121Accident · No injuriesLimited investigationFinal reportPiper J-3 · Chester, CTthe pilot's improper use of rudder control to maintain directional control during landing.NTSB NYC96LA043Accident · No injuriesLimited investigationFinal reportPiper J3F · Westerly, RIthe pilot's inadequate compensation for the wind condition, which subsequently resulted in the aircraft nosing over. The gusty crosswind condition was a related factor.NTSB CHI95LA127Accident · No injuriesLimited investigationFinal reportPiper J3C · Poplar Grove, ILThe student pilot's excessive throttle control and the certified flight instructor's inadequate supervision of the student. A factor in the accident was the gusty wind conditions.NTSB BFO95LA037Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Zanesville, OHthe pilot's failure to maintain control of the airplane while taxiing after landing. Related factors were the unfavorable (gusty) wind condition, and the pilot's improper compensation for wind conditions.NTSB CHI95LA084Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Kenosha, WIthe student's failure to maintain directional control during the landing roll.NTSB SEA94LA239Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Nampa, IDDirectional control was not maintained. A factor to the accident was: inadequate supervision.NTSB LAX94LA295Accident · No injuriesLimited investigationFinal reportPiper J-3C-65 · Jackson, CAthe pilot's inadequate compensation for the gust of wind and subsequent loss of directional control.NTSB MIA94LA180Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lutz, FLThe certified flight instructor's improper supervision of the student pilot during a wheel landing resulting in an on ground loss of control (inadvertent ground loop). Contributing to the accident was the student pilot's improper use of flight controls and…NTSB CHI94LA199Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Clear Lake, MNthe private pilot's failure to maintain directional control during the landing roll. Related factors are the rough/uneven terrain, and excessive brake application.NTSB CHI94LA086Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Dowagiac, MIFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's lack of experience in this make and model of aircraft, the crosswind, and snow beside the runway.NTSB SEA94LA056Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sidney, MTThe pilot's inadequate compensation for the crosswind resulting in loss of directional control.NTSB ANC94LA015Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Goose Bay, AKThe pilot-in-command did not maintain directional control of the airplane. A factor in the accident were the trees adjacent to the side of the runway.NTSB CHI93LA293Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Oshkosh, WIThe pilot-in-command's not maintaining directional control. Factors include a crosswind, the pilot-in-command's not attaining compensation for wind conditions, and his lack of experience in this type of airplane.NTSB ATL93LA125Accident · No injuriesLimited investigationFinal reportPiper J3 · Athens, GAThe dual student's improper application of wheel brakes prior to lowering the tail wheel and inadequate supervision by the CFI.NTSB ANC93LA091Accident · No injuriesLimited investigationFinal reportAeronca AR11 · Anchorage, AKFailure of the student pilot to maintain directional control, which resulted in a ground swerve, and inadequate supervision by the flight instructor. A factor related to the accident was: the soft/wet (muddy) terrain at the edge of the runway.NTSB CHI93LA100Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Mason City, IAExcessive braking by the dual student.NTSB ANC93LA018Accident · No injuriesLimited investigationFinal reportLuscombe SL8 · Anchorage, AKThe failure of the pilot in command to maintain directional control of his airplane. A factor in the accident was the pilot in commands improper taxi speed.NTSB FTW93LA029Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mcgregor, TXInadvertent stall by the pilot in command. Factors were the pilot's selection of the wrong runway, and the wind conditions.NTSB NYC93LA009Accident · No injuriesLimited investigationFinal reportAeronca 11-AC · Columbus, OHThe pilot failed to maintain control of the airplane, resulting the airplane departing the runway and impacted with the VASI lights.NTSB LAX92LA392Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Columbia, CAThe failure of the student to maintain directional control of the aircraft during the low speed portion of the landing roll. A factor in the accident was the lack of brake pedals at the instructor's seat position on the right side of the cockpit.NTSB NYC92LA135Accident · No injuriesLimited investigationFinal reportPiper J3 · Waynesville, OHThe pilot's failure to maintain control of the airplane on the ground due to his lack of experience in type of aircraft. This resulted in an unsuccessful aborted takeoff, the airplane veering off the runway and nosing over. A factor in this accident was the…NTSB CHI92LA158Accident · No injuriesLimited investigationFinal reportAeronca O-58B · Oshkosh, WIThe inadequate inspection by other maintenance personnel, and an inadequate preflight inspection by the pilot in command. A factor contributing to the accident was the reversal of the aileron cables.NTSB ANC92LA037Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Sitka, AKThe pilot/flight instructor's loss of directional control during the landing roll and the subsequent ground loop/swerve. Contributing to the accident was the gusty crosswind condition.NTSB CHI92LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Decorah, IAInadequate compensation for wind conditions, which resulted in a loss of directional control. Factors related to the accident were: the unfavorable wind conditions, snow covered runway, and snowbanks adjacent to the runway.NTSB SEA92LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Rawlins, WYAn inadequate weather evaluation. Factors to the accident were: gusts and crosswind.NTSB CHI91LA229Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lake Geneva, WIAircraft control was not maintained by the pilot. Factors related to the accident were a quartering tailwind.NTSB LAX91LA215Accident · No injuriesLimited investigationFinal reportTaylorcraft DC12-D · Las Vegas, NVThe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the pilot's lack of total experience in this type of aircraft.NTSB LAX91LA201Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Madera, CAThat the pilot failed to properly recover from a bounced landing. Contributing to this accident was the pilot's lack of experience in the airplane.NTSB MIA91LA130Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Leesburg, FLThe failure of the pilot to maintain directional control during the landig roll, and his failure to maintain airspeed during the attempted go-around which resulted in a descent and collision with two parked airplanes. Contributing to the accident was the…NTSB ATL91LA058Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Union Springs, ALThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve.NTSB LAX91LA077Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Bakersfield, CAThat the pilot failed to properly compensate for the wind conditions. Contributing to this accident was the existing crosswind.NTSB FTW90LA184Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Fort Worth, TXThe pilot in command's failure to maintain directional control. The crosswind was a factor.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 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.