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 FTW70A0001Accident · 2 fatalClosedMooney M20F · El Reno, OKJul 3, 1969 · N9143V · Destroyed NTSB FTW70D0065Accident · No injuriesClosedCessna 182 · Antlers, OKJun 30, 1969 · N2571R · Substantial damage NTSB FTW70D0075Accident · No injuriesClosedPiper PA-28 · Waynoka, OKJun 29, 1969 · N7382J · Substantial damage NTSB FTW70D0088Accident · Minor injuriesClosedPiper PA-28 · Kingfisher, OKJun 28, 1969 · N6398W · Substantial damage NTSB FTW70D0061Accident · Minor injuriesClosedBeech D18S · Oklahoma Cty, OKJun 20, 1969 · N68B · Substantial damage NTSB FTW70D0058Accident · No injuriesClosedPiper PA-25 · Guymon, OKJun 19, 1969 · N4631Y · Substantial damage NTSB FTW70F0034Accident · Minor injuriesClosedStinson 108-3 · Kingston, OKJun 15, 1969 · N6163N · Substantial damage NTSB FTW70F0021Accident · Minor injuriesClosedCessna 210B · Ardmore, OKJun 8, 1969 · N9606X · Destroyed NTSB FTW69F0526Accident · No injuriesClosedBeech G18S · Okmulgee, OKJun 2, 1969 · N351WB · Substantial damage NTSB FTW70F0121Accident · Minor injuriesClosedCessna 170B · Big Cedar, OKJun 1, 1969 · N3546D · Substantial damage NTSB FTW69A0085Accident · 2 fatalClosedBeech S35 · Page, OKJun 1, 1969 · N8622Q · Destroyed NTSB FTW70D0007Accident · No injuriesClosedCessna 150 · Leon, OKMay 31, 1969 · N6184T · Substantial damage NTSB FTW70F0024Accident · No injuriesClosedAeronca 11AC · Tulsa, OKMay 30, 1969 · N9508E · Substantial damage NTSB FTW69D0545Accident · No injuriesClosedCessna 150 · Ardmore, OKMay 30, 1969 · N6264S · Substantial damage NTSB FTW69F0552Accident · No injuriesClosedBeech 36 · Tulsa, OKMay 29, 1969 · N7604N · Substantial damage NTSB FTW70F0029Accident · Serious injuriesClosedErco 415-C · Pawhuska, OKMay 27, 1969 · N2146H · Substantial damage NTSB FTW70F0020Accident · Serious injuriesClosedMonocoupe 110 · Collinsville, OKMay 24, 1969 · N12350 · Substantial damage NTSB FTW69F0524Accident · Serious injuriesClosedCessna 170B · Tulsa, OKMay 18, 1969 · N2914D · Substantial damage NTSB FTW69D0518Accident · No injuriesClosedCessna 150 · Jenks, OKMay 14, 1969 · N490RA · Substantial damage NTSB FTW69F0531Accident · Serious injuriesClosedPiper PA-22 · Daisy, OKMay 11, 1969 · N4559Z · Destroyed NTSB FTW69F0517Accident · No injuriesClosedPiper PA-28 · Haskell, OKMay 10, 1969 · N5762F · Substantial damage NTSB FTW69A0081Accident · No injuriesClosedBeech G18S · Tulsa, OKMay 5, 1969 · N697Q · Substantial damage NTSB FTW69A0080Accident · 3 fatalClosedAero Comdr 690 · Rosedale, OKMay 5, 1969 · N9001N · Destroyed NTSB FTW69D0503Accident · Serious injuriesClosedHiggins H-3 · Chattanooga, OKMay 4, 1969 · N61H · Destroyed NTSB FTW69D0496Accident · No injuriesClosedCessna 182 · Guymon, OKMay 2, 1969 · N3383F · Substantial damage NTSB FTW69D0499Accident · No injuriesClosedErco 415-C · S.Coffeyvlle, OKApr 27, 1969 · N87360 · Substantial damage NTSB FTW69D0488Accident · No injuriesClosedChampion 7EC · Guthrie, OKApr 22, 1969 · N9872B · Substantial damage NTSB FTW69D0485Accident · No injuriesClosedMooney M20F · Okla City, OKApr 21, 1969 · N9724M · Substantial damage NTSB FTW69F0493Accident · No injuriesClosedPiper PA-28 · Okla.City, OKApr 18, 1969 · N1895J · Substantial damage NTSB FTW69D0472Accident · Serious injuriesClosedPiper PA-28 · Oklahoma Cty, OKApr 16, 1969 · N5588F · Minor damage NTSB FTW69D0458Accident · Minor injuriesClosedPiper J-3 · Hooker, OKApr 13, 1969 · N21619 · Destroyed NTSB FTW69F0481Accident · Serious injuriesClosedPiper PA-25 · Bethany, OKApr 6, 1969 · N6901Z · Destroyed NTSB FTW69D0422Accident · No injuriesClosedCessna 140 · Weatherford, OKApr 3, 1969 · N77053 · Substantial damage NTSB FTW69F0479Accident · 1 fatalClosedChampion 7GCB · Mt.View, OKApr 2, 1969 · N9870Y · Destroyed NTSB FTW69D0418Accident · No injuriesClosedCessna 182L · Tulsa, OKApr 1, 1969 · N42010 · Substantial damage NTSB FTW69D0431Accident · No injuriesClosedCessna 150 · Jenks, OKMar 26, 1969 · N4336U · Substantial damage NTSB FTW69D0417Accident · No injuriesClosedMooney M20C · Mangum, OKMar 25, 1969 · N78998 · Substantial damage NTSB FTW69D0416Accident · No injuriesClosedCessna 170A · Ada, OKMar 18, 1969 · N1464D · Substantial damage NTSB FTW69F0424Accident · No injuriesClosedPiper PA-22 · Tulsa, OKMar 16, 1969 · N5218Z · Substantial damage NTSB FTW69F0419Accident · Minor injuriesClosedBeech 35 · Oklahoma Cty, OKMar 14, 1969 · N3284V · Substantial damage NTSB FTW69F0426Accident · No injuriesClosedBeech 23 · Claremore, OKMar 13, 1969 · N2309L · Substantial damage NTSB FTW69F0415Accident · No injuriesClosedPiper PA-28 · Yukon, OKMar 12, 1969 · N6878W · Substantial damage NTSB FTW69D0414Accident · No injuriesClosedPitts S-1 · Okmulgee, OKMar 4, 1969 · N11J · Substantial damage NTSB FTW69D0407Accident · No injuriesClosedPiper PA-28 · Lexington, OKMar 1, 1969 · N7254J · Substantial damage NTSB FTW69F0406Accident · Minor injuriesClosedPiper PA-28 · Enid, OKFeb 28, 1969 · N9849W · Substantial damage NTSB FTW69A0059Accident · 2 fatalClosedPiper PA-24 · Clayton, OKFeb 22, 1969 · N8745P · Destroyed NTSB FTW69A0057Accident · 2 fatalClosedPiper J-3 · Beggs, OKFeb 16, 1969 · N3507K · Destroyed NTSB FTW69D0385Accident · No injuriesClosedCessna 182D · Vici, OKFeb 6, 1969 · N9014X · Substantial damage NTSB MKC69F0362Accident · Minor injuriesClosedLuscombe 8E · Noble, OKJan 23, 1969 · N1565B · Substantial damage NTSB FTW69F0383Accident · Serious injuriesClosedErcoupe 415-C · Jenks, OKJan 23, 1969 · N2208H · Substantial damage