NTSB investigations: Waco UPF-7
11 cases on aircraft the registry lists as Waco UPF-7, where the first occurrence was “Loss of control - on ground/water”. 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.
Cases per year
| 1988 | 1 |
|---|---|
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1996 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 LAX07CA192Accident · No injuriesData collectionFinal reportWaco UPF-7 · Reno, NVThe pilot's failure to maintain directional control.NTSB CHI03LA034Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Owatonna, MNThe remedial action not performed by the certified flight instructor (CFI) during the bounced landing and directional control not maintained during the go-around by CFI. Contributing factors were the CFIs preflight planning/preparation in placing the dual…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.NTSB LAX96LA292Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Payson, AZthe failure of the pilot to maintain directional control on touchdown and the landing ground roll.NTSB NYC96LA114Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · East Canton, PAthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a loss of control and subsequent collision with obstacles. The gusty crosswind condition was a related factor.NTSB LAX91LA370Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Wallace, CAThe 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 NYC91LA007Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Erwinna, PAThe pilot's failure to maintain directional control during the take off roll.NTSB DEN89LA201Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Watkins, COFailure of the left brake assembly, and subsequent loss of directional control by the pilot.NTSB NYC89LA180Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Plymouth, NHLoss of directional control during an aborted takeoff. The ditch was a related factor.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.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…