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 NYC84LA082Accident · No injuriesLimited investigationFinal reportPiper PA-600 · Newark, NJThe acft was on landing roll when it began to veer from the rwy. The plt attempted to maintain directional control but the acft left the rwy and collided with a taxiway marker sign causing substantial damage to the acft. Shortly thereafter, the right main…NTSB DEN84LA087Accident · No injuriesLimited investigationFinal reportTexas Helicopter 205 · Erie, COThe plt reported that he landed on rwy 15 with a wind from O90 deg at 20 gusting 30 KTS. After touchdown, the acft began veering to the left. The plt applied right rudder & right brake, but the left wheel dropped off the left side of the rwy & went into mud.…NTSB NYC84LA084Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Easton, PAThe student plt on his first solo flt veered off the rwy into a snowbank and nosed over. The plt said a puddle of water on the rwy contributed to the beginning of the swerve and he could not recover.NTSB FTW84LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Lamkin, TXThe acft nose gear dug into the soft sod rwy and collapsed. After the nose gear collapsed the acft nosed over and slid inverted for about 100 ft. the FAA coordinator said the plt apparently forced the nose down while trying to maintain directional control.…NTSB DEN84LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe acft swerved off the rwy and collapsed the left main landing gear during landing. The plt said he believes he misused the heel brakes during the landing roll since he was more familiar with acft with toe brakes.NTSB DEN84LA084Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Dixon, WYThe acft began to wander back & forth across the rwy on the takeoff roll. The CFI took control as the acft veered to theleft. The left wheel hit a snowbank & the acft ground looped to the left substantially damaging the right wing before coming to rest. There…NTSB CHI84LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Lone Rock, WIDuring the takeoff following a touch and go landing the acft swerved to the left and collided with a snowbank. The plt said he reached for the carburetor heat control and flap handle as the acft swerved. After the collision the acft nosed over.NTSB DEN84LA078Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Billings, MTThe plt stated that during takeoff a gust of wind blew the acft to the right and he decided to abort the takeoff. Duringthe abort the acft departed the rwy, went down a bank and came to rest upside down.NTSB MKC84LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft ran off the rwy during landing and collided with a pile of debris, collapsing the landing gear.NTSB MKC84LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Jasper, ARThe plt landed the acft on private property to visit relatives. During the landing the acft groundlooped and collapsed the left main landing gear. The plt reported that the winds were from 290 degrees at 18 KTS and gusty. Rugged terrain surrounded the area of…NTSB CHI84LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIDuring a cross wind landing the acft veered left, collided with a snowbank and nosed over. The winds were gusting to 20 knots.NTSB CHI84LA096Accident · No injuriesLimited investigationFinal reportCessna 150M · West Bend, WIThe acft went out of control during the takeoff roll after a touch and go landing. The plt stated that, as he applied power and went to raise the flaps the acft began to drift to the left. When he applied right rudder the acft began to skid to the right. He…NTSB MKC84LA064Accident · No injuriesLimited investigationFinal reportMitsubishi MU 2B-20 · Ames, IAThe acft landed in a crosswind on a snow and ice covered rwy. During landing, directional control was lost and the acft collided with a snowbank. The plt stated he attempted to use propeller reversing for braking and the acft started to slide to the left.NTSB LAX84LA154Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Healdsburg, CAThe plt reported that a gust of wind pushed up the left wing & the acft veered off the rwy. The acft then went down a shallow grade & impacted bushes. He reported the wind was from 330 deg at 10 gusting 18 KTS.NTSB CHI84LA095Accident · No injuriesLimited investigationFinal reportCessna C-172P · Macomb, ILThe acft swerved off the rwy into a ditch during a crosswind landing. The wind was from 180 degrees at 10 KTS. The plt said that he lost directional control of the acft because of the wind.NTSB CHI84IA093Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-61 · Chicago, ILAs the capt applied power & released brakes to begin the takeoff, the acft started to drift to the right. The capt stated that he closed the throttles & put the #1 & #2 throttles in reverse. The acft then began to veer left & spun around nearly 1-1/2 times.…NTSB CHI84LA089Accident · No injuriesLimited investigationFinal reportGrumman AA-1A · Hawley, MNThe acft ran into a snowbank during the landing roll and flipped over. The plt stated that the right brake pedal cylinder froze but this could not be confirmed during the investigation.NTSB ATL84LA085Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Beckley, WVDuring the takeoff roll the acft traveled about 2400 ft before starting a drift to the left. It covered another 425 ft prior to colliding with a snow bank shearing off the nose gear & collapsing both main landing gear. The rwy was covered with about 4 inches…NTSB NYC84LA069Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Annapolis, MDThe plt landed faster than normal and lost control of the acft on the icy rwy. The plt said he over-corrected with left rudder and the acft went off the rwy and slid on a frozen field collapsing the right main gear.NTSB NYC84LA068Accident · No injuriesLimited investigationFinal reportCessna 150 · Seneca Falls, NYDuring the landing rollout the acft hit an icy patch of rwy and at the same time encountered a gusty crosswind. The acftskidded into a snowbank and nosed over.NTSB FTW84LA117Accident · No injuriesLimited investigationFinal reportCessna 120 · Jayton, TXThe acft nosed over during landing. The plt said he was trying to correct a veer in the tail wheel acft and may have inadvertantly used the right brake.NTSB LAX84LA139Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Montague, CAThe acft veered off the rwy and nosed over during landing. The plt acknowledged that there was no wind and the acft was 'flying ok.' He said he just lost control and ground looped.NTSB LAX84LA137Accident · No injuriesLimited investigationFinal reportRockwell 114 · Las Vegas, NVThe acft veered off the rwy in a strong gusty crosswind. As the acft left the rwy the landing gear collapsed. The plt stated that she over-corrected having never attempted a takeoff in wind that strong.NTSB CHI84LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · Port Huron, MIThe student plt lost control of the acft on a snowy rwy and collided with a snowbank. The student added power for takeoff after a touch and go landing and the acft veered to the left. The acft was not corrected before a collision witha snowbank occurred. This…NTSB DEN84LA072Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Angel Fire, NMAfter making a x-country flt from Oklahoma city, ok to Angel Fire, NM, the plt landed on a snow covered rwy at an elevation of 8382 ft. during the landing, the acft bounced, drifted to the left side of the rwy, then hit a 3-1/2 ft snowbank. The plt reported…NTSB DEN84LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · Custer, SDThe acft collided with a snow berm during landing and nosed over. The plt said they were hit by a wind shear crosswind from a valley 90 degrees to the rwy.NTSB MKC84LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Elkader, IAThe acft nosed over during landing on a snow-covered rwy after striking a snow drift. The plt said he did not see any tracks in the snow covered rwy but since there was no NOTAM closing the arpt he went ahead with a soft field landing. He said the snow…NTSB CHI84LA078Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Holland, MIThe acft contacted a snowbank during landing. After the collision the acft nosed over. The plt stated that the winds forced the acft off the centerline of the rwy into the unplowed area of snow.NTSB CHI84LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIThe plt landed left of the rwy centerline with the acft 5 degrees left of the rwy heading. He did not correct to the right and the acft collided with a snowbank and nosed over.NTSB MKC84LA057Accident · No injuriesLimited investigationFinal reportYoung-Losey Q-2 · Kansas City, MOThe acft collided with a rwy marker after bouncing during a power off landing. The acft was descended from 500 ft power off to a touchdown. The tailwheel acft bounced about 20 ft into the air. The acft went for the rwys edge and slid to a stop in the grass.NTSB LAX84LA128Accident · No injuriesLimited investigationFinal reportBeech C-45H · Coolidge, AZThe plt stated that during the initial application of power, the left eng backfired due to a possible too sudden application of power. He said that due to 'inattention' he let the acft 'drift to the left side of the runway.' Just after the acft became…NTSB DEN84LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · Limon, COThe student plt on his 2nd supervised solo flt. After returning from te local practice area, he entered the traffic pattern for a touch-&-go landing. When he added power for the takeoff portion. The acft veered to the left. The left main wheel entered deeper…NTSB MKC84LA054Accident · No injuriesLimited investigationFinal reportCessna 182 · Marion, IAThe acft collided with a snowbank after swerving during takeoff. The swerve was started when the acft hit a windblown snowdrift which changed the acfts direction. After the collision the acfts nose gear collapsed and the left main gear retracted.NTSB DEN84LA058Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ekalaka, MTThe plt stated that during touchdown the acft hit an area of patchy snow & the acft veered off the rwy into a snowbank.NTSB DEN84LA057Accident · No injuriesLimited investigationFinal reportMaule M-5-220C · Holyoke, COThe acft ran off the rwy during landing and nosed over. The plt stated that the accident occurred during a landing on rwy 17. The wind was reported as from the southwest at four KTS. The plt stated that the glide path and airspeed were good on final approach.…NTSB DEN84LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, COAfter returning from a maintenance test flt, the plt made a normal apch to land on a snow covered rwy. According to the plt & his passenger, the acft touched down along the right side of the rwy in snow. The plane then veered to the right & nosed over. No…NTSB MKC84LA048Accident · No injuriesLimited investigationFinal reportCessna 402B · Davenport, IAThe acft skidded sideways during landing on an icy rwy. The nose gear collapsed sideways when it collided with a snowbank at the rwys edge. There were no injuries.NTSB LAX84LA120Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Murrieta, CAThe acft nosed over during landing rollout. The plt reported the acft speed on final was 80 mph which is faster than normal. The acft touched down about 900 ft down the 2682 ft rwy. The landing was on rwy 15 and the wind was from 045 degrees at 4 KTS. The plt…NTSB CHI84LA068Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Michigan City, INThe acft ran off the snow covered rwy into soft ground and collapsed the nose gear. The plt said that during acceleration for takeoff he felt the left main landing gear go off the left side of the rwy. He reduced power but by this time the gear was in soft…NTSB SEA84LA028Accident · No injuriesLimited investigationFinal reportCessna A-185F II · Driggs, IDThe acft collided with a hidden snow berm while landing on a snow covered rwy. The new snow was 2 to 3 inches deep over a compacted snow base. The rwy was plowed to a width of 30 to 35 ft with 3 ft berms. The plt stated that he encountered a whiteout during…NTSB MKC84LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Iowa Falls, IAThe acft swerved and collided with a snowbank alongside the rwy during landing. The pilot stated that she hit some snow and ice on the rwy and when the acft started to slide she lost control. The acft turned left and when the left wing hit the snowbank the…NTSB DEN84LA060Accident · No injuriesLimited investigationFinal reportCessna 425 · Big Piney, WYPrior to departure the plt telephoned the FBO at Big Piney arpt. He was advised of the poor wx conditions that existed at the arpt & was also advised not to land at the arpt. The acft was later observed to land at Big Piney arpt, touch down on the snow…NTSB DEN84FA047Accident · No injuriesField investigationFinal reportPiper 602P · Rock Springs, WYThe acft swerved off the snow-covered rwy during landing. The snow plow equipment operator was unable to keep the rwy clear due to strong winds. Finger drifts developed soon after each plowing. Two foot snow banks existed on either side of the rwy. The snow…NTSB FTW84LA101Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Bellville, TXThe plt stated he landed 'a little long & a little fast.' The acft then drifted off the paved rwy into grass & soft terrain. The right wheel dug into the ground & the acft nosed over onto its back at the line of rwy lights.NTSB MKC84LA043Accident · No injuriesLimited investigationFinal reportGates Learjet 25 · Kansas City, KSDuring takeoff on a snow covered rwy at night the aircraft ran off the left side of the runway & was damaged. At that time, the rwy was covered with a thin layer of dry snow over the top of hard packed snow. A 50 ft strip had previously been plowed along the…NTSB DEN84FA045Accident · No injuriesField investigationFinal reportConvair 440 · Rock Springs, WYCombs airways, flt 709, collided with a snow bank during the landing roll at sweetwater county aprt. The capt reported that 'immediately after touchdown, the acft veered left, struck a snow bank, then veered to the right 180 deg coming to rest on the rwy…NTSB ATL84LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student plt reported he picked up a slight crosswind during his descent for landing. The acft touched down on the main landing gear wings level, started to veer left & did not respond to right rudder pressure. The plt applied max braking but the acft ran…NTSB CHI84LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hayward, WIThe acft collided with a snow bank during the landing roll and nosed over. The rwy was covered with snow and was slick. The solo student plt said he landed with more airspeed than normal and the acft started to go to the left on the rwy. The plts attempted…NTSB CHI84LA064Accident · No injuriesLimited investigationFinal reportCessna 421 · Harbor Springs, MIThe plt stated that an overboost occurred on the right eng during the takeoff roll. He pulled off power on both engs but the acft slid off the rwy into a snowbank.NTSB CHI84LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Peoria, ILThe student plt elected to make a touch & go landing on a rwy covered with loose snow & patches of ice. He reported that when he added power during his 1st touch & go, the acft veered to the left & subsequently collided with a snowbank.