A.S.
My daughter and my ex hubby both have had night terrors. Both were brought on anytime they went to bed in an overtired state. My daughter doesn't have night terrors as often now (she's 8) but she'll still sleep walk on occasion when gone to bed overtired.
I've been to a sleep specialist for myself (hypersomnia - not linked to sleep walking or night terrors), but he explained that it is usually hereditary and sometimes will go away as adulthood comes around.