NTSB investigations, FL
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 ERA13LA374Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Marco Island, FLThe pilot’s improper pitch trim setting before takeoff, which resulted in the airplane’s rapid, nose-high pitch at takeoff and the pilot’s subsequent loss of control.NTSB ERA13LA363Accident · No injuriesLimited investigationFinal reportMooney M20R · Tallahassee, FLThe pilot's failure to troubleshoot the in-flight electrical problem and restore power using the operable redundant battery and his decision not to manually extend the airplane's landing gear, which resulted in a gear-up landing. Contributing to the accident…NTSB ERA13CA335Accident · No injuriesData collectionFinal reportCessna 172S · New Smyrna Beach, FLThe student pilot's improper landing flare and subsequent inadequate recovery from a bounced landing.NTSB ERA13IA326Incident · No injuriesIncident investigationFinal reportPiper PA-34 · Palm Coast, FLThe installation of an incorrect rudder trim tab control rod by unknown maintenance personnel, which resulted in the rod failing in flight due to overload and subsequent uncontrolled rudder oscillations.NTSB ERA13CA307Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Okeechobee, FLThe student pilot’s failure to maintain directional control during a go-around.NTSB ERA13LA297Accident · Minor injuriesLimited investigationFinal reportBeech G-36 · Pompano Beach, FLThe pilot’s premature rotation during takeoff with a tailwind and his delayed retraction of the landing gear, which reduced the airplane’s climb performance and subsequently led to the collision with power lines.NTSB ERA13LA291Accident · No injuriesLimited investigationFinal reportCessna 172S · Clearwater, FLA total loss of engine power for reasons that could not be determined because neither postaccident visual examinations nor test runs of the engine revealed any anomalies that would have precluded normal operation.NTSB ERA13FA275Accident · 1 fatalField investigationFinal reportCessna 340A · Boynton Beach, FLThe pilot’s loss of situational awareness, which resulted in an inadvertent aerodynamic stall/spin after he climbed the airplane back into instrument meteorological conditions (IMC). Contributing to the accident was the pilot’s improper decision to continue…NTSB ERA13IA267Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tallahassee, FLThe failure of the elevator trim cable due to fatigue cracking, which resulted from maintenance personnel’s repeated inadequate inspection of the cable.NTSB ERA13CA278Accident · No injuriesData collectionFinal reportPiper PA-46-500TP · West Palm Beach, FLThe pilot’s diversion of attention while taxiing the airplane, which resulted in his failure to maintain directional control and collision with a ditch.NTSB ERA13CA280Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Hollywood, FLThe pilot's failure to maintain directional control during the landing roll.NTSB ERA13LA254Accident · Serious injuriesLimited investigationFinal reportFleming Eldridge E Sonex · Naples, FLThe pilot’s failure to maintain airspeed during a forced landing, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of the noncertificated engine’s power for reasons that could not be determined because examination of the…NTSB ERA13CA277Accident · Minor injuriesData collectionFinal reportBoswell John J AIR CAM 912S · West Palm Beach, FLThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB ERA13LA248Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Geneva, FLThe passenger’s failure to adhere to the pilot’s instructions to stay away from the front of the airplane when the engine was operating.NTSB ERA13CA240Accident · No injuriesData collectionFinal reportPiper PA-44-180T · Loxahatchee, FLAn in-flight collision with a bird.NTSB DCA13CA088Accident · No injuriesData collectionFinal reportGeneral Atomics MQ-9 · Cocoa Beach, FLan improper flare leading to a nose-wheel first touchdown, which resulted in a pilot induced oscillation (PIO). The PIO caused the UAS to pitch up abruptly on the third nose gear contact with the runway, resulting in the separation of the nose wheel assembly…NTSB ERA13LA239Accident · No injuriesLimited investigationFinal reportCessna 182G · Clewiston, FLThe private pilot’s inadequate preflight planning and fuel management and the flight instructor’s inadequate supervision, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA13LA242Accident · No injuriesLimited investigationFinal reportSud SA 318C · South Bay, FLThe pilot’s failure to maintain proper rotor rpm while hovering in sideways flight.NTSB ERA13FA219Accident · 1 fatalField investigationFinal reportDaniels Dominator · Valkaria, FLThe pilot’s failure to maintain adequate power and airspeed, which resulted in a loss of control, abrupt descent, and impact with terrain. Contributing to the accident was the pilot’s failure to obtain adequate experience in the gyroplane before making the…NTSB ERA13FA217Accident · Minor injuriesField investigationFinal reportCessna 172N · Dade City, FLThe in-flight loosening of the No. 3 cylinder exhaust valve rocker arm stud, which resulted in a complete loss of engine power.NTSB ERA13LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Daytona Beach, FLA total loss of engine power during initial climb for reasons that could not be determined because postaccident examinations did not reveal any preimpact failures or malfunctions that would have precluded normal operation.NTSB CEN13IA270Incident · No injuriesIncident investigationFinal reportPiaggio P180 · Clearwater, FLThe failure of the nose landing gear steering manifold during landing, which resulted in an uncommanded and uncontrollable right turn, and the overhaul facility’s improper overhaul of the nose landing gear steering manifold.NTSB ERA13CA207Accident · No injuriesData collectionFinal reportCessna A185F · Palatka, FLThe pilot’s failure to retract the landing gear after takeoff from a runway, and his subsequent water landing with the wheels extended.NTSB ERA13FA201Accident · 1 fatalField investigationFinal reportSchoonover John D KIT FOX IV 1200 · St. Lucie, FLThe pilot’s failure to maintain adequate airspeed during the turn to final, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s combined use of two sedating…NTSB ERA13LA204Accident · No injuriesLimited investigationFinal reportHarris Pierce Velocity XL RG · Avon Park, FLA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination and testing did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA13LA199Accident · Minor injuriesLimited investigationFinal reportMaxfly Inc/Mckay WM Searey · Polk City, FLThe improper installation of incorrect attachment hardware by maintenance personnel during an undocumented repair, which resulted in an in-flight structural failure and subsequent loss of aircraft control. Contributing to the accident was the covering of the…NTSB ERA13LA198Accident · No injuriesLimited investigationFinal reportFranke Russell J Searey · Polk City, FLAn inadvertent encounter with the water wake from a larger amphibious airplane before takeoff and the pilot's subsequent inadequate preflight inspection of the airplane during which he failed to note damage caused by the wake encounter.NTSB ERA13LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLA partial loss of engine power due to the failure of the No. 3 exhaust valve. Contributing to the accident was the airplane operator’s failure to follow the engine manufacturer’s recommended engine overhaul intervals.NTSB ERA13FA186Accident · 2 fatalField investigationFinal reportRobinson R44 · Miami, FLThe mechanic's failure to properly secure the pitch link hardware of one main rotor blade to the rotating swash plate, which resulted in the pitch link separating in flight and the pilot's subsequent loss of control. Contributing to the accident was the…NTSB ERA13LA188Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe disconnection of the nose landing gear actuator, which resulted in the subsequent collapse of the nose landing gear. Contributing to the accident was the repair station’s inadequate maintenance, postmaintenance inspection process, and oversight of the…NTSB ERA13CA223Accident · No injuriesData collectionFinal reportPiper J3L-65 · Daytona Beach, FLThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion. Contributing to the accident was the pilot’s improper decision to land with a tailwind.NTSB ERA13CA189Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot's failure to maintain directional control during the landing roll.NTSB ERA13CA181Accident · No injuriesData collectionFinal reportCessna 172 · Tistusville, FLThe pilot's loss of airplane control while taxiing in gusting wind conditions associated with nearby thunderstorm activity.NTSB ERA13LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Perry, FLThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA13LA180Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Titusville, FLAn engine failure due to the separation of the engine crankcase, which resulted from the lateral movement of the center main bearing and the subsequent blocking of the oil feed hole that supplied oil to the No. 2 connecting rod, which then led to its failure…NTSB ERA13LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Panama City, FLA loss of preload to the crankshaft gear attachment bolt, resulting in rotation of the crankshaft gear and a subsequent total loss of engine power. The root cause for the loss of preload could not be determined during a postaccident examination of the…NTSB ERA13CA177Accident · Minor injuriesData collectionFinal reportTrick Trikes Eagle · Eustis, FLThe pilot’s failure to maintain control of the weight-shift aircraft during the final approach to land.NTSB ERA13LA175Accident · No injuriesLimited investigationFinal reportMooney M20F · Leesburg, FLThe incorrect rigging of the landing gear emergency extension system by unknown maintenance personnel, which resulted in a failure of the emergency extension cable, and jamming of the normal extension gear motor.NTSB ERA13LA171Accident · Serious injuriesLimited investigationFinal reportMcnulty John S Aerolite 103 · Immokalee, FLThe loss of engine power due to the seizure of the magneto piston.NTSB ERA13LA169Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US Z-105 · Homestead, FLThe pilot’s failure to maintain sufficient altitude to avoid obstructions during the approach to land, which resulted in a collision with power lines.NTSB ERA13FA168Accident · 3 fatalField investigationFinal reportPiper PA-31T · Fort Lauderdale, FLThe pilot's failure to maintain airplane control following an emergency, the nature of which could not be determined because of crash and fire damage, which resulted in an aerodynamic stall.NTSB ERA13CA164Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Groveland, FLThe pilot's failure to maintain the proper airspeed during a tailwind approach, his improper decision to continue a fast approach with a tailwind rather than go around, and his improper use of the wheel brakes during the landing roll.NTSB ERA13LA159Accident · Minor injuriesLimited investigationFinal report781569 FX 210 · Punta Gorda, FLA total loss of engine power for reasons that could not be determined from the available evidence.NTSB ERA13LA143Accident · Minor injuriesLimited investigationFinal reportCessna T337G · Homestead, FLThe reported partial loss of engine power from the rear engine for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA13FA144Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Lutz, FLThe noninstrument-rated pilot’s decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in spatial disorientation and a loss of aircraft control. Contributing to the accident was the pilot’s lack of instrument…NTSB ERA13CA182Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Venice, FLThe pilot’s failure to secure the airplane before moving the propeller to assist the engine start.NTSB ERA13CA146Accident · No injuriesData collectionFinal reportCessna 172P · Valparaiso, FLThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions.NTSB ERA13CA137Accident · Minor injuriesData collectionFinal reportCessna 172N · Okeechobee, FLThe pilot’s failure to maintain directional control during takeoff.NTSB ERA13FA133Accident · 3 fatalField investigationFinal reportCessna 310H · Yeehaw Junction, FLThe noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions and his subsequent spatial disorientation. Contributing to the accident was the copilot's improper evaluation of the weather…NTSB ERA13FA131Accident · 1 fatalField investigationFinal reportCessna T337C · New Smyrna Beach, FLMaintenance personnel's failure to follow procedures and published directives in calibrating the continuous flow fuel system and failure to accurately diagnose debris in the throttle assembly, resulting in a loss of power in one engine. Contributing to the…