NTSB investigations, 2014, AL
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 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 61 |
| 1965 | 92 |
| 1966 | 70 |
| 1967 | 85 |
| 1968 | 68 |
| 1969 | 75 |
| 1970 | 89 |
| 1971 | 73 |
| 1972 | 76 |
| 1973 | 82 |
| 1974 | 67 |
| 1975 | 71 |
| 1976 | 77 |
| 1977 | 82 |
| 1978 | 72 |
| 1979 | 50 |
| 1980 | 50 |
| 1981 | 48 |
| 1982 | 61 |
| 1983 | 60 |
| 1984 | 41 |
| 1985 | 45 |
| 1986 | 48 |
| 1987 | 45 |
| 1988 | 36 |
| 1989 | 33 |
| 1990 | 32 |
| 1991 | 30 |
| 1992 | 40 |
| 1993 | 33 |
| 1994 | 27 |
| 1995 | 42 |
| 1996 | 32 |
| 1997 | 17 |
| 1998 | 27 |
| 1999 | 29 |
| 2000 | 17 |
| 2001 | 25 |
| 2002 | 27 |
| 2003 | 30 |
| 2004 | 27 |
| 2005 | 22 |
| 2006 | 24 |
| 2007 | 29 |
| 2008 | 28 |
| 2009 | 13 |
| 2010 | 8 |
| 2011 | 17 |
| 2012 | 25 |
| 2013 | 10 |
| 2014 | 24 |
| 2015 | 23 |
| 2016 | 12 |
| 2017 | 19 |
| 2018 | 20 |
| 2019 | 15 |
| 2020 | 17 |
| 2021 | 15 |
| 2022 | 21 |
| 2023 | 19 |
| 2024 | 11 |
| 2025 | 18 |
| 2026 | 17 |
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\") = 2014
AND c.\"eventStateOrRegion\" = 'AL' 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") = 2014 AND c."eventStateOrRegion" = 'AL' 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 ERA15CA064Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Athens, ALThe pilot's failure to maintain adequate altitude while landing in gusty wind conditions, which resulted in a collision with power lines while on final approach.NTSB ERA15CA055Accident · No injuriesData collectionFinal reportMcdonnell Douglas Helicopter MD500 · Decatur, ALAn undetermined pilot's failure to maintain clearance from an electrical transmission tower resulting in substantial damage to a main rotor blade. Postaccident investigation could not determine which of two pilots was flying the helicopter at the time the…NTSB ERA15CA035Accident · Serious injuriesData collectionFinal reportHead AX8 88B · Montevallo, ALThe pilot's decision to conduct a landing to a confined area in high wind conditions, which resulted in a hard landing and subsequent injury to a passenger.NTSB ERA15CA018Accident · No injuriesData collectionFinal reportBell 206B · Prattville, ALThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14CA431Accident · No injuriesData collectionFinal reportPiper PA-18A-150 · Gunthersville, ALThe pilot's failure to retract the landing gear wheels prior to a water landing, resulting in a nose over upon touchdown.NTSB ERA14FA396Accident · 2 fatalField investigationFinal reportMcdonnell Douglas Helicopter 369E · Northport, ALAn inadvertent collision with a utility wire for reasons that could not be determined from recorded data and examination of the helicopter and accident site.NTSB ERA14LA391Accident · Serious injuriesLimited investigationFinal reportLet L 23 Super Blanik · Sylacauga, ALThe student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. Contributing to the accident was the student pilot's failure to properly assess her physical condition prior to conducting the flight.NTSB ERA14CA376Accident · Minor injuriesData collectionFinal reportPiper PA 34-220T · Gulf Shores, ALThe pilot's improper flare, which resulted in a bounced landing and subsequent loss of aircraft control.NTSB ERA14LA369Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Helena, ALA total loss of engine power for reasons that could not be determined due to postcrash fire damage.NTSB ERA14FA350Accident · 2 fatalField investigationFinal reportWilderoder Great Lakes 2TIA · Lillian, ALA loss of engine power due to an inoperative magneto and possible carburetor ice, which resulted in a forced landing into unsuitable terrain. Contributing to the accident was an inadequate magneto overhaul by unknown personnel and the modification to the…NTSB ERA14TA326Accident · Serious injuriesFinal reportCessna 336 · Mobile, ALThe pilot’s inadequate preflight fuel planning during which he did not ensure that there was adequate fuel in the main tanks for the flight, which resulted in a loss of engine power.NTSB ERA14LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Monroeville, ALA loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.NTSB ERA14LA324Accident · No injuriesLimited investigationFinal reportBeech 95 55 · Gulf Shores, ALThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA14FA300Accident · 3 fatalField investigationFinal reportIsrael Aircraft Industries 1124A · Huntsville, ALThe flight crew's inability to maintain airplane control during initial climb following deployment of the right thrust reverser for reasons that could not be determined because postaccident examination of the airframe and engine thrust reverser system did not…NTSB ERA14LA257Accident · Serious injuriesLimited investigationFinal reportP&M Quikr · Gulf Shores, ALThe pilot’s failure to maintain aircraft control during engine startup, which resulted in a collision with a parked airplane. Contributing to the accident was the pilot’s failure to follow engine startup procedures and a sudden surge of engine power for…NTSB ERA14CA206Accident · No injuriesData collectionFinal reportCessna 172I · Huntsville, ALThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA14LA179Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Clayton, ALMaintenance personnel’s failure to properly torque the engine case through bolts, which resulted in the fatigue fracture of the crankshaft and subsequent total loss of engine power.NTSB ERA14CA177Accident · No injuriesData collectionFinal reportAviat A 1B · Dadeville, ALThe pilot's failure to obtain the proper touchdown point while landing on a lake with a tailwind.NTSB ERA14LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Fairhope, ALThe pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.NTSB ERA14CA134Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Gulf Shores, ALThe student pilot's incorrect rudder input, which resulted in a ground loop and collision with a runway sign.NTSB ERA14LA149Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Alabaster, ALThe pilot’s delay in aborting the takeoff following the loss of directional control early in the takeoff roll due to a deflated left main landing gear tire.NTSB ERA14FA120Accident · 2 fatalField investigationFinal reportCessna 210L · Clay, ALThe pilot's failure to maintain control of the airplane while being vectored to intercept the localizer during night instrument meteorological conditions (IMC). Contributing to the accident was the operator's inadequate dispatch procedures, which did not…NTSB ERA14LA099Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Pell City, ALThe pilot’s use of an improper clutch engagement procedure, which resulted in clutch glazing, slippage, and, ultimately, the in-flight disengagement of the clutch and a loss of rotor rpm. Contributing to the accident were the installation of a light-weight…NTSB ERA14LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Alabaster, ALThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.