# NTSB investigations: Piper PA-28RT-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 LAX02LA054](https://openairdocs.org/ntsb/LAX02LA054.md): Piper PA-28RT-201 · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Dec 24, 2001 · N3023K · Substantial damage
  > The pilot's inadequate removal of snow and ice from the surfaces of the airplane before takeoff.
- [NTSB IAD01FA038](https://openairdocs.org/ntsb/IAD01FA038.md): Piper PA-28-RT201 · Manassas, VA · Accident · 1 fatal · Field investigation · Final report · Mar 20, 2001 · N2380U · Destroyed
  > The pilot's spatial disorientation due to a night visual illusion. A factor was the dark night condition.
- [NTSB NYC95LA070](https://openairdocs.org/ntsb/NYC95LA070.md): Piper PA-28RT-201 · Wilmington, OH · Accident · No injuries · Limited investigation · Final report · Mar 11, 1995 · N8395Y · Substantial damage
  > The pilot's failure to maintain adequate terrain clearance during a go around, which resulted in an inflight collision with a snowbank. A factor is the pilot's delay in initiating a go around.
- [NTSB BFO89FA003](https://openairdocs.org/ntsb/BFO89FA003.md): Piper PA-28RT-201 · Frederick, MD · Accident · 1 fatal · Field investigation · Final report · Oct 21, 1988 · N8291Z · Destroyed
  > Nonsubmitted
- [NTSB NYC82AA125](https://openairdocs.org/ntsb/NYC82AA125.md): Piper PA-28RT-201 · Dunkirk, NY · Accident · 4 fatal · Final report · Jun 17, 1982 · N8192A · Destroyed
  > The flt was cleared for a VOR rwy 24 apch. At 2226 the plt reported the arpt in sight. At 2228 the acft crashed 4,000 ftsouth of the departure end of rwy 24 on a heading of 115 deg. The jamestown,NY 2250 wx observation was partial obscuration, estimated 200…
- [NTSB CHI82DA043](https://openairdocs.org/ntsb/CHI82DA043.md): Piper PA-28R-201 · Mattoon, IL · Accident · No injuries · Final report · Feb 9, 1982 · N8282Z · Substantial damage
  > The pilot tookoff with an inoperative landing light. After arriving at the destination, it was dark and snowing, and the visibility was about one mile. Airport personnel were removing snow from the lights on runway 11/29. Snow had been cleared from the lights…

## 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 ('7102818')
    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=7102818&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.