# NTSB investigations, AR: Enroute

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 11 · 520 cases

## Latest cases

- [NTSB CEN26LA270](https://openairdocs.org/ntsb/CEN26LA270.md): Cessna P210R · Arkadelphia, AR · Accident · No injuries · Class 4 · Limited · Investigation open · Jul 23, 2026 · N5258A · Substantial damage
- [NTSB CEN26LA223](https://openairdocs.org/ntsb/CEN26LA223.md): Cessna T206H · Bryant, AR · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 11, 2026 · N72RK · Substantial damage
  > On June 10, 2026, about 1223 central daylight time, a Cessna T206H airplane, N72RK, was substantially damaged when it was involved in an accident near Bryant, Arkansas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN26LA215](https://openairdocs.org/ntsb/CEN26LA215.md): Eaa Acro Sport II · Sheridan, AR · Accident · No injuries · Class 4 · Limited · Final report · May 31, 2026 · N23RA · Substantial damage
  > The pilot’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN26FA126](https://openairdocs.org/ntsb/CEN26FA126.md): Peck JODEL-F12 · Rogers, AR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 26, 2026 · N30P · Destroyed
  > On February 26, 2026, about 1330 central standard time, a Peck Jodel-F12, N30P, experimental airplane, was destroyed when it was involved in an accident near Rogers, Arkansas. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code…
- [NTSB CEN26FA010](https://openairdocs.org/ntsb/CEN26FA010.md): Cessna 210B · Parkin, AR · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 6, 2025 · N9627X · Destroyed
  > On October 6, 2025, about 1514 central daylight time, a Cessna 210B airplane, N9627X, was destroyed when it was involved in an accident near Parkin, Arkansas. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB CEN25FA321](https://openairdocs.org/ntsb/CEN25FA321.md): Lancair NLA-275-FR-C · Bradley, AR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 19, 2025 · N345LA · Destroyed
  > On August 18, 2025, about 2133 central daylight time, a Lancair NLA-275-FR-C airplane, N345LA, was destroyed when it was involved in an accident near Bradley, Arkansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN25FA308](https://openairdocs.org/ntsb/CEN25FA308.md): Cessna T182T · Augusta, AR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 7, 2025 · N35370 · Substantial damage
  > On August 7, 2025, at 1037 central daylight time, a Cessna T182T airplane, N35370, was substantially damaged when it was involved in an accident near Augusta, Arkansas. The pilot was fatally injured and the passenger received minor injuries. The airplane was…
- [NTSB CEN25LA305](https://openairdocs.org/ntsb/CEN25LA305.md): Stolp Starduster SA300 · Marshall, AR · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 6, 2025 · N983AM · Substantial damage
  > On August 6, 2025 about 1552 central daylight time, a Stolp Starduster SA 300 airplane was substantially damaged when it was involved in an accident near Marshall, Arkansas. The pilot was not injured. The airplane was operated under the provisions of Title 14…
- [NTSB CEN25LA094](https://openairdocs.org/ntsb/CEN25LA094.md): Beech 58P · Pine Bluff, AR · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 6, 2025 · N138TL · Substantial damage
  > On February 5, 2025, about 1848 central standard time, a Beech 58P airplane, N138TL, was substantially damaged when it was involved in an accident near Pine Bluff, Arkansas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB CEN25FA033](https://openairdocs.org/ntsb/CEN25FA033.md): Beech 58 · Arlberg, AR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 29, 2024 · N811PB · Destroyed
  > On October 29, 2024, about 1426 central daylight time, a Beech 58 airplane, N811PB, was destroyed when it was involved in an accident near Arlberg, Arkansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB CEN24FA179](https://openairdocs.org/ntsb/CEN24FA179.md): Piper PA46-500TP · Marianna, AR · Accident · 2 fatal · Class 3 · Field · Final report · May 13, 2024 · N241PM · Substantial damage
  > The pilot’s exceedance of the airplane’s design limitations, which resulted in an in-flight breakup.
- [NTSB CEN24LA145](https://openairdocs.org/ntsb/CEN24LA145.md): Mooney M20E · Alpine, AR · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 2, 2024 · N86UM · Substantial damage
  > The improper maintenance of the cabin air and exhaust system which resulted in a cracked exhaust pipe and damaged cabin air tubing, and the subsequent elevated carbon monoxide levels in the cockpit and a forced landing to unsuitable terrain after the pilot…
- [NTSB CEN24LA056](https://openairdocs.org/ntsb/CEN24LA056.md): Vans RV6 · Fordyce, AR · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 5, 2023 · N600VS · Substantial damage
  > The pilot’s failure to attain a proper touchdown point following an unidentified electrical system failure and subsequent partial loss of engine power, which resulted in a runway overrun and impact with terrain. Contributing to the accident was the pilot’s…
- [NTSB CEN23LA419](https://openairdocs.org/ntsb/CEN23LA419.md): Beech A36 · El Dorado, AR · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 23, 2023 · N67CD · Substantial damage
  > A loss of engine power for undetermined reasons, which resulted in a forced landing and impact with terrain.
- [NTSB CEN23LA020](https://openairdocs.org/ntsb/CEN23LA020.md): Piper PA-22-160 · Osage, AR · Accident · No injuries · Class 4 · Limited · Final report · Oct 26, 2022 · N8457D · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.
- [NTSB CEN22LA228](https://openairdocs.org/ntsb/CEN22LA228.md): Air Tractor AT-602 · Allport, AR · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 1, 2022 · N5007R · Substantial damage
  > A partial loss of engine power due to fuel contamination from foreign object debris. Contributing to the accident was the operator’s failure to follow the manufacturer’s required airframe fuel filter inspection interval.
- [NTSB CEN22FA082](https://openairdocs.org/ntsb/CEN22FA082.md): Cessna 172 · Hardy, AR · Accident · 2 fatal · Class 3 · Field · Final report · Dec 26, 2021 · N5798T · Destroyed
  > The non-instrument rated pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was a loss of engine power due to fuel…
- [NTSB CEN22FA058](https://openairdocs.org/ntsb/CEN22FA058.md): Cessna 182L · Bonnerdale, AR · Accident · 1 fatal · Class 3 · Field · Final report · Dec 4, 2021 · N182NS · Destroyed
  > The noninstrument rated pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent impact with terrain.
- [NTSB CEN21LA405](https://openairdocs.org/ntsb/CEN21LA405.md): Beech A35 · Morrilton, AR · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 2, 2021 · N8419A · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on available information.
- [NTSB CEN21LA287](https://openairdocs.org/ntsb/CEN21LA287.md): Grumman G164 · Sedgwick, AR · Accident · No injuries · Class 3 · Limited · Final report · Jun 20, 2021 · N62375 · Substantial damage
  > The total loss of engine power due to the failure and disengagement of the torque sensor assembly front spur gear from its splined shouldered shaft due to a loose self-locking nut.
- [NTSB CEN21LA231](https://openairdocs.org/ntsb/CEN21LA231.md): Cessna 150J · Madison, AR · Accident · No injuries · Class 3 · Limited · Final report · Apr 28, 2021 · N5578G · Substantial damage
  > The pilot’s improper fuel planning which led to fuel exhaustion, and a total loss of engine power.
- [NTSB CEN21FA198](https://openairdocs.org/ntsb/CEN21FA198.md): Piper PA-46-310P · Danville, AR · Accident · 4 fatal · Class 3 · Field · Final report · Apr 23, 2021 · N461DK · Substantial damage
  > The pilot’s improper decision to continue flight in an area of moderate-to-heavy icing conditions, which resulted in exceedance of the airplane’s anti-icing system capabilities, a degradation of aircraft performance, and subsequent aerodynamic stall.
- [NTSB CEN21LA107](https://openairdocs.org/ntsb/CEN21LA107.md): Hawker Beechcraft G58 · Credit, AR · Accident · 2 fatal · Class 3 · Limited · Final report · Jan 4, 2021 · N325GC · Destroyed
  > A loss of left engine power for undetermined reasons, which resulted in an emergency descent with one engine inoperative and inadvertent collision with transmission lines. Contributing to the accident was the pilot’s inability to respond appropriately to the…
- [NTSB CEN21LA070](https://openairdocs.org/ntsb/CEN21LA070.md): Piper PA38 · Franklin, AR · Accident · 2 fatal · Class 3 · Limited · Final report · Nov 30, 2020 · N9879T · Destroyed
  > The impairment of both pilots from carbon monoxide exposure due to a degraded muffler. Contributing to the accident was the inadequate maintenance inspection, which failed to detect the degraded muffler.
- [NTSB CEN20LA379](https://openairdocs.org/ntsb/CEN20LA379.md): Cirrus SR22 · Chester, AR · Accident · 4 fatal · Class 3 · Limited · Final report · Sep 5, 2020 · N733CD · Destroyed
  > The noninstrument-rated pilot’s continued flight into dark night instrument meteorological conditions which resulted in spatial disorientation and a subsequent loss of airplane control.
- [NTSB CEN20CA303](https://openairdocs.org/ntsb/CEN20CA303.md): Stearman N2S 3 · Jacksonville, AR · Accident · No injuries · Class 4 · Data collection · Final report · Jul 22, 2020 · N2158P · Substantial damage
  > The pilot's failure to adequately monitor his fuel quantity during flight, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB CEN20LA269](https://openairdocs.org/ntsb/CEN20LA269.md): Air Tractor AT 602 · Weldon, AR · Accident · No injuries · Class 3 · Limited · Final report · Jul 3, 2020 · N602NY · Substantial damage
  > The total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.
- [NTSB CEN19FA332](https://openairdocs.org/ntsb/CEN19FA332.md): Cessna 150 · Prairie Grove, AR · Accident · 1 fatal · Class 3 · Field · Final report · Sep 24, 2019 · N4658X · Substantial damage
  > The noninstrument-rated pilot's loss of control due to spatial disorientation after encountering instrument meteorological conditions at night.
- [NTSB CEN19LA194](https://openairdocs.org/ntsb/CEN19LA194.md): Beech A23 · Fort Smith, AR · Accident · No injuries · Class 3 · Limited · Final report · Jul 1, 2019 · N3598R · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the flight instructor's fuel mismanagement.
- [NTSB CEN19LA146](https://openairdocs.org/ntsb/CEN19LA146.md): Sikorsky S76 · Morrilton, AR · Accident · No injuries · Class 3 · Limited · Final report · May 15, 2019 · N761AF · Substantial damage
  > The improper securing of the exhaust duct bolts, which resulted in the duct becoming unseated and substantial heat damage to the tail rotor drive shaft.
- [NTSB CEN18LA347](https://openairdocs.org/ntsb/CEN18LA347.md): Piper PA-28-235 · Little Rock, AR · Accident · Serious injuries · Limited investigation · Final report · Aug 22, 2018 · N7954W · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available evidence, which resulted in a forced landing on unsuitable terrain.
- [NTSB GAA18CA465](https://openairdocs.org/ntsb/GAA18CA465.md): Bellanca 8GCBC · El Dorado, AR · Accident · No injuries · Data collection · Final report · Jul 27, 2018 · N391KM · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB CEN18LA189](https://openairdocs.org/ntsb/CEN18LA189.md): M-Squared Sprint 1000 · Gurdon, AR · Accident · Serious injuries · Class 3 · Limited · Final report · May 22, 2018 · N138ZX · Substantial damage
  > Inadequate engine maintenance, which resulted in the failure of the MAG piston ring and the subsequent total loss of engine power due to a piston seizure.
- [NTSB CEN18LA099](https://openairdocs.org/ntsb/CEN18LA099.md): Beech 35 · Batesville, AR · Accident · No injuries · Limited investigation · Final report · Feb 8, 2018 · N4654D · Substantial damage
  > An in-flight control system flutter encounter during a turbulence encounter; the reason for the flutter could not be determined.
- [NTSB CEN18FA033](https://openairdocs.org/ntsb/CEN18FA033.md): Bell Helicopter Textron Canada 407 · Stuttgart, AR · Accident · 3 fatal · Field investigation · Final report · Nov 20, 2017 · N620PA · Destroyed
  > An in-flight loss of control due to bird strikes.
- [NTSB CEN17LA313](https://openairdocs.org/ntsb/CEN17LA313.md): Canion Michael W Zodiac 601XL · Grady, AR · Accident · No injuries · Limited investigation · Final report · Jul 20, 2017 · N577M · Substantial damage
  > The loss of engine power due to a lack of ignition resulting from a broken alternator wire.
- [NTSB CEN17FA071](https://openairdocs.org/ntsb/CEN17FA071.md): Columbia Aircraft Mfg LC41 550FG · Gurdon, AR · Accident · 2 fatal · Field investigation · Final report · Jan 5, 2017 · N972JK · Destroyed
  > The loss of control in flight for reasons that could not be determined because of the severe impact and postcrash fire damage to the airplane and the lack of information about the airplane emergency that the pilot was experiencing.
- [NTSB CEN16FA210](https://openairdocs.org/ntsb/CEN16FA210.md): Cessna 175 · Pine Bluff, AR · Accident · 1 fatal · Field investigation · Final report · Jun 8, 2016 · N6649E · Substantial damage
  > A loss of engine power during cruise flight for reasons that could not be determined because a test run of the engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation. Contributing to the accident were the…
- [NTSB CEN16LA197](https://openairdocs.org/ntsb/CEN16LA197.md): Cessna 501 · Texarkana, AR · Accident · Minor injuries · Limited investigation · Final report · May 24, 2016 · N804ST · Substantial damage
  > The pilot's failure to use supplemental oxygen as required during high-altitude flight, which resulted in his loss of consciousness following a loss of cabin pressurization. Contributing to the accident was the separation of the air conditioning system's…
- [NTSB CEN16LA026](https://openairdocs.org/ntsb/CEN16LA026.md): Cirrus Design SR22T · Fayetteville, AR · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 2015 · N857SW · Substantial damage
  > The fatigue failure of the oil cooler cross fitting, which resulted in engine oil starvation and a total loss of engine power.
- [NTSB CEN15LA308](https://openairdocs.org/ntsb/CEN15LA308.md): Devoe Clip Wing · Melbourne, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 2015 · N80917 · Substantial damage
  > The loss of engine power for reasons that could not be determined based on the available evidence and the postaccident engine examination, which led to a forced landing on unsuitable terrain due to the pilot’s decision not to deploy the ballistic parachute…
- [NTSB CEN15LA270](https://openairdocs.org/ntsb/CEN15LA270.md): Piper PA28-200 · Jonesboro, AR · Accident · No injuries · Limited investigation · Final report · Jun 10, 2015 · N872CS · Substantial damage
  > Maintenance personnel's improper engine oil drain valve installation, which led to engine oil exhaustion and the subsequent loss of engine power after takeoff at an altitude too low for the pilot to execute a forced landing in a suitable area.
- [NTSB CEN15FA189](https://openairdocs.org/ntsb/CEN15FA189.md): Cessna 152 · Batesville, AR · Accident · 1 fatal · Field investigation · Final report · Apr 2, 2015 · N65463 · Destroyed
  > The noninstrument-rated pilot's controlled flight into terrain due to an inadvertent encounter with clouds in dark night conditions. Contributing to the accident was the pilot's decision to fly at night in marginal visual meteorological conditions without the…
- [NTSB CEN15LA015](https://openairdocs.org/ntsb/CEN15LA015.md): Cessna P210N · West Memphis, AR · Accident · No injuries · Limited investigation · Final report · Oct 15, 2014 · N731QV · Substantial damage
  > A catastrophic engine failure due to an oil starvation event for reasons that could not be determined based on the available evidence.
- [NTSB CEN14LA204](https://openairdocs.org/ntsb/CEN14LA204.md): Cessna 210A · Searcy, AR · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 2014 · N9421X · Substantial damage
  > The pilot's inadequate preflight inspection of the airplane, which resulted in oil starvation and a subsequent engine failure.
- [NTSB CEN14GA135](https://openairdocs.org/ntsb/CEN14GA135.md): Cessna 210E · Oden, AR · Accident · 1 fatal · Final report · Jan 31, 2014 · N4957U · Substantial damage
  > The pilot’s improper decision to fly into an area with reported marginal meteorological conditions in an airplane not maintained for instrument flight and his subsequent failure to maintain clearance from trees and terrain.
- [NTSB CEN14LA030](https://openairdocs.org/ntsb/CEN14LA030.md): Piper PA 32R-300 · Hector, AR · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 2013 · N5605V · Substantial damage
  > An engine failure due to crankshaft fatigue cracking for reasons that could not be determined based on the available evidence.
- [NTSB CEN13IA387](https://openairdocs.org/ntsb/CEN13IA387.md): Martin Charles A Zenith Stol CH 750 · Paragould, AR · Incident · No injuries · Incident investigation · Final report · Jun 28, 2013 · N699TX · Minor damage
  > The improper installation of the propeller flange, which resulted in an in-flight separation of the propeller assembly.
- [NTSB CEN13LA095](https://openairdocs.org/ntsb/CEN13LA095.md): Mooney M20E · Gurdon, AR · Accident · No injuries · Limited investigation · Final report · Dec 5, 2012 · N9493V · Substantial damage
  > The total loss of engine power for reasons that could not be determined because no mechanical engine malfunctions were identified and because the actual fuel load and distribution at the time of the accident could not be determined.
- [NTSB CEN13LA054](https://openairdocs.org/ntsb/CEN13LA054.md): Cessna P210N · Conway, AR · Accident · 1 fatal · Limited investigation · Final report · Nov 7, 2012 · N887JA · Substantial damage
  > The pilot's inadequate preflight inspection, which failed to detect the lack of fuel and resulted in fuel exhaustion during climb, and the pilot's subsequent failure to maintain airplane control, which resulted in an aerodynamic stall at low altitude from…

Next page: https://openairdocs.org/ntsb-phases/400/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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/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.