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 BFO91FA031Accident · Serious injuriesField investigationFinal reportCessna 182F · Princeton, WVThe pilot's inadequate inflight decision which resulted in airframe icing.NTSB MIA91LA096Accident · 1 fatalLimited investigationFinal reportBartholomew Kolb Twinstar · Bronson, FLPilot-in-command's decision to initiate a flight with known deficiencies in his equipment in that his airspeed indicator was inoperative. He then failed to maintain airspeed in a turn on final approach, stalled, and crashed.NTSB LAX91LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Ana, CAThe pilot's improper inflight planning which resulted in the flight's encounter with wake turbulence from a landing heavy transport.NTSB CHI91LA106Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Ogallala, NEImproper planning/decision by the pilot and the lack of sufficient airspeed to maneuver (circle to land) in unfavorable wind conditions with structural ice on the aircraft. The adverse weather conditions and structural (wing) ice were related factors.NTSB BFO91LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Hagerstown, MDThe failure of the throttle control cable. A factor ws the rough terrain.NTSB FTW91LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe pilot's failure to maintain airspeed and altitude on final approach.NTSB ATL91LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNThe inadvertent stall of the aircraft, encountered as a result of the student pilot's inability to maintain the proper compensation for wind and the lack of total experience of the student pilot.NTSB DCA91MA023Accident · 25 fatalClass 1 · MajorFinal reportBoeing 737-291 · Colorado Spgs, COA loss of control of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…NTSB SEA91LA055Accident · No injuriesLimited investigationFinal reportCessna 180 · Glasgow, MTThe loss of engine power due to carburetor icing. Factors relating to the accident were the strong winds, high obstructions in the area and tailwind conditions for landing at the only available area.NTSB LAX91LA112Accident · No injuriesLimited investigationFinal reportPiper PA46-310P · Los Angeles, CAThe poor preflight planning performed by the pilot-in-command in accurately determining the weight and fuel consumption of the airplane which resulted in loss of engine power due to fuel exhaustion.NTSB NYC91LA077Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Wallkill, NYDecision by the non-instrument rated pilot to attempt flight into instrument meteorological conditions, resulting in airframe icing, loss of control and collision with trees. A factor related to the accident was the failure of the pilot to receive a…NTSB LAX91LA104Accident · No injuriesLimited investigationFinal reportCessna 340A · Truckee, CAThat the pilot failed to follow the correct emergency procedures when he began to experience engine problems and improperly used the fuel boost pumps contrary to the pilot's operating handbook. The initial cause of the engine surging could not be determined.NTSB LAX91LA101Accident · No injuriesLimited investigationFinal reportPiper PA28-201T · So. Lake Tahoe, CAThe pilot failed to properly compensate for the wind conditions, abruptly flared the airplane, and inadvertenly stalled the airplane. Contributing to this accident was windshear.NTSB FTW91LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Wichita Falls, TXThe pilot's inadequate compensation for crosswind conditions encountered on final and his failure to maintain directional control during the attempted go around. A factor in the accident was the unfavorable gusting crosswind conditions.NTSB DEN91LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Guymon, OKFuel starvation for undetermined reasons, and the pilot's delay in flaring the airplane. A factor was: the pilot's total lack of experience.NTSB FTW91FA038Accident · 5 fatalField investigationFinal reportPiper PA-32-300 · Falfurrias, TXThe pilot's improper compensation for wind conditions, the pilot not maintaining airspeed above vs during the go-around attempt and the pilot's impairment due to drugs. Factors were the gusting crosswind conditions and the pilot's lack of total aircraft…NTSB DEN91FA043Accident · 3 fatalField investigationFinal reportLearjet 35A · Aspen, COThe flight crew's failure to maintain airspeed and control of the airplane while maneuvering to land. Contributing factors were the flight crew's execution of an unstabilized approach and the surrounding snow-covered mountainous terrain.NTSB ANC91IA028Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Unalaska, AKThe windshear encountered on short final. Contributing to the accident was the rising terrain within 150 feet of the runway, the variable nature of the wind due to the rising terrain, and the pilot's failure to maintain lateral control during the go around.NTSB FTW91LA037Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Brownsville, TXThe pilot's failure to refuel the airplane prior to his departure on the last leg of the flight, which resulted in fuel exhaustion.NTSB LAX91FA093Accident · 1 fatalField investigationFinal reportCessna TR182 · Petaluma, CAThe pilot's inadvertent flight into IMC and his failure to maintain aircraft control of the airplane. Factors which contributed to the accident related to the pilot becoming disoriented in the dark, nighttime, instrument weather conditions, and to the pilot's…NTSB CHI91LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, WIImproper in-flight planning/decision by the pilot and his failure to maintain airspeed, which resulted in an inadvertent stall/mush onto snow covered terrain beside the runway. The adverse weather conditions and snow covered terrain were related factors.NTSB CHI91FA091Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Dutchtown, MOThe pilot's failure to maintain control of the airplane in instrument meteorological conditions and the pilot exceeding the design stress limits of the airplane during the loss of control. Contributing factors were the existing weather conditions.NTSB CHI91FA090Accident · 1 fatalField investigationFinal reportBeech F.35 · Sidney, OHThe pilot's intentional VFR flight into instrument meteorological conditions. Factors in the accident were the pilot's disregard for directives and overconfidence in his ability.NTSB SEA91FA046Accident · 2 fatalField investigationFinal reportCessna C-172 · Colstrip, MTThe pilot's failure to maintain adequate terrain clearance. Factors relating to the accident were the pilot's lack of total night flight experience, his lack of recent night flight experience, the dark night light conditions, and the mountainous/hilly terrain…NTSB MIA91LA077Accident · No injuriesLimited investigationFinal reportRyan Navion · Lake City, FLIn-flight encounter with wind shear while on short final resulting in a hard landing.NTSB LAX91LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Pixley, CAThe failure of the pilot to use carburetor heat in carburetor icing conditions. Contributing to the accident was the lack of experience in the accident airplane make and model.NTSB CHI91FA088Accident · 7 fatalField investigationFinal reportPiper PA-28-140 · Osceola, WIFailure of the pilots in both aircraft to seeing-and-avoid the other airplane.NTSB BFO91LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Harrisonburg, VAThe pilot's failure to maintain directional control. Contributing to the accident was premature raising of the flaps, and inadequate airspeed.NTSB ATL91LA048Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Lumberton, NCThe pilot suffered a stroke and lost control of the airplane on final approach.NTSB ATL91FA047Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Cordele, GAFailure of the pilot to attain proper runway alignment and to maintain proper altitude. Related factors were: darkness and the pilot becoming lost/disoriented.NTSB NYC91LA068Accident · No injuriesLimited investigationFinal reportBeech 200 · Johnstown, PAThe pilot's failure to maintain proper directional control of the airplane during landing, resulting in a collision with a snow bank and runway marker. A factor relating to the accident was the low visibility during landing.NTSB LAX91FA086Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Dunsmuir, CAThe pilot's delayed go-around attempt and improper use of carburetor heat. Contributing to the accident was a degradation of engine power due to fuel contamination from sand and rust.NTSB MIA91FA075Accident · 1 fatalField investigationFinal reportCessna 210L · Orlando, FLThe pilot's failure to maintain aircraft control in instrument conditions and his spatial disorientation. Factors were a failure of the vacuum pump and the pilot's lack of recent experience in partial panel instrument flying or training.NTSB NYC91DFA02Accident · 1 fatalFinal reportHayes Kolb/Twinstar · Round Lake, NYIn-flight structural failure of the outboard wing attachment fittings on both wings due to an undetermined reason.NTSB LAX91FA081Accident · 1 fatalField investigationFinal reportCessna T210M · Sacramento, CAA loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the ensuing emergency landing.NTSB MIA91LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-B-310 · Fernandina Bch, FLDelay by the pilot to perform a missed approach and failure to correct the descent before impact with terrain.NTSB NYC91LA064Accident · 1 fatalLimited investigationFinal reportBeech 58 · Batavia, NYThe failure of the pilot to ensure an adequate amount of fuel was on board for the planned flight which resulted in a double power loss due to the fuel exhaustion.NTSB NYC91LA062Accident · Minor injuriesLimited investigationFinal reportCessna P206 · Cleveland, OHFatigue failure of the number two propeller blade actuating pin, due to improper installation of the pins and non-compliance with an airworthiness directive (AD 77-13-77).NTSB CHI91LA074Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Cabool, MOFailure of the pilot to maintain proper runway alignment during a go-around. Factors related to the accident were: darkness and the pilot's lack of understanding of the landing gear electrical system.NTSB ATL91FA040Accident · 4 fatalField investigationFinal reportRockwell 114 · Bessemer, ALFailure of the pilot to follow instrument flight rules (IFR) and maintain the minimum descent altitude (mda) during the VOR approach. Factors related to the accident were: darkness and the adverse weather conditions.NTSB MIA91FA069Accident · 4 fatalField investigationFinal reportBeech 58P · Lantana, FLThe pilot in commands failure to maintain airspeed while performing a go around resulting in the airplane stalling and colliding with the ground in an uncontrolled descent.NTSB DEN91LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Houston, TXThe flight instructor's delay in taking remedial action, his inadvertently allowing the airplane to stall, and exceeding the aircraft's climb performance. Factors were: the flight instructor's lack of experience in aircraft type, his lack of experience as a…NTSB FTW91FA030Accident · 4 fatalField investigationFinal reportMooney 20J · Newcastle, OKThe pilot's failure to maintain aircraft control. Factors were spatial disorientation, improper IFR procedures, and the dark night with low ceilings and rain.NTSB CHI91DEP03Accident · 1 fatalFinal reportAir Command 503 · Tomahawk, WIThe pilot-in-command's abrupt movement of the flight controls which resulted in loss of rotor RPM and eventual departure from controlled flight. A factor contributing was ice accumulation on the pilot's face resulting in pilot incapacitation (visual…NTSB LAX91DUQ01Accident · No injuriesFinal reportVirgil D. Hawks Quickie · Camarillo, CAThe pilot's encounter with wake turbulence and his inflight loss of control by his failure to maintain a sufficient landing distance from a larger aircraft preceding his aircraft.NTSB CHI91LA068Accident · No injuriesLimited investigationFinal reportCessna 182A · Chadron, NEAn engine power loss for undetermined reasons.NTSB FTW91FA028Accident · 2 fatalField investigationFinal reportFolland Gnat T-1 · Bossier City, LAImproper planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to lack of fuel. The adverse weather conditions and radio malfunction were related factors.NTSB LAX91LA067Accident · No injuriesLimited investigationFinal reportPiper PA 34-200T · Red Bluff, CAThe failure of the pilot in command to detect a descent below the minimum descent altitude for the approach in use.NTSB NYC91FA058Accident · 1 fatalField investigationFinal reportMooney M20K · Gallipolis, OHThe pilot allowed the speed of the airplane to get too slow, resulting in an inadvertant stall at too low an altitude to allow recovery. A factor relating to the accident was the pilot's trepidation about a successful landing because of the weather.NTSB CHI91FA059Accident · 1 fatalField investigationFinal reportCessna 172P · Freeport, ILThe pilot-in-command's failure to maintain airspeed. Factors contributing were the pilot-in-command's misuse of flaps and his lack of total experience in this type of operation.