Skip to content

NTSB investigations

114 cases where the first occurrence was “Vortex turbulence encountered”.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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 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

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 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."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 FTW84LA234Accident · Serious injuriesLimited investigationFinal reportCanadair CL-600 · Clarksville, TXCruising at FL350, N215RL encountered wake turbulance from a descending 'heavy' Boeing 767. The resultant upset caused an uncontrolled loss of 11,000 ft in 10 to 15 seconds before the crew was able to recover. The acft was not damaged but an unrestrained pax…May 16, 1984 · N215RL · Minor damage 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…Apr 14, 1984 · N1092L · Substantial damage NTSB MIA84FU003Accident · 1 fatalFinal reportPterodactyl Ascender II · Palm Bay, FLThe plts of 2 ultralight vehicles were accompanying each other & were flying west at 500 ft AGL in calm air when an acft crossed ahead of their flt path. The acft was estimate to be flying at about 140 KTS & aprx 40 ft above the ultralights' alt. The…Apr 1, 1984 · UNREG · Destroyed NTSB DEN84LA111Accident · No injuriesLimited investigationFinal reportPiper PA-12-115 · Riverton, WYThe plt stated that a convair 580 had landed before him. The plt flew a normal glide slope & planned to land on the approach end of the rwy. On short final at 50 ft AGL, the acft suddenly banked 'over 90 degrees' to the left out of control. The acft then hit…Mar 19, 1984 · N4378M · Substantial damage NTSB LAX84IA153Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-30 · Los Angeles, CAAn aeromexico DC-9 encountered wake turbulence from a twa L-1011 on the approach to rwy 24L. The aeromexico acft was 6 miles (1 min & 10 sec) behind the twa acft & 800 ft below its glideslope at 6100 ft when the incident occurred.Jan 10, 1984 · XAAMF · No damage NTSB LAX83LA334Accident · No injuriesLimited investigationFinal reportCessna A188B · Calipatria, CAThe acft made a hard landing in a cotton field during a crop dusting operation after buffeting was felt in a turn. The pilot thought he was stalling in vortex turbulence from another acft in front of him. A toxic load of suprecide was dumped before the pilot…Jul 19, 1983 · N4463Q · Substantial damage NTSB MKC83LA155Accident · No injuriesLimited investigationFinal reportCessna A188B · Edgar, NEThe plt reported that he was completing a turnaround when the acft encountered turbulence from another plane that was spraying the same field. The acft began to settle. When he pulled up to avoid a power line, the acft stalled & crashed.Jul 13, 1983 · N9114G · Destroyed NTSB NYC83LA065Accident · No injuriesLimited investigationFinal reportCessna 150K · Wilmington, DEA C-130 aircrew was cleared to taxi to the run-up area at the north end of the arpt for a run-up. At that time, the wind was reported from 360 deg at 8 KTS. The C-130 crew stopped on the run-up pad facing the wind & began a run-up. In the meantime, a Cessna…Feb 19, 1983 · N5898G · Substantial damage 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…Feb 7, 1983 · N4687D · Substantial damage NTSB ANC83LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Anchorage, AKShortly after departure the flt received radar vectors placing it near a VFR reporting point located 4 mi past the departure end of rwy 32 & 2 mi east of the rwy centerline. Traffic advisories were issued by approach control indicating a beoing 747 climbing…Oct 9, 1982 · N6843A · No damage 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.Aug 20, 1982 · N4026S · Substantial damage NTSB CHI82DA279Accident · No injuriesFinal reportBell 47G-2 · Plainview, MNWhile making cleanup swaths over an odd shaped portion of a corn field, the pilot made two turns of about 220 degrees each in close proximity to each other. The second turn was made downwind from two previous swaths that had just been completed. During a…Jul 28, 1982 · N19JM · Substantial damage 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.Jul 24, 1982 · N82651 · Destroyed 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…Apr 5, 1982 · N8471V · Substantial damage