Switching circuit transistor NPN, load has voltage and current though transistor is off
Transistor is off ...


That means there is an open-circuit between its collector and emitter.


  ... and collector should see 0 V.


That's your error. 


You have R2 at 100 &Omega; giving a strong pull-up to V2.
You have R4 at 1 k&Omega; giving a weak pull-down to 0 V.


The combination gives \$ V_C = \frac {1000}{1000 + 100} V_2 = \frac {10}{11} V_2 \$.

With Q1 off it can be removed from the circuit. All you've got is a potential divider.







simulate this circuit &ndash; Schematic created using CircuitLab

Figure 1. An equivalent circuit using a relay. When the relay is off the contact is open and VC is almost 5 V.