NTSB investigations: Waco UIC
6 cases on aircraft the registry lists as Waco UIC. 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
| 1964 | 1 |
|---|---|
| 1968 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 2014 | 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 ('9600510'))
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 ('9600510'))
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 ERA14CA166Accident · No injuriesData collectionFinal reportWaco UIC · Saint Petersburg, FLThe pilot's inadequate compensation for the wind conditions during landing.NTSB MIA92LA104Accident · No injuriesLimited investigationFinal reportWaco U1-C · St. Petersburg, FLPilot-in-command's failure to maintain control of the airplane on landing. Contributing to the accident were the gusty crosswinds.NTSB LAX91LA087Accident · No injuriesLimited investigationFinal reportWaco UIC · Santa Paula, CAThe brittle fracture of the left brake master cylinder tread end causing loss of directional control.NTSB SEA85LA218Accident · No injuriesLimited investigationFinal reportWaco UIC · Boise, IDThe plt reported that when he landed, the acft began drifting to the left. Since there was a high speed turn-off ahead, he did not make an immediate correction for the drift. When a correction was applied, the acft did not respond & it continued into a ground…NTSB LAX68A0095Accident · 4 fatalClosedWaco UIC · S.Luis Obispo, CANTSB UNK64X1197Accident · No injuriesClosedWaco U1C · Watson Lake, Canada