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 CHI95IA138Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Washington, DCthe pilot's excessive use of the flight controls during the landing approach, the company's disregard of information provided by the airplane manufacturer, and the company's failure to identify a potentially hazardous conditions based on the information…NTSB NYC95LA095Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Robbinsville, NJLoss of engine for undetermined reasons.NTSB ATL95LA091Accident · Minor injuriesLimited investigationFinal reportBeech S-35 · Huntsville, ALA loose wire which shorted between an exposed terminal on the avionics bus relay and the oil line to the oil pressure gage, and the failure of maintenance personnel to tie up loose wires.NTSB NYC95LA092Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Cleveland, OHthe loss of engine power for undetermined reasons, and the pilot's improper decision to fly an extended landing pattern after experiencing a partial loss of engine power.NTSB LAX95LA170Accident · No injuriesLimited investigationFinal reportCessna 180 · Los Banos, CAfuel exhaustion due to the pilot's inadequate preflight planning and preparation.NTSB CHI95LA133Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Elk Creek, WIthe pilot's failure to maintain clearance with the trees. Factors in the accident include the trees, the tailwind condition, and the pilot's lack of proper certification.NTSB MIA95LA116Accident · 1 fatalLimited investigationFinal reportKorzep Bumble BEE 500 · Titusville, FLThe failure of the pilot to maintain rotor RPM, resulting in the subsequent in flight loss of control. The pilot's lack of qualification was a factor.NTSB ATL95FA087Accident · 1 fatalField investigationFinal reportDuke, Clarence E. Lancair 360 · Hampton, GAThe loss of engine power for undetermined reasons. A factor in the accident was the pilot's lack of recent flying experience.NTSB CHI95FA126Accident · 4 fatalField investigationFinal reportCessna 150M · Oshkosh, WIInadequate visual lookout by the pilot of the Beech V35B, resulting in his failure to see-and-avoid the Cessna 150, which was ahead and below him on final approach; and failure of the tower controller to provide adequate service (flight advisories and landing…NTSB LAX95LA159Accident · No injuriesLimited investigationFinal reportK. A. Covington Lancair 320 · Prescott, AZthe pilot's failure to attain a stabilized approach due to an improper elevator trim setting resulting in an improper flare.NTSB NYC95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Wilmington, OHThe flight instructor's inadequate supervision of the student pilot during the approach, resulting in a loss of control and hard landing. The gusty wind condition was a factor.NTSB LAX95LA158Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Lakeport, CAthe student's misjudged landing flare and his failure to verify the validity of the low rotor warning. Factors in the accident were the company management's continued use of the helicopter in flight training operations with a known discrepancy in the main…NTSB ATL95LA081Accident · Serious injuriesLimited investigationFinal reportEccker, Donald E. Rans S-10 · Wilson, NCThe pilot's failure to maintain control of the airplane during the touchdown phase of the emergency landing to the runway. The lack of a carburetor heat system and the carburetor icing weather conditions were factors.NTSB MIA95LA102Accident · No injuriesLimited investigationFinal reportGarrison Kolb Twinstar · Lakeland, FLFailure of the pilot to maintain airspeed resulting in the inadvertent stall. Contributing to the accident was complacency by the pilot while on short final approach to land.NTSB MIA95FA100Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · St. Petersburg, FLThe failure of the pilot to extend wing flaps and maintain airspeed while on approach to land resulting in an inadvertent stall, spin, and uncontrolled descent until collision with a residence and the ground.NTSB FTW95LA161Accident · Minor injuriesLimited investigationFinal reportGardner Varieze · Addison, TXThe jammed throttle. Factors were the knob becoming loose and separating from the throttle lever, and the lack of suitable terrain available for the forced landing.NTSB LAX95LA164Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Peoria, AZthe pilot's misjudged evaluation of the weather, and his inadequate compensation for the gusting winds and downdrafts.NTSB FTW95LA160Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Orange, TXThe pilot's delayed landing flare. Factors were fuel exhaustion due to the pilot's failure to stop and refuel.NTSB BFO95FA045Accident · 3 fatalField investigationFinal reportCessna 172M · Eldersburg, MDThe pilot's failure to maintain proper airspeed. Factors in the accident were the pilot's failure to remove carburetor heat during the go-around and the presence of a tailwind.NTSB CHI95IA116Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Moline, ILthe defective weld and the subsequent in flight failure of the welded plug located in the piston of the roll spoiler actuator. The manufacturer's inadequate design is a related factor.NTSB NYC95LA082Accident · No injuriesLimited investigationFinal reportCessna 150G · Dayton, OHthe pilot's inadequate preflight and inflight planning, resulting in fuel exhaustion and loss of engine power, and the subsequent nose over during a forced landing.NTSB BFO95LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Erie, PAThe loss of engine power for undetermined reasons.NTSB ATL95LA072Accident · No injuriesLimited investigationFinal reportCessna 172N · Paris, TNThe failure of the pilots of both aircraft to maintain proper visual lookout during landing at the uncontrolled airport.NTSB ANC95LA041Accident · No injuriesLimited investigationFinal reportCessna 170A · Anchorage, AKThe pilot's failure to correct for torque/p factor when adding engine power for the go-around maneuver. The pilot's misjudged flare, delayed go-around, and lack of total experience were factors in the accident.NTSB ANC95LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKA failure of the instructor pilot to adequately supervise the student pilot's landing approach. The student pilot's failure to maintain a proper altitude and distance to the runway touch-down point, and a snow berm at the approach end of the runway were…NTSB ATL95LA070Accident · No injuriesLimited investigationFinal reportRoggio Rotorway Executive · Toccoa, GAThe pilot's failure to use carburetor heat which resulted in the loss of engine power. A factor was weather conditions favorable for the formation of carburetor ice.NTSB ATL95LA069Accident · Minor injuriesLimited investigationFinal reportAerotek Zuni · Morganton, NCThe pilot's poorly planned approach which resulted in the loss of control of the aircraft because of gusty wind conditions.NTSB LAX95FA141Accident · 1 fatalField investigationFinal reportCessna 208B · Reno, NVthe pilot's failure to comply with published instrument approach procedures by a premature descent below the minimum altitude specified for the approach.NTSB ATL95LA066Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Cleveland, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion during the final approach for landing.NTSB SEA95LA069Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau Bergfalke II-55 · Bozeman, MTThe pilot misjudged his altitude and distance from the runway. A factor was the pilot's failure to obtain the current altimeter setting.NTSB NYC95LA074Accident · Serious injuriesLimited investigationFinal reportBeech T-34B · Jackson, NJthe flight instructor's attempt to maintain visual reference with the ground, and his delayed remedial action to the dual student's actions, which resulted in an inadvertent tree strike. Factors were the lack of recent night experience for both pilots, the…NTSB MIA95LA090Accident · No injuriesLimited investigationFinal reportCessna 177 · Miami, FLThe pilot-in-command's/CFI improper supervision of the dual student during a simulated short field approach for landing. This resulted in an in-flight loss of control (inadvertent stall), and subsequent hard landing.NTSB LAX95LA138Accident · No injuriesLimited investigationFinal reportBell 47 · Harmon Fieldan engine failure due to oil exhaustion from a missing oil pressure relief valve as the result of an improper maintenance inspection.NTSB LAX95IA142Incident · No injuriesIncident investigationFinal reportBeech 1900C · Los Angeles, CAAn axial shift of the outer bearing roller for an undetermined reason, resulting in erosion and failure of the flap track hinge bracket/bearing assembly. Factors relating to the incident were: the roller bearing and associated bracket assembly within the…NTSB CHI95LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lakeville, MNThe pilot misjudged distance and altitude during landing.NTSB NYC95FA068Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Suffolk, VAThe pilot's inadequate preflight and improper in-flight planning/decision, which resulted in fuel exhaustion. Darkness was a factor related to the improper planning/decision-making for the emergency landing.NTSB NYC95LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Wilmington, OHThe pilot's failure to maintain adequate terrain clearance during a go around, which resulted in an inflight collision with a snowbank. A factor is the pilot's delay in initiating a go around.NTSB CHI95LA100Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOThe pilot misjudged the fuel supply.NTSB MIA95LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crystal Springs, MSThe failure of the pilot in command to insure the aircraft contained adequate fuel to complete the flight.NTSB BFO95LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Belfast, MEthe student pilot's failure to adequately compensate for wind conditions. A related factor was the presence of high snowbanks along the sides of the runway.NTSB ATL95FA057Accident · 2 fatalField investigationFinal reportCessna 208B · Gainesville, GAThe pilots failure to maintain the minimum descent altitude during the approach. The weather and dark night light condition were factors.NTSB SEA95LA058Accident · No injuriesLimited investigationFinal reportMooney M20C · Omak, WAThe elevator push rod separation due to fatigue. Factors contributing to the accident were the pilot in command's failure to insure compliance with the airworthiness directive and the frozen push rod bearing.NTSB ATL95LA058Accident · No injuriesLimited investigationFinal reportCessna 150L · Jefferson, GAThe loss of engine power because of sticking valves. A factor was the continuous use of an improper fuel grade.NTSB FTW95FA129Accident · Minor injuriesField investigationFinal reportCessna 208B · Ardmore, OKThe pilot's continued flight into adverse weather conditions. Factors were the icing conditions prevailing at the destination airport, and the pilot's inability to maintain visual lookout due to windshield icing.NTSB FTW95LA128Accident · Serious injuriesLimited investigationFinal reportBeech 58P · Montrose, COThe pilot's failure to refuel the airplane resulting in a forced landing. The adverse weather conditions were factors.NTSB LAX95LA121Accident · 1 fatalLimited investigationFinal reportThunder and Colt GA42 · Hayward, CAthe pilot's decision to operate the blimp with a known and unresolved deficiency in the electrical system, which led to a loss of the flight controls and the pilot's improper remedial actions after the blimp came to rest on the ground.NTSB BFO95FA028Accident · 1 fatalField investigationFinal reportCessna T210M · Youngstown, OHloss of engine power for undetermined reason(s). Factors relating to the accident were: the weather conditions (restricted visibility with snow falling), reduced light condition at dusk, and the lack of suitable terrain for an emergency landing.NTSB ATL95FA054Accident · 2 fatalField investigationFinal reportPiper PA-30B · Franklin, NCThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. A factor was sunglare.NTSB LAX95LA116Accident · No injuriesLimited investigationFinal reportCessna 150G · Carefree, AZthe pilot's premature retraction of the flaps and failure to maintain an adequate airspeed during a go-around, which resulted in an inadvertent stall/mush.NTSB NYC95LA057Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Warwick, NYthe pilot allowed the airplane to get too low on the approach, during a simulated engine out landing, which resulted in impacting high bushes, and landing short of the runway.