NTSB investigations, GA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, newest first
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' 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' 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 ATL98LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Athens, GAThe student pilot's failure to maintain directional control during land roll out that resulted in the on ground collision.NTSB MIA98LA222Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain airspeed resulting in a stall.NTSB ATL98LA110Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Thomasville, GAThe pilot's poor in-flight decision to attempt a forced landing in a field 2 miles from an airport, leading to an on-ground collision with rough terrain. A factor was the pilot's physiological need.NTSB ATL98LA108Accident · Serious injuriesLimited investigationFinal reportDean R. Fellows Vans RV-6 · Bainbridge, GAThe pilot's failure to properly modify the crankshaft per the manufacturers service instructions for installation of a fixed pitch propeller and to apply proper torque values to the propellers mounting bolts.NTSB ATL98LA101Accident · No injuriesLimited investigationFinal reportWaco WMF · Chamblee, GAThe pilot's excessive taxi speed and excessive braking action that resulted in a nose over.NTSB MIA98TA215Accident · No injuriesFinal reportHughes TH-55A · Savannah, GAThe loss of engine power for an undetermined reason, resulting in a forced landing, and an in-flight collision with a ditch. A factor in this accident was a high density altitude.NTSB ATL98LA081Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Nicklesville, GAThe loss of engine power for undetermined reason. A factor was that weather conditions were favorable for the formation of carburetor ice.NTSB ATL98LA079Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Cordele, GAThe pilot's improper descent rate that led to a hard landing and porpoise, and his improper recovery from the ensuing bounced landing, resulting in the eventual separation of the empennage. A factor was the updraft.NTSB MIA98LA165Accident · No injuriesLimited investigationFinal reportCessna 172RG · Roberta, GAThe pilot's inadequate compliance with the emergency procedures for his failure to completely pump the main landing gear into the down and locked position. Contributing to the accident was the reported loss of electrical power for undetermined reasons.NTSB MIA98LA161Accident · No injuriesLimited investigationFinal reportRevolution MINI-500 · Villa Rica, GAThe pilot's choice of landing area during a precautionary landing adjacent to the runway. This resulted in an in-flight collision of the left skid with a rock during a cyclic flare, loss of directional control, and subsequent collision of the main rotor blade…NTSB MIA98LA158Accident · No injuriesLimited investigationFinal reportDavid McElhannon Avid MK. 4 · Elberton, GAA loss of engine power due to a failed combustion assembly, expansion seal.NTSB ATL98LA075Accident · No injuriesLimited investigationFinal reportCessna 310Q · Lafayette, GAThe pilot's improper flare during landing. Factors were the pilot's lack of familiarity with the airplane and the crosswind condition.NTSB MIA98FA155Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Fargo, GAthe left engine propeller blades struck the runway surface during takeoff, resulting in the pilot losing control of the airplane, and subsequently impacting with trees.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 MIA98LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Woodstock, GAThe pilot's failure to establish a positive climb to outclimb obstacle (tree) and his decision to execute a takeoff with a tailwind.NTSB ATL98LA073Accident · 1 fatalLimited investigationFinal reportQuad City Ultralight Challenger II · Savannah, GAIn flight collision with terrain for undetermined reasons. A contributing factor was the pilot's lack of familiarity with the aircraft.NTSB MIA98LA147Accident · No injuriesLimited investigationFinal reportWaco 10 GXE · Americus, GAThe pilot's failure to maintain directional control and his improper compensation for wind. Contributing was a crosswind.NTSB MIA98LA129Accident · Serious injuriesLimited investigationFinal reportKrips Kolb Firestar · Dallas, GAThe pilot's failure to maintain adequate airspeed for the existing wind conditions.NTSB MIA98LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Mallards Ldg, GAA deer on the runway which led to the pilot's evasive manuever to avoid the deer.NTSB MIA98LA122Accident · Serious injuriesLimited investigationFinal reportBrock 162F · Canton, GAthe pilot's improper use of throttle and collective pitch during initial takeoff climb, which resulted in a decay of rotor rpm and settling of the helicopter into a lake.NTSB ATL98FA060Accident · 5 fatalField investigationFinal reportCessna 525 · Marietta, GAThe failure of both pilots to see and avoid conflicting traffic, and the failure of the 172 pilot to operate the transponder as required by current regulations. Factors were the controller's failure to observe the traffic conflict, the lack of radar conflict…NTSB MIA98LA115Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Contributing factors were the pilot's lack experience in this category of aircraft. An additional factor was the inadequate upgrade training provided by the company that owned the…NTSB ATL98LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hampton, GAThe pilot's failure to maintain directional control during a full stop landing roll.NTSB ATL98LA057Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Chamblee, GAthe pilot's inadequate compensation for wind conditions and excessive application of braking action, which resulted in an on-ground loss-of-control and a nose over. Related factors were: the pilot's selection of the wrong runway, and the crosswind condition.NTSB ATL98FA056Accident · 1 fatalField investigationFinal reportJohn S. Hickey Swearingen SX 300 · Thomson, GAThe pilot's inadequate preflight planning of the fuel supply required for the flight that resulted in fuel exhaustion and the loss of engine power.NTSB MIA98LA083Accident · No injuriesLimited investigationFinal reportCessna T210N · Covington, GAthe pilot's inadequate preflight planning/preparation and/or improper fuel management, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Soft/wet terrain in the emergency landing area was a related factor.NTSB ATL98LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Americus, GAthe pilot's improper planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing on unprepared terrain.NTSB MIA98LA073Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Cumming, GAThe pilot's misjudgment of distance and airspeed, and his failure to attain the proper touchdown point.NTSB MIA98LA063Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAThe failure of the student to recover (pull-up) from the intentional maneuver resulting in the in-flight collision with terrain. Contributing to the accident was the ostentatious display by the student.NTSB MIA98LA061Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-602 · Wrightsville, GAThe failure of the pilot to maintain airspeed (Vs) resulting in the inadvertent stall during the initial climb.NTSB MIA98LA053Accident · Minor injuriesLimited investigationFinal reportBell 206B · Pooler, GAThe pilot's failure to maintain a safe altitude and a visual lookout while operating under a special visual flight rules clearance in instrument flight rule conditions, which resulted in the helicopter colliding with trees. Contributing to the accident was…NTSB MIA98FA047Accident · 2 fatalField investigationFinal reportCessna 414A · Guyton, GAInadequate maintenance of the cabin pressurization system, which resulted in inadequate pressurization and incapacitation of the pilot due to the hypoxia. Also causal was the pilot's failure to adequately monitor the cabin pressurization system.NTSB MIA98LA037Accident · Minor injuriesLimited investigationFinal reportCessna FR-172J · Marietta, GAA catastrophic failure of the oil cooler core which led to overboard porting of lubricating oil and subsequent engine failure.NTSB ATL98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lawrenceville, GAfailure of the student pilot to maintain directional control of the airplane, during the landing roll.NTSB ATL98LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · Waycross, GAa loss of engine power for undetermined reasons.NTSB ATL98LA011Accident · Minor injuriesLimited investigationFinal reportBeech 60 · Athens, GAthe pilot's improper in-flight planning/decision by attempting to land in weather that was below minimums, and his failure to attain a suitable touchdown point on the runway. Weather below landing minimums was a related factor.NTSB MIA98LA026Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Cummings, GAthe pilot landed the airplane with a tailwind condition, too long and too fast for the runway conditions.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 MIA98FA015Accident · 2 fatalField investigationFinal reportCessna 172M · Rabun Gap, GAThe pilot's continued flight under visual flight rules into known instrument meteorological conditions and his failure to maintain a safe altitude for terrain clearance resulting in the aircraft colliding with trees and the ground on the side of a mountain.NTSB ATL98LA004Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Blakley, GAthe pilot misjudge clearance from trees during pull-up from a swath run. The obstructions (power line and trees) were related factors.NTSB ATL98FA002Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Kennesaw, GAthe pilot's improper emergency procedures and subsequent loss of aircraft control, while attempting to maneuver for a precautionary landing. A factor relating to the accident was: partial loss of power in one or both engines for undetermined reason(s).NTSB ATL98LA001Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Sylvania, GAThe pilots failure to maintain clearance from transmission wires.NTSB MIA98LA004Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Trenton, GAfailure of the pilot to abort the takeoff, when he observed an indication of less than full engine power on the tachometer from the beginning of the takeoff roll. Factors relating to the accident were: the inadequate preflight planning and preparation by the…NTSB MIA97LA247Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Bainbridge, GAthe failure of the pilot to see and avoid the tractor resulting in an on ground collision. A factor in this accident was the limited forward visibility from the cockpit of the airplane.NTSB ATL97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Lawrenceville, GAThe student pilot's improper go-around technique that resulted in an inadvertent stall. A factor was a premature flare for landing.NTSB ATL97LA129Accident · Serious injuriesLimited investigationFinal reportKolb FIRESTAR-II · Albany, GAthe pilot's physical impairment, and his failure to maintain adequate airspeed while maneuvering, which led to a stall and ground impact.NTSB MIA97LA235Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Villa Rica, GAInadequate runway maintenance by the pilot for allowing trees to be in close proximity of the runway and failure to maintain clearance from the trees.NTSB MIA97LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Waynesboro, GAThe obscured vision of the pilot due to oil covering the windscreen. Contributing to the accident was the partial loss of engine power due to a cracked head of one of the cylinders and unsuitable terrain encountered during the forced landing.NTSB MIA97LA231Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Pinehurst, GAThe failure of the pilot to maintain clearance with the cotton crop while maneuvering to begin a spray pass over a 5 foot-tall cotton crop, resulting in the in-flight collision with the crop and terrain.NTSB MIA97FA232Accident · 1 fatalField investigationFinal reportBeech 200 · Dalton, GAthe pilot's improper IFR procedure, by failing to maintain the minimum descent altitude (MDA) during the ILS localizer approach, until the runway environment was in sight, which resulted in a collision with terrain short of the runway. Factors relating to the…