How do you handle failed deliveries, second attempts, final details, etc.?

A single failed delivery with a retry will still be classified as in_transit. It will also have a message detailing the specific failed delivery attempt.

If the delivery fails to the point where the carrier decides to stop redelivery, the tracking detail will either be return_to_sender, available_for_pickup, or failure depending on the action the carrier takes.