{"dot_number":"200263","summary":{"total":19,"fatalities":1,"injuries":10},"crashes":[{"crash_id":"1725206","dot_number":"200263","report_state":"IL","report_date":"20061129","report_time":"1600","city":"SO. HOLLAND","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUPCSEB7YLB39723","vehicle_license":"81734","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:44:37"},{"crash_id":"1465169","dot_number":"200263","report_state":"CA","report_date":"20040909","report_time":"2240","city":"UNINCORPORATED","state":"CA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUKBPYAXRP429569","vehicle_license":"SP78109","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:17"},{"crash_id":"1065535","dot_number":"200263","report_state":"CA","report_date":"20021112","report_time":"0850","city":"KERN","state":"CA","fatalities":1,"injuries":0,"tow_away":0,"vin":"1FUKABYA8MP382931","vehicle_license":"SP44798","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:33"},{"crash_id":"1206285","dot_number":"200263","report_state":"CA","report_date":"20021010","report_time":"2341","city":"BANNING","state":"CA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUKBPYA2RP594466","vehicle_license":"SP78110","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:33"},{"crash_id":"1080322","dot_number":"200263","report_state":"CA","report_date":"20020906","report_time":"0325","city":"FRESNO","state":"CA","fatalities":0,"injuries":0,"tow_away":0,"vin":"2HSFLAHN8VC030149","vehicle_license":"9B94623","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RALPH PIPKIN TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:46"},{"crash_id":"1066991","dot_number":"200263","report_state":"CA","report_date":"20020825","report_time":"0540","city":"SAN JOAQUIN","state":"CA","fatalities":0,"injuries":2,"tow_away":0,"vin":"1FUKBYA8RP594496","vehicle_license":"SP78106","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:46"},{"crash_id":"1082753","dot_number":"200263","report_state":"CA","report_date":"20020727","report_time":"1120","city":"KINGS","state":"CA","fatalities":0,"injuries":2,"tow_away":0,"vin":"1FUWDZYA8XPA81875","vehicle_license":"9A94303","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RALPH PIPKIN TRUCKING CO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:47"},{"crash_id":"571269","dot_number":"200263","report_state":"AZ","report_date":"20020326","report_time":"0530","city":"YUMA","state":"AZ","fatalities":0,"injuries":2,"tow_away":0,"vin":"1FUW3EDAXPP459600","vehicle_license":"6A59489","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RALPH PIPKIN","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:03"},{"crash_id":"290469","dot_number":"200263","report_state":"CA","report_date":"20010530","report_time":"0740","city":"IMPERIAL","state":"CA","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":"RALPH PIPKIN TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:41"},{"crash_id":"478866","dot_number":"200263","report_state":"CA","report_date":"20001212","report_time":"1240","city":"IMPERIAL","state":"CA","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":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:56"},{"crash_id":"475910","dot_number":"200263","report_state":"CA","report_date":"20000609","report_time":"0210","city":"SAN BERNARDINO","state":"CA","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":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:36"},{"crash_id":"448793","dot_number":"200263","report_state":"CA","report_date":"20000211","report_time":"1605","city":"SAN BERNARDINO","state":"CA","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":"RALPH PIPKEN TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:48"},{"crash_id":"470562","dot_number":"200263","report_state":"CA","report_date":"19990828","report_time":"0245","city":"KINGS","state":"CA","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":"RALPH PIPKIN TRKG INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:01"},{"crash_id":"448011","dot_number":"200263","report_state":"CA","report_date":"19990726","report_time":"1130","city":"STANISLAUS","state":"CA","fatalities":0,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:01"},{"crash_id":"467133","dot_number":"200263","report_state":"CA","report_date":"19990112","report_time":"1745","city":"RIVERSIDE","state":"CA","fatalities":0,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"464853","dot_number":"200263","report_state":"CA","report_date":"19980807","report_time":"0430","city":"KERN","state":"CA","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":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:28"},{"crash_id":"460652","dot_number":"200263","report_state":"CA","report_date":"19970726","report_time":"1530","city":"STANISLAUS","state":"CA","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":"PIPKIN TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:54"},{"crash_id":"450567","dot_number":"200263","report_state":"CA","report_date":"19950813","report_time":"0230","city":"FRESNO","state":"CA","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":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:54"},{"crash_id":"443772","dot_number":"200263","report_state":"CA","report_date":"19920524","report_time":"1650","city":"COLTON","state":"","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":"RALPH PIPKIN TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:53:04"}]}