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 DEN78FA003Accident · 2 fatalClosedMooney M20C · Sheridan, WYOct 4, 1977 · N5581Q · Destroyed NTSB DEN77FTC32Accident · Serious injuriesClosedPiper PA-18 · Weston, WYSep 28, 1977 · N1955P · Substantial damage NTSB DEN77FA060Accident · 2 fatalClosedBellanca 7GCBC · Tensleep, WYSep 27, 1977 · N8363V · Substantial damage NTSB DEN77FTC31Accident · No injuriesClosedCessna 150M · Cheyenne, WYSep 23, 1977 · N704CY · Substantial damage NTSB DEN77FTC30Accident · No injuriesClosedCessna 150 · Bill, WYSep 17, 1977 · N19258 · Substantial damage NTSB DEN77IA057Incident · No injuriesClosedBeech 95-B55 · Cheyenne, WYSep 14, 1977 · N1899W · Minor damage NTSB DEN77DTC29Accident · Minor injuriesClosedCessna 140 · Cody, WYSep 12, 1977 · N89879 · Substantial damage NTSB SEA77DYA35Accident · No injuriesClosedHughes 369D · Etna, WYSep 11, 1977 · N8396F · Substantial damage NTSB DEN77DTC28Accident · No injuriesClosedCessna T210L · Keyhole, WYSep 10, 1977 · N1721X · Substantial damage NTSB DEN77FTC27Accident · Minor injuriesClosedPiper PA-28 · Greybull, WYSep 4, 1977 · N41624 · Substantial damage NTSB DEN77FTC25Accident · Minor injuriesClosedCessna 150 · Meeteetse, WYAug 14, 1977 · N63518 · Substantial damage NTSB DEN77FTC23Accident · Minor injuriesClosedPiper PA16 · Douglas, WYAug 4, 1977 · N5639H · Substantial damage NTSB DEN77FTC26Accident · No injuriesClosedLuscombe 8A · Gillette, WYJul 31, 1977 · N71796 · Substantial damage NTSB DEN77DTC21Accident · Minor injuriesClosedAerospatial SA315B · Wilson, WYJul 31, 1977 · N6390 · Substantial damage NTSB DEN77DTC22Accident · No injuriesClosedPiper PA-22 · Hulett, WYJul 30, 1977 · N5849D · Substantial damage NTSB DEN77FTC19Accident · 2 fatalClosedDouglas DC-3A · Sheridan, WYJul 18, 1977 · N459 · Destroyed NTSB DEN77FTC20Accident · No injuriesClosedCessna T210M · Cody, WYJul 15, 1977 · N6711M · Substantial damage NTSB DEN77FTC18Accident · 1 fatalClosedLuscombe 8A · Walcott, WYJul 3, 1977 · N71257 · Destroyed NTSB DEN77FTC17Accident · No injuriesClosedCessna 210 · Cheyenne, WYJun 29, 1977 · N22132 · Substantial damage NTSB DEN77FTC16Accident · No injuriesClosedLockheed B-34 · Torrington, WYJun 24, 1977 · N7256C · Substantial damage NTSB DEN77FTC15Accident · Serious injuriesClosedAerospatial SA315B · Jackson, WYJun 22, 1977 · N62345 · Destroyed NTSB DEN77FA044Accident · 2 fatalClosedBeech 19A · Wheatland, WYMay 28, 1977 · N6952Q · Destroyed NTSB DEN77FTC14Accident · Serious injuriesClosedPiper PA-28R · Thayne, WYMay 13, 1977 · N57356 · Destroyed NTSB DEN77FTC13Accident · Minor injuriesClosedCessna 172L · Jackson, WYMay 8, 1977 · N19678 · Substantial damage NTSB DEN77FA041Accident · 2 fatalClosedPiper PA-34 · Bigtrails, WYMay 6, 1977 · N4948F · Destroyed NTSB DEN77FA040Accident · 4 fatalClosedBeech J35 · Lander, WYMay 4, 1977 · N83W · Destroyed NTSB DEN77FTC12Accident · Minor injuriesClosedSudaviation SA315B · Laramie, WYMay 3, 1977 · N90706 · Substantial damage NTSB DEN77DTC11Accident · No injuriesClosedBellanca 8GCBC · Elk Mountain, WYApr 25, 1977 · N8672V · Substantial damage NTSB DEN77FTC10Accident · Serious injuriesClosedCessna T210L · Wamsutter, WYApr 21, 1977 · N33DF · Substantial damage NTSB DEN77FA033Accident · 2 fatalClosedAeronca 7AC · Laramie, WYApr 7, 1977 · N83541 · Destroyed NTSB DEN77DTC09Accident · Minor injuriesClosedBell 206B · Laramie, WYApr 5, 1977 · N217RM · Substantial damage NTSB DEN77DTC08Accident · No injuriesClosedCessna 172 · Cody, WYMar 21, 1977 · N78531 · Destroyed NTSB DEN77FA031Accident · 2 fatalClosedCessna 210L · Elk Mountain, WYMar 16, 1977 · N1630X · Destroyed NTSB DEN77DTC07Accident · No injuriesClosedStinson 108-2 · Laramie, WYMar 12, 1977 · N992D · Substantial damage NTSB DEN77DTC06Accident · No injuriesClosedStinson 108-2 · Rock Springs, WYMar 6, 1977 · N9567K · Substantial damage NTSB DEN77FA028Accident · 1 fatalClosedCessna 414 · Farson, WYMar 2, 1977 · N8066Q · Destroyed NTSB DEN77DTC05Accident · No injuriesClosedCessna U206 · Cheyenne, WYFeb 14, 1977 · N8498Q · Substantial damage NTSB DEN77FA020Accident · No injuriesClosedHiller Acft FH1100 · Alpine, WYJan 19, 1977 · N208DP · Substantial damage NTSB DEN77DTC04Accident · No injuriesClosedPiper PA-12 · Rock Springs, WYDec 17, 1976 · N3277M · Substantial damage NTSB DEN77FA013Accident · 1 fatalClosedCessna 120 · Sheridan, WYDec 11, 1976 · N90193 · Destroyed NTSB DEN77DTC02Accident · No injuriesClosedCessna 182J · Cheyenne, WYDec 8, 1976 · N2766F · Substantial damage NTSB DEN77DTC01Accident · No injuriesClosedRobertson 180 · Edgerton, WYNov 8, 1976 · N134H · Substantial damage NTSB DEN77FA003Accident · 4 fatalClosedCessna 210F · Edgerton, WYOct 21, 1976 · N313E · Destroyed NTSB DEN77FA005Accident · Serious injuriesClosedBell B-212 · Casper, WYOct 17, 1976 · N398EH · Substantial damage NTSB DEN77FA001Accident · 1 fatalClosedCessna 182A · Buford, WYOct 4, 1976 · N6033B · Destroyed NTSB DEN76DTC46Accident · No injuriesClosedCessna 182 · Big Piney, WYSep 24, 1976 · N5789J · Substantial damage NTSB DEN76DTC45Accident · No injuriesClosedBellanca 7GCBC · Saratoga, WYAug 19, 1976 · N53966 · Substantial damage NTSB DEN76DTC44Accident · No injuriesClosedBellanca 7GCBC · Glenrock, WYAug 12, 1976 · N8752 · Substantial damage NTSB DEN76DTC43Accident · Minor injuriesClosedGrumman G-164 · Hawk Springs, WYAug 9, 1976 · N73WJ · Destroyed NTSB DEN76FTC42Accident · No injuriesClosedCessna 182N · Casper, WYJul 31, 1976 · N618WC · Substantial damage