# NTSB investigations: Waco UPF-7, CA

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 GAA15CA001](https://openairdocs.org/ntsb/GAA15CA001.md): Waco UPF 7 · Rio Vista, CA · Accident · No injuries · Data collection · Final report · Mar 6, 2015 · N32063 · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll.
- [NTSB WPR13CA146](https://openairdocs.org/ntsb/WPR13CA146.md): Waco UPF-7 · Paso Robles, CA · Accident · Minor injuries · Data collection · Final report · Mar 11, 2013 · N29969 · Substantial damage
  > The pilot's failure to adequately compensate for crosswind conditions, which resulted in a loss of directional control during the landing roll.
- [NTSB LAX07LA079](https://openairdocs.org/ntsb/LAX07LA079.md): Waco UPF-7 · Palos Verdes, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 2007 · N30140 · 2 aircraft · Substantial damage
  > the failure of both pilots to maintain adequate visual lookout and clearance from each other while maneuvering in close proximity.
- [NTSB LAX95LA166](https://openairdocs.org/ntsb/LAX95LA166.md): Waco UPF-7 · Chino, CA · Accident · No injuries · Limited investigation · Final report · Apr 22, 1995 · N20971 · Substantial damage
  > failure of the attachment link for the master cylinder return spring, which allowed the left brake to lock.
- [NTSB LAX91LA370](https://openairdocs.org/ntsb/LAX91LA370.md): Waco UPF-7 · Wallace, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1991 · N30107 · Substantial damage
  > The pilot's failure to properly align his airplane with the runway and his failure to maintain directional control during takeoff. Contributing factors related to the presence of rough and downhill terrain adjacent to the runway.
- [NTSB LAX83LA232](https://openairdocs.org/ntsb/LAX83LA232.md): Waco UPF7 · Seal Beach, CA · Accident · No injuries · Limited investigation · Final report · May 15, 1983 · N29962 · Substantial damage
  > The acft was landed on a Beach highway after the engine quit at 800 feet MSL. The acft damage during the landing was limited to a broken landing strut, bent propeller blade and fractured front and rear spars of the right wing. The flightwas a scenic excursion…
- [NTSB LAX73FUA40](https://openairdocs.org/ntsb/LAX73FUA40.md): Waco UPF-7 · Santa Ana, CA · Accident · No injuries · Closed · Apr 29, 1973 · N30141 · 2 aircraft · Substantial damage
- [NTSB OAK72DVM33](https://openairdocs.org/ntsb/OAK72DVM33.md): Waco UPF-7 · Watsonville, CA · Accident · No injuries · Closed · May 21, 1972 · N32137 · Substantial damage
- [NTSB OAK66D0120](https://openairdocs.org/ntsb/OAK66D0120.md): Waco UPF-7 · Markleville, CA · Accident · Minor injuries · Closed · Jul 3, 1965 · N220 · Destroyed
- [NTSB UNK64X0433](https://openairdocs.org/ntsb/UNK64X0433.md): Waco UPF7 · San Fernand, CA · Accident · Minor injuries · Closed · Feb 2, 1964 · N20971 · 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" = 'CA' 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=CA

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