Fatal NTSB investigations, WA

7 cases where the first occurrence was “Abrupt maneuver”.

Cases per year

19862026
Fatal NTSB investigations, WA per year, 1986–2026: 7 cases
19861
19872
19882
20031
20041

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 100)
  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 SEA04FA111Accident · 1 fatalField investigationFinal reportTeST TST-10 M · Enumclaw, WAAircraft control not maintained while maneuvering for landing. A proper glidepath was not maintained was a factor.Jun 21, 2004 · N410JP · Substantial damageNTSB SEA03FA089Accident · 2 fatalField investigationFinal reportCessna 172 · Republic, WAThe pilot's failure to maintain airspeed resulting in a stall and subsequent loss of control during low altitude maneuvering.May 30, 2003 · N7301A · Substantial damageNTSB SEA88FA095Accident · 1 fatalField investigationFinal reportCessna 172L · Ocean Shores, WAThe student pilot departed on his fifth solo flight from the airport where he had been accustomed to originating his instructional flights. After several touch and go landings he proceeded to a nearby airport and conducted at least one more touch and go.…May 14, 1988 · N7935G · DestroyedNTSB SEA88LA072Accident · 1 fatalLimited investigationFinal reportSteen Skybolt GT-2 · Saint John, WAAfter tkof witnesses said the acft did a maneuver at 50-60 ft AGL that involved a steep (90 degree) banked turn to a snap roll. The biwing acft was capable of aerobatic flt and the plt had discussed aerobatic roll maneuvers on tkof with the acft co-owner. The…Apr 12, 1988 · N76JJ · DestroyedNTSB SEA87FA106Accident · 1 fatalField investigationFinal reportHiller UH-12E · Shelton, WAThe pilot was properly certificated for the flight; however, due to operator insurance restrictions, all prior commercial flights had required the owner/operator to accompany this pilot, therefore this was the pilot's first commercial flight as sole pilot.…May 28, 1987 · N28875 · DestroyedNTSB SEA87FA051Accident · 2 fatalField investigationFinal reportCessna 150J · Vancouver, WAAircraft was returning from stage 3 instructional flight during which instructor normally allowed student to fly. Evidence indicates aircraft passed in vicinity of heavy bird activity and student executed nose down bird avoidance maneuver. Instructor, for…Jan 29, 1987 · N50922 · DestroyedNTSB SEA86FA245Accident · 2 fatalField investigationFinal reportCessna 150M · Carbonado, WAThe instructor and passenger departed on either an introductory flight, initial instructional flight, (or combination thereof). During the flight the aircraft was flown down a canyon which the instructor had flown down previously. As the aircraft approached…Sep 12, 1986 · N9250U · Destroyed