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 ATL85LA156Accident · No injuriesLimited investigationFinal reportPiper PA-25-260C · Ashburn, GAThe plt was on a flt to clean the spray boom by flying down the center of the airstrip & dispensing a cleaning substance thru the spray boom. He made one pass down the strip, then entered a pull-up to the right. He stated that he then turned back to the left…NTSB BFO85LA044Accident · No injuriesLimited investigationFinal reportCessna 182H · Waynesboro, VADuring the takeoff roll, the pilot noticed that the left door was open. While attempting to close the door, he failed to maintain directional control and the aircraft subsequently struck trees along the south side of runway 23.NTSB FTW85LA212Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Mckinney, TXDuring landing the acft started drifting off right side of rwy. Plt stated he used left rudder and brake but was unable to control the drift. The acft stopped after the nose gear collided with a ditch and collapsed. FAA maintenance personnel instructed plt to…NTSB LAX85LA243Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Concord, CAWhile landing on rwy 19R with a wind from 250 deg at 14 KTS, the acft went off the right side of the rwy & was damaged. Personnel in the control tower said that plt appeared to lose control of the acft during the landing flare & the acft cartwheeled to the…NTSB DEN85LA128Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Colorado Spring, COThe glider collided with a parked acft following a loss of directional control during the landing roll. The plt reported the left wing dipped during the landing roll because of the x-wind. The left wing tip wheel dug into an area of soft sand beside the rwy…NTSB LAX85LA245Accident · No injuriesLimited investigationFinal reportCessna 140 · Jackson, CAPrivate plt lost directional control of his tail wheel acft after landing on rwy 19, ground looped and nosed over in a ditch. Wind was from 270 degrees at 10 KTS with gusts to 15 KTS. He reported no mechanical failures or malfunctions with the acft.NTSB CHI85LA184Accident · No injuriesLimited investigationFinal reportCessna 180J · Minneapolis, MNThe plt was ferrying the acft to the anoka county arpt for radio maintenance. During the landing roll, the acft swerved off the right side of the rwy & was damaged. No preimpact part failure or malfunction was reported.NTSB MKC85LA094Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Peculiar, MODuring the landing roll at the plt's pvt air strip with a runway consisting of wet sod, the brakes were applied to stop the acft. The braking was ineffective and the acft departed the side of the runway. After departing the runway the main gear and nose gear…NTSB FTW85FA202Accident · Minor injuriesField investigationFinal reportBoeing 737-300 · Amarillo, TXThe acft landed in a thunderstorm, winds recorded at the time of the accident exceeded the limits recommended for full reverse thrust. The acft hydroplaned, weather-cocked slightly, and slid off the downwind side of the 300 ft wide rwy. The nosewheel…NTSB DEN85LA121Accident · No injuriesLimited investigationFinal reportBoeing PT 17 · Aurora, COThe acft ground looped while landing at front range aprt, Aurora, CO. The plt was receiving instruction from a flight instructor for insurance purposes. Witnesses saw the acft land in a normal manner then it began to swerve back and forth across the rwy which…NTSB ATL85LA149Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Ravenswood, WVDuring ldg roll the std plt lost directional control of the acft & ran off of the side of the rwy while practicing touch & go ldg with CFI.the CFI stated that the std made a normal approach & upon touchdown the acft made a sharp turn to the right and went off…NTSB FTW85LA192Accident · No injuriesLimited investigationFinal reportCessna 150 · Abilene, TXThe plt had little recent tail wheel experience. The accident occurred while landing in a x-wind that exceeded either or both the acft's and plt's capabilities. The acft ground looped. The left wheel dropped into mud beside the rwy and separated. The main…NTSB LAX85LA212Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Boron, CAWhile on a cross country business flt, the plt said he became concerned about an indicated low fuel state and decided to make a precautionary landing. Two approaches had to be abandoned due to what the plt described as 'the most difficult x-wind conditions…NTSB CHI85LA171Accident · No injuriesLimited investigationFinal reportCessna 150D · Columbus, OHDuring the landing roll the acft traveled off the left side of the rwy where the nose gear collapsed. Skid marks were found on the rwy where the plt attempted remedial action by applying brakes.NTSB CHI85LA167Accident · No injuriesLimited investigationFinal reportCessna 150M · Hutchinson, MNThe student plt was on his 2nd solo flt after being endorsed for flt in the Cessna 150 acft. During a landing, he lost directional control in winds that he reported were from 080 degs at 7 KTS. The acft went off the right side of the rwy & went in a ditch…NTSB ANC85LA064Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kenai, AKThe acft was occupied by the owner/plt, a 42 yr old student plt seated in the front seat, and a 41 yr old private plt, a career police officer of the anchorage police force, who was seated in the rear seat of this 2 seat acft. The seats were in a tanden…NTSB FTW85LA187Accident · No injuriesLimited investigationFinal reportCessna 180H · Midland, TXThe 108 hour pvt plt had been checked out in the taildragger on the day preceding the accident. Returning from a local flt, the plt reported, he lost control during the landing when he encountered a gusting x-wind. The wheel ass'y failed in the subsequent…NTSB ANC85FA063Accident · No injuriesField investigationFinal reportPiper PA-12 · Anchorage, AKDuring takeoff roll acft veered left off rwy, hit a snow bank and nosed over onto its back. Acft was 265 lbs over gwt. Two pax were in rear seat. Rear control stick was installed. There was a 10 kt right x-wind.NTSB LAX85LA207Accident · No injuriesLimited investigationFinal reportCessna 177 · Chinle, AZThe aircraft landed on runway 17. The winds were form 220 degrees gusting to 30-35 knot. The pilot stated that, as he came by a quonset hangar, the aircraft was struck by a gust of wind from the right front quarter. The aircraft weather-vaned into the wind…NTSB ANC85LA062Accident · No injuriesLimited investigationFinal reportCessna 207 · Port Graham, AKThe plt lost directional control while taking off from a rwy covered with 4 to 6 inches of snow, ice & slush. The acft then swerved sideways, collided with a snow bank & was damaged. The arpt was located on public domain & was not regularily attended or…NTSB SEA85LA091Accident · No injuriesLimited investigationFinal reportCessna 185 · Paulina, ORThe plt reported that on 4/11/85, the left tire blew out during a landing at omak, WA, damaging the left wheel & braking sys. He said that repairs had been made, but the left brake felt spongy. The next flt (on 4/12/85) was to a private airstrip at Paulina,…NTSB ATL85LA133Accident · No injuriesLimited investigationFinal reportCessna 195 · Lexington, KYDuring ldg roll-out the plt applied brake press in order to turn onto the taxiway & the rt brake grabbed causing the acft to ground loop. The left landing gear spring strut separated from the fuselage attachment point.NTSB LAX85LA237Accident · No injuriesLimited investigationFinal reportCessna 195 · Tucson, AZThe student lost control & ground looped the acft during rollout from the fifth landing while practicing for his bfr. The CFI reported that the accident might have been prevented had he been more attentive and/or provided better supervision.NTSB FTW85LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Carney, OKPlt attempted to abort takeoff from grass strip mowed in pasture. Plt lost control and acft received substantial damage when it ran off rwy and collided with dirt bank rwy estimated to be between 1,000 ft to 1200 ft long.NTSB DEN85LA115Accident · No injuriesLimited investigationFinal reportCessna 150M · Beulah, NDThe pilot reported that he encountered turbulence and gusty winds on landing approach to runway 28. He said his speed was fast to compensate for these conditions but that he did not use a crosswind landing technique because the winds had calmed down. The…NTSB SEA85LA083Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Burns, ORThe acft veered left and the plt overcorrected with right rudder and a ground loop then occurred. The plt said the brakes needed to be worked on prior to the accident. He said that they were not as effective as they should have been & that he was aware of the…NTSB LAX85LVM02Accident · No injuriesFinal reportCessna 152 · San Jose, CAThe plt stated, 'on third approach, which followed 2 go-arounds; landing was made and gusty winds forced aircraft off north side of runway and into drainage ditch where aircraft struck brush & came to rest.'NTSB SEA85LA106Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Excursion Inlet, AKThe plt elected to land on an airstrip in a narrow valley with mountains on either side. While landing in variable & gusty wind conditions, he lost directional control of the acft. The acft then veered off the right side of the rwy onto rough terrain where…NTSB DEN85LA110Accident · Minor injuriesLimited investigationFinal reportCessna 310N · Abiquiu, NMThe pilot attempted to takeoff from a rough, unimproved airstrip with a 3% uphill gradient, high density altitude, and gusty crosswind conditions. During the takeoff roll, the pilot lost directional control, lifted the airplane off the ground, cleared a…NTSB DEN85IA109Incident · No injuriesIncident investigationFinal reportCessna 185F · Jackson, WYThe plt of N57PL was attempting a landing in a strong crosswind in VFR conditions. During the landing roll, the left main landing gear tire blew out causing the acft to ground loop.NTSB ATL85LA127Accident · No injuriesLimited investigationFinal reportCessna A188B · Prentiss, MSThere was no wind as the plt took off to proceed to an ag site; however, by the time he arrived, the wind had begun to blow. Reportedly, he landed downwind on a rural road in winds that were from the southwest at 10 gusting to 15 KTS. The plt stated that he…NTSB DEN85LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Kemmerer, WYOn April 2, 1985, an inexperienced pvt plt attempted to land on a runway with a 24KT crosswind at Kemmerer, WY. The favorable runway was closed due to snow accumulations. On the third attempt the acft landed hard and bounced into the air. The plt attempted to…NTSB DEN85LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Logan, UTThe acft departed the rwy during a touch and go landing. The plt stated that after touchdown, the acft pulled to the right. The acft impacted a snowbank to adjacent to the rwy and nosed over. It was reported that the plt had applied wheel brakes with the…NTSB MKC85LA079Accident · No injuriesLimited investigationFinal reportCessna 188 · Osage City, KSThe plt was practicing landing at the airport when during the landing roll on the third attempt at landing the acft swerved off the rwy. The acft ground looped after departing the rwy and sustained substantial damage. The plt rptd the brakes grabbed…NTSB MIA85LA136Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Melbourne, FLThe acft was departing on rwy 27L, when aprx 1200 ft down the rwy, on the takeoff roll, it veered off the left side of the rwy & crossed two taxiways. The acft came to rest about 350 ft off the left side of rwy 27L. A post crash exam of the landing gear…NTSB LAX85LA189Accident · No injuriesLimited investigationFinal reportCessna 172G · Show Low, AZInstructor plt stated that prior to departure for Show Low he called the fixed base operator at Show Low and learned the winds were currently from 190 to 200 degrees a 20 T0 30 knots. He and his student departed and upon arriving in the Show Low area learned…NTSB NYC85LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Clearfield, PAThe acft veered off the rwy and collided with a drainage ditch during touchdown. The plt stated that during the apch to the arpt, the acft flew over a coal stripping mine which produced turbulence and resulted in a touchdown without proper alignment with the…NTSB CHI85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-20-125 · Zionsville, INThe plt stated that she flared slightly high upon landing, causing the acft to bounce. Once the acft was on the ground again it began to drift to the left side of the rwy. To correct for this drift, the plt applied right rudder, however, she overcorrected…NTSB NYC85LA090Accident · No injuriesLimited investigationFinal reportCessna L-19 · Perkasie, PACessna L-19,a practice flight of takeoffs and landings for glider tow operation for philidelphia glider council encounter a wind shift on landing. The student pilot over corrected and the aircraft ground looped. The instuctor pilot at this time took control…NTSB FTW85LA162Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Frederick, OKThe passenger heard a loud mechanical noise from the tail of the aircraft during rollout from a touch-and-go landing. The pilot was unable to maintain directional control, the aircraft ground looped, the main landing gear collapsed, and the wings were…NTSB DEN85LA101Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Grand Forks, NDOn March 21, 1985, a Piper pa 18 ground looped on landing rollout at gran Forks, ND. The instructor stated the aircraft accident occurred when he was checking out another flight instructor in the tailwheel airplane. During the landing roll out the airplane…NTSB MIA85LA127Accident · No injuriesLimited investigationFinal reportBeech E18S · St. ThomasThe plt lost control of the acft during takeoff with a slight tailwind component & the acft ground looped. Later, the plt realized that the tail wheel was not locked.NTSB MIA85LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Vero Beach, FLThe student pilot was practicing touch-&-go landings on rwy 11. Due to a wind shift, the active rwy was changed to rwy 4. The student stated that during his 1st pattern for a landing on rwy 4, his apch was high & fast. As the acft touched down, he lost…NTSB DEN85LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Wesbter, SDThe student pilot made a touch and go landing on a grass runway. The airplane bounced 6 feet in the air during landing and a go around was initiated. The airplane was then on a collision course with airport obstacles. The pilot initiated a left turn, the…NTSB LAX85LA174Accident · No injuriesLimited investigationFinal reportEngel Engel AIR · Truckee, CAPlt built this acft and this was the 4th test flight. Plt was lined up on rwy 28 for takeoff. Upon rolling lift off plt lost directional control and ran into a tall snow bank.NTSB CHI85LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILThe plt reported that as he lowered the nosewheel to the rwy during the landing roll, the acft veered to the right. As the right main gear went off the side of the rwy, it entered soft terrain which pulled the acft further to the right. Subsequently, the nose…NTSB SEA85LA078Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fish Lake Valle, NVDuring landing roll the acft veered sharply to the left and struck an irrigation sprinkling system. The operator discovered that the valve stem to the tire had broken and the plt had landed with a flat tire.NTSB SEA85LA070Accident · No injuriesLimited investigationFinal reportFairchild SA-227AC · Hailey, IDOn ldg the experienced captn encountered a right drift on the dry rwy with negligible winds. Rudder/pwr/nosewheel steering inputs were insufficient to regain directional control. Right drift translated into a strong right swerve with continued application of…NTSB NYC85LA076Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Andover, NJThe plt reported that the wind was from 300 deg at 12 gusting 20 KTS. While on final apch to land, the acft encountered a gust & settled prematurely. It drifted to the left & the left wheel entered a grassy area. The plt initiated corrective action, then the…NTSB LAX85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · S Lake Tahoe, CAThe acft collided with a snow bank during lndg. The plt said he noticed fog moving in and after touching down he started braking 'right away'. A skidding action took place and the acft went to the left into a snow bank. No mechanical or physical discrepancies…