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 FTW83LA243Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Cornerstone, ARThe acft collided with a dirt bank during a forced landing after the engine quit. The plt said he was making a swath runwhen the engine quit. The flagman said he saw black smoke then white smoke as the engine quit. Post crash investigation revealed that the…NTSB FTW83LA236Accident · No injuriesLimited investigationFinal reportPiper J3 · Sherrill, ARThe acft nosed over on an emergency downwind landing in a wet rice field after an eng failure. The plt stated that the eng failed as a result of water in the fuel. The operator services his acft from a private underground fuel storage tank. As a result of…NTSB FTW83LA235Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARAfter loading the acft with 50 gal of water, the plt took off to conduct aerial applicaiton maneuvers & to calibrate the acft's spray boom. At the end of the 1st swath run on a westerly heading, he pulled up over a power line, turned 90 deg right, reversed…NTSB FTW83LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Bentonville, ARThe pilot reported that after the acft went off the right side of the runway during landing it went through a drainage ditch and once again became airborne. After the acft landed the second time in a muddy field the nose gear collapsed resulting in damage to…NTSB FTW83LA227Accident · No injuriesLimited investigationFinal reportCessna 182P · Lonoke, ARThe eng quit after takeoff. The acft crashed in a wheat field while returning to the arpt. The carb was found full of water. The acft salvage operator reported finding a large quantity of water in the bladder-type fuel cells.NTSB FTW83LA352Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Morrilton, ARThe acft collided with trees on the final approach to land at night. The plt had canceled his IFR clearance. During the approach the plt had the rwy in sight and asked memphis center how FAR he was from the arpt. When he was informed he WAS3 miles south he…NTSB FTW83LA228Accident · No injuriesLimited investigationFinal reportCessna 182P · Searcy, ARThe plt reported that during a landing, the acft touched down hard. On touchdown, the right main gear failed & the acft veered off the rwy. After departing the rwy, the nose gear collapsed. Also, the fire wall was damaged during the landing.NTSB FTW83LA188Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Little Rock, ARThe pilot reported that prior to glide slope interception he placed his hand on the landing gear selector switch and was simultaneously told to contact the tower, which he did. As the acft approached the threshold, the throttles were retarded and props pushed…NTSB FTW83LA181Accident · No injuriesLimited investigationFinal reportCessna 320D · Carlisle, ARA private pilot was receiving multi-engine training from a CFI when the accident occurred. The CFI pulled the right throttle back for engine out training and the acft proceeded around the traffic pattern. The pilot thinks he moved the gear selector from up to…NTSB FTW83LA159Accident · No injuriesLimited investigationFinal reportCessna 150J · El Dorado, ARThe acft collided with trees after running off the end of the rwy during an aborted takeoff. The student plt made 2 touch and go landings and taxied in to have his seat fixed. After the repair he taxied out and held for about 5 minutes for traffic. After…NTSB FTW83FA144Accident · 1 fatalField investigationFinal reportCessna 172N · Mayflower, ARThe acft collided with trees while flying in a westerly direction near Mayflower, AR. The acft was returning from a cross-country at night and was observed by a group of youths who said it was flying fast at low alt. As they watched, it descended to about…NTSB FTW83LA136Accident · No injuriesLimited investigationFinal reportBellanca 7FC · Lake City, ARThe plt reported that during level flt, the eng lost power. He tried to land in an open field, but the acft struck a tree top aprx 35 to 40 ft AGL, then crashed on the ground, right wing first. The plt suspected possible carburetor ice. The temp & den point…NTSB FTW83FA128Accident · 3 fatalField investigationFinal reportCessna P-206C · Brookland, ARThe acft crashed in IMC weather after the pilot failed to complete a VOR approach to jonesboro. According to the owner of the accident acft, the plt was instrument rated and had filed an IFR flt plan but was not very proficient in instrument flying. During…NTSB FTW83LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Winslow, ARDuring dual instructional flt, the student plt was practicing a short field takeoff. After lifting off into ground effect, he elected to abort the takeoff when he did not think the acft was accelerating fast enough. The instructor pilot (CFI) stated that he…NTSB FTW83LA064Accident · No injuriesLimited investigationFinal reportBeech E33 · Little Rock, ARDuring the landing roll, all three of the landing gear retracted as the pilot was applying brakes to turn off at the first exit. FAA inspectors found the landing gear handle in the down position with the circuit breaker popped. The flaps were also found in…NTSB FTW83LA063Accident · No injuriesLimited investigationFinal reportCessna 421C · Little Rock, ARNose gear collapsed during landing. No reason for collapse found.NTSB FTW83LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Solgohachia, ARPilot overran runway and slid on grass into a tree. Pilot says he did not go-around because of rise in terrain.NTSB FTW83FA054Accident · 2 fatalField investigationFinal reportBeech A36 · Midland, ARWhen the plt filed his VFR flt plan he was observed using an IFR enroute chart. About 7 minutes after takeoff the plt requested a frequency to call for a clearance to climb on top of the overcast. Approximately 5 minutes later, as the plt was giving his…NTSB FTW83IA044Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Little Rock, ARThe aircrew reported that they broke out of the clouds at about 744 ft AGL while on an ILS approach and that the ceiling was ragged. At about 500 ft AGL, the captain turned on the windshield wipers. The first officer was flying the aircraft from thr right…NTSB FTW83FPG03Accident · 1 fatalFinal reportCessna 182L · Mt. Vernon, ARThe flt of two acft (a C-150 & N42562) departed heber springs & were in radio contact during the flt. N42562 reported over the conway, AR arpt at 2,000 ft with good visibility but indicated that there was an area of rain between conway & heber springs. The…NTSB FTW83FPG02Accident · 2 fatalFinal reportCessna R172K · Near Paris, ARThe plt & pax were on a flt from amarillo, TX to little rock, AR. An enroute stop was made at haskell, ok at appr 1900 to refuel. The owner of the afpt at haskell stated that the plane arrived in a fairly heavy rainstorm. At that time, a winter type cold…NTSB FTW83FPG01Accident · Serious injuriesFinal reportCessna 177 · North Little Ro, ARShortly after takeoff, the engine lost power. One witness stated that the engine did not completely quit. Another witness reported that it quit, but restarted and then operated with partial power. Reportedly, the aircraft remained in a nose high attitude,…NTSB FTW83LA029Accident · Minor injuriesLimited investigationFinal reportGulfstream G-164B · Pine Bluff, ARPilot just loaded seeds and tookoff when he noticed smoke and the engine lost power. During a forced landing the aircraft nosed over. Cause of power loss undetermined.NTSB FTW83LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Pine Bluff, ARThe student pilot had made several touch-and-go landings on the same runway. He stated his last approach and touchdown were normal. Reportedly, the nose gear collapsed during the landing roll. The aircraft went off the left side of the runway and flipped…NTSB FTW82DA340Accident · No injuriesFinal reportCessna 152A · Jonesboro, ARThe pilot stated that the purpose of the flight was to practice an aerobatic routine which required securing the engine at 5000 feet, executing various maneuvers and then execute a "dead stick" landing. He reported the routine was normal until he was "too…NTSB FTW82DA336Accident · No injuriesFinal reportSnow AT-301A · Leachville, ARThe pilot stated that while he was in the procedure turnaround for the third swath run. He lost elevator control. The aircraft impacted the ground and cartwheeled. Investigation revealed that the bolt connecting the elevator horn assembly and the elevator…NTSB FTW82DA334Accident · No injuriesFinal reportGrumman G164A · Marianna, ARThe pilot stated that shortly after lift off the engine backfired and lost power. He reported that the engine did not completely quit and there was no visible smoke, flame or oil coming from the engine. Due to his low altitude and heavy load the pilot elected…NTSB FTW82DA328Accident · No injuriesFinal reportPiper PA-18-150 · Devalls Bluff, ARThe pilot was flying over his farm and decided to land in a freshly plowed field. During the rollout, the main gear settled in the loose dirt and the plane nosed over.NTSB FTW82DA324Accident · No injuriesFinal reportPiper PA-25-260C · Des Arc, ARAfter pulling up from a swath run, the aircraft began to settle, then collided with the ground. This occurred after the pilot had dispensed all or nearly all of his load.NTSB FTW82DA349Accident · No injuriesFinal reportCessna 172N · Antoine, ARThe pilot stated that during the takeoff run from a private airstrip he allowed the aircraft to veer to the left and struck a drainage ditch.NTSB FTW82DA322Accident · No injuriesFinal reportCessna T188C · Altheimer, ARThe pilot stated he encountered turbulence while flying under a power line during a crop spraying operation. The left wing pitched-up and struck the power line and the aircraft went into an uncontrolable left bank. He reduced power and landed in a bean field,…NTSB FTW82DA318Accident · No injuriesFinal reportBeech 95-A55 · Conway, ARThe pilot report that he started to land on runway 18, but the wind shifted. At about 300 ft AGL, he aborted the landing and made a go-around to the right to land on runway 07. On the second approach, he forgot to extend the gear and landed with the wheels…NTSB FTW82DA315Accident · No injuriesFinal reportPiper PA-28-140 · Springdale, ARThe pilot stated taht the aircraft was at 4200 ft descending when the engine suddenly lost power. He was unable to glide to an airport so he landed on a road. During the landing, the right wing hit a road sign and was substantially damaged. After landing, the…NTSB FTW82DA296Accident · No injuriesFinal reportLake LA-4 · Springdale, ARDuring takeoff from a touch-and-go landing, the engine went to about idle power. During a forced landing, the left wing and nose collided with trees. Reportedly, the engine started developing full power just as the aircraft collided with trees. No mechanical…NTSB FTW82DA305Accident · No injuriesFinal reportAlon A2 · Poyen, ARAs the pilot approached his destination, malverne, AR, he descended into hazy conditions under a cloud layer. As he continued, he mistook Poyen, AR for malverne. He was unable to find the airport and elected to make a precautionary landing before dark. He…NTSB FTW82FPG19Accident · 1 fatalFinal reportCessna 150J · North Little Ro, ARAfter a right turn after takeoff from rwy 17 the plt declared an emergency. A witness heard the eng backfiring. The plt continued the right turn & attempted a landing on rwy 35. He was described as being too high & hot, & touched down, or almost touched down,…NTSB FTW82DA287Accident · No injuriesFinal reportGrumman G-164B · Humnoke, ARThe pilot reported that during takeoff, the left main gear got off the side of the rough airstrip and into a rice field. Subsequently, the plane flipped over.NTSB FTW82FPG18Accident · Serious injuriesFinal reportGrumman G-164A · Casa, ARThe aircraft collided with rising terrain during a procedure turn. While spraying a rice field.NTSB FTW82DA279Accident · No injuriesFinal reportGrumman G-164B · Beedeville, ARThe pilot proceeded to the job site with a load of urea. He circled for about 15 minutes waiting for the flagmen to arrive, then elected to return to the airport. As he leveled the plane, he experienced a gradual loss of power and was unable to maintain…NTSB FTW82DA276Accident · No injuriesFinal reportCessna T188C · Marvell, ARAn aerial application of an oil-based material resulted in a smearing of the windscreen. The pilot landed on a grass strip to clear the windscreen, and during, the landing, the aircraft flipped over. The pilot said when he applied brakes, the left wheel broke…NTSB FTW82DPG17Accident · No injuriesFinal reportRockwell S2R · Blackton, ARThe eng failed during a swath run & the acft struck a rice levee drg the forced landing in an adjacent bean field. After exiting the aircraft and while talking to his flagman the pilot stated the aircraft began to burn around the engine area. The fire spread…NTSB FTW82DA273Accident · No injuriesFinal reportGrumman G-164A · Mccrory, ARThe agriculture aircraft lost power during takeoff and an emergency forced landing was made in a soybean field. During the landing roll, the aircraft flipped over.NTSB FTW82DA258Accident · Serious injuriesFinal reportGrumman G-164B · Swifton, ARThe pilot was engaged in an aerial application flight over a rice field with multiple high tension wires. At the beginning of a swath run, the aircraft struck power lines and crashed. The pilot had no recollection of the accident.NTSB FTW82DPG16Accident · Minor injuriesFinal reportCallair A-9 · Hollygrove, ARThe pilot departed the Hollygrove flying service airport, made an immediate left turn, and sank into the trees east of the airport. He managed to dump the full load of chemicals before impact with the trees. The aircraft gave no indicationof any mechanical…NTSB FTW82DA244Accident · No injuriesFinal reportGrumman G-164A · Coy, ARThe pilot reported that the engine lost power as he was pulling up from a swath run. He pumped the throttle several times, the engine regained power momentarily, then quit. The pilot dumped his load and made a forced landing in a muddy field. As the plane was…NTSB FTW82DA238Accident · No injuriesFinal reportRockwell Intl S-2R · Eudora, ARSince the aircraft had not flown for two months, the pilot was on a flight to check the systems before flying for hire. The pilot flew over an unpopulated area of the Mississippi river with clear water in the spray tanks. He stated that while he as spraying…NTSB FTW82DA237Accident · Minor injuriesFinal reportGrumman G164B · Beedeville, ARThe agricultural aircraft lost power during takeoff. The pilot jettisoned the load and made a forced landing in a rice field. During the landing, the aircraft nosed over in soft muddy terrain.NTSB FTW82FPG15Accident · Serious injuriesFinal reportPiper PA-28-140 · Gould, ARThe student pilot stated that he was making a landing over wires when he stalled and the aircraft nosed into the ground.NTSB FTW82DA226Accident · No injuriesFinal reportWeatherly 201C · Lakewood, ARThe right main gear of the aircraft failed during the takeoff roll. The pilot stated that the gear failed after he had rolled about 150 ft.NTSB FTW82DA217Accident · No injuriesFinal reportGrumman G164B · Bono, ARThe aircraft was loaded with 1700 pounds of fertilizer and 70 gallons of fuel. The aircraft would not climb out of ground effect. During the forced landing the aircraft nosed over. The aircraft burned after impact.