incidents_2010: Annual data on oil spills in the US from 2010 onward

In julianbarg/oildata: Access data on the American oil pipeline system and oil spills

Description

Distribution, Transmission & Gathering, LNG, and Liquid Accident and Incident Data.

Usage

incidents_2010

Format

A data frame with columns:

DATAFILE_AS_OF

significant

Identify if record meets the significant criteria or not: If there was fatality, injury, fire, explosion, total property damage $50K or more in 1984 dollars, non-HVL loss >= 50bbls, HVL loss >= 5bbls, then SIGNIFICANT=’YES’, else SIGNIFICANT=’NO’. See also: https://www.phmsa.dot.gov/sites/phmsa.dot.gov/files/docs/pdmpublic_incident_page_allrpt.pdf.

serious

Identify if record meets the SERIOUS criteria or not: If there was fatality or injury then SERIOUS = ‘YES’ else SERIOUS = ’NO’.

ipe

Impacting People or the Environment (IPE) – when commodity (A8) is crude oil, refined petroleum products, of biofuel, if either criterion 1 or 2 below is met, the accident counts as IPE : 1. Regardless of Location of Accident (B10): Fatality (A12) greater than zero; or Injury requiring in-patient hospitalization (A13) greater than zero; or Ignition (A15) = Yes; or Explosion (A16) = Yes; or Evacuation (A17) greater than zero; or Wildlife impact (D1) = Yes; or Water contamination (D5a) = Ocean/Seawater, Groundwater, or Drinking water; or Public/Non-Operator Private Property Damage (D8a) greater than zero 2.For Location of Accident (B10) not “TOTALLY CONTAINED ON OPERATOR CONTROLLED PROPERTY”: Unintentional Release Volume (A9) greater than or equal to 5 gallons AND HCA (D7) = Yes; or Unintentional Release Volume (A9) greater than or equal to 5 barrels AND HCA (D7) = No; or Water contamination (D5a) = Surface; or Soil contamination (D2) = Yes.

integrity_assessment_target

Integrity Assessment Target – accidents Impacting People or the Environment (IPE) and one of these causes: Corrosion, Pipeline/Weld Material Failure, Failure of Previously Damage Pipe – caused by Excavation Damage or Other Outside Force Damage.

operations_maintenance_target

Operation & Maintenance Target - accidents Impacting People or the Environment (IPE) and one of these causes: Equipment Failure, Incorrect Operation, 1st & 2nd Party Excavation Damage, 3rd Party Excavation Damage with Root Cause = Locating Practices Not Sufficient.

incident_ID

Unique incident ID. Also called report ID or report number.

SUPPLEMENTAL_NUMBER

REPORT_RECEIVED_DATE

REPORT_TYPE

ID

Unique operator ID.

name

Name of the pipelines operator at the time of the incident (year).

year

Year accident occurred, derived from accident date.

OPERATOR_STREET_ADDRESS

OPERATOR_CITY_NAME

OPERATOR_STATE_ABBREVIATION

OPERATOR_POSTAL_CODE

LOCAL_DATETIME

lat

Accident location latitude.

long

Accident location longitude.

NRC_RPT_NUM

NRC_RPT_DATETIME

commodity

The type of commodity being spilled (Crude, HVL, etc.).

COMMODITY_SUBTYPE

COMMODITY_DETAILS

BLEND_DETAILS

BIO_DIESEL_DETAILS

volume

Volume of the spill.

INTENTIONAL_RELEASE_BBLS

recovered

Estimated volume of commodity recovered (barrels).

net_loss

Volume of commodity unintentionally released (in barrels) minus volume recovered.

FATALITY_IND

NUM_EMP_FATALITIES

NUM_CONTR_FATALITIES

NUM_ER_FATALITIES

NUM_WORKER_FATALITIES

NUM_GP_FATALITIES

fatalities

Total number of Fatalities.

INJURY_IND

NUM_EMP_INJURIES

NUM_CONTR_INJURIES

NUM_ER_INJURIES

NUM_WORKER_INJURIES

NUM_GP_INJURIES

injuries

Total number of Injuries.

SHUTDOWN_DUE_ACCIDENT_IND

SHUTDOWN_EXPLAIN

SHUTDOWN_DATETIME

RESTART_DATETIME

