No, these are the cool ones that take stuff out of the ground, not the ones that destroy everything above them
Then I clicked on one and saw it was the name of our local rock quarry. :)
(I guess technically a "surface mine" for "Construction Sand and Gravel".)
Not every mine is a "classic" underground mine with tunnels, etc.
See (for example) the W.Australian SuperPit gold mine which consolidated every shaft mine in a particular region into a single open pit that goes deeper than any pre existing underground mine in that area.
To answer the question posed, "how many (US?) mine sites pose a danger of type {X}" requires crawling the US BLM datasets, the OSHA datasets, the archived (from when active) MSHA datasets, and having a some luck onside for various specific sites due to large gaps and periods of not caring at all.
See:
* https://www.epa.gov/epcra/does-msha-have-jurisdiction-over-i...
* https://www.blm.gov/programs/aml-environmental-cleanup/aml
Various transnational global mining companies (Rio Tinto, et al) have extensive datasets on global resources and minesites, both operational, and past and potential future sites.