# NTSB investigations: Piper PA-34-200T, 2007

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 LAX08CA014](https://openairdocs.org/ntsb/LAX08CA014.md): Piper PA-34-200T · Napa, CA · Accident · No injuries · Data collection · Final report · Nov 11, 2007 · N3038P · Substantial damage
  > The pilot's failure to latch the cargo door during preflight.
- [NTSB NYC07CA213](https://openairdocs.org/ntsb/NYC07CA213.md): Piper PA-34-200T · Wilmington, DE · Accident · No injuries · Data collection · Final report · Sep 3, 2007 · N251AS · Substantial damage
  > The pilot's improper flare, which resulted in a hard landing. A factor to the accident was the wind gust.
- [NTSB LAX07CA243](https://openairdocs.org/ntsb/LAX07CA243.md): Piper PA-34-200T · Big Creek, ID · Accident · No injuries · Data collection · Final report · Aug 4, 2007 · N9356K · Substantial damage
  > The pilot's misjudgment of distance and speed, which led to a long landing, and his delayed application of brakes that resulted in long landing and a runway overrun.
- [NTSB NYC07CA156](https://openairdocs.org/ntsb/NYC07CA156.md): Piper PA-34-200 · Fort Lauderdale, FL · Accident · No injuries · Data collection · Final report · Jul 2, 2007 · N500JT · Substantial damage
  > The pilot's inadequate recovery from a bounced landing.
- [NTSB DEN07WA061](https://openairdocs.org/ntsb/DEN07WA061.md): Piper PA-34-200T · Gresse-en-Verco, France · Accident · 3 fatal · Foreign investigation · Feb 10, 2007 · N2195B · Destroyed
- [NTSB DEN07FA045](https://openairdocs.org/ntsb/DEN07FA045.md): Piper PA-34-200T · Manzanola, CO · Accident · 1 fatal · Field investigation · Final report · Jan 5, 2007 · N8231D · Destroyed
  > the pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing factors were the pilot's inadequate preflight planning, self-induced…
- [NTSB DEN07CA046](https://openairdocs.org/ntsb/DEN07CA046.md): Piper PA-34-200T · Walden, CO · Accident · No injuries · Data collection · Final report · Jan 1, 2007 · N821GS · Substantial damage
  > The pilot experiencing lateral flight control stiffness for undetermined reasons and the pilot's intentional wheels up landing. Factors were the snow covered and rough/uneven terrain.

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

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

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