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 FTW74FPM12Accident · 2 fatalClosedCameron Skyblt · Sand Springs, OKNov 10, 1973 · N711PC · Destroyed NTSB FTW74FPM10Accident · Serious injuriesClosedMooney M22 · Sand Springs, OKNov 5, 1973 · N7737M · Destroyed NTSB FTW74FPJ12Accident · Serious injuriesClosedBeech 35-33 · Cushing, OKNov 2, 1973 · N938T · Destroyed NTSB FTW74AF025Accident · 2 fatalClosedCessna 175 · Wister, OKOct 27, 1973 · N7685M · Destroyed NTSB FTW74AF024Accident · 1 fatalClosedBeech 95-C55 · Sallisaw, OKOct 25, 1973 · N24ST · Destroyed NTSB FTW74FPJ11Accident · 1 fatalClosedPiper J-3 · Elk City, OKOct 12, 1973 · N59625 · Destroyed NTSB FTW74DPJ10Accident · No injuriesClosedHelio Acft H-295 · Olustee, OKSep 28, 1973 · N6473V · Substantial damage NTSB FTW74DPM09Accident · No injuriesClosedCessna 150 · Bristow, OKSep 25, 1973 · N23369 · Substantial damage NTSB FTW74DPM08Accident · No injuriesClosedBoeing A75 · Coleman, OKSep 23, 1973 · N4564N · Substantial damage NTSB FTW74DPM07Accident · No injuriesClosedErco 415-C · Silver City, OKSep 9, 1973 · N93319 · Substantial damage NTSB FTW74AF014Accident · 2 fatalClosedBeech P35 · Achille, OKSep 6, 1973 · N1479G · Destroyed NTSB FTW74FPJ09Accident · No injuriesClosedCessna 140A · Bethany, OKSep 3, 1973 · N1108D · Substantial damage NTSB FTW74FPM06Accident · No injuriesClosedPiper PA-30 · Tulsa, OKAug 31, 1973 · N8328Y · Substantial damage NTSB FTW74AF010Accident · No injuriesClosedErco 415-C · Page, OKAug 22, 1973 · N93394 · Substantial damage NTSB FTW74AF009Accident · 2 fatalClosedAero Comdr 690A · Alex, OKAug 22, 1973 · N333CA · Destroyed NTSB FTW74FPJ06Accident · 1 fatalClosedEL Tomcat MK5 · Springer, OKAug 16, 1973 · N11VH · Substantial damage NTSB FTW74FPM05Accident · No injuriesClosedPiper PA-22 · Tulsa, OKAug 14, 1973 · N8039D · Substantial damage NTSB FTW74DPJ07Accident · No injuriesClosedChampion 7GCBC · Seminole, OKAug 14, 1973 · N5242X · Substantial damage NTSB FTW74DPJ05Accident · No injuriesClosedLuscombe 8A · Optima, OKAug 6, 1973 · N72004 · Substantial damage NTSB FTW74DPM04Accident · No injuriesClosedCessna 150E · Warner, OKAug 4, 1973 · N6251T · Substantial damage NTSB FTW74DPJ04Accident · No injuriesClosedBoeing A75N1 · Minco, OKAug 3, 1973 · N75321 · Substantial damage NTSB FTW74FPM03Accident · No injuriesClosedHughes 269C · Shidler, OKAug 1, 1973 · N9662F · Substantial damage NTSB FTW74DPJ03Accident · No injuriesClosedPiper PA-25 · Blanchard, OKJul 31, 1973 · N6189Z · Substantial damage NTSB FTW74AF005Accident · 3 fatalClosedBoeing 727 · Yukon, OKJul 27, 1973 · N127 · 2 aircraft · Substantial damage NTSB FTW74FPM02Accident · No injuriesClosedCessna 180 · Tulsa, OKJul 26, 1973 · N11118 · Substantial damage NTSB FTW74FPM01Accident · No injuriesClosedPiper PA-28 · Stilwell, OKJul 25, 1973 · N15917 · Substantial damage NTSB FTW74FPJ02Accident · Serious injuriesClosedBeech V35 · Oklahoma Cty, OKJul 12, 1973 · N630AW · Substantial damage NTSB FTW74FPJ01Accident · Serious injuriesClosedPiper PA-25 · Tonkawa, OKJul 11, 1973 · N6197Z · Destroyed NTSB FTW73FPM19Accident · Minor injuriesClosedBoeing B75N1 · Stuart, OKJun 28, 1973 · N5409N · Substantial damage NTSB FTW73FPJ25Accident · Minor injuriesClosedCessna 310Q · El Reno, OKJun 27, 1973 · N7935Q · Destroyed NTSB FTW73FPJ24Accident · Serious injuriesClosedCessna 172A · Canton, OKJun 23, 1973 · N7518T · Substantial damage NTSB FTW73FPM18Accident · No injuriesClosedErco 415-C · Tulsa, OKJun 22, 1973 · N99121 · Substantial damage NTSB FTW73DPJ23Accident · No injuriesClosedCessna 177 · El Reno, OKJun 20, 1973 · N3498T · Substantial damage NTSB FTW73FPM17Accident · Minor injuriesClosedCessna A188 · Centrahoma, OKJun 17, 1973 · N9905G · Substantial damage NTSB FTW73FPM16Accident · No injuriesClosedAero Comdr A-9B · Hallett, OKJun 13, 1973 · N7650V · Substantial damage NTSB FTW73FPM14Accident · No injuriesClosedCessna 182A · Kingston, OKJun 8, 1973 · N2146G · Destroyed NTSB FTW73FPM15Accident · 1 fatalClosedPiper PA-18A · Welch, OKJun 7, 1973 · N9290D · Destroyed NTSB FTW73FPM13Accident · No injuriesClosedCessna 182P · Sallisaw, OKJun 6, 1973 · PT-IRL · Substantial damage NTSB FTW73FPM12Accident · Serious injuriesClosedCessna 172K · Henryetta, OKJun 5, 1973 · N84358 · Substantial damage NTSB FTW73FPJ21Accident · No injuriesClosedCessna 150L · Yukon, OKMay 29, 1973 · N19200 · Substantial damage NTSB FTW73DPJ22Accident · No injuriesClosedPiper PA-25 · Banner, OKMay 29, 1973 · N6071Z · Destroyed NTSB FTW73DPJ20Accident · No injuriesClosedHiller UH-12B · Guymon, OKMay 28, 1973 · N6744C · Substantial damage NTSB FTW73FPM11Accident · No injuriesClosedCessna A188 · Tulsa, OKMay 23, 1973 · N3525Q · Substantial damage NTSB FTW73FPM10Accident · No injuriesClosedCessna 195A · Tulsa, OKMay 18, 1973 · N4343N · Substantial damage NTSB FTW73DPJ19Accident · No injuriesClosedPiper PA-25 · Tonkawa, OKMay 17, 1973 · N6197Z · Substantial damage NTSB FTW73DPJ18Accident · Minor injuriesClosedCessna 150L · Enid, OKMay 15, 1973 · N5241Q · Destroyed NTSB FTW73FPM09Accident · No injuriesClosedCessna A188 · Grove, OKMay 12, 1973 · N8055V · Substantial damage NTSB FTW73FPM08Accident · No injuriesClosedPiper PA-22 · Vinita, OKApr 27, 1973 · N6139D · Substantial damage NTSB FTW73FPJ17Accident · Minor injuriesClosedHughes 269B · Enid, OKApr 21, 1973 · N115AC · Substantial damage NTSB FTW73FPJ15Accident · No injuriesClosedBoeing B75N1 · El Reno, OKApr 20, 1973 · N5080N · Substantial damage