Increasing our knowledge of the orbits and compositions of Near-Earth Objects (NEOs) is important for a better understanding of the evolution of the Solar System and of life. The detection of serendipitous NEO appearances among the millions of archived exposures from large astronomical imaging surveys can provide a contribution which is complementary to NEO surveys. Using the AstroWISE information system, this work aims to assess the detectability rate, the achieved recovery rate and the quality of astrometry when data mining the ESO archive for the OmegaCAM wide-field imager at the VST. We developed an automatic pipeline that searches for the NEO appearances inside the AstroWISE environment. Throughout the recovery process, the pipeline uses several public web-tools to identify possible images that overlap with the position of NEOs, and acquires information on the NEOs predicted position and other properties (e.g., magnitude, rate and direction of motion) at the time of observations. We have recovered 196 appearances of NEOs from a set of 968 appearances predicted to be recoverable. It includes appearances for three NEOs which were on the impact risk list at that point. These appearances were well before their discovery. The subsequent risk assessment using the extracted astrometry removes these NEOs from the risk list. We estimate a detectability rate of 0.05 per NEO at an SNR>3 for NEOs in the OmegaCAM archive. Our automatic recovery rates are 40% and 20% for NEOs on the risk list and the full list, respectively. The achieved astrometric and photometric accuracy is on average 0.12 arcsec and 0.1 mag. These results show the high potential of the archival imaging data of the ground-based wide-field surveys as useful instruments for the search, (p)recovery and characterization of NEOs. Highly automated approaches, as possible using AstroWISE, make this undertaking feasible.