NTSB investigations, 2019, WA

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

Cases per year

20082026
NTSB investigations, 2019, 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\") = 2019
    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 GAA19CA517Accident · Minor injuriesData collectionFinal reportCessna 180 · Arlington, WAThe pilot's failure to properly secure the seat before takeoff, which resulted in it sliding back during takeoff and rendering him unable to reach the rudder pedals and throttle lever, a subsequent runway excursion, ground loop, and impact with a berm.Aug 20, 2019 · N180TB · Substantial damageNTSB WPR19LA227Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Spokane, WAA loss of directional control during landing for undetermined reasons.Aug 19, 2019 · N43793 · Substantial damageNTSB GAA19CA396Accident · No injuriesData collectionFinal reportDonald Bernard Higgs Pietenpol · Anacortes, WAThe failure of the left main landing gear attachment point during the landing roll for reasons that could not be determined because the attachment was not examined, which resulted in a loss of directional control, collision with a drainage culvert, and a…Jul 7, 2019 · N7169K · Substantial damageNTSB GAA19CA376Accident · No injuriesData collectionFinal reportPiper PA 12 · Yakima, WAThe separation of the left steering spring from the tailwheel assembly during landing for reasons that could not be determined, which resulted in a ground loop.Jun 30, 2019 · N4238M · Substantial damageNTSB GAA19CA313Accident · No injuriesData collectionFinal reportCessna 150 · Renton, WAThe pilot receiving instruction's failure to maintain directional control and his overapplication of right rudder and the flight instructor's delayed remedial action during the landing, which resulted in a ground-loop.Jun 4, 2019 · N8685S · Substantial damageNTSB GAA19CA167Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Yakima, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop, and the flight instructor's delayed remedial action.Mar 15, 2019 · N767CC · Substantial damageNTSB GAA19CA159Accident · Minor injuriesData collectionFinal reportPiper PA18 · Pullman, WAThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.Mar 9, 2019 · N4100Z · Substantial damageNTSB GAA19CA148Accident · No injuriesData collectionFinal reportCessna 172 · Bellingham, WAThe pilot's improper crosswind correction during taxi operations in gusting crosswind conditions.Feb 25, 2019 · CFHGQ · Substantial damageNTSB GAA19CA136Accident · No injuriesData collectionFinal reportCessna 182 · Arlington, WAThe pilot's distraction during the engine warm-up, which resulted in the airplane's collision with a hangar. Contributing to the accident was the pilot's failure to set the brakes.Feb 10, 2019 · N9101X · Substantial damage