STILL_SHUTDOWN_IND

fire

Commodity ignite (TRUE/FALSE).

explosion

Commodity explode (TRUE/FALSE).

NUM_PUB_EVACUATED

INCIDENT_IDENTIFIED_DATETIME

ON_SITE_DATETIME

on_offshore

Whether the oil spill occured onshore or offshore.

ONSHORE_STATE_ABBREVIATION

ONSHORE_POSTAL_CODE

ONSHORE_CITY_NAME

ONSHORE_COUNTY_NAME

DESIGNATED_LOCATION

DESIGNATED_NAME

PIPE_FAC_NAME

SEGMENT_NAME

FEDERAL

LOCATION_TYPE

INCIDENT_AREA_TYPE

INCIDENT_AREA_SUBTYPE

INCIDENT_AREA_DETAILS

DEPTH_OF_COVER

CROSSING

BRIDGE_CROSSING_IND

BRIDGE_TYPE

RAILROAD_CROSSING_IND

RAILROAD_TYPE

ROAD_CROSSING_IND

ROAD_TYPE

WATER_CROSSING_IND

WATER_TYPE

WATER_NAME

WATER_DEPTH

WATER_SUBTYPE

OFF_WATER_DEPTH

OFF_ACCIDENT_ORIGIN

OFFSHORE_STATE_ABBREVIATION

OFF_INSTATE_AREA

OFF_INSTATE_BLOCK

OFFSHORE_COUNTY_NAME

OFF_OCS_AREA

OFF_OCS_BLOCK

OFF_AREA_ACCIDENT_TYPE

PIPE_FACILITY_TYPE

system

Part of system involved in accident.

SYSTEM_SUBPART_INVOLVED

item

Item involved in accident.

PIPE_TYPE

PIPE_DIAMETER

PIPE_WALL_THICKNESS

PIPE_SMYS

PIPE_SPECIFICATION

PIPE_SEAM_TYPE

PIPE_SEAM_DETAILS

PIPE_MANUFACTURER

PIPE_MANUFACTURE_YEAR

PIPE_COATING_TYPE

PIPE_COATING_DETAILS

WELD_SUBTYPE

WELD_DETAILS

VALVE_TYPE

VALVE_MAINLINE_TYPE

VALVE_MAINLINE_DETAILS

VALVE_MANUFACTURER

VALVE_MANUFACTURE_YEAR

TANK_VESSEL_SUBTYPE

ITEM_INVOLVED_DETAILS

TANK_VESSEL_DETAILS

installation_year

Year item installed that involved in accident.

MATERIAL_INVOLVED

MATERIAL_DETAILS

RELEASE_TYPE

PUNCTURE_AXIAL

PUNCTURE_CIRCUM

LEAK_TYPE

LEAK_TYPE_OTHER

RUPTURE_ORIENT

RUPTURE_DETAILS

RUPTURE_WIDTH

RUPTURE_LENGTH

RELEASE_TYPE_DETAILS

WILDLIFE_IMPACT_IND

FISH_AQUATIC_IMPACT_IND

BIRDS_IMPACT_IND

TERRESTRIAL_IMPACT_IND

SOIL_CONTAMINATION

LONG_TERM_ASSESSMENT

REMEDIATION_IND

surface_water_remediation

Need for surface water remediation anticipated?

groundwater_remediation

Need for groundwater remediation anticipated?

soil_remediation

Need for soil remediation anticipated?

vegetation_remediation

Need for vegetation remediation anticipated?

wildlife_remediation

Need for wildlife remediation anticipated?

water_contamination

Water Contamination.

OCEAN_SEAWATER_IND

SURFACE_CONTAM_IND

GROUNDWATER_CONTAM_IND

DRINKING_WATER_CONTAM_IND

PRIVATE_WELL_CONTAM_IND

PUBLIC_WATER_CONTAM_IND

AMOUNT_RELEASED

REL_WATER_NAME

COULD_BE_HCA

COMMODITY_REACHED_HCA

COMMERCIALLY_NAV_IND

COMMERCIALLY_NAV_YES_NO

HIGH_POP_IND

HIGH_POP_YES_NO

OTHER_POP_IND

OTHER_POP_YES_NO

USA_DRINKING_IND

USA_DRINKING_YES_NO

