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 ATL89FA035Accident · 2 fatalField investigationFinal reportHughes 269C · Mohawk, TNThe helicopter had landed at a private airstrip and the instructor deplaned. The dual student remained in the helicopter with the engine running. The CFI reboarded and the student made the takeoff. Later, on downwind in traffic pattern, a witness reported a…Nov 14, 1988 · N9575F · DestroyedNTSB NYC89LA027Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Montauk, NYLoss of control, inflight, while landing, due to low level wind shear.Nov 13, 1988 · N722BH · Substantial damageNTSB ATL89LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lumberton, NCThe pilot had been flying about 45 minutes when he crashed short of the runway. He believed he departed with 16 gallons of fuel, based on fuel gauge readings. The wreckage examination failed to disclose any system problems. After the accident, only a small…Nov 13, 1988 · N993NA · Substantial damageNTSB SEA89LA018Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Port Gamble, WAForeign national pilot was obtaining helicopter instruction. On solo flt to practice lndgs in unimproved terrain, touched down on stump with one skid and rolled over. Plt cited temporary pwr loss during approach. Investigation found no engine malfunction.Nov 12, 1988 · N2460P · Substantial damageNTSB MIA89LA026Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Clearwater, FLAs the student plt was making a simulated single eng apch, the instructor's attention was momentarily diverted inside the cockpit. When the instructor looked outside again, the acft was low & slow on a short final apch. The CFI applied power to arrest the…Nov 11, 1988 · N81609 · Substantial damageNTSB FTW89LA020Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Powderly, TXThe pilot was receiving his biennial flight review and was on approach to the airport when he heard a loud snap and lost elevator control. He was able to put the airplane down on the runway, but could not get the tail down. When he applied the brakes, the…Nov 11, 1988 · N8394K · Substantial damageNTSB BFO89LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, VAThe student & instructor (CFI) made a normal apch at 60 KIAS with 30 degs of flaps. When aprx 100 to 200 ft AGL, the acft began to descend below the desired glidepath. The student added power and increased pitch attitude. The acft continued to descend and the…Nov 8, 1988 · N93031 · Substantial damageNTSB ATL89LA027Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Greensboro, NCPIC was attempting to land at unfamiliar airport with narrow rwy, 25 feet wide, bounded by trees. He did not determine wind other than its general direction. Crosswind was four knots. On short final, after crossing over trees that were approach obstacles,…Nov 7, 1988 · N2358X · Substantial damageNTSB LAX89LA038Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Vacaville, CADuring final approach, the glider collided with a fence. A witness stated that, 'the pilot simply let the glider get too low and too slow and hit a fence.' There were no mechanical problems reported prior to the accident. The pilot did not file an acdt report.Nov 6, 1988 · N129KS · Substantial damageNTSB FTW89IA016Incident · No injuriesIncident investigationFinal reportBoeing 727 · Houston, TXPoor planning/decision by the unidentified Cessna pilot by maneuvering in busy airspace near the arsa with no ATC coordination or transponder signal; no traffic advisory being issued by the approach controller; and inadequate visual lookout by the flight crew…Nov 6, 1988 · N386PA · No damageNTSB FTW89LA014Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Winnsboro, TXThe student plt checked the wx for his solo x/c and was advised of strong winds and moderate turbulence. The supervising flight instructor was aware of the wx report and allowed the student to depart, although all later x/c flights were cancelled due to the…Nov 5, 1988 · N69008 · Substantial damageNTSB ATL89FA025Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Mc Donough, GAShortly after takeoff the flight experienced a complete engine failure. The pilot attempted a forced landing to an open field but crashed short. The investigation disclosed that the pilot was not certificated as an airman and he did not have the permission of…Nov 5, 1988 · N2407L · Substantial damageNTSB MKC89LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Linn, MOWhile attempting to land crosswind on a 900 foot long dirt runway, the pilot decided he was too high and had excessive airspeed. He attempted to make a go around. However, he was unable to clear a dirt embankment and struck the nose wheel. Unaware of the…Nov 3, 1988 · N6287E · Substantial damageNTSB FTW89FA012Accident · 1 fatalField investigationFinal reportPiper 601B · Houston, TXPilot's decision to fly the approach visually with outside reference to the lights and inadvertently descending below the decision height off the proper glide path.Nov 2, 1988 · N60819 · DestroyedNTSB ATL89MA023Accident · 1 fatalMajor investigationFinal reportCessna 210D · Nashville, TNDrg west arr at ngt, plt was vctrd for a VFR, straight-in apch to rwy 2R & adzd of Boeing 727 off his rgt front, passingfm rgt to left. He was cautioned abt wake turbc (w/t) & replied, 'okay I see him.' Ctlr then told plt to turn inbnd & maint 'visual' with…Nov 2, 1988 · N3822Y · DestroyedNTSB FTW89IA011Incident · No injuriesIncident investigationFinal reportBell 206 L-1 · Brownsville, TXUncontained engine failure due to the thermal fatigue of the first stage trubine wheel.Oct 30, 1988 · N2092U · Minor damageNTSB BFO89FA004Accident · 3 fatalField investigationFinal reportPiper PA-34-200 · Ocean City, MDThe pilot failed to maintain adequate clearance above the terrain. Contributing factors are inattention to altitude and dark night conditions over illusionary producing featureless water.Oct 29, 1988 · N666RW · DestroyedNTSB ATL89FA019Accident · Serious injuriesField investigationFinal reportAeronca 7AC · Austell, GAPIC was obtaining bfr; stalls & flt at min control airspeed were completed. PIC began descent from 2500 MSL to his pvt strip for simulated engine out landing. In a subsequent interview PIC said carb heat was applied & removed after 30 sec. In his rpt he said…Oct 29, 1988 · N83045 · Substantial damageNTSB LAX89FA025Accident · 2 fatalField investigationFinal reportPiper PA31P-350 · Redlands, CAThe pilot's inadvertent selection of an inappropriate altitude for the attempted night special VFR circle to land maneuver. Contributing to the accident was the dark night, restricted visibilities and lack of ground reference lights. Also contributing to the…Oct 27, 1988 · N79HW · DestroyedNTSB CHI89LA016Accident · No injuriesLimited investigationFinal reportBeech F35 · Milwaukee, WIWhile executing a VOR approach and circling to land, the aircraft collided with trees and a fence, then impacted on a roadway short of the runway. The pilot had obtained a full weather briefing prior to his departure. The weather briefing included SIGMET golf…Oct 23, 1988 · N104TG · Substantial damageNTSB ATL89LA016Accident · No injuriesLimited investigationFinal reportSchempp-Hirth DISCUS-B · Whitwell, TNThe plt rprtd that thermal lift deteriorated drg the return leg of a x-country flt & he elected to make an off aprt lndg in a hay field. As he was on final apch on a westerly hdg, he saw a previously undetected power line across the field, which reqd a rapid…Oct 22, 1988 · N321SB · Substantial damageNTSB NYC89LA016Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Easton, PALanding short of the runway due to a power loss of unknown reason(s).Oct 21, 1988 · N56813 · Substantial damageNTSB MKC89LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Andover, KSWhile turning base to final for landing on a private grass strip, after a personal cross country flight, the aircraft stalled and fell uncontrolled to the terrain. A post accident investigation failed to reveal any malfunction of the control systems or…Oct 21, 1988 · N8641N · Substantial damageNTSB MKC89FA007Accident · 2 fatalField investigationFinal reportCessna T210F · Rogers, ARContinued flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain aircraft control after becoming disoriented. Contributing factors were: dark night, low ceilings, fog, drizzle, obscuration, and failure of the pilot to…Oct 21, 1988 · N6191R · DestroyedNTSB BFO89FA003Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Frederick, MDNonsubmittedOct 21, 1988 · N8291Z · DestroyedNTSB NYC89FA015Accident · 4 fatalField investigationFinal reportBeech A24R · Blue Bell, PAImproper VFR procedures, the pilot failed to maintian adequate airspeed for the attitude of flight of the airplane causing it to stall and collide with trees and a powerline during recovery.Oct 20, 1988 · N1RJ · DestroyedNTSB LAX89FA021Accident · 1 fatalField investigationFinal reportCessna TR-182 · Paso Robles, CAThe pilot failed to maintain the proper altitude while executing the published instrument approach procedure.Oct 19, 1988 · N739YS · DestroyedNTSB CHI89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Big Rapids, MIThe pilot stated that he failed to maintain sufficient airspeed and altitude during an IFR circle-to-land maneuver. The pilot reported that when he thought he was going to overshoot final, he tightened up the bank. The aircraft stalled and the left wing…Oct 19, 1988 · N300HF · Substantial damageNTSB NYC89LA014Accident · Serious injuriesLimited investigationFinal reportLet L13 · Warren, VTPilot's improper supervision of flight, permitted the student to not maintain the proper airspeed and stall the glider and crash into the ground.Oct 17, 1988 · CFYSR · Substantial damageNTSB NYC89LA012Accident · Serious injuriesLimited investigationFinal reportCessna P210 · Collegeville, PAThe plt rprtd that as he was arriving to land, he entered left traffic & moved the fuel selector to the fullest tank. Shortly after moving the fuel selector, the eng lost power as though it was fuel starved. He said he operated the fuel boost pump & switched…Oct 16, 1988 · N400JL · DestroyedNTSB LAX89LA019Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Tehachapi, CADuring the landing touchdown, on runway 11, a gust of wind was encountered and the airplane became airborne. The pilot attempted to go around. During the go around attempt the pilot was not able to gain control of the airplane. Winds at the time of the…Oct 15, 1988 · N44022 · Substantial damageNTSB FTW89LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Friendswood, TXThe student pilot descended from 1450 feet to 1000 feet and entered the traffic pattern. Just before turning base, he applied carburetor heat and ten seconds later the engine lost power and quit. Unsuitable terrain made the forced landing a hard landing. An…Oct 15, 1988 · N7054F · Substantial damageNTSB LAX89FA013Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Santa Maria, CAThe pilot failed to follow the correct I.f.r. procedures whereas he descended below the final approach fix altitude.Oct 12, 1988 · N6198H · DestroyedNTSB NYC89LA009Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Rutland, VTThe accident sequence was observed by two pilots who were awaiting takeoff at the approach end of the rwy in use. One of the pilots reported that the plt of the acdt acft advised him that the acdt acft had encountered ice during the flight. The acdt acft was…Oct 9, 1988 · N9431R · DestroyedNTSB MKC89FA004Accident · Serious injuriesField investigationFinal reportHughes 500C · Branson, MOThe flight was conducted for sightseeing with 5 passengers onboard. The pilot turned on final approach with 35 knots of airspeed and encountered a high rate of descent. The pilot reported that he noted a split tach and initiated an autorotation, but was…Oct 8, 1988 · N506WW · Substantial damageNTSB CHI89DET01Accident · 1 fatalFinal reportVolksplane VP-1 · Coldwater, MIA stall with entry into the incipient stage of a spin with insufficient altitude for recovery.Oct 8, 1988 · N131JT · Substantial damageNTSB LAX89FA010Accident · 1 fatalField investigationFinal reportCessna 182R · Salinas, CAThe pilot failed to follow published missed approach procedures. Factors contributing to the accident were the pilot lack of recent experience in type of operation, instrument go-around procedures, and the cloud covered mountainous terrain.Oct 7, 1988 · N1787R · DestroyedNTSB BFO89LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Sandston, VAThe plt said he was on final apch about 600 to 800 ft AGL when power loss occurred. He forced landed on an open field about 1/2 mi short of the rwy. The eng exam revealed that two teeth of the idler gear had separated. This resulted in a loss of continuity…Oct 6, 1988 · N739PE · Substantial damageNTSB ATL89FA005Accident · Serious injuriesField investigationFinal reportCessna 120 · Monroe, GAThe pilot was returning to land when he experienced a complete engine failure. The pilot reported completing a before landing check and rechecked the carburetor heat following the initial power loss. The sequence of events were typical of carburetor ice…Oct 5, 1988 · N77458 · DestroyedNTSB SEA89LA007Accident · No injuriesLimited investigationFinal reportAerospatiale SA341G · Fields, ORThe plt rprtd that as he was in a slow descending turn to the left at about 20 KTS (translational lift). The helicopter suddenly rotated to the left without warning. He estimated that this occurred at about 30 ft AGL. He applied right pedal & the rotation…Oct 4, 1988 · N401S · Substantial damageNTSB LAX89FA001Accident · 1 fatalField investigationFinal reportBeech B23 · Scottsdale, AZThe pilot's mismanagement of fuel. Contributing to the accident was the inadequate lighting of the fuel selector valve.Oct 3, 1988 · N7621R · DestroyedNTSB LAX89LA004Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Auberry, CAThe pilot was unfamiliar with the area that he was attempting to land in and circled to familiarize himself with the terrain. He then made a low pass over the dirt runway and circled to land. The first attempt was discontinued because the pilot felt that he…Oct 2, 1988 · N20680 · DestroyedNTSB LAX89LA003Accident · No injuriesLimited investigationFinal reportCessna 150F · Payson, AZThe aircraft collided with an obstacle during a go-around from the red creek private dirt strip. The plt reported that he had never landed at the 2000 ft, dirt strip and had no other short or soft field takeoff/landing practice beyond his instruction at an…Oct 2, 1988 · N8681S · DestroyedNTSB CHI89LA001Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Tell City, INThe pilot flew a VOR approach to the airport, but was too high to land on the approach runway. He executed a circling VFR pattern to land on the reciprocal runway, then flew into the ground fog in the descending base turn. The left wing struck a tree while in…Oct 2, 1988 · N8157Q · DestroyedNTSB ANC89LA001Accident · No injuriesLimited investigationFinal reportCessna 180 · Wasilla, AKDrg arrival to land on a lake at night, the plt began a 180 deg turn from a NE heading at aprx 500' AGL to a final apch on a sw heading. As the acft was in the turn, it began losing altitude rapidly. The plt applied power to stop the descent, but the acft…Oct 2, 1988 · N420SB · Substantial damageNTSB NYC89LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mayville, NYWhile on short final for landing, the flt encountered turbulence and began settling over trees located near the end of the runway. In the attempt to go around the plt allowed the acft to decelerate. The acft drifted 30 degrees right of the runway and crashed…Oct 1, 1988 · N3112Z · Substantial damageNTSB MKC88FA183Accident · 3 fatalField investigationFinal reportBeech D55 · N. Little Rock, ARThe pilot had been executing a vor/dme rwy 35 instrument approach to north Little Rock muni (1M1). The PIC called 'missed approach' a short time aft having been clrd to execute the instrument apprch. Apprch control attmptd to provide instructions to the PIC…Oct 1, 1988 · N7826R · DestroyedNTSB NYC88LA251Accident · No injuriesLimited investigationFinal reportCessna 210 · Kirkwood, NYThe plt attempted to land at a private airport at night on an unlit rwy. A go-around was initiated and during the go-around the eng lost pwr. A gear up landing was made beyond the rwy. The investigation revealed water in the fuel system. The eng was run up…Sep 30, 1988 · N7457E · Substantial damageNTSB LAX88FA330Accident · No injuriesField investigationFinal reportBell 206L-1 · Santa Barbara, CAFailure of the #1 turbine wheel. Contributing to this accident was the unreported over temperature cycles of the engine. Also contributing was the unsuitability of the landing surface from the presence of the 1/4 inch steel sheeting.Sep 29, 1988 · N2246Q · Substantial damageNTSB FTW88LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fort Worth, TXThe pvt plt (PIC) was flying with an instructor (CFI), who had an expired medical certificate. The CFI stated he was flying as a safety plt only. The PIC extended his downwind leg & subsequently was low & slow on a long final apch. He raised the nose of the…Sep 29, 1988 · N4683R · Substantial damage