{"dot_number":"1485817","summary":{"total":7,"fatalities":1,"injuries":3},"crashes":[{"crash_id":"5117964","dot_number":"1485817","report_state":"VA","report_date":"20260309","report_time":"1315","city":"Not Reported","state":"VA","fatalities":0,"injuries":0,"tow_away":0,"vin":"5KKWAVDV6KLJZ3362","vehicle_license":"UC44036","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CHARLES PORTER EXCAVATING LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:32"},{"crash_id":"4877068","dot_number":"1485817","report_state":"TN","report_date":"20250116","report_time":"1300","city":"NOT IN CITY LIMIT","state":"TN","fatalities":0,"injuries":1,"tow_away":0,"vin":"3HTJGTKTXEN797819","vehicle_license":"UC30927","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CHARLES PORTER EXCAVATING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4853410","dot_number":"1485817","report_state":"VA","report_date":"20241127","report_time":"1540","city":"","state":"VA","fatalities":0,"injuries":0,"tow_away":0,"vin":"3HTJGTKTXEN797819","vehicle_license":"UA15076","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CHARLES PORTER EXCAVATING LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4832317","dot_number":"1485817","report_state":"VA","report_date":"20241022","report_time":"0805","city":"","state":"VA","fatalities":1,"injuries":0,"tow_away":0,"vin":"1NKWLP0XXHJ148779","vehicle_license":"UC30907","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CHARLES PORTER EXCAVATING LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:34"},{"crash_id":"3931740","dot_number":"1485817","report_state":"VA","report_date":"20200212","report_time":"1059","city":"","state":"VA","fatalities":0,"injuries":1,"tow_away":0,"vin":"2FZXEWCB0YAG70217","vehicle_license":"TX-253901","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CHARLES PORTER EXCAVATING LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:52"},{"crash_id":"3866745","dot_number":"1485817","report_state":"NC","report_date":"20191016","report_time":"1236","city":"HUNTERSVILLE","state":"NC","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M1AN07Y8CM010399","vehicle_license":"PY126927","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CHARLES PORTER EXCAVATING LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:22"},{"crash_id":"3510866","dot_number":"1485817","report_state":"VA","report_date":"20171220","report_time":"1115","city":"","state":"VA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M2AD38CX1M010873","vehicle_license":"44383P","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"CHARLES PORTER EXCAVATING LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:17"}]}