Whoo! Whoo! Goes the Train by Anne Rockwell, illustrated by Anne Rockwell and Vanessa van der Baan

From chapters.ca:
On Allan's first train ride, every twist and turn brings a new sound. Clickety- clack! The train goes over a bridge. Clang! Clang! It nears a crossing. Whoosh! The doors slide open at a station. But Allan's favorite sound- Whoo! Whoo! -doesn't come until the very last stop, when he gets the best surprise of all.