NTSB investigations, 1997, HI
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1997
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") = 1997 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 LAX98LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lanai City, HIInterference on the controls by the passenger as the aircraft neared touchdown, and the pilot's failure to adequately brief and supervise the passenger on the use and relinquishing of the flight controls. A factor in the accident was the intentional control…NTSB LAX97LA322Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Hilo, HIfailure of the pilot to verify the quantity of fuel before departure, and to monitor fuel consumption during the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Tall grass in the emergency landing was a related factor.NTSB LAX97FA276Accident · Serious injuriesField investigationFinal reportLockheed L-1011-385-1-15 · Honolulu, HIthe cumulative distance taxied immediately prior to takeoff that precipitated an excessive heat buildup in the tires and resulted in the bead separation of a single tire during the takeoff roll. The absence of cockpit procedures/directives or monitoring…NTSB LAX97LA245Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Pahoa, HILoss of the propeller retaining nut and associated hardware for undetermined reasons. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB DCA97MA053Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11 · Honolulu, HIThe pilot's failure to apply adequate manual control inputs following his decision to disconnect the autopilot during the autoland operation, resulting in a subsequent loss of directional control. Also causal and contributing to the tail strike was the…NTSB LAX97LA204Accident · No injuriesLimited investigationFinal reportBell 204-B · Kaneohe, HIfailure of the pilot to verify that the load was properly rigged before attempting to pick it up. The uneven (sloping) terrain was a related factor.NTSB LAX97LA185Accident · 1 fatalLimited investigationFinal reportBell 206B · Hilo, HIthe noninstrument-rated pilot flew into instrument conditions and failed to maintain adequate terrain clearance, while attempting to descend through an overcast. The adverse weather conditions and mountainous terrain were related factors.NTSB LAX97LA176Accident · 2 fatalLimited investigationFinal reportHughes 369D · Puako, HIerosion of second stage stator vanes, inadequate maintenance inspection for the erosion, and subsequent fatigue failure of a stator vane, which resulted in loss of engine power and a forced landing on mountainous/hilly terrain. Also causal was: the pilot's…NTSB LAX97LA150Accident · 1 fatalLimited investigationFinal reportDuff MINI-500 · Lihue, Kauai, HIthe student pilot's improper use of the helicopter flight controls, which resulted in rotor contact with the tail boom and loss of control. Factors relating to the accident were: the pilot's lack of total and recent training and experience in airborne control…NTSB LAX97LA157Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Hilo, HIthe pilot's inadequate en route fuel consumption calculations, which led to his failure to recognize a deteriorating fuel duration versus time-to-go situation in a more timely way.NTSB LAX97LA139Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Mokuleia, HIAn unintentional stall for undetermined reasons.NTSB LAX97FA108Accident · Minor injuriesField investigationFinal reportBeech H18 · Honolulu, HIloss of aircraft control for undetermined reason(s).NTSB LAX97FA107Accident · Serious injuriesField investigationFinal reportHughes 369D · Milolii, HIfailure of the tail rotor for undetermined reason(s), resulting in tail rotor imbalance, separation of the tail rotor, and an autorotative landing on rough terrain with high vegetation. The lack of suitable terrain for a forced landing was a related factor.NTSB LAX97LA088Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Kamuela, HIfuel system contamination resulting in a partial loss of power, and the failure of the pilot to maintain adequate rotor rpm to cushion the autorotative landing and prevent main rotor blade contact with the tailboom. Factors were the inadequacy of…