Did you mean the normally closed connection, so the LED is active unless main power is on?

Even so a failure of the relay or a broken wire could cause the light to come on...