Context: https://en.wikipedia.org/wiki/Legio_IX_Hispana
The legion's disappearance is also the subject of the polarising 2010 film Centurion.
Everyone wants it to be a military disaster, but that sort of thing tends to leave more evidence than we have. I've always felt some kind of boring bureaucratic end is more likely.