Skip to content

NTSB investigations, UT

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 DEN65A0062Accident · 1 fatalClosedPiper PA-28 · Salt Lake City, UTMar 31, 1965 · N5748W · Substantial damage NTSB DEN65F0033Accident · No injuriesClosedCougar 1 · Manti, UTMar 24, 1965 · N92870 · Substantial damage NTSB DEN65A0060Accident · 4 fatalClosedCessna 170 · Ephraim, UTMar 20, 1965 · N3974V · Destroyed NTSB DEN65F0024Accident · Minor injuriesClosedCessna 170A · Huntington, UTMar 14, 1965 · N9086A · Substantial damage NTSB DEN65D0031Accident · No injuriesClosedCessna 180 · Vernal, UTMar 11, 1965 · N2661Y · Substantial damage NTSB DEN65F0028Accident · No injuriesClosedForney F-1A · Spanish Fork, UTFeb 24, 1965 · N3051G · Destroyed NTSB DEN65F0016Accident · No injuriesClosedLuscombe 8A · Bryce Canyon, UTFeb 22, 1965 · N20687 · Substantial damage NTSB DEN65F0023Accident · No injuriesClosedErcoupe 415C · Colton, UTFeb 11, 1965 · N2798H · Substantial damage NTSB DEN65A0053Accident · No injuriesClosedHughes 269B · Provo, UTFeb 4, 1965 · N9345F · Substantial damage NTSB DEN65F0009Accident · Minor injuriesClosedCessna 172 · Monument Vally, UTJan 31, 1965 · N3741S · Destroyed NTSB DEN65F0005Accident · No injuriesClosedLuscombe 8A · Colliston, UTJan 16, 1965 · N2761K · Substantial damage NTSB DEN65F0004Accident · No injuriesClosedPiper PA24 · Salt Lake City, UTJan 16, 1965 · N6464P · Substantial damage NTSB DEN65I0045Incident · No injuriesClosedBoeing B-720B · Salt Lake City, UTJan 4, 1965 · N93151 · Minor damage NTSB UNK65X1171Accident · No injuriesClosedCessna 182F · Duchesne, UTDec 28, 1964 · N3560Y · Substantial damage NTSB UNK65X1170Accident · No injuriesClosedNavion A · Spanish Fork, UTDec 28, 1964 · N4486K · Substantial damage NTSB UNK65X1067Accident · No injuriesClosedPiper PA28 · Moab, UTDec 20, 1964 · N7761W · Substantial damage NTSB UNK65X1059Accident · 1 fatalClosedPiper PA-24 · Ogden, UTDec 19, 1964 · N5875P · Destroyed NTSB UNK65X1005Accident · 2 fatalClosedPiper PA-18 · Carrington Isl., UTDec 13, 1964 · N6977D · Destroyed NTSB UNK65X0630Accident · No injuriesClosedPiper PA22 · Cedar City, UTNov 9, 1964 · N3221B · Substantial damage NTSB UNK65X0482Accident · Minor injuriesClosedPiper PA15 · Soldier Summit, UTOct 30, 1964 · N4461H · Destroyed NTSB UNK65X0470Accident · No injuriesClosedPiper PA18 · Promontory Pt, UTOct 29, 1964 · N3959Z · Substantial damage NTSB UNK65X0396Accident · No injuriesClosedCessna 170B · Rainbow Bridge, UTOct 24, 1964 · N3227A · Destroyed NTSB UNK65X0365Accident · 2 fatalClosedPiper PA-18 · Dugway, UTOct 21, 1964 · N5031K · Destroyed NTSB UNK65X0308Accident · No injuriesClosedCessna 172 · Ouray, UTOct 17, 1964 · N5031A · Substantial damage NTSB UNK65X0193Accident · No injuriesClosedPiper PA20 · Woods Cross, UTOct 8, 1964 · N7783K · Substantial damage NTSB UNK65X0160Accident · No injuriesClosedSwift GC1B · Salt Lake City, UTOct 6, 1964 · N80855 · Substantial damage NTSB UNK64X4167Accident · No injuriesClosedCessna 182 · Hite, UTSep 26, 1964 · N3170U · Substantial damage NTSB UNK64X4137Accident · No injuriesClosedPiper PA20 · Woods Cross, UTSep 25, 1964 · N7414K · Substantial damage NTSB UNK64X4095Accident · No injuriesClosedCessna 172 · Carrington Is, UTSep 22, 1964 · N8926B · Substantial damage NTSB DEN65D0048Accident · No injuriesClosedBeechcraft 35 · Panguitch, UTSep 12, 1964 · N2875V · Substantial damage NTSB UNK64X3736Accident · No injuriesClosedCessna 210 · Salt Lake City, UTSep 2, 1964 · N7347E · Substantial damage NTSB UNK64X3666Accident · No injuriesClosedPiper PA22 · Camp Williams, UTAug 29, 1964 · N5314Z · Substantial damage NTSB UNK64X3565Accident · No injuriesClosedCessna 182 · Bullfrog Basin, UTAug 23, 1964 · N5389B · Destroyed NTSB UNK64X3192Accident · No injuriesClosedCessna 182 · Green River, UTAug 3, 1964 · N9034X · Substantial damage NTSB UNK64X3078Accident · Minor injuriesClosedBell 47G3B1 · Kamas, UTJul 27, 1964 · N73972 · Substantial damage NTSB UNK64X3065Accident · No injuriesClosedBellanca 14192 · Salt Lake City, UTJul 27, 1964 · N9827B · Substantial damage NTSB UNK64X2977Accident · No injuriesClosedAeronca 7AC · Woods Cross, UTJul 22, 1964 · N83647 · Substantial damage NTSB UNK64X2852Accident · No injuriesClosedCessna 172 · Salt Lake City, UTJul 16, 1964 · N2590Y · Substantial damage NTSB UNK64X2845Accident · No injuriesClosedPiper PA24 · Vernon, UTJul 15, 1964 · N6427P · Substantial damage NTSB UNK64X2837Accident · No injuriesClosedBeechcraft 35 · Grantsville, UTJul 15, 1964 · N415B · Substantial damage NTSB UNK64X2773Accident · No injuriesClosedPiper PA18 · Manila, UTJul 12, 1964 · N3783Z · Substantial damage NTSB UNK64X2636Accident · No injuriesClosedPiper PA22 · Green River, UTJul 4, 1964 · N1448C · Substantial damage NTSB UNK64X2560Accident · 1 fatalClosedBell 47G · Ogden, UTJun 29, 1964 · N19H · Destroyed NTSB UNK64X1684Accident · No injuriesClosedCessna 140 · Moab, UTMay 9, 1964 · N2634N · Destroyed NTSB UNK64X1653Accident · No injuriesClosedCessna 180 · West Jordan, UTMay 7, 1964 · N4658A · Substantial damage NTSB UNK64X1647Incident · No injuriesClosedConvair 340 · Salt Lake City, UTMay 7, 1964 · N73104 · Minor damage NTSB UNK64X1607Accident · Minor injuriesClosedCessna 120 · Coalville, UTMay 4, 1964 · N81070 · Substantial damage NTSB UNK64X1212Accident · 2 fatalClosedStinson 108-2 · St John, UTApr 7, 1964 · N430C · Destroyed NTSB UNK64X1123Accident · No injuriesClosedCessna 175 · Salt Lake City, UTApr 1, 1964 · N7084M · Substantial damage NTSB UNK64X1070Accident · No injuriesClosedPiper PA18 · Salt Lake City, UTMar 28, 1964 · N3783Z · Substantial damage