NTSB investigations, AR
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 FTW82DA216Accident · No injuriesFinal reportCessna A188B · Gould, ARThe pilot stated that there were trees on the east end of the field that he was fertilizing and the wind was from the southwest at 15, gusting 20 KTS. The temperature was about 90 degrees. The pilot reported that when he was turning to go into the field, a…NTSB FTW82FPG14Accident · 2 fatalFinal reportAeronca 7AC · Lehi, ARThe acft was believed to have departed the west memphis arpt at approximately 1900. The acft was found at approximately 2000 in an open field 2 mi sw of the arpt. The acft had collided with the ground very hard in a nose down condition. Neither occupant…NTSB FTW82DA215Accident · No injuriesFinal reportBeech C23 · Brinkley, ARDuring a short field takeoff the pilot abruptly raised the nose of the aircraft. The aircraft drifted to the right and stalled. The aircraft crashed in an adjacent wheat field.NTSB FTW82DA207Accident · No injuriesFinal reportCessna 152 · Clarksville, ARThe pilot reported that after landing at ozark, AR, no fuel was available. Therefore, he proceeded to obtain fuel at Clarksville, AR, a distance of about 15 miles. After takeoff, he encountered moderate turbulence, leveled at about 600 ft, and reduced power…NTSB FTW82DA203Accident · No injuriesFinal reportAero Commander S2R · Lake City, ARThe aircraft departed from a soft private ag strip with a heavy load and would not climb high enough to get above wheat in a field off the end of the runway. The aircraft collided with the wheat and was subsequently destroyed by ground fire.NTSB FTW82DA198Accident · No injuriesFinal reportBell 47D1 · Jonesboro, ARAfter loading 40 gallons of herbicide on the aircraft the pilot attempted to lift off the back of the loading truck. The takeoff was normal; however, as the helicopter cleared the truck, it was not able to sustain a hover. The pilot then executed a running…NTSB FTW82FPG13Accident · 1 fatalFinal reportLuscombe 8A · Parkin, ARThe pilot departed presidents isle, TN with about 1/4 tank of fuel (3.5 gal) and proceeded en route with a planned stop at wynne, AR for fuel. Prior to reaching wynne, heavy rain was encountered and a landing was made at a private airport near Parkin, AR. The…NTSB FTW82FPG12Accident · 1 fatalFinal reportGrumman G-164 · Ethel, ARThe acft collided with power lines during the start of a swath run.NTSB FTW82DA189Accident · No injuriesFinal reportBell 47D-1 · Harrisburg, ARDuring an agricultural spraying operation the pilot turned downwind and the tail rotor struck a rice dike. The pilot lost control and the aircraft landed hard. The main rotor severed the tail boom. Investigation revealed the aircraft had been loaded within…NTSB FTW82DA188Accident · No injuriesFinal reportCessna T188C · Knobel, ARThe pilot stated that during his swath run the engine seemed to hesitate. While checking the engine the pilot collided with a levee and the landing gear separated from the aircraft. The pilot made a forced landing in an adjacent field.NTSB FTW82DA187Accident · No injuriesFinal reportGrumman G-164A · Pine Bluff, ARDuring landing the right main landing gear dropped into a ditch alongside the runway and the aircraft nosed over.NTSB FTW82DA172Accident · No injuriesFinal reportGrumman G164B · Marvell, ARDuring an aerial application process the pilot allowed the aircraft to collide with a rice levy. The aircraft was destroyed and there were no injuries to the pilot.NTSB FTW82FPG11Accident · 1 fatalFinal reportMoore Bell 47D1 · Amagon, ARThe purpose of the flight was to test the aerial spray equipment. After starting and warming the engine, the pilot took off, flew about 1/4 mi south, then flew north. A motorist stated that he saw black smoke coming from the helicopter. Two teen-agers heard…NTSB FTW82DA168Accident · No injuriesFinal reportPiper PA-34-200T · Harrison, ARDuring landing the aircraft porpoised and on the second bounce the nose gear assembly buckled, the windshield support buckled and the right windshield popped partially out of its channel. The pilot regained control and taxied in. The props and engine nacelles…NTSB FTW82DPG10Accident · Serious injuriesFinal reportCessna 188B · Glenwood, ARThe pilot became disoriented while on a ferry flight. He spotted a water tower in the town of Glenwood, AR and determined that he was about 35 miles southeast of his destination. He reported that the fuel gauge indicated between 1/4 and 1/2 full after he…NTSB FTW82DA157Accident · No injuriesFinal reportCessna 150M · Harrison, ARThe pilot was performing a low, slow pass to make a bean bag drop on a taxiway target when he lost control, collided with a ditch and nosed over. The aircraft flipped inverted. The stall warning horn was sounding during the maneuver.NTSB FTW82DA149Accident · Minor injuriesFinal reportCessna 172 · Delaplane, AROn landing the pilot noticed braking action was poor due to wet grass on the strip. The nose of the aircraft struck a soft spot on the runway, sank in and sheared off the nose gear. The aircraft then nosed over. Investigation revealed the pilot/owner had…NTSB FTW82FPG09Accident · Serious injuriesFinal reportStampe Renard SV4B · Clarksville, ARThe pilot was participating in a spot landing activity at a fly-in. He stated that he made a poor landing and allowed the aircraft to drift left and off of the runway. In order to miss the runway lights, he added power and initiated a go-around. After…NTSB FTW82DA135Accident · No injuriesFinal reportBeech S-35 · Jonesboro, ARThe pilot had completed his run-up in preparation for takeoff when he noticed smoke coming from behind the instrument panel and he exited the aircraft. The instrument panel was destroyed by fire before fire fighting equipment could extinguish the fire. No…NTSB FTW82DA128Accident · No injuriesFinal reportGrumman G-164A · Victoria, ARThe pilot reported taking off with full tanks and about 1600 lbs of fertilizer. After takeoff, he flew a short distance to the field that was being worked and made one swath run. During a procedure turn close to trees, the aircraft stalled and crashed.NTSB FTW82FA108Accident · 1 fatalField investigationFinal reportGulfstream American 690C · Hughes, ARThe acft had been on sales demonstration flts and was on a delivery flt from memphis, TN to dallas, TX. The plane was observed departing at 1550 CDT in a max performance climb. Radar info from mode c of the transponder returns indicated that the acft climbed…NTSB FTW82DA100Accident · No injuriesFinal reportCessna 310B · West Memphis, ARDuring a dual instruction engine out in a two engine aircraft a go around was attempted by the student pilot because of conflicting traffic in the pattern. The aircraft developed a high sink rate and the CFI landed the aircraft wheels up. The student raised…NTSB FTW82DA094Accident · No injuriesFinal reportGulfstream American G-164B · Holly Grove, ARThe agricultural pilot was aligning the aircraft to begin a swath run when the engine began to lose power. He noted a loss of manifold and oil pressure as well as black smoke from the exhaust. He turned away from the field and collided with trees rather than…NTSB FTW82DA088Accident · No injuriesFinal reportRockwell S-2R · Hughes, ARThe pilot attempted a downwind takeoff from a soft ag strip with a heavy load. After realizing that he would be unable to lift-off, the pilot initiated an abort. The aircraft continued off of the end of the strip and flipped over in a muddy terrain.NTSB FTW82DA083Accident · No injuriesFinal reportBeech B58 · Hot Springs, ARWhile on final approach to memorial airport the pilot stated that he heard another pilot announce that he was turning right base for landing on the active runway. The pilot on final became distracted while looking for the other aircraft and forgot to lower…NTSB FTW82DA078Accident · No injuriesFinal reportBellanca 8GCBC · Mena, ARThe pilot was flying to maintain proficiency. He had not flown this make and model within the last 90 days, but he had flown another tailwheel equipped aircraft on 12/4/81.while landing, he touched down while correcting for a crosswind, but then believed that…NTSB FTW82DA077Accident · No injuriesFinal reportCessna 152 · Arkadelphia, ARThe pilot elected to practice a forced landing pattern to a large rice field. As he passed over a stand of pine trees on final approach, he heard a loud thump. He increased power and returned to the airport. En route, he noted a dent on the leading edge of…NTSB FTW82DA067Accident · No injuriesFinal reportGrumman G-164A · Pickens, ARAt about 100 ft AGL during takeoff, the engine began to lose power. The pilot reported that he smelled a strong odor of hot metal and began a right turn to return to the airstrip. Shortly thereafter, he experienced a complete loss of power. While landing in…NTSB FTW82FRJ08Accident · 2 fatalFinal reportBellanca 7GCBC · Near Texarkana, ARDuring flight, the aircraft struck a powerline about 70 ft above the red river. The aircraft crashed in the river and drifted about 2 miles before it was recovered. The passenger's body was recovered on 03/21/82 and the pilot's body was recovered on 05/15/83…NTSB FTW82DA050Accident · No injuriesFinal reportCessna 140 · Bald Knob, ARAn estimate two hours of fuel was observed in the aircraft during the preflight inspection. About 24 minutes after takeoff, the engine lost power during takeoff from a touch and go landing. The power loss occurred at about 100 to 150 ft AGL. The instructor…NTSB FTW82DA037Accident · Serious injuriesFinal reportPiper PA-24-250 · Lonoke, ARThe pilot stated that the engine failed at 2000 ft as he was descending for an approach. He switched the fuel selector from the right tank to the left tank, turned on the boost pump, and pumped the throttle but the engine failed to start. The aircraft landed…NTSB FTW82FPG08Accident · 2 fatalFinal reportBeech 19 · Little Rock, ARThe aircraft departed north Little Rock airport sometime after 1745 and was not seen or heard from again. At approximately 1900 a witness 5 miles from the airport heard the sound of a light aircraft increasing and decreasing power just before the sound of…NTSB FTW82FPG07Accident · No injuriesClosedCessna 177RG · Little Rock, ARNTSB FTW82FPG06Accident · 1 fatalClosedPiper J3C-65 · Star City, ARNTSB FTW81IA027Incident · No injuriesClosedBeech A36 · Fayetteville, ARNTSB FTW82FPG05Accident · No injuriesClosedPiper PA-60 · El Dorado, ARNTSB FTW82DPG04Accident · No injuriesClosedCessna 182G · Hughes, ARNTSB FTW82DPG02Accident · Serious injuriesClosedCessna 177B · Crossett, ARNTSB FTW82KPG01Accident · 1 fatalClosedPitts S-1 · Jonesboro, ARNTSB FTW81DPG70Accident · No injuriesClosedAir Tractor AT-301 · Lonoke, ARNTSB FTW82FPG69Accident · Minor injuriesClosedCessna 150F · England, ARNTSB FTW81FPG65Accident · Serious injuriesClosedVans RV3 · Little Rock, ARNTSB FTW81DPG66Accident · No injuriesClosedPiper PA-23 · Jonesboro, ARNTSB FTW81DPG67Accident · No injuriesClosedAyres S2-R · Harrisburg, ARNTSB FTW81DPG64Accident · No injuriesClosedCessna A188B · Gin City, ARNTSB FTW81FPG63Accident · No injuriesClosedBeech C24R · Searcy, ARNTSB FTW81DPG62Accident · No injuriesClosedPiper PA-38 · Grubbs, ARNTSB FTW81FPG60Accident · 1 fatalClosedPiper J3C-65 · Almyra, ARNTSB FTW81FPG61Accident · No injuriesClosedPiper PA-23 · Malvern, ARNTSB FTW81DPG59Accident · No injuriesClosedAero Comdr S2R · Swifton, AR