NTSB investigations, Gulf of Mexico

5 cases where NTSB found Environmental issues.

Cases per year

20092026
NTSB investigations, Gulf of Mexico per year, 2009–2026: 5 cases
20091
20121
20131
20242

Latest cases

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'GM' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB DCA25LA091Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-322 · Gulf of America (Gulf of Mexico)An encounter with an area of clear air turbulence during cruise, which resulted in a serious injury to a flight attendant.Dec 29, 2024 · N647UA · No damageNTSB DCA24FA143Accident · Serious injuriesClass 3 · FieldFinal reportBoeing 737-7CT · Gulf of America (Gulf of Mexico)The pilot’s inadvertent encounter with convectively induced turbulence from a broken line of embedded thunderstorms moving across the region. Contributing to the accident was the failure of the air traffic controller to issue pertinent weather information…Apr 3, 2024 · N567WN · No damageNTSB CEN13FA491Accident · Minor injuriesField investigationFinal reportBell 407 · Ship Shoal 208H (Gulf of Mexico)The ingestion of vented methane gas into the helicopter’s engine during takeoff, which caused an engine compressor surge that led to a total loss of engine power.Aug 13, 2013 · N53LP · Substantial damageNTSB CEN12FA321Accident · 1 fatalField investigationFinal reportBell 206-L4 · (Gulf of Mexico)The pilot’s failure to maintain clearance from an obstacle while landing on an obstructed helipad, which resulted in a collision and loss of control. Contributing to the accident was the failure of the helipad owner to mark the helipad closed and the failure…May 28, 2012 · N7077F · Substantial damageNTSB CEN10FA079Accident · No injuriesField investigationFinal reportSikorsky S-76C++ · Gulf of Mexico (Gulf of Mexico)The pilot's failure to fully land the helicopter prior to entering a turn in strong, crosswind conditions, which resulted in a dynamic rollover.Dec 24, 2009 · N798P · Substantial damage