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 MKC84LA139Accident · No injuriesLimited investigationFinal reportCessna 152 · No.Little Rock, ARThe acft collided with a rwy light and nosed over during landing in a x-wind. The wind was reported to the student as from 040 degrees at 9 KTS at takeoff and 070 degrees at 11 KTS when she returned to land. These winds converted to a 90 degree x-wind of 6.5…NTSB DEN84LA149Accident · No injuriesLimited investigationFinal reportCessna 172N · Kindred, NDThe pilot stated that he made a normal landing approach to runway 15. During touchdown a gust of wind hit the airplane. The pilot said he was caught off guard and before he could regain control, the airplane went off the right side of the runway, struck a…NTSB SEA84LA106Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Carson City, NVAccording to the plt, the wind was from 230 deg at 12 gusting 18 KTS. He said that he had just lifted the tailwheel when a 'dust devil' push the acft to the right of the rwy. The acft then struck sage brush & a barbed wire fence & nosed over.NTSB SEA84LA105Accident · No injuriesLimited investigationFinal reportHelio H-700-SP · Meridian, IDThe plt stated that while landing onto his own field the left main gear caught in a deep furrow. The acft then veered to the right striking a woven wire & barbed wire fence, & a railroad tie.NTSB CHI84LA192Accident · No injuriesLimited investigationFinal reportBeech 23 · Put-In-Bay, OHDuring the landing roll, about 950 ft down the rwy, the acft hit a dip in the rwy & became airborne again. The plt stated that due to the gusty wind condition, the acft was blown over a grass field on the left side of the rwy. He considered going around, but…NTSB ANC84IA066Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-146 · Unalaska, AKA 'no brake condition' was experienced while the plt was using the yellow brake sys during a landing. The normal landing procedure calls for using the green sys. During the roll-out, the plt selected the emergency yellow sys & subsequently locked the brakes.…NTSB MIA84LA167Accident · No injuriesLimited investigationFinal reportCessna 172N · Ft.Lauderdale, FLThe acft nosed over during takeoff after running off the left side of the rwy. The wind was reported from 50 degrees at 13 KTS gusting to 23 KTS prior to the accident. After the accident the wind was from 030 degrees at 14 KTS.NTSB DEN84LA146Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Winner, SDThe plt reported that a gust of wind was encountered during the landing roll. The acft swerved to the right & left rudder did not correct the situation. The acft left the rwy & collided with a ditch. The plt said that he examined the tailwheel after the…NTSB DEN84LA145Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Canon City, COThe acft went off the side of the rwy into a ditch during landing. The plt said he was only using 20 degrees of flaps due to the wind and after touching down the acft was blown off the rwy. While in the dirt the plt added power 'to try and get lift to either…NTSB ANC84LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dillingham, AKThe plt lost directional during landing roll with two pax in the rear seats. He stated that the right brake failed after touchdown.NTSB ATL84LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Buckingham, VAThe acft bounced and drifted during the landing flare. The plt added power to go-around and was unable to clear the trees near the rwy.NTSB FTW84LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Haskell, TXPlt lost directional control of the acft during the landing roll and acft veered off the rwy striking a dirt bank. The nose gear collapsed upon impact with the bank. The plt reported only 145 hours of flt time in the 18 years she has had had her private…NTSB ATL84LA165Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Smithfield, NCThe plt had only 1 hr of night experience & was practicing night landings to maintain currency. During a landing, the acft bounced & the plt added power to recover. As power was applied, the acft went off the left side of the rwy & subsequently collided with…NTSB ANC84LA060Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Talkeetna, AKThe plt was repositioning the acft from a private strip near palmer, AK, to his property near Talkeetna, AK. After stopping at the Talkeetna arpt, he was hand propping the acft when the eng started & the acft began moving. The plt tried to turn off the mags,…NTSB SEA84LA099Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Sherwood, ORDuring landing the acft swerved off the rwy. The plt stated that the recommended procedure at this arpt is to land uphill. Investigation revealed that the landing was made with a 9 kt quartering tailwind.NTSB NYC84LA156Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Vultee L-13A · Dummerston, VTDuring arrival, the plt landed to the south on a turf rwy. He stated that after a normal apch & touchdown, the acft encountered a gust of wind, presumably from the northwest & the acft nosed over. Also, in an accident report, he reported the wind was from the…NTSB DEN84LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDuring a crosswind takeoff the right wing began to raise just as the plt was thinking about rotating. This startled him & he aborted the takeoff. The acft departed the left side of the rwy & flipped over on its back.NTSB CHI84LA172Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Winona, MNAfter landing, the plt was turning left onto the taxiway when the wind lifted the right wing and tail of the acft. The acft nosed over.NTSB MKC84LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · N.Carlisle, ARThe acft nosed over after swerving off the rwy into soft sod during landing. The student plt was on his 2nd solo flt andpracticing touch and go landings. This was the plts 1st landing at carlisle arpt where the wind was of more velocity and greater angle than…NTSB CHI84LA170Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Shelbyville, ILAfter a normal 3-point, full stall landing, the tailwheel equipped acft rolled a short distance, then veered to the left. The plt stated that he applied right rudder & both brakes, but the acft continued to the left. He reported that as the plane went off the…NTSB CHI84LA163Accident · No injuriesLimited investigationFinal reportWilliam Freeman Glasair · Lambertville, MIThe plt stated that during takeoff, the acft weather vaned into the wind and the left main landing gear went off the rwy. When the acft hit soft plowed dirt after leaving the rwy, it nosed over.NTSB MIA84LA151Accident · No injuriesLimited investigationFinal reportCessna 172M · Ocala, FLDuring a landing, the plt lost directional control & the acft veered off the left side of the rwy. The nose gear struck a concrete drainage conduit & was substantially damaged. The plt reported the wind was from 090 deg at 8 KTS.NTSB CHI84LA158Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Athens, OHThe plt was performing a rolling takeoff after a touch and go landing. He said he forgot to raise the flaps and as the acft approached rotational speed it veered to the left. He could not correct with rudder and the acft went into a ditch where it nosed over.NTSB NYC84LA145Accident · No injuriesLimited investigationFinal reportCessna A185F · Hazleton, PAAccording to the plt, he attempted to takeoff on rwy 28 with a variable wind from 180 deg at 9 KTS gusting to 19 KTS. After rolling about 200 ft, he gradually added power, but the acft began turning left, so he reduced the power. The acft straightened out,…NTSB DEN84LA131Accident · No injuriesLimited investigationFinal reportCessna 140 · Miller, SDThe acft ground-looped during the plt's first solo landing & the right main landing gear sheared off. The CFI said the student had made between 30 to 40 landings prior to the solo flt.NTSB ATL84LA145Accident · No injuriesLimited investigationFinal reportGrumman G164A · Huger, SCThe aerial application acft was using a gravel surfaced dirt road as a temporary landing strip. During the landing roll the acft drifted to the left & hit a soft spot, a tree, & nosed over in a ditch.NTSB MKC84LA126Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · Holdrege, NEThe student plt was on a solo x-country flt. His 1st en route stop was at Holdrege, NE. He aborted his 1st attempt to land & made a 2nd apch. In the meantime, the plt of another acft landed & experenced turbulent winds. When the student landed (after the 2nd…NTSB MKC84LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Little Rock, ARThe acft swerved during landing in a x-wind and the right main gear collapsed. The plt said he slipped the acft to lose altitude to land and did not get a 'feel' for the wind direction as a result.NTSB ANC84FA056Accident · Minor injuriesField investigationFinal reportPiper PA-20 · Anchorage, AKThe acft veered during takeoff roll and left the right side of the rwy after about 200 ft of roll. The left main landinggear collapsed and separated from the acft.NTSB FTW84LA200Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · New Orleans, LAShortly after touchdown on a x-wind landing, the tailwheel equipped acft began to weathervaned to the left into the wind. The plt lost directional control & the acft ground looped to the left. The right gear collapsed & the right wing dragged on the ground.…NTSB ANC84LA055Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Bettles, AKThe acft groundlooped during landing. The plt said he lost control of the acft. During the swerve one of the gear legs failed and the acft skidded on the fuselage.NTSB ANC84LA054Accident · No injuriesLimited investigationFinal reportCessna 180 · Kodiak, AKThe acft was landed in winds reported as 35 to 42 KTS. According to the plt control was lost during the landing roll andthe acft ground looped to the right. The plt stated that there were no mechanical irregularities with the acft.NTSB SEA84LA077Accident · No injuriesLimited investigationFinal reportCessna 180-A · Garfield, WAThe acft was landed in a soft stubble field. The landing gear mired and the acft ground looped breaking the right main landing gear.NTSB NYC84LA132Accident · No injuriesLimited investigationFinal reportCessna 140 · Jeanette, PAOne of the aircrew members was buying the acft & was receiving dual instruction before flying solo. After several landings, he flared for a 3-point landing. During the landing roll, the acft began drifting left & the student correctedback to the right. The…NTSB DEN84LA123Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Gallup, NMThe plt was ferrying his recently purchased acft. During the takeoff, the acft rose momentarily, then settled back to the rwy. The plt said he then had a directional control problem and the acft went off the left side of the rwy. He blamed the rise and fall…NTSB NYC84LA131Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Forty Fort, PADuring a supervised solo flt, the student plt had difficulty with directional control on his 6th landing. Subsequently, the acft swerved & the landing gear and wing were damaged.NTSB NYC84LA128Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Factoryville, PAPlt stated that he inadvertently allowed the acft to drift left during the landing roll when he reached for the hand brake. The left main and nose gears contacted a snow bank and the acft nosed over.NTSB MKC84FA114Accident · No injuriesField investigationFinal reportCanadair CL-600 Challenger · Little Rock, ARThe acft was on an FAA certification flt (experimental). During the recovery phase, a non-type rated FAA plt was in the l seat & the PIC was in the r seat. While descending, a duct fail lgt & a leading edge overheat lgt came on. The PIC took corrective…NTSB NYC84LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Hopedale, MADuring the sixth landing on the dual instructional flt, the acft veered to the left. The instructor took over the controls and applied right rudder but the acft contacted a snow bank and nosed over.NTSB NYC84LA125Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Stow, MADuring the landing roll, the acft began drifting to the left & the student plt overcontrolled with the rudder. Subsequently, the acft departed the rwy, collided with a snowbank & nosed over. The instructor (CFI) took control of theacft as the veer was taking…NTSB NYC84LA123Accident · No injuriesLimited investigationFinal reportCessna 172 · Reedsville, PAThe plt reported that at about the time he applied power to takeoff, the acft veered to the left. He stated that his efforts to return the acft to the centerline of the rwy did not work. Subsequently, the acft went thru a snowbank beside the rwy, then entered…NTSB FTW84LA181Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Fort Worth, TXThe plt lost directional control of the acft during landing roll & collided with 2 parked acft. The pilot stated that immediately upon runway contact the acft veered to the right toward the parked acft. He applied half throttle & full left rudder. Directional…NTSB FTW84LA183Accident · No injuriesLimited investigationFinal reportCessna 180 · Rayville, LADuring the takeoff the acft yawed left. The plt overcorrected causing the acft to yaw right & depart the right side of the rwy collapsing the left main landing gear.NTSB FTW84LA182Accident · No injuriesLimited investigationFinal reportMartin AM-1 (Mauler) · Lubbock, TXThe plt was making a takeoff in this large single engine single seat acft after only 1 hour of experience. The plt said that the engine or propeller malfunctioned. The acft veered off the side of the rwy through a fence and struck 4 horses. An FAA inspector…NTSB LAX84LA238Accident · No injuriesLimited investigationFinal reportCessna A185E · Tulelake, CAThe plt stated that a gusty left x-wind existed. After touchdown, the acft ground looped, went off the left side of the rwy & nosed over. He estimated that the wind was from 200 deg at 15 KTS.NTSB LAX84LA235Accident · Serious injuriesLimited investigationFinal reportBellanca 14-19-3 · Temple Bar, AZAccording to the plt, he lost directional control during the landing & the acft zig-sagged down the rwy. He did not use brakes for fear of a nose over. On the last 30% of the rwy, he attempted a go-around; however, the acft veered off the rwy & crashed in…NTSB DEN84LA118Accident · No injuriesLimited investigationFinal reportCessna A188B · Hardin, MTThe plt returned to the arpt with about a 100 gal load of spray solution on board when the flagger would not work. During the landing, the acft swerved to the left & the right gear collapsed. No mechanical malfunction or failure of the gear or brakes was…NTSB CHI84LA143Accident · No injuriesLimited investigationFinal reportCessna P210N · West Chicago, ILThe plt stated that a normal landing was made. After landing during the rollout the acft weathervaned and the plt said he heard a'chattering'noise. The acft skipped sideways off the rwy into the mud. Winds were gusting 32 KTS. The plt stated he was over…NTSB FTW84LA176Accident · No injuriesLimited investigationFinal reportCessna 188 · Clayton, LADuring the last landing of the day in a gusty crosswind, the acft went off the side of the rwy and nosed down in a plowed field. This was the plts 26th landing for this day, all on the same rwy. The wind was gusting to 20 KTS.NTSB FTW84LA175Accident · No injuriesLimited investigationFinal reportCessna 182J · Weatherford, TXThe acft landed long & fast with a 10 kt tailwind. The pilot was unable to stop the acft on the remaining rwy & ran of of the end. The left brake was found inop due to a lack of brake fluid. The acft was observed to veer to the right of the rwy prior to…