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 DEN71DTM27Accident · No injuriesClosedCessna 150 · Logan, UTMay 24, 1971 · N50511 · Substantial damage NTSB DEN71FTM26Accident · Serious injuriesClosedBeech 35 · Provo, UTMay 13, 1971 · N476B · Substantial damage NTSB DEN71FTM25Accident · Serious injuriesClosedGlobe GC-1B · Spanish Fork, UTMay 13, 1971 · N80695 · Destroyed NTSB DEN71DTM28Accident · No injuriesClosedFournier RF4D · Park City, UTMay 9, 1971 · N2188 · Substantial damage NTSB DEN71FXT23Accident · No injuriesClosedPiper PA-32 · Provo, UTMay 1, 1971 · N4250R · Substantial damage NTSB DEN71DXT24Accident · No injuriesClosedCessna 150 · Kearns, UTMay 1, 1971 · N7966E · Substantial damage NTSB DEN71DXT22Accident · Minor injuriesClosedCessna 172 · Beaver, UTApr 23, 1971 · N5877R · Substantial damage NTSB DEN71AD038Accident · Serious injuriesClosedCessna 185 · Roosevelt, UTMar 26, 1971 · N9832X · Substantial damage NTSB DEN71DXT21Accident · No injuriesClosedPiper PA-23 · Garden City, UTFeb 25, 1971 · N5477Y · Substantial damage NTSB DEN71DXT20Accident · No injuriesClosedCessna 320 · Tooele, UTFeb 2, 1971 · N3037T · Substantial damage NTSB DEN71FXT19Accident · No injuriesClosedPiper PA-24 · Monument Vly, UTJan 28, 1971 · N9010P · Substantial damage NTSB DEN71FXT18Accident · No injuriesClosedBell 206A · Salt Lake City, UTJan 13, 1971 · N4047G · Substantial damage NTSB DEN71AD030Accident · 1 fatalClosedBeech B23 · Mammoth, UTJan 2, 1971 · N4027T · Destroyed NTSB DEN71FXT17Accident · Serious injuriesClosedCessna 150 · Brigham City, UTDec 24, 1970 · N1159Y · Substantial damage NTSB DEN71DXT15Accident · Minor injuriesClosedBeech 35 · Monticello, UTNov 26, 1970 · N6012E · Substantial damage NTSB DEN71AD022Accident · 2 fatalClosedPiper PA-28 · Ogden, UTNov 12, 1970 · N95396 · Destroyed NTSB DEN71DXT14Accident · No injuriesClosedCessna 150H · Junction, UTNov 6, 1970 · N50359 · Substantial damage NTSB DEN71DXT13Accident · No injuriesClosedBeech 95-C55 · Milford, UTOct 28, 1970 · N7888L · Substantial damage NTSB DEN71DVW15Accident · No injuriesClosedHiller Acft FH1100 · Cedar City, UTOct 28, 1970 · N441FH · Substantial damage NTSB DEN71AD018Accident · 1 fatalClosedCessna 210H · Orderville, UTOct 24, 1970 · N6940R · Destroyed NTSB DEN71FXT12Accident · No injuriesClosedPiper PA-30 · Salt Lake City, UTOct 13, 1970 · N8792Y · Substantial damage NTSB DEN71DXT11Accident · No injuriesClosedPiper PA-20 · Ogden, UTOct 3, 1970 · N2186A · Substantial damage NTSB DEN71AD011Accident · 2 fatalClosedPiper PA-28 · Oakley, UTSep 14, 1970 · N6490J · Destroyed NTSB DEN71DXT09Accident · No injuriesClosedK.Twister IMP · Coalville, UTSep 13, 1970 · N5DF · Substantial damage NTSB DEN71DXT16Accident · No injuriesClosedCessna 180 · Aneth, UTSep 6, 1970 · N4650B · Substantial damage NTSB DEN71DXT08Accident · No injuriesClosedPiper PA-28 · Mexican Hat, UTSep 6, 1970 · N6859W · Substantial damage NTSB DEN71AD010Accident · 1 fatalClosedCessna 182N · Escalante, UTSep 4, 1970 · N92928 · Destroyed NTSB DEN71FXT07Accident · No injuriesClosedPiper PA-25 · Ogden, UTSep 3, 1970 · N6722Z · Substantial damage NTSB DEN71DXT06Accident · No injuriesClosedPiper PA-22 · Salt Lake Cty, UTAug 30, 1970 · N4547Z · Substantial damage NTSB DEN71AD009Accident · 4 fatalClosedPiper PA-22 · Salt Lake City, UTAug 29, 1970 · N8936C · Destroyed NTSB DEN71AD007Accident · Minor injuriesClosedLockheed 188 · Hill Af Base, UTAug 24, 1970 · N855U · Destroyed NTSB DEN71FXT05Accident · Serious injuriesClosedCessna TU206A · Corinne, UTJul 30, 1970 · N230B · Substantial damage NTSB DEN71FXT03Accident · Serious injuriesClosedBeech 35-33 · Salt Lake City, UTJul 25, 1970 · N862R · Substantial damage NTSB DEN71FX202Accident · 1 fatalClosedPiper PA-18A · Monticello, UTJul 25, 1970 · N2976P · Destroyed NTSB DEN71DXT04Accident · No injuriesClosedTaylorcraft BC12-D · Tooele, UTJul 11, 1970 · N39243 · Substantial damage NTSB DEN71DXT01Accident · No injuriesClosedPiper PA-18 · Fielding, UTJul 4, 1970 · N1249A · Substantial damage NTSB DEN71DVW01Accident · No injuriesClosedBeech 95-55 · Hanksville, UTJul 3, 1970 · N1302Z · Substantial damage NTSB DEN70DVW20Accident · No injuriesClosedCessna 172 · Cedar City, UTJun 18, 1970 · N3927F · Substantial damage NTSB DEN70DVW19Accident · No injuriesClosedBriegleb BG12B · Kanarraville, UTJun 13, 1970 · N4931 · Substantial damage NTSB DEN70FVW14Accident · No injuriesClosedPiper PA-28 · Pine Valley, UTMay 10, 1970 · N6762J · Destroyed NTSB DEN70ID054Incident · Minor injuriesClosedBoeing 727 · Salt Lake City, UTMay 7, 1970 · N2804W · Minor damage NTSB DEN70DXT09Accident · No injuriesClosedPiper PA-12 · Salt Lake City, UTMay 6, 1970 · N3505M · Substantial damage NTSB DEN70FXT08Accident · No injuriesClosedPiper PA-32 · Woods Cross, UTApr 30, 1970 · N4088R · Substantial damage NTSB DEN70FVW09Accident · No injuriesClosedCessna 310P · Springdale, UTMar 27, 1970 · N5939M · Substantial damage NTSB DEN70FXT07Accident · Serious injuriesClosedBrantly B-2 · Murray, UTMar 26, 1970 · N5917X · Substantial damage NTSB DEN70AD050Accident · 1 fatalClosedPiper PA-28 · Beaver, UTMar 21, 1970 · N3919T · No damage NTSB DEN70FXT06Accident · No injuriesClosedCessna 150 · Ogden, UTMar 14, 1970 · N7877E · Substantial damage NTSB DEN70AD048Accident · 1 fatalClosedPiper PA-23 · Sunnyside, UTMar 2, 1970 · N5927Y · Destroyed NTSB DEN70FXT05Accident · No injuriesClosedCessna 320 · Ephraim, UTFeb 10, 1970 · N5719X · Substantial damage NTSB DEN70DXT03Accident · No injuriesClosedCessna 180 · Heber, UTFeb 7, 1970 · N1510C · Substantial damage