Skip to content

NTSB investigations, UT

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 DEN77FTM28Accident · Serious injuriesClosedPiper PA-32R · Heber City, UTAug 22, 1977 · N4331F · Destroyed NTSB DEN77FA054Accident · 3 fatalClosedCessna 172 · Nsalina, UTAug 17, 1977 · N7985U · Destroyed NTSB DEN77DTM27Accident · Minor injuriesClosedCessna 150 · Tremonton, UTAug 9, 1977 · N4574U · Substantial damage NTSB DEN77DTC24Accident · Minor injuriesClosedLuscombe 8F · Dutch John, UTAug 6, 1977 · N1341B · Substantial damage NTSB DEN77FTM26Accident · No injuriesClosedPiper PA-32 · Hite, UTJul 30, 1977 · N3779W · Substantial damage NTSB DEN77DTM25Accident · Minor injuriesClosedCessna 172 · Richfield, UTJul 29, 1977 · N1373U · Substantial damage NTSB DEN77FTM24Accident · No injuriesClosedCessna 182P · Odgen, UTJul 17, 1977 · N6046J · Substantial damage NTSB DEN77FTM21Accident · Serious injuriesClosedPiper PA-28 · Beaver, UTJul 4, 1977 · N490FL · Destroyed NTSB DEN77DTM22Accident · Minor injuriesClosedPiper PA-24 · Hite, UTJul 4, 1977 · N9447P · Substantial damage NTSB DEN77FTM20Accident · No injuriesClosedPiper PA-28 · Benjamin, UTJun 22, 1977 · N9627K · Substantial damage NTSB DEN77FTM19Accident · Minor injuriesClosedCessna 188B · Vernal, UTJun 13, 1977 · N9300R · Substantial damage NTSB DEN77FTM17Accident · Serious injuriesClosedCessna 172M · Serviers, UTMay 28, 1977 · N4200Q · Destroyed NTSB DEN77FTM16Accident · No injuriesClosedCessna 150B · Parawon, UTMay 16, 1977 · N4414U · Substantial damage NTSB DEN77FTM15Accident · No injuriesClosedBeech 95B-55 · Salt Lake City, UTMay 6, 1977 · N214V · Substantial damage NTSB DEN77FTM14Accident · No injuriesClosedCessna 150G · E.Carbon City, UTApr 29, 1977 · N2936J · Substantial damage NTSB DEN77FA038Accident · 2 fatalClosedBellanca 7KCAB · Morgan, UTApr 29, 1977 · N76CC · Destroyed NTSB DEN77FTM13Accident · Minor injuriesClosedGrum Amer AA-1B · American Fork, UTApr 24, 1977 · N9565L · Destroyed NTSB DEN77FA036Accident · 2 fatalClosedCessna TU206F · Duchesne, UTApr 12, 1977 · N1066V · Destroyed NTSB DEN77FA035Accident · 2 fatalClosedCessna 182H · Tooele, UTApr 8, 1977 · N8390S · Destroyed NTSB DEN77FTM12Accident · Serious injuriesClosedNa Rockwell 114 · Vernal, UTMar 12, 1977 · N4735W · Destroyed NTSB DEN77FA027Accident · 3 fatalClosedCessna U206D · Hanna, UTFeb 26, 1977 · N72308 · Destroyed NTSB DEN77DTM11Accident · No injuriesClosedAero Comdr 112TC · Vernal, UTFeb 18, 1977 · N1866J · Substantial damage NTSB DEN77FTM10Accident · No injuriesClosedCessna 150L · Price, UTJan 31, 1977 · N6813G · Substantial damage NTSB DEN77DTM09Accident · No injuriesClosedAerospatle SA315B · Thistle, UTJan 31, 1977 · N67103 · Substantial damage NTSB DEN77FA022Accident · 2 fatalClosedCessna 172 · Moab, UTJan 24, 1977 · N4171F · Destroyed NTSB DEN77FTM08Accident · Minor injuriesClosedCessna 210 · Brigham City, UTNov 12, 1976 · N1840F · Substantial damage NTSB DEN77FA008Accident · 2 fatalClosedPiper PA-24 · Grantsville, UTNov 6, 1976 · N6180P · Destroyed NTSB DEN77FTM07Accident · 1 fatalClosedCessna P206B · Nephi, UTOct 19, 1976 · N4764F · Destroyed NTSB DEN77FTM06Accident · Minor injuriesClosedBell 47G · Beaver, UTOct 15, 1976 · N178B · Destroyed NTSB DEN76FTM05Accident · Minor injuriesClosedCessna T210L · Bullfrog Basin, UTOct 13, 1976 · N210V · Destroyed NTSB DEN77FTM04Accident · No injuriesClosedCessna 150J · Kamas, UTOct 9, 1976 · N60605 · Destroyed NTSB LAX77IA003Incident · Serious injuriesClosedBoeing 737 · Salt Lake City, UTOct 5, 1976 · N4523W · No damage NTSB DEN77DTM01Accident · No injuriesClosedCessna 172H · Parowan, UTOct 4, 1976 · N521SA · Substantial damage NTSB DEN77FTM03Accident · No injuriesClosedCessna 150 · Salt Lake City, UTSep 30, 1976 · N45230 · Substantial damage NTSB DEN76AD073Accident · 2 fatalClosedBell 47G3B2 · Mantua, UTSep 25, 1976 · N2205W · Destroyed NTSB DEN76FTM49Accident · No injuriesClosedNa Rockwell 112TC · Vernal, UTSep 22, 1976 · N4564W · Substantial damage NTSB DEN76DTM48Accident · No injuriesClosedBeech 95-E55 · Tremonton, UTSep 4, 1976 · N25612 · Substantial damage NTSB DEN76AD070Accident · 3 fatalClosedCessna 185 · Sunnyside, UTAug 25, 1976 · N9924X · Destroyed NTSB DEN76FTM47Accident · No injuriesClosedGrumman G-164A · Leland, UTAug 23, 1976 · N6589 · Substantial damage NTSB DEN76DTM46Accident · Minor injuriesClosedPiper PA-22 · Bullfrog Basin, UTAug 22, 1976 · N5927D · Substantial damage NTSB DEN76ATM45Accident · Serious injuriesClosedAmer Avco AA-1B · Escalante, UTAug 20, 1976 · N9947L · Destroyed NTSB DEN76AD066Accident · Minor injuriesClosedCessna TU206 · Ouray, UTAug 15, 1976 · N4831F · Substantial damage NTSB DEN76FTM43Accident · No injuriesClosedCessna 172M · Cedar City, UTAug 7, 1976 · N5285H · Substantial damage NTSB DEN76DTM44Accident · No injuriesClosedBensen B-8M · Lehi, UTAug 7, 1976 · N4194 · Substantial damage NTSB DEN76AD061Accident · 1 fatalClosedPiper PA-30 · Kings Peak, UTAug 1, 1976 · N7591Y · Destroyed NTSB DEN76FTM42Accident · No injuriesClosedCessna 182 · Salt Lake City, UTJul 31, 1976 · N5415B · Substantial damage NTSB DEN77FTM41Accident · Minor injuriesClosedCessna 206P · Lasal Junction, UTJul 27, 1976 · N2541X · Substantial damage NTSB DEN76FTM39Accident · Minor injuriesClosedBell 206B · Coalville, UTJul 14, 1976 · N49570 · Substantial damage NTSB DEN76DTM40Accident · No injuriesClosedCessna 150H · Howell, UTJul 13, 1976 · N22590 · Substantial damage NTSB DEN76AD055Accident · 1 fatalClosedSchweizer SGU222 · Heber City, UTJul 8, 1976 · N2769R · Destroyed