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 DEN80FTC16Accident · 2 fatalClosedCessna R172K · Cheyenne, WYMay 21, 1980 · N758LA · Destroyed NTSB DEN80FA033Accident · No injuriesClosedBeech 58 · Casper, WYMay 16, 1980 · N25734 · Substantial damage NTSB DEN80FTC14Accident · No injuriesClosedPiper PA-18 · Hulett, WYMay 6, 1980 · N8254C · Substantial damage NTSB DEN80FTC13Accident · Minor injuriesClosedCessna TU206G · Farson, WYApr 24, 1980 · N756PT · Substantial damage NTSB DEN80FTC12Accident · Minor injuriesClosedHughes 369D · Chugwater, WYApr 9, 1980 · N49667 · Destroyed NTSB DEN80DTC10Accident · No injuriesClosedSwearingen SA26T · Jackson, WYFeb 29, 1980 · N30SG · Substantial damage NTSB DEN80DTC08Accident · No injuriesClosedLuscombe 8E · Cheyenne, WYFeb 27, 1980 · N28490 · Substantial damage NTSB DEN80FTC09Accident · No injuriesClosedCessna 172N · Rock Springs, WYFeb 25, 1980 · N5216E · Substantial damage NTSB DEN80FTC07Accident · No injuriesClosedCessna 152 · Lander, WYFeb 16, 1980 · N24272 · Substantial damage NTSB DEN80DTC06Accident · No injuriesClosedCessna 172N · Kemmerer, WYFeb 12, 1980 · N739KU · Substantial damage NTSB DEN80FTC05Accident · No injuriesClosedHiller Acft UH-12D · Mckennon, WYFeb 8, 1980 · N31331 · Substantial damage NTSB DEN80DTC04Accident · No injuriesClosedBell 206B · Thermopolis, WYDec 28, 1979 · N16867 · Substantial damage NTSB DEN80FTC03Accident · Minor injuriesClosedBeech B95A · Rock Springs, WYDec 23, 1979 · N6DM · Destroyed NTSB DEN80DTC02Accident · No injuriesClosedPiper PA-28 · Wheatland, WYNov 29, 1979 · N7549W · Substantial damage NTSB DEN80FA006Accident · 4 fatalClosedCessna C210T · Jackson, WYOct 27, 1979 · N6470A · Destroyed NTSB DEN81FA066Accident · 4 fatalClosedBeech C33 · Dubois, WYOct 22, 1979 · N60234 · Destroyed NTSB DEN80FTC01Accident · No injuriesClosedCessna TU206F · Lander, WYOct 5, 1979 · N35824 · Substantial damage NTSB DEN79DTC28Accident · No injuriesClosedCessna 150F · Nsheridan, WYSep 22, 1979 · N60752 · Substantial damage NTSB DEN79DTC27Accident · No injuriesClosedBellanca 8GCBC · Jackson, WYSep 22, 1979 · N5052W · Substantial damage NTSB DEN79DTC26Accident · No injuriesClosedCessna U206A · Wheatland, WYAug 31, 1979 · N71900 · Substantial damage NTSB DEN79FTC25Accident · Serious injuriesClosedCessna 182 · Evanston, WYAug 24, 1979 · N3356U · Substantial damage NTSB DEN79FTC24Accident · Minor injuriesClosedHughes 369D · Kemmerer, WYAug 18, 1979 · N83FC · Substantial damage NTSB DEN79DTC23Accident · Minor injuriesClosedCessna 172 · Afton, WYAug 5, 1979 · N19921 · Substantial damage NTSB DEN79DTC22Accident · No injuriesClosedErco 415C · Cheyenne, WYAug 3, 1979 · N93927 · Substantial damage NTSB DEN79FTC21Accident · Serious injuriesClosedAerospatial S315B · Alpine, WYJul 20, 1979 · N49524 · Destroyed NTSB DEN79DTC20Accident · No injuriesClosedCessna 180 · Cody, WYJul 11, 1979 · N9083M · Substantial damage NTSB DEN79FTC19Accident · No injuriesClosedHughes 369D · Labarge, WYJul 1, 1979 · N8667F · Substantial damage NTSB DEN79DTC18Accident · No injuriesClosedBeech A-36 · Bondurant, WYJun 25, 1979 · N4260S · Substantial damage NTSB DEN79FTC17Accident · No injuriesClosedCessna 182 · Wamsutter, WYJun 17, 1979 · N7462S · Substantial damage NTSB DEN79DTC16Accident · No injuriesClosedBoeing A75-N1 · Kinnear, WYJun 15, 1979 · N66053 · Substantial damage NTSB DEN79DTC15Accident · No injuriesClosedPiper PA-24 · Rock Springs, WYMay 31, 1979 · N8436P · Substantial damage NTSB DEN79FTC14Accident · Minor injuriesClosedCessna 172E · Rawlins, WYMay 21, 1979 · N9240Z · Substantial damage NTSB DEN79FTC13Accident · Serious injuriesClosedCessna 340 · Rock Springs, WYMay 8, 1979 · N340ME · Substantial damage NTSB DEN79FTC12Accident · No injuriesClosedStinson 108 · Point Of Rocks, WYMay 4, 1979 · N97419 · Substantial damage NTSB DEN79FA037Accident · 2 fatalClosedCessna 172 · Centennial, WYMay 4, 1979 · N3047V · Destroyed NTSB DEN79DTC11Accident · No injuriesClosedPiper PA-18A · Casper, WYApr 20, 1979 · N8081C · Substantial damage NTSB DEN79FA033Accident · 4 fatalClosedPiper PA-34 · Lander, WYMar 27, 1979 · N2257M · Destroyed NTSB DEN79DTC10Accident · No injuriesClosedCessna 150 · Afton, WYMar 14, 1979 · N6411K · Substantial damage NTSB DCA79AA010Accident · Minor injuriesClosedDehavilland DHC-6 · Cheyenne, WYFeb 27, 1979 · N24RM · Substantial damage NTSB DEN79FA023Accident · 4 fatalClosedCessna 206 · Moose, WYFeb 24, 1979 · N114CK · Destroyed NTSB DEN79FTC09Accident · No injuriesClosedCessna 421 · Big Piney, WYFeb 21, 1979 · N8047Q · Substantial damage NTSB DEN79DTC08Accident · No injuriesClosedStinson 108-2 · Lander, WYFeb 21, 1979 · N9835K · Substantial damage NTSB DEN79FA020Accident · 1 fatalClosedCessna R172K · Banner, WYFeb 6, 1979 · N758AV · Destroyed NTSB DEN79DTC07Accident · No injuriesClosedPiper PA-18 · Casper, WYJan 24, 1979 · N54768 · Substantial damage NTSB DEN79DTC06Accident · Minor injuriesClosedPiper PA-31 · Pinedale, WYJan 21, 1979 · N9026Y · Substantial damage NTSB DEN79FTC05Accident · 1 fatalClosedCessna 172 · Rawlings, WYDec 17, 1978 · N7015A · Destroyed NTSB DEN79DTC04Accident · No injuriesClosedCessna 172 · Cheyenne, WYNov 28, 1978 · C-GZDD · Substantial damage NTSB DEN79FTC03Accident · No injuriesClosedBellanca 7GCBC · Laramie, WYNov 11, 1978 · N8802 · Substantial damage NTSB DEN79FA007Accident · 4 fatalClosedGrum-Amer AA-5B · Meeteetse, WYNov 8, 1978 · N28406 · Destroyed NTSB DEN79FTC01Accident · No injuriesClosedCessna 310P · Pinedale, WYOct 26, 1978 · N5752M · Substantial damage