The underground tanks are more dangerous but sometimes mandated for appearance rules.
Underground propane can leak and filter along the buried feed pipe to the house. Fill a basement.
Underground oil tanks can never result in an explosion.
But underground oil tanks can leak and leach into the water table.
To me, whether for heat or a generator, an above ground diesel/oil tank are the safest. You can see any leaks and nothing to go boom.