NTSB investigations, Pacific 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 | 1 |
|---|---|
| 1964 | 3 |
| 1966 | 5 |
| 1967 | 2 |
| 1968 | 2 |
| 1969 | 10 |
| 1970 | 4 |
| 1971 | 2 |
| 1972 | 4 |
| 1973 | 2 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 5 |
| 1979 | 3 |
| 1980 | 3 |
| 1988 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 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 c.\"eventStateOrRegion\" = 'PO' 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" = 'PO' 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 DCA27LA019Accident · Serious injuriesClass 4 · LimitedInvestigation openBoeing 777-222 · Pacific Ocean (Pacific Ocean)NTSB DCA26LA167Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Pacific Ocean (Pacific Ocean)An unanticipated encounter with clear air turbulence while in cruise flight.NTSB DCA21WA207IncidentClass 5 · ForeignAirbus 321 · Guam (Pacific Ocean)NTSB ANC21LA006Accident · No injuriesClass 3 · LimitedFinal reportPilatus PC12 · Pacific Ocean (Pacific Ocean)A total loss of engine power due to fuel starvation for reasons that could not be determined based on the available evidence.NTSB DCA19CA090Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 787 · Pacific Ocean (Pacific Ocean)an inadvertent slip and fall that resulted in a serious injury.NTSB WPR17LA186Accident · Minor injuriesLimited investigationFinal reportHawker Siddeley Hunter MK.58 · Pacific Ocean (Pacific Ocean)The pilot’s loss of airplane control after flying through another airplane's jet wash during an air defense exercise.NTSB WPR17LA075Accident · Serious injuriesLimited investigationFinal reportHughes 369A · (Pacific Ocean)The pilot's failure to detect the presence of water in the helicopter fuel system before the flight, which resulted in a total loss of engine power during cruise. Contributing to the accident was the pilot's delayed recognition of the power loss and late…NTSB WPR15LA242Accident · 1 fatalLimited investigationFinal reportBartels Lancair · Pacific Ocean (Pacific Ocean)The pilot's incapacitation for reasons that could not be determined because the airplane was not recovered from the ocean.NTSB DCA15LA067Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Honolulu (Pacific Ocean)an encounter with convective turbulence associated with a forecasted area of thunderstorms.NTSB WPR15LA089Accident · No injuriesLimited investigationFinal reportCirrus SR22 - NO Series · Maui (Pacific Ocean)The pilot's inability to transfer fuel from the aft auxiliary fuel tank to the main fuel tanks for reasons that could not be determined because the airplane was ditched and not recovered.NTSB DCA14CA083Accident · Serious injuriesData collectionFinal reportAirbus A330 323 · Seattle (Pacific Ocean)the flight attendant inadvertently tripping over a passenger's foot that was protruding into the aisle, which resulted in the flight attendant fracturing her foot.NTSB WPR10LA464Accident · 1 fatalLimited investigationFinal reportHughes OH-6A · Majuro (Pacific Ocean)A loss of helicopter control for undetermined reasons.NTSB WPR09LA244Accident · No injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The pilot’s failure to maintain clearance from an object during takeoff from the deck of a fishing vessel.NTSB LAX06WA202Accident · No injuriesForeign investigationPiper PA-44-180 · Pacific Ocean (Pacific Ocean)NTSB SEA03LA029Accident · Serious injuriesLimited investigationFinal reportDassault Falcon 900EX · (Pacific Ocean)The aircraft's encounter with moderate turbulence in cruise.NTSB LAX02LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean (Pacific Ocean)An in-flight encounter with clear air turbulence and wind shear, which resulted in a serious injury to a flight attendant.NTSB LAX89LA068Accident · Serious injuriesLimited investigationFinal reportBoeing 747SP-21 · Midway Islands (Pacific Ocean)Aircraft's encounter with unforecast severve clear turbulence.NTSB LAX81FA001Accident · 2 fatalClosedHughes 369HS · Pacific Ocean (Pacific Ocean)NTSB LAX80DJY01Accident · Minor injuriesClosedBeech D18S · Yap-W.Caroline Is (Pacific Ocean)NTSB LAX80DA077Accident · Minor injuriesClosedCessna 337 · Pacific Ocean (Pacific Ocean)NTSB LAX80DJA03Accident · 1 fatalClosedBeech C-45H · Pacific Ocean (Pacific Ocean)NTSB LAX79IA092Incident · 1 fatalClosedBoeing 747 · Pacific Ocean (Pacific Ocean)NTSB OAK79DAMS7Accident · 2 fatalClosedDouglas DC-3 · Honolulu (Pacific Ocean)NTSB OAK79DJA04Accident · No injuriesClosedCessna 185F · Pacific Ocean (Pacific Ocean)NTSB UNK78X0123Accident · Serious injuriesClosedDouglas DC-10 · Pacific Ocean (Pacific Ocean)NTSB OAK78DJA05Accident · No injuriesClosedPiper PA-28 · Pacific Ocean (Pacific Ocean)NTSB OAK78DJY02Accident · No injuriesClosedCessna 150 · Rota (Pacific Ocean)NTSB LAX78OA002Accident · Serious injuriesClosedBell 47G3B1 · No.Pacific Ocean (Pacific Ocean)NTSB OAK77FJY01Accident · Minor injuriesClosedDornier 28A1 · Kusaie Isl (Pacific Ocean)NTSB OAK77DVD12Accident · 1 fatalClosedPiper PA-28 · Pacific Ocean (Pacific Ocean)NTSB OAK76DJA12Accident · No injuriesClosedPiper PA-32 · No.Pacific Ocean (Pacific Ocean)NTSB OAK76AP043Accident · 1 fatalClosedBeech H18 · Pacific Ocean (Pacific Ocean)NTSB OAK76IP007Incident · No injuriesClosedBoeing 747 · No.Pacific Ocean (Pacific Ocean)NTSB OAK75AP013Accident · Serious injuriesClosedBoeing 747 · No.Pacific Ocean (Pacific Ocean)NTSB OAK74FJA23Accident · No injuriesClosedBeech E18S · No.Pacific Ocean (Pacific Ocean)NTSB OAK74FJA05Accident · Minor injuriesClosedInterstate S-1 · No.Pacific Ocean (Pacific Ocean)NTSB LAX73AL051Accident · 1 fatalClosedCessna 150 · No.Pacific Ocean (Pacific Ocean)NTSB OAK72AP039Accident · Serious injuriesClosedBoeing 747 · N.Pacific Ocean (Pacific Ocean)NTSB OAK72AP037Accident · Serious injuriesClosedBoeing 747 · No.Pacific Ocean (Pacific Ocean)NTSB OAK72DVM29Accident · Minor injuriesClosedDehavilland DH 114 · N.Pacific Ocean (Pacific Ocean)NTSB NYC72AN096Accident · 1 fatalClosedPiper PA-28 · Off Fire Isle (Pacific Ocean)NTSB CHI72AC010Accident · Serious injuriesClosedDouglas DC-8 · No.Pacific Ocean (Pacific Ocean)NTSB NYC72AN008Accident · Serious injuriesClosedBoeing 707 · No.Pacific Ocean (Pacific Ocean)NTSB OAK71AP029Accident · 1 fatalClosedCessna 207 · No.Pacific Ocean (Pacific Ocean)NTSB OAK71AP024Accident · Serious injuriesClosedBoeing 707 · No.Pacific Ocean (Pacific Ocean)NTSB OAK71AP017Accident · Serious injuriesClosedBoeing 707 · No.Pacific Ocean (Pacific Ocean)NTSB MIA70OM084Accident · Serious injuriesClosedDouglas DC-8 · N. Pacific Ocean (Pacific Ocean)NTSB OAK70A0027Accident · Serious injuriesClosedBoeing 707 · No.Pacific Ocean (Pacific Ocean)NTSB NYC70A0042Accident · Serious injuriesClosedBoeing 707 · No.Pacific Ocean (Pacific Ocean)NTSB UNK69X0145Accident · No injuriesClosedAeronca S-15AC · Ebon (Pacific Ocean)