it depends on the RF module.
First, it has to support the datarates of usb (480Mbps) which I doubt any cheap one will.
Second, for any usb communication, you need bidirectional signals and balanced lines. Even if the camera only sends data, it still needs to be identified and receive commands from the usb port.
You will also need a few line adaptations, so you can detect when the line is sending and when it is receiving.
Another option will be to take a picture with the camera, read it with a microcontroller, and then encode it in some format (maybe even compress it) and send it out on your RF connection. You would, of course, need USB host libraries for your camera, and possibly you will also need to reverse engineer its driver files.
If you do not want any image processing, analog cameras with integrated RF emitters are also available. All you have to do is connect the receiver to a device that reads image carrying analog signals, such as a TV or a TV-tuner card.