Final NTSB investigations, FL
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 | 98 |
| 2016 | 96 |
| 2017 | 97 |
| 2018 | 119 |
| 2019 | 113 |
| 2020 | 92 |
| 2021 | 97 |
| 2022 | 82 |
| 2023 | 83 |
| 2024 | 97 |
| 2025 | 74 |
| 2026 | 35 |
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'
AND c.\"completionStatus\" = 'Completed'
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' AND c."completionStatus" = 'Completed' 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 ERA26LA330Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Leesburg, FLThe instructor’s delayed remedial action during an aborted landing, which resulted in a loss of airplane control.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 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 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 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 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 ERA26LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Homestead, FLThe pilot’s excessive braking during the landing roll, which resulted in a nose over.NTSB ERA26LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Bartow, FLThe pilot’s failure to extend the landing gear before landing.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 ERA26LA182Accident · No injuriesClass 4 · LimitedFinal reportDonald E Johnston Velocity XL-RG · Crestview, FLThe pilot’s failure to extend the landing gear before landing.NTSB 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 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.NTSB ERA26LA161Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Fellsmere, FLAn in-flight collision with a bird while descending to land at an airport.NTSB ERA26LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Daytona Beach, FLAn in-flight collision with a bird while enroute.NTSB ERA26LA146Accident · No injuriesClass 4 · LimitedFinal reportSchroder David Lancair IV-P · Feather Sound, FLThe pilot's failure to extend the landing gear before landing.NTSB ERA26LA149Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Sanford, FLAn in-flight collision with a bird during initial climb.NTSB ERA26LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Chuluota, FLAn in-flight collision with a bird while enroute.NTSB ERA26LA139Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · St. Augustine, FLThe pilot's failure to extend the landing gear before landing.NTSB ERA26LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Thonotosassa, 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 ERA26LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Okeechobee, FLThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB ERA26LA130Accident · No injuriesClass 4 · LimitedFinal reportTextron 680A · Miami, FLThe flight crew’s failure to maintain adequate clearance from the blast fence during taxi to the runway for departure, and their inadequate inspection of the airplane after it contacted the blast fence.NTSB ERA26LA119Accident · No injuriesClass 4 · LimitedFinal reportTabor W Coates AR-1 · Kissimmee, FLThe pilot’s failure to obtain the proper rotor rpm during the takeoff roll which resulted in a loss of control.NTSB ERA26LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 320C · Bartow, FLMaintenance personnel’s failure to perform an adequate inspection of the airplane’s landing gear, which resulted in a collapse of the left main landing gear during landing.NTSB ERA26LA112Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Umatilla, FLThe failure of the right main landing gear during the landing roll, which resulted in a loss of control on the ground and collision with an airport sign.NTSB ERA26LA108Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-3 · Palmetto, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA26LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Pembroke Pines, FLThe pilot's failure to extend the landing gear before landing.NTSB ERA26LA100Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-3B · Floral City, FLThe student pilot’s loss of helicopter control during landing.NTSB ERA26LA090Accident · No injuriesClass 4 · LimitedFinal reportDevesh Tiwary Lightning XS · New Port Richey, FLThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB ERA26LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 414A · Tampa, FLThe pilot’s failure to secure a bottle, which restricted movement of the right rudder pedal during landing.NTSB ERA26LA080Accident · No injuriesClass 4 · LimitedFinal reportVarga 2150A · Frostproof, FLThe pilot’s failure to maintain control of the airplane during takeoff, resulting in a runway excursion and collision with terrain.NTSB ERA26LA082Accident · No injuriesClass 4 · LimitedFinal reportPiper PA44 · Pembroke Pines, FLAn in-flight collision with a bird while on approach to the destination airport.NTSB ERA26LA075Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-200 · Hawthorne, FLThe pilot’s failure to maintain an appropriate descent rate for a glassy water landing, which resulted in a hard landing.NTSB ERA26LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Lauderdale, FLThe student pilot’s improper landing flare and the flight instructor’s inadequate remedial action, which resulted in a hard landing and subsequent nose landing gear collapse.NTSB ERA26LA068Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Pierce, FLThe pilot’s inadequate visual lookout while taxing, which resulted in the airplane striking a light pole.NTSB ERA26LA065Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Cocoa, FLThe flight crew’s failure to adequately manage the available fuel onboard the airplane, which resulted in a total loss of power due to fuel starvation.NTSB ERA26LA063Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · DeLand, FLThe flight instructor’s inadequate fuel quantity inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA26LA062Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Pensacola, FLThe pilot’s exceedance of the critical angle of attack during initial climb which resulted in an aerodynamic stall.NTSB ERA26LA060Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters Carbon Cub FX2 · Okeechobee, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA26LA058Accident · No injuriesClass 4 · LimitedFinal reportHuebbe Tom MAX TH · Inverness Highlands South, FLThe pilot’s failure to maintain directional control on takeoff. Contributing to the accident was the aircraft design that did not incorporate differential braking.NTSB ERA26LA053Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-23-250 · Clewiston, FLThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB ERA26LA044Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Eastpoint, FLThe pilot’s loss of airplane control during a go-around, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper recovery from an aerodynamic stall.NTSB ERA26LA045Accident · No injuriesClass 4 · LimitedFinal reportBeech 95 · Edgewater, FLThe pilot’s failure to extend the landing gear prior to landing.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.