NTSB investigations, UT
18 cases where NTSB found Crosswind.
Cases per year
| 2008 | 3 |
|---|---|
| 2010 | 4 |
| 2011 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 2 |
| 2025 | 1 |
| 2026 | 2 |
Where
Latest 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\" = 'UT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03034040'))
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" = 'UT' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03034040')) 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 WPR26LA200Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll with gusting crosswind conditions.NTSB WPR26LA192Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Vernal, UTThe pilot's failure to maintain control during the landing flare with a gusting crosswind.NTSB WPR25LA227Accident · Minor injuriesClass 4 · LimitedFinal reportHartline J Bon Hartline Kitfox III · Logan, UTThe pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.NTSB WPR22LA052Accident · No injuriesClass 4 · LimitedFinal reportBagley Curtis Lynn Rans S-6S Coyote II · Fairfield, UTThe pilot's failure to maintain directional control during takeoff with a right crosswind.NTSB WPR21LA147Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Ogden, UTThe pilot's failure to maintain directional control during the landing roll with a light crosswind, which resulted in a runway excursion and collision with terrain.NTSB GAA19CA301Accident · No injuriesData collectionFinal reportLuscombe 8 · Heber, UTThe pilot's exceedance of the airplane's critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.NTSB GAA18CA576Accident · Minor injuriesData collectionFinal reportRaymon A. King Super CUB Replica · Saratoga Springs, UTThe pilot's failure to maintain directional control during the takeoff roll with crosswind conditions.NTSB WPR18LA217Accident · 1 fatalLimited investigationFinal reportSmith Hornet · St. George, UTThe pilot's loss of airplane control during takeoff due to an unexpected gust of wind.NTSB GAA15CA156Accident · No injuriesData collectionFinal reportCessna 172N · Vernal, UTThe pilot's failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.NTSB WPR12CA215Accident · No injuriesData collectionFinal reportMaule M-7-260 · Brigham City, UTThe pilot’s failure to maintain directional control while landing with a gusting crosswind.NTSB WPR11FA242Accident · 4 fatalField investigationFinal reportCessna 172R · Wendover, UTThe pilot did not maintain adequate airspeed during the downwind turn resulting in an aerodynamic stall, in-flight loss of control, and spin. Contributing to the accident was the pilot’s inadequate preflight planning and exceedance of the approved weight and…NTSB WPR10CA344Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Dutch John, UTThe pilot’s inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.NTSB WPR10CA304Accident · No injuriesData collectionFinal reportCessna A185F · Bryce Canyon, UTThe pilot's inadequate compensation for the crosswinds during takeoff.NTSB WPR10CA266Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · St. George, UTThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.NTSB WPR10CA229Accident · No injuriesData collectionFinal reportAviat A-1B · Moab, UTThe pilot's inadequate crosswind compensation resulting in a loss of directional control and impact with bushes.NTSB LAX08CA218Accident · No injuriesData collectionFinal reportCessna 180G · Heber, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control. Contributing to the accident was the crosswind weather conditions.NTSB SEA08CA150Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Logan, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was a crosswind wind gust.NTSB LAX08CA079Accident · No injuriesData collectionFinal reportCessna 180H · Moab, UTThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. A contributing factor was the unexpected dust devil.