NTSB investigations, TX
11 cases where NTSB found Wind, general.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2012 | 2 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
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\" = 'TX' 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\", '03034000'))
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" = 'TX' 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", '03034000')) 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 CEN23LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Sherman, TXThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.NTSB CEN22LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Kendleton, TXThe pilot’s improper in-flight planning and fuel management that resulted in the loss of engine power due to fuel exhaustion.NTSB CEN21LA169Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58 · Pottsboro, TXThe pilot failure to maintain directional control of the helicopter when it encountered an unanticipated wind allowing it to drift into a fence and subsequently roll over and impact terrain.NTSB CEN20CA176Accident · No injuriesClass 4 · Data collectionFinal reportNorth American SNJ · San Antonio, TXThe pilot's loss of directional control while landing a tailwheel airplane in gusty wind conditions.NTSB GAA18CA382Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 5 · Waller, TXThe glider pilot’s failure to maintain clearance from trees during landing.NTSB CEN13CA090Accident · No injuriesData collectionFinal reportCessna 172N · McKinney, TXThe pilot’s inadequate flare, which resulted in a hard nosewheel landing.NTSB CEN12LA258Accident · Minor injuriesLimited investigationFinal reportBell 206B · Amarillo, TXThe pilot's failure to maintain helicopter control during landing in gusty wind conditions associated with a thunderstorm, which resulted in a loss of tail rotor effectiveness.NTSB CEN11CA127Accident · No injuriesData collectionFinal reportCessna 182P · Clifton, TXThe pilot's inadequate compensation for the crosswind and inadequate flare, which resulted in a hard landing.NTSB CEN10CA160Accident · No injuriesData collectionFinal reportUltralight America Spitfire II Modelctv · Cameron, TXThe pilot's failure to maintain control while maneuvering during a forced landing after a partial loss of engine power.NTSB CEN09CA180Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · O'Donnell, TXThe pilot's failure to maintain control while performing a quick stop maneuver to an out of ground effect (OGE) hover. Contributing to the accident was the high density altitude and near calm wind condition.NTSB DFW08CA239Accident · No injuriesData collectionFinal reportGier Travis H Aventura II · Montgomery, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the wind gust.