# NTSB investigations: Piper PA-18A, 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 WPR14CA212](https://openairdocs.org/ntsb/WPR14CA212.md): Piper PA 18A · Arlington, WA · Accident · No injuries · Data collection · Final report · May 18, 2014 · N7474D · Substantial damage
  > The pilot's improper application of brakes during taxi in tailwind conditions, which resulted in a loss of aircraft control and subsequent nose over.
- [NTSB SEA83LA108](https://openairdocs.org/ntsb/SEA83LA108.md): Piper PA18-150 · Touchet, WA · Accident · No injuries · Limited investigation · Final report · May 24, 1983 · N8576C · Substantial damage
  > The acft nosed over during landing and came to rest inverted in an off airport landing. The pilot was surveying some land to be sprayed to estimate the cost. He landed on the field which was very soft and the acft nosed over. The pilot was not injured.
- [NTSB SEA74DYE18](https://openairdocs.org/ntsb/SEA74DYE18.md): Piper PA-18 · Arlington, WA · Accident · No injuries · Closed · Sep 23, 1973 · N7474D · Substantial damage
- [NTSB SEA71DWD28](https://openairdocs.org/ntsb/SEA71DWD28.md): Piper PA-18 · Arlington, WA · Accident · No injuries · Closed · Apr 3, 1971 · N7474D · Substantial damage
- [NTSB SEA70DW601](https://openairdocs.org/ntsb/SEA70DW601.md): Piper PA-18 · Rice, WA · Accident · No injuries · Closed · Feb 21, 1970 · N1194C · Substantial damage
- [NTSB SEA69D0268](https://openairdocs.org/ntsb/SEA69D0268.md): Piper PA-18 · Oraville, WA · Accident · No injuries · Closed · Jun 1, 1969 · N1870A · Substantial damage
- [NTSB SEA69D0185](https://openairdocs.org/ntsb/SEA69D0185.md): Piper PA-18A · Othello, WA · Accident · Minor injuries · Closed · Feb 9, 1969 · N6191D · Substantial damage
- [NTSB SEA67D0270](https://openairdocs.org/ntsb/SEA67D0270.md): Piper PA-18 · Dusty, WA · Accident · No injuries · Closed · Mar 27, 1967 · N8668C · Destroyed
- [NTSB UNK64X3791](https://openairdocs.org/ntsb/UNK64X3791.md): Piper PA18A · Tonasket, WA · Accident · No injuries · Closed · Sep 5, 1964 · N1870A · 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 ('7101804', '7102831'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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