{"dot_number":"1817165","summary":{"total":4,"fatalities":1,"injuries":2},"crashes":[{"crash_id":"2669325","dot_number":"1817165","report_state":"TX","report_date":"20130212","report_time":"0140","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9TG47N429539","vehicle_license":"P742614","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SPS LOGISTICS LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:36"},{"crash_id":"2553117","dot_number":"1817165","report_state":"IN","report_date":"20120510","report_time":"2234","city":"INDIANAPOLIS","state":"IN","fatalities":1,"injuries":1,"tow_away":0,"vin":"4V4NC9TG17N436075","vehicle_license":"P742615","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SPS LOGISTICS LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:56"},{"crash_id":"2358588","dot_number":"1817165","report_state":"TX","report_date":"20110104","report_time":"1900","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9GH06N399196","vehicle_license":"P670678","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SPS LOGISTICS LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:55"},{"crash_id":"2156012","dot_number":"1817165","report_state":"IL","report_date":"20090731","report_time":"1226","city":"Romeoville","state":"IL","fatalities":0,"injuries":1,"tow_away":0,"vin":"4V4NC9GHX7N445392","vehicle_license":"P681118","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SPS LOGISTICS LLC","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:42:56"}]}