NTSB investigations, FL
1,375 cases where NTSB found Personnel issues.
Cases per year
| 2008 | 80 |
|---|---|
| 2009 | 73 |
| 2010 | 80 |
| 2011 | 86 |
| 2012 | 83 |
| 2013 | 67 |
| 2014 | 87 |
| 2015 | 75 |
| 2016 | 71 |
| 2017 | 72 |
| 2018 | 92 |
| 2019 | 92 |
| 2020 | 69 |
| 2021 | 61 |
| 2022 | 68 |
| 2023 | 60 |
| 2024 | 75 |
| 2025 | 57 |
| 2026 | 27 |
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\", '02'))
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", '02')) 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 ERA26LA330Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Leesburg, FLThe instructor’s delayed remedial action during an aborted landing, which resulted in a loss of airplane control.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 ERA26LA284Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Palmetto, FLThe flight instructor’s failure to maintain clearance from obstacles during low altitude maneuvering, which resulted in a collision with a fence.NTSB ERA26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportStits Playmate · Green Cove Springs, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA26LA248Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe student pilot’s failure to ensure clearance while taxiing, which resulted in contact with another airplane that was performing an engine run-up.NTSB ERA26LA238Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P-MENTOR · Pompano Beach, FLThe student pilot’s improper landing flare, which resulted in a hard landing, and the flight instructor’s delayed remedial action.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 ERA26LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Bartow, FLThe pilot’s failure to extend the landing gear before landing.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 ERA26LA146Accident · No injuriesClass 4 · LimitedFinal reportSchroder David Lancair IV-P · Feather Sound, FLThe pilot's failure to extend the landing gear before landing.NTSB ERA26LA139Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · St. Augustine, FLThe pilot's failure to extend the landing gear before landing.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 ERA26LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Pembroke Pines, FLThe pilot's failure to extend the landing gear before landing.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 ERA26LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 414A · Tampa, FLThe pilot’s failure to secure a bottle, which restricted movement of the right rudder pedal during landing.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 ERA26LA075Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-200 · Hawthorne, FLThe pilot’s failure to maintain an appropriate descent rate for a glassy water landing, which resulted in a hard landing.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 ERA26LA068Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Pierce, FLThe pilot’s inadequate visual lookout while taxing, which resulted in the airplane striking a light pole.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 ERA26LA058Accident · No injuriesClass 4 · LimitedFinal reportHuebbe Tom MAX TH · Inverness Highlands South, FLThe pilot’s failure to maintain directional control on takeoff. Contributing to the accident was the aircraft design that did not incorporate differential braking.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 ERA26LA045Accident · No injuriesClass 4 · LimitedFinal reportBeech 95 · Edgewater, FLThe pilot’s failure to extend the landing gear prior to landing.NTSB ERA26LA025Accident · No injuriesClass 4 · LimitedFinal reportAkrotech Giles G-202 · Boca Raton, FLThe low-wing pilot’s inadequate visual lookout, which resulted in a collision with another airplane while taxiing.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 ERA26LA002Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260 · Parkland, FLThe pilot’s failure to retract the amphibious airplane’s landing gear before conducting a forced landing on the water, which resulted in a nose over.NTSB ERA25LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Merritt Island, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA25LA335Accident · No injuriesClass 4 · LimitedFinal reportLafferty Jack SEA REY · Bell, FLThe pilot’s failure to raise the landing gear before landing on the water.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 ERA25LA293Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Inverness Highlands South, FLThe pilot’s inadequate monitoring of the airplane during taxi which resulted in collision with a sign.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.