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 MIA06CA045Accident · No injuriesData collectionFinal reportSchewizer 233 · Immokalee, FLThe pilot's failure to maintain clearance during the final approach to land, which resulted in an impact with trees, and a hard landing.NTSB LAX06FA089Accident · 4 fatalField investigationFinal reportPiper PA-30 · Visalia, CAthe pilot's failure to maintain airspeed during the landing approach, which resulted in a stall and uncontrolled descent. Contributing factors to the accident were the pilot's impairment due to his prolonged use of a highly sedating over-the-counter sleep aid…NTSB LAX06CA090Accident · Serious injuriesData collectionFinal reportQuicksilver MX II Sprint · Bouse, AZLoss of engine power after takeoff due to engine overheating and piston seizure.NTSB SEA06FA039Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Burlington, WAThe pilot's failure to maintain the published minimum descent altitude and not adhering to the published missed approach procedures, which resulted in an in-flight collision with trees and terrain. Factors contributing to the accident were low ceilings and…NTSB SEA06LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Kelso, WAEncounter with carburetor icing conditions while maneuvering for the downwind which resulted in a loss of engine power due to carburetor ice. The aircraft nosing over during the landing roll in soft sand was a factor.NTSB SEA06FA038Accident · 1 fatalField investigationFinal reportMooney M20K · North Plains, ORThe pilot's failure to maintain airspeed while maneuvering for a forced landing, resulting in a stall-spin and uncontrolled descent to ground impact. A contributing factor was the loss of engine power due to fuel exhaustion resulting from the pilot's…NTSB LAX06CA079Accident · No injuriesData collectionFinal reportCessna 152 · Rancho Murieta, CAfuel contamination (water) due to the inadequate preflight by both pilots, which failed to detect the residual water contamination in fuel system. A factor in the accident was the soft terrain condition at the forced landing site.NTSB ATL06FA030Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Peachtree City, GAThe pilot's failure to maintain sufficient altitude while performing an instrument approach in instrument meteorological conditions, which resulted in an in-flight collision with trees and terrain.NTSB NYC06FA048Accident · 2 fatalField investigationFinal reportBeech D55 · Dawson, GAThe pilot's failure to maintain sufficient airspeed to preclude a stall, which resulted in an inadvertent stall and loss of control while circling to land. Factors associated with the accident were the pilot's inadequate in-flight planning and weather…NTSB DFW06CA045Accident · Minor injuriesData collectionFinal reportCessna 150L · Tulsa, OKThe pilot's improper preflight planning and preparation, which resulted in a loss of engine power due to fuel exhaustion.NTSB DEN06CA029Accident · Serious injuriesData collectionFinal reportCessna 182A · Hobbs, NMthe loss of engine power due to fuel exhaustion and the pilot's failure to visually verify the fuel quantity in the fuel tanks prior to departure. Contributing factors include the pilot's inadequate preflight, and the transmission wires.NTSB LAX06FA071Accident · 2 fatalField investigationFinal reportLearjet 35A · Truckee, CAThe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain an adequate airspeed while maneuvering in a steep turn close to the ground.NTSB LAX06CA070Accident · Minor injuriesData collectionFinal reportSocata TBM 700 · Lancaster, CAThe student's failure to maintain adequate airspeed, and the instructor's inadequate supervision and delayed remedial action, which resulted in a stall/mush.NTSB CHI06LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Marshall, MNA loss of engine power in both engines while on approach due to fuel exhaustion and the pilot's inaccurate fuel consumption calculations leading to him refueling the outboard tanks only.NTSB LAX06FA066Accident · 2 fatalField investigationFinal reportBeech 36 · Livermore, CAThe pilot's failure to maintain the appropriate glidepath alignment during an instrument landing system approach, resulting in collision with terrain. A contributing factor to the accident was the failure of the air traffic controllers to issue a minimum safe…NTSB LAX06LA065Accident · No injuriesLimited investigationFinal reportBeech F33A · La Verne, CAthe failure of the pilot of the other aircraft to comply with his air traffic control clearance and line up for the proper runway, and his failure to maintain an adequate visual lookout, which resulted in his in-flight collision with the Cessna airplane.NTSB NYC06LA045Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Chaplin, CTA complete loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the emergency landing.NTSB DEN06LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Peyton, COthe pilot's delay in applying carburetor heat that resulted in the partial loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA050Accident · Minor injuriesData collectionFinal reportElliott Quad City Ultralight Challenger II · California, MOThe pilot's failure to maintain aircraft control due to his failure to comply with procedures/directives, and the inadvertent stall/spin he encountered on his turn to base.NTSB MIA06CA031Accident · Minor injuriesData collectionFinal reportCessna 210 · Stuart, FLThe pilot's failure to maintain adequate airspeed during landing which resulted in an inadvertent stall and subsequent collision with terrain.NTSB MIA06CA029Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Daytona Beach, FLThe flight instructor's inadequate supervision, and the student pilot's improper go-around procedures, which resulted in the airplane's left wing striking the runway.NTSB SEA06LA026Accident · Serious injuriesLimited investigationFinal reportHitchens EDI 90FT · Chehalis, WAThe pilot's loss of control of the aircraft for undetermined reasons while on a one-half mile straight-in VFR GPS final approach. Factors included his unsuccessful remedial action, and contact with the terrain in an open soft field.NTSB ATL06LA022Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-110P1 · Orangeburg, SCThe pilot's inadequate preflight inspection and her failure to refuel the airplane which resulted in total loss of engine power due to fuel exhaustion, and subsequent in-flight collision with trees.NTSB SEA06CA024Accident · No injuriesData collectionFinal reportCessna 210-5 · Lopez Island, WAThe pilot's failure to maintain adequate clearance from an airport sign during the visual approach. The sign was a factor in the accident.NTSB NYC06FA040Accident · 1 fatalField investigationFinal reportBeech B-55 · Nantucket, MAThe pilot's failure to maintain the proper glidepath during the instrument approach, which resulted in controlled flight into water. Factors were the failure of the air traffic controllers to issue minimum safe altitude warnings, night lighting conditions,…NTSB SEA06FA022Accident · 1 fatalField investigationFinal reportCessna 425 · Belgrade, MTThe pilot's failure to maintain airspeed during the approach which resulted in an inadvertent stall. Factors associated with the accident were dark night conditions, clouds, icing conditions, low visibility and snow.NTSB LAX06LA048Accident · No injuriesLimited investigationFinal reportCessna 182A · San Diego, CAThe failure of the camshaft due to fatigue of one of the gear teeth, which resulted in a loss of engine power. Factors were the fence and the fence post.NTSB NYC06IA036Incident · No injuriesIncident investigationFinal reportMooney M20F · Cadiz, KYFuel starvation, which resulted in a loss of engine power.NTSB NYC06FA034Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Burlington, VTThe pilot's failure to follow the published instrument flight procedure, which resulted in an in-flight collision with terrain. Factors in the accident were the local air traffic controller's inadequate monitoring of the MSAW system, and his delayed…NTSB MIA06FA022Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Homestead, FLThe failure of both pilot's to maintain visual lookout resulting in the mid-air collision. A factor in the accident was the failure of the AS-350B pilot to follow approach procedures suggested in the Speedway Heliport Operations Manual. Findings in the…NTSB NYC06LA033Accident · No injuriesLimited investigationFinal reportBoeing 737-800 · State College, PAThe pilot's improper touchdown and recovery from a bounced landing. Factors to the accident were the operator's failure to provide sufficient information on the use of autothrottles and bounced landing recovery techniques, along with the Federal Aviation…NTSB CHI06LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Batavia, OHThe loss of engine power due to fuel starvation and improper fuel management by the pilot while on approach. Contributing factors were the low altitude and unsuitable terrain encountered during an emergency landing.NTSB LAX06CA038Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · Bakersfield, CAthe pilot's failure to maintain adequate airspeed, which resulted in an accelerated stall and hard landing.NTSB SEA06CA017Accident · No injuriesData collectionFinal reportCessna T210M · Salt Lake City, UTA loss of engine power due to fuel starvation as a result of the pilot's improper in-flight decision not to use the before landing checklist. A factor which contributed to the accident was the improper position of the mixture control.NTSB LAX06CA037Accident · Serious injuriesData collectionFinal reportHopkins Rutan VariViggen · Aguila, AZthe pilot's failure to maintain an adequate airspeed during landing approach, which resulted in an inadvertent stall. A contributing factor was the pilot's lack of experience in the accident airplane.NTSB CHI06FA032Accident · 1 fatalField investigationFinal reportAero Commander 500B · Gaylord, MIThe clearance not maintained with terrain during a nonprecision approach. Contributing factors were the ceiling, visibility, night conditions, and trees.NTSB ATL06CA016Accident · Minor injuriesData collectionFinal reportCessna 177 · New Bern, NCThe pilot's failure to activate the carburetor heat during approach resulting in a total loss of engine power due to carburetor ice.NTSB DFW06LA028Accident · 1 fatalLimited investigationFinal reportRehler Gyrocopter · New Braunfels, TXThe pilot's failure to maintain control while landing. A contributing factor was the high winds.NTSB DFW06CA031Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Osceola, ARThe pilot's failure to maintain control of the airplane while on final approach. A contributing factor was the gusty winds.NTSB DFW06CA030Accident · No injuriesData collectionFinal reportCessna 172N · Arlington, TXThe students improper recovery from a bounced landing. A contributing factor was the pilots excessive airspeed on final approach.NTSB ATL06CA013Accident · Minor injuriesData collectionFinal reportBeech BE-76 · Greer, SCThe pilot's misjudgment of altitude and distance which resulted in an undershoot of the runway, and the collision with trees.NTSB DFW06FA021Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · Tomball, TXThe pilot's failure to maintain control of the aircraft while attempting to execute a missed approach procedure in weather that was below landing minimums. Contributing factors were the low ceiling, and the below approach landing minimums.NTSB DFW06CA020Accident · Minor injuriesData collectionFinal reportDeussen Alexander II Rotorway Exec · Gibson, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA029Accident · No injuriesData collectionFinal reportHughes 269A · Omaha, NEThe loss of engine power for an undetermined reason and the pilot's improper execution of the emergency procedure which resulted in an excessive descent rate and subsequent hard landing.NTSB LAX06CA027Accident · No injuriesData collectionFinal reportLee Kolb Mark III Classic · Tucson, AZthe fatigue failure of the attachment that secured the horizontal stabilizer to the fuselage.NTSB CHI06CA022Accident · No injuriesData collectionFinal reportCessna 180 · Manitowish Wate, WIThe pilot's inadequate preflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident was the trees the airplane impacted during the forced landing.NTSB DEN06LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Cortez, COthe pilot's failure to maintain directional control of the airplane, resulting in a ground loop. Contributing factors were the excessive descent rate, the obstacle (horse), the high density altitude, and the tailwind.NTSB LAX06LA016Accident · 1 fatalLimited investigationFinal reportNord 3202 · Casa Grande, AZthe pilot's failure to maintain airspeed during a low-altitude evasive maneuver away from another airplane, which resulted in a stall and uncontrolled descent.NTSB DFW06CA011Accident · No injuriesData collectionFinal reportBell B206 L-3 · Marble Falls, TXA hard landing as result of a loss of engine power for undetermined reasons.NTSB DEN06LA005Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Kaycee, WYthe pilot's improper decision to attempt a go-around and the pilot's failure to maintain airspeed resulting in an inadvertent stall. A contributing factor was the hard landing.