NTSB investigations, 1987
331 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 372 |
|---|---|
| 1983 | 374 |
| 1984 | 329 |
| 1985 | 295 |
| 1986 | 315 |
| 1987 | 331 |
| 1988 | 295 |
| 1989 | 235 |
| 1990 | 278 |
| 1991 | 244 |
| 1992 | 217 |
| 1993 | 232 |
| 1994 | 213 |
| 1995 | 210 |
| 1996 | 221 |
| 1997 | 219 |
| 1998 | 224 |
| 1999 | 247 |
| 2000 | 229 |
| 2001 | 215 |
| 2002 | 204 |
| 2003 | 240 |
| 2004 | 217 |
| 2005 | 228 |
| 2006 | 213 |
| 2007 | 232 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1987
AND 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 year(c."eventDate") = 1987 AND 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 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…NTSB ATL88LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student plt was performing a normal landing with a crosswind from the left. The acft was drifting to the right at touchdown and was partially off the rwy to the right. The plt attempted to use the brakes and keep the acft's ground track parallel with the…NTSB LAX88LA019Accident · No injuriesLimited investigationFinal reportCessna 195A · Modesto, CAThe pilot stated that during the end of the landing roll on runway 28L, the aircraft started turning to the right and he could not correct it and the aircraft ground looped. There were no mechanical problems reported prior to the accident. The pilot reported…NTSB LAX88LA035Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Tucson, AZThe pilot reported that the engine would not start by pressing the starter so he decided to hand prop the engine. After several attempts the engine finally started. The engine immediately increased power and the aircraft jumped the chocks. The non-pilot…NTSB ANC88LA008Accident · No injuriesLimited investigationFinal reportCessna 207A · Sheldon Point, AKThe air taxi pilot attempted to land on a short narrow gravel air strip in crosswind conditions. He ran off the end of the runway and the airplane was substantially damaged. The wind was in excess of recommendations for the type acft. A witness reported that…NTSB SEA88LA007Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Petersburg, AKThe plt of the floatplane rprtd that after the acft touched down drg a water lndg & was on the 'roll-out,' she pushed the carb heat in & leaned forward to raise the flaps. At about that time, the floatplane bgn to swerve. She attempted to regain control;…NTSB BFO88DHD02Accident · No injuriesFinal reportBoeing A75N1 · Milton, DEThe pilot's improper brake application during a 'wheel' landing, which resulted in the aircraft nosing over. The slight downslope of the airstrip, a quartering tailwind, inadequate supervision on the part of the check pilot, and the pilot's lack of…NTSB CHI88FA005Accident · No injuriesField investigationFinal reportCessna TU-206G · Lansing, MIImmediately after takeoff the plt noted strong pressure on the right rudder. He trimmed out the rudder pressure and continued to fly in the local area. Approach flare and touchdown were normal. When the nose wheel contacted the runway the airplane veered…NTSB ANC88LA006Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Tin City, AKThe pilot stated the wind was a direct crosswind and the velocity was 30 knots gusting to 38 knots. During the take off roll, the airplane lifted off the ground and then settled and ran off the end of the runway.NTSB DEN88LA009Accident · No injuriesLimited investigationFinal reportCessna A185F · Glasgow, MTThe plt reported that he was landing on rwy 12 with the winds, as reported by UNICOM, 100 deg at 10 KTS. He said that shortly after touchdown the acft was hit by a strong gust from the rt. The rt wing lifted, the lt wing hit the ground, and the acft nosed…NTSB MKC88LA006Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Creve Coeur, MOWhile practicing stop and go ldgs, plt lost control during rollout. Acft swerved and entered an inadvertent ground loop. The right main landing gear failed and the right lower wing contacted the ground.NTSB LAX88LA010Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · San Jose, CAThe pilot stated that during the landing roll he was distracted and looked downward. He said that when he looked back up the ground loop had started and it was too late to correct it. He did not report any mechanical problems prior to the accident.NTSB DEN88LA006Accident · No injuriesLimited investigationFinal reportCessna 182P · Monument Valley, UTThe private pilot was landing on a dirt runway and at touchdown a crosswind weathervaned the aircraft to the right. The pilot added full power to try to go around but the aircraft settled back to the ground left of the runway. The aircraft came to rest 300…NTSB DEN88LA005Accident · Serious injuriesLimited investigationFinal reportRockwell 690B · Albuquerque, NMAcft was landing on rwy 17 at coronado airport, 9 NM n of Albuquerque, NM intl arpt. Plt said he brought props into reverse and acft went off right side of rwy. Plt brought props out of reverse, realigned acft on rwy, and reversed props again. Acft went off…