NTSB investigations, 1986, HI
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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
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\") = 1986
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") = 1986 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 LAX87LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Waipahu, HIThe plt dragged both wings through a sugar cane crop during landing roll on a gravel road after a partial loss of power. The engine had 4040 total hours and had been previously overhauled 1655 hours prior. The plt indicated that the eng had a top overhaul…NTSB LAX87DJA02Accident · No injuriesFinal reportCessna 172N · Honolulu, HIThe acft experienced a loss of engine power while descending during a practice instrument apch. The temperature was 81 degrees (f) with the dew point of 71 degrees (f). According to the icing probability chart, there is a possibility of serious carburetor…NTSB LAX87LA030Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Eleele Kauai, HIA Piper pa 31-350 lost power and collided with sign posts after landing on a road. It was reported to the FAA that the aircraft's right engine was producing partial power and the aircraft was unable to maintain altitude on the left engine. The pilot never…NTSB LAX87DJA01Accident · No injuriesFinal reportMurrayair MA-1 · Hilo, HIAfter returning from a spraying flt, the acft was refueled. After refueling, the plt used fuel to wash oil from the side of the acft & the wing step. When the eng was restarted about 2 min later, fuel fumes ignited & fire spread to the fuel truck. Both the…NTSB LAX87LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Hana, HIDuring a solo instructional flight, the pilot was attempting to fly a course directly over a 10,400 foot mountain. At the 5,200 ft level the pilot encountered turbulence and noticed a cloud build-up over the mountain. The pilot then decided to divert to the…NTSB LAX86FJA03Accident · Serious injuriesFinal reportBell 47G-3B1 · Lihue, HIThe helicoper crashed into trees while on a local pleasure flight. The pilot indicated that while hovering out of ground effect the main rotor and engine RPM were dropping below the minimum operating limits. The pilot lowered the collective to regain RPM but…NTSB LAX86FA243Accident · Serious injuriesField investigationFinal reportBell 206B · Hanalei, HIThe helicopter had just departed runway 05. Ground witnesses and several occupants in the helicopter reported that when it was about 150 ft AGL it sustained a total engine power loss. The pilot immediately entered into an abrupt right turn autorotation. The…NTSB LAX86MA238Accident · Minor injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Kameula, HIThe plt rprtd that as he 'hovered' the helicopter btn 5 & 10 ft after lift-off, he noted a 'slight lateral vibration.' He lndd immediately, but the vibration/ground resonance (vib) increased in severity, so he 'shut-off' both throttles. The vib contd to the…NTSB LAX86FJA06Accident · 2 fatalFinal reportBell 206B · Maui, HIThe acft collided with powerlines while carrying pass'g on a sightseeing flt through a canyon. The wires across the canyon were EST to be 1700 long with height AGL unknown. The wires were unmarked and were 1/2 in dia aluminum. One of the passengers was…NTSB LAX86LA193Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Keaau, HIA hiller 1100 was destroyed by fire after a forced landing. The plt indicated that the EGT had risen to approximately 800 deg c from 700 deg and then rose to 1100 deg. The heat warning light illuminated. The plt initiated a precautionary landing. The eng…NTSB LAX86LA188Accident · Minor injuriesLimited investigationFinal reportHughes 269 · Kahului, HIA Hughes 269 went out of control after turning left into a 20 kt tailwind condition. The plt indicated that the engine failed. The eng was run on a eng test stand and no deficientcies were found. A fuel sample was found to be within specified parameters. Ac…NTSB LAX86FJA01Accident · No injuriesFinal reportSchweizer 2-32 · Dillingham Fld, HIThe glider collided with a power line as the plt maneuvered down a valley to recover some airspeed that had been lost along a ridgeline. The vertical fin and rudder were damaged along the top 18 inches but the acft was landed without further incident.NTSB LAX86LA158Accident · 1 fatalLimited investigationFinal reportCessna 150L · Kailua Kona, HIGround witnesses observed the acft spiral into the pacific ocean. Neither the plt nor the acft have been recovered.NTSB LAX86LAMS1Accident · 1 fatalFinal reportCessna U206C · Maunaloa, HIWhile on an inter-island cargo flight conducted under 14 CFR 135, the pilot reported to the honolulu ARTCC that the airplane was experiencing a loss of propeller RPM; he did not report that the engine was losing power. The airplane crashed into the pacific…NTSB LAX86LA139Accident · No injuriesLimited investigationFinal reportCessna A150K · Hanakuli, HIThe acft was ditched in pacific ocean after the eng quit. Recovered inboard portion of left wing showed gas tank cap missing. The ditching occurred 1 mile from shore and the occupants were picked up unharmed after 20 minutes in the water. The plt said the eng…NTSB CHI86FA096Accident · Serious injuriesField investigationFinal reportBoeing 747-122 · Honolulu, HIThe scheduled passenger flight from Honolulu to chicago encountered clear air turbulence (cat) about 500 NM east of Honolulu while in cruise flight at flight level 330. The turbulence was unexpected, had not been forecast, and the fasten seat belt was not…NTSB LAX86LA119Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Kalaupapa, HIThe acft crashed off the end of rwy 23 during an attempted go-around after touchdown. The plt stated that after the acft touched down aprx 300 ft down the 2,760 foot rwy he raised the flaps along with the nose of the acft to slow down. Brakes were applied and…NTSB LAX86LA091Accident · Minor injuriesLimited investigationFinal reportBell 206B-3 · Waimea, HIWhile on a local flt, the plt descended to aprx 500 ft AGL and flew the helicopter along a coastal area. He reported the helicopter suddenly lost power and he initiated an autorotative landing to the beach where the helicopter 'had a hard landing.' An exam…NTSB LAX86LA090Accident · No injuriesLimited investigationFinal reportCessna 402B · Kalaupapa, HIThe plt said that when he departed rwy 5, the acft 'became airborne prematurely due to a hump and rough nature of the runway.' He further said that 'after wallowing monentarily behind the power curve,' the acft began a normal climb and acceleration profile.…NTSB LAX86LA078Accident · 1 fatalLimited investigationFinal reportCessna R172K · Kamuela, HIThe acft collided with terrain while maneuvering to aviod clouds during a local scenic flt. The plt stated that turbulence caused loss of control and the acft was blown into trees. The winds were from 050 degs at 37 KTS with gusts to 45 KTS. SIGMET oscar five…