Vatican approved miracles and apparitions?
There is certainly no known Vatican database for such information. One must do an individual search of a case by case study.
I will treat this question in two parts Vatican miracles that used in the process of beatification and canonization; the second part will concern Marian Apparitions.
The Vatican does not always publish the miracle involved in the case of a beatification or canonization. Individuals at times have requested to remain anonymous. They have the right to remain unknown to the public’s eye. I know of one case where Pope John Paul II refused to accept the miraculous healing of a young girl who’s amputated legs were restored. Pope John Paul II did not want the Communist government to persecute the young girl or her family. Pope John Paul II was heard saying that if God could perform such a miracle through the intercession of the then Venerable Claudine Thévenet, he can certainly perform another. She is now a canonized saint.
About 99% of all miracles involve a physical healing, however a very rare number are not of this nature. Some years ago, I remember that the approved miracle in a canonization case involved a young boy who invoked a Blessed when an avalanche was descending upon him. All perished, except the young boy. The snow parted on both sides of him and he simply walked to safety.
Now concerning Mariam Apparitions:
Since you looking for the kind of miracles or apparitions, that are marked as worthy of belief. Let us take a look at it.
First of all, it is the local bishop who has jurisdiction in the matter of proclaiming an apparition worthy of belief. Rarely will the Vatican step in i not and put it approval along side that of the local ordinary. It has happened. There is no requirement for Rome to interfere in the decisions of the local bishop on this matter.
Bishops evaluate evidence of an apparition according to these guidelines:
The facts in the case are free of error.
The person(s) receiving the messages is/are psychologically balanced, honest, moral, sincere and respectful of church authority.
Doctrinal errors are not attributed to God, Our Lady or to a saint.
Theological and spiritual doctrines presented are free of error.
Moneymaking is not a motive involved in the events.
Healthy religious devotion and spiritual fruits result, with no evidence of collective hysteria.
Judgment can find that an apparition shows all signs of being an authentic or a truly miraculous intervention from heaven, that it is clearly not miraculous or there are not sufficient signs manifesting it to be be so, or that it's not evident whether or not the alleged apparition is authentic.
If a Marian apparition is recognized by the bishop, it means that the message is not contrary to faith and morals and that Mary can be venerated in a special way at the site. But, because belief in a private revelation is not required by the church, Catholics are at liberty to decide how much personal spiritual emphasis to place on apparitions and the messages they deliver.
Pope Benedict XVI commented on private revelation in his 2010 apostolic exhortation Verbum Domini (“The Word of the Lord”). “Ecclesiastical approval of a private revelation essentially means that its message contains nothing contrary to faith and morals. it is licit to make it public and the faithful are authorized to give to it their prudent adhesion” (No. 46).
“A private revelation can introduce new emphases, give rise to new forms of piety, or deepen older ones,” Pope Benedict continued. “It can have a certain prophetic character and can be a valuable aid for better understanding and living the Gospel at a certain time; consequently it should not be treated lightly. It is a help which is proffered, but its use is not obligatory.” - Discernment of Miracle Claims
The best way to explain this that under normal conditions the local bishop of the diocese approves or disapproves the apparition in question. Occasionally, the Holy See will also recognize a particular Marian Apparition, but it is always after the local ordinary has rendered his decision after a diocesan inquest.
If a Marian apparition is recognized by the bishop, it means that the message is not contrary to faith and morals, that Mary can be venerated in a special way at the site and that the faithful can believe with confidence in the supernaturality of the event. But, because belief in a private revelation is not required by the church, Catholics are at liberty to decide how much personal spiritual emphasis (if any) to place on apparitions and the messages they deliver. - Bishop Approved Apparitions with Vatican Recognition
The following Marian Apparitions have been approved by the local bishop And later equally recognized by the Vatican:
- Guadalupe, Mexico (1531)
- Lezajsk, Poland (1578)
- Siluva, Lithuania (1608)
- Laus, France (1664)
- Rue du Bac, Paris, France (1830)
- Rome, Italy (1842)
- La Salette, France (1846)
- Lourdes, France (1858)
- Filippsdorf, Czech Republic (1866)
- Pontmain, France (1871)
- Gietrzwald, Poland (1877)
- Knock, Ireland (1879)
- Fatima, Portugal (1917)
- Beauraing, Belgium (1932)
- Banneux, Belgium (1933)
- Kibeho, Rwanda (1981)
Once approved by the local bishop, the Vatican is under no obligation to recognize a particular apparition as valid. It does so purely at it’s own discretion and for it’s own reasons.