NTSB investigations
20,992 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.\"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.
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."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
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 NYC92FA049Accident · 1 fatalField investigationFinal reportCessna 182P · Hanging Rock, OHThe pilot's improper use of carburetor heat, which resulted in the formation of carburetor ice and a loss of engine power and subsequent forced landing in trees.NTSB LAX92LA068Accident · No injuriesLimited investigationFinal reportCessna 210K · Watsonville, CAThe pilot's inadequate fuel calculation and failure to service the airplane's fuel tanks with adequate quantities of fuel to compete the fights. The loss of engine power resulting from fuel exhaustion was a factor in the accident.NTSB DEN92LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Yuma, COThe pilot's failure to maintain aircraft control. Factors were: an improper flare and lack of total flight time.NTSB LAX92FA065Accident · 2 fatalField investigationFinal reportBeech 58P · Flagstaff, AZ**This report was modified on 4/21/2016. Please see the public docket for this accident for additional information.** the pilot's failure to maintain airspeed at low altitude, which resulted in a stall and loss of airplane control during a circling approach…NTSB FTW92LA049Accident · Minor injuriesLimited investigationFinal reportKinkade E.5 Vans RV-4 · Alpine, TXInadvertent stall.NTSB NYC92FA047Accident · 1 fatalField investigationFinal reportPiper PA-23-235 · Fall River, MAThe pilot did not follow IFR proceedures and was manuvering at too low an altitude to remain clear of the terrain. Factors in the accident were; fatigue, fog and no visual ground clues.NTSB MIA92FA045Accident · 1 fatalField investigationFinal reportCessna 152 · Naples, FLThe pilot-in-command's incapacitation due to an undetermined cardiovascular event which resulted in an uncontrolled descent into the ground.NTSB DEN92LA015Accident · No injuriesLimited investigationFinal reportBeech V35 · Erie, COAn inadvertent gear up landing when the pilot in command and designated examiner failed to use proper procedures. A factor was: failure of the landing gear extension/retraction motor.NTSB FTW92FA035Accident · Serious injuriesField investigationFinal reportCessna U206G · Pasadena, TXFuel starvation due to the pilots' improper boost pump procedure. Factors were pilots' failure to follow checklist, dark night, and unsuitable terrain.NTSB CHI92LA043Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Rochester, MNImproper use of autopilot during approach which resulted in proper alignment not maintained by the pilot. Factors related to the accident were turbulence and crosswinds, over confidence in aircraft's capability and overconfidence in personal ability.NTSB DEN92IA014Incident · No injuriesIncident investigationFinal reportCessna 172RG · Broomfield, COFailure of the left main landing gear pivot assembly due to ductile torsional overstress.NTSB CHI92LA047Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mt Pleasant, MIWater in the fuel, and an inadequate preflight by the pilot.NTSB CHI92LA040Accident · No injuriesLimited investigationFinal reportMooney M20J · Morris, MNFailure to maintain proper glidepath. A factor related to the accident is the failure to perform remedial action, the dark night, and the snow shower in progress at the time.NTSB ATL92LA028Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Ramseur, NCThe pilot's improper compensation for the wind conditions. The gusty crosswind was a factor in the accident.NTSB FTW92LA032Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Hamilton, TXThe inadvertend encounter with icing conditions. Factors were the unavailability of an airport weather observation facility and the deteriorated aircraft performance.NTSB FTW92LA033Accident · No injuriesLimited investigationFinal reportBoeing 737-200 · Lubbock, TXThe in flight collision with geese. A factor was the dark night.NTSB BFO92FA011Accident · Serious injuriesField investigationFinal reportPiper PA-24-180 · Sandston, VAThe loss of engine power due to fuel exhaustion and the pilots selection of unsuitable terrain for the force landing. A factor was the pilot's improper inflight decision.NTSB DEN92LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Denver, COA false unsafe landing gear indication due to a frozen down lock switch. Factors were: icing conditions and low ceilings.NTSB LAX92LA059Accident · No injuriesLimited investigationFinal reportCessna 182H · Tucson, AZFuel exhaustion due to the pilot's inadequate preflight inspection, her failure to ensure that an adequate fuel supply was onboard and her decision not to refuel the aircraft prior to departure. Factors in the accident were: 1) the inoperative left fuel gage;…NTSB SEA92FA022Accident · Serious injuriesField investigationFinal reportCessna 150E · Vancouver, WAInadequate visual lookout on the part of the pilot as well as both the flight instructor and student of the other aircraft. A factor contributing to the accident was the other pilot's lack of landing light usage.NTSB CHI92FA032Accident · 3 fatalField investigationFinal reportBeech B100 · Romeo, MIThe pilot in command's improper inflight decision and the minimum descent altitude disregarded during an instrument approach.NTSB CHI92LA029Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Howell, MIProper glidepath was not maintained resulting in an undershoot. A factor related to the accident was dark night flying conditions.NTSB NYC92LA032Accident · No injuriesLimited investigationFinal reportCessna 150 · Poestenskill, NYThe pilot's improper use of carburator heat, resulting in carburator ice and a loss of engine power and subsequent forced landing on unsuitable terrain.NTSB NYC92LA031Accident · 2 fatalLimited investigationFinal reportMooney M20C · Painesville, OHThe pilot's failure to see and avoid the powerline tower structure while executing a visual approach to the airport. Factors related to the accident were the lack of proper radio equipment necessary to execute the instrument approach, restricted visibility…NTSB ATL92FA024Accident · 1 fatalField investigationFinal reportCessna 208B · Destin, FLThe pilots failure to follow instrument flight rules procedures by disregarding the minimum descent altitude for the approach and failing to maintain clearance from the terrain. A factor in the accident was the pilot's over confidence in his personal ability.NTSB CHI92FA028Accident · 1 fatalField investigationFinal reportPiper PA28-236 · Valley Center, KSThe pilot's spatial disorientation, his loss of aircraft control, and his exceeding the aircraft's design limits. Factors in the accident were the pilot's disregard for directives and procedures, and his continued flight into known adverse weather.NTSB SEA92LA017Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Belt, MTA blocked fuel vent and an inadequate preflight inspection, which resulted in fuel starvation.NTSB LAX92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Maricopa, AZThe cfi's inadequate supervision and his delayed remedial action. A factor was carburetor icing conditions.NTSB NYC92FA029Accident · 5 fatalField investigationFinal reportCessna 340 · Columbus, OHThe pilot's improper execution of an emergency procedure, after an engine failure, which resulted in the loss of airplane control. Factors related to the accident were: the pilot's improper management of the fuel system; the pilot's lack of proficiency in…NTSB NYC92DGM01Accident · 1 fatalFinal reportWillkins-Wayne VARI-VIGGEN · Erie, PAThe pilot lost control of the airplane at too low an altitude to recover. Factors related to the accident were the pilot's low time and experience in this type of airplane.NTSB LAX92LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Lake Havasu, AZThe pilot's; 1) inadequate preflight preparation, 2) failure to obtain current NOTAM information, and 3) failure to obtain a current altimeter setting. Factors in the accident were the dark night condition and the pilot election not to use the landing light.NTSB CHI92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Charles City, IAProper glide path not maintained. Factors in the accident are the premature landing gear extension and inadequate airspeed by the pilot in command.NTSB CHI92LA024Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Burlington, IAThe pilot having an improper fuel tank selector position.NTSB ANC92LA015Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot's loss of control during final approach when his attention was diverted to trying to operate the vernier throttle. Contributing to the accident was the pilot's lack of familiarity with the aircraft and his failure to maintain directional control of…NTSB BFO92LA008Accident · No injuriesLimited investigationFinal reportMooney 20F · Basye, VAThe pilot misjudged the altitude and distance to the runway. Factors were the gusty weather conditions and the pilot's delay in executing a go around.NTSB MIA92LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · Coleman, FLFailure of the unqualified pilot to maintain the proper glidepath while on final approach. Also, failure to perform the correct remedial action resulting in the collision with a power line.NTSB NYC92LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R · Caldwell, NJThe pilot allowed the airplane to get too low on final approach during a night visual landing. Factors in the accident were: the pilot improperly planned the approach, dark night and a lack of flight experience in night operations.NTSB LAX92LA035Accident · No injuriesLimited investigationFinal reportCessna 210 · San Diego, CAThe total loss of engine power due to unknown reason(s). A factor in this accident was the lack of suitable terrain to land the airplane, without incurring damage to the airplane.NTSB LAX92LA034Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Riverside, CAThe failure of the engine to transmission drive belt and the pilots failure to correctly judge of the landing flare during the subsequent autorotation.NTSB LAX92FA033Accident · 3 fatalField investigationFinal reportCessna 337F · Bullhead City, AZThe pilots failure to maintain a proper descent rate and to adequately judge the above ground altitude of the aircraft during the approach. Factors in the accident were: 1) the dark night conditions, 2) the pilot's degraded visual perceptive ability, and 3)…NTSB MIA92LA019Accident · No injuriesLimited investigationFinal reportBeech C-45H · Fort Lauderdale, FLHard landing due to failure of the pilot-in-command to maintain the proper descent rate. Contributing to the accident was the turbulence encountered during the apch.NTSB FTW92LA016Accident · Serious injuriesLimited investigationFinal reportBalkema/Boven Kestrel Hawk · West Memphis, ARThe pilot allowed the aircraft to enter an inadvertent stall during flare at excessive altitude while executing the forced landing. Factors were the pilot in command and unauthorized person performed carburetor maintenance adjustments prior to flight, and the…NTSB NYC92LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Groton, CTThe pilot's failure to maintain the minimum descent altitude during the approach. A factor was pilot fatigue.NTSB LAX92LA023Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Chiriaco Summit, CAThe delayed actions of the pilot-in-command in selecting a go-around ND subsequent loss of directional control which resulted in the airplane drifting off the runway centerline and colliding with terrain. Contributing to the accident was failure of the pilot…NTSB BFO92LA004Accident · No injuriesLimited investigationFinal reportCessna T210N · Wheeling, WVThe engine failure caused by fuel starvation and the pilot's improper fuel management.NTSB BFO92LA003Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Waynesboro, VAImproper in-flight planning/decision by the instructor (CFI). Contributing to the accident was the instructor's failure to properly monitor the student's performance.NTSB NYC92LA017Accident · No injuriesLimited investigationFinal reportBeech A23 · Fairfield, NJThe loss of engine power for undetermined reason's which resulted in a forced landing on unsuitable terrain.NTSB DEN92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARA power loss for undetermined reasons. Factors were: incorrect fuel, improper maintenance, and inadequate maintenance inspection interval.NTSB SEA92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Monticello, UTInadequate maintenance/overhaul of the engine, and subsequent failure of the #5 piston (hole burned in piston), due to pre-ignition and/or detonation. Rough/uneven terrain in the emergency landing area was a related factor.NTSB LAX92LA021Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Fremont, CAThe pilot's inadequate altitude on final approach.