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 FTW02LA034Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Benton, LAin-flight collision with trees while on final approach to land for an undetermined reason.NTSB FTW02FA036Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Graham, TXThe pilot's failure to discontinue the approach after encountering instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing factors were the dark night light condition, low ceiling, and reduced visibility due to fog.NTSB SEA02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Puyallup, WAThe pilots' failure to maintain aircraft control on short final, resulting in a touchdown off of the prepared landing surface. A factor was grassy terrain encountered on the landing rollout.NTSB LAX02LA025Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Nogales, AZThe pilot failed to maintain directional control while landing in a cross wind. He attempted a go-around, but inadvertently stalled the airplane, which resulted in an uncontrolled descent and collision with the runway.NTSB CHI02LA027Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Mounds View, MNFuel starvation caused by the pilot's improper positioning of the fuel tank fuel selector while in the traffic pattern, and the unsuitable terrain encountered during the forced landing. Factors relating to the accident were the pilot not complying with the…NTSB ATL02LA012Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA300/L · St. Augustine, FLThe pilot of the other airplanes failure to maintain a visual lookout and yield the right-of-way to a lower airplane while landing. This resulted in an inadvertent midair collision. Contributing to the accident was reported excessive radio communication on…NTSB LAX02LA024Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Copperopolis, CAThe pilot's misjudgment of speed and altitude on final approach to landing, which resulted in a low approach and impact with a fence at the runway threshold. The impact lead to a subsequent loss of control and nose over.NTSB DEN02LA010Accident · Minor injuriesLimited investigationFinal reportAgusta A119 · Ogden, UTimproper rigging of the rotary variable differential transformer by the manufacturer, resulting in incorrect fuel scheduling to the fuel control unit.NTSB MIA02LA015Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Gainesville, FLThe failure of both pilots to insure the airplane contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion and collision with trees during a forced landing.NTSB LAX02LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Herald, CAThe pilot's delay initiating a go-around during a downwind approach to a short runway.NTSB LAX02FA019Accident · 1 fatalField investigationFinal reportCessna 182S · Little River, CAthe pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with trees and terrain.NTSB FTW02LA023Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Wilton, ARthe pilot's failure to obtain a proper touchdown point and his excessive approach speed during a forced landing. A contributing factor was the total loss of engine power for undetermined reasons.NTSB CHI02LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lapeer, MIthe touchdown aim point not attained by the pilot rated student and the remedial action not performed by the flight instructor.NTSB CHI02LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Wayne, INThe pilot not maintaining control of the airplane during an attempted go-around. A factor was the trees.NTSB NYC02LA017Accident · Minor injuriesLimited investigationFinal reportBeech B95A · Pittstown, NJThe pilot’s failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in an inadvertent stall. A factor was the gusty wind conditions.NTSB CHI02FA009Accident · 1 fatalField investigationFinal reportBeech 58 · Dubuque, IAThe pilot continued flight into known adverse weather and disregarded the minimum descent altitude. Additional factors were the conditions conducive to pilot fatigue, fog, and night.NTSB FTW02LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Ozona, TXThe loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel the airplane. Contributing factors were the lack of suitable terrain for the forced landing and the dark night conditions.NTSB ANC02LA002Accident · Minor injuriesLimited investigationFinal reportEmbraer 120ER · Bethel, AKThe captain's continued descent below the minimum descent altitude which resulted in impact with terrain during an instrument landing approach. Factors contributing to the accident were the flightcrew's failure to reset the altimeters to the correct altimeter…NTSB SEA02FA005Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sandy, ORThe pilot's failure to maintain clearance from the trees while attempting to land in a field after entering an area of instrument meteorological conditions. Factors include low ceilings, rain, fog, strong winds, mountainous/hilly terrain, the pilot's…NTSB FTW02LA008Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Dallas, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion and subsequent loss of dual engine power while on approach.NTSB FTW02LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Chickasha, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB MIA02LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-30B-160 · Clarksville, TNThe failure of the CFI/check pilot to insure Vmc was maintained during a go-around following a simulated failed engine approach, resulting in an in-flight loss of control, uncontrolled descent, and collision with the terrain. A factor in the accident was the…NTSB FTW02FA003Accident · No injuriesField investigationFinal reportFokker F28 Mk 0100 · DFW Airport, TXThe collapse of the nose landing gear as a result of the failure of company maintenance personnel to follow the proper procedures for a towing the airplane with an unsafe nose landing gear indication. Contributing factors were the inadequate communication…NTSB IAD01LA109Accident · No injuriesLimited investigationFinal reportRhoades Rotorway Exec 162F · Whitehouse, OHThe soft terrain condition, which resulted in the helicopter's rollover during the forced landing. A factor was the loss of engine power due to engine overtemperature for undetermined reasons.NTSB SEA01FA175Accident · 1 fatalField investigationFinal reportPiper PA-30 · McCall, IDThe pilot's failure to maintain adequate airspeed following a loss of power on the left engine, resulting in loss of aircraft control. Factors included a loss of power on the left engine for undetermined reasons, and the pilot's failure to properly configure…NTSB FTW01LA214Accident · No injuriesLimited investigationFinal reportBell 206L-1 · W Cameron 168the failure of the rotor tachometer generator, which resulted in a precautionary landing in the Gulf of Mexico. A contributing factor to the accident was the rough water condition.NTSB DEN01FA162Accident · 1 fatalField investigationFinal reportCessna 337B · St. George, UTtotal loss of engine power on both engines due to fuel starvation and the pilot's inability to access the available fuel supply. Contributing factors were the pilot's inadequate supervision of the refueling operation, and his intentional operation of the…NTSB LAX01LA305Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlsbad, CAA hard landing due to the dual student's failure to maintain main rotor speed, his improper landing flare, and the flight control interference by the flight instructor.NTSB LAX01LA304Accident · 1 fatalLimited investigationFinal reportAerospatiale AS350BA · Chico, CAthe pilot's inadequate in-flight decision and delay in initiating a go-around during an encounter with brown out conditions, which led to his failure to maintain alignment of the helicopter with the intended go-around flight path and a resulting collision…NTSB ANC01LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · North Pole, AKA loss of engine power, due to contaminated fuel, during approach for landing. A factor associated with the accident was unsuitable terrain.NTSB CHI01LA317Accident · No injuriesLimited investigationFinal reportBeech 200 · Indianapolis, INThe pilot not maintaining the proper ILS glide slope during the approach and the pilot not executing a missed approach. Contributing to the accident was the rain/mist.NTSB SEA01LA170Accident · 1 fatalLimited investigationFinal reportCessna 182J · Gold Beach, ORThe pilot's failure to attain proper alignment while on final approach and clearance from trees. The pilot's lack of total experience in this type of mountain flying operation was a factor.NTSB LAX01LA303Accident · 2 fatalLimited investigationFinal reportCessna P206B · Willits, CAthe failure of the pilot to reset the elevator trim tab during the go-around, which resulted in his failure to maintain airspeed and an inadvertent stall.NTSB DEN01LA159Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Watkins, COthe pilot's failure to maintain clearance with the guy wire.NTSB FTW01LA204Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Harrisonburg, LAloss of control during approach for an undetermined reason.NTSB NYC01FA223Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Bern Township, PAThe pilot's loss of control for undetermined reasons, which resulted in a high speed dive to the ground.NTSB CHI01LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot's improper flare, and the flight instructor's delayed remedial action, which resulted in a loss of directional control.NTSB SEA01LA165Accident · No injuriesLimited investigationFinal reportCessna T210L · Olympia, WAThe inability of the landing gear to fully extend due to the failure of a hydraulic hose in the nose gear extension system.NTSB MIA01LA226Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Daytona Beach, FLa total loss of engine power due to the pilot's improper procedures by not placing the fuel selector on the tank with the most fuel, after a reported restricted movement of the flight controls for undetermined reasons, which resulted in fuel starvation and a…NTSB NYC01LA222Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Warren, VTThe pilot's improper fuel planning, which resulted in fuel exhaustion.NTSB LAX01LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Carson City, NVThe pilot's incorrect setting of the fuel selector valve during the prelanding checklist to a position between usable tanks, resulting in fuel starvation.NTSB LAX01FA297Accident · 1 fatalField investigationFinal reportCessna T210M · Watsonville, CAThe loss of engine power for undetermined reasons.NTSB CHI01LA303Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sheldon, IAthe in-flight planning/decision and proper touchdown point not attained by the pilot. Contributing factors were the ingested exhaust valve and lack of experience of the pilot.NTSB ANC01LA129Accident · Minor injuriesLimited investigationFinal reportde Havilland C-7A · Port Alsworth, AKThe captain's failure to maintain the proper glidepath, and improper short field landing procedures. Factors in the accident were a downdraft, and the captain's inadequate evaluation of the weather conditions.NTSB FTW01LA199Accident · No injuriesLimited investigationFinal reportJohn Greenlee X-Aircamper · Healdton, OKThe loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat during the approach to land. Contributing factors were weather conditions conducive to carburetor icing conditions and the lack of suitable terrain for…NTSB NYC01FA215Accident · 1 fatalField investigationFinal reportBeech BE-200 · Piqua, OHThe pilot's improper decision to attempt a visual landing under instrument meteorological conditions and his failure to maintain adequate altitude/clearance, which resulted in an in-flight collision with trees. A factor in this accident was the ground fog.NTSB ANC01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nenana, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was trees.NTSB NYC01FA212Accident · 1 fatalField investigationFinal reportPitts S-2B · Shirley, NYThe pilot under instruction's failure to maintain adequate airspeed, and the flight instructor's inadequate remedial action during a simulated engine-out approach, which resulted in an inadvertent stall, and subsequent ground impact.NTSB FTW01LA187Accident · Serious injuriesLimited investigationFinal reportBeech F33C · Sugarland, TXthe pilot's inadvertent stall of the airplane during the base/final approach for landing which resulted in a collision with terrain. A contributing factor was the pilot's diverted attention to an open cockpit door.NTSB IAD01LA098Accident · No injuriesLimited investigationFinal reportCessna 150M · Cincinnati, OHThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.