# NTSB investigations: Piper PA-28R-201T, 1987

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 MIA88LA034](https://openairdocs.org/ntsb/MIA88LA034.md): Piper PA-28R-201T · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Oct 31, 1987 · N2746Q · Substantial damage
  > Drg arrival, while being transferred from tampa apch ctl to twr ctl, the plt was clrd to lnd on rwy 14. Bfr lndg, he was adzd the wind was fm 070 deg at 15 KTS. Rwy 4 was available, but it was not suggested by the twr ctlr or reqd by the plt. The plt stated…
- [NTSB FTW87LA166](https://openairdocs.org/ntsb/FTW87LA166.md): Piper PA-28R-201T · Midland, TX · Accident · No injuries · Limited investigation · Final report · Jul 9, 1987 · N5919V · Substantial damage
  > During takeoff roll from mid-field on the wrong runway, the pilot realized he was running out of runway. He rotated the aircraft early and climbed to approximately 10 feet AGL. The aircraft would not climb. The pilot aborted the takeoff andapplied brakes…
- [NTSB ATL87LA188](https://openairdocs.org/ntsb/ATL87LA188.md): Piper PA-28R-201T · Bowling Green, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1987 · N38344 · Destroyed
  > The instructor (CFI) rprtd he preflighted the acft & taxied to the refueling area. While there, he was apchd by another plt who wanted to go with him on this flt. They agreed & the CFI moved to the rgt seat. They commenced the start-up, run-up & takeoff…

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

This list as a web page: https://openairdocs.org/ntsb?model=7102813&year=1987

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