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 MIA06LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Fort Myers, FLThe flight instructor's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was a malfunction of the elevator control for an undetermined reason, which required excessive forward pressure on the…NTSB MIA06FA090Accident · 3 fatalField investigationFinal reportBeech B-60 · Gainesville, FLThe loss of control for an undetermined reason.NTSB MIA06FA092Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Dunnellon, FLThe loss of engine power as a result of fuel starvation due to a contaminated carburetor fuel inlet screen.NTSB MIA06LA089Accident · No injuriesLimited investigationFinal reportBeech C24R · Panama City, FLA flat tire which occurred for undetermined reasons that resulted an inadvertent loss of control during the landing roll.NTSB MIA06LA086Accident · No injuriesLimited investigationFinal reportCessna 310K · Brooksville, FLThe mechanic's improper maintenance that resulted in the right main landing gear's separation from the airplane and an inadvertent loss of control during landing.NTSB MIA06CA084Accident · No injuriesData collectionFinal reportLinwood R. Lawrence Van's Aircraft RV-9A · Venice, FLThe pilot's improper landing flare/touchdown which resulted in a hard landing and damage to the airplane.NTSB MIA06CA085Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Tallahassee, FLThe pilot's failure to maintain directional control during the landing rollout while making a crosswind landing in gusting conditions which resulted in an advertent ground loop and damage to the airplane.NTSB MIA06CA083Accident · No injuriesData collectionFinal reportCessna 172M · Vero Beach, FLThe pilot's failure to maintain directional control while executing a go-around in gusty conditions which resulted in the airplane veering off the runway, colliding with a ditch and nosing over.NTSB MIA06CA082Accident · No injuriesData collectionFinal reportCessna C170A · Lakeland, FLThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB MIA06CA081Accident · No injuriesData collectionFinal reportWoolley John A Lancair 320 · Lakeland, FLThe pilot's improper landing flare/touchdown which resulted in a hard landing and damage to the airplane.NTSB MIA06CA080Accident · Minor injuriesData collectionFinal reportAero Commander 100 · Englewood, FLThe pilot's failure to abort the takeoff in time to stop on the remaining runway, which resulted in the airplane overrunning the runway.NTSB MIA06CA079Accident · No injuriesData collectionFinal reportMooney M20R · Destin, FLThe pilot's failure to maintain airspeed while attempting a go-around at a low altitude which resulted in an inadvertent stall/mush, an uncontrolled descent and an impact with terrain.NTSB MIA06LA078Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Parrot · Palm City, FLThe failure of the pilot-in-command to abort the takeoff after recognizing the engine was not developing full power during the takeoff roll. A contributing factor in the accident was the bending of the throttle cables which prevented full movement of the…NTSB MIA06LA077Accident · 2 fatalLimited investigationFinal reportMarvin T Eiland SparrowHawk · Ona, FLThe in-flight loss of control for undetermined reasons during a normal descent, resulting in an uncontrolled descent, and in-flight collision with terrain.NTSB MIA06CA088Accident · No injuriesData collectionFinal reportCessna 172N · Daytona Beach, FLThe pilot's improper landing flare/touchdown, which resulted in the airplane porpoising and incurring damage.NTSB MIA06LA074Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLFailure of the nose landing gear upper drag brace assembly due to overload acting on an undetected forging defect formed during the initial forging of the brace. A contributing factor in this accident was the runway distance remaining sign.NTSB MIA06LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bunnell, FLThe failure of the pilot to perform a preflight inspection of the airplane resulting in departure with an inadequate oil supply, subsequent engine failure due to oil starvation, and damage to the airplane during a forced landing. Contributing to the accident…NTSB MIA06CA072Accident · No injuriesData collectionFinal reportPiper PA32-301 · Key West, FLThe failure of the pilot to maintain directional control during the landing roll with a crosswind, resulting in collapse of the nose landing gear.NTSB MIA06CA102Accident · No injuriesData collectionFinal reportPiper 38-112 · Apopka, FLThe pilot's failure to maintain clearance from an object while taxiing which resulted in the airplane impacting the object and incurring damage.NTSB MIA06FA069Accident · 3 fatalField investigationFinal reportCessna 340A · Melbourne, FLThe pilot's failure to maintain adequate airspeed to avoid a stall during the final approach to land. Contributing to the accident was the pilot's impairment due to the use of a sedating antihistamine.NTSB MIA06LA068Accident · No injuriesLimited investigationFinal reportChampion 7EC · Zellwood, FLA loss of directional control due to the spring connecting the rudder to the tailwheel horn being detached.NTSB MIA06LA067Accident · No injuriesLimited investigationFinal reportCirrus SR20 · Orlando, FLCatastrophic engine failure due to a low oil level brought about by excessive blow-by and cylinder detonation. Contributing factors in this accident were the inadequate instructions contained in Service Bulletin M89-9 and the ditch.NTSB MIA06LA066Accident · Minor injuriesLimited investigationFinal reportLoehle P5151 · Lakeland, FLThe pilot's delay in initiating landing flare during a forced landing following a total loss of engine power. A factor was the lack of correct venting of the carburetor float bowl.NTSB MIA06LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sanford, FLA loss of engine power during takeoff-initial climb due to contamination (debris) lodged in the carburetor jet, which resulted in a forced landing and collision with trees.NTSB MIA06CA065Accident · No injuriesData collectionFinal reportCessna 172 · Leesburg, FLThe student pilot's failure to maintain directional control of the airplane during the landing roll resulting in collision with a taxiway sign.NTSB MIA06LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Baker, FLA loss of engine power due to an oil line leak and oil exhaustion. A contributing factor was the unsuitable terrain on which to make a forced landing.NTSB MIA06CA060Accident · Minor injuriesData collectionFinal reportLet L13 AC Blanik · Zephyrhills, FLThe pilot's encounter with downdraft.NTSB MIA06LA062Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Brooksville, FLAn in-flight loss of fuel for undetermined reasons which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.NTSB MIA06LA061Accident · No injuriesLimited investigationFinal reportBell 206B · Naples, FLThe pilot's selection of an unsuitable area to make a precautionary landing which resulted in the helicopter rolling into a ditch.NTSB MIA06LA058Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Fort Pierce, FLImproper magneto installation by maintenance personnel, which resulted in the magneto detaching from the engine and subsequent loss of engine power.NTSB MIA06LA056Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Fruitland Park, FLThe fatigue failure of the No. 4 cylinder resulting in a loss of engine power and subsequent forced landing.NTSB MIA06LA057Accident · No injuriesLimited investigationFinal reportCessna 525A · Tampa, FLFailure of both the left main and auxiliary brake lines due to fatigue cracking, rendering directional control impossible. A contributing factor in this accident was the airport sign concrete pad.NTSB MIA06LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lehigh Acres, FLThe loss of engine power for undetermined reasons, resulting in a nose-over during the forced landing.NTSB MIA06LA055Accident · No injuriesLimited investigationFinal reportBeech C90A · Tampa, FLThe collapse of the right main landing gear for an undetermined reason during the landing roll, which resulted in a collision with the runway. A factor contributing to the accident was the pilot's failure to follow the published emergency/abnormal procedures.NTSB MIA06CA053Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe improper landing flare by the pilot-rated student and the inadequate supervision of the pilot-rated student by the certified flight instructor, resulting in the improper touchdown of the helicopter and the helicopter rolling over.NTSB MIA06LA052Accident · No injuriesLimited investigationFinal reportCessna 501 · Fort Pierce, FLmechanical binding of the normal brake system, rendering directional control impossible. Contributing factors were the improper overhaul, inadequate quality control procedures by the overhaul facility, and the rough terrain.NTSB MIA06LA051Accident · No injuriesLimited investigationFinal reportCessna P210N · Sarasota, FLThe collapse of the nose landing gear for undetermined reasons.NTSB MIA06CA129Accident · No injuriesData collectionFinal reportTharp S Richard Challenger II · Apopka, FLThe pilot's inadequate selection of a landing area which resulted in one of the seaplane's floats impacting a submerged stump.NTSB MIA06FA050Accident · 3 fatalField investigationFinal reportCirrus Design SR-22 · Stuart, FLThe pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent and impact with the water. Contributing to the accident were a reported instrument failure, pilot disorientation, and instrument meteorological conditions. A factor in…NTSB MIA06LA049Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · West Palm Beach, FLA loss of engine power during descent due to an undetermined reason, which resulted in an off-airport forced landing and collision with a culvert.NTSB MIA06CA047Accident · No injuriesData collectionFinal reportCessna 152 · Lantana, FLThe student pilot's improper flare and inadequate recovery from a bounced landing, which resulted in the nosegear collapsing, the airplane veering off the runway, and nosing over.NTSB MIA06CA046Accident · No injuriesData collectionFinal reportPiper PA-46/Jetprop · Tampa, FLThe pilot's improper flare.NTSB MIA06LA048Accident · No injuriesLimited investigationFinal reportCessna 310N · Destin, FLThe down limit switch, which operates the landing gear mechanical stop, was bent in the up position and allowed the gear motor to continued to run, causing the gearbox to over-travel, pull on the landing gear rods, and retract the landing gear.NTSB MIA06CA045Accident · No injuriesData collectionFinal reportSchewizer 233 · Immokalee, FLThe pilot's failure to maintain clearance during the final approach to land, which resulted in an impact with trees, and a hard landing.NTSB MIA06FA039Accident · 3 fatalField investigationFinal reportRobinson R44 · Grand Ridge, FLThe pilot's continued flight into known adverse weather, and his impairment, which resulted in an in-flight collision with trees and terrain during cruise flight.NTSB MIA06LA037Accident · No injuriesLimited investigationFinal reportCessna P206C · Lake Wales, FLThe loss of engine power during takeoff-initial climb due to fuel starvation, which resulted in a hard, off-airport forced landing.NTSB MIA06CA040Accident · No injuriesData collectionFinal reportBeech BE23 · Palatka, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB MIA06CA034Accident · No injuriesData collectionFinal reportCessna 182 · Haines City, FLThe pilot's improper preflight planning/preparation, and operation of equipment with known deficiencies, a right wing fuel cap leak, which resulted in fuel exhaustion and the loss of engine power.NTSB DCA06MA010Accident · 20 fatalClass 1 · MajorFinal reportGrumman G-73T · Miami, FLThe in-flight failure and separation of the right wing during normal flight, which resulted from (1) the failure of the Chalk's Ocean Airways maintenance program to identify and properly repair fatigue cracks in the right wing and (2) the failure of the…NTSB MIA06LA041Accident · 3 fatalLimited investigationFinal reportCessna 195 · St. Augustine, FLThe loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and ditching. Factors contributing to the survivability of the accident were the low ceilings and rough water.