# NTSB investigations: Piper PA-28-201T, 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 LAX89FA178](https://openairdocs.org/ntsb/LAX89FA178.md): Piper PA-28-201T · Stockton, CA · Accident · 1 fatal · Field investigation · Final report · May 4, 1989 · N8133A · Destroyed
  > The pilot's improper decision to perform aerobatics which resulted in the design stress limits of the airplane being exceeded due to excessive airspeed. Contributing factors to the accident were the pilot's overconfidence in his and the airplane's ability,…
- [NTSB LAX86FA061](https://openairdocs.org/ntsb/LAX86FA061.md): Piper PA-28-201T · So. Lake Tahoe, CA · Accident · 3 fatal · Field investigation · Final report · Dec 9, 1985 · N2854R · Destroyed
  > Prior to departing on a VFR flt from south lake Tahoe, CA, to tracy, CA, the plt failed to obtain a wx briefing or file a flt plan. Wx at the arpt of departure was reported as scattered clouds at 1500 ft, broken ceiling conditions at an estimated 3000 ft,…
- [NTSB LAX82DA176](https://openairdocs.org/ntsb/LAX82DA176.md): Piper PA-28-201T · Van Nuys, CA · Accident · No injuries · Final report · May 16, 1982 · N8089N · Substantial damage
  > During flight at about 1500 ft, the engine suddenly lost power and the propeller stopped turning. The pilot attempted a restart, but the starter would not turn the propeller. The pilot maneuvered to make a forced landing at the Van Nuys airport. The aircraft…
- [NTSB LAX82DA120](https://openairdocs.org/ntsb/LAX82DA120.md): Piper PA-28-201T · Auberry, CA · Accident · No injuries · Final report · Mar 24, 1982 · N2861H · Substantial damage
  > During landing, the pilot rolled to the left side of the runway to avoid possible potholes. After steering to the left side, the left main gear encountered a small berm and the aircraft veered further left. The nosewheel hit the berm and the nose gear…

## 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 ('7102819'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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