NTSB investigations, GA
91 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 6 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 5 |
| 1990 | 1 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 1 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 7 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 5 |
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 c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240)
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 c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240) 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 DEN08CA016Accident · No injuriesData collectionFinal reportRobinson R-44 II · Cleveland, GAthe student pilot's failure to maintain control of the helicopter during the landing, resulting in substantial damage to the helicopter. Contributing to the accident was the windy conditions.NTSB MIA08FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Walthourville, GAThe non-instrument rated pilot's loss of control at night in marginal night VFR operations due to spatial disorientation. A factor in the accident was the pilot's improper decision to continue the flight.NTSB ATL07GA087Accident · Serious injuriesFinal reportBell 206B · Cedartown, GAThe pilot's failure to maintain control of the helicopter while maneuvering. Contributing to the accident were strong gusty winds.NTSB ATL07FA081Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Dawsonville, GAThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, with a low cloud ceiling, over mountainous terrain.NTSB ATL07FA040Accident · 4 fatalField investigationFinal reportBeech A36 · Hinesville, GAThe pilot's failure to maintain aircraft control resulting in the in-flight breakup of the airplane due to aerodynamic overload. Contributing to the accident were airframe icing and the pilot's impairment by illegal drugs.NTSB ATL06CA112Accident · No injuriesData collectionFinal reportCessna 170B · Griffin, GAAn in-flight encounter with weather on initial take off climb resulting in a loss of directional control and collision with the ground.NTSB CHI06MA115Accident · 1 fatalMajor investigationFinal reportCessna 210A · Ludville, GAThe pilot's failure to obtain updated en route weather information, which resulted in his continued instrument flight into a widespread area of severe convective activity, and the air traffic controller's failure to provide adverse weather avoidance…NTSB ATL06LA019Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Blairsville, GAThe non-instrument rated pilot's continued flight into known adverse weather and his failure to maintain clearance in mountainous terrain, resulting in an in-flight collision with trees and the ground. A factor in the accident was the pilot's lack of an…NTSB ATL05FA142Accident · 1 fatalField investigationFinal reportBeech V35B · Ellijay, GAThe pilot's continued cruise flight under visual flight rules into known adverse weather, which resulted in his loss of control of the airplane due to spatial disorientation, and an uncontrolled descent and collision with terrain. A factor associated with the…NTSB ATL05FA010Accident · 2 fatalField investigationFinal reportBeech B-55 · Atlanta, GAThe pilot initiated flight into known adverse weather conditions (thunderstorms), which resulted in a loss of control, and subsequent in-flight collision with the ground.NTSB ATL04FA159Accident · 4 fatalField investigationFinal reportBeech 36TC · Sylvester, GAThe pilot's inadequate in-flight planning/decision resulting in flight into thunderstorms resulting in an in-flight breakup of the airframe.NTSB ATL04FA141Accident · 3 fatalField investigationFinal reportRobinson R44 · Barnesville, GAThe certified flight instructor's in-flight decision to continue VFR flight into IMC, which resulted in spatial disorientation, and the subsequent in a loss of control. A factor was fog.NTSB ATL04FA075Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Alma, GAThe pilot's inadequate in-flight decision, and his failure to maintain aircraft control which resulted in continued VFR flight into IMC and the subsequent collision with trees during approach.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 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 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 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 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 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 ATL02LA111Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Atlanta, GAIn-flight encounter with turbulence during descent, that resulted in an serious injury to the flight attendant.NTSB MIA01LA175Accident · 1 fatalLimited investigationFinal reportBucker-Jungmann Aero Z-131 · Rupert, GAThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB MIA01LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 737-301 · Toccoa, GAAn in-flight encounter with unforecasted weather (turbulence) during an enroute climb resulting in one flight attendant sustaining serious injury.NTSB ATL01FA048Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Jasper, GAThe pilot disregarded preflight weather briefing information, and continued visual flight into known instrument weather conditions and collided with trees.NTSB MIA00LA267Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Atlanta, GAan in-flight encounter with turbulence in clouds during a normal descent, resulting in serious injuries.NTSB ATL00LA092Accident · Serious injuriesLimited investigationFinal reportBombardier CRJ · Atlanta, GAThe inadvertent flight into turbulent weather conditions.NTSB ATL00FA081Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Lumber City, GAPilot's failure to follow instrument procedures and descended below approach minimums and collided with trees. A factor was low clouds.NTSB MIA00LA108Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Athens, GAThe flight attendant's failure to seat and belt herself during an inflight encounter with turbulence in clouds resulting in her losing foothold and falling against a passenger seat, sustaining a fractured ankle.NTSB DCA98MA045Accident · Serious injuriesMajor investigationFinal reportDouglas DC-9-32 · Calhoun, GAThe failure of the flight crew to maintain adequate separation from hazardous meteorological conditions. Factors contributing to the accident were: (1) the failure of AirTran Airlines to provide adequate crewmember training and guidance regarding hazardous…NTSB ATL98FA007Accident · 1 fatalField investigationFinal reportChampion 7ECA · Hamilton, GAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from mountainous terrain. Related factors were: darkness, adverse weather conditions, and the pilot's self induced pressure…NTSB ATL97LA064Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Atlanta, GAThe failure of the flight crew to alert the cabin crew to the possibility of turbulence, leading to a serious injury when severe turbulence was encountered..NTSB MIA97LA145Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Augusta, GAflight by the pilot into known adverse weather conditions, which resulted in a loss of aircraft control during the landing flare, and collision with the terrain. The adverse weather with nearby thunderstorm activity, crosswind, and gusts was a related factor.NTSB ATL97LA055Accident · Serious injuriesLimited investigationFinal reportDassault Falcon 900B · Chamblee, GAan encounter with clear air turbulence, which led to injury of the flight attendant. A factor associated with the accident was: that the flight attendant was not being restrained by a seat belt.NTSB MIA97LA051Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Atlanta, GAfailure of the pilot to initiate an immediate climb (go-around or missed approach) after encountering fog, while on final approach to land. Darkness and fog at the end of the runway were related factors.NTSB MIA97FA021Accident · 1 fatalField investigationFinal reportCessna TU206B · Jasper, GAcontinued flight by the pilot into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from rising/mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB MIA96FA218Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Lagrange, GAthe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation and a forced landing in a pasture. Contributing factors in this accident were the pilot's inadequate pre-flight and in-flight…NTSB MIA96FA134Accident · 2 fatalField investigationFinal reportBeech V35 · Powelton, GAthe pilot's continued flight into known adverse weather conditions, resulting in an in-flight separation of the left wing and ruddervator. Factors in this accident were: level three and four thunderstorms, intense to extreme precipitation, and severe…NTSB ATL95FA088Accident · 1 fatalField investigationFinal reportCessna 172N · Atlanta, GAThe pilot's impairment of judgment and performance due to a drug, VFR flight into instrument meteorological conditions, and failure to remain clear of the obstacle (towering smoke stack). Factors relating to the accident were: the adverse weather conditions.NTSB ATL95LA062Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Alma, GAThe aircraft's encounter with unforecast clear air turbulence.NTSB MIA94LA173Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-32 · Valdosta, GAAn encounter with clear air turbulence that was not forecast nor observable on radar.NTSB ATL94LA100Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Hiram, GAThe inadvertent flight from VMC conditions to IMC conditions by the pilot. A factor in the accident was the ground fog in the area.NTSB ATL93LA159Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Atlanta, GAWas the pilot's inaccurate evaluation of weather conditions which resulted in the flight entering an area of turbulence.NTSB ATL93LA154Accident · No injuriesLimited investigationFinal reportCessna 177RG · Valdosta, GAThe pilot's inadequate evaluation of inflight weather conditions which resulted in the inflight encounter with severe turbulence and subsequent overstress of the airframe.NTSB ATL93FA143Accident · 4 fatalField investigationFinal reportBeech C-90 · Augusta, GAWas the pilot's failure to adequately evaluate inflight weather conditions which resulted in a loss of control when the airplane encountered a thunderstorm.NTSB ATL93FA026Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Blairsville, GAThe pilot's decision to continue the flight into adverse weather conditions which resulted in the inflight collision with high terrain. Factors were high wind and rain.NTSB ATL92LA172Accident · No injuriesLimited investigationFinal reportAyres S-2R · Douglas, GAThe pilot's failure to check weather prior to the flight. A factor was the dark night.NTSB ATL92FA139Accident · 2 fatalField investigationFinal reportBeech 58P · Greenville, GAContinued flight by the pilot into an area of known adverse weather, and his failure to maintain control of the aircraft, which resulted in exceeding the design stress limits of the plane and overload failure of the stabilizers and wings. The adverse weather…NTSB ATL92LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe improper in-flight decision by the instructor pilot to attempt a precautionary off airport landing when no emergency existed. Factors related to the accident were the fog and low ceilings in the area at the time.NTSB MIA92LA044Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Valdosta, GAThe pilot-in-command's improper in-flight decision to continue flight into deteriorating weather conditions. Contributing to the accident was the pilot's overconfidence in his personal ability to fly in instrument conditions.NTSB DCA92MA011Accident · 9 fatalMajor investigationFinal reportBeech 400 · Rome, GAThe captain's decision to initiate visual flight into an area of known mountainous terrain and low ceilings and the failure of the flightcrew to maintain awareness of their proximity to the terrain.