NTSB investigations, WA

6 cases where NTSB found Airport structure.

Cases per year

20132026
NTSB investigations, WA per year, 2013–2026: 6 cases
20131
20141
20162
20171
20191

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\", '03022042'))
  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 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 damageNTSB GAA17CA506Accident · No injuriesData collectionFinal reportPiper J3C · Camas, WAThe pilot receiving instruction’s failure to maintain directional control during landing.Aug 9, 2017 · N6048H · Substantial damageNTSB GAA16CA417Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot's failure to maintain clearance from the building door, which resulted in substantial damage to the left wing.Aug 4, 2016 · N4801D · Substantial damageNTSB GAA16CA216Accident · No injuriesData collectionFinal reportAirborne Redback · Arlington, WAThe pilot's failure to adequately secure the aircraft while manually starting the engine from outside the cockpit, which resulted in the unmanned aircraft becoming airborne and colliding with a hangar roof.May 4, 2016 · N528PG · Substantial damageNTSB WPR15CA056Accident · No injuriesData collectionFinal reportTaylorcraft BL 65 · Everett, WAThe pilot's failure to maintain directional control during the landing roll resulting in a runway excursion and collision with hangars.Dec 7, 2014 · N27580 · Substantial damageNTSB 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 damage