# NTSB investigations: Cessna 402B, 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.

## Latest cases

- [NTSB SEA02LA015](https://openairdocs.org/ntsb/SEA02LA015.md): Cessna 402B · Pasco, WA · Accident · No injuries · Limited investigation · Final report · Nov 15, 2001 · N910WT · Substantial damage
  > the pilot's failure to keep the aircraft from touching down short of the displaced threshold, and his failure to maintain directional control after the aircraft's left main gear tire deflated as a result of impacting the lip at the beginning of the subject…
- [NTSB SEA95LA159](https://openairdocs.org/ntsb/SEA95LA159.md): Cessna 402B · Wenatchee, WA · Accident · No injuries · Limited investigation · Final report · Jul 29, 1995 · N51816 · Substantial damage
  > Improper installation (failure to install cotter key) by company maintenance personnel.
- [NTSB SEA86LA031](https://openairdocs.org/ntsb/SEA86LA031.md): Cessna 402B · Spokane, WA · Accident · No injuries · Limited investigation · Final report · Dec 27, 1985 · N4624N · Substantial damage
  > The plt reported encountering icing conditions during his apch to Spokane. Upon arrival, the acft remained at Spokane for 30-40 minutes during which freezing drizzle and below freezing temps existed prior to and during the departure. The plt did not utilize…

## 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'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590P'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=207590P&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.