# NTSB investigations: Cessna 172B, 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 WPR26FA354](https://openairdocs.org/ntsb/WPR26FA354.md): Cessna 172B · Royal City, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 24, 2026 · N44P · Substantial damage
  > On September 23, 2026, about 1711 Pacific daylight time, a Cessna 172B, N44P, was substantially damaged when it was involved in an accident near Royal City, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB SEA07CA235](https://openairdocs.org/ntsb/SEA07CA235.md): Cessna 172B · Seattle, WA · Accident · No injuries · Data collection · Final report · Aug 14, 2007 · N7657X · Substantial damage
  > The private pilot's failure to see the approaching large wake swell, both during his landing and the subsequent takeoff, and the failure of the instructor pilot to insure that the private pilot's visual lookout was effective enough to detect the oncoming…
- [NTSB SEA95LA107](https://openairdocs.org/ntsb/SEA95LA107.md): Cessna 172B · Sinclair Island, WA · Accident · No injuries · Limited investigation · Final report · May 27, 1995 · N7996X · Substantial damage
  > The pilot's failure to attain the proper touchdown point. Contributing to the accident were a tailwind, wet grass, and the pilot's inadequate remedial action.
- [NTSB SEA92FA114](https://openairdocs.org/ntsb/SEA92FA114.md): Cessna 172B · Eatonville, WA · Accident · 1 fatal · Field investigation · Final report · May 22, 1992 · N7579X · Destroyed
  > Undetermined.
- [NTSB SEA81DYE38](https://openairdocs.org/ntsb/SEA81DYE38.md): Cessna 172A · Port Townsend, WA · Accident · No injuries · Closed · Aug 25, 1981 · N7438X · Substantial damage
- [NTSB SEA78DYP53](https://openairdocs.org/ntsb/SEA78DYP53.md): Cessna 172 · Ephrata, WA · Accident · No injuries · Closed · Sep 2, 1978 · N7409X · Substantial damage
- [NTSB SEA77DYE35](https://openairdocs.org/ntsb/SEA77DYE35.md): Cessna 172 · Ilwaco, WA · Accident · No injuries · Closed · Aug 27, 1977 · N6931X · Substantial damage
- [NTSB SEA76AS054](https://openairdocs.org/ntsb/SEA76AS054.md): Cessna 172B · Curlew, WA · Accident · 3 fatal · Closed · Jun 4, 1976 · N6916X · Destroyed
- [NTSB SEA76DYG20](https://openairdocs.org/ntsb/SEA76DYG20.md): Cessna 172B · Deer Park, WA · Accident · No injuries · Closed · Oct 5, 1975 · N7748X · Substantial damage
- [NTSB SEA69D0191](https://openairdocs.org/ntsb/SEA69D0191.md): Cessna 172B · Shelton, WA · Accident · No injuries · Closed · Feb 6, 1969 · N7996X · Substantial damage
- [NTSB SEA68D0304](https://openairdocs.org/ntsb/SEA68D0304.md): Cessna 172 · Ocean Shores, WA · Accident · No injuries · Closed · May 15, 1968 · N8070X · Substantial damage
- [NTSB SEA68A0045](https://openairdocs.org/ntsb/SEA68A0045.md): Cessna 172B · Bellingham, WA · Accident · 1 fatal · Closed · Jan 2, 1968 · N8051X · Substantial damage
- [NTSB SEA66D0183](https://openairdocs.org/ntsb/SEA66D0183.md): Cessna 172 · Bellingham, WA · Accident · No injuries · Closed · Dec 3, 1965 · N6933X · Substantial damage
- [NTSB UNK65X0580](https://openairdocs.org/ntsb/UNK65X0580.md): Cessna 172 · Ellensburg, WA · Accident · No injuries · Closed · Nov 6, 1964 · N7545X · 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'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072406'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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