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 DFW06CA017Accident · No injuriesData collectionFinal reportHawker Siddeley 125-700 · Houston, TXThe pilot-in-command's failure to attain proper runway alignment.NTSB CHI06CA014Accident · No injuriesData collectionFinal reportCessna 210C · Kankakee, ILA hydraulic line leak causing a loss of hydraulic fluid and subsequent failure of the hydraulic system. An additional cause was the inoperative landing gear extension system, both normal and emergency, due to a complete loss of the hydraulic system.NTSB CHI06CA013Accident · Minor injuriesData collectionFinal reportCessna 152 · Peoria, ILThe student pilot's failure to maintain adequate airspeed during a go-around which resulted in the airplane stalling.NTSB ATL06LA008Accident · 1 fatalLimited investigationFinal reportElan/Glaser Dirks DG-300 · Brownsboro, ALThe pilot's misjudgment of distance/altitude on final approach which resulted in an undershoot of the runway, and an in-flight collision with a embankment. A factor was the dirt bank/rising terrain.NTSB SEA06LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Newberg, ORThe flight instructor's failure to maintain airspeed while on approach for landing resulting in an inadvertent stall. Wind gusts, trees and an undetermined loss of engine power were factors.NTSB CHI06LA012Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Williams, MNThe pilot's failure to maintain airspeed which resulted in the airplane stalling. Factors associated with the accident were the low level at which the airplane was maneuvering and the pilot's failure to perform weight and balance calculations prior to the…NTSB SEA06CA008Accident · No injuriesData collectionFinal reportWilliams Challenger II · Spokane, WAThe loss of all engine power while on downwind for undetermined reasons.NTSB NYC06MA005Accident · 1 fatalMajor investigationFinal reportAugusta 109E · Smethport, PAThe pilot's failure to maintain aircraft control. Factors in the accident were, night instrument meteorological conditions, pilot workload, and improper air traffic control procedures by the approach controller.NTSB NYC06FA004Accident · 3 fatalField investigationFinal reportBeech A36 · Pikeville, KYThe pilot's failure to follow the published instrument approach which resulted in controlled flight into terrain. A factor was the low ceiling.NTSB NYC06CA006Accident · Minor injuriesData collectionFinal reportMooney M20K · Ithaca, NYThe pilot's failure to comply with the published instrument approach procedure, which resulted in an in-flight collision with trees.NTSB ATL06CA002Accident · Serious injuriesData collectionFinal reportPiper PA-28-181 · Pageland, SCThe pilots failure to maintain flying speed during the go-around, which resulted in a stall and the subsequent collision with trees.NTSB NYC06LA002Accident · Serious injuriesLimited investigationFinal reportEmbraer 170 · Dulles, VAThe flight crew's excessive maneuver in response to a traffic alert during the landing approach.NTSB NYC06CA053Accident · No injuriesData collectionFinal reportBeech E-55 · Providence, RIThe pilot's failure to verify landing gear extension after a landing gear malfunction, which resulted in a wheels up landing.NTSB DFW05FA251Accident · 2 fatalField investigationFinal reportCessna 150M · Crystal Springs, MSThe pilot's failure to retract the flaps during the go-around and his failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the dark night conditions.NTSB MIA05CA161Accident · Minor injuriesData collectionFinal reportVans RV-3 · Bell, FLThe pilot's failure to maintain visual lookout during a VFR approach toward the runway resulting in-flight collision with trees. Factors in this accident are no lights for the grass strip runway and attempting to land in low natural light visibility…NTSB IAD05CA148Accident · No injuriesData collectionFinal reportSchweizer SGS-2-33A · Windsor, VAThe solo student pilot's loss of control during landing.NTSB LAX05CA310Accident · Minor injuriesData collectionFinal reportClark Vans RV8 · Sonoma, CAa loss of engine power due to the failure of the master electrical power switch, which removed power to the electronic ignition.NTSB DEN05LA140Accident · No injuriesLimited investigationFinal reportCessna A185F · Boulder, COthe pilot's improper flare which resulted in a hard landing and his subsequent failure to recover from the bounced landing. Contributing factors were the pilot's improper in-flight decision to land in deteriorating weather conditions, turbulence associated…NTSB CHI05FA260Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Wabash, INThe pilot's spatial disorientation that resulted in his failure to maintain clearance from terrain. Factors to the accident were the pilot's lack of recent night experience and the hazy night conditions.NTSB IAD05CA134Accident · Serious injuriesData collectionFinal reportLamont Aventura II · Hope, METhe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with water. A factor to the accident was the wind gusts.NTSB CHI05CA263Accident · Minor injuriesData collectionFinal reportKeith Avid Amphibian · Buchanan, MIThe loss of engine power for undetermined reasons and the unsuitable terrain for landing encountered by the pilot. A factor was the power lines.NTSB NYC05FA140Accident · 1 fatalField investigationFinal reportCessna 177A · S. Hackensack, NJThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and subsequent loss of engine power. A factor in the accident was the pilot's impairment from prescription medication.NTSB SEA05LA189Accident · No injuriesLimited investigationFinal reportBallhagen/Shyrock Q-2 · Kalispell, MTThe pilot/owner's improper setting of the engine's valve clearance, leading to the failure of the exhaust valves to fully close and a total loss of power while on a VFR downwind, and the pilot/owner's failure to maintain sufficient airspeed as he tried to…NTSB LAX05LA286Accident · 1 fatalLimited investigationFinal reportCessna 172 · Yuma, AZthe pilot's failure to maintain an adequate airspeed on short final, which resulted in an inadvertent stall.NTSB DEN05CA132Accident · No injuriesData collectionFinal reportCessna 180J · Afton, WYloss of engine power for reasons undetermined.NTSB IAD05LA126Accident · 1 fatalLimited investigationFinal reportCessna 172H · Corry, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and collision with terrain.NTSB ANC05LA128Accident · No injuriesLimited investigationFinal reportGardner SR3500 · Anchorage, AKThe malfunction of the propeller reversing system during landing, which allowed the propeller to reverse pitch in-flight, resulting in an uncontrolled descent and impact with terrain.NTSB NYC05CA135Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Hancock, NYThe pilot's inadequate compensation for wind conditions, which resulted in the airplane impacting the ground. A factor in the accident was the downdraft wind condition, as reported by the pilot.NTSB ANC05LA125Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Skwentna, AKThe pilot's misjudged distance/altitude on final approach, which resulted in a noseover following an undershoot and in-flight collision with rough/uneven terrain. A factor associated with the accident was the rough/uneven terrain.NTSB LAX05LA272Accident · 1 fatalLimited investigationFinal reportPatch Dan F Varieze · San Diego, CAa divergence from the final approach course and an in-flight collision with storage containers for undetermined reasons.NTSB CHI05CA241Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Brodhead, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the vehicle the airplane contacted.NTSB CHI05CA239Accident · No injuriesData collectionFinal reportBeech 36 · Holland, MIThe failure of the pilot to extend the landing gear prior to landing. A factor to the accident was the pilot becoming distracted by his passengers during landing.NTSB ANC05CA124Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Chickaloon, AKThe pilot's misjudged distance and altitude on final approach to land, which resulted in an undershoot and structural damage to the airplane. A factor associated with the accident was a downdraft.NTSB LAX05FA271Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Pomona, CAA loss of engine power during the landing approach due to fuel starvation caused by debris and corrosion in the carburetor assembly. A factor contributing to the accident was the failure of the owner to comply with the manufacturer's service bulletin…NTSB DFW05FA217Accident · 2 fatalField investigationFinal reportBell 206B · Gulf of MexicoThe loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel calculations.NTSB NYC05LA134Accident · 3 fatalLimited investigationFinal reportPiper PA-28-180 · Erie, PAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion on approach, and subsequent loss of engine power.NTSB DEN05FA126Accident · 4 fatalField investigationFinal reportCessna 425 · Lone Tree, COThe pilot's failure to properly execute the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB IAD05LA122Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Saulsville, WVThe pilot's inadequate remedial action following a loss of control during the landing approach.NTSB CHI05LA225Accident · No injuriesLimited investigationFinal reportCessna 210 · Rapid City, SDThe landing gear extension not possible and inoperative flap system due to fatigue failure of a hydraulic system tube during approach. An additional cause was the improper rebuild/remanufacture of the hydraulic tube. Contributing factors were the dependency…NTSB LAX05LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Oro Valley, AZa loss of engine power due to the pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion. Contributing to the accident was the inaccuracy of the cockpit fuel gages which read 1/4 tank when empty.NTSB DEN05LA123Accident · No injuriesLimited investigationFinal reportForbes Rutan Long EZE · Albuquerque, NMa total electrical failure due to a short in the master relay, causing the main fuse to open. Contributing factors included an inadequate electrical design by the airplane's builder, a low-output alternator, a cement wall, and unsuitable terrain on which to…NTSB ANC05LA127Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tyonek, AKThe instructor pilot's inadvertent touchdown during a low pass, and attempted go-around, which resulted in an in-flight collision with terrain, and nose over.NTSB SEA05LA162Accident · 2 fatalLimited investigationFinal reportHarmon/Lance RV-4 · Coolin, IDThe pilot's failure to maintain clearance from trees while maneuvering to base leg for landing. Trees and inadequate in-flight planning were factors.NTSB SEA05CA167Accident · No injuriesData collectionFinal reportCessna 150L · Kellogg, IDThe pilot's failure to follow the correct go-around procedure during landing by advancing the power too rapidly and not repositioning the flaps to the required 20 degree position. Factors include a crosswind and high density altitude.NTSB DFW05FA202Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Parker, COThe pilot’s failure to fly a stabilized instrument approach at night which resulted in controlled flight into terrain. Contributing factors were; the dark night, low clouds, the inadequate design and function of the airport facility’s Minimum Safe Altitude…NTSB LAX05LA258Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Rancho Murieta, CAfuel starvation due to the inadequate fuel system management by both pilots. Also causal was the inadequate preflight inspection by both the instructor and student and their failure to verify the fuel quantities in each fuel tank, and, the instructor's…NTSB LAX05CA252Accident · No injuriesData collectionFinal reportBeech 35-A33 · Shelter Cove, CAthe pilot's failure to maintain adequate airspeed during an attempted go around, which resulted in a stall/mush and collision with the ground.NTSB ANC05CA115Accident · No injuriesData collectionFinal reportPiper PA-18 · Port Heiden, AKThe pilot's misjudged distance/altitude during final approach, which resulted in an undershoot and an in-flight collision with terrain.NTSB LAX05LA248Accident · Minor injuriesLimited investigationFinal reportScandinavian Aero Industry KZ VII · Elko, NVThe pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice and the total loss of engine power.NTSB ATL05LA137Accident · 1 fatalLimited investigationFinal reportCessna T210 · Muscle Shoals, ALThe pilot's inadequate visual lookout, and failure to maintain clearance, which resulted in an in flight collision with a transmission wire.