Skip to content

NTSB investigations, AR

80 cases where the first occurrence was “In flight collision with terrain/water”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
  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'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230)
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 DFW06LA163Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Colt, ARThe pilot's failure to maintain clearance with the ground during an aerial application flight.Jun 20, 2006 · N2292J · Destroyed NTSB DFW06LA088Accident · 1 fatalLimited investigationFinal reportBeech C23 · Mena, ARThe pilot's continued flight into instrument meteorological conditions. Contributing factors were the mountainous terrain and the low ceilings.Mar 21, 2006 · N2160W · Substantial damage NTSB DFW05LA179Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance with terrain during aerial application.Jul 12, 2005 · N9086V · Substantial damage NTSB FTW04CA181Accident · No injuriesData collectionFinal reportCessna 180E · Weiner, ARThe pilot's poor preflight preparation/planning which resulted in the pilot landing at a wrong airport. A contributing factor was the lack of suitable terrain for the off airport landing.Jul 8, 2004 · N8676X · Substantial damage NTSB FTW04FA172Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hot Springs, ARThe pilot's failure to fly a stabilized, published instrument approach procedure, which resulted in a collision with mountainous terrain. Factors were the clouds and the air traffic controllers' failure to provide known information that may have assisted the…Jul 2, 2004 · N4123R · Substantial damage NTSB FTW04LA156Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Joiner, ARThe pilot's failure to maintain clearance and altitude from terrain while maneuvering during an aerial application.Jun 8, 2004 · N9151C · Destroyed NTSB FTW04FA044Accident · 1 fatalField investigationFinal reportBeech H-35 · Mena, ARThe pilot's failure to maintain proper altitude and clearance from terrain. Contributing factors were the mountainous terrain, fog, clouds, and turbulence.Dec 15, 2003 · N7929D · Destroyed NTSB CHI03LA175Accident · No injuriesLimited investigationFinal reportCessna 210M · Carlisle, ARThe pilot's improper in-flight decision to descend for landing, at night, without the runway environment insight. Contributing factors were the pilot's disorientation, the embankment and the dark night condition.Jun 23, 2003 · N9TK · Substantial damage NTSB CHI03LA164Accident · No injuriesLimited investigationFinal reportMcCulloch J-2 · Magnolia, ARThe pilot's inadequate weight a balance calculations and inadequate preflight planning.Jun 14, 2003 · N4381G · Substantial damage NTSB FTW03FA059Accident · 3 fatalField investigationFinal reportBeech 1900C · Eagleton, ARIn-flight collision with terrain due to the pilot's failure to maintain clearance and altitude above rapidly rising terrain while on a VFR approach. Contributing factors were the obscuration of the terrain due to clouds.Dec 9, 2002 · N127YV · Destroyed NTSB FTW03FA008Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Lakeview, ARthe pilot's failure to maintain clearance with the terrain while maneuvering.Oct 8, 2002 · N4344J · Destroyed NTSB FTW03LA004Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · Marmaduke, ARThe pilot's failure to maintain aircraft control. A contributing factor was the towering cumulus in all quadrants.Oct 2, 2002 · N155HF · Substantial damage NTSB FTW00LA006Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M18 · Weldon, ARThe cause of the accident was undetermined.Oct 5, 1999 · N4779G · Destroyed NTSB FTW99LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvel, ARThe pilot's failure to attain the proper takeoff airspeed.Jul 21, 1999 · N6073U · Substantial damage NTSB FTW99LA095Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARThe pilot's failure to maintain terrain clearance during the downwind departure. Factors were the tailwind and the wet soft grass airstrip.Mar 18, 1999 · N8742H · Substantial damage NTSB FTW99LA013Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · Russellville, ARThe pilot's failure to maintain clearance with the ground due to the pilot's improper use of the flaps and the ensuing inadvertent descent. Factors were the dark night conditions, the pilot's diverted attention, and the foggy windshield.Oct 17, 1998 · N90GN · Substantial damage NTSB FTW98LA205Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Forrest City, ARThe pilot's failure to maintain clearance with terrain. Factors were the sunglare and the pilot's restriction to visibility due to chemicals on the windshield.May 7, 1998 · N91660 · Substantial damage NTSB FTW97LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ashdown, ARThe inadvertent stall/mush. A factor was the high density altitude.Jul 4, 1997 · N1798J · Destroyed NTSB FTW96LA307Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Beedeville, ARThe pilot's failure to maintain terrain clearance.Jul 16, 1996 · N163RA · Substantial damage NTSB FTW95LA284Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Elaine, ARThe pilot did not maintain a positive rate of climb.Jul 7, 1995 · N91282 · Substantial damage NTSB FTW95LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bigelow, ARThe pilot's failure to maintain clearance with terrain.Jun 20, 1995 · N7937 · Substantial damage NTSB FTW94LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARWas the pilots failure to maintain terrain clearance.May 20, 1994 · N9678 · Substantial damage NTSB FTW94LA159Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · De Witt, ARA stall/mush into terrain after the pilot inadvertently raised the flaps.May 16, 1994 · N448AT · Substantial damage NTSB FTW94FA121Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Hughes, ARWas the pilot's failure to maintain terrain clearance for undetermined reason.Apr 13, 1994 · N9086V · Destroyed NTSB FTW94LA118Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Elaine, ARThe pilot's failure to maintain terrain clearance.Apr 5, 1994 · N3094F · Substantial damage NTSB FTW94FA023Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Saratoga, ARThe pilot-in-command's performance of aerobatics at an altitude where it was not possible to maintain clearance.Oct 30, 1993 · N130KS · Substantial damage NTSB FTW93LA214Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Bono, ARThe airplane's takeoff performance being exceeded by the PIC. A factor was the pilot's inability to safely reject the takeoff.Jul 9, 1993 · N8522V · Substantial damage NTSB FTW93LA195Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A Dromader · Wheatley, ARThe pilot's operation of the airplane beyond its takeoff performance limitations and inadvertent stall. A factor was high density altitude.Jun 23, 1993 · N116RA · Substantial damage NTSB FTW93LA189Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Weiner, ARProper rotation speed not attained by the pilotJun 14, 1993 · N3098W · Substantial damage NTSB FTW93LA156Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Trumann, ARPilot's failure to maintain terrain clearance. A factor was the diverted attention of the pilot.May 15, 1993 · N6556 · Substantial damage NTSB DEN93FA053Accident · 2 fatalField investigationFinal reportBeech 65-A90 · Mount Ida, ARThe pilot's failure to establish an adequate climb rate. Factors in the accident were: pilot fatigue from lack of sleep, and the weather conditions.May 1, 1993 · N530N · Destroyed NTSB FTW92LA213Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Clarendon, ARThe pilot's failure to consult the airplane's performance data and ensure that adequate field length was available for takeoff.Aug 18, 1992 · N2357N · Substantial damage NTSB FTW92LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rector, ARThe pilot's premature liftoff.Jun 14, 1992 · N15424 · Substantial damage NTSB FTW92LA143Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Walnut Ridge, ARThe pilot's failure to maintain adequate terrain clearance. A factor was the loss of power as result of the uncoupling of the engine and the propeller.May 23, 1992 · N8380K · Substantial damage NTSB FTW92LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Almyra, ARThe pilot's improper judgement of the descent rate and his inadequate pull up at the bottom.Apr 22, 1992 · N4430S · Substantial damage NTSB FTW92LA089Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Wright, ARThe failure of the pilot to maintain altitude due to diverted attention.Mar 16, 1992 · N41KM · Destroyed NTSB FTW91LA157Accident · No injuriesLimited investigationFinal reportCessna 172K · Fisher, ARThe pilot's failure to use the aircraft performance data to compute the takeoff distance. A factor was the high density altitude.Aug 26, 1991 · N7043G · Substantial damage NTSB FTW91DPG18Accident · No injuriesFinal reportGrumman G-164A · Dewitt, ARThe pilot's failure to maintain proper glidepath. A factor was the berm at the approach end of the runway.Jul 31, 1991 · N5076 · Substantial damage NTSB FTW91LA095Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Newport, ARThe pilot's improper planning which resulted in his flying into his own chemicals.Jun 8, 1991 · N36335 · Substantial damage NTSB FTW91DPG06Accident · No injuriesFinal reportGrumman G-164A · Gillett, ARThe windshiled becoming obscured by aerial application spray and the resultant limited vision from the cockpit.May 14, 1991 · N9785 · Substantial damage NTSB FTW91FA017Accident · 1 fatalField investigationFinal reportBeech B55 · England, ARThe pilot's misjudgement of altitude, which resulted in his failure to arrest descent from a dive. The pilot's impaired judgment from consumption of ethanol (alcohol) was a factor.Nov 23, 1990 · N811J · Destroyed NTSB FTW90DPG11Accident · No injuriesFinal reportAir Tractor AT401 · Altheimer, ARThe pilot's failure to align the airplane with the runway during landing.Aug 23, 1990 · N10192 · Substantial damage NTSB FTW90DPG10Accident · No injuriesFinal reportCessna 188A · Hunter, ARThe pilot's failure to maintain proper clearance above the crops.Aug 23, 1990 · N3566Q · Destroyed NTSB FTW90DPG07Accident · No injuriesFinal reportSchweizer G-164B · Sherrill, ARPremature lift off and subsequent stall.Aug 3, 1990 · N8104K · Destroyed NTSB FTW90DPG04Accident · No injuriesFinal reportAir Tractor 301A · Foreman, ARThe pilot's inadvertent stall/mush.Jul 30, 1990 · N31631 · Destroyed NTSB MKC90MA049Accident · 7 fatalMajor investigationFinal reportGrumman G1159 · Little Rock, ARFailure of the pilot-in-command to follow IFR procedures (maintain an ILS glide path or initiate a missed approach) during an IFR arrival to the airport. Factors related to the accident were: unfavorable weather conditions, an erroneous wind indication from…Jan 19, 1990 · N46TE · Destroyed NTSB MKC89LA190Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Wabbaseka, ARImproper planning/decision by the pilot which resulted in his failure to maintain clearance from the tall vegetation (grass). The tall vegetation & high density altitude were considered to be contributing factors.Aug 26, 1989 · N10103 · Substantial damage 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.Jun 7, 1989 · N63535 · Substantial damage 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),…Apr 13, 1989 · N7245 · Substantial damage NTSB MKC88LA111Accident · No injuriesLimited investigationFinal reportAero Commander 685 · Scranton, ARShortly after takeoff from a 2400 foot sod strip, the PIC said the acft began to settle, although both engines were delivering takeoff power and RPM, and liftoff speeds were proper. The acft settled back to the runway and careened off on to the overrun…Jun 16, 1988 · N165SE · Substantial damage