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 FTW66F0445Accident · No injuriesClosedPiper PA-24 · Stillwater, OKNov 21, 1965 · N7192P · Substantial damage NTSB FTW66A0048Accident · 1 fatalClosedTaylorcraft BC-12 · Pearson, OKNov 20, 1965 · N29718 · Substantial damage NTSB FTW66F0422Accident · No injuriesClosedAero Cmdr 520 · Oklahoma City, OKNov 17, 1965 · N264RW · Substantial damage NTSB FTW66D0392Accident · No injuriesClosedPiper J-3 · Washita, OKNov 7, 1965 · N88468 · Substantial damage NTSB FTW66A0043Accident · 3 fatalClosedDouglas C-124 · Tulsa, OKNov 7, 1965 · AF52-942 · 2 aircraft · Substantial damage NTSB FTW66A0042Accident · No injuriesClosedBrantly B-2B · Wynne Wood, OKNov 6, 1965 · N2274U · Substantial damage NTSB FTW66A0041Accident · 2 fatalClosedCessna 182H · Moore, OKNov 5, 1965 · N1850X · Destroyed NTSB FTW66A0040Accident · 2 fatalClosedBeech 95-55 · Lawton, OKNov 3, 1965 · N1344Z · Destroyed NTSB FTW66F0346Accident · No injuriesClosedPiper PA-22 · Yukon, OKOct 28, 1965 · N7328D · Substantial damage NTSB FTW66A0038Accident · 1 fatalClosedLuscombe 8A · Guthrie, OKOct 24, 1965 · N39015 · Destroyed NTSB FTW66D0418Accident · No injuriesClosedPiper PA-24 · Tulsa, OKOct 15, 1965 · N7857P · Substantial damage NTSB FTW66F0352Accident · Minor injuriesClosedPiper J-3 · Randlett, OKOct 10, 1965 · N32905 · Substantial damage NTSB FTW66D0416Accident · No injuriesClosedPiper PA-30 · Tulsa, OKOct 10, 1965 · N7746Y · Substantial damage NTSB FTW66F0385Accident · No injuriesClosedCessna 172 · Tulsa, OKOct 9, 1965 · N5497R · Substantial damage NTSB FTW66F0339Accident · No injuriesClosedCessna 150 · Oklahoma Cty, OKOct 9, 1965 · N8761S · Substantial damage NTSB FTW66F0350Accident · No injuriesClosedMooney M20C · Bethany, OKOct 8, 1965 · N5848Q · Substantial damage NTSB FTW66A0035Accident · 1 fatalClosedCessna 182B · Tulsa, OKOct 7, 1965 · N2300G · Destroyed NTSB FTW66D0337Accident · No injuriesClosedBeechcraft 35-A33 · Moyer, OKOct 4, 1965 · N536T · Substantial damage NTSB FTW66F0335Accident · No injuriesClosedMooney M20A · Tulsa, OKOct 1, 1965 · N8369E · Substantial damage NTSB FTW66F0333Accident · Minor injuriesClosedLangley 2-4-90 · Tulsa, OKSep 26, 1965 · N51706 · Destroyed NTSB FTW66D0301Accident · No injuriesClosedBeechcraft J-35 · Ardmore, OKSep 24, 1965 · N3013C · Substantial damage NTSB UNK65X1535Accident · No injuriesClosedLockheed L-1049 · Ardmore, OKSep 20, 1965 · N9719C · Substantial damage NTSB FTW66A0012Accident · No injuriesClosedBrantly B2B · Yukon, OKSep 15, 1965 · N2252U · Substantial damage NTSB FTW66D0297Accident · No injuriesClosedPiper PA-25 · Hollis, OKSep 6, 1965 · N6474Z · Substantial damage NTSB FTW66D0296Accident · No injuriesClosedMooney M20C · Mangum, OKSep 5, 1965 · N6434U · Substantial damage NTSB FTW66F0307Accident · Minor injuriesClosedCessna 140 · Tulsa, OKSep 4, 1965 · N76029 · Substantial damage NTSB FTW66A0025Accident · No injuriesClosedBell 47G2A · Arnegie, OKSep 2, 1965 · N73259 · Substantial damage NTSB FTW66D0318Accident · No injuriesClosedCessna 172 · Vinita, OKAug 28, 1965 · N8809B · Substantial damage NTSB FTW66D0293Accident · No injuriesClosedCessna 182 · Perry, OKAug 22, 1965 · N1827X · Substantial damage NTSB FTW66F0254Accident · No injuriesClosedPiper PA-23 · Tulsa, OKAug 18, 1965 · N4982P · Substantial damage NTSB FTW66D0465Accident · No injuriesClosedPiper PA-22 · Yukon, OKAug 14, 1965 · N1962A · Substantial damage NTSB FTW66F0241Accident · Minor injuriesClosedPiper PA-25 · Fort Gibson, OKAug 4, 1965 · N6723Z · Substantial damage NTSB FTW66D0220Accident · Minor injuriesClosedCessna 150 · Wilson, OKAug 3, 1965 · N4163U · Substantial damage NTSB FTW66D0214Accident · No injuriesClosedCessna 182E · Tulsa, OKAug 1, 1965 · N3509Y · Substantial damage NTSB FTW66D0168Accident · No injuriesClosedPiper PA-28 · Yukon, OKJul 31, 1965 · N6600W · Substantial damage NTSB FTW66A0012Accident · 2 fatalClosedPiper J3C · Arnett, OKJul 31, 1965 · N24620 · Destroyed NTSB FTW66A0010Accident · 6 fatalClosedPiper PA-23 · Tahlequah, OKJul 29, 1965 · N2025P · Destroyed NTSB FTW66D0170Accident · No injuriesClosedPiper PA-23 · Fairview, OKJul 28, 1965 · N5630Y · Substantial damage NTSB FTW66D0261Accident · No injuriesClosedMooney M21 · Albion, OKJul 26, 1965 · N6941U · Substantial damage NTSB FTW66D0187Accident · No injuriesClosedChampion 7AC · Ada, OKJul 26, 1965 · N7563E · Substantial damage NTSB FTW66D0160Accident · No injuriesClosedPiper PA-24 · Enterprise, OKJul 25, 1965 · N7446P · Substantial damage NTSB FTW66A0007Accident · 1 fatalClosedCessna 172 · 2e Chelsea, OKJul 25, 1965 · N7031A · Destroyed NTSB FTW66F0166Accident · Serious injuriesClosedPiper PA-25 · Hough, OKJul 23, 1965 · N6739Z · Substantial damage NTSB FTW66A0005Accident · 2 fatalClosedHughes 269A · Woodward, OKJul 17, 1965 · N8710F · Destroyed NTSB FTW66D0149Accident · Minor injuriesClosedCessna 140 · Cashion, OKJul 15, 1965 · N72688 · Substantial damage NTSB FTW66D0178Accident · No injuriesClosedBeechcraft B35 · Carnegie, OKJul 14, 1965 · N5195C · Substantial damage NTSB FTW66D0164Accident · No injuriesClosedCessna 195 · Poteau, OKJul 13, 1965 · N74040 · Substantial damage NTSB FTW66F0210Accident · Serious injuriesClosedSchweizer SGS126 · Guthrie, OKJul 8, 1965 · N2776Z · Substantial damage NTSB FTW66D0127Accident · Minor injuriesClosedSnow S2C · Sickles, OKJul 7, 1965 · N9467R · Substantial damage NTSB FTW66D0126Accident · No injuriesClosedCessna 172 · Chickasha, OKJul 7, 1965 · N8554U · Destroyed