NTSB investigations, 1985
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\") = 1985
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") = 1985 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 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 FTW85LA298Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Bonita, LAThe plt stated he was the second of two acft in a formation takeoff and he encountered severe wake turbulence from the other acft (same type). He stated that he dumped his load of chemicals but could not get above the pwr curve and the acft settled into a…NTSB CHI85LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochester, MNThe student pilot on first solo x-country was ld on the 7500 ft runway. Tower had cautioned on wake turbulance from departing DC-9. On flare sp said acft dropped in swerved left, cartwheeled and nosed down.NTSB CHI85LA268Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6G · Dixon, ILReportedly, the plt made a touch-&-go landing while following an snj acft. He stated that during the takeoff, the acft had accelerated to 85 mph when he lowered the tail slightly & the acft lifted off normally. He reported that the acft was aprx 4 to 5 ft off…NTSB NYC85FA145Accident · 1 fatalField investigationFinal reportSikorsky S76A · Belmar, NJDuring takeoff & landing practice for a pre-solo plt the CFI saw a helicopter, N176FJ, approaching the arpt. N4956B, at the time of 1st sighting, was on a left base for rwy 3. The rotorcraft apparently did not see N4956B or hear any radio calls at this…NTSB FTW85IA149Incident · No injuriesIncident investigationFinal reportBeech A36 · Dfw Airport, TXDrg arr, a Beech A36, N2057A, was vectored for an ILS rwy 17L apch while a hvy Boeing 747 was being vectored for an ILS rwy 18R apch. The ATC arrival controller (ctlr) stated he had 'staggered' the A36 bhnd the 747 with at least 3 mi sepn. After the A36 was…NTSB MIA85LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · W. Palm Beach, FLWhile en route, the plt contacted Palm Beach apch control & obtain flt following. He reported that he was 20 mi north & wished to proceed southbound along the coast. The controller acknowledged the request & advised the plt to remain VFR. The controller did…