NTSB investigations, FL
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 ERA19LA227Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Hastings, FLThe pilot’s failure to secure the engine primer control, which resulted in an overly rich fuel/air mixture and degraded engine performance. Contributing to the accident was the pilot’s failure to abort the takeoff in a timely manner.NTSB GAA19CA467Accident · No injuriesData collectionFinal reportCessna 525 · Orlando, FLThe airplane’s impact with a bird during approach.NTSB GAA19CA466Accident · No injuriesData collectionFinal reportDiamond DA 42 NG · Palatka, FLThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended due to distraction, which resulted in a gear-up landing.NTSB ERA19TA223Accident · No injuriesClass 3Final reportCessna 180 · Okeechobee, FLThe pilot’s failure to maintain directional while landing with a quartering tailwind, which resulted in a ground loop.NTSB GAA19CA431Accident · No injuriesData collectionFinal reportDiamond DA40 · Tavernier, FLThe pilot's delayed decision to go around in high-temperature and high-density altitude conditions and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA19TA211Accident · No injuriesClass 3Final reportCessna 208 · Plant City, FLThe pilot's improper landing flare due to reduced visibility from a foggy windshield and his failure to use the airplane’s windshield defrost system, which resulted in a hard landing and subsequent nose landing gear collapse.NTSB ERA19LA217Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 77 · Leesburg, FLA partial loss of engine power due to carburetor icing, which resulted from the flight instructor's decision not to use carburetor heat.NTSB GAA19CA383Accident · No injuriesData collectionFinal reportPiper PA28 · Milton, FLThe flight instructor's intentional overapplication of rudder to avoid a ditch during landing with a tailwind, which resulted in a runway excursion and landing gear collapse.NTSB ERA19LA206Accident · No injuriesClass 3 · LimitedFinal reportBell OH58C · Gainesville, FLThe flight instructor's failure to maintain control of the helicopter during a simulated forced landing autorotation, which resulted in pylon whirl that substantially damaged the helicopter.NTSB GAA19CA413Accident · No injuriesData collectionFinal reportCessna 152 · Clewiston, FLThe student pilot's maneuver to the left to avoid striking birds during takeoff and his subsequent loss of directional control after aborting the takeoff and landing on soft, muddy grass adjacent to the runway during, which resulted in a nose-over.NTSB GAA19CA415Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB CEN19LA174Accident · No injuriesClass 3 · LimitedFinal reportRobinson R44 · Key West, FLThe failure of maintenance personnel to properly secure the right-side tail boom mounting bolts which resulted in the failure of the bolts and an inflight separation of the tail rotor.NTSB GAA19CA362Accident · No injuriesData collectionFinal reportCessna 172 · Tampa, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose-over.NTSB ERA19FA193Accident · 2 fatalField investigationFinal reportCessna 182 · Maitland, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN19LA168Accident · No injuriesClass 3 · LimitedFinal reportRockwell 690 · Jacksonville, FLThe overstress fracture of the roll pin in the nose landing gear (NLG) spacer assembly which caused interference between the nose wheel actuator rod and the left forward gear door actuating rods preventing the NLG to fully extend into the full down and locked…NTSB GAA19CA326Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe student pilot's excessive rudder application during takeoff and the flight instructor's delayed remedial action, which resulted in a loss of directional control, a runway excursion, and subsequent substantial damage.NTSB ERA19FA183Accident · 1 fatalClass 3 · FieldFinal reportVans Vans RV 4 · Green Cove Springs, FLThe failure of each pilot to maintain separation from the other airplane during intentional maneuvers within close proximity of each other.NTSB DCA19CA153Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A320 · Fort Lauderdale, FLA buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the pot locking lever was raised.NTSB CEN19LA157Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Palm City, FLA total loss of engine power due to fuel starvation.NTSB GAA19CA337Accident · No injuriesData collectionFinal reportVans RV10 · Fort Drum, FLThe pilot's failure to maintain the proper airspeed during approach, which resulted in an aerodynamic stall.NTSB CEN19LA147Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210 · Yankeetown, FLA loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA19CA272Accident · No injuriesData collectionFinal reportPiper PA28 · Maitland, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, the total loss of engine power, and subsequent impact with a car during an emergency landing on a road.NTSB ERA19FA170Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 30 · Naples, FLIncapacitation of the pilot due to a birdstrike through the windshield in front of the pilot's position, while on approach to land.NTSB WPR19LA136Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Winter Haven, FLA partial loss of engine power due to worn fuel valve O-rings, which allowed air into the fuel system and resulted in a forced landing to unsuitable 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 ERA19LA162Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Melbourne, FLA partial loss of engine power due to carburetor icing, and the flight instructor’s failure to effectively use carburetor heat while operating at an idle engine power setting in conditions conducive to carburetor icing.NTSB ERA19LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Key West, FLThe pilot's decision to attempt a takeoff in rough sea conditions, resulting in damage to the floats and the sinking of the seaplane.NTSB ERA19TA153Accident · No injuriesClass 3Final reportRobinson R22 · Bradenton Beach, FLThe pilot's improper decision to execute a low altitude turn that resulted in a strong tailwind and to reduce the airspeed to 0 knots and the flight instructor's diverted attention and inadequate monitoring, which resulted in the helicopter settling with…NTSB GAA19CA209Accident · No injuriesData collectionFinal reportBell 206 · Big Pine, FLThe pilot's failure to maintain helicopter control while it was being reloaded with the rotors turning in gusting wind conditions, which resulted in a rotor strike with ground equipment.NTSB DCA19CA137Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Fort Meyers, FLmissing attach screws on the aft galley oven, which allowed it to become dislodged landing, injuring a flight attendant.NTSB ERA19FA142Accident · 1 fatalField investigationFinal reportRobinson R44 II · Tampa, FLContamination of and an inadequate bond between the two layers of fabric comprising the helicopter engine's air induction inlet duct, which resulted a partial collapse of the duct, obstruction of the airflow into the engine, and a total loss of engine power.NTSB GAA19CA196Accident · No injuriesData collectionFinal reportPiper PA32 · Lakeland, FLThe pilot's failure to maintain clearance from a fence post during taxi to parking.NTSB ERA19TA146Accident · No injuriesClass 3Final reportCessna 172 · Fort Myers, FLThe pilot's failure to remain clear of a light pole while taxiing.NTSB ERA19LA141Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Palatka, FLThe pilot’s improper management of his fuel supply, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the outcome was the improper maintenance of the airplane’s ballistic recovery parachute system, which resulted in its…NTSB GAA19CA198Accident · No injuriesData collectionFinal reportCessna 195 · Ormond Beach, FLThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the nose landing gear collapsing.NTSB ERA19LA138Accident · No injuriesClass 3 · LimitedFinal reportFisher Flying Products Dakota Hawk · McAlpin, FLThe pilot's failure to use carburetor heat while operating at idle power in atmospheric conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power during takeoff.NTSB ERA19LA136Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 95B55 · Clewiston, FLThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to perform the appropriate emergency checklists following the loss of engine power.NTSB GAA19CA180Accident · No injuriesData collectionFinal reportPiper PA23 · Tampa, FLAn in-flight collision with a bird during the approach, which resulted in damage to the vertical stabilizer.NTSB ERA19LA137Accident · No injuriesClass 3 · LimitedFinal reportPilatus PC12 · Fort Lauderdale, FLImproper maintenance of the windshield, which resulted in delamination and in-flight depressurization.NTSB GAA19CA190Accident · No injuriesData collectionFinal reportCessna 172 · Hollywood, FLThe other pilot's failure to maintain adequate clearance from the stopped airplane while attempting to taxi around it.NTSB ERA19TA133Accident · No injuriesClass 3Final reportCessna 650 · Sanford, FLThe pilot's failure to keep the airplane on the taxiway while taxiing at night. Contributing to the accident was a miscommunication between the flight crewmembers about the position of the airplane.NTSB ERA19TA129Accident · No injuriesClass 3Final reportBeech E55 · St. Petersburg, FLThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.NTSB ERA19LA126Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Ponte Vedra Beach, FLA total loss of engine power due to the introduction of air into fuel lines and an interruption of fuel flow to the engine.NTSB WPR19FA093Accident · 5 fatalClass 2 · FieldFinal reportPiper PA23 · Pahokee, FLThe pilot's failure to maintain control of the airplane while maneuvering for landing with one engine inoperative following a loss of engine power for reasons that could not be determined based on the available information.NTSB ERA19LA125Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Leesburg, FLMaintenance personnel’s improper rigging of the main landing gear actuators, which resulted in the collapse of the right main landing gear.NTSB ERA19FA116Accident · 1 fatalClass 2 · FieldFinal reportPiper PA28 · Fellsmere, FLThe student pilot's loss of control due to spatial disorientation following an encounter with instrument meteorological conditions shortly after takeoff. Contributing to the accident was the failure of both the pilot and the flight school to ensure that the…NTSB ERA19TA114Accident · Serious injuriesFinal reportRempe Kitfox · Merritt Island, FLThe pilot's failure to maintain airplane control during an attempted go-around.NTSB ERA19FA112Accident · 1 fatalClass 3 · FieldFinal reportPiper PA25 · Fort Lauderdale, FLThe pilot’s failure to maintain proper altitude and clearance while maneuvering during a banner tow flight, which resulted in an in-flight collision with a 19-story building in a heavily congested area. Contributing to the accident were the easterly wind…NTSB ERA19FA106Accident · 1 fatalClass 2 · FieldFinal reportStol UC-1 · Winter Haven, FLA total loss of left engine power for reasons that could not be determined, and the instructor's failure to maintain airspeed while maneuvering for a forced landing, which resulted in a loss of control. Contributing to the accident was the instructor's…NTSB ENG19IA013Incident · No injuriesIncident investigationFinal reportBoeing 737 · Orlando, FLA No. 1 (left) engine high pressure compressor stage 2 blade separation. The blade separated due to a mixed-mode fatigue crack that originated on a blade disk post and was initiated by a misaligned (out-of-schedule) high pressure compressor stage 1 variable…