NTSB investigations, MA

10 cases where NTSB found Gusts.

Cases per year

20082026
NTSB investigations, MA per year, 2008–2026: 10 cases
20081
20092
20131
20161
20192
20202
20221

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\" = 'MA' 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\", '03034045'))
  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 ERA22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Barnstable, MAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun in gusting wind conditions.Jul 27, 2022 · N7437G · Substantial damageNTSB ERA21LA013Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA18 · Plymouth, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering gusting headwind.Oct 8, 2020 · N8788D · Substantial damageNTSB ERA20CA142Accident · No injuriesData collectionFinal reportCirrus SR20 · Stow, MAThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and impact with vegetation.Mar 27, 2020 · N586C · Substantial damageNTSB GAA20CA041Accident · No injuriesData collectionFinal reportMaule MX7 · Nantucket, MAThe pilot's failure to maintain directional control during landing on a grass runway in gusting wind conditions, which resulted in impact with a large bush.Oct 21, 2019 · N1052T · 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 ERA16LA115Accident · Serious injuriesLimited investigationFinal reportBeech 95 C55 · Plymouth, MAThe pilot's failure to maintain control of the airplane during an aborted takeoff in gusting wind conditions.Feb 27, 2016 · N482S · Substantial damageNTSB ERA13CA210Accident · No injuriesData collectionFinal reportCessna 172N · Stow, MAThe pilot’s failure to maintain directional control while landing in gusty wind conditions.Apr 20, 2013 · N739CK · Substantial damageNTSB ERA09LA538Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Vineyard Haven, MAThe pilot's improper flare while landing in gusting wind, which resulted in a hard landing.Sep 27, 2009 · N190MP · Substantial damageNTSB ERA09CA251Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Southbridge, MAThe pilot's inadequate compensation for the gusting wind conditions.Apr 18, 2009 · N96552 · Substantial damageNTSB MIA08CA084Accident · No injuriesData collectionFinal reportGrumman American AA5B · Marlboro, MAThe pilot's inadequate compensation for wind gusts while on final approach.Mar 29, 2008 · N333FT · Substantial damage