MOT Pass/Fail Data for Cerberas

[SlvrCrb]

Not sure if this data has been posted elsewhere on PH, did a quick search and couldn't find anything. The BBC applied to VOSA for the MOT data for all UK cars, much to VOSA's annoyance and after the Information Commissioner stepped in they were forced to hand the data from 2007 over, although they only provided a PDF version. Considering there's 12000+ rows of data over 20 columns, sorting through it would have been a nightmare, so the BBC reformatted into xls. Then the techs got hold of it and created an SQL database version. I'm in the middle of coding some PHP/SQL pages to allow a fully searchable database of the info, but in the meantime I've pulled off the Cerbera data for our amusement. Bear in mind this data is only cars that were road going and MOT'd in 2007 and not off the road, garaged or otherwise, but still gives us an idea of how many are left.... It also has all engines configurations grouped together, with no distinction between the V8 and S6. The data for other marques makes for some eye-opening reading....

So without further ado.... the list.

Year	Passes	Fails	Fail%	Body	Brakes	Driver View	Emissions	Lights	Identity	Wheels	Belts	Steering	Suspension	Tyres	OtherCycles	Controls	Not Tested
1996	60	28	31.8	4	35	6	13	16	2	1	0	6	11	7	0	0	2
1997	172	69	28.6	9	55	30	21	46	5	0	2	12	16	16	0	0	6
1998	171	51	23	2	51	18	18	36	1	1	1	14	24	13	0	0	8
1999	144	51	26.2	3	47	13	20	39	2	0	1	4	18	10	0	0	3
2000	70	33	32	1	28	14	11	18	2	0	0	2	12	5	0	0	2
2001	62	25	28.7	0	16	5	8	12	2	0	0	5	10	6	0	0	1
2002	37	10	21.3	0	5	5	2	8	1	0	0	0	2	2	0	0	1
2003	27	9	25	1	8	4	5	2	0	0	0	1	0	1	0	0	0
2004	9	1	10	0	0	2	0	2	0	0	0	0	0	0	0	0	0

[rustybkts]

Wow, sales seriously tailed off after 2000.

What a fantastic bit of info.

[ajp70]

A quick tot up comes to 1029 cars plus, as said, any cars not on the road for 2007. I doubt if there are very many cars not being used for the whole year and declared SORN. I'll guess at maybe 30. Also there are some Cerbs overseas which would not appear on the list so ad another guess of 20.

An interesting piece of info Silver so thanks for putting that up.

[davidd]

I we make the assumption that every fail was then retested and passed we have 752 cars....

[JR]

davidd said:

I we make the assumption that every fail was then retested and passed we have 752 cars....

Pity that you didn't read the post above - more like 11 or 12 hundred.

[Greeny]

JR said:

davidd said:

I we make the assumption that every fail was then retested and passed we have 752 cars....

Pity that you didn't read the post above - more like 11 or 12 hundred.

I read the post above, and agree with Davidd - 1029 was the total tests, some cars were tested twice!

Edited by Greeny on Thursday 11th February 21:09

[SlvrCrb]

Just for a giggle, Ferrari 612 SCAGLIETTI ... 36.8% Fail rate !!! My old Cerb's better than that

Year	Passes	Fails	Fail%	Body	Brakes	Driver View	Emissions	Lights	Identity	Wheels	Belts	Steering	Suspension	Tyres	OtherCycles	Controls	Not Tested
2004	12	7	36.8	0	5	1	1	3	0	0	0	1	0	2	0	0	0

[YKB]

Was discussed here before http://www.pistonheads.com/gassing/topic.asp?h=0&a...

But it's still interesting. You have to add the passes and failures together to get the total of cars MOTed. Last time I added it up I got 1031 Cerbs. The definitions are here http://www.vosa.gov.uk/vosa/repository/MOT-IB-716%...

We should get the figures for 2008 & 2009 later in the year.

[Greeny]

YKB said:

Was discussed here before http://www.pistonheads.com/gassing/topic.asp?h=0&a...

But it's still interesting. You have to add the passes and failures together to get the total of cars MOTed. Last time I added it up I got 1031 Cerbs. The definitions are here http://www.vosa.gov.uk/vosa/repository/MOT-IB-716%...

We should get the figures for 2008 & 2009 later in the year.

So is it that - 752 passed first time + 277 that passed second, (or third) time = 1029

[DonnyMac]

I know what you mean Greeny, it would be my best guess that they are not counting unique vehicles merely those presented and either passed or failed, and thus your figures would be right.

I’d be very surprised if they de-duped the figures against chassis numbers.

[YKB]

Greeny said:

YKB said:

