NTSB investigations, 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, 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 ERA16LA073Accident · No injuriesLimited investigationFinal reportCessna 310 · Kennesaw, GAInadequate inspection and rigging of the landing gear system, which resulted in the subsequent failure and collapse of the left main landing gear during landing.NTSB ERA16LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Lawrenceville, GAThe flight instructor's inadequate fuel management, which resulted in a total loss of engine power during initial climb due to fuel starvation and a subsequent forced landing.NTSB ERA16FA035Accident · 2 fatalField investigationFinal reportCessna 441 · Climax, GAThe pilot’s loss of airplane control due to spatial disorientation. Also causal to the accident was the pilot’s impairment by the combined effects of multiple medications and drugs.NTSB ERA16LA042Accident · No injuriesLimited investigationFinal reportCessna P210 · Atlanta, GAThe pilot's delayed extension of the landing gear and his failure to ensure that the main landing gear (MLG) were down and locked before touchdown, which resulted in the collapse of both MLG. Contributing to the landing gear collapse was the mis-set landing…NTSB ERA16FA032Accident · 3 fatalField investigationFinal reportPiper PA 28-180 · Cornelia, GAThe pilot's decision to initiate the flight into known adverse weather conditions, which resulted in his spatial disorientation and loss of airplane control.NTSB ERA16LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Savannah, GAThe pilot's inadequate preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and a total loss of engine power during approach. Contributing to the accident were the pilot’s failure to maintain adequate airspeed and his…NTSB ERA16FA005Accident · 1 fatalField investigationFinal reportPiper PA 38-112 · Jasper, GAThe student pilot's failure to accurately determine the airplane's fuel state, subsequent fuel exhaustion, and a total loss of engine power during initial climb. Contributing to the accident was the flight instructor's inadequate oversight of the student…NTSB ERA16LA004Accident · No injuriesLimited investigationFinal reportBeech 58 · Albany, GAThe mechanic's inadequate inspection of the brake system during the most recent annual inspection, which resulted in the failure of both left and right main landing gear torque plates and a subsequent loss of braking action.NTSB ERA15LA374Accident · No injuriesLimited investigationFinal reportBell 206 · Thomaston, GAThe loss of tail rotor control due to a fractured pin in the tail rotor control system; the reason the pin fractured could not be determined as the fractured pin was lost in shipping.NTSB ERA15FA359Accident · 5 fatalField investigationFinal reportBoatright Waylon RV10 · Alma, GAThe noncertificated pilot's decision to perform aerobatic maneuvers in his overweight, improperly-loaded airplane in dark night conditions at low altitude, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident…NTSB ERA15LA344Accident · Serious injuriesLimited investigationFinal reportEasterwood Mark W RV 6A · Rome, GAThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA15LA379Accident · No injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415 · Atlanta, GAThe pilot's loss of airplane control, which resulted in a hard landing.NTSB GAA15CA216Accident · No injuriesData collectionFinal reportCessna 150M · Ellijay, GAThe pilot's failure to attain and maintain sufficient airspeed during takeoff which resulted in a descent, loss of directional control, and a runway excursion.NTSB ERA15LA270Accident · No injuriesLimited investigationFinal reportAyres S2R T34 · Climax, GAA loss of thrust on takeoff for reasons that could not be determined, because postaccident examination of the engine and propeller assembly did not reveal any mechanical anomalies that would have precluded normal operation.NTSB DCA15CA146Accident · Serious injuriesData collectionFinal reportBoeing 767 432ER · Atlanta, GAthe flight attendant inadvertently slipped off a worn tread descending the crew rest ladder.NTSB ERA15CA243Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Moreland, GAThe flight instructor's inaccurate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB DCA15CA125Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 212 · Atlanta, GAthe flight attendant's failure to secure her lap belt and shoulder harness prior to the takeoff that resulted in her being thrown from her jumpseat shortly after takeoff.NTSB GAA15CA082Accident · Minor injuriesData collectionFinal reportBoeing PT 17 · Williamson, GAThe pilot landed off the right side of the runway resulting in a collision with terrain.NTSB GAA15CA071Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe pilot's failure to maintain pitch control during the landing. Contributing to this accident was the pilot's lack of experience with the airplane's performance characteristics during the approach resulting in a hard landing and runway excursion.NTSB ERA15FA208Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Atlanta, GAA partial loss of engine power due to contamination in the fuel manifold, which resulted in a collision with terrain shortly after takeoff.NTSB ERA15LA205Accident · Minor injuriesLimited investigationFinal reportJerome D Fischer RV-7 · Bartow, GAThe pilot's use of the improper fuel grade for the engine, which resulted in detonation, engine damage, and loss of engine power.NTSB GAA15CA047Accident · Minor injuriesData collectionFinal reportPiper PA 16 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll.NTSB ERA15LA197Accident · Serious injuriesLimited investigationFinal reportJames Kilroy Pitts Model 12 · LaGrange, GAA partial loss of engine power after takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB GAA15CA040Accident · No injuriesData collectionFinal reportTrom Wayne Vans RV6A · LaFayette, GAThe pilot's failure to maintain directional control during the landing roll in variable, gusting wind conditions, resulting in a runway excursion, and substantial damage to the airplane.NTSB GAA15CA070Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cornelia, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB ERA15LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Woodstock, GAThe pilot's failure to attain the proper touchdown point on the short, wet, turf runway. Contributing to the accident was the pilot’s use of a high approach speed.NTSB ERA15LA160Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Williamson, GAThe separation of the nosewheel upon landing due to a missing bolt that attached the upper torque assembly to the nosewheel steering arm assembly. When and how the bolt separated could not be determined.NTSB ERA15LA156Accident · 1 fatalLimited investigationFinal reportKolb Twinstar · Reynolds, GAThe student pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident was the student pilot's decision to operate…NTSB ERA15CA152Accident · No injuriesData collectionFinal reportCessna 182L · Waycross, GAThe pilot's failure to use any airport guidance while taxiing, which resulted in geographic disorientation and a takeoff attempt from an inadequate length and unsuitable surface.NTSB ERA15CA117Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Valdosta, GAThe pilot's failure to compensate for gusty wind conditions during the landing flare, which resulted in a hard landing and subsequent nose landing gear collapse.NTSB ERA15FA103Accident · 1 fatalField investigationFinal reportLuscombe 8 · Fort Valley, GAThe flight instructor’s failure to maintain airspeed during an approach with a simulated engine failure, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall/spin.NTSB ERA15LA075Accident · 1 fatalLimited investigationFinal reportJohnson David Earl Renegade Spirit · Brunswick, GAThe pilot's decision to fly the airplane with known engine deficiencies and his subsequent exceedance of the airplane's critical angle of attack following a loss of engine power, which resulted in an aerodynamic stall and loss of control after takeoff.NTSB DCA15CA035Accident · Serious injuriesData collectionFinal reportBoeing 737 824 · Valdosta, GAan inadvertent encounter with clear air turbulence while the flight attendants were returning to their seats.NTSB ERA15LA052Accident · Serious injuriesLimited investigationFinal reportDehavilland Tiger Moth DH 82A · Williamson, GAThe pilot’s failure to maintain airspeed while maneuvering, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall at an insufficient altitude to fully recover before collision with obstacles and terrain.NTSB ERA15FA017Accident · 1 fatalField investigationFinal reportAeronca 7EC · Cordele, GAAn in-flight loss of control for reasons that could not be determined based on the available evidence.NTSB ERA15FA016Accident · 2 fatalField investigationFinal reportRockwell International 112 · Gainesville, GAThe partial loss of engine power due to the undetected blockage of the inlet and outlet ports of the manifold valve by an organic compound of an unknown source.NTSB ERA15LA006Accident · Serious injuriesLimited investigationFinal reportSocata TBM 700 · Fayetteville, GAThe pilot’s inadvertent deactivation of the yaw damper in flight, which resulted in a prolonged side-slip condition that led to fuel starvation and the eventual total loss of engine power. Contributing to the accident was the pilot’s failure to attempt to…NTSB ERA15IA009Incident · No injuriesIncident investigationFinal reportFunk Ralph Velocity Xlrg · Atlanta, GAThe pilot’s failure to maintain directional control during a hard landing, which resulted in the fracture of the nose landing gear.NTSB ERA15CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Toccoa, GAThe private pilot's failure to maintain proper altitude and the flight instructor's failure to provide correction action, which resulted in a collision with terrain during landing.NTSB ENG14IA027Incident · No injuriesIncident investigationFinal reportBoeing 747 · Atlanta, GATurbine Overhaul Service's aggressive grit blasting and incomplete masking of the blade root neck that allowed the no grit blast area being exposed during the overhaul of the blade resulting in blasting media being embedded in the blade root from which a…NTSB ERA14FA455Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Fort Gaines, GAThe pilot’s failure to maintain airplane control during flight, which resulted in a collision with a river.NTSB ERA14LA436Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Monroe, GAThe improper installation of the oil filter adapter at an unknown time, which resulted in an oil leak and subsequent oil starvation to the engine.NTSB ERA14LA422Accident · No injuriesLimited investigationFinal reportAckland Jeffrey Dean SH 3R · Columbus, GAThe mechanic’s improper installation of the landing gear extend/retract switch, which resulted in the retraction of the landing gear during the aborted takeoff.NTSB ERA14FA377Accident · 2 fatalField investigationFinal reportCessna 150 · Senoia, GAThe noninstrument-rated pilot’s inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in subsequent collision with terrain.NTSB ERA14CA365Accident · No injuriesData collectionFinal reportCessna 182B · Clayton, GAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a tree and then obstacles during the subsequent aborted takeoff.NTSB ERA14LA360Accident · Serious injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Newnan, GAA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA14FA359Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Clayton, GAThe pilot’s decision to begin a flight with fog and low clouds present at the airport, which resulted in an encounter with instrument meteorological conditions immediately after takeoff and a controlled flight into terrain.NTSB ERA14CA353Accident · No injuriesData collectionFinal reportJannakos Gregory P Zodiac 601 HDS · Lawrenceville, GAThe pilot's inadequate flare, which resulted in a hard landing.NTSB ERA14LA341Accident · No injuriesLimited investigationFinal reportLet L 23 Super Blanik · Warm Springs, GAThe failure of the flight instructor to move his glider from an active runway in accordance with procedures due to his distraction by having a conversation with the air boss, which resulted in the landing glider colliding with the glider on the runway.NTSB ERA14FA339Accident · 2 fatalField investigationFinal reportAllen Steen Skybolt · Carrollton, GAAn in-flight loss of airplane control for reasons that could not be determined during postaccident examinations or based on the available evidence.