Skip to content

NTSB investigations: Waco UPF-7, FL

13 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 per year

19722026

Where

Latest cases

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."eventStateOrRegion" = 'FL' 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

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.\"eventStateOrRegion\" = 'FL' 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"

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."eventStateOrRegion" = 'FL' 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

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 ERA17LA340Accident · Minor injuriesLimited investigationFinal reportWaco UPF 7 · Ocklawaha, FLA failure of both magnetos due to multiple deficiencies, which resulted in a total loss of engine power.Sep 28, 2017 · N29909 · Substantial damage NTSB MIA01LA019Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLThe failure of the pilot to maintain directional control during landing with a quartering tail wind, resulting in the aircraft nosing over and coming to rest inverted.Oct 27, 2000 · N32049 · Substantial damage NTSB MIA98LA217Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLA loss of engine power due to undetermined reasons, resulting in an inadvertent stall at too low an altitude to allow recovery.Aug 3, 1998 · N29927 · Destroyed NTSB MIA97LA062Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Sanibel, FLA partial loss of engine power (rough running engine) for undetermined reason.Jan 14, 1997 · N29986 · Substantial damage NTSB MIA91LA147Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLA momentary loss of engine power due to undetermined reasons.May 15, 1991 · N32133 · Substantial damage NTSB MIA90IA036Incident · No injuriesIncident investigationFinal reportWaco UPF-7 · Key West, FLThe failure of the pilot to adequately watch for parked aircraft after becoming distracted.Nov 26, 1989 · N32133 · No damage NTSB MIA89LA245Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLInadequate visual lookout by the Waco pilot, which resulted in his misjudgement of clearance between his aircraft and the Cessna 172 and a subsequent collision.Sep 10, 1989 · N32133 · 2 aircraft · Minor damage NTSB MIA89LA112Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Marathon, FLThe pilot failed to maintain directional control of the aircraft and inadvertently allowed it to ground loop. Crosswind was a contributing factor.Mar 21, 1989 · N39752 · Substantial damage NTSB MIA89IA080Incident · Minor injuriesIncident investigationFinal reportWaco UPF-7 · Marathon, FLFuel starvation due to a corroded carburetor.Feb 6, 1989 · N39721 · Minor damage NTSB MIA88LA216Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLWhile 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…Jul 6, 1988 · N32133 · Substantial damage NTSB MIA88LA106Accident · Serious injuriesLimited investigationFinal reportWaco UPF-7 · St Petersburg, FLThe 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…Feb 14, 1988 · N29368 · Substantial damage NTSB MIA79D1068Accident · No injuriesClosedWaco UPF-7 · Kissimmee, FLMay 19, 1979 · N30199 · Substantial damage NTSB MIA72FLA49Accident · No injuriesClosedWaco UPF-7 · Capp, FLJun 3, 1972 · N32193 · Substantial damage