Basically nothing happens. The detective is a special helper, kind of like a support character. If the detective dies it will be harder for the crewmates to spot out information. What the crewmates can do is to send one or two people to follow the detective so they don’t die, since it’s a special and helpful role.