USA_ECOLOGICAL_IND

USA_ECOLOGICAL_YES_NO

EST_COST_OPER_PAID

EST_COST_GAS_RELEASED

EST_COST_PROP_DAMAGE

EST_COST_EMERGENCY

EST_COST_ENVIRONMENTAL

EST_COST_OTHER

EST_COST_OTHER_DETAILS

cost

Total estimated property damage (sum of above).

cost_1984

Converted Property Damage to Year 1984 dollars.

TOTAL_COST_CURRENT

ACCIDENT_PSIG

MOP_PSIG

ACCIDENT_PRESSURE

PRESSURE_RESTRICTION_IND

EXCEED_RESTRICTION_IND

PHMSA_RESTRICTION_IND

PART_C_QUESTION_2_IND

UPSTREAM_VALVE_TYPE_IND

DOWNSTREAM_VALVE_TYPE_IND

LENGTH_SEGMENT_ISOLATED

INTERNAL_INSPECTION_IND

DIAMETER_CHANGE_IND

UNSUITABLE_MAINLINE_IND

TIGHT_MITERED_IND

OTHER_RESTRICTIONS_IND

EXTRA_THICK_WALL_IND

OTHER_INSPECTION_IND

INTERNAL_INSPECTION_DETAILS

OPERATION_COMPLICATIONS_IND

EXCESSIVE_DEBRIS_IND

LOW_OP_PRESSURE_IND

LOW_FLOW_IND

INCOMPAT_COMMOD_IND

OTHER_COMPLICATIONS_IND

INSPECT_COMP_DETAILS

PIPELINE_FUNCTION

SCADA_IN_PLACE_IND

SCADA_OPERATING_IND

SCADA_FUNCTIONAL_IND

SCADA_DETECTION_IND

SCADA_CONF_IND

CPM_IN_PLACE_IND

CPM_OPERATING_IND

CPM_FUNCTIONAL_IND

CPM_DETECTION_IND

CPM_CONF_IND

ACCIDENT_IDENTIFIER

ACCIDENT_DETAILS

OPERATOR_TYPE

INVESTIGATION_STATUS

INVESTIGATION_STATUS_DETAILS

INVEST_SCHEDULE_IND

INVEST_NO_SCHEDULE_IND

INVEST_NO_SCHEDULE_IND_DETAILS

INVEST_NO_CONTROL_ROOM_IND

INVEST_NO_CONTROLLER_IND

INVEST_INCORRECT_ACTION_IND

INVEST_FATIGUE_IND

INVEST_INCORRECT_PROCEDURE_IND

INVEST_INCORRECT_CONTROL_IND

INVEST_MAINT_IND

INVEST_OTHER_IND

INVEST_OTHER_IND_DETAILS

EMPLOYEE_DRUG_TEST_IND

CONTRACTOR_DRUG_TEST_IND

NUM_EMPLOYEES_TESTED

NUM_EMPLOYEES_FAILED

NUM_CONTRACTORS_TESTED

NUM_CONTRACTORS_FAILED

MAP_CAUSE

Cause, coded by PHMSA.

CAUSE_DETAILS

INTERNAL_EXTERNAL

VISUAL_EXAM_RESULTS

VISUAL_EXAM_DETAILS

GALVANIC_CORROSION_IND

ATMOSPHERE_CORROSION_IND

STRAY_CURRENT_CORROSION_IND

MICROBIOLOGICAL_CORROSION_IND

SELECTIVE_SEAM_CORROSION_IND

OTHER_CORROSION_IND

CORROSION_TYPE_DETAILS

FIELD_EXAM_BASIS_IND

METALLURGICAL_BASIS_IND

OTHER_BASIS_IND

CORROSION_BASIS_DETAILS

UNDERGROUND_LOCATION

UNDER_CATHODIC_PROTECTION_IND

CATHODIC_PRO_START_YEAR

SHIELDING_EVIDENT

CATHODIC_SURVEY_TYPE

CP_ANNUAL_SURVEY_IND

CLOSE_INTERVAL_SURVEY_IND

OTHER_CP_SURVEY_IND

CP_ANNUAL_SURVEY_YEAR

CLOSE_INTERVAL_SURVEY_YEAR

OTHER_CP_SURVEY_YEAR

