# NTSB investigations: Piper PA-32RT-300, 2005

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 LAX06FA054](https://openairdocs.org/ntsb/LAX06FA054.md): Piper PA-32RT-300 · Kingsburg, CA · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2005 · N3039B · Destroyed
  > The pilot's in-flight decision to continue VFR flight into instrument meteorological conditions during descent, which resulted in an in-flight collision with trees and terrain. Fog, low ceiling, and obscuration were factors.
- [NTSB CHI05LA160](https://openairdocs.org/ntsb/CHI05LA160.md): Piper PA-32RT-300 · Kansas City, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 2005 · N21835 · Destroyed
  > The pilot not maintaining climb airspeed leading to the airplane's impact with the fence and terrain during takeoff. Factors in the accident were the pilot's inaccurate preflight planning calculations, the fence, and the levee.
- [NTSB CHI05CA093](https://openairdocs.org/ntsb/CHI05CA093.md): Piper PA-32RT-300 · St. Charles, MO · Accident · No injuries · Data collection · Final report · Apr 8, 2005 · N36691 · Substantial damage
  > The pilot's inadequate in-flight planning/decision by his failure to switch fuel tanks which resulted in fuel starvation and the loss of engine power. A factor was the trees.
- [NTSB DEN05FA066](https://openairdocs.org/ntsb/DEN05FA066.md): Piper PA-32RT-300 · Broomfield, CO · Accident · 1 fatal · Field investigation · Final report · Apr 7, 2005 · N3015L · Destroyed
  > the pilot's failure to maintain aircraft control during landing. Contributing factor's included the quartering tailwind, and the pilot's inadequate in-flight decision making.

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

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

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