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 DEN79DTM02Accident · Minor injuriesClosedCessna 150 · Price, UTNov 19, 1978 · N18687 · Substantial damage NTSB DEN79FA004Accident · 1 fatalClosedCessna 172 · Provo, UTOct 20, 1978 · N1333Y · Destroyed NTSB DEN79FTM01Accident · No injuriesClosedCessna P210N · Ogden, UTOct 14, 1978 · N4781P · Substantial damage NTSB DEN78DTM23Accident · No injuriesClosedCessna 180 · Hite, UTSep 24, 1978 · N9177C · Substantial damage NTSB DEN79FTC02Accident · No injuriesClosedPiper PA-28 · Bountiful, UTSep 12, 1978 · N7989W · Substantial damage NTSB DEN78FTM32Accident · Minor injuriesClosedCessna 150 · Heber, UTAug 17, 1978 · N51338 · Substantial damage NTSB DEN78FA061Accident · Serious injuriesClosedCessna 206 · Salina, UTAug 14, 1978 · N8009Z · Substantial damage NTSB DEN78FA059Accident · 6 fatalClosedBeech 55 · Fairfield, UTAug 13, 1978 · N978V · Destroyed NTSB DEN78FTM31Accident · Minor injuriesClosedSchweizer SGS2 · Heber, UTJul 29, 1978 · N65812 · Substantial damage NTSB DEN78DTM29Accident · No injuriesClosedCessna 185 · Green River, UTJul 20, 1978 · N94201 · Substantial damage NTSB DEN78FTM28Accident · 1 fatalClosedClark Focke 190A3 · Cedar City, UTJul 8, 1978 · N23FW · Destroyed NTSB DEN78DTM27Accident · Serious injuriesClosedPiper PA-28 · Oljato, UTJul 1, 1978 · N75103 · Substantial damage NTSB DEN78FTM26Accident · No injuriesClosedPiper J-3 · Provo, UTJun 25, 1978 · N92002 · Substantial damage NTSB DEN78FTM24Accident · Serious injuriesClosedErco 415-C · Eureka, UTJun 8, 1978 · N94153 · Destroyed NTSB DEN78FTM23Accident · No injuriesClosedBeech B19 · Ogden, UTJun 2, 1978 · N2063L · Substantial damage NTSB DEN78FTM21Accident · 1 fatalClosedBede BD5 · Wendover, UTMay 29, 1978 · N549 · Destroyed NTSB DEN78FTM22Accident · No injuriesClosedBeech B23 · Nephi, UTMay 27, 1978 · N7635R · Substantial damage NTSB DEN78FA041Accident · No injuriesClosedBell 206B3 · Westwater, UTMay 9, 1978 · N16873 · Substantial damage NTSB DEN78FTM20Accident · No injuriesClosedChampion 7ECA · Logan, UTMay 7, 1978 · N2898G · Substantial damage NTSB DEN78DTM19Accident · Minor injuriesClosedMooney M20C · Kanab, UTMay 3, 1978 · N6489U · Substantial damage NTSB DEN78FTM18Accident · No injuriesClosedCessna 150 · Fairview, UTMay 1, 1978 · N18221 · Substantial damage NTSB DEN78FTM13Accident · No injuriesClosedBellanca 14-19 · Provo, UTApr 29, 1978 · N9814B · Substantial damage NTSB DEN78FA038Accident · No injuriesClosedBeech BE-65 · Salt Lake City, UTApr 20, 1978 · N20 · Substantial damage NTSB DEN78FTM17Accident · Minor injuriesClosedStinson 108-2 · Vernal, UTApr 8, 1978 · N328C · Substantial damage NTSB DEN78FA036Accident · 1 fatalClosedCessna TP206C · Angle, UTApr 8, 1978 · N8697Z · Destroyed NTSB DEN78FA035Accident · 1 fatalClosedPiper PA-38 · Park City, UTApr 7, 1978 · N9360T · Destroyed NTSB DEN78DTM16Accident · No injuriesClosedAerospatial SA315B · Nmanila, UTMar 22, 1978 · N220RM · Substantial damage NTSB DEN78FTM15Accident · No injuriesClosedGrumman G164A · Park City, UTMar 13, 1978 · N48599 · Substantial damage NTSB DEN78FTM14Accident · Serious injuriesClosedPiper PA-28 · Brigham City, UTFeb 22, 1978 · N32188 · Substantial damage NTSB DEN78FA025Accident · 2 fatalClosedBeech 35 · Ogden, UTFeb 20, 1978 · N338RW · Destroyed NTSB DEN78FTM12Accident · No injuriesClosedPiper PA-28 · Provo, UTFeb 12, 1978 · N47865 · 2 aircraft · Substantial damage NTSB DEN78FTM11Accident · 1 fatalClosedTurner T-40 · Ogden, UTJan 29, 1978 · N862HC · Destroyed NTSB DEN78FA021Accident · 4 fatalClosedCessna 177B · Salt Lake City, UTJan 22, 1978 · N18133 · Substantial damage NTSB DCA78AA005Accident · 3 fatalClosedDouglas DC-8F · Kaysville, UTDec 18, 1977 · N8047U · Destroyed NTSB DEN78DTM09Accident · No injuriesClosedPiper PA-18 · Blanding, UTDec 10, 1977 · N255T · Substantial damage NTSB DEN78DTM08Accident · No injuriesClosedCessna T210 · Provo, UTDec 3, 1977 · N9604R · Substantial damage NTSB DEN78DTM05Accident · No injuriesClosedCessna 150 · Fremont, UTOct 30, 1977 · N50512 · Destroyed NTSB DEN78FTM07Accident · No injuriesClosedBeech B33 · Salt Lake City, UTOct 27, 1977 · N6837Q · Substantial damage NTSB DEN78FTM04Accident · Minor injuriesClosedCessna 150E · Ogden, UTOct 26, 1977 · N3547J · Substantial damage NTSB DEN78FTM03Accident · No injuriesClosedBellanca 14-19 · Delta, UTOct 25, 1977 · N8811R · Substantial damage NTSB DEN78FTM06Accident · Minor injuriesClosedCessna 172F · Salina, UTOct 9, 1977 · N8208U · Substantial damage NTSB DEN78FA001Accident · 2 fatalClosedBellanca 8KCAB · Vernal, UTOct 2, 1977 · N53961 · Destroyed NTSB DEN77DTM32Accident · No injuriesClosedPiper PA-18 · Ogden, UTOct 2, 1977 · N3918Z · Substantial damage NTSB DEN78DTM02Accident · No injuriesClosedThorp T-18 · Moam, UTOct 1, 1977 · N12KB · Substantial damage NTSB DEN78FA002Accident · 7 fatalClosedPiper PA-32 · Cedar Fort, UTSep 30, 1977 · N5400F · Substantial damage NTSB DEN77FTM31Accident · No injuriesClosedCessna 182P · Monument Vally, UTSep 30, 1977 · N101JL · Substantial damage NTSB DEN77FTM32Accident · No injuriesClosedPiper PA-22 · Ogden, UTSep 28, 1977 · N6915B · Substantial damage NTSB DEN77FA059Accident · 1 fatalClosedCessna 150K · Cedar Fort, UTSep 25, 1977 · N5956G · Destroyed NTSB DEN77FTM29Accident · Serious injuriesClosedCallair A-6 · Cedar City, UTSep 12, 1977 · N2958G · Destroyed NTSB DEN77FTM30Accident · No injuriesClosedCessna 175 · Hite, UTSep 3, 1977 · N7338M · Substantial damage