NTSB investigations

114 cases where NTSB found Sudden wind shift.

Cases, newest first

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03034010'))
  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.

NTSB ERA09CA479Accident · No injuriesData collectionFinal reportJonker JS-1B · Tullahoma, TNThe pilot's failure to maintain a proper glidepath while on approach, resulting in landing short of the runway.Aug 23, 2009 · N504BT · Substantial damageNTSB WPR09CA335Accident · No injuriesData collectionFinal reportCessna 180 · La Grande, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.Jul 5, 2009 · N3198D · Substantial damageNTSB WPR09CA289Accident · No injuriesData collectionFinal reportCessna 150 · Nampa, IDThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing roll.Jun 12, 2009 · N5504E · Substantial damageNTSB WPR09CA178Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Monterey, CAThe pilot's inadequate compensation for the wind conditions and failure to attain/maintain an adequate airspeed, which resulted in an aerodynamic stall.Apr 4, 2009 · N224RA · Substantial damageNTSB CEN09CA066Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Bowling Green, MOFailure of the pilot to maintain aircraft control during the landing sequence. A contributing factor was the sudden gusty crosswind.Nov 14, 2008 · N5432Z · Substantial damageNTSB WPR09CA008Accident · No injuriesData collectionFinal reportBell 47J-2A · Florence, AZThe pilot’s inadequate compensation for a wind shift encountered during the landing approach, which resulted in a hard landing and rollover. Contributing to the accident was the encounter with the wind shift.Oct 11, 2008 · N8567F · Substantial damageNTSB MIA08CA179Accident · No injuriesData collectionFinal reportCessna 172SP · South Harpswell, METhe pilot's failure to maintain control of the airplane while landing in gusty winds.Sep 1, 2008 · N251SP · Substantial damageNTSB LAX08CA173Accident · Minor injuriesData collectionFinal reportBeech A36 · Ryegate, MTThe pilot's failure to abort the takeoff when the ground roll acceleration profile was determined to be insufficient for takeoff. Contributing to the accident was the shifting wind conditions.Jun 26, 2008 · N824C · Substantial damageNTSB DEN08LA102Accident · No injuriesLimited investigationFinal reportCessna 150G · Brenham, TXThe sudden windshift (crosswind gust), rendering directional control impossible. Contributing factors in this accident were the high speed during the aborted takeoff and trees.Jun 10, 2008 · N4691R · Substantial damageNTSB LAX08CA165Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe flight instructor's inadequate compensation for the wind conditions, and his inadequate supervision of the student pilot. Factors contributing to the accident were a sudden wind shift and wind gusts.Jun 6, 2008 · N73403 · Substantial damageNTSB SEA08CA130Accident · No injuriesData collectionFinal reportBeech B19 · Burns, ORThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. The shifting wind was a factor.May 10, 2008 · N9342S · Substantial damageNTSB DEN08LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Reserve, NMThe pilot's loss of aircraft control, resulting in an inadvertent stall. Contributing factors in this accident were the sudden windshift to a gusting tailwind, an uphill runway, high density altitude, the pilot's failure to use all available runwayt, and his…Apr 17, 2008 · N6260J · DestroyedNTSB DEN08LA071Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · La Porte, TXThe loss of tail rotor effectiveness. Contributing factors were the sudden windshift to a tailwind, and the pilot initiating a hovering turn in ground effect.Apr 4, 2008 · N40289 · Substantial damageNTSB SEA08CA093Accident · Minor injuriesData collectionFinal reportGrumman G-164A · Dayton, WAThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed. A contributing factor was the sudden windshift.Mar 25, 2008 · N48629 · Substantial damage