NTSB investigations: Waco YMF

9 cases on aircraft the registry lists as Waco YMF. 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

19862026

NTSB investigations: Waco YMF per year, 1986–2026: 9 cases
1986	1
1988	1
1989	1
1993	1
1997	3
2015	1
2019	1

Where

Open the map

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9600411')) 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 ('9600411'))
  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 ('9600411'))
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 CEN19LA204Accident · No injuriesClass 3 · LimitedFinal reportWaco YMF-5C · Bar Harbor, MEA total loss of engine power due to a cylinder failure for undetermined reasons.Jun 22, 2019 · N63WC · Substantial damage NTSB GAA16CA089Accident · No injuriesData collectionFinal reportWaco YMF · Fullerton, CAThe pilot's failure to maintain directional control during the landing roll.Dec 25, 2015 · N99Y · Substantial damage NTSB LAX98LA033Accident · Serious injuriesLimited investigationFinal reportWaco YMF-5 · Sedona, AZThe failure and separation of the propeller for undetermined reasons.Nov 8, 1997 · N369DP · Destroyed NTSB MIA97LA222Accident · No injuriesLimited investigationFinal reportWaco YMF5 · Lake Buena Vist, FLfailure of maintenance personnel to follow installation procedures pertaining to the torque of the propeller retention nut, which resulted in a loose propeller retention nut, subsequent fatigue failure of the crankshaft, and loss of engine power. The lack of…Jul 28, 1997 · N14128 · Substantial damage NTSB MIA97LA058Accident · No injuriesLimited investigationFinal reportWaco WMF-5 · Kissimmee, FLthe pilot's failure to maintain direction control of the airplane after applying the brakes. A factor was the pilot's lack of familiarity with this make and model airplane.Jan 1, 1997 · N14128 · Substantial damage NTSB CHI94LA030Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Valparaiso, INThe pilot's inadequate compensation for wind conditions while landing in a gusty crosswind. Factors associated with the accident are the gusty crosswind and the pilot's lack of experience in this type airplane.Nov 2, 1993 · N369DP · Substantial damage NTSB MIA89LA076Accident · Minor injuriesLimited investigationFinal reportWaco YMF · Key West, FLThe inability of the plt to maintain control after encountering his own wake turbulence at a low altitude during a steep turning maneuver.Feb 3, 1989 · N99Y · Substantial damage NTSB MIA88LA220Accident · No injuriesLimited investigationFinal reportClassic YMF-5 · Key West, FLWhile turning the acft around at the operator's establishment after completing a sightseeing flt, the lower left wing collided with a vehicle.Jul 13, 1988 · N99Y · Substantial damage NTSB MIA87LA007Accident · No injuriesLimited investigationFinal reportWaco YMF · Key West, FLThe acft nosed over during landing roll. The professional plt stated that he was certain the brakes were off prior to takeoff and that he was sure he was not 'riding' the braked on landing. The plt stated that he thought the parking brake may have come on…Oct 15, 1986 · N99Y · Substantial damage