Skip to content

NTSB investigations, UT

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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" = 'UT' 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\" = 'UT' 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" = 'UT' 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 DEN66F0232Accident · No injuriesClosedBeechcraft 33 · Woods Cross, UTMar 2, 1966 · N8502M · Substantial damage NTSB DEN66F0231Accident · No injuriesClosedCessna 172B · Gunlock, UTFeb 28, 1966 · N6849X · Substantial damage NTSB DEN66A0060Accident · 4 fatalClosedPiper PA-28 · Bicknell, UTFeb 25, 1966 · N9089W · Destroyed NTSB DEN66F0230Accident · No injuriesClosedPiper PA-22 · Hatch, UTFeb 16, 1966 · N2604A · Substantial damage NTSB DEN66D0221Accident · No injuriesClosedPiper PA-28 · Provo, UTFeb 16, 1966 · N6248W · Substantial damage NTSB DEN66D0239Accident · No injuriesClosedCessna 140 · Woods Cross, UTFeb 12, 1966 · N2805N · Substantial damage NTSB DEN66D0206Accident · No injuriesClosedPiper PA-28 · Logan, UTJan 19, 1966 · N5071W · Substantial damage NTSB DEN66F0207Accident · No injuriesClosedBeechcraft C50 · Salt Lake City, UTJan 18, 1966 · N3744B · Substantial damage NTSB DEN66D0194Accident · No injuriesClosedCessna 180 · Witerocks, UTJan 10, 1966 · N2661Y · Substantial damage NTSB DEN66F0195Accident · No injuriesClosedCessna 310A · Salt Lake City, UTDec 29, 1965 · N5261A · Substantial damage NTSB DEN66A0052Accident · 3 fatalClosedBeech C35 · Coalville, UTDec 29, 1965 · N5945C · Destroyed NTSB DEN66A0038Accident · 13 fatalClosedDouglas DC-3A · Salt Lake City, UTNov 27, 1965 · N485 · Destroyed NTSB DEN66A0040Accident · 1 fatalClosedBeech T-34A · Kamas, UTNov 22, 1965 · N7826B · Destroyed NTSB DEN66F0172Accident · No injuriesClosedStinson 108 · Sandy, UTNov 20, 1965 · N9168K · Substantial damage NTSB DEN66A0036Accident · 5 fatalClosedBeech B95A · Beaver, UTNov 14, 1965 · N461T · Destroyed NTSB DEN66A0033Accident · 1 fatalClosedPiper PA-28 · New Harmony, UTNov 14, 1965 · N7044W · Destroyed NTSB DEN66F0165Accident · No injuriesClosedBeechcraft E35 · Woods Cross, UTNov 13, 1965 · N7335B · Substantial damage NTSB DCA66A0004Accident · 43 fatalClosedBoeing B-727 · Salt Lke Cty, UTNov 11, 1965 · N7030U · Destroyed NTSB DEN66F0154Accident · No injuriesClosedPiper PA-23 · Duchesne, UTNov 7, 1965 · N1331P · Substantial damage NTSB DEN66D0147Accident · No injuriesClosedBeechcraft 95-55 · Logan, UTOct 24, 1965 · N569T · Substantial damage NTSB DEN66A0029Accident · 1 fatalClosedBeechcraft B35 · Blanding, UTOct 19, 1965 · N5238C · Destroyed NTSB DEN66D0122Accident · No injuriesClosedPiper J-3 · Woodruff, UTOct 9, 1965 · N42420 · Substantial damage NTSB DEN66A0025Accident · Minor injuriesClosedBell 47G3B1 · Salt Lake City, UTOct 5, 1965 · N8537F · Destroyed NTSB DEN66D0166Accident · No injuriesClosedCessna 210A · Mexican Hat, UTSep 29, 1965 · N6692K · Substantial damage NTSB DEN66A0023Accident · 1 fatalClosedBell 47G3B1 · Monticello, UTSep 28, 1965 · N1127W · Destroyed NTSB DEN66D0110Accident · No injuriesClosedCessna 320 · Logan, UTSep 22, 1965 · N5722X · Substantial damage NTSB DEN66D0109Accident · No injuriesClosedBeechcraft K-35 · Veyo, UTSep 16, 1965 · N524T · Substantial damage NTSB DEN66A0016Accident · Minor injuriesClosedBell 47G3B1 · Bountiful, UTAug 24, 1965 · N1169W · Substantial damage NTSB DEN66F0064Accident · No injuriesClosedPiper PA-28 · Snowville, UTAug 9, 1965 · N5459W · Substantial damage NTSB DEN66F0048Accident · No injuriesClosedCessna 175 · Salt Lake City, UTAug 5, 1965 · N6770E · Substantial damage NTSB DEN66F0059Accident · No injuriesClosedCessna 172 · Salt Lake City, UTAug 3, 1965 · N7079T · Substantial damage NTSB DEN66F0058Accident · No injuriesClosedPiper PA-28 · Salt Lake City, UTAug 3, 1965 · N6043W · Substantial damage NTSB DEN66F0032Accident · No injuriesClosedPiper PA-22 · Eden, UTJul 17, 1965 · N5497Z · Substantial damage NTSB DEN66D0042Accident · No injuriesClosedPiper PA-24 · Panguitch, UTJul 16, 1965 · N6421P · Substantial damage NTSB DEN66F0052Accident · No injuriesClosedBeechcraft G35 · Salt Lake City, UTJul 13, 1965 · N4603D · Substantial damage NTSB DEN66F0033Accident · No injuriesClosedCessna 175 · Goldhill, UTJul 9, 1965 · N8180T · Destroyed NTSB DEN66D0016Accident · No injuriesClosedMooney M20A · Vernal, UTJun 26, 1965 · N6581B · Substantial damage NTSB DEN66F0001Accident · No injuriesClosedLuscombe 8F · Green River, UTJun 14, 1965 · N3535G · Substantial damage NTSB DEN65A0079Accident · 3 fatalClosedBellanca 14-133 · Panguitch, UTJun 13, 1965 · N6525N · Destroyed NTSB DEN66F0015Accident · No injuriesClosedGrasshopper D-8 · Heber, UTJun 12, 1965 · N5053K · Destroyed NTSB DEN65A0080Accident · 3 fatalClosedPiper PA-28 · Salina, UTJun 11, 1965 · N5244W · Destroyed NTSB DEN65F0103Accident · Minor injuriesClosedPiper PA-22 · Logan, UTMay 27, 1965 · N3449A · Substantial damage NTSB DEN65D0106Accident · No injuriesClosedPiper PA-22 · Woodruff, UTMay 26, 1965 · N8741D · Substantial damage NTSB DEN65F0105Accident · No injuriesClosedBeechcraft B-35 · Salt Lake City, UTMay 22, 1965 · N5126C · Substantial damage NTSB DEN65D0104Accident · No injuriesClosedCessna 172 · Cedar City, UTMay 22, 1965 · N3778S · Substantial damage NTSB DEN65D0073Accident · No injuriesClosedCessna 140 · Aneth, UTMay 3, 1965 · N76906 · Substantial damage NTSB DEN65D0072Accident · No injuriesClosedCessna 170 · La Sal, UTMay 2, 1965 · N2936D · Substantial damage NTSB DEN65F0057Accident · Minor injuriesClosedPiper PA-22 · Beryl Junction, UTApr 24, 1965 · N994A · Destroyed NTSB DEN65F0047Accident · Minor injuriesClosedCessna 182 · St George, UTApr 16, 1965 · N5490B · Substantial damage NTSB DEN65D0052Accident · Serious injuriesClosedCessna 210 · Orem, UTApr 4, 1965 · N6649X · Destroyed