The threads represent a stress concentration and so the failure occurred at that location.
Edit the geometry to represent the cross-section of the pipe including the profile of the threads and any reduction in wall thickness from steps in the thickness as well as the thread profile. Use small elements to capture the high stress gradients around these stress concentrations.
You could even do a small breakout model of just this local region.