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 LAX89LA031Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Saint Helena, CAThe pilot reported that after completing a three point landing, the airplane began to oscillate. He was unable to maintain directional control. Subsequently, the airplane went off the runway and nosed over in soft dirt. No mechanical failure or malfunction of…NTSB CHI89LA021Accident · No injuriesLimited investigationFinal reportCessna 170A · Springfield, ILThe conventional landing gear equipped airplane was substantially damaged when it nosed down after ground looping during a landing attempt. VMC prevailed and a 90 degree right crosswind, blowing at 12 knots, was present. The pilot relates in his statement…NTSB ANC89LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot reported that he lost directional control of the airplane during a post-flight taxi to tie down. He said that a small flashlight had fallen behind the left rudder pedal and limited the amount of brake and rudder available for directional control.NTSB DEN89FA024Accident · Minor injuriesField investigationFinal reportCanadair CL-600-1A11 · Aspen, COThe pic's failure to follow approved procedures and directives; the pic's failure to attain/maintain direction control of the airplane, the pic's failure to abort the takeoff in a timely manner; and the pic's failure to follow proper aborted takeoff…NTSB ATL89LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Reidsville, NCThe student plt reported that the airplane nose '...was wanting to come up sooner than it should' during the takeoff roll on his first solo flt; he checked the elevator trim and found it properly set. He elected to abort the takeoff. He reduced the pwr and…NTSB ANC89LA011Accident · No injuriesLimited investigationFinal reportCessna 180 · Seldovia, AKThe private pilot was attempting to land his Cessna 180 airplane on the beach near Seldovia, AK. The main landing gear encountered a soft spot during the landing roll, and the airplane nosed over. Afterward, the pilot elected to fly the airplane to its home…NTSB LAX89LA017Accident · No injuriesLimited investigationFinal reportCessna 150F · Goodyear, AZThe plt rprtd that drg the landing roll, the acft enctrd a gust of wind & veered off the dirt strip & onto a raised berm (edge of rwy). After enctrg the soft dirt & rough terrain, the nose gear collapsed & the plane nosed over. The plt had landed with 40 deg…NTSB DEN89LA016Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe pilot was practicing touch-and-go landings in a 15 kt crosswind condition in an acft in which he had 8 hrs experience. During takeoff roll after the sixth landing the plt lost control and the acft departed the side of the rnwy.NTSB LAX89LA016Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Van Nuys, CAIn both his oral and written statements, the student pilot stated that during the landing roll he lost directional control of the airplane. The student attempted to make a go-around, but before becoming airborne the airplane veered to the left of the runway…NTSB LAX89LA015Accident · No injuriesLimited investigationFinal reportHoward GFA-15P · Vacaville, CADuring the landing roll the pilot lost control of the airplane. The airplane ground looped and the main gear collapsed. There were no mechanical problems reported prior to the accident and the weather was not a factor.NTSB ANC89LA010Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Soldotna, AKDuring the landing roll the pilot lost directional control of the airplane. The airplane ground looped on the runway.NTSB ANC89LA008Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Bonanza Hills, AKThe commercial pilot was attempting to land on a private gravel airstrip in rural Alaska. During the landing roll, the left main landing gear encountered snow along the runway edge and veered sharply to the left and off the runway.NTSB ANC89LA018Accident · No injuriesLimited investigationFinal reportCessna 182C · Akiachak, AKThe air taxi pilot landed long and was unable to stop the aircraft before it ran off the runway and came to rest in a ditch. A 30-40 kt gusty crosswind and turbulence existed at the time. The pilot stated that during the landing roll, he discovered that the…NTSB NYC89LA010Accident · No injuriesLimited investigationFinal reportBeech 77 · Farmingdale, NYThe pilot of the Beech 77 had just started the engine and was checking the gauges, when the aircraft started moving forward. The pilot tried to turn the aircraft onto a taxiway. The aircraft continued straight ahead and hit two parked aircraft.NTSB CHI89LA007Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbondale, ILThe student pilot, while on the takeoff roll on his first solo flight, experienced a loss of directional control which he failed to correct. The aircraft swerved to the left and departed the runway, striking a VASI installation before coming to a stop. The…NTSB LAX89LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Concord, CAThe pilot stated that during the landing roll he lost directional control of the airplane and veered left of the runway centerline. The pilot stated that the left rudder was stuck in a fully deflected position and his attempt to add right rudder was…NTSB DEN89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Delta, UTOn a x-country flt, the plt elected to make a refueling stop at Delta, UT. He transmitted on UNICOM freq & got no reply,but noted a light wind favoring rwy 30 & rwy 34. He elected to land on rwy 30. He said that on final apch, he looked fortraffic to rwy 34,…NTSB ATL89LA010Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greensboro, NCThe plt had landed at southeast Greensboro earlier. He departed on rwy 35 and remained in closed traffic for landing. The td was made in the first 100 feet of the downsloped rwy at about 70 mph. The flaps were retracted and the plt reptd that a gust of wind…NTSB ATL89LA008Accident · Serious injuriesLimited investigationFinal reportNorth American T-6G · West Jefferson, NCDuring a landing attempt, the pilot lost directional control and veered off the right side of runway 27. The pilot reported applying opposite braking with negative results. The airplane examination failed to disclose any system problem.NTSB LAX89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Porterville, CADuring a dual instructional flight, the pilot lost directional control of the airplane while landing. The airplane veered left. When the pilot corrected to the right, the left main landing gear collapsed. The airplane nosed over and came to rest on the right…NTSB ATL89LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Savannah, GAWhile landing with a left x-wind, the acft veered to the left & went off the rwy. Subsequently, the nose gear collapsed in soft terrain. The plt thought tower personnel had told him the wind was from 030 deg at 9 KTS. A check of the transcript revealed that…NTSB FTW89LA002Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, TXNTSB SEA88LA190Accident · No injuriesLimited investigationFinal reportCessna 185F · Hillsboro, ORDuring landing roll the aircraft veered to the right and departed the runway where a groundloop occurred. The wind was calm. No explanation for the loss of control was given by the plt.NTSB ANC88LA148Accident · No injuriesLimited investigationFinal reportBell 212 · Deadhorse, AKThe pilot encountered a whiteout condition and elected to land on a frozen lake approximately 3 miles southwest of the airport. After touchdown on the ice, the helicopter broke the ice and rolled over on its back. The helicopter was destroyed by ground fire.NTSB NYC88LA244Accident · No injuriesLimited investigationFinal reportCessna 177 · Machias, METhe plt was practicing night takeoffs and landings. He stated that he had successfully accomplished two full stop landings. After the third landing, he applied full power to execute a go-around. The pilot said the airplane pulled to the left so he reduced the…NTSB CHI88LA245Accident · No injuriesLimited investigationFinal reportCessna 150F · Baraboo, WIWhile landing on a sod strip with an 11 knot quartering tailwind, the aircraft drifted to the left of the runway and encountered uneven terrain. The pilot reported that he failed to maintain directional control and was unable to avoid a ditch with standing…NTSB ANC88LA147Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Zacher Bay, AKThe pilot stated that during the takeoff run on the water, he lost directional control of the airplane, due to the high wind condition. The airplane's wing tip struck the water causing the airplane to nose over on its back.NTSB SEA88LA187Accident · No injuriesLimited investigationFinal reportCessna 210L · Juneau, AKThe plt stated that on landing on the airstrip, which also serves as a roadway, he encountered a depression in the surface. The acft porpoised and departed the left side of the prepared surface. The plt added power and regained the prepared surface. He then…NTSB CHI88LA241Accident · No injuriesLimited investigationFinal reportCessna 550 · Fremont, MIThe airplane ran off the end of the runway and struck an embankment after landing downwind from a VOR approach during heavy rain. Both pilots reported poor braking action and ineffectiveness of reverse thrust application after touchdown and during the landing…NTSB ANC88LA145Accident · No injuriesLimited investigationFinal reportCessna 185F · Chip River, AKThe air taxi pilot was attempting to land on the snow covered tundra near his passenger's fish camp. The tundra had not yet frozen sufficiently to support the weight of the airplane, and the main landing gear quickly became mired in the soft soil, causing the…NTSB NYC88LA239Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt.Holly, NJSeveral landings and takeoffs were performed. On the last landing, the aircraft touched down first on the right main gear and then the left main gear. The pilot stated that the aircraft seemed to slide or skid to the right and continued onto the grassy area…NTSB FTW88DPA09Accident · Minor injuriesFinal reportAeronca 11AC · Athens, TXAfter setting the aircraft down in the grass to the left of the runway, the pilot stated that a 40 mph wind gust picked the right wing up and set the aircraft on its nose. He attempted to keep the fuselage from tipping all the way over after disembarking;…NTSB MKC88FA173Accident · Minor injuriesField investigationFinal reportAero Commander 500B · Hays, KSOperation attempted with known deficiencies in equipment, and failure of the pilot to maintain directional control. A contributing factor was: the pilot's use of an improper starting procedure & the fence.NTSB DEN88LA206Accident · No injuriesLimited investigationFinal reportCessna 172 · Greeley, COThe student plt reported that he was making touch and go landings. During landing roll the crosswind lifted the right wing and caused the acft to drift to the left. The student plt said he attempted to correct the drift, to no avail. The left main wheel…NTSB ANC88LA140Accident · No injuriesLimited investigationFinal reportCessna 170B · Hope, AKThe arpt was located in an area between 2 mtns. It had two windsocks; one was at rwy level; the other was above the treetop level. The plt rprtd that the lower windsock showed the wind was favoring rwy 16, but was shifting about 45 deg to either side of the…NTSB ANC88LA133Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe private pilot stated that he was attempting to land on a gravel bar when the airplane encountered a soft spot and nosed over. He said that a contributing factor in the accident was that he had applied his brakes too strongly early in the landing roll, and…NTSB ANC88LA134Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Skwentna, AKThe airline transport rated pilot was flying a load of gasoline in a crop duster type airplane to a residence in rural Alaska. The landing site was a river sand bar located near the residence. The pilot stated, and witnesses concur, that the airplane's main…NTSB MKC88LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Warrensburg, MOWhile practicing stop and go ldgs, the student lost directional control. The takeoff was attempted with a left crosswind. The acft veered to the left, off the runway, and hit an embankment. The nose and left main gears, the propeller, and fuselage were…NTSB SEA88LA175Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Seattle, WAPlt landed with 80 deg right cross wind of 8 KTS, groundlooped to right. The plt said that ATIS info gave the wind as 220 degrees at 8 KTS; however his EST from windsock observation included gusts of 15 KTS. The observing station reported no gusts on the date…NTSB ANC88LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe commercial pilot attempted to takeoff from a rough and soft off-airport site in rural Alaska. During the takeoff roll, the airplane's main landing gear encountered an exceptionally soft spot, causing the airplane to nose over. The pilot stated that the…NTSB CHI88LA230Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Cambridge, OHThe pilot was on a solo flight for the purpose of practicing takeoffs and landings. The aircraft departed the right side of the runway and struck a culvert. The flight was the pilot's second supervised solo.NTSB ANC88LA130Accident · No injuriesLimited investigationFinal reportCessna 182TD · September Lake, AKThe 202 hour private pilot was attempting to takeoff in a Cessna 182 converted to a conventional configuration (taildragger) from an off-airport site in rural Alaska. The pilot reported that a strong, gusty crosswind pushed the airplane off the intended track…NTSB ANC88LA129Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Oshetna River, AKThe pilot reported that he was attempting to takeoff from an extremely narrow and short stretch of land situated near a River. He had used this off-airport, unimproved site for several years without difficulty until the accident flight. On this occasion, the…NTSB ANC88LA127Accident · No injuriesLimited investigationFinal reportMaule M-4 · Eureka Creek, AKDuring the takeoff roll on an upsloping gravel airstrip, the pilot lost control of the airplane. The airplane nosed over on its back. The pilot and both passengers exited the airplane without injuries.NTSB ANC88LA125Accident · No injuriesLimited investigationFinal reportCessna 180K · Chickaloonflats, AKOn touchdown off shore on the mud flats, the pilot lost complete control of the airplane. The airplane then nosed over on its back.NTSB ANC88LA122Accident · No injuriesLimited investigationFinal reportHelio H-295 · Anchorage, AKDuring the takeoff roll on the runway at approximately 20 to 25 mph the pilot lost directional control of the airplane. The airplane looped to the right.NTSB NYC88LA232Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Windham, CTThe student pilot said she heard a popping sound during the takeoff roll and almost instantaneously the door came open. She tried to close the door and when that failed she attempted to abort. She retarded the throttle and attempted braking but it was not…NTSB FTW88DRG12Accident · No injuriesFinal reportCessna 182R · Spicewood, TXThe plt said the windsock indicated the wind was from the northeast; however, witnesses said the winds were from the south & the acft landed downwind. The plt said he went around after the 1st apch, & on the next pattern, he made a lowerfinal apch. He said…NTSB ANC88LA121Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Kukaklek, AKDuring the takeoff roll on the gravel bar the airplane crossed the gravel area on to the soft tundra. The pilot then lost directional control of the airplane. The airplane nosed over on its back.NTSB ANC88LA118Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe plt was practicing touch-&-go landings. On the first landing, the acft bounced & a successful go-around was made. During the second landing, the plt lost directional control of the acft & it went off the left side of the rwy & was damaged.