NTSB investigations, AL
57 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 4 |
| 1986 | 2 |
| 1988 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 3 |
Where
Latest 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\" = 'AL' 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\" = 260)
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" = 'AL' 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" = 260) 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 MIA08CA030Accident · No injuriesData collectionFinal reportCessna 172N · Talladega, ALThe pilot's failure to maintain directional control of the airplane.NTSB DFW07CA136Accident · No injuriesData collectionFinal reportSandall Evan R RV8 · Wilsonville, ALThe pilot's failure to maintain directional control while landing.NTSB ATL07CA080Accident · No injuriesData collectionFinal reportRans RV-4 · Selma, ALThe pilot's failure to maintain directional control during landing roll.NTSB ATL07CA003Accident · No injuriesData collectionFinal reportHadwise Varieze · Enterprise, ALThe pilot's improper starting procedure, which resulted in an uncommanded aircraft movement and collision with a hanger.NTSB ATL06CA075Accident · No injuriesData collectionFinal reportCessna C172S · Muscle Shoals, ALThe student pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB ATL06CA012Accident · No injuriesData collectionFinal reportCessna 150 · Monroesville, ALThe pilot's failure to maintain directional control, which resulted in a loss of control and collision with trees.NTSB ATL05CA125Accident · No injuriesData collectionFinal reportCessna 172P · Monroeville, ALThe student pilot's failure to maintain directional control and the subsequent collision with the ground during landing.NTSB ATL05CA123Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Shorter, ALThe pilot's failure to maintain directional control, which resulted in the collapse of the left main landing gear.NTSB ATL05CA036Accident · No injuriesData collectionFinal reportChampion 7-GCAA · Talladega, ALThe binding right wheel brake that resulted in a loss of control during landing roll. A factor was the drainage ditch.NTSB ATL04CA131Accident · No injuriesData collectionFinal reportCessna 172 · Meridianville, ALThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with the ground.NTSB ATL04LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Montgomery, ALThe pilot's inadequate compensation for wind and his failure to maintain directional control during landing roll that resulted in the collapse of the nose gear. The crosswind was a contributing factor.NTSB ATL03LA076Accident · No injuriesLimited investigationFinal reportLarry Woods Venture · Fort Payne, ALThe pilot's failure to maintain directional control during the landing roll.NTSB ATL03LA032Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Geneva, ALThe pilot's failure to achieve takeoff due to a mistrimmed elevator, and his failure to maintain directional control.NTSB MIA03LA010Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Pell City, ALThe pilot's failure to maintain directional control following landing touchdown, resulting in a runway excursion and collision with a ditch off the left side of the runway.NTSB MIA02LA130Accident · No injuriesLimited investigationFinal reportBeech B50 · Clanton, ALThe pilot's failure to maintain directional control of the airplane during an aborted landing that resulted in a ground swerve and the airplane exiting the runway and collided with a fence, incurring damage.NTSB ATL02LA098Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tuscaloosa, ALThe pilots loss of directional control during landing roll, and subsequent inadvertent ground loop.NTSB MIA01LA092Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30A · Sylacauga, ALThe pilot's failure to maintain directional control during landing rollout, and the subsequent runway excursion and collision with trees.NTSB MIA00LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-105 · Cullman, ALfailure of the pilot to maintain directional control of the aircraft during the landing rollout, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it collided with a dirt bank.NTSB ATL00LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Oakland, ALThe pilot's failure to verify that his seat was locked prior to takeoff. The subsequent bounce on takeoff enabled the seat to shift aft thereby reducing the pilot's access to controls leading to the inadvertent loss of control and ground impact with trees.…NTSB ATL00FA016Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Geneva, ALThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall and the subsequent collision with trees.NTSB ATL99LA090Accident · No injuriesLimited investigationFinal reportCessna 172M · Double Springs, ALThe pilot's failure to maintain directional control of the aircraft during landing. A factor was the pilot's lack of experience.NTSB ATL98LA106Accident · No injuriesLimited investigationFinal reportCessna 170 · Pell City, ALThe pilot's improper use of the flight controls during a crosswind landing and the improper recovery from a bounce resulted in the collapse of the right main landing gear. A factor was the right crosswind.NTSB MIA98LA207Accident · No injuriesLimited investigationFinal reportMooney M-20J · Alexander City, ALThe pilot's failure to maintain directional control of the airplane during landing rollout and attempted go-around, resulting in departure from the runway and collision with adjacent brush and trees.NTSB MIA97LA153Accident · No injuriesLimited investigationFinal reportCessna 182P · Mobile, ALthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during landing rollout, which resulted in a collision with a runway light.NTSB ATL96LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bessemer, ALThe dual student's failure to maintain control of the aircraft during landing, and the flight instructor's failure to properly supervise the flight.NTSB ATL96LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Birmingham, ALthe pilot's failure to maintain directional control during landing,NTSB ATL96LA002Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Decatur, ALThe student pilot's failure to maintain directional control during an aborted takeoff attempt. A factor was the stripped throttle knob threads.NTSB ATL95LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Bessemer, ALThe pilot's failure to maintain directional control during a touch and go landing.NTSB ATL95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Meridianville, ALThe failure of the student pilot to maintain directional control of the aircraft.NTSB ATL94LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Headland, ALThe failure of the student pilot to maintain control of the aircraft during a crosswind landing.NTSB ATL93LA048Accident · No injuriesLimited investigationFinal reportCessna 120 · Bessemer, ALThe failure of the pilot to maintain directional control during take off.NTSB ATL93LA042Accident · No injuriesLimited investigationFinal reportPitts S2B · Tuscaloosa, ALThe failure of the pilot to maintain directional control of the aircraft, during the take off roll. A factor was the wind gust.NTSB ATL92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-22T · Headland, ALThe pilot's improper evaluation of wind conditions and selection of the wrong runway, which resulted in a loss of control during the landing roll. A factor to the accident was a gusting tail wind.NTSB ATL92LA158Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ft. Payne, ALThe pilot's improper procedure, in that he failed to raise the flaps following the short field landing, as prescribed in the pilot's information manual, which resulted in a loss of directional control. Factors were the tall grass adjacent to the runway, the…NTSB ATL92LA059Accident · No injuriesLimited investigationFinal reportCessna 310R · Tuscaloosa, ALThe instructor's inadequate supervision and the student pilot's failure to follow instructions.NTSB ATL91LA058Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Union Springs, ALThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve.NTSB ATL90LA184Accident · No injuriesLimited investigationFinal reportCessna 152 · Dothan, ALThe student pilot's selection of the wrong runway and the subsequent loss of directional control during takeoff. The pilot's improper usage of flight controls, presence of crosswind conditions, and his overall lack of experience were factors in the accident.NTSB ATL88LA237Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Eufaula, ALThe plt reported that he landed on a grass strip adjacent to the paved rwy, to 'save the (airplane) tires' from excessive wear. He stated that the airplane groundlooped during the rollout when it encountered a hole in the turf. A mechanic who examined the…NTSB ATL88LA201Accident · No injuriesLimited investigationFinal reportCessna 172M · Meridianville, ALThe plt reported that he attempted to make a touch and go ldg at the departure arpt before heading out on the first leg of a cross-country flt. The airplane encountered a gust of wind at touchdown and veered off the side of the rwy. The airplane subsequently…NTSB ATL86LA256Accident · No injuriesLimited investigationFinal reportCessna 310J · Bessemer, ALWhile taxiing for takeoff the plt attempting to taxi between two rows of parked acft. He used the left brake to maneuver the acft between the rows and could not stop the turn by using the right brake. The acft continued in the turn and struck a parked Cessna…NTSB ATL86LA268Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Roanoke, ALReportedly, during the landing roll, the acft went off the right side of the rwy and continued across a shallow ditch and down an embankment. The plt stated that the acft did not RESP0ND to control and brake inputs to correct the swerve in calm winds. The FAA…NTSB ATL86LA019Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Sylacauga, ALDuring takeoff ground run the plt lost directional control of the acft which ran off the side of the rwy and into a grove of trees. The plt stated that the right eng lost pwr, however, the eng was test run after the accident and no discrepancies were noted.NTSB ATL85LKG13Accident · No injuriesFinal reportCessna 182N · Panala, ALThe acft collided with a tree during lndg which pulled it to the left off the road chosen for landing. The plt applied pwr to clear a ditch and the acft came to rest in a row of small trees. The plt had said the eng had started missing after takeoff from the…NTSB ATL85LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Andalusia, ALThe student plt reported that during a landing roll, the acft veered to the right, went off the right side of the rwy & collide with a dirt bank.NTSB ATL85LA158Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Greenville, ALThe plt stated that he made a normal apch for a full stop, 3-point landing. During the landing roll, the acft began to vibrate & shake laterally. The plt reported that the vibration was caused by a tail wheel shimmy, but at first, he did not realize what…NTSB ATL85LKG02Accident · No injuriesFinal reportCessna 172N · Tuscaloosa, ALThe acft veered to the left during the takeoff ground run. The acft departed the rwy into a soft, plowed field where it momentarily nosed down before coming to rest on the main landing gear.NTSB ATL84LA178Accident · No injuriesLimited investigationFinal reportCessna 152 · Lacey Springs, ALWhen the plt was arriving at the uncontrolled arpt, no UNICOM was available, since the office was closed. The plt elected to land on rwy 24 after seeing another acft depart. The 1st apch was aborted due to gusty winds. After the 2nd apch, the acft touched…NTSB ATL84LKG03Accident · No injuriesFinal reportCessna 152 · Albertville, ALThe acft ran off the left side of the rwy during landing and nosed over. The student plt said he was practicing touch and go landings solo and lost control of the acft.NTSB ATL84LA020Accident · No injuriesLimited investigationFinal reportCessna 172 · Cullman, ALThe student plt was on his 1st solo flt. During a touch-and-go pattern, he started to takeoff, after landing, with the elevator trim in a nearly full nose-up position. He stated that after he added power to takeoff, he had to hold the nose down by applying…NTSB ATL83LA385Accident · No injuriesLimited investigationFinal reportBeech 58 · Birmingham, ALThe acft swerved off the rwy after the left tire deflated during heavy braking & the left landing gear collapsed during the swerve. The pilot stated the acft was rolling too fast after landing to make the first turn off. The pilot then applied heavy braking…