NTSB investigations, 2006, Gulf of Mexico
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1964 | 2 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 3 |
| 1972 | 2 |
| 1973 | 5 |
| 1974 | 1 |
| 1975 | 3 |
| 1976 | 2 |
| 1977 | 1 |
| 1980 | 4 |
| 1981 | 6 |
| 2006 | 2 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 2 |
Where
Open the mapLatest 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 year(c.\"eventDate\") = 2006
AND c.\"eventStateOrRegion\" = 'GM' AND c.\"eventCountry\" = 'USA'
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.
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 year(c."eventDate") = 2006 AND c."eventStateOrRegion" = 'GM' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DFW06IA151Incident · Serious injuriesIncident investigationFinal reportBell 206L-1 · South Pass 57 (Gulf of Mexico)The passenger's failure to follow procedures associated with operations in the vicinity of the helicopter and his failure to see/avoid the tail rotor of the helicopter.NTSB DFW06LA072Accident · Minor injuriesLimited investigationFinal reportBell 222B · Gulf of Mexico (Gulf of Mexico)The flight crew's failure to maintain control of the helicopter, and the crew's diverted attention to secondary tasks while preparing for the night landing. A contributing factor was the dark night conditions.