Was discussed here before http://www.pistonheads.com/gassing/topic.asp?h=0&a...

But it's still interesting. You have to add the passes and failures together to get the total of cars MOTed. Last time I added it up I got 1031 Cerbs. The definitions are here http://www.vosa.gov.uk/vosa/repository/MOT-IB-716%...

We should get the figures for 2008 & 2009 later in the year.

So is it that - 752 passed first time + 277 that passed second, (or third) time = 1029

Yes 1029. (I got to 1031 but I now realise I counted two Cerbs made in 1971!! Seems like a VOSA mistake). The data states 277 cars failed and that this was 27% of the total sample. This agrees with the total of 1029 Cerbs tested as 27% of 1029 = 277.

The only thing we don't know is if cars were MoTed twice in a year (due to being sold with a new MoT at a dealer) they are counted twice. But I guess this would only be a small number.

Edited by YKB on Thursday 11th February 23:25

[DonnyMac]

YKB said:

Greeny said:

YKB said:

Was discussed here before http://www.pistonheads.com/gassing/topic.asp?h=0&a...

But it's still interesting. You have to add the passes and failures together to get the total of cars MOTed. Last time I added it up I got 1031 Cerbs. The definitions are here http://www.vosa.gov.uk/vosa/repository/MOT-IB-716%...

We should get the figures for 2008 & 2009 later in the year.

So is it that - 752 passed first time + 277 that passed second, (or third) time = 1029

Yes 1029. (I got to 1031 but I now realise I counted two Cerbs made in 1971!! Seems like a VOSA mistake). The data states 277 cars failed and that this was 27% of the total sample. This agrees with the total of 1029 Cerbs tested as 27% of 1029 = 277.

The only thing we don't know is if cars were MoTed twice in a year (due to being sold with a new MoT at a dealer) they are counted twice. But I guess this would only be a small number.

Edited by YKB on Thursday 11th February 23:25

Agreed, a small number, but a massive percentage

[Steve_T]

Main failures would be handbrake, headlights adjustment and emissions I'd wager. Not that much of a surprise and if you bear in mind that some garages will take your car to an MOT, let it fail and then deal with the failures that result (since you don't pay to MOT a car a second time) then even the failure numbers may not be that big a deal.

[Robscim]

I think there's numerical confusion here!! I think David is right!

If I take my car for a test and it fails, that's one failure. On the presumption I then get it fixed and re-tested, and it passes, then that's one pass. Hence I'm in the 277 number for fails and the 750 number for passes, but only one car.

If I take the car, it fails and I give up, then the number would be the 1000+ number. Pretty unlikely given cerbera owners!!

Obviously, if I get the car re-tested during the year because I want to sell it with 12 months MOT, then that effectively reduces the number of cars on the road.

Consequently, there should be 750ish on the road.

I'm not trying to stoke the fire, I just like my car to be a bit more exclusive!!

Cheers

Rob

[Tanguero]

From the other thread...

YKB said:

Tanguero said:

I don't think so, because many cars will have failed first time, been fixed then come back to pass on the second or subsequent attempt.

I've looked into this now. The number for MoT passes is defined as the number of 'Initial MoT passes'. Document is here http://www.vosa.gov.uk/vosa/repository/MOT-IB-716%...

This would infer this is not the total number of cars just the number that passed first time.

The data also states 278 cars failed and this was 27% of the total sample. Hence 1031 Cerbs were tested as 27% of 1031 = 278.

[WorAl]

Tanguero said:

From the other thread...

YKB said:

Tanguero said:

I don't think so, because many cars will have failed first time, been fixed then come back to pass on the second or subsequent attempt.

I've looked into this now. The number for MoT passes is defined as the number of 'Initial MoT passes'. Document is here http://www.vosa.gov.uk/vosa/repository/MOT-IB-716%...

This would infer this is not the total number of cars just the number that passed first time.

The data also states 278 cars failed and this was 27% of the total sample. Hence 1031 Cerbs were tested as 27% of 1031 = 278.

That mentions nothing about re-tested cars though.............but the numbers add up so, it most likely is 1000ish cars rather than 750

[YKB]

We do need to also remember that these figures are now up to three years old. With additional write offs, long term SORNs and sales abroad there may today only be about 800 Cerbs on the road in the UK. Best look after them then!

[jammy_basturd]

When did the rule about new cars not needing an MOT within the first three years come in?

[VPower]

That is very interesting data, shame that Public Servants seem so reluctant to let us see our own data.


I recently suggested on the TVRCC forum they do a FOIA request and ask for Total TVR's registered so we can now for sure how many were actually put on the road.

Doubt they will bother, so does anyone on hear have the inclination?