NTSB investigations, 2022, 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\") = 2022
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") = 2022 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 DCA23LA172Incident · No injuriesClass 4 · LimitedFinal reportBoeing 777 · Kahului, HIThe flight crew’s failure to manage the airplane’s vertical flightpath, airspeed, and pitch attitude following a miscommunication about the captain’s desired flap setting during the initial climb.NTSB DCA23LA096Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus A330-243 · Kahului, HIThe flight crew’s decision to fly over an observed storm cell instead of deviating around it despite sufficient meteorological information indicating the potential for severe convective activity.NTSB ANC23LA009Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 77 · Lihue, HIThe airplane’s exceedance of its critical angle of attack after encountering a downdraft during departure, which resulted in an aerodynamic stall and impact with terrain.NTSB ANC23FA008Accident · 3 fatalClass 3 · FieldFinal reportRaytheon C90A · Kaupo, HIGuardian Flight’s inadequate pilot training and performance tracking, which failed to identify and correct the pilot’s consistent lack of skill, and which resulted in the pilot’s inability to maintain his position inflight using secondary instruments to…NTSB WPR23LA061Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter EC 130 B4 · Waimea, HIThe pilot's loss of helicopter control on approach to land due to entering a vortex ring state condition, which resulted in a hard landing.NTSB WPR23LA043Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Kapolei, HIThe pilot receiving instruction’s rapid reduction in throttle during hover autorotation training which resulted in a loss of control and collision with the ground.NTSB ANC23FA003Accident · 2 fatalClass 3 · FieldFinal reportAirborne Windsports Edge XT-912L · Mokuleia, HIStructural failure of the wing for undetermined reasons, which resulted in a loss of control.NTSB CEN22LA382Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Kahului, HIThe pilot’s inadequate compensation for gusting winds while maneuvering on the ground.NTSB ANC22LA046Accident · No injuriesClass 4 · LimitedFinal reportRockwell International 114 · Kailua-Kona, HIThe failure of the hydraulic power supply’s electric motor due to wear, which resulted in the left main landing gear and nose gear not fully extending and locking into place during landing. Contributing to the accident was the pilot's failure to adequately…NTSB ANC22FA041Accident · Serious injuriesClass 3 · FieldFinal reportBell 407 · Kalea, HIThe in-flight separation of the tail boom as a result of abnormal loading and fracture of the upper-left tail boom attachment bolt due to a gap between the upper-left longeron and aft fuselage bulkhead.NTSB ANC22LA025Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172P · Kekaha, HIThe pilot’s improper decision to continue the visual-flight-rules flight into low visibility conditions, which resulted in controlled flight into terrain.NTSB ANC22FA018Accident · 4 fatalClass 3 · FieldFinal reportSikorsky S-61N · Kekaha, HIThe improper installation of the fore/aft primary servo by maintenance personnel, which resulted in the attaching hardware backing out and which subsequently rendered the helicopter uncontrollable. Contributing to the accident was the company’s quality…NTSB ANC22LA012Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Hana, HIThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and subsequent impact with terrain.