{"dot_number":"507296","summary":{"total":17,"fatalities":0,"injuries":6},"crashes":[{"crash_id":"1482618","dot_number":"507296","report_state":"KY","report_date":"20050526","report_time":"1630","city":"CRESTWOOD","state":"KY","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DR9X9YD509246","vehicle_license":"123FDE","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ROY D BREWER","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:46"},{"crash_id":"1484318","dot_number":"507296","report_state":"TX","report_date":"20050428","report_time":"1305","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DR9X640525498","vehicle_license":"R4CL56","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ROY BREWER TRUCKING (ROY BREWER)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:47"},{"crash_id":"1219880","dot_number":"507296","report_state":"TX","report_date":"20031126","report_time":"1440","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKWDR9X8SS674962","vehicle_license":"R4XK01","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ROY BREWER TRUCKING (ROY BREWER  )","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:51"},{"crash_id":"1199636","dot_number":"507296","report_state":"TX","report_date":"20031030","report_time":"2014","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKWDR9X855674962","vehicle_license":"R4XK01","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ROY BREWER TRUCKING (ROY BREWER  )","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:05"},{"crash_id":"1137860","dot_number":"507296","report_state":"CO","report_date":"20030717","report_time":"1045","city":"","state":"CO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5D69X4YN511740","vehicle_license":"R4XK10","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ROY D BREWER TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:06"},{"crash_id":"1109992","dot_number":"507296","report_state":"AL","report_date":"20030310","report_time":"2135","city":"00","state":"AL","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5D69X2YD508244","vehicle_license":"1HE050","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ROY BREWER TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:18"},{"crash_id":"263619","dot_number":"507296","report_state":"TX","report_date":"20000103","report_time":"0254","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKWDR9X3SS656000","vehicle_license":"1LK916","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ROY BREWER TRUCKING (ROY BREWE","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:48"},{"crash_id":"158362","dot_number":"507296","report_state":"TX","report_date":"19991113","report_time":"0200","city":"PITTSBURG","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"","vehicle_license":"1HN489","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ROY BREWER TRUCKING (ROY BREWER  )","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:49"},{"crash_id":"152208","dot_number":"507296","report_state":"TX","report_date":"19990417","report_time":"1900","city":"","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"","vehicle_license":"1LF220","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ROY BREWER TRUCKING (ROY BREWER  )","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"148202","dot_number":"507296","report_state":"TX","report_date":"19981124","report_time":"1300","city":"FARMERS BRANCH","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"1HN489","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"BREWER, ROY TRUCKING (ROY BREWER   )","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:28"},{"crash_id":"147690","dot_number":"507296","report_state":"TX","report_date":"19981106","report_time":"0900","city":"FARMERS BRANCH","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"1HN489","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"BREWER, ROY TRUCKING (ROY BREWER   )","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:28"},{"crash_id":"138061","dot_number":"507296","report_state":"TX","report_date":"19971127","report_time":"0400","city":"GARLAND","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"1HL436","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"BREWER, ROY TRUCKING (ROY BREWER   )","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:52"},{"crash_id":"118498","dot_number":"507296","report_state":"TX","report_date":"19960708","report_time":"1500","city":"MOUNT PLEASANT","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKWDR9X8RS626288","vehicle_license":"1HN489","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"BREWER, ROY TRUCKING (ROY BREWER DBA)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:35"},{"crash_id":"93349","dot_number":"507296","report_state":"TX","report_date":"19941119","report_time":"0100","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKAD29X6JS501456","vehicle_license":"R45369","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"BREWER, ROY TRUCKING (ROY BREWER DBA)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:22"},{"crash_id":"92775","dot_number":"507296","report_state":"TX","report_date":"19941110","report_time":"2400","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKAD29X1GK329667","vehicle_license":"1BP992","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"BREWER, ROY TRUCKING (ROY BREWER DBA)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:22"},{"crash_id":"92704","dot_number":"507296","report_state":"TX","report_date":"19941109","report_time":"1200","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKAD29X3J5501446","vehicle_license":"R45368","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"BREWER, ROY TRUCKING (ROY BREWER DBA)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:22"},{"crash_id":"87577","dot_number":"507296","report_state":"TX","report_date":"19940812","report_time":"1200","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKAD29X1HS343845","vehicle_license":"R48618","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"BREWER, ROY TRUCKING (ROY BREWER DBA)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:23"}]}