NTSB investigations, 1988
9 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\") = 1988
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") = 1988 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 CHI89LA041Accident · No injuriesLimited investigationFinal reportCessna 152II · Grand Rapids, MIPilot's total lack of experience in this type of operation.NTSB LAX89LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Van Nuys, CAThe pilot lost control of the aircraft while descending for landing and collided with a pole. The pilot stated that he was cleared to land behind a king air, on runway 16R. The pilot stated that about the time he descended to 50 feet AGL, near the threshold,…NTSB ATL89LA038Accident · Serious injuriesLimited investigationFinal reportCessna 152F · Harkers Island, NCThe plt rprtd he was orbiting over a school of fish at aprx 800' when he encountered wake turbulence from his own acft. He believed that a wider orbit would have prevented him from flying back into the wake & additional altitude would have provided more time…NTSB MIA89LA022Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe plt taxied to rwy 6 & made an eng run-up. As he called the twr for tkof, a navy P-3 was making a low apch to rwy 10.the plt was told to taxi to rwy 10. Abt 30 sec later, as he arrived at rwy 10, he was clrd for tkof & was cautioned abt wake turbc fm the…NTSB ATL89MA023Accident · 1 fatalMajor investigationFinal reportCessna 210D · Nashville, TNDrg west arr at ngt, plt was vctrd for a VFR, straight-in apch to rwy 2R & adzd of Boeing 727 off his rgt front, passingfm rgt to left. He was cautioned abt wake turbc (w/t) & replied, 'okay I see him.' Ctlr then told plt to turn inbnd & maint 'visual' with…NTSB LAX88IA295Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC9-51 · Honolulu, HIThe aircrafts encounter with the engine exhaust flow and related turbulence from a heavy Boeing 747, which crossed the approach end of the runway about 1 minute and ten seconds prior to the incident.NTSB MKC88LA064Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Manter, KSWhile conducting a team aerial application operation, the trailing aircraft struck the terrain with the right wing tip, rotated in a flat attitude about 2 turns, and was destroyed by fire. The pilot said, while in a downwind procedure turnaround, into the…NTSB LAX88LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · El Toro, CAThe student plt was practicing touch-&-go landings & was cleared for an apch behind a C-130. He stated that he noted the touchdown point of the C-130 & planned his apch to remain above the C-130'S flt path. However, just before landing, when the acft was at…NTSB DEN88LA048Accident · No injuriesLimited investigationFinal reportRotorway Executive · Colorado Spring, COThe plt contacted ground control & was cleared to taxi from a hangar on the south end of the arpt to a hangar on the north end via twy-a. twy-a was located 400' west & parallel to rwy 17/35. The plt said he was air taxiing the helicopter just above the…