NTSB investigations, 2010, WA

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

Cases per year

20082026
NTSB investigations, 2010, 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\") = 2010
    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 WPR11CA037Accident · No injuriesData collectionFinal reportCessna 172S · Port Townsend, WAThe pilot's improper flare/touchdown while landing, resulting in a loss of directional control and a runway excursion.Nov 4, 2010 · N14511 · Substantial damageNTSB WPR10LA479Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Spokane, WAThe failure of a manufacturing splice of the right main landing gear tire’s inner tube, which resulted in a deflated tire and a consequent loss of directional control on landing.Sep 30, 2010 · N90SE · Substantial damageNTSB WPR10CA461Accident · No injuriesData collectionFinal reportDehavilland Beaver DHC-2 MK.1 · Renton, WAThe pilot's failure to maintain directional control of the float-equipped airplane during an aborted water takeoff, resulting in a dragged wing.Sep 19, 2010 · N24150 · Substantial damageNTSB WPR10CA322Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Sequim, WAThe pilot’s failure to maintain directional control during landing due to an encounter with sun glare.Jun 30, 2010 · N2990P · Substantial damageNTSB WPR10CA290Accident · No injuriesData collectionFinal reportWaco UKC-S · Seattle, WAThe pilot’s inadequate compensation for the crosswind condition, resulting in a loss of directional control during the landing roll.Jun 14, 2010 · N14611 · Substantial damageNTSB WPR10CA246Accident · No injuriesData collectionFinal reportCessna 180K · Renton, WAThe pilot's inadequate compensation for the wind conditions, resulting in the loss of directional control during the landing roll.May 19, 2010 · N66033 · Substantial damage