Skip to content

NTSB investigations, WY

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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" = 'WY' 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\" = 'WY' 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" = 'WY' 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 DEN81FTC16Accident · No injuriesClosedN American P-51D · Casper, WYJun 6, 1981 · N5471V · Substantial damage NTSB DEN81FA035Accident · 1 fatalClosedBell 206B · Evanston, WYMay 18, 1981 · N39101 · Substantial damage NTSB DEN81FTC15Accident · No injuriesClosedCessna 152 · Gillette, WYMay 8, 1981 · N6560H · Substantial damage NTSB DEN81FA032Accident · 3 fatalClosedCessna T210G · Worland, WYMay 7, 1981 · N6842R · Destroyed NTSB DEN81FA031Accident · 1 fatalClosedCessna 152 · Cowley, WYMay 4, 1981 · N757YH · Destroyed NTSB DEN81FA030Accident · 1 fatalClosedPiper PA-32 · Gillette, WYMay 4, 1981 · N8999N · Substantial damage NTSB DEN81FTC14Accident · No injuriesClosedDehavilland DHC-1 · Rawlins, WYApr 30, 1981 · N48262 · Substantial damage NTSB DEN81FTC13Accident · No injuriesClosedCessna 172XP · Moorcroft, WYApr 26, 1981 · N1254V · Substantial damage NTSB DEN81FTC12Accident · No injuriesClosedPiper PA-18 · Ft Bridger, WYApr 9, 1981 · N6881B · Substantial damage NTSB DEN81FA026Accident · 2 fatalClosedPiper PA-28 · Rock Springs, WYMar 29, 1981 · N44900 · Destroyed NTSB DEN81FA022Accident · No injuriesClosedBell 206A · Evanston, WYMar 16, 1981 · N7881S · Substantial damage NTSB DEN81FTC11Accident · Minor injuriesClosedCessna 140 · Wapiti, WYMar 14, 1981 · N72917 · Substantial damage NTSB DEN81FA020Accident · 1 fatalClosedCessna 206G · Cokeville, WYMar 7, 1981 · N735RM · Destroyed NTSB DEN81FTC09Accident · No injuriesClosedCessna 182 · Moran Juction, WYFeb 17, 1981 · N5871B · Substantial damage NTSB DEN81DTC10Accident · No injuriesClosedCessna 170B · Buffalo, WYFeb 14, 1981 · N1896C · Substantial damage NTSB DEN81FTC08Accident · No injuriesClosedBell 206B · Kenmerer, WYFeb 10, 1981 · N6238N · Substantial damage NTSB DEN81FA015Accident · 1 fatalClosedCessna 310C · Encampment, WYJan 4, 1981 · N6726T · Destroyed NTSB DEN81FA014Accident · 6 fatalClosedCessna T310R · Moose, WYJan 4, 1981 · N4880A · Destroyed NTSB DEN81FTC07Accident · No injuriesClosedCessna 182 · Worland, WYDec 31, 1980 · N4838D · Substantial damage NTSB DEN81FA013Accident · 1 fatalClosedPiper PA-24 · Teton Village, WYDec 25, 1980 · N5873P · Destroyed NTSB DEN81FTC06Accident · No injuriesClosedCessna 150K · Wright, WYDec 22, 1980 · N6458G · Substantial damage NTSB DEN81FTC05Accident · No injuriesClosedCessna 172 · Rock Springs, WYNov 22, 1980 · N51873 · Substantial damage NTSB DEN81FTC04Accident · Minor injuriesClosedCessna 150M · Casper, WYOct 25, 1980 · N345JF · Destroyed NTSB DEN81FTC03Accident · No injuriesClosedPiper PA-20 · Cody, WYOct 24, 1980 · N8536C · Substantial damage NTSB DEN81FTC02Accident · No injuriesClosedDehavilland DH82A · Evanston, WYOct 21, 1980 · N3744M · Substantial damage NTSB DEN81FA008Accident · 4 fatalClosedAero Cmdr 500B · Buffalo, WYOct 17, 1980 · N6395U · Substantial damage NTSB DEN80FAMS1Accident · 2 fatalClosedMooney M20F · Buffalo, WYOct 17, 1980 · N9182V · Destroyed NTSB DEN81FA006Accident · 1 fatalClosedCessna 182K · Rock Springs, WYOct 15, 1980 · N2463Q · Substantial damage NTSB MKC81FA003Accident · 2 fatalClosedCessna 182H · Newcastle, WYOct 6, 1980 · N3460S · Destroyed NTSB DEN81FTC01Accident · No injuriesClosedCessna 170 · Wright, WYOct 4, 1980 · N3830V · Substantial damage NTSB DEN80DTC31Accident · Minor injuriesClosedCessna 182-TR · Sundance, WYSep 17, 1980 · N756WV · Substantial damage NTSB MKC80FA054Accident · 4 fatalClosedBeech V35 · Jackson, WYSep 8, 1980 · N21MD · Destroyed NTSB DEN80FTC30Accident · Serious injuriesClosedCessna 210K · Jackson, WYSep 8, 1980 · N824M · Destroyed NTSB DEN80FTC29Accident · Serious injuriesClosedCessna 120 · Afton, WYAug 29, 1980 · N3032N · Substantial damage NTSB DEN80FA054Accident · 1 fatalClosedPiper PA-24R · Jackson, WYAug 17, 1980 · N4560J · Substantial damage NTSB DEN80FTC27Accident · No injuriesClosedCessna 310Q · Evanston, WYAug 16, 1980 · N69834 · Substantial damage NTSB DEN80DTC28Accident · No injuriesClosedHiller UH-12E · Greybull, WYAug 8, 1980 · N5389V · Substantial damage NTSB DEN80FTC25Accident · No injuriesClosedPiper PA-28R · Encampment, WYAug 5, 1980 · N7494J · Substantial damage NTSB DEN80FTC20Accident · No injuriesClosedHughes 269C · Edgerton, WYAug 3, 1980 · N7412F · Substantial damage NTSB DEN80FA052Accident · 2 fatalClosedAerospatial SA315 · Meeteetse, WYAug 1, 1980 · N47294 · Destroyed NTSB DEN80DTC26Accident · No injuriesClosedPiper PA-18 · Lysite, WYAug 1, 1980 · N82669 · Substantial damage NTSB DEN80FTC22Accident · Serious injuriesClosedAerospatle 315B · Afton, WYJul 17, 1980 · N3602C · Substantial damage NTSB DEN80FTC23Accident · No injuriesClosedPiper PA-25 · Aladdin, WYJul 15, 1980 · N4771Y · Substantial damage NTSB DEN80DTC24Accident · No injuriesClosedAerospatle SA315B · Pinedale, WYJul 12, 1980 · N223RM · Substantial damage NTSB DEN80FTC21Accident · No injuriesClosedPiper PA-16 · Rock Springs, WYJul 5, 1980 · N5331H · Substantial damage NTSB DEN80FTC19Accident · Minor injuriesClosedCessna 152 · Sheridan, WYJun 22, 1980 · N67417 · Substantial damage NTSB DEN80FTC18Accident · Minor injuriesClosedCessna 210L · Mountain View, WYJun 13, 1980 · N2280S · Substantial damage NTSB DEN80FA038Accident · No injuriesClosedAlouette SA315B · Jackson, WYJun 11, 1980 · N10067 · Substantial damage NTSB DEN80FTC17Accident · No injuriesClosedPiper PA-18 · Cheyenne, WYMay 23, 1980 · N6083A · Substantial damage NTSB DEN80FA036Accident · 1 fatalClosedCessna TR182 · Wheatland, WYMay 23, 1980 · N738GG · Destroyed