# NTSB investigations: Piper PA-28-236: On ground/water collision with object

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 LAX96LA301](https://openairdocs.org/ntsb/LAX96LA301.md): Piper PA-28-236 · Santa Ana, CA · Accident · No injuries · Limited investigation · Final report · Aug 4, 1996 · N8124S · Substantial damage
  > the pilot's decision to turn off the runway while at an excessive speed that did not allow him to maintain directional control of the aircraft.
- [NTSB CHI92LA176](https://openairdocs.org/ntsb/CHI92LA176.md): Piper PA-28-236 · Indian River, MI · Accident · No injuries · Limited investigation · Final report · Jun 13, 1992 · N8303Q · Substantial damage
  > An on ground collision with a deer during a landing ground roll.
- [NTSB LAX90LA255](https://openairdocs.org/ntsb/LAX90LA255.md): Piper PA28-236 · S. Lake Tahoe, CA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1990 · N8442A · Substantial damage
  > The pilot's failure to maintain clearance between the aircraft and an obstruction along his ground taxi route. Obstructions along the route and a fence constructed near the ramp are factors in the accident.
- [NTSB DEN84LA126](https://openairdocs.org/ntsb/DEN84LA126.md): Piper PA-28-236 · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Apr 7, 1984 · N2940T · Substantial damage
  > The plt got out of the acft to check the starter solenoid by turning the propeller. He left the mags on and the brakes off. When the prop was turned the acft started and collided with a parked acft.
- [NTSB LAX83LA235](https://openairdocs.org/ntsb/LAX83LA235.md): Piper PA 28-236 · Emigrant Gap, CA · Accident · No injuries · Limited investigation · Final report · May 18, 1983 · N2960X · Substantial damage
  > The acft collided with trees during takeoff. The CFI and student had made a landing on a rwy that was 2/3 covered with snow. They thought they could make a short field landing and a short field running takeoff. They nosed down in the snow during the attempted…

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

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

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