OpenAirDocs.org

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.

NTSB FTW01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Pearland, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion while in the traffic pattern.Apr 7, 2001 · N4514Y · Substantial damageNTSB FTW01LA096Accident · No injuriesLimited investigationFinal reportCessna T210M · Abilene, TXthe loss of engine power while on final approach due to fuel starvation as a result of the pilot's improper use of the fuel selector. A contributing factor was the elevated runway edge.Apr 6, 2001 · N555HG · Substantial damageNTSB FTW01LA093Accident · No injuriesLimited investigationFinal reportEmpson F4UCorsair · Baton Rouge, LAthe pilot's inadequate preflight planning resulting in fuel exhaustion during approach. A contributing factor was the lack of suitable terrain for the forced landing.Apr 5, 2001 · N914DA · Substantial damageNTSB MIA01IA110Incident · No injuriesIncident investigationFinal reportDouglas DC3A · San Juan, PRThe captain's activation of the left propeller feathering button after failure of the right engine for undetermined reasons resulting in loss of all engine power and the airplane making a forced landing in water.Apr 4, 2001 · N19BA · Minor damageNTSB DCA01MA034Accident · 18 fatalClass 1 · MajorFinal reportGrumman Gulfstream III · Aspen, COthe flight crew's operation of the airplane below the minimum descent altitude without an appropriate visual reference for the runway. Contributing to the cause of the accident were the Federal Aviation Administration's (FAA) unclear wording of the March 27,…Mar 30, 2001 · N303GA · DestroyedNTSB ATL01LA042Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Niceville, FLA loss of engine power for undetermined reasons.Mar 30, 2001 · N7471D · DestroyedNTSB CHI01LA109Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Minneapolis, MNThe pilot not maintaining the proper airspeed during the circling approach, the inadvertent stall and the subsequent loss of control. Factors were the pilot's decision to continue the approach in weather conditions below the approach/landing minimums, the…Mar 28, 2001 · N8247Q · Substantial damageNTSB LAX01LA124Accident · No injuriesLimited investigationFinal reportCessna 150G · San Diego, CAThe student pilot's poor inflight planning/judgement to continue a flight into IFR conditions and not divert to an airport operating under VFR conditions. Factors were the pilot's misunderstanding of his flight limitations, special VFR, and not obtaining a…Mar 21, 2001 · N733JG · Substantial damageNTSB LAX01LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gila Bend, AZFailure of the CFI to properly supervise the flight and the failure of the dual studen to maintain flying airspeed. A contributing factor was the wind shear encountered.Mar 20, 2001 · N4188E · Substantial damageNTSB IAD01FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-RT201 · Manassas, VAThe pilot's spatial disorientation due to a night visual illusion. A factor was the dark night condition.Mar 20, 2001 · N2380U · DestroyedNTSB DEN01LA073Accident · No injuriesLimited investigationFinal reportCessna 340 · Alamosa, COThe in-flight collision with a large bird during downwind approach for landing.Mar 20, 2001 · N9940F · Substantial damageNTSB MIA01FA102Accident · Serious injuriesField investigationFinal reportPiper PA-34-200 · Palm Coast, FLthe second pilot's failure to maintain Vmc during a single engine approach resulting in a loss of control in flight and subsequent collision with objects and terrain during an uncontrolled descent. Contributing to the accident was the PIC turning the right…Mar 16, 2001 · N44589 · DestroyedNTSB FTW01LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Houston, TXthe pilot's failure to execute a go-around after becoming low on a visual approach.Mar 13, 2001 · N93504 · Substantial damageNTSB MIA01LA096Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Brevard, NCan in-flight collision with a tree. Factors in this accident were the pilot's inadequate planned approach and excessive airspeed on the approach.Mar 10, 2001 · N2172S · Substantial damageNTSB ATL01LA038Accident · No injuriesLimited investigationFinal reportBeech 55 · Lake Wales, FLThe pilot's failure to follow the descent and before landing checklist that resulted in fuel starvation to both engines and the subsequent loss of engine power.Mar 10, 2001 · N8472N · Substantial damageNTSB SEA01FA059Accident · No injuriesField investigationFinal reportde Havilland DHC-8-102 · Portland, ORThe failure of the number 5 engine bearing assembly followed by the disconnection of the P2.5/P3 switching valve to rear inlet case sealing air tube and the melting of the NL probe port (sealing tube) which allowed an oil fed fire beyond the constraints of…Mar 6, 2001 · N822PH · Substantial damageNTSB SEA01LA053Accident · No injuriesLimited investigationFinal reportGibbs V-6 Stol · Newberg, ORthe pilot's mismanagement of his available fuel, the fuel starvation of the engine, and the pilot's excessive rate of descent during the touchdown portion of a power-off forced landing.Feb 25, 2001 · N230VG · Substantial damageNTSB CHI01FA093Accident · 2 fatalField investigationFinal reportCessna 172H · Centralia, ILThe student pilot allowed the airspeed to get too low and inadvertently stalled the airplane, and the CFI delayed in taking remedial action.Feb 21, 2001 · N733SS · DestroyedNTSB SEA01LA052Accident · No injuriesLimited investigationFinal reportCessna 402B · Billings, MTBest rate-of-climb single-engine speed was not maintained. Delayed remedial action was a factor.Feb 20, 2001 · N69316 · Substantial damageNTSB ATL01FA036Accident · 5 fatalField investigationFinal reportCessna 421 · Munford, ALThe pilot continued visual flight into instrument weather conditions that resulted in the inflight collision with a river bank. Factors were reduced visibility and dark night.Feb 14, 2001 · N5AY · DestroyedNTSB SEA01LA049Accident · No injuriesLimited investigationFinal reportAero Commander AC-690 · Eugene, ORan undetermined malfunction of the nose gear system which resulted in the failure of the nose gear to fully extend and lock prior to landing.Feb 12, 2001 · N690AC · Substantial damageNTSB LAX01LA095Accident · No injuriesLimited investigationFinal reportBeech A36 · Palo Alto, CAThe pilot-in-command's delayed decision to go-around and his failure to maintain sufficient airspeed during the attempted go-around. His non-verification of the flap setting contributed to the accident.Feb 9, 2001 · N3191A · Substantial damageNTSB LAX01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAFuel starvation due to the pilot inadvertently shutting off its supply on approach for landing.Feb 9, 2001 · N8122G · Substantial damageNTSB CHI01FA083Accident · 2 fatalField investigationFinal reportSwearingen SA227-AT · Beaver Island, MIThe flightcrew not maintaining altitude/clearance during the circling instrument approach. Factors were the pilot in command initiating the flight without proper weather reporting facilities at the destination, the flightcrew not flying to an alternate…Feb 9, 2001 · N318DH · DestroyedNTSB CHI01LA082Accident · Serious injuriesLimited investigationFinal reportBeech 65-B80 · Sioux Falls, SDThe pilot initiated the flight into known icing conditions which resulted in his ability to maintain control of the airplane. Factors associated with the accident were the ice accumulation and the company induced pressure for the pilot to make the flight into…Feb 8, 2001 · N107BA · Substantial damageNTSB ATL01LA033Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Augusta, GAThe pilot's failure to properly preflight fuel required for the flight that resulted in fuel exhaustion and the lost of engine power.Feb 8, 2001 · N125LS · Substantial damageNTSB DEN01LA050Accident · No injuriesLimited investigationFinal reportDassault-Breguet Mystere Falcon 900 · Pinedale, WY**This report was modified on 2/18/2016. Refer to the public docket for this accident for an explanation of the changes.** loss of directional control after touchdown for undetermined reasons.Feb 7, 2001 · N59CF · Substantial damageNTSB CHI01FA080Accident · 1 fatalField investigationFinal reportBeech 58 · Ainsworth, NEthe pilot's improper in-flight decision to continue flight into known adverse weather. A factor was the icing conditions.Feb 7, 2001 · N52BA · DestroyedNTSB ANC01TA035Accident · No injuriesFinal reportRobinson R-44 · Chickaloon, AKThe pilot's collision with terrain due to his inadequate planning of the approach, and his failure to maintain the helicopter's main rotor RPM during a go-around. Factors in the accident were a tailwind, flat lighting conditions, and snow-covered terrain.Feb 4, 2001 · N7183P · Substantial damageNTSB LAX01LA091Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Lake Elsinore, CAThe failure of the glider pilot to maintain adequate airspeed during a turn from base leg to final approach, which lead to a stall and spin.Feb 3, 2001 · N2685H · Substantial damageNTSB IAD01LA031Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Napoleon, OHThe fatigue failure in the fillet radius of the mast, which resulted in the separation of the main rotor system.Feb 3, 2001 · N98PM · Substantial damageNTSB ATL01LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Concord, NCThe pilots failure to follow the auxiliary fuel tank procedures, which resulted in the fuel starvation and the loss of engine power.Feb 1, 2001 · N60336 · Substantial damageNTSB CHI01LA076Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fulton, MOthe pilot not maintaining altitude/clearance from the power line during the circling approach. Factors were the power transmission wire, the plowed field, and that the pilot's lookout was not possible through the built up ice on the windshield.Jan 31, 2001 · N6754Y · Substantial damageNTSB NYC01FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Edgartown, MAThe pilot's failure to maintain a stabilized approach with an adequate vertical and lateral track. Also causal was his failure to maintain obstacle clearance.Jan 30, 2001 · N6837Y · DestroyedNTSB NYC01FA071Accident · 1 fatalField investigationFinal reportSchempp-Hirth Discus CS · Wurtsboro, NYThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin while on base leg.Jan 28, 2001 · N814CU · Substantial damageNTSB CHI01LA075Accident · Serious injuriesLimited investigationFinal reportEnstrom 480 · Dryden, MIThe pilots failure to maintain altitude/clearance from the terrain. The dark night was a factor.Jan 25, 2001 · N704G · Substantial damageNTSB CHI01IA073Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Grand Rapids, MIThe uncommanded deployment of the right flight spoiler due to the fatigue fracture of the spoiler lug.Jan 25, 2001 · N785CA · Minor damageNTSB LAX01LA080Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Douglas, AZThe student's failure to maintain control of the airplane during the go-around and his premature retraction of the landing gear. A factor was the flight instructor's inadequate supervision of the flight.Jan 23, 2001 · N5487T · Substantial damageNTSB CHI01LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culver, INthe proper glide path not attained by both pilots during a short field landing. The snow bank was a contributing factor.Jan 21, 2001 · N4378Q · Substantial damageNTSB IAD01LA028Accident · No injuriesLimited investigationFinal reportPiper 34-200T · Bluefield, WVThe pilot's failure to enter the correct altimeter setting, which resulted in continued flight below the decision height and a subsequent collision with trees.Jan 20, 2001 · N99ED · Substantial damageNTSB ATL01LA023Accident · Serious injuriesLimited investigationFinal reportCessna 172SP · Austell, GAThe pilots failure to follow instrument flight procedures and descended below the published the minimum descent altitude and subsequently collided with trees short of the runway.Jan 19, 2001 · N43PD · DestroyedNTSB SEA01IA039Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Seattle, WAA malfunctioning relay in the aircraft's flight management system (FMS) switching matrix and associated false "on course" indication on the captain's course deviation indicator (CDI), resulting in proper localizer course alignment not being obtained or…Jan 16, 2001 · N8084U · No damageNTSB FTW01LA050Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Burnet, TXthe pilot's failure to maintain proper glide path during a practice instrument approach, which resulted in an in-flight collision with terrain. Contributory factors to the accident were the dark night light condition and the safety pilot's inadequate…Jan 15, 2001 · N1736M · DestroyedNTSB MIA01FA060Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Bethel, NCthe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an in-flight collision with power lines and the subsequent impact with terrain. A factor in this accident was: the pilot's lack of recent instrument…Jan 14, 2001 · N3996T · DestroyedNTSB NYC01LA065Accident · No injuriesLimited investigationFinal reportCessna 182P · Angola, NYThe pilot's misjudged clearance over an obstacle.Jan 12, 2001 · N52359 · DestroyedNTSB FTW01LA049Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Fort Worth, TXthe loss of power to both engines for undetermined reasons during approach. Contributing factors were the pilot's failure to properly position the fuel selector in accordance with the landing checklist and the lack of suitable terrain for the forced landing.Jan 11, 2001 · N824ED · Substantial damageNTSB LAX01FA071Accident · Minor injuriesField investigationFinal reportWorldwide Aeros 40B · Oakland, CAOne or both of the rear ballonet air relief valves remained in an open position for undetermined reasons, which caused an out-of-balance trim condition; also causal was the flight crew’s decision to the fly the airship with a known deficiency (the inoperative…Jan 9, 2001 · N819AC · Substantial damageNTSB NYC01FA064Accident · 1 fatalField investigationFinal reportCessna 310R · Bluefield, WVThe pilot's failure to execute the published missed approach procedure. A factor was heavy snowfall during the approach.Jan 8, 2001 · N123RA · DestroyedNTSB FTW01IA061Incident · No injuriesIncident investigationFinal reportBell 206-L3 · Wc 368fuel exhaustion during approach due to the pilot's failure to refuel.Jan 8, 2001 · N142DP · Minor damageNTSB DEN01LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Meeker, COFuel exhaustion due to the failure of the instructor to ensure there was sufficient fuel for the flight. Factors were the instructor's inadequate supervision of the student pilot, and the deep snow-covered terrain.Jan 8, 2001 · N8067F · Substantial damage