NTSB investigations: Continental TSIO-520 series, 1986

4 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “In flight collision with terrain/water”. 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, 1986 per year, 1982–2026: 50 cases
19828
19833
19843
19854
19864
19871
19881
19891
19901
19912
19921
19932
19941
19951
19962
19971
20003
20014
20022
20033
20051
20061

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\") = 1986
    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\" = 230))
  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 DEN87FA023Accident · 5 fatalField investigationFinal reportBeech A36TC · Steamboat Sprgs, COPlt and four paxs were returning home from a ski vacation. A witness at the arpt observed a normal takeoff and saw the acft turn towards an area of high terrain located approximately 1.5 miles from the Steamboat arpt. The witness observed N36TS continue on a…Nov 29, 1986 · N36TS · DestroyedNTSB DEN86LA135Accident · No injuriesLimited investigationFinal reportCessna T210M · Erie, COThe plt reports that he remembers going through the checklist on downwind following a short flight from a nearby airport. He does not remember doing a final 'down and green' check and the aircraft was landed gear up.May 13, 1986 · N761XE · Substantial damageNTSB MIA86LA132Accident · No injuriesLimited investigationFinal reportCessna 402B · Opa Locka, FLThe plt stated that upon arrival at his destination he could not get his landing gear to extend. He then returned to Opa Locka airport where he intentionally landed with the gear up. Post crash investigation of the acft revealed that the landing gear would…Apr 25, 1986 · N401NA · Substantial damageNTSB DEN86LA074Accident · No injuriesLimited investigationFinal reportCessna T210M · Truth Or Conseq, NMAccording to the pilot, during the landing roll he is accustomed to keeping the nose gear off the runway until the ground speed has slowed. The pilot stated he did not check the landing gear condition lights. Upon lowering the nose, the acft propeller and…Feb 2, 1986 · N761JP · Substantial damage