# NTSB investigations: Piper PA-22 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. Page 8 of 9 · 404 cases ## Cases, newest first - [NTSB MKC66F0022](https://openairdocs.org/ntsb/MKC66F0022.md): Piper PA-22 · Detroit Lakes, MN · Accident · Minor injuries · Closed · Jun 3, 1965 · N806A · Substantial damage - [NTSB MKC66F0004](https://openairdocs.org/ntsb/MKC66F0004.md): Piper PA-22 · Imperial, NE · Accident · Serious injuries · Closed · May 28, 1965 · N2661P · Destroyed - [NTSB FTW66F0074](https://openairdocs.org/ntsb/FTW66F0074.md): Piper PA-22 · Breckenridge, TX · Accident · Minor injuries · Closed · May 20, 1965 · N1401A · Substantial damage - [NTSB DEN65F0057](https://openairdocs.org/ntsb/DEN65F0057.md): Piper PA-22 · Beryl Junction, UT · Accident · Minor injuries · Closed · Apr 24, 1965 · N994A · Destroyed - [NTSB UNK65X1488](https://openairdocs.org/ntsb/UNK65X1488.md): Piper PA22 · Portales, NM · Accident · Serious injuries · Closed · Apr 19, 1965 · N3682A · Destroyed - [NTSB SEA65A0051](https://openairdocs.org/ntsb/SEA65A0051.md): Piper PA-22 · Anaconda, MT · Accident · 1 fatal · Closed · Apr 16, 1965 · N1714P · Destroyed - [NTSB SEA65D0052](https://openairdocs.org/ntsb/SEA65D0052-201585.md): Piper PA-22 · Bellevue, WA · Accident · No injuries · Closed · Mar 25, 1965 · N2475A · Substantial damage - [NTSB MIA65F0020](https://openairdocs.org/ntsb/MIA65F0020.md): Piper PA-22 · Whitsett, NC · Accident · No injuries · Closed · Mar 22, 1965 · N893A · Substantial damage - [NTSB FTW66F0068](https://openairdocs.org/ntsb/FTW66F0068.md): Piper PA-22 · Morse, TX · Accident · No injuries · Closed · Feb 26, 1965 · N9237D · Substantial damage - [NTSB DEN65F0029](https://openairdocs.org/ntsb/DEN65F0029.md): Piper PA-22 · Tucson, AZ · Accident · Serious injuries · Closed · Feb 24, 1965 · N5213Z · Destroyed - [NTSB SEA65D0030](https://openairdocs.org/ntsb/SEA65D0030.md): Piper PA-22 · Great Falls, MT · Accident · No injuries · Closed · Feb 17, 1965 · N2346P · Substantial damage - [NTSB NYC65F0013](https://openairdocs.org/ntsb/NYC65F0013.md): Piper PA22 · Ansonia, CT · Accident · No injuries · Closed · Feb 14, 1965 · N1455A · Substantial damage - [NTSB SEA65F0012](https://openairdocs.org/ntsb/SEA65F0012.md): Piper PA-22 · Lake Oswego, OR · Accident · No injuries · Closed · Feb 13, 1965 · N1744A · Substantial damage - [NTSB CHI65D0016](https://openairdocs.org/ntsb/CHI65D0016.md): Piper PA-22 · Xenia, OH · Accident · No injuries · Closed · Feb 6, 1965 · N5041Z · Substantial damage - [NTSB DEN65D0012](https://openairdocs.org/ntsb/DEN65D0012.md): Piper PA22 · Gillette, WY · Accident · No injuries · Closed · Feb 4, 1965 · N1668A · Substantial damage - [NTSB NYC65F0009](https://openairdocs.org/ntsb/NYC65F0009.md): Piper PA22 · Somerset, PA · Accident · No injuries · Closed · Jan 30, 1965 · N1704A · Substantial damage - [NTSB CHI65F0189](https://openairdocs.org/ntsb/CHI65F0189.md): Piper PA-22 · Donovan, IL · Accident · No injuries · Closed · Jan 26, 1965 · N3307B · Substantial damage - [NTSB CHI65F0156](https://openairdocs.org/ntsb/CHI65F0156.md): Piper PA-22 · Danville, IL · Accident · No injuries · Closed · Jan 21, 1965 · N8649C · Substantial damage - [NTSB UNK65X1264](https://openairdocs.org/ntsb/UNK65X1264.md): Piper PA22 · Selma, CA · Accident · No injuries · Closed · Jan 10, 1965 · N684A · Substantial damage - [NTSB UNK65X1193](https://openairdocs.org/ntsb/UNK65X1193.md): Piper PA-22 · Pelham, TN · Accident · 5 fatal · Closed · Dec 30, 1964 · N8655D · Destroyed - [NTSB UNK65X1053](https://openairdocs.org/ntsb/UNK65X1053.md): Piper PA22 · Marshfield, WI · Accident · No injuries · Closed · Dec 19, 1964 · N940A · Substantial damage - [NTSB UNK65X0890](https://openairdocs.org/ntsb/UNK65X0890.md): Piper PA22 · St Marys, PA · Accident · Serious injuries · Closed · Nov 30, 1964 · N8616C · Destroyed - [NTSB UNK65X0851](https://openairdocs.org/ntsb/UNK65X0851.md): Piper PA-22 · Guinda, CA · Accident · 1 fatal · Closed · Nov 27, 1964 · N8696C · Destroyed - [NTSB UNK65X0685](https://openairdocs.org/ntsb/UNK65X0685.md): Piper PA-22 · Bedminster, NJ · Accident · No injuries · Closed · Nov 13, 1964 · N4533Z · Substantial damage - [NTSB UNK65X0465](https://openairdocs.org/ntsb/UNK65X0465.md): Piper PA-22 · Strasburg, OH · Accident · Serious injuries · Closed · Oct 28, 1964 · N3607P · Destroyed - [NTSB UNK65X0249](https://openairdocs.org/ntsb/UNK65X0249.md): Piper PA22 · Wiscasset, ME · Accident · Serious injuries · Closed · Oct 11, 1964 · N5606Z · Destroyed - [NTSB UNK64X4190](https://openairdocs.org/ntsb/UNK64X4190.md): Piper PA-22 · Osage City, KS · Accident · No injuries · Closed · Sep 28, 1964 · N1814A · Substantial damage - [NTSB UNK64X4044](https://openairdocs.org/ntsb/UNK64X4044.md): Piper PA-22 · Zaragoza, Mexico · Accident · Minor injuries · Closed · Sep 19, 1964 · N1646A · Destroyed - [NTSB UNK64X3997](https://openairdocs.org/ntsb/UNK64X3997.md): Piper PA22 · Norwood, CO · Accident · No injuries · Closed · Sep 15, 1964 · N1713P · Substantial damage - [NTSB UNK64X3884](https://openairdocs.org/ntsb/UNK64X3884.md): Piper PA22 · Melbourne, AR · Accident · Minor injuries · Closed · Sep 9, 1964 · N678A · Substantial damage - [NTSB UNK64X3072](https://openairdocs.org/ntsb/UNK64X3072.md): Piper PA22 · Dinmitt, TX · Accident · No injuries · Closed · Jul 27, 1964 · N8830C · Substantial damage - [NTSB UNK64X3066](https://openairdocs.org/ntsb/UNK64X3066.md): Piper PA22 · Liberty, NC · Accident · No injuries · Closed · Jul 27, 1964 · N3962P · Destroyed - [NTSB UNK64X3024](https://openairdocs.org/ntsb/UNK64X3024.md): Piper PA22 · Loon Creek, ID · Accident · Serious injuries · Closed · Jul 25, 1964 · N2676A · Destroyed - [NTSB UNK64X2810](https://openairdocs.org/ntsb/UNK64X2810.md): Piper PA22 · Iola, IL · Accident · No injuries · Closed · Jul 13, 1964 · N879A · Substantial damage - [NTSB UNK64X2785](https://openairdocs.org/ntsb/UNK64X2785.md): Piper PA22 · Joshua Tree, CA · Accident · No injuries · Closed · Jul 12, 1964 · N1410A · Substantial damage - [NTSB UNK64X2727](https://openairdocs.org/ntsb/UNK64X2727.md): Piper PA22 · Annapolis, MD · Accident · No injuries · Closed · Jul 9, 1964 · N1429A · Substantial damage - [NTSB UNK64X2636](https://openairdocs.org/ntsb/UNK64X2636.md): Piper PA22 · Green River, UT · Accident · No injuries · Closed · Jul 4, 1964 · N1448C · Substantial damage - [NTSB UNK64X2403](https://openairdocs.org/ntsb/UNK64X2403.md): Piper PA22 · Redding, CA · Accident · 3 fatal · Closed · Jun 20, 1964 · N3733A · Substantial damage - [NTSB UNK64X2385](https://openairdocs.org/ntsb/UNK64X2385.md): Piper PA22 · Satanta, KS · Accident · No injuries · Closed · Jun 20, 1964 · N3735A · Substantial damage - [NTSB UNK64X2201](https://openairdocs.org/ntsb/UNK64X2201.md): Piper PA22 · Chicago, IL · Accident · No injuries · Closed · Jun 9, 1964 · N653A · Substantial damage - [NTSB UNK64X1996](https://openairdocs.org/ntsb/UNK64X1996.md): Piper PA22 · W Mifflin, PA · Accident · Minor injuries · Closed · May 28, 1964 · N644A · Substantial damage - [NTSB UNK64X1948](https://openairdocs.org/ntsb/UNK64X1948.md): Piper PA22 · Eads, CO · Accident · No injuries · Closed · May 25, 1964 · N8850D · Substantial damage - [NTSB UNK64X1820](https://openairdocs.org/ntsb/UNK64X1820.md): Piper PA22 · El Dorado, KS · Accident · No injuries · Closed · May 18, 1964 · N892A · Substantial damage - [NTSB UNK64X1324](https://openairdocs.org/ntsb/UNK64X1324.md): Piper PA22 · Crescent, OR · Accident · No injuries · Closed · Apr 15, 1964 · N934A · Substantial damage - [NTSB UNK64X1097](https://openairdocs.org/ntsb/UNK64X1097.md): Piper PA22 · Cecil, GA · Accident · Minor injuries · Closed · Mar 29, 1964 · N962A · Substantial damage - [NTSB UNK64X1022](https://openairdocs.org/ntsb/UNK64X1022.md): Piper PA22 · Gage, OK · Accident · No injuries · Closed · Mar 23, 1964 · N1456A · Substantial damage - [NTSB UNK64X0768](https://openairdocs.org/ntsb/UNK64X0768.md): Piper PA22 · St Joseph, MO · Accident · No injuries · Closed · Mar 1, 1964 · N1422C · Substantial damage - [NTSB UNK64X0652](https://openairdocs.org/ntsb/UNK64X0652.md): Piper PA22 · Indianapolis, IN · Accident · No injuries · Closed · Feb 22, 1964 · N3314A · Substantial damage - [NTSB UNK64X0493](https://openairdocs.org/ntsb/UNK64X0493.md): Piper PA22 · Weaver, AL · Accident · No injuries · Closed · Feb 8, 1964 · N1804A · Substantial damage - [NTSB UNK64X0382](https://openairdocs.org/ntsb/UNK64X0382.md): Piper PA22 · Aleknacik, AK · Accident · No injuries · Closed · Jan 27, 1964 · N3319A · Substantial damage Next page: https://openairdocs.org/ntsb.md?model=7102202&page=9 ## 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."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&page=8 --- 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.