NTSB investigations, MA

7 cases where NTSB found Organizational issues.

Cases per year

20082026
NTSB investigations, MA per year, 2008–2026: 7 cases
20081
20091
20101
20121
20131
20142

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\", '04'))
  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 ERA14LA347Accident · Serious injuriesLimited investigationFinal reportColt Balloons 160A · Clinton, MAThe pilot's inadequate preflight and inflight planning and improper landing site selection and approach path, which resulted in the balloon contacting powerlines during landing. Contributing to the accident was the Federal Aviation Administration's inadequate…Jul 20, 2014 · N976TC · Minor damageNTSB ERA14MA271Accident · 7 fatalClass 1 · MajorFinal reportGulfstream Aerospace G IV · Bedford, MAThe flight crewmembers' failure to perform the flight control check before takeoff, their attempt to take off with the gust lock system engaged, and their delayed execution of a rejected takeoff after they became aware that the controls were locked.…Jun 1, 2014 · N121JM · DestroyedNTSB DCA13IA037Incident · No injuriesClass 1 · IncidentFinal reportBoeing 787 · Boston, MAan internal short circuit within a cell of the auxiliary power unit (APU) lithium-ion battery, which led to thermal runaway that cascaded to adjacent cells, resulting in the release of smoke and fire. The incident resulted from Boeing's failure to incorporate…Jan 7, 2013 · JA829J · Minor damageNTSB ERA12IA550Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MACompany maintenance personnel’s failure to comply with the airplane manufacturer’s service instructions by not removing the cracked drag brace from service nor inspecting the repaired drag brace at the appropriate interval, which resulted in the failure of…Aug 31, 2012 · N769EA · Minor damageNTSB ERA10FA283Accident · 1 fatalField investigationFinal reportSchweizer 269C-1 · Boxborough, MAThe FAA inspector's rapid reduction of power which resulted in a loss of engine power and his decision to initiate a turn during the autorotation without sufficient altitude to clear obstacles. Contributing to the accident was the FAA’s lack of comprehensive…May 26, 2010 · N73SJ · Substantial damageNTSB ERA09LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe CFI's inadequate preflight planning and delay to abort the takeoff from the soft takeoff area.Jun 20, 2009 · N29496 · Substantial damageNTSB NYC08FA218Accident · 1 fatalField investigationFinal reportDehavilland DHC6 · Hyannis, MAThe pilot's failure to remove the flight control lock prior to takeoff. Contributing to the accident was the Federal Aviation Administration's failure to issue an airworthiness directive making the manufacturer's previously-issued flight control lock service…Jun 18, 2008 · N656WA · Substantial damage