NTSB investigations, 2014, MA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19632026
NTSB investigations, 2014, MA per year, 1963–2026: 2,104 cases
19633
196464
196578
196681
196771
196869
196956
197087
197163
197258
197372
197468
197572
197645
197751
197868
197934
198035
198143
198238
198341
198453
198538
198640
198754
198829
198925
199044
199126
199231
199331
199433
199521
199628
199721
199822
199921
200029
200123
200223
200322
200428
200518
200616
200719
200812
200914
201024
201118
201210
201310
201412
201510
201612
201710
20189
20199
20208
202110
202211
20236
20247
202510
202610

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 year(c.\"eventDate\") = 2014
    AND c.\"eventStateOrRegion\" = 'MA' AND c.\"eventCountry\" = 'USA'
  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 ERA15LA015Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Granville, MADeformation of the No. 1 cylinder's intake valve, which resulted in a partial loss of engine power and a subsequent off-airport precautionary landing.Oct 12, 2014 · N57SH · Substantial damageNTSB ERA14CA419Accident · No injuriesData collectionFinal reportDehavilland DHC 6 Twin Otter · Pepperell, MAAn inadvertent collision with a bird, which resulted in substantial damage to the left wing.Aug 23, 2014 · N202EH · Substantial damageNTSB ERA14CA400Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Stow, MAThe flight instructor/pilot's failure to recover from a bounced landing, which resulted in a hard landing and the subsequent collapse of the nose landing gear. Contributing to the accident was the flight instructor's lack of total experience in the make and…Aug 9, 2014 · N497PA · Substantial damageNTSB ERA14CA352Accident · No injuriesData collectionFinal reportCessna 172M · Chatham, MAThe pilot's failure to maintain directional control during takeoff, resulting in a runway excursion and collision with trees.Jul 22, 2014 · N1066R · Substantial damageNTSB 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 ERA14CA364Accident · No injuriesData collectionFinal reportCessna 177B · Falmouth, MAThe pilot's misjudgment of speed and distance on final approach resulting in a touchdown near the departure end of the runway, a runway excursion, and collision with trees.Jul 19, 2014 · N18509 · Substantial damageNTSB ERA14IA301Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Burlington, MAA loss of clamping load of the No. 5 cylinder crankcase through bolts due to maintenance personnel’s failure to properly torque the through bolts during recent maintenance, which resulted in displacement of the No. 2 bearing and the subsequent catastrophic…Jun 11, 2014 · N813JE · 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 ERA14LA248Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron Canada 206 L4 · Beverly, MAMaintenance personnel’s inadequate inspection of the engine’s outer combustion case, which resulted in the failure of the case due to fatigue cracks that initiated on the inside surface of the case and the subsequent total loss of engine power.May 21, 2014 · N55SL · Substantial damageNTSB DCA14CA093Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD90 - 30 · Boston, MAthe captain's failure to verify the communications between himself and the tug operator, which resulted in him applying of brakes while the airplane was being pushed back from the gate by the tug with tow bar attached.May 12, 2014 · N933DN · 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 ERA14CA124Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe student pilot's failure to maintain an adequate approach glide path, which resulted in a collision with a snow bank.Feb 15, 2014 · N2143X · Substantial damage