# NTSB investigations: Piper PA-22-160, 1971

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 SEA72DYE17](https://openairdocs.org/ntsb/SEA72DYE17.md): Piper PA-22 · San Juan, WA · Accident · No injuries · Closed · Oct 12, 1971 · N3028Z · Substantial damage
- [NTSB MKC72AK022](https://openairdocs.org/ntsb/MKC72AK022.md): Piper PA-22 · Kenmare, ND · Accident · 2 fatal · Closed · Sep 30, 1971 · N8946D · Destroyed
- [NTSB NYC72FHM11](https://openairdocs.org/ntsb/NYC72FHM11.md): Piper PA-22 · Marlboro, NJ · Accident · No injuries · Closed · Sep 14, 1971 · N8940D · Substantial damage
- [NTSB MIA72AM021](https://openairdocs.org/ntsb/MIA72AM021.md): Piper PA-22 · Morris, AL · Accident · 2 fatal · Closed · Aug 29, 1971 · N8526D · Destroyed
- [NTSB NYC72DFJ14](https://openairdocs.org/ntsb/NYC72DFJ14.md): Piper PA-22 · Cicero, NY · Accident · No injuries · Closed · Aug 20, 1971 · N3269Z · Substantial damage
- [NTSB NYC72FID06](https://openairdocs.org/ntsb/NYC72FID06.md): Piper PA-22 · Montvale, VA · Accident · Serious injuries · Closed · Aug 18, 1971 · N8555D · Destroyed
- [NTSB NYC72DFA03](https://openairdocs.org/ntsb/NYC72DFA03.md): Piper PA-22 · Schroon Lake, NY · Accident · No injuries · Closed · Jul 31, 1971 · N3069Z · Substantial damage
- [NTSB NYC72AN001](https://openairdocs.org/ntsb/NYC72AN001.md): Piper PA-22 · Machias, NY · Accident · 3 fatal · Closed · Jul 3, 1971 · N9539D · Destroyed
- [NTSB CHI71DEM91](https://openairdocs.org/ntsb/CHI71DEM91.md): Piper PA-22 · Hubbard Lake, MI · Accident · No injuries · Closed · Jun 28, 1971 · N2904Z · Substantial damage
- [NTSB CHI71FEI64](https://openairdocs.org/ntsb/CHI71FEI64.md): Beech 35 · Shelby, OH · Accident · No injuries · Closed · Jun 20, 1971 · N2940V · 2 aircraft · Substantial damage
- [NTSB MIA71FKG84](https://openairdocs.org/ntsb/MIA71FKG84.md): Piper PA-22 · Hephzibah, GA · Accident · Minor injuries · Closed · May 18, 1971 · N3345Z · Substantial damage
- [NTSB FTW71DPA29](https://openairdocs.org/ntsb/FTW71DPA29.md): Piper PA-22 · Pottsboro, TX · Accident · No injuries · Closed · May 17, 1971 · N3618P · Substantial damage
- [NTSB NYC71FGT17](https://openairdocs.org/ntsb/NYC71FGT17.md): Piper PA-22 · Bloomsburg, PA · Accident · Minor injuries · Closed · May 7, 1971 · N3241Z · Substantial damage
- [NTSB LAX71DUG51](https://openairdocs.org/ntsb/LAX71DUG51.md): Piper PA-22 · Desert Cntr, CA · Accident · No injuries · Closed · Mar 11, 1971 · N8855D · Substantial damage
- [NTSB MKC71DDQ24](https://openairdocs.org/ntsb/MKC71DDQ24.md): Piper PA-22 · Camp Crook, SD · Accident · No injuries · Closed · Jan 29, 1971 · N9169D · Substantial damage
- [NTSB MIA71FLD45](https://openairdocs.org/ntsb/MIA71FLD45.md): Piper PA-22 · Sarasota, FL · Accident · No injuries · Closed · Jan 12, 1971 · N8521D · Substantial damage
- [NTSB MKC71FCD49](https://openairdocs.org/ntsb/MKC71FCD49.md): Piper PA-22 · Elkhart, IA · Accident · Minor injuries · Closed · Jan 10, 1971 · N8622D · Substantial damage
- [NTSB NYC71FHA25](https://openairdocs.org/ntsb/NYC71FHA25.md): Piper PA-22 · Basking Ridge, NJ · Accident · No injuries · Closed · Jan 3, 1971 · N8620D · 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") = 1971
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102214'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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