EXTERNALLY_COATED

PRIOR_DAMAGE

INT_VISUAL_EXAM_RESULTS

INT_VISUAL_EXAM_DETAILS

INT_CORROSIVE_COMMODITY_IND

INT_WATER_ACID_IND

INT_MICROBIOLOGICAL_IND

INT_EROSION_IND

INT_OTHER_CORROSION_IND

INT_CORROSION_TYPE_DETAILS

INT_FIELD_EXAM_BASIS_IND

INT_METALLURGICAL_BASIS_IND

INT_OTHER_BASIS_IND

INT_CORROSION_BASIS_DETAILS

INT_LOW_POINT_PIPE_LOC_IND

INT_ELBOW_LOC_IND

INT_OTHER_LOC_IND

CORROSION_LOCATION_DETAILS

CORROSION_INHIBITORS

CORROSION_LINING

CLEANING_DEWATERING

CORROSION_COUPONS

API_STD_OUT_OF_SERVICE_IND

API_STD_OUT_OF_SERVICE_YEAR

API_STD_IN_SERVICE_IND

API_STD_IN_SERVICE_YEAR

COR_INSP_TOOL_COLL_IND

COR_MAGNETIC_FLUX_LEAKAGE_IND

COR_MAG_FLUX_LEAKAGE_YEAR

COR_ULTRASONIC_IND

COR_ULTRASONIC_YEAR

COR_GEOMETRY_IND

COR_GEOMETRY_YEAR

COR_CALIPER_IND

COR_CALIPER_YEAR

COR_CRACK_IND

COR_CRACK_YEAR

COR_HARDSPOT_IND

COR_HARDSPOT_YEAR

COR_COMBINATION_TOOL_IND

COR_COMBINATION_TOOL_YEAR

COR_TRANSVERSE_FIELD_IND

COR_TRANSVERSE_FIELD_YEAR

COR_INSPECTION_OTHER_IND

COR_INSPECTION_OTHER_YEAR

COR_INSPECTION_OTHER_DETAILS

COR_HYDROTEST_CONDUCTED_IND

COR_HYDROTEST_CONDUCTED_YEAR

COR_HYDROTEST_PRESSURE

DIRECT_INSPECTION_TYPE

DIRECT_YES_DIG_YEAR

DIRECT_YES_NO_DIG_YEAR

COR_NON_DESTRUCTIVE_IND

COR_RADIOGRAPHY_IND

COR_RADIOGRAPHY_YEAR

COR_GUIDED_WAVE_IND

COR_GUIDED_WAVE_YEAR

COR_HANDHELD_ULTRA_IND

COR_HANDHELD_ULTRA_YEAR

COR_WET_MAGNETIC_IND

COR_WET_MAGNETIC_YEAR

COR_DRY_MAGNETIC_IND

COR_DRY_MAGNETIC_YEAR

COR_NON_DEST_OTHER_IND

COR_NON_DEST_OTHER_YEAR

COR_NON_DEST_DETAILS

NATURAL_FORCE_TYPE

EARTH_SUBTYPE

HEAVY_RAINS_SUBTYPE

LIGHTNING_SUBTYPE

TEMPERATURE_SUBTYPE

NF_OTHER_DETAILS

NF_EXTREME_WEATHER_IND

NF_HURRICANE_IND

NF_TROPICAL_STORM_IND

NF_TORNADO_IND

NF_OTHER_IND

NF_EXTREME_WEATHER_DETAILS

excavation_damage_type

Type of damage caused by excavation party.

EX_INSPECT_TOOL_COLLECTED_IND

EX_MAGNETIC_FLUX_LEAKAGE_IND

EX_MAGNETIC_FLUX_LEAKAGE_YEAR

EX_ULTRASONIC_IND

EX_ULTRASONIC_YEAR

EX_GEOMETRY_IND

EX_GEOMETRY_YEAR

EX_CALIPER_IND

EX_CALIPER_YEAR

EX_CRACK_IND

EX_CRACK_YEAR

EX_HARDSPOT_IND

EX_HARDSPOT_YEAR

EX_COMBINATION_TOOL_IND

EX_COMBINATION_TOOL_YEAR

EX_TRANSVERSE_FIELD_IND

EX_TRANSVERSE_FIELD_YEAR

