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 FTW67F0057Accident · No injuriesClosedPiper PA-28 · New Mannford, OKMay 30, 1966 · N5860W · Substantial damage NTSB FTW66D0682Accident · No injuriesClosedCessna 210 · Guthrie, OKMay 25, 1966 · N3761Y · Substantial damage NTSB FTW66F0675Accident · No injuriesClosedPiper PA-22 · Stilwell, OKMay 20, 1966 · N5837D · Substantial damage NTSB FTW66A0105Accident · No injuriesClosedBell Tomcat · Broken Bow, OKMay 16, 1966 · N9168R · Substantial damage NTSB FTW66F0666Accident · Serious injuriesClosedTaylorcraft DC-65 · Collinsville, OKMay 9, 1966 · N59565 · Substantial damage NTSB FTW66F0692Accident · Serious injuriesClosedGrumman G-164 · Broken Arrow, OKMay 8, 1966 · N695Y · Destroyed NTSB FTW66F0659Accident · Serious injuriesClosedTaylorcraft BL-65 · Sand Springs, OKMay 6, 1966 · N26613 · Destroyed NTSB FTW66F0652Accident · No injuriesClosedCessna 210 · Tulsa, OKMay 3, 1966 · N2377F · Substantial damage NTSB MKC66A0056Accident · 1 fatalClosedPiper PA-22 · Elk City, OKApr 29, 1966 · N2802P · Destroyed NTSB FTW66D0630Accident · No injuriesClosedCessna 180 · Hastings, OKApr 28, 1966 · N2755X · Substantial damage NTSB DCA66A0006Accident · 83 fatalClosedLockheed L-188C · Ardmore, OKApr 22, 1966 · N183H · Destroyed NTSB FTW66F0640Accident · No injuriesClosedPiper PA-18A · Yukon, OKApr 16, 1966 · N7199D · Substantial damage NTSB FTW66F0615Accident · No injuriesClosedPiper PA-28 · Stilwell, OKApr 14, 1966 · N8965W · Substantial damage NTSB FTW66D0616Accident · No injuriesClosedAlon A-2 · Tulsa, OKApr 14, 1966 · N6561Q · Substantial damage NTSB FTW66F0619Accident · No injuriesClosedPiper PA-25 · Cleo Springs, OKApr 11, 1966 · N6073Z · Substantial damage NTSB FTW66A0089Accident · 1 fatalClosedPiper PA-25 · Norman, OKApr 9, 1966 · N6158Z · Destroyed NTSB FTW66D0624Accident · No injuriesClosedCessna 170 · Bartlesville, OKApr 7, 1966 · N4411V · Substantial damage NTSB FTW66F0628Accident · No injuriesClosedStearman PT-17 · Billings, OKApr 5, 1966 · N66301 · Substantial damage NTSB FTW66A0087Accident · No injuriesClosedBell 47G-2 · Billings, OKApr 4, 1966 · N939B · Substantial damage NTSB FTW66D0609Accident · No injuriesClosedPiper PA-22 · Oklahoma City, OKApr 2, 1966 · N3366Z · Substantial damage NTSB FTW66F0586Accident · Minor injuriesClosedBoeing E-75 · Medford, OKMar 31, 1966 · N5269N · Substantial damage NTSB FTW66F0606Accident · Serious injuriesClosedPiper PA-25 · Guthrie, OKMar 30, 1966 · N6128Z · Substantial damage NTSB FTW66D0643Accident · No injuriesClosedAero Comdr 520 · Muskogee, OKMar 28, 1966 · N4196B · Substantial damage NTSB FTW66D0603Accident · No injuriesClosedCessna 150 · Tulsa, OKMar 28, 1966 · N8872G · Substantial damage NTSB FTW66A0084Accident · No injuriesClosedHughes 269A · Tulsa, OKMar 28, 1966 · N8733F · Substantial damage NTSB FTW66F0601Accident · No injuriesClosedPiper PA-18 · Waukomis, OKMar 26, 1966 · N7291D · Substantial damage NTSB FTW66F0600Accident · No injuriesClosedCallair A-5 · Kingfisher, OKMar 26, 1966 · N9965C · Substantial damage NTSB FTW66F0584Accident · No injuriesClosedPiper PA-25 · Okarche, OKMar 26, 1966 · N7687Z · Destroyed NTSB FTW66D0583Accident · Minor injuriesClosedCessna 172 · Randlett, OKMar 26, 1966 · N3773S · Substantial damage NTSB FTW66F0527Accident · No injuriesClosedCallair A-9 · Calumet, OKMar 12, 1966 · N8243H · Substantial damage NTSB FTW66D0525Accident · No injuriesClosedCessna 172 · Oklahoma City, OKMar 5, 1966 · N5747T · Substantial damage NTSB FTW66D0591Accident · No injuriesClosedPiper PA-18 · Morris, OKFeb 27, 1966 · N228T · Substantial damage NTSB FTW66D0535Accident · No injuriesClosedAeronca L-16A · Altus, OKFeb 26, 1966 · N10449 · Substantial damage NTSB FTW66F0520Accident · No injuriesClosedPiper PA-28 · Altus, OKFeb 6, 1966 · N6493W · Substantial damage NTSB FTW66F0507Accident · No injuriesClosedCessna 140A · Ardmore, OKFeb 3, 1966 · N1152D · Substantial damage NTSB FTW66A0065Accident · 2 fatalClosedBeech K35 · Mustang, OKJan 16, 1966 · N5330E · Destroyed NTSB FTW66D0464Accident · No injuriesClosedPiper PA-22 · Rosston, OKDec 29, 1965 · N2181A · Substantial damage NTSB FTW66F0483Accident · Minor injuriesClosedTaylorcraft BC12-D · Sand Springs, OKDec 26, 1965 · N95034 · Substantial damage NTSB FTW66F0482Accident · No injuriesClosedErcoupe 415-C · Fairview, OKDec 24, 1965 · N3750H · Substantial damage NTSB FTW66D0463Accident · No injuriesClosedBeechcraft B-55 · Oklahoma Cty, OKDec 24, 1965 · N145ZB · Substantial damage NTSB FTW66D0452Accident · No injuriesClosedCessna 172 · Altus, OKDec 24, 1965 · N5950R · Substantial damage NTSB FTW66F0481Accident · Minor injuriesClosedErcoupe 415-C · Lahoma, OKDec 22, 1965 · N93605 · Substantial damage NTSB FTW66F0450Accident · No injuriesClosedCessna 170 · Guthrie, OKDec 20, 1965 · N4192V · Substantial damage NTSB FTW66D0455Accident · No injuriesClosedBeechcraft M35 · Oklahomacity, OKDec 17, 1965 · N9927R · No damage NTSB FTW66D0449Accident · No injuriesClosedBeechcraft M-55 · Cushing, OKDec 17, 1965 · N109WB · Substantial damage NTSB FTW66F0458Accident · No injuriesClosedAero Cmdr 520 · Cleo Springs, OKDec 6, 1965 · N7834 · Substantial damage NTSB FTW66A0051Accident · Minor injuriesClosedHughes 269A · Enid, OKNov 26, 1965 · N8793F · Substantial damage NTSB FTW66F0434Accident · No injuriesClosedCessna 210 · El Reno, OKNov 24, 1965 · N9557T · Substantial damage NTSB FTW66D0440Accident · No injuriesClosedCessna 172 · Oklahoma City, OKNov 24, 1965 · N6812X · Substantial damage NTSB FTW66D0433Accident · No injuriesClosedPiper PA-28 · Stigler, OKNov 22, 1965 · N5654W · Substantial damage