NTSB investigations, MA

10 cases where NTSB found Terrain.

Cases per year

20082026
NTSB investigations, MA per year, 2008–2026: 10 cases
20082
20091
20121
20141
20161
20171
20181
20211
20241

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\", '030210'))
  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 ERA24LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Sterling, MAThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop and subsequent landing gear collapse. Contributing was the flight instructor’s delayed remedial action.Aug 25, 2024 · N5673B · Substantial damageNTSB ERA22LA043Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-236 · Orleans, MAThe pilot’s spatial disorientation and subsequent loss of airplane control while maneuvering over water in dark night conditions.Oct 31, 2021 · N2186U · DestroyedNTSB ERA18TA236Accident · No injuriesFinal reportCessna 182 · Hanson, MAThe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun. Contributing to the accident was the pilot's decision to land with a quartering tailwind.Aug 27, 2018 · N3115R · Substantial damageNTSB GAA17CA156Accident · No injuriesData collectionFinal reportCessna 120 · Orange, MAThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.Feb 24, 2017 · N77116 · Substantial damageNTSB GAA16CA515Accident · Serious injuriesData collectionFinal reportCessna 172 · Pittsfield, MAThe student pilot’s failure to maintain an appropriate descent rate and runway alignment during the landing flare, which resulted in the airplane touching down left of the runway and impacting a ditch.Sep 25, 2016 · N73101 · Substantial damageNTSB ERA14CA139Accident · No injuriesData collectionFinal reportPiper PA 11S · Marlboro, MAThe pilot's loss of directional control during the landing rollout in crosswinds, resulting in a runway excursion and subsequent impact with a snow bank.Mar 1, 2014 · N5556H · Substantial damageNTSB ERA12CA377Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1B · Lawrence, MAThe pilot's delayed decision to abort the takeoff, which resulted in a runway excursion.May 31, 2012 · N1608R · Substantial damageNTSB ERA09CA277Accident · No injuriesData collectionFinal reportPiper PA-30 · Great Barrington, MAThe pilot's improper decision to land with a tailwind.Apr 30, 2009 · N8034Y · Substantial damageNTSB MIA08CA071Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Norwood, MAThe failure of the flightcrew to maintain directional control of the airplane.Mar 2, 2008 · N9182A · Substantial damageNTSB MIA08LA041Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Norwood, MAThe loss of engine power for undetermined reasons. *This report was modified on May 20, 2008.*Jan 17, 2008 · N414DJ · Substantial damage