Final NTSB investigations, FL
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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.\"completionStatus\" = 'Completed'
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."completionStatus" = 'Completed' 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 ERA25LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Arcadia, FLThe pilot’s failure to maintain directional control while landing.NTSB ERA25LA380Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter UH-1D · DeLand, FLThe pilot’s loss of helicopter control during landing approach in strong wind conditions, which resulted in tail rotor contact with the ground during landing.NTSB ERA25LA131Accident · No injuriesClass 4 · LimitedFinal reportMallory Horton AQUA-BEE · Miami, FLThe pilot’s failure to lower the landing gear before touchdown.NTSB ERA25LA125Accident · No injuriesClass 4 · LimitedFinal reportC K ING Adventure CCX-2000 · Okeechobee, FLA separation of the left main landing gear during landing.NTSB ERA25LA124Accident · Minor injuriesClass 4 · LimitedFinal reportDecker Daniel B Searey · Tavares, FLThe pilot’s improper flare during a bounced water landing, which resulted in a nose-down and submersion of the airplane’s open cockpit in the water.NTSB ERA25FA119Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Pierson, FLThe non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.NTSB ERA25LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Fort Myers, FLThe student pilot’s failure to maintain clearance from a truck while taxiing.NTSB ERA25LA109Accident · Serious injuriesClass 4 · LimitedFinal reportNear William J RV-7A · Weirsdale, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent nose over.NTSB ERA25LA102Accident · No injuriesClass 4 · LimitedFinal reportDaniel A Robinson High 6 Berkut 540 · Orlando, FLThe pilot’s failure to verify the canopy latches were in the locked position prior to takeoff.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 ERA25LA096Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Pompano Beach, FLThe separation of the securing hardware for the right main landing gear upper and lower torque links for undetermined reasons, which prevented extension of the right main landing gear.NTSB ERA25LA084Accident · Serious injuriesClass 4 · LimitedFinal reportBeech BE-76 · Melbourne, FLThe pilot’s inadequate preflight fuel planning which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing.NTSB ERA25LA089Accident · Serious injuriesClass 4 · LimitedFinal reportBuckeye Dream Machine · Myakka City, FLThe non-certificated pilot’s improper decision to operate the powered parachute in close proximity to a fence, which resulted in a collision with the fence during takeoff. Also causal was the pilot’s decision to operate the powered parachute without having…NTSB DCA25LA065Accident · Serious injuriesClass 3 · LimitedFinal reportUvify IFO · Orlando, FLThe remote pilot-in-command’s (RPIC’s) failure to locate the drone show center position over the physical location of the sUA, which resulted in multiple sUA colliding during the initial lift and subsequent loss of control. Contributing to the accident was…NTSB ERA25LA079Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT504 · Big Cypress, FLThe pilot’s decision to depart with cargo outside of the designated baggage compartment, which resulted in the cargo interfering with the rudder control system.NTSB ERA25LA072Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Pahokee, FLThe pilots' failure to see and avoid the other airplane, which resulted in a midair collision during short final approach.NTSB ERA25LA059Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Lakeland, FLThe pilot’s failure to maintain yaw control during a tailwind approach, which resulted in a loss of tail rotor effectiveness, an uncommanded spin, and subsequent hard landing.NTSB ERA25LA054Accident · No injuriesClass 4 · LimitedFinal reportJolly Warren T Bakeng Duce · Plant City, FLFailure of the right main landing gear attachment bolt and hold-down nut, resulting in the right main landing gear collapsing.NTSB ERA25LA068Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Daytona Beach, FLThe maintenance technician’s failure to follow the manufacturer’s recommended procedures during a wheel and tire change to ensure proper clearance of the tire to the wheel well resulting in the right main wheel becoming stuck in the well and subsequent…NTSB ERA25LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Palm Beach Gardens, FLThe pilot’s failure to maintain directional control of the airplane during landing in a gusting crosswind, which resulted in a hard landing and runway excursion.NTSB ERA25LA056Accident · No injuriesClass 4 · LimitedFinal reportFinn Lassen RV-4 · O'Brien, FLA total loss of engine power and navigational equipment as a result of a faulty battery.NTSB ERA25LA039Accident · No injuriesClass 4 · LimitedFinal reportCessna T240 · Fort Myers, FLThe pilot’s inadequate compensation for the prevailing wind conditions while landing, which resulted in a runway excursion and collision with a sign.NTSB ERA25LA026Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sebring, FLA birdstrike during descent to the destination airport.NTSB ERA25FA020Accident · 2 fatalClass 3 · FieldFinal reportGeisz Gilbert A Lancair 360 · Cross City, FLThe pilot’s exceedance of the critical angle of attack, which resulted in an aerodynamic stall at an altitude too low to recover. Contributing to the accident was the total electrical failure, which likely resulted in a loss of airspeed indication.NTSB ERA25LA035Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Merritt Island, FLA worn fuel selector valve, which resulted in a restriction of fuel flow to the engine and a total loss of engine power due to fuel starvation.NTSB ERA25LA006Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Moore Haven, FLThe pilot’s failure to initiate the cross country flight with an adequate fuel supply, resulting in a loss of engine power and forced landing due to fuel exhaustion.NTSB ERA25LA003Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Tampa Bay, FLA total loss of engine power in flight due to fuel starvation. Contributing to the accident was the inadequate preflight fuel planning by the student pilot and flight instructor, and the improper inflight fuel management by the student pilot.NTSB ERA24FA395Accident · 2 fatalClass 3 · FieldFinal reportEvolution Revo · Zephyrhills, FLThe flight instructor’s failure to ensure the haul back cable was securely connected to the “J” hook prior to departing on the accident flight, which resulted in the cable becoming disconnected and the wings folding up during flight.NTSB ERA24LA384Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · DeLand, FLThe parachutist’s failure to control his canopy which resulted in a downwind landing, an overshoot of the drop zone, and collision with a departing airplane.NTSB ERA24LA363Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 65-TAC · Clearwater, FLThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the outcome, was the pilot’s inability to control the engine following the loss of directional control due to the separation of a knob from the engine’s throttle…NTSB ERA24LA399Accident · No injuriesClass 3 · LimitedFinal reportBell Textron Canada 505 · Marianna, FLThe student pilot’s failure to maintain rotor rpm during a simulated autorotation, which allowed for a resonance phenomenon to develop. Contributing to the accident was the flight instructor’s inadequate monitoring of the student pilot’s collective control…NTSB ERA24LA348Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Orlando, FLThe student pilot's failure to maintain directional control during while landing with a crosswind. Contributing was the instructor’s delayed remedial action.NTSB ERA24LA347Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Gainesville, FLThe separation of a nose landing gear axle retaining nut and the subsequent the failure of the nose landing gear during landing.NTSB ERA24LA345Accident · No injuriesClass 4 · LimitedFinal reportKlutts Joe A CUB · DeLand, FLThe pilot’s failure to maintain directional control during landing.NTSB ERA24LA341Accident · No injuriesClass 3 · LimitedFinal reportBeech 23 · Jacksonville, FLThe pilot’s improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation while on final approach to land, and the subsequent hard landing, which resulted in separation of the airplane’s landing gear.NTSB ERA24LA330Accident · No injuriesClass 3 · LimitedFinal reportRaytheon A36 · Naples, FLContamination of the airplane’s fuel system with debris, which resulted in restricted fuel flow through multiple fuel injectors and the subsequent partial loss of engine power.NTSB ERA24LA336Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Immokalee, FLThe student pilot’s (of the high wing airplane) inadequate visual lookout, which resulted in a ground collision with another airplane while taxiing.NTSB ERA24LA328Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Groveland, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA24LA320Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Port St. Lucie, FLThe pilot’s failure to correctly identify the airport runway, which resulted in a landing on a road and contact with a power line. Contributing to the outcome was the sun glare.NTSB ERA24LA315Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Zephyrhills, FLThe loss of engine power due to the formation of carburetor ice as a result of the pilot’s delayed application of carburetor heat.NTSB DCA24LA241Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Orlando, FLThe captain’s inadvertent aggressive application of the brakes during taxi which resulted in a sudden stop. Contributing to the accident was the flight attendants’ failure to notify the flight crew of the unsecure cabin.NTSB ERA24FA300Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Palm Beach Gardens, FLA loss of engine power for reasons that could not be determined.NTSB ERA24LA313Accident · No injuriesClass 4 · LimitedFinal reportTrozzi Thomas Searey · Eustis, FLThe flight instructor's failure to properly configure the landing gear before performing a water landing.NTSB ERA24LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Clearwater, FLAn in-flight collision with a bird while flying in the airport traffic pattern.NTSB ERA24LA287Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350 · Sanford, FLThe helicopter pilot’s improper maneuvering at low altitude in gusty wind conditions, which resulted in the helicopter entering a vortex ring state, and hard landing during a subsequent autorotation.NTSB ERA24LA279Accident · Serious injuriesClass 3 · LimitedFinal reportAlexander S Rolinski Aventura II · DeLand, FLImproper installation of the electric-driven fuel pump inlet hoses, which resulted in a hose failure and subsequent loss of engine power due to fuel starvation.NTSB ERA24LA272Accident · No injuriesClass 4 · LimitedFinal reportAdams Walter R Searey · Sopchoppy, FLThe pilot’s improper landing flare, which resulted in abnormal contact with the water during landing.NTSB ERA24LA271Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Hernando, FLThe improper installation of a cylinder rocker stud by maintenance personnel, which resulted in a partial loss of engine power and subsequent forced landing.NTSB ERA24LA270Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Hernando, FLThe pilot’s inadvertent throttle input during landing which resulted in a runway overrun.NTSB ERA24LA263Accident · No injuriesClass 3 · LimitedFinal reportRotorway Exec · Alva, FLA loss of tail rotor control as a result of unsecured tail rotor drive belt tensioner bolts.