NTSB investigations, 2024, UT

6 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2024, UT per year, 2008–2026: 190 cases
200819
200914
201014
201112
201212
20139
201410
201515
20169
20178
201811
201917
20206
20214
20225
202311
20246
20254
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\") = 2024
    AND c.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 WPR25LA006Accident · Minor injuriesClass 4 · LimitedFinal reportAgustawestland AW109SP · Kamas, UTThe pilot’s exceedance of the helicopter’s available power while landing in a confined area, which resulted in a loss of tail rotor effectiveness and a hard landing.Oct 8, 2024 · N631HC · Substantial damageNTSB ANC24LA071Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Huntsville, UTThe pilot's failure to navigate in hazy conditions, which resulted in a forced landing in a field and a collision with a pole.Jul 29, 2024 · N8485W · Substantial damageNTSB WPR24FA227Accident · 1 fatalClass 3 · FieldFinal reportFantasy Air Sro Allegro 2007 · Eureka, UTThe pilot’s failure to maintain airplane control during initial climb, which resulted in an in-flight upset and impact with terrain.Jul 7, 2024 · N969RC · Substantial damageNTSB WPR24LA164Accident · No injuriesClass 4 · LimitedFinal reportBoeing-Stearman PT-17 · Heber City, UTThe pilot’s failure to maintain directional control during the landing roll.May 27, 2024 · N7995 · Substantial damageNTSB WPR24LA143Accident · Minor injuriesClass 4 · LimitedFinal reportThatcher CX4 · Rowley, UTThe pilot’s failure to maintain directional control during the takeoff roll.Apr 30, 2024 · N440BS · Substantial damageNTSB WPR24LA088Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32R-301T · Spanish Fork, UTThe pilot's failure to ensure proper placement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.Feb 10, 2024 · N989SR · Substantial damage