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 FTW69F0142Accident · Minor injuriesClosedGlobe GC-1B · Okla.City, OKAug 10, 1968 · N2421B · Substantial damage NTSB FTW69D0139Accident · No injuriesClosedPiper PA-22 · Lamont, OKAug 6, 1968 · N1703P · Substantial damage NTSB FTW69D0133Accident · No injuriesClosedBeech A23-19 · Yukon, OKAug 6, 1968 · N3635Q · Substantial damage NTSB FTW69F0132Accident · No injuriesClosedCessna 150 · Erick, OKAug 5, 1968 · N7936E · Destroyed NTSB FTW69D0151Accident · No injuriesClosedCessna 182A · Lexington, OKAug 4, 1968 · N6123B · Substantial damage NTSB FTW69F0120Accident · No injuriesClosedCessna 170A · Piedmont, OKJul 31, 1968 · N9572A · Substantial damage NTSB FTW69D0082Accident · No injuriesClosedCessna 182 · Pond Creek, OKJul 28, 1968 · N3579U · Substantial damage NTSB FTW69F0069Accident · No injuriesClosedCessna 150 · Collinsville, OKJul 25, 1968 · N8326G · Substantial damage NTSB FTW69F0124Accident · No injuriesClosedCessna 150 · Beaver, OKJul 19, 1968 · N3698J · Substantial damage NTSB FTW69D0099Accident · No injuriesClosedTaylorcraft BC-65 · Broken Arrow, OKJul 19, 1968 · N22636 · Substantial damage NTSB FTW69D0062Accident · No injuriesClosedCessna 182 · Enid, OKJun 30, 1968 · N2244E · Substantial damage NTSB FTW69F0031Accident · 1 fatalClosedPiper PA-18A · Antlers, OKJun 16, 1968 · N9902D · Destroyed NTSB FTW68D0030Accident · No injuriesClosedBeech 23 · Claremore, OKJun 14, 1968 · N2309L · Substantial damage NTSB FTW69D0022Accident · No injuriesClosedCessna 182 · Ardmore, OKJun 2, 1968 · N3187R · Substantial damage NTSB FTW68A0101Accident · No injuriesClosedCessna 337B · Norman, OKMay 30, 1968 · N2308S · 2 aircraft · Substantial damage NTSB FTW68A0100Accident · 1 fatalClosedCessna 172 · Purcell, OKMay 30, 1968 · N9123B · No damage NTSB FTW69F0005Accident · No injuriesClosedHughes 269A · Jenks, OKMay 27, 1968 · N8843F · Destroyed NTSB FTW68D0613Accident · Minor injuriesClosedCallair A-4 · Mill Creek, OKMay 26, 1968 · N6042C · Destroyed NTSB FTW68A0095Accident · No injuriesClosedBell 47G3B1 · Yukon, OKMay 22, 1968 · N6228N · Substantial damage NTSB FTW69D0004Accident · No injuriesClosedPiper PA-24 · Antlers, OKMay 21, 1968 · N9009P · Substantial damage NTSB FTW68F0572Accident · No injuriesClosedPiper PA-28 · Guymon, OKMay 17, 1968 · N6355R · Substantial damage NTSB FTW69D0018Accident · No injuriesClosedCessna 310 · Daisy, OKMay 12, 1968 · N1715H · Substantial damage NTSB FTW68D0585Accident · No injuriesClosedPiper PA-25 · Terral, OKMay 5, 1968 · N6918Z · Substantial damage NTSB FTW68A0091Accident · 1 fatalClosedCessna 150H · Norman, OKMay 4, 1968 · N7099S · Destroyed NTSB FTW68F0577Accident · Minor injuriesClosedBeech A23 · Sasakwa, OKMay 1, 1968 · N4770J · Substantial damage NTSB FTW68D0565Accident · No injuriesClosedCessna 182K · Madill, OKApr 28, 1968 · N2552R · Substantial damage NTSB FTW68D0563Accident · No injuriesClosedCessna 182D · Balko, OKApr 26, 1968 · N9926T · Substantial damage NTSB FTW68F0562Accident · Serious injuriesClosedCessna 150E · Oweta, OKApr 25, 1968 · N6102T · Destroyed NTSB FTW68D0560Accident · No injuriesClosedCessna 150 · Wynona, OKApr 25, 1968 · N7178K · Substantial damage NTSB FTW68F0532Accident · No injuriesClosedAeronca 7EC · Okla.City, OKApr 18, 1968 · N4677E · Substantial damage NTSB FTW68D0531Accident · No injuriesClosedCessna 182 · Norman, OKApr 15, 1968 · N3143R · Substantial damage NTSB FTW68F0550Accident · No injuriesClosedCessna 150F · Mounds, OKApr 14, 1968 · N6830F · Substantial damage NTSB FTW68A0089Accident · No injuriesClosedBeech D18S · Altus, OKApr 14, 1968 · N212Z · Substantial damage NTSB FTW68F0548Accident · 1 fatalClosedPiper PA-18A · Watonga, OKApr 13, 1968 · N4578A · Destroyed NTSB FTW68F0504Accident · No injuriesClosedBeech A23 · Tulsa, OKApr 2, 1968 · N6931Q · Substantial damage NTSB FTW68D0541Accident · Minor injuriesClosedPiper PA-24 · Hardesty, OKMar 29, 1968 · N5631P · Substantial damage NTSB FTW68D0540Accident · No injuriesClosedPiper PA-11 · Altus, OKMar 28, 1968 · N78633 · Substantial damage NTSB FTW68D0502Accident · No injuriesClosedCessna 150 · Hardesty, OKMar 23, 1968 · N4357U · Substantial damage NTSB FTW68D0497Accident · No injuriesClosedStinson 108-3 · Beaver, OKMar 18, 1968 · N6175M · Substantial damage NTSB FTW68F0509Accident · Minor injuriesClosedCessna 172 · Oklahoma Cty, OKMar 14, 1968 · N1156F · Substantial damage NTSB FTW68D0486Accident · No injuriesClosedPiper PA-30 · Altus, OKMar 14, 1968 · N7278Y · Substantial damage NTSB FTW68F0476Accident · No injuriesClosedCessna 150 · Mounds, OKMar 13, 1968 · N2430J · Substantial damage NTSB FTW68F0483Accident · 1 fatalClosedCessna 172 · Broken Arrow, OKMar 1, 1968 · N8063L · Destroyed NTSB FTW68D0506Accident · No injuriesClosedCessna 172 · Fairview, OKMar 1, 1968 · N6250E · Substantial damage NTSB FTW68D0466Accident · No injuriesClosedPiper PA-28 · Okla.City, OKFeb 23, 1968 · N4234J · Substantial damage NTSB FTW68D0481Accident · No injuriesClosedBeech V-35 · Eufaula, OKFeb 18, 1968 · N7976M · Substantial damage NTSB FTW68F0449Accident · No injuriesClosedCessna 170B · Hominy, OKFeb 10, 1968 · N2759C · Substantial damage NTSB FTW68D0439Accident · No injuriesClosedMooney M20F · Webber Falls, OKFeb 4, 1968 · N3881N · Substantial damage NTSB FTW68A0078Accident · 4 fatalClosedMooney M20 · Page, OKJan 26, 1968 · N5225B · Destroyed NTSB FTW68D0430Accident · No injuriesClosedPiper J3C · Ardmore, OKJan 25, 1968 · N6741H · Substantial damage