# NTSB investigations, AR: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 6 · 280 cases

## Latest cases

- [NTSB CEN26LA040](https://openairdocs.org/ntsb/CEN26LA040.md): Cessna 180K · Lakeview, AR · Accident · No injuries · Class 4 · Limited · Final report · Nov 8, 2025 · N2697K · Substantial damage
  > The pilot’s decision to continue an approach that resulted in a long landing and inability to stop prior to the end of the runway. Contributing to the accident were the light conditions and a road with vehicles on it immediately adjacent to the end of the…
- [NTSB CEN25LA312](https://openairdocs.org/ntsb/CEN25LA312.md): Taylorcraft BC12 · Ozark, AR · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 9, 2025 · N95356 · Substantial damage
  > The pilot’s failure to maintain clearance from a tree which resulted in the right wing impacting the tree and a subsequent collision with trees and terrain. Contributing to the accident was the pilot’s decision to operate the airplane at a low altitude over…
- [NTSB CEN25LA081](https://openairdocs.org/ntsb/CEN25LA081.md): Piper PA-24-250 · Bentonville, AR · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 16, 2025 · N6799P · Substantial damage
  > The pilots’ mismanagement of the available fuel, which resulted in a loss of engine power due to fuel starvation.
- [NTSB CEN24LA189](https://openairdocs.org/ntsb/CEN24LA189.md): Piper PA-28-180 · Hot Springs, AR · Accident · Serious injuries · Class 3 · Limited · Final report · May 15, 2024 · N6571J · Destroyed
  > The student pilot’s selection of an improper fuel tank selector position, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the instructor’s inadequate oversight.
- [NTSB CEN24LA108](https://openairdocs.org/ntsb/CEN24LA108.md): Piper PA-28-180 · Conway, AR · Accident · No injuries · Class 3 · Limited · Final report · Jan 31, 2024 · N2184T · Substantial damage
  > The student pilot's improper movement of the fuel selector to the OFF position, which resulted in fuel starvation and a total loss of engine power.
- [NTSB CEN24LA069](https://openairdocs.org/ntsb/CEN24LA069.md): Aero Commander 100 · Texarkana, AR · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 18, 2023 · N4104X · Substantial damage
  > The pilot’s improper decision to attempt a go-around with full flaps extended, which resulted in decreased climb performance and led to a collision with trees.
- [NTSB CEN23LA408](https://openairdocs.org/ntsb/CEN23LA408.md): Flight Design Ctsw · Berryville, AR · Accident · No injuries · Class 4 · Limited · Final report · Sep 7, 2023 · N603CT · Substantial damage
  > The pilot’s failure to maintain aircraft control during the attempted go-around.
- [NTSB CEN23LA390](https://openairdocs.org/ntsb/CEN23LA390.md): Zlin Aviation S R O Savage Norden · Cabot, AR · Accident · No injuries · Class 3 · Limited · Final report · Aug 30, 2023 · N7373 · Substantial damage
  > The airplane manufacturer’s routing of the fuel pump wiring next to the engine’s turbocharger and exhaust, which thermally damaged the wiring and resulted in a malfunction of the fuel delivery system and a total loss of engine power.
- [NTSB CEN23LA271](https://openairdocs.org/ntsb/CEN23LA271.md): Cessna 172N · Siloam Springs, AR · Accident · No injuries · Class 4 · Limited · Final report · Jun 30, 2023 · N739GU · Substantial damage
  > The pilot’s failure to maintain clearance from power lines while on final approach to land.
- [NTSB CEN23FA258](https://openairdocs.org/ntsb/CEN23FA258.md): Cessna 177 · Hot Springs, AR · Accident · 1 fatal · Class 3 · Field · Final report · Jun 26, 2023 · N3138T · Substantial damage
  > The pilot’s improper preflight fuel planning and inflight fuel mismanagement, which resulted in a total loss of engine power due to fuel exhaustion, and his subsequent failure to maintain adequate airspeed during the forced landing, which resulted in the…
- [NTSB CEN23FA190](https://openairdocs.org/ntsb/CEN23FA190.md): Beech E-90 · Winslow, AR · Accident · 1 fatal · Class 3 · Field · Final report · May 17, 2023 · N522MJ · Destroyed
  > The pilot’s poor preflight decision to depart into known instrument meteorological conditions (IMC) without a functional autopilot system, which resulted in spatial disorientation and his failure to maintain aircraft control while flying in IMC during the…
- [NTSB CEN23FA074](https://openairdocs.org/ntsb/CEN23FA074.md): Beech M35 · Fayetteville, AR · Accident · 1 fatal · Class 3 · Field · Final report · Jan 6, 2023 · N673V · Destroyed
  > The pilot’s mismanagement of the airplane’s fuel system, which resulted in fuel starvation and a loss of engine power.
- [NTSB CEN23LA066](https://openairdocs.org/ntsb/CEN23LA066.md): Beech A36 · Harrison, AR · Accident · No injuries · Class 3 · Limited · Final report · Dec 19, 2022 · N8137P · Substantial damage
  > A loss of engine power for reasons that could not be determined.
- [NTSB CEN22LA152](https://openairdocs.org/ntsb/CEN22LA152.md): Bellanca 17-30A · Ash Flat, AR · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 25, 2022 · N8869V · Substantial damage
  > The partial loss of engine power during a go-around resulting in an inadvertent entry into an aerodynamic stall. Contributing to the accident was the inexperience of the low-time pilot.
- [NTSB CEN21LA471](https://openairdocs.org/ntsb/CEN21LA471.md): Just Highlander · West Cobb, AR · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 29, 2021 · N419SD · Substantial damage
  > The airplane’s encounter with gusting wind conditions and low-level wind shear on final approach, which resulted in a loss of control, an aerodynamic stall, and a subsequent hard landing.
- [NTSB CEN21FA277](https://openairdocs.org/ntsb/CEN21FA277.md): Cirrus Design SR20 · Conway, AR · Accident · 1 fatal · Class 3 · Field · Final report · Jun 18, 2021 · N62WR · Substantial damage
  > The pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and spin. Contributing to the accident was the failure of the pilot to perform an adequate preflight inspection, to include removal of the pitot tube cover.
- [NTSB CEN20CA391](https://openairdocs.org/ntsb/CEN20CA391.md): Champion 8GCBC · Ozark, AR · Accident · Minor injuries · Class 4 · Data collection · Final report · Sep 11, 2020 · N81BH · Substantial damage
  > The pilot's failure to maintain clearance from a wire during final approach to landing.
- [NTSB CEN19LA116](https://openairdocs.org/ntsb/CEN19LA116.md): Berkey S-6ES · Lafe, AR · Accident · No injuries · Class 3 · Limited · Final report · Apr 2, 2019 · N265GB · Substantial damage
  > The non-certificated pilot's failure to maintain an appropriate glidepath while landing toward the sun, which resulted in impact with vegetation and a subsequent loss of control.
- [NTSB GAA18CA549](https://openairdocs.org/ntsb/GAA18CA549.md): Aviat A1 · Bentonville, AR · Accident · Minor injuries · Data collection · Final report · Sep 12, 2018 · N868X · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during an attempted go-around after the airplane bounced, which resulted in an aerodynamic stall.
- [NTSB CEN17LA329](https://openairdocs.org/ntsb/CEN17LA329.md): James M Raulerson CH 750 · Manila, AR · Accident · No injuries · Limited investigation · Final report · Aug 24, 2017 · N61LR · Substantial damage
  > A loss of engine power for reasons that could not be determined because the airplane was not available for examination.
- [NTSB CEN16LA347](https://openairdocs.org/ntsb/CEN16LA347.md): Haggenmacher Bensen · Bryant, AR · Accident · 1 fatal · Limited investigation · Final report · Sep 3, 2016 · UNREG · Destroyed
  > The pilot’s loss of gyroplane control during an intentional high-speed pass, which resulted in the gyroplane porpoising and impacting terrain. Contributing to the accident was the pilot’s decision to conduct the flight in an aircraft in which he had little…
- [NTSB GAA15CA288](https://openairdocs.org/ntsb/GAA15CA288.md): Cessna 305F · Bentonville, AR · Accident · No injuries · Data collection · Final report · Sep 27, 2015 · N119BD · Substantial damage
  > The pilot's failure to maintain yaw control during a go-around, which resulted in a right main landing gear collapse and the right wing impacting terrain during a runway excursion.
- [NTSB CEN15FA374](https://openairdocs.org/ntsb/CEN15FA374.md): Beech 35 B33 · El Dorado, AR · Accident · 1 fatal · Field investigation · Final report · Aug 23, 2015 · N9704Y · Destroyed
  > The loss of engine power for reasons that could not be determined during postaccident examination of the accident site or based on the available information and the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical…
- [NTSB CEN15FA022](https://openairdocs.org/ntsb/CEN15FA022.md): CGS Hawk Arrow II Slsa · Lonoke, AR · Accident · 1 fatal · Field investigation · Final report · Oct 20, 2014 · N916H · Substantial damage
  > The pilot's loss of airplane control while turning onto the base leg of the traffic pattern due to his failure to maintain sufficient speed and/or overbanking, which resulted in the airplane impacting trees. Contributing to the pilot's fatal injuries was his…
- [NTSB CEN13LA381](https://openairdocs.org/ntsb/CEN13LA381.md): Beech C23 · Hot Springs, AR · Accident · No injuries · Limited investigation · Final report · Jun 30, 2013 · N3KT · Substantial damage
  > The pilots’ failure to monitor and manage fuel consumption during cruise flight, which resulted in fuel exhaustion and a subsequent forced landing.
- [NTSB CEN13LA359](https://openairdocs.org/ntsb/CEN13LA359.md): Bell 206 - L4 · Lake City, AR · Accident · No injuries · Limited investigation · Final report · Jun 19, 2013 · N467AE · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN11CA224](https://openairdocs.org/ntsb/CEN11CA224.md): Ayres S2R-T34 · Swan Lake, AR · Accident · Minor injuries · Data collection · Final report · Mar 12, 2011 · N92KM · Substantial damage
  > An in-flight collision with power lines following an encounter with a wind gust.
- [NTSB CEN11LA188](https://openairdocs.org/ntsb/CEN11LA188.md): Cessna 150G · Springdale, AR · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 2011 · N3257J · Substantial damage
  > The pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN10CA332](https://openairdocs.org/ntsb/CEN10CA332.md): Piper J3C-65 · Hot Springs, AR · Accident · No injuries · Data collection · Final report · Jun 14, 2010 · N70906 · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the pilot's inadvertent closure of the fuel valve. Contributing to the accident were the unmarked fuel shutoff valve and the pilot's inexperience in the accident airplane.
- [NTSB CEN10FA114](https://openairdocs.org/ntsb/CEN10FA114.md): Beech A36 · Winslow, AR · Accident · 4 fatal · Field investigation · Final report · Feb 6, 2010 · N1085D · Substantial damage
  > The instrument-rated pilot's spatial disorientation and subsequent loss of airplane control during flight in instrument meteorological and conditions favorable for structural icing.
- [NTSB DFW08CA180](https://openairdocs.org/ntsb/DFW08CA180.md): Mooney M20 · Rogers, AR · Accident · Minor injuries · Data collection · Final report · Jul 9, 2008 · N7072V · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight planning/decision.
- [NTSB DFW08LA161](https://openairdocs.org/ntsb/DFW08LA161.md): Cessna 150M · Forrest City, AR · Accident · 1 fatal · Limited investigation · Final report · Jun 7, 2008 · N3266V · Substantial damage
  > The failure of the pilot to maintain adequate airspeed while maneuvering in the traffic pattern, resulting in an inadvertent aerodynamic stall.
- [NTSB DFW08LA139](https://openairdocs.org/ntsb/DFW08LA139.md): Commander AC-680 · Hope, AR · Accident · No injuries · Limited investigation · Final report · May 8, 2008 · N39BA · Substantial damage
  > The pilot's failure to maintain control of the twin-engine airplane while landing. Contributing to the accident were the crosswind and partial loss of power on the right engine.
- [NTSB DFW08CA103](https://openairdocs.org/ntsb/DFW08CA103.md): Beech C-23 · De Queen, AR · Accident · No injuries · Data collection · Final report · Apr 20, 2008 · N2049L · Substantial damage
  > The pilot's failure to maintain control of the airplane during an aborted landing. Contributing to the accident were the crosswind and the pilot's inadequate compensation for the wind conditions.
- [NTSB CHI07LA113](https://openairdocs.org/ntsb/CHI07LA113.md): Murphy Aircraft Mfg SR3500 Moose · Cotter, AR · Accident · 2 fatal · Limited investigation · Final report · Apr 22, 2007 · N360MM · Substantial damage
  > The pilot not maintaining airplane control and airspeed during the approach. Factors were the gusty wind conditions, the inadvertent stall the pilot encountered, and the power lines that were impacted during the uncontrolled descent.
- [NTSB DFW07CA079](https://openairdocs.org/ntsb/DFW07CA079.md): Buckeye Breeze XL · Buffalo City, AR · Accident · Serious injuries · Data collection · Final report · Feb 21, 2007 · N582W · Destroyed
  > The pilot's failure to maintain control of the aircraft during approach. A contributing factor was the reported encounter with severe turbulence.
- [NTSB DFW07FA051](https://openairdocs.org/ntsb/DFW07FA051.md): Cessna 182R · Batesville, AR · Accident · 2 fatal · Field investigation · Final report · Jan 4, 2007 · N2658 · Destroyed
  > The pilot's failure to maintain clearance from trees. A contributing factor to the accident was the prevailing low ceilings.
- [NTSB DFW07FA041](https://openairdocs.org/ntsb/DFW07FA041.md): Beech A36 · Fayetteville, AR · Accident · 1 fatal · Field investigation · Final report · Dec 19, 2006 · N1100J · Destroyed
  > The pilot's failure to maintain clearance from obstacles. Contributing factors were the below approach/landing weather minimums, and the prevailing dark night conditions.
- [NTSB DFW06CA155](https://openairdocs.org/ntsb/DFW06CA155.md): Air Tractor AT-502 · Minturn, AR · Accident · No injuries · Data collection · Final report · Jun 6, 2006 · N9195G · Substantial damage
  > The pilot's inadequate inflight planning/decision, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DFW06CA139](https://openairdocs.org/ntsb/DFW06CA139.md): Allstar PZL SZD 51-1 Junior · Cherry Valley, AR · Accident · Minor injuries · Data collection · Final report · May 24, 2006 · N751MS · Substantial damage
  > The pilot's failure to maintain clearance from a tree while on final to approach to landing. A contributing factor was the loss of thermal lift on final approach.
- [NTSB DFW06CA084](https://openairdocs.org/ntsb/DFW06CA084.md): Piper PA-28-140 · Cherokee City, AR · Accident · No injuries · Data collection · Final report · Mar 15, 2006 · N5537F · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DFW06CA031](https://openairdocs.org/ntsb/DFW06CA031.md): Air Tractor AT-502B · Osceola, AR · Accident · No injuries · Data collection · Final report · Nov 10, 2005 · N5075P · Substantial damage
  > The pilot's failure to maintain control of the airplane while on final approach. A contributing factor was the gusty winds.
- [NTSB DFW05FA082](https://openairdocs.org/ntsb/DFW05FA082.md): Cessna 172F · Hot Springs, AR · Accident · 1 fatal · Field investigation · Final report · Mar 8, 2005 · N8382U · Substantial damage
  > A loss of engine power due to the pilot's failure to refuel resulting in fuel starvation. Contributing factors were the lack of suitable terrain for the forced landing, and a shoulder harness restraint system was not installed.
- [NTSB DFW05LA118](https://openairdocs.org/ntsb/DFW05LA118.md): Cessna TR182 · Little Rock, AR · Accident · 2 fatal · Limited investigation · Final report · Jan 10, 2005 · N6150S · Destroyed
  > The pilot's failure to maintain control of the airplane during an instrument approach for undetermined reasons. Contributing factors were the mist and low cloud ceiling.
- [NTSB FTW04LA149](https://openairdocs.org/ntsb/FTW04LA149.md): Cessna 150 · Benton, AR · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 2004 · N5677E · Substantial damage
  > The student pilot's failure to maintain airspeed resulting in an inadvertent stall during a go-around.
- [NTSB FTW04LA103](https://openairdocs.org/ntsb/FTW04LA103.md): Pdps PZL-Bielsko SZD-50-3 · Cherry Valley, AR · Accident · Serious injuries · Limited investigation · Final report · Apr 4, 2004 · N18SZ · Substantial damage
  > The pilot's failure to maintain airspeed during the landing which resulted in an inadvertent stall.
- [NTSB FTW04FA083](https://openairdocs.org/ntsb/FTW04FA083.md): Taylorcraft BC12-D · Wrightsville, AR · Accident · 1 fatal · Field investigation · Final report · Feb 27, 2004 · N43005 · Destroyed
  > The pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin on the downwind leg of the traffic pattern.
- [NTSB FTW04FA036](https://openairdocs.org/ntsb/FTW04FA036.md): Beech S35 · Harrison, AR · Accident · 2 fatal · Field investigation · Final report · Dec 4, 2003 · N350JL · Destroyed
  > The pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall. Contributing factors were the pilot's failure to follow the published instrument approach procedures, and his failure attain the proper glidepath.
- [NTSB FTW04FA006](https://openairdocs.org/ntsb/FTW04FA006.md): Twin Commander Acft. 680FL · Harrison, AR · Accident · Serious injuries · Field investigation · Final report · Oct 8, 2003 · N680WS · Destroyed
  > The loss of power to both engines due to fuel starvation as a result of the pilot's failure to complete the landing checklist while on final approach. A factor contributing to the accident was the lack of suitable terrain for the forced landing.
- [NTSB CHI03LA323](https://openairdocs.org/ntsb/CHI03LA323.md): Cessna 150L · Siloam Springs, AR · Accident · No injuries · Limited investigation · Final report · Sep 28, 2003 · N21915 · Substantial damage
  > A loss of engine power due to the pilot's inadequate planning/decision resulting in fuel exhaustion. Factors were the trees and the night conditions.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=AR&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=AR

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.