The pilot's inadvertent flight into unexpected instrument conditions and his visual look out not possible during takeoff leading to the nose over during the emergency landing after takeoff. Factors were the unexpected fog and the dark night conditions.