As what the sentence above illustrated is the problem of split infinitive. Infinitive phrase is evident by the use of the word "to". The most appropriate corrected sentence is to state in this manner:
In 1974, when I was a child, I wanted to become a pilot.
