The camera never goes off, it just doesn't always initialize.
Sometimes it is simply not sending in the call and it can be enabled by turning it on in the chat window. But sometimes the camera icon is not even visible and Skype needs to be restarted.
It happens in photo booth as well, it will say no camera connected. But this is when Skype was running so it may be Skype that is causing the problem still.