# NTSB investigations: Waco UPF-7, 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 CEN15LA295](https://openairdocs.org/ntsb/CEN15LA295.md): Waco UPF 7 · Montrose, CO · Accident · Serious injuries · Limited investigation · Final report · Jun 3, 2015 · N29943 · Substantial damage
  > The pilot's failure to attain suitable altitude while flying over high mountainous terrain in downdraft conditions.
- [NTSB DEN89LA201](https://openairdocs.org/ntsb/DEN89LA201.md): Waco UPF7 · Watkins, CO · Accident · No injuries · Limited investigation · Final report · Aug 27, 1989 · N2369Q · Substantial damage
  > Failure of the left brake assembly, and subsequent loss of directional control by the pilot.
- [NTSB DEN84FA211](https://openairdocs.org/ntsb/DEN84FA211.md): Waco UPF-7 · Brighton, CO · Accident · 1 fatal · Field investigation · Final report · Jul 6, 1984 · N32079 · Destroyed
  > The plt departed casper, WY, at 0500 with full fuel tanks. At 0807 the plt landed at an air national guard base but declineed to refuel and departed at 0918. Only a trace of fuel was found in the acft wreckage. The acft had been aloft 3 hours and 34 minutes.…
- [NTSB UNK64X0753](https://openairdocs.org/ntsb/UNK64X0753.md): Waco UPF-7 · Longmont, CO · Accident · No injuries · Closed · Feb 29, 1964 · N29301 · 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 ('9601302'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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