{"dot_number":"588058","summary":{"total":55,"fatalities":1,"injuries":35},"crashes":[{"crash_id":"3512678","dot_number":"588058","report_state":"AZ","report_date":"20171122","report_time":"1553","city":"KINGMAN","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"3AKJGLD57FSFZ3466","vehicle_license":"PA08029","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:17"},{"crash_id":"3507669","dot_number":"588058","report_state":"CA","report_date":"20171112","report_time":"2114","city":"UNINCORPORATED","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9EH5DN148710","vehicle_license":"YAGY725","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:17"},{"crash_id":"3313175","dot_number":"588058","report_state":"CA","report_date":"20161129","report_time":"1910","city":"ANDERSON","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9EH1DN148705","vehicle_license":"YAGY723","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:01"},{"crash_id":"3333345","dot_number":"588058","report_state":"CA","report_date":"20161031","report_time":"1620","city":"UNINCORPORATED","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJGLBG79LAG2235","vehicle_license":"YAHA275","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:01"},{"crash_id":"3220555","dot_number":"588058","report_state":"WA","report_date":"20160525","report_time":"1547","city":"Spokane","state":"WA","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9EH5DN148707","vehicle_license":"YAGY305","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:38:12"},{"crash_id":"3156312","dot_number":"588058","report_state":"CA","report_date":"20151021","report_time":"1130","city":"ONTARIO","state":"CA","fatalities":0,"injuries":1,"tow_away":0,"vin":"4V4NC9EH0DN148713","vehicle_license":"YAGY728","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:57"},{"crash_id":"3091306","dot_number":"588058","report_state":"OR","report_date":"20150807","report_time":"2120","city":"N MADRAS","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9EH6DN148702","vehicle_license":"YAHY304","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:57"},{"crash_id":"2937594","dot_number":"588058","report_state":"OR","report_date":"20141010","report_time":"2030","city":"3.83 S SHANIKO JCT","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKAD49X9EJ407868","vehicle_license":"YAHC488","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:33"},{"crash_id":"2914956","dot_number":"588058","report_state":"WA","report_date":"20140717","report_time":"1104","city":"KITTITAS","state":"WA","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9EH1BN529211","vehicle_license":"YAHN379","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:39:42"},{"crash_id":"2865808","dot_number":"588058","report_state":"ID","report_date":"20140517","report_time":"1738","city":"HOMEDALE","state":"ID","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XKAD49X7EJ407867","vehicle_license":"YAHC480","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:43"},{"crash_id":"2865087","dot_number":"588058","report_state":"OR","report_date":"20140317","report_time":"1055","city":"1.29 W MOSIER","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9EH9EN167455","vehicle_license":"YAHC193","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:54"},{"crash_id":"2849074","dot_number":"588058","report_state":"OR","report_date":"20140123","report_time":"1600","city":"TROUTDALE","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9EH4DN148701","vehicle_license":"YAGY729","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:55"},{"crash_id":"2648791","dot_number":"588058","report_state":"OR","report_date":"20121120","report_time":"1628","city":"2.81 N LAPINE","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9EJ8AN87034","vehicle_license":"YAFY735","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:46"},{"crash_id":"2632558","dot_number":"588058","report_state":"CA","report_date":"20121021","report_time":"2145","city":"SACRAMENTO","state":"CA","fatalities":0,"injuries":3,"tow_away":0,"vin":"1FUYNWEB7WP902848","vehicle_license":"YACS483","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:46"},{"crash_id":"2598402","dot_number":"588058","report_state":"WA","report_date":"20120906","report_time":"0835","city":"Tukwila","state":"WA","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9EJ6AN287033","vehicle_license":"YAFY730","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:40:47"},{"crash_id":"2604431","dot_number":"588058","report_state":"OR","report_date":"20120905","report_time":"1215","city":"PORTLAND","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9EJ6AN287033","vehicle_license":"YAFY730","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:47"},{"crash_id":"2596964","dot_number":"588058","report_state":"OR","report_date":"20120823","report_time":"1705","city":"PORTLAND","state":"OR","fatalities":0,"injuries":1,"tow_away":0,"vin":"4V4NC9EJ8AN287034","vehicle_license":"YAFY735","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:47"},{"crash_id":"2258363","dot_number":"588058","report_state":"CA","report_date":"20100430","report_time":"1950","city":"LOS ANGELES","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9EJ4AN287032","vehicle_license":"YAFY729","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:42"},{"crash_id":"2234716","dot_number":"588058","report_state":"UT","report_date":"20100313","report_time":"1525","city":"ELSINORE","state":"UT","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP7DU9X11D537463","vehicle_license":"YAFY704","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:43"},{"crash_id":"2214602","dot_number":"588058","report_state":"OR","report_date":"20091205","report_time":"0722","city":"2 S ALBANY","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJBBAV05LU24314","vehicle_license":"YAGC853","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:55"},{"crash_id":"2070004","dot_number":"588058","report_state":"OR","report_date":"20090113","report_time":"1244","city":"4.5 W MOLALLA","state":"OR","fatalities":1,"injuries":1,"tow_away":0,"vin":"1XKTDB9X6YJ845264","vehicle_license":"YAEW023","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:19"},{"crash_id":"1864886","dot_number":"588058","report_state":"CA","report_date":"20070911","report_time":"1100","city":"UNINCORPORATED","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUPCSEBXYDB82768","vehicle_license":"YAFK985","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:17"},{"crash_id":"1647779","dot_number":"588058","report_state":"CA","report_date":"20060612","report_time":"2120","city":"UNINCORPORATED","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"YAES772","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:57"},{"crash_id":"1518644","dot_number":"588058","report_state":"OK","report_date":"20050824","report_time":"1120","city":"","state":"OK","fatalities":0,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"YAD5616","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:28"},{"crash_id":"1544347","dot_number":"588058","report_state":"TX","report_date":"20050815","report_time":"2155","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJBBCG82PS70578","vehicle_license":"YADW397","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING (HAMMELL TRANSPORT SERVICE INC)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:28"},{"crash_id":"1499661","dot_number":"588058","report_state":"WA","report_date":"20050707","report_time":"1505","city":"BINGEN","state":"WA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJA6CK95PN86710","vehicle_license":"YAE0621","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING    ( HAMMELL TRANSPORT SERVICE )","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:45:46"},{"crash_id":"1389685","dot_number":"588058","report_state":"TN","report_date":"20041012","report_time":"0755","city":"","state":"TN","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:17"},{"crash_id":"1360771","dot_number":"588058","report_state":"CA","report_date":"20040809","report_time":"0945","city":"ELK GROVE","state":"CA","fatalities":0,"injuries":2,"tow_away":0,"vin":"","vehicle_license":"YACH488","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:17"},{"crash_id":"1294947","dot_number":"588058","report_state":"OR","report_date":"20040617","report_time":"1710","city":"7 E HERMISTON","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKADR9X4MJ565966","vehicle_license":"YAEH669","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:41"},{"crash_id":"1357353","dot_number":"588058","report_state":"GA","report_date":"20040615","report_time":"2210","city":"","state":"GA","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XKTDB9X5YJ845109","vehicle_license":"YAD344","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:41"},{"crash_id":"1245204","dot_number":"588058","report_state":"OR","report_date":"20040306","report_time":"0630","city":"1 E MEACHAM","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYSSEB91PF57223","vehicle_license":"YADP273","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:50"},{"crash_id":"1136419","dot_number":"588058","report_state":"CA","report_date":"20030502","report_time":"1040","city":"ALAMEDA","state":"CA","fatalities":0,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"4ADF228","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:17"},{"crash_id":"1122875","dot_number":"588058","report_state":"NE","report_date":"20030501","report_time":"0750","city":"OMAHA","state":"NE","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XP7DU9X510537465","vehicle_license":"HR65389","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORTATION","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:17"},{"crash_id":"1057090","dot_number":"588058","report_state":"NV","report_date":"20021220","report_time":"0120","city":"LAKE TOWNSHIP","state":"NV","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKDDR9X6VJ138871","vehicle_license":"YAED980","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:33"},{"crash_id":"1049107","dot_number":"588058","report_state":"MO","report_date":"20021112","report_time":"0050","city":"NON-CITY OR UNINCORPORATE","state":"MO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUPCXZB9YPB91015","vehicle_license":"P438449","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:33"},{"crash_id":"1075086","dot_number":"588058","report_state":"TX","report_date":"20021019","report_time":"0240","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJBBC602PJ0574","vehicle_license":"YADW398","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING (HAMMELL TRANSPORT SERVICE INC)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:33"},{"crash_id":"267858","dot_number":"588058","report_state":"WA","report_date":"20020122","report_time":"1516","city":"TUMWATER","state":"WA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X9YD538527","vehicle_license":"B7722330","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:48:03"},{"crash_id":"164238","dot_number":"588058","report_state":"UT","report_date":"20010303","report_time":"0330","city":"SNOWVILLE","state":"UT","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYDZYBXSP873890","vehicle_license":"YADW345","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:41"},{"crash_id":"936617","dot_number":"588058","report_state":"OR","report_date":"20010122","report_time":"1825","city":"1 W WESTON","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"581712HT2RLADRS","vehicle_license":"YADP270","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:42"},{"crash_id":"1122434","dot_number":"588058","report_state":"GA","report_date":"20010111","report_time":"2115","city":"","state":"GA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYSSEB0YPF57220","vehicle_license":"YADPZ28","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:55"},{"crash_id":"569532","dot_number":"588058","report_state":"ID","report_date":"20001221","report_time":"0330","city":"FRUITLAND","state":"ID","fatalities":0,"injuries":1,"tow_away":0,"vin":"1HSRDALR1SH683284","vehicle_license":"YADP243","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:55"},{"crash_id":"262481","dot_number":"588058","report_state":"OR","report_date":"20001116","report_time":"2323","city":"","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"181453DR9X9BDCP","vehicle_license":"","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:56"},{"crash_id":"209519","dot_number":"588058","report_state":"WA","report_date":"20001114","report_time":"0830","city":"PROSSER","state":"WA","fatalities":0,"injuries":0,"tow_away":0,"vin":"2WLPDCJG5EK909726","vehicle_license":"T434734","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:56"},{"crash_id":"208696","dot_number":"588058","report_state":"WA","report_date":"20000203","report_time":"1011","city":"TUMWATER","state":"WA","fatalities":0,"injuries":1,"tow_away":0,"vin":"XR817784","vehicle_license":"YADF228","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:48"},{"crash_id":"646635","dot_number":"588058","report_state":"KS","report_date":"19990710","report_time":"1510","city":"KANSAS CITY","state":"KS","fatalities":0,"injuries":4,"tow_away":0,"vin":"1FUYNWEB3WP902846","vehicle_license":"YACS493","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:01"},{"crash_id":"646710","dot_number":"588058","report_state":"KS","report_date":"19990710","report_time":"1510","city":"KANSAS CITY","state":"KS","fatalities":0,"injuries":4,"tow_away":0,"vin":"1FUYNWEB3WP902846","vehicle_license":"YAC5493","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:01"},{"crash_id":"249360","dot_number":"588058","report_state":"WY","report_date":"19990421","report_time":"0915","city":"COKEVILLE","state":"WY","fatalities":0,"injuries":2,"tow_away":0,"vin":"1FUYNWEB6XPA69838","vehicle_license":"YADC655","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"999173","dot_number":"588058","report_state":"PA","report_date":"19990314","report_time":"0119","city":"UPPER MACUNGIE","state":"PA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYNWEB9WP902849","vehicle_license":"YACS492","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMEL TRANS","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"829683","dot_number":"588058","report_state":"NE","report_date":"19990101","report_time":"1100","city":"","state":"NE","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYNWEB4XPA69640","vehicle_license":"YADC694","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRANSPORT SERVICE INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"259029","dot_number":"588058","report_state":"OR","report_date":"19980304","report_time":"0630","city":"","state":"OR","fatalities":0,"injuries":0,"tow_away":0,"vin":"036528PV0BDE3YU","vehicle_license":"","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"HAMMELL TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:39"}]}