NTSB investigations, 2007, FL
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 2007
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") = 2007 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 MIA08LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Sarasota, FLA loss of engine power due to contamination in the fuel filter.NTSB NYC08IA069Incident · No injuriesIncident investigationFinal reportPiper PA-32R · Destin, FLAn in-flight fire due to a fractured fuel injector line as a result of an unauthorized repair to the line.NTSB MIA08CA040Accident · No injuriesData collectionFinal reportAgusta A109 · ST. Augustine, FLThe pilot's failure to maintain a visual lookout while taxiing.NTSB MIA08CA031Accident · No injuriesData collectionFinal reportCessna 310P · Dunnellon, FLThe improper installation of the right main landing gear scissors by company maintenance personnel, resulting in the collapse of the right main landing gear during takeoff.NTSB NYC08CA063Accident · No injuriesData collectionFinal reportMaule M-7-235 · Key Largo, FLThe pilot's loss of control during the landing. Contributing was the wind gust.NTSB MIA08LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA32-260 · Marathon, FLA loss of engine power for undetermined reasons.NTSB NYC08LA060Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Plant City, FLA loss of rotor drive due to excessive slack and breakage of the drive belts. Contributing to the accident was the pilot departing in the helicopter after the rotor engagement time during engine start exceeded the time outlined in the pilot's operating…NTSB NYC08FA054Accident · 2 fatalField investigationFinal reportPiper PA-30 · Parkland, FLBoth pilots' failure to see and avoid the other airplane. Contributing to the accident were the erroneous readouts from the Cessna's altitude encoder.NTSB NYC08CA055Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Tallahassee, FLThe pilot's misjudged clearance over obstacles during final approach.NTSB MIA08CA025Accident · No injuriesData collectionFinal reportMessing Roy Sonex · New Smyrna Beac, FLThe pilot's failure to maintain altitude/clearance while on final approach for landing.NTSB NYC08LA052Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Gainesville, FLThe pilot's failure to follow the published emergency procedure. Contributing to the accident was a malfunction of the clutch assembly.NTSB MIA08LA023Accident · Serious injuriesLimited investigationFinal reportPorter Glen Aventura II · Rockledge, FLThe failure of the pilot to maintain airspeed during climbout, resulting in an aerodynamic stall and uncontrolled descent. Contributing to the severity of the pilot's injuries was the inadequate manufacture of the shoulder harness restraint cables.NTSB ANC08LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power during takeoff initial climb for an undetermined reason.NTSB MIA08FA021Accident · 1 fatalField investigationFinal reportMooney M20J · Fort Myers, FLThe reason for this occurrence was not determined.NTSB MIA08CA022Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Orlando, FLThe student pilot's failure to maintain directional control during landing.NTSB NYC08LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Miami, FLA total loss of engine power during initial climb for undetermined reasons.NTSB NYC08CA047Accident · No injuriesData collectionFinal reportCessna 152 · Venice, FLThe student pilot's improper recovery from a bounced landing.NTSB MIA08CA019Accident · Minor injuriesData collectionFinal reportLake LA-4-200 · Jacksonville, FLThe pilot's failure to maintain altitude while maneuvering over water. Contributing to the accident was glassy water conditions.NTSB NYC08CA036Accident · Minor injuriesData collectionFinal reportCessna 120 · Ocala, FLThe pilot's failure to maintain proper runway alignment during landing.NTSB NYC08CA035Accident · Minor injuriesData collectionFinal reportCessna 180 · Orlando, FLThe pilot's loss of control on the water after landing, which resulted in the bow of the right float submerging , and a nose-over event.NTSB NYC08LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Hollywood, FLThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall. Contributing to the accident were an inoperative stall warning system and an erroneous airspeed indicator.NTSB NYC08CA030Accident · Minor injuriesData collectionFinal reportSea & Air Sales Searey · Sanford, FLThe pilot's failure to raise the landing gear prior to a water landing. Contributing was the pilot's diverted attention.NTSB MIA08LA014Accident · No injuriesLimited investigationFinal reportCessna C208B · Opa Locka, FLFailure of the local controller to coordinate with the ground controller and the failure of the pilots to see and avoid each other.NTSB DFW08CA024Accident · Minor injuriesData collectionFinal reportPipistrel Sinus 912 · Holt, FLThe pilot's failure to maintain clearance from terrain. A contributing factor was the gusting crosswind.NTSB MIA08FA010Accident · 1 fatalField investigationFinal reportMooney M20K · Panama City, FLThe pilot's inadequate preflight inspection which resulted in a loss of engine power during cruise flight due to fuel contamination. A factor was the pilot's impairment due to recent cocaine use.NTSB NYC08FA020Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Boynton Beach, FLA total loss of engine power due to fuel starvation as a result of the pilots' improper in-flight fuel management.NTSB NYC08LA021Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Pensacola, FLThe fatigue fracture of the tail wheel spring during takeoff.NTSB NYC08LA019Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stuart, FLA partial loss of engine power during cruise flight due to a partially blocked fuel line.NTSB MIA08LA007Accident · No injuriesLimited investigationFinal reportCatchot Angus Kitfox IV · Crescent City, FLThe loss of engine power for undetermine reasons.NTSB MIA08LA006Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Fort Myers, FLA partial loss of engine power during approach for undetermined reasons.NTSB NYC07LA241Accident · Serious injuriesLimited investigationFinal reportEverson Sidewinder · Pensacola, FLThe pilot's failure to attain the proper touchdown point while landing.NTSB MIA07LA158Accident · No injuriesLimited investigationFinal reportFly BY Sea Comp AIR 1 · Rockledge, FLLoss of engine power for undetermined reasons.NTSB MIA07LA157Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Wimauma, FLThe failure of the pilot to maintain airspeed while maneuvering for a precautionary landing following a reported loss of engine power for undetermined reasons.NTSB NYC07LA233Accident · 1 fatalLimited investigationFinal reportTemco GC-1B · New Smyrna Bch, FLA loss of engine power due to fuel starvation, which was the result of a blocked fuel tank vent.NTSB NYC07FA234Accident · Serious injuriesField investigationFinal reportBeech H-18 · Ft. Lauderdale, FLA total loss of engine power due to fuel starvation as a result of the pilot's failure to place the fuel selector for the right engine in the proper position. Contributing to the accident was the improper loading of the cargo.NTSB NYC07CA238Accident · No injuriesData collectionFinal reportCessna 190 · Yulee, FLThe pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB MIA07LA152Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Milton, FLThe failure of the pilot to attain the proper touchdown point during the precautionary landing resulting in the on-ground collision with fence posts.NTSB NYC07CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28R-200 · Tampa, FLThe pilot's misjudged altitude/distance, which resulted in a hard landing, prior to the runway.NTSB MIA07FA147Accident · 2 fatalField investigationFinal reportBell 206B · Nokomis, FLThe pilot's failure to maintain clearance from the water.NTSB MIA07CA143Accident · Minor injuriesData collectionFinal reportCessna 172N · Carrabelle, FLThe improper flare by the pilot-in-command resulting in a hard landing.NTSB MIA07LA148Accident · No injuriesLimited investigationFinal reportBell 206B3 · Lakeland, FLThe failure of company maintenance personnel to replace the tail rotor drive shafts following tail rotor blade damage in 1999, the failure of maintenance personnel to replace the tail rotor drive shafts in 2004, following their knowledge that the tail rotor…NTSB MIA07LA140Accident · No injuriesLimited investigationFinal reportCessna 208B · Cross City, FLA total loss of engine power during cruise flight due to the fracture and separation of the compressor turbine blades for undetermined reasons. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB NYC07LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Daytona Beach, FLThe inadequate visual lookout of the pilot of the unknown airplane.NTSB MIA07CA138Accident · No injuriesData collectionFinal reportAnthony J. Bencivenga Aventura II · Okeechobee, FLThe pilot's failure to maintain directional control of the airplane during landing, which resulted in the pilot being inadvertently ejected and the airplane's impact with the water during an uncontrolled descent.NTSB MIA07LA136Accident · 2 fatalLimited investigationFinal reportApollo North America Tundra · Zephyrhills, FLImproper in-flight maneuvering that resulted in the weight-shift-aircraft's design limits being exceeded, wing failure, and a loss of control.NTSB ATL07CA122Accident · No injuriesData collectionFinal reportBell 206B · West Palm Beach, FLThe flight Instructor's delayed activation of the throttle during recovery from a demonstartion of an autorotation resulting in touchdown on soft terrain and a nosedown.NTSB ATL07CA121Accident · No injuriesData collectionFinal reportBeech BE-76 · Pompano Beach, FLThe pilot's improper flare resulting in a hard landing. A factor in the accident was the certified flight instructor's inadequate supervision.NTSB ATL07LA119Accident · 1 fatalLimited investigationFinal reportCessna P206 · Center Hill, FLThe pilot committed suicide. Contributing to the event was the pilot's impairment due to alcohol.NTSB MIA07CA134Accident · Minor injuriesData collectionFinal reportCessna 152 · Labelle, FLThe student pilot's attempted precautionary landing on unsuitable terrain which resulted in damage to the airplane during the landing.NTSB NYC07FA200Accident · Serious injuriesField investigationFinal reportBeech C24R · Niceville, FLThe pilot’s inadequate preflight inspection of the fuel quantity.