NCIS has killed a few major characters, but none quite so suddenly as Kate's. The late ghost/imaginations of Kate were really good though. She even did a little return thing a season or two ago in a "what if" kind of scenario (NCIS kind dipped their toes into the metaphysical there a few times).