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 LAX93LA012Accident · 2 fatalLimited investigationFinal reportGilbert SX300 · Rosamond, CAThe pilots inadequate compensation for the wind conditions and his failure to maintain an adequate airspeed while maneuvering which led to an inadvertent stall spin.NTSB ATL93FA008Accident · 4 fatalField investigationFinal reportCessna 310K · East Point, GAThe pilot's mismanagement of the fuel supply which resulted in fuel stravation of both engines.NTSB SEA93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Spokane, WAInadequate preflight planning/preparation. Factors to the accident were: fuel exhaustion and inadequate fuel consumption calculations.NTSB NYC93LA016Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Kitts Hill, OHA hard landing due to improper use of the collective, following a wire strike due to inadequate visual lookout.NTSB ANC93IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Anchorage, AKImproper ATC clearance instructions by the approach controller, resulting in a failure to insure safe separation between an airplane in visual conditions with an airplane in instrument meteorological conditions on converging courses. A factor which…NTSB NYC93LA018Accident · No injuriesLimited investigationFinal reportFranklin-Sullivan Technologies FS 1 · Littletown, PAInadequate altitude due to an improperly planned approach which resulted in a tree strike on final approach.NTSB ANC93LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nightmute, AKPilot did not attain proper touchdown point while landing on a raised gravel runway.NTSB SEA93LA004Accident · 1 fatalLimited investigationFinal reportCarlson Midget Mustang · Baker, ORAn inadvertent stall/spin by the pilot in command. A factor contributing to the accident was the pilot in command's lack of recent experience.NTSB MIA93LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · St Augustine, FLFailure of the instructor pilot (CFI) to assure adequate compensation for wind conditions. Factors related to the accident were: the crosswind and turbulent weather conditions.NTSB NYC93LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Marengo, OHThe pilot's inadequate visual lookout due to sunglare, which resulted in a tree strike on final approach.NTSB NYC93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Heathsville, VAThe improper inflight planning and decision by the student pilot resulting in fuel exhaustion.NTSB NYC93LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Akron, NYThe failure of the pilot to compensate for adverse winds and wind shear. A factor related to the accident was the adverse wind conditions.NTSB ATL93LA002Accident · No injuriesLimited investigationFinal reportBeech E-55 · Chattanooga, TNThe failure of an unknown person to follow proper procedures/directives by operating a radio-controlled model plane in airport traffic pattern airspace.NTSB LAX92LA409Accident · Minor injuriesLimited investigationFinal reportCessna 310D · Minden, NVPilot's and mechanic's inadequate inspection of the aircraft and the pilot's poor inflight decision by not returning to the departure airport after experiencing the initial engine loss of power on takeoff. Contributing to this accident was fuel starvation due…NTSB FTW92LA234Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Roswell, NMThe pilot failed to maintain the correct airspeed on final approach and allowed the aircraft to stall.NTSB ANC92LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Taylor Road, AKThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident were the gusting crosswinds and the pilot's lack of total experience in this type operation.NTSB SEA92LA215Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Helena, MTFuel exhaustion, the pilot in command's failure to refuel en route and the inability of the pilot in command to avoid the fence during the landing roll. Factors contributing to the accident were dark night conditions and the fence.NTSB LAX92LA406Accident · No injuriesLimited investigationFinal reportCessna 150B · Show Low, AZFuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft prior to departure.NTSB MIA92LA191Accident · Serious injuriesLimited investigationFinal reportLet L-13 · New Smyrna Bch, FLThe pilot's inadequate compensation for wind conditions. The downdraft was a factor in the accident.NTSB LAX92LA408Accident · 2 fatalLimited investigationFinal reportAir Command · Eureka, CAThe failure of the unqualified non certificated pilot to maintain control of the gyrocopter. A factor in the accident was the pilot's lack of total experience.NTSB LAX92LA404Accident · 1 fatalLimited investigationFinal reportLanceair 235 · Hollister, CAThe pilot performing the final segment of a visual approach at too low of an altitude resulting in an inflight collision with a guy wire.NTSB FTW92FA232Accident · 1 fatalField investigationFinal reportCessna 310R · Idabel, OKThe pilot's descent below the minimum descent altitude. Factors were the pilot's improper IFR procedure, low ceiling, and dark night conditions.NTSB BFO92LA150Accident · 2 fatalLimited investigationFinal reportPiper PA-28-160 · Bethel, METhe pilot's failure to maintain adequate altitude to avoid the terrain. The dark night was a factor.NTSB SEA92LA217Accident · No injuriesLimited investigationFinal reportCessna 140 · Moab, UTThe loss of engine power due to fuel exhaustion resulting from inaccurate fuel consumption calculations by the pilot. A factor relating to the accident was the terrain condition (ditch) in the landing area.NTSB CHI92LA289Accident · No injuriesLimited investigationFinal reportLearjet LR-60 · Hutchinson, KSInadequate flight test methods by the manufacturer and the FAA which did not permit safe operating clearances.NTSB CHI92FA290Accident · No injuriesField investigationFinal reportBeech B55 · Joliet, ILThe pilot's inadvertent wheels up landing.NTSB SEA92LA209Accident · 2 fatalLimited investigationFinal reportAnderson Vans RV-6 · Puyallup, WAThe failure of the pilot to configure the acft for landing (lowering of flaps) and maintain airspeed above stall during final approach for landing.NTSB MIA92LA189Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLUndetected chaffing and grounding of a wire to the nose landing gear squat switch which resulted in the landing gear being signalled at all times for gear up when electrical power was applied to the system. Contributing to the accident was the overheating of…NTSB MIA92LA188Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLFailure of the right main landing gear actuator due to overstress for undetermined reasons which resulted in loss of all landing gear system hydraulic fluid which in turn resulted in the pilot being unable to extend and lock the landing gear.NTSB MIA92LA186Accident · Minor injuriesLimited investigationFinal reportTaylor Prescott · Plant City, FLThe pilot in command's failure to maintain airspeed (vso) during a go around, resulting in a loss of control (stall), and subsequent on ground collision with a parked airplane.NTSB CHI92LA284Accident · No injuriesLimited investigationFinal reportCessna 150M · Joplin, MOPoor preflight planning and preparation along with the pilot's failure to assure an adequate fuel supply to complete the flight. A factor related to the accident was the downdraft encountered.NTSB BFO92IA145Incident · No injuriesIncident investigationFinal reportLockheed L1011-385 · Boston, MAInadequate lubrication which caused stress corrosion cracking and the separation of the right wing number two flap vane.NTSB FTW92GA227Accident · No injuriesFinal reportCessna T210L · Spring, TXThe pilot under instruction failure to follow the landing checklist and the instructor pilot's inadequate supervision. A factor was the overheated landing gear motor.NTSB BFO92FA151Accident · 3 fatalField investigationFinal reportCessna R182 · Edgartown, MAThe pilots's lack of regard for the published decision height of the approach and his decision not to execute a missed approach. Factors contributing to the accident include the pilot's failure to attain the proper glidepath and descent rate during the…NTSB ANC92LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-12-150 · Upper Yantarni, AKPilot in command inadvertant encounter with aerodynamic stall during low level approach turn. Factor affecting the accident was: the pilot's approach procedure/technique to fly VFR approach pattern at 50 feet AGL.NTSB SEA92FA197Accident · 4 fatalField investigationFinal reportCessna 170A · Lopez, WAThe pilot's inadvertent stall/spin. Factors include gusty, unfavorable, high velocity winds, and turbulence.NTSB CHI92DCA04Accident · Serious injuriesFinal reportTinsman RV6 · Foristell, MOThe partial failure of the fuel injection system. Factors related to the accident are the pilot's insufficient altitude to reach the runway from the downwind leg, and the presence of transmission wires in the off airport landing site.NTSB ANC92FA164Accident · 3 fatalField investigationFinal reportMcdonnell Douglas 369D · Eagle, AKAn inflight fatigue failure and separation of a main rotor blade, inadequate operator maintenance and inspection, and material defect.NTSB ANC92LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Lime Village, AKThe pilot in command not maintaining control of the airplane. A factor in the accident was the wind gusts.NTSB CHI92LA270Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Petersburg, MIInadequate visual lookout by the pilot in command during final approach. A factor in the accident was the sunglare.NTSB MIA92LA175Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hollywood, FLThe pilot-in-command's failure to refuel the airplane which resulted in a total loss of engine power in flight due to fuel exhaustion, subsequent forced landing, and on ground collision with a tree on landing roll out.NTSB CHI92LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wheeling, ILMain landing gear collapse as a result of the failure of a landing gear hydraulic pump seal.NTSB BFO92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Windham, CTThe pilot's improper IFR operation. Contributing was the pilot's instrument flight inexperience.NTSB BFO92FA125Accident · 3 fatalField investigationFinal reportPiper PA-60-602P · Georgetown, DEThe pilot's failure to maintain airspeed, while circling to land, resulting in an inadvertent stall. Factors related to the accident were: the pilot's excessive maneuvering of the airplane and his insufficient altitude for recovery from the stall.NTSB CHI92LA263Accident · No injuriesLimited investigationFinal reportCessna 402B · Almont, MIExcessive fuel system pump pressure and corresponding excessive fuel pressure and the pilot not maintaining the best single engine climb speed.NTSB LAX92FA374Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Concord, CAThe following Probable Cause was modified on April18, 2007, as a result of new information provided to the NTSB. The improper installation of the 1.75 inch od plug in the crankshaft by unknown maintenance personnel which resulted in an inadvertent feathering…NTSB MIA92FA173Accident · 2 fatalField investigationFinal reportBeech BE-A23-19 · Picayune, MSThe failure of the pilot in command to place the fuel selector on the fullest tank, resulting in an engine failure due to fuel starvation over unsuitable terrain.NTSB FTW92DQG02Accident · 1 fatalFinal reportWoodstock AIR Command 532 · Dumas, TXThe pilot's failure to maintain airspeed. A factor was the high density altitude.NTSB CHI92LA259Accident · No injuriesLimited investigationFinal reportMooney 20F · Lacon, ILThe pilot's failure to recognize that the runway he selected for landing was closed. Factors which contributed to the accident were: the pilot's anxiety following the near-collision, and his limited ability to detect the orange-colored marking.NTSB LAX92FA367Accident · 1 fatalField investigationFinal reportCessna 182Q · Santa Paula, CAThe failure of both pilots to see and avoid each other. Contributing to the accident was the azimuth of the setting sun and the Cessna 182 pilots non standard flight pattern.