NTSB investigations, 2008, 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\") = 2008
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") = 2008 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 ERA09CA127Accident · No injuriesData collectionFinal reportCessna 180K · Port Orange, FLThe pilot's inadequate compensation for the wind conditions during landing. Contributing to the accident were the gusting wind conditions and the pilot's lack of experience in the make and model airplane.NTSB ERA09CA120Accident · No injuriesData collectionFinal reportSchweizer 269C · Panama City, FLThe pilot's encounter with a loss of tail rotor effectiveness during an out-of-ground-effect hover.NTSB ERA09CA129Accident · No injuriesData collectionFinal reportBuckeye Dream Machine · Grant, FLThe pilot's failure to maintain clearance from the wire.NTSB ERA09LA109Accident · No injuriesLimited investigationFinal reportMichel Paul John Murphy Rebel · Live Oak, FLA partial loss of engine power for undetermined reasons.NTSB ERA09LA108Accident · Serious injuriesLimited investigationFinal reportBeech E18S · Fort Myers, FLThe failure of the right propeller to go to the feathered position for undetermined reasons following a total loss of right engine power during initial climb due to fuel starvation as a result of the pilot's improper fuel planning.NTSB ERA09CA101Accident · Minor injuriesData collectionFinal reportSteven G Goonen Searey · Polkland, FLA loss of control during the initial climb for undetermined reasons.NTSB ERA09FA092Accident · 1 fatalField investigationFinal reportCessna 172S · Goodland, FLThe pilot's failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was the night light conditions.NTSB ERA09CA121Accident · No injuriesData collectionFinal reportLake LA-4-200 · Apopka, FLThe pilot's improper flare.NTSB ERA09CA090Accident · No injuriesData collectionFinal reportBell OH-58C · Osceola County, FLThe pilot's misjudgment of altitude during low-altitude spraying operations, which resulted in an in-flight collision with water.NTSB ERA09FA087Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Sebring, FLThe pilot's exceedance of the design stress limitations of the airplane.NTSB ERA09CA091Accident · No injuriesData collectionFinal reportKimball Enterprises Pitts Model-12 · Weirdales, FLThe pilot's inadequate compensation for the wind conditions. Contributing to the accident was the crosswind.NTSB ERA09CA089Accident · Serious injuriesData collectionFinal reportMooney M20G · Sebastian, FLThe loss of engine power for undetermined reasons.NTSB ERA09IA115Incident · No injuriesIncident investigationFinal reportCessna 402C · Fort Lauderdale, FLThe airplane manufacturer's inadequate inspection procedure resulting in undetected fatigue cracking of the main landing gear barrel of the upper barrel and trunnion assembly.NTSB ERA09CA095Accident · No injuriesData collectionFinal reportBeech C23 · Panacea, FLA loss of engine power due to a failure of the mixture control cable housing attachment.NTSB ERA09LA081Accident · No injuriesLimited investigationFinal reportMerrell Stephen F1 Rocket · Sebastian, FLA loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.NTSB ERA09CA097Accident · Serious injuriesData collectionFinal reportMiller Long EZ/XP · Wauchula, FLA total loss of engine power for undetermined reasons.NTSB ERA09CA082Accident · Minor injuriesData collectionFinal reportCessna 208 · Homestead, FLThe inadvertent deployment of the reserve parachute, resulting in the skydiver being prematurely pulled from the airplane and striking the horizontal stabilizer.NTSB ERA09FA080Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · Ft. Lauderdale, FLThe failure of both pilots to see and avoid the other aircraft.NTSB ERA09LA079Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Punta Gorda, FLThe pilot's failure to maintain control of the airplane during a rejected takeoff. Contributing to the accident was a gust of wind.NTSB ERA09FA074Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Homosassa Spgs., FLThe pilot’s continued flight into known adverse weather conditions.NTSB ERA09CA073Accident · Minor injuriesData collectionFinal reportExtra Flugzeugbau EA 300/L · Tampa, FLThe pilot's inadequate visual lookout, which resulted in a collision with an object.NTSB ERA09LA067Accident · No injuriesLimited investigationFinal reportBeech V35 · Winter Haven, FLBoth pilots’ failure to see and avoid the other airplane. Contributing to the accident was the Beech pilot’s failure to monitor or utilize the common traffic advisory frequency.NTSB ERA09LA062Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Green Cove Springs, FLThe fusing of an electrical cable from the No. 2 (standby) alternator with the throttle cable resulting in the flight crew’s inability to move the throttle control. Contributing to the accident was the failure of maintenance personnel to detect inadequate…NTSB ERA09CA061Accident · No injuriesData collectionFinal reportCessna 172 · Ft. Lauderdale, FLThe student pilot's improper flare during landing. Contributing to the accident was the student pilot's lack of experience.NTSB ERA09LA055Accident · Serious injuriesLimited investigationFinal reportAmerican General Acft AG5B · Naples, FLA partial loss of engine power during takeoff for undetermined reasons.NTSB ERA09FA053Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Tallahassee, FLThe pilot's failure to maintain adequate airspeed on final approach, which resulted in a low-altitude aerodynamic stall and spin. Contributing to the accident was the pilot's failure to fly the published instrument approach and his subsequent failure to…NTSB ERA09LA047Accident · Minor injuriesLimited investigationFinal reportBell 206B · Boynton Beach, FLA loss of engine power due to an undertorqued air line fitting to the fuel control.NTSB ERA09FA039Accident · 3 fatalField investigationFinal reportPartenavia P.68C · Gainesville, FLThe pilot's failure to maintain the proper glidepath during an instrument-landing-system (ILS) approach. Contributing to the accident were the pilot's decision to initiate the ILS approach with weather below the published minimums, and the pilot's…NTSB ERA09CA104Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Tallahasee, FLThe pilot's failure to maintain aircraft control after touchdown. Contributing to the accident were the gusting winds.NTSB ERA09CA024Accident · Minor injuriesData collectionFinal reportLange Flugzeugbau E1 Antares · Winter Haven, FLThe failure of the pilot of the other airplane to announce his intentions prior to takeoff, resulting in a runway incursion. Contributing to the accident was the limited forward visibility due to the runway slope.NTSB ERA09LA015Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kissimmee, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during initial climb due to fuel contamination. Contributing to the accident was a fuel tank cap that did not seal properly.NTSB ERA09CA011Accident · No injuriesData collectionFinal reportVelocity SE-FG · Chipley, FLThe pilot's inadequate in-flight fuel planning, resulting in loss of engine power due to fuel exhaustion.NTSB ERA09IA009Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Lakeland, FLA failure of the flap actuator rod end due to low stress, high cycle fatigue, and subsequent overstress failure.NTSB ERA09LA001Accident · Serious injuriesLimited investigationFinal reportBezinque Alisport-Silent · Vero Beach, FLThe failure of the electric fuel boost pump which resulted in a loss of engine power due to fuel starvation.NTSB MIA08CA202Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor's delayed remedial action during a simulated autorotation.NTSB MIA08CA201Accident · Serious injuriesData collectionFinal reportCox Clyde H Fshr Aero Vsns Clbty · Tampa, FLThe pilot’s failure to maintain control of the airplane during takeoff due to inadequate maintenance.NTSB MIA08LA195Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Clearwater, FLThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the pilot's improper use of a supplemental cockpit lighting during approach.NTSB NYC08CA305Accident · No injuriesData collectionFinal reportRobinson R44 II · Marathon, FLThe pilot's failure to control the helicopter while maneuvering, resulting in loss of tail rotor effectiveness.NTSB NYC08CA297Accident · No injuriesData collectionFinal reportErcoupe 415-C · Sebring, FLA bird strike which substantially damaged the propeller and required the engine to be secured. Contributing to the accident was the damaged propeller.NTSB MIA08CA171Accident · Minor injuriesData collectionFinal reportCessna 152 · Ormond Beach, FLBoth pilots' inadequate preflight inspection of the fuel.NTSB MIA08LA164Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Arcaida, FLThe pilot's failure to maintain a proper climb rate after takeoff.NTSB NYC08CA276Accident · No injuriesData collectionFinal reportCessna A188B · Gardner, FLThe pilot's misjudged distance/altitude during takeoff.NTSB MIA08LA162Accident · Serious injuriesLimited investigationFinal reportNorth Wing Apache CLA · Boynton Beach, FLThe failure of the pilot to maintain control of the aircraft.NTSB NYC08LA264Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Palakta, FLThe partial loss of engine power for undetermined reasons.NTSB MIA08CA153Accident · No injuriesData collectionFinal reportBeech C23 · Winter Haven, FLThe student pilot's improper recovery from a bounced landing.NTSB MIA08LA152Accident · 2 fatalLimited investigationFinal reportMorris George Velocity 173RG · St. Augustine, FLA loss of control in flight due to undetermined reasons.NTSB NYC08LA255Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Ocean Ridge, FLA partial loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to add only a limited amount of fuel prior to the flight, and the fuel selector valve placards' inaccurate depiction of the airplane fuel tank…NTSB NYC08CA252Accident · Minor injuriesData collectionFinal reportBuschmann Robert E Helicycle · Stuart, FLThe pilot's improper decision to take off with a known discrepancy. Contributing to the accident was spilled fuel on the drive belts.NTSB SEA08LA162Accident · Serious injuriesLimited investigationFinal reportSport Flight Talon XP · Inverness, FLThe lower rod bearing failed due to corrosion.NTSB MIA08FA144Accident · 3 fatalField investigationFinal reportBeech A-36 · Tampa, FLThe pilot's improper decision to take off with a tailwind and his failure to maintain runway alignment during initial takeoff climb.