OpenAirDocs.org

NTSB investigations: Continental TSIO-520 series

62 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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\" = 351))
  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 SEA86LA184Accident · No injuriesLimited investigationFinal reportCessna T-210 · Battle Mountain, NVAfter a loss of power and a propeller overspeed, a forced landing was made. The pilot diverted from two chosen landing sites due to power lines crossing them. A road was chosen and during landing rollout the aircraft's wing tip clipped the top of a fence. The…Jul 25, 1986 · N4137C · Substantial damageNTSB ATL86LA158Accident · No injuriesLimited investigationFinal reportCessna T188 · Tyler, ALDuring a takeoff from a field strip the plt experienced a complete eng failure. The plt made a forced landing in a pecan orchard which resulted in airframe damage. Powerplant exam disclosed that the eng drive fuel pump had failed.Jun 3, 1986 · N4927J · Substantial damageNTSB SEA86IA080Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Reno, NVAt FL250 the engine ceased operating due to a failed fuel pump. A restart was successful at 10,000 feet m.s.l. with an uneventful landing. This fuel pump (a model g) had a total time of three hours. It was a replacement for a model c fuel pump which had…Mar 18, 1986 · N4360V · No damageNTSB FTW86FRG17Accident · Minor injuriesFinal reportCessna T210 · Ozona, TXThe acft was damaged in an off-arpt lndg after the eng quit. The plt said there was plenty of fuel on board the acft which was being ferried to its owner after an eng change. The plt was unable to restart the eng which had vibrated so that the plt thought he…Mar 11, 1986 · N6479Y · Substantial damageNTSB CHI86FA038Accident · Minor injuriesField investigationFinal reportCessna T210M · Highland, MIFifteen minutes after takeoff an eng failure occurred. The plt force landed the acft in a fld but the roughness of the landing surface resulted in the nose and right main gear collapsed. Examination disclosed the exhaust vavle had failed in the #4 cylinder.…Dec 4, 1985 · N1982M · Substantial damageNTSB DEN86LA017Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Bismarck, NDShortly after takeoff, the plt of the Beech A36TC acft activated what he believed was the flap retraction lever, and the eng quit. The plt made a forced landing aprx 1000 ft from the rwy departure end. During the investigation, the eng was started and…Nov 1, 1985 · N3663K · Substantial damageNTSB FTW85FA171Accident · 1 fatalField investigationFinal reportCessna T210N · Riesel, TXThe acft eng had just been top overhauled and a stol kit was added. The mechanic reportedly told the plt to be 'easy' on the eng and fly the acft 45-60 mins near the traffic pattern so it could be checked for oil leaks. The plt reportedlyignored these…Apr 1, 1985 · N6436N · DestroyedNTSB MIA84LA220Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Pelham, GAThe acft landed short of the rwy during a forced landing after the engine quit on final approach. The plt reported that he had experienced trouble keeping the engine running at low power settings.Aug 7, 1984 · N3310J · DestroyedNTSB CHI83LER02Accident · No injuriesFinal reportCessna T188C · Olivia, MNDuring takeoff the eng lost power & the acft crashed landed collapsing the gear. The crankshaft, P/N631716, had broken in the cheek area between #2 & #3 crank throws. 1 month prior to this accident the acft had collided with a fence. Afterinstalling a new…Aug 14, 1983 · N2060J · Substantial damageNTSB DEN83LA048Accident · No injuriesLimited investigationFinal reportCessna P210N · Glade Park, COThe acft landing gear collapsed during a forced landing after an engine failure. The pilot said he lost manifold and oilpressure and turned back toward grand junction when the engine began making loud noises. A landing was made on a slippery road and the acft…Jan 8, 1983 · N3886P · Substantial damageNTSB SEA82DA087Accident · No injuriesFinal reportCessna 206 · Renton, WAAccording to the pilot, the aircraft was on its first flight after a major engine overhaul and was being flown for maintenance evaluation. About 45 minutes after takeoff, the pilot requested a descent from 7500 feet MSL. After entering an overcast, the engine…Jun 13, 1982 · N60092NTSB CHI82IA113Incident · No injuriesIncident investigationFinal reportCessna 402B · Waukegan, ILPilot reported an oil leak in the right engine to controller while on an instrument approach to Waukegan airport. Several minutes later, pilot reported that he had lost sight of the airport and due to loss of power in the right engine, elected to land in a…Apr 5, 1982 · N69341 · Minor damage