NTSB investigations, FL
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 per year
| 1962 | 7 |
|---|---|
| 1963 | 6 |
| 1964 | 199 |
| 1965 | 231 |
| 1966 | 227 |
| 1967 | 258 |
| 1968 | 206 |
| 1969 | 197 |
| 1970 | 214 |
| 1971 | 205 |
| 1972 | 234 |
| 1973 | 254 |
| 1974 | 238 |
| 1975 | 218 |
| 1976 | 203 |
| 1977 | 220 |
| 1978 | 250 |
| 1979 | 242 |
| 1980 | 261 |
| 1981 | 208 |
| 1982 | 190 |
| 1983 | 219 |
| 1984 | 230 |
| 1985 | 212 |
| 1986 | 217 |
| 1987 | 200 |
| 1988 | 187 |
| 1989 | 183 |
| 1990 | 147 |
| 1991 | 158 |
| 1992 | 131 |
| 1993 | 147 |
| 1994 | 175 |
| 1995 | 136 |
| 1996 | 137 |
| 1997 | 146 |
| 1998 | 162 |
| 1999 | 143 |
| 2000 | 138 |
| 2001 | 120 |
| 2002 | 134 |
| 2003 | 136 |
| 2004 | 120 |
| 2005 | 150 |
| 2006 | 133 |
| 2007 | 150 |
| 2008 | 133 |
| 2009 | 103 |
| 2010 | 103 |
| 2011 | 110 |
| 2012 | 101 |
| 2013 | 91 |
| 2014 | 101 |
| 2015 | 99 |
| 2016 | 96 |
| 2017 | 97 |
| 2018 | 120 |
| 2019 | 113 |
| 2020 | 92 |
| 2021 | 97 |
| 2022 | 82 |
| 2023 | 83 |
| 2024 | 103 |
| 2025 | 105 |
| 2026 | 79 |
Where
Open the mapLatest cases
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 ERA27LA014Accident · No injuriesLimited investigationInvestigation openTextron 172S · Jacksonville, FLNTSB DCA27LA014Occurrence · No injuriesClass 4 · LimitedInvestigation openBoeing 777 · Orlando, FLNTSB ERA27LA003Accident · No injuriesClass 4 · LimitedInvestigation openHawker Siddeley HS.125 Series 700A · Fort Lauderdale, FLNTSB ERA26LA361Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-161 · Sarasota, FLNTSB ERA26LA351Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182S · St. Petersburg, FLNTSB ERA26LA342Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Panama City, FLOn September 7, 2026, about 1059 central daylight time, a Cessna 172N airplane, N734NM, was substantially damaged when it was involved in an accident near Panama City, Florida. The student pilot and flight instructor were not injured. The airplane was…NTSB CEN26FA310Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20F · Titusville, FLOn September 7, 2026, about 1015 eastern daylight time, a Mooney M20F airplane, N9546M, was destroyed when it was involved in an accident near Titusville, Florida. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA331Accident · No injuriesClass 3 · LimitedPreliminary reportBell 47G-4A · Alcoma, FLOn September 5, 2026, at 1422 eastern daylight time, a Bell 47G-4A, N797WS, was substantially damaged when it was involved in an accident near Alcoma, Florida. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal Regulations…NTSB DCA26MA352Accident · 5 fatalClass 1 · MajorPreliminary reportBoeing 767 · Miami, FLOn September 6, 2026, about 1353 eastern daylight time (EDT), 21 Air flight 7598, a Boeing 767-33A, N1997A, overran runway 30 after landing at Miami International Airport (MIA), Miami, Florida and subsequently impacted two ground passenger vehicles. The two…NTSB ERA26LA330Accident · No injuriesClass 4 · LimitedInvestigation openDiamond Aircraft Ind DA 40 NG · Leesburg, FLNTSB ERA26FA326Accident · 2 fatalClass 3 · FieldPreliminary reportMaclura Evolution · Tampa, FLOn September 3, 2026, about 0815 eastern daylight time, an experimental, amateur-built Evolution airplane, N305PV, was destroyed when it was involved in an accident near Tampa, Florida. The commercial pilot and passenger were fatally injured. The airplane was…NTSB ERA26LA319Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA22 · Pace, FLOn August 29, 2026, about 1030 central daylight time, a Piper PA-22-150, N5731D, was substantially damaged when it was involved in an accident near Pace, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA26LA316Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-18A 150 · New Smyrna Beach, FLOn August 27, 2026, about 1051 eastern daylight time, a Piper PA-18A 150, N2368P, was substantially damaged when it was involved in an accident near New Smyrna Beach, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA313Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Milton, FLThe flight instructor’s failure to maintain control of the helicopter during a low hover over a grass area, which resulted in left skid contact with the ground and a dynamic rollover to the left.NTSB ANC26LA088Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172L · Micanopy, FLOn August 18, 2026 at 1100 eastern daylight time, a Cessna 172L, N3866Q, was substantially damaged when it was involved in an accident near Micanopy, Florida. The flight instructor and student pilot were uninjured. The airplane was operated as a Title 14 Code…NTSB ERA26LA304Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Miramar, FLThe flight instructor’s failure to maintain control of the helicopter during a hover, which resulted in the left skid contacting ground and a subsequent dynamic rollover.NTSB ERA26LA300Accident · Serious injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Clermont, FLThe pilot’s failure to maintain clearance from trees during the landing approach.NTSB ANC26LA084Accident · Minor injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Anthony, FLOn August 12, 2026, at approximately 2305 eastern daylight time, a Robinson R44 Raven II helicopter, N861MP, was substantially damaged when it was involved in an accident near Anthony, Florida. The pilot and passenger sustained minor injuries. The helicopter…NTSB ERA26LA299Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Lakeland, FLAn in-flight collision with a bird while on approach.NTSB ERA26LA284Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Palmetto, FLThe flight instructor’s failure to maintain clearance from obstacles during low altitude maneuvering, which resulted in a collision with a fence.NTSB DCA26LA286Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LL · Sanford, FLAn encounter with convectively induced turbulence during cruise flight in an area of forecast thunderstorm activity.NTSB ERA26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportStits Playmate · Green Cove Springs, FLThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ANC26LA070Accident · Minor injuriesClass 3 · LimitedPreliminary reportMooney M20M · Tallahassee, FLOn July 8, 2026, at 1148 eastern daylight time, a Mooney M20 airplane was substantially damaged when it was involved in an accident near Tallahassee, Florida. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA258Accident · Serious injuriesClass 3 · LimitedPreliminary reportPortzline Joan M Flight Star II SC · Mulberry, FLOn July 4, 2026, about 1121 eastern daylight time, an experimental amateur-built Flight Star II SC airplane, N432JP, was substantially damaged when it was involved in an accident near Mulberry, Florida. The private pilot and a passenger were seriously…NTSB ERA26LA248Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe student pilot’s failure to ensure clearance while taxiing, which resulted in contact with another airplane that was performing an engine run-up.NTSB ERA26LA244Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182S · Naples, FLOn June 20, 2026 at 1030 eastern daylight time, a Cessna 182S, N7270H, was substantially damaged when it was involved in an accident near Naples, Florida. The pilot and three passengers were uninjured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26FA239Accident · 1 fatalClass 3 · FieldPreliminary reportBlessing RV-3A · Lakeland, FLOn June 15, 2026, about 1955 eastern daylight time, an experimental amateur-built Van’s RV-3A, N696DB, was destroyed when it was involved in an accident near Lakeland, Florida. The pilot received fatal injuries. The airplane was operated as a Title 14 Code of…NTSB ANC26LA053Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-235 · Key West, FLOn June 14, 2026, at 1035 eastern standard time, a Piper PA-28-235 airplane, N15564, was substantially damaged when it was involved in an accident near Key West, Florida. The pilot was not injured and the passenger sustained minor injuries. The airplane was…NTSB ANC26LA051Accident · Minor injuriesClass 3 · LimitedPreliminary reportRobinson R44 · Pembroke Pines, FLOn June 13, 2026, about 1318 eastern daylight time, a Robinson R44 Raven I helicopter, N336SG, was substantially damaged when it was involved in an accident at the North Perry Airport (HWO), Hollywood, Florida. The pilot and three passengers sustained minor…NTSB ERA26LA238Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P-MENTOR · Pompano Beach, FLThe student pilot’s improper landing flare, which resulted in a hard landing, and the flight instructor’s delayed remedial action.NTSB ERA26FA230Accident · Serious injuriesClass 3 · FieldPreliminary reportCessna 150 · Kissimmee, FLOn June 6, 2026, about 1458 eastern daylight time, a Cessna 150L, N156KA, was substantially damaged when it was involved in an accident near Kissimmee Gateway Airport (ISM), Kissimmee, Florida. The commercial pilot and student pilot were seriously injured.…NTSB ERA26LA226Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA44 · Opa-locka, FLNTSB ERA26LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Homestead, FLThe pilot’s excessive braking during the landing roll, which resulted in a nose over.NTSB ERA26LA221Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172P · Pembroke Pines, FLOn May 29, 2026, at 1138 eastern daylight time, a Cessna 172P, N96100, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor sustained serious injuries. The student pilot sustained minor injuries.…NTSB ERA26LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Bartow, FLThe pilot’s failure to extend the landing gear before landing.NTSB ERA26LA215Accident · Minor injuriesClass 3 · LimitedPreliminary reportTextron 172S · Jupiter Farms, FLOn May 22, 2026, about 1518 eastern daylight time, a Textron Aviation 172S, N294PL, was substantially damaged when it was involved in an accident near Jupiter Farms, Florida. The flight instructor and student pilot were not injured. The airplane was operated…NTSB ERA26LA206Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 750 · Fort Myers, FLOn May 9, 2026, at 1014 eastern daylight time, a Cessna 750 airplane, N119RM, was substantially damaged when it was involved in an accident near Fort Myers, Florida. The captain and first officer were not injured. The airplane was operated as a Title 14 Code…NTSB ERA26LA189Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Kissimmee, FLFracture of the left main landing gear trunnion during landing, which resulted in a loss of directional control during landing and subsequent runway excursion.NTSB ERA26LA184Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Tampa, FLThe pilot’s failure to maintain directional control of the airplane during the aborted landing, which resulted in a runway excursion, collision with a runway sign, and nose over.NTSB ERA26LA186Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172M · Crystal River, FLNTSB ERA26LA180Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Indiantown, FLOn April 18, 2026, about 2115 eastern daylight time, a Piper PA-28-181, N643FT, was substantially damaged when it was involved in an accident near Indiantown, Florida. The private pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26FA179Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 401B · Land O' Lakes, FLOn April 19, 2026, about 0834 eastern daylight time, a Cessna 401B, N122AT, was destroyed when it was involved in an accident near Land O’ Lakes, Florida. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA182Accident · No injuriesClass 4 · LimitedFinal reportDonald E Johnston Velocity XL-RG · Crestview, FLThe pilot’s failure to extend the landing gear before landing.NTSB ERA26FA177Accident · 1 fatalClass 3 · FieldPreliminary reportRajchl Vladimir Airplane Swing 06 · O'Brien, FLOn April 16, 2026, about 1030 eastern standard time, a Rajchl Vladimir Airplane Swing 06, N613SA, was substantially damaged when it was involved in an accident near O’Brien, Florida. The private pilot was fatally injured. The airplane was operated as a Title…NTSB ERA26FA166Accident · 2 fatalClass 3 · FieldInvestigation openNorth American AT-6D · Bronson, FLNTSB ERA26LA340Accident · No injuriesClass 4 · LimitedInvestigation openJames P Donovan Sportsman GS-2 · Winter Haven, FLNTSB ERA26LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Lutz, FLThe student pilot’s improper landing flare and the flight instructor’s inadequate remedial action, which resulted in a hard landing.NTSB ERA26LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Naples, FLThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA26LA172Accident · No injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-3 · Dry Tortugas, FLOn April 11, 2026, about 0845 eastern daylight time, an amphibious DeHavilland DHC-3, N708KA, was substantially damaged when it was involved in an accident near Dry Tortugas, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA170Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Jacksonville, FLThe pilot’s improper recovery from a practice autorotation, which resulted in a hard landing. Contributing to the accident was the flight instructor’s inadequate supervision of the pilot receiving the instruction.