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 FTW78FA047Accident · 2 fatalClosedAero Comdr 690A · Calumet, OKMay 27, 1978 · N299F · Destroyed NTSB FTW78DPJ25Accident · No injuriesClosedCessna 182 · Lawton, OKMay 27, 1978 · N2692G · Substantial damage NTSB FTW78FPM10Accident · Serious injuriesClosedGlobe Swift GC-1B · Tulsa, OKMay 26, 1978 · N5BT · Substantial damage NTSB FTW78DPJ23Accident · No injuriesClosedGreat Lakes 2T-1A · Enid, OKMay 24, 1978 · N6197L · Substantial damage NTSB FTW78FPJ22Accident · Minor injuriesClosedErco 415-C · El Reno, OKMay 23, 1978 · N93837 · Substantial damage NTSB FTW78FPJ20Accident · No injuriesClosedCessna 414A · Oklahoma City, OKMay 21, 1978 · N30AW · Substantial damage NTSB FTW78FPM09Accident · No injuriesClosedPiper PA-28 · Tulsa, OKMay 20, 1978 · N5454S · Substantial damage NTSB FTW78FPJ19Accident · No injuriesClosedCessna A188B · Kingfisher, OKMay 17, 1978 · N91138 · Substantial damage NTSB FTW78FPJ18Accident · Serious injuriesClosedPiper PA-25 · Comanche, OKMay 10, 1978 · N6141Z · Substantial damage NTSB FTW78FPJ21Accident · No injuriesClosedBeech 58P · Prague, OKMay 8, 1978 · N6031S · Substantial damage NTSB FTW78DPJ17Accident · Minor injuriesClosedCessna 188 · Braman, OKApr 23, 1978 · N9579G · Destroyed NTSB FTW78DPJ16Accident · No injuriesClosedCessna 150 · Marlow, OKApr 17, 1978 · N60683 · Substantial damage NTSB FTW78DPJ15Accident · Serious injuriesClosedPiper PA-25 · Tonkawa, OKApr 13, 1978 · N8634L · Substantial damage NTSB FTW78DPJ14Accident · No injuriesClosedCessna 172 · Tryon, OKApr 9, 1978 · N6461B · Destroyed NTSB FTW78FPM07Accident · Minor injuriesClosedCessna 172 · Muskogee, OKApr 8, 1978 · N6800A · Substantial damage NTSB FTW78FPM08Accident · No injuriesClosedPiper J3C-65 · Catoosa, OKApr 7, 1978 · N6538H · Substantial damage NTSB FTW78FPM06Accident · No injuriesClosedMooney M20E · Jay, OKApr 4, 1978 · N1282X · Substantial damage NTSB FTW78DPJ13Accident · No injuriesClosedBeech B24R · Hennessey, OKMar 29, 1978 · N2506W · Substantial damage NTSB FTW78DPJ12Accident · No injuriesClosedPiper PA-25 · Cashion, OKMar 26, 1978 · N6436Z · Substantial damage NTSB FTW78FPM05Accident · No injuriesClosedCessna 177 · Hominy, OKMar 11, 1978 · N29619 · Substantial damage NTSB FTW78FPM04Accident · No injuriesClosedCessna 177RG · Tulsa, OKFeb 13, 1978 · N19600 · Substantial damage NTSB FTW78FPM03Accident · No injuriesClosedCessna 175 · Pryor, OKJan 13, 1978 · N7141M · Substantial damage NTSB FTW78DPJ11Accident · No injuriesClosedCessna 182 · Hooker, OKJan 12, 1978 · N4973D · Substantial damage NTSB FTW78FPJ10Accident · No injuriesClosedPiper PA-32 · Oklahoma City, OKDec 22, 1977 · N3476W · Substantial damage NTSB FTW78DPM02Accident · No injuriesClosedCessna 150 · Claremore, OKDec 22, 1977 · N9141U · Substantial damage NTSB FTW78FPJ09Accident · No injuriesClosedPiper PA-24 · Oklahoma City, OKDec 14, 1977 · N8636P · Substantial damage NTSB FTW78FA014Accident · 1 fatalClosedPiper PA-28 · Langley, OKDec 4, 1977 · N41737 · Destroyed NTSB FTW78DPM01Accident · No injuriesClosedPiper PA-28 · Big Cedar, OKNov 30, 1977 · N8261N · Substantial damage NTSB FTW78FPJ08Accident · Minor injuriesClosedPiper PA-22 · Victory, OKNov 26, 1977 · N5921Z · Destroyed NTSB FTW78FPJ07Accident · No injuriesClosedBellanca 14-19 · Oklahoma City, OKNov 7, 1977 · N9817B · Substantial damage NTSB FTW78FA010Accident · Serious injuriesClosedPiper PA-34 · Tulsa, OKNov 6, 1977 · N33041 · Destroyed NTSB FTW78FPJ05Accident · 1 fatalClosedCessna A188B · Thomas, OKNov 3, 1977 · N4833R · Destroyed NTSB FTW78FPJ06Accident · Serious injuriesClosedCessna 172 · Nobel, OKOct 29, 1977 · N733DK · Destroyed NTSB FTW78FPJ04Accident · 1 fatalClosedPiper PA-36 · Garber, OKOct 25, 1977 · N57782 · Destroyed NTSB FTW78FA006Accident · 2 fatalClosedPiper PA-30 · Wetumka, OKOct 23, 1977 · N7623Y · Destroyed NTSB FTW78FPJ03Accident · No injuriesClosedCessna 177RG · Willow, OKOct 22, 1977 · N1594H · Substantial damage NTSB FTW78FA004Accident · 2 fatalClosedCessna 150L · Dewey, OKOct 16, 1977 · N1632Q · Destroyed NTSB FTW78FA001Accident · 5 fatalClosedPilatus PC6CH2 · Oklahoma City, OKOct 5, 1977 · N331V · Destroyed NTSB FTW78DPJ01Accident · No injuriesClosedCessna A188B · Albert, OKOct 5, 1977 · N6090G · Substantial damage NTSB FTW77FPJ37Accident · Minor injuriesClosedCessna 150 · Enid, OKSep 25, 1977 · N10854 · Destroyed NTSB FTW77FPJ35Accident · No injuriesClosedPiper PA-28 · Oklahoma City, OKSep 14, 1977 · N16547 · Substantial damage NTSB FTW77FA074Accident · 3 fatalClosedBeech V35A · Idabel, OKSep 12, 1977 · N800SC · Destroyed NTSB FTW77FPM21Accident · Minor injuriesClosedCessna 150 · Tulsa, OKSep 4, 1977 · N6686F · Substantial damage NTSB FTW77DPJ33Accident · Minor injuriesClosedCessna 177D · Waynoka, OKSep 3, 1977 · N34607 · Substantial damage NTSB FTW77DPJ34Accident · No injuriesClosedBell 206L · El Reno, OKSep 1, 1977 · N66LJ · Substantial damage NTSB FTW77FA073Accident · 3 fatalClosedPiper PA-28R · Hugo, OKAug 28, 1977 · N33862 · Destroyed NTSB FTW77FPM19Accident · No injuriesClosedAeronca 11AC · Tulsa, OKAug 23, 1977 · N9153E · Substantial damage NTSB FTW77FPM20Accident · Serious injuriesClosedJodette JD-9 · Wagoner, OKAug 21, 1977 · N2811J · Substantial damage NTSB FTW77FPM18Accident · No injuriesClosedHughes 269A · Council Hill, OKAug 21, 1977 · N8716F · Substantial damage NTSB FTW77FPJ38Accident · No injuriesClosedPiper PA-28 · Oklahoma City, OKAug 21, 1977 · N5790W · Substantial damage