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 CHI98LA289Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Laporte, INwas the student pilot s inadequate compensation for the wind conditions he encountered during the landing phase. A factor in this accident was the pilot s lack of total experience.Aug 2, 1998 · N8398R · Substantial damageNTSB CHI98FA288Accident · 1 fatalField investigationFinal reportHispano Aviacion A10B-37 · Oshkosh, WIthe pilot's failure to maintain adequate altitude which resulted in in-flight collision with trees and subsequent compressor stall for undetermined reasons.Aug 2, 1998 · N2741P · DestroyedNTSB LAX98LA253Accident · No injuriesLimited investigationFinal reportYakovlev YAK-55M · Lincoln, CAThe pilot of the other aircraft's inadequate visual lookoutAug 1, 1998 · N910RT · 2 aircraft · Substantial damageNTSB NYC98LA159Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1A · Point Of Woods, NYImproper maintenance which resulted in the installation of an incorrect venturi and the subsequent loss of engine power.Jul 31, 1998 · N9415L · Substantial damageNTSB FTW98FA338Accident · 3 fatalField investigationFinal reportCessna 210M · Leesville, LAThe pilot's failure to establish a climb during a night go-around. Factors were the lack of visual cues available to the pilot and the dark night illumination.Jul 31, 1998 · N732PB · DestroyedNTSB CHI98LA293Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Salina, KSinadequate maintenance which failed to detect corrosion in the fuel injector system and the fuel pump. Factors related to the accident were the low altitude and airspeed at which the loss of engine power occurred.Jul 31, 1998 · N101KT · Substantial damageNTSB CHI98LA292Accident · No injuriesLimited investigationFinal reportBell M74L · Grand Forks, NDThe worn rotor clutch shoes, and subsequent loss of main rotor rpm.Jul 31, 1998 · N1001N · Substantial damageNTSB NYC98LA154Accident · No injuriesLimited investigationFinal reportJohnson Revolution MINI-500 · Shermans Dale, PAThe builder/pilot's carburetor modification that did not allow for rapid fuel demand, which resulted in a loss of engine power of final approach.Jul 26, 1998 · N805JJ · Substantial damageNTSB LAX98LA245Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Torrance, CAThe failure of the pilot to maintain an adequate airspeed margin during the go-around attempt, which resulted in a stall/mush.Jul 26, 1998 · N74637 · DestroyedNTSB FTW98LA329Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Rockwall, TXThe pilot's improper use of the fuel tank selector resulting in the loss of engine power due to fuel starvation. A factor was the pilot's failure to follow the check list.Jul 25, 1998 · N30117 · Substantial damageNTSB FTW98FA333Accident · 4 fatalField investigationFinal reportCessna 182P · Jal, NMThe pilot's failure to maintain adequate airspeed. Contributing factors were high density altitude and excessive airplane weight.Jul 25, 1998 · N58870 · DestroyedNTSB LAX98LA243Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Temecula, CAA partial loss of engine power due to a disconnected throttle linkage, which was the result of an inadequate maintenance installation/inspection.Jul 24, 1998 · N2720V · DestroyedNTSB LAX98LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Baker, CAA loss of engine power for undetermined reasons.Jul 23, 1998 · N222LC · Substantial damageNTSB FTW98LA321Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Bridgeport, TXThe flight instructor's delay in recognizing and responding to the loss of right engine power which resulted in the airplane landing short of the runway. A factor was the loss of right engine power for undetermined reasons.Jul 21, 1998 · N3154P · Substantial damageNTSB CHI98LA265Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Ironwood, MIthe pilot's not compensating for wind conditions and his allowing an inadvertent stall. A factor was wind gusts.Jul 21, 1998 · N50930 · Substantial damageNTSB FTW98LA320Accident · Minor injuriesLimited investigationFinal reportNavion G · Telluride, COPilot operating the aircraft with an overly lean mixture. A factor was unsuitable terrain for a forced landing.Jul 19, 1998 · N2498T · Substantial damageNTSB FTW98LA323Accident · Serious injuriesLimited investigationFinal reportSchweizer SGU 2-22E · Canon City, COThe pilot's misjudgment of distance/altitude and his premature deployment of the spoilers, resulting in a undershoot and hard landing.Jul 17, 1998 · N9920J · Substantial damageNTSB FTW98LA313Accident · Serious injuriesLimited investigationFinal reportShoemaker S-12 Aeraile · Marion, ARThe non-certificated pilot's failure to maintain minimum required airspeed resulting in an inadvertent stall. A factor was the pilot's lack of total flight experience.Jul 17, 1998 · N82584 · Substantial damageNTSB CHI98LA258Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Springfield, MOthe pilot in command's inadequate preflight planning/preparation and inaccurate fuel consumption calculations that caused the aircraft's fuel supply to be exceeded. Factors to the accident were the dark light condition and the rough/uneven terrain condition.Jul 17, 1998 · N2953Y · Substantial damageNTSB FTW98LA312Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COThe pilot misjudged his altitude. Contributing to the accident were unfavorable wind and dark night conditions.Jul 16, 1998 · N444BP · Substantial damageNTSB LAX98LA232Accident · No injuriesLimited investigationFinal reportBeech A36TC · Boulder City, NVloss of engine power for undetermined reasons over unsuitable terrain.Jul 14, 1998 · N999AJ · DestroyedNTSB SEA98LA130Accident · No injuriesLimited investigationFinal reportPerson Vari EZE · Arlington, WAA lack of adequate carburetor heat available and overload of the main landing gear. Contributing factors were carburetor icing conditions and soft terrain.Jul 11, 1998 · N29NS · Substantial damageNTSB NYC98LA142Accident · No injuriesLimited investigationFinal reportCessna 180 · Wadsworth, OHA loss of engine power for undetermined reasons.Jul 10, 1998 · N180DR · Substantial damageNTSB ANC98LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's failure to maintain the proper glide path to the intended landing area and his failure to maintain flying airspeed resulting in a stall.Jul 10, 1998 · N1364P · Substantial damageNTSB ANC98FA091Accident · 2 fatalField investigationFinal reportSwearingen SA-26AT · St. George, AKThe pilot-in-command's failure to adequately monitor the instrument approach and the co-pilot's failure to intercept and maintain the proper NDB bearing on the approach. Contributing factors were the pilot-in-command's obstructed view of the NDB indicator and…Jul 7, 1998 · N501FS · DestroyedNTSB SEA98LA123Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Arlington, WAThe pilot's inadequate compensation for the wind conditions. Gusting winds were a factor.Jul 6, 1998 · N91380 · Substantial damageNTSB CHI98LA236Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Langdon, NDthe total loss of engine power for reasons undetermined. A factor was rough and uneven terrain.Jul 3, 1998 · N7301Y · Substantial damageNTSB ATL98LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Jacksonville, FLThe pilot's failure to manage his fuel properly leading to fuel starvation, a loss of engine power, and the collision with trees and the ground. A factor was his lack of total experience.Jul 2, 1998 · N9011J · Substantial damageNTSB ANC98LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Soldotna, AKThe pilot's inadvertent stall of the airplane.Jul 1, 1998 · N2163A · Substantial damageNTSB CHI98LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Flushing, MIwas a delayed go-around maneuver by the pilot. Factors associated with this accident were the pilot misjudging his final approach altitude and glide path, having inadequate altitude to clear the trees at the end of the runway, and inadequate training on how…Jun 29, 1998 · N20043 · Substantial damageNTSB NYC98LA135Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · West Buxton, MEfailure of the pilot to see-and-avoid power lines (inadequate visual lookout), as he was approaching to make a water landing on a river.Jun 28, 1998 · N47893 · Substantial damageNTSB FTW98FA287Accident · 1 fatalField investigationFinal reportCessna 175 · Clovis, NMThe pilot's failure to maintain adequate obstacle clearance and the proper landing glide path. Also causal was his loss of aircraft control during an attempted go-around. Factors were the dark night light conditions, the pilot's recent lack of sleep, and the…Jun 28, 1998 · N7366M · DestroyedNTSB LAX98FA210Accident · 1 fatalField investigationFinal reportCessna 152 · Santa Ana, CAThe failure of the pilot-in-command to identify a proper touchdown point on the runway and maintain an appropriate glidepath so as to remain clear of vortex turbulence from the preceding large aircraft. A factor in the accident was the pilot's failure to…Jun 24, 1998 · N67421 · DestroyedNTSB IAD98FA070Accident · 1 fatalField investigationFinal reportCessna 172N · Ocean City, MDThe pilot's failure to maintain control of the aircraft due to spatial disorientation. Contributing factors wer fog, dark night conditions, lack of recent experience, inadequate preflight planning, and flight into known adverse weather.Jun 22, 1998 · N5944E · DestroyedNTSB LAX98LA209Accident · Serious injuriesLimited investigationFinal reportGlaser-Dirks DG-800B · Jean, NVThe disconnection of the elevator control attachment nut due to improper installation by the manufacturer, which resulted in the pilot's loss of control.Jun 21, 1998 · N98NL · Substantial damageNTSB LAX98LA229Accident · No injuriesLimited investigationFinal reportCessna 310K · Calexico, CAThe pilot's continued operation of the aircraft with known deficiencies in the landing gear indicating system. A contributing factor to the accident was the pilot's expectation that the gear would be extended and locked irrespective of the indicator lights…Jun 19, 1998 · N6994L · Substantial damageNTSB CHI98LA209Accident · 1 fatalLimited investigationFinal reportTillman Christen II · Howell, MIthe pilot not maintaining aircraft control during the go-around maneuver. A factor in this accident was the pilot s lack of recent experience in the accident airplane.Jun 19, 1998 · N124ET · DestroyedNTSB NYC98FA129Accident · 1 fatalField investigationFinal reportHawker Hunter T MK 8 · Manchester, NHFuel exhaustion, resulting from the pilot's reliance on an inaccurate fuel quantity indicating system. A factor in the pilot's death was his intentional delay of the ejection sequence in order to avoid people and property on the ground.Jun 18, 1998 · N745WT · DestroyedNTSB ANC98LA104Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKAn in-flight collision with a large bird.Jun 18, 1998 · N2162C · Substantial damageNTSB SEA98FA100Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Helena, MTThe pilot's failure to maintain the correct altitude while turning inbound during a procedure turn to the ILS final approach course. Factors include hilly/mountainous terrain and clouds in the area where the course reversal was performed.Jun 17, 1998 · N446JR · DestroyedNTSB LAX98LA198Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Riverbank, CAThe pilot's inadequate visual lookout for on-coming ground traffic.Jun 14, 1998 · N48576 · Substantial damageNTSB LAX98LA197Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Shafter, CAThe aircraft's encounter with settling with power, which resulted from the pilot's decision to perform a steep downwind approach.Jun 14, 1998 · N110DT · Substantial damageNTSB LAX98LA196Accident · Minor injuriesLimited investigationFinal reportBeech 76 · San Martin, CAFailure of the instructor to adequately supervise the flight, which included ensuring that the student maintained the proper airspeed during the attempted go-around.Jun 14, 1998 · N912KA · Substantial damageNTSB ATL98LA083Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Destin, FLThe pilot's failure to maintain directional control and her failure to maintain adequate obstacle clearance during an attempted go-around. A factor was the pilot's inadequate compensation for the crosswind conditions.Jun 13, 1998 · N55369 · Substantial damageNTSB SEA98LA093Accident · 1 fatalLimited investigationFinal reportCessna 150 · Amboy, WAThe pilot's failure to maintain adequate altitude and/or clearance from terrain during a go-around attempt. Factors included a short landing area and trees in the landing area.Jun 10, 1998 · N7759E · Substantial damageNTSB SEA98FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Hillsboro, ORImproper installation (bushing), mechanical binding (bushing), mechanical binding (connecting rod), and fatigue within the crankshaft. Contributing factors were inadequate major (engine) overhaul and trees.Jun 9, 1998 · N199JM · DestroyedNTSB ANC98LA067Accident · No injuriesLimited investigationFinal reportCessna 185 · Chickaloon, AKThe pilot's inadvertent activation of the fuel boost pump selector switch during final approach, which resulted in an overly rich mixture and subsequent loss of engine power.Jun 9, 1998 · N9855X · Substantial damageNTSB MIA98LA180Accident · No injuriesLimited investigationFinal reportRobert E. Bean Wittman Tailwind W10 · Daytona Beach, FLThe pilot's poorly planned approach for not planning the intended touchdown point farther down the runway to avoid an area of known turbulence caused by terrain. Contributing to the accident was the turbulence.Jun 8, 1998 · N173RS · Substantial damageNTSB FTW98LA260Accident · No injuriesLimited investigationFinal reportBell 206B · Corpus Christi, TXThe failure of the tail rotor drive shaft due to the separation of a bolt at one of the drive shaft disc couplings for an undetermined reason, which resulted in the pilot's inability to maintain directional control during landing.Jun 7, 1998 · N16814 · Substantial damageNTSB FTW98LA257Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Hondo, TXThe inadvertent stall due to the pilot's failure to maintain control of the airplane. Factors were the high winds and the wind induced turbulence.Jun 6, 1998 · N1765S · Destroyed