NTSB investigations, 2018, WA

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

Cases per year

20082026
NTSB investigations, 2018, 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\") = 2018
    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 GAA19CA100Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot's loss of directional control during the landing roll and his subsequent overapplication of left rudder, which resulted in the right wing impacting the runway.Dec 14, 2018 · N19EC · Substantial damageNTSB GAA19CA080Accident · No injuriesData collectionFinal reportPiper PA 12 · Burlington, WAThe pilot's failure to maintain directional control while landing in crosswind conditions.Nov 29, 2018 · N3619M · Substantial damageNTSB GAA19CA055Accident · No injuriesData collectionFinal reportCessna A185 · Reardan, WAThe pilot receiving instruction's improper approach and landing flare in crosswind conditions, which resulted in a bounced landing and subsequent loss of directional control. Contributing to the accident was the flight instructor’s delayed remedial action.Nov 9, 2018 · N185PR · Substantial damageNTSB GAA19CA027Accident · No injuriesData collectionFinal reportPiper J3C · Camas, WAThe student pilot’s failure to maintain directional control during the landing roll.Oct 13, 2018 · N6048H · Substantial damageNTSB WPR18LA259Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Roche Harbor, WAThe pilot’s failure to secure his seat position prior to takeoff, which resulted in a loss of airplane control and subsequent hard landing.Sep 12, 2018 · N24ME · Substantial damageNTSB GAA18CA384Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC41 · Chelan, WAThe pilot's improper approach, which resulted in the airplane landing long and a subsequent runway overrun.Jun 27, 2018 · N1266C · Substantial damageNTSB GAA18CA373Accident · No injuriesData collectionFinal reportCessna 180 · Kent, WAThe pilot’s use of excessive braking during the landing roll, which resulted in the airplane coming to rest nose down.Jun 20, 2018 · N9130T · Substantial damageNTSB GAA18CA441Accident · No injuriesData collectionFinal reportPiper PA · East Sound, WAThe pilot's improper landing flare, which resulted in a bounced landing and his subsequent failure to maintain directional control in a gusting, left quartering headwind.Jun 17, 2018 · N11YB · Substantial damageNTSB GAA18CA336Accident · No injuriesData collectionFinal reportAviat A 1 · Renton, WAThe pilot’s inadequate crosswind correction, which resulted in the right wing impacting the water’s surface.Jun 10, 2018 · N352AM · Substantial damageNTSB GAA18CA290Accident · No injuriesData collectionFinal reportPiper PA 14 · Vashon, WAThe pilot’s failure to maintain directional control of the airplane during the takeoff roll due to his right foot inadvertently applying pressure to both rudder pedals.May 20, 2018 · N1423P · Substantial damageNTSB GAA18CA296Accident · No injuriesData collectionFinal reportCessna 182 · Prescott, WAThe pilot’s taxiing too fast on rough terrain, which resulted in a loss of directional control.May 17, 2018 · N182EW · Substantial damageNTSB GAA18CA238Accident · No injuriesData collectionFinal reportStinson 108 · Spokane, WAThe pilot’s failure to maintain directional control during landing.Apr 28, 2018 · N35VM · Substantial damageNTSB GAA18CA223Accident · No injuriesData collectionFinal reportKen Olson Scamp · Raymond, WAThe pilot's failure to maintain a proper landing flare, which resulted in an aerodynamic stall, bounced landing, and subsequent secondary stall during a go-around attempt.Apr 22, 2018 · N964TA · Substantial damageNTSB WPR18LA109Accident · Minor injuriesClass 3 · LimitedFinal reportLyons Robert Navajo HKS · Arlington, WAThe pilot's loss of directional control during landing. Contributing to the accident was the pilot's failure to attain a proper touchdown point, which required his use of heavy braking to stop on the remaining runway and exacerbated the uneven braking…Mar 11, 2018 · N1762C · Substantial damageNTSB GAA18CA165Accident · No injuriesData collectionFinal reportBellanca 1413 · Anacortes, WAThe pilot’s failure to maintain directional control during landing.Mar 10, 2018 · N74445 · Substantial damageNTSB GAA18CA164Accident · No injuriesData collectionFinal reportCessna 180 · Mount Vernon, WAThe pilot’s failure to maintain directional control of the airplane during landing.Mar 9, 2018 · N9463C · Substantial damage