IIRC, there was a case in Canada where a few RCMP officers were killed in a drug bust. Keeping the uniformed brother in mind, maybe his death was a part of a larger case?
Like pizzapie said, CSIs in Vegas are civilians. In New York and Miami, they are detectives. In real life, CSIs don't carry...