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.
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" 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 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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 &…NTSB 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…NTSB LAX82FUJ04Accident · No injuriesClosedCessna P210 · Phoenix, AZNTSB LAX81FUK04Accident · Minor injuriesClosedCessna 402B · Kayenta, AZNTSB LAX81FUJ21Accident · No injuriesClosedCessna 310Q · Prescott, AZNTSB LAX80DUJ56Accident · Minor injuriesClosedCessna TU206G · Parker, AZNTSB LAX80FA022Accident · 2 fatalClosedBeech V35B · Show Low, AZNTSB LAX79DA090Incident · No injuriesClosedCessna 402B · Grand Canyon, AZNTSB LAX79DUJ87Accident · No injuriesClosedCessna T210 · Kingman, AZNTSB LAX79FUJ89Accident · No injuriesClosedCessna 401B · Scottsdale, AZNTSB LAX79FUJ80Accident · Minor injuriesClosedCessna 401B · Phoenix, AZNTSB LAX79DUJ35Accident · No injuriesClosedCessna U206 · Littlefield, AZNTSB LAX78FA046Accident · 1 fatalClosedCessna T210M · Salome, AZNTSB LAX78DUJ23Accident · Minor injuriesClosedCessna 210L · Flagstaff, AZNTSB LAX78DUJ10Accident · Minor injuriesClosedCessna 210K · Benson, AZNTSB LAX77DUJ57Accident · Minor injuriesClosedCessna 210 · Estrella, AZNTSB LAX77FUJ45Accident · No injuriesClosedCessna T310Q · Santa Rosa, AZNTSB LAX76AL008Accident · Serious injuriesClosedCessna 210K · Grand Canyon, AZNTSB LAX75DUJ95Accident · Minor injuriesClosedCessna 210 · Payson, AZNTSB LAX75DUJ79Accident · No injuriesClosedCessna TU206 · Peoria, AZNTSB LAX75DUJ77Accident · No injuriesClosedCessna 210 · Phoenix, AZNTSB LAX75DUJ18Accident · Minor injuriesClosedCessna T206B · Nogales, AZ