NTSB investigations, 2019

71 cases where the sequence of events included Other weather encounter.

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 year(c.\"eventDate\") = 2019
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 CEN19LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Cloud, MNThe pilot's failure to maintain directional control during a crosswind landing. Contributing to the accident was the pilot’s decision to land in crosswind conditions given his lack of recent experience in those conditions.Apr 20, 2019 · N40956 · Substantial damageNTSB GAA19CA216Accident · No injuriesData collectionFinal reportBell 47G · Donna, TXThe pilot's failure to maintain altitude during an agricultural application flight.Apr 17, 2019 · N96671 · Substantial damageNTSB GAA19CA212Accident · Minor injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe pilot's failure to maintain lateral control during landing and his exceedance of the airplane’s critical angle of attack during the subsequent aborted landing, which resulted in an aerodynamic stall.Apr 17, 2019 · N425PA · Substantial damageNTSB GAA19CA202Accident · Minor injuriesData collectionFinal reportPiper PA 12 · Sisters, ORThe pilot's failure to maintain pitch control during the landing roll, which resulted in a nose-over.Apr 10, 2019 · N92798 · Substantial damageNTSB GAA19CA195Accident · No injuriesData collectionFinal reportRobinson R44 · Taunton, MAThe pilot's improper decision to land with a gusting left quartering tailwind and his subsequent attempt to reposition the helicopter and take off, which resulted in a dynamic rollover.Apr 2, 2019 · N344R · Substantial damageNTSB WPR19LA104Accident · Serious injuriesClass 3 · LimitedFinal reportCameron A-400 · Yountville, CAThe pilot’s inability to maintain obstacle clearance after the balloon’s encounter with a downdraft, which resulted in a collision with power lines.Apr 1, 2019 · N6954Y · No damageNTSB CEN19LA107Accident · Serious injuriesLimited investigationFinal reportCessna R172E · Loveland, COAn inflight loss of control on landing approach due to encountering a down-draft, and the pilot's failure to take timely action to abandon the approach and perform a go-around.Mar 23, 2019 · N7879N · Substantial damageNTSB GAA19CA173Accident · Minor injuriesData collectionFinal reportPereira Osprey · Independence, IAThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Mar 15, 2019 · N822GC · Substantial damageNTSB GAA19CA163Accident · No injuriesData collectionFinal reportAir Tractor AT 400A · Parma, IDThe pilot's failure to maintain directional control during landing in variable wind conditions, which resulted in the right wing impacting muddy terrain.Mar 11, 2019 · N400DQ · Substantial damageNTSB ERA19FA112Accident · 1 fatalClass 3 · FieldFinal reportPiper PA25 · Fort Lauderdale, FLThe pilot’s failure to maintain proper altitude and clearance while maneuvering during a banner tow flight, which resulted in an in-flight collision with a 19-story building in a heavily congested area. Contributing to the accident were the easterly wind…Mar 1, 2019 · N145AB · DestroyedNTSB GAA19CA154Accident · No injuriesData collectionFinal reportDenney Kitfox MDL Classiciv · Floodwood, MNThe pilot's loss of lateral control while landing in gusting crosswind conditions, which resulted in a nose-over.Feb 28, 2019 · N111YT · Substantial damageNTSB ERA19TA110Accident · Serious injuriesClass 3Final reportSikorsky HH-60L · Tullahoma, TNThe flight crew’s improper decision to continue the VFR flight into deteriorating weather conditions, which resulted in a collision with trees during a subsequent precautionary landing attempt.Feb 28, 2019 · N260MW · Substantial damageNTSB GAA19CA148Accident · No injuriesData collectionFinal reportCessna 172 · Bellingham, WAThe pilot's improper crosswind correction during taxi operations in gusting crosswind conditions.Feb 25, 2019 · CFHGQ · Substantial damageNTSB GAA19CA149Accident · No injuriesData collectionFinal reportZenair Zenith Stol CH 701 · Springfield, ILThe pilot's improper crosswind correction during taxi operations in gusting crosswind conditions.Feb 24, 2019 · N8436S · Substantial damageNTSB GAA19CA146Accident · No injuriesData collectionFinal reportCessna 182 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll with a gusting tailwind, which resulted in a runway excursion and collision with runway lights and taxiway signage.Feb 22, 2019 · N8644T · Substantial damageNTSB GAA19CA140Accident · No injuriesData collectionFinal reportPiper PA24 · Slaton, TXThe student pilot's complacency, which led to his improper crosswind correction and subsequent failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground collision.Feb 12, 2019 · N9184P · Substantial damageNTSB GAA19CA133Accident · No injuriesData collectionFinal reportDenney Kitfox IV Speedster · Page, AZThe pilot's failure to maintain lateral control during the landing flare, which resulted in the left wing striking a tree.Feb 8, 2019 · N995BW · Substantial damageNTSB GAA19CA109Accident · No injuriesData collectionFinal reportBeech B19 · Los Angeles, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with a fence.Jan 26, 2019 · N24682 · Substantial damageNTSB WPR19FA077Accident · 1 fatalClass 2 · FieldFinal reportRockwell 112 · Mt Hood, ORThe pilot's decision to fly the airplane in close proximity to mountainous terrain in an area of mountain wave activity that exceeded the performance capabilities of the airplane. Contributing to the accident was the pilot's degraded decision making and…Jan 25, 2019 · N1332J · DestroyedNTSB WPR19CA067Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Chino, CAThe pilot's loss of directional control while landing, which resulted in a ground loop.Jan 19, 2019 · N11852 · Substantial damageNTSB WPR19CA069Accident · No injuriesData collectionFinal reportChampion 7GCBC · Townsend, MTThe pilot's failure to maintain airplane control during a precautionary landing on an uneven, soft surface.Jan 16, 2019 · N822TT · Substantial damage