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.

NTSB CEN09CA302Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Gallup, NMThe pilot's inadequate preflight planning. Contributing to the accident was the high density altitude.May 16, 2009 · N94300 · Substantial damageNTSB CEN09CA258Accident · No injuriesData collectionFinal reportMarlin Varieze · Santa Teresa, NMThe pilot's failure to maintain control of the airplane, his failure to latch the canopy prior to takeoff, and his failure to complete the pretakeoff checklist due to his diverted attention.Apr 20, 2009 · N77JM · Substantial damageNTSB WPR09LA201Accident · No injuriesLimited investigationFinal reportBrinker / Garner BI-PLANE · Caldwell, IDLoss of control during the landing roll for undetermined reasons.Apr 17, 2009 · N375CB · Substantial damageNTSB WPR09CA126Accident · No injuriesData collectionFinal reportErcoupe 415-E · Camas, WAThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.Feb 19, 2009 · N94805 · Substantial damageNTSB ERA09CA171Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAA loss of engine power, as reported by the pilot, for undetermined reasons.Jan 12, 2009 · N57N · Substantial damageNTSB CEN09LA128Accident · 1 fatalLimited investigationFinal reportProbst Baby Ace D · Kilgore, TXA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning. Contributing to the accident was the pilot's failure to maintain situational awareness, resulting in him being lost.Jan 12, 2009 · N610DD · Substantial damageNTSB WPR09CA058Accident · No injuriesData collectionFinal reportCessna 140 · Preston, IDThe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a loss of control and subsequent nose over.Dec 17, 2008 · N4008N · Substantial damageNTSB ERA09FA087Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Sebring, FLThe pilot's exceedance of the design stress limitations of the airplane.Dec 13, 2008 · N99154 · Substantial damageNTSB CEN09CA050Accident · No injuriesData collectionFinal reportAeronca 7CCM · Chadron, NEThe pilot's failure to maintain direction control of the airplane. Contributing to the accident was the pilot's lack of experience.Nov 2, 2008 · N2259E · Substantial damageNTSB ERA09CA014Accident · Serious injuriesData collectionFinal reportPiper J3C-50 · Epping, NHThe pilot's improper preflight inspection and his decision to fly an unairworthy airplane.Oct 12, 2008 · N23267 · Substantial damageNTSB MIA08CA201Accident · Serious injuriesData collectionFinal reportCox Clyde H Fshr Aero Vsns Clbty · Tampa, FLThe pilot’s failure to maintain control of the airplane during takeoff due to inadequate maintenance.Sep 25, 2008 · N716HJ · Substantial damageNTSB MIA08LA196Accident · No injuriesLimited investigationFinal reportCessna 120 · Jesup, GAAn oil starvation-induced catastrophic engine failure due to the improper installation of the crankshaft expansion plug during engine overhaul.Sep 19, 2008 · N77068 · Substantial damageNTSB NYC08CA297Accident · No injuriesData collectionFinal reportErcoupe 415-C · Sebring, FLA bird strike which substantially damaged the propeller and required the engine to be secured. Contributing to the accident was the damaged propeller.Aug 29, 2008 · N87376 · Substantial damageNTSB CHI08CA208Accident · Serious injuriesData collectionFinal reportErcoupe 415-G · West Jefferson, OHThe improper preflight planning/preparation by the pilot and the loss of engine power due to fuel exhaustion during takeoff. Contributing factors were the pilot’s expired flight review and airman medical, the aircraft weight and balance exceeded by the pilot,…Jul 23, 2008 · N94413 · Substantial damageNTSB DFW08CA185Accident · Minor injuriesData collectionFinal reportStits SA3A · St Louis, MOThe pilot's failure to maintain control of the airplane during takeoff.Jul 14, 2008 · N134JW · Substantial damageNTSB LAX08CA204Accident · No injuriesData collectionFinal reportAeronca 7DC · Elk River, IDThe pilot's failure to maintain directional control.Jun 29, 2008 · N83056 · Substantial damageNTSB LAX08LA161Accident · Minor injuriesLimited investigationFinal reportDavison Vari Eze · Arlington, WAA loss of engine power for undetermined reasons.Jun 2, 2008 · N644VZ · Substantial damageNTSB DEN08LA096Accident · Minor injuriesLimited investigationFinal reportCommonwealth 185 · Roanoke, TXThe pilot's physiologic impairment and failure to attain the proper touchdown point during an intentional off airport landing. Contributing to the accident was the pilot's improper in-flight planning.May 24, 2008 · N33384 · Substantial damageNTSB CHI08CA127Accident · Minor injuriesData collectionFinal reportCessna 140 · Burlington, WIA loss of engine power for undetermined reasons. Contributing to the accident was the low altitude at the time of the loss of engine power.May 9, 2008 · N89307 · Substantial damageNTSB DFW08LA106Accident · Serious injuriesLimited investigationFinal reportTomblingson-Leathers Breezy RLU-1 · Groveton, TXThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the forced landing. Contributing factors were the non-suitable terrain for the forced landing and the pilot's lack of experience in the airplane.Apr 19, 2008 · N3921 · Substantial damageNTSB SEA08CA075Accident · No injuriesData collectionFinal reportCessna 140 · Logan, UTThe dual-student's excessive brake application, and the flight instructor's inadequate supervision of the flight.Feb 9, 2008 · N72957 · Substantial damageNTSB LAX08CA051Accident · No injuriesData collectionFinal reportLuscombe 8E · Brigham City, UTThe failure of the landing gear/ski attachment assembly due to inadequate maintenance.Jan 20, 2008 · N71730 · Substantial damageNTSB CHI08CA056Accident · No injuriesData collectionFinal reportErcoupe 415D · Abingdon, ILThe loose clamp on the throttle cable which prevented application of engine power. A factor in the accident was the low altitude when the throttle cable slipped.Dec 29, 2007 · N94131 · Substantial damageNTSB NYC08CA058Accident · No injuriesData collectionFinal reportFisher Aero Celebrity · White Plains, ALA propeller failure during cruise flight.Dec 8, 2007 · N43682 · Substantial damageNTSB NYC08CA036Accident · Minor injuriesData collectionFinal reportCessna 120 · Ocala, FLThe pilot's failure to maintain proper runway alignment during landing.Nov 13, 2007 · N120AB · Substantial damageNTSB DEN08CA026Accident · No injuriesData collectionFinal reportCessna 140 · Poultney, VTThe pilot's attempt to land on an unimproved airstrip resulting in a ground loop/swerve. Factors contributing to the accident were the pilot's poor judgement in attempting to land on an unsuitable runway and the unsuitable runway conditions.Nov 5, 2007 · N89120 · Substantial damageNTSB ANC08CA005Accident · No injuriesData collectionFinal reportTaylorcraft F-19 · Wasilla, AKThe flight instructor's delayed remedial action during the takeoff roll, which resulted in an overrun during an aborted takeoff, and a collision with trees.Oct 20, 2007 · N6628N · Substantial damageNTSB LAX07CA283Accident · No injuriesData collectionFinal reportLuscombe 8E · Ramona, CAthe installation and subsequent failure of an incorrect part, which jammed in one wheel's brake caliper and induced the pilot's loss of directional control.Sep 29, 2007 · N2826K · Substantial damageNTSB DFW07CA195Accident · No injuriesData collectionFinal reportCessna 140 · Lubbock, TXThe pilot's failure to maintain directional control of the airplane while landing. A contributing factor was the flight instructor's delay in taking remedial action.Sep 8, 2007 · N72699 · Substantial damageNTSB LAX07CA252Accident · No injuriesData collectionFinal reportCessna 140 · Olympia, WAThe pilot's failure to maintain directional control during landing.Aug 15, 2007 · N4084N · Substantial damageNTSB NYC07LA192Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Frenchtown, NJA partial loss of engine power for undetermined reasons.Aug 12, 2007 · N6429H · Substantial damageNTSB SEA07LA217Accident · 2 fatalLimited investigationFinal reportTaylorcraft BF12 · West Linn, ORThe corrosion, fatigue fracture, and subsequent separation of the left wing lift strut attachment fitting. Also causal was the inadequate maintenance and annual inspection by the owner/pilot/mechanic.Jul 28, 2007 · N13060 · Substantial damageNTSB DFW07CA177Accident · No injuriesData collectionFinal reportAeronca Champion · Kirbyville, TXThe pilot's inability to maintain directional control during takeoff roll as result of the failure of the airplane's tailwheel's steering arm.Jul 25, 2007 · N9870B · Substantial damageNTSB MIA07LA124Accident · Minor injuriesLimited investigationFinal reportDennis M. Durgin Junior Ace · Dover-Foxcroft, METhe failure of the pilot to maintain airspeed following total loss of engine power due to fuel starvation, resulting in a stall/mush, uncontrolled descent, and in-flight collision with trees.Jul 21, 2007 · N9778N · Substantial damageNTSB SEA07CA176Accident · Minor injuriesData collectionFinal reportCommonwealth 185 · Redlands, CAThe pilot's inadequate weather evaluation which resulted in the airplane's lack of climb performance and subsequent collision with terrain. Contributing factors included the downdraft and the high temperature.Jun 22, 2007 · N92827 · Substantial damageNTSB SEA07CA128Accident · No injuriesData collectionFinal reportForney F-1 · Morgan, UTThe pilot's failure to maintain clearance of the hill on final approach to a landing. Contributing factors were the downdraft weather condition, the hilly terrain, and his lack of familiarity with the geographical area.May 18, 2007 · N3007G · Substantial damageNTSB ANC07CA025Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Hope, AKThe pilot's selection of an unsuitable taxi area, which resulted in a loss of control during the taxi from landing.Mar 3, 2007 · N44233 · Substantial damageNTSB SEA07CA054Accident · No injuriesData collectionFinal reportCessna 140 · Murrieta, CAThe pilot's excessive application of brakes during taxi after landing, resulting in a nose over.Jan 23, 2007 · N2006V · Substantial damageNTSB DEN07CA052Accident · No injuriesData collectionFinal reportCessna 120 · La Salle, COThe pilot's failure to maintain clearance from the ground. Contributing factors included the pilot's intentional low pass and his misjudging his altitude.Jan 17, 2007 · N1670V · Substantial damageNTSB SEA07CA047Accident · No injuriesData collectionFinal reportCessna 140 · San Jose, CAThe pilot's excessive use of the airplane's wheel brakes, which resulted in a nose over during landing.Jan 14, 2007 · N18WB · Substantial damageNTSB LAX07LA081Accident · No injuriesLimited investigationFinal reportCessna 140 · Van Nuys, CAFailure of the pilot under instruction to maintain directional control of the airplane and the flight instructor's inadequate supervision.Dec 30, 2006 · N9198Z · Substantial damageNTSB CHI07LA039Accident · No injuriesLimited investigationFinal reportCessna 140 · Vienna, MOThe loss of engine power during cruise flight due to fatigued crankshaft cluster gear bolts and the inadequate major overhaul of the engine that was last performed by other maintenance personnel. An additional cause was a subsequent major engine overhaul not…Dec 9, 2006 · N76379 · Substantial damageNTSB CHI07CA031Accident · No injuriesData collectionFinal reportCessna 120 · Perryville, MOThe pilot's failure to maintain directional control during landing which resulted in an overload of the tailwheel attachment structure in the fuselage.Nov 23, 2006 · N1915N · Substantial damageNTSB CHI06LA268Accident · 1 fatalLimited investigationFinal reportWindler Tri Q2 · Branson, MOFatigue failure, originating in an area of surface corrosion, of the right elevator mid span hinge pin and the subsequent failure of the elevator torque tube. Additional causes are the separation of the elevator from the airframe due to the hinge pin and…Sep 22, 2006 · N6628K · DestroyedNTSB ANC06LA129Accident · No injuriesLimited investigationFinal reportPiper J5A · North Pole, AKThe pilot's inadequate in-flight planning, which resulted in a loss of engine power due to fuel starvation during cruise flight, and an emergency landing.Aug 30, 2006 · N35395 · Substantial damageNTSB NYC06CA188Accident · No injuriesData collectionFinal reportCessna 120 · Ashland, KYThe pilot's improper fuel tank selection, which resulted in fuel starvation and a subsequent loss of engine power. A factor in the accident was the trees.Jul 30, 2006 · N1981V · Substantial damageNTSB DEN06CA106Accident · No injuriesData collectionFinal reportCessna 140 · Cunningham, KSthe pilot's failure to maintain directional control during the aborted takeoff. A contributing factor was the mud.Jul 28, 2006 · N89669 · Substantial damageNTSB ANC06LA094Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Willow, AKThe pilot's misjudged distance/altitude during landing, which resulted in an undershoot and an in-flight collision with trees.Jul 20, 2006 · N2438K · Substantial damageNTSB SEA06CA144Accident · No injuriesData collectionFinal reportPiper PA-11 · Turner, MTThe passenger's inadvertent activation of the airplane's brakes during the landing roll, resulting in the pilot's loss of control and subsequent nose over. A factor was the pilot's inadequate preflight planning/preparation by not briefing the passenger about…Jul 15, 2006 · N4706H · Substantial damageNTSB DFW06CA185Accident · No injuriesData collectionFinal reportCessna 120 · Rockwall, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the prevailing crosswind.Jul 15, 2006 · N2591N · Substantial damage