NTSB investigations, FL
51 cases where NTSB found Descent/approach/glide path.
Cases per year
| 2008 | 3 |
|---|---|
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 5 |
| 2014 | 6 |
| 2015 | 6 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 9 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 1 |
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\", '01062040'))
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", '01062040')) 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 ERA24LA231Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Pierson, FLThe flight instructor’s failure to attain a proper touchdown point during a precautionary landing, which resulted in a runway excursion during landing.NTSB ERA24LA031Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ocklawaha, FLThe pilot’s failure to attain a proper touchdown point which resulted in a runway overrun and subsequent impact with a fence.NTSB ERA23LA153Accident · No injuriesClass 4 · LimitedFinal reportGreen Richard H VAN'S RV7A · Williston, FLThe hard landing and subsequent nose over during the forced landing. Contributing to the accident were the improperly secured canopy, and the distraction it created.NTSB ERA23LA021Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Daytona Beach, FLThe pilot’s misjudged landing point which resulted in a loss of control and collision with terrain.NTSB ERA23LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Sanford, FLThe pilot's unstable approach, which resulted in a hard landing and impact with a runway threshold light. Also causal was the flight instructor’s failure to take remedial action to prevent the hard landing.NTSB ERA22FA149Accident · 2 fatalClass 3 · FieldFinal reportCessna 182Q · Panama City, FLThe pilot’s deviation from the final approach course during a night instrument approach with low instrument meterological conditions, which resulted in an impact with heavily wooded terrain. Contributing to the accident was the pilot’s decision to continue…NTSB ERA22LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Immokalee, FLThe flight instructor’s delayed remedial action which resulted in the airplane impacting terrain short of the runway.NTSB ERA22LA006Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Williston, FLThe pilot’s failure to maintain clearance from terrain on approach which resulted in controlled flight into trees. Contributing to the accident was the flight instructor’s inadequate supervision of the approach path, the dark night conditions and the landing…NTSB ERA21LA261Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jupiter, FLThe flight instructor’s failure to obtain the proper touchdown point during a forced landing. Contributing to the accident was the improper service and subsequent inadequate inspection of the single-drive, dual magneto, which resulted in a total loss of…NTSB ERA21LA067Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Milton, FLThe pilot’s failure to attain a proper touchdown point and his landing with a high approach speed, which resulted in a runway overrun.NTSB ERA20CA153Accident · No injuriesData collectionFinal reportLancair Super ES · Merritt Island, FLThe pilot's failure to maintain a stabilized approach and improper landing flare, which resulted in a porpoised landing.NTSB ERA20LA037Accident · Serious injuriesClass 3 · LimitedFinal reportMosquito XE · Seffner, FLThe pilot's failure to maintain control of the helicopter while landing, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's lack of helicopter experience.NTSB GAA20CA088Accident · Serious injuriesData collectionFinal reportHiggins John H/Williams John D Questair Venture · Daytona Beach, FLThe pilot's unstabilized approach, which resulted in a hard, bounced landing, loss of directional control, and impact with a tree and then terrain.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 ERA19LA081Accident · No injuriesLimited investigationFinal reportCessna LC41 · Apopka, FLA partial loss of engine power during a go-around for reasons that could not be determined based on the available information, which resulted in a forced landing.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 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 ERA18LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA 44 · Daytona Beach, FLThe pilots’ improper in-flight weather evaluation and decision to continue the approach, which resulted in an encounter with a thunderstorm, a loss of airplane control, and collision with terrain. Contributing to the accident was the flight instructor’s…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 GAA18CA197Accident · No injuriesData collectionFinal reportPiper PA28 · Cedar Key, FLThe pilot’s unstabilized approach, which resulted in a long landing and subsequent runway overrun.NTSB ERA18LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Edgewater, FLThe flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach.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 ERA17LA306Accident · No injuriesLimited investigationFinal reportKerr Gerald Velocity SUV · St. Petersburg, FLThe pilot's misjudgment of the airplane’s speed and the distance remaining during landing and his improper decision to not abort the landing.NTSB GAA17CA213Accident · No injuriesData collectionFinal reportIcon A5 · Key Largo, FLThe pilot’s failure to maintain a proper descent rate during the approach, which resulted in a hard landing.NTSB GAA17CA138Accident · No injuriesData collectionFinal reportBeech T 34B · St. Petersburg, FLThe pilot's failure to maintain an appropriate glidepath to the runway.NTSB ERA16CA229Accident · No injuriesData collectionFinal reportCessna 182T · Crystal River, FLThe pilot's failure to execute a go-around following an unstabilized approach, which resulted in a bounced landing and runway excursion.NTSB ERA15LA380Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Sarasota, FLThe pilot’s failure to attain the proper touchdown point and to adequately slow the airplane within the available runway, which resulted in a runway overrun.NTSB ERA15FA361Accident · 1 fatalField investigationFinal reportCessna U206 · Spring Hill, FLThe pilot's failure to maintain a stabilized instrument approach, which resulted in a loss of control.NTSB ERA15LA372Accident · No injuriesLimited investigationFinal reportCessna A185F · Miami, FLThe pilot’s improper landing flare, which resulted in a hard landing and separation of the left main landing gear wheel from its strut.NTSB ERA15LA192Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Fort Myers, FLThe pilot's improper decision to land the airplane with a quartering, gusting tailwind and his subsequent failure to flare the airplane and maintain directional control after it bounced, which resulted in a runway excursion.NTSB ERA15CA196Accident · No injuriesData collectionFinal reportCessna 172P · Sebastian, FLThe pilot's misjudged airspeed and glidepath, which resulted in a landing area overshoot and runway excursion.NTSB ERA15CA143Accident · No injuriesData collectionFinal reportPiper J3C 65 · Clermont, FLThe pilot's failure to land the airplane within the desired touchdown zone, resulting in a long landing and collision with a fence.NTSB ERA14CA375Accident · Minor injuriesData collectionFinal reportCessna 172N · Valkaria, FLThe pilot's misjudgment of speed and distance on final approach during a precautionary landing, resulting in a touchdown off the departure end of the runway and collision with terrain. A factor in the accident was a partial loss of engine power for reasons…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 ERA14CA298Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Milton, FLThe pilot's failure to maintain the proper approach path, and his delayed remedial action, which resulted in a runway undershoot and collision with terrain prior to the runway.NTSB ERA14CA213Accident · No injuriesData collectionFinal reportBeech 76 · Fort Pierce, FLThe instructor's failure to obtain the proper touchdown point in a multiengine airplane, during a single-engine approach in a strong gusty headwind.NTSB ERA14IA237Incident · No injuriesIncident investigationFinal reportCessna 525 · Port Orange, FLThe pilot's failure to attain a proper touchdown point during landing and his failure to go around when he recognized that he would not be able to stop the airplane on the runway, which resulted in a runway excursion.NTSB ERA14CA136Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake Wales, FLThe pilot's improper flare during a water landing, which resulted in the wings contacting the water.NTSB ERA13CA016Accident · No injuriesData collectionFinal reportCessna 172P · Cedar Key, FLThe pilot's failure to attain the proper touchdown point, which resulted in a runway excursion.NTSB ERA12LA586Accident · No injuriesLimited investigationFinal reportStewart Mw/Stewart JD Sonerai 2L · Titusville, FLThe pilot's failure to attain the proper landing approach speed and touchdown point, which resulted in a runway excursion after touchdown and collision with a ditch.NTSB ERA12CA521Accident · Minor injuriesData collectionFinal reportCessna 152 · Deland, FLThe pilot’s failure to maintain airplane control on final approach in gusting wind conditions. Contributing to the accident was the pilot’s decision to operate in an environment of thunderstorms and rapidly deteriorating weather.NTSB ERA12FA387Accident · 1 fatalField investigationFinal reportPhillips William L Challenger · Plant City, FLThe non-certificated pilot’s loss of control during approach and landing. Contributing to the accident was the pilot’s lack of both total and recent flight experience.NTSB ERA12CA137Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · St Petersburg, FLThe flight instructor's delayed remedial action during the pilot-receiving-instruction's practice autorotation that developed a high rate of descent. Contributing to the accident was the pilot-receiving-instruction's improper control inputs during the…NTSB ERA12CA111Accident · No injuriesData collectionFinal reportErcoupe 415-C · Panacea, FLThe pilot did not attain the proper touchdown point during landing, which resulted in a runway overrun.NTSB ERA12CA010Accident · No injuriesData collectionFinal reportCalvin Nate H CALVIN-VELOCITY · Sebastian, FLThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot and collision with terrain prior to the runway.NTSB ERA11CA497Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Okeechobee, FLThe student pilot's failure to maintain the proper glidepath during a power-off landing and the flight instructor's delayed remedial action.NTSB ERA10CA419Accident · No injuriesData collectionFinal reportSchweizer SGS 1-34 · Groveland, FLThe pilot’s failure to attain the proper approach path to the runway, resulting in landing short of the runway.NTSB ERA09FA039Accident · 3 fatalField investigationFinal reportPartenavia P.68C · Gainesville, FLThe pilot's failure to maintain the proper glidepath during an instrument-landing-system (ILS) approach. Contributing to the accident were the pilot's decision to initiate the ILS approach with weather below the published minimums, and the pilot's…NTSB MIA08LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Hollywood, FLThe pilot's failure to achieve the proper touchdown point on landing and improper use of brakes. Contributing to the accident was the failure of the throttle cable attachment tab due to preexisting cracks.