The Duke of Edinburgh is known for his gaffes and one of the most memorable came when he visited Bromley in 2012.

It concerned 25-year-old council worker Hannah Jackson’s red dress which had a zip running the length of its front.

As he passed by, Prince Philip told blonde Hannah: "I would get arrested if I unzipped that dress."

News Shopper: The lady in red

It was on the same visit when he asked “Are they going to put you in the oven next?” when he spoke to pensioner Barbara Dubery who had been given a foil blanket to keep her warm.

News Shopper: Barbara Dubery in her foil blanket

Now it has been announced the Queen’s husband is retiring from royal duties later this year, we look back on some of his other outspoken comments and clangers.

"British women can't cook" (in Britain in 1966).

“I declare this thing open, whatever it is." (on a visit to Canada in 1969).

"Everybody was saying we must have more leisure. Now they are complaining they are unemployed." (during the 1981 recession).

"If it has got four legs and it is not a chair, if it has got two wings and it flies but is not an aeroplane, and if it swims and it is not a submarine, the Cantonese will eat it." (at a 1986 World Wildlife Fund meeting).

"It looks like a tart's bedroom." (on seeing plans for the Duke and Duchess of York's house at Sunninghill Park in 1988) "Yak, yak, yak; come on get a move on." (shouted from the deck of Britannia in Belize in 1994 to the Queen who was chatting to her hosts on the quayside).

"How do you keep the natives off the booze long enough to get them through the test?" (to a driving instructor in Oban, Scotland, during a 1995 walkabout).

"If a cricketer, for instance, suddenly decided to go into a school and batter a lot of people to death with a cricket bat, which he could do very easily, I mean, are you going to ban cricket bats?" (in 1996, amid calls to ban firearms after the Dunblane shooting).

"Bloody silly fool!" (in 1997, referring to a Cambridge University car park attendant who did not recognise him).

"It looks as if it was put in by an Indian." (pointing at an old-fashioned fusebox in a factory near Edinburgh in 1999).

"Deaf? If you are near there, no wonder you are deaf." (to young deaf people in Cardiff, in 1999, referring to a school's steel band).

"You are a woman, aren't you?"(In Kenya, in 1984, after accepting a small gift from a local woman).

"If you stay here much longer, you'll all be slitty-eyed." (to British students in China, during the 1986 state visit).

"Aren't most of you descended from pirates?" (to a wealthy islander in the Cayman Islands in 1994).

"You managed not to get eaten, then?" (suggesting to a student in 1998 who had been trekking in Papua New Guinea that tribes there were still cannibals).

In Germany, in 1997, he welcomed German Chancellor Helmut Kohl at a trade fair as "Reichskanzler" - the last German leader who used the title was Adolf Hitler.

"You're too fat to be an astronaut." (to 13-year-old Andrew Adams who told Philip he wanted to go into space. Salford, 2001).

"I wish he'd turn the microphone off." (muttered at the Royal Variety Performance as he watched Sir Elton John perform, 2001).

"Do you still throw spears at each other?" (In Australia in 2002 talking to a successful aborigine entrepreneur).

"You look like a suicide bomber." (to a young female officer wearing a bullet-proof vest on Stornoway, Isle of Lewis, in 2002).

"Do you know they're now producing eating dogs for anorexics?" (to a blind woman outside Exeter Cathedral, 2002) "Well, you didn't design your beard too well, did you?" (to designer Stephen Judge about his tiny goatee beard in July 2009).

"There's a lot of your family in tonight." (after looking at the name badge of businessman Atul Patel at a Palace reception for British Indians in October 2009).

"Do you work it a strip club?" (to 24-year-old Barnstaple Sea Cadet Elizabeth Rendle when she told him she also worked in a nightclub in March 2010).

"Do you have a pair of knickers made out of this?" pointing to some tartan (to Scottish Conservative leader Annabel Goldie a papal reception in Edinburgh in September 2010).

"How many people have you knocked over this morning on that thing?" (meeting disabled David Miller who drives a mobility scooter at the Valentine Mansion in Redbridge in March 2012).

"The Philippines must be half empty as you're all here running the NHS." (on meeting a Filipino nurse at a Luton hospital in February 2013).

"Just take the f***ing picture." (losing patience with an RAF photographer at events to mark the 75th anniversary of the Battle of Britain - July 2015).