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

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 CHI07FA026](https://openairdocs.org/ntsb/CHI07FA026.md): Piper PA-28-235 · Wellington, IL · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2006 · N8990W · Destroyed
  > Spatial disorientation experienced by the pilot while attempting to visually locate traffic during cruise flight, which resulted in a loss of aircraft control. Contributing factors were the inadvertent overload failure of the wing spar and stabilator, and the…
- [NTSB ANC06FA089](https://openairdocs.org/ntsb/ANC06FA089.md): Piper PA-28 · Manley Hot Spng, AK · Accident · 1 fatal · Field investigation · Final report · Jul 6, 2006 · N9026W · Destroyed
  > The pilot's continued cruise flight into known adverse weather conditions, his failure to maintain aircraft control while maneuvering, and his exceeding the design stress limits of the airplane, which resulted in an in-flight break-up. Factors associated with…
- [NTSB DEN06LA040](https://openairdocs.org/ntsb/DEN06LA040.md): Piper PA-28-235 · Torreon, NM · Accident · No injuries · Limited investigation · Final report · Feb 20, 2006 · N9149W · Substantial damage
  > The jammed magneto drive gear and the fractured camshaft gear, which resulted in the total engine failure. A factor contributing to the accident was the unsuitable dirt road on which the pilot had to force land the airplane.
- [NTSB LAX06FA082](https://openairdocs.org/ntsb/LAX06FA082.md): Piper PA-28-235 · Mammoth Lakes, CA · Accident · 2 fatal · Field investigation · Final report · Jan 8, 2006 · N9124W · Destroyed
  > the pilot's failure to maintain an adequate airspeed resulting in a stall/spin.

## 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") = 2006
  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=2006

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