# NTSB investigations, OK: 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 7 · 318 cases

## Latest cases

- [NTSB CEN26LA248](https://openairdocs.org/ntsb/CEN26LA248.md): Piper PA-30 · Tulsa, OK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 9, 2026 · N8154Y · Substantial damage
  > On July 9, 2026, about 1729 central daylight time, a Piper PA-30 airplane, N8154Y, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The flight instructor and pilot under instruction were seriously injured. The airplane was…
- [NTSB CEN25LA192](https://openairdocs.org/ntsb/CEN25LA192.md): Piper PA-32RT-300T · Tulsa, OK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 30, 2025 · N130XR · Substantial damage
  > On May 30, 2025, about 1627 central daylight time, a Piper PA-32RT-300T airplane, N130XR, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The pilot sustained serious injuries, and the pilot-rated passenger sustained minor…
- [NTSB CEN25FA148](https://openairdocs.org/ntsb/CEN25FA148.md): Anusiewicz Cassutt III M · Haskell, OK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 8, 2025 · N5RR · Substantial damage
  > On April 8, 2025, about 1459 central daylight time, a Cassutt III M airplane, N5RR, was substantially damaged when it was involved in an accident near Haskell, Oklahoma. The pilot was fatally injured. The aircraft was operated as a Title 14 Code of Federal…
- [NTSB CEN25LA051](https://openairdocs.org/ntsb/CEN25LA051.md): Cessna 340 · Muskogee, OK · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 27, 2024 · N5757C · Substantial damage
  > The pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.
- [NTSB CEN23LA268](https://openairdocs.org/ntsb/CEN23LA268.md): Velocity Velocity XL · Tahlequah, OK · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 27, 2023 · N340XL · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB CEN23LA224](https://openairdocs.org/ntsb/CEN23LA224.md): Beech A36 · Oklahoma City, OK · Accident · No injuries · Class 3 · Limited · Final report · Jun 4, 2023 · N9169Q · Substantial damage
  > A loss of engine power during approach for landing for undetermined reasons.
- [NTSB CEN23FA050](https://openairdocs.org/ntsb/CEN23FA050.md): Cessna 170 · Gage, OK · Accident · 2 fatal · Class 3 · Field · Final report · Nov 28, 2022 · N2710D · Destroyed
  > The non-certificated pilots’ loss of airplane control, resulting in an impact with terrain during final approach. Contributing to the accident was the airplane owner’s impairment due to his use of ethanol and depressant medications, in combination with his…
- [NTSB CEN22LA300](https://openairdocs.org/ntsb/CEN22LA300.md): Cessna 150E · Harrah, OK · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 1, 2022 · N6147T · Substantial damage
  > The flight instructor’s inadequate inflight fuel planning that resulted in fuel exhaustion and a forced landing.
- [NTSB DCA22LA126](https://openairdocs.org/ntsb/DCA22LA126.md): Boeing 757-236 · Tulsa, OK · Incident · No injuries · Class 3 · Limited · Final report · Jun 8, 2022 · N949FD · No damage
  > The flight crew’s misidentification of the intended landing runway. Contributing to the incident were (1) the flight crew’s failure to perceive and correctly interpret visual and auditory indicators – including electronic guidance – that they were approaching…
- [NTSB CEN22LA066](https://openairdocs.org/ntsb/CEN22LA066.md): Piper PA-22-135 · Tahlequah, OK · Accident · No injuries · Class 4 · Limited · Final report · Dec 3, 2021 · N3372A · Substantial damage
  > A loss of yaw control while on final approach, which resulted in the pilot performing an off-runway landing, and a subsequent nose over. The reason for the loss of yaw control could not be determined based on the available evidence.
- [NTSB GAA19CA536](https://openairdocs.org/ntsb/GAA19CA536.md): Cessna 310 · Tahlequah, OK · Accident · Minor injuries · Data collection · Final report · Sep 5, 2019 · N7673Q · Substantial damage
  > The total loss of right engine power due to fuel starvation and the pilot's improper fuel management.
- [NTSB GAA19CA142](https://openairdocs.org/ntsb/GAA19CA142.md): Cirrus SR22 · Tulsa, OK · Accident · No injuries · Data collection · Final report · Feb 20, 2019 · N381DE · Substantial damage
  > The pilot's failure to maintain a stabilized approach with a tailwind and his subsequent failure to maintain yaw control during an attempted go-around.
- [NTSB CEN18FA023](https://openairdocs.org/ntsb/CEN18FA023.md): Beech V35B · Alva, OK · Accident · 2 fatal · Field investigation · Final report · Nov 4, 2017 · N777PH · Destroyed
  > The flight instructor's and pilot's failure to recognize that a high descent rate had developed on short final, likely due to their distraction by an open engine cowling, and the unexpected strong pitch-down force during flap extension due to the installation…
- [NTSB CEN17LA357](https://openairdocs.org/ntsb/CEN17LA357.md): Beech A36 · McAlester, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 2017 · N18403 · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB GAA17CA472](https://openairdocs.org/ntsb/GAA17CA472.md): Mooney M20 · Skiatook, OK · Accident · No injuries · Data collection · Final report · Aug 2, 2017 · N95442 · Substantial damage
  > The pilot's improper decision to conduct the flight despite the fuel gauges indicating that there was insufficient fuel for the flight, which resulted in the low amount of fuel in the right tank becoming unported during the multiple turns, and his subsequent…
- [NTSB CEN17LA242](https://openairdocs.org/ntsb/CEN17LA242.md): Bellanca 17 30 · Grove, OK · Accident · No injuries · Limited investigation · Final report · Jun 25, 2017 · N14728 · Substantial damage
  > An unporting of fuel in the right wing while maneuvering in the airport traffic pattern, which resulted in a partial loss of engine power due to fuel starvation.
- [NTSB CEN17FA170](https://openairdocs.org/ntsb/CEN17FA170.md): Air Tractor AT 602 · Hollis, OK · Accident · 1 fatal · Field investigation · Final report · Apr 28, 2017 · N604RH · Substantial damage
  > An impact with terrain during final approach for reasons that could not be determined because no evidence of an in-flight failure or malfunction was observed.
- [NTSB CEN15LA205](https://openairdocs.org/ntsb/CEN15LA205.md): Pitts Model 12 · Burneyville, OK · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 2015 · N12DR · Substantial damage
  > The partial loss of engine power due to contamination of the fuel system.
- [NTSB CEN14LA129](https://openairdocs.org/ntsb/CEN14LA129.md): Cessna 525 · Elk City, OK · Accident · No injuries · Limited investigation · Final report · Feb 4, 2014 · N61YP · Substantial damage
  > The pilot’s descent below the published minimum descent altitude for the instrument approach procedure, which resulted in impact with a utility pole.
- [NTSB CEN13LA370](https://openairdocs.org/ntsb/CEN13LA370.md): Mooney M20J · El Reno, OK · Accident · No injuries · Limited investigation · Final report · Jun 25, 2013 · N205MC · Substantial damage
  > A loss of engine power, which resulted from the failure of the magneto assembly for reasons that could not be determined during postaccident examinations.
- [NTSB CEN13CA315](https://openairdocs.org/ntsb/CEN13CA315.md): Cub Crafters CCK · Cookson, OK · Accident · No injuries · Data collection · Final report · Jun 3, 2013 · N319MA · Substantial damage
  > A total loss of engine power due to water contamination in the fuel. Contributing to the accident was the pilot's failure to check the fuel during the preflight, and failure to check the fuel storage tank’s fuel filter/water separator.
- [NTSB CEN13TA113](https://openairdocs.org/ntsb/CEN13TA113.md): Cessna 550 · Oklahoma City, OK · Accident · Minor injuries · Final report · Dec 21, 2012 · N753CC · Substantial damage
  > The flight crew's decision to fly close behind a heavy airplane, which did not ensure there was adequate distance and time in order to avoid a wake turbulence encounter with the preceding heavy airplane’s wake vortex, which resulted in a loss of airplane…
- [NTSB CEN12CA625](https://openairdocs.org/ntsb/CEN12CA625.md): Beech 35 · Geary, OK · Accident · No injuries · Data collection · Final report · Sep 9, 2012 · N3014V · Substantial damage
  > The student pilot failed to maintain control of the airplane during a forced landing attempt which resulted in an aerodynamic stall. Contributing to the accident was the instructor pilot's delay in taking control of the airplane and the loss of engine power…
- [NTSB CEN12LA179](https://openairdocs.org/ntsb/CEN12LA179.md): Skeeter 1M · Oklahoma City, OK · Accident · 1 fatal · Limited investigation · Final report · Mar 3, 2012 · N1111V · Substantial damage
  > The pilot's failure to maintain airplane control while on final approach as he was executing a turn to provide spacing between his airplane and an airplane on the runway.
- [NTSB CEN12CA016](https://openairdocs.org/ntsb/CEN12CA016.md): Cessna 182A · Skiatook, OK · Accident · No injuries · Data collection · Final report · Oct 12, 2011 · N6171B · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel management.
- [NTSB CEN11FA434](https://openairdocs.org/ntsb/CEN11FA434.md): Schaffer Gary W Lancair · Yukon, OK · Accident · 1 fatal · Field investigation · Final report · Jun 30, 2011 · N358MA · Substantial damage
  > The pilot's use of an excessive bank angle while in the airport traffic pattern, which resulted in an accelerated stall. Contributing to the accident were the pilot’s lack of experience in the airplane and the pilot’s distracted attention to the rough running…
- [NTSB CEN11IA280](https://openairdocs.org/ntsb/CEN11IA280.md): Beech 90B · Chickasha, OK · Incident · No injuries · Incident investigation · Final report · Apr 11, 2011 · N37OU · Minor damage
  > The mechanic's improper installation of the aileron.
- [NTSB CEN10LA572](https://openairdocs.org/ntsb/CEN10LA572.md): Cessna 172RG · Tulsa, OK · Accident · Serious injuries · Limited investigation · Final report · Sep 28, 2010 · N5145U · Destroyed
  > A shorted terminal lug on the landing gear hydraulic pump which resulted in a cabin fire. Contributing to the accident was the lack of clear installation procedures for the hydraulic pump.
- [NTSB CEN10CA517](https://openairdocs.org/ntsb/CEN10CA517.md): Beech D35 · Guymon, OK · Accident · Minor injuries · Data collection · Final report · Sep 1, 2010 · N3446B · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB CEN10FA385](https://openairdocs.org/ntsb/CEN10FA385.md): Cessna 177B · Owasso, OK · Accident · 3 fatal · Field investigation · Final report · Jul 12, 2010 · N345MT · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during an engine-out approach to the runway, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot’s inadequate preflight planning, which resulted in a loss of engine power due…
- [NTSB CEN10FA382](https://openairdocs.org/ntsb/CEN10FA382.md): Cessna 421 · Tulsa, OK · Accident · 3 fatal · Field investigation · Final report · Jul 11, 2010 · N88DF · Substantial damage
  > The pilot’s inadequate preflight fuel planning and management in-flight, which resulted in total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s use of performance-impairing medications.
- [NTSB CEN10LA272](https://openairdocs.org/ntsb/CEN10LA272.md): North American T-28A · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · May 27, 2010 · N128AF · Substantial damage
  > The failure of the master rod bearing, which resulted in a loss of engine power.
- [NTSB CEN10FA071](https://openairdocs.org/ntsb/CEN10FA071.md): Cessna 310R · Alva, OK · Accident · 1 fatal · Field investigation · Final report · Dec 13, 2009 · N310CR · Substantial damage
  > The pilot's impairment due to medication use, a migraine headache, or both, and his decision to continue the approach below minimums without the proper visual references, resulting in the subsequent collision with terrain. Contributing to the accident was the…
- [NTSB DFW08CA229](https://openairdocs.org/ntsb/DFW08CA229.md): Sukhoi SU-31M · Collinsville, OK · Accident · No injuries · Data collection · Final report · Sep 14, 2008 · N531MS · Substantial damage
  > The pilot's failure to maintain clearance from marked transmission lines while on final approach.
- [NTSB DFW07LA080](https://openairdocs.org/ntsb/DFW07LA080.md): Beech P35 · Ponca City, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 2007 · N1554Z · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DFW07FA071](https://openairdocs.org/ntsb/DFW07FA071.md): Stevens KB-2 · Oklahoma City, OK · Accident · 1 fatal · Field investigation · Final report · Feb 18, 2007 · N6KT · Substantial damage
  > The pilot's failure to maintain control of the gyroplane while in the traffic pattern. Contributing to the accident was the high wind with terrain induced turbulence and the absence of the gyroplane's horizontal stabilizer.
- [NTSB DFW07LA032](https://openairdocs.org/ntsb/DFW07LA032.md): Noble Vans RV-7A · Norman, OK · Accident · 2 fatal · Limited investigation · Final report · Dec 2, 2006 · N216RV · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's attempt at formation flying.
- [NTSB DFW06CA165](https://openairdocs.org/ntsb/DFW06CA165.md): Cessna 210 · Lawton, OK · Accident · No injuries · Data collection · Final report · Jun 12, 2006 · N7303E · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DFW06CA112](https://openairdocs.org/ntsb/DFW06CA112.md): Bell 206B · Vinita, OK · Accident · No injuries · Data collection · Final report · May 2, 2006 · N342WC · Substantial damage
  > The pilot's improper pre-flight planning, which resulted in a total loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DFW06CA045](https://openairdocs.org/ntsb/DFW06CA045.md): Cessna 150L · Tulsa, OK · Accident · Minor injuries · Data collection · Final report · Jan 1, 2006 · N18132 · Substantial damage
  > The pilot's improper preflight planning and preparation, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB DFW05LA031](https://openairdocs.org/ntsb/DFW05LA031.md): Beech B200 · Tulsa, OK · Accident · Minor injuries · Limited investigation · Final report · Dec 9, 2004 · N6PE · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and in-flight planning / preparation.
- [NTSB FTW04LA046](https://openairdocs.org/ntsb/FTW04LA046.md): Bell 206B · Henryetta, OK · Accident · No injuries · Limited investigation · Final report · Dec 20, 2003 · N62HF · Substantial damage
  > The pilot's inadequate visual look out and failure to maintain clearance from guy wire while maneuvering for landing.
- [NTSB FTW04LA031](https://openairdocs.org/ntsb/FTW04LA031.md): Cessna 310-H · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Dec 2, 2003 · N815M · Substantial damage
  > The pilot's mismanagement of the fuel by which he failed to position the fuel selector on the appropriate fuel tanks resulting in fuel starvation. A contributing factor was the pilot's diverted attention.
- [NTSB FTW03LA220](https://openairdocs.org/ntsb/FTW03LA220.md): Cessna 172M · Ardmore, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 11, 2003 · N9651Q · Substantial damage
  > The failure of the pilot to adequately compensate for existing wind conditions. A contributing factor was the gusty crosswind conditions from the east.
- [NTSB FTW03LA009](https://openairdocs.org/ntsb/FTW03LA009.md): Cessna 152 · Tulsa, OK · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 2002 · N520SU · Substantial damage
  > The pilot's improper recovery from a bounced landing and his failure to maintain airspeed. A contributing factor was the pilot's failure to align with the runway.
- [NTSB FTW02LA257](https://openairdocs.org/ntsb/FTW02LA257.md): Smith Aerostar 601P · Piedmont, OK · Accident · No injuries · Limited investigation · Final report · Sep 16, 2002 · N90652 · Substantial damage
  > A fuel leak at the left boost pump to bladder tank flange, which resulted in fuel exhaustion and the subsequent loss of power to both engines.
- [NTSB FTW02LA089](https://openairdocs.org/ntsb/FTW02LA089.md): Bell 206L-3 · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Mar 4, 2002 · N227H · Substantial damage
  > the loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW02LA073](https://openairdocs.org/ntsb/FTW02LA073.md): Cessna 152 · Ardmore, OK · Accident · No injuries · Limited investigation · Final report · Jan 26, 2002 · N47802 · Substantial damage
  > the instructor pilot's delayed go-around which resulted in an in-flight collision with trees. A contributing factor to the accident was the instructor pilot's fatigued condition due to lack of sleep.
- [NTSB FTW02LA052](https://openairdocs.org/ntsb/FTW02LA052.md): Piper PA-23-250 · Duncan, OK · Accident · Serious injuries · Limited investigation · Final report · Dec 13, 2001 · N127CA · Substantial damage
  > The pilot's descent below the minimum descent altitude, and his failure to maintain obstacle clearance. Contributing factors were the below approach/landing minimum weather, the dark night conditions, and the inoperative REIL's.
- [NTSB FTW02LA009](https://openairdocs.org/ntsb/FTW02LA009.md): Cessna 182A · Chickasha, OK · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 2001 · N3862D · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=OK&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" = 'OK' 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=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.