EX_INSPECTION_OTHER_IND

EX_INSPECTION_OTHER_YEAR

EX_INSPECTION_OTHER_DETAILS

EX_BEFORE_DAMAGE

EX_HYDROTEST_CONDUCTED_IND

EX_HYDROTEST_CONDUCTED_YEAR

EX_HYDROTEST_PRESSURE

EX_DIRECT_INSPECTION_TYPE

EX_DIRECT_YES_DIG_YEAR

EX_DIRECT_YES_NO_DIG_YEAR

EX_NON_DESTRUCTIVE_IND

EX_RADIOGRAPHY_IND

EX_RADIOGRAPHY_YEAR

EX_GUIDED_WAVE_IND

EX_GUIDED_WAVE_YEAR

EX_HANDHELD_ULTRA_IND

EX_HANDHELD_ULTRA_YEAR

EX_WET_MAGNETIC_IND

EX_WET_MAGNETIC_YEAR

EX_DRY_MAGNETIC_IND

EX_DRY_MAGNETIC_YEAR

EX_NON_DEST_OTHER_IND

EX_NON_DEST_OTHER_YEAR

EX_NON_DEST_OTHER_DETAILS

PRIOR_NOTIFICATION_IND

ONE_CALL_SYSTEM_IND

EXCAVATOR_IND

CONTRACTOR_IND

LANDOWNER_IND

NOTIFY_CGA_DIRT

PUBLIC_ROW_IND

PUBLIC_SUBTYPE

PRIVATE_ROW_IND

PRIVATE_SUBTYPE

PIPELINE_EASEMENT_ROW_IND

POWER_TRANSMISSION_ROW_IND

RAILROAD_ROW_IND

PUBLIC_UTIL_EASEMENT_ROW_IND

FEDERAL_LAND_ROW_IND

DATA_NOT_COLLECTED_ROW_IND

UNKNOWN_ROW_IND

EXCAVATOR_TYPE

EXCAVATOR_EQUIPMENT

WORK_PERFORMED

ONE_CALL_NOTIFIED_IND

ONE_CALL_TICKET_NUM

ONE_CALL_CENTER_NAME

LOCATOR_TYPE

VISIBLE_MARKS

FACILITIES_MARKED

SERVICE_INTERRUPTION

SERVICE_INTERRUPTION_HOURS

ROOT_CAUSE

ONE_CALL_SUBTYPE

LOCATING_SUBTYPE

EXCAVATION_SUBTYPE

ROOT_CAUSE_OTHER

OUTSIDE_FORCE_TYPE

VEHICLE_SUBTYPE

OSF_HURRICANE_IND

OSF_TROPICAL_STORM_IND

OSF_TORNADO_IND

OSF_HEAVY_RAINS_IND

OSF_OTHER_WEATHER_IND

OSF_OTHER_WEATHER_DETAILS

OSF_INSPECT_TOOL_COLLECTED_IND

OSF_MAGNETIC_FLUX_LEAKAGE_IND

OSF_MAGNETIC_FLUX_LEAKAGE_YEAR

OSF_ULTRASONIC_IND

OSF_ULTRASONIC_YEAR

OSF_GEOMETRY_IND

OSF_GEOMETRY_YEAR

OSF_CALIPER_IND

OSF_CALIPER_YEAR

OSF_CRACK_IND

OSF_CRACK_YEAR

OSF_HARDSPOT_IND

OSF_HARDSPOT_YEAR

OSF_COMBINATION_TOOL_IND

OSF_COMBINATION_TOOL_YEAR

OSF_TRANSVERSE_FIELD_IND

OSF_TRANSVERSE_FIELD_YEAR

OSF_INSPECTION_OTHER_IND

OSF_INSPECTION_OTHER_YEAR

OSF_INSPECTION_OTHER_DETAILS

OSF_BEFORE_DAMAGE

OSF_HYDROTEST_CONDUCTED_IND

OSF_HYDROTEST_CONDUCTED_YEAR

OSF_HYDROTEST_PRESSURE

OSF_DIRECT_INSPECTION_TYPE

OSF_DIRECT_YES_DIG_YEAR

OSF_DIRECT_YES_NO_DIG_YEAR

OSF_NON_DESTRUCTIVE_IND

OSF_RADIOGRAPHY_IND

