# NTSB investigations, MA: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 7 · 344 cases

## Latest cases

- [NTSB CEN26FA257](https://openairdocs.org/ntsb/CEN26FA257.md): Dakota Cub Super 18 · Plymouth, MA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 16, 2026 · N84AJ · Substantial damage
  > On 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…
- [NTSB DCA26LA242](https://openairdocs.org/ntsb/DCA26LA242.md): Airbus Industrie A319-114 · Boston, MA · Incident · No injuries · Class 3 · Limited · Preliminary report · Jun 20, 2026 · N328NB · 2 aircraft · No damage
  > On 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…
- [NTSB ERA25LA100](https://openairdocs.org/ntsb/ERA25LA100.md): Consolidated Aeronautics Lake LA-4-200 · Orange, MA · Accident · No injuries · Class 4 · Limited · Final report · Jan 12, 2025 · N8BZ · Substantial damage
  > Failure 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.
- [NTSB ERA23LA373](https://openairdocs.org/ntsb/ERA23LA373.md): Liore et Oliver Nieuport 28 · Hudson, MA · Accident · No injuries · Class 3 · Limited · Final report · Sep 17, 2023 · SE-BMA · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB ERA23LA364](https://openairdocs.org/ntsb/ERA23LA364.md): Piper PA24 · Norwood, MA · Accident · No injuries · Class 4 · Limited · Final report · Sep 7, 2023 · N400RW · Substantial damage
  > The 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.
- [NTSB ERA23LA300](https://openairdocs.org/ntsb/ERA23LA300.md): Piper PA46 · Vineyard Haven, MA · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 15, 2023 · N444RR · Substantial damage
  > The pilot’s incapacitation due to a sudden in-flight cardiac event, which resulted in a gear-up landing.
- [NTSB ERA23FA077](https://openairdocs.org/ntsb/ERA23FA077.md): Mooney M20J · Falmouth, MA · Accident · 1 fatal · Class 3 · Field · Final report · Dec 2, 2022 · N3515H · Substantial damage
  > The 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.
- [NTSB ERA22LA425](https://openairdocs.org/ntsb/ERA22LA425.md): Piper PA-22-150 · Great Barrington, MA · Accident · No injuries · Class 3 · Limited · Final report · Sep 18, 2022 · N6076D · Substantial damage
  > The 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.
- [NTSB ERA21LA266](https://openairdocs.org/ntsb/ERA21LA266.md): Pilatus B4-PC11 · Sterling, MA · Accident · Minor injuries · Class 4 · Limited · Final report · May 20, 2021 · N65317 · Substantial damage
  > The pilot’s misjudged approach angle which resulted in impact with trees and terrain.
- [NTSB ERA21LA196](https://openairdocs.org/ntsb/ERA21LA196.md): Cessna 402C · Hyannis, MA · Accident · No injuries · Class 4 · Limited · Final report · Apr 26, 2021 · N2714B · Substantial damage
  > The 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…
- [NTSB ERA21LA122](https://openairdocs.org/ntsb/ERA21LA122.md): Piper PA46 · Leicester, MA · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 2, 2021 · N221ST · Substantial damage
  > The 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.
- [NTSB ERA20CA111](https://openairdocs.org/ntsb/ERA20CA111.md): Piper PA28 · Hanson, MA · Accident · No injuries · Class 4 · Data collection · Final report · Dec 23, 2019 · N5792U · Substantial damage
  > The 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.
- [NTSB ERA19TA278](https://openairdocs.org/ntsb/ERA19TA278.md): Cessna 208 · Pepperell, MA · Accident · No injuries · Class 3 · Final report · Sep 20, 2019 · N895SF · Substantial damage
  > The pilot's loss of control when the airplane encountered a downdraft during landing approach, which resulted in a subsequent hard landing and gear collapse.
- [NTSB GAA19CA401](https://openairdocs.org/ntsb/GAA19CA401.md): Cessna 172 · Vineyard Haven, MA · Accident · No injuries · Data collection · Final report · Jul 11, 2019 · N677DM · Substantial damage
  > The 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.
- [NTSB ERA18FA251](https://openairdocs.org/ntsb/ERA18FA251.md): Columbia Aircraft Mfg LC41 · Woburn, MA · Accident · 2 fatal · Field investigation · Final report · Sep 15, 2018 · N2536T · Destroyed
  > The pilots' loss of control during an instrument approach in instrument meteorological conditions as a result of spatial disorientation.
- [NTSB GAA17CA557](https://openairdocs.org/ntsb/GAA17CA557.md): Bellet James J Vans RV 8 · Orange, MA · Accident · Minor injuries · Data collection · Final report · Sep 26, 2017 · N184SJ · Substantial damage
  > The 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.
- [NTSB ERA17FA117](https://openairdocs.org/ntsb/ERA17FA117.md): Lavender Alan P Sonex · Methuen, MA · Accident · 1 fatal · Field investigation · Final report · Feb 28, 2017 · N315AL · Substantial damage
  > The 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…
- [NTSB ERA16LA258](https://openairdocs.org/ntsb/ERA16LA258.md): Piper PA24 · Westwood, MA · Accident · 1 fatal · Limited investigation · Final report · Jul 16, 2016 · N11MT · Substantial damage
  > The 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.
- [NTSB ERA15CA101](https://openairdocs.org/ntsb/ERA15CA101.md): Cessna 150L · Stow, MA · Accident · No injuries · Data collection · Final report · Jan 15, 2015 · N5443Q · Substantial damage
  > The 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.
- [NTSB ERA14LA347](https://openairdocs.org/ntsb/ERA14LA347.md): Colt Balloons 160A · Clinton, MA · Accident · Serious injuries · Limited investigation · Final report · Jul 20, 2014 · N976TC · Minor damage
  > The 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…
- [NTSB ERA14IA301](https://openairdocs.org/ntsb/ERA14IA301.md): Cirrus Design SR22 · Burlington, MA · Incident · No injuries · Incident investigation · Final report · Jun 11, 2014 · N813JE · Minor damage
  > A 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…
- [NTSB ERA14CA124](https://openairdocs.org/ntsb/ERA14CA124.md): Cessna 172S · Mansfield, MA · Accident · No injuries · Data collection · Final report · Feb 15, 2014 · N2143X · Substantial damage
  > The student pilot's failure to maintain an adequate approach glide path, which resulted in a collision with a snow bank.
- [NTSB ERA13CA355](https://openairdocs.org/ntsb/ERA13CA355.md): Beech 58 · New Bedford, MA · Accident · No injuries · Data collection · Final report · Jul 31, 2013 · N58DL · Substantial damage
  > The pilot's improper decision to land in the displaced threshold, resulting in a collision with the approach lighting system.
- [NTSB ERA12LA279](https://openairdocs.org/ntsb/ERA12LA279.md): Stanley B E Murphy Rebel · Falmouth, MA · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 2012 · N24V · Substantial damage
  > The pilot's delayed application of carburetor heat, which resulted in a loss of engine power.
- [NTSB ERA12IA090](https://openairdocs.org/ntsb/ERA12IA090.md): Cessna 402B · Nantucket, MA · Incident · No injuries · Incident investigation · Final report · Nov 29, 2011 · N303PJ · Minor damage
  > The 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…
- [NTSB ERA11LA198](https://openairdocs.org/ntsb/ERA11LA198.md): Piper PA-32R-300 · Vineyard Haven, MA · Accident · Minor injuries · Limited investigation · Final report · Mar 20, 2011 · N2027M · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA11FA102](https://openairdocs.org/ntsb/ERA11FA102.md): Cessna 310F · Orange, MA · Accident · 1 fatal · Field investigation · Final report · Jan 1, 2011 · N6725X · Substantial damage
  > The 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.
- [NTSB ERA11IA091](https://openairdocs.org/ntsb/ERA11IA091.md): Eurocopter Deutschland MBB-BK 117 C-1 · Boston, MA · Incident · No injuries · Incident investigation · Final report · Dec 4, 2010 · N271NE · Minor damage
  > Improper 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.
- [NTSB ERA11LA050](https://openairdocs.org/ntsb/ERA11LA050.md): North American/Schwamm AT-6F · Fitchburg, MA · Accident · 1 fatal · Limited investigation · Final report · Nov 6, 2010 · N164US · Substantial damage
  > A total loss of engine power due to a cracked carburetor float and resulting carburetor malfunction.
- [NTSB ERA10CA337](https://openairdocs.org/ntsb/ERA10CA337.md): Piper PA-28-181 · Great Barrington, MA · Accident · Serious injuries · Data collection · Final report · Jun 28, 2010 · N30062 · Substantial damage
  > The pilot's attempted visual flight into night instrument meteorological conditions, which resulted in spatial disorientation and subsequent controlled flight into terrain.
- [NTSB ERA10LA317](https://openairdocs.org/ntsb/ERA10LA317.md): Cessna 401 · Plymouth, MA · Accident · Serious injuries · Limited investigation · Final report · Jun 18, 2010 · N401TE · Substantial damage
  > A 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.
- [NTSB ERA10CA289](https://openairdocs.org/ntsb/ERA10CA289.md): Cessna 172N · Sterling, MA · Accident · No injuries · Data collection · Final report · May 31, 2010 · N6371D · Substantial damage
  > The 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.
- [NTSB MIA08FA163](https://openairdocs.org/ntsb/MIA08FA163.md): Beech G35 · South Easton, MA · Accident · 3 fatal · Field investigation · Final report · Aug 12, 2008 · N4615D · Destroyed
  > The 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.
- [NTSB MIA08CA084](https://openairdocs.org/ntsb/MIA08CA084.md): Grumman American AA5B · Marlboro, MA · Accident · No injuries · Data collection · Final report · Mar 29, 2008 · N333FT · Substantial damage
  > The pilot's inadequate compensation for wind gusts while on final approach.
- [NTSB MIA08CA017](https://openairdocs.org/ntsb/MIA08CA017.md): Piper PA-28-140 · Hyannis, MA · Accident · No injuries · Data collection · Final report · Nov 14, 2007 · N9610W · Substantial damage
  > The student pilot's mismanagement of the fuel supply and the flight instructor's inadequate supervision.
- [NTSB NYC07FA130](https://openairdocs.org/ntsb/NYC07FA130.md): Mooney M20J · Canton, MA · Accident · 1 fatal · Field investigation · Final report · Jun 4, 2007 · N4126H · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.
- [NTSB MIA07LA092](https://openairdocs.org/ntsb/MIA07LA092.md): Cessna 182A · Marstons Mill, MA · Accident · Serious injuries · Limited investigation · Final report · May 5, 2007 · N403RA · Substantial damage
  > The pilot's improper preflight planning and preparation resulting in an in-flight loss of engine power due to fuel exhaustion.
- [NTSB NYC07CA090](https://openairdocs.org/ntsb/NYC07CA090.md): Navion A · Marlboro, MA · Accident · Serious injuries · Data collection · Final report · Mar 31, 2007 · N4047K · Substantial damage
  > The pilot's failure to maintain a proper glidepath to the runway.
- [NTSB NYC07LA081](https://openairdocs.org/ntsb/NYC07LA081.md): Cessna 500 · Beverly, MA · Accident · No injuries · Limited investigation · Final report · Mar 17, 2007 · N511AT · Substantial damage
  > The 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…
- [NTSB NYC07FA065](https://openairdocs.org/ntsb/NYC07FA065.md): Socata TBM 700 · Dartmouth, MA · Accident · 3 fatal · Field investigation · Final report · Feb 3, 2007 · N944CA · Destroyed
  > Both pilots' failure to maintain aircraft control during a missed approach.
- [NTSB NYC06IA143](https://openairdocs.org/ntsb/NYC06IA143.md): Cessna 172S · Lawrence, MA · Incident · No injuries · Incident investigation · Final report · Jun 6, 2006 · N2138W · Minor damage
  > Foreign object damage to the leading edge of the propeller blade, which resulted in fatigue cracking and subsequent blade failure.
- [NTSB NYC06FA040](https://openairdocs.org/ntsb/NYC06FA040.md): Beech B-55 · Nantucket, MA · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2005 · N64PW · Destroyed
  > The 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,…
- [NTSB NYC05LA106](https://openairdocs.org/ntsb/NYC05LA106.md): Cessna 172N · Edgartown, MA · Accident · Serious injuries · Limited investigation · Final report · Jun 23, 2005 · N5118D · Substantial damage
  > The 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]
- [NTSB IAD05LA005](https://openairdocs.org/ntsb/IAD05LA005.md): Beech C24R · Hyannis, MA · Accident · No injuries · Limited investigation · Final report · Oct 15, 2004 · N6598C · Substantial damage
  > The 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.
- [NTSB NYC04LA191](https://openairdocs.org/ntsb/NYC04LA191.md): Mooney M20K · Edgartown, MA · Accident · Minor injuries · Limited investigation · Final report · Aug 12, 2004 · N231LK · Substantial damage
  > The 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.
- [NTSB NYC04FA136](https://openairdocs.org/ntsb/NYC04FA136.md): Piper PA-32-300 · Leominster, MA · Accident · 2 fatal · Field investigation · Final report · Jun 2, 2004 · N21072 · Destroyed
  > The 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.
- [NTSB NYC04CA128](https://openairdocs.org/ntsb/NYC04CA128.md): Cameron Balloons N90 · Whately, MA · Accident · Serious injuries · Data collection · Final report · May 23, 2004 · N6123U · Minor damage
  > The pilot's failure to maintain clearance from the trees. A factor was windshear.
- [NTSB NYC04LA109](https://openairdocs.org/ntsb/NYC04LA109.md): Piper PA-18-150 · Berkley, MA · Accident · Serious injuries · Limited investigation · Final report · Apr 19, 2004 · N9862D · Substantial damage
  > The 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…
- [NTSB NYC04LA014](https://openairdocs.org/ntsb/NYC04LA014.md): Cessna 182G · Athol, MA · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 2003 · N3419S · Substantial damage
  > The loss of power due to disengagement of the magneto idler gear. Also causal was the improper reinstallation of the magneto during the annual inspection.
- [NTSB NYC03FA205](https://openairdocs.org/ntsb/NYC03FA205.md): Cessna 182T · Concord, MA · Accident · 2 fatal · Field investigation · Final report · Sep 27, 2003 · N963LP · Destroyed
  > The pilot's failure to maintain aircraft control due to spatial disorientation. A factor was the low ceilings.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=MA&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=MA

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.