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 UNK65X0954Accident · No injuriesClosedErcoupe 415C · El Reno, OKDec 8, 1964 · N93578 · Substantial damage NTSB UNK65X0917Accident · Minor injuriesClosedCessna 140A · Ardmore, OKDec 4, 1964 · N5369C · Destroyed NTSB UNK65X0885Accident · No injuriesClosedLuscombe 8A · Colony, OKNov 29, 1964 · N71389 · Substantial damage NTSB UNK65X0880Accident · No injuriesClosedBoeing B-720 · Okla City, OKNov 29, 1964 · N113 · Substantial damage NTSB UNK65X0875Accident · No injuriesClosedCessna 182 · Broken Arrow, OKNov 28, 1964 · N5381B · Substantial damage NTSB UNK65X0767Accident · No injuriesClosedBrantly B2 · Muskogee, OKNov 20, 1964 · N5947X · Substantial damage NTSB UNK65X0744Accident · 1 fatalClosedCessna 140A · Tulsa, OKNov 16, 1964 · N5379C · Destroyed NTSB UNK65X0693Accident · No injuriesClosedBell 47G2A · Yukon, OKNov 13, 1964 · N3355D · Substantial damage NTSB UNK65X0662Accident · 1 fatalClosedMooney M18C · Perry, OKNov 11, 1964 · N484M · Destroyed NTSB UNK65X0661Accident · Serious injuriesClosedDean Case Specl · Fairview, OKNov 11, 1964 · N117Q · Destroyed NTSB UNK65X0635Accident · 2 fatalClosedCessna 206 · Ponca City, OKNov 9, 1964 · N5034U · 2 aircraft · Substantial damage NTSB UNK65X0597Accident · No injuriesClosedCessna 172 · Lawton, OKNov 7, 1964 · N3062U · Substantial damage NTSB UNK65X0388Accident · No injuriesClosedAero Comm 520 · El Reno, OKOct 23, 1964 · N4153B · Substantial damage NTSB UNK65X0238Accident · No injuriesClosedCessna 182 · Cache, OKOct 11, 1964 · N4898D · Substantial damage NTSB UNK65X0190Accident · Minor injuriesClosedCessna C37 · Shawnee, OKOct 8, 1964 · N17057 · Destroyed NTSB UNK64X4088Accident · Serious injuriesClosedLuscombe 8E · Sapulpa, OKSep 21, 1964 · N2045K · Substantial damage NTSB UNK64X4041Accident · Serious injuriesClosedPiper PA15 · Wetumka, OKSep 18, 1964 · N4674H · Substantial damage NTSB UNK64X3978Accident · No injuriesClosedPiper J3 · Guthrie, OKSep 13, 1964 · N25803 · No damage NTSB UNK64X3976Accident · No injuriesClosedPiper PA24 · Okla City, OKSep 13, 1964 · N6747P · Substantial damage NTSB UNK64X3885Accident · No injuriesClosedCessna 140 · El Reno, OKSep 9, 1964 · N2228V · Substantial damage NTSB UNK64X3822Accident · No injuriesClosedStinson 108-1 · Ardmore, OKSep 6, 1964 · N8149K · Substantial damage NTSB UNK64X3812Accident · No injuriesClosedPiper PA24 · Perry, OKSep 6, 1964 · N6839P · Substantial damage NTSB UNK64X3804Accident · 2 fatalClosedTaylorcraft BC-12D · Douglas, OKSep 5, 1964 · N95505 · Destroyed NTSB UNK64X3773Accident · No injuriesClosedPiper PA28 · Kingston, OKSep 4, 1964 · N8702W · Substantial damage NTSB UNK64X3750Accident · Minor injuriesClosedErcoupe 415C · Eufaula, OKSep 3, 1964 · N3206H · Substantial damage NTSB UNK64X3479Accident · No injuriesClosedCessna 182 · Mcalester, OKAug 19, 1964 · N6246A · Substantial damage NTSB UNK64X3252Accident · No injuriesClosedPiper PA24 · Prague, OKAug 7, 1964 · N7137P · Substantial damage NTSB UNK64X3189Incident · No injuriesClosedLockheed L-188A · Tulsa, OKAug 3, 1964 · N6119 · Minor damage NTSB UNK64X3151Accident · No injuriesClosedMooney MK20C · Okla City, OKAug 1, 1964 · N6751U · Substantial damage NTSB UNK64X3049Accident · No injuriesClosedCessna 310F · Durant, OKJul 26, 1964 · N6761X · Substantial damage NTSB UNK64X3048Accident · No injuriesClosedErcoupe 415C · Bartlesville, OKJul 26, 1964 · N94027 · Destroyed NTSB UNK64X3019Accident · No injuriesClosedChampion 7EC · Guymon, OKJul 25, 1964 · N8954B · Substantial damage NTSB UNK64X2998Accident · No injuriesClosedBeech F35 · Okla City, OKJul 23, 1964 · N271S · Substantial damage NTSB UNK64X2853Accident · No injuriesClosedCessna 182 · Weatherford, OKJul 16, 1964 · N3971D · Substantial damage NTSB UNK64X2782Accident · Serious injuriesClosedForney 415C · Purcell, OKJul 12, 1964 · N3244H · Destroyed NTSB UNK64X2756Accident · 1 fatalClosedBeechcraft A45 · Anadarko, OKJul 11, 1964 · N9191R · Destroyed NTSB UNK64X2712Accident · No injuriesClosedCessna 310G · Stillwater, OKJul 8, 1964 · N8943Z · Substantial damage NTSB UNK64X2648Accident · 2 fatalClosedCessna 172 · Tulsa, OKJul 4, 1964 · N6496E · Substantial damage NTSB UNK64X2646Accident · No injuriesClosedMooney MK20D · Gage, OKJul 4, 1964 · N6618U · Destroyed NTSB UNK64X2583Accident · 4 fatalClosedCessna 170B · Muskogee, OKJun 30, 1964 · N2550D · Destroyed NTSB UNK64X2514Accident · No injuriesClosedBeechcraft 23 · Yukon, OKJun 27, 1964 · N2364Z · Substantial damage NTSB UNK64X2505Accident · Serious injuriesClosedCessna 180C · Ardmore, OKJun 26, 1964 · N7678A · Destroyed NTSB UNK64X2493Accident · No injuriesClosedPiper PA22 · Mcalester, OKJun 26, 1964 · N9629D · Destroyed NTSB UNK64X2471Accident · 1 fatalClosedPiper J-3C · Stuart, OKJun 24, 1964 · N42594 · Destroyed NTSB UNK64X2463Accident · No injuriesClosedBeechcraft B35 · Wagoner, OKJun 24, 1964 · N5009C · Substantial damage NTSB UNK64X2462Accident · No injuriesClosedMooney MK20E · Hugo, OKJun 24, 1964 · N1987Y · Substantial damage NTSB UNK64X2396Accident · No injuriesClosedBeechcraft M23 · Tishomingo, OKJun 20, 1964 · N2329Z · Substantial damage NTSB UNK64X2341Accident · No injuriesClosedPiper PA24 · Stillwater, OKJun 17, 1964 · N5999P · Substantial damage NTSB UNK64X2339Accident · Minor injuriesClosedAeronca 7AC · Calumet, OKJun 17, 1964 · N1675E · Destroyed NTSB UNK64X2317Accident · No injuriesClosedPiper PA22 · Oakwood, OKJun 16, 1964 · N1439A · Substantial damage