NTSB investigations: Continental C85 series
2,292 cases on aircraft whose registry engine model is Continental C85 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 ('17008'))
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'))
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 NYC95LA206Accident · No injuriesLimited investigationFinal reportCessna 140 · Richmond, RIThe pilot's mismanagement of the fuel supply, and his improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power.NTSB FTW95LA365Accident · Serious injuriesLimited investigationFinal reportFunk, D.D. B-85C · Grants, NMa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI95LA291Accident · 1 fatalLimited investigationFinal reportCessna 140 · Mio, MIthe pilot's impairment of judgement and performance which led to performing a low altitude maneuver with insufficient altitude for recovery. A factor was the tailwind.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 CHI95LA275Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Lowell, INa loss of engine power due to carburetor ice. The lack of suitable terrain for a forced landing was a factor.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 LAX95LA212Accident · No injuriesLimited investigationFinal reportTupta-Smith Miniplane DSA-1 · Pacoima, CAfuel contamination.NTSB ANC95LA074Accident · Serious injuriesLimited investigationFinal reportChampion 11BC-S · Anchorage, AKThe pilot's improper compensation for the wind conditions. Factors associated with the accident are gusty winds and associated downdrafts.NTSB FTW95LA236Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Farmington, NMFailure by the pilot to maintain directional control.NTSB ANC95FA063Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Palmer, AKThe pilot's inadvertent stall. A factor in the accident was the pilot's emotional reaction to the vehicle travelling through his yard.NTSB FTW95LA223Accident · No injuriesLimited investigationFinal reportCessna 120 · College Station, TXThe pilot's inability to maintain directional control after encountering wake turbulence from a landing airplane. A factor was the tailwind.NTSB BFO95LA039Accident · Serious injuriesLimited investigationFinal reportPiper J3-C65 · Bayport, NYThe pilot's improper positioning of the fuel selector.NTSB BFO95LA040Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lakewood, NJThe pilot's inadequate compensation for wind conditions and his inadequate evaluation of the weather conditions which resulted in an overrun. A factor is the sudden windshift.NTSB LAX95FA145Accident · Minor injuriesField investigationFinal reportLuscombe 8E · Compton, CAThe pilot's poor preflight inspection, the mechanic's poor annual inspection, and the leaking fuel caps which allowed water to contaminate the fuel.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 FTW95LA137Accident · No injuriesLimited investigationFinal reportCessna 140 · Fentress, TXThe sudden movement of an animal into the path of the aircraft during takeoff roll. Factors were the inability of the pilot to establish a visual lookout down the runway due to the runway's 'crowned' midpoint.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 SEA95LA047Accident · No injuriesLimited investigationFinal reportCessna 120 · Scappoose, ORThe pilot's improper recovery from a bounced landing and inadvertent use of the brakes.NTSB FTW95LA108Accident · No injuriesLimited investigationFinal reportCraighead Corben JR. ACE · Athens, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB ANC95LA026Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Dutch Harbor, AKThe partial failure of the right brake due to a leaky brake line.NTSB ANC95LA022Accident · No injuriesLimited investigationFinal reportCessna 140 · Tok, AKThe pilot's attempt to fly into known adverse weather. A factor related to the accident was the icing conditions.NTSB LAX95LA055Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hemet, CAThe other aircraft pilot's inadequate bounced landing recovery and his failure to maintain directional control.NTSB LAX95LA054Accident · No injuriesLimited investigationFinal reportCessna 120 · Torrance, CAA blockage in the carburetor heat air duct which limited the effectiveness of the system's ability to prevent the formation of carburetor ice and resulted in a loss of power. A factor in the accident was the soft nature of the recently plowed ground in the…NTSB FTW95LA065Accident · No injuriesLimited investigationFinal reportCommonwealth Rearwin 185 · Longmont, COOil exhaustion and subsequent engine seizure due to a missing oil drain plug. Factors were the inadequate maintenance and the lack of suitable terrain for a forced landing.NTSB NYC95LA036Accident · No injuriesLimited investigationFinal reportPiper J3C · Waldoboro, METhe pilot's premature lift off which resulted in insufficient climb performance and collision with trees.NTSB FTW94LA307Accident · No injuriesLimited investigationFinal reportCessna 140 · Nenana, AKThe pilot's excessive use of the brakes during the aborted takeoff.NTSB ANC94LA136Accident · No injuriesLimited investigationFinal reportCessna 140 · Willow, AKThe pilot's improper starting procedures. Factors in the accident were the unavailability of a parking brake and tiedowns to secure the airplane.NTSB ATL94LA170Accident · 1 fatalLimited investigationFinal reportPiper J-5A · Raeford, NCThe pilot's ostentatious display which resulted in a loss of control of the airplane.NTSB CHI94LA311Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Cassoday, KSthe attempted low level flight/maneuver with inadequate visual lookout by the pilot-in-command.NTSB BFO94LA158Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Ravenswood, WVThe poorly planned approach which resulted in unporting of fuel from the left fuel tank and loss of engine power due to fuel starvation.NTSB CHI94LA285Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hettinger, NDthe pilot's improper use of the wheel brakes.NTSB CHI94LA278Accident · No injuriesLimited investigationFinal reportCessna 120 · Manitowoc, WIthe private pilot's improper use of brakes during the landing roll. A related factor is his lack of total experience.NTSB NYC94LA152Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Schuylerville, NYthe pilots failure to maintain adequate airspeed, which resulted in a stall/mush.NTSB ANC94LA065Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Wassila-Cheri, AKCarburetor ice collecting in the carburetor throat and the pilot's failure to use carburetor heat during the extended water taxi.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 ANC94LA058Accident · No injuriesLimited investigationFinal reportPiper J5A · Lake George, AKThe pilot's failure to maintain clearance from trees during takeoff. A factor in the accident was the bent gear leg.NTSB NYC94LA088Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Berwick, METhe pilot's inadequate preflight which fail to detect proper operation of the elevator which resulted in the loss of control inflight. A factor is inadequate maintenance which consisted of misrigging of the elevator flight controls.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 SEA94LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Snohomish, WAPoor in-flight planning/decision. A factor to the accident was: high vegetation.NTSB FTW94LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Hempstead, TXThe pilot's improper selection of the strip between the two runways. Factors were the pilot not being familiar with the airstrip and the soft, wet terrain.NTSB SEA94LA099Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Coalville, UTThe failure of the connecting rod. Factors include the rough uneven terrain encountered during the forced landing.NTSB ATL94LA067Accident · 1 fatalLimited investigationFinal reportCessna 140 · Celina, TNThe pilot's failure to maintain a proper altitude, and his failure to maintain clearance from the transmission wire.NTSB LAX94LA167Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Stallion Spring, CAThe pilot's continued VFR flight into instrument meteorological conditions. His failure to obtain a weather briefing, the low clouds, and the mountainous terrain were factors in the accident.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 LAX94LA170Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Santa Paula, CAthe existing meteorological conditions that were conducive to carburetor icing.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 BFO94LA039Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Chittenango, NYThe pilot's inadequate planning/decision to take off with the presence of a tailwind.NTSB SEA94LA050Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Burns, ORThe student pilot in command's application of excessive braking during the landing roll.