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 SEA84LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Everett, WAThe plt reported that during a landing, the acft encountered a gust of wind & ballooned. The airspeed decreased to 40 KTS & the acft dropped to the rwy. The plt applied full power & reduced the flaps from 40 deg to full up. The acft became airborne, but…NTSB LAX84LA372Accident · No injuriesLimited investigationFinal reportCessna 152 · Paso Robles, CAThe plt was landing on a 3000 ft strip that had been scraped out of the ground by using a 'blade'. During the construction, a 1 1/2 ft berm was left on each side of the strip. While on the landing roll, the plt kept the nose wheeloff the ground with a left…NTSB SEA84LA147Accident · No injuriesLimited investigationFinal reportCessna 207A · Reno, NVThe acft went off the rwy during a landing and the plt attempted a go-around with full flaps. The acft collided with a ditch and an irrigation pipe between the rwy and the taxi-way. The plt did not file an accident report. The accident information was…NTSB DEN84LA197Accident · No injuriesLimited investigationFinal reportCessna T188C · Philip, SDThe plt lost control of the acft during takeoff ground run when his vision was obscured by water which was sprayed on the windshield from a light rain shower.NTSB MKC84LA183Accident · No injuriesLimited investigationFinal reportCessna 150H · Nebraska City, NEUnable to start the engine with the electrical starter the pilot elected to pull the propeller through by hand. With the magneto switch 'off' and a 2X6 inch board in front of one main landing gear tire the engine started when the propeller was rotated. The…NTSB LAX84LA369Accident · No injuriesLimited investigationFinal reportSchweizer SGS-126D · Lucerne Valley, CAThe student plt reported that during a winch launch with a left x-wind, the wind lifted the left wing & the right wing contacted the ground. The glider then veered to the right & the right wing hit a wind sock & a vehicle. He reported that a wind-shift had…NTSB DEN84LA193Accident · No injuriesLimited investigationFinal reportCessna 188B · Albuquerque, NMThe arpt had a UNICOM & 2 rwys, 17/35 & 10/28. The acft had an operable radio, but the plt did not call UNICOM. He elected to land on rwy 17 which had a x-wind from 100 degs at 20 KTS. During the apch, the plt compensated for the x-wind by lowering the left…NTSB ANC84LA099Accident · No injuriesLimited investigationFinal reportInterstate S-1B2 · Anchorage, AKThe plt reported that he began taking off on rwy 31 with an 8 kt x-wind, but after he started rolling, he noticed the wind had changed to 'downwind.' The plane 'seemed to pull hard to the left' & he could not maintan rwy alignment. As the acft apchd the left…NTSB LAX84LA365Accident · No injuriesLimited investigationFinal reportStinson 108 · Camarillo, CAA prospective buyer in the left seat was initiating a takeoff in a tail wheel acft when the acft ground looped and the right main landing gear collapsed. The owner in the right seat was unable to correct the situation in time. The buyer had professed…NTSB MIA84LA192Accident · No injuriesLimited investigationFinal reportPiper J-3 CUB · Homestead, FLThe plt reported a loss of directional control occurred during the takeoff ground roll. The acft traveled off the rwy and collided with trees.NTSB CHI84LA261Accident · No injuriesLimited investigationFinal reportCessna 172N · Kilbourne, ILThe student pilot stated that the nose wheel cocked in sand while taxing and the acft nosed over.NTSB ATL84LLT11Accident · No injuriesFinal reportCessna T188C · Shelby, MSAcft was departing on the ninth aerial application flt of the operation. Weather had been clear but thunderstorms were building in the local area. On takeoff roll, a strong gust from the left rear caused loss of directional control. Acft veered left and…NTSB SEA84LA138Accident · No injuriesLimited investigationFinal reportCessna 170A · La Grande, ORDuring the landing roll, the acft veered to the right. The plt applied left rudder, but this did not help. Subsequently, the acft went off the rwy & the left main gear sank into soft ground & collapsed. An exam of the acft was made, but no reason was found…NTSB ATL84LA205Accident · No injuriesLimited investigationFinal reportSikorsky CH-19E · Iva, SCThe helicopter was being operated from sloping terrain. After returning from a spray mission, the plt remained inside the helicopter with the eng & rotor at ground idle while the ground crew refilled the spray tank. After completing the loading operation, the…NTSB FTW84LA276Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXShortly after touchdown during a touch and go landing directional control was lost. Acft veered off left side of rwy and came to rest in a waterway used by seaplanes that is adjacent and parallel to rwy 17L.NTSB NYC84LA210Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Mahaffey, PAThe acft veered off the prepared landing area in tall weeds and rocks where it nosed over. The plt had changed from a gravel rwy to the dirt one because of downdrafts. The 1st landing on the dirt rwy was made on the wheels and when the tail lowered the plt…NTSB ANC84LA090Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Healy, AKThe plt landed at a remote strip used by hunters and left in as poor a state as possible by them to make this choice game area relativley inaccessable. This area has many accidents as a result. The rwy is 1200 ft MSL. There are no wind direction indicators.…NTSB MKC84LA168Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Dexter, MOThe ag strip had recently been graded to increase its width from 20 ft to 50 ft. some clumps of dirt and sod had been left on the strip. The plt said the acft drifted to the left during takeoff roll and hit some of the dirt clods. The pltsaid he overcorrected…NTSB LAX84LA342Accident · Serious injuriesLimited investigationFinal reportLee Thorpe T-18 · Lee Vining, CAThe plt reported that during a landing in calm air, the acft began veering right when he applied the brakes. He corrected with left rudder & brake, then the acft veered left. Subsequently, it veered off the left side of the rwy, went down a grade & nosed…NTSB FTW84LA268Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Friendswood, TXPlt lost directional control of acft during landing roll. Acft traveled off the side of the 24 foot wide rwy where it contacted a parked acft, a fence and a ditch before stopping.NTSB ATL84LA195Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, VAThe plt practiced several landings, then made a soft field apch with 20 deg of flaps. During the 1st part of the landing roll, he held the nosewheel off the rwy, then lowered the nose & applied the brakes. At that time, the acft veered right, went off the rwy…NTSB LAX84LA340Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, CAThe student plt lost directional control on the takeoff roll, veered off the rwy & nosed over. Winds were reported as 160 deg at 10 KTS.NTSB DEN84LA171Accident · No injuriesLimited investigationFinal reportCessna 170B · Belen, NMDuring the takeoff roll directional control was lost and the acft rolled off the left side of the rwy. Heavy braking was applied in order to stop short of a fence and the acft nosed over inverted. Both occupants were rated plts. Their statements were…NTSB DEN84LA170Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Platteville, COThe ag plt was returning for his 3rd load. He said that after a wheel landing, he pulled back on the stick to lower the tailwheel & the acft ballooned back into the air. The plt said that he applied power to go around, but the acft settled & he lost…NTSB ANC84LA085Accident · No injuriesLimited investigationFinal reportCessna 170B · Mcgrath, AKThe acft ground looped and nosed over during landing. The plt had only about 4 hrs PIC in this acft. She said the acft veered left and she straightened it only to have it veer to the right. One main gear collapsed and the acft ground looped after which it…NTSB LAX84LA332Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Perris, CADuring a landing, the plt elected to go around. Power was applied, but the acft settled & touched down in a yaw to the left. Subsequently, the acft departed the rwy & collided with a parked DC-3. Three persons were standing by the DC-3 waiting to board it for…NTSB NYC84LA193Accident · No injuriesLimited investigationFinal reportCessna C172 · West Seneca, NYInexperienced FBO personnel changed rwy resulting in downwind landings. PIC accepted change though aware of wind. Acft drifted left during flare, touchdown and initial roll. The acft continued off the left side of the rwy and continued into an area of mud…NTSB CHI84LA227Accident · No injuriesLimited investigationFinal reportBarnes Firefly 7 · Flint, MIThe balloonist stated that the wind became stronger during her flt and even though she selected a landing area adequate for a high wind landing the balloon was dragged about 200 ft until the envelope became entangled in trees. The flt lasted about 1 hour and…NTSB CHI84LA220Accident · No injuriesLimited investigationFinal reportLeblanc Dragon FLY · Lansing, MIThe acft inadvertently became airborne on a high speed taxi test. The plt lowered the nose resulting in a porpoise & thecanard was damaged. The acft had not been inspected or certified by the FAA. Examination revealed that the right wing had a higher angle of…NTSB CHI84LA214Accident · No injuriesLimited investigationFinal reportStinson L-5E · Wooster, OHThe plt receiving instruction in landing conventional gear acft lost control during landing. The commercial PIC took control of the acft and his foot became jammed between the rudder pedal and airframe. The acft ground looped violently and nosed over.NTSB FTW84LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Ferriday, LAUpon landing the acft traveled off the side of the airstrip and nosed over in a small ditch. The student plt was not endorsed by a CFI for landing at this airstrip while on the x-country flight.NTSB CHI84LA208Accident · No injuriesLimited investigationFinal reportCessna 172L · Painesville, OHThe acft left the dry asphalt rwy, crossed a grassy area, went through a fence and killed a horse. The plt stated that after landing the airplane 'get pushed to rt of rwy.' Local winds were reported from 040 degs at 10 KTS. The plt had just recently purchased…NTSB CHI84LA207Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 · Plainwell, MIThe acft veered to the left side of a grass strip into taller grass which increased the drag on the left main gear. The acft swerved farther off path until a furrow was struck and the acft nosed over. Local winds were reported from 150 degrees at 8 KTS. The…NTSB SEA84LA120Accident · No injuriesLimited investigationFinal reportCessna A185E · Refuge Cove, AKThe plt stated in his report on form 6120.1 that the acft was on step during takeoff when the acft began a roll to the right. The right wing hit the water twice in spite of aileron control inputs to correct it. With the application of rudder and a power…NTSB LAX84LA323Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Novato, CAPlt lost directional control during landing roll. Acft veered off left side of rwy. Plt attempted to return to rwy and acft contacted VASI light. Gusty crosswind conditions existed. Plt's ttl flt time was 68.9 hrs.NTSB SEA84LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Fall City, WAThe acft was landed at an arpt with a narrow 25 ft rwy with tall grass on either side and partially unsurfaced. The student plt said he was blown off center line by a x-wind into the tall grass. As the acft slowed the nose wheel sunk inthe soft terrain and…NTSB MKC84LA145Accident · No injuriesLimited investigationFinal reportPietenpol-Grega GN1 · Warrensburg, MODuring a landing, the acft ran off the side of the rwy, hit a small ditch & nosed over.NTSB DEN84LA154Accident · No injuriesLimited investigationFinal reportCessna 150L · Evanston, WYPlt stated he couldn't make radio contact with the arpt and the wind sock indicated a x-wind so he elected to use rwy 34. The acft bounced during the landing. Plt stated, 'the wind shifted from a x-wind to 140 deg, causing a downwind which caused the plane to…NTSB NYC84LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Marlboro, NJThe pilot aborted his takeoff when he noted insufficient acceleration, but lost control of the aircraft, ran off the end of the runwaym thru a ditch and onto railroad tracks.NTSB NYC84LA175Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chatham, MADirectional control was lost during the takeoff ground roll with a slight quartering tailwind. Power was reduced but the acft traveled off the left side of the rwy where it collided with a tree.NTSB NYC84LA179Accident · No injuriesLimited investigationFinal reportCessna 175 · Ticonderoga, NYA student plt performing touch and go landings observed another acft at the departure end of the rwy, facing him. Assuming a collision was immenent, the plt aborted the takeoff, but locked the brakes while trying to stop. The acft swerved off the rwy, the…NTSB NYC84FA202Accident · Serious injuriesField investigationFinal reportBell 206B · Georgetown, DEAfter performing police patrol activities, the aircrew landed, refueled the helicopter, then took off to practice autorotative landings. Two autorotative landings were made on rwy 22, then 2 more were made on an adjacent grass area. After the 2nd landing on…NTSB FTW84LA238Accident · No injuriesLimited investigationFinal reportCessna 150H · Sunray, TXDuring initial climb, at an altitude of 8 to 10 ft AGL, the student plt reported experiencing 'turbulence like a down draft' & the acft settled back to the rwy. Believing that insufficient rwy remained to clear approaching power lines, the plt intentionally…NTSB ATL84LA178Accident · No injuriesLimited investigationFinal reportCessna 152 · Lacey Springs, ALWhen the plt was arriving at the uncontrolled arpt, no UNICOM was available, since the office was closed. The plt elected to land on rwy 24 after seeing another acft depart. The 1st apch was aborted due to gusty winds. After the 2nd apch, the acft touched…NTSB FTW84LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · New Roads, LAThe flt instructor stated that the 17 hr student plt was on a supervised solo flt when the accident occurred. The student was landing on rwy 18 with a wind from 220 degrees at 6 KTS. The student was unable to maintain directional control and the acft traveled…NTSB ANC84LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sand Point, AKThe plt stated that at the end of the landing roll, a strong gusty crosswind blew the acft to the left side breaking the left landing gear & wing.NTSB CHI84LA193Accident · No injuriesLimited investigationFinal reportCessna 172M · West Lafayette, OHThe acrt swerved off the rwy into soft plowed terrain and nosed over. The plt said that the wind had changed direction and velocity since his takeoff 2 hours before.NTSB CHI84IA195Incident · No injuriesIncident investigationFinal reportCessna 152 · Mansfield, OHThe plt stated that he made a normal cross wind landing and after a 5-10 ft ground roll, was blown off the rt side of the rwy.NTSB SEA84LA107Accident · No injuriesLimited investigationFinal reportCessna 180H · Bellingham, WADuring the landing roll with a cross-wind, directional control was lost & the acft ground-looped to the left collapsing the right main landing.NTSB MKC84LA141Accident · No injuriesLimited investigationFinal reportCessna 120 · Larchwood, IAThe acft nosed over after bouncing off the rwy during landing. The plt said he landed long and fast and was feeling apprehensive; when the acft bounced he released back pressure on the stick which caused a greater bounce and an excursion off the rwy. The plt…