NTSB investigations, 1984
10 cases where the first occurrence was “Vortex turbulence encountered”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 4 |
| 1984 | 10 |
| 1985 | 7 |
| 1986 | 7 |
| 1987 | 5 |
| 1988 | 9 |
| 1989 | 5 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 3 |
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 year(c.\"eventDate\") = 1984
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 year(c."eventDate") = 1984 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 MIA85LA006Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Miles City, FLAccording to the plt the acft became uncontrollable shortly after takeoff when it encountered rotor downwash generated by a departing helicopter. Initial impact occurred with a tree 200 ft left of the rwy. Post crash fire destroyed the wreckage.NTSB ATL85FID01Accident · Serious injuriesFinal reportCessna 172M · Norfolk, VAThe plt was making his landing apch behind a Boeing 727 and in front of a Boeing 737. Plt was requested by ATC to make a short apch but was also cautioned about wake turbulence. On final apch at aprx 50 ft AGL, N70554 rolled sharply into a 90 deg bank,…NTSB MKC84LA222Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Stanford, ARWhen the pilot made his first swath run he flew over a set of wires, on the return run he went under the wires. The pilot said he hit his own prop wash and rolled enough for the wing tip to contact the wire.NTSB ATL84LA212Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Grenada, MSDuring arrival to an uncontrolled arpt, the plt made an apch while following about 1/4 mi behind a UH-1 helicopter. At that time, there was a quartering head wind at about 4 KTS. While on final apch at an alt of about 200 ft AGL, the Cessna 172 encountered…NTSB NYC84LA217Accident · No injuriesLimited investigationFinal reportCessna 50M · Middletown, PAThe solo student plt was approaching the rwy to make a landing when the twr gave him go-around instructions due to an shorts 3-30 acft on final. During the go-around the student said he encountered wake turbulence. The acft cartwheeled and came to rest with…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…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 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…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…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.