Fatal NTSB investigations, 2011, GA
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
| 1964 | 6 |
|---|---|
| 1965 | 12 |
| 1966 | 11 |
| 1967 | 15 |
| 1968 | 19 |
| 1969 | 20 |
| 1970 | 24 |
| 1971 | 21 |
| 1972 | 25 |
| 1973 | 18 |
| 1974 | 17 |
| 1975 | 11 |
| 1976 | 20 |
| 1977 | 21 |
| 1978 | 17 |
| 1979 | 14 |
| 1980 | 19 |
| 1981 | 14 |
| 1982 | 19 |
| 1983 | 17 |
| 1984 | 15 |
| 1985 | 12 |
| 1986 | 12 |
| 1987 | 12 |
| 1988 | 7 |
| 1989 | 16 |
| 1990 | 12 |
| 1991 | 13 |
| 1992 | 10 |
| 1993 | 15 |
| 1994 | 7 |
| 1995 | 12 |
| 1996 | 10 |
| 1997 | 11 |
| 1998 | 7 |
| 1999 | 9 |
| 2000 | 10 |
| 2001 | 12 |
| 2002 | 13 |
| 2003 | 16 |
| 2004 | 11 |
| 2005 | 6 |
| 2006 | 11 |
| 2007 | 10 |
| 2008 | 7 |
| 2009 | 9 |
| 2010 | 8 |
| 2011 | 10 |
| 2012 | 12 |
| 2013 | 6 |
| 2014 | 9 |
| 2015 | 8 |
| 2016 | 7 |
| 2017 | 7 |
| 2018 | 9 |
| 2019 | 8 |
| 2020 | 7 |
| 2021 | 11 |
| 2022 | 8 |
| 2023 | 10 |
| 2024 | 6 |
| 2025 | 3 |
| 2026 | 5 |
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\") = 2011
AND c.\"eventStateOrRegion\" = 'GA' 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") = 2011 AND c."eventStateOrRegion" = 'GA' 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 ERA12FA084Accident · 3 fatalField investigationFinal reportCessna 177RG · Tallapoosa, GAThe failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.NTSB ERA12FA057Accident · 1 fatalField investigationFinal reportEckenrode Carl J Vans RV-6 · Taylorsville, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane and the pilot’s medical history did not reveal any anomalies that would have precluded normal operation.NTSB ERA12FA018Accident · 1 fatalField investigationFinal reportBerger Michael A Waiex · Washington, GAThe in-flight failure of the aircraft’s Y-tail attachment structure during maneuvering flight due to overload. Contributing to the accident was, the kit manufacturer’s use of 14 CFR Part 23, Appendix A design guidelines intended for a conventional tail…NTSB ERA12FA017Accident · 1 fatalField investigationFinal reportLuscombe 8A · Dixie, GAMaintenance personnel’s improper installation of the No. 2 cylinder’s connecting rod, which resulted in the disconnection of the rod and a subsequent loss of engine power.NTSB ERA11LA503Accident · 1 fatalLimited investigationFinal reportCessna 120 · Cordele, GAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11FA431Accident · 1 fatalField investigationFinal reportBeech G35 · Byron, GAThe pilot’s sustained flight at airspeeds in excess of the airplane's never exceed speed during a steep descent, which resulted in a subsequent in-flight structural failure due to overstress.NTSB ERA11FA406Accident · 1 fatalField investigationFinal reportMooney M20K · Augusta, GAThe pilot’s decision to fly the airplane after maintenance personnel advised him that the airplane should not be flown because the pilot provided an incorrect propeller for installation and the subsequent failure of the propeller attachment bolts and the…NTSB ERA11FA374Accident · 1 fatalField investigationFinal reportBinkley Richard Sonex · Calhoun, GAThe total loss of engine power for reasons that could not be determined because postimpact fire damage precluded a thorough examination of the engine.NTSB ERA11FA321Accident · 4 fatalField investigationFinal reportBeech V35 · Ellijay, GAThe pilot’s failure to maintain adequate clearance from terrain while maneuvering in a mountainous area.NTSB ERA11FA183Accident · 2 fatalField investigationFinal reportDehavilland DHC-6-100 · Hampton, GAThe pilot did not maintain airspeed while maneuvering, which resulted in an aerodynamic stall.