Orion is definitely dead. His Grave confirms that as canon.
As for the how and when, well, we don't have too many specifics. I would highly suggest the "One Last Step" fanfic on this forum, which appears to be about as canon as we're going to get at the moment. And, well, it's a great piece.