{"dot_number":"2175507","summary":{"total":5,"fatalities":2,"injuries":2},"crashes":[{"crash_id":"5011249","dot_number":"2175507","report_state":"TX","report_date":"20250619","report_time":"2116","city":"NOT LISTED","state":"TX","fatalities":1,"injuries":1,"tow_away":0,"vin":"1XP5DB9X16D894838","vehicle_license":"R725908","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"LONGHORN TUBULAR SERVICES LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:59"},{"crash_id":"4653765","dot_number":"2175507","report_state":"TX","report_date":"20231104","report_time":"1612","city":"ODESSA","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M1AX09Y4FM025042","vehicle_license":"R274552","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"LONGHORN TUBULAR SERVICES LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4606411","dot_number":"2175507","report_state":"NM","report_date":"20230807","report_time":"2148","city":"97","state":"NM","fatalities":1,"injuries":0,"tow_away":0,"vin":"1XP5DB9X54D813675","vehicle_license":"R657365","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"LONGHORN TUBULAR SERVICES LLC","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:32:29"},{"crash_id":"4451746","dot_number":"2175507","report_state":"TX","report_date":"20221102","report_time":"1753","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DU9X55N848806","vehicle_license":"R551870","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"LONGHORN TUBULAR SERVICES LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:05"},{"crash_id":"4363246","dot_number":"2175507","report_state":"TX","report_date":"20220519","report_time":"1202","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP7DU9X08D764377","vehicle_license":"R574928","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"LONGHORN TUBULAR SERVICES LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:23"}]}