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 CHI84LA056Accident · No injuriesLimited investigationFinal reportCessna A185F · Bad Axe, MIDuring arrival, the plt was advised by the UNICOM operator that rwy 21 was the active rwy. Soon after landing, a passenger boarded the acft & the plt took off again. He proceeded to make a pattern around the arpt & initiated another landing on rwy 21. The…NTSB MKC84LA035Accident · No injuriesLimited investigationFinal reportRockwell 114 · Council Bluffs, IAAccording to the plt, he landed on rwy 13, which was icy, and encountered a right x-wind. Subsequently, the acft drifted to the left, the left main gear hit a snowbank & the acft ground looped. The plt reported that the right wing hit snow & was damaged. He…NTSB FTW84LA098Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Bulverde, TXThe acft collided with a ditch during landing rollout after loss of control and a groundloop. According to the plt the landing was normal on a 2850 ft strip. The acft groundlooped at slow speed and went into a ditch off the right side of rwy 16. This flt was…NTSB DEN84LA037Accident · No injuriesLimited investigationFinal reportCessna 150L · Englewood, COThe acft collided with a snowbank and nosed over during landing. The plt said the acft was rolling out when it hit some slush on the rwy and was pulled into a snowbank on the left. The nose gear folded when it hit the 3 ft snowbank and the acft nosed over.…NTSB ANC84LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Delta Junction, AKThe acft was taking off from an unimproved area covered by 2 inches of snow. At about 80 ft into the takeoff roll the acft bounced left into muskeg, collapsing the landing gear.NTSB ATL84FU002Accident · 1 fatalFinal reportAmerican Aerolights Double Eagle · Cape Carteret, NCReportedly, the plt had previously flown in a 2 place ultralight vehicle, but had not flown in one that was equipped with a canard. He indicated to the owner that he would like to taxi the ultralight. The owner obliged after explaining the operation of the…NTSB LAX84LA081Accident · No injuriesLimited investigationFinal reportCessna 195 · El Cajon, CAThe pilot stated that the acft veered to the right during landing. The pilot tried left brake with no success. The acft groundlooped and the left gear failed. The brakes were examined after the accident but due to the damage to the lines & and fittings no…NTSB FTW84LA079Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Los Lunas, NMThis was to be the student's first flt & the CFI had him follow through on the controls. As the tail came off the rwy the student began overpowering the CFI at the controls. The CFI was unable to maintain directional control & the acft went off the rwy into a…NTSB LAX84LA080Accident · No injuriesLimited investigationFinal reportCessna 180A · Coalinga, CAWhile departing, the acft began veering left as the tailwheel came off the ground during the takeoff roll. It rolled onto a hard dirt shoulder to the left of the asphalt rwy. The plt reported that he corrected the drift by applying right rudder & the acft…NTSB CHI84LA066Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · La Porte, INThe acft veered off the rwy, hit a ditch and nosed over during takeoff. The plt reported that he lost control of the acft during the takeoff roll and it ran off the side of the rwy into an open field and nosed over.NTSB MKC84LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · Hampton, IAOn his fourth touch and go landing the pilot added power for the go-around and the aircraft drifted off the left side of the runway. The left main gear hit a snowbank and the aircraft flipped over landing upside down in the snow. The winds at macon city, IA…NTSB SEA84LA026Accident · No injuriesLimited investigationFinal reportHelio H-391B · Hood River, ORAccording to FAA inspectors, the plt made a hi speed turnoff onto a taxiway after landing & ground looped the acft. The plt stated that the right brake failed, the acft rolled off the rwy into mud & the plane spun 270 deg to the left. However, the right brake…NTSB FTW84LA065Accident · No injuriesLimited investigationFinal reportCessna 150G · Mcallen, TXThe acft groundlooped during landing and collided with a ditch. This acft had been converted to conventional landing gear. The plt had only 1 hour as PIC in this configuration of landing gear equipment.NTSB MKC84LA028Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Kearney, NEDuring the landing roll, the plt held the nosewheel off while slowing down, and used right rudder to compensate for a reported x-wind condition. As soon as the nosewheel touched down, the acft veered to the right. It went off the right side of the rwy, the…NTSB LAX84LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe plt, who was on his fist solo stated he 'started to flare out bit high, bounced a few times, lost directional control and went off runway 30, to the right. The acft went up on its right wing, then back down, and came to rest upright.'NTSB MKC84LA026Accident · No injuriesLimited investigationFinal reportCessna 180A · Topeka, KSThe acft veered off the rwy into the grass and collapsed the main landing gear during takeoff. The pilots seat slid aft as the acft accelerated and the pilot lost control of the acft. The acft veered off the left side of the runway into the grass. The pilot…NTSB MIA84LA031Accident · No injuriesLimited investigationFinal reportCessna 185 · Gainesville, FLThe acft nosed over during landing while on an instructional flt. The instructor plt was demonstrating a touch and go landing at the time of the accident. The landing was made on rwy 28 with the wind from 340 degrees at 7 KTS. The instructor stated that…NTSB DEN84LA026Accident · No injuriesLimited investigationFinal reportCessna 177RG · Durango, COThe acft ran off the right side of the rwy and collided with rwy lights during landing. The plt said he landed on the right side because the left side was being seal coated. Proper alignment was not maintained and the acft's right landing gear dropped off the…NTSB DEN84LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Broomfield, COThe plt reported that he landed on rwy 29R with a wind from 220 deg at 8 KTS. He stated that the touchdown was smooth, but after the nosewheel was lowered, the acft veered to the left. He applied right rudder & aileron, but reportedly, the plane did not…NTSB DEN84LA024Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Crested Butte, COAccording to the plt, the ground was covered with about 6 inches of light snow & the wind was from the southwest at 5 to 10 KTS. A snow plow preceeded him to the rwy & had cleared a strip about 10 to 12 ft wide on the 1st 1/3 of the rwy. When the plt was…NTSB CHI84LA044Accident · No injuriesLimited investigationFinal reportCessna 172 · Kentland, INThe acft ran off the rwy into soft dirt during landing roll and cartwheeled. The student plt landed on rwy 27 with windsreported from the south at 18-20 KTS. After a 100 ft ground roll the acft left the rwy to the right into an open field where it cartwheeled.NTSB FTW84LA052Accident · No injuriesLimited investigationFinal reportCessna A185E · El Paso, TXThe acft groundlooped during landing on an instructional flt. The landing was on rwy 22 and the wind was from 270 degrees at 9 KTS. After touchdown directional control was lost and the acft veered to the right collapsing the left mainlanding gear.NTSB ATL84LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Wadley, GAThe plt stated that he landed too fast on the grass strip, & when he attempted to turn off the rwy onto a taxiway, the acft groundlooped.NTSB NYC84LA023Accident · No injuriesLimited investigationFinal reportBeech E18S · Franklin, PAAfter landing, the acft veered off the rwy. Subsequently, it went down an embankment & was substantially damaged. No pre-crash part malfunction or failure was found.NTSB ANC84LA014Accident · No injuriesLimited investigationFinal reportCessna 180 · Montague Island, AKThe acft ground looped during takeoff from a beach on montaque Island. The acft had been parked on the beach and the water had been over the landing gear due to the tide. The plt did not consider that the wet brakes would not be effective if needed. There was…NTSB FTW84LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Weslaco, TXThe student was practicing touch & go landings on a solo flt. On his 1st apch, the acft touched down on the left side of the rwy. The student reported that when he added power to go around, the acft veered to the left. He reported that he applied excessive…NTSB DEN84FTK01Accident · No injuriesFinal reportBaking Duce · Rapid City, SDThe acft ran off the left side of the rwy during landing and the left main landing gear collapsed. When the plt attempted to bring the acft back onto the rwy the gear hit the edge of the rwy. There was a 7 to 10 kt crosswind on rwy 14 at the time of the…NTSB CHI84LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Port Huron, MIThe plt stated that shortly after touchdown several deer came out of the nearby woods & stopped on the left side of the rwy. He attempted to slow the acft down while staying on the right side of the rwy but went off the rwy & collided with a raised concrete…NTSB LAX84LA031Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · New River, AZThe tow pilot reported that during a takeoff tow with both acft still on the ground, he started to drift right as a gust of wind caught him. The glider pilot decided to release. The tow acft then went 100 yards off the rwy and collided with a parked glider.…NTSB LAX84LA037Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · New River, AZThe student plt was on his 9th solo landing when he landed on rwy 27 with a x-wing from 200 deg at 10 KTS. During the landing, the glider drifted to the north into some bushes, then swerved into a tree. The plt reported that upon landing, he lower the wrong…NTSB LAX84LA030Accident · No injuriesLimited investigationFinal reportCessna 402B · Twentynine Palm, CAThe acft was landed in a westerly direction on a state highway. During the landing roll, the acft's right main gear went off the pavement onto a soft, sandy shoulder area. Subsequently, the plt lost control, the acft hit a berm & the gear collapsed. The plt…NTSB DEN84LA013Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Bennett, COThe plt stated that he landed on a dirt road, approx 12 ft wide, and a gust of wind picked-up the right wing. He applied full rt aileron but the lt wing dragged on the ground. The acft spun to the lt and the nose gear collapsed.NTSB LAX84LA018Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Casa Grande, AZThe aircraft was equipped with brakes only on the left side. During a dual instructional flt, the student was landing the acft from the left seat. On the 4th landing, the acft encountered a reported right quartering gust of wind from the rear. The acft veered…NTSB NYC84LA010Accident · No injuriesLimited investigationFinal reportAero Commander 560E · Skaneateles, NYAcft ran off right side of rwy & collided with a drainage ditch collapsing nose & left main landing gear.NTSB DEN84LA009Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Falcon, CODuring the descent for landing, the plt observed that the wind was from the south. The plt decided to land downwind in the upsloping direction of the glider strip rather than upwind in the downsloping direction. He made his base leg too close to the strip &…NTSB CHI84LA029Accident · No injuriesLimited investigationFinal reportCessna U206G · South Fox Isl., MIThe acft collided with a mound alongside the rwy during landing. The rwy is 3500 ft long turf strip with a 20 degree dogleg 1500 ft from the north end. There is a small hill running along both sides of the rwy. The grass rwy was wet and theacft slid sideways.…NTSB ATL84LA020Accident · No injuriesLimited investigationFinal reportCessna 172 · Cullman, ALThe student plt was on his 1st solo flt. During a touch-and-go pattern, he started to takeoff, after landing, with the elevator trim in a nearly full nose-up position. He stated that after he added power to takeoff, he had to hold the nose down by applying…NTSB FTW84LA022Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Crystal City, TXWhile landing on a ranch strip, the acft encountered & sudden gust of wind & drifted off the pavement. The wing & gear of the acft collided with tall sunflower that were growing beside the strip. Subsequently, the nose gear collapsed & the acft nosed over.…NTSB CHI84LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, ILThe acft nosed over during takeoff roll while on a solo training flt. The pilot applied too much right rudder then over compensated with left rudder and brake. The acft went off the left side of the rwy into soft mud and nosed over.NTSB ATL84LA019Accident · No injuriesLimited investigationFinal reportBeech B-23 · Topping, VAThe acft overran the departure end of the rwy and collided with a ditch during landing. The weather was VMC. According to the pilot 2 go-arounds had been made because the acft was high. On the 3rd approach a touchdown was made about 1/2 way down the 2500 ft…NTSB CHI84LA021Accident · No injuriesLimited investigationFinal reportPiper J4E · Troy, MIThe acft departed the side of the rwy during landing and nosed over. A private pilot was being accompanied by a commercial pilot whose CFI cirtificate had expired. During landing roll the private pilot began 's' turns for better forward visibility. The…NTSB NYC84LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Toughkenamon, PAThe plt had difficulty in starting the eng & got a mechanic to be at the controls while he hand propped the acft. He had tried several times to start the eng, then tried with the throttle open. On that attempt, the eng started and the acft began to move…NTSB NYC84LA006Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Block Island, RIThe flt was uneventful until the acft was landed at the destination. During the landing, the acft veered off the rwy & was damaged. An exam of the brake sys revealed that the reservoir still had fluid. When checked, the left brake was firm, but the right…NTSB FTW84LA011Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Junction, TXWhile landing, the plt noticed a plane parked on the right side of the rwy, at the departure end. He became concerned that he was not slowing as fast as he desired & that there would be insufficient room to pass. Therefore, he pulled the parking brake handle.…NTSB FTW84LA010Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 Special · Wichita Falls, TXThe plt reported that during a landing with a quartering left head wind, the right brake did not hold & the acft veered to the left. He added power in an attempt to avoid a ground loop; however, the acft went in a wet, plowed field & nosed over. Reportedly,…NTSB CHI84LA017Accident · No injuriesLimited investigationFinal reportCessna 177 · Wonder Lake, ILThe acft veered off the rwy and into a fence during a crosswind landing. The landing was on rwy 9 and the wind was from 021 degrees at 5 KTS gusting to 22 KTS. The pilot had applied power for a go-around but not in time to prevent the touchdown. Then the acft…NTSB LAX84LA006Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Fremont, CAThe acft groundlooped during landing after an aerial glider tow. The plt reported that he had performed 23 glider tows that day and he may have become fatigued. He was accustumed to making a low level turn to a short final from a base leg at 100 ft AGL. This…NTSB ATL84LA012Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Moncks Corner, SCThe plt reported that he landed on rwy 5 with a wind from the north northwest at 8 to 15 KTS. During the landing, he encountered a gust of wind, the acft veered, and subsequently, the right main gear failed.NTSB DEN84LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDThe acft veered off the rwy and nosed over in the soft grass during landing. The CFI and student had been practicing crosswind landings on rwy 26 with the wind from 290 degrees at 11 KTS. After the landings the CFI got out of acft so that the student could…NTSB CHI84LA009Accident · No injuriesLimited investigationFinal reportMooney M20F · Evansville, INDuring takeoff, the acft began to swerve to the left despite the plt's attempts to maintain directional control with rudder & opposite brake. The acft went off the left side of the rwy 7 struck the VASI lights with both wings. An exam of the brakes revealed…