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 MKC84FA263Accident · 2 fatalField investigationFinal reportRockwell S-2R · Palestine, ARAfter an aerial spray operation, the plt took a passenger aboard the single place acft for a 'ride around the field.' Witnesses said the pax sat to the rgt of the plt in the cockpit. After takeoff to the east, the plt returned for a low pass down the rwy in…NTSB MKC84FPG01Accident · Serious injuriesFinal reportRobinson R22 · Frenchman'Bayou, ARThe acft crashed during autorotation into a soy bean field after the engine lost power. The plt was a student who did not have authorization to fly nor the proper certificate and endorsement from the CFI. The acft engine stopped due to fuel exhaustion. The…NTSB MKC84LA259Accident · No injuriesLimited investigationFinal reportBeech A36 · Carlisle, ARThe acft landing gear collapsed during landing. After electrical failure the plt had cranked the gear down in flt. Inspection revealed that a nut on the alternator ground wire had come off. The landing gear manual extension system had no deficiencies.NTSB MKC84LA257Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Flippin, ARThe acft ran off the departure end of the rwy during landing and collapsed the landing gear. The acft landed between 1/3AND 1/2 way down the rwy. The acft had been in rain showers and the rwy was wet. The plt applied brakes but braking was ineffective and the…NTSB MKC84LA255Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Marianna, ARThe landing gear contacted the bean crop which was being sprayed with sodium chlorate and the acft nosed over.NTSB MKC84FU007Accident · Serious injuriesFinal reportGemini Int'l. Hummingbird · Mount Hope, ARThe newly acquired ultralight had been flown for about 10 hours during the 2 week period of ownership. On this day, the wind was blowing at 15 mph and the owner was flying downwind over a hay field at about 50 ft AGL when the right engine on the twin engine…NTSB MKC84LA250Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARDuring a swath run the #9 cylinder on the radial engine separated. A forced landing was made during which the acft landed in a levee and nosed over.NTSB MKC84LA247Accident · Minor injuriesLimited investigationFinal reportDarrell W. MC Moran Monnett Moni · El Dorado, ARAfter lift-off on initial test flight of this homebuilt acft, the engine ceased to develop full RPM. The plt was unable to establish a rate of climb to clear terrain obstacles in the flight path, colliding first with tree tops and then the ground. Plt…NTSB MKC84LA242Accident · No injuriesLimited investigationFinal reportAyres S2R · Rohwer, ARThe plt was unable to maintain alt after the engine failed. A forced landing was made in a field covered with 4 to 6 ft tall weeds. The acft traveled sideways during the landing. After the accident, the plt observed a broken rod which had penetrated the…NTSB MKC84FA240Accident · Minor injuriesField investigationFinal reportCessna A188B · Stonewall, ARWhile engaged in aerial application, two acft working the same field collided in-flight. Pre-flight planning and briefing for the dual operation was not conducted. There were no inter-plane communications.NTSB MKC84FA225Accident · 1 fatalField investigationFinal reportBobby Wayne Watkins Mini Coupe · Nashville, ARThe builder/owner/plt had flown the home built acft for about 10 mins on its 1st test flt which was made a few days prior to the accident. On third flt, he took off on rwy 01, climbed straight-out for awhile, made a left turn to x-wind leg & started a…NTSB MKC84LA228Accident · No injuriesLimited investigationFinal reportAero Commander Thrush S2R · Waldenberg, ARWhile on takeoff roll one propeller blade separated and the engine came loose from the engine mounts. The acft was then stopped on the rwy.NTSB MKC84LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Pollard, ARThe plt stated that he was spot spraying a bean field and was aware of the location of the electrical transmission line. As he attempted to maneuver the acft under the line, a wing made contact with the line and the acft inpacted the ground.NTSB MKC84LA222Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Stanford, ARWhen the pilot made his first swath run he flew over a set of wires, on the return run he went under the wires. The pilot said he hit his own prop wash and rolled enough for the wing tip to contact the wire.NTSB MKC84LA211Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roe, ARAs a result of a supercharger failure, a partial power loss was experienced during a swath run. During the landing roll after a forced landing, the acft nosed over & came to rest inverted. An eng teardown revealed that both supercharger bearings had failed…NTSB MKC84LA215Accident · No injuriesLimited investigationFinal reportCessna 172H · Marvell, ARThe acft collided with telephone lines as the plt was making a low pass over the passengers place of business. The plt said he did not know the lines were there when his passenger asked for the low pass. The acft stalled and contacted the ground on the…NTSB MKC84LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARThe acft crashed into a levee in a rice field after losing engine power during a spray operation turn-around. The enginedid not quit entirely but lost enough power so that flt was not maintained. An inspection of the engine revealed a broked connecting rod.NTSB MKC84LA213Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillette, ARDuring swath run engine ran rough and could not sustain acft in flight. The plt made a forced landing in a soft freshly plowed field. The acft nosed over during the landing. Inspection of the acft revealed that one magneto was missing teethfrom the drive gear…NTSB MKC84LA209Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · West Memphis, ARThe acft nosed over during an off arpt forced landing following an engine failure. During post accident examination the acft was found to have a cracked #7 cylinder.NTSB MKC84LA210Accident · No injuriesLimited investigationFinal reportGrumman G164B · Mc Gehee, ARThe acft was engaged in an aerial application flt when the eng lost power. The plt made a forced landing in a bean field. During the landing roll, the acft struck a levee that was obscured by high vegetation & nosed over. A post-accident investigation…NTSB MKC84LA208Accident · No injuriesLimited investigationFinal reportCessna 337G · Hickory Ridge, ARThe plt was on a business trip to Hickory Ridge, AR. He stated that he landed at wynne, AR, but could not rent an auto to proceed to Hickory Ridge. The FBO stated that there was a 3200 ft crop dusting strip at Hickory Ridge, so the plt elected to fly there.…NTSB MKC84LA204Accident · No injuriesLimited investigationFinal reportCessna 172M · Colt, ARThe pilot stated that he made his final approach to the rwy at 70 mph and the aircraft floated when he flared for touchdown. He continued to state that after acft touched down, insufficient runway remained to stop before overrunning the runway and impacted a…NTSB MKC84LA199Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Sherrill, ARThe plt stated he was landing with a slight tailwind & the new brake system on the acft was sensitive. During touchdown,the acft nose over.NTSB MKC84FA197Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Wright, ARDuring aerial application, the plt was making a left turn over high voltage power lines when the acft hit the cables, crashed & burned in a rice field. An exam revealed 2 wire marks & 2 electrical arc marks on the left wing along with wire marks on one of the…NTSB MKC84LA233Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · No Little Rock, ARThe pilot-in-command was hired by the student pilot/aircraft owner to perform the passenger flight. No experience or currency records are available on the PIC as he had not held an airman's medical certificate for the last four years. On landing at…NTSB MKC84LA196Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Wynne, ARShortly after landing on rwy 16 the pilot noticed an aerial application acft lined up to land on rwy 34. Heavy braking was applied. The acft struck a rwy light, nosed over and came to rest inverted. The aerial application acft did not have a radio. It…NTSB MKC84LA178Accident · No injuriesLimited investigationFinal reportSnow AT400 · Portland, ARBoth acft were about to touch down. N501PR was above N501JS. The pilot of N501PR stated that just before touchdown the collision occurred and resulted in severing of the tail section of N501PR. The pilot of 501JS stated N501PR flared out to land directly in…NTSB MKC84LA180Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Pocahontas, ARAbout 18 inches of one propeller blade separated in flight. The acft began to shake violently and the plt shutdown the engine. The aircraft crashed during the forced lndg. Metallurgical examination revealed features typical of fatique cracking over aprox 2/3…NTSB MKC84LA172Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Gould, ARThe plt departed with a heavy load, & during a turn after takeoff, the acft began to settle. The load was dumped & the plt said he was applying full power, but the acft continued to mush & crashed about one mile from the airstrip.NTSB MKC84LA171Accident · No injuriesLimited investigationFinal reportCessna 150J · El Dorado, ARThe acft collided with a ditch while taxiing after landing. The plt was attempting to make a 180 degree turn on the rwy. She said she turned right to allow more room to swing left. She said that she was then unable to depress the left rudderpedal. The acft…NTSB MKC84LA165Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Harrisburg, ARThe acft's landing gear collided with a levee during a swath run. The acft then slowed & hit other levees. The plt dumped his load, but the plane crash landed & nosed over.NTSB MKC84LA166Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Pocahontas, ARThe plt said he was making a cleanup swath & encountered spray from the previous swath run. The spray contains a dye which covered the windshield & obscured the plt's vision. The plt said he pulled up at the end of the field but failed to clear the trees.…NTSB MKC84LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Carlisle, ARA ttl loss of pwr occurred during the second swath run. Plt made forced landing in a rice field containing aprx 6 to 7 inches of water at which time the acft nosed over. Plt stated water was found in the carburetor after the accident. Acft was fueled before…NTSB MKC84LA160Accident · No injuriesLimited investigationFinal reportCessna 188 · Mcgehee, ARThe acft ran out of fuel during an approach to the arpt & landed short of the strip. During the landing, the left main gear collapsed. The plt thought he had about 8 gal of fuel remaining.NTSB MKC84FA156Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Wickes, ARThe acft was force landed in an open rolling field after the engine lost power. The plt said the engine produced a rattling noise and vibration before the loss of manifold pressure. Post accident examination showed a failed #3 connecting rod and cylinder.NTSB MKC84LA154Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARWhile the plt was spraying rice, the left main gear of the acft struck a levee of a rice field & separated. The plt then proceeded to a nearby field for a landing. After a slight landing roll on soft terrain, the acft nosed over.NTSB MKC84LA152Accident · No injuriesLimited investigationFinal reportAyres S2R · Wilmot, ARPlt stated a loss of pwr occurred shortly after takeoff at an alt of 100 ft AGL. The acft nosed over during the forced landing. Inspection of the engine revealed no pre-impact failue/malfunction.NTSB MKC84LA150Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Morrilton, AROn short final the plt advanced the throttle to maintain alt but the engine failed to respond. Power remained at idle RPM and the acft landed short of the rwy. On touchdown the landing gear sank in the soft ground and all three gears were broken off.…NTSB MKC84LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Hardy, ARThe acft collided with trees during an off arpt precautionary landing. The plt received a wx briefing that forecasted low ceilings and visibilities along his route. The plt elected to continue the flt. During the flt he encountered fog. He made a 180 and…NTSB MKC84LA148Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Humnoke, ARPlt stated he noticed a vibration in the acft on two flts prior to the accident flt. Plt felt forward pressure on the stick so he attempted to trim the acft. The acft nosed forward colliding with the terrain. Inspection disclosed no preimpact…NTSB MKC84LA151Accident · No injuriesLimited investigationFinal reportBeech BE35 · Nashville, ARThe acft collided with the ground after takeoff. The plt said he over-rotated during takeoff. The acft rolled right and left, striking the right landing gear and then the left wing on the rwy.NTSB MKC84LA139Accident · No injuriesLimited investigationFinal reportCessna 152 · No.Little Rock, ARThe acft collided with a rwy light and nosed over during landing in a x-wind. The wind was reported to the student as from 040 degrees at 9 KTS at takeoff and 070 degrees at 11 KTS when she returned to land. These winds converted to a 90 degree x-wind of 6.5…NTSB MKC84LA136Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Lepanto, ARThe acft lost power during an aerial application flt & crashed during a forced landing. An investigation revealed that the magnetos were not in an airworthy condition at the time of the accident. The acft had been operated 338 hrs since the last 100 hr…NTSB MKC84FA281Accident · 1 fatalField investigationFinal reportMooney M20C · New Blaine, ARDespite a wx briefing forecasting IMC and discouraging VFR flight, the non-instrument rated plt departed aprx 1 hour before the accident. Impact occurred in wooded rising terrain at an elevation of about 1,957 ft MSL at an aprx nose down attitude of 4 degs.…NTSB MKC84LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · N.Carlisle, ARThe acft nosed over after swerving off the rwy into soft sod during landing. The student plt was on his 2nd solo flt andpracticing touch and go landings. This was the plts 1st landing at carlisle arpt where the wind was of more velocity and greater angle than…NTSB MKC84LA128Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Pocahontas, ARThe acft crashed after an engine failure during a swath run at an alt of 20 ft AGL. Examination of the engine revealed 3 dowel pins and 6 screws which hold the starter drive gear and the accessory drive gear had sheared. Metallurgical exam revealed that dowel…NTSB MKC84LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Little Rock, ARThe acft swerved during landing in a x-wind and the right main gear collapsed. The plt said he slipped the acft to lose altitude to land and did not get a 'feel' for the wind direction as a result.NTSB MKC84LA125Accident · No injuriesLimited investigationFinal reportCessna 150K · Paragould, ARA student pilot carrying a passenger landed to refuel. Unaware of the procedure to acquire fuel at this location, he took off for another airport. The engine quit on climb-out and the aircraft was substantially damaged when it landed short of the runway. No…NTSB MKC84LA123Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Monette, ARThe owner/plt reported that just after lift-off, he heard a loud squeal & the eng lost power. He dumped his load to clear trees then landed hard in a wheat field just beyond the trees. A dissassembly of the eng revealed that a supercharger bearing had failed…NTSB MKC84LA122Accident · Minor injuriesLimited investigationFinal reportBeech BE23 · Little Rock, ARThe acft crashed into trees during a forced landing. Examination of the acft fuel system after the accident showed less than 1 gallon of fuel in the right tank and about 15 gallons in the left tank. The acft was operated the entire flton the right tank and…