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 UNK64X2249Accident · No injuriesClosedBeechcraft 35 · Piedmont, OKJun 12, 1964 · N3388V · Substantial damage NTSB UNK64X2234Accident · No injuriesClosedLuscombe 8A · Mcalester, OKJun 11, 1964 · N23047 · Substantial damage NTSB UNK64X2176Accident · Serious injuriesClosedPiper PA18 · Enid, OKJun 7, 1964 · N2528B · Substantial damage NTSB UNK64X2136Accident · Serious injuriesClosedBrantly B2 · Okla City, OKJun 5, 1964 · N5907X · Substantial damage NTSB UNK64X2130Accident · No injuriesClosedCessna 175 · Okla City, OKJun 5, 1964 · N8369T · Substantial damage NTSB UNK64X2057Accident · No injuriesClosedWaco Ykcs · Okla City, OKMay 31, 1964 · N15232 · Substantial damage NTSB UNK64X2045Accident · Serious injuriesClosedPiper J3 · Bixby, OKMay 31, 1964 · N41308 · Substantial damage NTSB UNK64X1990Accident · Minor injuriesClosedGlobe Swift GC1B · Mcalester, OKMay 28, 1964 · N80667 · Substantial damage NTSB UNK64X1978Accident · No injuriesClosedSnow S2C · Bartlesville, OKMay 27, 1964 · N9472R · Substantial damage NTSB UNK64X1856Accident · Serious injuriesClosedPiper PA18 · Sulphur, OKMay 19, 1964 · N9148D · Destroyed NTSB UNK64X1842Accident · No injuriesClosedPiper PA24 · Okla City, OKMay 19, 1964 · N8339P · Substantial damage NTSB UNK64X1834Accident · Minor injuriesClosedBrantly B2B · Tulsa, OKMay 18, 1964 · N2170U · Destroyed NTSB UNK64X1719Accident · No injuriesClosedPiper PA22 · Collinsville, OKMay 11, 1964 · N1447C · Substantial damage NTSB UNK64X1682Accident · No injuriesClosedCessna 150 · Chattanooga, OKMay 9, 1964 · N5965E · Substantial damage NTSB UNK64X1655Accident · No injuriesClosedBeech A35 · Bristow, OKMay 7, 1964 · N576B · Substantial damage NTSB UNK64X1603Accident · No injuriesClosedCessna 140A · Frederick, OKMay 3, 1964 · N72385 · Substantial damage NTSB UNK64X1571Accident · No injuriesClosedCessna 120 · Okla City, OKMay 2, 1964 · N2391N · Substantial damage NTSB UNK64X1533Accident · No injuriesClosedPiper PA22 · Enid, OKApr 30, 1964 · N1439A · 2 aircraft · Minor damage NTSB UNK64X1425Accident · No injuriesClosedPiper PA23 · Guthrie, OKApr 23, 1964 · N4430P · Substantial damage NTSB UNK64X1404Accident · No injuriesClosedCallair A5 · Lucein, OKApr 21, 1964 · N9966C · Substantial damage NTSB UNK64X1400Accident · No injuriesClosedRyan PT22 · Tulsa, OKApr 21, 1964 · N59450 · Substantial damage NTSB UNK64X1364Accident · 1 fatalClosedPiper PA18 · Billings, OKApr 18, 1964 · N7246X · Destroyed NTSB UNK64X1243Accident · No injuriesClosedPiper PA24 · Norman, OKApr 10, 1964 · N5528P · Substantial damage NTSB UNK64X1238Accident · No injuriesClosedBeechcraft D18 · Piedmont, OKApr 9, 1964 · N181E · Substantial damage NTSB UNK64X1230Accident · Serious injuriesClosedPiper PA25 · El Reno, OKApr 8, 1964 · N6983Z · Minor damage NTSB UNK64X1229Accident · Serious injuriesClosedAeronca 7AC · Ames, OKApr 8, 1964 · N83867 · Substantial damage NTSB UNK64X1226Accident · No injuriesClosedPiper PA25 · Crescent, OKApr 8, 1964 · N6475Z · Destroyed NTSB UNK64X1175Accident · No injuriesClosedCessna 210 · Webber Falls, OKApr 5, 1964 · N7471E · Substantial damage NTSB UNK64X1143Accident · No injuriesClosedChampion 7FC · Muldrow, OKApr 3, 1964 · N84576 · Substantial damage NTSB UNK64X1090Accident · No injuriesClosedPiper PA20 · Mt View, OKMar 29, 1964 · N7446K · Substantial damage NTSB UNK64X1067Accident · Minor injuriesClosedPiper PA16 · Henryetta, OKMar 28, 1964 · N5956H · Substantial damage NTSB UNK64X1022Accident · No injuriesClosedPiper PA22 · Gage, OKMar 23, 1964 · N1456A · Substantial damage NTSB UNK64X0965Accident · No injuriesClosedBeechcraft E35 · Wagoner, OKMar 17, 1964 · N3310C · Substantial damage NTSB UNK64X0943Accident · Minor injuriesClosedPiper J3 · Tulsa, OKMar 15, 1964 · N38493 · Substantial damage NTSB UNK64X0912Accident · No injuriesClosedCessna 175 · Okla City, OKMar 14, 1964 · N9213B · Substantial damage NTSB UNK64X0870Accident · No injuriesClosedPiper PA24 · Frederick, OKMar 10, 1964 · N7482P · Substantial damage NTSB UNK64X0772Accident · No injuriesClosedCessna 170 · Okla City, OKMar 1, 1964 · N4419V · Substantial damage NTSB UNK64X0727Accident · No injuriesClosedBeechcraft 35B · Checotah, OKFeb 28, 1964 · N5103C · Substantial damage NTSB UNK64X0654Accident · No injuriesClosedBeechcraft 35 · Keyes, OKFeb 22, 1964 · N5846C · Substantial damage NTSB UNK64X0636Accident · No injuriesClosedPiper PA24 · Guymon, OKFeb 21, 1964 · N7335P · Substantial damage NTSB UNK64X0625Accident · No injuriesClosedBeechcraft 35 · Moore, OKFeb 20, 1964 · N4474V · Substantial damage NTSB UNK64X0607Accident · No injuriesClosedPiper PA24 · Ft Sill, OKFeb 19, 1964 · N7318P · Substantial damage NTSB UNK64X0486Accident · No injuriesClosedCessna 182 · Broken Arrow, OKFeb 7, 1964 · N5773B · Substantial damage NTSB UNK64X0344Accident · No injuriesClosedErcoupe 415 · Norman, OKJan 25, 1964 · N24054 · Substantial damage NTSB UNK64X0273Accident · No injuriesClosedCessna 182 · Ada, OKJan 18, 1964 · N6483A · Destroyed NTSB UNK64X0260Accident · No injuriesClosedCessna 182 · Pryor, OKJan 16, 1964 · N3652U · Substantial damage NTSB UNK64X0241Accident · 1 fatalClosedCessna 150 · Shawnee, OKJan 14, 1964 · N7844Z · Destroyed NTSB UNK64X0201Accident · No injuriesClosedBeechcraft C18S · Okla City, OKJan 9, 1964 · N11198 · Substantial damage NTSB UNK64X0149Accident · No injuriesClosedCessna 182 · Kingston, OKJan 4, 1964 · N2204G · Substantial damage