{"dot_number":"1074804","summary":{"total":8,"fatalities":1,"injuries":2},"crashes":[{"crash_id":"3633373","dot_number":"1074804","report_state":"MN","report_date":"20180806","report_time":"1211","city":"MINNEAPOLIS","state":"MN","fatalities":0,"injuries":0,"tow_away":0,"vin":"1NPFXU9X1YN509132","vehicle_license":"YBU7043","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MCPHILLIPS TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:34"},{"crash_id":"2739531","dot_number":"1074804","report_state":"MN","report_date":"20130822","report_time":"0751","city":"SAINT PAUL","state":"MN","fatalities":0,"injuries":0,"tow_away":0,"vin":"1NPFXU9X1YN509132","vehicle_license":"YBH3670","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MCPHILLIPS TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:24"},{"crash_id":"1938004","dot_number":"1074804","report_state":"MN","report_date":"20080116","report_time":"1055","city":"ROSEMOUNT","state":"MN","fatalities":0,"injuries":0,"tow_away":0,"vin":"1NPFXU9XXYD509135","vehicle_license":"YT98028","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MCPHILLIPS TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1668793","dot_number":"1074804","report_state":"MN","report_date":"20060808","report_time":"1504","city":"ST PAUL","state":"MN","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYDSEBXYLG35374","vehicle_license":"YTA8481","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MCPHILLIPS TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:48"},{"crash_id":"1492083","dot_number":"1074804","report_state":"MN","report_date":"20050602","report_time":"0855","city":"MINNEAPOLIS","state":"MN","fatalities":1,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"YAL1551","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MCPHILLIPS TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:46"},{"crash_id":"1358192","dot_number":"1074804","report_state":"MN","report_date":"20041004","report_time":"0947","city":"VERMILLION TOWNSHIP","state":"MN","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPBLB9X2HN251062","vehicle_license":"YAH9069","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MCPHILLIPS TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:17"},{"crash_id":"1152482","dot_number":"1074804","report_state":"MN","report_date":"20030811","report_time":"0926","city":"SCIOTA TOWNSHIP","state":"MN","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M2AD62C21M011042","vehicle_license":"YAN8504","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MCPHILLIPS TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:06"},{"crash_id":"1190776","dot_number":"1074804","report_state":"MN","report_date":"20030605","report_time":"1823","city":"HASTINGS","state":"MN","fatalities":0,"injuries":1,"tow_away":0,"vin":"1NP5LU0X6YN546908","vehicle_license":"YAL1551","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MCPHILLIPS TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:17"}]}