NTSB investigations, Atlantic Ocean
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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
| 1962 | 2 |
|---|---|
| 1964 | 2 |
| 1965 | 4 |
| 1966 | 4 |
| 1967 | 12 |
| 1968 | 9 |
| 1969 | 7 |
| 1970 | 3 |
| 1971 | 10 |
| 1972 | 7 |
| 1973 | 8 |
| 1974 | 5 |
| 1975 | 11 |
| 1976 | 3 |
| 1977 | 5 |
| 1978 | 8 |
| 1979 | 4 |
| 1980 | 10 |
| 1981 | 12 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2011 | 1 |
| 2012 | 4 |
| 2015 | 1 |
| 2018 | 2 |
| 2019 | 4 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 4 |
| 2026 | 1 |
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 c.\"eventStateOrRegion\" = 'AO' 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 c."eventStateOrRegion" = 'AO' 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 DCA26LA165Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Atlantic Ocean (Atlantic Ocean)The airplane’s encounter with turbulence resulted in serious injuries to a flight attendant who was not seated due to completion of arrival compliance checks.NTSB DCA23LA462Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Caribbean Sea (Atlantic Ocean)An inadvertent encounter with convectively induced turbulence during cruise that was not depicted by the airplane’s weather radar system.NTSB DCA23LA421Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-222 · Over the (Atlantic Ocean)An inadvertent encounter with clear air turbulence during cruise flight.NTSB DCA23LA382Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Myrtle Beach (Atlantic Ocean)An encounter with convectively induced turbulence (CIT) while in cruise flight.NTSB DCA23LA252Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-223 · Atlantic Ocean (Atlantic Ocean)An encounter with inadvertent convective turbulence during cruise flight.NTSB ERA22LA375Accident · 1 fatalClass 4 · LimitedFinal reportCessna 172 · Atlantic Ocean (Atlantic Ocean)The pilot's suicide.NTSB ERA21LA141Accident · 1 fatalClass 3 · LimitedFinal reportSteinman Mark E Lancair 320 · Atlantic Ocean (Atlantic Ocean)The airplane’s impact with water for reasons that could not be determined.NTSB ERA19LA180Accident · 1 fatalLimited investigationFinal reportCessna 560 · Atlantic Ocean (Atlantic Ocean)Impact with water for reasons that could not be determined based on the available information.NTSB ERA19TA120Accident · Minor injuriesClass 3Final reportCirrus SR22 · Atlantic Ocean (Atlantic Ocean)A loss of oil pressure and subsequent total loss of engine power for undetermined reasons.NTSB ERA19TA111Accident · No injuriesFinal reportPiper PA32 · West Palm Beach (Atlantic Ocean)A total loss of engine power for reasons that could not be determined based on the available evidence, which resulted in a ditched landing in the ocean.NTSB ERA19LA093Accident · 2 fatalLimited investigationFinal reportPiper PA32RT · Atlantic Ocean (Atlantic Ocean)The pilot's loss of control due to spatial disorientation.NTSB ERA19LA026Accident · 5 fatalLimited investigationFinal reportPiper PA31T · Atlantic Ocean (Atlantic Ocean)An in-flight loss of control, which resulted in an impact with water, for reasons that could not be determined because the airplane was not recovered.NTSB ERA18LA119Accident · 2 fatalLimited investigationFinal reportAmes Angier M LNC2 · Atlantic Ocean (Atlantic Ocean)The pilot's spatial disorientation after entering instrument meteorological conditions and encountering moderate-to-heavy precipitation, which resulted in a loss of airplane control.NTSB ERA15LA349Accident · 1 fatalLimited investigationFinal reportMooney M20TN · Atlantic City (Atlantic Ocean)A loose oxygen line, which was not detected by maintenance personnel during a recent annual inspection, that allowed oxygen to escape and drain the oxygen canister more quickly than the pilot expected. This reduced the pilot's availability of supplemental…NTSB ERA12LA578Accident · 1 fatalLimited investigationFinal reportCessna 172B · Atlantic Ocean (Atlantic Ocean)The pilot’s suicidal act.NTSB ERA12LA410Accident · No injuriesLimited investigationFinal reportPiper J5A · Atlantic Ocean (Atlantic Ocean)A loss of engine power for reasons that could not be determined because the aircraft sank after ditching and was not recovered.NTSB ERA12FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 150F · Atlantic Ocean (Atlantic Ocean)Undetermined (airplane and pilot missing).NTSB ERA12FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 182P · Atlantic Ocean (Atlantic Ocean)Undetermined; the airplane and pilot are missing.NTSB DCA11WA110Accident · Serious injuriesForeign investigationBoeing 777 · Montauk (Atlantic Ocean)The Unfalluntersuchungsstelle - Luftfahrt Accident Investigation Branch of Austria has notified the NTSB of an accident involving a Boeing 777-200 that occurred on September 12, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB NYC06LA016Accident · Serious injuriesLimited investigationFinal reportBoeing 737-832 · Atlantic Ocean (Atlantic Ocean)An encounter with turbulence during cruise flight.NTSB NYC04TA103Accident · No injuriesFinal reportMcDonnell Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean)The failure of the number two upper forward right engine cowling attachment, which resulted in substantial damage to the right inboard elevator. A factor was the inadequate procedures in the airliner maintenance manual.NTSB IAD03WA020Incident · No injuriesForeign investigationBritish Concorde · Atlantic Ocean (Atlantic Ocean)NTSB MIA01LA131Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR 42-300 · Atlantic Ocean (Atlantic Ocean)The in-flight encounter with moderate to severe turbulence in clouds resulting in the serious injury to the flight attendant. A contributing factor in the accident was the poor in-flight planning by the captain for his allowing beverage service to continue…NTSB MIA00FA064Accident · 1 fatalField investigationFinal reportCessna 172R · Atlantic Ocean (Atlantic Ocean)The pilot's lack of total experience in instrument flight, simulated instrument flight, and night flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with water. Contributing to the accident was the dark night with…NTSB MIA82FA019Accident · 2 fatalClosedPiper PA-60 · Sebastian (Atlantic Ocean)NTSB FTW82DA029Accident · No injuriesClosedBell 206L-1 · Gulf Of Mexico (Atlantic Ocean)NTSB FTW82DA028Accident · No injuriesClosedBell 206B · Gulf Of Mexico (Atlantic Ocean)NTSB DCA81AA026Accident · 1 fatalClosedDouglas DC-10 · N Atlantic Ocean (Atlantic Ocean)NTSB MIA81DA119Accident · 1 fatalClosedPiper PA-23 · Cuba (Atlantic Ocean)NTSB FTW81DRD35Accident · Minor injuriesClosedAerospatial AS350D · Gulf Of Mexico (Atlantic Ocean)NTSB MIA81DA082Accident · Minor injuriesClosedBrittnorman BN-2A · Nassau (Atlantic Ocean)NTSB FTW81IA099Incident · No injuriesClosedAerospatial AS350D · Gulf Of Mexico (Atlantic Ocean)NTSB FTW81DRA33Accident · No injuriesClosedBell 206B · Gulf Of Mexico (Atlantic Ocean)NTSB FTW81IA070Incident · No injuriesClosedBell 206B · Gulf Of Mexico (Atlantic Ocean)NTSB MIA81FA057Accident · 1 fatalClosedDouglas C-54B · St.Croix (Atlantic Ocean)NTSB MIA81DA044Accident · 2 fatalClosedPiper PA-32 · Aruba (Atlantic Ocean)NTSB FTW81DA016Accident · No injuriesClosedAerospatial AS-350 · Cameron (Atlantic Ocean)NTSB MIA81DA020Accident · 2 fatalClosedAero Comdr 520 · Grt Inagua (Atlantic Ocean)NTSB MIA81FA014Accident · 4 fatalClosedBell 206B · Atlantic Ocean (Atlantic Ocean)NTSB MIA810A005Accident · Serious injuriesClosedBoeing 707 · Kingston (Atlantic Ocean)NTSB MIA80FA104Accident · 3 fatalClosedDouglas DC-6B · Haiti-In Ocean (Atlantic Ocean)NTSB MIA80DA102Accident · Serious injuriesClosedLockheed L1011 · Nassau (Atlantic Ocean)NTSB MIA80DA093Accident · 1 fatalClosedPiper PA-23 · Little Rag Is (Atlantic Ocean)NTSB MIA81DKT36Accident · No injuriesClosedPiper PA-23 · Guantanamo (Atlantic Ocean)NTSB IAD80AA018Accident · 2 fatalClosedCessna 441 · Atlantic Ocean (Atlantic Ocean)NTSB MIA80DA024Accident · No injuriesClosedBeech C-50 · Atlantic Ocean (Atlantic Ocean)NTSB MIA79DKT97Accident · No injuriesClosedCessna 210 · Atlantic Ocean (Atlantic Ocean)NTSB NYC79DA062Accident · No injuriesClosedPiper PA-18 · Martha'S Vnyrd (Atlantic Ocean)NTSB MIA79DA114Accident · No injuriesClosedLockheed PV-1 · Aruba (Atlantic Ocean)NTSB MIA79DA079Accident · 2 fatalClosedLockheed PV-1 · Guamtanamo (Atlantic Ocean)