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

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 FTW97LA192](https://openairdocs.org/ntsb/FTW97LA192.md): Piper PA-28R-210T · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · May 15, 1997 · N43761 · Substantial damage
  > the pilot's failure to know and follow the emergency procedure for extending the landing gear after loss of electrical power. Factors relating to the accident were: an inoperative alternator, inadequate maintenance by the operator, a depleted battery, and…
- [NTSB FTW97LA125](https://openairdocs.org/ntsb/FTW97LA125.md): Piper PA-28R-201T · Hartsel, CO · Accident · No injuries · Limited investigation · Final report · Mar 16, 1997 · N38703 · Destroyed
  > The pilot's misjudging the proper touchdown point on the dirt road due to excessive airspeed and his failure to deploy flaps. Factors were the partial loss of engine lubricating oil due to the oil filler cap separating because some unknown person failed to…
- [NTSB FTW96LA197](https://openairdocs.org/ntsb/FTW96LA197.md): Piper PA-28R-201T · Peyton, CO · Accident · No injuries · Limited investigation · Final report · May 2, 1996 · N175WW · Substantial damage
  > the failure of the right main tire due to valve stem separation.
- [NTSB SEA92FA077](https://openairdocs.org/ntsb/SEA92FA077.md): Piper PA-28R-201T · Briggsdale, CO · Accident · 2 fatal · Field investigation · Final report · Apr 14, 1992 · N2742M · Destroyed
  > Proper altitude was not maintained. Factors include ostentatious display.
- [NTSB DEN88LA150](https://openairdocs.org/ntsb/DEN88LA150.md): Piper PA-28R-201T · Erie, CO · Accident · No injuries · Limited investigation · Final report · Jul 9, 1988 · N135E · Substantial damage
- [NTSB DEN82DA055](https://openairdocs.org/ntsb/DEN82DA055.md): Piper PA-28R-201T · Longmont, CO · Accident · No injuries · Final report · Apr 5, 1982 · N423CC · Substantial damage
  > The pilot reported that he made a normal approach and touched down in the landing zone as defined by the VASI. However, during the landing roll, the right brake was inoperative. He was unable to stop on the remaining runway while rolling straight ahead. About…
- [NTSB DEN81FTE55](https://openairdocs.org/ntsb/DEN81FTE55.md): Piper PA-28R · Westcliffe, CO · Accident · Minor injuries · Closed · Jul 7, 1981 · N31568 · Substantial damage

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

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

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