OpenAirDocs.org

NTSB investigations, MD

237 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\" = 'MD' 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 ERA23LA349Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Leonardtown, MDA loss of engine power during an approach to landing for undetermined reasons.Aug 24, 2023 · N955LS · Substantial damageNTSB ERA23LA195Accident · Serious injuriesClass 3 · LimitedFinal reportRichard Spatz RV-14A · Fallston, MDThe pilot’s failure to discontinue an unstabilized approach, resulting in an aerodynamic stall and collision with terrain.Apr 13, 2023 · N412RS · Substantial damageNTSB DCA23LA090Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ170 · Taneytown, MDAn encounter with turbulence during descent.Dec 3, 2022 · N85356 · No damageNTSB ERA23LA071Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20J · Gaithersburg, MDThe pilot’s visual flight below published altitude minimums, which resulted in collision with a powerline tower structure.Nov 27, 2022 · N201RF · Substantial damageNTSB ERA22LA263Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Westminster, MDThe student pilot’s loss of control during a go-around and the delayed remedial action initiated by the flight instructor, which resulted in a runway excursion and collision with trees.Jun 6, 2022 · N29501 · Substantial damageNTSB ERA22LA176Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177RG · Gaithersburg, MDThe pilot’s failure to maintain adequate airspeed while maneuvering on final approach which resulted in a high sink rate and subsequent collision with a fence.Apr 2, 2022 · N123LS · Substantial damageNTSB ERA21LA267Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Easton, MDA total loss of engine power for reasons that could not be determined.Jun 24, 2021 · N2143G · DestroyedNTSB ERA21LA247Accident · Minor injuriesClass 3 · LimitedFinal reportGarrison Ronald L Zodiac 601 XL · Cumberland, MDAn inadvertent release of the canopy, which allowing the canopy to open during flight and led to an inflight loss of airplane control. Contributing to the accident was the lack of any safeguard to prevent the inadvertent opening of the canopy.Jun 8, 2021 · N315SV · Substantial damageNTSB ERA21LA132Accident · No injuriesClass 3 · LimitedFinal reportCessna 150G · Indian Head, MDThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a total loss of engine power. Contributing was the flight instructor’s mismanagement of the precautionary landing approach.Feb 17, 2021 · N8428J · Substantial damageNTSB ERA20LA332Accident · No injuriesClass 3 · LimitedFinal reportGlasair 1RG · Hagerstown, MDThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Sep 23, 2020 · N324DJ · Substantial damageNTSB ERA20CA209Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA38 · Cumberland, MDThe pilot's failure to maintain directional control during landing and the subsequent go-around in gusting crosswind conditions.Jun 7, 2020 · N2470D · Substantial damageNTSB ERA20CA095Accident · No injuriesData collectionFinal reportCessna 208 · Baltimore, MDThe pilot's failure to maintain clearance from the approach lights during an instrument approach.Feb 7, 2020 · N988FX · Substantial damageNTSB ERA19LA274Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB9 · Fort Meade, MDThe failure of the carburetor intake scat tubing, which resulted in a partial loss of engine power.Sep 17, 2019 · N2824R · Substantial damageNTSB ERA19LA197Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Crisfield, MDThe pilot's sudden incapacitation from an undiagnosed cardiac arrhythmia while on final approach, which resulted in descent and collision with trees and terrain.Jun 15, 2019 · N2750Q · Substantial damageNTSB ERA19LA160Accident · No injuriesLimited investigationFinal reportPiper PA28R · Easton, MDThe loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.Mar 13, 2019 · N33305 · Substantial damageNTSB ERA18FA221Accident · 2 fatalField investigationFinal reportQuicksilver MXL II Sport · Westminster, MDThe in-flight fracture of a stainless steel bolt that was used to secure the upper and lower wing cables to the outer attach point at the leading edge spar of the right wing due to stress corrosion cracking, which caused the right wing to fail and precluded…Aug 18, 2018 · N105SE · Substantial damageNTSB GAA18CA074Accident · No injuriesData collectionFinal reportCessna 172 · Bowie, MDThe pilot’s failure to maintain situational awareness during the approach to land. Contributing to the accident was the pilot’s distraction by the instrument panel during the approach.Nov 30, 2017 · N474SP · Substantial damageNTSB ERA17LA246Accident · No injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MDThe fatigue failure of an exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.Jul 15, 2017 · N561TU · Substantial damageNTSB ERA16FA165Accident · 2 fatalField investigationFinal reportVans RV12 · Stevensville, MDThe pilot's failure to maintain airplane control during approach for landing in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.Apr 19, 2016 · N276VA · Substantial damageNTSB GAA16CA077Accident · No injuriesData collectionFinal reportPiper PA 28 · California, MDThe student pilot's descent below the prescribed final approach path at night, and flight instructor's failure to correct the student pilot's descent, which resulted in a collision with trees and impact with the ground.Dec 11, 2015 · N432FL · Substantial damageNTSB ERA15LA228Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Churchville, MDThe pilot's improper reduction of the fuel mixture while the airplane was descending on the final leg of the traffic pattern, which resulted in a total loss of engine power and subsequent aerodynamic stall.May 29, 2015 · N2009B · Substantial damageNTSB ERA15LA084Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts Special S-1S · Westminster, MDThe pilot’s failure to see and avoid the other airplane, which resulted in a midair collision while both airplanes were on final approach to land.Dec 27, 2014 · N49294 · 2 aircraft · Substantial damageNTSB DCA15CA037Accident · No injuriesData collectionFinal reportBoeing 737 · Baltimore, MDan inadvertent encounter with birds during approach to land that resulted in substantial damage.Dec 13, 2014 · N7710A · Substantial damageNTSB DCA15MA029Accident · 6 fatalClass 1 · MajorFinal reportEmbraer EMB-500 · Gaithersburg, MDthe pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…Dec 8, 2014 · N100EQ · DestroyedNTSB ERA15FA025Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Frederick, MDThe failure of the helicopter pilots and the airplane pilot to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident were the airplane pilot's descent below the…Oct 23, 2014 · N122ES · 2 aircraft · Substantial damageNTSB ERA14LA050Accident · No injuriesLimited investigationFinal reportCessna 170 · Ridgely, MDA total loss of engine power for reasons that could not be determined based on the available evidence.Oct 8, 2013 · N4216V · Substantial damageNTSB ERA12CA413Accident · Minor injuriesData collectionFinal reportMooney M10 · Hurlock, MDThe pilot's failure to see and avoid power lines during final approach to landing.Jun 24, 2012 · N9542V · Substantial damageNTSB ERA12CA080Accident · Serious injuriesData collectionFinal reportBeech V35 · Lusby, MDThe pilot did not maintain clearance from trees during a night approach.Nov 20, 2011 · N9569Q · Substantial damageNTSB ERA12CA042Accident · Minor injuriesData collectionFinal reportMoyes Bailey Dragonfly · Massey, MDThe pilot did not maintain airspeed during approach to landing, which resulted in an aerodynamic stall.Oct 18, 2011 · N103ST · Substantial damageNTSB OPS11IA499Incident · No injuriesIncident investigationFinal reportBoeing 737 · Camp Springs, MDThe misapplication of wake turbulence and instrument flight rules (IFR) separation criteria by air traffic controllers.Apr 18, 2011 · 2 aircraft · No damageNTSB ERA11LA229Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Ridgely, MDThe pilot receiving instruction's inadequate compensation for the wind during landing and delay in executing a go-around, which resulted in a loss of airspeed, low final approach, and subsequent collision with the ground short of the runway. Contributing to…Apr 4, 2011 · N7619J · Substantial damageNTSB ERA11CA045Accident · No injuriesData collectionFinal reportEvolution Revo · Gransonville, MDThe pilot's improper recovery from a bounced landing and the certificated flight instructor's inadequate remedial action, which resulted in an aerodynamic stall during a go-around.Oct 10, 2010 · N611TX · Substantial damageNTSB ERA10FA154Accident · 1 fatalField investigationFinal reportBeech P35 · Edgewater, MDThe pilot's failure to maintain adequate airspeed while on approach, which resulted in an inadvertent stall. Contributing to the accident was the pilot's likely impairment due to back pain, symptoms of opiate withdrawal, or both.Feb 27, 2010 · N1521S · Substantial damageNTSB ERA09CA077Accident · No injuriesData collectionFinal reportCessna 172I · Frederick, MDThe student pilot's delayed decision to abort the landing.Nov 27, 2008 · N35540 · Substantial damageNTSB MIA08MA203Accident · 4 fatalClass 1 · MajorFinal reportAerospatiale SA365N-1 D · District Heights, MDThe pilot's attempt to regain visual conditions by performing a rapid descent and his failure to arrest the descent at the minimum descent altitude during a nonprecision approach. Contributing to the accident were (1) the pilot’s limited recent instrument…Sep 28, 2008 · N92MD · Substantial damageNTSB NYC08LA310Accident · 1 fatalLimited investigationFinal reportDufault Mark V Pitts S-1D · Ridgely, MDThe pilot's inadequate preflight weather evaluation which resulted in an attempted landing in fog and subsequent impact with terrain.Sep 9, 2008 · N511MD · Substantial damageNTSB NYC08FA109Accident · 2 fatalField investigationFinal reportBeech A36 · Cumberland, MDThe pilot's failure to maintain the proper approach course for undetermined reasons.Feb 22, 2008 · N3815T · Substantial damageNTSB MIA08LA034Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Stevensville, MDA loss of engine power due to the failure of company maintenance personnel to comply with engine manufacturers requirements for carburetor adjustment during the 100-hour inspection.Jan 3, 2008 · N26WR · Substantial damageNTSB NYC08LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Gaithersburg, MDThe student pilot's failure to maintain aircraft control during an attempted touch-and-go. Contributing to the accident was the instructor's delay in taking remedial action, and the presence of trees in proximity to the side of the runway.Dec 1, 2007 · N259ER · Substantial damageNTSB NYC07FA109Accident · Serious injuriesField investigationFinal reportPiper PA38-112 · Odenton, MDThe pilot's mismanagement of the airplane's fuel supply, which resulted in fuel starvation and a total loss of engine power.May 4, 2007 · N2600N · Substantial damageNTSB NYC07LA105Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · La Plata, MDAn in-flight encounter with turbulence and the flight crew's failure to advise the cabin crew about potential forecast turbulence, as reported by the flight attendant.Apr 25, 2007 · N648SW · No damageNTSB NYC07FA042Accident · 2 fatalField investigationFinal reportCessna 210K · Edgewater, MDThe pilot's failure to maintain the proper altitude/clearance will on approach, which resulted in an in-flight collision with trees. Contributing to the accident was the night-light conditions, an obstruction light that was not illuminated, and trees that had…Dec 9, 2006 · N9449M · Substantial damageNTSB NYC07FA009Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Odenton, MDThe pilot's failure to maintain adequate clearance from terrain during the approach. Contributing was the pilot's self-induced pressure to land the airplane after being informed by air traffic control that he was not operating in compliance with the ADIZ…Oct 19, 2006 · N9130N · DestroyedNTSB CHI06FA186Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Edgewater, MDThe pilot' failure to maintain sufficient airspeed which resulted in a stall. A factor was the pilots failure to properly set the flaps for the go-around.Jul 11, 2006 · N8163Q · DestroyedNTSB NYC06LA160Accident · 1 fatalLimited investigationFinal reportAerial Productions Intl. Acrojet Special · Ocean City, MDThe pilot's failure to maintain adequate airspeed which resulted in a stall mush and subsequent impact with trees. A factor in the accident was windshear, and the high weight of the airplane.Jun 27, 2006 · N23AP · DestroyedNTSB NYC05CA076Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Indian Head, MDThe pilot's failure to maintain adequate altitude/clearance while on final approach, which resulted in an in-flight collision with trees. A factor in this accident was the gusty wind conditions.Apr 27, 2005 · N8730E · Substantial damageNTSB IAD04FA021Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Ferndale, MDThe pilot's failure to maintain airspeed during a sharp turn, which resulted in an inadvertent stall and subsequent impact with terrain. Factors included the pilot's failure to fly to the intended point of landing, and his abrupt course reversal back towards…May 14, 2004 · N755AF · DestroyedNTSB NYC04CA022Accident · No injuriesData collectionFinal reportCessna 182M · Laytonsville, MDThe pilot's abrupt evasive maneuver to avoid the deer, which resulted in the loss of airspeed and an inadvertent stall.Nov 1, 2003 · N70800 · Substantial damageNTSB NYC03FA180Accident · 1 fatalField investigationFinal reportAero Vodochody L-39ZO · Forest Hill, MDThe pilot's in-flight decision to delay application of engine power to account for the engine's slow response to throttle input, which resulted in an inadvertent stall and subsequent collision with a residential area. A factor related to the accident was the…Aug 24, 2003 · N298RD · DestroyedNTSB NYC03LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gaithersburg, MDThe pilot’s failure to maintain airspeed, resulting in an inadvertent stall.May 15, 2003 · N1514X · Substantial damage