# NTSB investigations: Piper PA-28-161, ME

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 NYC97LA060](https://openairdocs.org/ntsb/NYC97LA060.md): Piper PA-28-161 · Sanford, ME · Accident · No injuries · Limited investigation · Final report · Mar 14, 1997 · N2914A · Substantial damage
  > the pilot's premature raising of the flaps during the initial climb after takeoff, which resulted in a stall/mush. A factor relating to the accident was: the pilot's failure to maintain proper runway alignment after lift-off, which allowed the airplane to…
- [NTSB NYC90FA135](https://openairdocs.org/ntsb/NYC90FA135.md): Piper PA-28-161 · Greenville, ME · Accident · 2 fatal · Field investigation · Final report · Jun 19, 1990 · N44897 · Destroyed
  > Failure of the pilot to maintain the proper altitude, while searching for the destination airport at night. Factors related to the accident were: darkness, fog obscuring the destination airport lights, mountainous terrain, and the lack of visual perception at…
- [NTSB NYC88LA149](https://openairdocs.org/ntsb/NYC88LA149.md): Piper PA-28-161 · Fryeburg, ME · Accident · 1 fatal · Limited investigation · Final report · Jul 11, 1988 · N84493 · Destroyed
  > According to witnesses, the pilot had been drinking and two friends drove him to the airport and watched as he departed. They noted that the aircraft was climbing steeply after liftoff and then observed the aircraft's rotating beacon as the aircraft spiraled…

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

This list as a web page: https://openairdocs.org/ntsb?model=7102803&state=ME

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