# NTSB investigations: Cessna 172A, 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 WPR17LA169](https://openairdocs.org/ntsb/WPR17LA169.md): Cessna 172A · Enumclaw, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 2017 · N7243T · Substantial damage
  > The pilot's improper approach for landing, which resulted in the airplane landing long, and his delayed decision to go around with insufficient runway remaining, which resulted in collision with an airport perimeter fence.
- [NTSB WPR13CA252](https://openairdocs.org/ntsb/WPR13CA252.md): Cessna 172A · Eatonville, WA · Accident · Minor injuries · Data collection · Final report · May 31, 2013 · N7701T · Substantial damage
  > A partial loss of engine power due to carburetor icing and the pilot's failure to maintain adequate airspeed during a go-around, which resulted in a stall.
- [NTSB SEA06CA041](https://openairdocs.org/ntsb/SEA06CA041.md): Cessna 172A · Othello, WA · Accident · No injuries · Data collection · Final report · Jan 8, 2006 · N9852T · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll. A factor was the berm.
- [NTSB SEA86LA221](https://openairdocs.org/ntsb/SEA86LA221.md): Cessna 172A · San Juan Island, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1986 · N7405T · Destroyed
  > The pilot was flying the aircraft at a low altitude in order to spot fish. He ran the right fuel tank dry causing the engine to quit. He was unable to switch fuel tanks and attempt a restart due to his low altitude. A forced landing was made close to the…
- [NTSB SEA83FA029](https://openairdocs.org/ntsb/SEA83FA029.md): Cessna 172A · Renton, WA · Accident · Serious injuries · Field investigation · Final report · Dec 11, 1982 · N9846T · Destroyed
  > The eng lost power during takeoff at about 200 ft AGL. The acft then executed a left descending 180 deg turn & crashed on the flightline of an acft company. Investigation revealed that the fuel filter bowl contained about 1/2 fuel & 1/2 water, and the…
- [NTSB SEA74AS034](https://openairdocs.org/ntsb/SEA74AS034.md): Cessna 172A · Waterville, WA · Accident · 3 fatal · Closed · Mar 1, 1974 · N7820T · Destroyed
- [NTSB SEA69D0031](https://openairdocs.org/ntsb/SEA69D0031.md): Cessna 172 · Ashford, WA · Accident · No injuries · Closed · Jul 9, 1968 · N7392T · Substantial damage
- [NTSB SEA66F0240](https://openairdocs.org/ntsb/SEA66F0240.md): Cessna 172 · Pullman, WA · Accident · Minor injuries · Closed · Apr 13, 1966 · N7721T · Substantial damage
- [NTSB SEA66F0092](https://openairdocs.org/ntsb/SEA66F0092.md): Cessna 172 · Kent, WA · Accident · No injuries · Closed · Aug 15, 1965 · N9739T · Substantial damage
- [NTSB SEA65F0021](https://openairdocs.org/ntsb/SEA65F0021.md): Cessna 172 · Pullman, WA · Accident · No injuries · Closed · Mar 4, 1965 · N7200T · Substantial damage
- [NTSB SEA65D0027](https://openairdocs.org/ntsb/SEA65D0027.md): Cessna 172A · Seattle, WA · Accident · No injuries · Closed · Mar 2, 1965 · N7377T · Substantial damage
- [NTSB UNK65X0818](https://openairdocs.org/ntsb/UNK65X0818.md): Cessna 172 · Mesa, WA · Accident · No injuries · Closed · Nov 24, 1964 · N7362T · 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 ('2072404'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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