NTSB investigations, FL
79 cases where the sequence of events included Attempted remediation/recovery.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 5 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 8 |
| 2017 | 7 |
| 2018 | 21 |
| 2019 | 7 |
| 2020 | 8 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 2 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 DCA26FA019Accident · No injuriesClass 4 · FieldFinal reportAir Vev AIR ZERO2 · Indiantown, FLA cascading shutoff of multiple aft motors due to a sudden increase in motor loads during maneuvering, resulting in a loss of control.NTSB ERA25LA180Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8F · Punta Gorda, FLThe pilot’s failure to maintain direction control of the airplane during the landing roll.NTSB ERA25FA066Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW24 · Vero Beach, FLOn December 6, 2024, about 1240 eastern standard time, a Schleicher ASW 24 glider, N244RW, was substantially damaged when it was involved in an accident near Vero Beach, Florida. The pilot was fatally injured. The glider was owned by a local soaring club and…NTSB ERA23LA211Accident · Minor injuriesClass 4 · LimitedFinal reportAeropilot S R O Legend 600 · Vero Beach, FLThe pilot's improper recovery from a bounced landing, which resulted in a nose landing gear collapse and subsequent noseover. Contributing was the rough condition of the runway, as described by the pilot, and his decision to operate from it.NTSB ERA23FA185Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Sebastian, FLThe pilot’s failure to maintain airplane control during recovery from a bounced landing, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ERA22LA404Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Saint Cloud, FLThe pilot’s continuation of the instrument approach into known extreme precipitation and turbulence associated with a thunderstorm, resulting in excessive altitude deviations that required him to activate the Cirrus Airframe Parachute System.NTSB ERA21LA103Accident · No injuriesClass 3 · LimitedFinal reportTL Ultralight Sro Stingsport · Hollywood, FLThe inadequate maintenance and inspection of the fuel system, which resulted in a partial loss of engine power. Contributing was the pilot's mismanagement of the emergency approach and landing, which resulted in a runway overrun.NTSB ERA20CA143Accident · No injuriesData collectionFinal reportDiamond DA42 · Palm Coast, FLThe pilot receiving instruction’s failure to maintain airplane control during a simulated engine failure landing and subsequent attempted go-around in gusting crosswind conditions and the flight instructor's delayed remedial action.NTSB ERA20CA130Accident · No injuriesData collectionFinal reportCessna 172 · West Palm Beach, FLThe failure of the nosewheel steerage linkage during takeoff, which resulted in a loss of directional control and impact with an obstacle during an attempted aborted landing.NTSB ERA20CA106Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Tampa, FLThe flight instructor's inadvertent throttle reduction below idle, which resulted in a total loss of engine power and subsequent impact with terrain following a power-off autorotation.NTSB ERA20CA104Accident · No injuriesData collectionFinal reportSchweizer 269C · Ormond Beach, FLThe student pilot's improper pedal and cyclic input while maneuvering, which resulted in a loss of helicopter control.NTSB ERA20CA093Accident · No injuriesData collectionFinal reportCessna 172 · Crystal River, FLThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and subsequent nose-over.NTSB ERA20CA099Accident · No injuriesData collectionFinal reportPiper PA28 · Naples, FLThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and impact with sign.NTSB ERA20CA087Accident · No injuriesData collectionFinal reportVans Vans RV 8 · Fernandina Beach, FLThe pilot receiving instruction’s loss of directional control on landing with a crosswind, which resulted in a runway excursion and the left main landing gear collapsing.NTSB ERA20LA094Accident · Serious injuriesClass 3 · LimitedFinal reportAirborne America AX9-140 · Homestead, FLThe pilot's decision to operate the balloon at low altitude near obstructions, structures, and powerlines, which resulted in the balloon contacting powerlines. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of…NTSB ERA20CA058Accident · Minor injuriesData collectionFinal reportCessna P210 · Gainesville, FLThe airplane's impact by a bird during the initial climb.NTSB ERA20TA030Accident · No injuriesClass 3Final reportBeech 76 · Doral, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB GAA20CA050Accident · No injuriesData collectionFinal reportPiper PA 30 · Opa Locka, FLThe pilot receiving instruction's failure to relinquish the flight controls to the flight instructor during a simulated engine failure during takeoff, which resulted in the airplane touching down in a left banking attitude and the landing gear collapsing.NTSB GAA19CA383Accident · No injuriesData collectionFinal reportPiper PA28 · Milton, FLThe flight instructor's intentional overapplication of rudder to avoid a ditch during landing with a tailwind, which resulted in a runway excursion and landing gear collapse.NTSB GAA19CA326Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe student pilot's excessive rudder application during takeoff and the flight instructor's delayed remedial action, which resulted in a loss of directional control, a runway excursion, and subsequent substantial damage.NTSB GAA19CA198Accident · No injuriesData collectionFinal reportCessna 195 · Ormond Beach, FLThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the nose landing gear collapsing.NTSB GAA19CA121Accident · No injuriesData collectionFinal reportEurocopter AS 350 · Tampa, FLThe pilot's improper landing flare while practicing autorotations, which resulted in a hard, bounced landing.NTSB ERA19LA079Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Lauderdale, FLA total loss of engine power due to the fatigue fracture of the No. 2 exhaust rocker arm stud.NTSB GAA19CA085Accident · Minor injuriesData collectionFinal reportCessna 172 · St. Petersburg, FLThe pilot's failure to remove the gust lock before flight, which resulted in the airplane’s inability to rotate and a subsequent runway overrun. Contributing to the accident was the pilot’s failure to follow the preflight checklist.NTSB ERA19LA050Accident · Minor injuriesClass 3 · LimitedFinal reportUltralite Sro Stingsport · Clermont, FLAn inflight failure of the airplane’s horizontal stabilizer.NTSB GAA19CA081Accident · No injuriesData collectionFinal reportCessna 172 · Inverness, FLThe pilot receiving instruction's failure to maintain directional control during landing.NTSB GAA19CA046Accident · No injuriesData collectionFinal reportBeech 55 · Gainesville, FLThe pilot's inadvertent landing gear retraction during the landing roll, which resulted in a canted left main landing gear and the wing dragging during the subsequent landing following a go-around.NTSB ERA18LA257Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Winter Haven, FLThe student pilot’s improper pitch attitude control during the initial climb, which resulted in a loss of airspeed, and his subsequent decision to conduct a 180° turn following the perceived anomaly, which resulted in a runway overrun.NTSB ERA18TA267Accident · Serious injuriesClass 3Final reportGrob G103 Twin Astir · Groveland, FLThe student pilot's failure to relinquish the flight controls during landing when the flight instructor told him to do so, and the instructor’s subsequent inability to properly control the glider, which led to a hard landing.NTSB GAA18CA559Accident · No injuriesData collectionFinal reportPiper PA34 · Miami, FLThe pilot under instruction’s failure to maintain the twin-engine airplane’s minimum control airspeed with one engine inoperative and the flight instructor’s distraction when reconfiguring the airplane following the simulated engine failure, which resulted in…NTSB GAA18CA427Accident · Minor injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot’s inadvertent encounter with thunderstorm conditions and her failure to maintain a proper landing flare in a crosswind, which resulted in a bounced landing.NTSB GAA18CA406Accident · No injuriesData collectionFinal reportBeech 76 · Fort Lauderdale, FLThe pilot receiving instruction's failure to maintain a proper approach path and her delayed go-around during a simulated emergency landing, which resulted in landing short of the runway. Contributing to the accident was the flight instructor's failure to…NTSB ERA18LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 34-200 · Umatilla, FLMaintenance personnel ‘s failure to complete and verify the proper installation of the main landing gear (MLG) torque links’ attachment hardware, which resulted in the right MLG torque link disconnecting and the pilot’s subsequent inability to maintain…NTSB GAA18CA344Accident · No injuriesData collectionFinal reportBeech A36 · Arcadia, FLThe pilot’s loss of directional control during landing due to a flat tire.NTSB GAA18CA343Accident · Serious injuriesData collectionFinal reportAmerican AA · Port Orange, FLThe pilot’s inadequate preflight inspection of the fuel, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB GAA18CA261Accident · Minor injuriesData collectionFinal reportZenair CH 2000 · Naples, FLThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB ERA18LA145Accident · No injuriesLimited investigationFinal reportPiper PA28 · Vero Beach, FLWater contamination of the fuel supply, which resulted in a total loss of engine power.NTSB GAA18CA243Accident · No injuriesData collectionFinal reportCessna 310 · Gainesville, FLThe pilot’s failure to maintain an adequate approach path at night, which resulted in a tree strike.NTSB GAA18CA204Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot’s failure to maintain a stabilized approach, which resulted in overcorrection with the rudder during the landing, loss of control, and a runway excursion.NTSB ERA18LA102Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 32-300 · Pompano Beach, FLThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, which resulted in an aerodynamic stall, loss of control, and impact with terrain. Contributing to the accident was the pilot’s failure to maintain a proper approach…NTSB GAA18CA142Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna Astore · Apopka, FLThe student pilot’s failure to maintain directional control during takeoff.NTSB ERA18LA089Accident · 1 fatalClass 2 · LimitedFinal reportAirborne Windsports PTY Edge XT 912 L · Eustis, FLThe pilot's exceedance of the weight-shift-control aircraft's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot's lack of experience in the…NTSB ERA18LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · Marathon, FLThe pilot's failure to maintain directional control during takeoff.NTSB ERA17LA242Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Key Biscayne, FLThe nearly complete blockage of the right fuel tank strainer with organic material, which resulted in fuel starvation and the subsequent total loss of engine power. Contributing to the fuel starvation was the pilot receiving instruction’s and the flight…NTSB GAA17CA391Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Ferguson, FLThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA211Accident · No injuriesData collectionFinal reportMooney M20J · Cedar Key, FLThe pilot’s failure to follow the manufacturer’s go-around procedure, which resulted in an aerodynamic stall.NTSB ERA17LA160Accident · No injuriesLimited investigationFinal reportCessna 172 · Yankeetown, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA17CA209Accident · No injuriesData collectionFinal reportCessna 140 · St. Petersburg, FLThe pilot receiving instruction’s overcorrection with rudder during the landing roll, which resulted in a ground loop and runway excursion. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA17CA138Accident · No injuriesData collectionFinal reportBeech T 34B · St. Petersburg, FLThe pilot's failure to maintain an appropriate glidepath to the runway.NTSB GAA17CA136Accident · Minor injuriesData collectionFinal reportNielsen Martin M Challenger II · Punta Gorda, FLThe pilot’s failure to maintain directional control during landing.