NTSB investigations, FL
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 MIA05CA091Accident · No injuriesData collectionFinal reportCessna 172 · Kissimmee, FLThe pilot's improper recovery from a bounced landing resulting in a hard landing and damage to the airplane.NTSB SEA05LA073Accident · No injuriesLimited investigationFinal reportShorethose Kitfox Series 5 · Cresent City, FLAircraft handling not maintained during the landing rollout. Factors include soft terrain.NTSB MIA05CA089Accident · Minor injuriesData collectionFinal reportAerostar Yak-52TW · Daytona Beach, FLPilot's failure to maintain directional control in a variable wind condition during landing resulting in the airplane departing the runway subsequent landing gear separation and impact with trees.NTSB MIA05LA086Accident · Serious injuriesLimited investigationFinal reportFrank D. Amador Searey · Green Cove Spr, FLThe airplane builder's improper installation of the left rudder control cable, which resulted in the cable becoming jammed, a loss of directional control during takeoff, and the airplane departing the runway and impacting a tree.NTSB MIA05FA085Accident · 2 fatalField investigationFinal reportCommander 114-B · Venice, FLThe pilot's in-flight loss of control during takeoff/initial climb over the water at night due to spatial disorientation. A related factor was the night conditions.NTSB MIA05LA084Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Miami, FL"This case was modified may 30, 2006." The airplane's inadvertent impact with one of several deer that had entered the airport property and crossed the runway during the landing rollout.NTSB MIA05LA083Accident · No injuriesLimited investigationFinal reportCessna 172S · Palm Beach, FLThe flight crews inadvertent encounter with turbulence in clouds while being vectored by ATC while operating in instrument meteorological conditions. A factor in the accident was the ATC personnel's (ARTCC) inadequate weather avoidance assistance.NTSB MIA05CA082Accident · No injuriesData collectionFinal reportPiper PA-23-250 · West Palm Beach, FLThe failure of the pilot to maintain proper alignment with the runway, his failure to perform a go around after recognizing the aircraft was not properly aligned for landing, and his intentionally landing on a taxiway which resulted in a landing overrun and…NTSB MIA05LA080Accident · No injuriesLimited investigationFinal reportRobinson R44 · Homestead, FLThe CFI's inadequate supervision of the student during the instructional flight for his failure to stop an excessive rate of descent which resulted in a hard landing following a reported loss of engine power for undetermined reasons.NTSB MIA05LA081Accident · No injuriesLimited investigationFinal reportBeech C-45H · Panama City, FLThe overload failure of the left main landing gear for undetermined reasons during the landing roll resullting in collapse of the left main landing gear.NTSB MIA05LA077Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · DeLand, FLThe failure of the pilot to maintain sufficient airspeed during landing, resulting in an inadvertent stall, undershoot and collision with the ground.NTSB MIA05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bradfordville, FLThe failure of ATC to provide traffic advisories and safety alerts required in class C airspace and the inability of both pilots to see and avoid each other (low wing on top, high wing below), resulting in the midair collision.NTSB MIA05CA078Accident · No injuriesData collectionFinal reportCessna 180A · Orange Springs, FLThe pilot's failure to abort the landing and his misjudgment of the runway distance needed to complete the landing.NTSB MIA05IA087Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Jacksonville, FLInadequate welding procedure by the manufacturer resulting in a poor weld of the nose landing gear and collapse of the nose landing gear during a porpoised landing.NTSB MIA05CA075Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Clermont, FLThe pilot's inadvertent deploying of the spoilers, while on final approach, resulting in the glider descending and impacting trees.NTSB MIA05LA071Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Merritt Island, FLThe owner/pilot/mechanics inadequate installation of a fuel line resulting in a fuel leak, partial loss of engine power, and force landing in swampy terrain.NTSB MIA05CA072Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Opa Locka, FLThe dual student's improper descent rate during a simulated engine failure and simulated forced landing and the CFI's inadequate remedial action which resulted in a hard landing.NTSB MIA05LA070Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Destin, FLThe pilot's inadequate compensation for wind during a crosswind takeoff resulting in a loss of directional control and subsequent collision with terrain.NTSB MIA05CA074Accident · No injuriesData collectionFinal reportDgflugzeugbau DG-800S · Clermont, FLThe pilots failure to maintain airspeed which resulted in the glider stalling and impact with trees during the uncontrolled descent.NTSB MIA05CA067Accident · No injuriesData collectionFinal reportCessna 172 · Jacksonville, FLThe pilot's improper landing flare which resulted in a hard landing.NTSB MIA05LA066Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe improper installation and securing of the elevator trim tab push-rod attaching hardware by maintenance personal resulting in the rod disconnecting and a partial separation of the right elevator in flight.NTSB MIA05CA068Accident · No injuriesData collectionFinal reportCessna 305A · Bartow, FLThe pilots failure to maintain directional control resulting in the airplane ground-looping. A factor in the accident was the pilots lack of total experience in the airplane make and model.NTSB ANC05FA039Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Dunnellon, FLThe improper installation of the bolt that connects the throttle linkage to the fuel control arm by an unknown maintenance person, which resulted in a loss of the bolt, a loss of engine rpm control, and subsequent forced landing and collision with trees.NTSB ANC05CA040Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Panama City, FLThe pilot's failure to remove frost from the airplane which resulted in an inadvertent stall/mush during the takeoff/initial climb, and an in-flight collision with trees. Contributing to the accident were the rough and uneven airstrip, and degraded aircraft…NTSB MIA05LA063Accident · No injuriesLimited investigationFinal reportCessna T207A · West Palm Beach, FLThe pilot's inadequate fuel management resulting in a loss of engine power due to fuel starvation and subsequent impact with an embankment during an emergency landing.NTSB MIA05LA062Accident · No injuriesLimited investigationFinal reportHoward DGA-15 · Daytona Beach, FLMaintenance personnel failure to detect corrosion in the landing gear strut, resulting in the gear collapsing during landing and damage to the airplane.NTSB ANC05FA037Accident · 1 fatalField investigationFinal reportCessna 172 · Cedar Key, FLThe pilot's continued flight into instrument meteorological conditions (IMC), and his failure to maintain adequate airspeed during an abrupt maneuver to avoid a power line, which resulted in an inadvertent stall, a loss of control, and subsequent collision…NTSB MIA05CA061Accident · No injuriesData collectionFinal reportCessna 172 · Brooksville, FLThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.NTSB MIA05LA058Accident · Serious injuriesLimited investigationFinal reportInterplane Sro Skyboy · Zephyrhills, FLThe instructors in-flight loss of control due to the flight controls being jammed for undetermined reasons.NTSB ANC05FA034Accident · 2 fatalField investigationFinal reportBeech 35-C33 · Clearwater, FLThe loss of engine power during initial climb due to fuel exhaustion, the pilot's failure to refuel the airplane, and the pilot's failure to maintain minimum airspeed, which resulted in an inadvertent stall and uncontrolled descent into a residence.NTSB ANC05FA030Accident · 2 fatalField investigationFinal reportBeech K35 · Leesburg, FLAn abrupt maneuver performed by the pilot at a low altitude, and his failure to maintain adequate airspeed, which precipitated an inadvertent stall and impact with terrain.NTSB ANC05CA031Accident · Minor injuriesData collectionFinal reportDickson RV-7A · Panacea, FLThe pilot's misjudged landing flare, which resulted in a hard landing, the collapse of the nose gear, and subsequent nose over.NTSB ANC05LA026Accident · No injuriesLimited investigationFinal reportCessna 411A · Hollywood, FLThe failure of the right main landing gear locking mechanism during the landing roll, which resulted in the collapse of the right main landing gear.NTSB MIA05FA055Accident · 1 fatalField investigationFinal reportBell 206B · Bonifay, FLThe pilot's failure to maintain a climb after takeoff and his continued descent which resulted in an in-flight collision with the ground. A factor in the accident was the dark night.NTSB MIA05CA064Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Ocala, FLThe pilot-rated passengers improper use of the rudder control and his failure to maintain directional control resulting in a loss of control on the ground.NTSB MIA05CA054Accident · No injuriesData collectionFinal reportCessna 182S · Punta Gorda, FLThe pilot's improper flare resulting in a hard landing and subsequent damage to the firewall.NTSB MIA05CA053Accident · No injuriesData collectionFinal reportLee Harold Swarthout Velocity Xlrg · Daytona Beach, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll resulting in the on-ground collision with a fence and a ditch.NTSB MIA05LA052Accident · No injuriesLimited investigationFinal reportPaul Pajak RV-6A · Sanford, FLThe pilots failure to use carburetor heat in conditions conducive to carburetor icing which resulted in loss of engine power and collision with trees and ground during the resultant forced landing.NTSB IAD05FA032Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Coconut Creek, FLThe pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent to the ground. Factors included an avionics failure, pilot disorientation, and instrument meteorological conditions. A factor in the severity of the impact was the…NTSB MIA05FA050Accident · 2 fatalField investigationFinal reportCessna T337G · Lakeland, FLThe pilot's operation of the airplane with known deficiencies in equipment related to pitch, an abrupt pitch-up during the initial climb after takeoff for undetermined reasons and the failure of the pilot to maintain airspeed (Vs) resulting in inadvertent…NTSB MIA05LA049Accident · No injuriesLimited investigationFinal reportBeech B300 · Jacksonville, FLThe pilot's failure to perform a missed approach after losing sight of the runway and the misjudgment of distance on the runway which resulted in an overrun. A contributing factor was the fog.NTSB MIA05LA046Accident · 1 fatalLimited investigationFinal reportCessna 172M · Orlando, FLThe failure of the CFI to initiate a precautionary landing after noticing zero oil pressure with corresponding oil temperature increase, resulting in total loss of engine power due to oil exhaustion. A contributing factor in the accident was the failure of…NTSB MIA05FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Leesburg, FLThe pilot's decision to continue VMC flight into IMC conditions.NTSB MIA05CA048Accident · No injuriesData collectionFinal reportCessna 172SP · Clewiston, FLThe pilot's failure to maintain directional control during landing rollout which resulted in the airplane veering off the runway and colliding into an airport sign.NTSB MIA05FA044Accident · 1 fatalField investigationFinal reportCessna 210N · Weston, FLThe pilot's failure to maintain his assigned altitude, and allowed the airplane to descend for undetermined reasons resulting in an in-flight collision with terrain. Factors in the accident were clouds, rain, and the dark night.NTSB MIA05LA043Accident · No injuriesLimited investigationFinal reportCessna 172S · Lakeland, FLThe faulure of the pilot to maintain directional control of the aircraft during the landing roll resulting in the on-ground collision with a taxiway sign and subsequent collapse of the nose landing gear.NTSB MIA05LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Pierce, FLThe failure of the pilot of the Piper 181 to apply his parking brake when stopped awaiting departure and his failure to maintain a visual lookout resulting in his airplane rolling forward and colliding with the Piper 201 which was awaiting departure.NTSB MIA05FA040Accident · No injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340 · N. Miami Beach, FLThe improper maintenance of the left engine by company maintenance personnel (failure to flush metal from the oil system and failure to properly preserve the engine for storage) resulting in a total failure of the master rod bearing and contamination of the…NTSB MIA05LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Milton, FLA loss of engine power due to fuel starvation as a result of the improper fuel selector position.NTSB MIA05LA033Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Cocoa Beach, FLThe pilot's failure to maintain altitude resulting in flight collision with ground and subsequent collision with fence.