NTSB investigations, FL
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 ERA18LA112Accident · Serious injuriesClass 3 · LimitedFinal reportGulfstream Aerospace G V · Miami, FLThe passengers' failure to comply with the fasten seatbelt sign, with resulted in their injury during an inflight turbulence encounter.NTSB ERA18LA110Accident · Minor injuriesLimited investigationFinal reportBesarick Skybolt · Punta Gorda, FLA substantial oil leak, which resulted in a partial loss of engine power and failure of the No. 2 connecting rod.NTSB ERA18LA109Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Palatka, FLBoth pilots’ and the flight instructor’s failure to identify, see, and avoid the other airplane, which resulted in a midair collision.NTSB ERA18LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Key West, FLA partial loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB GAA18CA197Accident · No injuriesData collectionFinal reportPiper PA28 · Cedar Key, FLThe pilot’s unstabilized approach, which resulted in a long landing and subsequent runway overrun.NTSB GAA18CA162Accident · Minor injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Punta Gorda, FLA collision with a large bird during approach.NTSB ERA18LA103Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Orlando, FLThe improper adjustment of the fuel pump by maintenance personnel, which resulted in an overly rich fuel/air mixture and a total loss of engine power.NTSB GAA18CA159Accident · No injuriesData collectionFinal reportHughes 269 · Jacksonville, FLThe pilot’s failure to maintain rotor rpm during a practice autorotation, which resulted in ground contact and a dynamic rollover.NTSB GAA18CA151Accident · No injuriesData collectionFinal reportCessna 172 · Lakeland, FLThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a bounced landing.NTSB ERA18LA097Accident · Minor injuriesLimited investigationFinal reportReilly Charles W Escapade · Palatka, FLThe interruption of fuel to the engine during final approach, which resulted in a total loss of engine power due to fuel starvation, and the pilot's subsequent failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB ERA18LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Edgewater, FLThe flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach.NTSB GAA18CA204Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot’s failure to maintain a stabilized approach, which resulted in overcorrection with the rudder during the landing, loss of control, and a runway excursion.NTSB ERA18LA102Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 32-300 · Pompano Beach, FLThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, which resulted in an aerodynamic stall, loss of control, and impact with terrain. Contributing to the accident was the pilot’s failure to maintain a proper approach…NTSB ERA18FA092Accident · 2 fatalField investigationFinal reportQuest Kodiac 100 · Georgetown, FLThe pilots' spatial disorientation while maneuvering for landing in night conditions over unlighted terrain, which resulted in an uncontrolled descent and impact with water.NTSB GAA18CA142Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna Astore · Apopka, FLThe student pilot’s failure to maintain directional control during takeoff.NTSB ERA18LA089Accident · 1 fatalClass 2 · LimitedFinal reportAirborne Windsports PTY Edge XT 912 L · Eustis, FLThe pilot's exceedance of the weight-shift-control aircraft's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot's lack of experience in the…NTSB ERA18LA086Accident · Minor injuriesClass 3 · LimitedFinal reportStearman B75 · Zephryhills, FLThe pilot's inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power and impact with a pole during a forced landing.NTSB ERA18FA084Accident · 1 fatalField investigationFinal reportPiper PA28 · Bonifay, FLA partial loss of engine power due to a stuck exhaust valve. Contributing to the accident was the pilot's decision to operate an airplane with a known mechanical deficiency and his failure to fly an appropriate traffic pattern that would have allowed the…NTSB GAA18CA174Accident · No injuriesData collectionFinal reportCessna P210 · Jacksonville, FLThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were pilot fatigue and his failure to use the before landing checklist.NTSB GAA18CA182Accident · No injuriesData collectionFinal reportHeinlein George GH125 · Valkaria, FLThe pilot’s decision to exit the paved runway into soft terrain, which resulted in a ground loop and landing gear collapse.NTSB ERA18LA083Accident · 1 fatalLimited investigationFinal reportGregory Newman Sonex Trainer · Carrabelle, FLA loss of engine power for reasons that could not be determined because the airplane was not recovered. Also causal was the pilot's decision to conduct a low-altitude turn following the loss of engine power, which resulted in an exceedance of the airplane's…NTSB GAA18CA113Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Homstead, FLThe pilot’s diverted attention to his phone while maneuvering at a low altitude, which resulted in collision with terrain.NTSB ERA18LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · Marathon, FLThe pilot's failure to maintain directional control during takeoff.NTSB ANC18LA021Accident · Serious injuriesClass 3 · LimitedFinal reportFoxfly Foxdominator · Indiantown, FLThe pilot’s improper decision to attempt to take off in the gyroplane in strong gusting crosswind conditions, with insufficient distance to safely abort, which resulted in a loss of control and impact with a ditch and road embankment.NTSB ERA18LA068Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Fort Lauderdale, FLThe partial loss of engine power during the initial climb due to a stuck intake valve on the No. 4 cylinder.NTSB ERA18FA064Accident · 1 fatalField investigationFinal reportVans RV-12 · Bonita Springs, FLThe pilot's unsafe maneuvering and exceedance of the airplane's operating limitations, which resulted in an in-flight failure of the left wing. Contributing to the accident was the pilot's underlying physiologic or psychiatric disease.NTSB ERA18LA082Accident · Serious injuriesLimited investigationFinal reportMosquito XEL · Loxahatchee, FLThe noncertificated pilot's failure to maintain helicopter control during takeoff. Contributing to the accident were the pilot's lack of recent flight experience and his lack of training and experience in the accident helicopter make and model.NTSB CEN18FA061Accident · 5 fatalField investigationFinal reportCessna 340 · Bartow, FLThe pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.NTSB GAA18CA093Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot’s failure to maintain directional control during the landing flare.NTSB ERA18LA058Accident · No injuriesLimited investigationFinal reportMooney M20K · Venice, FLA failure of the normal landing gear extension system for reasons that could not be determined due to damage to the system and the pilot's failure to ensure that the landing gear was down and locked before touchdown. Contributing to the accident was the…NTSB ERA18FA056Accident · 1 fatalField investigationFinal reportBeech G35 · Cross City, FLThe pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in the pilot experiencing spatial disorientation and a subsequent loss of airplane control.NTSB ERA18LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Everglades City, FLThe loose nut connecting the mixture control cable to the mixture control arm, which resulted in the pilot’s inability to control the mixture and the subsequent total loss of engine power.NTSB ERA18LA053Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S76 · Islamorada, FLThe pilot's activation of the rotor brake while the No. 2 engine was still set to govern the power turbine speed, which resulted in continuous power being applied to the rotor while the rotor brake was engaged and led to excessive friction, heat, and a…NTSB ERA18LA062Accident · No injuriesLimited investigationFinal reportPiper PA32 · Oakland Park, FLThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18FA050Accident · 1 fatalField investigationFinal reportSmith Aerostar 601 · Miami, FLThe pilot's loss of control while returning to the airport after takeoff for reasons that could not be determined based on the available information.NTSB WPR18FA045Accident · 3 fatalField investigationFinal reportBeech C90 · Geneva, FLThe pilot's loss of airplane control due to spatial disorientation during an instrument approach in instrument meteorological conditions, and the flight instructor's delayed remedial action. Contributing to the accident was the flight instructor's impairment…NTSB DCA18CA055Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Fort Lauderdale, FLan inadvertent encounter with convective turbulence that resulted in a flight attendant injury.NTSB GAA18CA072Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Fort Pierce, FLThe pilot’s improper landing flare, which resulted in a tail strike and hard landing.NTSB DCA18CA043Accident · No injuriesData collectionFinal reportAirbus A319 115 · Miami, FLThe failure of the flight crew of N9011P to maintain an appropriate clearance from N344PP, which was stopped on the taxiway.NTSB ANC18LA014Accident · No injuriesLimited investigationFinal reportCessna 172 · Miami, FLThe pilot's decision to continue the landing after a loss of visual cues during a night landing.NTSB GAA18CA080Accident · No injuriesData collectionFinal reportCessna 172 · Daytona Beach, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB WPR18LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Odessa, FLA loss of engine power due to fuel starvation as a result of the pilot's inadequate planning and in-flight fuel management. Contributing to the accident was the pilot’s failure to follow proper procedures after the loss of engine power.NTSB ERA18LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA46 · Clearwater, FLA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA18FA030Accident · 1 fatalField investigationFinal reportMooney M20C · Starke, FLThe pilot's loss of control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing was the pilot's lack of instrument currency and his self-induced pressure to complete the flight.NTSB ANC18LA010Accident · No injuriesLimited investigationFinal reportRockwell International 112A · Clearwater, FLA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA18CA064Accident · No injuriesData collectionFinal reportCessna 172 · Pompano, FLThe pilot’s improper landing flare, which resulted in a porpoise.NTSB GAA18CA053Accident · No injuriesData collectionFinal reportPiper PA 28R · Melborne, FLThe pilot’s loss of directional control during the landing roll on the wet runway.NTSB ANC18LA009Accident · No injuriesLimited investigationFinal reportCessna 172RG · Opa Locka, FLA failure of the airplane 's electrical system, which led to the failure of the landing gear system, for reasons that could not be determined because postaccident examination and testing revealed no mechanical anomalies that would have precluded normal…NTSB GAA18CA039Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain lateral/bank control during landing in gusting crosswind conditions.NTSB ANC18FA007Accident · 1 fatalField investigationFinal reportIcon A5 · Clearwater, FLThe pilot's improper decision to perform aggressive, low-altitude maneuvers due to his impairment from the use of multiple psychoactive substances, which resulted in a loss of control.