NTSB investigations, FL
1,006 cases where NTSB found Task performance.
Cases per year
| 2008 | 50 |
|---|---|
| 2009 | 49 |
| 2010 | 47 |
| 2011 | 37 |
| 2012 | 54 |
| 2013 | 55 |
| 2014 | 75 |
| 2015 | 60 |
| 2016 | 57 |
| 2017 | 59 |
| 2018 | 79 |
| 2019 | 72 |
| 2020 | 56 |
| 2021 | 49 |
| 2022 | 50 |
| 2023 | 45 |
| 2024 | 56 |
| 2025 | 38 |
| 2026 | 18 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0206'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0206')) 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 ERA26LA313Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Milton, FLThe flight instructor’s failure to maintain control of the helicopter during a low hover over a grass area, which resulted in left skid contact with the ground and a dynamic rollover to the left.NTSB ERA26LA304Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Miramar, FLThe flight instructor’s failure to maintain control of the helicopter during a hover, which resulted in the left skid contacting ground and a subsequent dynamic rollover.NTSB ERA26LA300Accident · Serious injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Clermont, FLThe pilot’s failure to maintain clearance from trees during the landing approach.NTSB ERA26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportStits Playmate · Green Cove Springs, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA26LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Homestead, FLThe pilot’s excessive braking during the landing roll, which resulted in a nose over.NTSB ERA26LA184Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Tampa, FLThe pilot’s failure to maintain directional control of the airplane during the aborted landing, which resulted in a runway excursion, collision with a runway sign, and nose over.NTSB ERA26LA182Accident · No injuriesClass 4 · LimitedFinal reportDonald E Johnston Velocity XL-RG · Crestview, FLThe pilot’s failure to extend the landing gear before landing.NTSB ERA26LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Lutz, FLThe student pilot’s improper landing flare and the flight instructor’s inadequate remedial action, which resulted in a hard landing.NTSB ERA26LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Naples, FLThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA26LA170Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Jacksonville, FLThe pilot’s improper recovery from a practice autorotation, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving the instruction.NTSB ERA26LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Thonotosassa, FLThe pilot’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA26LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Okeechobee, FLThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB ERA26LA130Accident · No injuriesClass 4 · LimitedFinal reportTextron 680A · Miami, FLThe flight crew’s failure to maintain adequate clearance from the blast fence during taxi to the runway for departure, and their inadequate inspection of the airplane after it contacted the blast fence.NTSB ERA26LA119Accident · No injuriesClass 4 · LimitedFinal reportTabor W Coates AR-1 · Kissimmee, FLThe pilot’s failure to obtain the proper rotor rpm during the takeoff roll which resulted in a loss of control.NTSB ERA26LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 320C · Bartow, FLMaintenance personnel’s failure to perform an adequate inspection of the airplane’s landing gear, which resulted in a collapse of the left main landing gear during landing.NTSB ERA26LA108Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-3 · Palmetto, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA26LA100Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-3B · Floral City, FLThe student pilot’s loss of helicopter control during landing.NTSB ERA26LA090Accident · No injuriesClass 4 · LimitedFinal reportDevesh Tiwary Lightning XS · New Port Richey, FLThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB ERA26LA080Accident · No injuriesClass 4 · LimitedFinal reportVarga 2150A · Frostproof, FLThe pilot’s failure to maintain control of the airplane during takeoff, resulting in a runway excursion and collision with terrain.NTSB ERA26LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Lauderdale, FLThe student pilot’s improper landing flare and the flight instructor’s inadequate remedial action, which resulted in a hard landing and subsequent nose landing gear collapse.NTSB ERA26LA065Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Cocoa, FLThe flight crew’s failure to adequately manage the available fuel onboard the airplane, which resulted in a total loss of power due to fuel starvation.NTSB ERA26LA063Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · DeLand, FLThe flight instructor’s inadequate fuel quantity inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA26LA062Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Pensacola, FLThe pilot’s exceedance of the critical angle of attack during initial climb which resulted in an aerodynamic stall.NTSB ERA26LA060Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters Carbon Cub FX2 · Okeechobee, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA26LA053Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-23-250 · Clewiston, FLThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB ERA26LA044Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Eastpoint, FLThe pilot’s loss of airplane control during a go-around, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper recovery from an aerodynamic stall.NTSB ERA26LA023Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · St. Augustine, FLThe student pilot’s failure to properly set the elevator trim prior to takeoff, which resulted in her inability to effectively control the airplane’s pitch and a collision with trees at the end of the runway during initial climb.NTSB ERA25LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Merritt Island, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA25LA324Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · New Smyrna Beach, FLMaintenance personnel’s failure to detect and address water contamination of the airplane’s fuel system, which resulted in a total loss of engine power during initial climb.NTSB ERA25LA323Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Spring Hill, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.NTSB ERA25LA343Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · St. Petersburg, FLThe pilot’s failure to extend the landing gear prior to landing. Contributing to the accident was a malfunction of the landing gear’s electrical retraction/extension system, which tripped the circuit breaker.NTSB ERA25LA319Accident · No injuriesClass 4 · LimitedFinal reportWaco UBF · Tampa, FLThe pilot’s failure to maintain directional control during landing roll, which resulted in a runway excursion and collision with an object.NTSB ERA25LA382Accident · No injuriesClass 4 · LimitedFinal reportIcon A5 · Destin, FLThe pilot’s inadequate fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA266Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T337G · Pembroke Pines, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power to one of the airplane’s two engines. Contributing to the outcome was the pilot’s loading of the airplane beyond its maximum gross…NTSB ERA25LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · St. Augustine, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA256Accident · Serious injuriesClass 4 · LimitedFinal reportKyle Koncak Aventura II · DeLand, FLThe uncertificated pilot’s failure to remove an improvised gust lock which resulted in a loss of aircraft control at an altitude too low to recover.NTSB ERA25LA250Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Eustis, FLThe pilot’s inadequate preflight fuel planning and his failure to maintain directional control of the airplane after a total loss of right engine power during takeoff due to fuel starvation.NTSB ERA25LA217Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-23 · Palm Bay, FLA loss of engine power to both of the airplane’s engines due to fuel exhaustion and fuel starvation.NTSB ERA25FA201Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32RT · Yulee, FLThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the opening of the nose baggage door and subsequent distraction of the pilot…NTSB ERA25LA200Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Florida City, FLThe commercial pilot’s improper fuel management, which resulted in a loss of total engine power due to fuel starvation.NTSB ERA25LA194Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Hastings, FLThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA25LA184Accident · No injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Zolfo Springs, FLThe pilot’s failure to maintain control of the airplane during the takeoff. Contributing was the flight instructor’s lack of remedial action.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 ERA25LA207Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Winter Haven, FLThe pilot’s inadvertent movement of the fuel selector to a position that restricted fuel flow to the engine, which resulted in the loss of engine power during takeoff.NTSB ERA25LA192Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Fort Myers, FLThe pilot’s failure to maintain directional control of the airplane while landing in gusting crosswind conditions, which resulted in the left wing impacting the runway.NTSB ERA25LA160Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec · Chuluota, FLThe pilot’s failure to maintain lateral control of the helicopter during takeoff, which resulted in a dynamic rollover.NTSB ERA25LA159Accident · No injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · New Port Richey, FLMaintenance personnel’s inadequate inspection of the exhaust system, which allowed exhaust gases to enter the induction system from cracks in the exhaust manifold, resulting in a total loss of engine power and a subsequent forced landing.NTSB ERA25LA149Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Miami, FLThe student pilot’s failure to maintain control of the airplane during a go-around, which resulted in an aerodynamic stall.NTSB ERA25LA142Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206G · Wedgefield, FLA total loss of engine power as a result of an excessively rich fuel-to-air ratio due to the pilot’s failure to properly lean the engine’s fuel air mixture and the inadvertent activation of the auxiliary fuel pump.NTSB ERA25LA141Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Hollywood, FLA total loss of engine power was due to a fracture of the crankshaft at the No. 3 main journal, which originated from a preexisting, thermally induced crack that had gone undetected by maintenance personnel during an inspection performed as part of the…