NTSB investigations, FL
41 cases where NTSB found Aircraft capability.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 5 |
| 2010 | 4 |
| 2011 | 2 |
| 2012 | 6 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 1 |
| 2025 | 2 |
Where
Latest 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\", '010610'))
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", '010610')) 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 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 ERA25LA098Accident · Minor injuriesClass 3 · LimitedFinal reportMontaer Ltda MC01 · Miramar, FLThe pilot’s delay in recognizing and acting upon the airplane’s reduced takeoff performance.NTSB ERA23LA161Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-46-350P · St. Augustine, FLThe pilot's inadequate preflight planning, which resulted in a takeoff above the airplane’s maximum gross weight, a CG forward of the limit, and a tailwind component that prevented the airplane from climbing above trees.NTSB ERA23LA020Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 100 · New Smyrna Beach, FLThe pilot’s exceedance of the critical angle of attack during takeoff and corresponding stall/mush. Contributing to the accident were the pilot’s operation of the airplane above the maximum specified gross weight.NTSB ERA22FA422Accident · 2 fatalClass 3 · FieldFinal reportWren Ronnie D Titan II · Citra, FLThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain airspeed while recovering from an aerobatic maneuver, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s use of…NTSB ERA22LA180Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 269A · Fort White, FLThe non-instrument-rated pilot’s decision to fly a visual flight rules only helicopter in instrument meteorological conditions, which resulted in a collision with trees and terrain.NTSB ERA21FA194Accident · 3 fatalClass 3 · FieldFinal reportBeech C23 · Middleburg, FLThe pilot's decision to depart from a soft grass runway with a tailwind, which resulted in an increased takeoff distance and subsequent impact with trees during the initial climb.NTSB ERA21LA139Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Pierce, FLThe pilot under instruction’s improper landing flare and attempted go-around which resulted in an aerodynamic stall, and subsequent loss of control. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA21LA036Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon 400A · Fernandina Beach, FLThe flight crew's improper decision to land with a tailwind on a wet runway, which resulted in a runway overrun. Contributing to the accident was the copilot’s early retraction of the speed brakes and the pilot’s decision to turn off the anti-skid system.NTSB DCA19MA143Accident · Minor injuriesClass 2 · MajorFinal reportBoeing 737 · Jacksonville, FLAn extreme loss of braking friction due to heavy rain and the water depth on the ungrooved runway, which resulted in viscous hydroplaning. Contributing to the accident was the operator’s inadequate guidance for evaluating runway braking conditions and…NTSB GAA18CA218Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Pensacola, FLThe pilot’s loss of directional control and long landing in gusting wind conditions due to his shoe getting stuck on the brakes.NTSB GAA18CA197Accident · No injuriesData collectionFinal reportPiper PA28 · Cedar Key, FLThe pilot’s unstabilized approach, which resulted in a long landing and subsequent runway overrun.NTSB CEN18FA061Accident · 5 fatalField investigationFinal reportCessna 340 · Bartow, FLThe pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.NTSB ERA17CA208Accident · No injuriesData collectionFinal reportPiper PA23 · Cedar Key, FLThe pilot's failure to stop the airplane within the available runway after conducting the approach and landing with a tailwind.NTSB ERA17TA170Accident · Serious injuriesFinal reportBell 206 · Orange Springs, FLThe pilot's failure to maintain adequate clearance between the helicopter's skid and the firefighting bucket and suspension cable, which resulted in the cable becoming entangled on the landing skid and a subsequent loss of helicopter control.NTSB ERA17FA145Accident · 1 fatalField investigationFinal reportPipistrel Virus SW · Micanopy, FLThe pilot's intentional flight into an area of known convective thunderstorm activity, which resulted in an in-flight breakup.NTSB ERA17LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cedar Key, FLA partial loss of engine power due to a stuck exhaust valve and the noncertificated pilot's inadequate preflight planning, which resulted in the airplane being overloaded, both of which led to the airplane's inability to attain a positive climb rate.…NTSB ERA16FA074Accident · 2 fatalField investigationFinal reportHinton Paul M RV 4 · Greenville, FLThe pilot's decision to initiate the flight into known adverse weather conditions, in an airplane that was not approved for instrument flight, which resulted in an encounter with instrument meteorological conditions and his subsequent spatial disorientation…NTSB GAA15CA289Accident · Minor injuriesData collectionFinal reportCessna 195 · Merritt Island, FLThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB ERA15CA021Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Everglades City, FLThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overshoot, runway excursion, and collision with vegetation and water.NTSB ERA14CA397Accident · Minor injuriesData collectionFinal reportRaytheon G36 · Milton, FLThe pilot's inadequate preflight planning, which resulted in an attempted takeoff over the airplane's maximum gross weight and beyond its aft center of gravity limit. Contributing to the accident was the pilot's lack of total flight experience in the aircraft…NTSB ERA14FA343Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · North Captiva Island, FLThe pilot’s failure to secure the cargo in the cargo compartment, which resulted in a weight shift that led to the center of gravity exceeding its aft limit during a go-around attempt and a subsequent aerodynamic stall. Also causal to the accident were the…NTSB ERA12FA491Accident · 1 fatalField investigationFinal reportSilvaire Luscombe 8A · St. Petersburg, FLThe flight instructor’s and the pilot’s failure to maintain airspeed after a partial loss of engine power after takeoff for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane…NTSB ERA12CA419Accident · No injuriesData collectionFinal reportCessna 172S · West Palm Beach, FLThe flight instructor’s failure to maintain airplane control during the takeoff in gusting crosswind conditions. Contributing to the accident was the flight instructor’s decision to conduct takeoffs and landings in conditions exceeding the airplane’s maximum…NTSB ERA12FA326Accident · 1 fatalField investigationFinal reportGutierrez Pablino Hummel Bird · DeFuniak Springs, FLThe pilot's failure to maintain airplane control due to the airplane’s exceedence of its maximum gross weight and center of gravity’s most rearward limit and his lack of familiarity with the airplane make and model, which resulted in an aerodynamic stall and…NTSB ERA12LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe student pilot’s decision to depart from an intersection with insufficient runway remaining for takeoff, which resulted in a rejected takeoff and subsequent runway excursion.NTSB ERA12CA278Accident · Minor injuriesData collectionFinal reportPiper PA-18A · West Palm Beach, FLThe inadequate assembly of the brakes, which caused them to lock during the landing roll when the airplane transitioned from asphalt to turf, resulting in the airplane nosing over.NTSB ERA12LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA46 · Wellington, FLThe pilot's failure to maintain directional control of the airplane during the takeoff roll, which resulted in a collision with a tree.NTSB ERA12LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Mulberry, FLThe pilot’s failure to abort the takeoff after recognizing the airplane’s poor performance during the takeoff roll. Contributing to the passenger’s injuries was the pilot’s failure to provide a briefing on the use of the lapbelt, which delayed the passenger’s…NTSB ERA11LA451Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Arcadia, FLThe pilot’s decision to take off in high density altitude conditions with the airplane over its maximum gross weight, due to the pilot’s improper weight and balance calculations, which resulted in the airplane’s inability to climb or maintain altitude.NTSB ERA11CA059Accident · No injuriesData collectionFinal reportHiller-Rogerson Helicopter UH12E · Madison, FLThe pilot's encounter with a settling with power condition while he was performing slow, low-level, out-of- ground-effect flight maneuvers.NTSB ERA10LA450Accident · No injuriesLimited investigationFinal reportAir Tractor AT402 · Pompano Beach, FLThe pilot's delayed decision to abort the takeoff, which resulted in a runway overrun and a subsequent collision with obstacles and terrain. Contributing to the accident was the airplane's high gross weight.NTSB ERA10CA445Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC42-550FG · Tampa, FLThe pilot's failure to reduce engine power following a high-powered engine start.NTSB ERA10LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Clearwater, FLThe overweight condition of the airplane due to the pilot's inadequate preflight planning, resulting in the airplane's degraded climb performance. Contributing to the accident was the pilot's retraction of the flaps prior to reaching the manufacturer's…NTSB ERA10GA015Accident · No injuriesFinal reportBell OH-58A · Ocala, FLThe excessive wear and failure of engine governor components for undetermined reasons, which resulted in a loss of engine power.NTSB ERA09CA545Accident · No injuriesData collectionFinal reportKermit Weeks Quicksilver · Polk City, FLThe pilot’s failure to adequately inspect the landing gear floats for water prior to takeoff.NTSB ERA09LA502Accident · 2 fatalLimited investigationFinal reportM-Squared Sprint 1000 · Madeira Beach, FLA loss of torque to the gearbox engine-side coupling flange bolts, which resulted in separation of the gearbox and propeller from the engine and the subsequent severing of the airplane's tail structure.NTSB ERA09LA398Accident · 2 fatalLimited investigationFinal reportBarber John A Glasair · Switzerland, FLA loss of control in flight for undetermined reasons. Contributing to the accident was the pilot's performance of aerobatic maneuvers at altitudes lower than those recommended by the kit manufacturer, resulting in insufficient terrain clearance to conduct a…NTSB ERA09LA229Accident · 1 fatalLimited investigationFinal reportGaynor Donald J RV6A · Englewood, FLThe pilot's operation of the airplane while impaired (alcohol) and his decision to attempt aerobatic maneuvers at a low altitude resulting in the loss of aircraft control and subsequent collision with trees.NTSB NYC08FA133Accident · 4 fatalField investigationFinal reportCessna 172 · Indiantown, FLThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude. Contributing to the accident was the overweight condition of the airplane and the inoperative stall warning horn.NTSB MIA08FA038Accident · 3 fatalField investigationFinal reportCessna 172L · Clearwater, FLThe pilot's failure to maintain airspeed while maneuvering for approach to land. Contributing to the accident was the pilot's operation of the airplane above the design gross weight.