Will be just the opposite of scary. You can recall protected and insulated. With the proper therapist you can confront the memory and obtain resolution and healing.
Read "Regression Hypnotherapy" by Randal Churchill and you will get an idea of what can be done.