NTSB investigations, 2023, WA

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

Cases per year

20082026
NTSB investigations, 2023, WA per year, 2008–2026: 174 cases
20089
20099
20106
201110
201216
201311
201411
20155
201612
20179
201816
20199
20204
202114
20223
20239
20244
202511
20266

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\" = 'WA' 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 WPR23LA356Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Eatonville, WAThe pilot's failure to maintain directional control during the takeoff roll, in gusty wind conditions, which resulted in a runway excursion.Sep 22, 2023 · N7955H · Substantial damageNTSB WPR23FA344Accident · 1 fatalClass 3 · FieldFinal reportSeawind 3000 · Bellevue, WAThe pilot’s loss of airplane control after encountering a lake swell and skipping during takeoff.Sep 15, 2023 · N57TJ · Substantial damageNTSB WPR23LA291Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Friday Habor, WAThe pilot’s loss of directional control during landing, which resulted in a ground loop.Jul 28, 2023 · N185GG · Substantial damageNTSB WPR23LA276Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Chelan, WAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop and subsequent nose over.Jul 18, 2023 · N300SS · Substantial damageNTSB WPR23LA271Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Burlington, WAThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.Jul 11, 2023 · N8889K · Substantial damageNTSB WPR23LA268Accident · No injuriesClass 4 · LimitedFinal reportVickers-Armstrong Spitfire IX · Deer Park, WAThe pilot’s failure to maintain directional control during landing with a crosswind.Jul 7, 2023 · N633VS · Substantial damageNTSB WPR23LA248Accident · No injuriesClass 4 · LimitedFinal reportFound FBA2C · Moses Lake, WAThe pilot’s failure to maintain directional control during landing.Jul 3, 2023 · CFXRB · Substantial damageNTSB WPR23LA273Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Metaline Falls, WAThe pilot’s loss of directional control during landing due to impact with a concrete ring embedded in the grass runway.Jul 1, 2023 · N68TP · Substantial damageNTSB WPR23LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Twisp, WAThe pilot’s loss of directional control during landing, which resulted in a runway excursion and ground loop.May 14, 2023 · N185MG · Substantial damage