# 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 47 of 56 · 2,799 cases ## Cases, newest first - [NTSB FTW69F0142](https://openairdocs.org/ntsb/FTW69F0142.md): Globe GC-1B · Okla.City, OK · Accident · Minor injuries · Closed · Aug 10, 1968 · N2421B · Substantial damage - [NTSB FTW69D0139](https://openairdocs.org/ntsb/FTW69D0139.md): Piper PA-22 · Lamont, OK · Accident · No injuries · Closed · Aug 6, 1968 · N1703P · Substantial damage - [NTSB FTW69D0133](https://openairdocs.org/ntsb/FTW69D0133.md): Beech A23-19 · Yukon, OK · Accident · No injuries · Closed · Aug 6, 1968 · N3635Q · Substantial damage - [NTSB FTW69F0132](https://openairdocs.org/ntsb/FTW69F0132.md): Cessna 150 · Erick, OK · Accident · No injuries · Closed · Aug 5, 1968 · N7936E · Destroyed - [NTSB FTW69D0151](https://openairdocs.org/ntsb/FTW69D0151.md): Cessna 182A · Lexington, OK · Accident · No injuries · Closed · Aug 4, 1968 · N6123B · Substantial damage - [NTSB FTW69F0120](https://openairdocs.org/ntsb/FTW69F0120.md): Cessna 170A · Piedmont, OK · Accident · No injuries · Closed · Jul 31, 1968 · N9572A · Substantial damage - [NTSB FTW69D0082](https://openairdocs.org/ntsb/FTW69D0082.md): Cessna 182 · Pond Creek, OK · Accident · No injuries · Closed · Jul 28, 1968 · N3579U · Substantial damage - [NTSB FTW69F0069](https://openairdocs.org/ntsb/FTW69F0069.md): Cessna 150 · Collinsville, OK · Accident · No injuries · Closed · Jul 25, 1968 · N8326G · Substantial damage - [NTSB FTW69F0124](https://openairdocs.org/ntsb/FTW69F0124.md): Cessna 150 · Beaver, OK · Accident · No injuries · Closed · Jul 19, 1968 · N3698J · Substantial damage - [NTSB FTW69D0099](https://openairdocs.org/ntsb/FTW69D0099.md): Taylorcraft BC-65 · Broken Arrow, OK · Accident · No injuries · Closed · Jul 19, 1968 · N22636 · Substantial damage - [NTSB FTW69D0062](https://openairdocs.org/ntsb/FTW69D0062.md): Cessna 182 · Enid, OK · Accident · No injuries · Closed · Jun 30, 1968 · N2244E · Substantial damage - [NTSB FTW69F0031](https://openairdocs.org/ntsb/FTW69F0031.md): Piper PA-18A · Antlers, OK · Accident · 1 fatal · Closed · Jun 16, 1968 · N9902D · Destroyed - [NTSB FTW68D0030](https://openairdocs.org/ntsb/FTW68D0030-110300.md): Beech 23 · Claremore, OK · Accident · No injuries · Closed · Jun 14, 1968 · N2309L · Substantial damage - [NTSB FTW69D0022](https://openairdocs.org/ntsb/FTW69D0022.md): Cessna 182 · Ardmore, OK · Accident · No injuries · Closed · Jun 2, 1968 · N3187R · Substantial damage - [NTSB FTW68A0101](https://openairdocs.org/ntsb/FTW68A0101.md): Cessna 337B · Norman, OK · Accident · No injuries · Closed · May 30, 1968 · N2308S · 2 aircraft · Substantial damage - [NTSB FTW68A0100](https://openairdocs.org/ntsb/FTW68A0100.md): Cessna 172 · Purcell, OK · Accident · 1 fatal · Closed · May 30, 1968 · N9123B · No damage - [NTSB FTW69F0005](https://openairdocs.org/ntsb/FTW69F0005.md): Hughes 269A · Jenks, OK · Accident · No injuries · Closed · May 27, 1968 · N8843F · Destroyed - [NTSB FTW68D0613](https://openairdocs.org/ntsb/FTW68D0613.md): Callair A-4 · Mill Creek, OK · Accident · Minor injuries · Closed · May 26, 1968 · N6042C · Destroyed - [NTSB FTW68A0095](https://openairdocs.org/ntsb/FTW68A0095.md): Bell 47G3B1 · Yukon, OK · Accident · No injuries · Closed · May 22, 1968 · N6228N · Substantial damage - [NTSB FTW69D0004](https://openairdocs.org/ntsb/FTW69D0004.md): Piper PA-24 · Antlers, OK · Accident · No injuries · Closed · May 21, 1968 · N9009P · Substantial damage - [NTSB FTW68F0572](https://openairdocs.org/ntsb/FTW68F0572.md): Piper PA-28 · Guymon, OK · Accident · No injuries · Closed · May 17, 1968 · N6355R · Substantial damage - [NTSB FTW69D0018](https://openairdocs.org/ntsb/FTW69D0018.md): Cessna 310 · Daisy, OK · Accident · No injuries · Closed · May 12, 1968 · N1715H · Substantial damage - [NTSB FTW68D0585](https://openairdocs.org/ntsb/FTW68D0585.md): Piper PA-25 · Terral, OK · Accident · No injuries · Closed · May 5, 1968 · N6918Z · Substantial damage - [NTSB FTW68A0091](https://openairdocs.org/ntsb/FTW68A0091.md): Cessna 150H · Norman, OK · Accident · 1 fatal · Closed · May 4, 1968 · N7099S · Destroyed - [NTSB FTW68F0577](https://openairdocs.org/ntsb/FTW68F0577.md): Beech A23 · Sasakwa, OK · Accident · Minor injuries · Closed · May 1, 1968 · N4770J · Substantial damage - [NTSB FTW68D0565](https://openairdocs.org/ntsb/FTW68D0565.md): Cessna 182K · Madill, OK · Accident · No injuries · Closed · Apr 28, 1968 · N2552R · Substantial damage - [NTSB FTW68D0563](https://openairdocs.org/ntsb/FTW68D0563.md): Cessna 182D · Balko, OK · Accident · No injuries · Closed · Apr 26, 1968 · N9926T · Substantial damage - [NTSB FTW68F0562](https://openairdocs.org/ntsb/FTW68F0562.md): Cessna 150E · Oweta, OK · Accident · Serious injuries · Closed · Apr 25, 1968 · N6102T · Destroyed - [NTSB FTW68D0560](https://openairdocs.org/ntsb/FTW68D0560.md): Cessna 150 · Wynona, OK · Accident · No injuries · Closed · Apr 25, 1968 · N7178K · Substantial damage - [NTSB FTW68F0532](https://openairdocs.org/ntsb/FTW68F0532.md): Aeronca 7EC · Okla.City, OK · Accident · No injuries · Closed · Apr 18, 1968 · N4677E · Substantial damage - [NTSB FTW68D0531](https://openairdocs.org/ntsb/FTW68D0531.md): Cessna 182 · Norman, OK · Accident · No injuries · Closed · Apr 15, 1968 · N3143R · Substantial damage - [NTSB FTW68F0550](https://openairdocs.org/ntsb/FTW68F0550.md): Cessna 150F · Mounds, OK · Accident · No injuries · Closed · Apr 14, 1968 · N6830F · Substantial damage - [NTSB FTW68A0089](https://openairdocs.org/ntsb/FTW68A0089.md): Beech D18S · Altus, OK · Accident · No injuries · Closed · Apr 14, 1968 · N212Z · Substantial damage - [NTSB FTW68F0548](https://openairdocs.org/ntsb/FTW68F0548.md): Piper PA-18A · Watonga, OK · Accident · 1 fatal · Closed · Apr 13, 1968 · N4578A · Destroyed - [NTSB FTW68F0504](https://openairdocs.org/ntsb/FTW68F0504.md): Beech A23 · Tulsa, OK · Accident · No injuries · Closed · Apr 2, 1968 · N6931Q · Substantial damage - [NTSB FTW68D0541](https://openairdocs.org/ntsb/FTW68D0541.md): Piper PA-24 · Hardesty, OK · Accident · Minor injuries · Closed · Mar 29, 1968 · N5631P · Substantial damage - [NTSB FTW68D0540](https://openairdocs.org/ntsb/FTW68D0540.md): Piper PA-11 · Altus, OK · Accident · No injuries · Closed · Mar 28, 1968 · N78633 · Substantial damage - [NTSB FTW68D0502](https://openairdocs.org/ntsb/FTW68D0502.md): Cessna 150 · Hardesty, OK · Accident · No injuries · Closed · Mar 23, 1968 · N4357U · Substantial damage - [NTSB FTW68D0497](https://openairdocs.org/ntsb/FTW68D0497.md): Stinson 108-3 · Beaver, OK · Accident · No injuries · Closed · Mar 18, 1968 · N6175M · Substantial damage - [NTSB FTW68F0509](https://openairdocs.org/ntsb/FTW68F0509.md): Cessna 172 · Oklahoma Cty, OK · Accident · Minor injuries · Closed · Mar 14, 1968 · N1156F · Substantial damage - [NTSB FTW68D0486](https://openairdocs.org/ntsb/FTW68D0486.md): Piper PA-30 · Altus, OK · Accident · No injuries · Closed · Mar 14, 1968 · N7278Y · Substantial damage - [NTSB FTW68F0476](https://openairdocs.org/ntsb/FTW68F0476.md): Cessna 150 · Mounds, OK · Accident · No injuries · Closed · Mar 13, 1968 · N2430J · Substantial damage - [NTSB FTW68F0483](https://openairdocs.org/ntsb/FTW68F0483.md): Cessna 172 · Broken Arrow, OK · Accident · 1 fatal · Closed · Mar 1, 1968 · N8063L · Destroyed - [NTSB FTW68D0506](https://openairdocs.org/ntsb/FTW68D0506.md): Cessna 172 · Fairview, OK · Accident · No injuries · Closed · Mar 1, 1968 · N6250E · Substantial damage - [NTSB FTW68D0466](https://openairdocs.org/ntsb/FTW68D0466.md): Piper PA-28 · Okla.City, OK · Accident · No injuries · Closed · Feb 23, 1968 · N4234J · Substantial damage - [NTSB FTW68D0481](https://openairdocs.org/ntsb/FTW68D0481-111925.md): Beech V-35 · Eufaula, OK · Accident · No injuries · Closed · Feb 18, 1968 · N7976M · Substantial damage - [NTSB FTW68F0449](https://openairdocs.org/ntsb/FTW68F0449.md): Cessna 170B · Hominy, OK · Accident · No injuries · Closed · Feb 10, 1968 · N2759C · Substantial damage - [NTSB FTW68D0439](https://openairdocs.org/ntsb/FTW68D0439.md): Mooney M20F · Webber Falls, OK · Accident · No injuries · Closed · Feb 4, 1968 · N3881N · Substantial damage - [NTSB FTW68A0078](https://openairdocs.org/ntsb/FTW68A0078.md): Mooney M20 · Page, OK · Accident · 4 fatal · Closed · Jan 26, 1968 · N5225B · Destroyed - [NTSB FTW68D0430](https://openairdocs.org/ntsb/FTW68D0430.md): Piper J3C · Ardmore, OK · Accident · No injuries · Closed · Jan 25, 1968 · N6741H · Substantial damage Next page: https://openairdocs.org/ntsb.md?state=OK&page=48 ## 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=47&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.