⚠️ Offence types

All offence categories ranked by frequency. 'Driving without Due Care and Attention' is the most common, followed by pavement obstruction and red light offences.

Custom SQL query returning 82 rows (hide) 

select offence as Offence, count(*) as [Total reports], round(100.0 * sum(case when disposal not in ('NFA', 'Duplicate Submission') then 1 else 0 end) / count(*), 0) as [Action rate %] from reports where offence is not null group by offence order by [Total reports] desc

Edit SQL

This data as json, CSV

OffenceTotal reportsAction rate %
Driving without Due Care and Attention 8805 59.0
Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 4753 79.0
Contravening a Red Traffic Light 3662 63.0
Cause vehicle to be left in a dangerous position 2215 77.0
Using a Mobile Phone Whilst Driving 2207 72.0
Driving without Reasonable Consideration 1785 54.0
Stop a vehicle within pelican pedestrian crossing limits 1649 87.0
Misc - Non Traffic Offences 1133 21.0
Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 676 84.0
Stop a vehicle on pedestrian crossing 500 75.0
Cause unnecessary obstruction by motor vehicle 427 87.0
Use a vehicle / cycle on a road and contravene a local traffic order other than parking 299 67.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 269 76.0
VRM fails to conform to Regulations 157 83.0
Driving a vehicle wholly or partly on a footpath 155 66.0
Contravene Lane Closure Red X 121 74.0
Dangerous Driving 115 63.0
Drive on hard shoulder 110 59.0
Motor vehicle fail to accord precedence at a pelican crossing 98 73.0
Use a motor vehicle / trailer in a condition likely to cause danger of injury 80 70.0
No Insurance 76 72.0
Drive a vehicle other than on the carriageway of a motorway 68 75.0
Driver not in position to have Proper Control 56 54.0
No Seat Belt 53 42.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 50 56.0
Vehicle overtake within crossing limits 42 90.0
Fail to display front VRM plate 36 67.0
Duplicate Submission 34 9.0
Prohibited vehicle in offside lane of motorway 34 65.0
Motor vehicle fail to comply with solid white line road markings 29 21.0
Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 29 41.0
Drive / Ride / Lead an animal on a footpath 27 44.0
/C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 24 79.0
Fail to Conform to Cycle Lane 24 67.0
Use vehicle on a road without valid test certificate 23 78.0
Motor vehicle fail to comply with endorsable sect 22 73.0
Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 21 52.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 19 16.0
Motor vehicle fail to comply with a non endorsab 17 65.0
Use a vehicle / cycle on a road and contravene a l 15 87.0
No vehicle excise licence 12 33.0
Offence to be added 12 17.0
Waiting on a road in a prohibited area 11 82.0
Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver 10 50.0
/ trailer outside of the Greater London area 9 67.0
Keeping a vehicle with registration marks obscured 9 56.0
Drive a vehicle on common land 8 75.0
Fail to display rear VRM plate 8 38.0
Drive a vehicle other than on the carriageway of a 7 86.0
Motor vehicle fail to accord precedence at a pelic 6 67.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 6 33.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 5 80.0
Stop a vehicle within pelican pedestrian crossing l 5 80.0
Motor vehicle fail to comply with a directional arrow sign 4 100.0
CCaauussee uunnnneecceessssaarryy oobbssttrruuccttiioonn bbyy mmoottoorr vveehhiiccllee 3 67.0
DMroivtionrg v wehitihcoleu fta Dilu teo Ccoamrep alyn dw Aittht eenntdioonrsable 3 67.0
Drive / stop / cause to remain at rest a motor veh 3 67.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic eq 3 33.0
Motor vehicle fail to comply with solid white line 3 33.0
Person in charge cause veh / trailer to be left to involve danger to road user 3 100.0
Use a motor vehicle / trailer in a condition likely t 3 33.0
Use on a road a motor vehicle / trailer in such a c 3 33.0
section 36 traffic sign -other than manned or 3 67.0
Driver parked on pedestrian road marked by a white “Zig-zag line” 2 0.0
MCaiuscs e- Nunonne Tcreasfsfaicr yO offbesntcreusction by motor vehicle 2 0.0
CCaauussee vuenhniecclee stsoa brye olebfstt irnu cat dioann gbeyr mouost opro vseithioicnle 1 0.0
Contravene a Red Traffic Light 1 100.0
Contravene local traffic order 1 100.0
DCariuvsee o unn hnaercde ssshaoruyl doebrstruction by motor vehicle 1 0.0
DCariuvsineg u wnnitehcoeusts aDruye o Cbasrteru acntido nA tbtye nmtiootnor vehicle 1 100.0
Dangerous driving 1 0.0
Drive a motor vehicle when the VRM fails to conform to regulations. 1 100.0
Drive mechanically propelled vehicle without reasonable consideration 1 100.0
Drive motor vehicle on a footpath/ Unnecessary Obstruction 1 100.0
Fail to accord precedence to pedestrian at zebra crossing 1 100.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equ 1 100.0
No Insurance Motor vehicle fail to co 1 100.0
Use a motor vehicle / trailer the number of passenger / manner carried likely to cause danger 1 0.0
VCaRuMse f auinlsn teoc ceossnaforyr mob tsot rRuecgtiuolnat bioyn msotor vehicle 1 100.0
driving without due care/attention 1 0.0
fail to comply with a non endorsable traffic sign 1 100.0
sMeocttioorn v 3e6h itcrlaef ffiaci ls tigon c o-omthpelyr wthiathn emnadnonrseadb oler 1 100.0