NTSB investigations, GA
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 ATL91FA120Accident · 1 fatalField investigationFinal reportHughes 269C · Blakely, GALoss of engine power for an undetermined reason, and failure of the instructor pilot (CFI) to follow procedures and maintain rotor RPM.NTSB ATL91FA124Accident · 2 fatalField investigationFinal reportPiper PA-28 · Mt. Berry, GAThe pilot's inadequate preflight planning, his poor inflight decision to continue into deteriorating weather conditions, and his inadvertent flight into IMC. Factors in this accident were: the clouds obscuring the mountain at the time of the accident, and the…NTSB ATL91LA113Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Camilla, GARestricted exhaust valve movement, low cylinder compression, and fouling of the engine spark plugs, which resulted in the loss of engine power. Factors were the improper servicing of the aircraft, and the use of an improper fuel grade.NTSB ATL91FA110Accident · 1 fatalField investigationFinal reportCessna 150J · Monroe, GAThe pilots attempted flight in adverse weather and the physical impairment of the student pilot from the consumption of alcoholic beverages prior to flight. A factor in the accident was the foggy weather condition at the airport.NTSB ATL91FA108Accident · 2 fatalField investigationFinal reportCessna T37B · Chickamauga, GAThe T-37 pilot misjudged the clearance between his aircraft and the A-26.NTSB ATL91LA106Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG-200 · Marshallville, GAThe pilot's failure to maintain airspeed and the inadvertent stall/spin. A factor was the loss of thermal lifting action.NTSB ATL91LA104Accident · Serious injuriesLimited investigationFinal reportPeecher EAA Biplane P-2 · Dalton, GAThe pilot's failure to maintain airspeed when he diverted his attention outside the airplane which resulted in an inadvertent stall and subsequent collision with trees.NTSB ATL91LA102Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Lake Seminole, GAThe failure of the pilot to maintain clearance from the surface.NTSB ATL91LA095Accident · No injuriesLimited investigationFinal reportBeech 55 · Perry, GAImproper in-flight planning/decision by the pilot in command (CFI). The improper procedure of turning the fuel selector valve to 'off' at altitude to simulate a failed engine, then delaying restarting of the engine until the aircraft was on final approach was…NTSB ATL91LA092Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Statesboro, GAFailure of both pilots to perform a visual lookout sufficiently adequate to avoid a collision at an uncontrolled airport. Factors related to the accident were: failure of the pilot of N95170 to communicate on the common traffic advisory frequency (CTAF) and…NTSB ATL91FA090Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAThe van driver's inadequate visual lookout and poor division of attention.NTSB ATL91LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Hampton, GAThe pilot's improper flare and his failure to execute an abort in a timely manner when a safe landing was not possible. Factors in the accident were the wet grass conditions at the airstrip, and the pilot's lack of recent total flying experience.NTSB ATL91LA078Accident · 1 fatalLimited investigationFinal reportLewis Challenger II · Thomaston, GAThe pilot's failure to properly maintain the airplane in accordance with prescribed procedures which resulted in fuel contamination, fouled spark plugs, and a loss of engine power. The pilot also failed to follow normal emergency procedures for the loss of…NTSB DCA91MA033Accident · 23 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Brunswick, GAThe loss of control in flight as a result of a malfunction of the left engine propeller control unit which allowed the propeller blade angles to go below the flight idle position. Contributing to the accident was the deficient design of the propeller control…NTSB ATL91LA076Accident · No injuriesLimited investigationFinal reportDavid Lowe ULTRA-PUP · Waycross, GAThe failure of the airplane battery, which prohibited the complete extension of the landing gear, resulting in a landing with the nose gear retracted. A factor in the accident was the soft terrain at the selected landing area.NTSB ATL91LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Chamblee, GAThe hole in the airport taxiway, which was created by the erosion of soil beneath the taxiway, and the failure of the airport to inspect and maintain ditches which run beneath the runways and taxiways.NTSB ATL91LA070Accident · No injuriesLimited investigationFinal reportCessna 150G · Villa Rica, GAA loss of engine power for undetermined reasons.NTSB ATL91LA068Accident · No injuriesLimited investigationFinal reportCessna 210G · Metter, GAThe pilot's failure to extend the landing gear when his attention was diverted by radio conversation.NTSB ATL91FA064Accident · Serious injuriesField investigationFinal reportPiper PA-34-220T · Lawrenceville, GAThe poor inflight planning by the pilot which resulted in fuel exhaustion. Factors related to this accident were the unfavorable winds, the dark night, and the inoperable airport runway lights.NTSB ATL91LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Suches, GAThe pilot's failure to maintain altitude during cruise flight after loss of electrical power for an undetermined reason.NTSB ATL91LA059Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Pavo, GAThe failure of the no. 2 exhaust valve and cylinder head, which resulted in a total loss of engine power. A factor in the accident was the collision with a road sign during the forced landing.NTSB ATL91LA057Accident · No injuriesLimited investigationFinal reportCessna 182Q · Brunswick, GAA hidden hole in the runway surface, which was contacted by the nose wheel during the landing roll.NTSB ATL91LA061Accident · Serious injuriesLimited investigationFinal reportMaxair ARV 582 · Eastman, GAThe inadvertent stall of the aircraft which was encountered as a result of the lack of total experience of the non-rated pilot.NTSB ATL91IA050Incident · No injuriesIncident investigationFinal reportPiper PA-60-600 · Cochran, GAFailure of the right engine shutoff valve which resulted in a complete loss of engine power. The airplane veered off the right side of the runway and the right main landing gear collapsed as a result of the pilots failure to maintain directional control…NTSB ATL91FA047Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Cordele, GAFailure of the pilot to attain proper runway alignment and to maintain proper altitude. Related factors were: darkness and the pilot becoming lost/disoriented.NTSB ATL91LA045Accident · No injuriesLimited investigationFinal reportCessna 182A · Warm Springs, GAAn electrical short related to the alternator from an undetermined source.NTSB ATL91FA042Accident · 1 fatalField investigationFinal reportCessna 310 · Brunswick, GAThe incapacitation of the pilot.NTSB ATL91LA036Accident · No injuriesLimited investigationFinal reportCessna 195B · La Grange, GAThe failure of the tailwheel steering spring.NTSB ATL91FA035Accident · 1 fatalField investigationFinal reportBeech B95 · Austell, GAThe loss of engine power which resulted from the pilot's failure to properly use the carburetor heat. The pilot failed to maintain flying speed during the emergency descent which resulted in a stall on final approach. A factor in the accident was weather…NTSB ATL91LA029Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Senoia, GAImproper preflight planning and preparation by the pilot which resulted in fuel exhaustion. Factors to the accident were the dark night operation and the collision with utility lines.NTSB ATL91IA024Incident · No injuriesIncident investigationFinal reportCessna S550 · Columbus, GAA fatigue failure of a spot weld on the gas generator case, which resulted in an engine explosion.NTSB ATL91LA023Accident · No injuriesLimited investigationFinal reportCessna 172N · Chamblee, GAPilot's failure to maintain adequate wingtip clearance during taxi.NTSB ATL91FA018Accident · 1 fatalField investigationFinal reportCessna 182E · Blairsville, GAFuel exhaustion resulting in engine stoppage, and the pilot's failure to obtain fuel earlier in the flight.NTSB ATL91IA017Incident · No injuriesIncident investigationFinal reportFokker F28 MK0100 · Atlanta, GAFrozen moisture in the stabilizer actuator hydraulic servo valve which resulted in reduced movement of the servo valve and limited its ability to respond to flight control inputs. The lack of response from the servo valve resulted in the jammed stabilizer…NTSB ATL91LA010Accident · No injuriesLimited investigationFinal reportCessna A150K · Dublin, GAThe pilot's inadequate preflight planning and preparation, in that he did not ensure that enough fuel was on board to complete the flight.NTSB ATL91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Savannah, GATotal failure of a connecting rod cap bolt which resulted in a total loss of power.NTSB ATL91LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAThe student pilot's failure to maintain directional control during a takeoff attempt. Factors to the accident were the student's overall lack of flight experience, and the reported wind gust.NTSB ATL90LA185Accident · No injuriesLimited investigationFinal reportCessna 210 · White Plains, GAThe fuel starvation to the engine for undertermined reasons.NTSB ATL90FA179Accident · 3 fatalField investigationFinal reportCessna 421B · Jefferson, GAFailure of the pilot to perform the correct emergency procedures, when confronted with a loss of engine power, and his failure to maintain minimum control speed (VMC), which resulted in a loss of aircraft control.NTSB ATL90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Brookley, GAFuel exhaustion. Factors include improper planning/decision by the pilot-in-command.NTSB ATL90LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Palmetto, GAThe number two cylinder exhaust valve sticking in the closed position, which resulted in a partial power loss during the takeoff. A factor in the accident was the pilot's improper preflight inspection, in that he did not correctly analyze the engine problem…NTSB ATL90LA171Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Americus, GAA low cycle fatigue failure of the left main landing gear spring.NTSB ATL90LA165Accident · No injuriesLimited investigationFinal reportGrumman AA1 · Gainesville, GAThe student pilot's failure to properly flare.NTSB ATL90LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Palmetto, GAThe pilot's operation of the airplane with known mechanical deficiencies. A factor in the accident was the improperly maintained condition of the magnetos.NTSB ATL90LA160Accident · No injuriesLimited investigationFinal reportCessna 172P · Lawrencevile, GAThe pilot's failure to maintain directional control during the landing roll.NTSB ATL90FA158Accident · 2 fatalField investigationFinal reportNorth American T-6G · Locust Grove, GAThe pilot-in-command's failure to maintain aircraft control during maneuvering flight, allowing the airplane to stall without sufficient altitude for recovery.NTSB ATL90DKG06Accident · No injuriesFinal reportProsser Mono FLY · Cartersville, GAThe pilot/builder's failure to ensure that the substituted control stick was adequately attached to the aileron bell crank.NTSB ATL90DKG05Accident · No injuriesFinal reportAyres Bull Thrush · Americus, GAFailure of the engine main oil line which allowed the engine oil to be ignited by the hot engine.NTSB ATL90IA154Incident · No injuriesIncident investigationFinal reportDassault DA20F · Chamblee, GAThe right fuel control unit malfunctioned and allowed the engine speed to decrease below idle speed (45%) which resulted in an engine fire. Factors in the incident were: the improper rigging of the fuel control unit during installation, and the flight crew's…NTSB ATL90TL#03Accident · No injuriesClass 3Final reportCessna 185A · Americus, GA