# NTSB investigations: Piper PA-28R-200, 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 NYC06CA210](https://openairdocs.org/ntsb/NYC06CA210.md): Piper PA-28R-200 · West Milford, NJ · Accident · No injuries · Data collection · Final report · Aug 23, 2006 · N4583T · Substantial damage
  > The pilot's inadequate compensation for the wind conditions, which resulted in a hard landing. A factor was the wind.
- [NTSB NYC06FA169](https://openairdocs.org/ntsb/NYC06FA169.md): Piper PA-28R-200 · Block Island, RI · Accident · 3 fatal · Field investigation · Final report · Jul 5, 2006 · N5012S · Substantial damage
  > The pilot's inadequate preflight decision making and his failure to maintain terrain clearance during departure. Contributing, were low ceilings, rain, and thunderstorms.
- [NTSB NYC06FA156](https://openairdocs.org/ntsb/NYC06FA156.md): Piper PA-28R-200 · Philipsburg, PA · Accident · 1 fatal · Field investigation · Final report · Jun 26, 2006 · N56246 · Destroyed
  > The pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into trees. Factors in the accident were the low cloud ceiling, and dark night conditions.
- [NTSB LAX06CA191](https://openairdocs.org/ntsb/LAX06CA191.md): Piper PA-28R-200 · Alpine, CA · Accident · No injuries · Data collection · Final report · Jun 4, 2006 · N4438T · Substantial damage
  > a loss of engine power due to the aviation maintenance technician's failure to install the correct oil sump quick drain, which resulted in the inadvertent draining of engine oil during flight.
- [NTSB CHI06LA139](https://openairdocs.org/ntsb/CHI06LA139.md): Piper PA-28R-200 · Hale, MI · Accident · No injuries · Limited investigation · Final report · May 25, 2006 · N3310P · Substantial damage
  > The pilot's inadequate compensation for the crosswind condition and failure to maintain clearance from the tree. Factors were the crosswind and the tree.

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

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