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 NYC98LA125Accident · Serious injuriesLimited investigationFinal reportBeech BE 65-80 · Malone, NYThe pilot's failure to follow emergency procedures, and his failure to maintain control of the airplane after a loss of power from one engine. Factors include fuel filter blockage, inadequate maintenance, and the pilot's lack of experience in multi-engine…NTSB CHI98LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Sikesville, MOthe deer which ran in front of the airplane during the landing flare. Factors associated with the accident were the inadequate airspeed which resulted in the pilot not being able to maintain directional control of the airplane as he attempted to avoid deer,…NTSB ANC98LA060Accident · No injuriesLimited investigationFinal reportCessna U206 · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are variable winds, and windshear.NTSB ANC98TA062Accident · Minor injuriesFinal reportCessna 185 · Kotzebue, AKThe instructor pilot's inadequate compensation for wind conditions. A factor associated with this accident was a downdraft prior to touchdown.NTSB FTW98LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Claremore, OKThe pilot's failure to maintain obstacle clearance.NTSB MIA98LA171Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Jacksonville, FLThe pilot's failure to maintain airspeed (VSO) on final approach resulting in an inadvertent stall.NTSB FTW98LA245Accident · No injuriesLimited investigationFinal reportCessna 320B · Rockport, TXThe pilot's failure to maintain airspeed during a go around which resulted in an inadvertent stall. Factors were the pilot's lack of experience in the make and model aircraft, his failure to follow the before landing checklist, and his improper use of the…NTSB MIA98LA168Accident · No injuriesLimited investigationFinal reportGulfstream American 690C · Jacksonville, FLthe left main landing gear failed to extend due to a jammed link assembly.NTSB NYC98LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hanover, PAfailure of the pilot to obtain current information for the divert airfield, and his selection of an unsuitable area for landing. Related factors included: the lower ambient light conditions at dusk, construction on the airfield, and an over-reliance on the…NTSB NYC98GA113Accident · 2 fatalFinal reportCessna 182R · Middleborough, MAThe pilot-in-command's failure to maintain control of the airplane during a VFR go-around. A factor was the impairment due to drugs.NTSB SEA98LA082Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Sandpoint, IDLoss of consciousness by the pilot-in-command/flight instructor, resulting in loss of aircraft control and subsequent collision with terrain.NTSB FTW98LA241Accident · No injuriesLimited investigationFinal reportMader WAG-AERO 2+2 · Hurricane, UTAn encounter with high vegetation and unsuitable terrain during a forced landing. A factor was a partial failure of the engine's exhaust stack during flight.NTSB ANC98LA055Accident · Minor injuriesLimited investigationFinal reportDouglas DC-3C · Anchorage, AKThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent loss of engine power. A related factor was the soft, marshy terrain at the forced landing area.NTSB NYC98FA111Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Lincoln, MAThe pilot's failure to maintain airspeed.NTSB LAX98LA168Accident · No injuriesLimited investigationFinal reportCessna T210M · Santa Barbara, CAThe pilot's mismangement of the fuel by the improper position of the fuel tank selector.NTSB SEA98FA078Accident · 2 fatalField investigationFinal reportPiper PA-31T1 · Great Falls, MTThe flight crew's failure to maintain aircraft control.NTSB LAX98LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Hollister, CAThe failure of the instructors and dual students in both aircraft to maintain an adequate visual lookout, which resulted in their combined failures to see and avoid each other. Inadequate supervision of the two flights by the respective instructor pilots were…NTSB FTW98LA224Accident · No injuriesLimited investigationFinal reportMooney M20F · Telluride, COThe pilot exceeded the crosswind capability performance of the aircraft, and his delayed response in initiating a go around. Factors were gusty, crosswind and tailwind conditions, and high density altitude.NTSB FTW98LA223Accident · Serious injuriesLimited investigationFinal reportAS+ AC-4 · Cedar Fort, UTFailure by the pilot to maintain control of the aircraft. A factor was lack of experience in make and model.NTSB LAX98LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Clarksburg, CAA total loss of engine power for undetermined non-mechanical reasons. A contributing factor in the landing nose-over was the presence of the soft terrain.NTSB MIA98FA162Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Mccalla, ALThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB IAD98LA053Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Nashua, NHThe pilot's improper fuel management which led to fuel starvation.NTSB CHI98LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Emily, MNThe pilot's failure to maintain the proper rate of descent on final. A factor was the vegetation (bushes).NTSB ATL98LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Hendersonville, NCThe pilot's failure to attain the proper touchdown point and improper go-around procedures resulting in collision with wires, trees, and the ground. Factors were the pilot's lack of familiarity with the airplane and the short runway.NTSB SEA98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Monroe, WAFuel starvation due to the flight instructor's improper in-flight decision to simulate an engine failure by pulling the mixture control toward the lean position until the engine shut down, and his failure to return the mixture to the rich position until after…NTSB LAX98FA149Accident · 1 fatalField investigationFinal reportRobinson R22 · Irwindale, CAThe failure of the pilot to observe in a timely manner and maintain clearance from electrical power transmission wires and her improper maneuver to avoid the obstruction.NTSB ATL98LA067Accident · 1 fatalLimited investigationFinal reportUnknown Freebird Sport · Englewood, FLThe inadvertent aerodynamic stall, and subsequent loss of control in-flight by the non-certificated pilot. A factor was the use of over the counter drugs which are known to cause drowsiness.NTSB LAX98LA148Accident · No injuriesLimited investigationFinal reportCessna 150G · Oroville, CAThe pilot's failure to maintain the proper glide path, and his inadequate compensation for wind conditions, which resulted in an undershoot.NTSB FTW98LA198Accident · No injuriesLimited investigationFinal reportCessna 172N · Parker, COa fractured #1 exhaust valve rocker arm stud, which subsequently resulted in loss of engine power and a forced landing. The lack of suitable terrain in the forced landing area was a related factor.NTSB FTW98LA193Accident · Serious injuriesLimited investigationFinal reportLerille P & W 1937 · Lafayette, LAThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB CHI98LA135Accident · No injuriesLimited investigationFinal reportCessna C-182 · Emporia, KSThe pilot's failure to maintain control of the airplane. Factors contributing to this accident were the strong crosswind and the wind gusts.NTSB CHI98LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · Eagle River, WIthe pilot failed to compensate for the wind conditions, improperly executed a go-around when he raised the flaps, and failed to maintain obstacle clearance with the trees.NTSB NYC98LA101Accident · Serious injuriesLimited investigationFinal reportBeech D95A · Mount Sterling, KYWas the failure of the flight instructor to feather the engine in a timely manner. Factors were improper placement of the fuel selector valve by the student and failure of the flight instructor to adequately supervise its placement.NTSB LAX98FA141Accident · 2 fatalField investigationFinal reportCessna 172 · Ramona, CAThe loss of control of the aircraft on final approach for undetermined reasons.NTSB IAD98FA047Accident · 1 fatalField investigationFinal reportBeech 58 · Columbus, OHThe pilot's inadequate planned approach and his failure to follow wake turbulence avoidance procedures by not staying above the glide-path of the preceding Boeing 757, which resulted in a vortex turbulence encounter. Contributing to the accident was the wake…NTSB FTW98FA191Accident · 1 fatalField investigationFinal reportBeech F33A · Del Rio, TXthe pilot's loss of control during a go-around after impacting approach light poles on initial approach. A contributing factor was the prevailing dark night light condition.NTSB NYC98LA097Accident · Serious injuriesLimited investigationFinal reportLet L-23 Super Blanik · Pipersville, PAthe pilot's misjudgment of distance and altitude, while on an approach to an off-airport landing area, which resulted in a lack of airspeed and/or altitude to reach the intended landing area (undershoot), a stall or mush into tree(s), and collision with a…NTSB LAX98LA140Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Los Angeles, CAAn overtemp of the engine during start within 10 hours of the accident, and the failure to report the event to the maintenance facility.NTSB NYC98FA095Accident · 1 fatalField investigationFinal reportMooney M20J · Bridgeport, CTThe pilot's failure to maintain control of the airplane during night instrument meteorological conditions. Contributing factors were dark night conditions, low ceilings, rain, and his decision to divert to an airport under instrument meteorological conditions…NTSB MIA98LA137Accident · No injuriesLimited investigationFinal reportBennett M-500A · Lakeland, FLa hex nut on the cyclic flight control pushrod bolt had backed off for undetermined reason(s) and allowed the bolt to become disconnected from the control yoke teeter block, resulting in a loss of cyclic control and subsequent roll over during an emergency…NTSB FTW98LA188Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Longmont, COThe pilot inadvertently stalling the aircraft during the landing touchdown. Factors were a crosswind and the pilot's lack of total flight experience.NTSB LAX98LA138Accident · No injuriesLimited investigationFinal reportPorat RAF-200 · Hollister, CAThe failure of the pilot to maintain control of the aircraft. A factor in this accident is the pilot's lack of experience in type aircraft.NTSB LAX98LA137Accident · No injuriesLimited investigationFinal reportGrumman American AA5B · Aguanga, CAthe lack of available published information regarding obstructions and nonstandard lighting at the private airport, and the lack of a lighted and properly marked displaced threshold.NTSB LAX98LA136Accident · Minor injuriesLimited investigationFinal reportBeech M35 · North Las Vegas, NVfuel starvation due to the pilot's improper fuel management and his failure to select the fullest tank for landing.NTSB FTW98LA187Accident · No injuriesLimited investigationFinal reportBell 206B · Cameron, LAThe loss of engine power for undetermined reasons and the pilot's improper flare which resulted in a hard landing.NTSB MIA98LA133Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Miami Lakes, FLThe failure of the pilot to ensure the aircraft contained enough fuel to complete the flight resulting in loss of engine power due to fuel exhaustion.NTSB MIA98LA130Accident · 1 fatalLimited investigationFinal reportStarck Auriga · Collegedale, TNA leak in the electric fuel boost pump caused by an improperly sized 'O' ring installation and the pilot's failure to maintain airspeed during an approach to a forced landing resulting in a stall.NTSB MIA98LA129Accident · Serious injuriesLimited investigationFinal reportKrips Kolb Firestar · Dallas, GAThe pilot's failure to maintain adequate airspeed for the existing wind conditions.NTSB LAX98LA135Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Scottsdale, AZThe pilot's failure to maintain directional control and his inadequate compensation for the wind condition. A contributing factor was the crosswind.NTSB CHI98FA119Accident · 1 fatalField investigationFinal reportCessna 208B · Bismarck, NDthe pilot's failure to maintain adequate airspeed during the approach which resulted in an inadvertant stall. Factors associated with the accident were the icing conditions and the pilot's low level experience in this make and model of airplane.