# Major NTSB investigations, OK

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 DFW08MA076](https://openairdocs.org/ntsb/DFW08MA076.md): Cessna 500 · Oklahoma City, OK · Accident · 5 fatal · Class 1 · Major · Final report · Mar 4, 2008 · N113SH · Destroyed
  > Airplane wing-structure damage sustained during impact with one or more large birds (American white pelicans), which resulted in a loss of control of the airplane.
- [NTSB DCA88MA059](https://openairdocs.org/ntsb/DCA88MA059.md): Embraer EMB-110P · Lawton, OK · Accident · Serious injuries · Major investigation · Final report · May 24, 1988 · N65DA · Destroyed
  > None submitted
- [NTSB FTW88MA021](https://openairdocs.org/ntsb/FTW88MA021.md): Convair 640 (340D) · Bartlesville, OK · Accident · Minor injuries · Major investigation · Final report · Oct 28, 1987 · N3411 · Destroyed
  > The capt was cross-feeding both engines from the right tank while the first officer (f/o) was flying, without informing the f/o. the capt then left the cockpit while cross-feeding. Both tank valves and the right boost pump were on. The right tank ran dry, the…
- [NTSB FTW87MA133](https://openairdocs.org/ntsb/FTW87MA133.md): Cessna P210R · Arnett, OK · Accident · 1 fatal · Major investigation · Final report · Jun 3, 1987 · N5488A · Destroyed
  > The flt departed baton rouge (btr) for the plts stated dest of alexandria, which was 78 miles on a bearing of 301 deg, at 0836 CDT. After dep the btr local area there was no radio contact with any ATC facility. The transponder continued to transmit a code…
- [NTSB FTW85MA297](https://openairdocs.org/ntsb/FTW85MA297.md): Beech H35 · El Reno, OK · Accident · 3 fatal · Major investigation · Final report · Jul 25, 1985 · N356B · Destroyed
  > The acft took off at 1054 CDT in VMC with no flt plan. At that time, there was a rprtd ceiling of 1800 ft. at 1112 CDT, the plt rprtd he was at 10,000 ft, 'just reaching the tops.' At 1137 CDT, he stated 'we're about 60 west of oke city, westbound to sayre…
- [NTSB DCA82AA001](https://openairdocs.org/ntsb/DCA82AA001.md): Learjet 24 · Felt, OK · Accident · 3 fatal · Closed · Oct 1, 1981 · N44CJ · Destroyed

## The whole list in SQL

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

```sql
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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?major=1&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.