⚠️ 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 8032 59.0
Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 4156 78.0
Contravening a Red Traffic Light 3447 62.0
Cause vehicle to be left in a dangerous position 2192 77.0
Using a Mobile Phone Whilst Driving 2035 73.0
Driving without Reasonable Consideration 1773 54.0
Stop a vehicle within pelican pedestrian crossing limits 1458 86.0
Misc - Non Traffic Offences 1056 20.0
Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 661 83.0
Stop a vehicle on pedestrian crossing 489 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 292 68.0
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment 251 76.0
VRM fails to conform to Regulations 154 83.0
Driving a vehicle wholly or partly on a footpath 143 67.0
Contravene Lane Closure Red X 119 74.0
Dangerous Driving 110 61.0
Drive on hard shoulder 106 59.0
Motor vehicle fail to accord precedence at a pelican crossing 94 74.0
No Insurance 71 72.0
Use a motor vehicle / trailer in a condition likely to cause danger of injury 69 71.0
Drive a vehicle other than on the carriageway of a motorway 63 78.0
Driver not in position to have Proper Control 51 53.0
No Seat Belt 51 41.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 39 92.0
Fail to display front VRM plate 33 67.0
Prohibited vehicle in offside lane of motorway 33 67.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 28 39.0
Duplicate Submission 25 8.0
/C atruasiele ur nonuetsciedses aorfy t hoeb sGtrruecattieorn L boyn dmoont oarr evaehicle 24 79.0
Drive / Ride / Lead an animal on a footpath 24 50.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
Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic 19 16.0
Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 17 53.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 10 30.0
Offence to be added 10 20.0
Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver 10 50.0
Waiting on a road in a prohibited area 10 80.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
Drive a vehicle other than on the carriageway of a 7 86.0
Fail to display rear VRM plate 7 43.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