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 FTW67D0333Accident · No injuriesClosedCessna 172 · Enid, OKNov 20, 1966 · N4196L · No damage NTSB FTW67D0319Accident · No injuriesClosedCessna 172 · Norman, OKNov 20, 1966 · N5950R · Substantial damage NTSB FTW67D0318Accident · No injuriesClosedCessna 182C · Rose 3kla, OKNov 20, 1966 · N8552T · Substantial damage NTSB FTW67D0332Accident · No injuriesClosedCessna 182 · Felt, OKNov 19, 1966 · N2799G · Substantial damage NTSB FTW67A0053Accident · Minor injuriesClosedCessna 182H · Davis, OKNov 13, 1966 · N2024X · Substantial damage NTSB FTW67A0051Accident · No injuriesClosedBell 47G3B1 · Yukon, OKNov 10, 1966 · N1130W · Substantial damage NTSB FTW67D0287Accident · No injuriesClosedPiper PA-28 · Pond Creek, OKNov 9, 1966 · N4633R · Substantial damage NTSB FTW67F0328Accident · No injuriesClosedCessna 150E · Mannsville, OKNov 8, 1966 · N6251T · Substantial damage NTSB FTW67F0266Accident · No injuriesClosedMooney M20C · Oklahoma Cty, OKOct 28, 1966 · N6718U · Substantial damage NTSB FTW67F0264Accident · Minor injuriesClosedCessna 210E · Bunch, OKOct 19, 1966 · N7411C · Substantial damage NTSB FTW67D0274Accident · No injuriesClosedCessna 172 · Bartlesville, OKOct 14, 1966 · N4206L · Substantial damage NTSB FTW67F0247Accident · No injuriesClosedPiper PA-24 · Oklahoma City, OKOct 13, 1966 · N7483P · Substantial damage NTSB FTW67D0260Accident · No injuriesClosedCessna 182 · Pond Creek, OKOct 12, 1966 · N1948X · Substantial damage NTSB FTW67D0258Accident · No injuriesClosedCessna 182 · Blackwell, OKOct 9, 1966 · N2026X · Substantial damage NTSB FTW67F0225Accident · No injuriesClosedPiper PA-28 · Yukon, OKOct 5, 1966 · N9337J · Substantial damage NTSB FTW67D0224Accident · No injuriesClosedCessna 175 · Perry, OKOct 2, 1966 · N6593E · Destroyed NTSB FTW67F0222Accident · No injuriesClosedCessna 210 · Oklahoma Cty, OKSep 28, 1966 · N3705Y · Substantial damage NTSB FTW67D0217Accident · No injuriesClosedBeech 35 · Guymon, OKSep 21, 1966 · N8946M · Substantial damage NTSB FTW67A0042Accident · No injuriesClosedBell 47G2A1 · Vici, OKSep 12, 1966 · N73997 · Substantial damage NTSB FTW67D0200Accident · No injuriesClosedMooney M20C · Guthrie, OKSep 9, 1966 · N1316W · Substantial damage NTSB FTW67F0199Accident · Minor injuriesClosedCessna 172 · Yukon, OKSep 7, 1966 · N6686A · Substantial damage NTSB FTW67A0030Accident · No injuriesClosedBell 47G3B1 · Yukon, OKSep 6, 1966 · N8542F · Substantial damage NTSB FTW67A0027Accident · Minor injuriesClosedHughes 269A · Tulsa, OKSep 3, 1966 · N8733F · Destroyed NTSB FTW67D0210Accident · No injuriesClosedMooney M20E · Ada, OKSep 2, 1966 · N79838 · Substantial damage NTSB FTW67D0209Accident · No injuriesClosedBeech 23 · Lake Texoma, OKAug 31, 1966 · N2310L · Substantial damage NTSB FTW67A0025Accident · 1 fatalClosedPiper PA-18 · Kellyville, OKAug 21, 1966 · N5897D · Destroyed NTSB FTW67F0143Accident · No injuriesClosedNavion A · Oklahoma Cty, OKAug 13, 1966 · N91702 · Substantial damage NTSB FTW68F0033Accident · Serious injuriesClosedPiper PA-30 · Sand Springs, OKAug 11, 1966 · N7218Y · Destroyed NTSB FTW67D0175Accident · No injuriesClosedCessna 172 · Apache, OKAug 11, 1966 · N1613Y · Substantial damage NTSB FTW67D0174Accident · No injuriesClosedCessna 182 · Edmond, OKAug 11, 1966 · N3366Y · Substantial damage NTSB FTW67D0146Accident · No injuriesClosedBoeing E75N1 · Altus, OKAug 8, 1966 · N5268N · Substantial damage NTSB FTW67F0114Accident · Minor injuriesClosedTurner T-40A · Piedmont, OKAug 2, 1966 · N115ET · Substantial damage NTSB FTW67D0119Accident · No injuriesClosedCessna 150 · Erick, OKJul 30, 1966 · N8417G · Substantial damage NTSB FTW67A0020Accident · No injuriesClosedPiper PA-24 · El Reno, OKJul 29, 1966 · N8420P · Substantial damage NTSB FTW67F0113Accident · Serious injuriesClosedCessna 140A · Wilson, OKJul 24, 1966 · N1104D · Substantial damage NTSB FTW67F0109Accident · No injuriesClosedLuscombe 8A · Enid, OKJul 23, 1966 · N71533 · Substantial damage NTSB FTW67D0104Accident · No injuriesClosedPiper PA-24 · Tonkawa, OKJul 18, 1966 · N7900P · Substantial damage NTSB FTW67D0072Accident · No injuriesClosedCessna 150 · Ardmore, OKJul 14, 1966 · N8191S · Substantial damage NTSB FTW67A0011Accident · No injuriesClosedConvair 880M · Oklahoma Cty, OKJul 14, 1966 · N112 · Substantial damage NTSB FTW67D0066Accident · No injuriesClosedCessna 120 · Duncan, OKJul 7, 1966 · N2072V · Substantial damage NTSB FTW67D0055Accident · No injuriesClosedCessna 150 · Waurtka, OKJul 5, 1966 · N8399G · Substantial damage NTSB FTW67D0053Accident · No injuriesClosedBeech 23 · Port Cobb, OKJul 3, 1966 · N2374L · Substantial damage NTSB FTW67D0044Accident · No injuriesClosedCessna 150 · Cordell, OKJun 26, 1966 · N7825E · Substantial damage NTSB FTW67D0024Accident · No injuriesClosedStinson 108 · Tulsa, OKJun 21, 1966 · N97424 · Substantial damage NTSB FTW66A0116Accident · 1 fatalClosedCherokee II · Tulsa, OKJun 18, 1966 · N74007 · Destroyed NTSB FTW66I0115Incident · No injuriesClosedLear Jet · Enid, OKJun 15, 1966 · N802L · 2 aircraft · Substantial damage NTSB FTW67F0041Accident · No injuriesClosedCessna 182 · Oklahoma City, OKJun 14, 1966 · N2090X · Substantial damage NTSB FTW67D0023Accident · No injuriesClosedCessna 310K · Wagoner, OKJun 13, 1966 · N7003L · Substantial damage NTSB FTW67F0022Accident · No injuriesClosedCessna 172F · Bethany, OKJun 5, 1966 · N5327R · Substantial damage NTSB FTW67D0032Accident · No injuriesClosedErcoupe 415-C · Altus, OKJun 4, 1966 · N2131H · Substantial damage