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 SEA85LA039Accident · No injuriesLimited investigationFinal reportCessna 152A · Pullman, WAPlt made 10 touch and go landings and had just raised the flaps and was applying full pwr to initiate another takeoff. Noting he was rt of the centerline he applied left rudder. Acft veered sharply to the left where it slid on ice into a snowbank.NTSB DEN85LA061Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Newburg, NDPlt attempted takeoff on a slippery, snow covered field with a 45 degree x-wind. Acft veered during the takeoff ground run and left main gear sheared off after contacting a snowbank.NTSB LAX85LA096Accident · No injuriesLimited investigationFinal reportCessna 172RG · Camarillo, CAThe plt reported that upon landing a strong gust of wind caused the acft to deviate to the left. Application of the appropriate flight controls did not arrest the deviation. Brakes were applied but not in time to prevent the acft from exiting the rwy. The…NTSB CHI85LA083Accident · No injuriesLimited investigationFinal reportCessna 172M · Mt Sterling, ILThe plt landed long at his home arpt using no flaps with a prevailing tailwind. The 2600 ft turf strip was frozen. During braking the acft skidded off the rwy and struck a snow berm before rolling inverted.NTSB CHI85LA080Accident · No injuriesLimited investigationFinal reportPiper Aerostar 600 · Kalamazoo, MIThe plt reported upon touchdown, the acft contacted a patch of ice causing it to slide sideways resulting in a left main gear collapse. ATC twr witnesses stated the acft appeared fast on final and a hard landing was made.NTSB MIA85LA063Accident · No injuriesLimited investigationFinal reportBeech 58P · Deland, FLN41Q was taxiing to the ramp after landing. As N41Q taxied behind N3707N, who was starting the rt engine, propwash caused plt of N41Q to lose directional control of the acft. Prop of N41Q contacted the left elevator of N3707N.NTSB MIA85LA062Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Naples, FLAfter making a three point landing on the paved runway the pilot lost control of the acft, it veered left and ran off the rwy. The acft then struck a mound of sandy soil and nosed over.NTSB LAX85LA095Accident · No injuriesLimited investigationFinal reportPitts Special SST · Palo Alto, CADuring 3 previous touch & go landings the plt noticed a slight tendency for the acft to turn rt during the landing roll roll. He decided to make a full stop landing. During the landing the plt allowed the acft roll onto the runway shoulder. He said he was…NTSB BFO85LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Newburg, MDDuring ldg roll the PIC felt a vibration as the tailwheel contacted the rwy. In an effort to minimize the vibration the plt lifted the tailwheel off the rwy. The acft began to ground loop to the right toward a pole. Heavy application of the wheel brakes…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 SEA85LA041Accident · No injuriesLimited investigationFinal reportCessna 441 · Coeur D' Alene, IDOn takeoff run, acft drifted left of center line, left seat pilot made corrective rudder input then right seat pilot made additional corrective input. Acft yawed moderately to left and contacted a snow berm. Acft spun left 180 degrees and slid backward to a…NTSB NYC85LA046Accident · No injuriesLimited investigationFinal reportCessna 140 · Burlington, VTThe acft skidded & veered left during the landing roll, & subsequently, it nosed over on the rwy.NTSB SEA85LA045Accident · No injuriesLimited investigationFinal reportCessna A152 · Deer Park, WADuring landing practice on an instructional flight at an uncontrolled arpt, acft was being taxiied back for takeoff after a full stop landing. Surface was icy and snow-covered. Student was practicing directional control exercise with rudder. Acft skidded and…NTSB NYC85LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAPlt stated that after a normal crosswind touchdown, the tail section did not drop as expected, but rose and veered left. Acft swerved and flipped inverted.NTSB CHI85LA071Accident · No injuriesLimited investigationFinal reportCessna 182K · Lincoln, ILThe plt lost directional control during the landing roll. The acft veered to the right, rolled through 60 ft of sod, struck a dead furrow & nosed up. Winds were from 230 degrees at 13 KTS. The plt stated he should have used more rudder for cross wind…NTSB LAX85LA077Accident · No injuriesLimited investigationFinal reportCessna 177RG · Santa Maria, CAAfter touchdown on a touch-and-go lndg, acft veered left and left wing came up, raising left wheel off ground. Plt corrected with aileron and added power for go-around but acft was off runway and traversing soft terrain; lift-off speed was not attained and…NTSB DEN85LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Nucla, COAccording to the plt, after landing on centerline brakes were applied and ice on the rwy caused the acft to veer left. An abort was initiated but realizing that the acft was going off the side of the rwy the plt secured the eng. The nose gear collapsed as the…NTSB DEN85LA041Accident · No injuriesLimited investigationFinal reportGulfstream Aerocommander 695 · Cortez, COThe accident acft was the first to use the rwy since it was scraped by the snow plow earlier in the day. A commercial plt that operates at the arpt said about 2-3 inches of snow had accumulated on the rwy since it was cleared. The plt of the accident acft…NTSB DEN85LA039Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Conrad, MTPlt stated takeoff was being made on a dirt trail, heading 270 degrees, with a 20 kt headwind. Just prior to rotation wind shifted to a direction from the south-southwest. Acft drifted off right side of trail, contacted a ditch and nosed over.NTSB ATL85LA051Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Fremont, NCThe student plt reported that he landed hard & bounced twice before settling to the rwy. He applied full braking & the acft skidded off the end of the rwy.NTSB NYC85LA038Accident · No injuriesLimited investigationFinal reportGulfstream 690B · Millinocket, MEPlt stated that after touchdown, acft began a left drift. As plt applied corrective input, he noted the left wheel was in a snow windrow, so additional input was made to break wheel free of window. Left wheel crossed windrow as acft swerved right but plt was…NTSB LAX85LA060Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Chino, CAWhen the plt received ldg instructions the wind was reported as being calm. During ldg flare on rwy 26, at 2 ft AGL, a gust was encountered. The gust was from the acft's 7 o'clock position & the plt was unable to maintain control of the acft. He stated that…NTSB FTW85LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKAfter touchdown flaps were raised and power added to takeoff during the touch-&-go landing. The solo student pilot was unable to maintain birectional control of the acft and it went off the left side of the asphalt rwy. The acft nosed overafter colliding with…NTSB ANC85LA028Accident · No injuriesLimited investigationFinal reportCessna 185 · Nome, AKThe acft crashed during takeoff in gusty wind conditions. The acft reportedly hit a snow drift during takeoff and veeredoff the road being used as a rwy. The acft flew a short distance before impact.NTSB FTW85LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Lagrange, TXFor unknown reasons the plt aborted the takeoff. Directional control was lost and the acft rolled into a parked acft. The private plt received his rating 2 days prior to the accident.NTSB FTW85LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXShortly after touchdown on a full stop landing directional control was lost and the acft went off the left side of the 5,000 x 100 ft rwy. The aircraft collided with and came to rest in a ditch on the north side of the runway. Winds were northeasterly at 10…NTSB BFO85FA007Accident · 1 fatalField investigationFinal reportQuickie Q2 · Clinton, MDThe acft was making its first takeoff following several previous hours of taxi tests. Witnesses reported that the airplane drifted to the left early in the takeoff roll until the left main wheel dropped off the rwy. The acft yawed to the left and continued…NTSB LAX85LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Paso Robles, CAStudent plt stated, while landing a 45 deg x-wing picked up the wing and flipped acft over. Plt was on a solo x-country flt.NTSB CHI85LA061Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Sterling, ILThe acft ground looped & cartwheeled while landing during a personal flt. The plt lacked experience in tailwheel type acft.NTSB MIA85LA048Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Jacksonville, FLThe student plt stated that he was practicing a 'run on' landing. The acft was on the ground and the weight shifted foward on the skid, the right skid dug into soft sod and rolled over. The plt had accumucated a total time of 20 hrs of flt time.NTSB NYC85LA035Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Millbrook, NYPlt stated that while taxiing off the runway onto the taxiway, a gust of wind caused the acft to drift left. Plt stated he over corrected with rudder and power; acft swerved right, off the narrow prepared surface and down a steep embankment.NTSB MKC85LA027Accident · No injuriesLimited investigationFinal reportTemco GC-1B Swift · Fulton, MOThe acft left the rwy collided with a pile of brush and nosed over during takeoff. A x-wind of 90 degrees at 8-14 KTS affected the takeoff. The plt said he delayed the abort too long after the acft started heading off the rwy thinking he could become airborne.NTSB MIA85LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Cross City, FLPlt stated that after touchdown as braking was initiated the acft began to pull to the left. Right brake was applied with no correcting effect. The acft ran off the left side of the runway and the landing gear collapsed. Post crash exam of brakes revealed no…NTSB DEN85LA031Accident · No injuriesLimited investigationFinal reportCessna 150E · Wallsburg, UTThe acft swerved off the rwy and nosed over after colliding with a dirt bank and a ditch. The plt said that at touchdownon the gravel ranch strip he felt a bump and the acft veered to the edge of the rwy. He added that power was applied forthe go-around but…NTSB DEN85LA030Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Oaks, NDPlt stated that immediately after touchdown, the right wheel seemed to drag. Right drift was initially corrected by use of opposite aileron to reduce weight on right wheel and rudder for directional control. However, as the acft slowed weight settled on the…NTSB LAX85LA044Accident · No injuriesLimited investigationFinal reportCessna 185F · Glendale, AZThe acft went to the left of the desired track for takeoff and the plt said that in the attempt to regain directional control by means of throttle manipulation and brake application (the plt in later inspection of rwy and brakes reported rubber marks on the…NTSB CHI85LA094Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Holland, MIThe plt stated that a slight rudder pedal misalignment caused the acft to run off the rwy & into a ditch during the takeoff roll. He stated that during the first part of the takeoff roll the rudder 'did not respond normally or as expected.' A later…NTSB FTW85LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Denver City, TXPlt cited gust on landing caused acft to drift to right, plt visual acuteness reduced by landing into setting sun. Corrective control input of left aileron was excessive, causing left wing to drop to ground contact. Acft pivoted about left wing tip and came…NTSB CHI85LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Alton, ILWhile on a solo training flt, the student plt flew from centralia to Alton, IL, & entered the traffic pattern to land onrwy 11. The wind was reported from 170 deg at 12 KTS gusting to 20 KTS. During the apch, the acft was blown to the left side of the rwy…NTSB ANC85LA013Accident · No injuriesLimited investigationFinal reportMaule M-6 · Homer, AKShortly after touchdown the acft veered left. Right rudder was applied causing the acft to over correct back to the right. In an effort to regain directional control left rudder was applied. The acft ground looped to the right collapsing the left main landing…NTSB LAX85LA031Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Chandler, AZThe student plt started to retract the flaps during a touch-&-go landing with a CFI on board the acft. The acft veered and the CFI took control. During this time the student applied the brakes. The right main landing gear went into the dirt and the acft nosed…NTSB CHI85LA026Accident · No injuriesLimited investigationFinal reportBeech G-18S · Belleville, MIAfter reaching 75 KTS on takeoff roll, the acft ground looped to the left, shearing the main landing gear in side overload. Plt stated left gear seemed to be dragging. Investigation revealed no evidence of pre-existing brake/wheel malfunction or failure.NTSB CHI85LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Berlin, WIThe plt stated that he attempted to takeoff from a grass strip that is priented north and south. He described the grass as being 'too long' and the wind was from the west. The plt over rotated the acft to raise the nose wheel clear of the grass and was unable…NTSB LAX85LA026Accident · No injuriesLimited investigationFinal reportHarvard MK IV/AT-6 · Apple Valley, CAPlt had executed successful crosswind landing and was decelerating on roll-out when a gust of wind caused the acft to swerve into the wind. Directional control could not be regained with rudder so plt elected to attempt go-around. Acft became airborne in…NTSB ANC85LA007Accident · No injuriesLimited investigationFinal reportCessna A185E · Shulin Lake, AKThe acft nosed over during a water landing. This acft had wheels in the floats and one of the wheels was not retracted for the water landing. These gear are hand retracted by the plt. The plt said he checked visually to insure the left gear was up but did not…NTSB DEN85LA011Accident · No injuriesLimited investigationFinal reportHelio Courier · Livingston, MTPrior to the attempted takeoff fss advised the plt of wind from 250 deg at 20 gusting to 30 KTS and informed him that rwy 26 would be the preferred rwy. The plt elected to use rwy 22. During the takeoff roll the right wing rose in a gust but control was…NTSB LAX85LA021Accident · No injuriesLimited investigationFinal reportCessna 172RG · El Monte, CAThe plt landed the acft fast & lost control. Subsequently, the acft went off the right side of the rwy & struck a perimeter fence.NTSB FTW85LA016Accident · No injuriesLimited investigationFinal reportCessna 172P · Stillwater, OKPilot had returned to his home airport after aborting a business flight due to weather. After landing, the pilot was taxiing from the active runway when the aircraft flipped inverted due to strong gusting winds. The wind was reported by the pilot to be…NTSB LAX85LA018Accident · No injuriesLimited investigationFinal reportCessna R172 · Corning, CAThe plt reported that during a landing on rwy 34, the acft encountered a x-wind gust & was pushed off the rwy. It subsequently collided with a ditch & was damaged. The plt reported that the wind was from 300 deg at 16 gusting 22 KTS.NTSB LAX85LA017Accident · No injuriesLimited investigationFinal reportCessna 150M · Camarillo, CAPlt lost directional control of acft just prior to takeoff rotation. Acft continued off left side of rwy into a plowed field despite attempted remedial action. Nose gear collapsed.