# NTSB investigations: Piper PA-22-150, OK

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 FTW90LA006](https://openairdocs.org/ntsb/FTW90LA006.md): Piper PA-22-150 · Edmond, OK · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 1989 · N1940P · No damage
  > Inadequate supervision by the pilot. Factors related to the accident were: darkness and the passenger's impairment from use of a prescription drug (medication).
- [NTSB FTW84LA370](https://openairdocs.org/ntsb/FTW84LA370.md): Piper PA-22-150 · Tahlequah, OK · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1984 · N3350Z · Substantial damage
  > Law enforcement officers responding to the acft accident found the acft inverted beyond the south end of the runway. Plt stated he and his passengers had been drinking beer and decided to go flying. Plt's statements to officers are not clear on exact events…
- [NTSB FTW83LA265](https://openairdocs.org/ntsb/FTW83LA265.md): Piper PA-22-150 · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Jun 4, 1983 · N2637P · Substantial damage
  > The acft veered off the rwy & nosed over. The plt stated he had purchased the acft to start taking plt lessons to securehis license which had been revoked 10/3/79.
- [NTSB FTW82DPJ03](https://openairdocs.org/ntsb/FTW82DPJ03.md): Piper PA-22 · Seiling, OK · Accident · No injuries · Closed · Oct 27, 1981 · N3949P · Substantial damage
- [NTSB FTW81FA019](https://openairdocs.org/ntsb/FTW81FA019.md): Piper PA-22 · Oklahoma City, OK · Accident · 1 fatal · Closed · Dec 21, 1980 · N2524P · Destroyed
- [NTSB FTW79DPJ38](https://openairdocs.org/ntsb/FTW79DPJ38-202527.md): Piper PA-22 · O'Keene, OK · Accident · Serious injuries · Closed · Aug 8, 1979 · N3808P · Substantial damage
- [NTSB FTW76FPJ39](https://openairdocs.org/ntsb/FTW76FPJ39.md): Piper PA-22 · Randlett, OK · Accident · Serious injuries · Closed · Jul 15, 1976 · N6160D · Destroyed
- [NTSB FTW76FPJ28](https://openairdocs.org/ntsb/FTW76FPJ28.md): Piper PA-22 · Oklahoma City, OK · Accident · No injuries · Closed · Mar 19, 1976 · N1722P · Substantial damage
- [NTSB FTW75AF071](https://openairdocs.org/ntsb/FTW75AF071.md): Piper PA-22 · Gore, OK · Accident · 2 fatal · Closed · Jun 6, 1975 · N7030D · Destroyed
- [NTSB FTW75FPM12](https://openairdocs.org/ntsb/FTW75FPM12.md): Piper PA-22 · Tulsa, OK · Accident · No injuries · Closed · Mar 21, 1975 · N7633D · Substantial damage
- [NTSB FTW74FPM05](https://openairdocs.org/ntsb/FTW74FPM05.md): Piper PA-22 · Tulsa, OK · Accident · No injuries · Closed · Aug 14, 1973 · N8039D · Substantial damage
- [NTSB FTW71AF066](https://openairdocs.org/ntsb/FTW71AF066.md): Piper PA-22 · Meers, OK · Accident · 2 fatal · Closed · Apr 1, 1971 · N7442D · Destroyed
- [NTSB FTW71AF029](https://openairdocs.org/ntsb/FTW71AF029.md): Piper PA-22 · Baker, OK · Accident · 1 fatal · Closed · Dec 9, 1970 · N5752D · Destroyed
- [NTSB FTW68F0331](https://openairdocs.org/ntsb/FTW68F0331.md): Piper PA-22 · Fairview, OK · Accident · Minor injuries · Closed · Nov 11, 1967 · N3635P · Destroyed
- [NTSB FTW68D0415](https://openairdocs.org/ntsb/FTW68D0415.md): Piper PA-22 · Honobia, OK · Accident · Minor injuries · Closed · Oct 28, 1967 · N6707B · Substantial damage
- [NTSB FTW68D0220](https://openairdocs.org/ntsb/FTW68D0220.md): Piper PA-22 · Marshall, OK · Accident · No injuries · Closed · Sep 9, 1967 · N6946D · Substantial damage
- [NTSB FTW66F0675](https://openairdocs.org/ntsb/FTW66F0675.md): Piper PA-22 · Stilwell, OK · Accident · No injuries · Closed · May 20, 1966 · N5837D · Substantial damage
- [NTSB FTW66D0609](https://openairdocs.org/ntsb/FTW66D0609.md): Piper PA-22 · Oklahoma City, OK · Accident · No injuries · Closed · Apr 2, 1966 · N3366Z · Substantial damage
- [NTSB FTW66F0346](https://openairdocs.org/ntsb/FTW66F0346.md): Piper PA-22 · Yukon, OK · Accident · No injuries · Closed · Oct 28, 1965 · N7328D · Substantial damage
- [NTSB FTW66D0229](https://openairdocs.org/ntsb/FTW66D0229.md): Piper PA-22 · Oklahoma Cty, OK · Accident · No injuries · Closed · May 27, 1965 · N4842A · Substantial damage
- [NTSB UNK65X1462](https://openairdocs.org/ntsb/UNK65X1462.md): Piper PA22 · Yukon, OK · Accident · Minor injuries · Closed · Feb 27, 1965 · N3366Z · 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" = 'OK' 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 ('7102210'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102210&state=OK

---
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.
