NTSB investigations, 2016, HI

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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

19632026
NTSB investigations, 2016, HI per year, 1963–2026: 870 cases
19632
196416
196518
196622
196729
196819
196920
197012
197121
197219
197324
197417
197513
197619
197720
197818
197917
198023
198117
198213
198311
198413
198519
198620
198726
198812
198915
199011
199118
199217
19939
199418
199512
199612
199714
19987
199912
200015
200112
20023
200314
200415
200516
200613
200710
200811
200910
20106
20117
201210
201310
201410
20156
201614
20178
201812
201910
20206
20215
202213
20238
202411
20256
20264

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\") = 2016
    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.

NTSB WPR17FAMS2Accident · 3 fatalMissing aircraftFinal reportCessna 172M · Open water, HIUndetermined because the airplane was not located.Dec 31, 2016 · N174LL · DestroyedNTSB GAA17CA094Accident · No injuriesData collectionFinal reportSchauer William A JR Starduster TOO SA300 · Kapolei, HIThe pilot's failure to maintain directional control during the landing roll.Dec 8, 2016 · N2822T · Substantial damageNTSB WPR17FA021Accident · 2 fatalField investigationFinal reportHughes 369 · Pukoo, HIThe pilot's decision to continue visual flight into an area of instrument meteorological conditions at night in rain, which resulted in his geographic disorientation and controlled flight into terrain.Nov 16, 2016 · N81GG · DestroyedNTSB GAA17CA025Accident · No injuriesData collectionFinal reportCessna 172 · Kapolei, HIThe pilot’s use of an excessive pitch attitude during the landing flare, which resulted in a bounced landing.Oct 5, 2016 · N429ES · Substantial damageNTSB WPR17LA005Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Waimea, HIImpact of the lift cable after it exited the helicopter during liftoff with the main rotor (MR) blades, which resulted in the separation of an MR blade tip and the vertical vibration of the helicopter.Oct 4, 2016 · N311VT · Substantial damageNTSB WPR16LA175Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Honolulu, HIThe pilot's failure to maintain helicopter control in gusting wind conditions, which resulted in the helicopter rescue net’s contact with a utility pole and serious injury to an occupant who fell from the rescue net. Contributing to the accident was the…Sep 2, 2016 · N5232G · No damageNTSB WPR16LA168Accident · No injuriesLimited investigationFinal reportRobinson R44 · Kailua/Kona, HIAn on-ground upset for reasons that could not be determined because postaccident examination of the helicopter revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.Aug 26, 2016 · N74805 · Substantial damageNTSB WPR16LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA 23-150 · Kona, HIThe total loss of power in both engines during cruise flight for reasons that could not be determined because the airplane was not recovered from the ocean.Jul 15, 2016 · N3180P · DestroyedNTSB GAA16CA472Accident · No injuriesData collectionFinal reportCessna 172 · Kahului, HIThe pilot's incorrect pitch control during the landing flare, which resulted in a porpoise and hard landing.Jul 10, 2016 · N335SP · Substantial damageNTSB WPR16LA119Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Waianae, HIThe total loss of engine power during cruise flight due to carburetor icing. Contributing to the accident was the pilot’s delay in applying carburetor heat during flight while operating in an area conducive to carburetor icing.May 23, 2016 · N6697Y · Substantial damageNTSB WPR16FA116Accident · 5 fatalField investigationFinal reportCessna 182 · Hanapepe, HIThe pilot's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic…May 23, 2016 · N2007X · DestroyedNTSB OPS16IA009IncidentClass 3 · IncidentFinal reportCessna 172S · Honolulu, HIThe air traffic controller's decision to clear an aircraft to land on a runway occupied by another aircraft that had previously been instructed to line up and wait. Contributing to the runway incursion was the failure of the air traffic controller to visually…Feb 26, 2016 · N269ME · 2 aircraft · No damageNTSB WPR16FA072Accident · 1 fatalField investigationFinal reportBell 206B · Honolulu, HIThe in-flight failure of the engine-to-transmission drive shaft due to improper maintenance, which resulted in low main rotor rpm and a subsequent hard landing to water.Feb 18, 2016 · N80918 · Substantial damageNTSB WPR16FA055Accident · Serious injuriesField investigationFinal reportAirbus EC130 · Hanalei, HIThe fatigue failure of the engine fuel pipe as a result of vibration caused by a worn starter-generator front bearing support, which excited the fuel pipe and caused it to oscillate at a resonant frequency, and a subsequent loss of engine power due to fuel…Jan 18, 2016 · N11VQ · Substantial damage