NTSB investigations, 2023, UT

10 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2023, UT per year, 2008–2026: 114 cases
200810
20098
20106
20116
20125
20132
20142
20156
20166
20175
20186
20197
20205
20215
20227
202310
20247
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\" = '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\" = '230' 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 WPR24LA026Accident · No injuriesClass 4 · LimitedFinal reportZlin Aviation Sro Savage · Fairfield, UTThe pilot’s failure to maintain airplane control during the landing, which resulted in a ground loop.Oct 13, 2023 · N866SA · Substantial damageNTSB WPR24LA016Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235C · Provo, UTThe pilot’s failure to maintain directional control during landing.Oct 12, 2023 · N235PR · Substantial damageNTSB WPR23LA358Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Salt Lake City, UTThe student pilot’s failure to maintain directional control during landing.Sep 27, 2023 · N190BM · Substantial damageNTSB WPR23LA353Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Monument Valley, UTThe pilot’s failure to maintain directional control after encountering a wind gust on the landing roll, which resulted in a ground loop.Sep 21, 2023 · N63130 · Substantial damageNTSB WPR23LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Moab, UTThe pilot’s loss of directional control during landing, which resulted in a ground loop.Aug 15, 2023 · N9977N · Substantial damageNTSB WPR23LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fremont Island, UTThe pilot undergoing instruction’s excessive application of asymmetrical braking during landing, which resulted in a ground loop.Jul 7, 2023 · N1664D · Substantial damageNTSB WPR23LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Nephi, UTA total loss of engine power due to fuel contamination as a result of the inadequate removal of fuel system corrosion during previous maintenance.Jun 8, 2023 · N7318Y · Substantial damageNTSB WPR23LA136Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Spanish Fork, UTThe retraction of the main landing gear for undetermined reasons.Mar 15, 2023 · N2572V · Substantial damageNTSB WPR23LA114Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Ephraim, UTThe pilot’s improper landing flare and loss of directional control.Feb 24, 2023 · N84717 · Substantial damageNTSB WPR23LA109Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Morgan, UTThe pilot’s failure to maintain directional control during landing.Feb 12, 2023 · N8135K · Substantial damage