NTSB investigations, 1993, 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, 1993, 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\") = 1993
    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 LAX94LA076Accident · No injuriesLimited investigationFinal reportHughes 369D · Waimea, Kauai, HIAn inadequate engine compressor cleaning procedure specified in the manufacturer's service letter, which resulted in the total loss of engine power due to contamination, blockage, and collapse of the fuel nozzle inlet screen. Factors in the accident were: the…Dec 22, 1993 · N115HD · Substantial damageNTSB LAX94LA027Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Mokuleia, HIthe student pilot's misjudgement of descent rate and terrain clearance while manuevering along a ridgeline. Factors in the accident were the downdrafts and the mountainous/hilly nature of the terrain.Oct 28, 1993 · N7779S · Substantial damageNTSB LAX94LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Hilo, HIthe failure of the right engine's magnetos for undetermined reasons and the resulting overtemperature of the remaining left engine.Oct 14, 1993 · N7079J · DestroyedNTSB LAX93LA371Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Kepuhi Molokai, HIA loss of main rotor RPM for undetermined reasons.Sep 30, 1993 · N150CA · DestroyedNTSB LAX93FA318Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Honolulu, HIA divergence of the main rotor from its normal plane of rotation for an undetermined reason(s) which resulted in rotor contact with the airframe.Aug 11, 1993 · N4017J · DestroyedNTSB LAX93FA281Accident · 1 fatalField investigationFinal reportRobinson R22B · Honolulu, HIThe instructor allowing the student fly solo in wind conditions exceeding the maximum allowable winds in the training syllabus, and also near the maximum demonstrated controllability envelope for the helicopter. Factors which contributed to the accident were…Jul 8, 1993 · N501R · DestroyedNTSB LAX93LA249Accident · No injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe failure of the pilot to maintain adequate ground obstruction clearance while engaged in a cattle herding operation.Jun 11, 1993 · N1113L · Substantial damageNTSB LAX93LA132Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe pilots failure to maintain an adequate visual lookout for obstructions while performing a low altitude surveillance operation in a mountainous area, and, his failure to select an altitude sufficient to ensure clearance from all potential obstacles.Feb 22, 1993 · N58240 · Substantial damageNTSB LAX93LA104Accident · 4 fatalLimited investigationFinal reportFairchild Hiller FH-1100 · Volcano Natl Pk, HIA loss of tail rotor control for an undetermined reason(s). A factor which contributed to the accident was the pilot's choice of a hover altitude/position inadequate to reach a shoreline in the event of an emergency. A factor which contributed to the severity…Jan 25, 1993 · N427FH · Destroyed