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 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 ATL07IA078Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-111 · Atlanta, GAThe mechanics failure to follow procedures and directives in securing the lower engine cowling after maintenance, and the failure of the first officer to follow the checklist to ensure the engine cowling was secured during the walk around inspection resulting…NTSB ATL07FA077Accident · 5 fatalField investigationFinal reportBeech 58 · Hamilton, GAThe pilot's exceeding the design stress limits of the airplane while performing aerobatics in a nonaerobatic airplane, which resulted in an in-flight overload failure of the airframe. A factor in the accident was the pilot's decision to perform aerobatics.NTSB ATL07CA075Accident · Minor injuriesData collectionFinal reportCessna 182B · ST. Mary's, GAThe pilot's decision to operate an airplane with known deficiencies in equipment (inoperative carburetor heat control cable) resulting in a total loss of engine power due to carburetor icing.NTSB ATL07CA074Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · Waynesboro, GACompany maintenance personnel’s improper installation of an unapproved oil quick drain plug which resulted in oil exhaustion and subsequent loss of engine power during cruise flight.NTSB ATL07CA070Accident · No injuriesData collectionFinal reportCessna 152 · Hinesville, GAThe pilots improper preflight planning with resulted in a loss of engine power due to fuel exhaustion.NTSB ATL07LA065Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Woolsey, GAIn-flight fire of the right wing for undetermined reasons.NTSB ATL07LA064Accident · No injuriesLimited investigationFinal reportBeech BE-90 · Augusta, GAA total failure of the electrical system for undetermined reasons, which resulted in the pilot's inability to ensure that the landing gear was down and locked.NTSB ATL07CA059Accident · No injuriesData collectionFinal reportStinson 108 · Lawrenceville, GAThe pilot's failure to maintain directional control on landing roll out resulting in a ground loop.NTSB ATL07CA062Accident · No injuriesData collectionFinal reportPiper PA-28A-180C · Atlanta, GAThe pilot's failure to maintain directional control of the airplane while landing with a flat main tire.NTSB ATL07CA058Accident · No injuriesData collectionFinal reportCessna 172K · Cornelia, GAThe failure of the owner/operator to repair or replace a known leaking brake system components resulting in a total loss of brakes while taxing and an on-ground collision with trees.NTSB ATL07LA057Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Atlanta, GAThe improper maintenance of the "B-nut" fitting adjacent to the fuel pump by maintenance personnel, resulting in a fuel leak and wing explosion.NTSB ATL07LA054Accident · 1 fatalLimited investigationFinal reportJames Walter Hornet · Talbotton, GAThe failure of the right main fuel line, resulting in fuel starvation and a loss of engine power.NTSB ATL07CA060Accident · No injuriesData collectionFinal reportMaule M-5 235C · Moultrie, GAThe pilot's failure to maintain directional control of the airplane during landing roll.NTSB ATL07CA048Accident · No injuriesData collectionFinal reportMooney M20J · Toccoa, GAThe pilot's failure to maintain airspeed during a go-around resulting in an inadvertenent stall and collision with the ground.NTSB ATL07CA047Accident · No injuriesData collectionFinal reportCessna 172R · Cartersville, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control and an on-ground collision with a sign.NTSB ATL07CA046Accident · Serious injuriesData collectionFinal reportRobinson R-44 · Covington, GAThe student pilot's failure to maintain control of the helicopter during liftoff, which resulted in an in-flight collision with the ground.NTSB ATL07LA045Accident · 2 fatalLimited investigationFinal reportHiller UH-12A · Bethlehem, GAThe pilot's failure to maintain adequate rotor rpm, which resulted in an attempted autorotation and in-flight collision with trees. Contributing to the severity of the accident was the pilot exceeding the helicopters takeoff capability.NTSB ATL07CA043Accident · No injuriesData collectionFinal reportBurkhart-Grob G109 · Monticello, GAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control, an in-flight collision with a hangar, and subsequent in-flight collision with the runway.NTSB ATL07CA042Accident · No injuriesData collectionFinal reportPiper PA-12 · Elberton, GAThe passenger's inadvertent application of the left brake during landing roll, which resulted in a swerve to the left and impact with trees.NTSB ATL07LA041Accident · No injuriesLimited investigationFinal reportBeech A36 · Brunswick, GAThe pilot's failure to activate the electric fuel pump following a loss of engine power for undetermined reasons.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 ATL07CA039Accident · No injuriesData collectionFinal reportCessna C150 · Palmetto, GAThe pilot's inadequate compensation for a crosswind during the landing flare, which resulted in a loss of control and an in-flight collision with objects. A factor associated with the accident was a crosswind.NTSB ATL07CA037Accident · No injuriesData collectionFinal reportEurocopter France EC120B · Griffin, GAThe first pilot's failure to maintain directional control of the helicopter during hover in ground effect, and the second pilot's (a certificated flight instructor), delayed remedial action, which resulted in an in-flight collision with the ground. A factor…NTSB ATL07FA036Accident · 1 fatalField investigationFinal reportCessna T210M · Haddock, GALoss of engine power for undetermined reasons.NTSB OPS07IA002Incident · No injuriesIncident investigationFinal reportBoeing 757-212 · Atlanta, GAThis incident was caused by the local controller's issuance of an improper takeoff clearance to DAL1606. Contributing was the failure of the oncoming and outgoing local controllers to provide and receive a complete position relief briefing; and the oncoming…NTSB ANC07LA011Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Albany, GAThe loss of engine power during cruise flight due to a fractured crankshaft, resulting in an off-airport forced landing in a muddy field.NTSB ATL07FA030Accident · 3 fatalField investigationFinal reportCessna 414A · Lawrenceville, GAThe pilot's failure to follow the instrument approach procedure. Contributing to the accident was the pilot's descent below the prescribed decision height altitude.NTSB ATL07LA028Accident · Minor injuriesLimited investigationFinal reportScharnhorst RV-4 · Hoschton, GAThe failure of the manufacturer to safety wire the purge valve stop screw during maintenance resulting in a total loss of engine power in cruise flight due to fuel starvation. This resulted in a forced landing, on-ground collision with a berm/terrace, and…NTSB ATL07CA027Accident · Serious injuriesData collectionFinal reportPiper J-2 · Williamson, GAThe pilot's inadequate preflight inspection which resulted in fuel exhaustion a subsequent total loss of engine power.NTSB ATL07LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-15 · Conyers, GALoss of engine oil for undetermined reasons resulting in oil starvation, failure of the No. 1 connecting rod resulting in the total loss of engine power.NTSB CHI07LA035Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Atlanta, GAThe exceedance of airplane design stress limits when the pilot did not maintain aircraft control after his attention was diverted to the right side attitude indicator during cruise flight. An additional cause was the aural detection for the autopilot…NTSB ATL07LA021Accident · Serious injuriesLimited investigationFinal reportTennyson Howard Baslee DR-1 · Macon, GAThe pilot/owner's improper design change which resulted in a blocked carburetor inlet and a loss of engine power.NTSB ATL07CA019Accident · Serious injuriesData collectionFinal reportHolmgreen RV-6A · Midway, GAAn on ground encounter with rough/uneven terrain during the landing roll out resulting in the collapse of the nosewheel and subsequent nose over.NTSB ATL07LA014Accident · 1 fatalLimited investigationFinal reportCarlson Lancair Propjet · Dalton, GAThe pilot's failure to maintain airspeed during a forced landing, resulting in an inadvertent stall. Contributing to the accident was the pilot's mismanagement of the fuel supply, which resulted in loss of engine due to fuel starvation.NTSB ATL07CA015Accident · No injuriesData collectionFinal reportCessna 172G · Dalton, GAThe pilot's improper starting procedures, which resulted in an on-ground engine fire.NTSB ATL07FA002Accident · 4 fatalField investigationFinal reportCessna 177 · Stockbridge, GAThe pilot's attempted takeoff over the allowable takeoff gross weight of the airplane and his failure to maintain airspeed during climb after takeoff.NTSB ATL06CA131Accident · No injuriesData collectionFinal reportBeech A36 · Macon, GAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation and a forced landing.NTSB ATL06LA130Accident · Minor injuriesLimited investigationFinal reportBellanca 14-13-2 · Ellijay, GAA loss of engine power due to fuel contamination. Also causal was the mechanic's failure to ensure the aircraft's fuel system was free of contamination while performing an annual inspection.NTSB ATL06CA128Accident · No injuriesData collectionFinal reportMooney M-20J · Blue Ridge, GAThe pilot's failure to achieve the proper touchdown point on landing resulting in an overrun, and on ground collision with trees.NTSB ATL06CA124Accident · No injuriesData collectionFinal reportCessna 172R · Winder, GAThe student pilot's failure to maintain control of the airplane during an attempted go-around.NTSB ATL06LA134Accident · No injuriesLimited investigationFinal reportCirrus Design SR22-GTS · Mc Rae, GAThe pilot's failure to use supplemental oxygen where required, and his failure to maintain sufficient airspeed to avoid a stall.NTSB ATL06LA119Accident · No injuriesLimited investigationFinal reportAyres S2R · Doerun, GAThe loss of engine power for an underdetermined reason, resulting in a forced landing, an on ground collision with trees, and a post crash fire.NTSB ATL06LA115Accident · 1 fatalLimited investigationFinal reportMcWhorter Skystar Vixen · Peachtree City, GAThe pilot's failure to maintain airspeed while maneuvering to reverse his direction following loss of engine power shortly after takeoff resulting in an inadvertent stall and collision with the ground. A factor in the accident was a loss of engine power for…NTSB ATL06CA117Accident · No injuriesData collectionFinal reportCessna 172S · Thomson, GAThe student pilot's failure to maintain directional control during the landing roll resulting in an on-ground collision with an embankment.NTSB ATL06CA116Accident · No injuriesData collectionFinal reportCessna 172M · Augusta, GAThe pilot's improper flare on landing with excessive altitude resulting in a hard landing.NTSB ATL06LA114Accident · Minor injuriesLimited investigationFinal reportBeech D45 · Bainbridge, GAThe improper maintenance installation of the fuel inlet line by other maintenance personnel resulting in a partial loss of engine power after takeoff due to fuel starvation.NTSB ATL06CA113Accident · No injuriesData collectionFinal reportCessna 208 · Riceboro, GAThe pilot's failure to achieve the proper takeoff distance on a short water runway resulting in an in-flight collision with a berm and a marshy area on initial takeoff climb.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 ATL06CA109Accident · No injuriesData collectionFinal reportCessna 182L · Eatonton, GAThe CFI's failure to initiate a go-around when he noticed the flight was high during approach resulting in the flight landing long, overrunning the runway , and colliding with trees. Factors in the accident were a wet runway and a tailwind for landing.