OpenAirDocs.org

NTSB investigations, 2017, MA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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

Where

Open the map

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\") = 2017
    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 GAA18CA071Accident · No injuriesData collectionFinal reportCessna 402 · Hyannis, MAEncounter with a flock of birds during takeoff at night, resulting in multiple bird strikes and structural damage.Dec 4, 2017 · N2748Y · Substantial damageNTSB GAA18CA065Accident · No injuriesData collectionFinal reportAveko Sro VL-3C-1 · Northampton, MAThe pilot’s improper landing flare, which resulted in a loss of directional control and subsequent impact with approach lighting.Nov 24, 2017 · N876MB · Substantial damageNTSB ERA18LA023Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1A · Montague, MAThe pilot’s failure to maintain directional control during the attempted takeoff, which resulted in a runway excursion.Nov 2, 2017 · N3512L · Substantial damageNTSB GAA17CA557Accident · Minor injuriesData collectionFinal reportBellet James J Vans RV 8 · Orange, MAThe pilot's failure to remove the engine cowl plugs during preflight, which resulted in excessive engine cylinder head temperatures during climb and a total loss of engine power.Sep 26, 2017 · N184SJ · Substantial damageNTSB ERA17LA329Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Nantucket, MAThe separation of the pushrod from the elevator trim tab actuator, which rendered controlled flight impossible. Contributing to the separation of the pushrod was the failure of maintenance personnel to properly secure it to the elevator trim tab actuator.Sep 13, 2017 · N836GW · Substantial damageNTSB GAA17CA429Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Edgartown, MAThe airplane’s collision with geese during the takeoff roll.Jul 23, 2017 · N831SR · Substantial damageNTSB GAA17CA326Accident · No injuriesData collectionFinal reportCessna 150 · Newburyport, MAThe student pilot's decision to attempt to close the cockpit window during takeoff and his subsequent failure to maintain directional control.Jun 4, 2017 · N6511S · Substantial damageNTSB DCA17CA111Accident · Serious injuriesData collectionFinal reportAirbus A320 232 · Boston, MAan inadvertent encounter with convective turbulence.May 2, 2017 · N595JB · No damageNTSB ERA17FA117Accident · 1 fatalField investigationFinal reportLavender Alan P Sonex · Methuen, MAThe pilot's failure to properly secure oil and fuel line fittings during maintenance, which resulted in an inflight engine fire, and his subsequent loss of control while maneuvering for landing. Contributing to the accident was the pilot's diverted attention…Feb 28, 2017 · N315AL · 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 damage