NTSB investigations, FL
24 cases where the first occurrence was “On ground/water encounter with weather”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 5 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 3 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2006 | 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\" = 330)
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" = 330) 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 ANC06LA098Accident · No injuriesLimited investigationFinal reportCessna 402B · Ft. Lauderdale, FLThe pilot's continued flight into adverse weather, and his failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with an airport runway sign, and subsequent collapse of the nose gear. A factor…NTSB MIA04CA040Accident · No injuriesData collectionFinal reportCessna 210L · Fort Meade, FLThe failure of the pilot to abort the takeoff after encountering fog during the preflight and engine run-up, and also his failure to maintain proper alignment with the runway during the takeoff roll due to a fogged windshield resulting in the collision with a…NTSB ATL01LA111Accident · No injuriesLimited investigationFinal reportCessna 172N · Sarasota, FLThe pilot's improper in-flight decision to land at an airport with high wind conditions, which resulted in a loss of control on the ground during taxi operations and subsequent nose over of the airplane.NTSB MIA00LA179Accident · No injuriesLimited investigationFinal reportAerostar S57-A · Windermere, FLan in-flight collision with a tree. A factor in this accident was high wind conditions.NTSB MIA98LA080Accident · No injuriesLimited investigationFinal reportCessna 172H · St. Petersburg, FLa sudden encounter with wind gusts associated with a quickly passing rain shower which resulted in a nose-over, and subsequent collision with the runway.NTSB MIA95LA050Accident · Serious injuriesLimited investigationFinal reportBeech 95-C55 · Arcadia, FLPoor in flight planning/decision by the pilot for electing to land with fog on the airstrip. Contributing to the accident was failure of the pilot to obtain a formal preflight weather briefing and his failure to fully apply the brakes (normal) after landing.…NTSB MIA95LA020Accident · No injuriesLimited investigationFinal reportCessna 182-D · Deland, FLThe failure of the pilot to compensate for the gusty wind conditions during taxi for takeoff.NTSB MIA94LA150Accident · No injuriesLimited investigationFinal reportMooney M20-J · Apalachicola, FLThe pilot's inadequate compensation for the crosswind resulting in not maintaining alignment with the runway and the pilot's delay in aborting the landing. The crosswind was a factor.NTSB MIA93LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · La Belle, FLThe pilot in commands failure to correct for wind conditions during landing rollout resulting in the aircraft flipping over during wind gust encounter.NTSB MIA93LA087Accident · No injuriesLimited investigationFinal reportCessna 402B · Opa-Locka, FLFailure of the pilot-in-command to perform weight and balance calculations, exceeding the gross weight of the airplane, and disregarding wind information provided by the tower controller.NTSB MIA92LA092Accident · No injuriesLimited investigationFinal reportCessna 170A · Miami, FLFailure of the pilot in command to maintain directional control. Contributing to the accident was the unfavorable wind (windshift).NTSB ATL92LA046Accident · No injuriesLimited investigationFinal reportCessna 172 · Leesburg, FLThe unfavorable wind conditions encountered by the flight during taxi.NTSB MIA92LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bunnell, FLImproper handling of the aircraft by the pilot-in-command and failure to maintain directional control. Contributing to the accident was the lack of total experience of the pilot-in-command.NTSB MIA91LA173Accident · No injuriesLimited investigationFinal reportCessna 172N · Punta Gorda, FLFailure of the pilot to observe the windsock before landing resulting in failure to maintain directional control after landing with a quartering tailwind. The airplane collided with a ditch. Contributing to the accident was lack of total experience of the…NTSB MIA91LA133Accident · No injuriesLimited investigationFinal reportCessna 150L · Lake Wales, FLFailure of airport personnel to perform airport maintenance which resulted in inaccurate wind information due to a deteriorated windsock, and failure of the student pilot to maintain directional control during the landing roll with a tail wind. Also,…NTSB MIA91LA119Accident · No injuriesLimited investigationFinal reportCessna 150L · Palm Bay, FLLoss of control during the landing roll due to failure of the pilot to apply aileron control to prevent the airplane from drifting off the runway due to a crosswind and failure to maintain directional control. Contributing to the accident was the pilot's lack…NTSB MIA91LA081Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Plant City, FLFailure of the pilot to maintain proper alignment during the landing roll, excessive rudder input, and loss of directional control resulting in the collapse of the right main landing gear.NTSB MIA91LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fort Myers, FLThe failure of the pilot to maintain directional control while landing with shifting gusty winds.NTSB MIA90LA172Accident · No injuriesLimited investigationFinal reportPiper PA24-260 · Destin, FLThe pilots failure to obtain accurate wind information resulting in the airplane being blown off the runway on landing when a gust which exceeded the crosswind capability of the airplane was encountered.NTSB MIA90FA008Accident · 1 fatalField investigationFinal reportMcdonnell Douglas DC-9-31 · Orlando, FLInadequate weather evaluation and inadequate supervision of the ground guide (mechanic) by company/operator/management personnel, failure of the ground guide to follow safety procedures, and the weather condition (lightning).NTSB MIA87LA210Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLWhile taxiing from landing in reduced visibility the instructor plt stated that he was unable to establish whether or not the acft was on a taxiway. He was then attempting to reverse direction when the rt wing collided with a fence.NTSB MIA84LA159Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · New Smyrna Bch, FLWhile the plt was taxing onto the rwy, the wind picked up the right wing & the acft was blown inverted. The winds were gusting 30 KTS.NTSB MIA82DA065Accident · No injuriesFinal reportCessna 152 · Opa Locka, FLWhile doing touch and go landings the pilot observed a squall line approaching the airport. He proceeded to make a full stop landing and was taxiing to operations, when a strong gust of wind picked up the tail of the aircraft and flipped it over. The pilot…NTSB MIA82DA040Accident · Minor injuriesFinal reportCessna 152 · New Port Richey, FLThe pilot elected to land on runway 080 with winds from 170 degrees at 14 knots gusting to 25 knots. The aircraft ran off the side of the runway into soft sand where the nose wheel collapsed and the aircraft nosed over.