NTSB investigations, 1987, 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

19632026
NTSB investigations, 1987, HI per year, 1963–2026: 871 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
20265

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\") = 1987
    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 LAX88LA077Accident · No injuriesLimited investigationFinal reportCessna 150E · Hilo, HIDuring a local pleasure flt, while climbing to 5500 feet, the engine sputtered and quit. During the landing roll, the acft nosed over. The engine was examined with no mechanical failures or malfunctions noted. The acft was operating in the range of serious…Dec 24, 1987 · N3009J · Substantial damageNTSB LAX88FA075Accident · 8 fatalField investigationFinal reportPiper PA-31-350 · Maunaloa, HIThe flight was to be flown across a 22 mile channel between islands on an overcast night with no moon and no ground reference lights. The aircraft disappeared from radar and, after extensive searches, could not be found. A three dimensional flight track was…Dec 24, 1987 · N712AN · DestroyedNTSB LAX88LA059Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Lihue, Kauai, HIPilot failure to maintain adequate main rotor RPM.Nov 26, 1987 · N77DJ · Substantial damageNTSB LAX88LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Honolulu, HIThe pilot estimated that the aircraft's reduced fuel quantity was adequate for the flight during his preflight inspection. As the aircraft descended for the traffic pattern near the destination airport both engines failed. After the loss of power the pilot…Nov 20, 1987 · N27512 · Substantial damageNTSB LAX88LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe pilot stated that the engine lost power while he was flying low over the ocean on a fish spotting flight. Subsequently, he ditched the aircraft in the ocean & it was not retrieved.Nov 17, 1987 · N2973V · DestroyedNTSB LAX88LA044Accident · No injuriesLimited investigationFinal reportBeech D18S · Mokuleia, HIThe plt rprtd that he had made a normal preflight, but after the acft had rolled about 200 to 250 ft on the takeoff roll, the nose gear collapsed. The acft came to rest with damage to the nose section, props & engs. Drg an inspn of the acft, the landing gear…Nov 15, 1987 · N802H · Substantial damageNTSB LAX88LA043Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIThe plt rprtd that during an external load operation, the helicopter ran out of fuel. Subsequently, it was damaged when it touched down hard during a forced landing.Nov 14, 1987 · N1113L · Substantial damageNTSB LAX87DJA09Accident · No injuriesFinal reportEmair MA-1-B · Paauilo, HIDuring an aerial application flt, just after take off, the plt noted that the engine oil temp was high and that blue smoke was coming from the engine. Unable to land at the airport, the acft collided with the terrain short of the runway and nosed over.…Sep 11, 1987 · N9924M · Substantial damageNTSB LAX87LA322Accident · No injuriesLimited investigationFinal reportGovernment Aircraft Fact Nomad 24A · Lanai, HIWhen the flt was aprx 15 mi west of Lanai on a cargo flt from honolulu to hilo, HI, the plt observed the fuel gauges oscillating erratically toward the low side. He diverted toward Lanai to refuel. However, when the flt was abt 9 mi westof Lanai, the left eng…Sep 2, 1987 · N37808 · Substantial damageNTSB LAX87LA310Accident · Minor injuriesLimited investigationFinal reportBell 206B · Kailua-Kona, HIAs the helicopter was climbing over rising terrain at 300' to 400' AGL, the plt noted altimeter & airspeed indcns of 8700' & 60 mph. After climbing an adnl 2 min to aprx 10,000' (12,000' density alt), he noticed the rotor RPM was bleeding off. He made a 180…Aug 23, 1987 · N2777R · Substantial damageNTSB LAX87DJA08Accident · No injuriesFinal reportEmair MA-1B · Pahala, HIDuring an aerial application operation, while taking off, the aircraft veered off the runway and came to rest nose down. Inspection of the landing gear revealed that the left main landing gear scissor bolt broke.Aug 13, 1987 · N9924M · Substantial damageNTSB LAX87DJA07Accident · No injuriesFinal reportEmair MA-1B · Pahala, HIAt the end of an aerial application flt, the plt reported that after approaching the arpt in a light rain, he failed to keep the acft centered on the rwy. The acft exited the rwy to the left where it collided with the terrain and nosed over. There were no…Jul 27, 1987 · N9919M · Substantial damageNTSB LAX87LA242Accident · No injuriesLimited investigationFinal reportCessna 310R · Kailua, HIA Cessna 310R ditched in the pacific ocean aprx 500 NM sw Hawaii after an eng failure. The plt indicated that the #2 eng failed while in cruise flt at 8,000 ft MSL. Oil was observed leaking from the eng cowling. The acft was unable to maintain alt on #1 eng.…Jun 22, 1987 · N98836 · DestroyedNTSB LAX87LA227Accident · No injuriesLimited investigationFinal reportCessna 150L · Huelo, HIDuring a local pleasure sightseeing flight, the engine lost power and eventually quit. The plt initiated an emergency landing in a pineapple field where the acft collided with the terrain and nosed over. The acft was found to have aprx half a gallon of fuel…Jun 6, 1987 · N10566 · Substantial damageNTSB LAX87LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe student and CFI landed at ford island and the CFI deplaned to observe the student perform solo landings. The studentexecuted one takeoff and landing without incident. On the second approach the student elected to make a go-around. He used full flaps for…May 14, 1987 · N704QH · Substantial damageNTSB LAX87LA195Accident · Serious injuriesLimited investigationFinal reportCessna 402A · Kahului, HIShortly after takeoff, the plt reqd an 'immediate downwind' to rtrn to the arpt & was clrd to land. When asked if equip-ment was needed, he replied, 'negative, sir, a little matter of fuel.' A witness said the acft appeared very low on final apch with both…Apr 29, 1987 · N4588Q · DestroyedNTSB LAX87LA189Accident · 4 fatalLimited investigationFinal reportCessna 172N · Lihue, HIThe pilot filled the aircraft's fuel tanks, loaded three air tour passengers and proceeded up a canyon that climbed up to an elevation of about 3000 feet MSL on a sightseeing flight. A ground tour bus driver observed smoke emanating from the canyon and…Apr 24, 1987 · N739RV · DestroyedNTSB LAX87DJA06Accident · Serious injuriesFinal reportSchweizer SGS2-33 · Mokuleia, HIDuring a local sightseeing flt along a ridge line, while maneuvering around a cloud build-up, the acft entered a windshear that suddenly nosed the acft over in an aprx 75 deg vertical dive. Just prior to colliding with trees, the plt was able to regain some…Apr 23, 1987 · N11468 · DestroyedNTSB LAX87LA178Accident · 1 fatalLimited investigationFinal reportBell 206B · Laupahoehoe, HIThe pilot of the Bell 206B and his three passengers arrived over a beached barge that they were to land on. The pilot hovered over the barge in a left quartering tailwind of about 10 knots and over a moderate sea with waves breaking against the barge. The two…Apr 15, 1987 · N370AH · DestroyedNTSB LAX87DJA05Accident · Serious injuriesFinal reportNihon YS-11A · Honolulu, HIDuring the takeoff ground run approaching V1/VR, the #1 engine fire warning light illuminated and the fire bell sounded. The takeoff was aborted and the acft was turned off the rwy onto a taxiway. The engines were shutdown and the captain ordered a right side…Apr 10, 1987 · N118MP · No damageNTSB LAX87LA161Accident · 1 fatalLimited investigationFinal reportBell 206B · Kona, HIThe pilot picked up two of the passengers at a resort hotel and then flew to kailua-Kona airport (koa). After hot refueling the helicopter with the two passengers on board, two more passengers boarded the helicopter and then the flight departed koa. When the…Mar 29, 1987 · N90153 · DestroyedNTSB LAX87LA137Accident · No injuriesLimited investigationFinal reportCessna 172C · Kahului, HIThe acft collided with trees while manuevering in mountainous terrain. The plt had planned a local flight from honolulu to maui and return. Once over the island of maui, the plt notified the fss that he was changing his route and would be passing through the…Mar 8, 1987 · N6353F · Substantial damageNTSB LAX87FA112Accident · 1 fatalField investigationFinal reportHughes 369D · Honolulu, HIDrg tkof clb, a loud noise occurred as 1 of 5 main rotors (mrb's) & the tail boom sepd fm the helicopter (hel). The hel then crashed & hit a submerged reef aprx 200' fm the heliport. An exam of the failed mrb showed its retention strap assy(rsa), pn…Feb 9, 1987 · N1102U · DestroyedNTSB LAX87DJA04Accident · 1 fatalFinal reportGlaser-Dirks DG-400 · Dillingham, HIThe aircraft was observed flying over a ridge at a 'good rate of airspeed'. It turned back towards the ridge and collided with the terrain. There was a SIGMET in effect for moderate to severe turbulence. Investigation revealed no preimpact mechanical…Feb 2, 1987 · N104MN · DestroyedNTSB LAX87DJA03Accident · Serious injuriesFinal reportEmroth Emair MA-1B · Naalehu, HIDuring an aerial application flight, the aircraft was observed to make a downwind run when the pilot dumped the load collided with the terrain, become airborne and eventually collided with trees. Witnesses stated that they heard the engine running and that it…Jan 20, 1987 · N88896 · DestroyedNTSB LAX87LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Lanai, HIThe Cessna 172K nosed over in strong winds while taxiing for departure on rwy 3. The plt indicated that he was 'back taxiing' on rwy 3 when the wind 'got under wing, then under tail, and plane turned upside down.' The plt also indicated that the winds were…Jan 12, 1987 · N7459 · Substantial damage