# NTSB investigations: Waco UPF-7, NH

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 NYC89LA180](https://openairdocs.org/ntsb/NYC89LA180.md): Waco UPF-7 · Plymouth, NH · Accident · No injuries · Limited investigation · Final report · Aug 2, 1989 · N39752 · Substantial damage
  > Loss of directional control during an aborted takeoff. The ditch was a related factor.
- [NTSB NYC88LA190](https://openairdocs.org/ntsb/NYC88LA190.md): Waco UPF-7 · Greenland, NH · Accident · No injuries · Limited investigation · Final report · Jul 21, 1988 · N20973 · Substantial damage
  > The intention of the flight was to give people at an annual company picnic a ride in the aircraft. After takeoff and while starting a left turn the pilot stated that he encountered a 'sudden windshear/downdraft.' The aircraft never got above 200 feet and…
- [NTSB NYC88LA179](https://openairdocs.org/ntsb/NYC88LA179.md): Waco UPF-7 · Plymouth, NH · Accident · No injuries · Limited investigation · Final report · Jul 9, 1988 · N32126 · Substantial damage
  > The plt reported that the eng lost power during takeoff as the acft was climbing thru about 200 to 250 ft AGL. Unable to restore power, he turned to land in a corn field, but was unable to reach it. He then selected a smaller field, but during the landing,…
- [NTSB NYC79FNC36](https://openairdocs.org/ntsb/NYC79FNC36.md): Waco UPF-7 · North Conway, NH · Accident · No injuries · Closed · Jul 10, 1979 · N32127 · Substantial damage
- [NTSB NYC78FNC27](https://openairdocs.org/ntsb/NYC78FNC27.md): Waco UPF-7 · North Conway, NH · Accident · Minor injuries · Closed · May 22, 1978 · N39713 · 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" = 'NH' 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=NH

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