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 MKC89FA159Accident · 6 fatalField investigationFinal reportCessna U206 · Pettigrew, ARImproper planning/decision by the pilot, his VFR flight into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related the accident were: the adverse weather conditions, high terrain, the…NTSB MKC89LA146Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Lonoke, ARPartial failure of the power-plant for undetermined reasons.NTSB MKC89LA142Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Waldenburg, ARThe total failure of the engine supercharger which resulted in a loss of engine power.NTSB MKC89FA136Accident · 1 fatalField investigationFinal reportNorth American AT-6D · Earle, ARThe pilot's improper planning/decision and over confidence in his flying ability, which resulted in a loss of control, while maneuvering at low altitude. The pilot's inadequate altitude and airpeed were considered to be contributing factors.NTSB MKC89LA134Accident · No injuriesLimited investigationFinal reportGrumman G164 · Brinkley, ARThe failure of the aircraft engine due to water contamination. The pilot executed a landing in a flooded rice field which did not permit a successful landing.NTSB MKC89LA129Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Wynne, ARUnsuitable terrain selected by the pilot. A contributing factor was the rough/uneven landing area.NTSB MKC89LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Pine Bluff, ARImproper in-flight planning/decision by the pilot by continuing the approach when the runway lights did not activate. Contributing factors were: dark night and soft terrain.NTSB MKC89LA121Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Snow Lake, ARThe selection of unsuitable terrain to takeoff from by the pilot and the inadequate runway maintenance by airport personnel. Contributing to the accident was the hidden hole which the airplane contacted resulting in the pilot's inability to control the…NTSB MKC89LA119Accident · Minor injuriesLimited investigationFinal reportRockwell Thrush S2R · Carlisle, ARThe engine failed due to a cracked cylinder and the pilot was forced to attempt a landing in a rice field where the gear collapsed.NTSB MKC89FA117Accident · Serious injuriesField investigationFinal reportCessna 172M · Oakland, ARPilot electing to buzz persons on the lake at low altitude and colliding with power lines.NTSB MKC89LA118Accident · No injuriesLimited investigationFinal reportBeech V35 · Strong, AREngine failure due to fuel starvation.NTSB MKC89FA110Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Winslow, ARThe pilot flying into adverse weather conditions which resulted in the in-flight separation of a portion of the right wing. Contributing to the accident was the pilot's lack of total experience.NTSB MKC89LA105Accident · No injuriesLimited investigationFinal reportWeatherly 620TP · Montrose, ARFailure of the pilot in command to maintain control of the aircraft during landing adversely affected by the existance of a tailwind of average proportions.NTSB MKC89LA098Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Brinkley, ARThe pilot's failure to gradually raise the flaps during the go-around and maintain adeqaute airspeed to continue the climbout.NTSB MKC89LA095Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Hot Springs, ARA wheels up landing was performed by the pilot in command, due to the interrupted landing and go-around. A psychological traffic pattern habit interference mind set interfered with the pilots ability to perform the normal functions required by the landing…NTSB MKC89LA089Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARImproper planning/decision by the pilot, and his misjudgement of clearance between the airplane, wires, and the ground during the aerial application maneuver. Factors relating to the accident were: the dirty windshield, sunglare, transmission line (wires),…NTSB MKC89FA083Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Mayflower, ARThe pilots failure to maintain airspeed (vs), and inadvertant entry into a stall with necessary remedial action not understood.NTSB MKC89LA081Accident · No injuriesLimited investigationFinal reportRockwell S2R T34 · Heth, ARAircraft control not maintained by the pilot in command due to landing in a tailwind of excessive velocity which the pilot misjudged or failed to recognize.NTSB MKC89LA080Accident · No injuriesLimited investigationFinal reportCallair A9-B · Fisher, ARFailure of the engine magneto resulting in engine failure.NTSB MKC89LA079Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARFailure of the engine blower assembly drive shaft, while maneuvering at low altitude, and failure of the pilot to maintain adequate airspeed, which resulted in a stall before he could land.NTSB MKC89LA075Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARAn engine fire during engine start for undetermined reasons.NTSB MKC89LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Griffithville, ARThe failure of the pilot to assure suitable terrain was being used for the landing.NTSB MKC89LA068Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Harrisburg, ARThe failure of the hydraulic line which rendered the brake system inoperative.NTSB MKC89FA063Accident · 2 fatalField investigationFinal reportPiper PA-18 · Jacksonville, ARSevere corrosion of the left forward wing lift strut which resulted in the in-flight separation of the left wing. A contributing factor was inadequacy of the applicable service bulletin.NTSB MKC89FA061Accident · 2 fatalField investigationFinal reportBeech 58 · Hamburg, ARThe pilot continued VFR flight into IMC conditions and failed to maintain sufficient altitude above the wooded terrain. Weather conditions, low light conditions at or near dusk, lack of visual cues (visual perception) by the pilot, and trees were contributing…NTSB MKC89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jacksonville, ARDuring a local familarization and acceptance flight for the new acft owner, smoke entered the cockpit and oil pressure was lost. A precautionary emergency ldg was attempted on a soft, muddy, plowed farm field, resulting in substantial damage to the acft.…NTSB MKC89LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lakeview, ARDuring a personal cross country flight, the newly certificated private pilot said he was attempting to land on a 3200 foot grass strip with an existing gusting crosswind. He lost directional control during the landing, hit a runway light, tearing off the left…NTSB MKC89LA030Accident · No injuriesLimited investigationFinal reportCessna 170A · Mccrory, ARThe student pilot and passenger said after about 10 minutes of local flight, they experienced a partial power loss. An emergency ldg was attempted on a near by rural strip, but the plt said he had excess airspeed and was unable to land successfully. The…NTSB MKC89FA027Accident · 6 fatalField investigationFinal reportBeech E-90 · Locust Grove, ARThe pilot's failure to maintain obstacle clearance altitude and exceeding the minimum descent altitude published in the approach procedure.NTSB MKC89LA023Accident · No injuriesLimited investigationFinal reportStearman B75N1 · Benton, ARThe flt was uneventful until the landing at the saline county arpt, Benton, ark. The PIC stated he applied too much brake and applied it prematurely during the landing roll and the acft nosed over to the inverted posn. The resultant impact crushed the…NTSB MKC89LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mena, AROn left crosswind leg, during initial climb, the aircraft experienced a total loss of power. The acft had reached about 800 feet AGL and was about 1 1/2 miles from the departure end of the runway. An emergency ldg was attempted which resulted in substantial…NTSB MKC89FA017Accident · Serious injuriesField investigationFinal reportCessna T210M · Clarksville, ARThe pilot took off on a 4500 ft runway, raised the landing gear, and turned south at approximately the 2500 ft point. Aircraft lost engine power. Pilot attempted to return to departure runway. Aircraft impacted prior to reaching the runway. Examination of the…NTSB MKC89FA007Accident · 2 fatalField investigationFinal reportCessna T210F · Rogers, ARContinued flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain aircraft control after becoming disoriented. Contributing factors were: dark night, low ceilings, fog, drizzle, obscuration, and failure of the pilot to…NTSB MKC89DPG01Accident · 1 fatalFinal reportCulver LFA · Dumas, ARA witness stated that the airplane backfired while in a turn at low altitude. He heard it backfire twice more and noticed engine running at idle just before it crashed. When runup, the engine would attain 1900 RPM, then backfire and the RPM would drop to 600…NTSB MKC89LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · West Memphis, ARThe pilot said he was unable to activate the runway lights on the designated frequencies during a night personal flight. He attempted to land without the aid of the runway lights, and touched down on the FAR end of the runway subsequently running off the end…NTSB MKC88LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Harrison, ARWhile in normal cruise flt, the plt declared an emergency. He stated the eng had failed & that he thought it had 'thrown a rod.' Subsequently, the acft was extensively damaged drg an emerg landing in a wooded area. An investigation revealed the #6 connecting…NTSB MKC88FA183Accident · 3 fatalField investigationFinal reportBeech D55 · N. Little Rock, ARThe pilot had been executing a vor/dme rwy 35 instrument approach to north Little Rock muni (1M1). The PIC called 'missed approach' a short time aft having been clrd to execute the instrument apprch. Apprch control attmptd to provide instructions to the PIC…NTSB MKC88LA181Accident · No injuriesLimited investigationFinal reportBeech 77 · Friendship, ARThe CFI rprtd he was demonstrating an emergency landing to a pvt rated plt & confusion (about who was flying the acft) resulted in a commitment to land. The landing was made on a gravel road. During the roll-out, the acft veered into a ditch & was damaged.NTSB MKC88LA150Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Weiner, ARThe pilot handproped the starterless aircraft. After engine start, the pilot was unable to gain access to the cockpit, and the aircraft taxied uncontrolled into some nearby farm implements. The purpose of the flight was to ferry the acft for an annual…NTSB MKC88LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Elaine, ARDuring an aerial application operation, the pilot said that immediately after breaking ground on takeoff, the engine quit. He attempted to re-land on the remaining available runway, but ran off the end, hitting a ditch and nosing over. Cause of the engine…NTSB MKC88LA161Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARWhile en route to engage in an aerial application operation, the plt said the engine began to misfire and cut out. Unable to correct the malfunction, the plt dumped his chemical load and began returning to the departure airstrip. En route, he felt he would…NTSB MKC88LA158Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Humphrey, ARWhile attempting to land on a narrow dirt road bordered by crops, the plt said he contacted the high vegetation on the right side. The acft began to veer to the right. The plt attempted to steer to the left and veered off the roadway into a ditch and nosed…NTSB MKC88LA159Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Swifton, ARShortly after takeoff during an aerial application operation, the pilot said he was unable to establish a positive climb. After traveling about 1 mile, he elected to dump his dry fertilizer load. When he dumped the load, the increased aerodynamic drag caused…NTSB MKC88FA154Accident · Serious injuriesField investigationFinal reportBoeing 737-222 · Little Rock, ARThe sked air carrier flt was aborted after the capt heard a noise and felt a vibration emanating from the left side of the acft, which at the time, was perceived as a 'blown' tire. The acft was subsequently stopped on the active rwy, and an order fm the…NTSB MKC88LA152Accident · No injuriesLimited investigationFinal reportCessna 150 · Coy, ARWhile practicing for his pvt plt check ride, the student pilot returned to the airstrip to practice takeoffs and ldgs. He lost all power on final approach, and due to aircraft on the departure end of the runway, he attempted an emergency ldg on an adjacent…NTSB MKC88LA148Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Tarry, ARThe pilot said the engine quit abrubtly during an aerial application turn around maneuver. He attempted to land in a nearby farm field and because of the soft terrain conditions, the acft nosed over during the roll out. Post accident investigation revealed a…NTSB MKC88LA145Accident · No injuriesLimited investigationFinal reportGrumman G-164B · West Helena, ARThe plt said, while enroute to an aerial application operation, the engine lost power and an emergency ldg was made into the trees. Post accident investigation revealed that an intake valve on number 9 cylinder had failed.NTSB MKC88LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Cherry Valley, ARThe plt said that shortly after takeoff, he had a partial power loss. He dumped his chemical load and attempted to return for landing. While turning the engine suffered a complete loss of power. He attempted to land, but on the roll out, acft nosed over in…NTSB MKC88DPG02Accident · 2 fatalFinal reportSnow 600-S2C · Almyra, ARTwo ag aircraft were spraying the same field. According to several witnesses, 1671S was heading south and 3660X was heading east. Both aircraft were actively engaged in the spraying operation but did not seem to the witnesses to be coordinating with each…NTSB MKC88LA141Accident · No injuriesLimited investigationFinal reportRockwell S2R · O'Kean, ARWhile performing an aerial application operation, the plt said he experienced a total powerplant failure. He attempted an emergency ldg in a cultivated rice field. During the ldg attempt, the aircraft sustained substantial damage to the propeller, landing…