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 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.NTSB ERA24LA033Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Orlando, FLA partial loss of engine power during initial climb after takeoff for undetermined reasons.NTSB ERA24LA030Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Pembroke Pines, FLThe pilot’s loss of airplane control and descent into terrain due to spatial disorientation during a solo night cross country flight. Contributing to the accident was the pilot’s self-reported fatigue.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 ERA24LA022Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20E · Pembroke Pines, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB ERA24LA011Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P2010 · Ocala, FLA total loss of engine power for reasons that could not be determined. Contributing to the accident was the flight instructor’s failure to maintain adequate airspeed and exceedance of the airplane’s critical angle of attack during the forced landing, which…NTSB ERA24LA009Accident · Minor injuriesClass 4 · LimitedFinal reportMonocoupe 90AL-115 · Myakka City, FLThe pilot’s failure to maintain adequate clearance from a fence during takeoff.NTSB ERA23LA379Accident · Minor injuriesClass 4 · LimitedFinal reportDorr Dan W Sequoia F.8L Falco · Sanford, FLThe pilot’s failure to maintain airplane control after an engine access cover opened during the initial climb.NTSB ERA23LA388Accident · No injuriesClass 3 · LimitedFinal reportRemos GX · Fort Pierce, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.NTSB ERA23LA365Accident · Minor injuriesClass 3 · LimitedFinal reportSheehan Kevin A Vans RV-8 · Umatilla, FLA total loss of engine power for reasons that could not be determined.NTSB ERA23FA352Accident · 2 fatalClass 3 · FieldFinal reportEurocopter EC135 · Pompano Beach, FLAn inflight fire outside of the engine firewalls, likely from overheating of the No. 1 engine for undetermined reasons, which resulted in a partial tailboom separation.NTSB ERA23LA350Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Immokalee, FLThe flight instructor’s inadequate supervision of the student pilot during hover flight, which resulted in main rotor blade contact with the ground after the student pilot applied a sudden control input.NTSB ERA23LA390Accident · Minor injuriesClass 4 · LimitedFinal reportIrwin Jeffrey C Buccaneer Biib · Sopchoppy, FLThe pilot’s improper recovery from a bounced landing.NTSB ERA23FA340Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Fort Pierce, FLThe left seat instructor’s intentional maneuvering of the airplane in an aerobatic steep turn for which it was not approved, which resulted in an exceedance of the structural limitations of the airplane and an inflight breakup.NTSB ERA23LA359Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 500 S · Key West, FLA total loss of engine power for reasons that could not be determined.NTSB ERA23LA337Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Haines City, FLA total loss of engine power due to fuel starvation for reasons that could not be determined.NTSB ERA23LA324Accident · Serious injuriesClass 3 · LimitedFinal reportJamros Robert L JR Challenger II · Port Orange, FLThe total loss of engine power due to an out-of-temperature seizure of the PTO cylinder.NTSB ERA23FA323Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Pembroke Pines, FLThe flight instructor’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and subsequent rapid descent into terrain.NTSB ERA23FA321Accident · 1 fatalClass 3 · FieldFinal reportKolb Firestar · McAlpin, FLA collision with trees during takeoff for reasons that could not be determined based on available information.NTSB ENG23LA033Incident · No injuriesClass 3 · LimitedFinal reportAirbus A320 · Jacksonville, FLThe loss of both Integrated Drive Generators (IDG) due to worn fixed cylinder block bores, which caused the IDGs to be tripped offline and caused the airplane to enter an emergency electrical configuration.NTSB CEN23LA354Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Clewiston, FLThe student pilot’s improper landing flare, which resulted in a hard landing on the nose landing gear. Contributing to the accident was the flight instructor’s inadequate supervision of the student pilot.NTSB DCA23LA395Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-214 · Fort Lauderdale, FLThe flight crew’s abrupt change in pitch in response to a traffic collision advisory system resolution advisory that resulted in a serious injury to a flight attendant.NTSB ERA23LA311Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Winter Haven, FLThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and collision with a taxiway sign.NTSB DCA23LA378Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-214 · Inverness, FLAn inadvertent encounter with convectively induced turbulence during descent.NTSB CEN23LA301Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer 269C-1 · Titusville, FLThe student pilot’s failure to maintain helicopter control while on the ground when his attention was diverted for post flight activities.NTSB ERA23LA290Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Clearwater, FLThe pilot’s improper preflight inspection which resulted in a loss of engine power due to fuel contamination (water).NTSB ERA23LA283Accident · Minor injuriesClass 3 · LimitedFinal reportAirborne Edge-X · Coral Gables, FLA partial loss of engine power for reasons that could not be determined.NTSB ERA23LA284Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269C · Macclenny, FLThe improper maintenance of the landing gear dampers and main rotor elastomeric dampers, resulting in ground resonance during an unsuccessful takeoff attempt with the helicopter near its maximum gross weight for the density altitude.NTSB ERA23LA272Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Wellington, FLWear of the fuel control unit drive shaft and the corresponding fuel pump drive gear, which resulted in the disengagement of the fuel control unit from the fuel pump, a decrease in fuel flow, and a loss of engine power.NTSB ERA23LA267Accident · Serious injuriesClass 3 · LimitedFinal reportFly Gyros M24 Orion · Venice, FLThe pilot’s failure to maintain directional control on takeoff for unknown reasons; whether the pilot’s acute stroke contributed to, or resulted from, the accident could not be determined.NTSB ERA23LA261Accident · No injuriesClass 3 · LimitedFinal reportDassault-Breguet Falcon 10 · Panama City, FLThe flight crew’s failure to appropriately configure the airplane for landing, which resulted in a failed attempt to utilize the thrust reversers during landing and the inability to stop the airplane using its brakes due to increased forward thrust.…NTSB ERA23LA269Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Orlando, FLThe pilot’s improper landing flare during a practice autorotation, which resulted in a hard landing.