This appeared today in Reddit's Skyrim community. It's the mod "Normandy", which adds a crash site of the Mass Effect ship into the game. It's located outside of Whiterun, so you can probably fast-travel to this thing no matter where you are in your character's progression.
Still, what the hell else did this guy install in his game? Because that looks like some kind of undead guy wearing a Red Dead Redemption hat while riding a horker. Small wonder this was posted under the headline: "I think maybe I should stop installing mods for a while." Admitting you have a problem is always the first step.