NTSB investigations, 1986
7 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\") = 1986
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") = 1986 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 MIA87LA023Accident · No injuriesLimited investigationFinal reportCessna 421C · Tampa, FLThe flt had been cleared for a visual approach behind a Lockheed L-1011 aircraft and was warned to use caution against wake turbulence. The flight encountered the wake turbulence of the L-1011 at 1600 feet. Control could not be maintained and the aircraft…NTSB MIA87LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ft. Pierce, FLA USCG helicopter had landed on rwy 4 moments before the accident and had cleared the rwy. The helicopter had advised the acft on UNICOM frequency of his intent to land. The acft advised the helicopter that he had him in sight and would follow him in. The…NTSB FTW87LA013Accident · No injuriesLimited investigationFinal reportCessna 182J · England Afb, LAThe plt was on an apch into England Afb, LA, behind a flt of 4 jet fighters. He stated that at aprx 200 ft past the threshold, while at about 3 ft AGL & 80 mph, the acft suddenly fell & touched down on the main gear. It then porpoised btn the main & nose gear…NTSB ANC87LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · King Salmon, AKThe pilot was cleared to taxi his airplane into position and to hold behind a cherokee six airplane. After the cherokee six departed, he was cleared for takeoff. Immediately after lift off at 10 to 15 feet above the runway, the pilot stated the airplane went…NTSB LAX86LA263Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Truckee, CADuring an air show 3 North American, AT-6, acft took off in what the plt of the 3rd acft described as 'staggered' sequence. A witness described the departures as being 'information' or in 'close proximity' to each other. The first 2 acft gained altitude…NTSB LAX86FA221Accident · 1 fatalField investigationFinal reportAerospatiale TB20 · Van Nuys, CAWhile in the traffic pattern for rwy 16L the light acft plt was cautioned about possible wake turbulence from an arriving C-130 hercules acft landing on rwy 16R. The light acft plt acknowledged observing the C-130, which was above him. The C-130 landed on rwy…NTSB SEA86FA047Accident · 1 fatalField investigationFinal reportCessna TR182RG · Reno, NVThe pilot was flying his Cessna TR182RG back to Reno cannon airport, a facility with a frequent mixture of light general aviation aircraft and heavy turbine air carrier operations. The pilot had acquired the majority of his terminal experience in and around…