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 FTW68F0422Accident · No injuriesClosedCessna 140 · Ponca City, OKJan 21, 1968 · N72750 · Substantial damage NTSB FTW68A0072Accident · No injuriesClosedPiper PA-30 · Enid, OKJan 17, 1968 · N7407Y · Substantial damage NTSB FTW68D0402Accident · No injuriesClosedCessna 172 · Stigler, OKDec 25, 1967 · N3958F · Substantial damage NTSB FTW68D0401Accident · No injuriesClosedBeech A23 · Pryor, OKDec 23, 1967 · N3515R · Substantial damage NTSB FTW68A0062Accident · 2 fatalClosedPiper PA-24 · Shawnee, OKDec 8, 1967 · N6519P · Destroyed NTSB FTW68A0061Accident · No injuriesClosedDouglas B-26 · Oklahoma Cty, OKDec 8, 1967 · N6840D · Substantial damage NTSB FTW68A0057Accident · 1 fatalClosedPiper PA-22 · Porum, OKDec 1, 1967 · N7007B · Destroyed NTSB FTW68A0056Accident · 2 fatalClosedPiper PA-24 · Enid, OKNov 30, 1967 · N6020P · Destroyed NTSB FTW68D0340Accident · No injuriesClosedPiper PA-30 · Okla.City, OKNov 27, 1967 · N7519Y · Substantial damage NTSB FTW68D0366Accident · No injuriesClosedPiper PA-24 · Hollis, OKNov 25, 1967 · N8378P · Substantial damage NTSB FTW68A0051Accident · No injuriesClosedCessna 310L · El Reno, OKNov 22, 1967 · N2261F · Substantial damage NTSB FTW68F0364Accident · No injuriesClosedCessna 175 · Mooreland, OKNov 20, 1967 · N9431B · Substantial damage NTSB FTW68D0354Accident · No injuriesClosedCessna 150 · Sand Springs, OKNov 20, 1967 · N3288J · Substantial damage NTSB FTW68D0338Accident · No injuriesClosedMooney M20C · Marlow, OKNov 20, 1967 · N6434U · Substantial damage NTSB FTW68F0362Accident · No injuriesClosedPiper PA-28 · Yukon, OKNov 17, 1967 · N4483J · Substantial damage NTSB FTW68D0352Accident · No injuriesClosedErco 415-C · Guthrie, OKNov 15, 1967 · N99911 · Substantial damage NTSB FTW68D0336Accident · No injuriesClosedCessna 182 · Norman, OKNov 14, 1967 · N2087R · Substantial damage NTSB FTW68D0361Accident · No injuriesClosedCessna 210 · Alva, OKNov 13, 1967 · N6766R · Substantial damage NTSB FTW68D0292Accident · No injuriesClosedMooney M20E · Tulsa, OKNov 13, 1967 · N5596Q · Substantial damage NTSB FTW68D0334Accident · No injuriesClosedRyan ST-3KR · Tulsa, OKNov 12, 1967 · N1344 · Minor damage NTSB FTW68A0048Accident · Serious injuriesClosedGyrocopter Z3-65M · Oklahoma Cty, OKNov 12, 1967 · N74064 · Substantial damage NTSB FTW68F0333Accident · No injuriesClosedCessna 150 · Bethany, OKNov 11, 1967 · N8761S · Substantial damage NTSB FTW68F0331Accident · Minor injuriesClosedPiper PA-22 · Fairview, OKNov 11, 1967 · N3635P · Destroyed NTSB FTW68D0332Accident · No injuriesClosedNaval Fcty N3N · Frederick, OKNov 11, 1967 · N44830 · Substantial damage NTSB FTW68F0329Accident · Serious injuriesClosedAeronca 7AC · Kingfisher, OKNov 6, 1967 · N1703E · Substantial damage NTSB FTW68A0047Accident · 2 fatalClosedCessna 150F · Elgin, OKNov 4, 1967 · N8683S · Destroyed NTSB FTW68D0415Accident · Minor injuriesClosedPiper PA-22 · Honobia, OKOct 28, 1967 · N6707B · Substantial damage NTSB FTW68D0297Accident · No injuriesClosedPiper PA-25 · Reed, OKOct 20, 1967 · N7655Z · Substantial damage NTSB FTW68F0288Accident · Minor injuriesClosedCessna 310D · Stilwell, OKOct 19, 1967 · N6927T · Substantial damage NTSB FTW68D0286Accident · No injuriesClosedCessna 150 · Okla. City, OKOct 17, 1967 · N3954U · Substantial damage NTSB FTW68D0283Accident · No injuriesClosedBeech S35 · Tulsa, OKOct 14, 1967 · N320JD · Substantial damage NTSB FTW68A0040Accident · 1 fatalClosedBensen B8M · Yukon, OKOct 10, 1967 · N9171 · Destroyed NTSB FTW68F0244Accident · Serious injuriesClosedPiper PA-28 · Tulsa, OKOct 1, 1967 · N6721W · Substantial damage NTSB FTW68D0026Accident · No injuriesClosedCessna 150E · Mill Creek, OKSep 30, 1967 · N6251T · Substantial damage NTSB FTW68D0241Accident · No injuriesClosedCessna 150 · Lexington, OKSep 24, 1967 · N7985E · Substantial damage NTSB FTW68D0238CaseClosedMooney M20C · Okmulgee, OKSep 19, 1967 NTSB FTW68D0222Accident · No injuriesClosedCessna 150F · Guymon, OKSep 10, 1967 · N6671F · Substantial damage NTSB FTW68D0220Accident · No injuriesClosedPiper PA-22 · Marshall, OKSep 9, 1967 · N6946D · Substantial damage NTSB FTW68D0199Accident · No injuriesClosedCessna 182C · Skiatook, OKSep 4, 1967 · N8572T · Substantial damage NTSB MKC68A0018Accident · 4 fatalClosedPiper PA-16 · Blocker, OKSep 3, 1967 · N5746H · 2 aircraft · Destroyed NTSB FTW68D0217Accident · No injuriesClosedErco 415-C · Canute, OKSep 3, 1967 · N2131H · Substantial damage NTSB FTW68A0023Accident · 2 fatalClosedPiper PA-28 · Springer, OKAug 31, 1967 · N7452R · Destroyed NTSB FTW68F0213Accident · No injuriesClosedPiper PA-22 · Quinton, OKAug 27, 1967 · N1330C · Substantial damage NTSB FTW68F0161Accident · Minor injuriesClosedPiper PA-28 · Blackwell, OKAug 27, 1967 · N5090W · Substantial damage NTSB FTW68F0160Accident · No injuriesClosedPiper PA-24 · Okla-City, OKAug 27, 1967 · N8545P · Substantial damage NTSB FTW68D0193Accident · No injuriesClosedPiper PA-24 · Skiatook, OKAug 27, 1967 · N6452P · Substantial damage NTSB FTW68F0191Accident · Minor injuriesClosedCessna 170 · Okla.City, OKAug 26, 1967 · N4105V · Substantial damage NTSB FTW68F0189Accident · No injuriesClosedBeech A23-19 · Temple, OKAug 23, 1967 · N4788J · Substantial damage NTSB FTW68F0158Accident · No injuriesClosedPiper PA-24 · Mangum, OKAug 22, 1967 · N8721P · Substantial damage NTSB FTW68F0157Accident · No injuriesClosedLuscombe 8C · Norman, OKAug 22, 1967 · N2863K · Substantial damage