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 LAX01FA274Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Boulder City, NVthe pilot's failure to maintain an adequate terrain and obstruction clearance altitude while maneuvering in a non-standard visual approach to land. The pilot's misjudgment of his altitude and distance from the airport was due to impairment by alcohol. Factors…NTSB FTW01LA179Accident · 1 fatalLimited investigationFinal reportPdps PZL-Bielsko SZD-55-1 · Uvalde, TXthe pilot's failure to maintain aircraft control during the base turn, which resulted in an inadvertant stall/spin.NTSB CHI01LA278Accident · No injuriesLimited investigationFinal reportGremminger 532 Commander · Ste. Genevieve, MOThe inadequate fuel supply for the flight which resulted in fuel exhaustion. A factor associated with the accident was the low altitude and the soft terrain on which the forced landing was made.NTSB DEN01LA143Accident · No injuriesLimited investigationFinal reportBlanik L-13 · Morgan, UTthe pilot's inadvertent lowering of the flaps and her failure to extend the spoilers.NTSB ANC01LA112Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Wrangell, AKThe pilot's inadequate evaluation of the weather conditions during a downwind landing at a remote lake. Factors in the accident were a downdraft, rough/uneven terrain, and the pilot's inadequate in-flight planning/decision(s).NTSB MIA01LA211Accident · Serious injuriesLimited investigationFinal reportBeech BE-200 · Sandersville, GAThe pilot-in command's failure to maintain airspeed during the approach, resulting in an inadvertent stall and in-flight collision with the terrain during an uncontrollable descent.NTSB CHI01LA269Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Mackinac Island, MIThe pilot's failure to maintain proper glidepath during the landing approach resulting in the pilot not maintaining clearance from the trees. Factors were the haze, the gusty winds, and the trees.NTSB LAX01LA273Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Fullerton, CAloss of engine power due to fuel contamination.NTSB DEN01LA141Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Ouray, COthe partial loss of engine power due to the slippage of the wastegate linkage as a result of the plunger on the linkage being undertorqued by an unknown person. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC01LA111Accident · No injuriesLimited investigationFinal reportCessna 180A · Arctic Village, AKThe pilot's improper use of carburetor heat during a go-around. Factors in the accident were carburetor icing conditions, and high vegetation in the landing area.NTSB FTW01LA172Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Wc 173the pilot's failure to maintain yaw control of the helicopter during approach.NTSB LAX01LA269Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Fort Bragg, CAthe pilot's failure to maintain airspeed while making a precautionary landing resulting in an inadvertent stall.NTSB MIA01LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Covington, GAThe flight instructor's improper monitoring of the dual student during a simulated engine out approach and her delayed decision to initiate a go-around resulting in the airplane colliding with trees at the departure end of the runway during the go-around.NTSB MIA01FA206Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-35 · Hilton Head, SCImproper maintenance/installation and and inadequate inspection of the airplane's flap torque tube joints during routine maintenance by company maintenance personnel, which resulted in the right flap torque tube assembly coupler becoming detached and the…NTSB LAX01LA263Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and loss of engine power while on approach for landing.NTSB CHI01FA247Accident · Minor injuriesField investigationFinal reportBeech C35 · Oshkosh, WIThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB NYC01FA189Accident · 1 fatalField investigationFinal reportPiper PA-46-350 · Westfield, MAThe pilot's failure to maintain aircraft control while maneuvering during a go-around.NTSB DEN01LA128Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Bountiful, UTthe loss of engine power for an undetermined reason. A contributing factor was inadequate clearance of an obstacle during the forced landing by the pilot.NTSB CHI01FA244Accident · 1 fatalField investigationFinal reportSchuchart Stoddard HamiltonSH3 · Oshkosh, WIThe inadvertent stall/spin by the pilot.NTSB CHI01FA235Accident · 1 fatalField investigationFinal reportPayne Giles G-202 · Oshkosh, WIThe pilot failed to maintain aircraft control which resulted in an inadvertant stall. Factors with the accident were the pilot misjudged the approach and the pilot's lack of total experience in the Giles G-202.NTSB CHI01LA227Accident · No injuriesLimited investigationFinal reportMcIlraith Searey Amphibian · La Crosse, WIThe pilot's inadequate compensation for wind conditions and turbulence which resulted in the encountered stall. Factors to the accident were turbulence and the high wind condition.NTSB ATL01LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lake City, FLThe pilots failure to maintain clearance during an approach to land, that resulted in an in-flight collision with trees.NTSB SEA01LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oak Harbor, WAThe pilot's inadequate remedial action while on final approach. The encounter with wake turbulence was a factor.NTSB NYC01IA199Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Teterboro, NJThe right aft rudder cable being installed over a cable guide by maintenance personnel.NTSB LAX01LA247Accident · No injuriesLimited investigationFinal reportBeech J35 · Las Vegas, NVThe pilot's failure to comply with the airplane flight manual, resulting in fuel starvation and subsequent forced landing on rough terrain.NTSB NYC01FA178Accident · 3 fatalField investigationFinal reportBeech 58-TC · Sidney, NYThe pilot's failure to follow IFR procedures which resulted in a collision with rising terrain. Factors related to the accident were the rising terrain and fog.NTSB LAX01LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Chandler, AZThe failure of maintenance personnel to properly tighten a fuel line fitting during an engine installation resulting in a fuel leak and fire during the maintenance checkflight. A factor in the accident was inadequate inspection of the installation prior to…NTSB CHI01FA218Accident · 1 fatalField investigationFinal reportCessna 310R · Oak Creek, WIThe pilot not maintaining clearance from objects during an ILS approach in low night IFR conditions and his descent below decision height. Factors were the dark night, mist, low ceiling, and the trees west of the approach.NTSB NYC01LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Stow, MAThe pilot's failure to maintain airplane control during a go-around.NTSB NYC01LA175Accident · Minor injuriesLimited investigationFinal reportYakovlev 52 · Moultonboro, NHA clogged fuel vent line due to a mud dauber nest, and rough terrain, including a large hole, in the forced landing field.NTSB NYC01LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Schuyler, NYThe pilot's delayed go-around, which resulted in an in-flight collision with trees. A factor in this accident was the crosswind conditions.NTSB SEA01LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tekoa, WAThe non-current pilot's failure to maintain sufficient altitude or clearance with wheat crops on short final, and the flight instructor's inadequate remedial action. Factors included wheat crops and a dirt bank on short final, the runway's lack of a visual…NTSB CHI01FA206Accident · 6 fatalField investigationFinal reportBeech E-55 · Carterville, MOThe pilot's failure to maintain aircraft control and the pilot's improper in-flight planning and decisions. Factors relating to the accident were the pilot's lack of experience in the airplane, the inadvertent spiral, and the residence.NTSB FTW01LA164Accident · Minor injuriesLimited investigationFinal reportYoung RV-6 · Spring, TXthe loss of engine power for undetermined reasons during the landing approach. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC01FA169Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Medford, NJThe pilot's improper use of the flight controls while turning to base, which resulted in a stall/spin and subsequent impact with the ground.NTSB CHI01LA202Accident · No injuriesLimited investigationFinal reportCessna 172N · West Chicago, ILThe instructor pilot's inadequate recovery from the bounced landing and inadequate supervision of the dual students alignment with the runway. A factor was the student pilot not maintaining proper alignment with the runway during landing.NTSB LAX01FA236Accident · No injuriesField investigationFinal reportBell 47D-1 · Riverside, CAThe engine crankshaft's failure as the result of fatigue cracking initiated by surface damage and localized overheating due to the installation at overhaul of incorrectly sized bearings.NTSB IAD01LA076Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider LS3-A · Front Royal, VAthe pilot's inadequate altitude/clearance from a tree along his final approach path.NTSB ATL01LA070Accident · No injuriesLimited investigationFinal reportHughes 369A · Wadesboro, NCThe pilot's inadequate pre-flight planning which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was rough and uneven terrain.NTSB CHI01LA194Accident · 1 fatalLimited investigationFinal reportHouston Challenger II · Sedalia, MOthe unsuitable terrain encountered during the forced landing. Additional factors were the pilot's lack of experience in the type of airplane, the loss of engine power for undetermined reasons, and the trees.NTSB LAX01IA241Incident · No injuriesIncident investigationFinal reportBeech A36 · Bakersfield, CADuring landing approach, mechanical binding of the elevator control cable occurred due to a contract mechanic's improper maintenance.NTSB ANC01TA076Accident · No injuriesFinal reportBell 212 · Clear, AKThe pilot's selection of an unsuitable landing site following a partial loss of power during approach to landing in a multiengine helicopter. Factors associated with the accident are an automatic fuel control unit that had a restricted fuel flow due to an…NTSB NYC01LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rochester, NYFuel exhaustion, due to the student pilot's failure to monitor his fuel supply.NTSB ANC01LA074Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Soldotna, AKThe loss of engine power due to fuel exhaustion and the pilot's failure to refuel the airplane.NTSB LAX01LA221Accident · No injuriesLimited investigationFinal reportCessna 172M · Napa, CALoss of engine power due to the restricted movement of the number 1 exhaust valve that subsequently bent the exhaust push rod and push rod housing.NTSB LAX01FA222Accident · 1 fatalField investigationFinal reportBeech 35-B33 · Lakeside, CALoss of control in flight due to cardiovascular incapacitation.NTSB DEN01LA117Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Eagle, COthe pilot's inadequate wind evaluation, and his inadequate planning/decision to land with a tailwind, at a density altitude of 13,418 feet. Contributing factors were the tailwind and the high density altitude weather condition.NTSB MIA01LA170Accident · 2 fatalLimited investigationFinal reportUnknown DragonFly B · LaBelle, FLThe inadvertent stall/spin by the pilot resulting in an uncontrolled descent and impact with the ground.NTSB IAD01FA070Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Greenwich, CTThe pilot's failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, due to spatial disorientation. Factors in the accident were the fog, and the pilot's use of a sedating medication.NTSB LAX01LA216Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Mesa, AZa loss of power for unexplained reasons. Also causal was the CFI's operation of the helicopter in a region of the height/velocity curve where a successful autorotation could not be accomplished. A factor in the accident was the high density altitude.