{"dot_number":"448592","summary":{"total":12,"fatalities":1,"injuries":4},"crashes":[{"crash_id":"2219648","dot_number":"448592","report_state":"TX","report_date":"20091220","report_time":"1818","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X87D684593","vehicle_license":"AD12960","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO FREIGHT TRANSPORTATION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:43"},{"crash_id":"2026749","dot_number":"448592","report_state":"UT","report_date":"20080505","report_time":"0530","city":"NEPHI","state":"UT","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPXDB9X08D751052","vehicle_license":"AD31392","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO FREIGHT TRANSPORTATION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:42"},{"crash_id":"2072629","dot_number":"448592","report_state":"UT","report_date":"20080207","report_time":"1444","city":"OREM","state":"UT","fatalities":0,"injuries":1,"tow_away":0,"vin":"1NPHD49X77N730900","vehicle_license":"AD23727","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO FREIGHT TRANSPORTATION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:43"},{"crash_id":"1924320","dot_number":"448592","report_state":"TX","report_date":"20080102","report_time":"1305","city":"","state":"TX","fatalities":1,"injuries":0,"tow_away":0,"vin":"1XP5DB9X05D826562","vehicle_license":"AB59029","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO FREIGHT TRANSPORTATION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1640687","dot_number":"448592","report_state":"TX","report_date":"20060410","report_time":"1259","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X75D854553","vehicle_license":"AB71800","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO FREIGHT TRANSPORTATION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:58"},{"crash_id":"1318324","dot_number":"448592","report_state":"IN","report_date":"20040630","report_time":"1055","city":"HAMMOND","state":"IN","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X05D826562","vehicle_license":"AB59029","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO FREIGHT TRANSP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:40"},{"crash_id":"1218658","dot_number":"448592","report_state":"AZ","report_date":"20031129","report_time":"1141","city":"PHOENIX","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5D69X6XD496629","vehicle_license":"AA10499","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO FREIGHT TRANSPORTATION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:51"},{"crash_id":"1216205","dot_number":"448592","report_state":"AZ","report_date":"20031127","report_time":"1743","city":"MESA","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUCPDYBOXPB59990","vehicle_license":"CB50847","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO FREIGHT TRANSPORTATION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:51"},{"crash_id":"1086059","dot_number":"448592","report_state":"AZ","report_date":"20030213","report_time":"1646","city":"GILBERT","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5D69X0XD496626","vehicle_license":"CB50848","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO FREIGHT TRANSPORTATION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:18"},{"crash_id":"1054135","dot_number":"448592","report_state":"AZ","report_date":"20021116","report_time":"0414","city":"","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKWDB9X6YR857624","vehicle_license":"AA13334","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO FREIGHT TRANSPORTATION INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:33"},{"crash_id":"572206","dot_number":"448592","report_state":"AZ","report_date":"20011230","report_time":"0604","city":"CHANDLER","state":"AZ","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DR9X8WN444610","vehicle_license":"CB50846","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO MILK TRANSPORT","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:03"},{"crash_id":"115311","dot_number":"448592","report_state":"TX","report_date":"19960405","report_time":"0900","city":"EL PASO","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKAD29X8LS544845","vehicle_license":"59A018","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPHO TRANSPORTATION/PIPHO MILK TRANSPOR","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:35"}]}