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 ATL97LA144Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Belleview, FLthe pilot's improper in-flight planning/decision, and his delay in initiating a go-around, which resulted in a hard touchdown, loss of directional control, and collision with objects (fence and trees).Sep 28, 1997 · N3402Z · Substantial damageNTSB NYC97LA188Accident · No injuriesLimited investigationFinal reportJackman Pitts S-1S · Hammondsport, NYthe pilot's improper flare.Sep 27, 1997 · N4241Z · Substantial damageNTSB CHI97LA304Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Brooklyn, MIfailure of the pilot to see-and-avoid the transmission wires (inadequate visual lookout, and failing to maintain sufficient altitude and clearance from the obstruction).Sep 27, 1997 · N1269K · DestroyedNTSB ATL97LA141Accident · No injuriesLimited investigationFinal reportTomlinson Pober Super ACE · Lebanon, TNThe pilot's failure to follow normal checklist procedures that resulted in fuel starvation.Sep 27, 1997 · N54JT · Substantial damageNTSB SEA97IA217Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Soda Springs, IDThe pilot's failure to see-and-avoid the truck. Related factors included: a truck, insufficient runway obstruction information provided in the Airport/Facility Directory by the FAA, and VASI glide path angle setting (by local airport personnel) which provided…Sep 25, 1997 · CGBUA · Minor damageNTSB SEA97FA215Accident · 3 fatalField investigationFinal reportCessna 172M · Bremerton, WAThe pilot's misjudgment of distance and altitude from the runway, and his subsequent failure to maintain clearance from the terrain. Factors contributing to the accident were dark night conditions, the pilot's improper decision to conduct the flight at night,…Sep 24, 1997 · N6756H · Substantial damageNTSB NYC97LA192Accident · No injuriesLimited investigationFinal reportCessna 150G · Forest, VAthe pilot's movement of the mixture control to the idle cut-off position, during an approach to land, which resulted in a loss of engine power and a forced landing before reaching the runway.Sep 24, 1997 · N4748X · Substantial damageNTSB CHI97LA299Accident · No injuriesLimited investigationFinal reportBeech C23 · Champaign, ILan undetermined engine and/or oil system failure that resulted in an oil leak and subsequent loss of engine power. A related factor was: high vegetation (corn crop) in the emergency landing area.Sep 24, 1997 · N1851Z · Substantial damageNTSB FTW97LA355Accident · Serious injuriesLimited investigationFinal reportAmerican General AG5B · Texarkana, ARthe pilot's improper planning/decision, by failing to ensure timely refueling of the airplane, which resulted in fuel exhaustion, loss of engine power, and a forced landing.Sep 22, 1997 · N1194L · Substantial damageNTSB CHI97LA307Accident · No injuriesLimited investigationFinal reportCessna 182 · Dassel, MNthe pilot's failure to attain the proper touchdown point on the airstrip. Factors associated with the accident were the high vegetation which skewed the pilot's visual perception of threshold, and the embankment which the airplane contacted.Sep 22, 1997 · N7331Q · Substantial damageNTSB ATL97FA135Accident · 1 fatalField investigationFinal reportCessna 182G · Lexington, TNImproper planning/decision by the pilot, which led to the fuel exhaustion, loss of engine power, and a forced landing. Trees in the emergency landing area were a related factor.Sep 22, 1997 · N3725U · Substantial damageNTSB IAD97LA121Accident · Minor injuriesLimited investigationFinal reportPohlman/Pohlman Rotorway Exec 90 · Westminster, MDThe loss of power due to carburetor icing. A factor to this accident was the carburetor heat was not accessible from within the cockpit.Sep 21, 1997 · N94CJ · Substantial damageNTSB NYC97LA183Accident · No injuriesLimited investigationFinal reportCessna 402C · Nantucket, MAthe pilot's delayed decision to perform a go-around (missed approach). Related factors were: darkness, low ceiling, fog, and disorientation of the flight crew, while making the approach in conditions of limited visibility.Sep 19, 1997 · N6879Y · Substantial damageNTSB CHI97LA295Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Greenwood, INthe student pilot's failure to maintain adequate airspeed during the go-around, which resulted in an inadvertant stall. A factor related to the accident was the raising of flaps.Sep 17, 1997 · N43DR · Substantial damageNTSB ANC97LA160Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Gulkana, AKThe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control after touchdown. A factor associated with the accident was the gusty wind conditions.Sep 14, 1997 · N4116D · Substantial damageNTSB FTW97LA346Accident · 1 fatalLimited investigationFinal reportReilly Thorp T-18 · Wagoner, OKthe pilot's failure to maintain airspeed.Sep 13, 1997 · N16LE · DestroyedNTSB LAX97LA324Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-180 · Reno, NVThe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in an inadvertent stall/mush. Factors in the accident were: the pilot's lack of qualification in the aircraft; the FAA pilot certification system's failure to transfer the…Sep 12, 1997 · N69645 · Substantial damageNTSB LAX97LA322Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Hilo, HIfailure of the pilot to verify the quantity of fuel before departure, and to monitor fuel consumption during the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Tall grass in the emergency landing was a related factor.Sep 12, 1997 · N18503 · Substantial damageNTSB SEA97LA211Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mackay, IDThe pilot misjudged the distance/altitude while on final approach.Sep 9, 1997 · N91019 · Substantial damageNTSB LAX97LA320Accident · Minor injuriesLimited investigationFinal reportBell 206B · Minden, NVA hard landing due to the failure of the pilot to adequately compensate for the wind direction and velocity on initiating his approach to the landing area, resulting in a loss of tail rotor authority.Sep 9, 1997 · N90115 · Substantial damageNTSB LAX97LA318Accident · No injuriesLimited investigationFinal reportBeech A23A · Tucson, AZthe student pilot's improper recovery from a bounced landing, and failure to maintain adequate airspeed during an attempted go-around, which resulted in a stall and impact with the terrain (runway).Sep 8, 1997 · N2339W · DestroyedNTSB MIA97LA241Accident · No injuriesLimited investigationFinal reportCessna 182B · Paris, TNTemporary loss of engine power for undetermined reasons res ulting in a forced landing on unsuitable terrain.Sep 7, 1997 · N2794G · Substantial damageNTSB MIA97LA240Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Concord, NCThe failure of the pilot to latch the canopy closed prior to takeoff. This resulted in the canopying opening while on approach to land and the pilot was unable to maintain altitude due to the excessive drag.Sep 7, 1997 · N560SS · Substantial damageNTSB FTW97LA359Accident · No injuriesLimited investigationFinal reportShutt Marquart MA-5 · Pecos, TXThe pilot's inadequate compensation for the crosswind during a forced landing following a loss of engine power due to fuel exhaustion for an undetermined reason. Factors were the gusty winds and rough/uneven terrain.Sep 7, 1997 · N82ND · Substantial damageNTSB NYC97LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Chester, PAthe pilot's misjudgment of altitude and distance to the runway, which resulted in an undershoot and failure to reach the proper touchdown point. Rising terrain at the approach end of the runway was a related factor.Sep 6, 1997 · N4982S · Substantial damageNTSB ATL97LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Kenly, NCThe pilot's failure to see and avoid a utility line on final approach to land. The sunglare and utility line were factors.Sep 6, 1997 · N6898F · Substantial damageNTSB LAX97LA310Accident · No injuriesLimited investigationFinal reportBingelis Falco F.8L · Watsonville, CAthe pilot's misjudgment of distance and speed on final approach, leading to a landing undershoot.Sep 4, 1997 · N84TX · Substantial damageNTSB LAX97LA308Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Gerlach, NVThe pilot's failure to maintain an adequate airspeed while attempting a right slip, which resulted in an inadvertent stall.Aug 31, 1997 · N4459P · Substantial damageNTSB IAD97LA116Accident · Minor injuriesLimited investigationFinal reportBeech Musketeer 23 · Wauseon, OHThe pilot's fuel mismanagement by his failure to switch fuel tank positions, which resulted in the fuel starvation and the loss of engine power.Aug 31, 1997 · N2372L · Substantial damageNTSB CHI97LA277Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAinadequate supervision by the designated examiner by failing to ensure a timely autorotation recovery was initiated. A related factor was: the student pilot allowed the rotor rpm to diminish after the examiner simulated a loss of engine power.Aug 31, 1997 · N7058T · DestroyedNTSB CHI97LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Romeo, MIthe pilot's improper use of carburetor heat, which resulted in carburetor ice and loss of engine power. Factors relating to the accident were: carburetor icing conditions, and the crop (corn) in the emergency landing area.Aug 31, 1997 · N60200 · Substantial damageNTSB ATL97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Lawrenceville, GAThe student pilot's improper go-around technique that resulted in an inadvertent stall. A factor was a premature flare for landing.Aug 31, 1997 · N9625V · Substantial damageNTSB NYC97FA173Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Hancock, MAThe pilot's failure to maintain adequate terrain clearance and the proper altitude. Contributing was mountainous terrain.Aug 29, 1997 · N40AB · DestroyedNTSB LAX97LA298Accident · No injuriesLimited investigationFinal reportBeech H35 · Vacaville, CAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was inoperative fuel gauges.Aug 22, 1997 · N4689D · Substantial damageNTSB CHI97LA271Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Zionsville, INfailure of the pilot to maintain adequate airspeed, which resulted in a stall and subsequent spin. A factor associated with the accident was the pilot's lack of experience in this make and model of glider.Aug 22, 1997 · N600JP · DestroyedNTSB CHI97LA266Accident · Minor injuriesLimited investigationFinal reportSwearingen SA226TC · Des Moines, IAthe pilot's improper in-flight planning/decision and failure to perform the emergency procedure for shut-down of the right engine. Factors relating to the accident were: the power lever cable became disconnected from the fuel control unit, due to improper…Aug 20, 1997 · N224AM · Substantial damageNTSB CHI97LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glenwood, MNfailure of the student pilot to maintain the correct airspeed for a go-around maneuver, which resulted in a stall/mush and collision with terrain.Aug 17, 1997 · N23236 · Substantial damageNTSB NYC97LA165Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Lexington, KYThe pilot misjudged distance and altitude to the runway after transition from an instrument approach to a visual approach. Factors related to the accident were the rain, and uphill runway conditions at a dark night.Aug 14, 1997 · N227R · Substantial damageNTSB MIA97FA232Accident · 1 fatalField investigationFinal reportBeech 200 · Dalton, GAthe pilot's improper IFR procedure, by failing to maintain the minimum descent altitude (MDA) during the ILS localizer approach, until the runway environment was in sight, which resulted in a collision with terrain short of the runway. Factors relating to the…Aug 14, 1997 · N74EJ · Substantial damageNTSB LAX97LA283Accident · Serious injuriesLimited investigationFinal reportCessna 195 · Santa Ana, CAWater contamination in the fuel system due to the failure of the mechanic who performed the last annual inspection to adequately comply with the AD which required inspection of the fuel tank filler area for proper sealing, and the pilot's inadequate preflight…Aug 11, 1997 · N9328A · Substantial damageNTSB ATL97LA122Accident · Minor injuriesLimited investigationFinal reportZenair 701 · Spruce Creek, FLThe failure of the engine for undetermined reasons, while maneuvering close to the ground. Factors included the soft terrain and the conditions favorable for carburetor icing.Aug 11, 1997 · N105RC · Substantial damageNTSB SEA97LA184Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Bountiful, UTThe pilot's inadequate fuel management which resulted in fuel starvation.Aug 10, 1997 · N9666M · Substantial damageNTSB NYC97LA162Accident · Minor injuriesLimited investigationFinal reportSimpson Avid Flyer · Westerly, RIThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.Aug 10, 1997 · N7156X · Substantial damageNTSB FTW97LA303Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Los Alamos, NMThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Aug 10, 1997 · N22286 · Substantial damageNTSB ATL97LA119Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe loss of control of the airplane due to the pilot's improperly planned approach and failure to maintain adequate airspeed.Aug 8, 1997 · N757WL · Substantial damageNTSB ATL97LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Rockhill, SCThe pilot's failure to plan and have adequate fuel for the flight.Aug 8, 1997 · N66098 · Substantial damageNTSB ATL97FA113Accident · Serious injuriesField investigationFinal reportPilatus BN-2 Islander · Fajardo, PRThe pilot's failure to maintain adequate visual lookout.Aug 7, 1997 · N26JA · 2 aircraft · Substantial damageNTSB DCA97MA058Accident · 228 fatalClass 1 · MajorFinal reportBoeing 747-300 · Nimitz Hillthe captain's failure to adequately brief and execute the nonprecision approach and the first officer's and flight engineer's failure to effectively monitor and cross-check the captain's execution of the approach. Contributing to these failures were the…Aug 6, 1997 · H7468 · DestroyedNTSB MIA97LA227Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Tullahoma, TNthe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation, a forced landing, and impact with a tree.Aug 5, 1997 · N9236Q · Substantial damageNTSB LAX97FA272Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Hesperia, CAfailure of the pilot to see-and-avoid high voltage power lines, while coping with a lack of engine power during a go-around in a high density altitude condition. Factors relating to the accident were: high density altitude that resulted in a normal reduction…Aug 5, 1997 · N8227Q · Destroyed