NTSB investigations, 1989, HI
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
| 1963 | 2 |
|---|---|
| 1964 | 16 |
| 1965 | 18 |
| 1966 | 22 |
| 1967 | 29 |
| 1968 | 19 |
| 1969 | 20 |
| 1970 | 12 |
| 1971 | 21 |
| 1972 | 19 |
| 1973 | 24 |
| 1974 | 17 |
| 1975 | 13 |
| 1976 | 19 |
| 1977 | 20 |
| 1978 | 18 |
| 1979 | 17 |
| 1980 | 23 |
| 1981 | 17 |
| 1982 | 13 |
| 1983 | 11 |
| 1984 | 13 |
| 1985 | 19 |
| 1986 | 20 |
| 1987 | 26 |
| 1988 | 12 |
| 1989 | 15 |
| 1990 | 11 |
| 1991 | 18 |
| 1992 | 17 |
| 1993 | 9 |
| 1994 | 18 |
| 1995 | 12 |
| 1996 | 12 |
| 1997 | 14 |
| 1998 | 7 |
| 1999 | 12 |
| 2000 | 15 |
| 2001 | 12 |
| 2002 | 3 |
| 2003 | 14 |
| 2004 | 15 |
| 2005 | 16 |
| 2006 | 13 |
| 2007 | 10 |
| 2008 | 11 |
| 2009 | 10 |
| 2010 | 6 |
| 2011 | 7 |
| 2012 | 10 |
| 2013 | 10 |
| 2014 | 10 |
| 2015 | 6 |
| 2016 | 14 |
| 2017 | 8 |
| 2018 | 12 |
| 2019 | 10 |
| 2020 | 6 |
| 2021 | 5 |
| 2022 | 13 |
| 2023 | 8 |
| 2024 | 11 |
| 2025 | 6 |
| 2026 | 5 |
Where
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 year(c.\"eventDate\") = 1989
AND c.\"eventStateOrRegion\" = 'HI' 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") = 1989 AND c."eventStateOrRegion" = 'HI' 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 LAX90DJA02Accident · Minor injuriesFinal reportBryce Duster BJ-1B · Haleiwa, Oahu, HIThe separation in flight of the vertical wood fin from the main structure. It was not determined if the separation was due to overload forces or fatigue.NTSB LAX90LA050Accident · No injuriesLimited investigationFinal reportHughes 369HS · Waimea, HIThe improper installation of the pc tube by company maintenance personnel, which resulted in fatigue failure of the tube due to induced bending stresses.NTSB LAX90FA019Accident · 1 fatalField investigationFinal reportBeech 77 · Kalihi, HIVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB DCA90MA005Accident · 20 fatalClass 1 · MajorFinal reportDe Havilland DHC-6-300 · Halawa,Molokai, HIThe airplane's controlled flight into terrain as a result of the decision of the captain to continue flight under visual flight rules at night into instrument meteorological conditions (IMC), which obscured rising mountainous terrain. Contributing to the…NTSB LAX90DJA01Accident · Minor injuriesFinal reportEmair MA1-B · Hilo, HIThe failure of a main landing gear tire which caused the pilot to apply excessive brake pressure to avoid departing a narrow landing strip. Contributing to the accident was the pilot accepting an aircraft that had a tire worn beyond safe limits and…NTSB LAX89FA307Accident · 1 fatalField investigationFinal reportAero Commander 680FLP · Kailua-Kona, HIInadequate maintenance, and operation by the pilot with known deficiencies in the aircraft. Factors related to the accident were: excessive wear in both engines, improper use of powerplant controls by the pilot, subsequent overtemperature/detonation in both…NTSB LAX89LA281Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350D · Volcano, HIA catastrophic failure of the power turbine shaft and bearings. The failure was a result of oil starvation due to an excessively worn chip detector o-ring seal,inadequate maintenance and preflight. Contributing factor(s) was: the mountainous terrain.NTSB LAX89LA257Accident · Minor injuriesLimited investigationFinal reportCessna 337H · Honolulu, HIAn unexpected and sudden encounter with severe turbulence while the aircraft was cruising over the pacific ocean in cumulus cloud conditions.NTSB LAX89LA246Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Kalapana, HIThe loss of engine power due to the failure of the engine exhaust valve in the no. 2 cylinder and the disregard of the Lycoming service bulletin by company maintenance personnel. Contributing to the accident was the high vegetation and trees located at the…NTSB LAX89LA188Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Haleiwa, Oahu, HIThe pilot's failure to adequately compensate for wind conditions and the failure to maintain sufficient altitude to clear obstacles. Contributing to the accident were the downdrafts along the ridge line.NTSB LAX89LA222Accident · 2 fatalLimited investigationFinal reportAmerican AA-1C · Kalaupapa, HIThe pilot's failure to maintain sufficient airspeed to prevent a stall from which there was insufficient altitude to recover.NTSB DCA89MA058Accident · 11 fatalMajor investigationFinal reportBeech H18 · Waipio Valley, HIThe pilot's improper in-flight planning/decision to maneuver with insufficient altitude over or in a a canyon area. Factors related to the accident were: the terrain conditions and scenic air tour's lack of specific direction to its pilots concerning safety…NTSB LAX89LA197Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS350D · Waialae Falls, HIImproper maintenance/adjustment of the engine fuel control unit by company maintenance personnel, which resulted in a slight loss of engine power, and failure of the pilot to maintain rotor RPM, while turning and taking off from a hover with a relatively…NTSB DCA89MA027Accident · 9 fatalClass 1 · MajorFinal reportBoeing 747-122 · Honolulu, HIThe sudden opening of the improperly latched forward lobe cargo door in flight and the subsequent explosive decompression. Contributing to the accident was a deficiency in the design of the cargo door locking mechanisms, which made them susceptible to…NTSB LAX89FA103Accident · Minor injuriesField investigationFinal reportCessna 150K · Honolulu, HIInadequate control tower service provided by the local controller (lc), and failure of the two pilots to see and avoid each other's aircraft. Related factors were: identification of the wrong aircraft by the local controller, his excessive workload (heavy…