I have a big dog but he's getting a bit old and stiff, and finding it hard to jump into the back of my Model Y these days. Unfortunately he can't figure out ramps either.
The clearance on the Y from the ground to the trunk is roughly 27 inches. I was looking at the CT and it seems like he'd fit...