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 DEN67F0169Accident · No injuriesClosedCessna 172 · Panguitch, UTOct 14, 1966 · N3659L · Substantial damage NTSB DEN67A0026Accident · 1 fatalClosedCessna 150F · Tooele, UTOct 4, 1966 · N7798F · Destroyed NTSB DEN67D0109Accident · No injuriesClosedCessna 172 · Vernon, UTOct 2, 1966 · N6188E · Substantial damage NTSB DEN67A0028Accident · 4 fatalClosedPiper PA-24 · Alton, UTOct 2, 1966 · N7555P · Destroyed NTSB DEN67F0116Accident · Serious injuriesClosedBeech B35 · Salt Lake City, UTOct 1, 1966 · N8931A · Substantial damage NTSB DEN6MD0107Accident · No injuriesClosedCessna 150D · Salt Lake City, UTSep 20, 1966 · N4448U · Substantial damage NTSB DEN67A0023Accident · No injuriesClosedCessna 182B · Green River, UTSep 20, 1966 · N2365G · Substantial damage NTSB DEN67D0117Accident · No injuriesClosedCessna 150 · Salt Lake City, UTSep 18, 1966 · N4411U · Substantial damage NTSB DEN67D0119Accident · Minor injuriesClosedCessna 180E · Hanksville, UTSep 14, 1966 · N2661Y · Destroyed NTSB DEN67F0100Accident · No injuriesClosedHelio H-295 · Salt Lake City, UTSep 5, 1966 · N6302V · Substantial damage NTSB DEN67F0108Accident · No injuriesClosedCessna 320D · Vernal, UTSep 1, 1966 · N429T · Substantial damage NTSB DEN67D0118Accident · No injuriesClosedCessna 170B · Midvale, UTSep 1, 1966 · N2970D · Substantial damage NTSB DEN67F0093Accident · 1 fatalClosedChampion 7GC · Heber, UTAug 29, 1966 · N7590E · Substantial damage NTSB DEN67A0017Accident · 2 fatalClosedAeronca 11AC · Sandy, UTAug 24, 1966 · N9775E · Destroyed NTSB DEN67D0077Accident · No injuriesClosedCessna 182 · Green River, UTAug 16, 1966 · N4918D · Substantial damage NTSB DEN67A0014Accident · 5 fatalClosedPiper PA-28 · Vernal, UTAug 6, 1966 · N8300W · Destroyed NTSB DEN67D0053Accident · No injuriesClosedCessna 150 · Roosevelt, UTJul 23, 1966 · N2079Z · Substantial damage NTSB DEN67A0008Accident · Serious injuriesClosedHiller UH-12E · Escalante, UTJul 21, 1966 · N5360V · Destroyed NTSB DEN67D0043Accident · No injuriesClosedCessna 170 · Moab, UTJul 16, 1966 · N3455C · Substantial damage NTSB DEN67D0042Accident · No injuriesClosedBellanca 14-13 · Panguitch, UTJul 13, 1966 · N74209 · Substantial damage NTSB DEN66F0044Accident · No injuriesClosedCessna 182 · Sandy, UTJul 10, 1966 · N4968D · Substantial damage NTSB DEN67D0052Accident · No injuriesClosedPiper PA-12 · Blanding, UTJul 9, 1966 · N7909H · Substantial damage NTSB DEN67A0001Accident · 2 fatalClosedCessna T210F · Cisco, UTJul 6, 1966 · N6790R · Destroyed NTSB DEN67F0024Accident · No injuriesClosedN American AT-6 · Delta, UTJul 5, 1966 · N3326G · Substantial damage NTSB DEN67F0029Accident · No injuriesClosedBeech B35 · Salt Lake City, UTJul 2, 1966 · N8693A · Substantial damage NTSB DEN67D0028Accident · No injuriesClosedPiper PA-24 · Coalville, UTJul 2, 1966 · N6884P · Substantial damage NTSB DEN67F0011Accident · Serious injuriesClosedBeec 23 · Bountiful, UTJun 17, 1966 · N2352Z · Destroyed NTSB DEN66F0360Accident · No injuriesClosedPiper PA24 · Salt Lake City, UTJun 16, 1966 · N8771P · Substantial damage NTSB DEN67F0004Accident · Minor injuriesClosedCessna 205 · Erron, UTJun 11, 1966 · N1873Z · Substantial damage NTSB DEN67D0014Accident · Minor injuriesClosedCessna 182A · Dutch John, UTJun 10, 1966 · N5109D · Destroyed NTSB DEN66A0088Accident · Minor injuriesClosedBell 47G3B1 · Ogden, UTJun 7, 1966 · N1323X · Substantial damage NTSB DEN67D0002Accident · No injuriesClosedCessna 150 · Provo, UTJun 5, 1966 · N8654S · Substantial damage NTSB DEN67F0003Accident · Minor injuriesClosedCessna 182 · Salt Lake City, UTJun 2, 1966 · N5185D · Substantial damage NTSB DEN66D0333Accident · No injuriesClosedPiper PA-22 · Hanksville, UTJun 1, 1966 · N829A · Substantial damage NTSB DEN66F0342Accident · No injuriesClosedCessna 182 · Salt Lake City, UTMay 28, 1966 · N8580S · Substantial damage NTSB DEN66D0340Accident · No injuriesClosedCessna 210 · Logan, UTMay 22, 1966 · N9439T · Substantial damage NTSB DEN66F0341Accident · No injuriesClosedPiper PA-25 · St.George, UTMay 15, 1966 · N6389Z · Substantial damage NTSB DEN66F0332Accident · No injuriesClosedBellanca 14-13 · Mexican Hat, UTMay 15, 1966 · N86825 · Substantial damage NTSB DEN66F0339Accident · No injuriesClosedCessna 170 · Oljato, UTMay 14, 1966 · N9130A · Substantial damage NTSB DEN66D0294Accident · No injuriesClosedBeech T-34A · Provo, UTApr 30, 1966 · N12271 · Substantial damage NTSB DEN66F0295Accident · No injuriesClosedBeech G35 · Salt Lake City, UTApr 26, 1966 · N4603D · Substantial damage NTSB DEN66D0309Accident · No injuriesClosedCessna 210A · Riverton, UTApr 23, 1966 · N9418X · Substantial damage NTSB DEN66D0285Accident · No injuriesClosedCessna 120 · Tremonton, UTApr 22, 1966 · N72233 · Substantial damage NTSB DEN66F0277Accident · No injuriesClosedCessna 182A · Salt Lake City, UTApr 5, 1966 · N2120G · Substantial damage NTSB DEN66F0293Accident · No injuriesClosedCessna 172 · Sandy, UTApr 3, 1966 · N2590Y · Substantial damage NTSB DEN66D0278Accident · Minor injuriesClosedPiper J3C · Green River, UTMar 26, 1966 · N88244 · Substantial damage NTSB DEN66F0265Accident · No injuriesClosedCessna 172 · Kearns, UTMar 24, 1966 · N8307B · Substantial damage NTSB DEN66F0263Accident · No injuriesClosedCessna 185 · Salt Lake City, UTMar 12, 1966 · N4031Y · Substantial damage NTSB DEN66A0063Accident · No injuriesClosedPiper PA-24 · Hanksville, UTMar 7, 1966 · N8325P · Substantial damage NTSB DEN66F0232Accident · No injuriesClosedBeechcraft 33 · Woods Cross, UTMar 2, 1966 · N8502M · Substantial damage