# NTSB investigations: Piper PA-22-108 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 15 · 709 cases ## Cases, newest first - [NTSB CHI68F0545](https://openairdocs.org/ntsb/CHI68F0545-112197.md): Piper PA-22 · Lexington, KY · Accident · No injuries · Closed · Jan 16, 1968 · N5927Z · Substantial damage - [NTSB CHI68D0667](https://openairdocs.org/ntsb/CHI68D0667.md): Piper PA-22 · Bucyrus, OH · Accident · No injuries · Closed · Jan 14, 1968 · N5553Z · Substantial damage - [NTSB OAK68D0314](https://openairdocs.org/ntsb/OAK68D0314.md): Piper PA-22 · Travis Afb, CA · Accident · No injuries · Closed · Dec 21, 1967 · N4901Z · Substantial damage - [NTSB MKC68D0426](https://openairdocs.org/ntsb/MKC68D0426.md): Piper PA-22 · Fayette, MO · Accident · No injuries · Closed · Dec 13, 1967 · N5969Z · Substantial damage - [NTSB SEA68D0232](https://openairdocs.org/ntsb/SEA68D0232.md): Piper PA-22 · Oak Harbor, WA · Accident · No injuries · Closed · Dec 3, 1967 · N5017Z · Substantial damage - [NTSB DIA68F0131](https://openairdocs.org/ntsb/DIA68F0131.md): Piper PA-22 · Odenton, MD · Accident · No injuries · Closed · Nov 26, 1967 · N5974Z · Substantial damage - [NTSB MKC68F0313](https://openairdocs.org/ntsb/MKC68F0313.md): Piper PA-22 · St.Charles, MO · Accident · No injuries · Closed · Nov 4, 1967 · N4708Z · Substantial damage - [NTSB CHI68D0399](https://openairdocs.org/ntsb/CHI68D0399.md): Piper PA-22 · English, IN · Accident · No injuries · Closed · Oct 30, 1967 · N5797Z · Destroyed - [NTSB MIA68D0217](https://openairdocs.org/ntsb/MIA68D0217.md): Piper PA-22 · San Juan, PR · Accident · No injuries · Closed · Oct 14, 1967 · N5611Z · Substantial damage - [NTSB CHI68F0303](https://openairdocs.org/ntsb/CHI68F0303.md): Piper PA-22 · Plymouth, MI · Accident · No injuries · Closed · Oct 11, 1967 · N5100Z · Substantial damage - [NTSB FTW68D0267](https://openairdocs.org/ntsb/FTW68D0267.md): Piper PA-22 · Manila, AR · Accident · No injuries · Closed · Oct 4, 1967 · N5031Z · Substantial damage - [NTSB CHI68D0299](https://openairdocs.org/ntsb/CHI68D0299.md): Piper PA-22 · Worthington, KY · Accident · No injuries · Closed · Sep 24, 1967 · N4882Z · Substantial damage - [NTSB MIA68F0218](https://openairdocs.org/ntsb/MIA68F0218.md): Piper PA-22 · Humacao, PR · Accident · No injuries · Closed · Sep 23, 1967 · N5278Z · Substantial damage - [NTSB NYC68D0184](https://openairdocs.org/ntsb/NYC68D0184.md): Piper PA-22 · West Chester, PA · Accident · Minor injuries · Closed · Sep 11, 1967 · N5014Z · Substantial damage - [NTSB CHI68D0357](https://openairdocs.org/ntsb/CHI68D0357.md): Piper PA-22 · Lombard, IL · Accident · No injuries · Closed · Sep 4, 1967 · N5822Z · Substantial damage - [NTSB NYC68F0125](https://openairdocs.org/ntsb/NYC68F0125.md): Piper PA-22 · Butler, PA · Accident · No injuries · Closed · Aug 13, 1967 · N5895Z · Substantial damage - [NTSB NYC68D0117](https://openairdocs.org/ntsb/NYC68D0117.md): Piper PA-22 · Augusta, ME · Accident · No injuries · Closed · Aug 11, 1967 · N5042Z · Substantial damage - [NTSB MKC68D0098](https://openairdocs.org/ntsb/MKC68D0098.md): Piper PA-22 · Des Moines, IA · Accident · No injuries · Closed · Aug 3, 1967 · N4526Z · Substantial damage - [NTSB MIA68D0079](https://openairdocs.org/ntsb/MIA68D0079.md): Piper PA-22 · Orlando, FL · Accident · No injuries · Closed · Jul 20, 1967 · N5388Z · Substantial damage - [NTSB FTW68F0115](https://openairdocs.org/ntsb/FTW68F0115.md): Piper PA-22 · Texas City, TX · Accident · No injuries · Closed · Jul 15, 1967 · N5501Z · Substantial damage - [NTSB ANC68D0015](https://openairdocs.org/ntsb/ANC68D0015.md): Piper PA-22 · Galena, AK · Accident · No injuries · Closed · Jul 13, 1967 · N5110Z · Substantial damage - [NTSB NYC68F0064](https://openairdocs.org/ntsb/NYC68F0064.md): Piper PA-22 · Seneca Falls, NY · Accident · Minor injuries · Closed · Jul 8, 1967 · N4963Z · Destroyed - [NTSB CHI68D0251](https://openairdocs.org/ntsb/CHI68D0251.md): Piper PA-22 · Urbana, IL · Accident · No injuries · Closed · Jul 1, 1967 · N5732Z · Substantial damage - [NTSB CHI68F0102](https://openairdocs.org/ntsb/CHI68F0102.md): Piper PA-22 · Wilmington, OH · Accident · Minor injuries · Closed · Jun 30, 1967 · N5171Z · Substantial damage - [NTSB CHI68F0003](https://openairdocs.org/ntsb/CHI68F0003.md): Piper PA-22 · Columbus, OH · Accident · Minor injuries · Closed · Jun 14, 1967 · N4682Z · Substantial damage - [NTSB CHI68D0056](https://openairdocs.org/ntsb/CHI68D0056.md): Piper PA-22 · Midlothian, IL · Accident · No injuries · Closed · Jun 8, 1967 · N5473Z · Substantial damage - [NTSB CHI67F0650](https://openairdocs.org/ntsb/CHI67F0650.md): Piper PA-22 · Nashport, OH · Accident · No injuries · Closed · May 29, 1967 · N5507Z · Substantial damage - [NTSB CHI68F0006](https://openairdocs.org/ntsb/CHI68F0006.md): Piper PA-22 · Greenville, MI · Accident · 1 fatal · Closed · May 26, 1967 · N5516Z · Destroyed - [NTSB CHI68D0038](https://openairdocs.org/ntsb/CHI68D0038.md): Piper PA-23 · Elgin, IL · Accident · No injuries · Closed · May 24, 1967 · N5902Z · Substantial damage - [NTSB MKC67D0607](https://openairdocs.org/ntsb/MKC67D0607.md): Piper PA-22 · St.Paul, MN · Accident · No injuries · Closed · May 11, 1967 · N5193Z · Substantial damage - [NTSB NYC68D0057](https://openairdocs.org/ntsb/NYC68D0057.md): Piper PA-22 · Amherst, NY · Accident · No injuries · Closed · May 7, 1967 · N5888Z · Substantial damage - [NTSB NYC67F0677](https://openairdocs.org/ntsb/NYC67F0677.md): Piper PA-22 · Liberty, NY · Accident · No injuries · Closed · May 5, 1967 · N5802Z · Substantial damage - [NTSB NYC67F0652](https://openairdocs.org/ntsb/NYC67F0652.md): Piper PA-22 · Old Town, ME · Accident · No injuries · Closed · May 4, 1967 · N4529Z · Substantial damage - [NTSB MKC67D0571](https://openairdocs.org/ntsb/MKC67D0571.md): Piper PA-22 · Ankeny, IA · Accident · No injuries · Closed · May 1, 1967 · N4526Z · Substantial damage - [NTSB MIA67D0510](https://openairdocs.org/ntsb/MIA67D0510.md): Piper PA-22 · Clewiston, FL · Accident · No injuries · Closed · Apr 30, 1967 · N5399Z · Substantial damage - [NTSB MIA67F0497](https://openairdocs.org/ntsb/MIA67F0497.md): Piper PA-22 · Augusta, GA · Accident · No injuries · Closed · Apr 9, 1967 · N4972Z · Substantial damage - [NTSB ANC67D0098](https://openairdocs.org/ntsb/ANC67D0098.md): Piper PA-22 · Fairbanks, AK · Accident · No injuries · Closed · Apr 9, 1967 · N4981Z · Substantial damage - [NTSB DIA67D0067](https://openairdocs.org/ntsb/DIA67D0067.md): Piper PA-22 · Winston-Salem, NC · Accident · No injuries · Closed · Apr 8, 1967 · N5837Z · Substantial damage - [NTSB MIA68F0189](https://openairdocs.org/ntsb/MIA68F0189.md): Piper PA-22 · West Columbia, SC · Accident · No injuries · Closed · Apr 7, 1967 · N5880Z · Substantial damage - [NTSB CHI67D0643](https://openairdocs.org/ntsb/CHI67D0643.md): Piper PA-22 · Spiceland, IN · Accident · No injuries · Closed · Apr 7, 1967 · N5070Z · Substantial damage - [NTSB FTW67D0513](https://openairdocs.org/ntsb/FTW67D0513.md): Piper PA-22 · Walnut Ridge, AR · Accident · No injuries · Closed · Apr 2, 1967 · N4885Z · Substantial damage - [NTSB CHI67D0566](https://openairdocs.org/ntsb/CHI67D0566.md): Piper PA-22 · Greenville, OH · Accident · Minor injuries · Closed · Apr 2, 1967 · N5704Z · Substantial damage - [NTSB DIA67D0075](https://openairdocs.org/ntsb/DIA67D0075.md): Piper PA-22 · Patuxent Nas, MD · Accident · No injuries · Closed · Mar 27, 1967 · N5730Z · Substantial damage - [NTSB CHI67D0524](https://openairdocs.org/ntsb/CHI67D0524.md): Piper PA-22 · Eleva, WI · Accident · No injuries · Closed · Mar 14, 1967 · N5315Z · Substantial damage - [NTSB OAK67D0236](https://openairdocs.org/ntsb/OAK67D0236.md): Piper PA-22 · Honolulu, HI · Accident · No injuries · Closed · Mar 9, 1967 · N4711Z · Substantial damage - [NTSB MKC67F0529](https://openairdocs.org/ntsb/MKC67F0529.md): Piper PA-22 · St.Paul, MN · Accident · No injuries · Closed · Mar 9, 1967 · N4599Z · Destroyed - [NTSB CHI67D0560](https://openairdocs.org/ntsb/CHI67D0560.md): Piper PA-22 · Hinsdale, IL · Accident · No injuries · Closed · Feb 26, 1967 · N5864Z · Substantial damage - [NTSB OAK67D0243](https://openairdocs.org/ntsb/OAK67D0243.md): Piper PA-22 · Clearlake, CA · Accident · Minor injuries · Closed · Feb 19, 1967 · N4996Z · Substantial damage - [NTSB ANC67F0080](https://openairdocs.org/ntsb/ANC67F0080.md): Piper PA-22 · Fairbanks, AK · Accident · No injuries · Closed · Feb 19, 1967 · N5110Z · Substantial damage - [NTSB MKC67D0501](https://openairdocs.org/ntsb/MKC67D0501.md): Piper PA-22 · Whte Bear Lk, MN · Accident · No injuries · Closed · Feb 14, 1967 · N5193Z · Substantial damage Next page: https://openairdocs.org/ntsb.md?model=7102204&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 ('7102204')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?model=7102204&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.