Fatal NTSB investigations, 2012, FL
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1963 | 1 |
|---|---|
| 1964 | 17 |
| 1965 | 19 |
| 1966 | 20 |
| 1967 | 18 |
| 1968 | 25 |
| 1969 | 20 |
| 1970 | 33 |
| 1971 | 21 |
| 1972 | 26 |
| 1973 | 31 |
| 1974 | 30 |
| 1975 | 46 |
| 1976 | 31 |
| 1977 | 33 |
| 1978 | 52 |
| 1979 | 48 |
| 1980 | 58 |
| 1981 | 39 |
| 1982 | 25 |
| 1983 | 49 |
| 1984 | 40 |
| 1985 | 31 |
| 1986 | 32 |
| 1987 | 32 |
| 1988 | 30 |
| 1989 | 34 |
| 1990 | 24 |
| 1991 | 28 |
| 1992 | 32 |
| 1993 | 25 |
| 1994 | 31 |
| 1995 | 28 |
| 1996 | 29 |
| 1997 | 28 |
| 1998 | 19 |
| 1999 | 24 |
| 2000 | 27 |
| 2001 | 15 |
| 2002 | 34 |
| 2003 | 24 |
| 2004 | 30 |
| 2005 | 31 |
| 2006 | 19 |
| 2007 | 21 |
| 2008 | 21 |
| 2009 | 24 |
| 2010 | 15 |
| 2011 | 16 |
| 2012 | 18 |
| 2013 | 16 |
| 2014 | 19 |
| 2015 | 22 |
| 2016 | 13 |
| 2017 | 18 |
| 2018 | 21 |
| 2019 | 17 |
| 2020 | 18 |
| 2021 | 17 |
| 2022 | 16 |
| 2023 | 13 |
| 2024 | 14 |
| 2025 | 7 |
| 2026 | 11 |
Where
Latest 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\") = 2012
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2012 AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 ERA13FA096Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Leesburg, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of power in both engines during cruise flight. Contributing to the accident was the pilot’s use of prescription and illicit drugs, which likely impaired…NTSB ERA13FA082Accident · 1 fatalField investigationFinal reportCessna 421C · Lake Worth, FLThe pilot's failure to follow established engine-out procedures and to maintain a proper airspeed after the total loss of engine power on one of the airplane’s two engines during the initial climb. Contributing to the accident was the total loss of engine…NTSB ERA13FA071Accident · 1 fatalField investigationFinal reportGreen Gary E Thorp T-18 · Pahokee, FLThe descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.NTSB ERA13FA070Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Apollo Beach, FLMast bumping for reasons that could not be determined because one main rotor blade was not recovered.NTSB ERA13LA020Accident · 2 fatalLimited investigationFinal reportAirborne Windsports PTY XT-912 · Winter Haven, FLThe pilot’s failure to maintain aircraft control during takeoff in crosswind conditions, which resulted in collision with terrain.NTSB ERA12FA572Accident · 1 fatalField investigationFinal reportCessna 172S · Land O'Lakes, FLThe pilot’s decision to continue the cross-country flight while fatigued, which resulted in him falling asleep during the initial descent for landing.NTSB ERA12LA537Accident · 2 fatalLimited investigationFinal reportQuad City Ultralights Challenger II · Ocala, FLThe pilot's inadvertent overstress of the airplane, which resulted in the in-flight separation of the outer section of the right wing.NTSB ERA12FA491Accident · 1 fatalField investigationFinal reportSilvaire Luscombe 8A · St. Petersburg, FLThe flight instructor’s and the pilot’s failure to maintain airspeed after a partial loss of engine power after takeoff for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane…NTSB ERA12FA387Accident · 1 fatalField investigationFinal reportPhillips William L Challenger · Plant City, FLThe non-certificated pilot’s loss of control during approach and landing. Contributing to the accident was the pilot’s lack of both total and recent flight experience.NTSB ERA12FA385Accident · 6 fatalField investigationFinal reportPilatus PC-12/47 · Lake Wales, FLThe failure of the pilot to maintain control of the airplane while climbing to cruise altitude in instrument meteorological conditions (IMC) following disconnect of the autopilot. The reason for the autopilot disconnect could not be determined during…NTSB ERA12FA345Accident · 1 fatalField investigationFinal reportShepard Jimmy D JR Pitts S1D · Port Richey, FLThe pilot's decision to conduct aerobatic flight at a low altitude, which resulted in a collision with the water.NTSB ERA12FA326Accident · 1 fatalField investigationFinal reportGutierrez Pablino Hummel Bird · DeFuniak Springs, FLThe pilot's failure to maintain airplane control due to the airplane’s exceedence of its maximum gross weight and center of gravity’s most rearward limit and his lack of familiarity with the airplane make and model, which resulted in an aerodynamic stall and…NTSB ERA12FA271Accident · 1 fatalField investigationFinal reportWejebe Jose CA8 -SF · Everglades City, FLThe pilot’s failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of airplane control.NTSB ERA12LA227Accident · 2 fatalLimited investigationFinal reportEmeraude CP-301-A · Niceville, FLThe pilots’ inadequate use of carburetor heat, which resulted in carburetor icing and a subsequent loss of engine power.NTSB ERA12FA196Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Melbourne, FLThe pilot's abrupt maneuver in response to a perceived traffic conflict, which resulted in an accelerated stall and a loss of airplane control at low altitude. Contributing to the accident was the air traffic controller's incomplete instructions, which…NTSB ERA12FA193Accident · 2 fatalField investigationFinal reportCessna 172S · Key West, FLThe non-night-qualified pilot's improper decision to depart in dark night visual meteorological conditions, which resulted in his subsequent spatial disorientation, loss of control, and impact with water.NTSB ERA12FA161Accident · 1 fatalField investigationFinal reportCessna 340A · Ocala, FLThe pilot's failure to maintain adequate airspeed and altitude on final approach, resulting in an impact with terrain short of the airport.NTSB ERA12FA151Accident · 1 fatalField investigationFinal reportCessna 150G · Quincy, FLThe non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…