# NTSB investigations: Piper PA-32RT-300T, 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 FTW97FA171](https://openairdocs.org/ntsb/FTW97FA171.md): Piper PA-32RT-300T · Rye, CO · Accident · 3 fatal · Field investigation · Final report · Apr 26, 1997 · N2225A · Destroyed
  > The pilot initiating flight into IMC conditions in mountainous terrain. Factors were mountainous terrain, low ceiling, snow, preflight planning, and in-flight planning and decision making.
- [NTSB FTW94LA120](https://openairdocs.org/ntsb/FTW94LA120.md): Piper PA-32RT-300T · Englewood, CO · Accident · Serious injuries · Limited investigation · Final report · Apr 8, 1994 · N881GK · Destroyed
  > A loss of power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB DEN93FA012](https://openairdocs.org/ntsb/DEN93FA012.md): Piper PA-32RT-300T · Kersey, CO · Accident · 2 fatal · Field investigation · Final report · Nov 20, 1992 · N39683 · Destroyed
  > Inadvertent stall and loss of control due to structural icing. Factors were: icing conditions, and flight into known adverse weather.
- [NTSB DEN82DA110](https://openairdocs.org/ntsb/DEN82DA110.md): Piper PA-32RT-300T · Durango, CO · Accident · No injuries · Final report · Jun 23, 1982 · N31912 · Substantial damage
  > The pilot reported that after taking off, dense white smoke began to fill the cockpit and seemed to come from under the instrument panel. He stated that the instruments were in the normal operating range, but the smoke became so dense that the visibility in…
- [NTSB DEN79DTE63](https://openairdocs.org/ntsb/DEN79DTE63.md): Piper PA-32R · Fort Collins, CO · Accident · No injuries · Closed · Jul 24, 1979 · N36782 · 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 ('7103216'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7103216&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.
