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 FTW85LA145Accident · No injuriesLimited investigationFinal reportCessna 150G · Miami, OKStudent pilot was on a solo cross country flight from siloam springs ar. To Miami, ark. And return. The pilot had landed at Miami previously. He had started his takeoff run when a wind gust caused the aircraft to veer left. The aircraft went off the runway…NTSB DEN85LA091Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Taos, NMThe plt said that he made a late decision to abort his takeoff and that he was unable to stop the acft before it ran off the end of the rwy into sage brush covered terrain. The acft sustained damage but no one was injured.NTSB ATL85LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Memphis, TNAcft bounced during lndg in 10KT x-wind. The stu plt was on his 3rd unsupvr solo. The acft went off the rwy on the rt side & collapsed the nose lndg gear. The student had 28 hrs total flt time with a logbook restriction entered by his instructor to restrict…NTSB NYC85LA073Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Utica, NYThe plt reported that during an ILS apch, he broke out & saw the arpt. However, he said that 'lake effect' was moving in rapidly. The wind was reported from 290 deg at 12 gusting 18 KTS. The plt elected to continue his apch to rwy 33 rather than circle & land…NTSB CHI85LA131Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, WIThe acft collided with a snowbank during takeoff after the plt lost directional control. The takeoff was attempted on rwy 22. The wind was from 180 degrees at 13 KTS.NTSB MIA85LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Daytona Beach, FLThe plt stated that during a landing at Daytona Beach, the acft encountered wind shear, he lost directional control & the acft veered off the left side of the rwy into the grass. During the occurrence, the prop struck the ground & the right wing tip was…NTSB BFO85LA020Accident · No injuriesLimited investigationFinal reportBellanca 7-ECA Citabria · Annapolis, MDDuring final apch to rwy 30, a go-around was executed due to a shift in wind direction, according to the plt. He subsequently entered the pattern for rwy 12, made a full stop lndg with no difficulties, and took off again for a planned touch and go on the next…NTSB LAX85LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Bakersfield, CADuring an authorized local solo practice flt, the 31-hour student was performing takeoffs and landing. According to plt, second landing was 'hard' and a nose wheel shimmy was noted during the taxi-back for takeoff. Just before liftoff on the next takeoff, the…NTSB FTW85LA128Accident · No injuriesLimited investigationFinal reportCessna 205 · College Station, TXThe acft veered to the right on touchdown. The plt was unable to regain control before the acft departed the right side of the rwy and nosed over when it entered the soft terrain. No evidence of a nose gear failure was found.NTSB DEN85LA085Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Polson, MTThe plt stated a 35 kt gust of wind from the north lifted the tail of the acft to the left. The acft veered right, contacted a snow bank and nosed over. The plt was taxiing on rwy 18 after landing when the accident occurred.NTSB NYC85LA069Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Beaver Falls, PAThe student plt was on a supervised solo flt. While landing with an 8 kt rgt x-wind, the acft veered left, went off the rwy & hit a 1 ft deep snowbank, then nosed over. No pre-impact part failure or malfunction was found.NTSB NYC85LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Jeannette, PAAfter returning to the arpt, the plt made a night landing in light & variable wind conditions. During the landing, the acft drifted left of the centerline, encountered snow & ice, & subsequently hit a snowbank & nosed over.NTSB CHI85LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Pontiac, MIThe acft nosed over after a loss of control during landing roll portion of a touch & go lndg. The low flt time student plt was practicing endings solo when control was lost and the acft left the rwy. The plt reported that he was resetting the carb heat &…NTSB CHI85LA114Accident · No injuriesLimited investigationFinal reportBeech 58 · Hibbing, MNThe acft ran off the rt. Side of the rwy into a snowbank after a hard lndg. The plt stated that he was 50 ft adh & off centerline to the left at the middle marker during the instrument approach. The passg at this time said he could se the rwy off to the rt.…NTSB CHI85LA108Accident · No injuriesLimited investigationFinal reportCessna 182P · Hamilton, OHThe acft nosed over in snow during lndg, the FAA inspector at the scene the following day found the acft off the left side of the rwy in the snow. The acft tracks indicated that the lndg was made too FAR to the left which allowed the left lndg gear to enter…NTSB CHI85LA122Accident · No injuriesLimited investigationFinal reportCessna 182RG · Mundelein, ILThe plt of this acft did not know the rwy surface condition prior to an attmpted landing. UNICOM advisories were not available. Due to a recent storm, six to twelve inches of wet snow overlying a patchy layer of compacted snow existed when he touched down.…NTSB CHI85LA117Accident · No injuriesLimited investigationFinal reportCessna 177RG · Janesville, WIThe acft collided with a snowbank during lndg. An investigation by a qualified A&P mech found the lock-o-seal in the master cylinder had improper clearance. Lack of proper clearence restricted return flow of brake fluid to the reservoir. This led to locking…NTSB DEN85LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hot Springs, SDPlt said he performed a 'hasty' preflight. During engine pre-start the plt inadvertently left the throttle open. The engine srated and the acft taxied across the ramp and hit a fence post before the plt could regain control of the acft.NTSB CHI85LA112Accident · No injuriesLimited investigationFinal reportCessna 172RG · Pontiac, MIThe acft slid into a snowbank at the end of a lndg roll on an icy rwy with a x-wind. The plt said that he did not use brakes because of the icy condition of the rwy. The x-wind weathervaned the acft to the left and into the snow alongside the rwy.NTSB CHI85LA111Accident · No injuriesLimited investigationFinal reportCessna 195B · Galena, OHThe acft nosed over when the main lndg gear hit a snowbank during lndg. Te plt stated that he had a x-wind from the rt side. He allowed the acft to drift left into the snow.NTSB CHI85LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, OHThe student pilot was given clearance to land rwy 14, but lined up & landed rwy 05 which was snow & ice covered. The pilot lost control on landing roll striking a snow bank and turning over.NTSB DEN85LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Kalispell, MTThe acft collided with a snowbank during the landing roll following a loss of directional control. The plt reported that the left brake froze or locked up when it was applied during the landing. Inspection revealed that there was a substantial amount of ice…NTSB NYC85LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · E.Milford, NJThe acft contacted a patch of ice on the rwy during landing. Control of the acft was lost and it contacted a snow bank which resulted in substantial damage.NTSB LAX85LA138Accident · No injuriesLimited investigationFinal reportBeech BE-18 · Santa Maria, CAThe plt reptd that during the landing rollout on rwy 30, a gust of wind caused the acft right wing to lift. The plt was unable to correct the uplifting wing and the acft entered into a left groundloop maneuver & exited the rwy. The local controller reported…NTSB MIA85LA094Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Ft.Lauderdale, FLThe acft landed with a x-wind component of about 25 KTS from the right. The plt and witnesses stated the wind lifted the right wing of off the rwy. Side forces resulted in the left main landing gear collapsing. Maximum demonstrated takeoff and landing x-wind…NTSB CHI85LA106Accident · No injuriesLimited investigationFinal reportCessna 150D · Siren, WIThe acft collided with a snow bank during landing. This was a solo student flt for the plt. The wind was 20 degrees off the rwy heading and varying bet 7-12 KTS in velocity. The student reported that either more brake & aileron or a running takeoff would have…NTSB DEN85LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COThe student plt lost directional control of the acft when pwr was added to takeoff during a touch and go landing. The plt stated the acft began to veer right when pwr was added and he applied 'too much right rudder' to correct. The acft veered left and…NTSB CHI85LA102Accident · No injuriesLimited investigationFinal reportCessna 421C · Bay City, MIThe acft colloded with a snowbank during lndg. The plt & passg stated that a lndg gear cught in snow piled at an intersection from plowing. The induced drag veered the acft off the rwy to the left.NTSB MIA85LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Merritt Island, FLPlt lost directional control and the acft collided with a dirt embankment while landing. The acft was landed with a right rear crosswind.NTSB LAX85LA134Accident · Minor injuriesLimited investigationFinal reportMilentz Quickie 02 · Camarillo, CAOn a local test flt for the recently constructed experimental homebuilt acft, plt experienced an on ground loss of control during the takeoff ground roll, veered off the runway and cartwheeled after encounterimg plowed furrow. Pltstated that the takeoff roll…NTSB LAX85LA133Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Big Bear, CAAfter spending the day skiing, the plt & passengers planned to depart on a return flt to san diego. The wind was from 210 to 220 deg at about 10 mph. The plt elected to takeoff on rwy 7 since low clouds were approaching from the west & the visibility was near…NTSB FTW85LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Corsicana, TXThe student plt was on a x-country flt with intermediate stops at Corsicana & terrell, TX. At Corsicana, he initiated a touch & go landing on a partially ice covered rwy. After he applied power to takeoff, the acft began to swerve. The student stated that the…NTSB FTW85LA110Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Shreveport, LAThe plt landed on rwy 05 which was icy and covered with a blanket of fresh snow. He stated the wind was from 360 degs at 10 KTS. He had been informed of poor braking conditions on the rwy. The plt used main wheel brakes and reverse thrust. The acft drifted…NTSB MKC85LA053Accident · No injuriesLimited investigationFinal reportCessna A152 · Olathe, KSThe acft collided with a snow bank on the left side of the rwy following a loss of directional control during a touch and go landing. The plt stated control of the acft was lost when he attempted to reconfigure the acft for the takeoff portion of the touch…NTSB ANC85LA043Accident · No injuriesLimited investigationFinal reportCessna U206G · Unalakleet, AKAcft veered to the left and contacted a snowbank during the takeoff ground roll. Inspection revealed plt failed to remove the rudder gust lock before takeoff was attempted.NTSB LAX85LA124Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Canyon, AZThe 50 year old private pilot, with a total of 158 flight hours, said the landing was made on the right half of the 150 ft wide rwy. As he attempted to steer to the middle of the rwy the acft skidded off the left side of the rwy and contacted a snow bank aprx…NTSB ATL85LMG02Accident · No injuriesFinal reportPiper PA-28-180 · Goldsboro, NCWhile landing at night, the acft encountered unfavorable winds & went off the left side of the rwy. After departing the rwy, it hit a drainage ditch & the nose gear collapsed. About 50 mi northwest at the raleigh/durham arpt, the wind was variable from 290 to…NTSB DEN85LA070Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Cedar City, UTThe acft nosed over after contacting a ditch following a loss of directional control during a landing roll. The plt stated that after a soft touchdown the acft began to veer to the left of the rwy. Remedial rudder pressure and braking was attemted to no…NTSB MKC85LA050Accident · No injuriesLimited investigationFinal reportCessna 150L · Beloit, KSThe student pilot stated he was practicing touch and go landings on rwy 35. After touchdown, the airplane veered left, hit a snowbank off the side of the runway & flipped forward to the inverted position. Winds were from 300 degrees at 5 knots, gusting to 10…NTSB CHI85LA093Accident · Minor injuriesLimited investigationFinal reportSaabye Cassutt Sport Racer · Lake Village, INThe acft nosed over after colliding with a snow bank during landing. A snow covered driveway, which parallels the rwy was used for landing. The driveway measures 2600'X 25' and the landing was made to the north. The acft was blown to the right during the…NTSB FTW85LA099Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Addison, TXThe plt stated that on touchdown, the acft veered left & went off the edge of the 30' wide rwy. The nose gear then collapsed in soft terrain before the plt could get the acft back on the rwy surface. At 1900 CST, the wind was from 360 deg at 30 gusting 40 KTS.NTSB LAX85LA116Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Makakilo, HIOn an air taxi flt, after landing at a prearranged site the plt signaled to his 3 pax to board the helicopter. As the pax attempted to board from the right side of the acft, the rotor blades went out of track/phase. The acft began uncontrollable bouncing up…NTSB MKC85LA054Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wa Keeney, KSAcft touched down left of centerline. Left main gear contacted slush on the rwy and the acft swerved into a 2 to 3 ft snowbank alongside the rwy. Plt stated, 'the rwy was plenty clear and the accident would not have happened if the plane had been kept on the…NTSB ATL85LA080Accident · No injuriesLimited investigationFinal reportCessna 310Q · Beaver, WVThe acft collided with a snow bank during landing ground run on an icy rwy. Plts vision obstructed by ice on windshield. Icing was encountered about 10 mins prior to landing. SIGMET and plt reports indicated the presence of icing. The plt had filed an IFR flt…NTSB MKC85LA049Accident · No injuriesLimited investigationFinal reportCessna 150A · Independence, MOPlt made two go-arounds because the acft was blown to the left of the rwy. Acft touched on third attempt, veered to the left and contacted a snowbank.NTSB LAX85LA105Accident · No injuriesLimited investigationFinal reportBell 204 · Snelling, CAPlt vacated the acft with engine at idle & with the blades turning to refuel. The landing platform mounted on the 'nurse' truck was slippery from an oil & copper mixture used in the spraying operation. The helicopter started to slide & the plt reboarded just…NTSB CHI85LA085Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Wheeling, ILThe low time pilot with six POB was ld at dark night light saw showers and icy patches on runway during rollout the acft entered a skid with nose cocked to the left the left main gear failed outboard and the acft exited the left side of the rwy the left wing…NTSB ANC85LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKPlt stated, while taxiing the wind lifted the acft twice. On the second ground contact the landing gear collapsed. Plt reported winds were from 090 degrees at 10 to 18 knots.NTSB MKC85LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Olathe, KSPilot said acft swerved to right during landing roll. Acft ran off right side of rwy into snow covered area resulting indamage to wing & gear. No evidence of aircraft malfunction was found after the accident.NTSB MIA85LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Wesley Chapel, FLThe student plt flying N94560 was making her 1st solo touch and go landing when control of the acft was lost. Upon touchdown, N94560 veered left, departed the rwy and collided with N3854D which was being taxied on the grass aprx 20 ft from the rwy.