NTSB investigations, 2003, GA
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 | 2 |
| 1964 | 77 |
| 1965 | 114 |
| 1966 | 113 |
| 1967 | 140 |
| 1968 | 101 |
| 1969 | 126 |
| 1970 | 117 |
| 1971 | 131 |
| 1972 | 142 |
| 1973 | 89 |
| 1974 | 117 |
| 1975 | 77 |
| 1976 | 103 |
| 1977 | 113 |
| 1978 | 120 |
| 1979 | 95 |
| 1980 | 92 |
| 1981 | 83 |
| 1982 | 82 |
| 1983 | 84 |
| 1984 | 79 |
| 1985 | 75 |
| 1986 | 56 |
| 1987 | 63 |
| 1988 | 61 |
| 1989 | 51 |
| 1990 | 60 |
| 1991 | 61 |
| 1992 | 54 |
| 1993 | 38 |
| 1994 | 49 |
| 1995 | 47 |
| 1996 | 48 |
| 1997 | 49 |
| 1998 | 54 |
| 1999 | 38 |
| 2000 | 42 |
| 2001 | 49 |
| 2002 | 49 |
| 2003 | 51 |
| 2004 | 46 |
| 2005 | 32 |
| 2006 | 44 |
| 2007 | 54 |
| 2008 | 49 |
| 2009 | 47 |
| 2010 | 48 |
| 2011 | 44 |
| 2012 | 39 |
| 2013 | 30 |
| 2014 | 34 |
| 2015 | 33 |
| 2016 | 42 |
| 2017 | 35 |
| 2018 | 35 |
| 2019 | 39 |
| 2020 | 36 |
| 2021 | 37 |
| 2022 | 42 |
| 2023 | 37 |
| 2024 | 44 |
| 2025 | 24 |
| 2026 | 27 |
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\") = 2003
AND c.\"eventStateOrRegion\" = 'GA' 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") = 2003 AND c."eventStateOrRegion" = 'GA' 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 ATL04LA062Accident · No injuriesLimited investigationFinal reportCessna 172R · Atlanta, GAThe pilot's improper flare resulting in a hard landing. A factor is lack of total experience.NTSB ATL04LA050Accident · Minor injuriesLimited investigationFinal reportBaker KR-2 · St. Marys, GAThe pilot's failure to maintain airspeed during climb out which resulted in a stall and inflight collision with trees.NTSB ATL04FA045Accident · 2 fatalField investigationFinal reportBeech B200 · Morlan, GAThe pilot's inadequate in-flight planning/decision when he continued the flight below the decision height and collided with trees. A related factor was the low ceiling.NTSB ATL04IA048Incident · No injuriesIncident investigationFinal reportCessna 560XL · Savannah, GAThe malfunction of the nose wheel gear for undetermined reasons.NTSB ATL04FA038Accident · 1 fatalField investigationFinal reportBeech 55 · Griffin, GAA loss of engine power due to the pilot's failure to follow the engine failure after liftoff emergency procedure to feather the left engine propeller resulting in a loss of control during climbout, and the subsequent collision with a commercial building. A…NTSB ATL04LA036Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Suches, GAThe pilot's failure to maintain airspeed during a go-round that resulted in an inadvertent stall and the subsequent collision with trees.NTSB ATL04LA019Accident · No injuriesLimited investigationFinal reportSpegele Mustang II · Calhoun, GAThe pilot's improper flare which resulted in a hard landing and subsequent landing gear collapse.NTSB ATL04LA017Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Carrollton, GAA loss of engine power for undetermined reasons.NTSB ATL04LA009Accident · No injuriesLimited investigationFinal reportCessna 150G · Jeykll Island, GAThe pilot's preflight planning and the mismanagement of the fuel supply that resulted in fuel exhaustion.NTSB ATL04IA002Incident · No injuriesIncident investigationFinal reportNorth American T6G · Clayton, GAThe pilot's inadequate compensation for wind conditions that resulted in his failure to maintain directional control during landing roll. A factor was gusting tailwinds.NTSB ATL04LA001Accident · 1 fatalLimited investigationFinal reportJohnson Walter A Hornet · Saint Marys, GAThe loss of engine power due to improper maintenance and the pilot's failure to maintian airspeed during the attempted forced landing that resulted in a stall.NTSB ATL03LA150Accident · Minor injuriesLimited investigationFinal reportSherman Holie Freebird · Newnan, GAThe failure of the aileron control rod, and subsequent loss of control in-flight.NTSB ATL03LA145Accident · No injuriesLimited investigationFinal reportCessna 180 · Pavo, GAThe pilot's failure to maintain airspeed, resulting in an inadvertent stall.NTSB ATL03FA142Accident · 1 fatalField investigationFinal reportCessna 172M · Perry, GAThe pilot inadequate preflight inspection of the airplane, and also causal was his failure to detect water-contaminated fuel which resulted in a loss of engine power and his failure to maintain adequate airspeed which resulted in an stall.NTSB ATL03LA141Accident · No injuriesLimited investigationFinal reportBellanca CH-300 · Peachtree City, GAThe pilots failure to maintain directional control during landing roll that resulted in a ground loop and subsequent collapse of the main landing gear.NTSB ATL03FA140Accident · 1 fatalField investigationFinal reportBeechcraft A36 · Stone Mountain, GAThe pilot's intentional flight into the ground for the purpose of suicide while impaired by alcohol.NTSB ATL03FA137Accident · 1 fatalField investigationFinal reportMooney M-20C · Monticello, GAThe pilot's continued VFR flight into IMC conditions, and his failure to maintain obstacle clearance and collision with trees. A factor was low ceiling.NTSB ATL03FA136Accident · 1 fatalField investigationFinal reportBeech BE-55 · Winder, GAThe pilot's inadequate preflight preparation in which he failed to secure the cabin door which diverted his attention and resulted in the failure to maintain directional control.NTSB ATL03LA132Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Camilla, GAThe malfunction (locking) of the left brake piston during the landing roll, which resulted in a loss of control and subsequent nose over.NTSB ATL03FA128Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Rome, GAA loss of engine power due to fuel system contamination (water). Also causal was the pilot's loss of control for undetermined reasons.NTSB ATL03LA124Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Atlanta, GAThe failure of the ground crew to follow powerback procedures and directives.NTSB ATL03LA122Accident · No injuriesLimited investigationFinal reportAir Tractor AT401B · Girard, GAA loss of engine power due to the failure of the internal supercharger blower seals.NTSB ATL03LA120Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Canon, GAThe loss of engine power due to water and corrosion in the fuel system. A factor was the collision with a ditch.NTSB ATL03LA106Accident · No injuriesLimited investigationFinal reportPolstra Zodiac CH 601 HDS · Thomson, GAThe total loss of engine power due to the fatigue fracture of the No. 3 cylinder intake valve, which resulted in a forced landing to rough terrain and subsequent collision with small trees and a tree stump.NTSB ATL03FA107Accident · 2 fatalField investigationFinal reportPiper PA-31P · Augusta, GAThe pilot's failure to maintain airspeed while maneuvering on initial take off climb resulting in an inadvertent stall, loss of control, and subsequent in-flight collision with trees and a swamp. A factor in the accident was a reported loss of engine power…NTSB ATL03CA105Accident · Minor injuriesData collectionFinal reportAyers RV-6A · St. Simons Isld, GAThe pilot's inadequate preflight inspection that resulted in his failure to remove the seatbelt (flight control gust lock) from the right side flight control stick.NTSB ATL03LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hampton, GAThe certified flight instructor's failure to maintain clearance from the runway during a low pass. A factor was gusty wind conditions.NTSB ATL03LA097Accident · No injuriesLimited investigationFinal reportCessna 172P · Newnan, GAThe pilot's failure to maintain directional control during the landing roll that resulted in the collapse of the right main landing gear.NTSB ATL03LA095Accident · No injuriesLimited investigationFinal reportAerospatiale AS355F2 · Bainbridge, GAThe pilot's improper flare during an attempted landing.NTSB ATL03FA089Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Calhoun, GAThe pilot's failure to obtain a preflight weather briefing, which would have indicated that MVFR to IFR conditions prevailed over the route with embedded thunderstorms and rain, and his decision to continue VFR flight into instrument meteorological…NTSB ATL03LA091Accident · Serious injuriesLimited investigationFinal reportHomebuilt Unkown · Summerville, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall, and subsequent collision with the ground.NTSB ATL03LA088Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Milledgeville, GAThe pilot's failure to maintain airspeed during climbout which resulted in a low altitude stall and subsequent in-flight collision with the terrain.NTSB ATL03LA084Accident · No injuriesLimited investigationFinal reportBeech A23 · Brunswick, GAMaintenance personnel's failure to secure the fitting on a fuel line, which resulted in a loss of engine power.NTSB CHI03LA113Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Lithonia, GAThe flight into adverse weather encountered by the flight crew, and the flight attendant's restraint not available when she was informed to take her seat. The convective associated turbulence was a contributing factor.NTSB ATL03LA079Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75L3 · Gainesville, GAThe pilot's failure to maintain directional control during the landing roll resulting in an inadvertent ground loop.NTSB ATL03FA077Accident · 1 fatalField investigationFinal reportCessna 414 · Waleska, GAThe pilot's failure to maintain clearance from terrain.NTSB ATL03FA068Accident · 2 fatalField investigationFinal reportRockwell 690B · Homerville, GAAn in-flight encounter with unforecasted severe turbulence in cruise flight resulting in the design limits of the airplane being exceeded due to an overload failure of the airframe, and collision with a swampy area.NTSB ATL03LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Savannah, GAThe pilot misjudged the landing distance, landed with excessive airspeed, did not attempt a go-around resulting in the airplane going off the overrun, and colliding with trees.NTSB ATL03FA064Accident · 2 fatalField investigationFinal reportCessna 172S · Monroe, GAThe pilot’s exceedence of the design limits of the airplane, which resulted in the overload failure of the horizontal stabilizers, followed by the overload separation of the right wing and subsequent loss of control.NTSB ATL03LA081Accident · No injuriesLimited investigationFinal reportBeech A100 · Carrollton, GAThe pilot misjudged the approach and touchdown airspeeds that resulted in the overrun of the runway during a landing. Factors were the wet runway and hydroplaning conditions.NTSB ATL03LA063Accident · No injuriesLimited investigationFinal reportCessna A152 · Peachtree City, GAThe pilot's failure to maintain directional control during landing roll that resulted in a nose over after the airplane departed the runway surface. A factor is muddy terrain.NTSB ATL03FA062Accident · 1 fatalField investigationFinal reportCessna 320D · Perry, GAThe pilot continued visual flight into instrument meteorological conditions, and his failure to maintain altitude/terrain clearance.NTSB ATL03FA055Accident · 1 fatalField investigationFinal reportBeech A-36 · Milledgeville, GAThe pilot's improper IFR procedure by which he failed to maintain the minimum descent altitude, and his failure to maintain obstacle clearance. A factor was low the ceiling.NTSB ATL03LA051Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Atlanta, GAThe flight's encounter with severe turbulence that resulted in serious injury to a flight attendant.NTSB ATL03FA049Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Sylvania, GAThe pilot's decision to conduct VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Related factors were the guy wire and the fog.NTSB ATL03LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Rome, GAThe maintenance personnel failure to secure the throttle linkage during the installation of the carburetor that resulted in the loss of engine power.NTSB ATL03LA047Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Valdosta, GAThe pilot's failure to maintain adequate airspeed during a go-around resulting in an inadvertent stall and collision with trees.NTSB ATL03LA042Accident · Minor injuriesLimited investigationFinal reportCessna 182 · LaFayette, GAIn flight loss of engine power for undetermined reasons.NTSB ATL03LA036Accident · No injuriesLimited investigationFinal reportBeech 65 · Fitzgerald, GAThe pilot's mismanagement of the fuel supply that resulted in fuel starvation and the loss of engine power in both engines. A factor was a tree.NTSB MIA03LA044Accident · No injuriesLimited investigationFinal reportCessna 150K · Jessup, GAThe loss of engine power for undetermined reasons. A contributing factor was unsuitable terrain.