BE58 pilot reported a nose gear collapse on landing as a result of a malfunction of the nose wheel extension mechanism.

Narrative

A landing gear failure occurred at approximately XA:00 local time Day 0. This issue occurred while flying the cruise enroute portion of the flight. On the approach phase of the flight; the gear was lowered using the flight manual normal procedure. This procedure was then determined unsuccessful as the gear indication lighting showed only two of the three gear down lights illuminated. Glancing out the side window; the gear observation mirror that is located on the engine nacelle confirmed that the nose gear was not down or locked into position. The two pilot crew assessed the problem and it was decided to return to the home base where the flight originated. This allowed time for further trouble shooting and burning off excess fuel. On climb out from the aborted approach the gear retraction procedure was performed; and unfortunately the gear in transit light continued to stay illuminated as the nose gear would not retract. While enroute back to home field the crew worked on troubleshooting the issue and was unable to find a resolution to the problem.On descent to the originating home base airport; the crew briefed the approach and landing with the assumption that the nose gear would likely collapse under load. A full shutdown of the engines was discussed and determined to be the best option as it would promote getting both engine propellers in a safe configuration to maximize control and minimize as much fire hazard as possible. On final approach; the aircraft was configured for normal landing; and once the runway could be made; both engines were shut down and props feathered. Once engines were secured; the master switch and fuel was shut off. The aircraft gently touched down at normal speeds and the aircraft was controlled to a gentle stop where it came to rest on its nose midway down the runway and on the centerline. There were no injuries or property damage outside of the damage to the nose section of the aircraft. It was later determined there was a mechanical failure of a component on the nose wheel extension mechanism that caused the issue.