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 FTW77FA071Accident · 1 fatalClosedPiper PA-28R · Healdton, OKAug 19, 1977 · N38140 · Destroyed NTSB FTW77FA068Accident · Serious injuriesClosedHoward 500 · Pawhuska, OKAug 13, 1977 · N44HH · Destroyed NTSB FTW77FPM17Accident · No injuriesClosedCessna 150 · Tulsa, OKAug 2, 1977 · N6341K · Substantial damage NTSB FTW77DPJ32Accident · No injuriesClosedCessna 150 · Olustee, OKJul 24, 1977 · N66636 · Substantial damage NTSB FTW77FPM16Accident · No injuriesClosedCessna 150 · Tulsa, OKJul 20, 1977 · N704NS · Substantial damage NTSB FTW77FPJ31Accident · No injuriesClosedCessna 337G · Oklahoma City, OKJul 17, 1977 · N72473 · Substantial damage NTSB FTW77DPJ30Accident · No injuriesClosedGrumman G-164B · Carnegie, OKJul 15, 1977 · N6616Q · Destroyed NTSB FTW77FPJ29Accident · Minor injuriesClosedVolksplane VP-1 · Oklahoma City, OKJul 9, 1977 · N64619 · Substantial damage NTSB FTW77FPJ28Accident · Minor injuriesClosedPiper J3C-65 · Yukon, OKJul 3, 1977 · N87791 · Substantial damage NTSB FTW77FPM15Accident · No injuriesClosedCessna 120 · Bristow, OKJul 2, 1977 · N3067N · Substantial damage NTSB FTW77FPJ27Accident · No injuriesClosedCessna 172L · Cherokee, OKJul 1, 1977 · N1091M · Substantial damage NTSB FTW77DPJ24Accident · No injuriesClosedCessna 182 · Felts, OKJul 1, 1977 · N21074 · Substantial damage NTSB FTW77DPJ25Accident · No injuriesClosedSchweizer SGS233 · Lawton, OKJun 25, 1977 · N7757S · Substantial damage NTSB FTW77FPM14Accident · No injuriesClosedBeech C23 · Afton, OKJun 17, 1977 · N9294S · Substantial damage NTSB FTW77DPJ23Accident · No injuriesClosedRockwell S2R · Tyrone, OKJun 17, 1977 · N5615X · Substantial damage NTSB FTW77FPM13Accident · No injuriesClosedBell 47G · Copan, OKJun 15, 1977 · N16657 · Substantial damage NTSB FTW77DDJ22Accident · No injuriesClosedCessna 177 · Cache, OKJun 12, 1977 · N30144 · Substantial damage NTSB FTW77FPM12Accident · Minor injuriesClosedCessna 177 · Sapulpa, OKJun 9, 1977 · N3466T · Substantial damage NTSB FTW77FPJ20Accident · Serious injuriesClosedCessna A188B · Cherokee, OKJun 3, 1977 · N8210G · Destroyed NTSB FTW77DPJ21Accident · Minor injuriesClosedCessna A188 · Lawton, OKJun 3, 1977 · N9367R · Substantial damage NTSB FTW77FPJ19Accident · Minor injuriesClosedPiper PA-25 · Perry, OKJun 2, 1977 · N6452Z · Substantial damage NTSB FTW77FPM11Accident · No injuriesClosedPiper PA-25 · Pryor, OKMay 28, 1977 · N4646Y · Substantial damage NTSB FTW77FPM10Accident · 1 fatalClosedPiper J-3 · Jay, OKMay 24, 1977 · N6355H · Destroyed NTSB FTW77DPJ18Accident · No injuriesClosedBlanik L-13 · Guymon, OKMay 8, 1977 · N101JJ · Substantial damage NTSB FTW77FPM09Accident · No injuriesClosedCessna 150M · Tulsa, OKMay 7, 1977 · N9103U · Substantial damage NTSB FTW77FA052Accident · Minor injuriesClosedBeech 95-55 · Durant, OKMay 6, 1977 · N414R · Substantial damage NTSB FTW77FPM08Accident · No injuriesClosedPiper PA-28 · Henryetta, OKMay 3, 1977 · N7789N · Substantial damage NTSB FTW77DPJ16Accident · Minor injuriesClosedCessna 150 · Stillwater, OKApr 19, 1977 · N6191G · Substantial damage NTSB FTW77FPJ14Accident · Serious injuriesClosedBoeing E75 · Erick, OKApr 8, 1977 · N5179N · Destroyed NTSB FTW77FPJ13Accident · No injuriesClosedDehavilland DH 104 · Yukon, OKMar 31, 1977 · N1541V · Substantial damage NTSB FTW77DPJ12Accident · Serious injuriesClosedPiper PA-25 · Gotebo, OKMar 29, 1977 · N8822L · Destroyed NTSB FTW77DPJ15Accident · No injuriesClosedPiper PA-25 · Arnett, OKMar 28, 1977 · N6425Z · Substantial damage NTSB FTW77FA047Accident · 3 fatalClosedPiper PA-23 · Mcalester, OKMar 26, 1977 · N3361P · Destroyed NTSB FTW77DPJ11Accident · No injuriesClosedGrumman G-164B · Carnegie, OKMar 23, 1977 · N6600Q · Substantial damage NTSB FTW77FPJ10Accident · Minor injuriesClosedCessna A188B · Altus, OKMar 20, 1977 · N6500G · Substantial damage NTSB FTW77FPJ09Accident · No injuriesClosedCessna 182Q · Mangum, OKMar 18, 1977 · N735AB · Substantial damage NTSB FTW77FPM07Accident · No injuriesClosedBeech B55 · Tulsa, OKMar 17, 1977 · N4374W · Substantial damage NTSB FTW77FA042Accident · 2 fatalClosedMooney MK-21 · El Reno, OKMar 14, 1977 · N6440Q · Destroyed NTSB FTW77FPJ08Accident · No injuriesClosedPiper PA-22 · Duncan, OKMar 12, 1977 · N5426Z · Substantial damage NTSB FTW77FPJ07Accident · No injuriesClosedCessna 180D · Thomas, OKMar 12, 1977 · N6452X · Substantial damage NTSB FTW77FPM06Accident · No injuriesClosedCessna 172K · Bartlesville, OKFeb 22, 1977 · N46305 · Substantial damage NTSB FTW77FPM05Accident · No injuriesClosedCessna 150 · Tulsa, OKFeb 15, 1977 · N10422 · Substantial damage NTSB FTW77DPJ06Accident · No injuriesClosedCessna 150 · Medford, OKFeb 5, 1977 · N7303G · Substantial damage NTSB FTW77DPM04Accident · Serious injuriesClosedMooney M20A · Tulsa, OKJan 9, 1977 · N5768Q · No damage NTSB FTW77DJP05Accident · Minor injuriesClosedBeech B95A · Ardmore, OKJan 3, 1977 · N1383Z · Destroyed NTSB FTW77FA022Accident · 1 fatalClosedAmerican AA1B · Oklahoma City, OKDec 14, 1976 · N6278L · Destroyed NTSB FTW77FPJ04Accident · Minor injuriesClosedGrum Amer AA1 · Oklahoma City, OKDec 4, 1976 · N5732L · Substantial damage NTSB FTW77DPJ03Accident · No injuriesClosedAero Comdr 690A · Oklahoma City, OKDec 2, 1976 · N81491 · Substantial damage NTSB FTW77FPJ02Accident · Serious injuriesClosedErco 415-C · Chattanooga, OKNov 28, 1976 · N93786 · Destroyed NTSB FTW77FPJ01Accident · No injuriesClosedCessna 172 · Oklahoma City, OKNov 25, 1976 · N5473R · Substantial damage