# NTSB investigations: Piper PA-28-140 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 61 of 78 · 3,857 cases ## Cases, newest first - [NTSB SEA69A0058](https://openairdocs.org/ntsb/SEA69A0058.md): Piper PA-28 · Mcknzie Brdg, OR · Accident · 3 fatal · Closed · May 30, 1969 · N7133R · Destroyed - [NTSB NYC70D0004](https://openairdocs.org/ntsb/NYC70D0004.md): Piper PA-28 · Spring Valley, NY · Accident · No injuries · Closed · May 30, 1969 · N6389R · Substantial damage - [NTSB CHI70D0126](https://openairdocs.org/ntsb/CHI70D0126.md): Piper PA-28 · Monee, IL · Accident · No injuries · Closed · May 29, 1969 · N7352J · Substantial damage - [NTSB NYC70D0006](https://openairdocs.org/ntsb/NYC70D0006.md): Piper PA-28 · Canastota, NY · Accident · Minor injuries · Closed · May 28, 1969 · N6362W · Substantial damage - [NTSB CHI70F0088](https://openairdocs.org/ntsb/CHI70F0088.md): Piper PA-28 · Monticello, IL · Accident · No injuries · Closed · May 28, 1969 · N8250N · Substantial damage - [NTSB MIA70F0257](https://openairdocs.org/ntsb/MIA70F0257.md): Piper PA-28 · Moultrie, GA · Accident · No injuries · Closed · May 24, 1969 · N6465R · Substantial damage - [NTSB FTW70D0004](https://openairdocs.org/ntsb/FTW70D0004.md): Piper PA-28 · Vernon, TX · Accident · No injuries · Closed · May 24, 1969 · N9629W · Substantial damage - [NTSB CHI69D0666](https://openairdocs.org/ntsb/CHI69D0666.md): Piper PA-28 · Grayslake, IL · Accident · No injuries · Closed · May 23, 1969 · N8282N · Substantial damage - [NTSB LAX69D0367](https://openairdocs.org/ntsb/LAX69D0367.md): Piper PA-28 · Rialto, CA · Accident · No injuries · Closed · May 17, 1969 · N95264 · Substantial damage - [NTSB CHI69D0640](https://openairdocs.org/ntsb/CHI69D0640.md): Piper PA-28 · Princeton, IL · Accident · No injuries · Closed · May 14, 1969 · N6383R · Substantial damage - [NTSB NYC69D0445](https://openairdocs.org/ntsb/NYC69D0445.md): Piper PA-28 · Thomasville, PA · Accident · No injuries · Closed · May 10, 1969 · N4657R · Substantial damage - [NTSB MKC69F0420](https://openairdocs.org/ntsb/MKC69F0420.md): Piper PA-28 · Kanapolis, KS · Accident · No injuries · Closed · May 10, 1969 · N8048N · Substantial damage - [NTSB FTW69F0517](https://openairdocs.org/ntsb/FTW69F0517.md): Piper PA-28 · Haskell, OK · Accident · No injuries · Closed · May 10, 1969 · N5762F · Substantial damage - [NTSB DIA69D0204](https://openairdocs.org/ntsb/DIA69D0204.md): Piper PA-28 · College Park, MD · Accident · No injuries · Closed · May 10, 1969 · N6337W · Substantial damage - [NTSB MKC69A0058](https://openairdocs.org/ntsb/MKC69A0058.md): Piper PA-28 · Detroit Lake, MN · Accident · 1 fatal · Closed · May 8, 1969 · N9510W · Destroyed - [NTSB ANC70F0004](https://openairdocs.org/ntsb/ANC70F0004.md): Piper PA-28 · Auke Bay, AK · Accident · No injuries · Closed · May 8, 1969 · N8803N · Substantial damage - [NTSB CHI69D0617](https://openairdocs.org/ntsb/CHI69D0617.md): Piper PA-28 · Wayland, MI · Accident · No injuries · Closed · May 6, 1969 · N8211N · Substantial damage - [NTSB MIA69F0483](https://openairdocs.org/ntsb/MIA69F0483.md): Piper PA-28 · Chamblee, GA · Accident · No injuries · Closed · May 4, 1969 · N4668R · Substantial damage - [NTSB CHI69F0643](https://openairdocs.org/ntsb/CHI69F0643.md): Piper PA-28 · Detroit, MI · Accident · No injuries · Closed · May 4, 1969 · N1676J · Destroyed - [NTSB NYC69D0406](https://openairdocs.org/ntsb/NYC69D0406.md): Piper PA-28 · Mt Pocono, PA · Accident · No injuries · Closed · May 3, 1969 · N1793J · Substantial damage - [NTSB DIA69F0193](https://openairdocs.org/ntsb/DIA69F0193-182569.md): Piper PA-28 · Lottsburg, VA · Accident · No injuries · Closed · May 2, 1969 · N590R · Substantial damage - [NTSB LAX69F0362](https://openairdocs.org/ntsb/LAX69F0362.md): Piper PA-28 · Santa Ana, CA · Accident · No injuries · Closed · May 1, 1969 · N9832W · Substantial damage - [NTSB FTW69D0511](https://openairdocs.org/ntsb/FTW69D0511.md): Piper PA-28 · Eldorado, TX · Accident · No injuries · Closed · Apr 30, 1969 · N95160 · Substantial damage - [NTSB OAK69D0287](https://openairdocs.org/ntsb/OAK69D0287.md): Piper PA-28 · San Jose, CA · Accident · No injuries · Closed · Apr 29, 1969 · N5543F · Substantial damage - [NTSB NYC69F0425](https://openairdocs.org/ntsb/NYC69F0425.md): Piper PA-28 · Hershey, PA · Accident · Minor injuries · Closed · Apr 27, 1969 · N7384J · Substantial damage - [NTSB DEN69F0228](https://openairdocs.org/ntsb/DEN69F0228.md): Piper PA-28 · Albuquerque, NM · Accident · Minor injuries · Closed · Apr 26, 1969 · N6626W · Substantial damage - [NTSB CHI69F0636](https://openairdocs.org/ntsb/CHI69F0636.md): Piper PA-28 · E Palestine, OH · Accident · Minor injuries · Closed · Apr 26, 1969 · N8389R · Destroyed - [NTSB MKC69D0456](https://openairdocs.org/ntsb/MKC69D0456.md): Piper PA-28 · Ellinwood, KS · Accident · No injuries · Closed · Apr 23, 1969 · N6272W · Substantial damage - [NTSB OAK69D0294](https://openairdocs.org/ntsb/OAK69D0294.md): Piper PA-28 · Concord, CA · Accident · No injuries · Closed · Apr 21, 1969 · N6727J · Substantial damage - [NTSB NYC69D0412](https://openairdocs.org/ntsb/NYC69D0412.md): Piper PA-28 · Danbury, CT · Accident · No injuries · Closed · Apr 21, 1969 · N7243J · Substantial damage - [NTSB CHI69F0602](https://openairdocs.org/ntsb/CHI69F0602.md): Piper PA-28 · Grand Ledge, MI · Accident · No injuries · Closed · Apr 20, 1969 · N6440R · Substantial damage - [NTSB FTW69D0484](https://openairdocs.org/ntsb/FTW69D0484.md): Piper PA-28 · Abilene, TX · Accident · No injuries · Closed · Apr 19, 1969 · N3530K · Substantial damage - [NTSB DIA69D0178](https://openairdocs.org/ntsb/DIA69D0178.md): Piper PA-28 · Clinton, MD · Accident · No injuries · Closed · Apr 19, 1969 · N6077W · Substantial damage - [NTSB FTW69F0493](https://openairdocs.org/ntsb/FTW69F0493.md): Piper PA-28 · Okla.City, OK · Accident · No injuries · Closed · Apr 18, 1969 · N1895J · Substantial damage - [NTSB DEN69D0226](https://openairdocs.org/ntsb/DEN69D0226.md): Piper PA-28 · Sedalia, CO · Accident · No injuries · Closed · Apr 17, 1969 · N4145J · Substantial damage - [NTSB FTW69D0472](https://openairdocs.org/ntsb/FTW69D0472.md): Piper PA-28 · Oklahoma Cty, OK · Accident · Serious injuries · Closed · Apr 16, 1969 · N5588F · Minor damage - [NTSB MKC69D0436](https://openairdocs.org/ntsb/MKC69D0436.md): Piper J3C-65 · Olathe, KS · Accident · No injuries · Closed · Apr 13, 1969 · N65042 · 2 aircraft · Substantial damage - [NTSB MIA69A0066](https://openairdocs.org/ntsb/MIA69A0066.md): Piper PA-28 · Greeneville, TN · Accident · 1 fatal · Closed · Apr 13, 1969 · N5793F · Destroyed - [NTSB NYC69D0395](https://openairdocs.org/ntsb/NYC69D0395.md): Piper PA-28 · Orwigsburg, PA · Accident · No injuries · Closed · Apr 12, 1969 · N1750J · Substantial damage - [NTSB CHI69F0659](https://openairdocs.org/ntsb/CHI69F0659.md): Piper PA-28 · De Pere, WI · Accident · No injuries · Closed · Apr 12, 1969 · N1733J · Substantial damage - [NTSB DIA69F0174](https://openairdocs.org/ntsb/DIA69F0174.md): Piper PA-28 · Rock Hall, MD · Accident · No injuries · Closed · Apr 9, 1969 · N5113G · Substantial damage - [NTSB CHI69D0572](https://openairdocs.org/ntsb/CHI69D0572.md): Piper PA-28 · Wheeling, IL · Accident · No injuries · Closed · Apr 5, 1969 · N1862J · Substantial damage - [NTSB FTW69F0436](https://openairdocs.org/ntsb/FTW69F0436.md): Piper PA-28 · Baton Rouge, LA · Accident · No injuries · Closed · Apr 3, 1969 · N6761J · Substantial damage - [NTSB FTW69F0471](https://openairdocs.org/ntsb/FTW69F0471.md): Piper PA-28 · San Antonio, TX · Accident · No injuries · Closed · Mar 27, 1969 · N6555W · Substantial damage - [NTSB UNK69X0113](https://openairdocs.org/ntsb/UNK69X0113.md): Piper PA-28 · Rio Salado, Mexico · Accident · No injuries · Closed · Mar 25, 1969 · N4295J · Substantial damage - [NTSB NYC69F0424](https://openairdocs.org/ntsb/NYC69F0424.md): Piper PA-28 · Keeseville, NY · Accident · Serious injuries · Closed · Mar 25, 1969 · N1871J · Destroyed - [NTSB MKC69D0391](https://openairdocs.org/ntsb/MKC69D0391.md): Piper PA-28 · Fulton, MO · Accident · No injuries · Closed · Mar 25, 1969 · N5582F · Substantial damage - [NTSB CHI69D0577](https://openairdocs.org/ntsb/CHI69D0577.md): Piper PA-28 · Elyria, OH · Accident · No injuries · Closed · Mar 23, 1969 · N6407W · Substantial damage - [NTSB LAX69D0309](https://openairdocs.org/ntsb/LAX69D0309.md): Piper PA-28 · Lucerne Val, CA · Accident · Minor injuries · Closed · Mar 22, 1969 · N7377J · Substantial damage - [NTSB CHI69F0533](https://openairdocs.org/ntsb/CHI69F0533.md): Piper PA-28 · New Richmond, OH · Accident · No injuries · Closed · Mar 21, 1969 · N6782J · Substantial damage Next page: https://openairdocs.org/ntsb.md?model=7102802&page=62 ## 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 ('7102802')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?model=7102802&page=61 --- 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.