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 DEN83LA130Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cando, NDAfter returning to the arpt, the plt landed on rwy 30 with a right x-wind at about 16, gusting 23 KTS. Reportedly, the grass was aprx 1 ft tall on the rwy & the landing area sloped downward to the west. After touchdown, the plt maintained control of the acft…NTSB FTW83LA257Accident · No injuriesLimited investigationFinal reportCessna 170B · Roswell, NMThe solo student plt was practicing touch and go landings. According to the plt, after landing and rolling about 200 ft he applied power to takeoff, the acft turned left and then ground looped 180 degrees. The right main landing gear collapsed.NTSB SEA83LA112Accident · No injuriesLimited investigationFinal reportCessna 180H · Blakely Island, WAA Cessna 180H, N2429F, was being landed on rwy 19 after a Cessna 172M, N80202, had just landed. The Cessna 180 plt stated that during arrival, the wind socks at the ends of the rwy were swinging in all directions & there was light to moderate turbulence.…NTSB NYC83LA127Accident · No injuriesLimited investigationFinal reportChampion Bellanca 7GCAA · Akron, NYThe acft landed on the runway and ground looped off to the right, collapsed the landing gear and settled on the left wing. The wing failed at the strut attach points. Damage consisted of a broken left wheel hub, gear strut broken, cockpit floor ruptured and…NTSB DEN83LA128Accident · No injuriesLimited investigationFinal reportCessna 180B · Decker, MTThe tailwheel acft groundlooped on takeoff as the tail came up and the acft swerved sharply to the left. During the turn at about 40 mph the acft nosed over. The pilot noticed a pulling to the left as the takeoff roll commenced but thought he could contain it…NTSB CHI83LA240Accident · No injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNThe acft veered off the rwy during landing. The landing was on rwy 07. The wind was from 360 degrees at 15 KTS. A thunderstorm was in the area and some turbulence remained. The pilot stated he felt one good bump at 50 AGL and from that point to touchdown very…NTSB FTW83LA282Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Mount Ida, ARDuring the takeoff portion of a touch and go lndg the plt applied pwr and the acft drifted off the left side of the 50 ft wide rwy onto soft terrain. The nose gear collapsed and the propeller and leading edge of the rt wingtip were damaged.NTSB CHI83LA229Accident · No injuriesLimited investigationFinal reportCessna 152 · Holland, MIWhile the student plt was taking off with a left crosswind, he reportedly became distracted when he became aware that he was applying incorrect aileron deflection for wind correction. He stated that he corrected the ailerons, but in the meantime, the acft…NTSB NYC83LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Olean, NYThe acft nosed over during taxi after landing when the acft went off the runway into soft dirt. The student pilot had completed a cross-country flight without incident. After landing during taxi at Olean, NY the pilot applied brakes and the acft swerved to…NTSB ANC83LA086Accident · No injuriesLimited investigationFinal reportCessna 170 · Central, AKThe plt reported that during arrival, he checked the windsock & noted a x-wind condition of 10 KTS or less. However, he said the windsock was being blown from side to side. While landing on rwy 26, the acft veered to the right. Subsequently, the left gear…NTSB ANC83LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKAccording to the pilot he was landing on the lake with one notch of flaps indicating 50-55 mph. The touchdown was smooth and after planing for 3-4 seconds the acft veered left. He corrected to the right and the acft straightened then suddenly veered right,…NTSB SEA83LA104Accident · No injuriesLimited investigationFinal reportCessna 180 · Klamath Falls, ORAccording to the plt, he encountered a gust while landing on rwy 14 with a quartering tail wind, then lost directional control. Subsequently, the acft departed the left side of the rwy & the left gear collapsed. The tower control reported that the wind was…NTSB LAX83LA238Accident · No injuriesLimited investigationFinal reportCessna 182 · Riverside, CAThe acft collided with a hangar after being hand propped without a qualified person in the cockpit. The acft had been borrowed and was known to have a low battery. The pilot did a start by hand propping the acft with a non-pilot in the right front seat.…NTSB SEA83LA101Accident · No injuriesLimited investigationFinal reportMooney M20J · Blaine, WADuring his first approach to land, the plt initiated a go-around after floating too FAR down the rwy. He reported that the second approach & landing were normal until a few seconds after touchdown. At that time, the acft encountered a gust of wind, lifted off…NTSB NYC83LA119Accident · No injuriesLimited investigationFinal reportBeech Sport · Bangor, METhe acft ran off the runway and collapsed the landing gear during landing. The student pilot had made 7 successful landings. On this final landing a gust of wind blew the acft across the runway and the pilot lost direction control. The acft went off the left…NTSB LAX83LA237Accident · No injuriesLimited investigationFinal reportCessna 152 · Torrance, CAThe acft veered off the rwy during an instructional supervised solo flt. The plt started with dual instruction to include touch and go landings. When the tower was advised by the CFI of his intentions to solo his student the tower replied with a precautionary…NTSB CHI83LA222Accident · No injuriesLimited investigationFinal reportCessna 172 · Warsaw, INThe pilot stated that he was on his final approach for a third touch-and-go landing and that he was aware of a right quartering crosswind. He made adjustments to compensate for the wind but just before touchdown a gust of wind lifted the right wing. Before…NTSB SEA83LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Klamath Falls, ORThe acft groundlooped off the runway during landing in a gusty crosswind. The pilot and passnger were not injured. The winds were reported as 300 degrees 18 knots gusting to 22 knots.NTSB MIA83FKA03Accident · No injuriesFinal reportPiper PA-23-250 · Cabo Rojo, PRPolice department personnel stated that while landing at night on an off airport field, the aircraft grounded looped about 250 ft after touchdown, sustaining substantial damage. This was drug related activity.NTSB MKC83LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Atlantic, IAThe aircraft swerved off the left side of the runway collided with a fence and nosed over in a freshly plowed field during landing. The acft was owned by the pilot and was being landed on the pilots private airstrip at his farm. The pilot indicated that the…NTSB FTW83LA240Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodward, OKAs the a/s increased drng tkof roll the acft started to skid to the rt. The student plt stated that with full l aileron and no rt rudder the acft continued to skid to the rt. He then atmptd to apply l rudder and abort the tkof by reducing pwr. The acft veered…NTSB CHI83LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ironwood, MIThe acft drifted to the right on the rwy during a crosswind landing and collided with a rwy light.NTSB LAX83LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Maxwell, CAThe acft contacted mustard grass alongside the airstrip and swerved off to the right collapsing the nose gear. The weather was VMC and no flt plan was filed. The pilot stated that he touched down in the middle of the 55 ft wide strip. In spite of this somehow…NTSB FTW83LA231Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wheeler, TXThe plt stated that before reaching rotation speed, with about 250 ft of rwy remaining, the left main landing gear dropped off into a chug hole in the rwy. The acft became prematurely airborne, heading off the rwy to the left. It came down in rough terrain…NTSB DEN83LA113Accident · No injuriesLimited investigationFinal reportCessna 182Q · Townsend, MTThe acft nosed over in a plowed field off the end of the rwy during an attempted aborted takeoff. The acft had departed one arpt and landed again at a private strip to onload a passenger clothes bag. The landing was uphill into the wind. There was no windsock…NTSB DEN83LA112Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Buffalo, WYThe plt reported that he attempted to takeoff on rwy 30 with a left x-wind from 210 deg at 25, gusting 30 KTS. At aprx 45 mph, after he had raised the tail of the acft into the takeoff attitude, a gust of wind was encountered & the acft weathervaned to the…NTSB NYC83LA109Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Old Bridge, NJAfter the plt returned from a local flt, he reportedly encountered a gust of wind & lost directional control. Subsequently, the acft collided with a tree & then nosed over. Aprx 25 mi west at trenton, NJ, the 2050 EDT wind was reported from 220 deg at 15,…NTSB ANC83LA078Accident · No injuriesLimited investigationFinal reportCessna U206 · Twin Hills, AKThe plt was dispatched to a beach area to pick up passengers. After landing, the passengers & baggage were loaded & the plt attempted to takeoff. The top & bottom of the beach area had some humps of gravel that blended into the beach sand. During the takeoff…NTSB MKC83IA102Incident · No injuriesIncident investigationFinal reportFairchild Swearingen SA226T · Lincoln, NEDuring landing roll the acft veered left. The parking brake valve was suspected to have failed & was replaced as a precautionary measure.NTSB FTW83LA224Accident · No injuriesLimited investigationFinal reportCessna 180K · Houma, LAThe plt was step taxiing on the intracoastal canal when he attempted a right turn. This resulted in a left rear crosswind which resulted in the left wing to striking a tree on the canal bank.NTSB CHI83LA202Accident · No injuriesLimited investigationFinal reportCessna P210N · Lansing, MIThe acft overran the rwy and slid on wet grass into a ditch. The rwy was 2432 ft long and the wind was from 180 degrees at 12 KTS gusting to 29 KTS. The plt said that just prior to touchdown the airspeed seemed to increase and the acft floated farther down…NTSB FTW83LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Bentonville, ARThe pilot reported that after the acft went off the right side of the runway during landing it went through a drainage ditch and once again became airborne. After the acft landed the second time in a muddy field the nose gear collapsed resulting in damage to…NTSB FTW83LA219Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Iowa, LAThe acft nosed over during an off arpt landing. The plt stated that he was landing to check his aerial application load and talk to a farmer. During touchdown the main landing gear dug into the soft ground and the acft nosed over.NTSB CHI83LA195Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Gaylord, MIThe acft nosed over immediately upon landing on a turf rwy. An inspection of the rwy revealed two skid marks in the turf about 75 ft long and 900 ft from the approach end of rwy 36.NTSB DEN83LA107Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Erie, CODuring a second touch & go the acft ran off the side of the rwy. The plt last flew on 10/4/82 for about a 1 hr flt.NTSB CHI83LA194Accident · No injuriesLimited investigationFinal reportMooney M20E · Springfield, ILThe acft ran off the left side of the rwy and collided with the VASI after landing. The plt stated he landed on rwy 22 when approach said the wind favored that rwy. He said that 'just as the wheels touched down a gust of wind pushed the nose to the left and…NTSB MIA83LA134Accident · No injuriesLimited investigationFinal reportGulfstream American AA1B · Moore Haven, FLAccording to the plt he collided with a large ant hill during the takeoff roll, lost directional control, & veered off the rwy into trees.NTSB FTW83LA216Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Roswell, NMThe CFI stated, the acft was lined up on the center line at the end of runway 17. The student pilot applied power and the acft veered to the left, he over-corrected to the right. He further stated, 'I reduced the power to idle as the right landing gear…NTSB DEN83LA106Accident · No injuriesLimited investigationFinal reportCessna U206 · Mexican Hat, UTThe acft nosed over during the landing roll at a dirt strip near Mexican Hat, UT while on a business trip. According to the pilot the acft hit a bump in the runway which caused it to become airborne. The crosswind caused the acft to settle onto the soft right…NTSB MIA83LA132Accident · No injuriesLimited investigationFinal reportCarter Pitts Special S-1 · Sebring, FLThe acft was landed behind a Piper navajo and rolled right and left striking both wing tips before nosing over. The pilot believes she encountered vortex turbulence from the Piper navajo which landed in front of her. The weather was vmcand no flight plan was…NTSB FTW83LA210Accident · No injuriesLimited investigationFinal reportCessna A188B · Winsboro, LAAprx 600 feet of the 2300 foot strip is concrete and the remainder is turf. According to the pilot, he raised the tail prior to running off the concrete. As the takeoff roll continued onto the turf, the acft veered sharply to the right. Full left rudder,…NTSB NYC83LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Hammonton, NJThe acft swerved off the runway into a soft field and nosed over during landing. The landing was on runway 21 and the wind was from 240 degrees at 10 KTS. The acft had rolled about 1000 feet when it began to veer to the right. The pilot tried left rudder and…NTSB FTW83LA203Accident · No injuriesLimited investigationFinal reportCessna 172B · Spearman, TXThe acft swerved off the right side of the rwy and collided with a ditch. The acft nose gear collapsed during the sequence. The landing was on rwy 20 and during the approach the plt noticed that the wind was out of the south and that the wind sock was…NTSB DEN83LA104Accident · No injuriesLimited investigationFinal reportNorth American T-6 · Grand Junction, COThe pilot stated that he made his approach to rwy 22 with a crosswind of 23 KTS. The acft bounced and relanded on 3 points fairly hard. The acft rolled out for 100 yards veering to left, then turning 90 degrees left. The right gear collapsed. The wind was…NTSB NYC83LA101Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Millbrook, NYThe pilot was using runway 17 for takeoff when he lost directional control. The acft went off the left side of the runway and over an embankment.NTSB FTW83LA207Accident · No injuriesLimited investigationFinal reportCessna 182P · Van Horn, TXThe acft collided with a ravine after leaving the rwy during a crosswind landing. The student pilot was on a cross country and was making and enroute landing. Upon arrival at the 2700 rt private gravel strip the pilot elected to land on rwy 06. He said he ws…NTSB CHI83LA183Accident · No injuriesLimited investigationFinal reportCessna 172 · Frankfort, ILThe wind was gusting to 40 KTS. The pilot stated a strong gust of wind lifted the left wing and blew the acft off the runway where a row of trees swung the acft into a plowed field. The pilot said the winds were stronger than reported.NTSB CHI83LA177Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Youngstown, OHThe pilot stated that during a landing, the left wing was caught by the wind and the aircraft drifted to the right. A go-around was initiated but the aircraft struck a runway light and a runway distance marker and nosed over.NTSB CHI83LA176Accident · No injuriesLimited investigationFinal reportCessna 182 · Madison, WIThe aircraft groundlooped and rolled inverted during the takeoff roll. The student pilot stated that during the takeoff roll the sun broke through the clouds and blinded him. He reported, that this condition plus the crosswind interferred with his ability to…NTSB FTW83LA209Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Cheneyville, LAAccording to the operator, the brakes failed during landing causing the acft to ground loop off of the rwy. He also stated that postcrash investigation revealed a broken brake line on the right brake which he suspects was an act of sabotage by an unknown…