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 MIA00FA041Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · Deland, FLThe inadequate visual lookout by the pilot-in-command (PIC)/certified flight instructor (CFI) of both aircraft. Contributing factors in the accident were: 1) the frequency congestion of the CTAF 2) the poor in-flight planning decision by the PIC/CFI of the…NTSB MIA00LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe inadequate supervision of the student pilot by the pilot-in-command (CFI) for his failure to take the controls from the student and initiate a go-around earlier following the airplane drifting off the runway centerline.NTSB MIA00LA035Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Daytona Beach, FLThe pilot's failure to maintain directional control during an attempted go-around, and the subsequent wing tip strike of the ground and collision with a tree. A factor in the loss of control was the crosswind conditions present during the landing attempt.NTSB MIA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182RG · Jacksonville, FLThe pilot's failure to complete the before landing checklist and extend the landing gear, resulting in a gear up landing. A factor in the accident is the failure of the landing gear warning circuit to activate the cockpit warning horn.NTSB MIA00LA028Accident · No injuriesLimited investigationFinal reportCessna 172N · Defuniak Spgs, FLWas the pilot's failure to obtain a proper weather briefing resulting in his encounter with fog, his having to make a precautionary landing in a field when the aircraft became low on fuel, and the on ground collision with trees during landing roll.NTSB MIA00LA027Accident · No injuriesLimited investigationFinal reportCessna 172R · Daytona Beach, FLWas the pilot's improper flare and improper recovery from a bounced landing resulting in a hard landing and damage to the aircraft.NTSB MIA00LA025Accident · 1 fatalLimited investigationFinal reportFrederick Rocket II · Coral Springs, FLThe pilot's failure to maintain airspeed while maneuvering (VSO) resulting in an inadvertent stall and subsequent in-flight collision with water. Contributing to the accident was the pilot's improper fuel management resulting in a total loss of engine power…NTSB ATL00LA013Accident · No injuriesLimited investigationFinal reportBeech BE36 · Daytona Beach, FLThe collapse of the main landing gear for undetermined reasons.NTSB ATL00LA010Accident · No injuriesLimited investigationFinal reportCessna 310Q · Jacksonville, FLThe failure of the left main landing gear down locking mechanism for undetermined reasons.NTSB MIA00FA019Accident · 1 fatalField investigationFinal reportCessna 152 · Tamarac, FLthe pilot's failure to maintain airspeed resulting in the airplane stalling and entering a spin to the left at an inadequate altitude and his failure to apply spin recovery emergency procedures prior to the airplane impacting the swamp.NTSB ATL00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe student pilot's in-flight decision that resulted in the loss of engine power due to fuel exhaustion after he became lost and disoriented. A factor was the two fences.NTSB ATL00LA003Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-MARINER · West Boca Raton, FLThe flight instructor's delayed response in taking remedial action during a practice autorotation. Factors were his inadequate planned approach and his improper use of powerplant controls.NTSB ATL00LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe carburetor icing conditions that were present. Factors were the failure of the pilot to follow the emergency procedures checklist, and the objects that included a flag pole, a road sign and a tractor trailer vehicle.NTSB MIA00LA011Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Ft. Lauderdale, FLThe PIC's improper use of cyclic control during landing which resulted in a main rotor strike of the terrain and the rotorcraft's tail boom.NTSB MIA00LA010Accident · No injuriesLimited investigationFinal reportCessna 150M · Bunnell, FLThe erosion and separation of the aft end plate P/N 0450338-18 of the right muffler resulting in exhaust gas contact to electrical wires in the engine compartment. Also, unsuitable terrain encountered by the pilot during the forced landing. A finding in the…NTSB MIA00LA009Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Lake Wales, FLThe partial loss of engine power due to the inadequate annual inspection of the airplane by the mechanic with IA for his failure to assure that the mixture control cable jam nut at the rod end was secured following the reported adjustment by the airplane…NTSB MIA00LA005Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Sunny Isles, FLA loss of engine power while maneuvering due to improper ignition timing by unknown person(s) resulting in an emergency descent and collision with the water.NTSB MIA00LA012Accident · No injuriesLimited investigationFinal reportBeech D35 · Indiantown, FLThe reported unauthorized use of the airplane by an unknown person.NTSB MIA00LA004Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Opa Locka, FLThe improper flare by the co-pilot, and the failure of the captain to take remedial action by applying power to arrest the observed high rate of descent resulting in a hard landing. A finding in the accident was the inadequate maintenance adjustment of the…NTSB MIA00LA001Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in engine failure due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.NTSB MIA99LA275Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Dunnellon, FLThe pilot's improper recovery from a bounced landing.NTSB MIA99LA274Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · St. Augustine, FLThe inadvertent inflight collision with a bird resulting in substantial damage to the right wing outboard leading edge.NTSB MIA99LA268Accident · No injuriesLimited investigationFinal reportBanting Glasair II · River Ranch, FLA total loss of engine power for undetermined reasons, which resulted in a forced landing to non-suitable terrain.NTSB MIA99LA270Accident · No injuriesLimited investigationFinal reportCessna 172RG · Orlando, FLthe pilot's failure to ensure that the landing gear was down and locked following loss of electrical power for undetermined reasons, resulting in substantial damage to the airplane when the right main landing gear collapsed upon landing.NTSB MIA99LA271Accident · No injuriesLimited investigationFinal reportCessna 177 · St Petersburg, FLA loose throttle control cable clamp which resulted in a lose of power.NTSB ATL99FA134Accident · 2 fatalField investigationFinal reportBeech BE-35-J35 · Bartow, FLThe pilot's inadequate fuel management that resulted in the complete loss of engine power.NTSB MIA99LA253Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Homestead, FLThe pilot's failure to obtain the proper touch down point on landing and excessive airspeed resulting in an overrun, and subsequent collision with a fence post and clippings.NTSB MIA99LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · St. Petersburg, FLthe pilots improper use of the hand brake during the landing roll out and his failure to maintain directional control, which resulted in the airplane exiting the runway and incurring substantial damage.NTSB MIA99FA252Accident · No injuriesField investigationFinal reportBoeing B737-300 · West Palm Beach, FLThe fatigue fracture and separation of the high pressure turbine forward rotating air seal due to a manufacturing defect in a bolt hole that was not detected by the engine manufacturer due to inadequate and ineffective inspection techniques. Contributing to…NTSB MIA99FA250Accident · Serious injuriesField investigationFinal reportMbb BO105CBS · Kenansville, FLThe pilots failure to recognize entry into settling with power during approach to land and his failure to take remedial action to escape from settling with power resulting in the helicopter descending and colliding with trees and swampy terrain.NTSB MIA99LA265Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Naples, FLThe pilot's failure to perform manual gear extension procedures with a suspected unsafe landing gear indication which resulted in a collapse of the main landing gear on landing rollout. A factor in the accident was the pilot's lack of total experience in kind…NTSB MIA99LA247Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeland, FLThe student pilots improper use of brakes on landing rollout resulting in a loss of directional control and subsequent collision with a ditch. Contributing to the accident was the certified flight instructors improper supervision of the student pilot.NTSB MIA99FA246Accident · No injuriesField investigationFinal reportDiamond Aircraft Industries DA20-A1 · Cedar Key, FLThe pilot's failure to follow the checklist (turn Fuel Valve-On, and activate electric fuel boost pump) and the pilot's decision to continue flight with a known unairworthy condition (illumination of low fuel pressure warning light on takeoff roll) with…NTSB MIA99FA245Accident · 8 fatalField investigationFinal reportBeech B-90 · West Palm Beach, FLa total loss of engine power due to fuel exhaustion. Contributing factors in this accident were the pilot's operation of the airplane in an overweight condition, inadequate pre-flight and in-flight planning.NTSB MIA99LA242Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-29 · Fort Lauderdale, FLan in-flight failure of the right aileron due to fatigue cracking in the attachment structure of the right inboard aerodynamic compensator, which resulted in a loss of control, a forced landing, and subsequent impact with the ground.NTSB ATL99LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Baker, FLThe flight instructor misjudged his altitude and airspeed. A factor was trees.NTSB MIA99LA241Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Winter Haven, FLthe pilot-in command/flight instructor allowed the student pilot to get the nose of the airplane too low in the water causing a loss of directional control and a subsequent impact of the right wing in the water.NTSB MIA99LA243Accident · No injuriesLimited investigationFinal reportPowers Rotorway Exec 162 · Lutz, FLa loss of power due to undetermined reasons, resulting in a forced landing and subsequent impact with the ground. A factor in this accident was the pilot was not qualified or certified in helicopters.NTSB MIA99LA237Accident · No injuriesLimited investigationFinal reportDinkel-Brook SEA REY · Orlando, FLthe pilot's failure to maintain control of the airplane resulting in an inadvertent stall at too low an altitude to recover.NTSB MIA99LA233Accident · No injuriesLimited investigationFinal reportCessna 172RG · Miami, FLThe delay by the pilot-in-command to extend the gear resulting in collapse of the main landing gear after touchdown. Factors in the accident were the inoperative gear warning system associated with the throttle due to the broken wire at the throttle…NTSB MIA99FA230Accident · 1 fatalField investigationFinal reportCessna 210L · Tampa, FLThe failure of the pilot to follow procedures and directives established by the operator for his failure to fuel the airplane after landing following the first leg. Contributing to the accident was the total loss of engine power due to fuel exhaustion.…NTSB MIA99LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Ocala, FLA misjudged flare and the failure of the student pilot to use the proper recovery technique for a bounced landing, allowing the airplane to commence a porpoise, and the eventual collapse of the nose landing gear.NTSB MIA99FA226Accident · No injuriesField investigationFinal reportCanadair CL-600 · Fort Lauderdale, FLThe failure of the flight crew to main directional control of the airplane after landing, resulting in the airplane going off the side of the runway and colliding with a taxiway sign, collapsing the nose landing gear, and causing substantial damage to the…NTSB ATL99LA116Accident · Minor injuriesLimited investigationFinal reportCessna R172-E · Chiefland, FLPremature fuel exhaustion due to a cracked fuel line. Contributing to the severity of the accident was the electrical service drop line, which crossed the roadway.NTSB MIA99FA224Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pembroke Pines, FLThe failure of the pilot to maintain airspeed and inadvertent stall of the airplane by the pilot-in-command resulting in the uncontrolled descent and in-flight collision with a house. Contributing factors in the accident were the loss of engine power due to…NTSB MIA99FA219Accident · 1 fatalField investigationFinal reportBeech B-58 · Panacea, FLThe pilot's excessive speed and extended touchdown point during landing resulting in an inability to stop the airplane within the length of the wet, grass runway, and the subsequent on-ground collision with the airport fence and trees.NTSB ATL99LA117Accident · No injuriesLimited investigationFinal reportQuicksilver GT-500 · Ormond Beach, FLThe in-flight collision with an object for an undetermined reasons. A factor was the stolen/unauthorized use of the airplane.NTSB MIA99LA223Accident · 1 fatalLimited investigationFinal reportArnet Pereyra Aero Aventura II · Rockledge, FLThe pilot's failure to attain directional control during his attempted takeoff due to his exceeding the airplane's gross weight limit for takeoff and the resultant inflight collision with a building.NTSB MIA99LA228Accident · No injuriesLimited investigationFinal reportWilliam John Schulz WJS Jaybird · Tangerine, FLthe pilot's improper torqueing of a rocker arm adjusting jam nut, that resulted in the adjuster loosening, and a partial loss of engine power. This resulted in the pilot making an off airport precautionary landing and subsequent nose over, during which the…NTSB MIA99LA213Accident · No injuriesLimited investigationFinal reportWilliam Jay Kinney Challenger II · Pahokee, FLfailure of the engine to propeller drive belt for undetermined reasons, resulting in loss of engine power, and a forced landing to unsuitable terrain.