# NTSB investigations: Waco UPF-7, 1988

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 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 MIA88LA216](https://openairdocs.org/ntsb/MIA88LA216.md): Waco UPF-7 · Key West, FL · Accident · No injuries · Limited investigation · Final report · Jul 6, 1988 · N32133 · Substantial damage
  > While on a sightseeing flt, during the landing roll with a direct crosswind from the rt at 9 KTS, the plt reported that the acft turned into the wind. He was unable to correct this with left rudder & braking before the acft travelled into a ditch. He further…
- [NTSB MIA88LA106](https://openairdocs.org/ntsb/MIA88LA106.md): Waco UPF-7 · St Petersburg, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 14, 1988 · N29368 · Substantial damage
  > The plt stated that while on apch to land, the engine lost power. During an attempt to land on runway 36 the acft stalled & nosed in from an approximate 50 foot altitude. No determination could be made as to the nature of the malfunction of the engine as…

## 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 year(c."eventDate") = 1988
  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&year=1988

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