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 DEN76AD056Accident · 4 fatalClosedStinson 108-2 · Kamas, UTJun 29, 1976 · N8015K · Destroyed NTSB DEN76FTM38Accident · Minor injuriesClosedCessna 172 · Cedar City, UTJun 26, 1976 · N7264G · Substantial damage NTSB DEN76DTM37Accident · No injuriesClosedPiper PA-28 · Hatch, UTJun 23, 1976 · N5818U · Substantial damage NTSB DEN76DTM36Accident · No injuriesClosedCessna 172F · Provo, UTJun 5, 1976 · N8770U · Substantial damage NTSB DEN76FTM31Accident · Serious injuriesClosedGrumman G-164 · Morgan, UTJun 2, 1976 · N491Y · Destroyed NTSB DEN76FTM33Accident · No injuriesClosedPiper PA-34 · Bullfrog Basin, UTMay 31, 1976 · N33025 · Substantial damage NTSB DEN76DTM32Accident · No injuriesClosedCessna T210L · Navajo Mtn, UTMay 30, 1976 · N2239S · Substantial damage NTSB DEN76DTM34Accident · No injuriesClosedCessna 172M · Manila, UTMay 29, 1976 · N80976 · Substantial damage NTSB DEN76FTM30Accident · No injuriesClosedCessna 177 · Ogden, UTMay 24, 1976 · N30367 · Substantial damage NTSB DEN76DTM29Accident · No injuriesClosedCessna 195 · Hurricane, UTMay 20, 1976 · N1537H · Substantial damage NTSB DEN76DTM35Accident · No injuriesClosedCessna 188B · New Castle, UTMay 14, 1976 · N9278R · Substantial damage NTSB DEN76FTM27Accident · Serious injuriesClosedCessna 182P · Hanksville, UTApr 30, 1976 · N5603J · Substantial damage NTSB DEN76FTM26Accident · Minor injuriesClosedCessna 182E · Salt Lake City, UTApr 25, 1976 · N3195Y · Substantial damage NTSB DEN76FTM28Accident · No injuriesClosedPiper PA-18 · Tooele, UTApr 24, 1976 · N9692P · Substantial damage NTSB DEN76FTM12Accident · No injuriesClosedErco 415-C · Heber, UTApr 11, 1976 · N2335H · Substantial damage NTSB DEN76FTM25Accident · No injuriesClosedHiller Acft UH-12D · Bountiful, UTApr 10, 1976 · N67113 · Substantial damage NTSB DEN76DTM24Accident · No injuriesClosedCessna 180 · Moab, UTMar 28, 1976 · N3642C · Substantial damage NTSB DEN76FTM23Accident · Minor injuriesClosedCessna T210L · Roosevelt, UTMar 18, 1976 · N59100 · Substantial damage NTSB DEN76AD040Accident · Serious injuriesClosedHiller Acft UH-12E · Bluff, UTMar 14, 1976 · N67159 · Destroyed NTSB DEN76DTM22Accident · No injuriesClosedStinson 108-2 · Bryce Canyon, UTMar 13, 1976 · N9698K · Substantial damage NTSB DEN76FTM21Accident · No injuriesClosedPiper PA-32 · Logan, UTMar 9, 1976 · N4174R · Substantial damage NTSB DEN76FTM19Accident · No injuriesClosedCessna 180 · St.George, UTMar 5, 1976 · N9294C · Substantial damage NTSB DEN76FTM20Accident · No injuriesClosedCessna 172M · Bryce Canyon, UTMar 4, 1976 · N9415H · Substantial damage NTSB DEN76FTM18Accident · No injuriesClosedCessna 210A · Salt Lake City, UTFeb 23, 1976 · N349CP · Substantial damage NTSB DEN76AD033Accident · 4 fatalClosedGrum Amer AA-5 · Hyrum, UTFeb 13, 1976 · N1357R · Destroyed NTSB DEN76FTM17Accident · Serious injuriesClosedCessna T337C · Salt Lake City, UTFeb 1, 1976 · N2496S · Destroyed NTSB DEN76DTM16Accident · No injuriesClosedCessna 172A · Logan, UTJan 30, 1976 · N6844X · Substantial damage NTSB DEN76DTM15Accident · No injuriesClosedCessna 172 · Ephraim, UTJan 30, 1976 · N1741F · Substantial damage NTSB DEN76AD029Accident · No injuriesClosedCessna 402B · Logan, UTJan 29, 1976 · N8049Q · Substantial damage NTSB DEN76FTM14Accident · Minor injuriesClosedCessna 172M · Monument Vly, UTJan 13, 1976 · N9937Q · Substantial damage NTSB DEN76DTM13Accident · No injuriesClosedCessna 140 · Price, UTJan 7, 1976 · N73083 · Substantial damage NTSB DEN76AD027Accident · 3 fatalClosedPiper PA-28 · Ibapah, UTJan 3, 1976 · N44600 · Destroyed NTSB DEN76AD024Accident · 4 fatalClosedCessna 172M · Beaver, UTDec 6, 1975 · N13730 · Destroyed NTSB DEN76AD023Accident · No injuriesClosedConvair 580 · Hill Afb, UTNov 10, 1975 · N90 · Substantial damage NTSB DEN76AD022Accident · 1 fatalClosedCessna 172M · Beaver, UTOct 25, 1975 · N61895 · Destroyed NTSB DEN76FTM11Accident · Serious injuriesClosedPiper PA-24 · Salt Lake City, UTOct 24, 1975 · N8922P · Substantial damage NTSB LAX76AL025Accident · No injuriesClosedCessna 182 · Richfield, UTOct 17, 1975 · N14MD · 2 aircraft · Minor damage NTSB DEN76DTM09Accident · Minor injuriesClosedLuscombe 8E · Hanksville, UTOct 4, 1975 · N1797K · Substantial damage NTSB DEN76FTM10Accident · Serious injuriesClosedCessna 172F · Tremonton, UTSep 27, 1975 · N8465U · Substantial damage NTSB DEN76FTM08Accident · No injuriesClosedCessna 150L · Woods Cross, UTSep 25, 1975 · N18158 · Substantial damage NTSB DEN76FTM07Accident · Minor injuriesClosedBerkshire 70 · Heber City, UTSep 20, 1975 · N4KX · Destroyed NTSB DEN76AD015Accident · 6 fatalClosedBeech A35 · Hurricane, UTSep 7, 1975 · N7FS · Destroyed NTSB DEN76FTM06Accident · No injuriesClosedCessna 172 · Beaver, UTAug 26, 1975 · N7954B · Substantial damage NTSB DEN76AD011Accident · 4 fatalClosedPiper PA-28 · Mountain Home, UTAug 22, 1975 · N8254W · Destroyed NTSB DEN76FTM04Accident · No injuriesClosedCessna 150 · Cedar City, UTAug 19, 1975 · N66670 · Destroyed NTSB DEN76FTM05Accident · No injuriesClosedDehavilland DHC-2 · Ogden, UTAug 15, 1975 · N5317G · Substantial damage NTSB DEN7LAD009Accident · 2 fatalClosedCessna 170B · Spanish Fork, UTAug 13, 1975 · N8030A · Destroyed NTSB DEN7LAD010Accident · 1 fatalClosedBeech J35 · Hanksville, UTAug 12, 1975 · N7204B · Substantial damage NTSB DEN7LFTM01Accident · Minor injuriesClosedCessna 182 · Dutch John, UTAug 9, 1975 · N2576R · Substantial damage NTSB DEN7LAD007Accident · 2 fatalClosedPiper PA-22 · Fremont, UTAug 1, 1975 · N3567Z · Destroyed