# NTSB investigations: Piper PA-28RT-201T, NM

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 DEN99LA005](https://openairdocs.org/ntsb/DEN99LA005.md): Piper PA-28RT-201T · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Oct 3, 1998 · N8182J · Substantial damage
  > The premature flaring of the airplane, resulting in an inadvertent stall.
- [NTSB DEN88FA141](https://openairdocs.org/ntsb/DEN88FA141.md): Piper PA-28RT-201T · Capitan, NM · Accident · 1 fatal · Field investigation · Final report · Jun 27, 1988 · N29318 · Destroyed
- [NTSB DEN85LA208](https://openairdocs.org/ntsb/DEN85LA208.md): Piper PA-28RT-201T · Clovis, NM · Accident · No injuries · Limited investigation · Final report · Aug 1, 1985 · N2232R · Destroyed
  > While in level cruise flight at 17,000 ft, pilot noticed sound change in cabin. All instrument readings were normal with the exception of manifold pressure drop from 32 to 25 inches. Engine began to sputter and run rough. Oil pressure warning light blinked…
- [NTSB FTW82FQA13](https://openairdocs.org/ntsb/FTW82FQA13.md): Piper PA-28RT-201T · Toadlena, NM · Accident · Serious injuries · Final report · Feb 18, 1982 · N29665 · Substantial damage
  > The non-instrument rated pilot in Piper PA-28RT, N29665, was using a call sign, N1104X, which was the registration number of a destroyed PA-32. He was cleared to climb to FL200, but as he continued, his speech became slurred. He acknowledged an artc…

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

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

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