NTSB investigations, WY
10 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 1 |
|---|---|
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1998 | 3 |
| 2000 | 1 |
| 2007 | 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\" = 340)
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" = 340) 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 DEN07LA101Accident · No injuriesLimited investigationFinal reportBeech 1900D · Laramie, WYThe pilot's improper decision, his misjudgment of his speed and distance, and his failure to perform a go-around resulting in the airplane overrunning the runway and striking an electrical box. Factors contributing to the accident were the failure of the crew…NTSB DEN00LA057Accident · No injuriesLimited investigationFinal reportLearjet 60 · Jackson, WYThe pilot not following the airplane manufacturer's recommended landing procedures for a contaminated runway by landing with a tailwind. Factors were the pilot's inadvertent deactivation of the anti-skid protection, the ice contaminated runway, and the snow…NTSB FTW98LA334Accident · Minor injuriesLimited investigationFinal reportCessna 500 · Rawlins, WYThe captain's use of improper airplane performance data, resulting in inadequate takeoff capability. Factors were his decision to abort the takeoff above V1, the separation of the drag chute, a wet runway, a tailwind, and collision with objects that included…NTSB FTW98LA254Accident · No injuriesLimited investigationFinal reportCessna 172A · Ten Sleep, WYThe student pilot's failure to select a proper touchdown point. A factor was his lack of recent experience conducting solo flight operations.NTSB FTW98LA200Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Jackson, WYthe pilot's misjudgment of distance and speed, while approaching to land; his failure to attain a proper touchdown point for landing; and his failure to go around, while there was sufficient runway remaining. A related factor was the uneven terrain, which was…NTSB SEA95LA147Accident · No injuriesLimited investigationFinal reportCessna A188B · Esterbrook, WYThe pilot's failure to attain the proper touchdown point and airspeed for landing. Contributing to the accident were high density altitude, the short landing area, and the pilot's failure to initiate a go-around in time to allow recovery from the situation.NTSB SEA91LA007Accident · No injuriesLimited investigationFinal reportCessna 414A · Jackson, WYThe pilot's inadequate preflight preparation of the aircraft, his failure to remove snow and ice from the aircraft before takeoff, and his delay in attempting to abort the takeoff.NTSB DEN89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Alpine, WYPilot's decision to land at an unlighted airport at night. The aircraft landed long and overran the runway.NTSB DEN87LA082Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Rock Rover, WYThe plt was using a pasture for takeoff. The winds were calm and the takeoff run was slightly uphill. There was a low spot in the pasture which was soft from melting snow. The acft did not reach takeoff speed before reaching the end of the pasture. During the…NTSB DEN82DA041Accident · No injuriesFinal reportBellanca 7GCBC · Thermopolis, WYDuring a landing in a hay meadow the pilot touched down long, due to a tailwind, and turned uphill to avoid hitting a fence and ditch. The aircraft ground looped breaking the right wheel strut.