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 ERA09WA153Accident · Minor injuriesForeign investigationCessna 421B · Nassau, BahamasOn January 29, 2009, at 2130 eastern daylight time, a Cessna 421B, Bahamian registration C6-DXL, operated by a private individual as an air ambulance, experienced a loss of engine power while on approach to the Lynden Pindling International Airport (MYNN),…NTSB ERA09FA148Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Moncks Corner, SCA loss of aircraft control during the landing approach for undetermined reasons.NTSB CEN09MA142Accident · Serious injuriesClass 1 · MajorFinal reportAerospatiale Alenia ATR 42-320 · Lubbock, TXThe flight crew's failure to monitor and maintain a minimum safe airspeed while executing an instrument approach in icing conditions, which resulted in an aerodynamic stall at low altitude. Contributing to the accident were 1) the flight crew's failure to…NTSB ERA09CA142Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLA loss of engine power during approach due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB WPR09CA092Accident · No injuriesData collectionFinal reportRyan Navion · Three Forks, MTA total loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel system management. Contributing to the accident were the pilot's diverted attention and failure to perform the prelanding checklist.NTSB CEN09LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMCollapse of the landing gear during landing due to the incorrect installation of the landing gear actuator. Contributing to the accident was the pilot's failure to initiate the abnormal procedures checklist prior to landing.NTSB ERA09LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jasper, GAA total loss of engine power for an undetermined reason.NTSB CEN09FA135Accident · 3 fatalField investigationFinal reportGulfstream Aerospace Commander · Wray, COThe pilot’s failure to maintain aircraft control during the approach resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s improper preflight planning and conditions conducive for structural icing.NTSB ERA09CA134Accident · Serious injuriesData collectionFinal reportPiper PA-32R-300 · Manteo, NCThe pilot's failure to follow the missed approach procedure while landing with a low ceiling.NTSB ERA09CA171Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAA loss of engine power, as reported by the pilot, for undetermined reasons.NTSB WPR09LA083Accident · No injuriesLimited investigationFinal reportCessna 172RG · Carson City, NVThe overload failure of the landing gear actuator at an undetermined time.NTSB CEN09LA124Accident · Minor injuriesLimited investigationFinal reportLavigna Lancair IV P · Iola, KSThe total loss of engine power for undetermined reasons.NTSB WPR09FA072Accident · No injuriesField investigationFinal reportEurocopter AS 350 BA · Honolulu, HIThe partial loss of engine power during landing for an undetermined reason.NTSB ERA09LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Wilmington, NCA loss of engine power due to the crew's inadequate in-flight fuel monitoring.NTSB ERA09LA124Accident · 1 fatalLimited investigationFinal reportPiper PA-28-160 · Indiana, PAThe pilot's decision to attempt VFR flight in IMC conditions, resulting in a collision with trees during a go-around.NTSB CEN09FA115Accident · 2 fatalField investigationFinal reportNanchang China CJ-6 · Justin, TXThe pilot's failure to maintain adequate airspeed while maneuvering on approach, which resulted in an accelerated stall and subsequent loss of control.NTSB ERA09FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Pittstown, NJThe pilot's failure to maintain an adequate clearance from trees during the night landing approach and the flight instructor's inadequate remedial action.NTSB CEN09CA123Accident · No injuriesData collectionFinal reportCessna T210M · Fort Collins, COA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank before landing.NTSB ERA09LA106Accident · 1 fatalLimited investigationFinal reportReamer RV7A · Wadesboro, NCThe pilot's failure to maintain adequate airspeed while on approach for a precautionary landing, which resulted in an aerodynamic stall.NTSB CEN09CA118Accident · No injuriesData collectionFinal reportSocata TBM 700 · Clovis, NMThe pilot's failure to complete the before-landing checklist, which led to his failure to lower the gear before landing.NTSB CEN09FA098Accident · 2 fatalField investigationFinal reportPiper PA-46 · Hayden, COThe pilot's loss of situational awareness while maneuvering in adverse weather conditions, resulting in spatial disorientation.NTSB CEN09FA099Accident · 1 fatalField investigationFinal reportPiper PA-32R · North Canton, OHThe pilot’s inappropriate control inputs as a result of spatial disorientation, which led to an aerodynamic stall and loss of control. Contributing to the accident were the pilot's decision to conduct flight into known icing conditions, ice accumulation that…NTSB ERA09FA093Accident · 1 fatalField investigationFinal reportBeech 36 · Louisville, KYThe pilot’s continued operation of the aircraft with known deficiencies. Contributing to this accident was the improper sealing of the engine case during overhaul.NTSB CEN09LA095Accident · No injuriesLimited investigationFinal reportCessna 402 · Madison, WIThe pilot’s improper fuel management, which resulted in a loss of engine power during an instrument landing due to fuel exhaustion.NTSB CEN09FA094Incident · No injuriesField investigationFinal reportBombardier CL-600-2C10 · Chicago, ILThe failure of the left landing gear to extend due to improper maintenance when the landing gear door was replaced. Contributing to the incident was the manufacturer's inadequate maintenance manual instructions.NTSB DCA09IA017Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Philadelphia, PAthe failure of the maintenance personnel to properly complete the installation, and the inspection personnel to conduct the proper functional test, of the left main landing gear uplock assembly.NTSB WPR09LA056Accident · 1 fatalLimited investigationFinal reportCessna 172 · Lompoc, CAThe pilot's failure to maintain clearance from the power line. Contributing to the accident was the pilot's lack of recent experience.NTSB CEN09WA082Accident · 2 fatalForeign investigationLearjet Lear 23 · Tlaxcala, MexicoOn December 7, 2008 at approximately 1815 central standard time (CST) a twin-engine turbo fan, Learjet 23, Mexican Registration XC-LGD, was destroyed when it impacted a lake while on final approach to an unlit day visual flight rules airport near Tlaxcala,…NTSB ERA09LA081Accident · No injuriesLimited investigationFinal reportMerrell Stephen F1 Rocket · Sebastian, FLA loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.NTSB ERA09CA073Accident · Minor injuriesData collectionFinal reportExtra Flugzeugbau EA 300/L · Tampa, FLThe pilot's inadequate visual lookout, which resulted in a collision with an object.NTSB WPR09LA049Accident · Serious injuriesLimited investigationFinal reportRaytheon G36 · Porterville, CAA loss of engine power for undetermined reasons.NTSB ERA09CA077Accident · No injuriesData collectionFinal reportCessna 172I · Frederick, MDThe student pilot's delayed decision to abort the landing.NTSB WPR09LA046Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Monterey, CAThe pilot's inadequate fuel system management and inflight planning that led to a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's failure to use the landing checklist.NTSB ERA09FA068Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T4 · Whites Creek, TNThe pilot's failure to feather the left propeller and secure the left engine following the total loss of left engine power, and his subsequent failure to maintain airspeed, lateral, and directional control of the airplane. Contributing to the accident was the…NTSB ERA09LA067Accident · No injuriesLimited investigationFinal reportBeech V35 · Winter Haven, FLBoth pilots’ failure to see and avoid the other airplane. Contributing to the accident was the Beech pilot’s failure to monitor or utilize the common traffic advisory frequency.NTSB CEN09FA070Accident · 3 fatalField investigationFinal reportPiper PA46-500TP · Marshfield, WIThe pilot's failure to maintain control of the airplane during final approach for landing in night, visual meteorological conditions for undetermined reasons.NTSB ERA09LA064Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Groton, CTThe student pilot’s failure to maintain a proper descent profile to avoid trees during the night visual approach and the flight instructor’s inadequate oversight.NTSB ERA09FA060Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIThe pilot's improper descent below the published minimum descent altitude during the approach, which resulted in controlled flight into terrain.NTSB ERA09IA056Incident · No injuriesIncident investigationFinal reportDeHavilland DHC-8-311 · Philadelphia, PAThe mechanical overload of the nosewheel steering links for undetermined reasons, which resulted in nose landing gear rotation and its subsequent wedging within the wheel well structure.NTSB CEN09LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Downers Grove, ILThe pilot's failure to maintain a proper glidepath while on final approach in night conditions, due to his impairment from recent use of alcohol, cocaine, and over-the-counter and prescription medications.NTSB ERA09FA053Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Tallahassee, FLThe pilot's failure to maintain adequate airspeed on final approach, which resulted in a low-altitude aerodynamic stall and spin. Contributing to the accident was the pilot's failure to fly the published instrument approach and his subsequent failure to…NTSB ANC09LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairbanks, AKThe failure of the instructor pilot in the other airplane to maintain separation from the Cessna 182R, and his failure to follow the tower controller’s instructions.NTSB ERA09FA039Accident · 3 fatalField investigationFinal reportPartenavia P.68C · Gainesville, FLThe pilot's failure to maintain the proper glidepath during an instrument-landing-system (ILS) approach. Contributing to the accident were the pilot's decision to initiate the ILS approach with weather below the published minimums, and the pilot's…NTSB ERA09CA038Accident · No injuriesData collectionFinal reportBeech 35-C33 · Atlanta, GAThe pilot’s failure to maintain a proper glide path during the final approach, resulting in a collision with the airport approach lights.NTSB CEN09CA053Accident · No injuriesData collectionFinal reportCessna 172F · Hutchinson, MNThe bird that the airplane struck while on final approach.NTSB ANC09LA009Accident · Minor injuriesLimited investigationFinal reportConstrucciones Aeronauticas CASA-212 · Toksook Bay, AKThe flight crew’s inability to adjust/increase power to the right engine during the landing approach due to an in-flight disconnect of the engine power control linkage, resulting in a loss of control of the airplane. Contributing to the accident was the…NTSB ERA09LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Plymouth, NCThe Piper Dakota (PA-28-236) pilot's failure to see and avoid the Piper Cherokee (PA-32-260).NTSB ERA09CA046Accident · No injuriesData collectionFinal reportHilderson Oswald Aventura HP · Weirwood, VAThe pilot's failure to maintain control of the airplane following an in-flight encounter with turbulence during approach, which led to a loss of engine power due to fuel starvation, and subsequent forced landing into trees.NTSB WPR09LA029Accident · No injuriesLimited investigationFinal reportCessna 421C · Mesa, AZThe failure of the hydraulic landing gear extension systems due to a ruptured line.NTSB WPR09FA027Accident · 2 fatalField investigationFinal reportCessna P206 · Estacada, ORThe pilot's failure to maintain clearance from trees while on approach to land at night. Contributing to the accident was the electrical system failure and the pilot's diverted attention.