NTSB investigations, FL
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 ERA26LA025Accident · No injuriesClass 4 · LimitedFinal reportAkrotech Giles G-202 · Boca Raton, FLThe low-wing pilot’s inadequate visual lookout, which resulted in a collision with another airplane while taxiing.NTSB ERA26LA023Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · St. Augustine, FLThe student pilot’s failure to properly set the elevator trim prior to takeoff, which resulted in her inability to effectively control the airplane’s pitch and a collision with trees at the end of the runway during initial climb.NTSB DCA26FA019Accident · No injuriesClass 4 · FieldFinal reportAir Vev AIR ZERO2 · Indiantown, FLA cascading shutoff of multiple aft motors due to a sudden increase in motor loads during maneuvering, resulting in a loss of control.NTSB ERA26LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · North Lauderdale, FLA total loss of engine power due to a fuel delivery system leak, which allowed air to enter the fuel system. The source of the leak could not be determined based on the available evidence.NTSB ERA26LA007Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Miami, FLOn October 07, 2025, at 1440 eastern daylight time, a Cessna 172M, N433PT, was substantially damaged when it was involved in an accident near Miami, Florida. The private pilot and the flight instructor were uninjured. The airplane was operated as a Title 14…NTSB CEN26FA005Accident · 3 fatalClass 3 · FieldPreliminary reportBeech 58P · Williston, FLOn October 5, 2025, at 1610 eastern daylight time, a Beech 58P airplane, N121GJ, was destroyed when it was involved in an accident near Williston, Florida. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA013Accident · No injuriesClass 4 · LimitedFinal reportCessna T182T · Venice, FLThe pilot’s failure to maintain directional control while taxiing in gusty, quartering tailwind conditions.NTSB ERA26LA002Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260 · Parkland, FLThe pilot’s failure to retract the amphibious airplane’s landing gear before conducting a forced landing on the water, which resulted in a nose over.NTSB ERA25LA369Accident · No injuriesClass 3 · LimitedPreliminary reportGregory A Spicola AR-1 · Fort Myers, FLOn September 28, 2025, about 1000 EST, a Spicola AR-1 gyroplane, N107AR, was substantially damaged when it was involved in an accident at Buckingham Field Airport (FL59), Lehigh Acres, Florida. The commercial pilot and pilot-rated passenger were not injured.…NTSB ERA25LA368Accident · No injuriesClass 3 · LimitedPreliminary reportElmore Travis C Searey · Rotonda West, FLOn September 28, 2025, at 1126 eastern daylight time, an experimental, amateur-built Searey, N2090S, was substantially damaged when it was involved in an accident near Stump Pass, Florida. The private pilot sustained minor injuries. The airplane was operated…NTSB ERA25LA377Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Okeechobee, FLCollision with a bird during cruise flight.NTSB ERA25LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Merritt Island, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA25LA350Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Astatula, FLOn September 17, 2025 at 1000 eastern daylight time, a Piper PA-28-181 100i, N580JA, was substantially damaged when it was involved in an accident near Astatula, Florida. The student pilot sustained minor injuries. The airplane was operated as a 14 Code of…NTSB ERA25LA345Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172 · Williston, FLOn September 13, 2025, about 0733 eastern daylight time, a Cessna 172G, N345QA, was substantially damaged when it was involved in an accident near Williston, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB DCA25LA323Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Port Orange, FLAn encounter with convective turbulence during descent, which resulted in serious injuries to a flight attendant.NTSB ERA25LA335Accident · No injuriesClass 4 · LimitedFinal reportLafferty Jack SEA REY · Bell, FLThe pilot’s failure to raise the landing gear before landing on the water.NTSB ERA25LA327Accident · Minor injuriesClass 3 · LimitedPreliminary reportMark Strout Zenair Zodiac 601HDS · Connerton, FLOn September 01, 2025 about 1605 eastern standard time, an experimental amateur-built Zenith Zodiac 601 HDS, N680LM, was substantially damaged when it was involved in an accident near Connerton, Florida. The pilot and the passenger received minor injuries.…NTSB ERA25LA324Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · New Smyrna Beach, FLMaintenance personnel’s failure to detect and address water contamination of the airplane’s fuel system, which resulted in a total loss of engine power during initial climb.NTSB DCA25LA312Accident · Serious injuriesClass 4 · LimitedFinal reportMcdonnell Douglas MD 83 · Miami, FLAn encounter with convective turbulence during descent that resulted in a serious injury to a flight attendant.NTSB ERA25LA323Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Spring Hill, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.NTSB ERA25LA343Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · St. Petersburg, FLThe pilot’s failure to extend the landing gear prior to landing. Contributing to the accident was a malfunction of the landing gear’s electrical retraction/extension system, which tripped the circuit breaker.NTSB ERA25LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Miami, FLAn inflight loss of hydraulic fluid from the landing gear system through a cracked fitting, which resulted in a landing gear collapse upon touchdown.NTSB ERA25LA302Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172 · Titusville, FLOn August 15, 2025, about 1415 eastern daylight time, a Cessna 172, N7205Q, was substantially damaged when it was involved in an accident near Titusville, Florida. The pilot was seriously injured and the flight instructor received minor injuries. The airplane…NTSB ERA25LA301Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 560XL · Oakland Park, FLOn August 14, 2025, about 1715 eastern daylight time, a Cessna 560XL, N802TD, was substantially damaged when it was involved in an accident near Oakland Park, Florida. The airline transport pilot and commercial pilot were not injured. The airplane was…NTSB ERA25LA300Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · Inverness, FLOn August 14, 2025, about 1915 easter daylight time, a Piper-PA12, N4014M, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The private pilot sustained serious injuries, and the passenger received a minor injury. The…NTSB ERA25LA297Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · Ponce Inlet, FLOn August 11, 2024, about 1359 easter daylight time, a Piper PA-12, N2504M, was substantially damaged when it was involved in an accident near Ponce Inlet, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA25LA293Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Inverness Highlands South, FLThe pilot’s inadequate monitoring of the airplane during taxi which resulted in collision with a sign.NTSB ERA25LA288Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Pembroke Pines, FLOn August 05, 2025, about 0820 eastern daylight time, a Cessna 172N, N1213F, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor and student pilot were not injured. The airplane was operated as a…NTSB ERA25LA319Accident · No injuriesClass 4 · LimitedFinal reportWaco UBF · Tampa, FLThe pilot’s failure to maintain directional control during landing roll, which resulted in a runway excursion and collision with an object.NTSB ERA25LA281Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Kissimmee, FLOn July 30, 2025, at 11:28 eastern daylight time, a Cessna 172S, N121CW, was substantially damaged when it was involved in an accident near Kissimmee, Florida. The private pilot and flight instructor were uninjured. The airplane was operated as a Title 14…NTSB ERA25LA278Accident · Minor injuriesClass 3 · LimitedPreliminary reportOrlican S R O M-8 Eagle · Lake Worth Beach, FLOn July 28, 2025, about 16:24 eastern daylight time, an Orlican M-8, N974FL, was substantially damaged when it was involved in an accident near Lake Worth Beach, Florida. The flight instructor sustained minor injuries, the private pilot sustained no injuries,…NTSB ERA25LA382Accident · No injuriesClass 4 · LimitedFinal reportIcon A5 · Destin, FLThe pilot’s inadequate fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA266Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T337G · Pembroke Pines, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power to one of the airplane’s two engines. Contributing to the outcome was the pilot’s loading of the airplane beyond its maximum gross…NTSB ERA25LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · St. Augustine, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA263Accident · No injuriesClass 4 · LimitedFinal reportPiper PA34 · Fort Lauderdale, FLThe flight instructor’s inadequate supervision and delayed remedial actions during the landing approach, which resulted in the airplane contacting the runway with the landing gear retracted.NTSB ERA25LA261Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172H · Century, FLOn July 9, 2025, about 1820 central daylight time, a Cessna 172, N3254C, was involved in an accident near Century, Florida. The pilot and the passenger were not injured. The flight was conducted as a 14 Code of Federal Regulations Part 91 personal flight. The…NTSB ERA25LA256Accident · Serious injuriesClass 4 · LimitedFinal reportKyle Koncak Aventura II · DeLand, FLThe uncertificated pilot’s failure to remove an improvised gust lock which resulted in a loss of aircraft control at an altitude too low to recover.NTSB ERA25LA250Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Eustis, FLThe pilot’s inadequate preflight fuel planning and his failure to maintain directional control of the airplane after a total loss of right engine power during takeoff due to fuel starvation.NTSB ERA25LA235Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Milton, FLSeparation of the throttle cable sleeve during takeoff, which resulted an uncommanded engine power reduction and the pilot’s inability to control the engine throttle, and resulted in a forced landing.NTSB DCA25LA240Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A321-211 · Miami, FLThe unexpected encounter with a rapidly developing convective cell during climb resulting in convectively induced turbulence on a dark moon-less evening.NTSB DCA25LA238Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Fort Myers, FLThe airplane’s inadvertent encounter with convective turbulence during descent, which resulted in serious injuries to two flight attendants.NTSB DCA25LA234Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Ebro, FLThe airplane’s encounter with convective turbulence during climb while diverting to an alternate airport, resulting in a serious injury to a passenger who disregarded the flight crew’s illuminated seat belt sign and the cabin crew’s instruction to remain…NTSB ERA25LA234Accident · Minor injuriesClass 3 · LimitedPreliminary reportSteven Scott Grasley RV-7A · Interlachen, FLOn June 13, 2025, about 15:31 eastern daylight time, an experimental, amateur built RV-7A, N783RV, was substantially damaged when it was involved in an accident near Interlachen, Florida. The commercial pilot received minor injuries. The airplane was operated…NTSB ERA25LA229Accident · Minor injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R66 · Valparaiso, FLOn June 12, 2025, about 1850 eastern daylight time, a Robinson Helicopter R66, N633AF, was substantially damaged when it was involved in an accident near Valparaiso, Florida. The pilot and passenger sustained minor injuries, and a second passenger was not…NTSB ERA25LA273Accident · No injuriesClass 3 · LimitedFinal reportMooney M20R · New Port Richey, FLThe pilot's mismanagement of the available fuel, which resulted in fuel starvation and a total loss of engine power.NTSB ERA25LA232Accident · No injuriesClass 4 · LimitedFinal reportScoda Aeronautica Ltda Super Petrel XP · Geneva, FLThe airplane’s collision with a submerged object during landing, which resulted in substantial damage to the fuselage/hull.NTSB ERA25LA217Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-23 · Palm Bay, FLA loss of engine power to both of the airplane’s engines due to fuel exhaustion and fuel starvation.NTSB ERA25LA216Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172F · Vero Beach, FLA total loss of engine power for reasons that could not be determined.NTSB ERA25FA201Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32RT · Yulee, FLThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the opening of the nose baggage door and subsequent distraction of the pilot…NTSB ERA25LA200Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Florida City, FLThe commercial pilot’s improper fuel management, which resulted in a loss of total engine power due to fuel starvation.