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 LAX07LA216Accident · No injuriesLimited investigationFinal reportCessna 180A · Redding, CAFuel exhaustion due to the pilot's inadequate in-flight planning/decision concerning fuel system management and his failure to refuel while en route.NTSB LAX07GA217Accident · No injuriesFinal reportEurocopter France AS350 B3 · Paso Robles, CAa loss of control for undetermined reasons, which resulted in an uncommanded roll and subsequent collision with terrain. Contributing factors in the accident were the flying pilot's failure to request assistance from the second pilot in a timely manner and…NTSB NYC07LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Enterprise, ALThe designated examiner's improper decision to simulate an engine failure on short final approach, in conjunction with a short-field landing maneuver, and his inadequate remedial action. Contributing to the accident was the private pilot's inadvertent…NTSB LAX07CA211Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Mukilteo, WAFuel exhaustion resulting from the pilot's inadequate preflight inspection and failure to refuel the airplane, either before departure or at any of the alternate airports en route.NTSB NYC07CA163Accident · Minor injuriesData collectionFinal reportCessna 182K · Matincus Island, MEAn evasive maneuver to avoid a bird, while on final approach, which resulted in an in-flight collision with trees.NTSB MIA07FA116Accident · No injuriesField investigationFinal reportEurocopter EC 130 B4 · New York, NYThe fatigue fracture and in-flight separation of a 20-inch section of the blue composite main rotor blade trailing edge, aft of the spar, due to inadequate manufacture, and the manufacturer’s subsequent failure to detect an out-of-specification deviation in…NTSB LAX07CA206Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Ventus-2C · Bridgeport, CAThe pilot's encounter with an unfavorable wind and high sink rate conditions.NTSB DFW07CA147Accident · No injuriesData collectionFinal reportPiper PA28R-200 · Lubbock, TXThe inadvertent stall and subsequent hard landing as result of the pilot's failure to maintain airspeed and his delayed relinquishing of the airplane's controls when requested by the flight instructor.NTSB SEA07LA190Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Orangeburg, SCThe pilot's failure to maintain airspeed during go-around which resulted in a stall. The tailwind was a factor.NTSB SEA07FA189Accident · 1 fatalField investigationFinal reportCessna 182Q · Cashmere, WAThe pilot's failure to maintain adequate clearance from trees while on final approach. A contributing factor was the sun glare.NTSB SEA07CA191Accident · No injuriesData collectionFinal reportPiper PA 28R-180 · Henderson, NVThe pilot's failure to maintain control of the airplane during the attempted go-around, which resulted in a hard landing. A contributing factor was the crosswind.NTSB CHI07CA196Accident · Minor injuriesData collectionFinal reportAnderson Glasair FT II · Cedar Rapids, IAThe loss of engine power for undetermined reasons during the downwind leg, which resulted in a forced landing. A factor in the accident was the unsuitable terrain encountered.NTSB NYC07CA151Accident · No injuriesData collectionFinal reportLet Super Blanik L-23 · Warren, VTThe glider's inadvertent encounter with windshear. A factor was the outflow from a nearby thunderstorm.NTSB DEN07LA108Accident · 2 fatalLimited investigationFinal reportSchwarz RV-6A · Greeley, COthe pilot's failure to maintain airspeed resulting in an inadvertent stall and impact with terrain.NTSB ANC07FA054Accident · 2 fatalField investigationFinal reportCessna 177RG · Wasilla, AKThe flight instructor's failure to adequately supervise the private pilot (dual student), and his delayed go-around during approach to land. Contributing to the accident was the dual student's misjudged distance/altitude.NTSB SEA07LA177Accident · 2 fatalLimited investigationFinal reportMooney M20C · Price, UTThe pilot's failure to maintain clearance from power transmission lines while on a night straight-in visual flight rules approach. Factors include a power transmission line about one and three-tenths mile off the approach end of the runway, and the pilot's…NTSB CHI07LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Columbia, ILThe certified flight instructor's (CFI's) inadequate preflight planning/preparation of a test altitude that would afford an on airport landing in the event of engine power loss. Additional causes were the CFI not flying a traffic pattern that would allow for…NTSB DEN07CA103Accident · No injuriesData collectionFinal reportPiper PA-30 · Highgate, VTThe pilot's failure to maintain airspeed on approach resulting in the stall and subsequent impact with terrain.NTSB ATL07CA094Accident · No injuriesData collectionFinal reportCessna C152 · Miami, FLThe pilot's loss of consciousness while on final approach to land, resulting in an uncontrolled descent, and a hard landing on the runway.NTSB SEA07TA174Accident · No injuriesFinal reportCessna 185C · Kalispell, MTThe complete loss of engine power during an attempted go-around from a simulated engine-out landing. Factors include rough/uneven terrain and high vegetation where the pilot made an emergency forced landing.NTSB NYC07LA146Accident · No injuriesLimited investigationFinal reportBell-Carson 47G-Super C-4 · Wall Township, NJA total failure of the number one connecting rod during approach.NTSB ATL07LA092Accident · No injuriesLimited investigationFinal reportCessna 172 · Brinson, GAA partial loss of engine power due to a blocked carburetor jet.NTSB NYC07LA144Accident · No injuriesLimited investigationFinal reportBeech T-34A · Maxton, NCA total loss of engine power for undetermined reasons.NTSB NYC07CA141Accident · No injuriesData collectionFinal reportPiper PA31-310 · Marietta, PAThe pilot's failure to obtain the proper touchdown point, which resulted in an undershoot.NTSB CHI07CA169Accident · Minor injuriesData collectionFinal reportCessna 150H · Bellaire, MIA loss of engine power for undetermined reasons. A factor in the accident was the deer fence.NTSB ANC07CA050Accident · Minor injuriesData collectionFinal reportCessna 206 · Seldovia, AKThe pilot's inadequate compensation for wind conditions during the final landing approach, which resulted in an in-flight collision with trees. A factor associated with the accident was turbulence.NTSB ATL07CA090Accident · Minor injuriesData collectionFinal reportRosenbaum Super Petrel · Palm Harbor, FLThe pilot's failure to maintain directional control of the airplane during approach to land on a lake resulting in an inflight collision with water. A factor was the pilot's lack of qualification and total experience in the accident airplane make and model.NTSB SEA07CA149Accident · No injuriesData collectionFinal reportPiper PA-16 · Esparto, CAThe pilot's misjudgment of altitude resulting in an undershoot. Factors included the berm and the wind gusts.NTSB ANC07CA043Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot's failure to maintain clearance from trees while landing, and his selection of an unsuitable landing site, which resulted in an in-flight collision with a tree and an on-ground encounter with brush.NTSB SEA07LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Redlands, CAThe restriction of the carburetor float as a result of a misadjusted retractor clip. A contributing factor was the fire.NTSB MIA07LA109Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lantana, FLSeparation of a landing gear hydraulic line at the fitting for undetermined reasons.NTSB MIA07CA106Accident · Minor injuriesData collectionFinal reportCessna 150L · Greensboro, GAThe pilot's failure to retract the wing flaps during a go-around, which resulted in a stall, and uncontrolled descent, and an impact with terrain.NTSB ANC07LA046Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Clear, AKThe dual student's misjudged distance/altitude during the final approach to land, and the flight instructor's inadequate supervision of the student, which resulted in an undershoot, and substantial damage.NTSB NYC07CA133Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Lumberton, NJThe flight instructor's improper decision to simulate an engine failure in the traffic pattern by cutting off fuel to the engine, and his subsequent failure to maintain directional control during an aborted landing.NTSB NYC07FA130Accident · 1 fatalField investigationFinal reportMooney M20J · Canton, MAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.NTSB LAX07LA186Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Upland, CAFailure of the pilot under instruction to maintain the minimum single engine control airspeed (air) and directional control while turning to final approach. Also causal was the flight instructor's inadequate supervision and delayed remedial actions.NTSB DEN07LA098Accident · Serious injuriesLimited investigationFinal reportBoeing 757-251 · Denver, COThe inadvertent encounter with moderate turbulence during the approach which resulted in a serious injury to the flight attendantNTSB LAX07CA182Accident · No injuriesData collectionFinal reportCessna 340A · Chandler, AZfuel starvation due to the pilot's failure to adequately manage and monitor his fuel supply.NTSB DEN07CA097Accident · Minor injuriesData collectionFinal reportStevenson RV-6 · Oakley, KSThe pilot's failure to maintain airspeed during final approach resulting in a inadvertent stall and impact with terrain.NTSB LAX07LA175Accident · 1 fatalLimited investigationFinal reportSkygear Skygear · Chino, CAThe pilot's failure to maintain an adequate airspeed that resulted in an inadvertent stall.NTSB DEN07CA096Accident · No injuriesData collectionFinal reportCessna 172P · Manhattan, KSThe flight instructor's failure to maintain control of the airplane during the landing. A contributing factor was the inadvertent encounter with the military helicopter's rotor wash.NTSB CHI07CA156Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Elwood, INThe commercial pilot's failure to maintain adequate altitude and airspeed which resulted in the airplane mushing into the terrain during the simulated forced landing along with the CFI's failure to adequately supervise the commercial pilot's actions.NTSB CHI07LA150Accident · 2 fatalLimited investigationFinal reportWood Vans RV7A · Marysville, OHThe pilot's failure to maintain clearance from an object during a go-around and subsequent failure to maintain adequate airspeed. An airport sign and an inadvertent stall were factors.NTSB DFW07LA118Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5B · Hilltop Lakes, TXThe loss of engine power due to carburetor ice. Contributing factors were the lack of suitable terrain for a forced landing and the weather conditions that were conducive to carburetor ice.NTSB SEA07LA132Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Lake Elsinore, CAThe glider's encounter with a downdraft while in the traffic pattern, resulting in insufficient altitude to reach the airport. A contributing factor was the pilot's selection of an unsuitable off-airport landing area, which led to an on-ground collision with…NTSB SEA07CA128Accident · No injuriesData collectionFinal reportForney F-1 · Morgan, UTThe pilot's failure to maintain clearance of the hill on final approach to a landing. Contributing factors were the downdraft weather condition, the hilly terrain, and his lack of familiarity with the geographical area.NTSB SEA07CA125Accident · No injuriesData collectionFinal reportCessna 170B · Fairfield, IDThe pilot's failure to maintain adequate airspeed while turning from base to final, resulting in an inadvertent stall/mush and subsequent collision with terrain.NTSB DEN07CA092Accident · No injuriesData collectionFinal reportCentrair 101C · Alamogordo, NMThe pilot's inability to control the glider after encountering the downdraft causing the glider to land short of the dirt strip. Factors contributing to the accident were the downdraft and the runway marker.NTSB LAX07CA154Accident · Minor injuriesData collectionFinal reportBurkhart Grob G103 Twin II · Minden, NVThe pilot's failure to maintain an adequate airspeed, which led to an inadvertent stall.NTSB DFW07CA112Accident · No injuriesData collectionFinal reportCessna 180 · Austin, TXThe loss of engine power as result of carburetor icing. Contributing factors were the lack of suitable terrain for the forced landing and the weather conditions conducive to carburetor icing.