I'm curious what those rare cases are.
But also - that's reverse transcription, not reverse translation. Maybe Lupe made this point a little too late in his description.
EDIT: Sorry, moved around the above after rethinking
Retroviruses are a subset of RNA viruses that utilize the strategy you're referring to. This requires additional machinery be coded for to allow reverse transcription to DNA and then subsequent integration into host DNA. The vast majority of RNA viruses are not retroviruses.