NTSB investigations, FL
10 cases where the first occurrence was “Vortex turbulence encountered”.
Cases per year
| 1984 | 2 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2007 | 1 |
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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' 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 MIA07CA044Accident · Serious injuriesData collectionFinal reportAirborne Windsports Classic · Sebring, FLThe pilot's delay on the runway prior to takeoff that resulted in an encounter with wake turbulence from a landing jet that had to perform a go-around.NTSB ATL98LA006Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-A1 · West Palm Beach, FLthe pilot's inadvertent use of the wrong runway, and his improper decision to continue the approach behind a large airplane (MD-80), which resulted in a wake turbulence encounter, loss of aircraft control, and collision with terrain.NTSB MIA93LA011Accident · 1 fatalLimited investigationFinal reportHunter Velocity · Apopka, FLAn encounter with wake turbulence from a Boeing 727.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 MIA87FA098Accident · No injuriesField investigationFinal reportPiper PA-34-200 · Miami, FLThe plt stated that he was on final approach & cleared to land long, when a 737 was cleared for an immediate takeoff and he was told to make s turns or whatever necessary. He slowed to land and when he was approximately 10 to 20 ft. in the air he encountered…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 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…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 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…