Do substitution mutations typically result in frameshift

No.

Only insertion and deletion mutation can result in frame shift.

Frame shift is Protein-coding DNA is divided into codons which are three bases long, insertions and deletions in these codons can completely change a gene so its message cannot be decoded correctly. Such mutations are called frameshift mutations. For example, consider the sentence, "The cat ate her rat." Each word represents a codon. If we delete the first letter and read the sentence in the same way, it doesn't make sense. Similarly if the codons become jumbled up, they would no longer make any sense, in such frameshifts, a similar error occurs at the DNA level, where the codons cannot be parsed correctly. This usually gives rise to truncated proteins that are as useless as "rca tet hce tee" is uninformative.