# NTSB investigations: Piper PA-22, 1970

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 FTW71DPJ21](https://openairdocs.org/ntsb/FTW71DPJ21.md): Piper PA-22 · Thomas, OK · Accident · No injuries · Closed · Dec 3, 1970 · N8818C · Substantial damage
- [NTSB IAD71AI024](https://openairdocs.org/ntsb/IAD71AI024.md): Piper PA-22 · Hamlin, WV · Accident · 1 fatal · Closed · Nov 8, 1970 · N26F · Substantial damage
- [NTSB SEA71DWG31](https://openairdocs.org/ntsb/SEA71DWG31.md): Piper PA-22 · Othello, WA · Accident · Minor injuries · Closed · Nov 1, 1970 · N8643C · Substantial damage
- [NTSB ANC71DAA06](https://openairdocs.org/ntsb/ANC71DAA06.md): Piper PA-22 · Fairbanks, AK · Accident · No injuries · Closed · Aug 22, 1970 · N677A · Substantial damage
- [NTSB CHI71FBJ11](https://openairdocs.org/ntsb/CHI71FBJ11.md): Piper PA-22 · Kalamazoo, MI · Accident · Serious injuries · Closed · Jul 23, 1970 · N2253A · Substantial damage
- [NTSB CHI70FDW24](https://openairdocs.org/ntsb/CHI70FDW24.md): Piper PA-22 · Richmond, MI · Accident · Minor injuries · Closed · Jun 30, 1970 · N946A · Substantial damage
- [NTSB NYC70AN136](https://openairdocs.org/ntsb/NYC70AN136.md): Piper PA-32 · Saranac Lake, NY · Accident · 5 fatal · Closed · Jun 27, 1970 · N3682W · Destroyed
- [NTSB MIA70FKG26](https://openairdocs.org/ntsb/MIA70FKG26.md): Piper PA-22 · Jonesboro, GA · Accident · No injuries · Closed · Apr 26, 1970 · N1898P · Substantial damage
- [NTSB CHI70DBJ17](https://openairdocs.org/ntsb/CHI70DBJ17.md): Piper PA-22 · Schoolcraft, MI · Accident · No injuries · Closed · Mar 29, 1970 · N2747P · Substantial damage
- [NTSB ANC70FAA05](https://openairdocs.org/ntsb/ANC70FAA05.md): Piper PA-22 · College Br, AK · Accident · Minor injuries · Closed · Mar 22, 1970 · N3506Z · Substantial damage
- [NTSB CHI70DBJ07](https://openairdocs.org/ntsb/CHI70DBJ07.md): Piper PA-22 · Lake City, MI · Accident · No injuries · Closed · Feb 15, 1970 · N1146C · Substantial damage
- [NTSB NYC70FGM04](https://openairdocs.org/ntsb/NYC70FGM04.md): Piper PA-22 · Jeannette, PA · Accident · No injuries · Closed · Jan 17, 1970 · N600A · Substantial damage
- [NTSB FTW70FBG07](https://openairdocs.org/ntsb/FTW70FBG07.md): Piper PA-22 · Port Lavaca, TX · Accident · Minor injuries · Closed · Jan 17, 1970 · N8611C · Substantial damage
- [NTSB DEN70DXA02](https://openairdocs.org/ntsb/DEN70DXA02.md): Piper PA-22 · Guernsey, WY · Accident · No injuries · Closed · Jan 12, 1970 · N2221A · Substantial damage
- [NTSB FTW70FPG01](https://openairdocs.org/ntsb/FTW70FPG01.md): Piper PA-22 · Springdale, AR · Accident · No injuries · Closed · Jan 3, 1970 · N1651A · 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 year(c."eventDate") = 1970
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102202'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102202&year=1970

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