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 LAX95LA224Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Chandler, AZFuel exhaustion resulting from the pilot's failure to determine the amount of fuel onboard at departure. The reduced ambient lighting was a factor in this accident.NTSB SEA95LA130Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Challis, IDThe pilot's failure to maintain an adequate supply of fuel for the flight. The terrain condition was a factor.NTSB BFO95LA072Accident · No injuriesLimited investigationFinal reportKolb Twinstar · Abingdon, VAThe loss of engine power due to undetermined reasons. Factors found to be involved in this accident were the condition inspection was overdue and the inadequate training received by the student pilot owner/builder.NTSB ANC95FA086Accident · 4 fatalField investigationFinal reportPiper PA-31 · Valdez, AKThe pilot's failure to follow the published IFR (missed approach) procedure and assure adequate altitude/clearance from mountainous terrain.NTSB SEA95LA125Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Monroe, WAThe pilot's failure to maintain airspeed.NTSB MIA95FA155Accident · Serious injuriesField investigationFinal reportCessna 402A · Miami, FLThe pilot-in-command's failure to maintain airspeed (VMC) after loss of power of one engine while on final approach, resulting in an in-flight loss of control and subsequent in-flight collision with terrain. Contributing to the accident was a total loss of…NTSB FTW95LA258Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Kingston, OKA malfunction of the propeller governor due to a loose control cable.NTSB BFO95LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Wauseon, OHThe pilot's failure to obtain/maintain adequate altitude/clearance from obstacles during an attempted go-round. Related factors are the pilot's failure to attain the planned approach and the improper go-around procedures.NTSB BFO95LA073Accident · Minor injuriesLimited investigationFinal reportKemp ACRO-SPORT II · Honeoye Falls, NYthe pilot's inadequate preflight planning/preparation and his misjudging of the touchdown during the forced landing. Related factors are the pilot's improper maintenance, and fuel contamination.NTSB CHI95LA195Accident · No injuriesLimited investigationFinal reportCessna 172 · St Cloud, MNThe pilot's improper inflight planning/decision, which resulted in continued flight into adverse weather. Factors relating to the accident were: the thunderstorm outflow, and inadequate weather evaluation by the pilot.NTSB LAX95GA219Accident · 3 fatalFinal reportDouglas C-54G · Ramona, CAInadequate visual lookout by the Beech 58P pilot, and the operator's inadequate procedures concerning 360-degree overhead approaches.NTSB BFO95LA070Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Utica, NYThe pilot's improper retraction of the flaps.NTSB LAX95LA218Accident · Minor injuriesLimited investigationFinal reportED Bergreen KIS · San Leandro, CAthe pilot's poor preflight preparation and in-flight decision to overfly a suitable airport when it was evident that he was having an engine problem. The fuel exhaustion was a factor in this accident.NTSB BFO95LA066Accident · 1 fatalLimited investigationFinal reportDrake Moni · Pittsfield, MAthe pilot's failure to maintain/regain control of the aircraft during the simulated engine-out procedure while on approach to landing.NTSB SEA95FA120Accident · 1 fatalField investigationFinal reportCessna 175A · Moab, UTThe pilot's failure to maintain proper altitude in the visual flight rules (VFR) traffic pattern. Contributing to the accident were the pilot's failure to follow dispatch procedures, the dark night conditions, and the unavailability of the airport's…NTSB LAX95LA211Accident · 1 fatalLimited investigationFinal reportHarmon Dolphin · Paso Robles, CAThe pilot's decision continue VFR flight into instrument meteorological conditions (IMC), loss of aircraft control due to spatial disorientation, and exceeding the design stress limits of the airplane. The weather condition was a related factor.NTSB BFO95LA061Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee BT-13B · Oxford, CTthe pilot's failure to maintain sufficient altitude/clearance from terrain. The low ceiling was a related factor in the accident.NTSB BFO95LA060Accident · Serious injuriesLimited investigationFinal reportBronislaus Challenger II · Burlington, CTA loss of engine power for an undetermined reason(s), the 30-hour student pilot's poor judgment in allowing himself to receive dual instruction in an airplane not equipped with dual conntols, the cfi's poor judgment in attempting to give instruction to a…NTSB BFO95FA058Accident · 3 fatalField investigationFinal reportCessna 150L · Highgate, VTthe failure of both pilots to see and avoid each other. A factor was the Cessna 172H pilot's impairment due to medication.NTSB SEA95LA116Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Blakely Island, WAAn undetermined loss of engine power and suitable terrain was not available.NTSB FTW95LA392Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Springlake, TXThe loss of engine power due to the uncontained failure of the third stage turbine wheel. A factor was the lack of suitable terrain for the forced landing.NTSB MIA95FA145Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Gainesville, FLThe pilot's loss of aircraft control due to spatial disorientation after continuing the VFR flight into instrument meteorological conditions. Factors relating to the accident were: the existing weather conditions and dark night that contributed to the pilot's…NTSB CHI95LA173Accident · Minor injuriesLimited investigationFinal reportCessna 150L · St. Charles, MOthe student pilot's inadvertent interference with flight controls which resulted in a stall. A factor associated with the accident was the student's excessive use of the elevator control.NTSB SEA95LA114Accident · No injuriesLimited investigationFinal reportCessna 150J · Miles City, MTThe flight instructor's inadequate supervision. Factors to the accident were: The student pilot's failure to maintain aircraft control and the downdraft.NTSB FTW95FA226Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Palestine, TXLoss of aircraft control during a go-around, due to failure of the flight instructor (CFI) to assure that the minimum control speed (VMC) was maintained. Factors relating to the accident were: shutdown of the left engine, which would have prevented normal…NTSB ATL95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Columbia, SCThe misalignment of the nose gear centering track and roller assemblies which precluded landing gear extension.NTSB CHI95LA166Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Valparaiso, INThe pilot's improper execution of the ILS approach. Factors related to the accident were the fog and the pilot's lack of total flight time in actual instrument conditions.NTSB LAX95LA200Accident · No injuriesLimited investigationFinal reportEurocopter AS-355F1 · Lost Hills, CAthe pilot's in-flight loss of control and failure to maintain a proper descent rate due to spatial disorientation and lack of visual cues during a dark, night approach to a unimproved landing zone, and his failure to initiate a go-around when he first lost…NTSB MIA95LA140Accident · No injuriesLimited investigationFinal reportMoncrief Zodiac 601 · Fernandina Bch, FLThe failure of maintenance personnel to adequately torque the propeller bolts during the last inspection resulting in the bolt failures and the loss of the propeller.NTSB MIA95LA139Accident · No injuriesLimited investigationFinal reportCessna 182A · Vero Beach, FLTotal loss of engine power for undetermined reasons while on final approach to land and unsuitable terrain encountered during the landing roll.NTSB ATL95LA100Accident · Minor injuriesLimited investigationFinal reportBeech 95-A55 · Tuskeegee, ALThe pilot's inadequate preflight planning that resulted in fuel exhaustion.NTSB NYC95LA122Accident · 2 fatalLimited investigationFinal reportCessna 172N · Weston, WVthe pilot's failure to maintain airspeed which resulted in an inadvertent stall, and a subsequent uncontrolled descent and collision with the ground.NTSB LAX95LA193Accident · No injuriesLimited investigationFinal reportCessna 172F · Boonville, CAa loss of engine power for undetermined reasons.NTSB NYC95LA124Accident · 1 fatalLimited investigationFinal reportBailey Quickie Q-2 · Woodsfield, OHThe loss engine power for undetermined reason and the pilot's failure to maintain control which resulted in an inflight collision with terrain.NTSB FTW95LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ville Platte, LAThe pilot's failure to clear a levee during the approach. A factor was a truck parked on the runway.NTSB FTW95FA206Accident · 2 fatalField investigationFinal reportNorth American T-6G · Beaumont, TXThe pilot's failure to perform a go-around and his failure to maintain airspeed. Factors in the accident were improper runway alignment and an aft center of gravity.NTSB SEA95FA103Accident · 2 fatalField investigationFinal reportCessna 177RG · Kent, WAThe pilot's misjudgment of distance and altitude during the approach. Factors in the accident were the dusk light condition and the shadows.NTSB FTW95LA212Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Owasso, OKThe failures of the landing gear hydraulic pump and the emergency gear extension system as result of inadequate maintenance by maintenance personnel.NTSB CHI95FA153Accident · 1 fatalField investigationFinal reportRyan Navion · Sturgis, MIthe pilot's inadequate compensation for wind conditions during the attempted landing and go-around. A factor was the crosswind weather condition.NTSB SEA95FA101Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Cheyenne, WYfailure of the pilot to maintain sufficient altitude/clearance from rising terrain. Factors relating to the accident were: low light conditions at dusk, low ceilings with thunderstorms in the area, and continued flight by the pilot into adverse weather…NTSB FTW95LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Baytown, TXThe pilot failed to maintain the proper glidepath during landing.NTSB FTW95LA194Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Casa, ARThe pilot's failure to maintain obstacle clearance.NTSB SEA95LA096Accident · No injuriesLimited investigationFinal reportCessna A185F · Oroville, WAWater contamination in the fuel, and the pilot's inadequate preflight of the aircraft before flight. Factors related to the accident were: deteriorated seal(s) on the fuel tank cap(s), non-compliance with an airworthiness directive to prevent water leaking…NTSB NYC95FA105Accident · 2 fatalField investigationFinal reportBeech BE60 · Olney, ILThe pilot's improper IFR procedures by descending below the minimum descent altitude and not executing the published missed approach procedures. A factor in thE accident was the low overcast and fog conditions.NTSB NYC95FA103Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Toano, VAThe pilot misjudged altitude and distance which resulted in an undershoot of the landing area and collision with water. Contributing factors are inadequate helipad lighting and a dark night light condition.NTSB FTW95FA186Accident · 1 fatalField investigationFinal reportBell 206L-3 · Venice, LALoss of engine power due to ingestion of exhaust fumes from an oil platform flare boom.NTSB FTW95FA184Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Porter, TXThe pilot's failure to identify the unsafe condition created by carrying a battery with jumper cables attached in the baggage compartment and the ensuing fire in the baggage compartment.NTSB BFO95FA048Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Louisa, VAthe non-instrument rated private pilot's continued VFR flight into IMC and failure to maintain adequate altitude/clearance from terrain/obstacles. Related factors were the pilot's lack of total experience in IMC operations, his failure to obtain a preflight…NTSB MIA95LA123Accident · Serious injuriesLimited investigationFinal reportBeech B95 · Leakesville, MSThe failure of the pilot-in-command to operate the aircraft in accordance with manufacturer's limitations resulting in fuel starvation and a total loss of power in both engines.NTSB FTW95LA183Accident · No injuriesLimited investigationFinal reportCessna 340A · Dallas, TXThe pilot's failure to maintain aircraft control during landing. A factor was the loss of engine power for undetermined reasons.