# NTSB investigations: Piper PA-28-236, 2008

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 CEN09CA109](https://openairdocs.org/ntsb/CEN09CA109.md): Piper PA28 · Ely, MN · Accident · No injuries · Data collection · Final report · Dec 17, 2008 · N845D · Substantial damage
  > The pilot's failure to maintain directional control during landing. Contributing to the accident were the reduced left main landing gear wheel rotation for undetermined reasons and the snow-covered runway.
- [NTSB ERA09LA033](https://openairdocs.org/ntsb/ERA09LA033.md): Piper PA-32-260 · Plymouth, NC · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 2008 · N3568W · 2 aircraft · Substantial damage
  > The Piper Dakota (PA-28-236) pilot's failure to see and avoid the Piper Cherokee (PA-32-260).
- [NTSB DEN08CA115](https://openairdocs.org/ntsb/DEN08CA115.md): Piper PA-28-236 · Osage Beach, MO · Accident · No injuries · Data collection · Final report · Jun 22, 2008 · N8106M · Substantial damage
  > The pilot failed to maintain separation from the parked airplanes while taxiing at an excessive speed for the conditions. Contributing to the accident was the airport personnel's decision to park the airplanes in close proximity to the taxiway.
- [NTSB SEA08CA103](https://openairdocs.org/ntsb/SEA08CA103.md): Piper PA-28-236 · Alturas, CA · Accident · Minor injuries · Data collection · Final report · Apr 4, 2008 · N2092E · Substantial damage
  > The pilot's inadequate compensation for the gusty crosswind conditions. The wind gusts were a contributing factor.

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

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

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