Skip to content

NTSB investigations, OK

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 FTW81DPJ23Accident · No injuriesClosedCessna 152 · Ada, OKMay 20, 1981 · N49022 · Substantial damage NTSB FTW81DPJ25Accident · Minor injuriesClosedGrumman G-164 · Burns Flat, OKMay 8, 1981 · N11KF · Substantial damage NTSB FTW81FA088Accident · 2 fatalClosedBeech 35 · Muse, OKMay 6, 1981 · N3952C · Destroyed NTSB FTW81FA084Accident · 2 fatalClosedCessna 152 · Jones, OKMay 1, 1981 · N68256 · Destroyed NTSB FTW81DPJ24Accident · No injuriesClosedBell 47D1 · Okeene, OKApr 25, 1981 · N7768 · Substantial damage NTSB FTW81FPJ22Accident · No injuriesClosedBeech H35 · Oklahoma City, OKApr 23, 1981 · N5560D · Substantial damage NTSB FTW81DPJ21Accident · No injuriesClosedCessna P210N · Ardmore, OKApr 22, 1981 · N731PD · Substantial damage NTSB FTW81FPJ20Accident · Minor injuriesClosedCessna 150 · Dover, OKApr 19, 1981 · N23005 · Substantial damage NTSB FTW81FA074Accident · 4 fatalClosedBeech E35 · Fay, OKApr 18, 1981 · N3281C · Destroyed NTSB FTW81FPJ19Accident · Serious injuriesClosedCessna A150K · Norman, OKApr 15, 1981 · N8382M · Substantial damage NTSB FTW81FA069Accident · Minor injuriesClosedAerospatial AS350D · Edmond, OKApr 11, 1981 · N888WR · Substantial damage NTSB FTW81FPJ18Accident · Minor injuriesClosedCessna 152 · Bethany, OKApr 9, 1981 · N24734 · Substantial damage NTSB FTW81FPJ16Accident · No injuriesClosedGrumman G-164B · Billings, OKApr 9, 1981 · N48478 · Destroyed NTSB FTW81DPJ15Accident · No injuriesClosedCessna 188 · Seiling, OKApr 9, 1981 · N4830R · Substantial damage NTSB FTW81DPJ14Accident · No injuriesClosedBoeing A75 · Covington, OKApr 8, 1981 · N50149 · Destroyed NTSB FTW81DPM10Accident · No injuriesClosedVarieze Rutan · Bengal, OKApr 3, 1981 · N15RL · Substantial damage NTSB FTW81DPJ13Accident · No injuriesClosedCessna A188B · Cherokee, OKApr 1, 1981 · N731AM · Substantial damage NTSB FTW81FPJ12Accident · Serious injuriesClosedCessna 188 · Blackwell, OKMar 29, 1981 · N4858R · Destroyed NTSB FTW81FPM09Accident · Minor injuriesClosedCessna 152 · Cleveland, OKMar 26, 1981 · N49594 · Destroyed NTSB FTW81DA049Accident · Minor injuriesClosedHughes 269C · Yukon, OKMar 19, 1981 · N8647F · Destroyed NTSB FTW81DPJ11Accident · Serious injuriesClosedCessna A188B · Duncan, OKMar 11, 1981 · N86547 · Destroyed NTSB FTW81DPJ10Accident · No injuriesClosedPitts S-1C · El Reno, OKFeb 24, 1981 · N19JS · Substantial damage NTSB FTW81FA036Accident · 1 fatalClosedLuscombe 8A · Bixby, OKFeb 18, 1981 · N1331B · Destroyed NTSB FTW81FA029Accident · 2 fatalClosedMooney M20F · Bethany, OKFeb 6, 1981 · N7100V · Destroyed NTSB FTW81FPM07Accident · Minor injuriesClosedCessna 150M · Sand Springs, OKJan 18, 1981 · N66389 · Destroyed NTSB FTW81FPJ10Accident · No injuriesClosedBeech 95-B55 · Oklahoma City, OKJan 12, 1981 · N5700K · Substantial damage NTSB FTW81FA023Accident · 5 fatalClosedBell 206B · Norman, OKJan 9, 1981 · N10785 · Destroyed NTSB FTW81FPJ09Accident · No injuriesClosedPiper PA-28 · Enid, OKJan 8, 1981 · N38558 · Substantial damage NTSB FTW81FPM06Accident · No injuriesClosedPiper PA-28 · Atoka, OKJan 4, 1981 · N8824E · Substantial damage NTSB FTW81FPJ08Accident · No injuriesClosedPiper PA-38 · Hennessey, OKJan 4, 1981 · N2405L · Substantial damage NTSB FTW81FA019Accident · 1 fatalClosedPiper PA-22 · Oklahoma City, OKDec 21, 1980 · N2524P · Destroyed NTSB FTW81FPM05Accident · Serious injuriesClosedMooney M20K · Afton, OKDec 17, 1980 · N231KX · Destroyed NTSB FTW81FPM03Accident · No injuriesClosedCessna R172K · Lenapah, OKNov 30, 1980 · N758BN · Substantial damage NTSB FTW81DPJ07Accident · No injuriesClosedCessna 150 · Beaver, OKNov 30, 1980 · N7723E · Substantial damage NTSB FTW81FPM04Accident · No injuriesClosedBeech E18S · Tulsa, OKNov 26, 1980 · N202GW · Substantial damage NTSB FTW81FPM02Accident · Minor injuriesClosedCessna 310Q · Tulsa, OKNov 11, 1980 · N69606 · Substantial damage NTSB FTW81DPJ06Accident · No injuriesClosedHughes 269B · Guymon, OKNov 8, 1980 · N9301F · Destroyed NTSB FTW81FPJ05Accident · No injuriesClosedMaule M-5 · Meno, OKNov 2, 1980 · N5638L · Substantial damage NTSB FTW81FPJ04Accident · Serious injuriesClosedAero Comdr 100 · Hobart, OKOct 26, 1980 · N3701X · Destroyed NTSB FTW81FPJ03Accident · Serious injuriesClosedPiper PA-38 · Hammon, OKOct 19, 1980 · N2476L · Destroyed NTSB FTW81FPJ02Accident · No injuriesClosedWaco YPF-7 · Oklahoma City, OKOct 19, 1980 · N32077 · Substantial damage NTSB FTW81FA005Accident · 4 fatalClosedGrum Amer AA-5B · Madill, OKOct 16, 1980 · N28252 · Destroyed NTSB FTW81FPJ01Accident · Minor injuriesClosedPiper PA-38 · Stillwater, OKOct 11, 1980 · N2592B · Destroyed NTSB FTW81FPM01Accident · 1 fatalClosedBenson B8M · Tulsa, OKOct 9, 1980 · N475 · Destroyed NTSB FTW80FA122Accident · 2 fatalClosedCessna 150L · Hendrix, OKSep 25, 1980 · N11424 · Destroyed NTSB FTW80FPJ36Accident · Serious injuriesClosedCessna 188B · Altus, OKSep 24, 1980 · N8979G · Destroyed NTSB FTW80FPJ34Accident · No injuriesClosedCessna 195B · Newcastle, OKSep 12, 1980 · N195JW · Substantial damage NTSB FTW80FPM19Accident · Serious injuriesClosedWeatherly 201C · Commerce, OKSep 4, 1980 · N9080W · Destroyed NTSB FTW80DPM18Accident · No injuriesClosedCessna 180 · Langley, OKAug 30, 1980 · N9211C · Destroyed NTSB FTW80FPM17Accident · No injuriesClosedPiper PA-25 · Henryetta, OKAug 23, 1980 · N9558P · Substantial damage