NTSB investigations: Continental TSIO-520 series, 1987

5 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 per year

19822026
NTSB investigations: Continental TSIO-520 series, 1987 per year, 1982–2026: 65 cases
19823
19831
19842
19853
19863
19875
19882
19894
19922
19941
19953
19963
19972
19993
20003
20015
20021
20036
20044
20053
20064
20072

Latest cases

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 year(c.\"eventDate\") = 1987
    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')
      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\" = 130))
  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 MIA88LA030Accident · No injuriesLimited investigationFinal reportCessna T-210N · Tallahassee, FLDuring ldg gear extension plt did not get safe down indication. Attempts to use emergency extension pump were unsuccessful. Acft was landed nose gear extended main gear retracted. Post accident inspection of the acft revealed the left main gear down lock…Nov 10, 1987 · N4612C · Substantial damageNTSB SEA88LA005Accident · No injuriesLimited investigationFinal reportCessna 340A · Tacoma, WAAs the plt was taxiing to the active rwy, the acft's right brake became inop due to a loss of hydraulic fluid. Subsequently, the acft went off the side of the taxiway, contd over an embankment & was damaged. The loss of hydraulic fluid was due to a leak in…Oct 11, 1987 · N37358 · Substantial damageNTSB MIA87IA229Incident · No injuriesIncident investigationFinal reportCessna 402B · W.Palm Beach, FLThe lt main gear would not extend when the plt attempted to lower the gear & and the acft was landed in that condition. An exam of the strut assy revealed that a bearing, p/n 5041108-1/2 had failed permitting the strut to overextend, jamming the gear in the…Aug 23, 1987 · N3767C · Minor damageNTSB FTW87LA124Accident · No injuriesLimited investigationFinal reportCessna T210N · Tahlequah, OKThe right brake disk separated from the hub when brakes were applied during landing rollout. The aircraft veered left off the runway and into a drainage ditch where the horizontal stabilizer contacted the ground, damaging both of its spars.May 11, 1987 · N5342A · Substantial damageNTSB ATL87IA114Incident · No injuriesIncident investigationFinal reportCessna 340 · Myrtle Beach, SCPlt initiated autoplt climb from 12000 to 16000 ft. plt heard a loud snapping noise. Acft pitched up and efforts of both front seat occupants were reqd to keep nose down. Plt stated trim stuck in full nose up position. Plt stated that when the acft approached…Apr 17, 1987 · N25RF · Minor damage