# NTSB investigations, WA

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 97 of 97 · 4,814 cases

## Cases, newest first

- [NTSB UNK64X0678](https://openairdocs.org/ntsb/UNK64X0678.md): Cessna 175 · Ellensburg, WA · Accident · No injuries · Closed · Feb 23, 1964 · N8160T · Substantial damage
- [NTSB UNK64X0634](https://openairdocs.org/ntsb/UNK64X0634.md): Stinson 108-2 · Federal Way, WA · Accident · No injuries · Closed · Feb 21, 1964 · N9613K · Substantial damage
- [NTSB UNK64X0613](https://openairdocs.org/ntsb/UNK64X0613.md): Taylorcraft BC12D · Bremerton, WA · Accident · No injuries · Closed · Feb 19, 1964 · N43243 · Minor damage
- [NTSB UNK64X0570](https://openairdocs.org/ntsb/UNK64X0570.md): Piper PA22 · Renton, WA · Accident · No injuries · Closed · Feb 15, 1964 · N5381Z · Substantial damage
- [NTSB UNK64X0552](https://openairdocs.org/ntsb/UNK64X0552.md): Beechcraft 23 · Seattle, WA · Accident · 4 fatal · Closed · Feb 13, 1964 · N2375J · Destroyed
- [NTSB UNK64X0512](https://openairdocs.org/ntsb/UNK64X0512.md): Cessna 150 · Othello, WA · Accident · No injuries · Closed · Feb 9, 1964 · N7806Z · Substantial damage
- [NTSB UNK64X0504](https://openairdocs.org/ntsb/UNK64X0504.md): Cessna 182 · Prosser, WA · Accident · 3 fatal · Closed · Feb 9, 1964 · N8660T · Destroyed
- [NTSB UNK64X0487](https://openairdocs.org/ntsb/UNK64X0487.md): Cessna 185 · Enumclaw, WA · Accident · No injuries · Closed · Feb 7, 1964 · N9902X · Substantial damage
- [NTSB UNK64X0483](https://openairdocs.org/ntsb/UNK64X0483.md): Cessna 172 · Davenport, WA · Accident · No injuries · Closed · Feb 7, 1964 · N4264F · Substantial damage
- [NTSB UNK64X0390](https://openairdocs.org/ntsb/UNK64X0390.md): Piper PA24 · Arlington, WA · Accident · No injuries · Closed · Jan 28, 1964 · N5106P · Substantial damage
- [NTSB UNK64X0384](https://openairdocs.org/ntsb/UNK64X0384.md): Bell 47D1 · Yakima, WA · Accident · No injuries · Closed · Jan 28, 1964 · N1061 · Substantial damage
- [NTSB UNK64X0377](https://openairdocs.org/ntsb/UNK64X0377.md): Piper J3C-65 · Puget Sound, WA · Accident · 1 fatal · Closed · Jan 26, 1964 · N98319 · Destroyed
- [NTSB UNK64X0337](https://openairdocs.org/ntsb/UNK64X0337.md): Piper PA24 · Hoodsport, WA · Accident · 1 fatal · Closed · Jan 23, 1964 · N8034P · Destroyed
- [NTSB SEA63A0071](https://openairdocs.org/ntsb/SEA63A0071.md): Curtiss-Wrt C-46F · Puyallup, WA · Accident · Serious injuries · Closed · Feb 16, 1963 · N616Z · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?page=97&state=WA

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
