NTSB investigations: Continental TSIO-520 series, AZ

79 cases on aircraft whose registry engine model is Continental TSIO-520 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.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17040'))
  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 LAX87LA064Accident · No injuriesLimited investigationFinal reportCessna P210N · Chandler, AZWhile the plt was receiving vectors for arrival at Chandler, AZ, the eng lost power. Subsequently, the plt made an emergency landing about 1 mi north of the arpt. He rprtd that he had filled the fuel tanks at Chandler & had flown to durango, co on 12/5/86. On…Dec 15, 1986 · N3605P · Substantial damageNTSB LAX87LA037Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Buckeye, AZA Cessna T210N crashed when the pilot attempted to underfly wires during a go-around. The pilot misjudged the surface winds and made his final approach with a tail wind. When he passed the midpoint on the 2,600 ft airstrip and still was not on the ground he…Nov 11, 1986 · N1625U · Substantial damageNTSB LAX86LA103Accident · No injuriesLimited investigationFinal reportCessna T210N · Tucson, AZThe plt planned to fly nonstop fm houston, TX, to phoenix, AZ. He reported that during the trip he encountered 'fluctuating head winds' & he miscalculated the acft's endurance. Fuel exhaustion occurred 8 miles fm Tucson, AZ., & the plt made a successful…Jan 2, 1986 · N6594Y · 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 LAX85LA257Accident · Serious injuriesLimited investigationFinal reportCessna T303 · Mesa, AZPlt took off from scottsdale at 1934 MST for a 13 NM flt to reposition the acft to home base. Within minutes the plt advised ATC that he was 6 mi out with minimum fuel and requested no delay. He then asked for clearance to rwy 22R and was cleared to land on…May 14, 1985 · N4661V · DestroyedNTSB 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 LAX84LA427Accident · No injuriesLimited investigationFinal reportCessna TU206C · Catalina, AZThe acft ran into ruts washed out by recent rains on a private arpt. The plt reported that he circled the arpt to look for hazards. He concluded that it was ok to land. After the accident he said that he should have called the arpt operator prior to flying…Jul 15, 1984 · N3971G · Substantial damageNTSB LAX83FA166Accident · 3 fatalField investigationFinal reportBeech A36TC · Sedona, AZDuring preflt briefings, the plt was briefed to expect deteriorating wx conditions with associated flt precautions for mountain obscurement, icing & moderate turbulence. The wx briefings were complete, except due to an inoperative circuit, the 0654 prescott &…Mar 24, 1983 · N3863U · DestroyedNTSB LAX82FA072Accident · 4 fatalField investigationFinal reportCessna P210N · 6 Nm North Of S, AZThe pilot was advised that VFR to flagstaff was not recommended. He advised the briefer that he had just recently flown from sedona and knew he could return VFR. At about 1938 MST, the plane departed phoenix with no flight plan. While en route, the pilot…Feb 8, 1982 · N731NQ · DestroyedNTSB LAX82FUJ04Accident · No injuriesClosedCessna P210 · Phoenix, AZOct 30, 1981 · N4773P · Substantial damageNTSB LAX81FUK04Accident · Minor injuriesClosedCessna 402B · Kayenta, AZSep 23, 1981 · N3826C · Substantial damageNTSB LAX81FUJ21Accident · No injuriesClosedCessna 310Q · Prescott, AZJan 2, 1981 · N310CV · Substantial damageNTSB LAX80DUJ56Accident · Minor injuriesClosedCessna TU206G · Parker, AZMay 7, 1980 · N756BA · DestroyedNTSB LAX80FA022Accident · 2 fatalClosedBeech V35B · Show Low, AZDec 6, 1979 · N1863L · DestroyedNTSB LAX79DA090Incident · No injuriesClosedCessna 402B · Grand Canyon, AZSep 24, 1979 · N61SA · Minor damageNTSB LAX79DUJ87Accident · No injuriesClosedCessna T210 · Kingman, AZJun 26, 1979 · N2431K · Substantial damageNTSB LAX79FUJ89Accident · No injuriesClosedCessna 401B · Scottsdale, AZJun 22, 1979 · N7902Q · Substantial damageNTSB LAX79FUJ80Accident · Minor injuriesClosedCessna 401B · Phoenix, AZJun 5, 1979 · N77MG · DestroyedNTSB LAX79DUJ35Accident · No injuriesClosedCessna U206 · Littlefield, AZNov 7, 1978 · N60838 · Substantial damageNTSB LAX78FA046Accident · 1 fatalClosedCessna T210M · Salome, AZMay 5, 1978 · N761EK · DestroyedNTSB LAX78DUJ23Accident · Minor injuriesClosedCessna 210L · Flagstaff, AZJan 21, 1978 · N732BW · Substantial damageNTSB LAX78DUJ10Accident · Minor injuriesClosedCessna 210K · Benson, AZNov 12, 1977 · N9484M · Substantial damageNTSB LAX77DUJ57Accident · Minor injuriesClosedCessna 210 · Estrella, AZJun 7, 1977 · N732EC · Substantial damageNTSB LAX77FUJ45Accident · No injuriesClosedCessna T310Q · Santa Rosa, AZApr 27, 1977 · N310TT · Substantial damageNTSB LAX76AL008Accident · Serious injuriesClosedCessna 210K · Grand Canyon, AZAug 2, 1975 · N9496M · Substantial damageNTSB LAX75DUJ95Accident · Minor injuriesClosedCessna 210 · Payson, AZJun 28, 1975 · N16CM · Substantial damageNTSB LAX75DUJ79Accident · No injuriesClosedCessna TU206 · Peoria, AZApr 11, 1975 · N58476 · Substantial damageNTSB LAX75DUJ77Accident · No injuriesClosedCessna 210 · Phoenix, AZApr 11, 1975 · N94148 · Substantial damageNTSB LAX75DUJ18Accident · Minor injuriesClosedCessna T206B · Nogales, AZAug 14, 1974 · N3895G · Substantial damage