# NTSB investigations: Piper PA-18A 150, 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 LAX69F0178](https://openairdocs.org/ntsb/LAX69F0178.md): Piper PA-18A · Corona, CA · Accident · Serious injuries · Closed · Oct 19, 1968 · N3788P · Substantial damage
- [NTSB SEA69A0019](https://openairdocs.org/ntsb/SEA69A0019.md): Piper PA-18 · Sunnyside, WA · Accident · 2 fatal · Closed · Sep 5, 1968 · N2889P · Destroyed
- [NTSB FTW69D0140](https://openairdocs.org/ntsb/FTW69D0140.md): Piper PA-18 · Fabens, TX · Accident · No injuries · Closed · Aug 7, 1968 · N3971P · Substantial damage
- [NTSB MKC69D0108](https://openairdocs.org/ntsb/MKC69D0108.md): Piper PA-18A · Concordia, KS · Accident · No injuries · Closed · Aug 3, 1968 · N4891A · Destroyed
- [NTSB DEN69F0057](https://openairdocs.org/ntsb/DEN69F0057.md): Piper PA-18A · Yoder, WY · Accident · No injuries · Closed · Jul 9, 1968 · N9850D · Substantial damage
- [NTSB FTW69F0345](https://openairdocs.org/ntsb/FTW69F0345.md): Piper PA-18A · Breckenridge, TX · Accident · 1 fatal · Closed · Jun 24, 1968 · N9121D · Destroyed
- [NTSB FTW69F0031](https://openairdocs.org/ntsb/FTW69F0031.md): Piper PA-18A · Antlers, OK · Accident · 1 fatal · Closed · Jun 16, 1968 · N9902D · Destroyed
- [NTSB DEN68F0284](https://openairdocs.org/ntsb/DEN68F0284.md): Piper PA-18A · Montrose, CO · Accident · 1 fatal · Closed · Jun 7, 1968 · N3484Z · Destroyed
- [NTSB SEA69D0045](https://openairdocs.org/ntsb/SEA69D0045.md): Piper PA-18 · Carver, OR · Accident · No injuries · Closed · May 27, 1968 · N5881D · Substantial damage
- [NTSB DEN68F0281](https://openairdocs.org/ntsb/DEN68F0281.md): Piper PA-18A · Roswell, NM · Accident · No injuries · Closed · May 26, 1968 · N3776P · Destroyed
- [NTSB SEA68D0308](https://openairdocs.org/ntsb/SEA68D0308.md): Piper PA-18 · Pocatello, ID · Accident · No injuries · Closed · May 20, 1968 · N8489D · Substantial damage
- [NTSB DEN68F0274](https://openairdocs.org/ntsb/DEN68F0274.md): Piper PA-18 · Rifle, CO · Accident · Serious injuries · Closed · May 18, 1968 · N1870P · Substantial damage
- [NTSB SEA69F0022](https://openairdocs.org/ntsb/SEA69F0022.md): Piper PA-18 · Lowell, OR · Accident · Minor injuries · Closed · May 10, 1968 · N9073D · Substantial damage
- [NTSB FTW68F0568](https://openairdocs.org/ntsb/FTW68F0568.md): Piper PA-18A · Batesville, TX · Accident · 1 fatal · Closed · May 1, 1968 · N9465D · Destroyed
- [NTSB FTW68D0605](https://openairdocs.org/ntsb/FTW68D0605.md): Piper PA-18 · Charlotte, TX · Accident · Minor injuries · Closed · Apr 28, 1968 · N7669D · Substantial damage
- [NTSB LAX68D0394](https://openairdocs.org/ntsb/LAX68D0394.md): Piper PA-18 · Tehachapi, CA · Accident · Minor injuries · Closed · Apr 18, 1968 · N9470D · Destroyed
- [NTSB MIA68F0488](https://openairdocs.org/ntsb/MIA68F0488.md): Piper PA-18A · Savannah, GA · Accident · Serious injuries · Closed · Mar 28, 1968 · N8695D · Destroyed
- [NTSB FTW68A0081](https://openairdocs.org/ntsb/FTW68A0081.md): Piper PA-18A · Uvalde, TX · Accident · 1 fatal · Closed · Mar 23, 1968 · N3911Z · Destroyed
- [NTSB FTW68D0500](https://openairdocs.org/ntsb/FTW68D0500.md): Piper PA-18 · San Angelo, TX · Accident · No injuries · Closed · Mar 17, 1968 · N7382D · 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 ('7101837'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7101837&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.