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 FTW72FPJ12Accident · Serious injuriesClosedPitts Spcl S1C · Cushing, OKAug 30, 1971 · N11MA · Substantial damage NTSB FTW72FPM07Accident · No injuriesClosedLuscombe 8A · Wann, OKAug 29, 1971 · N45792 · Destroyed NTSB FTW72DPM06Accident · No injuriesClosedCessna 150 · Skiatook, OKAug 28, 1971 · N3474J · Substantial damage NTSB FTW72FPJ10Accident · Minor injuriesClosedCessna 172H · Bethany, OKAug 27, 1971 · N2790L · Substantial damage NTSB FTW72FPM05Accident · No injuriesClosedPiper PA-25 · Atwood, OKAug 25, 1971 · N6531Z · Substantial damage NTSB FTW72AF011Accident · 2 fatalClosedPiper PA-18 · Broken Bow, OKAug 21, 1971 · N9571D · Destroyed NTSB FTW72DPJ09Accident · No injuriesClosedCessna 177 · Norman, OKAug 15, 1971 · N3274T · Substantial damage NTSB FTW72FPM04Accident · No injuriesClosedBeech D18S · Jenks, OKAug 9, 1971 · N80385 · Substantial damage NTSB FTW72FPJ08Accident · No injuriesClosedCessna 182G · Watonga, OKAug 4, 1971 · N3737U · Substantial damage NTSB FTW72FPJ11Accident · Serious injuriesClosedPiper PA-25 · Hardesty, OKAug 3, 1971 · N6115Z · Destroyed NTSB FTW72DPJ07Accident · Minor injuriesClosedCessna 150H · Okene, OKJul 31, 1971 · N6762S · Substantial damage NTSB FTW72DPJ06Accident · No injuriesClosedPiper PA-18 · Fort Sill, OKJul 31, 1971 · N6482D · Substantial damage NTSB FTW72DPJ05Accident · No injuriesClosedPiper PA-25 · Texhoma, OKJul 31, 1971 · N8687L · Substantial damage NTSB FTW72DPJ04Accident · No injuriesClosedCessna 195B · Gould, OKJul 23, 1971 · N3029B · Substantial damage NTSB FTW72DPJ03Accident · Minor injuriesClosedCessna 172 · Watonga, OKJul 16, 1971 · N1577Y · Substantial damage NTSB FTW72AF003Accident · 2 fatalClosedCessna 172 · Sasakwa, OKJul 12, 1971 · N5978R · Destroyed NTSB FTW72FPM02Accident · No injuriesClosedBellanca 14-13 · Collinsville, OKJul 10, 1971 · N86754 · Substantial damage NTSB FTW72DPM03Accident · No injuriesClosedPiper PA-28 · New Mannford, OKJul 9, 1971 · N7634J · Substantial damage NTSB FTW72FPJ02Accident · No injuriesClosedCessna 172 · Fort Supply, OKJul 5, 1971 · N3761L · Substantial damage NTSB FTW72FPM01Accident · Serious injuriesClosedCessna 150 · Wagoner, OKJul 3, 1971 · N50778 · Substantial damage NTSB FTW72DPJ01Accident · Minor injuriesClosedCessna 150L · Yukon, OKJul 3, 1971 · N6938G · Substantial damage NTSB FTW71DPJ49Accident · No injuriesClosedPiper PA-28 · Oklahoma Cty, OKJun 24, 1971 · N7147W · Substantial damage NTSB FTW71DPM32Accident · No injuriesClosedGrumman G-164 · Dustin, OKJun 22, 1971 · N582Y · Substantial damage NTSB FTW71FPJ45Accident · No injuriesClosedBeech 35 · Lahoma, OKJun 20, 1971 · N3097V · Substantial damage NTSB FTW71DPJ47Accident · No injuriesClosedPiper PA-18 · Oklahoma Cty, OKJun 20, 1971 · N102T · Substantial damage NTSB FTW71FPJ44Accident · No injuriesClosedCessna 172G · Oklahoma Cty, OKJun 19, 1971 · N4160L · Substantial damage NTSB FTW71FPJ46Accident · 1 fatalClosedPiper PA-25 · Duncan, OKJun 18, 1971 · N6983Z · Destroyed NTSB FTW71IF082Incident · No injuriesClosedDouglas DC-3A · Okla.City, OKJun 11, 1971 · N692A · Minor damage NTSB FTW71FPM30Accident · No injuriesClosedPiper PA-20 · Wagoner, OKJun 6, 1971 · N6995K · Substantial damage NTSB FTW71FPJ48Accident · Serious injuriesClosedCougar 010A · Moore, OKJun 4, 1971 · N74068 · Substantial damage NTSB FTW71FPM29Accident · 1 fatalClosedFly Baby 1-14 · Durant, OKMay 31, 1971 · N7347 · Destroyed NTSB FTW71FPM31Accident · Serious injuriesClosedPiper PA-28 · Sobol, OKMay 24, 1971 · N8165N · Destroyed NTSB FTW71FPJ43Accident · No injuriesClosedPiper PA-30 · Oklahoma Cty, OKMay 24, 1971 · N8396Y · Substantial damage NTSB FTW71FPM28Accident · Minor injuriesClosedPiper PA-18A · Okemah, OKMay 16, 1971 · N6773B · Destroyed NTSB FTW71DPJ42Accident · No injuriesClosedPiper PA-17 · Hammon, OKMay 14, 1971 · N5001H · Substantial damage NTSB FTW71AF077Accident · 1 fatalClosedCessna 150 · Langley, OKMay 14, 1971 · N6323G · Destroyed NTSB FTW71FPJ41Accident · No injuriesClosedBeech G50 · Oklahoma Cty, OKMay 11, 1971 · N5697D · Destroyed NTSB FTW71DPM26Accident · No injuriesClosedLuscombe 8A · Tahlequah, OKMay 11, 1971 · N1208K · Substantial damage NTSB FTW71AF074Accident · No injuriesClosedFairchild F-27F · Mcalister, OKMay 9, 1971 · N966P · Substantial damage NTSB FTW71FPM25Accident · No injuriesClosedCessna 180 · Honobia, OKMay 4, 1971 · N1705C · Substantial damage NTSB FTW71FPM24Accident · No injuriesClosedAeronca 11AC · Vinita, OKMay 3, 1971 · N85928 · Substantial damage NTSB FTW71FPM27Accident · No injuriesClosedBeech 18E · Muskogee, OKApr 30, 1971 · N2279 · Substantial damage NTSB FTW71FPJ40Accident · 1 fatalClosedPiper J3C · Lindsay, OKApr 21, 1971 · N42682 · Destroyed NTSB FTW71DPJ38Accident · No injuriesClosedCessna 172K · Altus, OKApr 13, 1971 · N79222 · Substantial damage NTSB FTW71DPJ39Accident · No injuriesClosedStinson 108-3 · Shattuck, OKApr 9, 1971 · N6946M · Substantial damage NTSB FTW71AF069Accident · 2 fatalClosedPiper PA-23 · Norman, OKApr 7, 1971 · N2047P · Destroyed NTSB FTW71FPJ37Accident · No injuriesClosedVolksplane OL-1 · El Reno, OKApr 6, 1971 · N11BL · Substantial damage NTSB MIA71FPM23Accident · No injuriesClosedCessna 180 · Tulsa, OKApr 2, 1971 · N4758B · Substantial damage NTSB FTW71AF066Accident · 2 fatalClosedPiper PA-22 · Meers, OKApr 1, 1971 · N7442D · Destroyed NTSB FTW71FPJ36Accident · No injuriesClosedCallair A-4 · Terral, OKMar 28, 1971 · N7579C · Substantial damage