NTSB investigations, WY
13 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 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\" = 310)
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" = 310) 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 DEN02LA006Accident · No injuriesLimited investigationFinal reportPilatus PC-12 · Casper, WYThe pilot's failure to maintain clearance from another parked airplane while taxiing. Contributing factors were the night light conditions, and the pilot's fatigue from a long day.NTSB DEN00LA166Accident · No injuriesLimited investigationFinal reportCessna 340A · Big Piney, WYCollision with animals during the takeoff roll.NTSB DEN00LA026Accident · No injuriesLimited investigationFinal reportCessna 421C · Gillette, WYThe collision with a deer on the runway during a night landing. A factor was the dark night.NTSB DEN99LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Burlington, WYThe pilots' inadequate preflight planning for take off in that he failed to consider the takeoff surface not being a paved surface. A factor was loose material on the roadway used for take off.NTSB FTW98LA336Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Cody, WYThe pilot's failure to maintain visual lookout while taxiing the aircraft.NTSB SEA94LA141Accident · No injuriesLimited investigationFinal reportRockwell AC-690 · Casper, WYAnimals (deer) on the runway during the landing roll. Factors include a dark night.NTSB SEA93IA050Incident · No injuriesIncident investigationFinal reportBeech 1900C · Riverton, WYThe pilot's disorientation. Factors include snow, fog, snow covered terrain, and a drainage ditch.NTSB DEN86LA260Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wright, WYAcft was taxiing for takeoff from driveway on private ranch. Plt said there was strong x-wing gusting from left to right. Plt said he was holding right rudder when wind velocity decreased. Wing tip struck post beside driveway, acft turned right, and rolled…NTSB DEN86IA031Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Casper, WYAcft was parked at gate awaiting departure. A bus used to shuttle flt crews around the ramp arrived at flt 855 to deliver a flt attendant. The driver was backing away from acft when the left side to bus contacted rt wing tip. Damage was limited to wing tip…NTSB DEN85LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverton, WYThe student plt attempted to land on rwy 17. The wind was reported to be from 010 degs at 13 KTS. The acft touched down halfway down the rwy. The plt attempted to go around but aborted because of the tailwind. The acft ran off the end of the rwy and collided…NTSB DEN84LA257Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Cheyenne, WYFollowing an uneventful solo flight the student plt began to follow a parking vehicle to a parking spot. The spot that the parking vehicle driver selected necessitated that the acft execute a 180 deg turn just priop to stopping. During this turn the right…NTSB DEN83LA138Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Afton, WYThe pitts special and a Cessna 182 collided on an active rwy the pitts was landing and the Cessna was taxiing down the rwy for refueling. The Cessna had made a radio call leaving the hanger area but did not make one prior to actually goingonto the rwy. The…NTSB DEN83LA051Accident · No injuriesLimited investigationFinal reportCessna 172XP · Harmony, WYThe acft collided with a fence at the departure end of a pasture field during a go-around. The pilot had decided to land in an easterly direction to avoid powerlines and did not consider direction of the wind. Full flaps did not slow the acft effectively…