Hi Evan,
its at Nelson airport. It snagged the net of a fishing boat in 1982 and was subsequently recovered, along with an engine and a propeller, which are held by a local diving club.
NZ2029 (from ADF Serials):
Hudson Mk.III NZ2029 S/n 3852, previously AE497 from British Purchasing Mission contracts. Shipped to New Zealand on Donerail, BOC Unit 1 Hobsonville on 20 October 1941 and assembled at No.1 Aircraft Depot Hobsonville. To No.2 GR Squadron Nelson. Crashed after hitting sea while low flying [during air gunnery exercise] over Tasman Bay 30 September 1942. The propellers struck the water before the aircraft climbed to about 200 feet and then crashed into the sea. Flying Officer Dean Horrocks, Sergeant Vincent Hill, Sergeant Jack Bryson, Sergeant Victor Chapple, Sergeant Gordon Stevens and AC1 John Davis killed. Warrant Officer J. Colway injured. Written off books at Nelson 16 October 1942."
Although ADF Serials records the date in which NZ2029 struck the water as 30 September 1942, Errol Martyn in his book For Your Tomorrow Volume One; Fates 1915 - 1942 records the incident occuring the day before, "...at about 1555 some 5 miles off Motueka".