Can spirits of the dead have sex with us or is it all just demons?

i was reading about incubus and succubus but could spirits of deceased people do it as well as demons i also read the 99% of the time that demons don`t want sex they want your soul