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 MIA05CA032Accident · Serious injuriesData collectionFinal reportCessna 172B · Zephyrhills, FLThe pilot's failure to set the parking brake and his improper starting procedure which resulted in an unattended aircraft running away after hand starting the engine and the airplane colliding with parked airplanes, incurring substantial damage.NTSB MIA05CA030Accident · Minor injuriesData collectionFinal reportEnstrom F-28C · Panama City Bch, FLThe pilot's improper refueling of the helicopter resulting in loss of engine power do to fuel exhaustion and damage to the helicopter during the subsequent hard forced landing.NTSB MIA05LA029Accident · Serious injuriesLimited investigationFinal reportJoseph R. Sirgo Aquilla · Eustis, FLThe passenger's control interference, which resulted in a loss of control, and the airplane impacting a hangar during takeoff/initial climb.NTSB MIA05LA027Accident · No injuriesLimited investigationFinal reportCessna 170A · Opa Locka, FLThe pilot's improper landing flare/touchdown, which resulted in a hard landing.NTSB MIA05LA037Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, FLThe improper flare by the pilot in command resulting in a hard landing, Restricted movement of the throttle was a contributing factor.NTSB MIA05CA034Accident · No injuriesData collectionFinal reportBeech 58 · Fort Pierce, FLThe failure of the pilot to follow the checklist and extend the landing gear during landing resulting in a gear-up landing.NTSB MIA05CA022Accident · No injuriesData collectionFinal reportChampion 7GCBC · Pierson, FLThe inadequate visual lookout by the pilot-in-command resulting in the airplane encountering uneven terrain, propeller contact to the ground, and subsequent nose over.NTSB MIA05FA024Accident · 2 fatalField investigationFinal reportSocata TB 20 · Key West, FLThe pilot's failure to maintain aircraft control as a result of spatial disorientation. A related factor was the dark, night conditions.NTSB MIA05CA039Accident · No injuriesData collectionFinal reportRobinson R-22 · Daytona Beach, FLThe improper landing flare by an unknown pilot at an unknown time resulting in a hard landing and substantial damage to the helicopters tailcone.NTSB MIA05LA021Accident · 1 fatalLimited investigationFinal reportJ.D. Calhoun Vans Acft RV6A · Weirsdale, FLFailure of the nose landing gear for undetermined reasons, resulting in the airplane nosing over during the landing roll, and the pilot's decision to operate the airplane with known deficiencies in the nose landing gear. A factor contributing to the fatality…NTSB MIA05FA020Accident · 1 fatalField investigationFinal reportRawdon Bros. T1 · Pembroke Pines, FLImproper maintenance by company maintenance personnel, and the pilot-in-command's operating the airplane with known deficiencies, which resulted in the loss of engine power due to fuel system contamination, and a loss of control while maneuvering to return to…NTSB MIA05LA018Accident · No injuriesLimited investigationFinal reportCessna 340A-RAM VI · Pensacola, FLThe left landing gear collapsing due to the actuator separating for undetermined reasons.NTSB MIA05FA017Accident · 1 fatalField investigationFinal reportCessna P206 · Jacksonville, FLThe improper setting of the elevator trim by the pilot-in-command, his failure to follow the checklist related to elevator trim setting, and his failure to maintain VS during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and…NTSB MIA05CA038Accident · No injuriesData collectionFinal reportSteven W. Jones KR2 · Zellwood, FLThe failure of the pilot to maintain directional control during landing resulting in the on-ground collision with a drainage ditch.NTSB MIA05LA019Accident · No injuriesLimited investigationFinal reportScottish Bulldog 120/121 · Jacksonville, FLThe pilot's failure to maintain altitude/clearance with trees resulting in the in-flight collision with a tree, damage to the right main landing gear, and subsequent collapse of the right main landing gear during the emergency landing.NTSB MIA05LA015Accident · Serious injuriesLimited investigationFinal reportDavid Cadorette Fox Model II · Vero Beach, FLLoss of engine power, for undetermined reasons, resulting in the airplane impacting with a tree and the ground during the subsequent forced landing.NTSB MIA05LA012Accident · No injuriesLimited investigationFinal reportRockwell 112A · Tampa, FLThe pilot's failure to properly set flaps for takeoff which resulted in the aborted takeoff and subsequent impact with water during an overrun of the runway and seawall.NTSB MIA05LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Pompano Beach, FLThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power in one engine. Contributing factors were the pilot's inadequate handling of the aircraft following failure of the right engine for his failure…NTSB MIA05FA008Accident · 3 fatalField investigationFinal reportEurocopter Deutschland BO-105 CBS5 · Santa Rosa Bch, FLThe pilot's spatial disorientation and in-flight loss of control of the helicopter after encountering night instrument meteorological conditions resulting in collision with water during the resultant uncontrolled descent. A factor in the accident was the…NTSB MIA05CA014Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Valkaria, FLThe inadvertent collision with a deer during takeoff which resulted in damage to the right brake system and the airplane being unable to stop prior to the end of the runway.NTSB MIA05LA003Accident · Serious injuriesLimited investigationFinal reportde Havilland DH-82C · Cross City, FLA loss of engine power for undetermined reasons, which resulted in a forced landing.NTSB MIA05CA002Accident · Minor injuriesData collectionFinal reportRobinson R-22 · Pompano Beach, FLThe flight crew's excessive descent rate during landing, resulting in a hard landing, and the tail boom being severed.NTSB MIA05LA001Accident · No injuriesLimited investigationFinal reportRotorway 162F · New Smyrna Beac, FLA loss of engine power due to undetermined reasons, which resulted in the pilot entering autorotation and affecting a forced landing to the water.NTSB MIA04FA128Accident · 4 fatalField investigationFinal reportCessna R182 · Milton, FLThe pilots operation of the airplane with known deficiencies in the equipment based on witness statements describing an excessive rpm drop and rough running engine after starting, during the engine run-up, and after becoming airborne, his failure to abort the…NTSB ATL04LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Inverness, FLThe improper installation of the carburetor which resulted in a loss of engine power and subsequent collision with trees during an emergency landing.NTSB ATL04CA185Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Belle Glade, FLThe pilot's inadequate preflight inspection and a loss of engine power due to water contamination of the fuel.NTSB ATL04LA177Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Lake Wales, FLThe pilot's inadequate preflight planning and preparation, and his inadequate visual lookout, which resulted in a collision with a television tower.NTSB ATL04CA179Accident · Minor injuriesData collectionFinal reportCessna 152 · Inverness, FLThe pilot's inadequate preflight inspection, and his failure to detect the presence of water in the fuel system, which resulted in a loss of engine power and subsequent collision with trees and terrain.NTSB ATL04CA192Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Miami, FLThe pilot's failure to follow the after landing check list, which resulted in his inadvertent gear retraction during landing roll.NTSB ATL04CA182Accident · No injuriesData collectionFinal reportMaule M4-210C · Gainesville, FLThe pilot-rated passenger's inadvertent interference with the flight controls during landing, which resulted in a loss of control and the airplane nosed over.NTSB MIA04LA126Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Greenville, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The pilot's inadequate preflight planning/preparation to ensure an adequate fuel supply is a contributing factor.NTSB MIA04LA124Accident · No injuriesLimited investigationFinal reportCessna 550 · Venice, FLThe pilot's failure to maintain adequate airspeed which resulted in a stall and undershoot of the runway.NTSB MIA04LA123Accident · No injuriesLimited investigationFinal reportBell 206B3 · Panama City, FLInadequate maintenance inspection resulting in the partial loss of engine power due to a loose pneumatic line on the governor and ditching of the helicopter.NTSB MIA04LA122Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · West Palm Beach, FLThe partial loss of engine power due to low cylinder compression during recovery from a practice autorotation resulting in a hard landing and damage to the helicopter.NTSB MIA04LA121Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Ochopee, FLThe pilot's loss of control in flight for undetermined reasons, which resulted in an uncontrolled descent, and subsequent impact with trees and the terrain.NTSB MIA04LA120Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · Pensacola, FLThe pilot's inadequate planning/decision and his failure to maintain airspeed which resulted in fuel exhaustion and an inadvertent stall.NTSB MIA04FA119Accident · 1 fatalField investigationFinal reportCessna U206B · Key West, FLA loss of engine power for an undetermined reason during cruise flight, which resulted in the pilot ditching the airplane in ocean waters.NTSB MIA04CA109Accident · No injuriesData collectionFinal reportCessna 172SP · Miami, FLThe pilot's failure to maintain control while landing with a crosswind and gusting wind conditions, which resulted in the airplane veering off the runway and incurring damage.NTSB MIA04GA117Accident · 1 fatalFinal reportBell 47G-5 · Bunnell, FLThe pilot's continued flights and inadequate inspections after repeated tail rotor guard ground strikes due to improper flaring, which resulted in an in-flight failure of tail rotor drive shaft components, a loss of control, and the helicopter crash.NTSB MIA04CA116Accident · No injuriesData collectionFinal reportCessna 152 · Sarasota, FLThe student pilot's incorrect recovery following a bounced landing resulting in a hard landing and collapse of the nose landing gear.NTSB MIA04FA115Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Miami, FLThe failure of company maintenance personnel to secure the push/pull tube to the left lug of the non-rotating portion of the swashplate assembly following maintenance, and the inability of the pilot to control the helicopter resulting in the in-flight…NTSB MIA04CA114Accident · No injuriesData collectionFinal reportCessna 140 · Wimauma, FLThe improper in-flight weather evaluation by the student pilot resulting in a downwind landing and subsequent nose over.NTSB MIA04LA113Accident · Minor injuriesLimited investigationFinal reportRobinson R 22 Mariner · Lantana, FLThe failure of the pilot-in-command to maintain recommended main rotor RPM following a reported total loss of engine power due to undetermined reasons, during a practice autorotation resulting in a hard landing and subsequent roll over.NTSB DCA04MA061Accident · Serious injuriesMajor investigationFinal reportBoeing 777 · Miami, FLthe in-flight encounter with unforecasted clear air turbulence.NTSB MIA04CA118Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Sugar Loaf Key, FLThe failure of the pilot to attain the proper touchdown point resulting in a landing overrun and subsequent on-ground collision with trees.NTSB MIA04LA111Accident · No injuriesLimited investigationFinal reportRobert J. Labonte Defiant · DeLand, FLThe failure of the pilot to fully extend the nose landing gear resulting in collapse of it during the landing roll. A contributing factor in the accident was the lack of a nose landing gear down and locked indicator.NTSB MIA04FA107Accident · No injuriesField investigationFinal reportLearjet 55 · Fort Lauderdale, FLThe flight crew's decision to continue the approach into known area of potentially severe weather (Thunderstorm), which resulted in the flight encountering a 30 knot cross wind, heavy rain, low-level wind shear, and hydroplaning on a ungrooved contaminated…NTSB MIA04LA136Accident · No injuriesLimited investigationFinal reportCessna 182 · Naples, FLThe dual student's improper landing flare and the pilot-in-command/CFI's inadequate supervision resulting in a hard landing.NTSB MIA04CA106Accident · No injuriesData collectionFinal reportPiper PA-28 · Okeechobee, FLStudent pilot's failure to maintain directional control of the airplane during landing roll, resulting in the airplane departing the runway and impacting a fence incurring substantial damage to the airplane.NTSB ENG04IA021Incident · No injuriesIncident investigationFinal reportRaytheon Corporate Jets Beechjet 400A · Sarasota, FLHigh-altitude ice crystals that had accreted on the compressor vanes and were ingested into the high pressure compressor when the pilots retarded the power levers causing compressor surges and flameouts of both engines. Contributing factors were the lack of…