In terms of presentations this means:
for a fibration in the ordinary model structure on topological spaces or in the model structure on simplicial sets, and for the ordinary fiber of topological spaces or simplicial sets, respectively, we have such a long exact sequence.
For background and details see fibration sequence.
Given a tower of homotopy fibers such as a Whitehead tower or Adams resolution, the long exact sequences of homotopy groups for each stage combine to yield an exact couple. The corresponding spectral sequence is the Adams spectral sequence.
The first exhaustive study of these is due to
whence the terminology Puppe sequences.
Textbook accounts include
Robert Switzer, around 2.59 of Algebraic Topology - Homotopy and Homology, Die Grundlehren der Mathematischen Wissenschaften in Einzeldarstellungen, Vol. 212, Springer-Verlag, New York, N. Y., 1975.
Stanley Kochmann, corollary 3.2.7 of Bordism, Stable Homotopy and Adams Spectral Sequences, AMS 1996