{"dot_number":"147251","summary":{"total":14,"fatalities":3,"injuries":6},"crashes":[{"crash_id":"1046294","dot_number":"147251","report_state":"AZ","report_date":"20021016","report_time":"1650","city":"BUCKEYE","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP6D29X3HD209861","vehicle_license":"14724A","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPELINE TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:33"},{"crash_id":"277771","dot_number":"147251","report_state":"AZ","report_date":"20010618","report_time":"1525","city":"TUCSON","state":"AZ","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGD29X9E0178823","vehicle_license":"14729A","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPELINE TRUCKING CO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:41"},{"crash_id":"929384","dot_number":"147251","report_state":"CA","report_date":"20010529","report_time":"1435","city":"POMONA","state":"CA","fatalities":1,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPELINE TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:41"},{"crash_id":"938238","dot_number":"147251","report_state":"CA","report_date":"20010402","report_time":"1555","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":"PIPELINE TRUCKING CO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:41"},{"crash_id":"479586","dot_number":"147251","report_state":"CA","report_date":"20010227","report_time":"1130","city":"LOS ANGELES","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":"PIPELINE TRUCKING CO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:41"},{"crash_id":"868654","dot_number":"147251","report_state":"NV","report_date":"20001219","report_time":"1000","city":"LAS VEGAS","state":"NV","fatalities":0,"injuries":2,"tow_away":0,"vin":"209858","vehicle_license":"13627A","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPELINE TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:55"},{"crash_id":"448797","dot_number":"147251","report_state":"CA","report_date":"20000313","report_time":"0405","city":"KERN","state":"CA","fatalities":1,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPELINE TRUCKING CO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:48"},{"crash_id":"470421","dot_number":"147251","report_state":"CA","report_date":"19990721","report_time":"1315","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":"PIPELINE TRUCKING CO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:01"},{"crash_id":"471921","dot_number":"147251","report_state":"CA","report_date":"19990621","report_time":"1400","city":"CHINO","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":"PIPELINE TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:01"},{"crash_id":"464022","dot_number":"147251","report_state":"CA","report_date":"19980403","report_time":"0240","city":"RIVERSIDE","state":"CA","fatalities":1,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PIPELINE TRUCKING CO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:38"},{"crash_id":"461975","dot_number":"147251","report_state":"CA","report_date":"19971102","report_time":"1740","city":"LOS ANGELES","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":"PIPELINE TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:52"},{"crash_id":"461503","dot_number":"147251","report_state":"CA","report_date":"19971015","report_time":"0900","city":"SAN BERNARDINO","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":"PIPELINE TRUCKING CO","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:52"},{"crash_id":"446400","dot_number":"147251","report_state":"CA","report_date":"19970220","report_time":"1400","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":"PIPELINE TRUCKING CO INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:05"},{"crash_id":"458879","dot_number":"147251","report_state":"CA","report_date":"19970124","report_time":"1015","city":"ONTARIO","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":"PIPELINE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:05"}]}