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 NYC88LA108Accident · No injuriesLimited investigationFinal reportCessna 182 · Batavia, NYThe acft was returning to the airport for landing after an instructional flight with a student. The student was landing the aircraft but when snow showers were encountered while flying downwind, the instructor pilot took control. He stated that he was landing…NTSB LAX88LA124Accident · No injuriesLimited investigationFinal reportCessna 180 · Corona, CAThe plt was completing a personal flt. During the landing roll the airplane began to swerve to the left. The plt reptd the rudder was ineffective due to the airplane's slow speed and she applied the brakes. Before the airplane came to a stop the left landing…NTSB NYC88LA107Accident · No injuriesLimited investigationFinal reportCessna T210M · Greene, NYDuring takeoff roll, the aircraft drifted to the right edge of the runway in a soft-field takeoff attitude. The right main gear contacted the top of a snowbank. The aircraft then yawed to the right and impacted a second snowbank where it came to rest.NTSB NYC88LA106Accident · No injuriesLimited investigationFinal reportCessna 172 · Old Town, MEFollowing rollout from a normal landing in strong winds, and during a left turn onto the taxiway, the wing of the aircraft was lifted up by a quartering tailwind and flipped over.NTSB ANC88LA042Accident · No injuriesLimited investigationFinal reportCessna 185F · Ophir, AKDuring the takeoff roll from the frozen lake the pilot lost directional control of the aircraft causing the aircraft to nose over on its back. The pilot stated during the takeoff roll the aircraft crossed a snowmachine track causing him to lose control of the…NTSB ANC88LA038Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKThe private pilot-in-command of the Piper PA-18 lost control of the airplane while attempting to takeoff from a section of snow covered river ice.NTSB SEA88LA075Accident · No injuriesLimited investigationFinal reportPiper J-3 · Newberg, ORThe pilot had not flown for over five years and was doing multiple touch and goes in order to prepare for his biennial flight review. While on a landing rollout the engine ceased operating. The pilot exited the aircraft and began hand propping the engine. The…NTSB NYC88LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Morristown, NJDuring a landing rollout, the flight encountered strong gusty crosswinds. The aircraft ran off the right side of the runway. The nose wheel dug into mud and the prop and left wing tip made contact with the ground.NTSB CHI88LA072Accident · No injuriesLimited investigationFinal reportCessna P210 · Indianapolis, INWhile landing on the ice-covered runway, the pilot failed to stop his aircraft before the end of the runway. The aircraft ran off the departure end of the runway, encountered soft terrain and nosed over. The pilot had received two partial weather briefings,…NTSB ATL88LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Statesville, NCThe airplane encountered a crosswind gust at touchdown and the student plt lost control. The airplane veered off of the side of the rwy and subsequently impacted an embankment. The student had about 8 hrs of total solo flt experience, about 6 of which was…NTSB NYC88LA095Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Burlington, VTThe flight was taking off for an instructional flight in the local area. During ground run, the aircraft veered to the left and the pilot was unable to bring the aircraft under control. The aircraft collided with a snowbank and flipped inverted. The aircraft…NTSB SEA88LA053Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Othello, WAThe student pilot encountered gusting winds and lost control of the aircraft during landing roll. The aircraft veered to the right of the runway and struck a parked unoccupied aircraft.NTSB SEA88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Yakima, WAThe pilot had just purchased the aircraft and was practicing takeoffs and landings. On the first landing attempt, during the ground roll after touchdwn, the pilot lost directional control and the aircraft ground looped.NTSB CHI88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minneapolis, MNStudent pilot stated that airplane went off runway at 50 KIAS after losing control during landing rollout. Airplane sustained substantial damaged when nose gear collapsed.NTSB LAX88LA115Accident · No injuriesLimited investigationFinal reportCessna 180A · Prescott, AZDuring the dual primary cross country flight, the student was making the approach and landing at Prescott. The CFI said that the approach and touchdown were normal, however, the aircraft began drifting to the right in a gradual turn as the aircraft slowed.…NTSB CHI88LA086Accident · No injuriesLimited investigationFinal reportMooney M-20C · Minneapolis, MNWhile executing touch and go landings the pilot's attention was diverted inside the aircraft while adjusting the interior lights to determine the position of the flaps. He lost control of the aircraft and it departed the runway striking a snow bank.NTSB BFO88LA020Accident · No injuriesLimited investigationFinal reportMaule MX7-180 · Lewisburg, WVThe plt started landing flare on rwy 22 when he encountered wind gusts. The acft swung right and the left wing struck the rwy. The acft cartwheeled and came to a stop inverted.NTSB ATL88LA099Accident · No injuriesLimited investigationFinal reportBeech 18S · Morganton, NCPIC aborted first takeoff attempt due to crosswind induced directional control difficulties. During second takeoff attempt, gusty crosswind lifted left wing & acft became airborne. PIC forced acft back onto rwy, lost directional control and veered off rwy…NTSB NYC88LA092Accident · No injuriesLimited investigationFinal reportCessna 182 · Westfield, PAThe pilot was attempting a soft field takeoff with full power and right rudder applied. During ground run, the tail of the aircraft struck a snowbank, pulling the aircraft into the snow. When the left main gear hit the snow the aircraft flipped over onto its…NTSB FTW88LA071Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Benito, TXThe student plt was making a touch and go on his second solo flt. After the flaps were retracted and the power was increased, the acft veered to the right and hit a runway light. The acft then continued into the dirt beside the runway where the nose gear…NTSB NYC88LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Rochester, NHDuring landing, the flight encountered a crosswind from the left and almost immediately the aircraft became airborne again. The pilot flared for landing, landed hard, bounced and at this time the pilot decided to abort and go around. The aircraft drifted to…NTSB ATL88LA097Accident · No injuriesLimited investigationFinal reportCessna 172 · Jackson, TNWhile returning home with his newly purchased acft the plt made a refueling stop. The winds were strong and gusting upwards of thirty KTS at the refueling arpt and the destination arpt. During the takeoff roll the winds shifted to a right crosswind. The acft…NTSB ATL88LA098Accident · No injuriesLimited investigationFinal reportBeech 77 · Concord, GAPIC obtained wx brief of high winds from northwest with strong gusts. Takeoff was from pvt strip with wind sock which showed wind aligned with rwy 01. As takeoff roll was begun wind shifted to 90 degrees left crosswind. At rotation left wing was lifted by…NTSB MIA88LA111Accident · No injuriesLimited investigationFinal reportCessna A188B · Macon, MSThe plt stated that during the takeoff roll, the left lndg gear failed causing the acft to swerve off the rwy & into a ditch bordering the rwy. An exam by FAA personnel revealed tire marks on the rwy which continued off the rwy & into the ditch. According to…NTSB FTW88LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Washington, OKThe student pilot received dual instruction in crosswind takeoffs and landings after which the instructor pilot deplaned to observe the student. The student lost directional control on the first takeoff attempt and the aircraft collided with a ditch after…NTSB ATL88LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Galion, OHThe airplane bounced during ldg, and subsequently ran off the side of the rwy into snow and nosed over. The wind conditions at the time were reportedly calm. The airplane was equipped with stc-approved conventional (taildragger) ldg gear. The plt stated he…NTSB FTW88DRA03Accident · Serious injuriesFinal reportHiller UH-12-D · Bon-Wier, TXGround crewmember's failure to follow established procedures for secureing the aircraft to the transport trailer.NTSB BFO88LA021Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Orange, VAAccording to the plt, during the landing roll the acft drifted to the right and before he could take corrective action the acft ground looped. He had 3 hrs of total time in this make/model acft. The plt rptd he was late applying corrective rudder forces. He…NTSB NYC88LA082Accident · No injuriesLimited investigationFinal reportGulfstream AA-5B · Bridgeport, CTDuring a touch and go landing, the aircraft touched down on the main gear just past the numbers. Full right aileron and left rudder was used for directional control. During rollout, the right wing came up and the left wing made contact with the runway…NTSB ANC88LA031Accident · No injuriesLimited investigationFinal reportCessna 170 · Healy, AKThe pilot stated that he was taxiing for takeoff when he lost directional control of the aircraft causing the plane to strike a small tree next to a snow covered taxiway.NTSB CHI88LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Ft. Wayne, INAirplane nosed over in soft snow during a crosswind landing attempt. The PIC tried to recover from a loss of directional control by attempting to roll out on snow covered sod after hopping over a snowbank that was next to the runway landing surface.NTSB ATL88LA092Accident · No injuriesLimited investigationFinal reportCessna 172P · Wakeman, OHThe 106 hour pvt plt reptd that he had rented the acft for a LCL flt from the uncontrolled airport. The rwy was snow and ice covered with a 12 kt wind from 240 degrees. After conferring with the LCL CFI on duty, he elected to make the LCL flt. During the t.o.…NTSB SEA88LA049Accident · No injuriesLimited investigationFinal reportPiper Aerostar 602P · Lovelock, NVThe non-multiengine rated pilot (left seat) executed a takeoff during which the aircraft developed a slight right drift. The pilot then attempted to utilize nose wheel steering to correct and a hard left swerve ensued resulting in a loss of directional…NTSB LAX88LA109Accident · No injuriesLimited investigationFinal reportCessna 185E · Redding, CAThe canadian plt attempted to land the conventional gear acft on runway 34 with the reported local wind from 330 deg at 16 KTS. The acft touched down about 2400 ft beyond the threshold of the 7003-foot-long rwy. After a bounced landing, directional control…NTSB ANC88LA030Accident · No injuriesLimited investigationFinal reportCessna 207 · Brevig Mission, AKThe pilot stated that while taxiing on the ramp perpendicular to the wind direction, a strong wind gust lifted the right wing and tail of the aircraft. The aircraft slowly turned over on its back.NTSB LAX88LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Van Nuys, CAThe student pilot was on his second supervised solo and had executed a go-around on his first attempted touch & go maneuver. The plt reentered the traffic pattern and landed on runway 34L. The airplane exited to the left of the runway onto the grass. With the…NTSB DEN88LA067Accident · No injuriesLimited investigationFinal reportCessna 180 · Roundup, MTThe private plt rancher was completing a work flt. During the flt, the plt made 5 off arpt landings in snow 5 to 6 inches deep. The landing on which the accident occurred was made at a local arpt on a snow covered rwy. During the landing, the acft sank into…NTSB MKC88LA050Accident · No injuriesLimited investigationFinal reportCessna 182RG · Texarkana, ARThe PIC claimed he was unable to start the aircraft normally. He said he couldn't remember if he properly secured the acft before attempting to prop start. As he pulled the propeller through, the acft eng revved up to a high RPM. The PIC claimed there was a…NTSB CHI88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Wis. Rapids, WIAirplane drifted left into a snowbank while rolling out from a landing on a snow and ice covered runway. Landing winds as reported by the pilot were from 60 degrees to the right of the nose at 5 to 8 knots.NTSB LAX88LA106Accident · No injuriesLimited investigationFinal reportCessna TR182 · Truckee, CANTSB SEA88LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Henderson, NVDuring ground landing roll on a touch and go practice session, the solo student pilot allowed the aircraft to drift off the side of the runway and overcorrected in the opposite direction. After applying full power to abort the landing, she realized the flaps…NTSB CHI88LA057Accident · No injuriesLimited investigationFinal reportCessna 421A · Wheeling, ILNTSB NYC88LA070Accident · No injuriesLimited investigationFinal reportCessna 195 · Meriden, CTAfter performing several touch and go landings, the student pilot made a landing right of the center line. The aircraft drifted to the right, struck a snowbank, sheared off the left main landing gear, then groundlooped. The aircraft came to rest on the grass…NTSB MIA88LA096Accident · No injuriesLimited investigationFinal reportCessna 150 · Titusville, FLStudent pilot lost directional control while landing with right quartering wind. The acft departed the left side of the runway and the nose gear bogged down in sand. The nose gear then failed aft and the acft came to rest on the nose and left wing tip.NTSB LAX88LA104Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAAt the end of a local pleasure flight, during the landing roll, the pilot lost control of the aircraft and ground looped. There were no reported mechanical failures or malfunctions of the aircraft.NTSB DEN88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Peyton, CONTSB SEA88LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172M · St. Anthony, IDDuring landing onto the 50 foot wide snow covered runway, directional control was lost with the aircraft drifting to the left of the runway, striking a snow berm, and then nosing over inverted.NTSB CHI88LA051Accident · No injuriesLimited investigationFinal reportCessna 172N · Fond Du Lac, WINTSB CHI88DEP03Accident · Minor injuriesFinal reportPiper PA-38-112 · Sheboygan, WIThe aircraft experienced a loss of control during the takeoff portion of a touch and go. The aircraft departed the runway and struck a snowbank collapsing the nose gear. The aircraft was substantially damaged.NTSB DEN88LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Duchesne, UTThe student plt was performing a cross country training flight. At his first stop, during the takeoff portion of a touch and go landing, the aircraft swerved to the left and struck a three foot snow bank on the left side of the runway. The plt reported that…