# NTSB investigations: Piper PA-28, CA

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 WPR16FA103](https://openairdocs.org/ntsb/WPR16FA103.md): Piper PA28 · Pomona, CA · Accident · Serious injuries · Field investigation · Final report · May 8, 2016 · N5046W · Substantial damage
  > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB LAX85LA242](https://openairdocs.org/ntsb/LAX85LA242.md): Piper PA-28-160 · Springville, CA · Accident · No injuries · Limited investigation · Final report · May 5, 1985 · N5166W · Substantial damage
  > After overflying the uncharted, private airstrip & evaluating its size, the PIC attempted to land on the narrow rwy. Only about 900 ft of the rwy was usable. After touching down, the plt realized the acft could not be stopped on the remaining available strip,…
- [NTSB OAK74AP067](https://openairdocs.org/ntsb/OAK74AP067.md): Piper PA-28 · Glen Ellen, CA · Accident · 2 fatal · Closed · Jun 14, 1974 · N8762W · Destroyed
- [NTSB OAK70FVM23](https://openairdocs.org/ntsb/OAK70FVM23.md): Piper PA-28 · San Jose, CA · Accident · No injuries · Closed · Jun 22, 1970 · N5385W · Substantial damage
- [NTSB LAX70FUQ21](https://openairdocs.org/ntsb/LAX70FUQ21.md): Piper PA-28 · Santa Susana, CA · Accident · No injuries · Closed · Apr 11, 1970 · N5046W · Substantial damage
- [NTSB OAK69D0063](https://openairdocs.org/ntsb/OAK69D0063.md): Piper PA-28 · Novato, CA · Accident · No injuries · Closed · Jul 27, 1968 · N5418W · Substantial damage
- [NTSB LAX66D0142](https://openairdocs.org/ntsb/LAX66D0142.md): Piper PA-28 · Ridgecrest, CA · Accident · No injuries · Closed · Sep 5, 1965 · N5333W · Substantial damage
- [NTSB LAX66D0086](https://openairdocs.org/ntsb/LAX66D0086.md): Piper PA-28 · Santa Susana, CA · Accident · No injuries · Closed · Aug 7, 1965 · N5046W · Substantial damage
- [NTSB OAK65F0066](https://openairdocs.org/ntsb/OAK65F0066.md): Piper PA28 · Vacaville, CA · Accident · Serious injuries · Closed · Apr 6, 1965 · N7761W · Substantial damage
- [NTSB LAX65F0045](https://openairdocs.org/ntsb/LAX65F0045.md): Piper PA-28 · Acton, CA · Accident · Serious injuries · Closed · Mar 28, 1965 · N6260W · Destroyed
- [NTSB OAK65A0055](https://openairdocs.org/ntsb/OAK65A0055.md): Piper PA28 · Hayward, CA · Accident · 4 fatal · Closed · Feb 13, 1965 · N7513W · Destroyed
- [NTSB UNK64X2295](https://openairdocs.org/ntsb/UNK64X2295.md): Piper PA-28 · Monterey, CA · Accident · 1 fatal · Closed · Jun 14, 1964 · N5384W · Destroyed

## 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102801'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102801&state=CA

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