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 DEN7LFTM02Accident · No injuriesClosedPiper PA-24 · Canyonlands, UTJul 27, 1975 · N8642P · Destroyed NTSB DEN76DTM03Accident · No injuriesClosedCessna 210 · St.George, UTJul 26, 1975 · N30796 · Substantial damage NTSB DEN76AD006Accident · 5 fatalClosedCessna P206A · Parowan, UTJul 24, 1975 · N4693F · Destroyed NTSB DEN7LAD005Accident · Minor injuriesClosedCessna 185 · Bullfrog Basin, UTJul 13, 1975 · N4188Y · Substantial damage NTSB DEN76AD001Accident · 4 fatalClosedGrum Amer AA5-B · Salt Lake City, UTJul 4, 1975 · N1525R · Destroyed NTSB DEN7KAD063Accident · 3 fatalClosedCessna 172M · Manila, UTJun 27, 1975 · N1431V · Destroyed NTSB DEN75FTM20Accident · Minor injuriesClosedPiper PA-25 · West Jordan, UTJun 27, 1975 · N6722Z · Substantial damage NTSB DEN7KAD061Accident · 2 fatalClosedCessna 182E · Cove Fort, UTJun 17, 1975 · N3361Y · Destroyed NTSB DEN75DTM19Accident · No injuriesClosedCessna 180B · Orangeville, UTJun 16, 1975 · N5063E · Substantial damage NTSB DEN75AD060Accident · 1 fatalClosedCessna 150 · Logan, UTJun 16, 1975 · N1333Q · Destroyed NTSB DEN75FTM16Accident · No injuriesClosedLuscombe 8A · Salt Lake City, UTJun 12, 1975 · N72078 · Substantial damage NTSB DEN75DTM15Accident · No injuriesClosedBeech B19 · Duchesne, UTMay 25, 1975 · N24627 · Substantial damage NTSB DEN75DTM14Accident · Minor injuriesClosedCessna 175 · Lynn, UTMay 10, 1975 · N7003M · Substantial damage NTSB DEN75FTM13Accident · Serious injuriesClosedCessna 150F · Vernal, UTMar 15, 1975 · N66184 · Destroyed NTSB DEN75AD047Accident · Serious injuriesClosedCessna U206 · Vernal, UTMar 10, 1975 · N2139F · Destroyed NTSB DEN75AD046Accident · 4 fatalClosedBellanca 17-30A · Delle, UTMar 8, 1975 · N39871 · Destroyed NTSB DEN75AD040Accident · 3 fatalClosedBeech 95-B55 · Riverton, UTFeb 1, 1975 · N157D · Destroyed NTSB DEN75DTM12Accident · No injuriesClosedPiper PA-12 · Green River, UTJan 19, 1975 · N3010M · Substantial damage NTSB DEN75DTM10Accident · No injuriesClosedPiper PA-28 · Provo, UTJan 13, 1975 · N4971T · Substantial damage NTSB DEN75FTM09Accident · Serious injuriesClosedPiper PA-28 · Bountiful, UTJan 4, 1975 · N7322J · Destroyed NTSB DEN75AD034Accident · 2 fatalClosedCessna 150K · Tremonton, UTDec 20, 1974 · N6359G · Destroyed NTSB DEN75ATM08Accident · No injuriesClosedBell 47G-3B · Kamas, UTDec 16, 1974 · N73218 · Substantial damage NTSB DEN75FTM11Accident · Minor injuriesClosedErco 415-C · Bountiful, UTDec 14, 1974 · N87276 · Destroyed NTSB DEN75AD031Accident · 1 fatalClosedBeech H35 · Provo, UTDec 10, 1974 · N361B · Destroyed NTSB DEN75DTM07Accident · No injuriesClosedCessna 170B · Morgan, UTDec 7, 1974 · N8227A · Substantial damage NTSB DEN75AD027Accident · 1 fatalClosedRockwell 690A · Kingston, UTNov 12, 1974 · N40MP · 2 aircraft · Destroyed NTSB DEN75AD025Accident · 2 fatalClosedAero Comdr 560 · Bicknell, UTNov 2, 1974 · N867G · Destroyed NTSB DEN75AD022Accident · Minor injuriesClosedBell 47G3B1 · Vernal, UTOct 26, 1974 · N1170W · Substantial damage NTSB DEN75AD019Accident · 4 fatalClosedPiper PA-28 · St.George, UTOct 3, 1974 · N9039W · Destroyed NTSB DEN75FTM06Accident · No injuriesClosedCessna 182B · Sandy, UTSep 28, 1974 · N7169E · Substantial damage NTSB DEN75AD015Accident · 2 fatalClosedCessna 182J · Indianola, UTSep 25, 1974 · N2755F · Destroyed NTSB DEN75FTM05Accident · No injuriesClosedPiper PA-28 · Salt Lake City, UTSep 8, 1974 · N7511W · Substantial damage NTSB DEN75AD009Accident · 1 fatalClosedBell 47G3B1 · Ogden, UTSep 5, 1974 · N73972 · Destroyed NTSB DEN75AD008Accident · 1 fatalClosedCessna 172 · Parowan, UTAug 31, 1974 · N5114A · Destroyed NTSB DEN75DTM01Accident · No injuriesClosedPiper PA-28 · Manila, UTAug 6, 1974 · N8703N · Substantial damage NTSB DEN75DTM04Accident · No injuriesClosedPiper PA-28 · Orangeville, UTJul 24, 1974 · N4093 · Substantial damage NTSB DEN75FTM02Accident · No injuriesClosedBeech B50 · Salt Lake City, UTJul 20, 1974 · N415T · Substantial damage NTSB DEN75AD002Accident · 2 fatalClosedPiper PA-28 · Nephi, UTJul 12, 1974 · N8535W · Destroyed NTSB DEN75FTM03Accident · Serious injuriesClosedPiper PA-18 · Tremonton, UTJul 2, 1974 · N3351A · Substantial damage NTSB DEN74DTM21Accident · No injuriesClosedPiper PA-28 · Lake Powell, UTJun 15, 1974 · N5262L · Substantial damage NTSB DEN74DTM16Accident · Minor injuriesClosedCessna 150H · Nephi, UTJun 9, 1974 · N6942S · Destroyed NTSB DEN74FTM20Accident · Serious injuriesClosedPiper PA-31 · Halls Crossing, UTJun 2, 1974 · N17AM · Substantial damage NTSB DEN74FTM18Accident · Serious injuriesClosedPiper PA-22 · Bountiful, UTJun 2, 1974 · N5363Z · Substantial damage NTSB DEN74AD056Accident · Serious injuriesClosedCessna 402B · Logan, UTMay 31, 1974 · N69391 · Destroyed NTSB DEN74FTM19Accident · Minor injuriesClosedPiper PA-25 · Milford, UTMay 23, 1974 · N7352Z · Destroyed NTSB DEN74FTM15Accident · Minor injuriesClosedCessna 210B · Logan, UTMay 9, 1974 · N9606X · Substantial damage NTSB DEN74DTM14Accident · No injuriesClosedCessna 172I · Price, UTApr 28, 1974 · N35686 · Substantial damage NTSB DEN74DTM17Accident · No injuriesClosedCessna 150G · Cedar City, UTApr 25, 1974 · N8333J · Substantial damage NTSB DEN74DTM13Accident · Minor injuriesClosedLuscombe 8A · Green River, UTApr 9, 1974 · N45482 · Substantial damage NTSB DEN74AD045Accident · 4 fatalClosedPiper PA-22 · Cedar City, UTMar 23, 1974 · N8490D · Destroyed