{"dot_number":"1697338","summary":{"total":4,"fatalities":0,"injuries":0},"crashes":[{"crash_id":"4624242","dot_number":"1697338","report_state":"AZ","report_date":"20230914","report_time":"0458","city":"SCOTTSDALE","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPXD40XXFD278265","vehicle_license":"CJ57160","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JAMES WATER TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:29"},{"crash_id":"4332171","dot_number":"1697338","report_state":"AZ","report_date":"20220406","report_time":"1544","city":"CHANDLER","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FVHALCK0ADAV2969","vehicle_license":"CL63288","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JAMES WATER TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:23"},{"crash_id":"4079055","dot_number":"1697338","report_state":"AZ","report_date":"20201210","report_time":"0600","city":"MESA","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1NPCLP0X2JD465859","vehicle_license":"CK54187","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JAMES WATER TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:25"},{"crash_id":"3913352","dot_number":"1697338","report_state":"AZ","report_date":"20200113","report_time":"1907","city":"MESA","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FVHALCK0ADAV2969","vehicle_license":"CL63288","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JAMES WATER TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:11"}]}