NTSB investigations, 2012, Gulf of Mexico
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 2012
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") = 2012 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 CEN12LA652Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · (Gulf of Mexico)An in-flight fire, which resulted in the airplane’s forced landing in water. The source of the fire could not be determined because the airplane wreckage was not recovered.NTSB 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…