The only situation I can think of where one might use "There had," would be in a sentence such as "There had been a storm." I don't know of any other type of usage for that particular word combination.
"Had" is the past tense of the verb "to have"- so it is somewhat more of an active verb than "to be" which is the verb for which "was" is the past tense. I think it is just one of those quirks of the English language that "had" is simply not used in that way. I don't know of a rule that really states it; it simply isn't in usage.