# NTSB investigations: Piper PA-28-235, 1968

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 FTW69D0012](https://openairdocs.org/ntsb/FTW69D0012-201675.md): Piper PA-28 · Mulege, Mexico · Accident · No injuries · Closed · Dec 30, 1968 · N166DP · Substantial damage
- [NTSB SEA69D0164](https://openairdocs.org/ntsb/SEA69D0164.md): Piper PA-28 · Duvall, WA · Accident · Minor injuries · Closed · Dec 6, 1968 · N9347W · Destroyed
- [NTSB NYC69D0275](https://openairdocs.org/ntsb/NYC69D0275.md): Piper PA-28 · Chester, CT · Accident · Minor injuries · Closed · Nov 28, 1968 · N8891W · Substantial damage
- [NTSB MKC69F0231](https://openairdocs.org/ntsb/MKC69F0231.md): Piper PA-28 · Ottumwa, IA · Accident · No injuries · Closed · Oct 20, 1968 · N8701W · Substantial damage
- [NTSB MKC69F0236](https://openairdocs.org/ntsb/MKC69F0236.md): Piper PA-28 · Western, NE · Accident · No injuries · Closed · Oct 17, 1968 · N9419W · Substantial damage
- [NTSB MKC69A0023](https://openairdocs.org/ntsb/MKC69A0023.md): Piper PA-28 · Osceola, IA · Accident · 2 fatal · Closed · Oct 13, 1968 · N9176W · Destroyed
- [NTSB SEA69D0128](https://openairdocs.org/ntsb/SEA69D0128.md): Piper PA-28 · Spanaway, WA · Accident · No injuries · Closed · Sep 24, 1968 · N9265W · Substantial damage
- [NTSB NYC69F0201](https://openairdocs.org/ntsb/NYC69F0201.md): Piper PA-28 · Canandaigua, NY · Accident · No injuries · Closed · Sep 22, 1968 · N8809W · Substantial damage
- [NTSB DIA69F0063](https://openairdocs.org/ntsb/DIA69F0063.md): Piper PA-28 · Charlotte, NC · Accident · No injuries · Closed · Sep 15, 1968 · N8805W · Substantial damage
- [NTSB CHI69F0511](https://openairdocs.org/ntsb/CHI69F0511.md): Piper PA-28 · Monticello, IL · Accident · Serious injuries · Closed · Sep 12, 1968 · N9114W · Substantial damage
- [NTSB NYC69A0030](https://openairdocs.org/ntsb/NYC69A0030.md): Cessna 402 · Flushing, NY · Accident · 2 fatal · Closed · Sep 8, 1968 · N8283F · 2 aircraft · Substantial damage
- [NTSB NYC69D0168](https://openairdocs.org/ntsb/NYC69D0168.md): Piper PA-25 · Bridgton, ME · Accident · No injuries · Closed · Sep 2, 1968 · N8941W · Substantial damage
- [NTSB NYC69D0188](https://openairdocs.org/ntsb/NYC69D0188.md): Piper PA-28 · Jackman, ME · Accident · Minor injuries · Closed · Aug 25, 1968 · N8543W · Substantial damage
- [NTSB SEA69D0080](https://openairdocs.org/ntsb/SEA69D0080.md): Piper PA-28 · Oakley, ID · Accident · No injuries · Closed · Jul 30, 1968 · N9163W · Substantial damage
- [NTSB MKC69D0100](https://openairdocs.org/ntsb/MKC69D0100.md): Piper PA-28 · Clearwater, NE · Accident · No injuries · Closed · Jul 30, 1968 · N9150W · Substantial damage
- [NTSB CHI69D0204](https://openairdocs.org/ntsb/CHI69D0204.md): Piper PA-28 · Tiffin, OH · Accident · Minor injuries · Closed · Jul 16, 1968 · N8658W · Substantial damage
- [NTSB SEA69D0033](https://openairdocs.org/ntsb/SEA69D0033.md): Piper PA-28 · Sekiu, WA · Accident · No injuries · Closed · Jul 15, 1968 · N8819W · Substantial damage
- [NTSB FTW69A0003](https://openairdocs.org/ntsb/FTW69A0003.md): Piper PA-28 · Dryden, TX · Accident · 4 fatal · Closed · Jul 13, 1968 · N9092W · Destroyed
- [NTSB DEN69D0032](https://openairdocs.org/ntsb/DEN69D0032.md): Piper PA-28 · Holyoke, CO · Accident · No injuries · Closed · Jun 20, 1968 · N9167W · Substantial damage
- [NTSB SEA69F0081](https://openairdocs.org/ntsb/SEA69F0081.md): Piper PA-28 · Westport, WA · Case · Closed · Jun 18, 1968 · N8518W
- [NTSB DEN68D0278](https://openairdocs.org/ntsb/DEN68D0278.md): Piper PA-28 · Delta, UT · Accident · No injuries · Closed · Jun 1, 1968 · N9250W · Substantial damage
- [NTSB OAK69F0039](https://openairdocs.org/ntsb/OAK69F0039.md): Piper PA-28 · San Francisco, CA · Accident · No injuries · Closed · May 30, 1968 · N9238W · Substantial damage
- [NTSB MIA68F0528](https://openairdocs.org/ntsb/MIA68F0528.md): Piper PA-28 · Marietta, GA · Accident · No injuries · Closed · May 22, 1968 · N8914W · Substantial damage
- [NTSB DEN69D0022](https://openairdocs.org/ntsb/DEN69D0022.md): Piper PA-28 · Calhan, CO · Accident · Serious injuries · Closed · May 21, 1968 · N136F · Substantial damage
- [NTSB MIA69F0038](https://openairdocs.org/ntsb/MIA69F0038.md): Piper PA-28 · Vero Beach, FL · Accident · Serious injuries · Closed · May 19, 1968 · N9301W · Substantial damage
- [NTSB LAX68F0385](https://openairdocs.org/ntsb/LAX68F0385.md): Piper PA-28 · Santa Paula, CA · Accident · No injuries · Closed · Mar 28, 1968 · N8555W · Substantial damage
- [NTSB MKC68D0496](https://openairdocs.org/ntsb/MKC68D0496.md): Piper PA-28 · Oakes, ND · Accident · No injuries · Closed · Feb 27, 1968 · N8687W · Substantial damage
- [NTSB CHI68D0616](https://openairdocs.org/ntsb/CHI68D0616.md): Piper PA-28 · Lafayette, IN · Accident · No injuries · Closed · Feb 24, 1968 · N8537W · Substantial damage
- [NTSB NYC68F0392](https://openairdocs.org/ntsb/NYC68F0392.md): Piper PA-28 · Shrewsbury, NJ · Accident · No injuries · Closed · Feb 16, 1968 · N9136W · Substantial damage
- [NTSB CHI68D0626](https://openairdocs.org/ntsb/CHI68D0626.md): Piper PA-28 · Sunman, IN · Accident · No injuries · Closed · Feb 14, 1968 · N8777W · Substantial damage
- [NTSB DEN68D0206](https://openairdocs.org/ntsb/DEN68D0206.md): Piper PA-28 · Portales, NM · Accident · No injuries · Closed · Jan 28, 1968 · N8545W · Substantial damage
- [NTSB NYC68D0355](https://openairdocs.org/ntsb/NYC68D0355.md): Piper PA-28 · Beverly, MA · Accident · No injuries · Closed · Jan 23, 1968 · N9241W · Substantial damage
- [NTSB LAX68D0300](https://openairdocs.org/ntsb/LAX68D0300.md): Piper PA-28 · Imperial, CA · Accident · No injuries · Closed · Jan 18, 1968 · N8576W · Substantial damage
- [NTSB CHI68F0571](https://openairdocs.org/ntsb/CHI68F0571.md): Piper PA-28 · Bluffton, OH · Accident · No injuries · Closed · Jan 18, 1968 · N8631W · 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") = 1968
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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