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 DEN87LA181Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Worland, WYThe plt said the acft bounced during landing and he lost control. The acft ran off the rwy and when the plt applied the brakes too hard, the acft nosed over.NTSB SEA87LA156Accident · No injuriesLimited investigationFinal reportBoeing IB75A · Spokane, WAThe plt rprtd that when he landed, the wind was from 190 deg at 6 gusting 12 KTS. Drg the landing roll, after slowing to an estimated 15 KTS, the acft encountered a gust of wind which caused 'the right wing to dip.' Subsequently, the acft 'rotated' about 60…NTSB ATL87DEI09Accident · No injuriesFinal reportCessna 170B · Upper Sandusky, OHDuring takeoff attempt from runway 36 the aircraft veered to the left about 250 feet from the runway threshold and contacted the ground. The pilot reported that a crosswind caught him off guard. Weather information obtained from findlay flight service…NTSB ANC87LA094Accident · No injuriesLimited investigationFinal reportCessna 185 · Aleknagik, AKThe commercial pilot and his three passengers were on a fishing trip to a remote stream in southwest Alaska. The pilot attempted to land on a beach area near the stream and nosed the airplane over. The airplane was equipped with large 'tundra' tires that the…NTSB DEN87LA176Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Bountiful, UTThe private pilot was practicing touch and go landing. The pilot reported the third landing was a wheel landing. Just after touchdown, adjacent to large petroleum tanks, the aircraft weather cocked to the right. The aircraft swerved right and departed the…NTSB NYC87LA198Accident · No injuriesLimited investigationFinal reportLake LA-250 · Alton Bay, NHThe Lake renegade 250 was making a water takeoff when it started a sharp left turn. The aircraft stopped in the water and the pilot exited without injuries prior to the aircraft turning over. Examination of the aircraft showed that the engine pylon had…NTSB SEA87LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Sun Valley, IDAfter landing touchdown, plt encountered swirling winds. Acft drifted left and into airport boundary (cyclone-type) fence.NTSB FTW87LA159Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Dallas, TXDuring flare/touchdown on runway 15, the aircraft's right wing came up sharply, due to a gusting cross wind, causing the left wing to strike the runway. The aircraft then cartwheeled, left wing, nose, right wing, causing substantial damage. Reported winds at…NTSB CHI87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Duluth, MNRprtdly, the winds were prevailing from the northeast & were variable & gusty. The plt entered the traffic pattern to land on rwy 14, but aborted his 1st attempt. During the 2nd apch, he used a notch of flaps & corrected for the x-wind by slipping the acft…NTSB LAX87LA256Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Huron, CAAt the end of a cross country flight,the plt applied the brakes on touch down. The acft veered to the left and the plt applied the right brake, however, the left main landing gear went off the edge of the rwy. The acft went out of control, exited the rwy and…NTSB ANC87LA089Accident · No injuriesLimited investigationFinal reportCessna 180 · Matanuska Glaci, AKThe pilot stated that upon touchdown on the glacier the surface was cluster snow. The aircraft rolled about 150 feet and nosed over on its back.NTSB MKC87FA130Accident · No injuriesField investigationFinal reportMitsubishi MU-2B-60 · Kansas City, MODuring a takeoff, PIC lost directional control of acft, causing it to swerve off the active runway, spin around, shearing the nose gear assembly and left main wheel. The nose wheel strut assembly careened into the right powerplant propeller causing the torque…NTSB FTW87LA157Accident · No injuriesLimited investigationFinal reportCessna 172L · Houston, TXWhile lndg, the student plt had flared the acft in a rgt x-wind with gusts to 13 KTS. Subsequently, the acft drifted left & the left main gear went into soft mud. The acft then veered to the left and was damaged.NTSB ANC87LA092Accident · No injuriesLimited investigationFinal reportPiper J-3 · Lake Creek, AKThe pilot stated he touchdowned on a gravel bar and shortly after touchdown he lost control of the aircraft causing the aircraft to nose over on its back.NTSB ANC87LA090Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Becharof Lake, AKThe pilot stated he was rolling out for takeoff when the nose wheel struck a soft area causing the aircraft to go up on its nose.NTSB ANC87LA088Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Pingo Ridge, AKThe pilot stated that after touchdown he lost control of the aircraft causing the aircraft to nose over on its back.NTSB ANC87LA085Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot stated that he lost directional control of the aircraft during the takeoff causing the plane to groundloop.NTSB MIA87LA193Accident · No injuriesLimited investigationFinal reportStinson 108-1 · West Palm Beach, FLWhile on an instructional flt during the landing roll the acft began to drift to the right. The student plt corrected the drift with left rudder, however he then added full power. The acft then ground looped to the left, during which the right main gear…NTSB DEN87LA160Accident · No injuriesLimited investigationFinal reportCessna 182RG · Deming, NMDuring the landing flare the plt reported he flared late and the acft bounced and porpoised. The plt commented and the plt rated passenger in the right seat misinterpreted the comment as a request for assistance. With two people conflicting on the controls a…NTSB BFO87LA043Accident · No injuriesLimited investigationFinal reportCessna 195A · Cambridge, MDAfter purchasing the acft in atl, the plt, who held an a & p certificate, inspected and flew the acft in the local area bfr departing on a ferry flt to rockland, ME. Drg lndg at his first fuel stop, the acft swerved to the rt and the plt intentionally…NTSB NYC87LA189Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Doylestown, PAUpon landing, the flight encountered standing water on the runway and the aircraft hydroplaned veering right of the centerline. The main landing gear collapsed causing substantial damage. The acft went off the rt side of the rwy after 2839 ft of roll and…NTSB FTW87LA154Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Baytown, TXDrg the lndg roll, the acft started to drift to the left, so the plt corrected with right rudder. He said he over- controlled, then applied left rudder & brake, followed by right rudder & brake. Subsequently, the situation became aggravated until both main…NTSB LAX87LA244Accident · No injuriesLimited investigationFinal reportNord 3202 · Bishop, CADuring a relocation flight of a newly purchased acft, the plt was making a cross wind landing when on touchdown the left wing raised. The plt corrected by applying left aileron, however, he also relaxed the back pressure on the control stick allowing the tail…NTSB SEA87LA120Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Yakima, WAWhile on landing roll in gusty crosswind conditions, the aircraft swerved off the runway and ground looped.NTSB FTW87LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Alice, TXThe pilot stated that during landing roll the right brake locked, the aircraft exited the runway, crossed a grassy area and collided with an airport light pole. Inspection of the brakes, rudder and nose wheel steering revealed no preimpact mechanical…NTSB ATL87LA178Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Augusta, GAThe aircraft was on its first flight from the factory. The pilot was checked out in the aircraft on the day prior to theaccident flight. Witnesses reported the aircraft touched down and lifted off several times. The pilot stated the aircraft got away from him…NTSB ANC87LA082Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Iliamna, AKThe student pilot stated that during a landing roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back.NTSB CHI87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Muncie, INAfter landing on rwy 32 the acft veered to the left, crossing a parallel taxiway and striking a taxiway light. The plt stated that the acft then became airborne before striking a terrain depression, at which time the nosewheel sheared off and the propeller…NTSB ATL87LA171Accident · No injuriesLimited investigationFinal reportLuscombe 8A · London, OHThe pilot was making a planned refueling stop at madison county airport. He stated he made a normal pattern entry, approach and landing. During the roll out the aircraft groundlooped to the right and departed the runway. Investigation revealed no preimpact…NTSB LAX87LA229Accident · No injuriesLimited investigationFinal reportCessna 180 · Kernville, CAThe plt rprtd that he made a precautionary landing on a remote airstrip after detecting smoke & an odor of burnt oil coming from the eng compartment. After landing, he determined the source of the odor was spilled oil on the exhaust & he elected to takeoff…NTSB ANC87FA080Accident · No injuriesField investigationFinal reportPiper PA-22 · Theodore River, AKThe private pilot elected to abort the takeoff attempt from an abandoned roadway too late to stop in time to avoid going into brush and small trees. He said he decided against the takeoff at about the mid-point in the 4000 foot gravel section of the road. The…NTSB NYC87LA173Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Canastota, NYA student pilot was performing tkofs and lndgs when after touchdown on the third landing, he lost directional control of the aircraft. After atmptg to salvage the lndg, the pilot initiated a go-around but the left wing stalled and the aircraft impacted on the…NTSB MIA87LA183Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Miramar, FLThe student plt was conducting solo touch & go ldgs when directional control of the acft was lost & the acft left the rwy & collided with a rwy designator sign during the ldg phase.NTSB FTW87LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Yukon, OKOn touchdown the aircraft started to drift to the left. The pilot applied right rudder and lost directional control of the aircraft. The aircraft's right wing contacted the runway and the aircraft nosed over.NTSB DEN87LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Los Lunas, NMThe plt reported that after touchdown, the acft swerved to the right and went into a water filled irrigation ditch. The acft nosed over and came to rest inverted. A post accident inspection revealed a deflated tail wheel which appeared to have blown out. It…NTSB DEN87LA149Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Driscoll, NDThe plt rprtd he lost directional control as he was lndg on a paved section of old highway to load chemicals. The acft swerved & went into a ditch. The left main gear collapsed & the acft came to rest back on the roadway, where it was destroyed by a…NTSB FTW87LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Arlington, TXThe dual student pilot, while on his second flight, suddenly applied full right rudder during flare/touchdown and froze on the controls while in this position. The aircraft veered off the right side of the runway into deep and soft mud before the CFI could…NTSB CHI87LA144Accident · No injuriesLimited investigationFinal reportCessna 182M · Lake Village, INThe aircraft bounced twice while landing on runway 36 and nosed over after the third bounce. Pilot reports being high on final with 20 degrees flaps so she applied full flaps and steepened glide angle. She also reports a northwest crosswind at 15 to 20 knots,…NTSB MKC87LA123Accident · No injuriesLimited investigationFinal reportBeech C35 · Spencer, IADuring ldg, PIC failed to maintain directional control and swerved off the rwy. Ldg gear collapsed and acft was substantially damaged. Witnesses said plt and pax were behaving irrationally prior to lvf departure apt. PIC left the scene of accident and two…NTSB LAX87LA232Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Rancho Calif, CAThe plt elected to make a precautionary landing due to deteriorating wx along his route of flt. He stated that there was a x-wind from the left when he landed on rwy 30. Drg the landing, the acft drifted off the rwy & one of the main landing gear mired in…NTSB BFO87DIG05Accident · No injuriesFinal reportCessna 152 · Baltimore, MDThe student pilot, who had approximately 47 hours in the aircraft and approximately 8 hours as pilot-in-command, stated that after touchdown on runway 33R the aircraft veered to the right and departed the runway and collided with a ditch. The wind was…NTSB ANC87LA076Accident · No injuriesLimited investigationFinal reportMaule M-6 · Kenai, AKThe pilot effected a go-around during an approach to runway 01 in gusty surface wind conditions. During the second approach he landed and lost control at or near the demonstrated crosswind component limit for this airplane. The airplane ground looped and…NTSB SEA87LA113Accident · No injuriesLimited investigationFinal reportCessna 172P · Snohomish, WAThe pilot initiated a landing on a 2650 ft long runway in a 11-18 knot quartering tailwind condition. He flew the final approach too fast and flared prematurely. The acft floated down the rwy, landed hard and bounced twice. The plt lost control and the acft…NTSB MIA87LA172Accident · No injuriesLimited investigationFinal reportBushby Mustang II · Cocoa, FLDuring the landing roll the plt lost control of the acft. It then departed the rwy, collided with a taxiway marker sign & came to rest.NTSB FTW87LA140Accident · Minor injuriesLimited investigationFinal reportCessna 150G · College Station, TXThe pilot stated that upon touchdown the aircraft began to shake so violently that he could not see the panel or control the aircraft. During landing roll it veered off the left side of the runway. The nose and right main gear wheels dug into the soft ground…NTSB NYC87LA158Accident · No injuriesLimited investigationFinal reportBeech 58TC · Oxford, CTThe flight was making an ILS approach to runway 36 in IMC. The aircraft touched down about 2,000 feet down the 5,000 foot runway and to the left of the runway centerline. The aircraft hydroplaned on standing water on the runway and skidded off the end coming…NTSB CHI87LA145Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Marion, INAs the student plt was making a x-wind takeoff on a dual instructional flt, the instructor (CFI) reduced the power at about 15 ft AGL to simulate an eng failure. The student reacted by raising the nose of the acft, but the instructor corrected this by…NTSB LAX87LA220Accident · No injuriesLimited investigationFinal reportRyan ST-A · Mariposa, CAAt the start of a pleasure flight, the plt reported that during the takeoff roll the acft started to veer to the left. The plt applied right rudder to correct, however, the acft did not respond before the left main left the edge of the rwy and dug in the soft…NTSB ANC87LA074Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKThe pilot landed on an asphalt surfaced runway with a Cessna 185 airplane that had been modified to accept extremely large 'tundra' tires, which are intended primarily for off-airport and gravel runway landings. The pilot lost directional control during the…NTSB ANC87LA073Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe private pilot elected to land at an abandoned arpt on an unmaintained dirt taxiway adjoining the gravel rwy inorder to reduce the crosswind component. The acft hit a soft spot during the landing roll and nosed over. The U.S. Dept of commerce's Alaska…