NTSB investigations, 2013, WA

6 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2013, WA per year, 2008–2026: 107 cases
200810
20099
20106
20118
20124
20136
201411
20156
20162
20177
20188
20196
20207
20213
20224
20231
20246
20252
20261

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\") = 2013
    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\" = '240' 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 WPR13LA360Accident · No injuriesLimited investigationFinal reportVersteeg Helicycle · Richland, WAThe pilot’s failure to maintain helicycle control during hover due to an inadvertent control input.Aug 5, 2013 · N234RV · Substantial damageNTSB WPR13CA361Accident · Minor injuriesData collectionFinal reportBuckeye Dream Machine · Fruitland, WAThe operation of a powered parachute by a non-certificated pilot, and the pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with a vehicle.Jul 3, 2013 · UNREG · Substantial damageNTSB WPR13LA287Accident · Serious injuriesLimited investigationFinal reportBell 206B · Royal City, WAThe pilot's failure to maintain clearance from netting material during a low pass over trees, which resulted in a loss of helicopter control.Jun 24, 2013 · N407FK · Substantial damageNTSB WPR13CA252Accident · Minor injuriesData collectionFinal reportCessna 172A · Eatonville, WAA partial loss of engine power due to carburetor icing and the pilot's failure to maintain adequate airspeed during a go-around, which resulted in a stall.May 31, 2013 · N7701T · Substantial damageNTSB WPR13LA188Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ocean Shores, WAThe pilots’ loss of helicopter control during the approach to landing.Apr 12, 2013 · N442FG · Substantial damageNTSB WPR13CA121Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Sunnyside, WAThe pilot’s inadequate vigilance while maneuvering at low altitude and his subsequent failure to maintain clearance from power lines.Feb 9, 2013 · N6726J · Substantial damage