Ok our solution is a new locking collar that can be scverewed on before but with a small bolt in it so it can be clamped to the spindle, then we are also machining some bearing retaining rings out of better materials.
The locking collar loosened because the tab in the retaining ring failed...