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 SEA07LA276Accident · No injuriesLimited investigationFinal reportWerner Vari-Eze · Tooele, UTThe loss of engine power for an undetermined reason. Contributing factors were the lack of suitable terrain for the forced landing and the wind shear conditions encountered during the forced landing attempt.NTSB NYC07LA210Accident · 1 fatalLimited investigationFinal reportCessna 150J · Hazleton, PAThe pilot’s failure to maintain airspeed while maneuvering at low altitude.NTSB NYC07LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Daytona Beach, FLThe inadequate visual lookout of the pilot of the unknown airplane.NTSB DFW07LA191Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Borger, TXA loss of engine power while on approach due to fuel starvation. Contributing to the accident were a corroded carburetor fuel needle valve, inlet fuel screen and no suitable terrain for the forced landing.NTSB SEA07FA247Accident · 6 fatalField investigationFinal reportLancair LC41-550FG · Kernville, CAThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern for landing. Contributing to the accident was the pilot's failure to maintain an adequate airspeed.NTSB MIA07CA138Accident · No injuriesData collectionFinal reportAnthony J. Bencivenga Aventura II · Okeechobee, FLThe pilot's failure to maintain directional control of the airplane during landing, which resulted in the pilot being inadvertently ejected and the airplane's impact with the water during an uncontrolled descent.NTSB CHI07CA291Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-33A · Alliance, OHThe pilot's inattentiveness during the aircraft preflight and his failure to maintain clearance above the trees.NTSB SEA07LA250Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Morgan, UTThe pilot's failure to maintain control of the glider while maneuvering on final approach to landing, which resulted in an collision with a tree. A factor was the wind gust.NTSB DEN07LA160Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lawrence, KSTotal failure of the landing gear retraction/extension assembly. Contributing factors in this accident were worn parts in the landing gear retraction/extension assembly, and mechanical binding of the extension assembly.NTSB SEA07FA240Accident · Serious injuriesField investigationFinal reportFlight Design Ctsw · St. George, UTThe loss of engine power during approach for an undetermined reason. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX07LA257Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Heber, UTThe pilot's failure to maintain sufficient airspeed during landing, resulting in an inadvertent stall/spin, undershoot and collision with the ground.NTSB SEA07IA237Incident · No injuriesIncident investigationFinal reportRaytheon Cobra · Whetstone, AZThe student pilot's failure to follow proper procedures, specifically not verifying that the mode switch was in the automatic position before changing the pilot address, which resulted in a loss of aircraft control. Contributing to the accident was the flight…NTSB CHI07CA275Accident · Minor injuriesData collectionFinal reportWeaver, David A Pulsar 912XP · Plato Center, ILthe pilot's failure to maintain airspeed. Factors were the pilot's lack of familiarity with the aircraft and pilot's failure to maintain altitude.NTSB ATL07CA117Accident · Minor injuriesData collectionFinal reportCessna 172K · Charlotte, NCThe pilot's failure to maintain directional control while landing.NTSB NYC07LA197Accident · No injuriesLimited investigationFinal reportCessna T210N · Old Bridge, NJThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation during approach.NTSB NYC07FA196Accident · Serious injuriesField investigationFinal reportLiberty Aerospace XL2 · Ormond Beach, FLThe student pilot's failure to maintain aircraft control during an attempted go-around.NTSB ANC07LA088Accident · No injuriesLimited investigationFinal reportPiper J-3 · Big Lake, AKThe flight instructor's delayed instructions to apply the carburetor heat, and his inadequate supervision. A factor contributing to the accident was carburetor icing conditions.NTSB LAX07CA256Accident · No injuriesData collectionFinal reportCessna 150L · Keystone Height, FLthe student pilot's excessive retraction of flaps and failure to attain an adequate airspeed during a go-around that led to a stall/mush.NTSB SEA07LA234Accident · No injuriesLimited investigationFinal reportCessna 182P · Nampa, IDThe total loss of engine power due to the carburetor throat becoming obstructed with paint that had pealed off of the induction air inlet channel in an area where paint should not have been applied. Factors include an earthen berm running across the field…NTSB SEA07FA228Accident · 1 fatalField investigationFinal reportCessna T210G · Lomita, CAThe loss of engine power during approach as a result of fuel starvation due to the pilot's improper pre takeoff fuel system selector valve positioning. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB CHI07LA266Accident · No injuriesLimited investigationFinal reportCessna 172M · Marine City, MIA loss of engine power for undetermined reasons. Factors contributing to the accident were the insufficient runway remaining and the soft terrain.NTSB CHI07CA261Accident · No injuriesData collectionFinal reportCessna 210 D · Fort Wayne, INThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight.NTSB ANC07CA076Accident · No injuriesData collectionFinal reportMaule M-5-235 · Talkeetna, AKThe flight instructor's inadequate supervision of the student while landing, which resulted in an undershoot and an in-flight collision with an object. Factors contributing to the accident are the dual student's misjudged altitude/distance and delayed…NTSB LAX07CA242Accident · No injuriesData collectionFinal reportCessna 172B · Sisters, ORThe pilot's failure to maintain adequate clearance from trees.NTSB ANC07FA073Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Sitka, AKThe pilot's failure to maintain altitude/distance from obstacles during an IFR circling approach, and his failure to follow the instrument approach procedure. Contributing to the accident was clouds.NTSB LAX07LA240Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Polson, MTa flight control jam for undetermined reasons.NTSB CHI07LA289Accident · No injuriesLimited investigationFinal reportCessna 310Q · Brownsburg, INThe pilot's poor in-flight planning to make an off airport precautionary landing and his failure to maintain clearance from the construction equipment during the landing roll. Contributing to the accident was the construction equipment.NTSB NYC07LA183Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Fort Lauderdale, FLThe total loss of power in one engine during approach, due to a fatigue fracture of the crankshaft.NTSB NYC07LA182Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Kennesaw, GAThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion during approach.NTSB ANC07CA072Accident · No injuriesData collectionFinal reportPiper PA-18 · Anaktuvuk Pass, AKThe pilot's inadequate preflight inspection, which resulted in a loss of engine power during approach due to water contaminated fuel.NTSB NYC07CA179Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's delayed decision to abort the landing, which resulted in an impact with a tree.NTSB LAX07CA246Accident · No injuriesData collectionFinal reportFound Aircraft Canada FBA-2C1 · Challis, IDthe pilot's inadequate bounced landing recovery technique, which resulted in a hard landing.NTSB ANC07CA070Accident · No injuriesData collectionFinal reportBell 206B · Anchorage, AKThe pilot's failure to maintain clearance from a light pole during final approach, which resulted in the helicopter striking the pole.NTSB MIA07CA128Accident · Minor injuriesData collectionFinal reportEngineering & Research Ercoupe 415-C · Valkaria, FLThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent collision with the runway.NTSB LAX07CA237Accident · Minor injuriesData collectionFinal reportBeech C35 · Redlands, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall.NTSB CHI07CA232Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Warrensburg, MOThe flight instructor's failure to maintain adequate airspeed and aircraft control, which resulted in a stall while on final approach. A factor in the accident were the two fences.NTSB ATL07CA108Accident · No injuriesData collectionFinal reportEvektor Aerotechnic Sportstar · Shirley, NYThe student pilot's failure to maintain adequate airspeed resulting in a stall. Contributing to the accident was the student pilots failure to relinquish the flight controls when instructed to do so.NTSB DEN07LA127Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Basin, WYThe carburetor icing causing a partial loss of engine power, and the pilot's failure to maintain aircraft control leading to the inadvertent stall. A factor contributing to the accident was the conditions conducive for carburetor icing.NTSB CHI07LA219Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Fond Du Lac, WIThe loss of engine power due to the failure of the engine's master connecting rod which resulted in the forced landing. The road sign was a factor.NTSB SEA07LA209Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Nampa, IDThe total loss of engine power for an undetermined reason. Factors include a power transmission line between the point were the aircraft lost power and the runway that the pilot was attempting to reach.NTSB MIA07LA124Accident · Minor injuriesLimited investigationFinal reportDennis M. Durgin Junior Ace · Dover-Foxcroft, METhe failure of the pilot to maintain airspeed following total loss of engine power due to fuel starvation, resulting in a stall/mush, uncontrolled descent, and in-flight collision with trees.NTSB MIA07CA125Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26E · Big Flats, NYThe pilot's misjudged distance/altitude during approach resulting in collision with trees and the ground.NTSB LAX07CA224Accident · Minor injuriesData collectionFinal reportCessna 150M · Woodland, CAAn in-flight collision with a bird. A factor in the accident was the deteriorated aircraft performance capability due to the increased drag that made continued flight impossible.NTSB CHI07CA222Accident · No injuriesData collectionFinal reportCessna 150J · Waldron, MOThe student pilot's failure to maintain directional control during the go-around. The cornfield was a factor.NTSB NYC07LA168Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · E.Stroudsburg, PAThe pilot's improper fuel management resulting in loss of engine power.NTSB SEA07LA196Accident · 1 fatalLimited investigationFinal reportNorth American F-51D · Camarillo, CAThe pilot's failure to maintain aircraft control during a go-around. Contributing to the accident was the pilot's lack of experience in the make and model of airplane.NTSB MIA07LA121Accident · 1 fatalLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Unionville, PAThe pilot's failure to maintain control of the glider for undetermined reasons.NTSB LAX07LA220Accident · Serious injuriesLimited investigationFinal reportMurrin Frederick L Sopwith F1 · Greenville, PAa fuel starvation induced loss of engine power due to inadequate fuel system pressure. A factor in the accident was the pilot/builder's failure to adequately adjust the fuel system pressure.NTSB LAX07LA218Accident · Minor injuriesLimited investigationFinal reportClement Zenith Zodiac CH601 · Rosamond, CAA total loss of engine power during approach due to the improper idle screw/stop adjustment. A factor contributing to the accident was deteriorated fuel.NTSB SEA07CA194Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jordan, MTThe pilot's failure to maintain aircraft control during a go-around. Contributing factors were the pilot's selection of unsuitable terrain for landing and the rough/uneven terrain.