NTSB investigations, AR
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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.\"eventStateOrRegion\" = 'AR' AND c.\"eventCountry\" = 'USA' 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."eventStateOrRegion" = 'AR' AND c."eventCountry" = 'USA' 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 MKC87LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Widener, ARThe ag airplane was making the final swath run over a cottonfield when the engine lost power. After touchdown in a ricefield, the airplane flipped forward to the inverted position. The reason for the power loss could not be determined.NTSB MKC87LA151Accident · No injuriesLimited investigationFinal reportCessna 150F · Bono, ARThe pilot said he had glided down to 500 feet AGL with the throttle reduced to idle trying to locate a landing strip. He said he applied power and the engine responded too late to avoid hitting a levee in the rice field and he flipped to the inverted position.NTSB MKC87LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Forrest City, ARWhile doing a repositioning operation, with an ag acft, the engine quit, due to fuel exhaustion. The PIC said that a visual inspection of the fuel supply would have prevented the accident. He said that in an attempt to turn back to a dirt strip, the acft…NTSB MKC87DPG02Accident · Serious injuriesFinal reportPiper PA-25-235 · Hazen, ARThe pilot stated to a witness that after coming out of his 2nd pass, in the last 1/3 of his procedural turn, the plane stalled and the right wing struck a telephone wire which caused it to swing onto a gravel road. It hit left wing/nose down, bounced, and…NTSB MKC87LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Waldron, ARThe plt said he was on a x-country for his commerical cert. He checked enroute wx for the return trip and was told VMC prevailed. However he rptd that he encountered haze & clouds. He let down to VMC but after he got in the clear all he could see was…NTSB MKC87LA134Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Benton, ARDuring a positioning flt to pick up revenue passengers, PIC neglected to lower ldg gear for ldg. Acft was substantially damaged. PIC stated he forgot to lower gear and no warning horn had activated.NTSB MKC87LA132Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Russellville, ARDuring the night approach, the pilot saw the reflection of orange balls on a powerline. He added power and went over the powerline, then reduced power to land and stalled the aircraft short of the runway. The nose gear broke off and the airplane slid 200…NTSB MKC87LA133Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mcdougal, ARThe ag airplane was on takeoff roll when the pilot smelled smoke in the cockpit. He stopped the airplane and turned off the fuel and switches before evacuating the airplane. He said the flames were coming from the cowling around the engine. Due to the total…NTSB MKC87LA129Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Bull Shoals, ARThe pilot stated the winds were four to five mph from the sw as he departed and he could see thunderstorms four or five miles to the west. He overflew his destination when he saw large waves on the water. He landed in a smooth-water cove and was taxiing…NTSB MKC87LA125Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Hazen, ARThe PIC was returning to base of operations after completing an aerial application operation. Enroute, PIC experienced an engine failure and made a forced ldg in a farm field. After touchdown, acft nosed over and was substantially damaged. Subsequent…NTSB MKC87FA121Accident · Serious injuriesField investigationFinal reportTaylorcraft BL-65 · Hope, ARThe PIC had last student certificate and medical in 1978. On this flight with passenger, takeoff was made from rough hay meadow, 1372 feet long. When airplane could not climb over powerline at end of meadow, pilot decided to fly under powerline. Right wing…NTSB MKC87LA115Accident · No injuriesLimited investigationFinal reportAyres S2R600 · Lepanto, ARThe PIC had taken off for a LCL aerial operation. Enroute PIC had an engine failure and made a forced ldg in a muddy field. PIC applied brakes and acft nosed over. The exhaust rocker arm box on no. 3 cylinder was found to be cracked keeping exhaust valve in…NTSB MKC87LA114Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Knoble, ARThe PIC had taken off for a local aerial application operation. While maneuvering to make initial application the acft started to lose power and sink during a downwind turn. PIC dumped his load but acft continued to sink until one wing struck the terrain and…NTSB MKC87LA113Accident · No injuriesLimited investigationFinal reportAyres S2R600 · Paragould, AREn route to a local aerial application operation PIC experienced a total engien failure. During subsequent emergency landing in a farm field the acft was substantially damaged. No reason could be determined for the engine failure.NTSB MKC87LA108Accident · No injuriesLimited investigationFinal reportCessna 150L · Harrison, ARThe pilot said he was landing into the wind and when he was 20 feet above the runway, the wind seemed to shift to a tail wind. The airplane stalled, hit the runway hard and bounced. The pilot said he pushed the control wheel forward and the nose wheel hit the…NTSB MKC87LA107Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Newport, ARThe pilot stated that he was spraying a rice field in formation with another airplane when his aircraft experienced an inflight upset due to the propwash, or wake turbulence, generated by the other aircraft. The landing gear struck a rice levee and was…NTSB MKC87LA105Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Knobel, ARThe PIC stated that the acft was struck by a gust of wind, and he lost control. The PIC applied rt rudder towards a 1OFT ditch in an att to get over it. The acft was too heavy to fly over the ditch and the acft impacted into the ditch. A review of wx cond's…NTSB MKC87DPG01Accident · 1 fatalFinal reportCessna A188B · Lake Village, ARAfter completing several spary swaths, the pilot began another turn for another spray swath. A witness stated that during this right turn, the aircraft initiated a left descending turn and crashed into nearby trees and then burned. Examination found no…NTSB MKC87LA102Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Fayetteville, ARThe PIC was demonstrating the helo to a prospective customer. The PIC was hovering in a remote area with rough and uneven terrain. The PIC rptd outside air temps of abt 90 degrees during the demo flt. The PIC stated that he was moving around over the grnd in…NTSB MKC87LA098Accident · No injuriesLimited investigationFinal reportCessna 172F · Blythville, ARThe eng started to slow down ten miles from the destination arpt and despite emergency measures, it stopped two miles out. The forced landing was in a plowed field and when the nose wheel dug in, the acft flipped forward to the inverted position. The…NTSB MKC87LA095Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brinkley, ARThe acft had 100 gallons of water onboard for the ag training flt. The plt has completed one spray pass and was half way through the turnaround when the acft stalled. It collided with the ground and flipped forward to the inverted position. The plt listed 80…NTSB MKC87LA091Accident · Minor injuriesLimited investigationFinal reportBeech V35B · N Little Rock, ARThe acft was on a short ferry flt when the fuel pressure decreased and could not be restored. During the final apch of the forced landing on a city street, the acft struck a ground wire and fell to the street. Due to the intense fire that followed, the reason…NTSB MKC87LA086Accident · No injuriesLimited investigationFinal reportCessna 150 · West Memphis, ARThe acft was flown 1.6 hrs on a previous flt since being topped off with fuel. At the end of 2 hrs and 11 mins, during the accident flt, the eng quit. The fuel tanks were found to be empty with no broken fuel lines. During the post accident exam, it was found…NTSB MKC87LA063Accident · No injuriesLimited investigationFinal reportGlasair SH2 · Springdale, ARImmediately after takeoff, the engine stopped and the acft collided with trees and then the terrain. Inspection revealed contamination in the fuel tank, the lines and the filter. Contamination was water, dirt, straw and gravel. The fuel being used was regular…NTSB MKC87LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Carlisle, ARThe PIC was climbing enroute to a field to spread fertilizer. Abt 2 minutes into the climb the acft eng quit. The forced landing substantially damaged the acft. The PIC commented in his rpt that he should have checked fuel before departure even though he had…NTSB MKC87LA050Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A-600 · Hazen, ARThe pilot stated that he had flown six loads of wheat seeds and was returning to a private airstrip for another load when he ran out of daylight while on final approach to a landing. During the time he was considering the option of a rejected landing and a…NTSB MKC87FA048Accident · 1 fatalField investigationFinal reportCessna A150K · West Memphis, ARThe airplane was making low passes over the edge of a trailer park and at the end of each pass, it would climb almost straight up and then make a steep banked turn and dive for another pass. At the end of the last pullup, the airplane made an abrupt steep…NTSB MKC87LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Flippin, ARThe pilot stated that immediately upon touchdown, the nose slowly descended to the runway. The airplane slid for 450 feet before it stopped. A support bracket and an angle was found broken. It has not been determined if the parts were broken before or after…NTSB MKC87LA041Accident · Minor injuriesLimited investigationFinal reportBeech BE-77 · Arkadelphia, ARThe student pilot was landing at the home airport after her solo cross-country flight when the airplane went off the left side of the runway. It rolled across a grassy area and then went into a large water/mudhole. The nose gear collapsed when it impacted the…NTSB MKC87LA039Accident · No injuriesLimited investigationFinal reportCessna 120 · Salem, ARThe airplane was being ferried when the engine failed. The only available field had cattle, hills and trees. On landing roll the pilot had to brake hard to avoid trees. The airplane nosed over to the inverted position. Inspection revealed total engine failure…NTSB MKC87LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Forrest City, ARThe student pilot was landing after one leg of a solo cross-country flight. The airplane ran off the right side of the runway and into a small drainage ditch.NTSB MKC87FA037Accident · 1 fatalField investigationFinal reportCessna T210N · Sherwood, ARThe PIC dptd morristown with 600# of cargo as part of a rnd trip to mcalester, okla. Headwinds at alt were avg 45 KTS. The PIC had asked for 60 gal before the departure but rcvd 59.1. Aft several hrs in cruise flt, the PIC notified memphis cntr ctrlr that a…NTSB MKC87IA034Incident · No injuriesIncident investigationFinal reportEmbraer Brasilia EMB-120 · Fort Smith, ARThe flight crew stated that they were initiating a descent into final approach for a landing when the right engine gearbox chip detector lgith illuminated followed by a loud bang and severe vibration. When the propeller was feathered and the engine shut down…NTSB MKC87LA032Accident · No injuriesLimited investigationFinal reportCessna 172P · Pine Bluff, ARThe pilot stated he had flown over trees from the southeast and descended to 50 ft. upon seeing trees in front of the acft he turned left, away from the trees. The left wing touched the ground followed by the nose gear. The acft then flipped forward to the…NTSB MKC87LA028Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B-600 · Earle, ARThe pilot stated that the powerplant was performing normally during initial climb when, suddenly, the engine experienced a power loss after backfiring. Immediate remedial action resulted in a partial power output but not enough to sustain flight. Emergency…NTSB MKC87LA029Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Dumas, ARThe plt stated that he was operating VFR out of ft. lauderdale, Florida, when he encountered IMC weather close to valdosta, Georgia. At this point, the plt further stated, he air-filed an IFR flight plan but elected not to land and refuel. According to ATC…NTSB MKC87LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Harrison, ARThe routine business flt had progressed normally until approaching bentonville, Arkansas. The PIC rptd his eng ran rough for a very brief period and quit. Emerg procedures were conducted but a restart was impossible. Only 1.5 hrs of flt had transpired since…NTSB MKC87LA024Accident · No injuriesLimited investigationFinal reportCessna 177XP · Camden, ARThe pilot stated he was on approach during IMC and had the airport in sight when he flew into another cloud and had started a missed approach when he collided with a tree. He completed the missed approach and diverted to monroe, LA.NTSB MKC87LA018Accident · No injuriesLimited investigationFinal reportCessna 150H · Flippin, ARWhile the student pilot was practicing touch-and-go landings, the airplane ran off the side of the runway, hit a ditch and flipped forward to the inverted position. The pilot stated he thought one of the brakes had locked. There was no signs of excessive…NTSB MKC87FA017Accident · 1 fatalField investigationFinal reportBeech E18S · Texarkana, ARThe airplane was on a positioning flight so it would be in place for an early Monday morning freight run. Pilot called for missed approach and after receiving clearance, declared he was in VFR conditions and thought he would land on rwy 31. During a turn, the…NTSB MKC87LA013Accident · No injuriesLimited investigationFinal reportMooney M20D · Johnson, ARThe plt had attempted a localizer apch to fayetteville, AK, and stated that his VOR indicator would not hold course. The plt then elected to abort the apch and land at a pvt strip near the fayetteville VOR. The plt was able to land at the strip but according…NTSB MKC87FA012Accident · 2 fatalField investigationFinal reportPiper PA-24 · Siloam Springs, ARThe plt had logged 3 hrs of simulated instrument training prior to this accident. He received a wx briefing which reported wx conditions nearby were IFR due to low ceilings and fog. Immediately after takeoff, the acft started a left turn and impacted terrain…NTSB MKC87LA009Accident · No injuriesLimited investigationFinal reportCessna 501 · Little Rock, ARThe PIC stated that he had to fly a faster than normal apprch to the outer marker for the ILS apprch as instructed by apprch control. Apprch cntl indicated that a Boeing 727 was no. 2 for the apprch and that the PIC should maintain 230 KTS till further…NTSB MKC87LA006Accident · No injuriesLimited investigationFinal reportCessna 421C · Hot Springs, ARThe pilot stated that gear went down normally, he had three green lights and the gear warning horn was not on and he could see that the nose gear was down by looking in the nacelle mirror. After touchdown, the nose was lowered and as it touched the runway,…NTSB MKC86LA199Accident · No injuriesLimited investigationFinal reportBell 206A · Texarkana, ARThe pilot stated that the left front passenger raised the collective pitch control by mistake while trying to open the cabin door. According to the pilot, the rotor system was between 65-70 n 1 , and the throttle at flight idle. When the helicopter achieved…NTSB MKC86FA179Accident · 2 fatalField investigationFinal reportLockheed 18-56 (Howard 250) · Texarkana, ARWhile apchg for a lndg, the acft pitched up, rolled inverted & impacted the terrain to the left of the rwy. No preimpactpart failure/malfunction was fnd; however, an inv revealed the acft had been loaded with the center-of-gravity (CG) wellbehind the aft…NTSB MKC86LA176Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hope, ARThe CFI stated that the landing gear collpased during landing roll as he raised the flaps. The student, a commercial plt, was applying power for a touch and go at the time. Post accident examination of the landing gear system failed to disclose any…NTSB MKC86LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Goodwin, ARThe ag acft was being used to spray nudrin on soybeans when the engine lost power. The plt made a forced landing in a rice field and the acft flipped forward to the inverted position. Investigation revealed the two-piece cam reduction gear came apart. An AD…NTSB MKC86LA162Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Dumas, ARThe pilot stated that after takeoff, during initial climb, he heard grinding metal and smelled hot metal before the engine slowed down and seized. After crash landing in a corn field, the pilot further stated, he noticed smoke coming from the engine…NTSB MKC86LA161Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Lewisville, ARThe PIC made a landing to a rain soaked sod rwy when the acft's right main gear fell into a large mud hole during the landing roll and the acft flipped inverted. The subsequent flipping action substantially damaged the acft.