NTSB investigations, WY
7 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2003 | 1 |
Where
Open the mapLatest cases
Query with SQL
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 320)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320) 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 DEN03LA148Accident · No injuriesLimited investigationFinal reportCessna 150H · Moran, WYthe pilot's selection of an unsuitable takeoff area which resulted in an encounter with the gopher hole during the touch-and-go. Factors contributing to the accident were the gopher hole, the abrupt pull up, the low airspeed, the inadvertent stall mush, the…NTSB DEN02LA024Accident · No injuriesLimited investigationFinal reportAviat A-1A · Afton, WYThe pilot's failure to maintain directional control, which resulted in a collision with a snow bank. Contributing factors were the icy runway and the snow bank.NTSB DEN99LA017Accident · No injuriesLimited investigationFinal reportCessna 182A · Bedford, WYThe pilot's failure to identify a soft area on his newly constructed airstrip, which subsequently caused his airplane to nose over.NTSB SEA95LA180Accident · No injuriesLimited investigationFinal reportMooney M20A · Rock Springs, WYThe pilot's failure to maintain control of the aircraft. Factors include the uneven runway condition, the information regarding the crowned condition not being disseminated by airport personnel, and the inadequate review/inspection of the condition by FAA…NTSB SEA91LA187Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Kemmerer, WYThe pilot's poor planning/decision. Factors include selecting the wrong runway under the high density altitude conditions.NTSB DEN88LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYDuring landing on a ranch road while on a business flight the plt struck a pile of gravel placed on the road to facilitate road repairs. The aircraft flipped over and caused substantial damage to the vertical stabilizer, horizontal stabilizer, propeller and…NTSB DEN83LA207Accident · No injuriesLimited investigationFinal reportCessna 210E · Powell, WYAccording to the pilot he made an approach to a dirt road beside a feed lot and overshot the intended touchdown point. He was relectant to make a go around because there was a high hill close ahead. He tried to stop the acft on the road remaining but the road…