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 ATL90LA063Accident · No injuriesLimited investigationFinal reportBeech A 36 · Ocean Island Be, NCLoss of engine power due to fuel starvation and the pilot in commands failure to turn on the electric boost pump during attempted engine restart resulting in a forced landing.NTSB MKC90LA052Accident · No injuriesLimited investigationFinal reportCessna 150 · Clear Lake, MNFailure of the pilot to maintain proper alignment with the runway, his delay in initiating a go-around, and his premature raising of the flaps. Factors related to the accident were the adverse wind conditions and the tree.NTSB LAX90FA082Accident · 3 fatalField investigationFinal reportBeech 95-55 · Chico, CAThe failure of the pilots of N790T and N721L to see and avoid each other. Factors which contributed to the accident were: the pilot of the C-182P, N790T, was disoriented and improperly entered the traffic pattern due to recent marijuana use; the pilot of the…NTSB FTW90FA063Accident · 1 fatalField investigationFinal reportCessna 172M · Tomball, TXFailure of the pilot in Cessna 150, N714RS, to comply with the air traffic control clearance, and failure of both pilots to maintain adequate visual lookout to see-and-avoid each other. Factors related to the accident were: physical impairment of the pilot in…NTSB MIA90FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Sebastian, FLFailure of the AA-1A pilot to see-and-avoid the Piper PA-28 which had entered traffic first. A factor related to the accident was: failure of the PA-28 pilot to see the American AA-1A, when the AA-1A was on a base leg and the PA-28 was further out on final…NTSB DEN90LA048Accident · No injuriesLimited investigationFinal reportCameron N105 · Littleton, COInadequate compensation for the wind conditions by the pilot in command.NTSB ATL90LA059Accident · No injuriesLimited investigationFinal reportCessna 425 · Augusta, GAFailure of the pilot to maintain control of the aircraft during the go-around. A factor related to the accident was: the pilot's delay in initiating the go-around.NTSB ATL90FA056Accident · Serious injuriesField investigationFinal reportCessna 150F · Weaver, ALThe pilot misjudged distance and altitude to the runway during a simulated engine-out approach, and failed to maintain clearance from trees. Factors related to the accident were: dusk light conditions, and the pilot's lack of recent experience in the make and…NTSB ATL90LA058Accident · No injuriesLimited investigationFinal reportBeech C24R · Greer, SCThe pilot in command's improper flare which resulted in a hard landing.NTSB ANC90FA032Accident · Minor injuriesField investigationFinal reportCessna 182 · Anchorage, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: the obstructions (utility pole, power line & fence) in the emergency landing area.NTSB DCA90MA019Accident · 73 fatalClass 1 · MajorFinal reportBoeing 707-321B · Cove Neck, NYThe failure of the flightcrew to adequately manage the airplane's fuel load, and their failure to communicate an emergency fuel situation to air traffic control before fuel exhaustion occurred. Contributing to the accident was the flightcrew's failure to use…NTSB FTW90LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Austin, TXFailure of the rocker arm in the engine driven fuel pump.NTSB CHI90DET03Accident · 1 fatalFinal reportPterodactyl Ascender II+2 · Lake Village, INIn-flight structural failure of the right wing spar.NTSB LAX90LA074Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ramona, CAThe pilot encountered a tailwind while on final approach, but delayed the go-around. During the go-around the pilot failed to maintain airspeed and entered a descent (settling with power).NTSB LAX90LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Coalinga, CAThe pilot's misjudgement of distance and altitude to the runway, while on final approach, which resulted in his failure to attain the proper touchdown point for landing. Factors related to the accident were: darkness, haze, and soft terrain in the area where…NTSB LAX90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32-R-300 · Sacramento, CAAn inadvertent collision with a large bird during the hours of darkness while in the landing pattern.NTSB LAX90LA071Accident · No injuriesLimited investigationFinal reportNorth American Navion · Apple Valley, CAThe pilot failed to properly preflight the airplane and departed on the accident flight with minimal fuel.NTSB CHI90LA071Accident · No injuriesLimited investigationFinal reportCessna 177B · Acme, MIThe student pilot misjudged distance and altitude to the runway, and the instructor pilot (CFI) failed to attain remedial action, which resulted in their failure to attain the proper touchdown point. Factors related to the accident were: the cfi's lack of…NTSB MKC90MA049Accident · 7 fatalMajor investigationFinal reportGrumman G1159 · Little Rock, ARFailure of the pilot-in-command to follow IFR procedures (maintain an ILS glide path or initiate a missed approach) during an IFR arrival to the airport. Factors related to the accident were: unfavorable weather conditions, an erroneous wind indication from…NTSB ANC90LA030Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Anchorage, AKThe pilot misjudged his distance and altitude to the runway on final approach, and failed to attain the proper touchdown point. Factors related to the accident were: dark night, unfavorable wind wind conditions and snow covered terrain.NTSB MIA90LA057Accident · No injuriesLimited investigationFinal reportBeech 400 · West Point, MSThe pilot misjudged distance, speed, and altitude on final approach, and failed to attain the proper touchdown Point for landing.NTSB MIA90LA056Accident · Minor injuriesLimited investigationFinal reportCessna 404 · Boca Raton, FLLoss of power in the right engine due to a disconnected duct between the turbocharger and the plenum chamber. The reason for the loss of power in the left engine was not determined.NTSB CHI90FA066Accident · Serious injuriesField investigationFinal reportCessna 402A · Mosinee, WIThe pilot disregarding the published decision height and not performing a missed approach.NTSB CHI90FA065Accident · 1 fatalField investigationFinal reportCessna 402B · Appleton, WIThe pilot's decision to continue flight into known adverse weather conditions resulting in a windshear encounter with insufficient altitude for recovery. The existing adverse weather conditions were factors.NTSB NYC90FA054Accident · 3 fatalField investigationFinal reportCessna 310R · Burlington, VTFor an unknown reason, the aircraft entered a descent and crashed in a lake.NTSB MKC90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Dexter, MOThe pilot misjudged his distance and altitude on final approach, and failed to reach the proper touchdown point for landing. The gusty crosswind condition was a related factor.NTSB DEN90FA042Accident · Serious injuriesField investigationFinal reportFairchild SA227-AC · Elko, NVImproper IFR procedure by the captain, and inadequate monitoring of the approach by the first officer, which resulted in a failure to maintain proper altitude during the approach. Factors related to the accident were: the terrain and weather conditions at the…NTSB MKC90LA047Accident · Serious injuriesLimited investigationFinal reportBurnett Starduster TOO · Lawrence, KSThe pilot misjudged clearance from tree(s) near the approach end of the runway, while on final approach to land. Factors related to the accident were: sunglare, lack of visual cues to the pilot, and tree(s).NTSB MKC90LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hornersville, MOPoor judgement of the pilot due to consumption of alcohol, and his misjudgement of distance and altitude to the runway, while on final approach, which subsequently resulted in a touchdown and nose over short of the runway.NTSB DEN90LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Provo, UTFuel starvation due to pilot misjudgement of fuel requirements for the trip and a failure to refuel the airplane en route.NTSB LAX90LA067Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Van Nuys, CAThe pilot's failure to maintain adequate airspeed during final approach which allowed the aircraft to stall and collide with the runway.NTSB LAX90LA066Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Santa Ana, CAThe failure of bolts retaining the idler shaft allowing the cam shift timing to change and by its failure to drive the left magneto.NTSB LAX90FA068Accident · 1 fatalField investigationFinal reportCessna 182P · Napa, CAThe failure of the pilot to properly execute the published approach and missed approach which resulted in a collision with mountainious terrain.NTSB CHI90LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · Traverse City, MIImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB MIA90FA050Accident · Serious injuriesField investigationFinal reportPiper PA-30 · Tallahassee, FLPilot factor in that he failed to maintain a/c control in instrument meteorological conditions due to spatial disorientation caused by fixation of an undetermined light source.NTSB LAX90LA059Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Santa Barbara, CAThe pilot's failure to maintain adequate terrain clearance during a night visual approach.NTSB MKC90LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Norfolk, NEInproper in-flight planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: the adverse weather conditions, the pilot's lack…NTSB CHI90LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jenison, MIThe pilot's failure to maintain adequate airspeed during the approach. A contributing factor was the icing condition that existed at the time of the accident.NTSB MIA90FA044Accident · Serious injuriesField investigationFinal reportCessna 210M · Stuart, FLThe pilot's improper calculation of fuel consumption which resulted in an inadequate fuel supply to reach his destination.NTSB FTW90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Clinton, OKPilots failure to correctly maintain the proper glidepath, which caused him to impact short of the runway.NTSB CHI90FA056Accident · No injuriesField investigationFinal reportCessna 340 · Merrill, WIFailure of the pilot to maintain proper alignment with the runway during his landing roll and an inflight encounter with icing conditions.NTSB CHI90FA050Accident · 2 fatalField investigationFinal reportBeech 60 · Erie, PAThe pilot's failure to assure that the aircraft had an adequate supply of fuel on board for the intended flight. Contributing factors to the accident were an inoperative right fuel quantity gage which resulted in inaccurate fuel consumption calculations, and…NTSB NYC90LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · No. Andover, MAThe pilot inadvertently turned off the magneto switch during a go-around, resulting in a loss of power. Also causal to the accident was the failure of the pilot of a second airplane to respond to the tower controller's instructions. A factor related to the…NTSB FTW90FA046Accident · Serious injuriesField investigationFinal reportBell 206L-1 · S Marsh Is 7The pilot's failure to recognize and correct a situation involving loss of tail rotor effectiveness, resulting in loss of aircraft control.NTSB DCA90MA011Accident · 6 fatalClass 1 · MajorFinal reportBritish Aerospace BAE-3101 · Pasco, WAThe flightcrew's decision to continue an unstabilized instrument landing system (ILS) approach that led to a stall, most likely of the horizontal stabilizer, and loss of control at low altitude. Contributing to the accident was the air traffic controller's…NTSB ATL90LA046Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Selmer, TNThe failure of the instructor to place the engine mixture control in the rich position prior to beginning traffic pattern maneuvers. As a result, the engine quit because of the lean fuel mixture at the high power setting required for the go-around and…NTSB MIA90LA041Accident · No injuriesLimited investigationFinal reportCessna 150 · Orlando, FLThe pilot's loss of control of the aircraft due to a loss of consciousness brought on by reactive hypoglycemia.NTSB FTW90DQG01Accident · 1 fatalFinal reportSenior Aerosport/Paet PJ 260 · Hereford, TXThe pilot's failure to maintain adequate obstacle clearance on the approach to landing. A factor was the power pole just short of the end of the runway.NTSB ATL90LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Danielsville, GAInadequate preflight preparation/planning by the pilot, by not assuring an adequate supply of fuel, which resulted in fuel exhaustion. Related factors were: a false fuel quantity indication, trees in the emergency landing area, and failure of the landing gear…NTSB ANC90LA017Accident · No injuriesLimited investigationFinal reportBeech 18 · Brevig Mission, AKLoss of power in the the right engine for an unknown reason. The rough/uneven terrain was a contributing factor.