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 SEA85LA007Accident · No injuriesLimited investigationFinal reportCessna 180 · Burley, IDAs plt initiated takeoff in a left x-wind, acft began to weathervane to the left. Increased right rudder and repeated applications of right brake failed to arrest an increasing swerve to left, with right brake pedal eventually bottoming out. As acft departed…NTSB SEA85LA006Accident · No injuriesLimited investigationFinal reportCessna 140A · Las Vegas, NVAccording to the plt he was unable to raise the tail of the acft during the takeoff and directional control could not be maintained. The plt made a hard landing in the acft on the day before the the accident. Investigators did not any flight control…NTSB SEA85LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Ashford, WAThe acft ground looped during a landing in a gusty x-wind. After directional control was lost the acft veered off the rwy striking trees. No accident report form was filed by the plt.NTSB SEA85LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Aberdeen, IDAccording to the solo student plt, while accelerating through 40 KTS during takeoff the acft began to drift to the left. The acft departed the rwy, rolled through two fences and nosed over in the soft ground.NTSB NYC85LA006Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Coram, NYPlt stated rough condition of runway surface made directional control difficult. The left wheel overran the runway edge which was bounded by a dirt ridge. Plt was unable to bring the left wheel back onto the prepared surface as ridge dimensions increase…NTSB CHI85LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Xenia, OHThe plt reported that after landing on the 3000 ft grass rwy, the acft traveled off the right & hit a ditch. No mechanical problems were evident.NTSB LAX85LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Van Nuys, CAThe student plt was on his 3rd supervised solo flt & stayed in the traffic pattern to practice landings. On the 2nd approach to land, the acft ballooned during the flare & yawed to the left. The acft touched down & immediately veered left, went off the rwy &…NTSB CHI85LA002Accident · Minor injuriesLimited investigationFinal reportBrewer Corsair · Ft. Wayne, INAfter touchdown and an initial rollout of aprx 480 ft, the acft began veering to the right. The acft departed the right side of the rwy and contacted a plowed trench, 29 ft from the rwy, where it nosed over.NTSB NYC84LA322Accident · Minor injuriesLimited investigationFinal reportGulfstream 112 · West Hampton, NYThe acft collided with the ground following a loss of control during the landing flare. As the student plt began the flare, the acft veered to the left and contacted the ground despite the application of right rudder.NTSB ANC84FA192Accident · No injuriesField investigationFinal reportCessna 305A · Anchorage, AKDuring the rollout the tail wheel began to shimmy and the acft swerved to the right and ground looped. The left wing and left horizontal stabilizer contacted the ground. Investigation revealed that the tail wheel spring ass'y was oversized and not properly…NTSB NYC84LA324Accident · No injuriesLimited investigationFinal reportCessna 140 · Harrisburg, PAAcft was landed downwind in light wind conditions by student plt. On roll-out, after normal braking was applied for deceleration, acft began to drift right. Student applied left brake as CFI also applied corrective left brake. Left brake connecting rod failed…NTSB SEA84LA232Accident · No injuriesLimited investigationFinal reportGlasair None · Burns, ORDuring the takeoff ground run the aircraft drifted to right side of the rwy. Plt attempted to correct the drift using left rudder and he stated that he over corrected for the drift and the acft began to veer to the left. The acft veered left and departed the…NTSB LAX84LA496Accident · No injuriesLimited investigationFinal reportCessna 180K · Salinas, CAThe plt stated that he landed on rwy 26 and after the acft slowed down to aprx 15 to 20 KTS, a gust of wind lifted the rt wing and the acft veered to the rt. The plt was unable to maintain directional control and the acft ground looped collapsing the left…NTSB ANC84LA188Accident · No injuriesLimited investigationFinal reportMaule M-4 · King Salmon, AKThe plt stated that after he lifted the tail off the rwy the acft encountered a gust of wind and he lost control swerving into a ditch adjacent to the rwy.NTSB LAX84LA497Accident · No injuriesLimited investigationFinal reportChampion 7FC · Merced, CADuring takeoff the plt lost control of the acft. It veered off the rwy & collided with a dirt bank. The plt indicated that his wife may have unknowingly been applying pressure to the heel brakes during the attempted takeoff.NTSB CHI84LA403Accident · No injuriesLimited investigationFinal reportCessna 150H · Indianapolis, INThe plt stated that during the takeoff roll, the window popped open. At about that time, the acft began traveling to the left side of the rwy, but the plt elected to continue the takeoff. While in a nose high attitude to takeoff, the aft fuselage contacted a…NTSB CHI84LA397Accident · No injuriesLimited investigationFinal reportBeech D 35 · Alexandria, MNThe acft was started with the throttle open after refueling. The plt said the acft collided with a gas hose before he could get the throttle reduced.NTSB ANC84LA191Accident · No injuriesLimited investigationFinal reportCessna 185 · Mt Plummer, AKThe plt stated that while landing in a crosswind, he ground looped the airplane. The acft departed the airstrip surface and rolled off the mountainside backward.NTSB NYC84LA318Accident · No injuriesLimited investigationFinal reportCessna 182P · West Mifflin, PAOn arrival at airport, plt received wind information from twr as varying from 230 to 250 degrees at 15 KTS gusting to 20 and was offerred a choice of rwy 28 or rwy 23. Rwy 23 is 100 ft wide and 2380 ft long. Plt chose rwy 28. At landing flare, acft…NTSB NYC84LA325Accident · No injuriesLimited investigationFinal reportPiper J-3 · Durham, CTThe plt attempted to land on a grass strip. The wind was reported to be from 270 degrees at 10 KTS. The plt stated that he experienced a change in wind direction and a gust. The acft then veered and collided with a stone wall.NTSB LAX84FA484Accident · 2 fatalField investigationFinal reportMooney M20C · Mariposa, CAThe acft collided with a tree & telephone pole during a go-around maneuver on rwy 26. Investigation revealed that the acft exited the left side of rwy 26 about 1625 ft beyond the threshold. Although there were no eyewitnesses to the accident a ground witness…NTSB DEN84FTE04Accident · No injuriesFinal reportHomebuilt KR 2 · Boulder, COPlt installed a different propeller on acft to increase RPM and thrust. After takeoff plt was unable to gain sufficient alt to clr trees on base leg. Precautionary landing was made on a highway. Plt applied right brake during landing roll and acft traveled to…NTSB ANC84LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Montague Island, AKPlt was attempting takeoff from a sand bar which was not only soft but sloped to the right toward the water. On takeoff roll, the tailwheel was raised prematurely and directional control could not be maintained with rudder. The aircraft drifted downslope…NTSB ANC84LA179Accident · No injuriesLimited investigationFinal reportCessna 140 · Middle River, AKPlt stated right brake pressure was lost during landing roll. Acft veered off left side of rwy and contacted trees. Post accident testing revealed no evidence of a right brake failure or malfunction.NTSB ANC84FA182Accident · No injuriesField investigationFinal reportCessna 152 II · Anchorage, AKThe student plt was performing touch-and-go lndg practice. On the second lndg touchdown, the left wing dipped. The plt applied right aileron and the acft continued toward taxi lights. Plt applied left rudder to avoid taxi lights and acft headed toward another…NTSB FTW84LA399Accident · No injuriesLimited investigationFinal reportCessna 172N · Katy, TXPrior to the accident the CFI and student were in the acft when it rolled into a bean field while landing on a road which divided the field. After pushing the acft back onto the road a takeoff was attempted. Directional control was lostand the acft nosed over…NTSB FTW84LA397Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Flatonia, TXThe plt stated he applied full power to the eng as he started his takeoff run on rwy 15. He applied forward pressure on the control yoke to raise the tail and the acft started to drift left. The rt wing hit a tree and the acft continued into a lake.NTSB LAX84LA480Accident · No injuriesLimited investigationFinal reportFocke-Wulf 44J Stieglitz · Hollister, CAThe two commercial rated pilots were flying together for the purpose of gaining proficiency so that one of the plt's could pass his bfr. The one plt who was not current performed tree takeoffs and landings from the front seat. The plts then switched seats and…NTSB FTW84LA396Accident · No injuriesLimited investigationFinal reportCessna 152 · Laporte, TXDuring the ldg flare the acft drifted left and touched down near the edge of the rwy. The plt did not correct the drift and the acft drifted off the left side of the rwy. After colliding with a ditch the acft nosed over coming to rest inverted.NTSB SEA84LA226Accident · No injuriesLimited investigationFinal reportMaule M6 · Driggs, IDAfter landing long and fast brakes were applied, directional control was lost and the acft ground looped off of the rwy. The acft collided with and came to rest in a ditch.NTSB LAX84LA478Accident · No injuriesLimited investigationFinal reportAgusta A109 · Clifton, AZThe plt reported that he landed firmly on the ground at the main ramp & went into the 2 min cool down mode for eng shutdown. He stated that immediately after the power levers were retarded to idle, he felt a slight lateral movement of the controls which was…NTSB NYC84LA309Accident · No injuriesLimited investigationFinal reportCessna 172N · Gaithersburg, MDDue to a left drifting tendency the solo student plt aborted the first landing. On touchdown for the second apch, the acft again veered left and continued off of the rwy colliding with a ditch. There were no mechanical malfunctons reported or discovered.NTSB MKC84LA274Accident · No injuriesLimited investigationFinal reportGates Learjet LR-24D · Chesterfield, MOThe acft was landed in a thunderstorm with a 16 kt left quartering tailwind. The plt was aware of an area on the rwy which tended to collect water but due to heavy precipitation this area could not be viewed from the cockpit. The left main gear hydroplaned as…NTSB FTW84LA387Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Wharton, TXAfter landing on rwy 14 the plt did a 180 deg turn and taxied back down the rwy. While attempting to turn right onto the taxiway the left main gear departing the improved surface and collapsed when it struck a concrete culvert. Brake skid marks were found on…NTSB NYC84LA312Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ellendale, DEDue to high oil temp the solo student plt elected to make a precautionary landing. During the rollout a x-wind from the right resulted in the acft drifting left off the rwy. The left wing struck soy bean plants causing the acft to spin to the right collapsing…NTSB MKC84LA278Accident · No injuriesLimited investigationFinal reportCessna C-150M · Council Bluffs, IAStudent plt departed on supervised solo flt. Later, instructor noted wind conditions at the airport had become unfavorable & advised plt by radio to divert to a specific alternate where winds conditions were favorable. Plt disregarded advice, proceeded to…NTSB DEN84LA283Accident · No injuriesLimited investigationFinal reportCessna 140 · Butte, MTThe plt taxied to rwy 11 and got out of the acft to check the wind. The rwy lights were not operating at the time. The pilot decided that rwy 11 was the most favorable rwy and the takeoff was attempted. The wind conditions at the time off the accident were…NTSB ANC84LA155Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe acft ran off the rwy during landing. The plt said he lost control of the acft and went on the grass for about 40 ft. the rear seat had been removed for cargo. A 6 year old boy in the back of the acft was seated on top of rope and cans ofgas at the time of…NTSB MIA84LA246Accident · No injuriesLimited investigationFinal reportRockwell 100-180 · Orlando, FLStudent plt stated that during landing roll, left brake failed and acft swerved into a ditch. Brakes had functioned satisfactorally during pre-takeoff taxi and run up. Investigation showed brake reservoir 1/2 full and left brake inoperative for undetermined…NTSB ANC84LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kashwitna River, AKThe plt said he was flying in a 'draw' doing some scouting for hunting when the terrain seemed to be rising faster than the acft was climbing. Without room to reverse course he elected to land on a River bank. Upon touchdown directional control was lost and…NTSB LAX84FUJ05Accident · No injuriesFinal reportGrumman American AA1 · Mesa, AZThe acft went off the rwy during a landing in a 15-25 kt wind. The plt said a gust of wind swerved the acft off the rwy. The plt attempted a go-around but realized he could not make it in the dirt so he cut the throttle. The acft rolled intoa ditch and nosed…NTSB CHI84LA379Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · New Point, INFollowing a crosswind landing on a narrow runway bordered by a corn crop on both sides, the acft rolled into an area where the x-wind was blocked by the corn. The plt failed to maintain directional control, caught a wing tip in the high corn and verred off…NTSB ANC84LA156Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Chandalar Lake, AKThe plt stated that during the takeoff roll aprx 1/2 way down the gravel strip, the acft went into brush off the side of the rwy. There were no reported mechanical malfunctions.NTSB SEA84LA214Accident · No injuriesLimited investigationFinal reportCessna 180A · Scappoose, ORThe pilot stated that during the takeoff ground run, just prior to rotation, he 'took a sharp gust of wind from the left and ground looped the aircraft.'NTSB ANC84LA162Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rohn River, AKThe acft would not lift off in the distance the plt thought. The density alt was near 1500 ft and the plt had 130 lbs in the rear seat and baggage area. The plt said that the acft bounced during the roll and then ground looped.NTSB ANC84LA161Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Slana, AKThe acft ran off of a narrow public road during landing. The plt said a gust of crosswind caught his right wing and turned the acft off the road into the bushes.NTSB LAX84LUJ02Accident · No injuriesFinal reportCessna 188A · Salome, AZThe plt said his prop stirred up a cloud of dust during takeoff and in a state of reduced visibility he collided with a mound of dirt. The collision separated the left main landing gear from the acft. Subtantial damage was done to the acft.NTSB DEN84LA268Accident · No injuriesLimited investigationFinal reportCessna 182Q · Billings, MTThe pilot was landing with a 30 degree left crosswind of 15 knots, gusting to 27 knots. On touchdown, the acft veered off the runway and nosed over. The pilot cited more crosswind training and practice as preventative actions.NTSB LAX84LA456Accident · No injuriesLimited investigationFinal reportCessna 150G · Apple Valley, CAThe student was receiving instruction in soft field landings & rudder control during the landing roll-out. A downwind approach was made to rwy 18 which had a downward gradient of 1.5%. Flaps were used for the approach & the acft touched down about 1/3 of the…NTSB ANC84LA145Accident · No injuriesLimited investigationFinal reportCessna 188 · Fairbanks, AKThe acft landed short of the rwy at a mining strip. The plt said he encountered a downdraft and in spite of the additionof full power the acft descended to the ground. The acft was loaded with 150 gallons of diesel fuel in the hopper and the plt attempted to…