I have one dog that goes out of excitement. If we go for a drive she is fine for a long time unless we go to the woods that are only about 5 minutes from my house. She has been on very long trips all over the county with no trouble. As we get to the end of the road to the woods there is a gate where everyone has to stop. As soon as I stop to open the gate she starts to whine and fidget and we have about 1/2 a minute to get her out of the car or else she loses all control and it isn't pretty. She does not do it on purpose and acts very embarrased when it happens. Maybe your dog was REALLY happy to be going for a ride

and couldn't handle the excitement. Unfortunately, I have a car not a truck with a dog box so she is no longer welcome on car trips to the woods

.