NTSB investigations, FL
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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' 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' 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 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.NTSB ERA24LA105Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Parkland, FLA catastrophic engine failure due to oil starvation to the main bearings for undetermined reasons.NTSB ERA24FA104Accident · 3 fatalClass 3 · FieldFinal reportBeech V35 · Clearwater, FLAn in-flight engine compartment fire due to a partially loose flexible fuel hose b-nut at the fuel metering unit. Contributing to the severity of the accident was the pilot’s inability to visually identify the destination airport at night, which prolonged the…NTSB ERA24LA118Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Miami, FLTail rotor contact with an unseen object while performing a precautionary landing to a closed helipad at night.NTSB ERA24LA100Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Orlando, FLThe failure of the pilot flying to maintain directional control after touchdown with wind gusts that exceeded the airplane’s crosswind limitation. Contributing to the accident were the flightcrew’s continued approach to the runway despite the consistent wind…NTSB ERA24LA098Accident · Serious injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Zephyrhills, FLThe glider pilot’s failure to release from the towline after the tow plane experienced a loss of engine power.NTSB ERA24FA096Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Weston, FLThe pilots’ spatial disorientation in dark night visual meteorological conditions, which resulted in their failure to maintain altitude and a subsequent descent and impact with a swamp.NTSB ERA24LA092Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · New Smyrna Beach, FLA failure of the right brake during taxi, which resulted in a taxiway excursion and collision with a tree.NTSB ERA24LA093Accident · Serious injuriesClass 4 · LimitedFinal reportQuest Kodiak 100 · Lakeport, FLThe improper recovery from a bounced landing, which resulted in a hard landing and subsequent noseover.NTSB DCA24LA079Incident · No injuriesClass 3 · LimitedFinal reportBoeing 747-87UF · Miami, FLMaintenance personnel’s improper installation and inspection of the port M borescope plug, which resulted in an engine fire.NTSB ERA24LA079Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Daytona Beach, FLThe UAS operator’s failure to operate within the limitations of the COA that he was using to operate inside class C airspace, which resulted in a collision between the UAS and the helicopter.NTSB ERA24FA075Accident · 1 fatalClass 3 · FieldFinal reportHughes Helicopters 369E · Miami, FLMain rotor contact with the tail boom for unknown reasons, resulting in the separation of the tail boom.NTSB ERA24LA070Accident · No injuriesClass 3 · LimitedFinal reportBeech A24 · Miami, FLA partial loss of engine power during initial climb for undetermined reasons, resulting in a forced landing.NTSB ERA24LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Pahokee, FLThe flight instructor’s failure to maintain control of the airplane after encountering a wind gust during landing.NTSB ERA24LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Miami, FLThe business jet flight crew’s failure to appropriately position their airplane to mitigate the impact of their extended duration, high-power engine run, and their failure to adequately communicate these factors to air traffic control, which resulted in the…NTSB ERA24LA059Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Zephyrhills, FLAn aerodynamic stall from which the pilots did not recover while maneuvering in the airport traffic pattern.NTSB ERA24LA051Accident · No injuriesClass 3 · LimitedFinal reportLancair 235 · Stuart, FLA landing gear collapse due to a hydraulic fluid leak in the landing gear system.NTSB ERA24LA043Accident · Minor injuriesClass 3 · LimitedFinal reportLancair IV · Perry, FLA rapid throttle advancement after a period of idling, which resulted in a flooded engine and total loss of engine power.NTSB ERA24FA036Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Micanopy, FLThe non-instrument-rated pilot’s improper inflight decision making and his flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident were the pilot’s…NTSB ERA24LA041Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Lake City, FLA landing gear collapse following an aborted takeoff due to degraded climb performance for reasons that could not be determined.