# NTSB investigations: Cessna 172D, 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 WPR18LA047](https://openairdocs.org/ntsb/WPR18LA047.md): Cessna 172D · Auburn, WA · Accident · No injuries · Class 3 · Limited · Final report · Dec 7, 2017 · N2351U · Substantial damage
  > The pilot's loss of airplane control for reasons that could not be determined based on the available information.
- [NTSB GAA16CA286](https://openairdocs.org/ntsb/GAA16CA286.md): Cessna 172 · Arlington, WA · Accident · No injuries · Data collection · Final report · Jun 6, 2016 · N539MT · Substantial damage
  > The failure of the airplane’s right steering rod end, which resulted in the pilot’s inability to maintain directional control.
- [NTSB WPR09CA113](https://openairdocs.org/ntsb/WPR09CA113.md): Cessna 172D · Bow, WA · Accident · Minor injuries · Data collection · Final report · Feb 9, 2009 · N2404Y · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection and failure to verify the fuel quantity on board.
- [NTSB SEA04CA141](https://openairdocs.org/ntsb/SEA04CA141.md): Cessna 172D · Morton, WA · Accident · No injuries · Data collection · Final report · Jul 24, 2004 · N2527Y · Substantial damage
  > The pilot's misjudgment of altitude on final approach which resulted in an improper touchdown point and subsequent runway overrun. A factor was sunglare.
- [NTSB SEA95LA087](https://openairdocs.org/ntsb/SEA95LA087.md): Cessna 172 · Twisp, WA · Accident · Minor injuries · Limited investigation · Final report · May 1, 1995 · N2548Y · Substantial damage
  > The improper installation of a nose landing gear assembly bolt (no cotter key installed) by unknown maintenance personnel. This led to a failure of the nose landing gear steering and subsequent noseover during landing rollout.
- [NTSB SEA87LA032](https://openairdocs.org/ntsb/SEA87LA032.md): Cessna 172D · Kennewick, WA · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 1986 · N2349U · Substantial damage
  > The private pilot was seated in the right front seat with the student pilot in the left front seat. The pvt pilot allowed the student pilot to takeoff. The student over rotated and the stall warning was sounding. The pvt pilot took command of the aircraft but…
- [NTSB SEA78DYP04](https://openairdocs.org/ntsb/SEA78DYP04.md): Cessna 172D · Sunnyside, WA · Accident · No injuries · Closed · Nov 1, 1977 · N2388U · Substantial damage
- [NTSB SEA72FYE06](https://openairdocs.org/ntsb/SEA72FYE06.md): Cessna 172 · Renton, WA · Accident · No injuries · Closed · Aug 5, 1971 · N2048Y · Substantial damage
- [NTSB SEA71DWD10](https://openairdocs.org/ntsb/SEA71DWD10.md): Cessna 172 · Arlington, WA · Accident · Serious injuries · Closed · Jul 4, 1970 · N2513Y · Substantial damage
- [NTSB SEA69F0192](https://openairdocs.org/ntsb/SEA69F0192.md): Cessna 172 · Port Orchard, WA · Accident · Minor injuries · Closed · Feb 21, 1969 · N2459Y · Substantial damage
- [NTSB SEA69A0017](https://openairdocs.org/ntsb/SEA69A0017.md): Cessna 172 · Lopez, WA · Accident · 2 fatal · Closed · Aug 28, 1968 · N2520Y · Destroyed
- [NTSB SEA66D0018](https://openairdocs.org/ntsb/SEA66D0018.md): Cessna 172D · Latah, WA · Accident · No injuries · Closed · Jul 3, 1965 · N2180Y · Substantial damage
- [NTSB SEA65D0066](https://openairdocs.org/ntsb/SEA65D0066.md): Cessna 172 · Yakima, WA · Accident · No injuries · Closed · May 23, 1965 · N2134Y · Substantial damage

## 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 ('2072410'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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