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 FTW80FPJ32Accident · No injuriesClosedCessna 150G · Norman, OKAug 21, 1980 · N3661J · Substantial damage NTSB FTW81DPJ31Accident · No injuriesClosedScorpion 133 · Oklahoma City, OKAug 17, 1980 · N5586N · Substantial damage NTSB FTW80FPJ33Accident · No injuriesClosedBeech 23 · Griggs, OKAug 16, 1980 · N6017L · Destroyed NTSB FTW80FA105Accident · 2 fatalClosedCessna 172M · Caddo, OKAug 16, 1980 · N12906 · Destroyed NTSB FTW80FPM16Accident · No injuriesClosedCessna 182 · Sand Springs, OKJul 31, 1980 · N2474X · Substantial damage NTSB FTW80FPM15Accident · Serious injuriesClosedAngel SPL · Wagoner, OKJul 27, 1980 · N6929C · Substantial damage NTSB FTW80DPJ29Accident · No injuriesClosedCessna 172M · Hobart, OKJul 18, 1980 · N80117 · Substantial damage NTSB FTW80FPM13Accident · No injuriesClosedBell 206B · Tulsa, OKJul 17, 1980 · N17HC · Substantial damage NTSB FTW80FPM14Accident · 1 fatalClosedBell 47G · Calvin, OKJul 16, 1980 · N16657 · Destroyed NTSB FTW80FPM12Accident · Minor injuriesClosedCessna 172L · Leach, OKJun 29, 1980 · N7822G · Substantial damage NTSB FTW80DPJ27Accident · Minor injuriesClosedCessna 152 · Gage, OKJun 27, 1980 · N48976 · Substantial damage NTSB FTW80FPJ26Accident · Minor injuriesClosedCessna 177 · Watonga, OKJun 25, 1980 · N2167C · Substantial damage NTSB FTW80FPJ24Accident · 1 fatalClosedBenson B8M · Frederick, OKJun 20, 1980 · N4355 · Destroyed NTSB FTW80FPJ23Accident · Serious injuriesClosedCessna 195 · Lexington, OKJun 20, 1980 · N1585D · Substantial damage NTSB FTW80FA085Accident · 3 fatalClosedCessna 172N · Boise City, OKJun 15, 1980 · N4929G · Destroyed NTSB FTW80FPM11Accident · No injuriesClosedPiper PA-28 · Okmulgee, OKJun 8, 1980 · N44752 · Substantial damage NTSB FTW80FA083Accident · 1 fatalClosedCessna 172L · Boise City, OKJun 8, 1980 · N6808Q · Destroyed NTSB FTW80DPJ25Accident · No injuriesClosedCallair A-9B · Ponca City, OKJun 4, 1980 · N7798V · Substantial damage NTSB FTW80FPJ21Accident · No injuriesClosedCessna 152 · Grandfield, OKJun 3, 1980 · N757YQ · Substantial damage NTSB FTW80DPJ22Accident · No injuriesClosedGrumman G-164 · Fairview, OKJun 3, 1980 · N10256 · Substantial damage NTSB FTW80DPJ20Accident · No injuriesClosedHiller Acft HU-12D · Norman, OKMay 13, 1980 · N102BC · Substantial damage NTSB FTW80FPJ18Accident · Minor injuriesClosedCessna 182 · El Reno, OKMay 8, 1980 · N2412G · Substantial damage NTSB FTW80FA070Accident · 1 fatalClosedCessna 150 · Tulsa, OKMay 7, 1980 · N2970V · 2 aircraft · Destroyed NTSB FTW80FPJ17Accident · No injuriesClosedBellanca 8GCBC · Enid, OKMay 6, 1980 · N86782 · Destroyed NTSB FTW80FPJ16Accident · No injuriesClosedBrantly B-2 · Frederick, OKMay 3, 1980 · N2112U · Destroyed NTSB FTW80FPJ14Accident · No injuriesClosedCessna 188 · Olustee, OKApr 29, 1980 · N5635G · Substantial damage NTSB FTW80DPJ15Accident · No injuriesClosedErco 415 · Guthrie, OKApr 19, 1980 · N6588Q · Substantial damage NTSB FTW80FA062Accident · 1 fatalClosedPiper PA-28 · Wagoner, OKApr 9, 1980 · N8747N · Destroyed NTSB FTW80FPM10Accident · No injuriesClosedJunkster 1 · Tulsa, OKApr 7, 1980 · N451M · Substantial damage NTSB FTW80FPM09Accident · No injuriesClosedBeech 95-C55 · Tulsa, OKApr 7, 1980 · N5925S · Substantial damage NTSB FTW80FPJ13Accident · No injuriesClosedCessna 310R · Norman, OKApr 7, 1980 · N87241 · Substantial damage NTSB FTW80FPM08Accident · No injuriesClosedPiper J-3 · Bristow, OKMar 22, 1980 · N98236 · Substantial damage NTSB FTW80FPJ12Accident · Minor injuriesClosedBoeing E75 · Chickasha, OKMar 21, 1980 · N5188N · Substantial damage NTSB FTW80FPJ11Accident · No injuriesClosedBell 206L · El Reno, OKMar 11, 1980 · N144MB · Substantial damage NTSB FTW80FPJ09Accident · Serious injuriesClosedPieten Pol AIR CP · Moore, OKMar 9, 1980 · N3869 · Destroyed NTSB FTW80FPJ10Accident · No injuriesClosedPiper PA-32 · Loyal, OKMar 7, 1980 · N3223W · Substantial damage NTSB FTW80DPJ08Accident · No injuriesClosedCessna 170 · Gage, OKMar 7, 1980 · N2635V · Destroyed NTSB FTW80FA046Accident · 5 fatalClosedPiper PA-32 · Ardmore, OKFeb 20, 1980 · N56482 · Destroyed NTSB FTW80FPM07Accident · Serious injuriesClosedBensen Gyro · Quapaw, OKFeb 14, 1980 · NONE · Destroyed NTSB FTW80DA041Accident · Serious injuriesClosedRepublic P47D · Tulsa, OKFeb 9, 1980 · N47DD · Destroyed NTSB FTW80AA037Accident · 2 fatalClosedAero Comdr 690A · New Castle, OKJan 30, 1980 · XB-AEA · Destroyed NTSB FTW80FA035Accident · 1 fatalClosedBeech 35-33 · Mcalester, OKJan 14, 1980 · N620V · Destroyed NTSB FTW80FA033Accident · 1 fatalClosedCessna 172 · Tulsa, OKJan 10, 1980 · N589RA · Destroyed NTSB FTW80FA032Accident · 4 fatalClosedBeech 95-B55 · Duncan, OKJan 10, 1980 · N4643A · Destroyed NTSB FTW80DPM06Accident · Minor injuriesClosedMaule M-5 · Vinitta, OKDec 26, 1979 · N51624 · Substantial damage NTSB FTW80FPJ05Accident · No injuriesClosedPiper PA-38 · Guymon, OKDec 8, 1979 · N4387E · Substantial damage NTSB FTW80FPJ06Accident · No injuriesClosedBeech J35 · Wellston, OKDec 7, 1979 · N3018C · Substantial damage NTSB FTW80FA020Accident · Serious injuriesClosedPiper PA-32 · Harrah, OKDec 5, 1979 · N4097R · Destroyed NTSB FTW80FPM05Accident · No injuriesClosedCessna 152 · Tulsa, OKDec 1, 1979 · N25475 · Substantial damage NTSB FTW80FPJ04Accident · No injuriesClosedCessna 172K · Norman, OKNov 24, 1979 · N84907 · Substantial damage