NTSB investigations, MA

328 cases where the phase of flight was Enroute.

Cases, newest first

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 = 400)
  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 NYC99FA222Accident · 2 fatalField investigationFinal reportCessna 337C · North Adams, MAthe failure of the pilot of the Cessna 305 to follow the instructions issued, and maintain a low altitude. A factor was the delay in evasive action by the pilot of the Cessna 337 after he was first advised that the Cessna 305 was climbing.Sep 12, 1999 · N973FS · 2 aircraft · DestroyedNTSB NYC99MA178Accident · 3 fatalMajor investigationFinal reportPiper PA-32R-301 · Vineyard Haven, MAThe pilot's failure to maintain control of the airplane during a descent over water at night, which was a result of spatial disorientation. Factors in the accident were haze, and the dark night.Jul 17, 1999 · N9253N · DestroyedNTSB NYC99FA026Accident · 1 fatalField investigationFinal reportCessna 414A · Mattapoisett, MAThe pilot's failure to maintain control of the airplane after an undetermined failure of the airplane's attitude indicator. A factor in this accident was fog.Nov 20, 1998 · N6820J · DestroyedNTSB NYC98FA161Accident · 2 fatalField investigationFinal reportCessna 150M · Worthington, MAThe pilot's failure to maintain airspeed due to diverted attention.Aug 2, 1998 · N704ZY · DestroyedNTSB NYC98FA124Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Dalton, MAThe pilot's decision to continue the flight into instrument meteorological conditions, resulting in a loss of control, and airplane stress limits to be exceeded. Factors in the accident, the pilot's decision to disregard the preflight weather briefing, and…Jun 3, 1998 · N75137 · DestroyedNTSB NYC98LA089Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Berkley, MAloss of engine power for undetermined reason(s), which resulted in a forced landing and subsequent nose-over on uneven terrain. Uneven terrain (furrow) in the forced landing area was a related factor.Apr 5, 1998 · N4158Z · Substantial damageNTSB IAD98LA034Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Haverhill, MAA loss of engine power due to a fractured number two cylinder exhaust valve and cracked cylinder. Contributing factors were the operator's allowance of the time between engine overhaul to be exceeded and the trees.Mar 4, 1998 · N63387 · DestroyedNTSB NYC98LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittsfield, MAThe pilot's poor in-flight decision to continue VFR flight in IFR conditions. Factor's in this accident were the pilot's inadequate pre-flight planning, and fog.Oct 14, 1997 · N62264 · Substantial damageNTSB NYC98LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Gt. Barrington, MAslippage of the number 2 main bearing for undetermined reason(s) which resulted in a broken crankshaft.Oct 1, 1997 · N29134 · Substantial damageNTSB IAD97FA123Accident · 1 fatalField investigationFinal reportFairchild Hiller FH-1100 · Pittsfield, MAThe first pilot's improper procedures for an autorotation, and improper flare which resulted in a hard landing. Also causal was the second pilot's inadequate remedial action.Sep 27, 1997 · N5045F · DestroyedNTSB NYC97FA019Accident · No injuriesField investigationFinal reportCessna 172N · Andover, MAfailure of the dual magneto, which resulted in a total loss of engine power, and subsequent collision with trees during a forced landing at night. Darkness and trees in the emergency landing area were related factors.Nov 21, 1996 · N4926G · Substantial damageNTSB NYC97LA018Accident · No injuriesLimited investigationFinal reportDubis Team Minimax · North Adams, MAfuel contamination, which resulted in a loss of engine power. Factors relating to the accident were: the lack of a drain in the fuel system to properly check the fuel before flight, and the pilot's failure (or inability) to detect the contaminated fuel.Nov 16, 1996 · N4335W · Substantial damageNTSB IAD96LA150Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Templeton, MAthe student pilot's improper in-flight decision to continued the cross-country flight into night conditions, and his inability to find the destination (or an alternate airport) in a timely manner, which resulted in fuel exhaustion, forced landing, and…Sep 21, 1996 · N2607J · DestroyedNTSB NYC96LA141Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Boston, MAa fracture failure of the crankcase, which resulted in separation of the number five cylinder, loss of engine power, and a ditched landing.Jul 5, 1996 · N131AC · Substantial damageNTSB NYC96LA117Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chatham, MAfailure of the oil pump, which resulted in oil starvation and subsequent failure of the number two and four cylinder connecting rods. Also causal was inadequate maintenance by noncompliance with the airworthiness directive that required replacement of the oil…May 28, 1996 · N19708 · Substantial damageNTSB NYC96IA116Incident · No injuriesIncident investigationFinal reportBoeing 767-31AER · Boston, MANumerous electrical anomalies as a result of a loose main battery shunt connection and undetermined electrical system causes.May 28, 1996 · PHMCH · Minor damageNTSB IAD96FA055Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Wareham, MALoss of engine power due to bearing insert being destroyed by excess heat. A factor in this accident is the pilot's experience level.Mar 30, 1996 · N57012 · DestroyedNTSB NYC96FA052Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Harwich, MAthe pilot's improper in-flight decision to continue flight under visual flight rules, while flying into instrument meteorological conditions. Also causal was the pilot's failure to maintain control of the airplane after entering IMC, which resulted in the…Jan 18, 1996 · N5934U · DestroyedNTSB NYC96LA028Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Southbridge, MAfatigue failure of the engine crankshaft.Nov 26, 1995 · N344C · Substantial damageNTSB NYC95FA181Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Rehoboth, MAThe pilot's inadvertent flight into hazardous weather, which subsequently resulted in exceeding the design stress limits of the airplane and an in-flight breakup. Factors relating to the accident were: embedded thunderstorms, turbulence, and failure of the…Aug 3, 1995 · N8072X · DestroyedNTSB NYC95LA160Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Deerfield, MAThe pilot's inadequate evaluation of the weather, which resulted in an encounter with unfavorable winds and an inflight loss of control. The unfavorable/high winds and sudden wind gusts were related factors.Jul 15, 1995 · N4214A · DestroyedNTSB NYC95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, MAthe pilot's improper preflight planning/preparation, inaccurate fuel consumption calculations and failure to refuel, resulting in fuel exhaustion and a subsequent collision with trees during the forced landing.Jul 9, 1995 · N9143Y · DestroyedNTSB NYC95LA116Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Taunton, MAthe failure of the pilot to monitor his fuel supply, which resulted in a power loss due to fuel exhaustion, and a forced landing in rough terrain.May 20, 1995 · N4285K · Substantial damageNTSB NYC95GA060Accident · 4 fatalFinal reportEurocopter AS-350-B · Cambridge, MA1) The Massachusetts state police (msp) management's failure to provide adequate oversight of its air wing; 2) fuel contamination and obstructed fuel injector nozzles, due to inadequate fuel storage and storage requirements by the msp, resulting in a loss of…Feb 22, 1995 · N20SP · DestroyedNTSB NYC95LA019Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Westfield, MAthe pilot's improper in-flight planning and inaccurate fuel consumption calculations, resulting in fuel exhaustion and the subsequent forced landing at night.Oct 30, 1994 · N85JW · Substantial damageNTSB BFO95FA006Accident · 2 fatalField investigationFinal reportCessna T337G · Hyannis, MALoss of aircraft control for an undetermined reason. Darkness and the weather conditions were related factors.Oct 24, 1994 · N807J · DestroyedNTSB NYC95LA016Accident · No injuriesLimited investigationFinal reportAngel Avid/Heavy Hauler · Sutton, MAThe pilot's failure to maintain the fuel selector on the proper position.Oct 23, 1994 · N740FA · Substantial damageNTSB NYC94FA148Accident · 1 fatalField investigationFinal reportBeech A100 · Williamstown, MAthe pilot's failure to maintain minimum control speed after an undetermined loss of engine power, which resulted in an inadvertent stall at too low of an altitude to allow recovery.Aug 4, 1994 · N7GA · DestroyedNTSB BFO94LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Raynham, MAFailure of the number four cylinder piston rings.Jun 15, 1994 · N8029Z · Substantial damageNTSB BFO94FA112Accident · 2 fatalField investigationFinal reportBeech 24R · Nantucket, MAthe total loss of engine power over unsuitable terrain, for undetermined reasons. The pilot's failure to ensure that proper survival equipment was onboard the airplane was a related factor.Jun 6, 1994 · N9258S · DestroyedNTSB BFO94LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Taunton, MAA total loss of engine power for undetermined reasons. A factor in this accident was the lack of suitable terrain to enable the successful completion of the forced landing.Feb 4, 1994 · N1877Q · Substantial damageNTSB BFO94FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Northampton, MAFailure of the air traffic control (ATC) facility to identify and provide the required traffic information to the jump aircraft before release of the jumper(s). A factor related to the accident was: inadequate visual lookout by the pilot of the jump aircraft.Nov 21, 1993 · N3011F · DestroyedNTSB BFO94LA010Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5B · Sterling, MASeparation of the number one exhaust valve due to fatigue cracking which resulted in loss of engine power. Other related factors were misjudgment of altitude and airspeed by the pilot resulting in on ground collision with the terrain and subsequent nose over.Nov 14, 1993 · N28215 · Substantial damageNTSB BFO94FA008Accident · 2 fatalField investigationFinal reportMooney MO-20J · Seekonk, MAThe pilot's inadequate in flight planning/decision to continue flight into known adverse weather conditions after the engine's dry air vacuum pump failed and the pilot's failure to maintain airplane control during approach. A factor in the accident was the…Nov 14, 1993 · N4224H · DestroyedNTSB NYC94LA017Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Littleton, MAThe flight instructor's inadequate in-flight decision in the selection of the simulated forced landing area, and his delay in initiating a go around which resulted in the airplane colliding with trees.Oct 23, 1993 · N67197 · Substantial damageNTSB BFO93LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Byfield, MALoss of engine power during climb for undetermined reasons.Sep 11, 1993 · N4898T · DestroyedNTSB NYC93LA156Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Lawrence, MAThe improper installation of the battery box cover by maintenance personnel.Aug 15, 1993 · N30393 · Substantial damageNTSB NYC93FA140Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot initiating VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. During his attempt to regain control of the aircraft the pilot exceeded the design stress limits resulting in wing…Aug 3, 1993 · N2093A · DestroyedNTSB NYC93LA120Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Palmer, MAThe loss of engine power for undetermined reasons. A factor was lack of suitable terrain for the forced landing.Jun 19, 1993 · N8664Q · Substantial damageNTSB NYC93LA029Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Great Barrington, MAThe inadequate pre-flight by the pilot ensuring fuel cap security. A factor in this accident was the pilots complacency in fuel management.Oct 22, 1992 · N4384N · DestroyedNTSB NYC93LA023Accident · No injuriesLimited investigationFinal reportCessna C-152 · Petersham, MAThe imprpoer maintenance procedures which resulted in engine failure and subsequent forced landing on unsuitable terrain.Oct 17, 1992 · N49269 · Substantial damageNTSB NYC93LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newburyport, MAThe pilot's inaccurate fuel consumption calculations and improper preflight planning, resulting in fuel exhaustion.Oct 15, 1992 · N2386L · Substantial damageNTSB NYC92LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Newburyport, MAThe loss of engine power for undetermined reasons.Aug 22, 1992 · N3985W · Substantial damageNTSB NYC92LA178Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Nantucket, MAThe pilot's failure to use carburetor heat, resulting in carburetor ice and loss of engine power and subsequent forced landing in the ocean.Aug 13, 1992 · N67052 · Substantial damageNTSB NYC92FA117Accident · 3 fatalField investigationFinal reportBell 47-G4A · Shelburne Falls, MAThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.Jun 16, 1992 · N1041B · DestroyedNTSB NYC92LA034Accident · Minor injuriesLimited investigationFinal reportRyan 260-B · Barre, MAA total loss of engine power in cruise flight due to fuel starvation resulting in a forced landing and collapse of the landing gear during the landing roll. A factor related to the accident was a leaking fuel selector valve.Nov 20, 1991 · N5321K · Substantial damageNTSB NYC91LA252Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Hadley, MAAn inflight loss of control due to entanglement of a prematurely deployed parachute in the elevator.Sep 29, 1991 · N6316A · DestroyedNTSB NYC91LA191Accident · No injuriesLimited investigationFinal reportBeech C-23 · Williamstown, MAEngine failure as a result of improper engine overhaul performed by other maintenance personnel. A factor was the lack of suitable terrain.Jul 28, 1991 · N7690R · Substantial damageNTSB NYC91LA185Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Templeton, MAFuel starvation induced power loss on first the left engine due to a failed fuel fitting and then the right engine due to a worn fuel fitting. A factor was the lack of suitable terrain for the forced landing.Jul 22, 1991 · N54819 · Substantial damageNTSB NYC91FA115Accident · 2 fatalField investigationFinal reportCessna 172G · New Bedford, MAThe pilot's improper planning/decision and failure to maintain proper altitude after encountering adverse weather at low altitude. The adverse weather (fog) was a related factor.Apr 9, 1991 · N6005R · Destroyed