Skip to content

NTSB investigations, OK

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with 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

duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB FTW71DPJ35Accident · No injuriesClosedBeech A23-19 · Turpin, OKMar 28, 1971 · N6916Q · Substantial damage NTSB FTW71FPJ34Accident · Minor injuriesClosedCessna 150K · Bethany, OKMar 25, 1971 · N6495G · Substantial damage NTSB FTW71DPJ33Accident · No injuriesClosedCessna 182 · Woodward, OKMar 17, 1971 · N3563U · Substantial damage NTSB FTW71DPJ32Accident · No injuriesClosedCessna 182N · Enid, OKMar 17, 1971 · N92494 · Substantial damage NTSB FTW71DPJ31Accident · No injuriesClosedBoeing A75 · Chickasha, OKMar 15, 1971 · N50536 · Substantial damage NTSB FTW71FPJ30Accident · No injuriesClosedCessna 172K · Bethany, OKMar 14, 1971 · N84226 · Substantial damage NTSB FTW71FPM22Accident · No injuriesClosedCessna 150J · Spiro, OKMar 13, 1971 · N60953 · Substantial damage NTSB FTW71AF058Accident · 2 fatalClosedCessna 150G · Mcalester, OKMar 8, 1971 · N3285J · Destroyed NTSB FTW71FPJ29Accident · Minor injuriesClosedCessna 150K · Mustang, OKMar 5, 1971 · N5798G · Substantial damage NTSB FTW71FPM21Accident · No injuriesClosedPiper PA-28 · Tulsa, OKFeb 23, 1971 · N7729N · Substantial damage NTSB FTW71DPJ28Incident · No injuriesClosedCessna 150 · Woodward, OKFeb 23, 1971 · N7126F · Minor damage NTSB FTW71FPM20Accident · No injuriesClosedPiper PA-28 · Tulsa, OKFeb 19, 1971 · N5541U · Substantial damage NTSB FTW71AF046Accident · Serious injuriesClosedDouglas DC-3C · Shawnee, OKFeb 14, 1971 · N14273 · Destroyed NTSB FTW71DPJ27Accident · Minor injuriesClosedCessna 172 · Taloga, OKJan 31, 1971 · N2595Y · Substantial damage NTSB FTW71AF043Accident · 1 fatalClosedTaylorcraft BF1265 · Vinita, OKJan 24, 1971 · N36303 · Destroyed NTSB FTW71DPM19Accident · No injuriesClosedPiper PA-28 · Bernice, OKJan 23, 1971 · N993PK · Substantial damage NTSB FTW71AF042Accident · No injuriesClosedBeech E18S · Muskogee, OKJan 20, 1971 · N225H · Substantial damage NTSB FTW71DPM17Accident · No injuriesClosedLuscombe 8A · Bokchito, OKJan 16, 1971 · N71894 · Substantial damage NTSB FTW71AF039Accident · 1 fatalClosedAeronca L-3 · Chelsea, OKJan 16, 1971 · N48225 · Destroyed NTSB FTW71DPM18Accident · No injuriesClosedCessna 150D · Skiatook, OKJan 13, 1971 · N4522U · Substantial damage NTSB FTW71DPJ26Accident · No injuriesClosedCessna 150 · East Jesse, OKJan 11, 1971 · N8284S · Substantial damage NTSB FTW71DPM16Accident · No injuriesClosedBeech V35A · Stilwell, OKJan 9, 1971 · N8485N · Substantial damage NTSB FTW71FPJ24Accident · No injuriesClosedCessna 150 · Wellston, OKDec 30, 1970 · N8449J · Destroyed NTSB FTW71IF033Incident · No injuriesClosedBritish AC 1-11 · Okla.City, OKDec 20, 1970 · N1542 · No damage NTSB FTW71FPJ23Accident · Serious injuriesClosedCessna 150 · Okla.City, OKDec 12, 1970 · N8435J · Substantial damage NTSB FTW71DPJ22Accident · No injuriesClosedBeech 23 · Waukomis, OKDec 12, 1970 · N2332L · Substantial damage NTSB FTW71DPJ26Accident · No injuriesClosedCessna 185 · Buffalo, OKDec 9, 1970 · N101LL · Substantial damage NTSB FTW71AF029Accident · 1 fatalClosedPiper PA-22 · Baker, OKDec 9, 1970 · N5752D · Destroyed NTSB FTW71DPJ21Accident · No injuriesClosedPiper PA-22 · Thomas, OKDec 3, 1970 · N8818C · Substantial damage NTSB FTW71FPJ20Accident · Serious injuriesClosedCessna 150J · Temple, OKDec 1, 1970 · N30HP · Substantial damage NTSB FTW71AF028Accident · 1 fatalClosedTaylorcraft BC-65 · Medford, OKDec 1, 1970 · N11201 · Destroyed NTSB FTW71AF025Accident · 1 fatalClosedAero Comdr 681 · Altus, OKNov 25, 1970 · N9060N · Destroyed NTSB FTW71DPM15Accident · No injuriesClosedPiper PA-22 · Bristow, OKNov 23, 1970 · N9952D · Substantial damage NTSB FTW71FPM14Accident · No injuriesClosedCessna 180 · Jenks, OKNov 19, 1970 · N3375D · Substantial damage NTSB FTW71FPM12Accident · No injuriesClosedCessna 170B · Owasso, OKOct 16, 1970 · N4469B · Substantial damage NTSB FTW71FPM11Accident · No injuriesClosedWaco EQC-6 · Kingston, OKOct 11, 1970 · N2277 · Substantial damage NTSB FTW71DPM13Accident · No injuriesClosedAeronca 11AC · Atoka, OKOct 11, 1970 · N3805E · Substantial damage NTSB FTW71DPM10Accident · No injuriesClosedCessna 210T · Tulsa, OKOct 9, 1970 · N6142R · Substantial damage NTSB FTW71FPM09Accident · Serious injuriesClosedBellanca 14-133 · Tulsa, OKOct 3, 1970 · N6505N · Substantial damage NTSB FTW71DPJ19Accident · No injuriesClosedCessna 172 · Oklahoma Cty, OKSep 29, 1970 · N79444 · Substantial damage NTSB FTW71FPJ18Accident · Minor injuriesClosedAero Comdr 680V · Norman, OKSep 28, 1970 · N1123V · Substantial damage NTSB FTW71FPJ17Accident · Serious injuriesClosedPiper J3C-65 · Butler, OKSep 27, 1970 · N88091 · Substantial damage NTSB FTW71DPJ16Accident · No injuriesClosedCessna 150 · Chattanooga, OKSep 15, 1970 · N50933 · Substantial damage NTSB FTW71DPM08Accident · No injuriesClosedChampion 7KCAB · Jenks, OKAug 25, 1970 · N111AT · Substantial damage NTSB FTW71AF008Accident · No injuriesClosedBeech D18S · Tulsa, OKAug 23, 1970 · N87Q · Substantial damage NTSB FTW71FPJ15Accident · No injuriesClosedMooney M20F · Oklahoma Cty, OKAug 20, 1970 · N9321V · Substantial damage NTSB FTW71DPM07Accident · No injuriesClosedPiper PA-25 · Wade, OKAug 18, 1970 · N6297Z · Substantial damage NTSB FTW71DPJ13Accident · No injuriesClosedPiper PA-28 · Hobart, OKAug 16, 1970 · N3462R · Substantial damage NTSB FTW71DPJ12Accident · No injuriesClosedGrumman G-164 · Boise City, OKAug 15, 1970 · N7716 · Substantial damage NTSB FTW71DPJ11Accident · No injuriesClosedCessna 320D · Oklahoma Cty, OKAug 6, 1970 · N3329Q · Substantial damage