NTSB investigations, 2004, HI

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 2004, 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\") = 2004
    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 LAX05LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Waialua, HIthe pilot misjudged distance and altitude and failed to attain the proper landing touchdown point.Dec 23, 2004 · N2751Z · Substantial damageNTSB LAX05CA047Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Kapolei, HIthe pilot's failure to maintain directional control, which resulted in a collision with an obstacle.Dec 8, 2004 · N140ND · Substantial damageNTSB LAX05FA011Accident · 1 fatalField investigationFinal reportCessna 310K · Kula, HIThe failure of the pilot to maintain adequate clearance from mountainous terrain during cruise flight. A factor in the accident was the dark night lighting conditions.Oct 18, 2004 · N7049L · DestroyedNTSB LAX04FA329Accident · 5 fatalClass 1 · FieldFinal reportBell 206B · Kalaheo, HIThe pilot's decision to continue flight under visual flight rules into an area of turbulent, reduced visibility weather conditions, which resulted in the pilot's spatial disorientation and loss of control of the helicopter. Contributing to this accident was…Sep 25, 2004 · N16849 · DestroyedNTSB LAX04CA321Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kona, HIthe CFI's failure to maintain an adequate airspeed and main rotor rpm, and his improper flare, which resulted in a hard landing. A factor in the accident was the CFI's diverted attention.Sep 18, 2004 · N22XM · Substantial damageNTSB LAX04CA315Accident · Minor injuriesData collectionFinal reportBell 206B · Kahului, HIthe pilot's inadequate compensation for the gusty crosswind conditions, which resulted in a dynamic rollover. Contributing factors were the direct crosswind and his lack of total experience in the accident helicopter make and model.Aug 16, 2004 · N529RS · Substantial damageNTSB LAX04CA290Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe student pilot's misjudged flare, which resulted in a hard landing. Also causal was the student pilot's improper recovery from a bounced landing and pilot induced porpoise and failure to maintain directional control on the landing roll, which resulted in…Aug 13, 2004 · N3554Y · Substantial damageNTSB LAX04CA268Accident · No injuriesData collectionFinal reportMcDonnell Douglas 369FF · Lihue, HIThe pilot misjudging the clearance between the tree and the main rotor blades. Contributing factors to the accident were the high workload of the pilot and his lack of experience with bambi bucket operations.Jul 16, 2004 · N530RL · Substantial damageNTSB LAX04LA256Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350 B2 · Hilo, HIthe pilot's inadequate planning/decision by his VFR flight into IMC, and his failure to maintain obstacle clearance which resulted in an in-flight collision with a tree. A low ceiling and fog were contributing factors.Jul 8, 2004 · N196BH · Substantial damageNTSB ANC04IA046Incident · Minor injuriesIncident investigationFinal reportCessna 208 · Kalaupapa, HIAn in-flight encounter with turbulence during cruise flight, which resulted in a minor injury to a passenger. On February 7, 2006, this occurrence was reclassified from an accident to an incident and this narrative was modified.Apr 21, 2004 · N302PW · No damageNTSB LAX04FA190Accident · Serious injuriesField investigationFinal reportPiper PA 28-161 · Holoaloa, HIThe pilot's continued flight into adverse weather conditions that resulted in an in-flight collision with mountainous terrain. Factors in the accident were rising terrain, low clouds and rain, and the pilot's lack of familiarity with the geographic area.Apr 19, 2004 · N8198A · DestroyedNTSB LAX04LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-31 · Kahului, HIthe pilot's failure to maintain an adequate airspeed while maneuvering for landing on one engine, which resulted in an inadvertent stall. The loss of power in one engine for undetermined reasons was a factor.Feb 18, 2004 · C-GPTE · Substantial damageNTSB LAX04CA136Accident · No injuriesData collectionFinal reportCessna 177A · Honolulu, HIthe pilot's misjudged landing flare, which resulted in a hard landing and porpoising down the runway.Feb 16, 2004 · N30599 · Substantial damageNTSB LAX04FA113Accident · 3 fatalField investigationFinal reportCessna 414A · Laupahoehoe, HIthe pilot's disregard for an in-flight weather advisory, his likely encounter with marginal VFR or IMC weather conditions, his decision to continue flight into those conditions, and failure to maintain an adequate terrain clearance altitude resulting in an…Jan 31, 2004 · N5637C · DestroyedNTSB LAX04LA101Accident · No injuriesLimited investigationFinal reportScott RV-8A · Lihue, HIthe engine lost partial power for undetermined reasons.Jan 18, 2004 · N809RS · Destroyed