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 ERA24LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Zephyrhills, FLA partial loss of engine power during initial climb due to fuel contamination that resulted from corrosion and loose corrosion debris in the carburetor, which restricted fuel flow to the engine.NTSB ERA24LA256Accident · Minor injuriesClass 3 · LimitedFinal reportZenith 701 · Ocala, FLThe pilot’s failure to maintain aircraft control and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin during an attempted go-around.NTSB ERA24LA250Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Vero Beach, FLExcessive side loading of the vertical stabilizer.NTSB ERA24LA243Accident · Minor injuriesClass 4 · LimitedFinal reportEide Turner T-40A · Middleburg, FLThe pilot’s loss of control during climb out, which resulted in a collision with a tree.NTSB ERA24LA235Accident · No injuriesClass 3 · LimitedFinal reportTemco/Lazier TT-1 · Laurel Hill, FLThe pilot’s delay in turning on the fuel tip tank transfer pumps after departure, resulting in fuel starvation to the engine, engine flameout, and a subsequent forced landing.NTSB ERA24LA233Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32RT · Palmetto, FLThe pilot’s improper decision to re-attempt a takeoff with little runway remaining, after rejecting a takeoff in gusting wind conditions, which resulted in a runway overrun at a higher speed and collision with terrain.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 ERA24LA227Accident · 1 fatalClass 3 · LimitedFinal reportBrallier Scott Glasair I · Gulf of Mexico, FLThe non-instrument-rated pilot’s loss of airplane control due to spatial disorientation while flying over water in dark night conditions. Contributing to the accident was the pilot’s decision to conduct the overwater flight in conditions conducive to the…NTSB ERA24LA228Accident · Serious injuriesClass 3 · LimitedFinal reportSchleicher ASH 31 MI · Winter Haven, FLThe pilot’s failure to ensure that a suitable landing area was available in case the restart of the motor glider’s engine was unsuccessful. Contributing, was insufficient battery charge to extend the motor glider’s pylon assembly.NTSB DCA24LA200Accident · No injuriesClass 4 · LimitedFinal reportAergility Atlis 1 · Dunnellon, FLAn intermittent electrical failure that switched two motor controllers off, resulting in a loss of hover capability and impact with the ground.NTSB ERA24LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Vero Beach, FLAn in-flight collision with a bird while on approach.NTSB ERA24LA223Accident · No injuriesClass 3 · LimitedFinal reportBeechcraft TC-12B · Lehigh Acres, FLThe asymmetric reverse thrust during the landing roll for reasons that could not be determined, resulting in the flightcrew’s inability to maintain directional control and a subsequent runway excursion.NTSB ERA24LA398Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · St. Augustine, FLThe pilot’s improper landing flare resulting in a hard, bounced landing.NTSB ERA24LA215Accident · No injuriesClass 4 · LimitedFinal reportHughes 369 · Crestview, FLThe pilot’s improper flare, which resulted in a hard landing and the main rotor blades contacting the tail boom.NTSB ERA24LA211Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Apopka, FLA partial loss of engine power due to sticking exhaust valves. Contributing to the accident was maintenance personnel’s failure to use available engine data while troubleshooting a known engine issue and maintenance personnel’s failure to comply with…NTSB ERA24LA210Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Titusville, FLThe pilot’s failure to maintain directional control while landing in variable wind conditions, which resulted in runway excursion and collision with an approach light.NTSB ERA24LA208Accident · Serious injuriesClass 3 · LimitedFinal reportAdmore International Jets Aircam · DeLand, FLThe uncommanded movement of the left propeller into reverse during approach for undetermined reasons, resulting in an in-flight loss of control of the airplane at low altitude during approach.NTSB ERA24LA205Accident · No injuriesClass 3 · LimitedFinal reportAirbus Helicopters AS350B3 · Plant City, FLThe pilot’s inadequate yaw control of the helicopter while maneuvering at a low altitude and airspeed, which resulted in a hard landing.NTSB ERA24LA198Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Palatka, FLThe failure of the nose oil seal to remain secure in the engine crankcase, which resulted in a loss of engine oil and partial loss of engine power.NTSB ERA24LA197Accident · No injuriesClass 4 · LimitedFinal reportBeech F35 · McAlpin, FLThe pilot’s inadequate preflight planning and failure to abort the takeoff at the predetermined decision point.NTSB ERA24LA185Accident · 1 fatalClass 3 · LimitedFinal reportBailey-Moyes Dragonfly · Groveland, FLThe pilot’s improper installation and inspection of the right lower wing strut attachment bolt, which resulted in the inflight failure of the right wing.NTSB ERA24LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Holt, FLThe pilot’s failure to maintain an appropriate descent rate during the landing approach, which resulted in a hard landing and subsequent nose over of the airplane.NTSB ERA24LA166Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Key Biscayne, FLA loss of engine power for reasons that could not be determined.NTSB ERA24LA163Accident · Serious injuriesClass 3 · LimitedFinal reportEvektor-Aerotechnik A S Harmony LSA · Seffner, FLThe improper installation of the fuel line that connected the fuel pump to the four-way distributor, which resulted in fuel starvation when the line became disconnected.NTSB ERA24FA160Accident · 1 fatalClass 3 · FieldFinal reportArthur B Canning Merlin Lite · Mulberry, FLThe pilot/builder’s modifications of the motorglider’s engine, which resulted in an excessively lean fuel air mixture, preignition, piston failure, and a subsequent total loss of engine power during the initial climb. Contributing to the outcome was the…NTSB ERA24LA214Accident · No injuriesClass 3 · LimitedFinal reportBeech 95B55 · St. Augustine, FLThe incomplete extension of the landing gear into the down-and-locked position for reasons that could not be determined. .NTSB ERA24LA159Accident · Serious injuriesClass 3 · LimitedFinal reportDta Voyager II 912S · Clermont, FLLack of lubrication of the No. 4 connecting rod bearing, which resulted in a total loss of engine power.NTSB ERA24FA157Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-44-180 · Fort Pierce North, FLThe flight instructor’s failure to maintain control of the multiengine airplane after a partial loss of engine power on one engine during a go-around, which resulted in an aerodynamic stall. Contributing to the accident was the mechanic’s failure to check the…NTSB ERA24LA161Accident · No injuriesClass 3 · LimitedFinal reportNavion Navion B · Sanford, FLA sudden loss of all engine power during takeoff for undetermined reasons.NTSB ERA24FA154Accident · 2 fatalClass 3 · FieldFinal reportMooney M20K · St. Augustine, FLThe pilot’s failure to maintain adequate airspeed of the airplane while in the traffic pattern, which resulted in an aerodynamic stall/spin. Contributing was the pilot’s distraction due to the in-flight opening of the main cabin door, which resulted from the…NTSB ERA24LA153Accident · Minor injuriesClass 3 · LimitedFinal reportDenzil Velarde MTO Sport · Tavernier, FLThe gyroplane’s encounter with a tailwind during the initial climb, which resulted in a loss of airspeed and subsequent forced landing.NTSB ERA24LA149Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA28 · Apopka, FLThe pilot and the landscape worker’s inadequate visual lookout, which resulted in a collision.NTSB ERA24LA145Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Melbourne, FLThe student pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA24LA173Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pembroke Pines, FLAn inflight collision with a bird while approaching the destination airport.NTSB ERA24LA144Accident · No injuriesClass 3 · LimitedFinal reportGlasair Sportsman 2+2 · Fort Meade, FLThe pilot’s inadequate inspection of the airplane following an inflight smoke event, which result in separation of the exhaust pipe and hot exhaust igniting the engine cowling, and a subsequent loss of engine power.NTSB ERA24LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Homosassa Springs, FLThe pilot’s failure to confirm the throttle position before attempting to start the airplane’s engine by manually rotating the propeller, which resulted in a loss of airplane control.NTSB ERA24LA135Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Homestead, FLA loss of engine power due to carburetor ice as a result of the pilot’s failure to use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ERA24LA129Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11 · Fort Myers, FLThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB ERA24LA130Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200 · Zephyrhills, FLThe pilot’s failure to lower the landing gear before touchdown, which resulted in a gear-up landing.NTSB ERA24LA128Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters PA18-150 · Edgewater, FLMaintenance personnel’s failure to detect the worn aileron cable during the most recent inspections, which resulted in the separation of the aileron control cable and a subsequent loss of airplane control during landing.NTSB ERA24LA126Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Key Largo, FLThe pilot’s improper go-around technique, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB ERA24LA124Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Sanford, FLA total loss of engine power due to fuel starvation and the flight crew’s mismanagement of the available fuel.NTSB ERA24LA122Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Cape Coral, FLA total loss of engine power due to fuel starvation as a result of the pilot’s failure to properly secure a fuel supply line.NTSB ERA24LA216Accident · Serious injuriesClass 3 · LimitedFinal reportApellix B1 Washing Drone · Orlando, FLA failure of the sUAS’s magnetometer while operating in close proximity to commercial air conditioning equipment, which resulted in the sUAS’s erratic maneuvering. Contributing to the accident was the RPIC’s failure to input the appropriate command to disarm…NTSB ERA24LA117Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Dunnellon, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB ERA24LA115Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Pierson, FLThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA24LA119Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Polk City, FLThe glider pilot’s misjudged altitude, which resulted in an off-airport landing and collision with a fence.NTSB ERA24LA113Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Melbourne, FLThe pilot receiving instruction’s failure to correctly identify the runway centerline prior to initiating the nighttime takeoff, which resulted in a collision with a runway edge light and subsequent runway excursion. Contributing to the accident was the…NTSB ERA24FA110Accident · 2 fatalClass 3 · FieldFinal reportBombardier CL-600-2B16 · Naples, FLCorrosion of both engines’ variable geometry (VG) system components, which led to their operation in an off-schedule position and resulted in near-simultaneous sub-idle rotating compressor stalls on approach, subsequent loss of thrust in both engines, and an…NTSB ERA24LA111Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-301T · Palm Beach Gardens, FLThe pilot’s failure to maintain directional control of the airplane during the landing roll in a gusting crosswind.