NTSB investigations: Continental C85 series

64 cases on aircraft whose registry engine model is Continental C85 series, where the first occurrence was “Loss of control - in flight”. 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\" = 250))
  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 BFO85LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Chesapeake, VAThe student plt was making a takeoff from rwy 20 with an estimated 10 kt right x-wind. After about 800 ft of ground run, the acft lifted off at aprx 65 mph. At an alt of about 30 ft, the acft began to settle in a left drift as it flew abeam trees on the right…May 6, 1985 · N2034V · Substantial damageNTSB FTW85FA209Accident · 2 fatalField investigationFinal reportLuscombe 8E · Verden, OKAt about 1700 CDT on 5/5/85, the acft was observed taking off at chickasha, OK. At sometime after 1700, an acft matching its description was observed flying low over a lake. A witness in that area observed it pulled up in a steep climb over the dam, until it…May 5, 1985 · N2497K · DestroyedNTSB CHI85LA187Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Strongsville, OHWhile on final apch the headwind changed to a quartering left crosswind. A sudden loss of alt occurred and the acft contacted the displaced threshold and weathervaned into the wind. The acft traveled off the side of the rwy and nosed over in an area of grass.May 5, 1985 · N89599 · Substantial damageNTSB NYC85FNC01Accident · Serious injuriesFinal reportPiper J-3 · Rutland, VTWitnesses related that as the acft got airborne the wings wobbled and the acft descended out of control to impact. Local law enforcement officers found evidence that the acft struck trees before colliding with the terrain.Nov 25, 1984 · N19AN · DestroyedNTSB NYC84LA258Accident · Serious injuriesLimited investigationFinal reportPiper J58 · Gilead, METhe acft was forced to land according to the plt, after a downdraft at low alt & airspeed created a trap. The plt said that he & a friend were looking for a fishing spot, when he realized that he could not make it over the top of rising terrain ahead & could…Jul 29, 1984 · N38402 · Substantial damageNTSB MKC84FA157Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Norfolk, NEThree witnesses stated the acft entered a steep climb after lift-off and continued climbing to an alt of aprx 250 to 350 ft AGL, stalled and spun to the rwy. The acft impacted the rwy 1100 ft from the apch end in a nose low and left wing low attitude.Jun 3, 1984 · N42497 · Substantial damageNTSB CHI84LA206Accident · Serious injuriesLimited investigationFinal reportErcoupe 415C · Sturtevant, WIAccording to the plt, he was making a hi speed taxi check when the acft lifted off to about 5 ft AGL. After lift-off, the acft began to go to the left. When the plt applied right rudder, the plane veered further left & crashed in an onion field. An exam of…May 27, 1984 · N93939 · Substantial damageNTSB ATL83FKJ05Accident · 2 fatalFinal reportAeronca 7BCM L-16A · Gadsden, ALThe acft collided with the ground in a 70 degree dive while taking part in an air show as a spotter plane. The acft had dropped one smoke grendade and was orbiting to drop another when it turned left and pitched down. According to an inspection guide for this…Jul 9, 1983 · N2557B · DestroyedNTSB ATL83FKQ02Accident · Serious injuriesFinal reportCessna 140 · New Albany, MSThe student plt was instructed to make 1 or 2 landings after returning from a solo cross-country flt. He was unable to recall details of the accident, but his wife was at the airport & was a witness. According to her, the plt made a go-around on his first…May 10, 1983 · N76379 · Substantial damageNTSB DEN83FTM02Accident · 2 fatalFinal reportPiper J3C-65 · Near Holden, UTThe student pilot and his wife had flown from salt lake city to Holden, UT. According to his father, the plane crashed in an open field while the pilot was flying low and looking for a place to land. The plane crashed in an open grain field in about a 15 deg…Nov 6, 1982 · N67084 · Substantial damageNTSB CHI82DA319Accident · No injuriesFinal reportCessna 120 · St. Paul, MNPilot did not stow starter crank properly. During a landing the aircraft touched down almost sideways, went down on a wingtip and up on its nose. The starter crank was found jammed in the rudder controls.Aug 22, 1982 · N76778 · Substantial damageNTSB MKC82DA141Accident · Minor injuriesFinal reportCessna 140 · West Plains, MOThe pilot was practicing short field takeoffs and maneuvered to clear a 50 foot barrier. He stalled the aircraft and was unable to recover before impacting the ground, nose and right wing first.Aug 10, 1982 · N2319V · Substantial damageNTSB CHI82DA258Accident · No injuriesFinal reportLuscombe 8F · Belleville, MIDuring the approach the acft stalled about 20 ft AGL. The plt added power but the acft touched down short of the rwy & collided with a ditch.Jul 16, 1982 · N5PL · Substantial damageNTSB MKC82FCG17Accident · 1 fatalFinal reportErcoupe 415-C · Topeka, KSThe aircraft crashed and burned during takeoff at 1303 CST. The pilot received second degree burns over 20 per cent of his body and expired on 3/9/82. Two sailplanes were damaged by impact and fire, and a third sailplane received fire damage. The pilot…Mar 2, 1982 · N93846 · Destroyed