NTSB investigations, 1999, 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\") = 1999
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") = 1999 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 LAX00LA039Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Hilo, HIAn oil starvation induced failure and seizure of the engine. The reasons for the oil starvation event are undetermined.NTSB LAX00FA041Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-30F · Honolulu, HIThe pilot-in-command initiated an evasive manuver during a near midair collission. The airplane entered a prestall buffet, which resulted in buckling of the elevator skins.NTSB LAX00LA009Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waialua, HIThe pilot's delay in recognizing the onset of a wind direction change resulting in the downward flow of wind on the leeward side of the mountain (strong sink rate).NTSB DCA99MA088Accident · 10 fatalMajor investigationFinal reportPiper PA-31-350 · Volcano, HIthe pilot's decision to continue visual flight into instrument meteorological conditions (IMC) in an area of cloud-covered mountainous terrain. Contributing to the accident were the pilot's failure to properly navigate and his disregard for standard operating…NTSB LAX99LA282Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Kahului, HIThe pilot's initial misjudgment of the wind speed and his decision to continue a downwind landing approach when his speed and altitude profile was inadequate, and his failure to maintain main rotor rpm, resulting in settling with power and a hard landing.NTSB LAX99LA263Accident · Serious injuriesLimited investigationFinal reportPartenavia P68C · Kaunakakai, HIThe prospective passenger's intentional act of bypassing proscribed airport procedures for boarding aircraft. A factor was the failure of another operator's ground personnel to comply with ramp access restrictions.NTSB LAX99FA242Accident · 1 fatalField investigationFinal reportBeech 58 · Hilo, HIThe pilot's improper fuel system modifications resulting in inadequate fuel flow to the left engine during a critical phase of flight. Factors in the accident were the operation at an over gross weight condition with a CG more than 2 inches aft of the rear…NTSB LAX99LA238Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe airplane's encounter with turbulent air from the rotor wash of a large military helicopter, which resulted from the instructor's decision to continue the approach while the helicopter was on the runway.NTSB LAX99LA232Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Wailua, HIThe failure of the pilot to adequately compensate for the existing gusty wind conditions and his improper recovery from a bounced landing.NTSB LAX99LA226Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Kaunakakai, HIThe pilot encountered a dust devil during the takeoff transition from a dirt and grass area resulting in a loss of vision, disorientation, and subsequent collision with trees.NTSB LAX99LA190Accident · 1 fatalLimited investigationFinal reportBeech B90 · Mokuleia, HIThe pilot's incapacitation due to the effects of hypoxia from repeated flights to altitudes above 18,000 feet msl without supplemental oxygen.NTSB LAX99LA124Accident · No injuriesLimited investigationFinal reportBeech D95A · Dillingham, HIThe student's failure to maintain aircraft control in the gusty crosswind conditions due to limited left yaw authority induced by the simulated single engine approach. The flight instructor's inadequate supervision of the flight and his failure to terminate…