I've never experienced this within my 10+ years of working with SQLite. I've seen it a fair bunch with MariaDB though.
Therr have been a couple (literally) of occasions where customers have contacted me and it turned out their database was corrupt, though I don't know the circumstances under which it occurred. Presumably there are instances where it wasn't reported to me too.