NTSB investigations, UT

7 cases where NTSB found Total experience w/ equipment.

Cases per year

20102026
NTSB investigations, UT per year, 2010–2026: 7 cases
20101
20111
20121
20171
20181
20191
20221

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 c.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02031025'))
  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 WPR22FA227Accident · 2 fatalClass 3 · FieldFinal reportCessna 152 · Mendon, UTThe flight instructor’s failure to recover from a developed spin, which resulted in impact with terrain. Contributing to the accident was the flight instructor’s decision to enter the maneuver below the operator’s altitude limitation.Jun 24, 2022 · N934JH · Substantial damageNTSB GAA19CA359Accident · Minor injuriesData collectionFinal reportAutogyro Cavalon · Nephi, UTThe pilot's insufficient rudder input during takeoff, which resulted in a loss of yaw control and a hard landing.Jun 19, 2019 · N882M · Substantial damageNTSB WPR18LA217Accident · 1 fatalLimited investigationFinal reportSmith Hornet · St. George, UTThe pilot's loss of airplane control during takeoff due to an unexpected gust of wind.Aug 11, 2018 · N218B · Substantial damageNTSB WPR17LA098Accident · Serious injuriesLimited investigationFinal reportRobert E Bounds Bounds Bearcoupe · Hanksville, UTThe flight instructor's failure to maintain airplane control during landing when he inadvertently applied brake pressure to the toe brakes when the airplane touched down.May 5, 2017 · N136BC · Substantial damageNTSB WPR12FA235Accident · 4 fatalField investigationFinal reportCirrus SR20 · Duck Creek Village, UTThe pilot's failure to maintain sufficient airspeed and airplane control while maneuvering a heavily loaded airplane over high mountainous terrain in a high density altitude environment. Contributing to the accident was the pilot’s lack of experience…May 29, 2012 · N187PG · Substantial damageNTSB WPR11LA151Accident · No injuriesLimited investigationFinal reportBell 206B-III · Tooele, UTThe pilot did not maintain yaw control of the helicopter during a maneuvering hover. Contributing to the accident was the pilot’s lack of experience in the make and model helicopter.Mar 1, 2011 · N206BY · Substantial damageNTSB WPR10FA315Accident · 1 fatalField investigationFinal reportAero Commander CallAir · Salt Lake City, UTThe pilot’s failure to maintain airspeed, which resulted in a stall/spin to the ground.Jun 26, 2010 · N7700V · Substantial damage