# NTSB investigations: Piper PA-23, 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 FTW95LA383](https://openairdocs.org/ntsb/FTW95LA383.md): Piper PA-23 · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Sep 8, 1995 · N2291P · Substantial damage
  > The pilot's improper in-flight planning/decision by inadvertently selecting a less suitable area for landing (than the runway). Factors relating to the accident were: a malfunction of the nose landing gear micro-switch, which resulted in a false indication…
- [NTSB DEN87FA110](https://openairdocs.org/ntsb/DEN87FA110.md): Piper PA-23 · Craig, CO · Accident · Serious injuries · Field investigation · Final report · Apr 21, 1987 · N3231P · Substantial damage
  > The plt and his wife were on a cross country flt to visit relatives in north carolina. Several witnesses observed the aircraft depart Craig-moffet airport with the engine(s) running rough and using almost the entire runway to get airborne. Once airborne the…
- [NTSB DEN84FA148](https://openairdocs.org/ntsb/DEN84FA148.md): Piper PA-23-150 · Parker, CO · Accident · Serious injuries · Field investigation · Final report · May 13, 1984 · N1425P · Substantial damage
  > According to the pilot the acft had not been flown for two months and he intended to practice touch and go landings. Maintenance personnel were requested to add 10 gals of fuel to the right main tank just prior to departure. They reported that upon arrival…
- [NTSB DEN80FA014](https://openairdocs.org/ntsb/DEN80FA014.md): Piper PA-23 · Grand Lake, CO · Accident · 1 fatal · Closed · Dec 23, 1979 · N2013P · Substantial damage
- [NTSB DEN80FTE04](https://openairdocs.org/ntsb/DEN80FTE04-201188.md): Piper PA-23 · Peyton, CO · Accident · No injuries · Closed · Oct 25, 1979 · N4038P · Substantial damage
- [NTSB DEN77FTE49](https://openairdocs.org/ntsb/DEN77FTE49.md): Piper PA-23 · Lamar, CO · Accident · No injuries · Closed · May 24, 1977 · N777HA · Substantial damage
- [NTSB DEN76FTE05](https://openairdocs.org/ntsb/DEN76FTE05.md): Piper PA-23 · Lake City, CO · Accident · No injuries · Closed · Jul 7, 1975 · N5RJ · Substantial damage
- [NTSB DEN69D0205](https://openairdocs.org/ntsb/DEN69D0205.md): Piper PA-23 · Boulder, CO · Accident · No injuries · Closed · Dec 31, 1968 · N1097P · Substantial damage
- [NTSB DEN69F0168](https://openairdocs.org/ntsb/DEN69F0168.md): Piper PA-23 · Denver, CO · Accident · No injuries · Closed · Dec 22, 1968 · N1135P · Substantial damage
- [NTSB DEN66F0063](https://openairdocs.org/ntsb/DEN66F0063.md): Piper PA-23 · Loveland, CO · Accident · No injuries · Closed · Jul 11, 1965 · N6567F · Substantial damage
- [NTSB UNK64X3944](https://openairdocs.org/ntsb/UNK64X3944.md): Piper PA23 · Broomfield, CO · Accident · No injuries · Closed · Sep 12, 1964 · N2050P · 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 ('7102302'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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