NTSB investigations, 2023, 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, 2023, 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\") = 2023
    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 ANC24LA011Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Kahului, HIA partial loss of engine power due to the formation of carburetor ice, which resulted in the inability to maintain altitude in the traffic pattern. Contributing to the outcome was the pilot’s delayed use of carburetor heat in conditions conducive to the…Dec 23, 2023 · N53725 · Substantial damageNTSB ANC24LA010Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kapolei, HIThe first pilot’s failure to maintain a stabilized approach, in gusty crosswind conditions, in an environment favoring wake turbulence.Dec 12, 2023 · N172CN · Substantial damageNTSB ANC24LA005Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Kapolei, HIA partial loss of engine power due to lose baffling from the muffler, which resulted in an obstruction of the exhaust system.Dec 4, 2023 · N691YW · Substantial damageNTSB DCA24LA034Incident · Minor injuriesClass 3 · LimitedFinal reportBoeing 717 · Kahului, HIThe captain did not verify that the tow tractor had exited the area in front of the airplane before taxiing for departure. Contributing factors were the dark conditions and the absence of an illuminated hazard beacon on the tow tractor, which reduced its…Nov 30, 2023 · N494HA · Minor damageNTSB ANC23LA038Accident · No injuriesClass 4 · LimitedFinal reportAerospatiale AS350B2 · Honolulu, HIThe instructor pilot’s inadequate supervision of the pilot receiving instruction, which resulted in a hard landing, and substantial damage to the tail boom.May 22, 2023 · N745RH · Substantial damageNTSB ANC23LA023Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P337H · Kona, HIThe failure of the pilot to recognize that the rear engine was not operating during takeoff, which resulted in an attempted single-engine takeoff and the airplane’s subsequent descent and impact with terrain. Contributing to the accident was a loss of rear…Feb 14, 2023 · N5KR · Substantial damageNTSB DCA23LA133Incident · No injuriesClass 3 · LimitedFinal reportBoeing 777-222 · Honolulu, HIThe airport’s continued use of taxiway Kilo, despite an identified risk of pilots repeatedly failing to stop at a hold short line prior to two intersecting runways. Contributing were 1) the operator’s moving map display, which omitted a published restriction…Jan 24, 2023 · N774UA · 2 aircraft · No damageNTSB ANC23LA012Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 208B · Kualapuu, HIThe pilot’s failure to maintain adequate altitude during a circling approach procedure in dark night visual meteorological conditions, which resulted in a collision with terrain.Jan 16, 2023 · N236KA · Substantial damage