# NTSB investigations: Piper PA-28R-201: In flight collision with terrain/water

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 CHI02LA015](https://openairdocs.org/ntsb/CHI02LA015.md): Piper PA-28R-201 · Lapeer, MI · Accident · No injuries · Limited investigation · Final report · Oct 28, 2001 · N6899C · Substantial damage
  > the touchdown aim point not attained by the pilot rated student and the remedial action not performed by the flight instructor.
- [NTSB CHI93LA285](https://openairdocs.org/ntsb/CHI93LA285.md): Piper PA-28 · Crookston, MN · Accident · No injuries · Limited investigation · Final report · Jul 27, 1993 · N172ND · Substantial damage
  > The pilot in command's delayed in-flight decision. A factor to the accident is the pilot in command's failure to attain a proper touchdown point.
- [NTSB LAX87FA071](https://openairdocs.org/ntsb/LAX87FA071.md): Piper PA-28R-201 · Gorman, CA · Accident · 1 fatal · Field investigation · Final report · Dec 27, 1986 · N50U · Destroyed
  > The aircraft descended into mountainous terrain during a night cross-country flight. The surviving pilot stated that he was attending to paperwork and when he looked up he turned on the landing light in time to see trees just prior to impact. He further…
- [NTSB CHI83LA210](https://openairdocs.org/ntsb/CHI83LA210.md): Piper PA-28R · Mora, MN · Accident · No injuries · Limited investigation · Final report · May 11, 1983 · N36804 · Substantial damage
  > The acft ran off the departure end of the rwy into a cornfield during an aborted takeoff. The pilot stated that after liftoff the stall warning came on and the acft would not accelerate or climb. He pulled the power off and aborted the takeoff. The acft…

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

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

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