It is very common in Oklahoma. We are fortunate to have the OERB.
https://oerb.com/
They clean up drill sites or production sites for free. Check with the abstract on the property about mineral rights. Most all residential neighborhoods the home owners don't get the mineral rights. It is however illegal to drill in a neighborhood, except for water.
There are indeed old working wells in areas where neighborhoods have grown up around them. Even our state capital has working wells on the grounds in front of the capital.
At the aerial business we had a wonderful archive of old aerial photos and we regularly would print photos from the 40s and 50s of sites covered in wells. My old boss worked for a couple of years as a roughneck on a crew drilling wells. He said it was common to close a well by digging down 6 feet, throwing down some gunny sacks, and covering it in a yard of concrete, and trying to lose the paperwork. He quit for that reason.
We had one lady that had a very nice new house. She turned on the garbage disposal and the house blew up. She was not killed, but injured. We printed an image from 1951 and a new aerial of her house. An improperly closed well was right under her kitchen. Natural gas right from the ground has no odor at all.
When we were looking to buy our house, I printed images of 1951, 1961 1971, 1981, and 1991, and 2000. Our house was built in 1995. It was just a farmer's wheat field, then a local college used it as a sports field for ball games. Never any bad pookie stuff. And the farmer's trash pile was no where close to our neighborhood.