A crew on board a Cathay Pacific aircraft saw a North Korean missile blow up over the Sea of Japan last week, the airline told CNBC on Monday.