Skip to content

NTSB investigations: Waco UPF-7

94 cases on aircraft the registry lists as Waco UPF-7. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with 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."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

duckdb -csv -c "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.\"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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB NYC86LA008Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Norwood, MAAccording to the pilot, during the takeoff climb the aircraft did not develop sufficient power to maintain altitude. The pilot turned the aircraft to the right in an attempt to return to the airport. During the approach to the airport, the aircraft collided…Oct 14, 1985 · N39714 · Substantial damage NTSB DEN84FA211Accident · 1 fatalField investigationFinal reportWaco UPF-7 · Brighton, COThe 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.…Jul 6, 1984 · N32079 · Destroyed NTSB CHI84LA273Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Hamilton, OHThe plt stated he landed long and fast and during an attempted go-around collided with a parked acft near the end of the grass strip.Jun 30, 1984 · N39717 · Substantial damage NTSB NYC84LA220Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Orange, MAThe plt stated that he was giving local sightseeing flights. He indicated that a 'wide' gentleman and a 'moderate' size gentleman boarded the acft. The plt moved the throttle to ensure clearance but found one of the pax restricted the movement slightly. The…Jun 23, 1984 · N32127 · Substantial damage NTSB CHI83LA361Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · New Lexington, OHAccording to the pilot, during landing roll he applied brakes to maintain directional control. He heard a loud noise and experienced right brake failure. The acft veered left and came to rest in trees at the rnwy edge. Exam of the acft revealed the brake…Aug 5, 1983 · N29957 · Substantial damage NTSB LAX83LA232Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Seal Beach, CAThe 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…May 15, 1983 · N29962 · Substantial damage NTSB FTW83LA002Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Albuquerque, NMUpon completion of an airshow the plt returned to coronado arpt. Upon touchdown the acft tried to nose over & a go-around was made. After two touch & go's the plt isolated the problem to a locked right brake so he attempted to remedy the problem by cutting…Oct 3, 1982 · N30136 · Substantial damage NTSB CHI82DA237Accident · No injuriesFinal reportWaco UPF-7 · Popular Grove, ILThe pilot experienced severe engine vibration during cruise flight. The pilot performed an emergency landing in a field. Because of the length of the field the pilot landed hard and the left main gear collapsed. The separated gear struck and fractured the…Jul 4, 1982 · N39714 · Substantial damage NTSB NYC79FNC36Accident · No injuriesClosedWaco UPF-7 · North Conway, NHJul 10, 1979 · N32127 · Substantial damage NTSB MIA79D1068Accident · No injuriesClosedWaco UPF-7 · Kissimmee, FLMay 19, 1979 · N30199 · Substantial damage NTSB NYC78FNC27Accident · Minor injuriesClosedWaco UPF-7 · North Conway, NHMay 22, 1978 · N39713 · Substantial damage NTSB MIA78FKQ11Accident · No injuriesClosedWaco UPF-7 · Meridian, MSMay 16, 1978 · N39737 · Substantial damage NTSB NYC78FHA06Accident · Minor injuriesClosedWaco UPF7 · Tannersville, PANov 19, 1977 · N167K · Substantial damage NTSB NYC78FA004Accident · 2 fatalClosedWaco UPF-7 · Palmyra, NYOct 29, 1977 · N32140 · Destroyed NTSB SEA77DYG10Accident · No injuriesClosedWaco UPF-7 · Spokane, WANov 20, 1976 · N29926 · Substantial damage NTSB FTW76FQD06Accident · No injuriesClosedWaco UPF-7 · El Paso, TXSep 6, 1975 · N2369Q · Substantial damage NTSB MKC76DTK04Accident · No injuriesClosedWaco UPF-7 · N Sioux City, SDAug 30, 1975 · N29974 · Substantial damage NTSB MIA74DKJ21Accident · No injuriesClosedWaco UPF-7 · Huntsville, ALAug 30, 1973 · N29982 · Substantial damage NTSB FTW74FQG07Accident · No injuriesClosedWaco UPF-7 · Dimmitt, TXAug 19, 1973 · N2369Q · Substantial damage NTSB NYC73FHA25Accident · No injuriesClosedWaco UPF-7 · Bedminster, NJMay 6, 1973 · N29927 · Substantial damage NTSB LAX73FUA40Accident · No injuriesClosedWaco UPF-7 · Santa Ana, CAApr 29, 1973 · N30141 · 2 aircraft · Substantial damage NTSB SEA73FYC06Accident · Serious injuriesClosedWaco UPF-7 · Vancouver, WAAug 19, 1972 · N29949 · Substantial damage NTSB MIA72FLA49Accident · No injuriesClosedWaco UPF-7 · Capp, FLJun 3, 1972 · N32193 · Substantial damage NTSB OAK72DVM33Accident · No injuriesClosedWaco UPF-7 · Watsonville, CAMay 21, 1972 · N32137 · Substantial damage NTSB LAX70F0185Accident · Serious injuriesClosedWaco UPF-7 · Douglas, AZOct 19, 1969 · N39700 · Destroyed NTSB CHI70D0020Accident · No injuriesClosedWaco UPF-7 · Columbus, OHJun 7, 1969 · N29982 · Substantial damage NTSB CHI68D0772Accident · No injuriesClosedWaco UPF-7 · Manchester, OHJun 9, 1968 · N32140 · Substantial damage NTSB LAX68F0408Accident · Minor injuriesClosedWaco UPF-7 · Mesa, AZApr 14, 1968 · N32136 · Substantial damage NTSB DEN67A0055Accident · 1 fatalClosedWaco UPF-7 · Las Cruces, NMMar 25, 1967 · N32094 · Destroyed NTSB CHI67F0272Accident · No injuriesClosedWaco UPF-7 · Midland, MIOct 9, 1966 · N32133 · Substantial damage NTSB SEA67F0096Accident · 1 fatalClosedWaco UPF-7 · Wilder, IDAug 12, 1966 · N170E · Destroyed NTSB NYC67F0169Accident · No injuriesClosedWaco UPF-7 · Centre Hall, PAAug 6, 1966 · N32073 · Substantial damage NTSB CHI67D0097Accident · Minor injuriesClosedWaco UPF7 · Richmond, INJul 10, 1966 · N32026 · Substantial damage NTSB MIA66F0615Accident · Minor injuriesClosedWaco UPF7 · Mooresville, NCJun 26, 1966 · N173E · Substantial damage NTSB MIA67D0062Accident · Minor injuriesClosedWaco UPF-7 · Stone Mountain, GAJun 19, 1966 · N29324 · Substantial damage NTSB NYC66F0302Accident · No injuriesClosedWaco UPF-7 · Manville, NJOct 17, 1965 · N29305 · Destroyed NTSB SEA66D0106Accident · Minor injuriesClosedWaco UPF-7 · Ashland, ORJul 21, 1965 · N32023 · Destroyed NTSB NYC66F0095Accident · Serious injuriesClosedWaco UPF7 · Manchester, VTJul 17, 1965 · N32168 · Destroyed NTSB OAK66D0120Accident · Minor injuriesClosedWaco UPF-7 · Markleville, CAJul 3, 1965 · N220 · Destroyed NTSB NYC65A0138Accident · 2 fatalClosedWaco UPF-7 · Ocean City, MDMay 9, 1965 · N39722 · Destroyed NTSB UNK64X4180Accident · No injuriesClosedWaco UPF7 · Steel Creek Tp, SCSep 27, 1964 · N184E · Substantial damage NTSB UNK64X2769Accident · No injuriesClosedWaco UPF7 · Brookville, OHJul 11, 1964 · N32083 · Minor damage NTSB UNK64X0753Accident · No injuriesClosedWaco UPF-7 · Longmont, COFeb 29, 1964 · N29301 · Substantial damage NTSB UNK64X0433Accident · Minor injuriesClosedWaco UPF7 · San Fernand, CAFeb 2, 1964 · N20971 · Substantial damage