NTSB investigations, WY
7 cases where the defining event was Runway excursion.
Cases per year
| 2010 | 2 |
|---|---|
| 2011 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2023 | 1 |
| 2026 | 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '300')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '300') 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 WPR27LA022Accident · No injuriesLimited investigationInvestigation openHonda HA-420 · Alpine, WYNTSB WPR23LA108Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Lander, WYThe pilot’s failure to maintain directional control during landing.NTSB GAA16CA354Accident · No injuriesData collectionFinal reportCessna 188 · Saratoga, WYThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in substantial damage.NTSB WPR13CA282Accident · No injuriesData collectionFinal reportCessna 170B · Rawlins, WYThe pilot’s delayed decision to abort the takeoff. Contributing to the accident was the pilot's inadequate preflight planning and a high density altitude, which resulted in a runway excursion and collision with terrain.NTSB WPR12CA068Accident · No injuriesData collectionFinal reportBeech J35 · Cheyenne, WYThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB DCA11IA015Incident · No injuriesClass 1 · IncidentFinal reportBoeing 757-223 · Jackson Hole, WYa manufacturing defect in a clutch mechanism that prevented the speedbrakes from automatically deploying after touchdown, and the captain’s failure to monitor and extend the speedbrakes manually. Also causal was the failure of the thrust reversers to deploy…NTSB WPR11IA055Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Jackson, WYThe flight crew's inability to stop the airplane during landing roll on a snow- and ice-contaminated runway. Contributing to the runway overrun were the deteriorating runway conditions.