OpenAirDocs.org

NTSB investigations, MA

344 cases where the phase of flight was Approach.

Cases per year

19642026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 500)
  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 CEN26FA257Accident · 1 fatalClass 3 · FieldPreliminary reportDakota Cub Super 18 · Plymouth, MAOn July 16, 2026, about 0740 eastern daylight time, a Dakota Cub Super 18 airplane, N84AJ, was substantially damaged when it was involved in an accident near Plymouth, Massachusetts. The pilot was fatally injured. The airplane operated under the provisions of…Jul 16, 2026 · N84AJ · Substantial damageNTSB DCA26LA242Incident · No injuriesClass 3 · LimitedPreliminary reportAirbus Industrie A319-114 · Boston, MAOn June 20, 2026, about 1134 eastern daylight time (EDT), Delta Air Lines flight 2351 (DAL2351), an Airbus A319, and American Airlines flight 3161 (AAL3161), a Boeing 737-800, were involved in a runway incursion that resulted in a go-around of DAL2351 at…Jun 20, 2026 · N328NB · 2 aircraft · No damageNTSB ERA25LA100Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Orange, MAFailure of the left main landing gear to fully extend and lock for undetermined reasons as a functional test of the landing gear system could not duplicate the anomaly.Jan 12, 2025 · N8BZ · Substantial damageNTSB ERA23LA373Accident · No injuriesClass 3 · LimitedFinal reportLiore et Oliver Nieuport 28 · Hudson, MAA total loss of engine power for undetermined reasons.Sep 17, 2023 · SE-BMA · Substantial damageNTSB ERA23LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Norwood, MAThe pilot’s failure to fly an appropriate glide path during the landing approach, which resulted in a collision with approach lights and the ground short of the intended runway.Sep 7, 2023 · N400RW · Substantial damageNTSB ERA23LA300Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA46 · Vineyard Haven, MAThe pilot’s incapacitation due to a sudden in-flight cardiac event, which resulted in a gear-up landing.Jul 15, 2023 · N444RR · Substantial damageNTSB ERA23FA077Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Falmouth, MAThe pilot’s failure to maintain clearance from trees during the landing approach. Contributing to the accident was the sun glare, which impaired the pilot's visibility and situational awareness.Dec 2, 2022 · N3515H · Substantial damageNTSB ERA22LA425Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Great Barrington, MAThe student pilot's inadvertent movement of the fuel selector to the OFF position, which resulted in fuel starvation and a total loss of engine power.Sep 18, 2022 · N6076D · Substantial damageNTSB ERA21LA266Accident · Minor injuriesClass 4 · LimitedFinal reportPilatus B4-PC11 · Sterling, MAThe pilot’s misjudged approach angle which resulted in impact with trees and terrain.May 20, 2021 · N65317 · Substantial damageNTSB ERA21LA196Accident · No injuriesClass 4 · LimitedFinal reportCessna 402C · Hyannis, MAThe flight instructor’s failure to confirm the position of the left engine’s auxiliary fuel boost pump switch during a simulated engine out procedure, which resulted in an excess amount of fuel in the engine and subsequent partial loss of power during a…Apr 26, 2021 · N2714B · Substantial damageNTSB ERA21LA122Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA46 · Leicester, MAThe pilot’s failure to maintain the minimum airspeed for flight in icing conditions, which resulted in a loss of elevator control during approach due to ice accumulation.Feb 2, 2021 · N221ST · Substantial damageNTSB ERA20CA111Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Hanson, MAThe flight instructor's delayed remedial action, which resulted in his decision to perform an off field landing and the airplane's subsequent impact with terrain.Dec 23, 2019 · N5792U · Substantial damageNTSB ERA19TA278Accident · No injuriesClass 3Final reportCessna 208 · Pepperell, MAThe pilot's loss of control when the airplane encountered a downdraft during landing approach, which resulted in a subsequent hard landing and gear collapse.Sep 20, 2019 · N895SF · Substantial damageNTSB GAA19CA401Accident · No injuriesData collectionFinal reportCessna 172 · Vineyard Haven, MAThe pilot's failure to maintain lateral position in relation to the instrument approach course at night in instrument meteorological conditions, which resulted in collision with a tree.Jul 11, 2019 · N677DM · Substantial damageNTSB ERA18FA251Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 · Woburn, MAThe pilots' loss of control during an instrument approach in instrument meteorological conditions as a result of spatial disorientation.Sep 15, 2018 · N2536T · DestroyedNTSB 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 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 ERA16LA258Accident · 1 fatalLimited investigationFinal reportPiper PA24 · Westwood, MAThe pilot's improper fuel management, which resulted in exhaustion of the fuel in the selected fuel tank and a total loss of engine power due to fuel starvation.Jul 16, 2016 · N11MT · Substantial damageNTSB ERA15CA101Accident · No injuriesData collectionFinal reportCessna 150L · Stow, MAThe flight instructor's delayed remedial action in response to the student pilot's improper go-around, which resulted in the airplane exceeding its critical angle of attack, experiencing an aerodynamic stall, and impacting a parked airplane.Jan 15, 2015 · N5443Q · 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 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 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 damageNTSB ERA13CA355Accident · No injuriesData collectionFinal reportBeech 58 · New Bedford, MAThe pilot's improper decision to land in the displaced threshold, resulting in a collision with the approach lighting system.Jul 31, 2013 · N58DL · Substantial damageNTSB ERA12LA279Accident · Minor injuriesLimited investigationFinal reportStanley B E Murphy Rebel · Falmouth, MAThe pilot's delayed application of carburetor heat, which resulted in a loss of engine power.Apr 13, 2012 · N24V · Substantial damageNTSB ERA12IA090Incident · No injuriesIncident investigationFinal reportCessna 402B · Nantucket, MAThe failure of the right main fuel tank transfer pump, which resulted in a total loss of engine power on the right engine during approach due to fuel starvation, and a subsequent hard landing. Contributing to the incident was the pilot's operation of the…Nov 29, 2011 · N303PJ · Minor damageNTSB ERA11LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Vineyard Haven, MAThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Mar 20, 2011 · N2027M · Substantial damageNTSB ERA11FA102Accident · 1 fatalField investigationFinal reportCessna 310F · Orange, MAThe pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.Jan 1, 2011 · N6725X · Substantial damageNTSB ERA11IA091Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Boston, MAImproper installation of wiring associated with a medical cabinet interior, which resulted in chafing and a subsequent in-flight fire. Contributing to the incident was inadequate maintenance procedures for continued airworthiness.Dec 4, 2010 · N271NE · Minor damageNTSB ERA11LA050Accident · 1 fatalLimited investigationFinal reportNorth American/Schwamm AT-6F · Fitchburg, MAA total loss of engine power due to a cracked carburetor float and resulting carburetor malfunction.Nov 6, 2010 · N164US · Substantial damageNTSB ERA10CA337Accident · Serious injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's attempted visual flight into night instrument meteorological conditions, which resulted in spatial disorientation and subsequent controlled flight into terrain.Jun 28, 2010 · N30062 · Substantial damageNTSB ERA10LA317Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAA total loss of engine power during final approach due to fuel starvation as a result of the pilot’s delayed configuration of the airplane for landing.Jun 18, 2010 · N401TE · Substantial damageNTSB ERA10CA289Accident · No injuriesData collectionFinal reportCessna 172N · Sterling, MAThe pilot’s decision to not continue with the go-around, which resulted in a collision with trees. Contributing to the accident was the pilot’s distraction due to the passenger’s panicked condition.May 31, 2010 · N6371D · Substantial damageNTSB MIA08FA163Accident · 3 fatalField investigationFinal reportBeech G35 · South Easton, MAThe pilot's failure to maintain control of the airplane while attempting to execute an instrument approach in instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument currency.Aug 12, 2008 · N4615D · DestroyedNTSB 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 damageNTSB MIA08CA017Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Hyannis, MAThe student pilot's mismanagement of the fuel supply and the flight instructor's inadequate supervision.Nov 14, 2007 · N9610W · Substantial damageNTSB NYC07FA130Accident · 1 fatalField investigationFinal reportMooney M20J · Canton, MAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.Jun 4, 2007 · N4126H · Substantial damageNTSB MIA07LA092Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Marstons Mill, MAThe pilot's improper preflight planning and preparation resulting in an in-flight loss of engine power due to fuel exhaustion.May 5, 2007 · N403RA · Substantial damageNTSB NYC07CA090Accident · Serious injuriesData collectionFinal reportNavion A · Marlboro, MAThe pilot's failure to maintain a proper glidepath to the runway.Mar 31, 2007 · N4047K · Substantial damageNTSB NYC07LA081Accident · No injuriesLimited investigationFinal reportCessna 500 · Beverly, MAThe inadequate guidance and procedures provided by the airplane manufacturer regarding operation of the pneumatic de-icing boots. Also causal was the Federal Aviation Administration's inadequate directives which failed to require manufacturers to direct…Mar 17, 2007 · N511AT · Substantial damageNTSB NYC07FA065Accident · 3 fatalField investigationFinal reportSocata TBM 700 · Dartmouth, MABoth pilots' failure to maintain aircraft control during a missed approach.Feb 3, 2007 · N944CA · DestroyedNTSB NYC06IA143Incident · No injuriesIncident investigationFinal reportCessna 172S · Lawrence, MAForeign object damage to the leading edge of the propeller blade, which resulted in fatigue cracking and subsequent blade failure.Jun 6, 2006 · N2138W · Minor damageNTSB NYC06FA040Accident · 1 fatalField investigationFinal reportBeech B-55 · Nantucket, MAThe pilot's failure to maintain the proper glidepath during the instrument approach, which resulted in controlled flight into water. Factors were the failure of the air traffic controllers to issue minimum safe altitude warnings, night lighting conditions,…Dec 1, 2005 · N64PW · DestroyedNTSB NYC05LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Edgartown, MAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall and subsequent impact with terrain. [This report was modified on June 10, 2008]Jun 23, 2005 · N5118D · Substantial damageNTSB IAD05LA005Accident · No injuriesLimited investigationFinal reportBeech C24R · Hyannis, MAThe mechanic's failure to secure the fuel pressure line to the fuel pressure gauge fitting, which resulted in an engine compartment fire and a subsequent loss of engine power.Oct 15, 2004 · N6598C · Substantial damageNTSB NYC04LA191Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Edgartown, MAThe pilot's failure to maintain airspeed while performing maneuvers to land, which resulted in an inadvertent stall/mush. A factor was the gusting wind conditions.Aug 12, 2004 · N231LK · Substantial damageNTSB NYC04FA136Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Leominster, MAThe pilot's failure to follow instrument flight procedures resulting in a collision with trees. A factor related to the accident was the low cloud ceiling, and dark night.Jun 2, 2004 · N21072 · DestroyedNTSB NYC04CA128Accident · Serious injuriesData collectionFinal reportCameron Balloons N90 · Whately, MAThe pilot's failure to maintain clearance from the trees. A factor was windshear.May 23, 2004 · N6123U · Minor damageNTSB NYC04LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Berkley, MAThe pilot's misjudgment of altitude/distance and his failure to maintain adequate clearance from trees while landing. Factors related to the accident were the lack runway displaced threshold markings, the trees located at the end of the runway, and the…Apr 19, 2004 · N9862D · Substantial damageNTSB NYC04LA014Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Athol, MAThe loss of power due to disengagement of the magneto idler gear. Also causal was the improper reinstallation of the magneto during the annual inspection.Oct 21, 2003 · N3419S · Substantial damageNTSB NYC03FA205Accident · 2 fatalField investigationFinal reportCessna 182T · Concord, MAThe pilot's failure to maintain aircraft control due to spatial disorientation. A factor was the low ceilings.Sep 27, 2003 · N963LP · Destroyed