He wouldn't be suspended as such, but he would be urged to take leave, primarily because his fiance has just died so he's going to be a little mixed up and I wouldn't trust him with a gun. There is a name for the type of leave that people get when someone close has died, I just can't put my finger on the name. I'll edit this post if I remember. I think it may be grievance leave, though I'm not sure.
Anyway, he would definately not be involved in the case, although if he knew someone on the case (but they weren't close friends and he didn't know the fiance) then that person might stay on the case. If they did, it's possible they may accidentally mention details of the case, if he begs him to tell him.
Also, when the case goes to court he'll be allowed to go and he'll hear all the details then.