NTSB investigations: Continental TSIO-520 series

79 cases on aircraft whose registry engine model is Continental TSIO-520 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 ('17040')
      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 LAX92FA174Accident · 5 fatalField investigationFinal reportCessna P210N · Baxter, CA1) A partial loss of the airplane's vacuum system which resulted in the total loss of the directional gyro and the attitude indicator, 2) the pilot not maintaining aircraft control due spatial disorientation, and 3) the pilot not correcting for a spiral by…Apr 12, 1992 · N9TG · DestroyedNTSB BFO92LA037Accident · No injuriesLimited investigationFinal reportPiper 46-310P · Lima, OHThe pilot failure to maintian adequate airspeed during final approach which resulted in a stall. Contributing to the accident was ice on the wings.Mar 10, 1992 · N4321L · Substantial damageNTSB ATL91FA161Accident · 3 fatalField investigationFinal reportCessna 402B · Kathleen, GAThe pilot's failure to maintain aircraft control while descending at night. Factors related to the accident were: darkness, fog, the pilot's lack of qualification in multi-engine aircraft, his lack of experience in this type of aircraft, his overconfidence in…Aug 16, 1991 · N5855M · DestroyedNTSB SEA91LA118Accident · No injuriesLimited investigationFinal reportBeech A36TC · Ogden, UTLoss of control by the pilot due to inadequate preflight planning and preparation which resulted in over gross weight aircraft loading. A factor relating to the accident was the high density altitude weather conditions.May 24, 1991 · N3671F · Substantial damageNTSB MIA91MA100Accident · 4 fatalMajor investigationFinal reportPiper PA-46-310P · Bronson, FLThe pilot's failure to activate the pitot heat before ascending above the freezing level in instrument meteorological conditions (IMC), followed by his improper response to erroneous airspeed indications that resulted from blockage of the pitot tube by…Mar 17, 1991 · N9112K · DestroyedNTSB NYC91LA031Accident · No injuriesLimited investigationFinal reportBeech B36TC · Caldwell, NJPremature rotation and an inadvertent stall. Factors include lack of total experience in this type of aircraft.Nov 18, 1990 · N38PK · Substantial damageNTSB SEA90FA066Accident · 2 fatalField investigationFinal reportMooney M20K · Carson City, NVThe pilot failed to maintain airspeed during takeoff. A contributing factor was the high density altitude.Apr 13, 1990 · N231NB · DestroyedNTSB NYC89LA066Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Newport, RILoss of control during an attempted go-around due to raising the flaps at low airspeed, in a nose high attitude.Jan 14, 1989 · N6556A · DestroyedNTSB NYC88FA216Accident · 2 fatalField investigationFinal reportCessna TU206G · White Lake, NYThe float equipped aircraft made multiple takeoff attempts on a lake, getting airborne at least once prior to the accident. On the takeoff run that terminated in the accident, the pilot turned into an inlet after getting airborne with insufficent room to turn…Aug 12, 1988 · N4613Z · Substantial damageNTSB LAX88FA245Accident · 4 fatalField investigationFinal reportCessna 320D · Mammoth Lakes, CAThe pilot executed a left (south) crosswind departure towards higher terrain after departing runway 27; the plt was following a slower single engine airplane that had preceded his departure. Ground witnesses reported that as the airplane approached the higher…Jul 4, 1988 · N9HS · DestroyedNTSB FTW87MA133Accident · 1 fatalMajor investigationFinal reportCessna P210R · Arnett, OKThe flt departed baton rouge (btr) for the plts stated dest of alexandria, which was 78 miles on a bearing of 301 deg, at 0836 CDT. After dep the btr local area there was no radio contact with any ATC facility. The transponder continued to transmit a code…Jun 3, 1987 · N5488A · DestroyedNTSB NYC87FA109Accident · 1 fatalField investigationFinal reportCessna P210R · Block Island, RIThe aircraft disappeared from the controller's scope while receiving radar vectors. The aircraft was missing until March 20, 1987 when fishermen pulled part of the wreckage out of ocean waters near Block Island, RI. The engine and propeller, engine firewall,…Mar 13, 1987 · N6434A · DestroyedNTSB CHI87DEM05Accident · Serious injuriesFinal reportCessna T210L · Lawton, MIThe plt experienced a loss of control shortly after takeoff which resulted in an uncontrolled descent. The acft struck the ground with its left wingtip causing it to flip over onto its side. The plt reported that the auto-plt had been worked on after having…Dec 6, 1986 · N999WF · Substantial damageNTSB FTW87LA004Accident · No injuriesLimited investigationFinal reportCessna T210N · Caddo, TXPrivate pilot in Cessna T210 attempted take off from soft, unimproved field, pilot and 1 passenger, 80 gallons fuel, crosswind component of 12 knots. Pilot rotated aircraft prematurely. Acft settled back to ground and became airborne with approximately 20 ft…Oct 10, 1986 · N5167Y · Substantial damageNTSB SEA86LA206Accident · No injuriesLimited investigationFinal reportCessna 340 · Prairie City, ORThe plt was attempting to land the acft on an unlit airstrip during dusk conditions. While attempting to align the acft with the center of the 30 foot wide airstrip the plt heard the stall warning horn sounding. During an attempted go around an inadvertent…Aug 13, 1986 · N2696U · Substantial damageNTSB SEA86LA124Accident · Minor injuriesLimited investigationFinal reportCessna 206T · Murphy, IDThe pilot attempted to land with excessive airspeed and altitude. A bounced landing occurred with a touchdown being more than 2/3 way down the runway. During VFR co-around, a departure stall was entered and the aircraft struck the ground with the left wing…May 13, 1986 · N1046V · Substantial damageNTSB LAX86FA077Accident · 2 fatalField investigationFinal reportCessna T210N · Hyder, AZWitnesses observed the acft depart the ranch airstrip, level off at about 200 ft AGL & make a turn back over the ranch house. The acft occupants were seen to wave to the people on the ground as the acft began an abrupt climbing turn. The witnesses then saw…Dec 29, 1985 · N4592Y · DestroyedNTSB LAX85LA331Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Taohoma, CAOn July 27, 1985 a float equipped Cessna TU206G landed on choppy water, nosed over and sank at the seaplane base in lake tahoe, CA. The pilot and 1 passenger were not injured. Witnesses reported that time water conditions were moderate chop with waves 2 to 5…Jul 28, 1985 · N6277Z · Substantial damageNTSB LAX85LA221Accident · Minor injuriesLimited investigationFinal reportCessna TU-206G · Pinon, AZAt the conclusion of a cross country business flt, plt initiated a straight in approach after monitoring the wind conditions by observing a flag, which he reported as 'limp.' Plt reported that touchdown occurred at '50 knots' following a full flap approach at…Apr 25, 1985 · N4877U · Substantial damageNTSB CHI85FA158Accident · 1 fatalField investigationFinal reportCessna T210N · Ravenna, OHThe plt departed port columbus uneventfully, flew for aprx 40 mins then shot a VOR apch to the mda at portage county. This fld does not have a wx reporting facility. The plt then performed a missed apch upon reaching mda. During the missed apch and after…Apr 11, 1985 · N9596Y · DestroyedNTSB ANC84LA177Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Point Hope, AKThe acft crashed during an attempted night takeoff with the plt controlled rwy lights turned off. The plt stated he had consumed a couple of alchoholic beverages earlier in the evening; and although approached by several people to fly, he stated he refused…Sep 16, 1984 · N731FT · Substantial damageNTSB NYC84FA269Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Richmond, NHThe plt was flying inbound for the ILS rwy 02 apch via the gardner VOR transition. While on the transition, the acft descended below the 4000 ft MSL min alt to 2600 ft MSL. The plt was alerted by ATC. He responded that his chart read 3000 ft. the acft then…Aug 13, 1984 · N4323G · DestroyedNTSB LAX84LA209Accident · No injuriesLimited investigationFinal reportCessna TU-206G · Auburn, CAThe plt came in for her 3rd landing and after flaring high'cut'the throttle and said she hoped for a'soft'landing with trim back and 40 degrees of flaps. A plt on the ground near the rwy said his attention was drawn to the acft because of a large increase in…Mar 8, 1984 · N206GA · Substantial damageNTSB LAX83LA367Accident · No injuriesLimited investigationFinal reportCessna T210M · Eureka, NVThe pilot had landed at this strip to attend a local rodeo. The airstrip was 2000 ft of loose gravel. The wind was calm,temperature 65 degrees, and the elevation was 5900 ft MSL, density alt was 7500 ft. the pilot used 10 degrees of flaps for takeoff. He said…Jul 31, 1983 · N761NF · Substantial damageNTSB LAX83LA142Accident · No injuriesLimited investigationFinal reportCessna T188C · Clarksburg, CAAccording to the plt, he was taking off from a narrow gravel strip with a x-wind when he encounter a strong gust. Reportedly, he lost control when the acft was about 1 ft AGL & the right main wheel hit a ditch. Subsequently, the acft was spun around & was…Mar 16, 1983 · N9957J · Substantial damageNTSB CHI83LA008Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Sparta, MIWitnesses observed a normal climb out, but as the acft cleared trees the plt began jettisoning the load. The plt stated that about 1/2 mi from the departure end of rwy 6 the acft seemed to mush & then descend into the trees. The wind at grand rapids, 20 mi…Oct 5, 1982 · N2892J · Substantial damageNTSB FTW82AA299Accident · 12 fatalFinal reportRobertson C-414 · Lindale, TX7-Seat acft took off with 4 adults & 8 children aboard. Acft rotated at about 2000 ft down rwy & climbed in a flat nose high attitude before settling into 30 ft trees about 4223 ft from point of lift-off. Acft oscillated violently 2 or 3 times in the pitch…Jul 29, 1982 · N110VM · DestroyedNTSB FTW82AA046Accident · 7 fatalFinal reportRobertson C-402B · Laredo, TXThe acft was observed to be extremely slow throughout the approach & that the plt appeared to be having some difficulty with over-controlling the acft. It then leveled out at 50-80 ft AGL on final over the threshold, entered a nose-high attitude & then…Jan 24, 1982 · N4244Z · DestroyedNTSB DEN82FA018Accident · 3 fatalField investigationFinal reportCessna T210N · 28 Mi Ene Ogden, UTDuring an IFR flt at 12,000 ft the plt contacted ATC & requested a higher altitude to get out of IMC. He was cleared to climb & maintain 14,000 ft. the plt acknowledged the clearance at 1855 & was not heard from again. Radar contact was lost at 1859.…Jan 16, 1982 · N6520Y · Destroyed