NTSB investigations, 2006, 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
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\") = 2006
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") = 2006 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 LAX07LA002Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Hilo, HIInadvertent application of the lateral cyclic friction, which resulted in a loss of control and subsequent hard landing.NTSB LAX06TA259Accident · No injuriesFinal reportHughes 369D · Lahaina, HIthe pilot's failure to shut down the engine prior to exiting the helicopter resulting in the tail rotor contacting the ground. A contributing factor was the gusting wind conditions present at the accident site.NTSB LAX06LA246Accident · 2 fatalLimited investigationFinal reportCessna 177B · Kalaupapa, HILoss of aircraft control during cruise flight for undetermined reasons. Clouds, rain, and dark night conditions were factors.NTSB LAX06LA236Accident · Serious injuriesLimited investigationFinal reportHammack Air Command Elite · Hilo, HIan in-flight separation of a control rod joint assembly, which resulted in the pilot's loss of control. The underlying reason for the separation could not be determined.NTSB LAX06CA227Accident · No injuriesData collectionFinal reportHughes 369D · Kihei, HIthe pilot's failure to maintain an adequate clearance from obstructions, which led to a main rotor blade strike.NTSB LAX06CA184Accident · Minor injuriesData collectionFinal reportRobinson R44 · Wailuku, HIthe pilot's inadequate compensation for the existing gusty wind conditions that resulted in his failure to maintain proper alignment with the landing area.NTSB LAX06LA155Accident · Serious injuriesLimited investigationFinal reportPartenavia P68 · Kaunakakai, HIthe pilot's failure to attain a proper climb rate and to maintain adequate clearance from the terrain during the initial climb in dark night conditions, which resulted in an in-flight collision with terrain.NTSB LAX06CA150Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe pilot's misjudged flare resulting in a hard landing and a porpoise pilot induced oscillation.NTSB ANC06LA028Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Kailua-Kona, HIThe flight instructor's delayed remedial action while conducting hover practice with a student pilot, which resulted in the helicopter contacting the ground and rolling over. A factor contributing to the accident was an inadvertent dynamic roll over.NTSB LAX06FA126Accident · 3 fatalField investigationFinal reportCessna 414A · Kahului, HIThe failure of the pilot to execute the published emergency procedures pertaining to configuring the airplane for single engine flight, which would have allowed him to maintain minimum controllable airspeed (Vmc) and level flight. The pilot's failure to…NTSB LAX06LA098Accident · No injuriesLimited investigationFinal reportEurocopter AS350D · Kahului, HIA total loss of engine power due to the internal effects on the bearings consistent with an operating event of insufficient oil supply. Contributing to the accident was the pilot’s improper flare during the autorotative descent.NTSB LAX06LA072Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350BA · Hana, HIThe total loss of engine power due to a fatigue failure of a turbine blade. A factor in the accident was the lack of a suitable forced landing site.NTSB LAX06FA080Accident · No injuriesField investigationFinal reportEurocopter EC 130B4 · Lahaina, HIAn intermittent electrical continuity failure and short of the DECU-XPC wiring harness, which resulted in an uncommanded and an initially undetected engine deceleration and a resulting loss of main rotor rpm. Also causal was the manufacturer's inadequate…