NTSB investigations, 2001, HI
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 | 4 |
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\") = 2001
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") = 2001 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 LAX02LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Honolulu, HIFuel exhaustion due to the pilot's inadequate preflight inspection and improper in-flight decision and planning.NTSB LAX02LA039Accident · No injuriesLimited investigationFinal reportBell 206 B-2 · Aieia, HIThe pilot's loss of lateral control while in a hover that resulted in a rollover and collision with the ground. A factor was the unclear exit and boarding procedures provided to the work crew, who were non-aviators, during the preflight briefing.NTSB LAX02LA010Accident · 1 fatalLimited investigationFinal reportRhoades Jodel D-9 · Waialua, HILoss of engine power for unknown reasons. A factor was the inadvertent stall the pilot encountered while maneuvering to make a forced landing in an open taro field.NTSB LAX02LA007Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kahoolawe Isle, HIInadequate visual surveillance by the pilot before takeoff resulting in liftoff with a deplaning passenger still partially aboard the helicopter. A factor in the accident was the operator's inadequate procedures.NTSB LAX01FA306Accident · Minor injuriesField investigationFinal reportBell 206B · Hilo, HIThe failure of the mechanic to secure the No. 8 bearing thrust nut during maintenance work, which resulted in the total failure of the first stage turbine wheel shaft. Also causal was his misjudgment of his height during the flare resulting in a hard landing.…NTSB LAX01FA208Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Lanai City, HIthe CFI's inadequate in-flight planning/decision making, inadequate supervision, and his delayed remedial action, which resulted in controlled flight into terrain.NTSB LAX01FA200Accident · No injuriesField investigationFinal reportHughes 369D · Hanapepe, HIa loss of engine power while in cruise flight resulting from the failure and liberation of several turbine blades due to hot corrosion effects which weakened the blades. The hot corrosion damage was the result of multiple turbine over temperature events which…NTSB LAX01LA181Accident · No injuriesLimited investigationFinal reportCessna 337C · Paauilo, HIA dual loss of engine power for undetermined reasons.NTSB LAX01FA127Accident · No injuriesField investigationFinal reportAgusta A109A · Hanapepe, Kauai, HIthe pilot's misjudged flare during an autorotation, which resulted in a hard landing. A contributing factor was the check airman's failure to demonstrate a stuck pedal maneuver prior to assigning the procedure to the pilot.NTSB DCA01WA027Incident · No injuriesForeign investigationLockheed L1011 · Honolulu, HINTSB LAX01LA083Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Lihue, HIThe manufacturer's inadequate collective lock design, which resulted in the collective unlocking during a preflight check and subsequent unintentional liftoff and loss of helicopter control. The pilot's loss of control was due in part to the unavailability of…NTSB LAX01IA073Incident · No injuriesIncident investigationFinal reportBoeing 747-200F · Honolulu, HIthe failure of the lighting dimmer switch or circuit components for undetermined reasons, which resulted in smoke in the cockpit.