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 MKC85LA192Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Grand Island, NEDuring flt, the plt encountered radio receiver problems & diverted to Grand Island, NE. During arrival, he requested a special VFR clearance, but could not ascertain if the tower had answered. Radio communication was established in the traffic pattern & the…NTSB MKC85LA174Accident · No injuriesLimited investigationFinal reportCessna 180 · Ames, IAThe desired rwy (19) was closed at the destination, so the plt landed on rwy 13 with a 15 kt x-wind. The x-wind was within the capability of the acft & the plt. After touchdown, the plt used full rudder & brake to maintain directional control. However, he…NTSB CHI85LA326Accident · No injuriesLimited investigationFinal reportCessna 177B · Kankakee, ILThe plt landed on the 5100 ft x 100 ft rwy, porpoised several times, lost directional control and veered off the rwy. The nose gear broke off and the acft nosed down.NTSB BFO85LA064Accident · No injuriesLimited investigationFinal reportStampe SV4C · Fredericksburg, VAThe acft lost directional control and veered to the right. Colliding with a tied down Cessna 210, N2542X, while taking off from rwy 23 at shannon airport, Fredericksburg, Virginia.NTSB DEN85LTE05Accident · Minor injuriesFinal reportGordon Thorpe T-18 · Alamosa, COThe plt of the amateur built acft was on a flt to ashkosh, WI with an en route stop at pueblo, CO. Due to wx in the pueblo area, he diverted to Alamosa, CO. On his 1st apch to land on rwy 20, he made a go-around. On his 2nd apch, the acft landed long & at…NTSB DEN85LA201Accident · No injuriesLimited investigationFinal reportCessna U206 · Greystone, COThe plt lost control of the acft during an attempted takeoff from a 7000 ft gravel road. The takeoff was being made to the north-northeast and the plt reported winds were from 180 degs at 10 KTS gusting to 15 KTS. The acft veered left, contacted a tree and…NTSB DEN85LTE04Accident · No injuriesFinal reportWoolsey Quickie Q2 · Rawlins, WYAfter taking off, the plt noted that the acft's CG had shifted, & as fuel was consumed, the elevator down authority seem to decay. He suspected that baggage (stowed behind the plt's seat & inaccessible during flt) had shifted aft requiring greater than usual…NTSB DEN85LA204Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3 · Logan, NMThe plt lost directional control while landing on a gravel road. Subsequently, the acft was damaged when it veered to the right & went into a ditch.NTSB DEN85LA193Accident · No injuriesLimited investigationFinal reportCessna 182P · Missoula, MTThe pilot lost directional control during the touchdown phase of landing. The aircraft was substantially damaged when it veered off the runway and nosed over in the soft dirt.NTSB NYC85LA188Accident · No injuriesLimited investigationFinal reportLake LA-4 · Sidney, MEAccording to the plt, the acft was on step and in indicating about 45 KTS airspeed. It then encountered a boat wake and began flying. The acft porpoised 2 or 3 times and then collided with the water in an estimated 10 to 15 deg nose down attitude. The pwr was…NTSB FTW85LA292Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Chattanooga, OKThe plt lost directional control while landing in a crosswind and the acft ground looped after the left main landing gear contacted soft terrain alongside of the runway. The nearest official aviation weather reporting station was at lawton, OK, located 16…NTSB DEN85LA191Accident · No injuriesLimited investigationFinal reportCessna 172 · Sykeston, NDThe plt said he made a normal landing on an aerial application airstrip. During the rollout the plt spotted an unmarked mail box. The plt said he swerved to avoid colliding with the mail box. The acft went off the side of the strip and into a field. The plt…NTSB NYC85LA182Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Livingston, NYThe acft departed the right side of the rwy where it collided with a corn crop during a landing roll. The acft owner, a pvt plt, stated a mechanic on board was flying at the time of the accident. The mechanic stated that the owner was at the controls when the…NTSB NYC85LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bedminster, NJN4319F heard NG138J announce its position in the traffic pattern throughout the approach and landing. N4319F landed on runway 30 and was taxiing back to the ramp on the parallel taxiway. The occupant of N4319F observed N6139J land about midway down the runway…NTSB NYC85LA178Accident · Minor injuriesLimited investigationFinal reportCessna C172 · Ellington, CTThe acft collided with the ground during takeoff from rwy 01 at Ellington, Connecticut, and was substantially damaged but there was no fire. The pilot received minor injuries. The aircraft crashed for undetermined reasons.NTSB MKC85LA161Accident · No injuriesLimited investigationFinal reportCessna 180G · Harrison, ARThe plt stated that during a wheel landing, the acft bounced, but not hard. He reported that he applied sufficient power to recover & made a smooth, 3-point touchdown, then the acft began a gradual skidding turn to the right. The plt corrected with left…NTSB CHI85LA288Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Eden Prairie, MNThe acft collided with the fence during an aborted takeoff. The tires of the acft showed signs of hydroplaning after the accident. No mechanical discrepancies were noted during the investigation. The takeoff was aborted the plt said because the acft yawed…NTSB ATL85LA220Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mt Sterling, KYThe insturctor (CFI) was demonstrating a soft field takeoff from a grass area beside the rwy. At that time, the acft lifted off, then settled back onto the grass. The CFI reported that the right main gear touched down in a hole which caused the acft to veer…NTSB ANC85FA130Accident · No injuriesField investigationFinal reportPiper PA-22/20 · Alexander Lake, AKThe plt lost directional control of the acft during takeoff and the acft rolled into rough terrain along side of the rwy where it nosed over.NTSB SEA85LA169Accident · No injuriesLimited investigationFinal reportCessna 185F · Boise, IDThe acft ground looped and the left main gear collapsed during a landing roll. The plt reported that the left wing came up during the landing roll which resulted in the acft veering to the right. When the wing settled, the left main gear collapsed allowing…NTSB NYC85FNC05Accident · Serious injuriesFinal reportBarnes AX7 · Gorham, METhe pilot took off with three passengers in a hot air balloon. There was an unforecast wind change with an increase in velocity. This change in wind direction and velocity precluded the ability to make a landing and keep the basket upright. When the basket…NTSB MKC85LA160Accident · No injuriesLimited investigationFinal reportCessna 180J · Fort Dodge, IAN180DH was landing on a 6,547 x 150 ft, dry, asphalt, runway with a lt quartering headwind at 15, with gust to 20 KTS. The plt said he made a full flap, full stall, 3PT, landing. The acft was aligned with the rwy centerline but after a short roll the acft…NTSB DEN85LA192Accident · No injuriesLimited investigationFinal reportCessna 170B · Missoula, MTThe pilot stated that he did not use proper technique and did not maintain directional control while landing in a brisk and direct crosswind. The airplane was substantially damaged in the hard landing that was followed by a ground loop.NTSB CHI85LA295Accident · No injuriesLimited investigationFinal reportRobert Thibodeau JR ACE · Troy, MIOn July 17,1985 at 1015 EDT, a Robert Thibodeau jr ace N3642, registered to and flown by Robert Thibodeau, lost control and collided with the terrain on takeoff at Troy oakland airport, Troy,Michigan, while on a personal flight. Visual meteorological…NTSB SEA85LA172Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Moses Lake, WAA ground loop occurred during landing roll on rwy 36. The wind at touchdown was from 210 degs at 5 KTS. The twr did give the plt the current wind when the controller cleared him to land. The plt was aware that he would be landing with a left quartering tail…NTSB MKC85LA225Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Griffithville, ARThe plt reports that the acft fishtailed during the takeoff roll and ran off the side of the rwy. The acft was heading toward a canal and the plt elected to try to fly over the canal. The acft became airborne and flew about 1/4 mi. The plt saw trees ahead and…NTSB MKC85LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrison, ARAfter an en route stop, on a x-country flt, the student plt was taxiing to takeoff again. While proceeding northbound with a left x-wind, the plt applied braking action to slow the acft for a turn. At about that time, the acft veered to the right, went down…NTSB ANC85LA131Accident · No injuriesLimited investigationFinal reportCessna 180 · Barrow, AKThe plt reported that when he returned to the arpt, he made a 3-point landing in gusty x-wind conditions. Reportedly, the acft then ground looped & was damaged. At 1534 adt, the wind at Barrow was from 050 deg at 13 gusting 18 KTS.NTSB MKC85LA153Accident · No injuriesLimited investigationFinal reportCessna 172M · Olathe, KSPlt stated that she used left aileron and right rudder for x-wind correction and did not release the rudder pressure on touchdown. The acft went off side of rwy, crossed a taxiway, went down an embankment and through a fence into a plowed field where it nosed…NTSB ANC85FA125Accident · No injuriesField investigationFinal reportCessna 152 · Big Lake, AKThe glider plt was in training for a single eng land rating & was indorsed for solo flt. During her training, she & her instructor plt had landed at the Big Lake arpt. She thought that that was her approval to land there solo. However, there were sandy soft…NTSB CHI85LA277Accident · No injuriesLimited investigationFinal reportBurch Pitts S-1 · Houghton Lake, MIThe acft nosed down following a ground loop during a landing roll. The plt reported the tailwheel began to shimmy, directional control of the acft was lost and it ground looped to the right. The acft traveled aprx 10 ft off the rwy where the left wing dug…NTSB ANC85FA118Accident · Minor injuriesField investigationFinal reportDouglas DC-6A · Egegik, AKAirplane accelerated to v 1 and struck through on sandy beach. The nose pitched up and the pilot lost directional control. The airplane struck adjacent bank caught fire. It was totally destroyed.NTSB NYC85LA161Accident · No injuriesLimited investigationFinal reportCessna 152II · Ebensburg, PAThe student plt was practicing takeoffs and landings when the acft traveled off the left side of the rwy during the fourth landing. Once off the rwy, the acft traveled into a construction area where it nosed over.NTSB DEN85LA184Accident · No injuriesLimited investigationFinal reportCessna A188B · Del Norte, COThe plt was attempting to take off from a 3800-FT grass rwy. Field elevation was 7700 ft, temp was 88 deg. The plt said that at about 2500 ft down the rwy he decided to abort the takeoff. Directional control was lost and the airplane groundlooped. The plt…NTSB BFO85LA055Accident · No injuriesLimited investigationFinal reportCessna 172M · Hagerstown, MDThe recently certificated instructor was performing touch and go landings with a paraplegic student, who used a hand control for rudder operation. On the third landings the acft veered to the right and the CFI took control of the acft. The student pilot…NTSB FTW85LA275Accident · No injuriesLimited investigationFinal reportLuscombe T8F · Frederick, OKThe plt stated his foot slipped off the right rudder pedal which allowed the acft to veer left off the rwy. The acft hit a ditch and flipped over. FAA coordinator confirmed initial notification of substantial damage to the acft.NTSB CHI85LA267Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · New Richmond, WIThe acft veered to the rt & hit a rwy marker during the attempted go-around. The wind was from 210 degrees at 19 KTS gusting to 27 KTS. The plt said that if the marker had been 'break-away' plastic the damage would have been negliable.NTSB LAX85LA302Accident · No injuriesLimited investigationFinal reportMeyers OTW · Winters, CAThe purpose of this flt was to check out a commercial plt in the acft. Dual flt controls & heel brakes were installed. The student was practicing landings & on his 4th or 5th landing roll, the acft began to turn to the right. The student applied left rudder &…NTSB LAX85LA300Accident · No injuriesLimited investigationFinal reportHelio H-250 · Imperial, CAThis plt executed a full flap 40 mph landing. After touchdown the left main landing gear lifted off the rwy, & the plt was not able to lower it using rudder, brakes, & aileron control. No attempt was made o use power to regain directinal control as the acft…NTSB FTW85LA268Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76 · Eugene IslandThe plt had landed on the offshore heliport in the gulf of Mexico. The S76 helicopter rolled backward on the platform with the helicopter tilting to its right. The coplt exited the acft and found the right main gear wheel off the platform and into the deck…NTSB CHI85LA256Accident · Minor injuriesLimited investigationFinal reportRichard E. Rowland Cassutt III M · Kankakee, ILOn landing the homebuilt tailwheel acft, the pilot lost directional control, struck a ditch and flipped over on the acft's back resulting in substantial damage to the acft.NTSB ANC85LA116Accident · No injuriesLimited investigationFinal reportPiper J-3/100 · Port Lions, AKThe plt lost directional control of the acft during a touch and go landing. The acft veered off the rwy and contacted boulders. The plt reported to bystanders at the accident site that it had been a long time since he had flown an acft equipped with heel…NTSB ANC85LA110Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe plt reported that by the time he had returned to the arpt, the wind velocity had increased to 18 KTS. During the landing, he lost directional control & the acft ground looped & was damaged.NTSB DEN85LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lordsburg, NMThe plt attempted to take off from a dirt road at or near max gross wieght and at high density alt conditions. The plt said there was a small rise in the road and he eased back on the control yoke. Directional control was lost and the airplane skidded off the…NTSB LAX85LA291Accident · No injuriesLimited investigationFinal reportCessna 180 · Murrieta, CAAt the conclusion of a personal cross country flight, the pilot stated he made a hard landing after which, the aircraft got away from him and ground looped.NTSB LAX85LA290Accident · No injuriesLimited investigationFinal reportLuscombe 8A · San Jose, CAThe pilot lost directional control,during the takeoff phase of a touch and go landing. The acft swerved off the runway as it entered a ground loop that collapsed the right landing gear strut.NTSB DEN85LA171Accident · No injuriesLimited investigationFinal reportCessna 172 · Gallup, NMOn June 23, 1985, a student plt flying a C-172 departed the side of the rwy whole landing at Gallup, NM. He said that the landing was made at too high an airspeed. Upon departing the rwy the acft proceeded into a ditch causing substantial damage.NTSB MKC85LA139Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Sheldon, IAThe student plt was on a solo x-country flight. After the nose wheel touched down on landing, the acft veered left, went into a corn field & nosed over. The plt stated that he may have let the nose wheel contact the rwy before he neutralized the rudder…NTSB LAX85LA295Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Angwin, CADuring a VFR cross country flt, wx conditions along the route induced the plt to divert to the Angwin arpt. After an overflt to obtain wind information from the wind sock, the plt said he entered the pattern and completed a normal approach and touchdown.…NTSB ANC85LA105Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Lewis River, AKThe pilot stated there was a gust of wind about 10 knots, the pilot was not able to reach flying speed, and the aircraft ran off the departure end of the runway.