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 CHI88DEX04Accident · No injuriesFinal reportCessna 172M · Alexandria, INAircraft experienced intermittent engine operation while on final, followed by complete engine failure on landing rollout. Pilot noticed smoke entering cockpit during restart attempt. Aircraft was evacuated by pilot and three passengers. There was an engine…Apr 25, 1988 · N80269 · Substantial damageNTSB ATL88LA151Accident · Serious injuriesLimited investigationFinal reportCirrus Design Standard · Chester, SCThe glider pilot failed to maintain sufficient altitude while on final approach for landing and struck trees.Apr 22, 1988 · N3LB · Substantial damageNTSB ATL88FA150Accident · Minor injuriesField investigationFinal reportCessna 152 · Moncks Corner, SCApr 22, 1988 · N94251 · Substantial damageNTSB MIA88LA157Accident · No injuriesLimited investigationFinal reportCessna 150J · Deland, FLAfter landing at umatilla, muni, an unattended arpt, the plt asked an unauthorized individual to fill the acft's tanks. The individual stated that fuel is not sold to transient acft. The plt departed with the fuel tank gauges indicating 1/4 each. When it was…Apr 20, 1988 · N60358 · Substantial damageNTSB LAX88LA167Accident · No injuriesLimited investigationFinal reportCessna 182D · Coolidge, AZAt the end of a pleasure cross country flight, while on final approach, the engine quit. Unable to land on the runway, the aircraft was landed in a soft field where during the landing roll the aircraft nosed over. The pilot had selected the right fuel tank…Apr 20, 1988 · N8847X · Substantial damageNTSB CHI88DEC01Accident · Minor injuriesFinal reportBeech 23 · Brighton, MIThe unsuitable terrain (trees and a lake) encountered during a forced landing made necessary by the partial failure of the aircraft's powerplant during and attempted go-around. The occupants were able to exit the aircraft before it sank; the aircraft was…Apr 18, 1988 · N2326L · Substantial damageNTSB CHI88LA098Accident · No injuriesLimited investigationFinal reportCessna 150K · Pinconning, MIThe airplane collided with a hangar and a tree during an attempted go-around at gross airport. The pilot stated that he flared too high and failed to correct the left yaw when he added power. The resultant flight path was directly into trees which he felt he…Apr 17, 1988 · N6126G · Substantial damageNTSB ATL88IA147Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200 · Cleveland, OHApr 17, 1988 · N433PE · Minor damageNTSB SEA88FA078Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Port Angeles, WADrg arr, the flt was handed off to whidbey island apch ctl at whidbey island (nuw) naval air stn (nas). Nuw was 35 mi NE of the destn (fairchild intl arpt/clm), at Port Angeles, which had no operg ctl twr. The plt was given the nuw wx, which was 400 scat,…Apr 16, 1988 · N36815 · DestroyedNTSB LAX88FA161Accident · 4 fatalField investigationFinal reportCessna 172G · Los Banos, CAFailure of the pilot to maintain control of his aircraft to avert a collision with the ground.Apr 16, 1988 · N4493L · DestroyedNTSB SEA88LA077Accident · No injuriesLimited investigationFinal reportBeech K-35 · Pullman, WAWhile on final for the runway the pilot advanced the throttle and the engine lost power. The aircraft was landed short of the runway onto a field, where the nose gear collapsed during the landing roll. Mechanics who examined the aircraft after the accident…Apr 14, 1988 · N40NL · Substantial damageNTSB MIA88FA144Accident · Serious injuriesField investigationFinal reportBeech A-23 · Fort Myers, FLThe private pilot experienced an engine failure on final approach and executed a forced landing to a wooded area and crashed. The pilot said he had flown about 2.0 hours on the right tank and did not switch to the left tank prior to landing. Another pilot had…Apr 13, 1988 · N8856M · Substantial damageNTSB LAX88LA158Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Temecula, CAWhile on final approach, the pilot encountered crosswind conditions and was unable to maintain the runway centerline. The pilot advanced the throttle and remembered hearing the stall horn. The aircraft cleared a building by 10 feet off the side of the runway…Apr 12, 1988 · N5518H · Substantial damageNTSB DEN88LA094Accident · No injuriesLimited investigationFinal reportAgusta A109A · Sioux Falls, SDApr 9, 1988 · N33SV · Substantial damageNTSB DEN88FA093Accident · 2 fatalField investigationFinal reportCessna 310I · Helena, MTThe acft depd glasgow, Montana, where the passenger (secretary of state for Montana) had been campaigning. Initially, a VFR flt plan had been filed; however, drg arrival at Helena, an IFR flt plan was filed when the plt realized the wx had deteriorated. The…Apr 9, 1988 · N8008M · DestroyedNTSB NYC88LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-325 · West Seneca, NYLoss of power due to fuel starvation. Contributing factor was adversed weather conditions.Apr 8, 1988 · N59845 · DestroyedNTSB BFO88FA034Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Manassas, VAThe pilot had departed waycross, GA, on the morning of the accident for a cross country flight to Manassas, VA. During the approach into Manassas, the aircraft contacted trees off the approach ends of rwys 34L and 34R. Both rwys were in use at the time and it…Apr 6, 1988 · N1719J · DestroyedNTSB DEN88LA092Accident · No injuriesLimited investigationFinal reportCessna 210L · Cheyenne, WYThe CFI was giving a checkout to the private pilot doctor. The CFI flight records showed only one hour in this make/model. The fuel selector was in the right tank position throughout the flight. The pilot reported that the engine quit on one mile short final…Apr 5, 1988 · N910DS · Substantial damageNTSB FTW88LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Leona, TXThe plt planned his apch to land about 1000 ft down the 3400 ft dirt rwy because the first 1000 ft was wet and soft. The last 400 ft was also wet and soft. The wind was calm and the apch speed was high. During the flare, the acft ballooned and floated past…Apr 3, 1988 · N8775U · Substantial damageNTSB LAX88LA151Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Palo Alto, CADuring a local flight in the pattern, the engine experienced a loss of power and a forced landing was made short of the runway. Inspection of the engine revealed that water was in the fuel pump bowl and rust was present on the cylinders.Apr 2, 1988 · N99373 · Substantial damageNTSB CHI88FA090Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Quincy, ILDescent below the dh by the pilot in command during an instrument approach into known adverse weather rather then proceeding to a suitable alternate destination.Apr 2, 1988 · N32076 · DestroyedNTSB MKC88FA072Accident · 1 fatalField investigationFinal reportBeech H18 · Kansas City, MOThe cargo flt dptd cincinnati enrt to wichita, KS with an intermediate stop at Kansas City dtwn arpt. The flt progressed nrmly to a VOR rwy 03 instrument apch, circling to rwy 01. The PIC had been clrd to commence the apch. Twr pers subsequently advised the…Apr 1, 1988 · N989B · DestroyedNTSB MIA88LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wayside, MSWhile on an aerial application flt on short final, the plt pulled the throttle lever to reduce airspeed but it broke at the power control quadrant. The apch was continued & after acft traveled aprx 1/2 the length of the rwy, he turned the magneto switch off.…Apr 1, 1988 · N7961 · Substantial damageNTSB LAX88LA155Accident · No injuriesLimited investigationFinal reportCessna 182RG · Davis, CAApr 1, 1988 · N400BT · Substantial damageNTSB NYC88LA113Accident · No injuriesLimited investigationFinal reportPiper J-3 · Downingtown, PAThe pilot was performing touch and go wheel landings. During an approach the pilot came in too low and the right main landing gear impacted an electric power pole. The pilot landed the aircraft on a grass strip with only the left main gear then flipped…Mar 28, 1988 · N7170H · Substantial damageNTSB LAX88FA140Accident · No injuriesField investigationFinal reportEnstrom 280C · Fremont, CAFailure of the engine to main rotor drive system due to a drive belt slippage caused by a drive pulley worn beyond its service limit. Contributing to the accident was the inadequate factory maintenance manuals which did not provide the serviceable limits for…Mar 27, 1988 · N5692P · Substantial damageNTSB MIA88LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Terra Ceia, FLWhile on a cross country flt, the plt elected to return to the departure point due to 'bad weather.' He later advised tower personnel when the flt was 10 miles south, inbound for landing. The plt was given landing information after which he reported a loss of…Mar 26, 1988 · N44759 · DestroyedNTSB DEN88FA087Accident · 2 fatalField investigationFinal reportCessna 421A · Albuquerque, NMThe plt and one pax were on a business trip in the U.S. From Canada. The plt had the acft fuel tanks 'topped off' prior to departure from Kansas city. The flt plan indicated 3 hours 30 min enroute to Albuquerque with 5 hours 30 min of fuel on board. Strong…Mar 26, 1988 · CGVDG · DestroyedNTSB CHI88FA082Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Alma, MIDrg arrival, the plt was provided vectors for an sdf rwy 9 apch. No wx rprt was available for the destn (Alma), but the plt was adzd the saginaw wx was: indefinite ceiling, 200' obscured, vis 1/2 mi with fog, temp 41, dew point 31, wind 100 deg at 8 KTS,…Mar 25, 1988 · N54848 · DestroyedNTSB MKC88FA067Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Excelsior Spgs, MODuring arrival at night, after using fuel from the inboard tanks, the plt switched to the outboard fuel tanks. Shortly, thereafter, both engs lost power. The plt declared an emergency & obtained vectors to the nearest airport, but was unable to reach it.…Mar 22, 1988 · N62526 · DestroyedNTSB MIA88LA128Accident · No injuriesLimited investigationFinal reportCessna 150H · Pensacola, FLThe 3.8 hr cross country flt was uneventful, but after the flt entered the downwind leg of the traffic pattern for landing, the eng quit due to fuel exhaustion. During the forced landing the acft collided with trees & came to rest.Mar 22, 1988 · N22954 · Substantial damageNTSB ATL88LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Easley, SCThe plt rptd that he attempted to land at the 2,000 ft strip in a 15 kt tailwind. The airplane touched down long, and he elected to abort the ldg and takeoff again. During initial climb, he felt the tailwheel hit trees located at the end of the rwy. He…Mar 20, 1988 · N2233N · Substantial damageNTSB SEA88FA060Accident · Serious injuriesField investigationFinal reportPitts S-1C · Carson City, NVUpon returning to the Carson airport, N3545 (nieuport) approached from the south and executed a 45 degree entry to the downwind leg for runway 27. While established on final and approximately 100 feet from the threshold to runway 27, and at an elevation of…Mar 19, 1988 · N6389 · 2 aircraft · DestroyedNTSB CHI88FA079Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Taylorville, ILThe helicopter experienced a loss of control while in slow flight out of ground effect. The helicopter impacted the ground in a black plowed field during a period of low visibility due to snow. The occurrence happened in a remote area with few ground…Mar 18, 1988 · N5759H · DestroyedNTSB LAX88FA130Accident · Serious injuriesField investigationFinal reportDornier DO-24 · Oildale, CAPilot's improper fuel consumption calculations and his failure to properly use the mixture control.Mar 17, 1988 · N772AX · DestroyedNTSB MIA88FA127Accident · 1 fatalField investigationFinal reportMooney M-20J · Fernandina Bch, FLThe private pilot flew a flight that consumed about 31 gallons of fuel from a 31 gallon tank. The other fuel tank still had 31 gallons of fuel. The engine failed on base leg and the aircraft crashed in a wooded area. The pilot did not switch the fuel selector…Mar 15, 1988 · N4781H · DestroyedNTSB SEA88LA055Accident · No injuriesLimited investigationFinal reportCessna 207A · Las Vegas, NVDuring a maintenance flight, while on final approach, the engine ceased operating. Adequate fuel was available in the right fuel tank. The left fuel tank contained 4.5 gallons of which 3.5 gallons are unusable. The plt said he was slipping the acft on the…Mar 10, 1988 · N6380H · Substantial damageNTSB CHI88LA076Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dixon, ILMar 10, 1988 · N4072D · Substantial damageNTSB LAX88LA119Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Columbia, CAAt the end of a pleasure flight, while on short final over the landing threshold, the left wing suddenly lifted. The pilot lost control of the aircraft which collided with the terrain and nosed over. There were no reported mechanical failures or malfunctions.Mar 8, 1988 · N8216E · Substantial damageNTSB CHI88IA074Incident · No injuriesIncident investigationFinal reportSwearingen SA226T · Chicago, ILThe TRACON supervisor failed to comply with the established visual minima criteria and his incorrect issuance of a visual approach to an arriving aircraft.Mar 7, 1988 · N600TA · 2 aircraft · No damageNTSB CHI88DEP04Accident · No injuriesFinal reportCessna 172L · West Bend, WIAfter 30 minutes of local flight, on a dark night, the pilot increased the throttle setting after selecting approach flaps. There was no response from the engine. A forced landing was initiated and the aircraft collided with trees and terrain. A subsequent…Mar 6, 1988 · N7089Q · Substantial damageNTSB ATL88FA106Accident · 2 fatalField investigationFinal reportCessna 150 · Knoxville, TNThe Cessna made a long straight in final approach. The aircraft's radio transmitter was inop. Afterward the Cessna PIC rpted that initially he saw the Beech on a left base. Later he stated the Beech was heading away from the traffic pattern. Witnesses…Mar 6, 1988 · N60371 · 2 aircraft · Minor damageNTSB CHI88DEM02Accident · No injuriesFinal reportGalloway XTC · Lowell, MIThe pilot of the homebuilt aircraft was attempting to perform some 'pattern flights' when, after turning on to the base leg of the traffic pattern, the engine seized. The pilot attempted to 'dead stick' the aircraft to the runway, but altitude and airspeed…Mar 5, 1988 · N3969C · Substantial damageNTSB BFO88FA025Accident · No injuriesField investigationFinal reportCessna 150E · Mitchellville, MDThe student plt elected to initiate the flt even though the flaps malfunctioned during the previous flt. Shortly after takeoff the plt was unable to keep the flaps in the extended position. The plt had not been feeling well on the morning of the flt and felt…Mar 2, 1988 · N6202T · Substantial damageNTSB CHI88DEX02Accident · Serious injuriesFinal reportLogan Junior ACE · Cloverdale, INDuring approach, the aircraft struck power lines near the approach end of runway and crashed on the runway. The pilot had less than 1 hour flight time in this model homebuilt aircraft.Feb 29, 1988 · N21BL · Substantial damageNTSB NYC88LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Plymouth, MAThe pilot of the PA-24 said everything was normal until he switched fuel tanks and turned on the boost pump. He said a power loss followed. He was unable to get the engine restarted prior to making an off airport landing. A witness in the aircraft said the…Feb 28, 1988 · N5435P · DestroyedNTSB NYC88DNA01Accident · No injuriesFinal reportGrosvenor Quickie · Middletown, RIThe worn propeller transmission (reduction gear assembly), which failed to transmit power to the propeller at a critical point in the go-around.Feb 28, 1988 · N3774X · Substantial damageNTSB MIA88LA117Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lantana, FLThe plt stated that he turned a long final apch due to other traffic in the pattern. He only saw one other acft in front of him. He was approximately 200 feet from the end of the runway when he felt the impact as the two acft collided. He then attempted to go…Feb 27, 1988 · N66661 · 2 aircraft · Substantial damageNTSB LAX88FA117Accident · Serious injuriesField investigationFinal reportPiper PA-28R-180 · Soledad, CAPilot's failure to promptly initiate remedial action and his failure to raise the aircraft's landing gear during an attempted go-around. Contributing factors relate to the pilot's poor in-flight decision, inattentiveness to VFR procedures and his not…Feb 27, 1988 · N7660J · Substantial damageNTSB FTW88FA074Accident · 1 fatalField investigationFinal reportCessna 150J · Henderson, TXThe Cessna had just rolled out on base on 3rd or 4th touch go when it collided with a biplane that was not in the traffic pattern. Collision occurred between the outer panel of the left upper wing of the biplane and the rt side of the eng cowling of the…Feb 27, 1988 · N5522G · 2 aircraft · Substantial damage