NTSB investigations, WA
8 cases where the first occurrence was “Vortex turbulence encountered”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2006 | 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.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 410)
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" = 'WA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 410) 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 SEA07IA019Incident · No injuriesIncident investigationFinal reportCessna 172 · Seattle, WAThe instructor pilot's improper in-flight decision not to take evasive action as a heavy aircraft passed by while on an upwind parallel approach path to an adjacent runway, leading to a wake vortices encounter. Factors include a nearly direct crosswind…NTSB SEA01LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oak Harbor, WAThe pilot's inadequate remedial action while on final approach. The encounter with wake turbulence was a factor.NTSB SEA00LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe pilot's failure to attain proper alignment with the landing runway, and her failure to maintain proper glide path for the landing runway, resulting in an encounter with vortex turbulence from a preceding heavy aircraft landing on a parallel runway and…NTSB SEA91LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Pullman, WAThe pilot's encounter with wake turbulence shortly before touchdown, resulting in a hard landing.NTSB SEA90LA136Accident · No injuriesLimited investigationFinal reportNorth American P-51 · Seattle, WAAn encounter with vortex turbulence while on final approach to landing.NTSB SEA84LA083Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Kent, WAThe plt requested clearance to transit the seattle tca for a landing at Boeing field. He was advised of a DC-10 departing the seattle-tacoma intl arpt & was cautioned about possible wake turbulence. The DC-10 passed the helicopter with about 1 1/2 mi lateral…NTSB SEA82DA128Accident · Serious injuriesFinal reportAeronca 7AC · Kent, WADuring practice steep turns the aircraft encountered its wake turbulence. Manuevers to regain control were not effective. The aircraft contacted trees in a nose low attitude.NTSB SEA82DA045Accident · No injuriesFinal reportRockwell Intl. S-2R · Eureka, WAAfter spraying most of his load, the pilot made a dry pass and dropped a smoke flare. The flare was dropped to check the drift of the air relative to a susceptible crop east of the field being sprayed. After dropping the flare, the pilot made a 180 degree…