Why this doesn't work?

LineTraceByChannel need the End of line segment, just like you did at the Start (but Z need to have a negative value for End). From Break Hit Result you need to use Impact Point not Location.
This works if your character is already in the required location (up to the sky).