NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
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.\"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."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 FTW88LA099Accident · No injuriesLimited investigationFinal reportBeech B55 · Ada, OKThe plt said all pre-flt prep were normal including an eng run-up. The takeoff was being made with light winds. After rolling about 300 ft the acft began a swerve to the rt which the plt perceived was associated with a loss of pwr on the rt eng. The plt…NTSB LAX88LA178Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Sacramento, CANTSB LAX88LA177Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Temecula, CADuring the landing roll in a direct crosswind, the aircraft began to weather vane. The pilot was unable to maintain control of the aircraft which veered off the runway where it collided with the terrain and nosed over. There were no reported mechanical…NTSB CHI88LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sault Ste Marie, MIDuring taxi for take-off, the student pilot attempted to apply brakes as he neared the end of the runway. As the aircraft veered to the left, he noted that his right foot was not on the brake pedal. The aircraft left the taxiway and struck a fire hydrant,…NTSB LAX88LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAThe student pilot's flt purpose was to practice takeoffs & landings at a different arpt. When he departed, the winds were the same as the dest arpt. The CFI felt that a weather briefing was not required. The student touched down on rwy 24 & the acft began…NTSB CHI88LA106Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Eden Prairie, MNWhile on an aircraft familiarization for purpose of check out, the pilot encountered a gusty crosswind on landing and failed to maintain aircraft control. The instructor pilot took over the controls, but was unable to regain directional control, and the…NTSB ATL88FA162Accident · No injuriesField investigationFinal reportBeech 55 · Atlanta, GANTSB LAX88LA171Accident · No injuriesLimited investigationFinal reportCessna 180B · Quincy, CAAt the end of a pleasure flight, while in the traffic pattern, the pilot noted that the winds were light and variable. While on final approach, a correction for drift was made. During the landing roll, in gusting conditions, the pilot lost control of the…NTSB BFO88LA043Accident · No injuriesLimited investigationFinal reportBeech C23 · Manassas, VAThe plt said that earlier he attempted to land at carlisle, pa and during the lndg roll he encountered a wind gust and lost directional control of the acft. The r wing raised and the acft went off the side of the rwy. The plt said he heard a loud bump as the…NTSB LAX88LA173Accident · No injuriesLimited investigationFinal reportChampion 7CCM · Cameron Park, CAWhile practicing touch and go landings, the pilot reported that a wind from behind caught the tail of the aircraft. The pilot overcorrected and ground looped the aircraft. The aircraft veered off the runway and nosed over. The pilot reported that there were…NTSB DEN88LA105Accident · No injuriesLimited investigationFinal reportCessna 185F · Erie, COThe commercial plt was practicing touch and go landings during a local flight. During landing roll on the last landing, the pilot reached down to retract landing flaps and opened the cowl flaps. He then became aware that the aircraft was turning right. Left…NTSB CHI88LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-140D · Whittemore, MIWhile landing on a farmer's strip, the pilot failed to maintain directional control of the aircraft. The aircraft swerved off the left side of the strip, into a plowed field where it struck a rock.NTSB BFO88LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Wise, VAThe student plt was on his first solo flight and attempting his second solo landing when he was unable to maintain directional control in a left crosswind. The acft drifted right and the plt attempted to do a go-around to avoid going off the side of the rwy.…NTSB SEA88LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Elko, NVDuring landing roll the pilot lost directional control of the aircraft with a groundloop resulting. The pilot had a total time of 17 hours in this type of aircraft and 152 hours total flight time.NTSB FTW88LA094Accident · No injuriesLimited investigationFinal reportCessna 182J · Lamont, OKThe pilot lost directional control while landing on an asphalt roadway near his residence. The nose wheel dug into adjacent soft terrain and the aircraft tipped over. The road was not in use by auto traffic because a bridge was out of service. It was…NTSB FTW88DQG04Accident · No injuriesFinal reportPiper PA-28-201T · Shallowater, TXThe pilot lost directional control during the landing roll with a strong left crosswind on a narrow runway. A go-around was attempted but the aircraft drifted right and received substantial damage when it touched down in soft terrain.NTSB NYC88LA134Accident · No injuriesLimited investigationFinal reportBeech C17B · Butler, PAAfter landing the airplane was taxiing on runway 08 when it went off the side of the runway and struck a runway light and taxi sign. While attempting to get back on the runway, the left gear collapsed.NTSB ATL88LA157Accident · No injuriesLimited investigationFinal reportCessna 180A · Danville, KYThe plt performed a wheel landing and attempted to hold the tailwheel off the runway surface with nose down elevator. The right wing began to lift and the acft veered to the right. Remedial control inputs were made and the left main landing gear axle…NTSB ANC88LA050Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot returned to Fairbanks int'l airport from an intended cross-country flight due to deteriorating weather. During the flight the airplane felt out of trim, and she elected to land on the longest runway available (10,300). During the landing roll she…NTSB NYC88LA115Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Walton, NYThe pilot decided to land on a sod strip. He bounced once, then lowered the nose to keep it on the ground. The prop dug into the ground and the aircraft flipped over. The pilot reported that he was practicing manuevers and wanted to practice a sod landing.NTSB ANC88LA048Accident · No injuriesLimited investigationFinal reportCessna 206 · Cantwell, AKThe air-taxi pilot stated that he attempted to takeoff from a private, dirt runway that was dry in the middle and muddy towards the edges. During the takeoff roll, the airplane's left main gear tire encountered the soft, muddy area and turned abruptly towards…NTSB ANC88LA046Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Near Central, AKThe pilot-in-command landed at the 'hot' refueling site and was attempting to exit the helicopter for a crew change. The hot refueling landing pad consisted of a black membrane with bundles of laths placed perpendicular to the helicopter's skids to prevent…NTSB NYC88LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Slatington, PAThe pilot landed at Slatington, Pennsylvania during strong wind conditions. When the pilot applied brakes, a sudden gust of wind lifted the left wing and pushed the aircraft off the right side of the runway down an embankment, and into a tree stump.NTSB NYC88LA126Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Windham, CTThe pilot took off and flew a short pattern around the airport. The pilot stated that on descent from 1200 feet strong winds started pushing the aircraft and he was losing control. The aircraft bounced and he decided to go around. However, on climb out the…NTSB MIA88LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe plt stated that as he was rolling out on the runway, the right wing lifted, and in an attempt to correct the situation, the acft went off the right side of the runway, flipped over and came to rest inverted.NTSB FTW88LA089Accident · No injuriesLimited investigationFinal reportCessna 172K · Houston, TXThe high-wing, tricycle gear airplane was taxiing out in winds gusting to 29 knots from about 320 degrees. While the airplane was heading 250 degrees, it was overturned to the inverted position. Owner's manual does not list any restrictions for maximum…NTSB NYC88LA122Accident · No injuriesLimited investigationFinal reportCessna 172 · Myerstown, PAThe pilot stated that during takeoff the aircraft veered to the left and the left wheel dug into the sod. At the same time the right wing lifted up and the aircraft rolled over. The wind was variable at 10 to 15 knots, gusting to 30.NTSB MIA88FA142Accident · Serious injuriesField investigationFinal reportCessna 172N · Vero Beach, FLThe acft was observed to touch down on rwy 36 with full flaps on the grass strip bordered on both sides by citrus groves, surface winds in the area were 120 degs at 11 KTS. The acft was observed to drift to the left off the rwy toward the grove. The plt…NTSB MIA88LA145Accident · No injuriesLimited investigationFinal reportCessna 140A · Lakeland, FLWhile on a personal flt during the landing roll after the plt applied the brakes, the acft nosed over & came to rest inverted. He stated that the left brake locked up & after the acft was removed from the rwy, he disassembled each brake assy in an effort to…NTSB ATL88LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe acft was taxiing for departure when a gust of wind lifted the left wing and the acft overturned. The surface winds were reported at 16 knots with gusts to 27 knots. The plt stated that proper flight control inputs were used for taxiing in windy conditions.NTSB MIA88LA141Accident · No injuriesLimited investigationFinal reportCessna T-188C · Miami, FLWhile taxiing from landing after a maintenance test flight, the rt main wheel assy separated from the rt landing gear strut. The acft then went off the taxiway & came to rest in the grass. Examination of the rt landing gear revealed that the spring strut…NTSB FTW88DRG08Accident · No injuriesFinal reportBoeing Stearman E-75 · Fisher, TXAfter touchdown, the pilot stated that he lost directional control and the right main gear ran off the right side of the runway. During attempted recovery, the airplane rolled off the left side of the runway, collided with a drainage ditch and nosed over to…NTSB NYC88LA124Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Warwick, NYDuring takeoff and landing practice, the aircraft veered left off of the runway despite reported full right rudder application by the pilot. The aircraft continued to roll across the grass and came to rest after colliding with a construction ditch.NTSB FTW88LA086Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Grand Prairie, TXThe student pilot lost directional control on the takeoff ground run and the aircraft was damaged after it ran off the runway. The reported weather showed a 90 degree left crosswind at 12 knots velocity with gusts to 20 knots. The plt did not file an acc…NTSB FTW88DPA03Accident · No injuriesFinal reportAir Tractor AT-502 · Olney, TXThe pilot was familiarizing himself with this type of aircraft and was making a full flap landing. He allowed the aircraft to drift left during the landing roll in a slight crosswind. He then attempted to abort the landing roll with the application of takeoff…NTSB LAX88LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Payson, AZThe pilot reported that during the landing roll a dust devil (whirlwind) pushed the aircraft off the runway, colliding with the terrain resulting in substantial damage. The pilot reported that the wind velocity was 25 knots gusting to 30 as a quartering…NTSB ANC88LA080Accident · No injuriesLimited investigationFinal reportChampion 7EC · Anchorage, AKThe private pilot lost directional control of the airplane during the landing roll. The aircraft groundlooped to the left, striking a fence. The pilot reported that he came in high and hurried his approach to fit in with the flow of air traffic at the…NTSB MIA88LA130Accident · No injuriesLimited investigationFinal reportChampion 7ECA · La Belle, FLDuring the ground run to take off, the unidentified pilot lost control of the acft. It departed the rwy, collided with a fence, nosed over, then came to rest. The identity of the plt has not been determined.NTSB LAX88LA139Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Lompoc, CADuring the landing roll with a crosswind of 15-20 knots, the pilot lost control of the aircraft, collided with the terrain and, approximately 200 yards off the runway, the aircraft nosed over.NTSB CHI88LA083Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, WIThe pilot was landing on the 40 foot wide rnwy in a 10-12 knot x-wind. He stated he had little rnwy reference in the dark night due to a very faded rnwy centerline. The acft ran off the hard surface into the mud, ran into a depression in the soil and nosed…NTSB BFO88LA032Accident · No injuriesLimited investigationFinal reportDreyer-Starduster SA-300 · Richlands, VAAfter touchdown, during the landing roll, the acft veered sharply to the left. The plt attempted to correct this action by applying right rudder and the acft veered 45 degrees to the right. The acft traveled off the right side of the rwy and came to rest on…NTSB ANC88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKAfter touchdown on a frozen lake, the aircraft rolled approximately 100 feet and at that point the pilot lost directional control and the aircraft nosed over on its back.NTSB DEN88LA085Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Greeley, COThe CFI rated plt and his CFI rated passenger were practicing touch and go landings. The plt reported that the winds were light and variable. The plt reported that the tail wheel chattered during the last touchdown, and the aircraft swerved to the left. The…NTSB BFO88LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chatham, VAThe student plt was practicing touch and go landings when the accident occurred. He stated the acft was a little high and fast on final apch. On touchdown the acft veered left and traveled off the rwy. The left wing contacted a tree and the acft spun around…NTSB NYC88LA110Accident · No injuriesLimited investigationFinal reportCessna 182RG · Princeton, NJDuring landing at Princeton, new jersey, the flight encountered turbulence in the last 500 feet before reaching the runway. The pilot initiated a go around and came in with 10 degree flaps. Aircraft touched down and rolled a few feet then lifted off again…NTSB CHI88LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Sebewaing, MIThe plt rprtd that when he landed, the acft bounced twice & went straight forward for about 200 ft. when he applied brakes, the acft veered to the left. Subsequently, the acft went off the runway & into a ditch where the nose gear collapsed. The plt believed…NTSB SEA88LA061Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Blackfoot, IDThe pilot lost directional control of the aircraft during gusting crosswinds. During landing rollout the aircraft veered from the centerline of the runway to the right striking a fence. The pilot had only 7 hours of flight time in this aircraft.NTSB MKC88LA065Accident · No injuriesLimited investigationFinal reportCessna 150J · Searcy, ARWhile landing in direct crosswind, the PIC lost directional control during the roll out. The acft veered off the runway, damaging the right wing tip and empennage. The pilot stated he thought a gust of wind caused the loss of control.NTSB LAX88LA136Accident · No injuriesLimited investigationFinal reportBell 206B · Honolulu, HIAfter touchdown the plt reduced the throttle and removed his left hand from the throttle/collective pitch control to retune the radio. His attention was directed to the frequency indicator during the procedure. The helicopter became airborne and moved to the…NTSB ATL88LA116Accident · No injuriesLimited investigationFinal reportCessna 172F · Myrtle Beach, SCThe pilot reported that the airplane began to sink rapidly about 100 ft above the rwy threshold. He added pwr and initiated a flare. Upon touchdown, the airplane pitched down and rolled rt. The airplane subseqeuntly skidded off of the rt side of the rwy and…