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 DEN89LA182Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Weston, COWater in the fuel and inadequate preflight by the pilot. A contributing factor was the ditch.NTSB MIA89LA201Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Leesburg, FLFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall as he initiated a go-around.NTSB MKC89LA162Accident · No injuriesLimited investigationFinal reportRockwell S2R · Bono, ARThe pilot's failure to maintain airspeed during a go-around resulting in the airplane stalling/mushing and descending out of control until collision with trees.NTSB FTW89LA140Accident · 2 fatalLimited investigationFinal reportAeronca 7AC · Gueydan, LAThe pilot's inadvertent spin entry at pattern altitude which resulted in ground collision.NTSB NYC89FA166Accident · 3 fatalField investigationFinal reportPiper PA-28-236 · Thomasville, PAThe pilot's failure to fly the published approach procedure, which resulted in controlled flight into the terrain.NTSB LAX89LA240Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Chandler, AZInadequat preflight planning/preparation and the improper flight planning/decisions, ie. Improper fuel consumption calculations, by the PIC.NTSB FTW89FA136Accident · 2 fatalField investigationFinal reportPiccard AX-6 · Houston, TXThe pilot's failure to abort the attempt to clear the obstacle. Factors in the accident were: the poor condition of the balloon envelope and the pilot's lack of experience as pilot in command of balloon operations.NTSB FTW89LA139Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Llano, TXThe pilot's inadvertent closing of the mixture control while his attention was diverted to the landing gear cycling. The engine subsequently quit followed by a forced landing and collision with trees.NTSB MIA89FA192Accident · No injuriesField investigationFinal reportCessna 152 · Miami Lakes, FLThe failure of the pilot to visually inspect the airplane fuel tanks during the preflight inspection to assure adequate fuel to conduct the flight was available.NTSB FTW89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Blanco, TXInadequate in-flight planning/decisions by not identifying the wind direction along with the failure to maintain airspeed. Contributing to the accident was the tailwind, wires and trees.NTSB MIA89IA186Incident · No injuriesIncident investigationFinal reportBell 206L-1 · Chiefland, FLEngine failure due to failure of the first stage turbine wheel disk.NTSB LAX89LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-30B-160 · Merced, CAThe pilot's inadequate preflight planning/preparation, resulting in fuel exhaustion.NTSB DEN89FA155Accident · Serious injuriesField investigationFinal reportPiper PA-16 · Minot, NDFailure of the airframe tubing (longeron) at the lower forward door frame due to corrosion. A contributing factor was failure of maintenance personnel to comply with service bulletin #819.NTSB ANC89LA114Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKA blocked fuel line between the fuel selector and the engine which caused fuel starvation.NTSB MIA89FA181Accident · 1 fatalField investigationFinal reportWood-Oldfield Baby Great Lakes · Clermont, FLFailure of the pilot to maintain airspeed which resulted in an inadvertent stall/spin. A contributing factor was the pilot's lack of experience in the aircraft.NTSB FTW89LA129Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Elmendorf, TXPilot's decision to discontinue the use of carburetor heat, in carburetor icing conditions, that led to a complete loss of power at an altitude insufficient for a safe landing on the airport.NTSB DEN89LA151Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Ennis, MTThe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall.NTSB CHI89FA124Accident · 1 fatalField investigationFinal reportCessna 150L · Sugar Grove, ILFailure to maintain airspeed above stall speed, and a stall/spin encountered with inadequate altitude for recovery. Factors related to the accident were: thunderstorm, pre-flight briefing not obtained and poor weather evaluation by the pilot.NTSB DEN89LA164Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Telluride, COThe pilot's failure to maintain aircraft control during an encounter with turbulence. Contributing to the accident was the turbulence.NTSB CHI89DEP12Accident · Serious injuriesFinal reportSchuning/Teratorn Terra II · New Berlin, WIFailure of the pilot to maintain adequate airspeed during the go-around, which resulted in an inadvertent stall.NTSB ANC89LA103Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Iliamna, AKInadequate annual inspection by maintenance personnel.NTSB LAX89LA224Accident · No injuriesLimited investigationFinal reportCessna 340 · Paso Robles, CAImproper use (mismanagement) of the fuel system by the pilot, which resulted in fuel starvation. Related factors were: the lack of fuel quantity indicators (not installed) in the aircraft, flight by the pilot with this known deficiency, and trees in the…NTSB DEN89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180 · Broomfield, COThe failure of the student to properly plan the flt resulting in fuel exhaustion.NTSB ANC89IA099Incident · No injuriesIncident investigationFinal reportDe Havilland DHC-3 · Palmer, AKInadequate lubrication which resulted in the failure of the horizontal stabilizer's trim actuator.NTSB LAX89LA222Accident · 2 fatalLimited investigationFinal reportAmerican AA-1C · Kalaupapa, HIThe pilot's failure to maintain sufficient airspeed to prevent a stall from which there was insufficient altitude to recover.NTSB DEN89LA140Accident · No injuriesLimited investigationFinal reportSchweizer 1-26E · Elbert, COThe pilot's improper inflight planning which placed the aircraft too FAR from the runway to complete a normal landing.NTSB CHI89LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Port Huron, MIImproper in-flight planning/decision by the student pilot and his inadvertent encounter with wake turbulence from the transport aircraft. The student's lack of total experience was considered a contributing factor.NTSB CHI89LA111Accident · No injuriesLimited investigationFinal reportBoeing E75 · Shelbyville, INThe pilot allowed his attention to be devaited, misjudged altitude and distance to the runway while on final approach, and failed to maintain clearance above the power lines. Contributing factors were: the power lines and parked aircraft.NTSB MIA89LA175Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Miramar, FLInadequate planning/decision by the pilot, which resulted in loss of engine power due to fuel exhaustion. A contributing factor was the faulty reading from the fuel quantity indicator.NTSB ATL89FA160Accident · Minor injuriesField investigationFinal reportGrumman American AA-5 · Columbus, OHThe student pilot's improperly planned approach, and inadequate supervision by the instructor pilot (CFI), which led to an encounter with wake turbulence and a loss of aircraft control.NTSB DEN89LA136Accident · No injuriesLimited investigationFinal reportCessna 150M · Gooding, IDImproper inflight decision of the pilot to continue the flight without refueling which resulted in fuel exhaustion.NTSB BFO89LA044Accident · No injuriesLimited investigationFinal reportCessna 172A · Madison Heights, VAStudent pilot's failure to maintain proper airspeed during the landing attempt which resulted in the initiation of a go-around. Contributing factors to the accident were the pilot's poor preflight planning and his becoming disoriented during the flight. Also…NTSB FTW89LA112Accident · Minor injuriesLimited investigationFinal reportSwift GC-1B · Luther, OKFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. The proximity of the trees were a factor.NTSB SEA89FA103Accident · 1 fatalField investigationFinal reportWhittaker Bushby Mustang 1 · Alderwood Manor, WAPilot's failure to maintain proper airspeed. Contributing factors were the pilot's poor judgement in flying a traffic pattern at tree-top level and a tailwind condition during the steep turn to final.NTSB MIA89FA172Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Ashland, VAImproper go-around by the pilot by not maintaining a climb and obtaining proper altitude before turning. The pilot's poor approach and the trees were considered to be contributing factors.NTSB FTW89DRD06Accident · No injuriesFinal reportGrumman-Schweizer G-164B · Ville Platte, LAWear and/or failure of the carburetor/float. Factors related to the accident were: the terrain conditions.NTSB MKC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Buffalo, MNMisjudgement of altitude and distance by the student and inadequate supervision of flight by the instructor (CFI). Contributing factors were: unfavorable wind conditions, high vegetation (grass), and a ditch.NTSB DEN89FA131Accident · 1 fatalField investigationFinal reportBoeing PT-17 · Meeker, COThe inadvertent stall-spin at an altitude insufficient to effect a safe recovery. Contributing factors include high density altitude and wind shear.NTSB FTW89LA106Accident · No injuriesLimited investigationFinal reportBell 206L · Abbeville, LAPartial loss of engine power for an undetermined reason. Factors related to the accident were: person(s) in the intended emergency landing area and soft terrain where the helicopter touched down.NTSB FTW89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Stratford, TXImproper planning/decision by the pilot, and his inadequate compensation for wind conditions, which resulted in a loss of aircraft control. The wind condition was a related factor.NTSB DEN89FA127Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Wilmington, OHThe failure of the pilot to assure an adequate fuel supply and his failure to refuel en route.NTSB ATL89LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Medina, OHFailure of airport management to establish a displaced threshold which would provide adequate obstruction clearance. Factors contributing to the accident were the power lines, the utility pole and the dusk light conditions.NTSB SEA89LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Bend, ORThe pilot allowed his attention to be diverted by a crosswind and failed to maintain clearance from trees on approach.NTSB CHI89LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA28R-180 · Frankfort, ILPilot's failure to maintain directional control while attempting to land in cross/tailwind conditions.NTSB ANC89LA081Accident · No injuriesLimited investigationFinal reportCessna 185F · Kahiltna Glac, AKThe pilot's decision to commit himself to a landing before completing an evaluation of the weather in the vicinity of the landing site. Contributing to the severity of the accident was the snowbank off the side of the runway with which the aircraft collided.NTSB LAX89LA207Accident · No injuriesLimited investigationFinal reportCessna A185F · Jackson, CAThe pilot did not establish a climb rate sufficient enough to clear trees before turning towards them during a go-around. Contributing to the accident were gusty crosswinds which changed to a tailwind when the aircraft turned to the right and the pilots…NTSB BFO89LA037Accident · Serious injuriesLimited investigationFinal reportSchweizer I-26E · Churchville, MDThe pilot's failure to maintain adequate airspeed during the turn from base to final approach which resulted in the wing contacting the ground and the glider cartwheeling.NTSB FTW89LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Crosbyton, TXThe pilot's judgement of altitude and distance while on an approach to land. Factors related to the accident were: the high wind, transmission line, and airport fuel tank.NTSB MKC89FA116Accident · 2 fatalField investigationFinal reportBeech D55 · Greenwood, INInadequate preflight and improper use of the fuel system, which resulted in fuel starvation, and improper use of emergency procedures. Factors related to the accident were: self induced pressure by the pilot to meet an arrival time, his failure to extend the…NTSB MKC89LA113Accident · Minor injuriesLimited investigationFinal reportAmerican AA5-B · Valentine, NEThe pilot delayed initiating a go-around after not attaining a proper touchdown point during the approach to land. Contributing factors were the high density altitude and the trees off the departure end of the runway.