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 ATL00FA041Accident · 1 fatalField investigationFinal reportBeech BE-58 · Palatka, FLThe pilot's physically impaired condition due to his high level of alcohol. Factors were the pilot's intentional VFR flight into IMC conditions and failure to perform a missed approach, which resulted in a collision with the ground.NTSB MIA00LA133Accident · 1 fatalLimited investigationFinal reportAir & Space. 18A · Lakeland, FLThe pilot's in-flight loss of control while maneuvering for undetermined reasons resulting in an uncontrolled descent and subsequent in-flight collision with terrain.NTSB MIA00LA131Accident · Minor injuriesLimited investigationFinal reportMcCan Velox REV II · Mulberry, FLThe bending overstress separation of the elevator pitch control rod for undetermined reasons. This resulted in an in-flight loss of control, bail out, and subsequent in-flight collision with terrain.NTSB MIA00LA137Accident · Minor injuriesLimited investigationFinal reportWalden A. Cooper Pitts S1S · Daytona Beach, FLCollapse of the tail wheel to the right during landing rollout when the forward attach bolt sheared for undetermined reasons. This resulted in the aircraft's rudder deflecting to the right, the pilot losing directional control, and the aircraft running off…NTSB ATL00LA040Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Leesburg, FLThe pilot's failure to maintain clearance from objects during the final approach. A factor was downdraft on final approach.NTSB MIA00FA129Accident · 3 fatalField investigationFinal reportLearjet 35A · Marianna, FLthe pilot's failure to maintain control of the airplane while on final approach resulting in the airplane striking trees. Factors in this accident were: improper planning of the approach, and not obtaining the proper alignment with the runway.NTSB MIA00IA128Incident · No injuriesIncident investigationFinal reportDassault DA-20 · Opa Locka, FLThe failure of the PIC to execute the complete procedure for emergency extension of the landing gear and the subsequent landing with the left main landing gear not locked fully down, resulting in an excursion off the runway and collision with a runway…NTSB MIA00FA126Accident · 1 fatalField investigationFinal reportCessna 177RG · Chipley, FLThe failure of the pilot to maintain runway alignment during the initial climb from the grass airstrip. Also, the excessive pull-up by the pilot and inadvertent stall. Findings in the investigation were 1) in-flight collision with the tops of trees and 2) the…NTSB MIA00LA124Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Petersburg, FLThe failure of the pilot to maintain clearance between the left wingtip and a hangar door resulting in the on-ground collision.NTSB ATL00LA039Accident · Serious injuriesLimited investigationFinal reportAlon A-2A · Hernando, FLLoss of power due to carburetor contamination. Factors, were the trees, and the weather conditions were conducive to carburetor icing.NTSB MIA00FA118Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Panama City, FLThe pilot experiencing spatial disorientation while reversing course during a dark night while over water which resul;ted in an in-flight collision with water. A factor was the dark night lighting conditions.NTSB MIA00LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe partial loss of engine power due to undetermined reasons.NTSB MIA00LA116Accident · No injuriesLimited investigationFinal reportStearman A75N1 · Fort Lauderdale, FLThe pilot's failure to maintain directional control after touchdown and the subsequent wing tip strike, ground loop, and runway excursion.NTSB MIA00LA115Accident · Serious injuriesLimited investigationFinal reportBeech 1900 · Miami, FLInadequate visual lookout by the driver of the vehicle.NTSB MIA00LA112Accident · No injuriesLimited investigationFinal reportCessna A188B · Lake Placid, FLThe pilots inadequate visual outlook while performing aerial application resulting in the aircraft colliding with a piece of farm equipment which was parked in the field which caused the right main landing gear to separate and damage to the right wing during…NTSB MIA00LA111Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Sanford, FLThe pilot's improper collective and cyclic control usage during an emergency descent, following the onset of a 1 to 1 vibration for undetermined reasons, resulting in the helicopter landing hard and rolling over.NTSB MIA00LA110Accident · Minor injuriesLimited investigationFinal reportAeronca-Bubeck Irving BUBECK-AERONCA · Merritt Island, FLThe flight instructors inadequate supervision of the dual student resulting in the student pushing forward on the control stick during a bounced landing until the aircraft impacted the runway, bounced, landed hard, and broke the main landing gear.NTSB MIA00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLSeparation of the right main landing gear tire recap during takeoff resulting in the pilot's loss of directional control, the aircraft departing the runway, collapse of the landing gear, and collision with the airport fence.NTSB MIA00LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLthe flight instructor's inadequate supervision of the student pilot by allowing the student to fly in gusty wind conditions with excessive crosswinds that resulting in the student pilot not maintaining control and nosing the aircraft over.NTSB MIA00FA107Accident · No injuriesField investigationFinal reportCessna 310D · Stuart, FLthe failure of both pilots to maintain an adequate visual lookout, resulting in both airplanes colliding in flight. Contributing to the accident were: 1) inadequate approach/departure control service by ATC approach/departure personnel, and the failure of the…NTSB MIA00FA103Accident · 4 fatalField investigationFinal reportCessna 172K · Sarasota, FLThe failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…NTSB ATL00LA033Accident · Serious injuriesLimited investigationFinal reportAero Comp COMP-AIR-6 · Indiantown, FLThe maintenance personnel inadequate inspection of the fuel system that resulted in loss of engine power due to fuel filter contamination.NTSB ATL00IA035Incident · No injuriesIncident investigationFinal reportCessna CE-560 · Key Largo, FLThe malfunction of the nose gear locking mechanism for undetermined reason.NTSB MIA00FA102Accident · 2 fatalField investigationFinal reportMcDonnell Douglas HU-600N · Miami, FLThe pilot's ostentatious display and in-flight decision to perform an abrupt low altitude pitch up maneuver (aerobatic flight). This resulted in the main rotor blades colliding with and separating the tail boom assembly while maneuvering, and the helicopters…NTSB ATL00LA031Accident · 1 fatalLimited investigationFinal reportunknown unknown · Manatee, FLThe pilot's impairment due to the use of unapproved medication which led to loss of control in flight.NTSB ATL00LA030Accident · Minor injuriesLimited investigationFinal reportBurak Stanley A XF4 · Brooksville, FLThe owner/builder's failure to build the airplane within the design stress limits of the drive shaft assembly, that resulted in the failure of the Flex Coupling Retention Bolts.NTSB MIA00LA099Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Brooksville, FLTotal loss of engine power for undetermined reasons on appr oach for landing resulting in an in-flight collision with a dirt bank, separation of the main landing gear, and subsequent nose over. Contributing to the accident was carburetor icing conditions.NTSB MIA00LA097Accident · No injuriesLimited investigationFinal reportHughes TH-55 · Odessa, FLThe pilot's improper use of flight controls (cyclic and col lective) during a autorotation resulting in a hard landing and subsequent roll over.NTSB ATL00LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Titusville, FLThe pilot's improper decision to attempt a flight on minimal fuel, which resulted in a total loss of engine power due to fuel exhaustion. A factor was the closed fuel pumps at the departure airport.NTSB MIA00LA094Accident · No injuriesLimited investigationFinal reportNorth American NA-64 · Clearwater, FLA total loss of engine power due to fuel starvation for und etermined reasons. This resulted in a forced landing to none suitable terrain, and a subsequent in-flight collision with trees and terrain.NTSB MIA00LA095Accident · No injuriesLimited investigationFinal reportAerospatiale SA341G · Delray, FLa collision with a fence while at a hover, which resulted in the helicopter rolling over.NTSB MIA00LA093Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Miami, FLthe pilot planned the approach too low, which resulted in inadequate altitude to clear powerlines, and the subsequent in-flight collision with the ground.NTSB ATL00LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB ATL00LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot's failure to maintain visual lookout during flight operations under Visual Flight Rules. A factor is that the pilot was not on the airport radio frequency.NTSB ATL00FA024Accident · 2 fatalField investigationFinal reportMooney M20J · Odessa, FLThe pilot's failure to maintain a safe altitude and his failure to attain the proper touchdown point during landing. A factor was the utility pole.NTSB MIA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Englewood, FLThe failure of the pilot to retract the flaps from the fully extended position following the last landing resulting in the failure to maintain airspeed and subsequent descent for a forced landing. A contributing factor in the accident was the pilot's…NTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.NTSB MIA00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ocean Reef Club, FLThe failure of the pilot to maintain directional control of the airplane while taxiing after landing resulting in the on-ground collision with high vegetation.NTSB MIA00LA071Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Deland, FLThe pilot's evasive maneuver during landing roll due to panic after hearing another pilot report landing on the opposite runway resulting in the pilot losing directional control and nosing over in soft terrain. A factor in the accident was the pilot of the…NTSB MIA00TA070Accident · Minor injuriesFinal reportBell UH-1H · Fort Myers, FLA total loss of engine power due to turbine wheel fracture resulting from fatigue for undetermined reasons that resulted in an autorotation to unsuitable terrain and hard touchdown and rollover.NTSB MIA00LA072Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Palmetto, FLFailure for undetermined reasons of the right main landing gear strut during landing resulting in collapse of the right main landing gear.NTSB MIA00LA061Accident · No injuriesLimited investigationFinal reportEaa Chapter 229 Zenair 601 · Kissimmee, FLThe pilot's failure to maintain directional control on landing resulting in the airplane going off the side of the runway and colliding with a barricade.NTSB MIA00LA063Accident · No injuriesLimited investigationFinal reportCessna 550 · Homestead, FLAn inadvertent in-flight collision with a bird in cruise flight resulting in substantial damage to the airplane.NTSB ATL00LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Melbourne, FLThe certified flight instructor's improper touchdown flare that resulted in a hard landing.NTSB MIA00GA057Accident · Serious injuriesFinal reportHughes OH-6A · Fort Myers, FLimproper maintenance inspection of the helicopter by unknown maintenance personnel, resulting in a worn control rod bearing being continued in service, and subsequent separation, resulting in an in-flight loss of control and a crash.NTSB MIA00LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-400 · Naples, FLThe pilot's improper fuel management and selection of an empty fuel tank (auxiliary) on approach for landing. This resulted in a total loss of engine power due to fuel starvation, forced landing, and subsequent in-flight collision with terrain.NTSB MIA00LA051Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodville, FLThe pilot's improper preflight planning resulting in loss of engine power due to fuel exhaustion and the collision with trees during a forced landing.NTSB MIA00LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Fort Lauderdale, FLThe failure of the pilot to maintain minimum flying airspeed, (Vso) during takeoff following a partial loss of engine power resulting in the aircraft stalling, an uncontrolled descent, and collision with trees. A factor in the accident was the failure of the…NTSB MIA00LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLThe pilot's improper flare resulting in a hard landing and a collapsed nose landing gear.NTSB MIA00LA038Accident · No injuriesLimited investigationFinal reportMaule MX-7-160 · Palm Bch Garden, FLThe sailplane pilot's failure to comply with standard emergency procedures for 'sailplane release failure' upon its occurrence and his maneuvering of the sailplane while still tethered to the tow plane resulting in the inflight loss of control and engine…