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 CHI84LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe plt stated that this was his first solo flt. During the first takeoff following a touch and go landing the acft wentoff the left side of the rwy and collided with a snowbank. After the collision the acft nosed over.NTSB NYC84LA122Accident · No injuriesLimited investigationFinal reportCessna 172M · Fitchburg, MADuring a touch-&-go landing, the student plt lost directional control. The acft landed slightly sideways on the right main gear & the right wing tip hit the ground. The right wing, prop, eng mount & nose gear were damaged.NTSB NYC84LA120Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Lawrence, MAThe plt reported that the acft ballooned on landing, & on the 2nd touchdown, it veered left towards a snowbank. He maneuvered to avoid the snowbank, but the nose wheel collapsed in soft mud.NTSB MKC84LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wilson, ARThe acft nosed over during takeoff after hitting a soft spot in the rwy. The takeoff area was a private grass airstrip 1300 ft long. The plt said he had no control of the acft after hitting the soft dirt.NTSB LAX84LA228Accident · No injuriesLimited investigationFinal reportCessna 150M · Holbrook, AZThe acft collided with a mound of rubble during an aborted takeoff. The takeoff was attempted uphill to avoid buildings and wires according to the plt. The density alt was 6200 ft. after the collision the acft nosed over.NTSB SEA84LA074Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Hailey, IDThe student plt attempted to taxi back on the active rwy after landing and groundlooped. During the swerve the left wingcontacted a snow bank. The student plt recommended no tail-up taxiing.NTSB DEN84LA113Accident · No injuriesLimited investigationFinal reportCessna 150L · Springfield, COAccording to the plt he landed too FAR on the right side of the rwy & the right wheel hit a chunk of ice. The acft veered right into a snowbank collapsing the nose gear.NTSB MKC84LA107Accident · No injuriesLimited investigationFinal reportCessna 340 · Olathe, KSThe acft skidded off the rwy into slush covered terrain alongside the rwy, dragging the left gear in the mud. As the acft continued its fwd roll the main gear struck the edge of a taxiway & collapsed backwards. The rwy was covered with slush at the time of…NTSB MKC84LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Lincoln, NEDuring landing roll on the runway with crosswind conditions and restricted visibility due to ice on the windshield the acft slid left on the ice and collided with a snow bank, damaging the propeller and the right wing tip.NTSB ANC84LA047Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe plt landed on hard packed snow on a glacier. Some of the crusted snow gave in and the acft swerved to the left whilenosing over.NTSB SEA84LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Kennewick, WAThe plt was performing touch and go landings when he lost control of the acft and groundlooped. The wind was gusting to 15 KTS.NTSB LAX84LA224Accident · No injuriesLimited investigationFinal reportBeech 55 · Phoenix, AZThe acft veered off the rwy into soft dirt collapsing the right main landing gear. The left brake was foundNTSB SEA84LA073Accident · No injuriesLimited investigationFinal reportCessna 152II · Preston, IDThe solo student plt was making a takeoff after a touch-and-go landing. The acft swerved to the left, collided with a snowbank, and nosed over.NTSB ATL84LA139Accident · No injuriesLimited investigationFinal reportCessna 150F · Bardstown, KYThe CFI flew one pattern with the student and sent him solo. During the attempted takeoff the acft veered off the rwy & hit a dirt bank. The student said the rudder pedals would not move. Reportedly a wrench was found jammed in the rudder pedals. Some…NTSB FTW84LA166Accident · 4 fatalLimited investigationFinal reportBell 206L-1 · W Camrn Blk 624The pilot and passengers boarded the helicopter in an attempt to fly off the rig before the passage of a squall line. The acft engine was being started when the acft was blown off the platform and into the water by a gust of wind. The acft impacted the sea…NTSB FTW84LA165Accident · No injuriesLimited investigationFinal reportCessna 172N · Stamford, TXThe acft touched down nose wheel 1st on the 3200 ft x 60 ft asphalt rwy. As the plt attempted to hold the acft on the surface, directional control was lost & the acft went off the right side of the rwy, rolling into a muddy field. The nose wheel dug into the…NTSB ANC84FA044Accident · No injuriesField investigationFinal reportChampion 7EC · Anchorage, AKThe acft swerved and collided with a snowbank during landing. The wind was calm and the rwy dry. After the collision the right landing gear collapsed.NTSB LAX84LA218Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Sonoma, CAThe student plt had previously soloed on 12/4/83 & had accumulated about 30 hrs of total time of which 3.7 hrs were solo. Just prior to the accident flt, the student's instructor had flown with him & he had completed 4 landings on that flt. The student then…NTSB CHI84LA126Accident · No injuriesLimited investigationFinal reportBeech BE-90 · Columbus, OHWhile taking off on rwy 27L, the acft contacted a ridge of snow at the intersection of rwy 14, where rwy 14 had been plowed. After striking the snow, the acft drifted to the right & the plt noted a reduction of power from the right eng. The right main gear…NTSB NYC84LA106Accident · No injuriesLimited investigationFinal reportCessna C172 · Fairfield, NJThe acft hit a snowdrift during landing roll and veered left into a snowbank. The acft nosed down, striking the right wing tip and propellers.NTSB MIA84LA103Accident · No injuriesLimited investigationFinal reportMaule M4-220 · Boca Raton, FLThe plt stated that while practicing touch & go's he lost directional control & the left landing gear collapsed.NTSB CHI84LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Stow, OHThe acft ran off the rwy & collided with a snowbank during landing. The acft had been subjected to previous damage whichhad not been fully repaired when a mechanic released it for further flt. A bolt (slightly worn, according to the mechanic) was reused in…NTSB ANC84FA045Accident · No injuriesField investigationFinal reportCessna 152 · Anchorage, AKThe acft had previously been involved in an accident in which the airframe was substantially damaged. It was then rebuilt & put back into service. Since then, it had been flown about 24 hrs using a snow covered rwy for takes & landing. During the 1st…NTSB FTW84LA186Accident · No injuriesLimited investigationFinal reportLockheed VEGA-1 · Yukon, OKThe plt was practicing touch-&-go landings & lost control of the acft. It swerved to the left onto soft terrain & went over on its nose. At 1st, the plt made comments about improper strut inflation. However, later, he reported that wx was not a problem & that…NTSB MKC84LA096Accident · No injuriesLimited investigationFinal reportCessna 172P · Broken Bow, NEA gust of wind overturned the acft during taxi from landing. The wind was from 330 degrees at 24 KTS gusting to 34 KTS.NTSB LAX84LA206Accident · No injuriesLimited investigationFinal reportCessna 170B · Fullerton, CAThe acft ran off the rwy during landing. The plt said the'right brake was not functioning properly.' The acft collided with a rwy light and collapsed the right main gear.NTSB NYC84LA098Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Bedford, MAThe acft was decelerating at about 35 mph during roll when a gust of wind picked up the right wing and the acft veered to the right. Full power was applied to regain control and during acceleration the right main gear collapsed and the acft pivoted right and…NTSB CHI84LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Strongsville, OHThe CFI stated that on the second landing, during the flare, the acft veered off the left side of the rwy due to the rt crosswind. He stated that he attempted to take control of the acft but it was already off the rwy in a two to three ft deep snowbank. The…NTSB ATL84LA113Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Rockingham, NCN92792 was being taxied from a tie down area when the prop struck the right wing on an unoccupied B-35, N8813A. The plt stated the brakes failed as he was attempting to taxi between two rows of parked acft and directional control was lost.NTSB FTW84LA162Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Braithwaite, LAThe plt said that when he applied power for takeoff he overcorrected and the acft veered right. He attempted to abort but saw a ditch and reapplied power. The acft hit the ditch and collapsed the landing gear. The plt thought maybe the brakes locked but an…NTSB CHI84LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Taylorville, ILThe acft collided with a snowbank and nosed over during landing. The student plt said a nose wheel shimmy developed during landing roll and he was unable to keep the acft on the 6O ft wide rwy.NTSB CHI84LA122Accident · No injuriesLimited investigationFinal reportCessna R172K · Marion, OHThe plt lost directional control of the acft during landing on an icy rwy in a gusty crosswind. The acft skidded to the left and contacted a snowbank, after which it nosed over.NTSB SEA84LA062Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Pullman, WAAccording to the student plt, the winds were prevailing from the southeast at 5 to 10 KTS, but were shifting & gusting to 20 KTS. During a landing on rwy 5, the acft veered off the right side side of the rwy, then struck a ditch & nosed over.NTSB SEA84LA059Accident · No injuriesLimited investigationFinal reportCessna 172RGII · Grangeville, IDThe acft ground looped during landing on an icy rwy and nosed over after leaving the rwy. The landing was made with a right quartering tailwind.NTSB LAX84LA192Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Watsonville, CAThe acft ran off the left side of the rwy during the takeoff portion of a touch and go landing. After colliding with a ditch the acft nosed over.NTSB ANC84MA037Accident · No injuriesMajor investigationFinal reportEmbraer EM-110P1 · Cordova, AKDuring a landing at night, the acft touched down slightly left of the rwy centerline, which was not visible, & began veering to the left. The plt reported that the acft did not respond to rudder inputs, rudder tiller inputs or differential reverse thrust. It…NTSB NYC84LA095Accident · No injuriesLimited investigationFinal reportCessna 182RG · Teterboro, NJAccording to the plt after about an hour and 10 min flight he returned for landing. During the landing roll the acft skidded off the rwy onto soft dirt damaging the propeller and right wing tip.NTSB MKC84LA080Accident · No injuriesLimited investigationFinal reportCessna 150M · Norton, KSThe solo student landed in a light crosswind on a rwy with patches of snow and ice. The acft slid sideways after bouncing and collided with a snowbank.NTSB MKC84LA078Accident · No injuriesLimited investigationFinal reportGulfstream American AA5B · Papillion, NEThe plt overran during an attempted takeoff on the water covered rwy. The acft failed to attain the proper airspeed for lift off. During the overrun the nose gear sheared off. The plt said the standing water on the turf rwy prevented proper acceleration.NTSB LAX84LA191Accident · No injuriesLimited investigationFinal reportCessna 180A · Truckee, CAPrior to takeoff, the plt had to push the acft out of mud where the right landing gear had sunk into the ground. He took off and flew for 1/2 an hour. The plt reported that during the landing, the right brake seemed to be frozen and the acft swerved to the…NTSB SEA84LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Roseburg, ORThe acft drifted left during the student pilots landing and collided with VASI lights. After the collision the acft nosed over. The CFI on the ground said the wind shifted just prior to the last landing.NTSB ATL84LKG04Accident · Serious injuriesFinal reportCessna 177B · Kennesaw, GAThe acft bounced during landing and when it started to veer off the rwy the plt attempted a go-around. The acft collidedwith trees and came to rest in a small ditch.NTSB ATL84LA103Accident · No injuriesLimited investigationFinal reportBeech 19A · Mayersville, MSThe plt circled the airstrip prior to landing and believed the landing area in suitable condition. During the landing right main landing gear mired in a soft spot and the landing gear collapsed.NTSB ATL84LKG03Accident · No injuriesFinal reportCessna 152 · Albertville, ALThe acft ran off the left side of the rwy during landing and nosed over. The student plt said he was practicing touch and go landings solo and lost control of the acft.NTSB MKC84LA075Accident · No injuriesLimited investigationFinal reportCessna 172P · Springfield, MOThe student plt was on the final leg of a x-country flt. While landing with a gusty x-wind, the acft veered off the rwy, encountered soft terrain & nosed over.NTSB MKC84LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Boonville, MOThe acft nosed over after landing. The plt said that the arpt manager told him that 'there is a valley that funnels the wind and has blown other acft the same way'. The plt said the only way to avoid this condition is to land farther down the rwy.NTSB MKC84LA073Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lawrence, KSThe dual student allowed the acft to porpoise & yaw and lost control of the acft as it veered into a ditch. The CFI on board tried to correct the situation with rudder and throttle but was unsucessful in the attempt.NTSB LAX84LA175Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chino, CAThe acft groundlooped and ran off the side of the rwy during landing.NTSB CHI84LA108Accident · No injuriesLimited investigationFinal reportCessna 172P · Lansing, MIThe acft veered off the rwy during landing. The plt tried to straighten the acft with rudder pressure but the acft continued off the rwy into a gully of snow.NTSB LAX84LA169Accident · No injuriesLimited investigationFinal reportShuey Glassaire · Chico, CAThe acft groundlooped during landing and ran off the rwy. The landing gear collapsed and ruptured the wing tanks. The plt stated that he thought the fuel shifted in his'homebuilt'as he tried to do a 3 point landing.