# NTSB investigations, AR: Unknown

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.

## Latest cases

- [NTSB CEN22LA121](https://openairdocs.org/ntsb/CEN22LA121.md): Piper PA22 · Furlow, AR · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 14, 2022 · N7337D · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB CEN19FA248](https://openairdocs.org/ntsb/CEN19FA248.md): Cessna 310 · De Queen, AR · Accident · 1 fatal · Class 3 · Field · Final report · Aug 4, 2019 · N310QA · Substantial damage
  > A loss of control for reasons that could not be determined based on the available information.
- [NTSB CEN12LA352](https://openairdocs.org/ntsb/CEN12LA352.md): Grumman G164 · Higginson, AR · Accident · No injuries · Limited investigation · Final report · Jun 7, 2012 · N779EF · Substantial damage
  > The partial loss of engine power for reasons that could not be determined due to impact and fire damage.
- [NTSB FTW03LA094](https://openairdocs.org/ntsb/FTW03LA094.md): Cessna 210L · Morrilton, AR · Accident · No injuries · Limited investigation · Final report · Feb 4, 2003 · N22432 · Substantial damage
  > The failure of the main landing gear to extend and lock, as a result of a hydraulic fluid leak caused by a chaffed and ruptured flex line.
- [NTSB FTW01LA180](https://openairdocs.org/ntsb/FTW01LA180.md): Cessna 210 · Fort Smith, AR · Accident · No injuries · Limited investigation · Final report · Aug 12, 2001 · N8137L · Substantial damage
  > the overload fracture of the left main landing gear actuator which resulted in the loss of all hydraulic fluid and led to a wheels up landing.
- [NTSB FTW00LA006](https://openairdocs.org/ntsb/FTW00LA006.md): WSK PZL Mielec M18 · Weldon, AR · Accident · 1 fatal · Limited investigation · Final report · Oct 5, 1999 · N4779G · Destroyed
  > The cause of the accident was undetermined.
- [NTSB FTW99FA150](https://openairdocs.org/ntsb/FTW99FA150.md): Grumman-Schweizer G164-B · Brinkley, AR · Accident · 1 fatal · Field investigation · Final report · May 26, 1999 · N8285K · Destroyed
  > The pilot's inadvertent VFR flight into instrument meteorological conditions. Contributing factors were the pilots failure to maintain control of the aircraft, spatial disorientation, and the fog.
- [NTSB FTW91LA077](https://openairdocs.org/ntsb/FTW91LA077.md): Vuncannon Rotoway Exec 152 · Jonesboro, AR · Accident · Serious injuries · Limited investigation · Final report · May 10, 1991 · N316FV · Destroyed
  > The pilot's inadequate lookout and failure to maintain sufficient clearance from the wires for safe operation.
- [NTSB MKC89FA061](https://openairdocs.org/ntsb/MKC89FA061.md): Beech 58 · Hamburg, AR · Accident · 2 fatal · Field investigation · Final report · Feb 17, 1989 · N348U · Destroyed
  > The 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 FTW82FPG14](https://openairdocs.org/ntsb/FTW82FPG14.md): Aeronca 7AC · Lehi, AR · Accident · 2 fatal · Final report · Jun 7, 1982 · N83654 · Substantial damage
  > The acft was believed to have departed the west memphis arpt at approximately 1900. The acft was found at approximately 2000 in an open field 2 mi sw of the arpt. The acft had collided with the ground very hard in a nose down condition. Neither occupant…
- [NTSB FTW82FA108](https://openairdocs.org/ntsb/FTW82FA108.md): Gulfstream American 690C · Hughes, AR · Accident · 1 fatal · Field investigation · Final report · Mar 29, 1982 · N5957K · Destroyed
  > The acft had been on sales demonstration flts and was on a delivery flt from memphis, TN to dallas, TX. The plane was observed departing at 1550 CDT in a max performance climb. Radar info from mode c of the transponder returns indicated that the acft climbed…
- [NTSB FTW80DPG03](https://openairdocs.org/ntsb/FTW80DPG03.md): Bellanca 7ECA · Batesville, AR · Accident · No injuries · Closed · Oct 16, 1979 · N6308N · Substantial damage
- [NTSB FTW70F0252](https://openairdocs.org/ntsb/FTW70F0252.md): Champion 7ECA · Alicia, AR · Accident · No injuries · Closed · Sep 23, 1969 · N2880G · Substantial damage
- [NTSB FTW67F0167](https://openairdocs.org/ntsb/FTW67F0167.md): Cessna 140 · Jonesboro, AR · Accident · Serious injuries · Closed · Jul 24, 1966 · N3192N · Destroyed

## 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 = 990)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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