NTSB investigations, 2002, 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 | 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\") = 2002
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") = 2002 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 ATL03LA028Accident · No injuriesLimited investigationFinal reportCessna 172F · Stuart, FLThe pilot's inflight encounter with wind shear on final approach, which resulted in an inflight loss of control and subequent uncontrolled descent into trees.NTSB MIA03CA037Accident · No injuriesData collectionFinal reportPiper PA-30 · Tallahassee, FLthe pilot's improper start procedure which resulted in an unintentional engine start, and unoccupied aircraft collision with hangar structure.NTSB ATL03LA031Accident · No injuriesLimited investigationFinal reportBeech F-35 · Hollywood, FLThe pilot exceeded the design limits of the airplane which resulted in an in flight structural failure.NTSB MIA03CA030Accident · No injuriesData collectionFinal reportCessna A150M · Crystal River, FLThe student pilot's improper application of brakes during the landing rollout, which resulted in a loss of directional control and the airplane running off of the runway, impacting a runway light structure, and nosing over.NTSB MIA03LA033Accident · No injuriesLimited investigationFinal reportBeech 200 · Jacksonville, FLFailure of the main landing gear locking mechanism for undetermined reasons, which resulted in the main landing gear collapsing, and damage to the airplane during landing.NTSB MIA03CA026Accident · No injuriesData collectionFinal reportPiper PA38 · Pensacola, FLThe student pilot's attempt to turn off the runway at an excessive taxi speed resulting in a loss of directional control and collision with a taxiway sign.NTSB MIA03FA025Accident · 2 fatalField investigationFinal reportRaytheon 58 · Fort Myers, FLthe pilot's spatial disorientation during instrument meteorological conditions, which resulted in his failure to maintain aircraft control. Contributing factors included the pilot's distraction to the low fuel status and the low cloud conditions.NTSB MIA03FA024Accident · 2 fatalField investigationFinal reportAaa Aircraft Leasing 192 · Miami, FLThe inflight fire of undetermined origin, which resulted in pilot incapacitation, loss of aircraft control and an inflight collision with a building.NTSB MIA03CA063Accident · No injuriesData collectionFinal reportConsolidated Aeronautics LA-4-200 · Blountstown, FLThe failure of the certified flight instructor (CFI) to maintain clearance between the wingtip and a water marker bouy resulting in contact with the wingtip.NTSB MIA03LA022Accident · No injuriesLimited investigationFinal reportLet L-23 · Groveland, FLthe pilot's failure to extend the dive brakes during approach and his excessive airspeed and improper landing flare which resulted in the airplane nosing down and impacting with the runway.NTSB ATL03LA021Accident · No injuriesLimited investigationFinal reportCessna T210M · Lakeland, FLThe collapse of the main landing gear for undetermined reasons.NTSB ATL03LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain airspeed during an approach to land that resulted in an inflight collision with the runway. A factor was the crosswind condition.NTSB MIA03LA015Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Orlando, FLThe poor in-flight planning by the pilot-in-command for his failing to request a runway more aligned with the wind and his failure to maintain directional control after landing resulting in collapse of the nose landing gear and the airplane nosing over.NTSB ATL03LA014Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Orlando, FLThe airplane's inflight encounter with turbulence that resulted in injuries to the number two flight attendant.NTSB ATL03LA012Accident · 1 fatalLimited investigationFinal reportBeech F33A · Fernandina Bch, FLWater contamination in the fuel system which resulted in the loss of engine power and the subsequent collision with trees.NTSB MIA03FA007Accident · 2 fatalField investigationFinal reportCessna 172M · Coral Springs, FLThe failure of the dual students and flight instructors on both N9840V and N6101F to see and avoid each other, which resulted in a midair collision.NTSB MIA03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Vero Beach, FLThe collapse of the nose landing gear for undetermined reasons resulting in the loss of directional control and the subsequent collapse of the main landing gears.NTSB MIA03LA008Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Sebring, FLThe student pilot's premature rotation and failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall, an uncontrolled descent, and an impact with the ground.NTSB MIA03FA005Accident · 1 fatalField investigationFinal reportCessna 310 · Merritt Island, FLThe pilot's decision to take off with a known equipment deficiency, and his failure to maintain airspeed (VMC) following a loss of engine power to one of the airplane's two engines for undetermined reasons, which resulted in descent and an impact with terrain.NTSB ATL03LA005Accident · No injuriesLimited investigationFinal reportCessna 172 · Opa Locka, FLThe pilot' inadequate evaluation of weather information, and the selection of the wrong runway that resulted in an attempted takeoff with a tailwind and the subsequent loss of control during takeoff.NTSB ATL03LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Pompano Beach, FLThe loss of engine power for undetermined reasons.NTSB MIA03LA003Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Immokalee, FLA loss of engine power on takeoff for undetermined reasons.NTSB MIA03LA001Accident · 1 fatalLimited investigationFinal reportBowers Velocity SR6E · Valkaria, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.NTSB MIA02LA172Accident · No injuriesLimited investigationFinal reportRonald Levee Kitfox IV · De Land, FLThe failure of the pilot to maintain directional control of the airplane during the flare/touchdown resulting in substantial damage. A factor in the accident was the poor in-flight planning decision by the pilot for his continuing the approach in close…NTSB MIA02FA173Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Yeehaw Junction, FLthe pilot's continued flight into known severe weather, resulting in an in-flight separation of the right wing, vertical stabilizer and the stabilator. Factors in this accident were heavy thunderstorm, and failure of the FAA controllers to provide the pilot…NTSB ATL02FA175Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Milton, FLA sheared mixture cable which resulted in a loss of engine power.NTSB MIA02FA170Accident · 1 fatalField investigationFinal reportBeagle B-206 Series 2 · McAlpin, FLthe pilot's failure to maintain an adequate airspeed to sustain controlled flight, which resulted in an inadvertent stall during a turn from base to final. A contributing factor was the pilot's use of judgment and performance impairing drugs.NTSB ATL02LA172Accident · No injuriesLimited investigationFinal reportCessna 172P · Lutz, FLThe pilot's failure to maintain visual lookout and clearance during taxi, which resulted in an on-ground collision with a building.NTSB MIA02IA167Incident · No injuriesIncident investigationFinal reportBoeing 737-823 · Miami, FLThe failure of the tug driver to maintain wingtip clearance with a parked airplane, and the inability of the tug driver to communicate with the brake rider during a tow operation following failure of the headset cord. Contributing factors in the incident were…NTSB ATL02LA166Accident · No injuriesLimited investigationFinal reportCessna 172S · Immokalee, FLThe student pilot's improper flare at touchdown resulted in a hard landing while performing an off-airport precautionary landing after the inadvertent activation of the autopilot.NTSB MIA02LA165Accident · Serious injuriesLimited investigationFinal reportCessna T337D · Fort Pierce, FLThe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.NTSB MIA02LA164Accident · Minor injuriesLimited investigationFinal reportClarence F. Callahan Challenger II · Plymouth, FLThe pilot's failure to maintain the proper alignment which resulted in the airplane impacting trees on the south side of the approach end of the landing runway.NTSB MIA02LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe student pilot's failure to maintain control of the airplane during the takeoff roll/run which resulted in the airplane departing the runway and into a ditch where it nosed over incurring substantial damage.NTSB ATL02FA162Accident · 2 fatalField investigationFinal reportAmerican General AA-5B · Zephyrhills, FLThe pilots continued visual flight into instrument conditions (fog), and subsequent collision with a tree and a residence.NTSB MIA02FA161Accident · Serious injuriesField investigationFinal reportSikorsky S76A+ · Miami, FLThe flight crew's diverted attention, inadequate visual lookout, and failure to ensure adequate main rotor clearance. Factors in the accident were the continued operation, with known obstructions in the area, and the failure of the FAA to initially certify…NTSB ATL02LA164Accident · No injuriesLimited investigationFinal reportBarker Experimental · Panacea, FLThe builders inadequate weld on the nose gear u-shaped bracket, that resulted in the nose wheel strut failure, and subsequent nose over during an attempted landing.NTSB ATL02IA165Incident · No injuriesIncident investigationFinal reportBeech 1900D · Tampa, FLThe improper service of the left main landing gear socket, resulting in fatigue failure of the left main landing gear socket assembly at the lower scissor attachment point.NTSB MIA02IA160Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB BK-117 A4 · Bradenton, FLImproper maintenance/installation of the No. 2 engine power turbine (PT) wheel assembly by company maintenance personnel, which resulted in deflection at the engine case axial midpoint and misalignment between the inlet housing and the rear bearing support…NTSB MIA02LA153Accident · 2 fatalLimited investigationFinal reportReviere Vans RV6A · Tampa, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, while maneuvering, and subsequent impact with a concrete wall. A factor in this accident was the impairment of the pilot in command due to the use of prescription…NTSB MIA02LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · La Belle, FLThe student pilot's improper in-flight planning and failure to use carburetor heat while conditions existed that were conductive to carburetor icing.NTSB ATL02IA155Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Tampa, FLThe failure of the left main landing gear retract cylinder support frame due to fatigue.NTSB MIA02LA146Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Fort Lauderdale, FLthe pilot's abrupt pull up and his failure to maintain airspeed during a go-around, which resulted in an inadvertent stall/spin and impact with the terrain during the resultant uncontrolled descent.NTSB MIA02LA156Accident · No injuriesLimited investigationFinal reportAviat A1 · Merritt Island, FLThe pilot's failure to maintain directional control during the landing rollout while landing in a crosswind which resulted in the airplane inadvertently veering off the runway and incurring damage when the pilot forced it into a ground loop to avoid entry…NTSB ATL02LA152Accident · No injuriesLimited investigationFinal reportCessna 150 · Lakeland, FLThe pilot's failure to maintain a visual lookout while taxiing to parking resulting in an on-ground collision with a pole. A related factor was the diverted attention to the lineman.NTSB ATL02LA149Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Ft. Lauderdale, FLPilot in command failed to maintain directional control of the airplane during the landing roll that resulted in a ground loop and the overload failure of the right main landing gear.NTSB MIA02LA150Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Leesburg, FLLoss of engine power for undetermined reasons during takeoff, resulting in the airplane colliding with the ground and nosing over during the subsequent forced landing.NTSB ATL02LA147Accident · No injuriesLimited investigationFinal reportAurandt Rotor Horse · Cape Coral, FLThe loss of engine power for undetermined reasons.NTSB MIA02LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Hialeah, FLThe failure of the pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch and subsequent nose over of the airplane.NTSB DCA02MA054Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 727-232 · Tallahassee, FLThe captain's and first officer's failure to establish and maintain a proper glidepath during the night visual approach to landing. Contributing to the accident was a combination of the captain's and first officer's fatigue, the captain's and first officer's…NTSB MIA02LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Okeechobee, FLThe failure of the pilot to maintain directional control of the airplane during the takeoff roll following a short field approach and landing, resulting in the on-ground collision with a fence.