# NTSB investigations, OK: 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 CEN24FA148](https://openairdocs.org/ntsb/CEN24FA148.md): Davis DA-3 · Antlers, OK · Accident · 3 fatal · Class 3 · Field · Final report · Apr 4, 2024 · N88DT · Destroyed
  > Impact with terrain for reasons that could not be determined.
- [NTSB CEN20LA266](https://openairdocs.org/ntsb/CEN20LA266.md): Lancair ES-P · Pauls Valley, OK · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 6, 2020 · N444TW · Destroyed
  > The reason for this accident could not be determined based on the available information.
- [NTSB DFW07LA170](https://openairdocs.org/ntsb/DFW07LA170.md): Hazen Fly Baby · Page, OK · Accident · 1 fatal · Limited investigation · Final report · Jul 20, 2007 · N6156Y · Substantial damage
  > The airplane's collision with wooded and mountainous terrain for undetermined reasons.
- [NTSB DFW05LA069](https://openairdocs.org/ntsb/DFW05LA069.md): Nolen Lite Squared · Holdenville, OK · Accident · 1 fatal · Limited investigation · Final report · Jan 14, 2005 · N222JN · Destroyed
  > Undetermined
- [NTSB FTW02LA134](https://openairdocs.org/ntsb/FTW02LA134.md): Robinson Tierra II · Hooker, OK · Accident · 1 fatal · Limited investigation · Final report · May 1, 2002 · N3960D · Destroyed
  > the loss of control for an undetermined reason, which resulted in an in-flight collision with terrain.
- [NTSB FTW01FA151](https://openairdocs.org/ntsb/FTW01FA151.md): Ercoupe 415-CD · McAlester, OK · Accident · 1 fatal · Field investigation · Final report · Jun 24, 2001 · N3962H · Destroyed
  > the inadvertent stall by the pilot-in-command.
- [NTSB FTW86FPJ02](https://openairdocs.org/ntsb/FTW86FPJ02.md): Cessna 152 · Tahlequah, OK · Accident · Serious injuries · Final report · Nov 1, 1985 · N4969H · Substantial damage
  > The acft contacted static cables and descended to ground contact during an aerial search for a person. The plt had turned the acft into the sun when it contacted one of two static cables on a power transmission array aprx 159 ft AGL. The towers to which the…
- [NTSB FTW85FA209](https://openairdocs.org/ntsb/FTW85FA209.md): Luscombe 8E · Verden, OK · Accident · 2 fatal · Field investigation · Final report · May 5, 1985 · N2497K · Destroyed
  > At about 1700 CDT on 5/5/85, the acft was observed taking off at chickasha, OK. At sometime after 1700, an acft matching its description was observed flying low over a lake. A witness in that area observed it pulled up in a steep climb over the dam, until it…
- [NTSB FTW85FA112](https://openairdocs.org/ntsb/FTW85FA112.md): Cessna 402B · Altus, OK · Accident · 2 fatal · Field investigation · Final report · Feb 6, 1985 · N5780M · Destroyed
  > During an eng start, prior to the flt, the l eng backfired 2 or 3 times. A witness described the 1st backfired as 'the loudest I have ever heard.' When the acft took off, two persons living near the departure end of the rwy noted that the acft (believed to be…
- [NTSB FTW84FA291](https://openairdocs.org/ntsb/FTW84FA291.md): Cessna 152 · Minco, OK · Accident · 2 fatal · Field investigation · Final report · Jun 29, 1984 · N6473P · Destroyed
  > The student plt had rented the acft. Records showed that he had flown this acft on previous occasions. The plt acting as instructor did not possess a current instructor certificate. There were no witnesses to the crash, but the acft was observed maneuvering…
- [NTSB FTW84FA258](https://openairdocs.org/ntsb/FTW84FA258.md): Cessna 152 · Fairview, OK · Accident · 1 fatal · Field investigation · Final report · May 31, 1984 · N49640 · Destroyed
  > The acft had inflt structural failure and separation of some components and crashed in an inverted flat spin parts of the wing and aileron were never found. Some parts were found about 1/2 mile from the primary impact point. An autopsy onthe plt revealed the…
- [NTSB FTW84IA135](https://openairdocs.org/ntsb/FTW84IA135.md): Nihon YS-11 · Tulsa, OK · Incident · No injuries · Incident investigation · Final report · Feb 15, 1984 · N903TC · No damage
  > The acft experienced a nose wheel steering malfunction & ran off the rwy during landing. The nose wheel system was removed from the acft & submitted for inspection & overhaul. Examination revealed that the lever shaft 'ears' had separated from fatigue.
- [NTSB FTW81FPM01](https://openairdocs.org/ntsb/FTW81FPM01.md): Benson B8M · Tulsa, OK · Accident · 1 fatal · Closed · Oct 9, 1980 · N475 · Destroyed
- [NTSB FTW79FPJ19](https://openairdocs.org/ntsb/FTW79FPJ19.md): Piper PA-36 · Boise City, OK · Accident · 1 fatal · Closed · May 27, 1979 · N9978P · Destroyed
- [NTSB FTW79DPJ04](https://openairdocs.org/ntsb/FTW79DPJ04.md): Beech E50 · Frederick, OK · Accident · No injuries · Closed · Feb 9, 1979 · N4376D · Substantial damage
- [NTSB FTW78FPM11](https://openairdocs.org/ntsb/FTW78FPM11.md): Lockheed TV-2 · Muskogee, OK · Accident · Serious injuries · Closed · May 27, 1978 · N1118U · Destroyed
- [NTSB FTW74DPJ10](https://openairdocs.org/ntsb/FTW74DPJ10.md): Helio Acft H-295 · Olustee, OK · Accident · No injuries · Closed · Sep 28, 1973 · N6473V · Substantial damage
- [NTSB FTW69A0014](https://openairdocs.org/ntsb/FTW69A0014.md): Aeronca 11AC · Idabel, OK · Accident · 2 fatal · Closed · Aug 31, 1968 · N85811 · 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" = 'OK' 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=OK

---
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.