OSF_RADIOGRAPHY_YEAR

OSF_GUIDED_WAVE_IND

OSF_GUIDED_WAVE_YEAR

OSF_HANDHELD_ULTRA_IND

OSF_HANDHELD_ULTRA_YEAR

OSF_WET_MAGNETIC_IND

OSF_WET_MAGNETIC_YEAR

OSF_DRY_MAGNETIC_IND

OSF_DRY_MAGNETIC_YEAR

OSF_NON_DEST_OTHER_IND

OSF_NON_DEST_OTHER_YEAR

OSF_NON_DEST_DETAILS

INTENTIONAL_SUBTYPE

INTENTIONAL_DETAILS

OSF_OTHER_DETAILS

FIELD_EXAM_IND

METALLURGICAL_IND

OTHER_ANALYSIS_IND

OTHER_ANALYSIS_DETAILS

STILL_UNDER_INVEST_IND

FAILURE_TYPE

FATIGUE_VIBR_RELATED_1

FAILURE_SUBTYPE_1

FATIGUE_VIBR_RELATED_OTHER_1

MECHANICAL_STRESS_1

OTHER_FACTOR_1

OTHER_FACTOR_DETAILS_1

FATIGUE_VIBR_RELATED_2

FAILURE_SUBTYPE_2

FATIGUE_VIBR_RELATED_OTHER_2

MECHANICAL_STRESS_2

OTHER_FACTOR_2

OTHER_FACTOR_DETAILS_2

STRESS_SUBTYPE

STRESS_DETAILS

ADDITIONAL_DENT_IND

ADDITIONAL_GOUGE_IND

ADDITIONAL_PIPE_BEND_IND

ADDITIONAL_ARC_BURN_IND

ADDITIONAL_CRACK_IND

ADDITIONAL_LACK_FUSION_IND

ADDITIONAL_LAMINATION_IND

ADDITIONAL_BUCKLE_IND

ADDITIONAL_WRINKLE_IND

PWF_ADDL_MISALIGNMENT_IND

ADDITIONAL_BURNT_STEEL_IND

PWF_ADDITIONAL_OTHER_IND

PWF_ADDITIONAL_OTHER_DETAILS

PWF_INSP_TOOL_COLLECTED_IND

PWF_MAGNETIC_FLUX_LEAKAGE_IND

PWF_MAG_FLUX_LEAKAGE_YEAR

PWF_ULTRASONIC_IND

PWF_ULTRASONIC_YEAR

PWF_GEOMETRY_IND

PWF_GEOMETRY_YEAR

PWF_CALIPER_IND

PWF_CALIPER_YEAR

PWF_CRACK_IND

PWF_CRACK_YEAR

PWF_HARDSPOT_IND

PWF_HARDSPOT_YEAR

PWF_COMBINATION_TOOL_IND

PWF_COMBINATION_TOOL_YEAR

PWF_TRANSVERSE_FIELD_IND

PWF_TRANSVERSE_FIELD_YEAR

PWF_INSPECTION_OTHER_IND

PWF_INSPECTION_OTHER_YEAR

PWF_INSPECTION_OTHER_DETAILS

PWF_HYDROTEST_CONDUCTED_IND

PWF_HYDROTEST_CONDUCTED_YEAR

PWF_HYDROTEST_PRESSURE

PWF_DIRECT_INSPECTION_TYPE

PWF_DIRECT_YES_DIG_YEAR

PWF_DIRECT_YES_NO_DIG_YEAR

PWF_NON_DEST_IND

PWF_RADIOGRAPHY_IND

PWF_RADIOGRAPHY_YEAR

PWF_GUIDED_WAVE_IND

PWF_GUIDED_WAVE_YEAR

PWF_HANDHELD_ULTRA_IND

PWF_HANDHELD_ULTRA_YEAR

PWF_WET_MAGNETIC_IND

PWF_WET_MAGNETIC_YEAR

PWF_DRY_MAGNETIC_IND

PWF_DRY_MAGNETIC_YEAR

PWF_NON_DEST_OTHER_IND

PWF_NON_DEST_OTHER_YEAR

PWF_NON_DEST_OTHER_DETAILS

EQ_FAILURE_TYPE

CONTROL_VALVE_IND

