NTSB investigations, MA

345 cases where the phase of flight was Approach.

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 = 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 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 · DestroyedNTSB NYC03FA203Accident · 1 fatalField investigationFinal reportCessna 402C · Nantucket, MAThe pilot's failure to maintain aircraft control during a missed approach. Factors in this accident were fog and the night light conditions.Sep 23, 2003 · N405BK · Substantial damageNTSB IAD03LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Sterling, MAThe student pilot's misjudgment of his traffic pattern altitudes, which resulted in a premature descent into a tree.Apr 19, 2003 · N1241S · Substantial damageNTSB IAD03FA043Accident · 6 fatalField investigationFinal reportBeechcraft B200 · Leominster, MAThe pilot's low altitude maneuver using an excessive bank angle, and his failure to maintain airspeed which resulted in an inadvertent stall and subsequent collision with a building. A factor was the pilot's impairment from prescription medications.Apr 4, 2003 · N257CG · Substantial damageNTSB NYC03LA025Accident · No injuriesLimited investigationFinal reportCessna 172G · Stow, MAThe pilot's failure to maintain adequate altitude/clearance. A factor in this accident was gusty wind conditions.Nov 23, 2002 · N1152F · Substantial damageNTSB NYC03LA019Accident · 2 fatalLimited investigationFinal reportMooney M20R · Vineyard Haven, MAThe pilot's spatial disorientation during a missed approach, which resulted in a loss of control, and the airplane's subsequent impact with water. Factors included clouds, rain, and night lighting conditions.Nov 13, 2002 · N2165Y · DestroyedNTSB NYC03LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Edgartown, MAThe pilot's inadequate in-flight evaluation of the landing facilities wind conditions, and inadequate airspeed resulting in a stall/mush. A factor related to the accident was the tailwind condition.Oct 1, 2002 · N8071Z · Substantial damageNTSB NYC02LA167Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Chatham, MAThe pilot's improper in-flight decision to continue the landing after losing visual contact with the runway, which resulted in his failure to obtain the proper touchdown point, and the subsequent overrun. Factors in this accident were the clouds and low…Aug 16, 2002 · N20787 · Substantial damageNTSB NYC02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Nantucket, MAa loss of engine power for undetermined reasons.Jan 12, 2002 · N6315R · Substantial damageNTSB NYC01FA189Accident · 1 fatalField investigationFinal reportPiper PA-46-350 · Westfield, MAThe pilot's failure to maintain aircraft control while maneuvering during a go-around.Jul 28, 2001 · N3DM · DestroyedNTSB NYC01LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Stow, MAThe pilot's failure to maintain airplane control during a go-around.Jul 16, 2001 · N9133D · DestroyedNTSB NYC01FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Edgartown, MAThe pilot's failure to maintain a stabilized approach with an adequate vertical and lateral track. Also causal was his failure to maintain obstacle clearance.Jan 30, 2001 · N6837Y · DestroyedNTSB NYC01FA005Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-26A · Edgartown, MAThe pilot's failure to follow instrument flight procedures resulting in a collision with a tree. A factor related to the accident was the low cloud ceiling.Oct 7, 2000 · N60BT · DestroyedNTSB NYC01LA004Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Marshfield, MAThe pilot's improper management of the fuel supply, which resulted in fuel starvation of the engine. A factor in the accident was the pilot's diverted attention to the inclement weather.Oct 4, 2000 · N6096B · Substantial damageNTSB NYC00LA242Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nantucket, MAThe pilot's failure to maintain the proper glide path to the runway. Factors related to the accident were the fog conditions and the pilot’s fatigue.Aug 26, 2000 · N8133Z · DestroyedNTSB IAD00LA047Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Grt Barrington, MAThe pilot's failure to perform a go around and his inadequate recovery from a bounced landing. Factors in the accident were the pilot's s failure to maintain the proper glide path and to reach the proper touchdown point.May 31, 2000 · N1154K · Substantial damageNTSB IAD00LA045Accident · No injuriesLimited investigationFinal reportBeech A-36 · Bedford, MAthe pilot's improper fuel management which resulted in fuel starvation.May 27, 2000 · N66SB · Substantial damageNTSB IAD00FA023Accident · 1 fatalField investigationFinal reportAerotechnik L-13 SEH Vivat · Plymouth, MAthe flight instructor's inadequate compensation for the wind conditions. A factor was the flight instructor's improper use of speed brakes and the strong gusty winds with downdrafts.Feb 23, 2000 · N64RG · DestroyedNTSB NYC00FA058Accident · 1 fatalField investigationFinal reportCessna 172P · Leominster, MAThe student pilot's failure to see and avoid the private pilot's airplane. Factors included the student pilot's non-standard traffic pattern entry, the private pilot's failure to check for other traffic before turning onto final, and the position of the sun…Dec 22, 1999 · N96273 · 2 aircraft · DestroyedNTSB NYC99LA151Accident · No injuriesLimited investigationFinal reportLearjet 60 · Hyannis, MAThe flightcrew's inadequate coordination and their failure to utilize checklists. Also causal was the captain's improper decision to continue the approach to a runway with insufficient length. A factor in the accident was the improper maintenance.Jul 2, 1999 · N219FX · Substantial damageNTSB NYC99FA060Accident · 1 fatalField investigationFinal reportCessna 170A · Leominster, MAThe pilot's failure to maintain the proper altitude during the approach.Feb 11, 1999 · N1460D · Substantial damageNTSB NYC99FA012Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Provincetown, MAThe failure of the pilot to follow the published instrument approach procedure, which resulted in inadvertent collision with water. Factors in the accident were the dark night and low ceiling.Oct 9, 1998 · N7100L · DestroyedNTSB NYC98LA183Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Chatham, MAthe failure of the pilot to maintain airspeed during a go-around and which resulted in an inadvertent stall. Factors in the accident were the pilot's lack of total experience and the gusting crosswinds.Sep 5, 1998 · N28764 · Substantial damageNTSB NYC98GA113Accident · 2 fatalFinal reportCessna 182R · Middleborough, MAThe pilot-in-command's failure to maintain control of the airplane during a VFR go-around. A factor was the impairment due to drugs.May 25, 1998 · N9885E · DestroyedNTSB NYC98FA111Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Lincoln, MAThe pilot's failure to maintain airspeed.May 23, 1998 · N82824 · DestroyedNTSB NYC98FA024Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Fitchburg, MAThe flight instructor's inadequate in-flight decision and his failure to maintain adequate airspeed which resulted in a loss of control. Contributing was the flight instructor's failure to follow standard practices while simulating and practicing emergency…Oct 31, 1997 · N3EV · DestroyedNTSB NYC97LA183Accident · No injuriesLimited investigationFinal reportCessna 402C · Nantucket, MAthe pilot's delayed decision to perform a go-around (missed approach). Related factors were: darkness, low ceiling, fog, and disorientation of the flight crew, while making the approach in conditions of limited visibility.Sep 19, 1997 · N6879Y · Substantial damageNTSB NYC97FA173Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Hancock, MAThe pilot's failure to maintain adequate terrain clearance and the proper altitude. Contributing was mountainous terrain.Aug 29, 1997 · N40AB · DestroyedNTSB NYC97LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · North Andover, MAFuel vents blocked by frozen moisture which resulted in restricted fuel flow to the engine and subsequent loss of engine power.Jan 29, 1997 · N67898 · DestroyedNTSB NYC96LA025Accident · No injuriesLimited investigationFinal reportCessna 150J · Norwood, MAthe student's inadvertent use of the mixture control and the flight instructor's inadequate supervision during the final approach resulting in the loss of engine power due to fuel starvation and the subsequent nose over during the forced landing.Nov 13, 1995 · N51197 · Substantial damageNTSB NYC96LA020Accident · No injuriesLimited investigationFinal reportCessna 414A · Grt Barrington, MAthe pilot's inadequate compensation for wind conditions, which resulted in an undershoot of the proper touchdown point for landing. Factors relating to the accident were: the unfavorable wind conditions and the exposed runway lip.Oct 27, 1995 · N2UD · Substantial damageNTSB NYC95FA224Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Marlborough, MAthe Stearman, N89X, pilot's inadequate visual lookout. A factor was the failure of the flight instructor of the Cessna 150, N1766Q, to announce his position in the traffic pattern in accordance with recommended procedures.Sep 24, 1995 · N89X · 2 aircraft · Minor damageNTSB NYC95LA180Accident · No injuriesLimited investigationFinal reportWright JUNGSTER-I · Mansfield, MAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and subsequent uncontrolled descent and collision with the terrain.Jul 31, 1995 · N26241 · Substantial damageNTSB BFO95LA066Accident · 1 fatalLimited investigationFinal reportDrake Moni · Pittsfield, MAthe pilot's failure to maintain/regain control of the aircraft during the simulated engine-out procedure while on approach to landing.Jun 18, 1995 · N787DD · DestroyedNTSB NYC95FA031Accident · 1 fatalField investigationFinal reportMooney M20J · Brewster, MAFailure of the pilot to maintain control of the airplane during a missed approach. A factor related to the accident was: the deteriorating weather condition with a low ceiling and rain.Nov 19, 1994 · N5681Y · DestroyedNTSB NYC95FA030Accident · 1 fatalField investigationFinal reportCessna 402C · Hyannis, MAthe pilot's failure to maintain a proper glide path during an ILS approach, which resulted in a collision with power lines. Factors in this accident were; adverse weather conditions with turbulence, down drafts and fog.Nov 19, 1994 · N402BK · DestroyedNTSB NYC95LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAThe pilot's failure to maintain adequate terrain clearance, which resulted in an inflight collision with trees. Other related factors were: heavy rain, moderate turbulence, dark night, and high winds.Nov 18, 1994 · N14315 · DestroyedNTSB NYC95LA002Accident · No injuriesLimited investigationFinal reportCessna 185F · Rochester, MAThe pilot's inadeqaute calculation of fuel and inadeqaute inflight decision which resulted in fuel exhaustion and the loss of engine power.Oct 9, 1994 · N53074 · Substantial damageNTSB BFO94LA074Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Plymouth, MAThe pilot's failure to maintain adequate airspeed.Apr 23, 1994 · N2167 · Substantial damageNTSB BFO94LA069Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Beverly, MAThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and collision with the ground.Apr 15, 1994 · N84409 · DestroyedNTSB NYC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hopedale, MAthe certified flight instructor's delay in taking remedial action by not initiating the go-around, resulting in the in-flight collision with the tree.Mar 27, 1994 · N2598Q · Substantial damageNTSB NYC94LA010Accident · Minor injuriesLimited investigationFinal reportSchlappi RV3 · Hatfield, MAThe pilot misjudged his distance and altitude which resulted in an undershoot of the runway. A factor was his delay in intiating a go around.Oct 15, 1993 · N669CP · Substantial damageNTSB NYC94FA007Accident · 1 fatalField investigationFinal reportBeech A36 · Topsfield, MAFailure of the pilot to follow the published IFR procedure, and his failure to correct a spiral after becoming spatially disoriented.Oct 9, 1993 · N6AP · DestroyedNTSB BFO93LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittsfield, MAThe failure of the pilot of the PA-28, N9044J, to properly tune his radios, and his failure to see and avoid the PA-38, N91357.Jul 24, 1993 · N9044J · 2 aircraft · Substantial damageNTSB NYC93FA026Accident · 2 fatalField investigationFinal reportBeech 55 · Leicester, MAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were the pilot's lack of recent flight experience and his lack of recent instrument experienced.Oct 19, 1992 · N1ZB · DestroyedNTSB BFO92IA145Incident · No injuriesIncident investigationFinal reportLockheed L1011-385 · Boston, MAInadequate lubrication which caused stress corrosion cracking and the separation of the right wing number two flap vane.Sep 20, 1992 · N786DL · Minor damageNTSB BFO92FA151Accident · 3 fatalField investigationFinal reportCessna R182 · Edgartown, MAThe pilots's lack of regard for the published decision height of the approach and his decision not to execute a missed approach. Factors contributing to the accident include the pilot's failure to attain the proper glidepath and descent rate during the…Sep 19, 1992 · N102SR · DestroyedNTSB NYC92LA113Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hadley, MAA power loss of undetermined origin while operating over unsuitable terrain.Jun 13, 1992 · N5220X · Substantial damageNTSB NYC92LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Palmer, MAThe improper use of carburetor heat which resulted in a power loss due to carburetor ice over unsuitable terrain. Factors related to the accident were the carburetor icing conditions and the failure of the pilot to be aware of the temperature/dewpoint spread.Mar 31, 1992 · N3047N · Substantial damageNTSB BFO92LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · East Taunton, MAInadequate preflight by the dual student and inadequate supervision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.Jan 29, 1992 · N8379N · Destroyed