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

Page 56 of 56 · 2,799 cases

## Cases, newest first

- [NTSB UNK64X2249](https://openairdocs.org/ntsb/UNK64X2249.md): Beechcraft 35 · Piedmont, OK · Accident · No injuries · Closed · Jun 12, 1964 · N3388V · Substantial damage
- [NTSB UNK64X2234](https://openairdocs.org/ntsb/UNK64X2234.md): Luscombe 8A · Mcalester, OK · Accident · No injuries · Closed · Jun 11, 1964 · N23047 · Substantial damage
- [NTSB UNK64X2176](https://openairdocs.org/ntsb/UNK64X2176.md): Piper PA18 · Enid, OK · Accident · Serious injuries · Closed · Jun 7, 1964 · N2528B · Substantial damage
- [NTSB UNK64X2136](https://openairdocs.org/ntsb/UNK64X2136.md): Brantly B2 · Okla City, OK · Accident · Serious injuries · Closed · Jun 5, 1964 · N5907X · Substantial damage
- [NTSB UNK64X2130](https://openairdocs.org/ntsb/UNK64X2130.md): Cessna 175 · Okla City, OK · Accident · No injuries · Closed · Jun 5, 1964 · N8369T · Substantial damage
- [NTSB UNK64X2057](https://openairdocs.org/ntsb/UNK64X2057.md): Waco Ykcs · Okla City, OK · Accident · No injuries · Closed · May 31, 1964 · N15232 · Substantial damage
- [NTSB UNK64X2045](https://openairdocs.org/ntsb/UNK64X2045.md): Piper J3 · Bixby, OK · Accident · Serious injuries · Closed · May 31, 1964 · N41308 · Substantial damage
- [NTSB UNK64X1990](https://openairdocs.org/ntsb/UNK64X1990.md): Globe Swift GC1B · Mcalester, OK · Accident · Minor injuries · Closed · May 28, 1964 · N80667 · Substantial damage
- [NTSB UNK64X1978](https://openairdocs.org/ntsb/UNK64X1978.md): Snow S2C · Bartlesville, OK · Accident · No injuries · Closed · May 27, 1964 · N9472R · Substantial damage
- [NTSB UNK64X1856](https://openairdocs.org/ntsb/UNK64X1856.md): Piper PA18 · Sulphur, OK · Accident · Serious injuries · Closed · May 19, 1964 · N9148D · Destroyed
- [NTSB UNK64X1842](https://openairdocs.org/ntsb/UNK64X1842.md): Piper PA24 · Okla City, OK · Accident · No injuries · Closed · May 19, 1964 · N8339P · Substantial damage
- [NTSB UNK64X1834](https://openairdocs.org/ntsb/UNK64X1834.md): Brantly B2B · Tulsa, OK · Accident · Minor injuries · Closed · May 18, 1964 · N2170U · Destroyed
- [NTSB UNK64X1719](https://openairdocs.org/ntsb/UNK64X1719.md): Piper PA22 · Collinsville, OK · Accident · No injuries · Closed · May 11, 1964 · N1447C · Substantial damage
- [NTSB UNK64X1682](https://openairdocs.org/ntsb/UNK64X1682.md): Cessna 150 · Chattanooga, OK · Accident · No injuries · Closed · May 9, 1964 · N5965E · Substantial damage
- [NTSB UNK64X1655](https://openairdocs.org/ntsb/UNK64X1655.md): Beech A35 · Bristow, OK · Accident · No injuries · Closed · May 7, 1964 · N576B · Substantial damage
- [NTSB UNK64X1603](https://openairdocs.org/ntsb/UNK64X1603.md): Cessna 140A · Frederick, OK · Accident · No injuries · Closed · May 3, 1964 · N72385 · Substantial damage
- [NTSB UNK64X1571](https://openairdocs.org/ntsb/UNK64X1571.md): Cessna 120 · Okla City, OK · Accident · No injuries · Closed · May 2, 1964 · N2391N · Substantial damage
- [NTSB UNK64X1533](https://openairdocs.org/ntsb/UNK64X1533.md): Piper PA22 · Enid, OK · Accident · No injuries · Closed · Apr 30, 1964 · N1439A · 2 aircraft · Minor damage
- [NTSB UNK64X1425](https://openairdocs.org/ntsb/UNK64X1425.md): Piper PA23 · Guthrie, OK · Accident · No injuries · Closed · Apr 23, 1964 · N4430P · Substantial damage
- [NTSB UNK64X1404](https://openairdocs.org/ntsb/UNK64X1404.md): Callair A5 · Lucein, OK · Accident · No injuries · Closed · Apr 21, 1964 · N9966C · Substantial damage
- [NTSB UNK64X1400](https://openairdocs.org/ntsb/UNK64X1400.md): Ryan PT22 · Tulsa, OK · Accident · No injuries · Closed · Apr 21, 1964 · N59450 · Substantial damage
- [NTSB UNK64X1364](https://openairdocs.org/ntsb/UNK64X1364.md): Piper PA18 · Billings, OK · Accident · 1 fatal · Closed · Apr 18, 1964 · N7246X · Destroyed
- [NTSB UNK64X1243](https://openairdocs.org/ntsb/UNK64X1243.md): Piper PA24 · Norman, OK · Accident · No injuries · Closed · Apr 10, 1964 · N5528P · Substantial damage
- [NTSB UNK64X1238](https://openairdocs.org/ntsb/UNK64X1238.md): Beechcraft D18 · Piedmont, OK · Accident · No injuries · Closed · Apr 9, 1964 · N181E · Substantial damage
- [NTSB UNK64X1230](https://openairdocs.org/ntsb/UNK64X1230.md): Piper PA25 · El Reno, OK · Accident · Serious injuries · Closed · Apr 8, 1964 · N6983Z · Minor damage
- [NTSB UNK64X1229](https://openairdocs.org/ntsb/UNK64X1229.md): Aeronca 7AC · Ames, OK · Accident · Serious injuries · Closed · Apr 8, 1964 · N83867 · Substantial damage
- [NTSB UNK64X1226](https://openairdocs.org/ntsb/UNK64X1226.md): Piper PA25 · Crescent, OK · Accident · No injuries · Closed · Apr 8, 1964 · N6475Z · Destroyed
- [NTSB UNK64X1175](https://openairdocs.org/ntsb/UNK64X1175.md): Cessna 210 · Webber Falls, OK · Accident · No injuries · Closed · Apr 5, 1964 · N7471E · Substantial damage
- [NTSB UNK64X1143](https://openairdocs.org/ntsb/UNK64X1143.md): Champion 7FC · Muldrow, OK · Accident · No injuries · Closed · Apr 3, 1964 · N84576 · Substantial damage
- [NTSB UNK64X1090](https://openairdocs.org/ntsb/UNK64X1090.md): Piper PA20 · Mt View, OK · Accident · No injuries · Closed · Mar 29, 1964 · N7446K · Substantial damage
- [NTSB UNK64X1067](https://openairdocs.org/ntsb/UNK64X1067.md): Piper PA16 · Henryetta, OK · Accident · Minor injuries · Closed · Mar 28, 1964 · N5956H · Substantial damage
- [NTSB UNK64X1022](https://openairdocs.org/ntsb/UNK64X1022.md): Piper PA22 · Gage, OK · Accident · No injuries · Closed · Mar 23, 1964 · N1456A · Substantial damage
- [NTSB UNK64X0965](https://openairdocs.org/ntsb/UNK64X0965.md): Beechcraft E35 · Wagoner, OK · Accident · No injuries · Closed · Mar 17, 1964 · N3310C · Substantial damage
- [NTSB UNK64X0943](https://openairdocs.org/ntsb/UNK64X0943.md): Piper J3 · Tulsa, OK · Accident · Minor injuries · Closed · Mar 15, 1964 · N38493 · Substantial damage
- [NTSB UNK64X0912](https://openairdocs.org/ntsb/UNK64X0912.md): Cessna 175 · Okla City, OK · Accident · No injuries · Closed · Mar 14, 1964 · N9213B · Substantial damage
- [NTSB UNK64X0870](https://openairdocs.org/ntsb/UNK64X0870.md): Piper PA24 · Frederick, OK · Accident · No injuries · Closed · Mar 10, 1964 · N7482P · Substantial damage
- [NTSB UNK64X0772](https://openairdocs.org/ntsb/UNK64X0772.md): Cessna 170 · Okla City, OK · Accident · No injuries · Closed · Mar 1, 1964 · N4419V · Substantial damage
- [NTSB UNK64X0727](https://openairdocs.org/ntsb/UNK64X0727.md): Beechcraft 35B · Checotah, OK · Accident · No injuries · Closed · Feb 28, 1964 · N5103C · Substantial damage
- [NTSB UNK64X0654](https://openairdocs.org/ntsb/UNK64X0654.md): Beechcraft 35 · Keyes, OK · Accident · No injuries · Closed · Feb 22, 1964 · N5846C · Substantial damage
- [NTSB UNK64X0636](https://openairdocs.org/ntsb/UNK64X0636.md): Piper PA24 · Guymon, OK · Accident · No injuries · Closed · Feb 21, 1964 · N7335P · Substantial damage
- [NTSB UNK64X0625](https://openairdocs.org/ntsb/UNK64X0625.md): Beechcraft 35 · Moore, OK · Accident · No injuries · Closed · Feb 20, 1964 · N4474V · Substantial damage
- [NTSB UNK64X0607](https://openairdocs.org/ntsb/UNK64X0607.md): Piper PA24 · Ft Sill, OK · Accident · No injuries · Closed · Feb 19, 1964 · N7318P · Substantial damage
- [NTSB UNK64X0486](https://openairdocs.org/ntsb/UNK64X0486.md): Cessna 182 · Broken Arrow, OK · Accident · No injuries · Closed · Feb 7, 1964 · N5773B · Substantial damage
- [NTSB UNK64X0344](https://openairdocs.org/ntsb/UNK64X0344.md): Ercoupe 415 · Norman, OK · Accident · No injuries · Closed · Jan 25, 1964 · N24054 · Substantial damage
- [NTSB UNK64X0273](https://openairdocs.org/ntsb/UNK64X0273.md): Cessna 182 · Ada, OK · Accident · No injuries · Closed · Jan 18, 1964 · N6483A · Destroyed
- [NTSB UNK64X0260](https://openairdocs.org/ntsb/UNK64X0260.md): Cessna 182 · Pryor, OK · Accident · No injuries · Closed · Jan 16, 1964 · N3652U · Substantial damage
- [NTSB UNK64X0241](https://openairdocs.org/ntsb/UNK64X0241.md): Cessna 150 · Shawnee, OK · Accident · 1 fatal · Closed · Jan 14, 1964 · N7844Z · Destroyed
- [NTSB UNK64X0201](https://openairdocs.org/ntsb/UNK64X0201.md): Beechcraft C18S · Okla City, OK · Accident · No injuries · Closed · Jan 9, 1964 · N11198 · Substantial damage
- [NTSB UNK64X0149](https://openairdocs.org/ntsb/UNK64X0149.md): Cessna 182 · Kingston, OK · Accident · No injuries · Closed · Jan 4, 1964 · N2204G · Substantial damage

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

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