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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB NYC98FA161Accident · 2 fatalField investigationFinal reportCessna 150M · Worthington, MAThe pilot's failure to maintain airspeed due to diverted attention.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB NYC96LA028Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Southbridge, MAfatigue failure of the engine crankshaft.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB BFO95FA006Accident · 2 fatalField investigationFinal reportCessna T337G · Hyannis, MALoss of aircraft control for an undetermined reason. Darkness and the weather conditions were related factors.NTSB NYC95LA016Accident · No injuriesLimited investigationFinal reportAngel Avid/Heavy Hauler · Sutton, MAThe pilot's failure to maintain the fuel selector on the proper position.NTSB 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.NTSB BFO94LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Raynham, MAFailure of the number four cylinder piston rings.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB BFO93LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Byfield, MALoss of engine power during climb for undetermined reasons.NTSB NYC93LA156Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Lawrence, MAThe improper installation of the battery box cover by maintenance personnel.NTSB 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…NTSB 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.NTSB 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.NTSB NYC93LA023Accident · No injuriesLimited investigationFinal reportCessna C-152 · Petersham, MAThe imprpoer maintenance procedures which resulted in engine failure and subsequent forced landing on unsuitable terrain.NTSB NYC93LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newburyport, MAThe pilot's inaccurate fuel consumption calculations and improper preflight planning, resulting in fuel exhaustion.NTSB NYC92LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Newburyport, MAThe loss of engine power for undetermined reasons.NTSB 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.NTSB NYC92FA117Accident · 3 fatalField investigationFinal reportBell 47-G4A · Shelburne Falls, MAThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.NTSB 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.NTSB NYC91LA252Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Hadley, MAAn inflight loss of control due to entanglement of a prematurely deployed parachute in the elevator.NTSB 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.NTSB 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.NTSB 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.