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 MKC88LA044Accident · No injuriesLimited investigationFinal reportCessna 206 · Wichita, KSDuring a night ldg with strong gusty x-winds, the PIC lost control during the roll out and careened off the runway substantialy damaging the acft. The PIC stated the windshield was partially coated with ice making forward visibility difficult.NTSB LAX88LA092Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lakeport, CADuring ldg rollout the acft veered off the rwy, went into a ditch & collided with terrain causing substantial damage. The surface winds were estimated at only 5 KTS. The plt acknowledged that the accident might have been prevented if he had been less…NTSB DEN88LA056Accident · No injuriesLimited investigationFinal reportCessna 150M · Delta, UTDuring the landing roll, the acft swerved to the right into a snowbank and nosed over. The plt said he found snow packed between the landing gear wheel and wheel pants restricting the wheel from rotating. In his recommendation for prevention, the plt stated…NTSB DEN88LA055Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Albuquerque, NMThe ATP rated plt and a commercial rated passenger were taking a scheduled cargo flight from Albuquerque to las cruces, new Mexico. The runway was covered with snow, ice and water from a snow storm the previous night. It was snowing lightly at the time of the…NTSB SEA88LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Everett, WAThe student pilot had landed with full flaps prior to the application of full power for takeoff. The aircraft veered to the left side of the runway into mud and nosed over inverted. The aircraft's flap indicator had been placarded inoperative by the operator.NTSB MIA88LA087Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Tampa, FLDuring the landing roll the acft veered off the rwy, travelled through a retention pond, nosed over & came to rest. According to a plt who landed shortly after the accident, he had his hands full landing on the same rwy due to a 'stiff crosswind'. The pilot…NTSB DEN88LA049Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Clovis, NMNTSB SEA88LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Juneau, AKThe aircraft was ballooning during the approach to the ice-covered lake. The pilot momentarily added power to go-around, but elected to reduce the power in order to land. During the landing roll directional control was lost with the aircraft sliding into an…NTSB NYC88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Old Bridge, NJThe flight made a normal approach and touched down on runway 24. As the pilot applied pwr for takeoff due to the hazardous runway conditions, the pilot lost directional control and the left main landing gear impacted plowed snow at the edge of the runway.NTSB DEN88LA052Accident · No injuriesLimited investigationFinal reportCessna 305A · Littleton, CONTSB ANC88DAG02Accident · No injuriesFinal reportCessna 172 · Willow, AKThe pilot stated that immediately upon touchdown, the airplane started sinking in (two feet) deep snow, and came to a stop in about 50 feet. The left wing and propeller struck the ground. The plt had overflown the arpt and saw the snow removal equipment about…NTSB DEN88LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe plt reported that he was making touch and go landings on rwy 09, an asphalt rwy 6200 x 75 ft. the wind was light and variable. The plt said that during the 4th t&g, he landed a little fast and not perfectly aligned with the rwy. When he applied pwr to…NTSB ANC88LA023Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot stated that during the landing roll on the ice covered runway, he lost control causing the plane to exit the departure end of the runway into a snow bank.NTSB NYC88LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Concord, NHThe aircraft was landing at Concord municipal airport, and during landing roll, the aircraft veered to the left leaving the runway surface and nosed over in the field between the taxiway and runway 35.NTSB MKC88LA035Accident · No injuriesLimited investigationFinal reportCessna 182Q · Davenport, IAThe PIC had chosen rwy 15 for the LOC app and was cleared by approach control. The PIC stated that he cancelled his IFR flt plan entering clear conditions at 3,000 ft. the PIC further stated that he planned an approach using a ltl higher spd for the gusty…NTSB DEN88FA044Accident · Serious injuriesField investigationFinal reportSwearingen SA-26AT · Telluride, CODuring a visual apch, the plt said he encountered 2000 fpm downdrafts. The plt stated he added power and executed a normal apch at 120 KTS, compensating for downdrafts/crosswinds. After touchdown, the plt said he did not get a beta light on the right eng. He…NTSB MIA88IA079Incident · No injuriesIncident investigationFinal reportCessna U206G · Key West, FLWhile water taxiing nw from the ramp to takeoff with the wind from the north at 22 KTS, the rt wing lifted resulting in the lt float digging into the water. The plt attempted to correct this by turning into the wind and applying full-up right aileron but was…NTSB FTW88LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Woodworth, LAThe plt stated that during landing roll the aircraft veered left due to a strong wind gust. The aircraft fell into a ravine, coming to rest 180 degrees from the runway heading, damaging both wing spars at the fuselage attach points and collapsing the nose…NTSB MKC88LA034Accident · No injuriesLimited investigationFinal reportLuscombe 8-A · Chillicothe, MODuring a ldg attempt, acft touched down and swerved abruptly. Loss of control was experienced by PIC, and acft made a 180 degree turn on the runway. PIC stated the brakes may have been frozen, as he had taxied thru standing water during departure.NTSB CHI88LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Redwood Falls, MNWind was 210 degrees at 13 knots when the student pilot attempted a landing on snow compacted runway 12. The student stated that a gust of wind pushed the aircraft sideways and it struck a snowbank when it exited the runway to the left.NTSB MKC88LA031Accident · No injuriesLimited investigationFinal reportSonerai 2L · St. Louis, MOWhile practicing take offs and ldgs, PIC lost directional control during rollout. He added power and struck a snowbank just after becoming airborne during running takeoff.NTSB DEN88LA038Accident · No injuriesLimited investigationFinal reportCessna T210R · Bismarck, NDThe plt was attempting to takeoff at dusk on a gravel road. The acft veered off of road and hit a ditch.NTSB MIA88LA066Accident · No injuriesLimited investigationFinal reportCessna A188B · South Bay, FLThe plt attempted a landing on a narrow runway, on an embankment. The airplane swerved to the left, into a crosswind, and left the rwy. The right main ldg gear collided with a boulder; the airplane nosed over and came to rest in the water.NTSB ATL88LA065Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Elizabethtown, KYAfter a short stop btn flts, the battery was too weak to crank the eng. The plt elected to hand-prop the eng while his non-rated pax held the brakes. He briefed the pax on the proper procedure. He had previously allowed the pax to operate the brakes while…NTSB MIA88LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fellsmere, FLWhile on a business flt over the company's property the plt elected to land the acft on a 40 foot wide dirt road. After touchdown the acft drifted off the left side of the road, due in part, to a crosswind. The left wing collided with a tree.NTSB ATL88LA063Accident · No injuriesLimited investigationFinal reportCessna 150K · Portland, TNThe student plt rptd that the airplane veered off the rt side of the rwy into a ditch while ldg in x-wind conditions. The student plt estimated that the wind velocity was 10 KTS with gusts to 20 KTS. The student rptdly had about 32 hrs total flt experience,…NTSB MKC88LA024Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Coffeyville, KSWhile trying to start the acft with a low battery, PIC exited the acft and pulled the propeller one quarter of a turn to get it past the compression cycle. Engine started with pax aboard and proceeded to taxi. PIC was unable to stop the acft, and pax, after…NTSB SEA88LA082Accident · No injuriesLimited investigationFinal reportCessna TU206G · Silverdale, WAWhile on the lndg roll with a qtrg hdwnd, the acft enctrd a gust which pushed it to the left. The plt said he applied full rgt aileron, but it had no effect. As the acft was 'being blown' toward trees, the plt applied full rgt brake. He said the left wing tip…NTSB ANC88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot stated that he was taxiing for takeoff when he lost directional control of the aircraft causing the right main ski to break through the ice; the aircraft then ground looped.NTSB DEN88LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Telluride, CODuring a downwind landing, the plt experienced difficulty in controlling his acft. Approximately 2,500 feet from the west end of the rwy the acft ground looped into some rocks and was substantially damaged. The plt stated that he was landing downwind and…NTSB MIA88LA045Accident · No injuriesLimited investigationFinal reportMooney M-22 · Fort Pierce, FLPlt stated that on landing roll at approximately 30 to 35 knots the nose landing gear began to shimmy and turn to the left. Full right brake and rudder could not correct the left turning tendency of the aircraft. The aircraft ran off the left side of the…NTSB LAX88LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Sacramento, CAA Cessna 172N veered off runway 30. The pilot reported that a gust of wind lifted the left wing resulting in the right wing scraping the runway surface. The airplane subsequently ground looped to the right and departed the runway. The winds were reported to…NTSB FTW88LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · New Orleans, LAThe pilot was attempting to start the unsecured aircraft by hand-propping it. The aircraft started and rolled forward striking a fuel truck, damaging the left wing, fuselage, and propeller.NTSB ATL88LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Waynesboro, GAThe student plt lost control of the airplane while landing, during his second supervised-solo flt. The airplane veered off of the rwy into a ditch where the nosegear collapsed and the airplane nosed over. The wind was reportedly calm.NTSB CHI88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lake City, MIThe student pilot initiated a takeoff from a snow covered runway. During the initial ground run, he lost directional control. Subsequently, the aircraft ran off the side of the runway & collided with trees. The plt rprtd the wind was from the south at 8 to 10…NTSB FTW88LA030Accident · No injuriesLimited investigationFinal reportCessna 185 · Burnet, TXDuring landing roll, the aircraft drifted to the left of the runway centerline. Witnesses then observed the aircraft veer to the right and ground loop coming to rest off the end of the runway. Attempts to contact the student plt have not been successful.NTSB CHI88DEE01Accident · No injuriesFinal reportAlexander Volksplane VP-1 · Dekalb, ILThe plt had little experience flying tailwheel equipped acft & had only 10 hrs flt time in this make & model. During arrival, he landed on rwy 27 with a quartering left x-wind that was gusting to 20 KTS. Just before touchdown, a gust of wind caused the acft…NTSB DEN88LA022Accident · No injuriesLimited investigationFinal reportCessna 182N · Albuquerque, NMThe plt reported that she was making a touch and go. She said as she applied full power to takeoff the acft veered to the right. She was unable to realign the acft with the rwy and elected to continue the takeoff and 'pulled the acft off at a speed below…NTSB NYC88LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Marlboro, MAThe pilot was attempting a landing at Marlboro airport. Upon touchdown brakes were applied. According to the pilot, the aircraft was not stopping but instead was sliding down the runway. The pilot turned the nosewheel to the left to slow the aircraft but…NTSB NYC88LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Erwinna, PAThe pilot was landing the aircraft on runway 25 at vansant airport. At about 100 feet down the runway, the aircraft veered to the left, off of the runway and slid down an embankment and came to rest after colliding with a tree.NTSB MIA88LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Sarasota, FLDrg arrival, while being transferred from tampa apch ctl to twr ctl, the plt was clrd to lnd on rwy 14. Bfr lndg, he was adzd the wind was fm 070 deg at 15 KTS. Rwy 4 was available, but it was not suggested by the twr ctlr or reqd by the plt. The plt stated…NTSB DEN88DTE01Accident · No injuriesFinal reportQuickie Q-200 · Watkins, COThe plt rprtd he failed to lock the aileron reflexers tight for landing. During the landing roll, the lock slipped & the tail lifted off the rwy. Subsequently, the acft veered to the right, went off the rwy & hit a mudhole, then flipped over.NTSB MIA88LA039Accident · No injuriesLimited investigationFinal reportPitts S-1C · Clearwater, FLThe plt stated that on landing roll, as he added power to go around, he lost control of the aircraft, ran off the runway, flipped over and came to rest inverted. The torque of the relatively powerful engine added to the control problems in this short fuselage…NTSB LAX88DUQ01Accident · 1 fatalFinal reportStits Elkins 85 · Camarillo, CADuring the starting procedures for a local flight, the pilot had chocked the wheels and was hand-propping the engine. After several tries, the engine started. The airplane jumped the chocks and the pilot moved to the right wing, attempting to stop the…NTSB ANC88LA016Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Alexander Lake, AKThe relatively inexperienced private pilot attempted to land his float equipped airplane with a tailwind and gusty winds in choppy water conditions. He lost control of the airplane and it was substantially damaged.NTSB LAX88LA024Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palo Alto, CADuring a local flt while practicing touch and go landings, the plt lost control of the acft during the landing rollout. The acft groundlooped to the left, exited the rwy and nosed down.NTSB LAX88LA022Accident · No injuriesLimited investigationFinal reportCessna 402B · Avalon, CAOn landing the pilot reported he heard a loud bang and the aircraft veered to the right. The pilot corrected to the leftby applying left brake. The aircraft returned to the center of the runway; however, it began to skid. The pilot realized that he was…NTSB ATL88LA026Accident · No injuriesLimited investigationFinal reportPitts S2A · Ramseur, NCThe pilot lost directional control while making a normal landing. The pilot did not report a mechanical problem. The ground loop cause substantial damage to the aircraft's undercarriage.NTSB MIA88LA017Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Madison, MSThe plt stated that during the landing roll the acft began to veer off towards the left side of the rwy. Full rt rudder would not correct this. The acft then left the rwy, ground looped, & as a result the rt main gear collapsed & the tailwheel separated from…NTSB DEN88LA013Accident · No injuriesLimited investigationFinal reportBeech C45G · Salt Lake City, UTWhile conducting the last landing at the completion of a revenue freight hauling flt the acft departed the side of the runway separating the left main landing gear and damaging the left wing and number one engine. The plt stated that the landing lights would…