NTSB investigations: Continental C85 series
133 cases on aircraft whose registry engine model is Continental C85 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 ('17008')
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 ('17008')
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 LAX97LA273Accident · No injuriesLimited investigationFinal reportCessna 140 · Pacoima, CAThe pilot's failure to maintain directional control of the aircraft during landing.NTSB LAX97LA223Accident · No injuriesLimited investigationFinal reportCessna 140 · Columbia, CAthe student pilot's failure to maintain directional control of the aircraft during a bounced landing recovery.NTSB LAX97LA216Accident · No injuriesLimited investigationFinal reportCessna 120 · Hollister, CAthe pilot's excessive use of right rudder during the initial stages of the takeoff ground roll, which resulted in his failure to maintain directional control. The unfavorable wind was a related factor.NTSB IAD97LA066Accident · No injuriesLimited investigationFinal reportGlobe GC-1-A · Wilmington, OHfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in a collision with trees. Related factors were: the crosswind, and lack of experience in the make and model of airplane.NTSB MIA97LA029Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Charlotte, NCfailure of the pilot maintain directional control of the aircraft, while landing. The proximity of trees was a related factor.NTSB SEA96LA210Accident · No injuriesLimited investigationFinal reportCessna 120 · Nampa, IDthe solo student pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop/swerve.NTSB CHI96LA111Accident · No injuriesLimited investigationFinal reportCessna 140 · Ulysses, KSFailure of the pilot to maintain directional control of the airplane during the takeoff roll, and his improper use of brakes and elevator control, while aborting the takeoff. A factor relating to the accident was the gusty wind condition.NTSB CHI95LA321Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Boyne Falls, MIthe pilot's failure to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB BFO95LA086Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Batavia, OHwas the the second pilot's loss of directional control during the takeoff roll, and the flight instructor/pilot-in-command's inadequate supervision of the flight instructor/second pilot. A related factor was the flight instructor/second pilot's lack of total…NTSB CHI95LA228Accident · Serious injuriesLimited investigationFinal reportReed RS15 · Ames, IAThe glider pilot's inadequate preflight of the glider by failing to properly secure a push-pull tube to the glider's right ruddervator; and failure of both the glider pilot and the tow pilot to release the tow rope, which led to a stall of the tow airplane.NTSB LAX95LA247Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Columbia, CAthe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain directional control.NTSB FTW95LA236Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Farmington, NMFailure by the pilot to maintain directional control.NTSB SEA95LA067Accident · No injuriesLimited investigationFinal reportCessna 140 · Ogden, UTDirectional control was not maintained. Factors to the accident were a lack of total experience in type of aircraft and crosswind.NTSB LAX95LA115Accident · No injuriesLimited investigationFinal reportSkov-Papworth Q2 · Hollister, CAthe pilot's failure to maintain directional control of the aircraft during the takeoff ground roll. The pilot's lack of recent experience is a factor in the accident.NTSB NYC94LA095Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-E · Warrenton, VAthe pilot did not maintain directional control of the airplane during an aborted takeoff, which resulted in the airplane veering off the runway and nosing over. A factor in this accident was the pilot's lack of experience on grass strips in this make and…NTSB FTW94LA153Accident · No injuriesLimited investigationFinal reportCessna 120 · Goodyear, AZThe pilot's failure to maintain directional control. A factor was the gusty crosswind.NTSB FTW94LA148Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Lancaster, TXThe pilot's failure to use tie downs and proper assistance during the hand propping engine start.NTSB LAX94LA161Accident · No injuriesLimited investigationFinal reportLuscombe 8EZ · Prescott, AZthe flying pilot's inadequate compensation for the existing crosswind condition, his failure to maintain directional control, and the inadvertent entry into a ground loop. A factor in the accident was the flying pilot's lack of experience in conventional…NTSB LAX94LA131Accident · No injuriesLimited investigationFinal reportPiper J5A-L4F · Kernville, CAthe pilot's improper use of the flight controls resulting in his failure to maintain directional control. The existing crosswind is a factor in this accident.NTSB FTW94LA062Accident · No injuriesLimited investigationFinal reportCessna 140 · Espanola, NMWas the dual student pilot's failure to maintain directional control. A factor was the certificated flight instructor's inadequate supervision.NTSB CHI93LA358Accident · No injuriesLimited investigationFinal reportCessna 140 · Trenton, ILFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.NTSB ANC93LA104Accident · No injuriesLimited investigationFinal reportCessna 140 · Juneau, AKThe pilot's failure to maintain directional control. A factor to the accident was the pilot's lack of total experience.NTSB ANC93LA073Accident · No injuriesLimited investigationFinal reportCessna 140 · Dillingham, AKThe pilot in command's failure to maintain proper runway alignment.NTSB SEA93LA126Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Vancouver, WAThe pilot's inadequate remedial action. Factors include crosswinds, gusts, and the pilot's lack of total experience in tailwheel type aircraft.NTSB FTW93LA110Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Abbeville, LAThe pilot's failure to compensate for crosswind conditions and the subsequent loss of directional control. Factors were the gusting crosswinds and the soft wet groundNTSB ATL93LA048Accident · No injuriesLimited investigationFinal reportCessna 120 · Bessemer, ALThe failure of the pilot to maintain directional control during take off.NTSB LAX92LA364Accident · No injuriesLimited investigationFinal reportCessna 140 · Reedley, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll and his excessive use of the brakes.NTSB ANC92LA121Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BCS12-D · Sitka, AKThe pilots failure to maintain directional control of the airplane. Contributing to the accident were the crosswind and the large boulders (objects) beside the runway.NTSB CHI92LA144Accident · No injuriesLimited investigationFinal reportErcoupe 415-E · Berlin, WIThe pilot's inadequate compensation for the crosswind during the takeoff roll.NTSB ATL92LA094Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Wilmington, NCThe pilot's failure to obtain proper assistance during the engine starting procedure, and his failure to properly attend to the airplane with the engine running.NTSB CHI92LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbury, NEThe pilot's improper use of the brakes. An associated factor is the pilot's lack of total experience in the type airplane.NTSB FTW92LA028Accident · No injuriesLimited investigationFinal reportCessna 120 · Las Cruces, NMThe pilot's failure to maintain directional control. A factor was the tailwind.NTSB CHI91LA238Accident · No injuriesLimited investigationFinal reportCessna 140 · Cadillac, MIImproper compensation for wind conditions resulting in aircraft control not being maintained. Factors related to the accident were a gusty crosswind condition and lack of total experience by the pilot.NTSB CHI91LA118Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Flushing, MIThe pilot's failure to attain proper runway alignment and not maintaining directional control which resulted in a ground loop. Factors relating to this accident were the gusty crosswind conditions which existed at the time.NTSB LAX91LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZThat the pilot improperly used the flight controls and brakes. Contributing to this accident was an existing cross/tailwind.NTSB CHI91LA066Accident · No injuriesLimited investigationFinal reportCessna 140 · So. Sioux City, NEDirectional control not maintained by the pilot-in-command. Factors related to the accident were a snow covered runway and a lack of recent experience.NTSB LAX90LA342Accident · No injuriesLimited investigationFinal reportPiper J-3C-115 · Wickenburg, AZThe pilot's failure to maintain directional control.NTSB MIA90LA127Accident · No injuriesLimited investigationFinal reportCessna 140 · Opa-Locka, FLLoss of control during the landing roll due to the instructor pilot's lack of experience in tailwheel equipped aircraft.NTSB ANC90LA072Accident · No injuriesLimited investigationFinal reportCessna C-140 · Minto, AKUncertificated pilot's failure to become qualified to operate an aircraft and gain the ability to recognize and respond to crosswind situations.NTSB LAX90LA163Accident · No injuriesLimited investigationFinal reportCessna 140 · Paso Robles, CAThe pilot failed to maintain directional control.NTSB LAX90LA154Accident · No injuriesLimited investigationFinal reportCessna 120 · Phoenix, AZThe pilot failed to maintain directional control by improperly using the rudders/tall wheel steering.NTSB MKC90LA096Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Thedford, NEThe pilot in command's failure to compensate for wind while landing resulting in loss of directional control and collision with terrain.NTSB LAX89LA261Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Rio Linda, CAFailure of the pilot to maintain proper runway alignment during an aborted landing. Related factors were: a false airspeed indication, the pilot's lack of familiarity with the aircraft, his improper use of carburetor heat, his diverted attention, and the…NTSB MKC89LA133Accident · No injuriesLimited investigationFinal reportCessna 140 · Creve Ceour, MOThe failure of the pilot to plan the approach and maintain alignment with the sod landing strip. The pilot's innattention to the grass strip resulted in a landing in a soft wheat field.NTSB CHI89LA089Accident · No injuriesLimited investigationFinal reportCessna 140 · Terre Haute, INPilot's inability to maintain directional control during the takeoff roll. A factor in the accident was the crosswind.NTSB DEN89LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMImproper use of brakes which resulted in an inadvertent ground swerve.NTSB BFO88LA021Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Orange, VAAccording to the plt, during the landing roll the acft drifted to the right and before he could take corrective action the acft ground looped. He had 3 hrs of total time in this make/model acft. The plt rptd he was late applying corrective rudder forces. He…NTSB MKC87LA174Accident · No injuriesLimited investigationFinal reportCessna 120 · Creighton, NEThe flt dptd harvard, NE., with a dest of wausa, NE abt 1 hrs flying dist to the northeast. The departure commenced abt 1 hr and 40 min's prior to dark. The PIC stated he encountered strong headwinds along the route which delayed his progress. The acft…NTSB ANC87LA145Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kahlitna Glac, AKThe pilot stated after touchdown on the lake, he lost directional control of the aircraft causing the plane to nose over on its back and the aircraft sank in 20 to 25 feet of water.NTSB LAX87LA042Accident · No injuriesLimited investigationFinal reportCessna 120 · Columbia, CAAt the beginning of a local pleasure flight, the pilot lost control of the aircraft while practicing high speed taxiing for directional control for takeoffs and landings. Upon reaching liftoff speed, the power was reduced to idle. The aircraft swerved to the…