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 CHI83LA385Accident · No injuriesLimited investigationFinal reportCessna 150 · Savanna, ILThe plt reported the winds were from 160 deg at 7 KTS & that he back taxied on rwy 14 to takeoff. He reported that during the takeoff roll, he encountered a right x-wind, & when he was aprx 2/3 of the way down the rwy, the acft veered to the left. After…NTSB LAX83LA392Accident · No injuriesLimited investigationFinal reportCessna 17OA · Ramona, CAThe plt was practicing touch-and-go landings in winds that were variable at 5 gusting 10 KTS. On his 4th landing, he touched down using the 'full stall technique.' He reported that after touching down, he turned off the carburetor heat & raised the flaps,…NTSB DEN83LTM06Accident · No injuriesFinal reportJodel D11S · Bountiful, UTThe pilot landed and said it felt like he ran into standing water during roll-out. The acft veered left and went through grass, rocks and a ditch. The left gear was punched up through the wing. The right gear and the flaps were also damaged.NTSB CHI83LER04Accident · No injuriesFinal reportCessna 170A · Crystal, MNAs the plt applied brakes the acft veered off to the right. He applied left rudder & left brake to no avail, & the acft ground-looped off the right side of the rwy. The left brake outer lining was missing. There were two rivets missing & one rivet had broken.…NTSB CHI83LA382Accident · No injuriesLimited investigationFinal reportCessna 180 · Frankfort, INThe purpose of the flt was to transport 3 student parachute jumpers. After the jumpers egressed, the plt & jumpmaster returned to the arpt. During the landing, the acft hit a ridge on the grass rwy & bounced in the air. The acft then touched down in a crab,…NTSB MKC83LA186Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Storm Lake, IAThe acft ran off the right side of the rwy and collapsed the right landing gear. The acft landing on rwy 35 with the wind from the northeast at 7 to 10 KTS. The pilot said the acft turned left after touchdown and she corrected with right rudder, then the acft…NTSB SEA83LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Baker, ORThe pilot said the acft veered 180 degrees, hit a depression and then the left wing struck the ground. The pilot was landing on rwy 30 which was closed for resurfacing. The x's had been moved 50 ft off the centerline of the rwy. The acft left landing gear…NTSB CHI83LA376Accident · No injuriesLimited investigationFinal reportBeech S35 · Austin, MNThe plt started to takeoff on rwy 35 with a wind from 300 deg at 19, gusting 25 KTS. During the takeoff roll, the right door popped open & the acft veered to the left. Reportedly, the plt intended to continue the takeoff (to circle, land & fix the door).…NTSB MIA83LA198Accident · No injuriesLimited investigationFinal reportBeech H-18 · Elgin Afb, FLThe plt reported that during the landing, the acft 'snapped' to the right & attempts to recover were unsuccessful. During a subsequent ground loop, the left main gear collapsed. An exam of the fracture was made, but no signs of fatigue cracking was evident.…NTSB DEN83LA186Accident · No injuriesLimited investigationFinal reportCessna 180 · Cheyenne, WYThe acft groundlooped during takeoff. The plt stated that he incorrectly assumed a 14 kt headwind when the tower gave the 'winds light at fourteen' after previously assigning rwy light. After applying power he realized that he had a x-wind and cut the power.…NTSB CHI83LA423Accident · No injuriesLimited investigationFinal reportBeemer Pitts S-1C · Portage, WIThe acft had just been purchased & was being ferried to palatka, FL. During the landing roll at an en route arpt, the acft ground looped, and subsequently, came to rest inverted. The plt stated that this was his 1st landing in the pitts S-10 & that he was…NTSB ATL83LA317Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Broxton, GADuring arrival, the plt landed on an ag strip in light & variable wind conditions. The dirt & grass rwy was aprx 50 ft wide & was next to a fence. Reportedly, the acft drifted to the left, during the landing, until the left wheel got into a rut. Subsequently,…NTSB MKC83LA173Accident · No injuriesLimited investigationFinal reportCessna 170A · Syracuse, KSWhile the plt was making his second landing, the acft began to rock back & forth during the roll-out. He added power to correct the oscillation, but said the power had the opposite effect. He lost directional control & the acft swerved off the left side of…NTSB CHI83LA344Accident · No injuriesLimited investigationFinal reportCessna 185 · Elyria, OHDuring arrival, the plt could not contact anyone at the destination arpt UNICOM, so he elected to land on rwy 7. The wind at that time was from 190 deg at 11 knots. On the landing roll, the acft reportedly fishtailed. Subsequently, the left main gear…NTSB ATL83LA306Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDThe acft nosed over after a solo student pilot lost directional control during landing. The wind was from the south at 5 to 10 KTS. Because of the wind and turbulence the CFI had flown one pattern with him. The student made the landing without assistance. The…NTSB LAX83FVD05Accident · No injuriesFinal reportTrager Goldwing · Kingdon, CAThe plt was flying a registered, home built, ultralight acft that had just been certificated. The 1st flt was made earlier on the date of the accident. The plt stated that he made 10 landings at lodi, CA, with the wind about 20 deg off the rwy heading at 3 to…NTSB LAX83LA368Accident · No injuriesLimited investigationFinal reportPiper PA-28RT · Novato, CAThe acft left the rwy during landing and collided with a dirt embankment. The plt was practicing takeoffs and landings. The tower had advised him that rwy 13 was in use and there was right crosswind. During the 3rd landing as the plt was raising the flaps he…NTSB DEN83LA179Accident · No injuriesLimited investigationFinal reportCessna 305A · Minot, NDThe acft swerved off the rwy into a ditch after bouncing during landing. The pilot said he was cleared to land on rwy 13THE winds were from 290 degrees at 4 KTS. The pilot said a gust of wind (none reported) hit the acft during flare for a 2 point landing.…NTSB ATL83LA300Accident · Minor injuriesLimited investigationFinal reportBeech D18S · Revenswood, WVAfter returning from a sport parachuting flt, the plt landed on rwy 3 with a 5-KT, right x-wind. He stated that the touchdown was normal, but when the tailwheel came down at aprx 40 KTS, the acft started to turn to the left. He corrected with right rudder &…NTSB FTW83LA356Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Lordsburg, NMThe acft groundlooped off the rwy during landing. When the plt attempted to steer the acft back onto the rwy the left main landing gear collapsed. The plt had landed on rwy 30 and after landing the acft went off the left side off the rwy. The plt then steered…NTSB ANC83FA134Accident · No injuriesField investigationFinal reportCessna 150 · Anchorage, AKThe acft during taxi to takeoff in a wind of 11 KTS gusting to 19 KTS suddenly went off the taxiway into a 30 ft deep open ditch. This was a dual instructional flt and there was apparently no mechanical malfunctions even though the CFI stated that this acft…NTSB NYC83LA195Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Hunter, NYThe plt reported that during the landing roll, the acft swerved to the left when he applied brakes. Subsequently, the acft went onto downward sloping terrain & the left main gear failed. An exam of the braking sys revealed that the right brake cable had…NTSB FTW83LA359Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Houston, TXThe acft collided with an unoccupied pickup truck during the landing roll. The truck was parked off the left side of therwy. The acft had started drifting right during the landing flare. As the acft touched down the student was correcting back to the left…NTSB LAX83LA324Accident · Minor injuriesLimited investigationFinal reportBoeing IB75A · Tracy, CAAccording to the operator, the pilot lost directional control about 1200 ft down the rwy, lifted off prematurely and was unable to clear trees in an almond orchard at the end ofthe rwy. Initial impact occurred 120 ft north of the rwy centerline.NTSB ANC83LA136Accident · No injuriesLimited investigationFinal reportHelio H-295 · Fairbanks, AKThe plt reported that during the landing roll, the left brake failed & the acft ran off the right side of the rwy. Reportedly, the acft was damaged when it went off the gravel rwy at or near the departure end. No malfunction or failure of the brake assembly…NTSB NYC83LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oak Bluffs, MAThe plt report that during the landing roll, he encountered a bump on the rwy & the acft became airborne aprx 5 to 10 ft. he elected to go around rather than continue the landing since there was not enough room to recover & stop safely. While attempting to…NTSB DEN83LA171Accident · No injuriesLimited investigationFinal reportCessna 182P · Gunnison, COThe acft collided with a drainage ditch and collapsed the nose gear during landing. The pilot stated the landing was normal but during rollout he elected to retract the flaps, turn off the carbuertor heat and open the cowl flaps. At thistime the acft veered…NTSB ATL83LA284Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B-450 · Hollandale, MSThe acft swerved and nosed over during landing. The pilot stated that on landing the tire blew and directional control was lost. Post accident examination showed the left tire was flat. It was also noted that the tire was worn excessively which allowed tube…NTSB NYC83LA183Accident · No injuriesLimited investigationFinal reportCessna C140 · Plattsburgh, NYThe acft groundlooped following separation of the right wheel and axle during a practice short field landing. Examination revealed two of the four axle attaching bolts were stripped and missing.NTSB DEN83LA169Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Cody, WYThe acft groundlooped during landing and damaged the landing gear. The pilot had 80 hours in tailwheel acft but only 1.6IN the accident make and model. The landing was on rwy 22 and the wind was from 130 degrees at 10 to 12 KTS. The plt slipped the acft on…NTSB MKC83LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Nebraska City, NEThe student plt lost directional control during a takeoff on his 2nd solo flt. He reported that as he started the takeoff, the acft began moving to the left of the rwy, so he applied right rudder, but too much, then too much left rudder. Subsequently, the…NTSB SEA83LA151Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Ellensburg, WAThe acft nosed over during an aborted takeoff. The pilot stated that the acft was subjected to a gusty tailwind just before takeoff and the acft started to skip and skid with the nose to the left. The pilot started abort procedures and said the tail of the…NTSB ATL83FIA03Accident · Minor injuriesFinal reportPiper PA-32-300 · Ft. Washington, MDDuring arrival, the acft was landed on rwy 6 on a dark night. The plt stated that the airspeed indicated 85 KTS as the acft was over the rwy numbers, and after a normal landing, he applied both brakes. He reported that as soon as he applied brakes, the acft…NTSB NYC83LA181Accident · No injuriesLimited investigationFinal reportCessna 140 · Londonderry, VTThe plt reported that during a landing on rwy 23, the acft difted off the rwy when he did not allow for a x-wind. A go-around was initiated. However, the landing gear contacted a mound of dirt & the acft nosed over while it was at full throttle. Reportedly,…NTSB CHI83LA316Accident · No injuriesLimited investigationFinal reportCessna 188-B · Springfield, MNThe acft crashed into a cornfield during a takeoff to spray crops. The pilot stated that there were no mechanical problems with the acft. Investigaiton showed that the pilot attempted a takeoff on rwy 31 with a 5 kt tailwind. The acftdid not become airborne.NTSB CHI83LA290Accident · Minor injuriesLimited investigationFinal reportEipper MX-2 · Pylmouth, INThe acft was taking off for dual instruction when a gust of wind picked up the wing and the aircraft cartwheeled ending on the nose and rt. Wing. The instructor stated that as the acft accelerated a sudden gust of wind caught the acft from the left. The…NTSB LAX83FVG14Accident · Serious injuriesFinal reportSikorsky S-58 · Biggs, CAThe plt reported that he brought the helicopter to a hover in the loading area & eased forward to the rwy where he attempted to 'transition from a hover to flt.' He became aware that the helicopter was not going to have sufficient performance, so he elected…NTSB CHI83LA320Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mason, MIThe student & instructor plt (CFI) were practicing landings in the student's acft, which was equipped with brakes only on the left side. Reportedly, the student flared high during a landing & the CFI added power to recover. After touchdown, the roll-out was…NTSB NYC83FA173Accident · No injuriesField investigationFinal reportRockwell NA-265-65 · Flushing, NYThe acft was observed to land fast & long. Tire marks on the rwy revealed that the acft started to veer left from the rwy centerline about 5,475 ft down the rwy. At about 6,150 ft down the rwy the acft exited the left side of the rwy & collided with a chain…NTSB FTW83LA331Accident · No injuriesLimited investigationFinal reportCessna 180 · Lubbock, TXThe acft groundlooped during landing after control was lost during a downwind landing. The acft landed on rwy 26 and thewind was reported from 090 degrees at 10 KTS. The plt reported that a gust of wind caused the acft to veer left and control was lost.NTSB CHI83LA306Accident · No injuriesLimited investigationFinal reportCessna 150J · Hibbing, MNThe acft collided with a ditch during takeoff roll. The takeoff was on rwy 31 with the wind from 270 degrees at 8 KTS. The plt said that at 30-40 mph he lost directional control and swerved off the rwy into a drainage ditch. The rwy was 150 ft wide and made…NTSB MKC83LA151Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Scottsbluff, NEWhile the student plt was making his first supervised sold landing, the acft veered left at touchdown. The plt applied power for a go around & the left wing contacted the ground off the rwy spinning the acft around.NTSB CHI83LA302Accident · No injuriesLimited investigationFinal reportBoeing B75 · Cincinnati, OHThe acft collided with a ditch during landing roll and nosed down. The weather was VMC with the wind from 020 degrees AT6 KTS. The plt landed on rwy 24. About 1500 ft from the threshold the acft veered off the rwy and hit the ditch. The pltattributed the loss…NTSB ANC83FA120Accident · No injuriesField investigationFinal reportCessna 305E · Eielson Afb, AKAccording to the plt the wind was variable from 210 to 240 deg at 2 gusting 8 KTS. While landing on the wide rwy (31), he touched down on the right side & was angling to the left to minimize the x-wind component. After touchdown, the acft veered to the left &…NTSB ANC83FA119Accident · Serious injuriesField investigationFinal reportCurtiss C-46A · Bettles, AKJust after touchdown the acft rolled over a frost heave on the rwy surface and began veering to the right. The plt applied left brake and added pwr to the right eng but the acft continued going right until the right wing struck a hill adjacent to the right…NTSB NYC83LA169Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Durhamville, NYAccording to the plt, the acft touched down aprx 500 ft down the rwy, and after rolling aprx 200 ft, it encounter a strong gust. Subsequently, the acft veered left & went off the runway. The plt simultaneously applied full power as the acft hit an embankment.…NTSB LAX83LA329Accident · No injuriesLimited investigationFinal reportCessna TU206G · Lovelock, NVDuring a cross country a change of course around some adverse weather put the acft in the vicinity of Lovelock, NV. Since fuel was marginal for completion of the flt the pilot decided to land at Lovelock for fuel. As the flt neared Lovelock the pilot could…NTSB CHI83LA305Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Berrien Springs, MIThe plt reported that when he landed, the wind was variable from west to north at 12 to 15 KTS. He stated that after touchdown, he held the tail up in the slip stream. Reportedly, directional control was good until the acft entered an area that was not…NTSB LAX83LA323Accident · No injuriesLimited investigationFinal reportCessna 180A · Hawthorne, NVThe pilot stated that upon arrival in the Hawthorne area, the winds reported by UNICOM were extremely variable at 27 KTS gusting to 35 KTS. The UNICOM operator recommended rwy 28, then rwy 15 and finally settled on rwy 23 as the best for the wind condition.…NTSB MKC83LA146Accident · No injuriesLimited investigationFinal reportCessna 185 · Mound Valley, KSThe plt took off from a small arpt to reposition the acft on a road to pick up sky divers. During the landing, he lost control of the acft & it swerved off the road & hit a tree.