NTSB investigations, 2007, 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
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\") = 2007
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") = 2007 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 SEA08LA051Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A330-323 · Honolulu, HIThe failure of the two flight attendants in the aft galley to understand the lead flight attendant's instructions, which resulted in them not being seated when the flight encountered convectively induced severe turbulence. Contributing to the accident was the…NTSB LAX07LA253Accident · No injuriesLimited investigationFinal reportEdra Aeronautica Seastar · Kapolei, HIA loss of engine power due to fuel starvation that resulted from the pilot's inadequate preflight planning/preparation and failure to ensure that an adequate fuel supply was onboard the aircraft.NTSB SEA07CA161Accident · No injuriesData collectionFinal reportCessna 150J · Honolulu, HIThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for a forced landing.NTSB LAX07CA176Accident · No injuriesData collectionFinal reportI.C.A.-Brasov IS-28B2 · Mokuleia, HIthe pilot's inadequate compensation for the gusting tailwind conditions and failure to maintain directional control. The failure of the tow rope during takeoff was also causal.NTSB SEA07LA110Accident · Minor injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Makawao, HIThe pilot's improper decision to takeoff downwind in a confined landing zone, which resulted in a failure to attain translational lift and a loss of control.NTSB SEA07LA108Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Kahuku, HIFatigue cracking of the oil line from the engine gearbox to the oil pressure gauge, which resulted in loss of engine lubricating oil, leading to seizure of the power turbine.NTSB LAX07IA115Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 BA · Kahului, HIThe loss of tail rotor control due to wear damage to the pitch control input rod that resulted ultimately in the fatigue failure of the upper support yoke arm. Contributing factors were the improper maintenance inspection of the expansion pin assembly and the…NTSB CHI07MA083Accident · 1 fatalMajor investigationFinal reportMcDonnell Douglas 369FF · Haena, HIThe fatigue failure of the tail rotor blade root fitting due to a manufacturing defect which resulted in the separation of the tail rotor system and loss of tail rotor control. A contributing factor to the accident were the trees that the helicopter struck…NTSB NYC07MA073Accident · 4 fatalMajor investigationFinal reportAerospatiale AS350BA · Princeville, HIThe failure of maintenance personnel to properly tighten (torque) the flight control servo lower attachment clevis, and reinstall a functioning lock washer, which resulted in a flight control disconnect and a complete loss of helicopter control. Contributing…NTSB LAX07CA077Accident · Serious injuriesData collectionFinal reportBombardier DHC-8-103 · Kaunakakai, HIan in-flight encounter with clear air turbulence, which resulted in a serious injury to a deadheading crewmember.