Twice now my mini 3 pro has done a emergency/forced landing with a full battery withouth returning to home.
Each time the height has been minimal and the area I fly in is unrestricted.

Can someone shed light on why this happens and how one can override it and simply ask it to return to home?

Can someone shed light on why this happens
Yes ... if you post the recorded flight data from one of these flights so I can see what actually happened.
Go to: https://www.phantomhelp.com/LogViewer/Upload/
... where you'll find instructions.
That will give a report you can post a link for the report here.
Or just post the .txt file.

Hi, Raztec. Thank you for reaching out and we're sorry to read about this. Was there any message from the DJI Fly app before the forced landing? Also, is there any video showing the issue? If yes, please provide us with the video and sync the flight records, and then PM us your DJI account and the flight time.

As suggested by Labroides, post the flight logs for BOTH affected flights.
How long before the flights did you charge the battery or batteries?

The batteries were freshly charged.
How to I upload flight logs and where are they?
I don't believe I was recording the screen or video

Raztec Posted at 10-19 10:08
The batteries were freshly charged.
How to I upload flight logs and where are they?
I don't believe I was recording the screen or video

"How to I upload flight logs and where are they?"
Did you look at the instructions Labroides mentioned?

Sean-bumble-bee Posted at 10-19 11:43
"How to I upload flight logs and where are they?"
Did you look at the instructions Labroides mentioned?

This forum doesn't allow me to attach or upload a .txt file.
Any suggestions?

Raztec Posted at 10-19 17:04
This forum doesn't allow me to attach or upload a .txt file.
Any suggestions?

Upload to Dropbox or something like that and post a link.

Raztec Posted at 10-19 10:08
The batteries were freshly charged.
How to I upload flight logs and where are they?
I don't believe I was recording the screen or video

Hi, Raztec. Here are the steps on how to sync the Flight Records on the DJI Fly app:
1. Launch DJI Fly, 「click Profile – More – enter Flight Data Center」;
2. When "Auto-sync Flight Records" is not enabled, there will be a pop-up window that asks whether to enable it once you enter this page;
3. If the pop-up prompt is canceled, you can still select the quick button "enable" that displays at the top of this page;
4. You can also manually enable it by Profile – Settings – Sync Flight Data – Auto-sync Flight Records.

Note:
Please ensure that a flight record showing the issue is present. If not, please try to recreate it.
Auto-sync Flight Records is the process of uploading the local data of the mobile device to the DJI cloud server and downloading the server data to the mobile device.
During the auto synchronization, please ensure that the mobile device is under an available network service.

Raztec Posted at 10-19 17:04
This forum doesn't allow me to attach or upload a .txt file.
Any suggestions?

Upload the .txt to
https://www.phantomhelp.com/LogViewer/Upload/
and post the URL in a reply here.

DJI Gamora Posted at 10-19 17:38
Hi, Raztec. Here are the steps on how to sync the Flight Records on the DJI Fly app:
1. Launch DJI Fly, 「click Profile – More – enter Flight Data Center」;
2. When "Auto-sync Flight Records" is not enabled, there will be a pop-up window that asks whether to enable it once you enter this page;

That's not what he asked for and isn't any help to him.

https://www.dropbox.com/scl/fi/lqbe4zvkrzwlwtjzpy644/DJIFlightRecord_2023-10-17_-19-40-06.txt?rlkey=79kybzayg3r2lar9t1k4mnctg&dl=0

https://www.dropbox.com/scl/fi/n7w378e7rdr3x7c5adzjj/DJIFlightRecord_2023-10-17_-19-48-47.txt?rlkey=bt62876al94fhqgkr3nn6yl52&dl=0

https://www.dropbox.com/scl/fi/5ya1btwnowx1c4w8uohd5/DJIFlightRecord_2023-10-17_-19-49-27.txt?rlkey=cvvxpa2p1wqfk40c62nshe3n8&dl=0

https://www.dropbox.com/scl/fi/vn32ijpx2s3b8zil9e12e/DJIFlightRecord_2023-10-17_-20-28-25.txt?rlkey=c9v6vibq4ts3nkrllyk5vv7xu&dl=0

#1 = https://www.phantomhelp.com/logviewer/7MPMMURNKCDRLJBE6905
#2 = https://www.phantomhelp.com/logviewer/5ILGIPLRG77VGF6H24U9
#3 = https://www.phantomhelp.com/logviewer/0Y50XA59WSRDWZQ0HPES/
#4 = https://www.phantomhelp.com/logviewer/6KOEKSJCIB5GII3347SU/

You are 1.1km from the end of a runway, at a guess less than 530m from the flight path into and out of the Nelson Airport. Though https://nrc.canada.ca/en/drone-tool/
shows that drone flights are permitted.
The first log also warns you that you are in a Airport warning zone.
All 4 logs tell you that either the gimbal cover is on or that there is a problem with the gimbal.
None of the logs show a critical battery, none show a full battery, 40-06 starts at 89%, 28-25 ends at 81%.
I think three of the logs show a normal, throttle closed landing and 49-27 might show a grab and twist.
Would you care to try for the correct logs?

Can someone simply tell me if such a forced landing by the drone with no ability to override it is an occurrence at all?
I just want to know if this is something that can and will happen under the right circumstances.

Raztec Posted at 10-21 16:13
Can someone simply tell me if such a forced landing by the drone with no ability to override it is an occurrence at all?
I just want to know if this is something that can and will happen under the right circumstances.

Yes .. If you were to launch close to an NFZ without waiting for GPS and flew into the NFZ.
When your drone did receive location data from GPS, you would find yourself in a forced landing situation.
You would still be able to control the drone to try to fly back, but you couldn't stop the descending while you were in the NFZ.

OK. That probably explains it. I am near an airport. However, I have permission to fly here and do so successfully 38/40 times.
Just those two occasions is when the drone landed itself without any ability to override it.
Perhaps, I didn't wait long enough for the GPS signals to register. I will remember that in the future when I get my damaged drone back.