INSTRUMENTATION_IND

SCADA_IND

COMMUNICATIONS_IND

BLOCK_VALVE_IND

CHECK_VALVE_IND

RELIEF_VALVE_IND

POWER_FAILURE_IND

STOPPLE_CONTROL_FITTING_IND

ESD_SYSTEM_FAILURE_IND

OTHER_CONTROL_RELIEF_IND

OTHER_CONTROL_RELIEF_DETAILS

OTHER_PUMP_IND

OTHER_PUMP_DETAILS

OTHER_STRIPPED_IND

OTHER_STRIPPED_DETAILS

OTHER_NON_THREADED_IND

OTHER_NON_THREADED_DETAILS

FAILURE_DETAILS

ADDITIONAL_VIBRATION_IND

ADDITIONAL_OVERPRESSURE_IND

ADDITIONAL_SUPPORT_IND

ADDITIONAL_DEFECT_IND

ADDITIONAL_ELECTRICITY_IND

ADDITIONAL_INSTALLATION_IND

ADDITIONAL_MISMATCH_IND

ADDITIONAL_DISSIMILAR_IND

ADDITIONAL_BREAKDOWN_IND

ADDITIONAL_VALVE_IND

ADDITIONAL_ALARM_IND

IEF_ADDL_MISALIGNMENT_IND

ADDITIONAL_THERMAL_IND

EQ_ADDITIONAL_OTHER_IND

EQ_ADDITIONAL_OTHER_DETAILS

OPERATION_TYPE

OVERFLOW_OTHER_IND

OVERFLOW_OTHER_DETAILS

OPERATION_DETAILS

RELATED_INADEQUATE_PROC_IND

RELATED_NO_PROC_IND

RELATED_FAILURE_FOLLOW_IND

RELATED_OTHER_IND

OPERATION_RELATED_DETAILS

CATEGORY_TYPE

OPERATOR_QUALIFICATION_IND

QUALIFIED_INDIVIDUALS

OTHER_TYPE

MISC_DETAILS

UNKNOWN_SUBTYPE

PREPARER_NAME

PREPARER_TITLE

PREPARER_EMAIL

PREPARER_TELEPHONE

PREPARER_FAX

PREPARED_DATE

AUTHORIZER_NAME

AUTHORIZER_TITLE

AUTHORIZER_TELEPHONE

AUTHORIZER_EMAIL

narrative

Written description of the incident.

EST_COST_OPER_PAID_CURRENT

EST_COST_GAS_RELEASED_CURRENT

EST_COST_PROP_DAMAGE_CURRENT

EST_COST_EMERGENCY_CURRENT

EST_COST_ENVIRONMENTAL_CURRENT

EST_COST_OTHER_CURRENT

cause

Cause of the incident.

subcause

Subcause of the incident, coded by PHMSA.

SPILL_TYPE_CATEGORY

date

Date of the spill.

state

State of incidents (for offshore, the state of nearby coast).

manufacture_year

Year that the failed pipe or valve was manufactured.

Details

Title 49 of the Code of Federal Regulations (49 CFR Parts 191, 195) requires pipeline operators to submit incident reports within 30 days of a pipeline incident or accident. The CFR defines accidents and incidents, as well as criteria for submitting reports to the Office of Pipeline Safety. The following kinds of information are collected: * Key report information * In-depth location information * Facility information * Operating information * Drug and Alcohol information * Cause of the accident/incident Specific information includes the time and location of the incident(s), number of any injuries and/ or fatalities, commodity spilled/gas released, causes of failure and evacuation procedures. The reports are used for identifying long- and short-term trends at the national, state and operator-specific levels. The frequency, causes, and consequences of the incidents provide insight into the safety metrics currently used by PHMSA, state partners, and other pipeline safety stakeholders, including the pipeline industry and general public. PHMSA also uses the data for inspection planning and risk assessment.

Source

United States Department of Transportation (DOT) Pipeline and Hazardous Materials Safety Administration (PHMSA). https://www.phmsa.dot.gov/data-and-statistics/pipeline/distribution-transmission-gathering-lng-and-liquid-accident-and-incident-data (right side bar).

Examples

## Not run: 
 incidents_2010

## End(Not run)

julianbarg/oildata documentation built on Nov. 27, 2020, 4 p.m.