NTSB investigations, GA
159 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 7 |
| 1984 | 10 |
| 1985 | 8 |
| 1986 | 11 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 6 |
| 1990 | 6 |
| 1991 | 8 |
| 1992 | 6 |
| 1993 | 5 |
| 1994 | 8 |
| 1995 | 7 |
| 1996 | 3 |
| 1997 | 6 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 5 |
| 2001 | 8 |
| 2002 | 9 |
| 2003 | 5 |
| 2004 | 7 |
| 2005 | 3 |
| 2006 | 8 |
| 2007 | 9 |
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\" = 250)
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" = 250) 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 NYC08CA037Accident · No injuriesData collectionFinal reportCessna 172N · Statesboro, GAThe student pilot's failure to maintain a proper flare at touchdown.NTSB MIA07CA106Accident · Minor injuriesData collectionFinal reportCessna 150L · Greensboro, GAThe pilot's failure to retract the wing flaps during a go-around, which resulted in a stall, and uncontrolled descent, and an impact with terrain.NTSB ATL07CA085Accident · Serious injuriesData collectionFinal reportRobert J. Jackson RV6-A · Summerville, GAThe pilot's failure to maintain sufficient airspeed to avoid a stall during the landing flare, resulting in an uncontrolled descent and in-flight collision with the runway.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 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 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 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 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 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 ATL06CA106Accident · Serious injuriesData collectionFinal reportCessna 172F · Rome, GAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent impact with the ground.NTSB ATL06LA079Accident · 1 fatalLimited investigationFinal reportTaylor Skybolt · Sharpsburg, GAThe pilot's loss of control while conducting aerobatic flight. Factors in the accident were the pilot's ostentatious display, and lack of recent and total experience in type of operation.NTSB ATL06CA037Accident · Serious injuriesData collectionFinal reportBeech BE-76 · Hinesville, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with trees.NTSB NYC06FA048Accident · 2 fatalField investigationFinal reportBeech D55 · Dawson, GAThe pilot's failure to maintain sufficient airspeed to preclude a stall, which resulted in an inadvertent stall and loss of control while circling to land. Factors associated with the accident were the pilot's inadequate in-flight planning and weather…NTSB ATL06CA118Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe student pilot's failure to maintain airspeed during a touch-and-go landing on initial takeoff climb, resulting in a hard landing on the departure runway.NTSB ATL05LA121Accident · 1 fatalLimited investigationFinal reportDenmark Mini-Max · Covington, GAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, uncontrolled descent, and subsequent collision with the ground.NTSB ATL05CA058Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Suches, GAThe pilot's premature liftoff and failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall/mush to the runway and subsequent collision with a fence during aborted takeoff.NTSB ATL05LA005Accident · Serious injuriesLimited investigationFinal reportMoody Easy Riser · Augusta, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin, and subsequent collision with the ground.NTSB ATL04FA190Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Euharlee, GAThe pilot's failure to maintain adequate control of the airplane, which resulted in the pilot exceeding the design limits of the airplane and subsequent in-flight separation.NTSB ATL04LA178Accident · 1 fatalLimited investigationFinal reportSchleicher K6-CR · LaGrange, GAThe pilot's failure to maintain control of the aircraft which resulted in a stall and subsequent impact with terrain. Factors were the pilot's impairment due to marijuana and his unreported mental conditions.NTSB ATL04LA173Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401B · Bainbridge, GAThe pilot's failure to maintain adequate airspeed during an abrupt maneuver which resulted in a stall and collision with the ground.NTSB ATL04CA170Accident · Minor injuriesData collectionFinal reportCessna 172R · Atlanta, GAThe intentional interuption of the flight controls in flight that resulted in a uncontrolled descent and collision with a fence.NTSB ATL04LA076Accident · No injuriesLimited investigationFinal reportBell 206 · Locust Grove, GAThe pilot's failure to maintain directional control of the helicopter while lifting off a dolly to a hover. This resulted in the tail rotor blades and main rotor blades colliding with the ground and subsequent roll over.NTSB ATL04FA071Accident · 1 fatalField investigationFinal reportCessna 150G · High Falls, GAThe pilot's impairment due to alcohol which resulted in his failure to maintain adequate airspeed, inadvertent stall, and subsequent in-flight collision with trees.NTSB ATL04LA036Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Suches, GAThe pilot's failure to maintain airspeed during a go-round that resulted in an inadvertent stall and the subsequent collision with trees.NTSB ATL03LA145Accident · No injuriesLimited investigationFinal reportCessna 180 · Pavo, GAThe pilot's failure to maintain airspeed, resulting in an inadvertent stall.NTSB ATL03LA091Accident · Serious injuriesLimited investigationFinal reportHomebuilt Unkown · Summerville, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall, and subsequent collision with the ground.NTSB ATL03LA088Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Milledgeville, GAThe pilot's failure to maintain airspeed during climbout which resulted in a low altitude stall and subsequent in-flight collision with the terrain.NTSB ATL03LA047Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Valdosta, GAThe pilot's failure to maintain adequate airspeed during a go-around resulting in an inadvertent stall and collision with trees.NTSB ATL02LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · St. Simons Island, GAThe pilot's failure to maintain airspeed during a simulated emergency landing, and his delayed remedial action that resulted in a stall, and an uncontrolled collision with trees. A factor was the check pilot's inadaquate supervision of the check ride.NTSB MIA02FA152Accident · 1 fatalField investigationFinal reportCessna 150J · Brunswick, GAthe pilot's failure to maintain an adequate airspeed during takeoff, which resulted in an inadvertent stall. A contributing factor was the pilot's decision to takeoff in an over gross weight condition.NTSB MIA02LA115Accident · 2 fatalLimited investigationFinal reportBailey Dragon Fly · Trenton, GAthe pilot-in-command's failure to maintain airspeed while maneuvering, which resulted in the airplane stalling, spinning, and impacting with the ground.NTSB MIA02LA114Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Carrollton, GAthe pilot's inadequate compensation for wind and his failure to maintain aircraft control.NTSB MIA02LA099Accident · Minor injuriesLimited investigationFinal reportPiper J-3F-65 · Eton, GAThe pilot's failure to maintain directional control during initial climb after takeoff, resulting in collision with a power pole. A factor in the accident was the flight's encounter with a downdraft condition during initial climb.NTSB ATL02LA097Accident · No injuriesLimited investigationFinal reportAerospatiale 350B · Gainesville, GAThe check airman’s failure to follow prescribed procedures that resulted in the lost of control and subsequent in-flight collision with the terrain. A factor was gusting wind conditions.NTSB MIA02LA093Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200-Saeta · Perry, GAThe pilots failure to maintain airspeed while performing a turn at a low altitude, which resulted in a inadvertent stall, an uncontrolled descent, and an impact with trees and terrain.NTSB ATL02LA086Accident · No injuriesLimited investigationFinal reportPiper J-3 · Carrollton, GAThe pilots failure to maintain flying speed that resulted in an inadvertent stall.NTSB ATL02FA043Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Atlanta, GAThe pilot experienced spatial disorientation that resulted in the loss of control.NTSB ATL02FA025Accident · 1 fatalField investigationFinal reportCessna C-210N · Lilburn, GAThe pilot's failure to maintain aircraft control.NTSB ATL02LA009Accident · 1 fatalLimited investigationFinal reportBass Moni · Locust Grove, GAThe pilot's failure to maintain airspeed during a low-altitude aerobatic maneuver, which resulted in an inadvertent stall/spin and subsequent uncontrolled descent into terrain.NTSB MIA01FA223Accident · 3 fatalField investigationFinal reportBeech A23 · Blairsville, GAThe failure of the pilot to maintain airspeed resulting in an inadvertent stall an subsequent in-flight collision with trees then the ground during the uncontrolled descent.NTSB MIA01LA211Accident · Serious injuriesLimited investigationFinal reportBeech BE-200 · Sandersville, GAThe pilot-in command's failure to maintain airspeed during the approach, resulting in an inadvertent stall and in-flight collision with the terrain during an uncontrollable descent.NTSB MIA01LA202Accident · 2 fatalLimited investigationFinal reportLancair 360 · St. Marys, GAThe flight instructor/pilot in command's continued flight into known adverse weather, which resulted in a loss of control, and uncontrolled descent, and the airplane crashing into the Atlantic Ocean.NTSB ATL01FA082Accident · 2 fatalField investigationFinal reportLuscombe 8A · Resaca, GAThe certificated flight instructor's failure to maintain control of the airplane during a turning maneuver, which resulted in an inadvertent stall and subsequent collision with terrain. A factor was the loading of the airplane over maximum gross weight.NTSB MIA01LA147Accident · No injuriesLimited investigationFinal reportRussell Heyn Rans S-6 · Swainsboro, GAthe failure of the pilot to properly compensate for a crosswind and for gusty conditions during takeoff/initial climb, which resulted in an inflight loss of control and collision with the ground.NTSB MIA01LA082Accident · 4 fatalLimited investigationFinal reportBeech 36 · Tybee Island, GAThe flights entry into a descending right turn for undetermined reasons resulting in the flight crashing into the ocean.NTSB MIA00LA245Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Berlin, GAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.