NTSB investigations, 2012, UT

6 cases where the defining event was Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2012, UT per year, 2008–2026: 63 cases
20084
20093
20104
20118
20126
20132
20144
20153
20162
20172
20183
20192
20202
20215
20223
20234
20243
20251
20262

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\") = 2012
    AND c.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240')
  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 WPR12LA413Accident · Serious injuriesLimited investigationFinal reportEllefson T-BIRD II · Richfield, UTA loss of control during landing due to a pitch control malfunction. Contributing to the accident was the pilot’s decision to continue flight with a known mechanical problem.Sep 5, 2012 · N8106C · Substantial damageNTSB WPR12FA378Accident · 2 fatalField investigationFinal reportAircraft Mfg & Development CH 2000 · Nephi, UTThe pilot's inability to maintain airplane control due to an encounter with a microburst/downdraft that exceeded the climb performance capabilities of the airplane.Aug 30, 2012 · N651AM · Substantial damageNTSB WPR12LA214Accident · Serious injuriesLimited investigationFinal reportMarley Kolb Firestar II · Cedar Fort, UTThe pilot's failure to maintain airplane control while on approach for landing in gusting wind conditions.May 17, 2012 · N9173T · Substantial damageNTSB WPR12LA205Accident · Serious injuriesLimited investigationFinal reportInfinity 2000 · Hurricane, UTThe pilot's decision to fly at a low altitude in a canyon, which resulted in insufficient altitude to recover from an encounter with terrain-induced turbulence.May 11, 2012 · N541KP · Substantial damageNTSB WPR12LA198Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Hanksville, UTThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude in high density altitude conditions, which resulted in the airplane’s inability to climb or maintain clearance from terrain.May 8, 2012 · N28WF · Substantial damageNTSB WPR12FA184Accident · 3 fatalField investigationFinal reportCessna A185F · Blanding, UTThe pilot's failure to maintain airplane control during low-level maneuvering flight. Contributing to the pilot’s death was the lack of a timely emergency rescue response due to the lack of effective emergency signal transmissions from both the airplane’s…Apr 25, 2012 · N243W · Substantial damage