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 ATL02LA070Accident · No injuriesLimited investigationFinal reportCessna 210 · Naples, FLTotal loss of engine power due to improper maintenance by company maintenance personnel which allowed the mixture control linkage to disconnect in flight which resulted in an emergency descent to landing into unsuitable terrain.NTSB ATL02LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe students pilot's failure to perform a go-around after a bounced landing condition that resulted in the on-ground collision with a ditch.NTSB MIA02LA074Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Coral Springs, FLThe instructor's too high flare during an autorotational landing, resulting in a hard touchdown and rollover. Factors contributing to the accident were the instructor's nonperformance of a preflight brief concerning procedures and techniques for a simulated…NTSB ATL02LA066Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400A · Hastings, FLFatigue cracking in the most outboard splice bolt hole in the lower spar cap of the right wing. .NTSB MIA02IA072Incident · No injuriesIncident investigationFinal reportPiper PA-31-325 · Fort Laudedale, FLThe failure of the pilot to assure all items of the before landing checklist were complied with before landing, resulting in the wheels up landing.NTSB ATL02LA064Accident · 1 fatalLimited investigationFinal reportKopp Robert E GYRO-KOPP-TER · Citra, FLThe pilots failure to maintain flight control, followed by a subsequent collision with the terrain.NTSB MIA02LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Kissimmee, FLThe pilot's failure to maintain the proper clearance while taxing the airplane which resulted in the left wing tip colliding with an object and damage to the airplane. A related factor was night conditions.NTSB MIA02FA066Accident · 2 fatalField investigationFinal reportCessna 172N · Bunnell, FLInadequate maintenance inspection of the airplane by comapny maintenance personnel which resulted in corrosion in an aileron control cable going undetected, failure of the aileron control cable, and impact with terrain following loss of control of the…NTSB ATL02LA055Accident · 1 fatalLimited investigationFinal reportKrejci S-51D · Port St. Lucie, FLThe pilots failure to maintain airspeed while maneuvering in an attempt to return to landing area (Emergency/ departure airport.) This resulted in an inadvertent stall and subsequent in-flight collision with terrain. Factor to the accident was a partial loss…NTSB ATL02LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe student pilot's improper flare and failure to recover from a bounced landing resulting in the subsequent collapse of the nose gear during the landing flare touchdown. A factor contributing to the accident was the student pilot's lack of total experience.NTSB ATL02LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, FLTotal loss of engine power due to oil starvation to the No. 3 connecting rod preceded by aft displacement of the center main bearing due to excessive wear. This resulted in a forced landing to none suitable terrain and subsequent on-ground collision with a…NTSB ATL02FA051Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Vero Beach, FLThe flight's encounter with isolated severe to extreme turbulence that resulted in an in-flight breakup of the airplane and subsequent impact with terrain.NTSB MIA02LA061Accident · Serious injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Belle Glade, FLthe pilot continued flight into known adverse weather resulting in a loss of control and subsequent impact with the ground.NTSB ATL02FA048Accident · 2 fatalField investigationFinal reportBell 206L-1 · New Smyrna Bch., FLThe pilot continued visual flight into instrument conditions that resulted in the in-flight collision with trees. Factor were the pilot's alcohol impaired condition, and low cloud conditions.NTSB MIA02LA060Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-V · West Palm Beach, FLThe flight crew's failure to follow preflight inspection/checklist procedures, which resulted in their failure to detect wooden sticks in the landing gear weight-on-wheel switches and their failure in flight to respond to crew alert messages to disarm the…NTSB ATL02LA047Accident · No injuriesLimited investigationFinal reportPiper PA -18 · Winter Haven, FLThe pilot's improper flare during an attempted landing on water. A factor was glassy water.NTSB ATL02LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Panama City Bch, FLThe pilot's failure to use carburetor heat that resulted in the loss of engine power. A factor was weather conditions favorable for the formation of carburetor ice.NTSB MIA02FA059Accident · 4 fatalField investigationFinal reportCessna TR182 · Cedar Key, FLthe failure of the pilot to maintain control of the airplane due to spatial disorientation resulting in the airplane descending and colliding with water. A factor in the accident was a dark night .NTSB ATL02LA044Accident · Minor injuriesLimited investigationFinal reportHiller UH12E · Miami, FLFatigue cracking in the main rotor hub that resulted in the separation of the main rotor system. A factor was corrosive deposits on the exposed portion of the plate set pin.NTSB MIA02LA058Accident · 1 fatalLimited investigationFinal reportHarleman Tornado II · Molino, FLThe pilot's failure to maintain obstacle clearance, resulting in the in-flight collision with a static wire and an uncontrolled descent and collision with the ground. A factor in the accident was the pilot's impairment resulting from the use of unapproved…NTSB MIA02LA057Accident · Serious injuriesLimited investigationFinal reportCessna R172E · River Ranch, FLThe reported loss of engine power due to undetermined reasons. Contributing factors in the accident were an improper flap setting, excessive landing speed, and terrain consisting of berms.NTSB MIA02LA054Accident · 1 fatalLimited investigationFinal reportQuitzau, Carl Vortex · Immokalee, FLThe failure of the pilot to maintain directional control of the gyroplane resulting in the in-flight loss of control and subsequent in-flight collision with terrain.NTSB MIA02LA053Accident · No injuriesLimited investigationFinal reportCessna 182L · Boca Raton, FLThe pilot's failure to perform a proper preflight inspection and refueling of the aircraft, resulting in an in-flight loss of engine power due to fuel exhaustion and a collision with a road sign during the emergency landing.NTSB MIA02LA055Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Milton, FLThe inability of the pilot to maintain directional control of the airplane resulting in a ground loop. A finding in the investigation was a loose left rudder flight control cable.NTSB MIA02LA056Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Sarasota, FLThe poor in-flight planning decision by the pilot-in-command for his failure to request the runway most aligned with the wind and his failure to maintain directional control during the landing roll.NTSB ATL02LA042Accident · Minor injuriesLimited investigationFinal reportLouis Edmondson 162F · St. Petersburg, FLThe pilot's decision to continue flight with demonstrated inadequate takeoff performance capability, which resulted in an in-flight loss of control and subsequent hard landing.NTSB MIA02LA050Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Lake Placid, FLThe failure of the pilot to perform a proper preflight inspection and his improper fuel tank selection for takeoff, resulting in a loss of engine power on takeoff due to fuel starvation, and the pilot's failure to maintain directional control of the aircraft…NTSB MIA02FA049Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Micanopy, FLThe pilot's experiencing spatial disorientation while maneuvering at a low altitude at night under visual meteorological conditions which resulted in an uncontrolled descent and an in-flight collision with a tree.NTSB ATL02LA038Accident · Minor injuriesLimited investigationFinal reportH.S. Mosley Cuby Sport · Panama City, FLThe pilot's inadequate preflight and inflight decisions that resulted the execution of and off-airport landing to rough and uneven terrain where the airplane nosed over during the landing. The pilot did not apply normal breaking during the landing roll.NTSB ATL02LA035Accident · 1 fatalLimited investigationFinal reportSpringer Longbow 150 · Oak Hill, FLThe improper modification of the exhaust muffler which resulted in fractures that enabled the contamination of the cabin heating and ventilation system. The pilot subsequently became incapacitated by carbon monoxide poisoning, and the airplane descended…NTSB ATL02LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Clewiston, FLThe student pilot's inadequate compensation for wind, and failure to maintain directional control. A contributing factor was a crosswind.NTSB ATL02FA032Accident · 1 fatalField investigationFinal reportCessna 172R · Tampa, FLThe pilot's unauthorized use of an aircraft for the purpose of commiting suicide.NTSB ATL02TA030Accident · Minor injuriesFinal reportHughes OH-6A · Tampa, FLThe pilot's improper flare during practice autorotation.NTSB MIA02IA047Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Miami, FLThe failure of the first officer to fly a stabilized approach at the correct airspeed and his failure to execute a missed approach resulting in touchdown about 5,000 feet past the runway threshold at an excessive airspeed and over run of the runway prior to…NTSB MIA02FA048Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hollywood, FLThe pilot's inadequate planning for a Title 14 CFR Part 135 on-demand air taxi flight, and his failure to refuel the airplane, which resulted in fuel exhaustion while en route over the Atlantic Ocean, a power off glide, and ditching in the ocean.NTSB ATL02LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Trenton, FLThe pilot's improper in-flight decision to make a precautionary landing after sustaining a total loss of electrical power with sufficient fuel remaining to reach his destination airport. This resulted in an off field landing to an off site location in a…NTSB ATL02LA019Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Vero Beach, FLThe pilot's inadequate preflight fuel requirements for the flight, resulting in fuel exhaustion and the subsequent loss of engine power.NTSB MIA02LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172M · New Smyrna Bch, FLthe failure of the pilot to maintain airspeed, during initial climb out, which resulted in an inadvertent stall, and subsequent impact with the terrain.NTSB ATL02LA018Accident · No injuriesLimited investigationFinal reportPitts S-1S · Sanford, FLThe pilot's failure to maintain control of the airplane during landing roll in a tailwind, which resulted in a nose-over on the runway.NTSB MIA02FA045Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Jacksonville, FLThe pilot becoming spatially disoriented and losing control of the airplane during a missed approach resulting in the airplane descending uncontrolled and colliding with trees and the ground.NTSB MIA02FA041Accident · Minor injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340-580STC · Sunny Isles Bch, FLThe inadequate dispatch of the airplane by company personnel prior to the first leg of the flight due to failure of company personnel to prepare a new flight release and weight and balance after considerable time on the ground with the engines operating. Also…NTSB MIA02LA036Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1C · Pompano Beach, FLThe failure of the pilot-in-command to maintain airspeed (Vs), while maneuvering for an emergency landing, resulting in an inadvertent stall and subsequent in-flight collision with terrain. A contributing factor in the accident was the loss of engine power…NTSB MIA02LA030Accident · No injuriesLimited investigationFinal reportBeech A36 · Milton, FLthe pilot's failure to properly manage the available fuel in all fuel tanks, which resulted in the loss of engine power due to fuel starvation, a forced landing, and damage to the aircraft when the proper touch down point was not attained.NTSB MIA02LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Stuart, FLThe pilot's improper fuel consumption calculations resulting in a loss of engine power due to fuel exhaustion and collision with trees during a forced landing.NTSB MIA02LA024Accident · No injuriesLimited investigationFinal reportCessna 172M · Crystal River, FLthe pilot's failure to keep a proper visual lookout and ensure proper clearance during taxi operations, which resulted in a collision with vehicles.NTSB MIA02LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Deland, FLThe loss of engine power during takeoff/initial climb due to undetermined reasons.NTSB MIA02LA020Accident · No injuriesLimited investigationFinal reportMooney M20C · High Springs, FLThe pilot's improper preflight planning/preparation and failure to ensure sufficient fuel was available to complete the flight, which resulted in fuel exhaustion, a forced landing, and damage to the aircraft when it collided with a fence during the landing…NTSB MIA02LA018Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Belle Glade, FLThe loss of engine oil for undetermined reasons that resulted in the engine seizing, a forced landing on a dirt road, and an impact with a vehicle on the dirt road during the landing rollout.NTSB ATL02LA013Accident · No injuriesLimited investigationFinal reportCessna 172S · Sarasota, FLThe operators failure to ensure adequate training had been provided to the student pilot in autopilot operations, and the student pilot's failure to comply/ follow written instructions (Federal Regulations/172 Skyhawk Information Manual) pertaining to the…NTSB ATL02LA012Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA300/L · St. Augustine, FLThe pilot of the other airplanes failure to maintain a visual lookout and yield the right-of-way to a lower airplane while landing. This resulted in an inadvertent midair collision. Contributing to the accident was reported excessive radio communication on…