NTSB investigations, 2023, ID

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

Cases per year

20082026
NTSB investigations, 2023, ID per year, 2008–2026: 161 cases
20089
20096
201011
20114
201212
20136
20146
20157
20167
201710
20189
201912
20207
202113
20229
202312
202412
20256
20263

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\" = 'ID' 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 WPR24LA027Accident · No injuriesClass 4 · LimitedFinal reportKitfox S5 · Ririe, IDThe pilot’s inadvertent excessive use of brakes which resulted in a nose-over.Nov 4, 2023 · N88VJ · Substantial damageNTSB WPR24LA008Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Caldwell, IDThe pilot’s failure to maintain directional control during landing, resulting in a roll over.Oct 9, 2023 · N838SH · Substantial damageNTSB WPR23FA301Accident · 1 fatalClass 3 · FieldFinal reportGlasair Glastar · Idaho City, IDThe pilot’s loss of airplane control during takeoff for reasons that could not be determined.Aug 4, 2023 · N617G · Substantial damageNTSB WPR23LA292Accident · No injuriesClass 4 · LimitedFinal reportJohn Espe Cruiser · Buhl, IDThe pilot's failure to maintain airplane control during landing with a gusting tail wind.Jul 29, 2023 · N314E · Substantial damageNTSB WPR23LA246Accident · No injuriesClass 4 · LimitedFinal reportBlack Sheep CCX-1865 · Big Creek Ranger Station, IDThe pilot’s failure to identify the wet landing surface and his subsequent inability to maintain directional control and stop during landing on the unimproved grass runway, which resulted in a runway excursion and unintentional ground loop.Jun 28, 2023 · N510US · Substantial damageNTSB WPR23LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Idaho Falls, IDThe pilot’s failure to maintain directional control while landing with a gusting crosswind.Jun 21, 2023 · N3531Y · Substantial damageNTSB WPR23LA227Accident · No injuriesClass 4 · LimitedFinal reportCamille E Patch Calidus · Jerome, IDThe pilot’s failure to maintain directional control during landing, which resulted in rollover.Jun 9, 2023 · N800YA · Substantial damageNTSB WPR23LA211Accident · No injuriesClass 4 · LimitedFinal reportRockwell International S-2R · Paul, IDThe pilot’s failure to maintain directional control on the takeoff roll, resulting in a runway excursion.Jun 3, 2023 · N4894X · Substantial damageNTSB WPR23LA144Accident · No injuriesClass 4 · LimitedFinal reportKeskimaki Charles A Kitfox · Rigby, IDThe pilot receiving instruction’s failure to maintain directional control during landing and the flight instructor’s delayed remedial action.Mar 27, 2023 · N89CK · Substantial damageNTSB WPR23LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Hayden, IDThe failure of the right main landing gearbox assembly due to fatigue cracking, which resulted in a loss of directional control during the landing roll.Jan 31, 2023 · N9235B · Substantial damageNTSB WPR23LA106Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Sandpoint, IDThe pilot’s failure to maintain directional control during landing and subsequent failure to maintain clearance from a snow berm during a go around.Jan 30, 2023 · N1791P · Substantial damageNTSB WPR23LA090Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-160 · Minidoka, IDThe pilot’s failure to maintain control during landing on a contaminated runway.Jan 16, 2023 · N30737 · Substantial damage