NTSB investigations, 2009, 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 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 | 82 |
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 year(c.\"eventDate\") = 2009
AND 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 year(c."eventDate") = 2009 AND 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 ERA10LA101Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St. Petersburg, FLA loss of engine power for undetermined reasons.NTSB ERA10FA091Accident · 4 fatalField investigationFinal reportCessna 172S · Kissimmee, FLThe pilot's decision to depart under special VFR flight at night when instrument meteorological conditions prevailed at the departure airport and along the route of flight and his continued VFR flight into instrument meteorological conditions, which resulted…NTSB ERA10LA086Accident · 2 fatalLimited investigationFinal reportCox Busby Mustang · Plant City, FLThe pilot’s failure to maintain adequate airspeed following a loss of engine power for undetermined reasons.NTSB ERA10LA085Accident · Serious injuriesLimited investigationFinal reportTail Feather Sea Rey · Sanibel Island, FLThe pilot’s failure to add power during a low-level turn, which resulted in a loss of airspeed and a subsequent stall.NTSB ERA10LA084Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Hillsboro Beach, FLA total loss of engine power for undetermined reasons.NTSB ERA10CA083Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 · Indian Key, FLThe pilot's failure to secure the collective control prior to departing the helicopter, which resulted in an unmanned departure and subsequent crash of the helicopter.NTSB ERA10CA078Accident · No injuriesData collectionFinal reportCessna 172 · Panancea, FLThe pilot's failure to maintain directional control during the landing rollout.NTSB ERA10CA071Accident · No injuriesData collectionFinal reportCirrus SR-22 · Everglades City, FLThe pilot's failure to maintain directional control during the attempted go-around.NTSB ERA10LA070Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Port Charlotte, FLA partial loss of engine power due to the separation of the spark plug hole helicoil from the bottom position of the No. 3 cylinder for undetermined reasons.NTSB ERA10CA069Accident · No injuriesData collectionFinal reportParadise USA Paradise P-1 Slsa LW · Plant City, FLThe pilot's improper flare while landing, which resulted in a hard landing.NTSB ERA10CA076Accident · No injuriesData collectionFinal reportClassic Waco YMF · Dunnellon, FLThe certified flight instructor’s delayed response to the student pilot's loss of directional control while landing, which resulted in a ground-loop. Contributing to the accident was the student pilot's loss of directional control.NTSB ERA10LA063Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright Travel AIR · Fort Myers, FLThe pilot's improper recovery from a bounced landing and failure to maintain directional control, which resulted in a ground loop. Contributing to the accident was the pilot's minimal experience in the airplane make and model.NTSB ERA10CA079Accident · No injuriesData collectionFinal reportAir Gulfstream Airlines SX-300 · West Palm Beach, FLThe loss of directional control while landing for undetermined reasons.NTSB ERA10CA064Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pahokee, FLThe pilot’s failure to maintain control of the helicopter.NTSB ERA10FA052Accident · 1 fatalField investigationFinal reportAero Commander 100 · Weston, FLThe flight's descent for undetermined reasons, resulting in the in-flight collision with terrain.NTSB ERA10CA054Accident · No injuriesData collectionFinal reportPiper PA32 · Jacksonvile, FLThe pilot’s failure to maintain directional control during landing in gusty crosswind conditions.NTSB ERA10LA050Accident · Minor injuriesLimited investigationFinal reportGrumman Aircraft ENG G-111 · Ft Pierce, FLA total loss of left engine power and subsequent failure of the airplane to maintain airspeed and altitude on the remaining engine for undetermined reasons.NTSB ERA10FA048Accident · 2 fatalField investigationFinal reportCessna 172S · Tallahassee, FLThe pilots' spatial disorientation during flight in dark conditions, which resulted in an uncontrolled descent into terrain.NTSB ERA10CA046Accident · Minor injuriesData collectionFinal reportAmerican AA1 · Lake Placid, FLThe pilot's failure to maintain clearance from a power line.NTSB ERA10CA045Accident · No injuriesData collectionFinal reportBeech 77 · Gainesville, FLThe pilot's failure to maintain aircraft control during landing.NTSB ERA10LA042Accident · No injuriesLimited investigationFinal reportBeriev BE-103 · Miami, FLA malfunction of the landing gear retraction/extension and indication system for undetermined reasons, which resulted in one or more components being improperly positioned for the water landing.NTSB ERA10LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Brooksville, FLA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.NTSB ERA10FA028Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Zephyrhills, FLA total loss of engine power during a night approach for undetermined reasons.NTSB ERA10LA019Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · La Belle, FLThe loss of main rotor rpm due to the failure of one or more of the drive belts for undetermined reasons.NTSB ERA10GA015Accident · No injuriesFinal reportBell OH-58A · Ocala, FLThe excessive wear and failure of engine governor components for undetermined reasons, which resulted in a loss of engine power.NTSB ERA10LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Marathon, FLA total loss of engine power for undetermined reasons.NTSB ERA10LA009Accident · No injuriesLimited investigationFinal reportButler Aerostar · Brooksville, FLThe collapse of the nose landing gear during landing rollout for undetermined reasons.NTSB ERA09LA547Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glen St. Mary, FLThe pilot's failure to maintain control of the airplane during the landing.NTSB ERA09CA541Accident · No injuriesData collectionFinal reportCessna 172P · Pensacola, FLThe pilot's inability to maintain control during landing due to the separation of the nose landing gear upper scissor from the nose gear assembly. Contributing to the accident was the inadequate visual examination performed during the annual inspection.NTSB ERA09CA545Accident · No injuriesData collectionFinal reportKermit Weeks Quicksilver · Polk City, FLThe pilot’s failure to adequately inspect the landing gear floats for water prior to takeoff.NTSB ERA09FA526Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Fort Lauderdale, FLFatigue failure of the No. 5 engine cylinder fuel supply line, which resulted in an engine compartment fire. Also causal was the pilot's failure to immediately secure the engine/perform a forced landing after discovery of the fire, which resulted in the…NTSB ERA09FA524Accident · Serious injuriesField investigationFinal reportCurtis John P SEA REY · Winter Haven, FLThe flightcrew's failure to maintain adequate airspeed while maneuvering during a simulated engine failure, resulting in an aerodynamic stall and uncontrolled descent.NTSB ERA09CA525Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A TWI · Clermont, FLThe flight instructor's delayed remedial action resulting in an off-airfield landing and ground loop.NTSB ERA09CA522Accident · No injuriesData collectionFinal reportCessna 152 · Merritt Island, FLThe student pilots failure to maintain directional control after landing.NTSB ERA09CA548Accident · No injuriesData collectionFinal reportPiper PA-20 · Herlong, FLThe pilot’s improper visual lookout while taxing on soft terrain.NTSB ERA09LA503Accident · 1 fatalLimited investigationFinal reportPiper PA-11 · Quincy, FLThe pilot’s improper use of flight controls following a partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s impairment from the use of an over-the-counter sedating antihistamine.NTSB ERA09LA500Accident · 1 fatalLimited investigationFinal reportBlum Matthew Aventura II · Boca Raton, FLThe improper assembly of both carburetors, resulting in an excessively rich fuel to air ratio and subsequent partial loss of engine power.NTSB ERA09LA502Accident · 2 fatalLimited investigationFinal reportM-Squared Sprint 1000 · Madeira Beach, FLA loss of torque to the gearbox engine-side coupling flange bolts, which resulted in separation of the gearbox and propeller from the engine and the subsequent severing of the airplane's tail structure.NTSB ERA09CA495Accident · No injuriesData collectionFinal reportUnderland/Grothe/Finstrom Mmii (Must · Lantana, FLThe delay by both pilots to abort the takeoff resulting in a runway overrun. Contributing to the accident was the unintentional forward movement of the pilot's seat resulting in interference with the control stick.NTSB ERA09LA520Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Arcadia, FLThe pilot's bounced takeoff roll, which resulted in a collapsed landing gear. Contributing to the accident was the airplane's overweight condition.NTSB ERA09LA488Accident · Serious injuriesLimited investigationFinal reportBoeing 717-200 · Inverness, FLThe flight crew's encounter with convective turbulence. Contributing to the accident was the failure of the operator's dispatch department to provide the flightcrew with current adverse weather information along the planned route of flight. Also contributing…NTSB ERA09LA477Accident · Serious injuriesLimited investigationFinal reportVollenweider R/Hurst R F Vans RV-9A · Marianna, FLFailure of the propeller speed reduction gearbox for undetermined reasons. Contributing to the accident was the pilot’s decision to disregard the manufacturer's mandate to replace the gearbox, the manufacturer's failure to provide owners with technical…NTSB ERA09LA473Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Okeechobee, FLA total loss of engine power during initial climb for undetermined reasons.NTSB ERA09LA549Accident · No injuriesLimited investigationFinal reportCessna 172P · Pensacola, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA09LA464Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland EC-145 · North Captiva Island, FLThe pilot's failure to arrest the helicopter's descent, which resulted in controlled flight into terrain.NTSB ERA09LA471Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Sanford, FLThe fatigue cracking at the point the nose landing gear actuator attaches to the mount resulting in separation of the actuator and partial collapse of the nose landing gear. Contributing to the accident was the lack of specific inspection guidance for…NTSB ERA09LA458Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Sanford, FLThe pilot’s failure to maintain directional control during takeoff.NTSB ERA09TA440Accident · Minor injuriesFinal reportEurocopter AS 350B3 · Jacksonville, FLThe flight instructor's improper decision to attempt hover flight without hydraulic power and his subsequent loss of control.NTSB ERA09CA505Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Geneva, FLOil starvation due to air in the engine oil supply line, which resulted in engine seizure during initial climb.NTSB ERA09LA421Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Dunedin, FLA partial loss of engine power for undetermined reasons.