NTSB investigations, AZ
6 cases where the first occurrence was “Vortex turbulence encountered”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1995 | 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.\"eventStateOrRegion\" = 'AZ' 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" = 'AZ' 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 SEA08CA027Accident · No injuriesData collectionFinal reportEurocopter France EC 130 B4 · Meadview, AZThe downward flexing of the standing helicopter's main rotor blades and subsequent impact with its tail boom as a result of another helicopter's rotor blade's vortices. .NTSB LAX02LA230Accident · Serious injuriesLimited investigationFinal reportViolet Dragonfly · Tucson, AZThe pilot's loss of control resulting from his improperly planned approach and an inadvertent encounter with wake turbulence.NTSB LAX95LA346Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Avondale, AZthe pilot's failure to plan to avoid wake turbulence.NTSB LAX86LA072Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Tucson, AZAfter about a 45 min wait as the number one acft for departure, the controller informed the plt that he could expect an additional 3 min wait because of wake turbulence from a (large) EC-130 acft which was approaching for a touch & go landing. The plt elected…NTSB LAX83FA098Accident · No injuriesField investigationFinal reportBeech H35 · Tucson, AZDuring arrival, the plt was advised of the position of a Boeing 727 that was landing on rwy 29R & he reported seeing theacft. He also was cautioned about possible wake turbulence from the Boeing & he acknowledged. The plt reported that while he was on an…NTSB LAX82DA306Accident · No injuriesFinal reportHiller UH-12E · Chandler, AZThe pilot was spraying liquid chemicals at night. The pilot flew into his own wake turbulence and lost control and collided with the ground. Control was regained to make an upright landing in the field. Skids were torn off the aircraft.