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 FTW66F0124Accident · No injuriesClosedMooney M20E · Ponca City, OKJul 3, 1965 · N6650R · Substantial damage NTSB FTW66F0162Accident · No injuriesClosedPiper PA-28 · Tulsa, OKJun 26, 1965 · N5786W · Substantial damage NTSB FTW66F0142Accident · No injuriesClosedAero Cmdr 680 · Piedmont, OKJun 24, 1965 · N6814S · Substantial damage NTSB FTW66F0103Accident · No injuriesClosedStinson L-5G · Norman, OKJun 19, 1965 · N63854 · Substantial damage NTSB FTW66F0047Accident · No injuriesClosedPiper PA-28 · Oklahoma City, OKJun 10, 1965 · N5066W · Substantial damage NTSB FTW66F0046Accident · No injuriesClosedPiper PA-22 · Okmulgee, OKJun 6, 1965 · N56892 · 2 aircraft · Substantial damage NTSB FTW66F0086Accident · No injuriesClosedMooney M18C · Piedmont, OKMay 30, 1965 · N492M · Substantial damage NTSB FTW66D0084Accident · No injuriesClosedFairchild M62-A · Arnett, OKMay 28, 1965 · N47563 · Destroyed NTSB FTW66D0229Accident · No injuriesClosedPiper PA-22 · Oklahoma Cty, OKMay 27, 1965 · N4842A · Substantial damage NTSB FTW65A0119Incident · No injuriesClosedDouglas DC-6A · Altus, OKMay 24, 1965 · N34956 · Substantial damage NTSB FTW66F0077Accident · No injuriesClosedPiper PA-24 · Tulsa, OKMay 22, 1965 · N8670P · Substantial damage NTSB FTW66F0075Accident · No injuriesClosedCessna 210D · Chickasha, OKMay 21, 1965 · N3836Y · Substantial damage NTSB FTW66F0039Accident · Serious injuriesClosedPiper PA-25 · Maysville, OKMay 13, 1965 · N6596Z · Destroyed NTSB FTW66F0034Accident · Minor injuriesClosedCessna 150 · Norman, OKMay 4, 1965 · N7989Z · Substantial damage NTSB FTW65D0033Accident · No injuriesClosedBeechcraft 35 · Beaver, OKApr 26, 1965 · N3920N · Substantial damage NTSB FTW65F0055Accident · No injuriesClosedPiper PA-24 · Oklahoma City, OKApr 23, 1965 · N6212P · Substantial damage NTSB FTW66F0021Accident · No injuriesClosedBeechcraft A-35 · Ardmore, OKApr 20, 1965 · N659B · Substantial damage NTSB FTW65F0026Accident · No injuriesClosedPiper PA-30 · Oklahoma City, OKApr 18, 1965 · N7670Y · Substantial damage NTSB FTW65F0023Accident · Minor injuriesClosedCessna 140 · Tulsa, OKApr 14, 1965 · N1794V · Substantial damage NTSB FTW66F0019Accident · No injuriesClosedCessna 182A · Oklahoma City, OKApr 8, 1965 · N3968B · Substantial damage NTSB FTW66F0016Accident · Serious injuriesClosedMooney M20C · Foraker, OKMar 28, 1965 · N6454U · Substantial damage NTSB FTW66D0012Accident · No injuriesClosedCessna 182 · Enid, OKMar 21, 1965 · N1948X · Substantial damage NTSB FTW66F0205Accident · No injuriesClosedErcoupe 415-C · Garber, OKMar 16, 1965 · N99252 · Substantial damage NTSB FTW65A0092Accident · Minor injuriesClosedBrantly B2 · Mustang, OKMar 15, 1965 · N5969X · Destroyed NTSB FTW66F0133Accident · No injuriesClosedCessna 150 · Sapula, OKMar 9, 1965 · N5598E · Substantial damage NTSB FTW66D0002Accident · No injuriesClosedCessna 150 · Ardmore, OKMar 3, 1965 · N2578J · Substantial damage NTSB FTW66F0132Accident · No injuriesClosedBeechcraft C-50 · Tulsa, OKMar 1, 1965 · N3714B · Substantial damage NTSB UNK65X1462Accident · Minor injuriesClosedPiper PA22 · Yukon, OKFeb 27, 1965 · N3366Z · Substantial damage NTSB UNK65X1454Accident · No injuriesClosedCessna 140A · Ardmore, OKFeb 25, 1965 · N5627C · Substantial damage NTSB UNK65X1432Accident · No injuriesClosedPiper PA22 · Ardmore, OKFeb 17, 1965 · N4579Z · Substantial damage NTSB UNK65X1429Accident · No injuriesClosedMooney M20E · Woodward, OKFeb 16, 1965 · N79822 · Substantial damage NTSB UNK65X1426Accident · No injuriesClosedBeechraft A-35 · Tulsa, OKFeb 15, 1965 · N531B · Substantial damage NTSB FTW65A0082Accident · No injuriesClosedLockheed L-188 · Okarche, OKFeb 15, 1965 · N111 · Substantial damage NTSB UNK65X1416Accident · No injuriesClosedCessna 310D · Oklahoma City, OKFeb 12, 1965 · N6955T · Substantial damage NTSB FTW65A0081Accident · No injuriesClosedGrumman G-73 · Oklahoma Cty, OKFeb 12, 1965 · N2940 · Substantial damage NTSB FTW65A0078Accident · No injuriesClosedDouglas B-26 · Oklahoma Cty, OKJan 28, 1965 · N202R · Substantial damage NTSB UNK65X1352Accident · No injuriesClosedPiper PA-28 · Russell, OKJan 26, 1965 · N5245W · Substantial damage NTSB FTW65A0077Accident · Serious injuriesClosedHughes 269A · Oklahoma Cty, OKJan 25, 1965 · N8883F · Destroyed NTSB FTW65A0069Accident · No injuriesClosedConvair CV-240 · Tulsa, OKJan 8, 1965 · N74850 · Substantial damage NTSB FTW65A0067Accident · 3 fatalClosedCessna 182B · Kla City, OKJan 5, 1965 · N2401G · Destroyed NTSB UNK65X1220Accident · No injuriesClosedPiper PA28 · Weatherford, OKJan 3, 1965 · N7615W · Substantial damage NTSB UNK65X1203Accident · 2 fatalClosedPiper PA24 · Cushing, OKDec 31, 1964 · N5399P · Destroyed NTSB UNK65X1195Accident · No injuriesClosedPiper PA24 · El Reno, OKDec 31, 1964 · N7124P · Substantial damage NTSB UNK65X1184Accident · No injuriesClosedTaylorcraft DCO · Vinita, OKDec 29, 1964 · N50605 · Substantial damage NTSB UNK65X1159Accident · No injuriesClosedCessna 150 · Cushing, OKDec 27, 1964 · N5779E · Substantial damage NTSB UNK65X1101Accident · No injuriesClosedBeech 35 · Broken Arrow, OKDec 23, 1964 · N2863V · Substantial damage NTSB UNK65X1073Accident · No injuriesClosedPiper PA28 · Elmore City, OKDec 20, 1964 · N5767W · Substantial damage NTSB UNK65X1039Accident · No injuriesClosedGlobe GC1B · Purcell, OKDec 18, 1964 · N3398K · Substantial damage NTSB UNK65X0992Accident · 2 fatalClosedRyan ST3KR · Altus, OKDec 12, 1964 · N88717 · Destroyed NTSB UNK65X0962Accident · Serious injuriesClosedCessna 210 · Sayre, OKDec 9, 1964 · N9554T · Substantial damage