NTSB investigations, WA

8 cases where NTSB found Misc hardware.

Cases per year

20102026
NTSB investigations, WA per year, 2010–2026: 8 cases
20101
20111
20122
20131
20182
20211

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 c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010714'))
  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 WPR21LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Twisp, WAAn in-flight separation of the control stick from the torque tube assembly, which resulted in a loss of directional control during the landing roll and subsequent on-ground collision.Jun 20, 2021 · N6917Z · 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 WPR18LA098Accident · Serious injuriesClass 3 · LimitedFinal reportRaytheon A36 · Enumclaw, WAA total loss of engine power due to oil starvation as a result of a loose oil line B-nut.Mar 4, 2018 · N207PC · Substantial damageNTSB WPR13FA243Accident · Minor injuriesField investigationFinal reportHiller UH-12E · Wenatchee, WAFatigue failure of the six bolts that secured the bevel gear to the first stage planetary carrier, which caused the transmission to seize while the helicopter and main rotor were still operating.May 26, 2013 · N99090 · Substantial damageNTSB WPR12CA236Accident · No injuriesData collectionFinal reportBell 206B · Burbank, WAThe failure of maintenance personnel to properly torque an air tube fitting, which resulted in a total loss of engine power.May 30, 2012 · N106TV · Substantial damageNTSB WPR12IA248Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 B2 · Seattle, WAFailure of maintenance personnel to ensure that the tail rotor pitch change link bolt was properly secured, which resulted in an in-flight separation of the bolt and subsequent vibration.May 22, 2012 · N105TV · Minor damageNTSB WPR11CA309Accident · Minor injuriesData collectionFinal reportCessna 182A · Vancouver, WAThe pilot's failure to properly engage the banner tow rope with the airplane's tail hook.Jul 5, 2011 · N5175D · Substantial damageNTSB WPR10FA163Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Morton, WAThe failure of maintenance personnel to properly secure a fitting cap on the throttle and metering assembly inlet after conducting a fuel system pressure check, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was…Mar 20, 2010 · N224GS · Substantial damage