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 CHI83LA271Accident · No injuriesLimited investigationFinal reportBeech E18S · Youngstown, OHThe plt had not obtained a wx briefing, but had gotten info from another company plt who had flown into the destination arpt earlier. During arrival, he could see the rotating beacon & rwy lights thru some fog & elected to make a visual apch. At aprx 75 ft…Jun 19, 1983 · N995H · Substantial damageNTSB DEN83LA144Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Brighton, COAfter entering the landing pattern, the plt noted binding of the aileron control system. Reportedly the aileron controls seemed to lock, so he used the rudders for directional control & landed in a plowed field. During the landing, the acft nosed over. An…Jun 18, 1983 · N2801Z · Substantial damageNTSB SEA83FA127Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Stehekin, WAThe acft crashed into trees at the departure end of the rwy during a go-around. The pilot had attempted a landing on RWY34 with full flaps. Power was cut on final over the trees at 75 mph. When touchdown had not been accomplished about halfway down the rwy…Jun 16, 1983 · N47RR · DestroyedNTSB MIA83LA157Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 · Chuluota, FLThe plt reported that after he was airborne for 40 min, he was forced to terminate the flt due to the apch of a severe rain shower. He stated that when the acft was on a final apch to rwy 11, a sink rate developed that he could not arrest. Subsequently, the…Jun 12, 1983 · N155SS · Substantial damageNTSB MIA83LA156Accident · No injuriesLimited investigationFinal reportCessna 210L · Alva, FLOn departure the pilot stated that the landing gear would not retract fully and the engine did not seem to be producing full power so he elected to return to the airport. During the turn from base to final approach, flaps were extended to the full position.…Jun 12, 1983 · N2188S · Substantial damageNTSB FTW83FA271Accident · 3 fatalField investigationFinal reportCessna TU206F · Pampa, TXDuring arrival on a dark night, the acft collided with level ground aprx 1 mi northeast of the arpt. It touched down on a west northwesterly heading in aprx a 45 deg, left bank, slightly nose down, attitude. An exam of the wreckage was made, but no evidence…Jun 12, 1983 · N35925 · DestroyedNTSB NYC83FHD02Accident · Serious injuriesFinal reportPiper PA-32-260 · Trenton, NJThe acft collided with a railroad bridge overpass during a forced landing after fuel exhaustion. The flt departed NC fornj with an enroute stop to drop off a passenger. The pilot was unable to refuel at this stop as planned and departed andoverflew other…Jun 11, 1983 · N15SB · DestroyedNTSB MKC83LA123Accident · No injuriesLimited investigationFinal reportCessna 150H · Salem, MOThe flt instructor (CFI) initiated a simulated forced landing at about 500 ft AGL as the acft was climbing during takeoff at night. The student elected to turn downwind for a landing on the departure rwy. When the CFI determined that the student would not be…Jun 10, 1983 · N6732S · Substantial damageNTSB ATL83LA226Accident · No injuriesLimited investigationFinal reportLet L-13 · Warrenton, VAThe pilot stated that this was his third flt of the day and his first in this particular acft. He misjudged his glide path and landed about 100 feet short of the runway. The glider rolled into the creek and the nose impacted about 2 feet below the top of the…Jun 10, 1983 · N90626 · Substantial damageNTSB CHI83LA247Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lansing, MIThe acft made a forced landing when the engine quit during the turn to final approach. Just prior to engine failure the pilot stated that he changed the fuel selector to what he believed to be the both tanks position but he actually turned it to the off…Jun 9, 1983 · N53060 · Substantial damageNTSB ATL83FA224Accident · Serious injuriesField investigationFinal reportCessna 172 · Mocksville, NCN5722T, a Cessna 172, and N3452J, a Cessna 150, collided over the approach end of runway 09 while both acft were on short final approach. Both acft impacted the runway and came to rest about 280 ft east of runway 09 threshold.Jun 8, 1983 · N5722T · 2 aircraft · Substantial damageNTSB LAX83LA273Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-29D2 · Reno, NVAccording to the plt, he received an aerial tow to 2500 ft AGL, and after releasing, the glider encountered sinking wx conditions. He proceeded back to the arpt. After entering a downwind for landing, the glider reportedly encountered an area of extreme sink.…Jun 7, 1983 · N46045 · Substantial damageNTSB ANC83FA092Accident · No injuriesField investigationFinal reportBell B47G-2 · Anchorage, AKThe helicopter experienced a tail rotor strike during a hard landing with a door open. According to the student pilot who is a commercial pilot working on an add-on helicopter rating, the left cockpit door unlatched and partially opened on the downwind leg…Jun 7, 1983 · N6140C · Substantial damageNTSB MKC83FA122Accident · Serious injuriesField investigationFinal reportCessna 320E · Minden, NEThe acft stalled and crashed on the final approach to land. The acft had called for landing information and entered the pattern and was seen established in a low final approach when it suddenly turned right and descended to the ground. The acft impacted about…Jun 6, 1983 · N26972 · Substantial damageNTSB ATL83LA217Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Shinnston, WVThe instructor (CFI) was providing takeoff & landing instructions to his son, a student plt. After making a takeoff & landing, they took off again on rwy 22. At lift-off, the CFI noticed a Cessna 180 being taxied for takeoff. At aprx 300 ft AGL, they made a…Jun 6, 1983 · N3511E · Substantial damageNTSB SEA83FU003Accident · Serious injuriesFinal reportSunburst Ultralight · Independence, ORThe pilot stated that he was trying to teach himself to fly his ultrlight. After several takeoffs from a friends field, a rather severe crosswind started which complicated landing. After numerous passes at the small strip, the pilot said he decided to land…Jun 5, 1983 · UNREG · DestroyedNTSB NYC83LA154Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Freeport, PAThe glider collided with a fence during landing. The glider had experienced loss of lift shortly after a release from tow at 2500 ft AGL. Heavy sink and alt loss was encountered and continued. The pilot started a long straight in final approach to land but it…Jun 5, 1983 · N65859 · Substantial damageNTSB NYC83LA134Accident · No injuriesLimited investigationFinal reportBeech 77 · W. Mifflin, PAThe acft landed about 20 ft short of the runway shearing the nose gear and damaging the prop. The student pilot said he encountered a 'small' windshear and he over reacted on the controls causing the acft to contact the ground short of the runway surface.Jun 5, 1983 · N66982 · Substantial damageNTSB LAX83LA286Accident · No injuriesLimited investigationFinal reportJohnson VARI-EZE · Palo Alto, CAThe pilot stated that in an attempt to improve his landings and reduce the landing roll, the airspeed on final was 10 mph less than normally used. He was also attempting to touchdown on the numbers at the threshold. The acft's landing gear struck a small dike…Jun 5, 1983 · N36RJ · Substantial damageNTSB CHI83LA248Accident · No injuriesLimited investigationFinal reportHelio H-391B · Croton, MIThe acft collided with wires on an approach to a lake.Jun 5, 1983 · N4119D · Substantial damageNTSB CHI83LA244Accident · Serious injuriesLimited investigationFinal reportMonerai Sailplane · Montpelier, OHThe glider dragged a wing and carlwheeled during a low turn maneuver by the pilot. The pilot stated that he apparently had failed to lock the flap handle in the proper position and the acft had picked up excess airspeed. In trying to stay in the rwy…Jun 5, 1983 · N13HT · Substantial damageNTSB CHI83FA239Accident · 1 fatalField investigationFinal reportBeech 35 · Auburn, OHThe acft approached the 1800 ft grass strip from the west. Local residents reported the wind as from the wse at 28-30 mph. There was no wind sock at the landing strip. According to witnesses the acft traveled 3/4 of the rwy without touching the ground. At…Jun 5, 1983 · N3939N · DestroyedNTSB ATL83LA212Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Raeford, NCThe pilot stated that he wanted to practice night landings. He made on successful touch and go landing. On the second attempt he went low on final and struck the top of trees short of the runway. A VASI was in place on the landing runway. The pilot had flown…Jun 5, 1983 · N5386Q · DestroyedNTSB LAX83LA269Accident · No injuriesLimited investigationFinal reportCessna T337H · Redding, CADuring the landing sequence at a private airstrip the plt attempted to lower the landing gear but found it would not lock. The acft was returned to the departure arpt and after circling for two and one half hours with darkness approaching was landed with the…Jun 4, 1983 · N1497S · Substantial damageNTSB CHI83LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Lake, MNThe acft collided with a railroad sign during approach to a private airstrip. The weather was VMC but there was a cross-wind of about 15 KTS and a low sun creating sunglare. The acft drifted to the south side of the rwy due to wind and collided with the sign.…Jun 4, 1983 · N55270 · Substantial damageNTSB ATL83FA211Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Lexington, NCThe acft crashed short of the approach end of the intended landing rwy. The weather was VMC. The landing rwy was 26 and the pilot said he realized he was low on the final approach. During the approach the acft was blown off the approach path. Although the…Jun 3, 1983 · N7571R · Substantial damageNTSB NYC83FNC06Accident · No injuriesFinal reportGrumman AA-5A · Warren, VTThe plt reported that during a landing on rwy 4, he encountered wind shear which forced the acft to lose alt & touch down short of the rwy. The acft then veered left & collided with a hangar. The plt reported the wind was from 300 deg at 12 gusting 18 KTS.…Jun 2, 1983 · CGAEX · Substantial damageNTSB ATL83LA207Accident · No injuriesLimited investigationFinal reportRand KR-2 · Dayton, TNThe acft had been airborne for over 1 hr & was descending onto base leg when the eng quit running as the plt went to add power. A forced landing was made in a grassy area near the rwy. After the acft touched down, it hit a ditch during the roll-out, then…Jun 1, 1983 · N83UT · Substantial damageNTSB NYC83FA128Accident · No injuriesField investigationFinal reportCessna 172RG · Plattsburgh, NYDuring an IFR arrival, aprx 1 mi from the outer marker (om), the plt asked for a descent from 3300 ft MSL & was cleared for the localizer, rwy 1 apch. The published min alt at the om was 2100 ft. the plt reported at the om, and 11 seconds later, the…May 31, 1983 · N6207R · Substantial damageNTSB LAX83FA256Accident · 4 fatalField investigationFinal reportBeech H35 · Antioch, CAThe acft collided with the ground in a nose low attitude during flt in the traffic pattern to land. Witnesses described the pattern as being close in, slow and low compared to normal traffic. The attitude of the acft was described as nose high. As the acft…May 31, 1983 · N391B · DestroyedNTSB NYC83FA126Accident · 4 fatalField investigationFinal reportBeech B36TC · Farmingdale, NYThe acft collided with a powerline static wire during an instrument landing approach. The private plt was instrument rated and had received a weather briefing and filed an IFR flt plan. He commented to the briefer that 'it doesn't sound too good' and that he…May 30, 1983 · N837E · DestroyedNTSB LAX83FU007Accident · 1 fatalFinal reportUltralight Engineering Astra HS · Bakersfield, CAThe plt was on a familiarization flt in preparation to fly the Ultralight vehicle on a x-country to evaluate it for a magazine article. The eng quit on the 1st flt & a successful forced landing was made. Reportedly, the vehicle required only minor repairs & a…May 30, 1983 · UNREG · Substantial damageNTSB LAX83FU006Accident · 1 fatalFinal reportEipper Weight Shift · Bakersfield, CAReportedly, the plt was lining up on final apch to land when the ultralight vehicle collided with a power line at aprx 30 ft AGL. According to the county coroner, the plt died from accidental electrocution on 5/31/83.May 30, 1983 · UNREG · Substantial damageNTSB FTW83FA253Accident · 1 fatalField investigationFinal reportPiper PA28R200 · Decatur, TXAfter landing due to poor wx the pilot obtained a wx briefing during which he was told of a long line of thunderstorms 150 miles wide covering the area in which he was located. The pilot departed & then attempted to land at an airport 15 miles away in gusty…May 30, 1983 · N41761 · DestroyedNTSB FTW83FA252Accident · 1 fatalField investigationFinal reportPiper PA-60 · New Orleans, LAWitnesses reported that when the acft was stabilized on final apch, it pitched up slightly & yawed, then rolled left to an inverted attitude & crashed in a canal. Several witnesses stated that the left prop was windmilling. One stated the left prop had…May 30, 1983 · N52AC · DestroyedNTSB SEA83LA114Accident · No injuriesLimited investigationFinal reportStinson 108 · Grants Pass, ORThe acft ran off the runway and collided with bushes during an aborted go-around. According to the pilot a crosswind caught the acft as he was landing, in spite of his attempts to keep it straight the acft started to veer to the left and he decided to…May 29, 1983 · N6202M · Substantial damageNTSB ATL83LA204Accident · No injuriesLimited investigationFinal reportMooney M20K · Mitchellville, MDThe acft collided with a chain link fence and a dirt bank on the final approach just prior to touchdown. The fence was about a foot and a half higher than the dirt and the dirt bank was aprx an equal height above the runway. The plt had flown through rain…May 29, 1983 · N9872Q · Substantial damageNTSB CHI83LA233Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Woodruff, WIThe plt was briefed on the wx before departing waukegan, IL. At the destination, Woodruff, WI, the wx was forecasted to be VFR, except for light rain & the chance of scattered thunderstorms. While en route, the plt checked on the wx & spoke with another plt…May 28, 1983 · N2164X · Substantial damageNTSB CHI83LA231Accident · No injuriesLimited investigationFinal reportCessna 152 · Steubenville, OHThe student plt & an instructor (CFI) were practicing touch-and-go landings. On about the 5th pattern, the CFI moved the mixture control to the off position to simulate an engine failure. He stated that he had been taught to do this by his instructor. When…May 27, 1983 · N757TV · Substantial damageNTSB FTW83LA249Accident · No injuriesLimited investigationFinal reportCessna 150M · Oklahoma City, OKThe Certified Flight Instructor's delayed remedial action which resulted in the dual student stalling the airplane.May 26, 1983 · N66245 · Substantial damageNTSB ATL83LA202Accident · No injuriesLimited investigationFinal reportCessna 195 · Florence, SCAccording to the plt, the eng lost power about 3 mi from the arpt after he switched from the right to the left fuel tank. He reported that he switched the boost pump to the 'high' position, but was unable to restart the eng. He estimated there was 5 to 7 gal…May 26, 1983 · N4395V · Substantial damageNTSB DEN83FA120Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Canon City, CODuring base turn the acft stalled, rolled over & spun to the ground.May 25, 1983 · N2433L · DestroyedNTSB CHI83LA227Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Elgin, ILThe acft collided with the roof of a trailer truck during an approach to land over a toll road. The collision separated the left main gear from the acft and damaged the other two landing gear. The impact left two depressions about 2 inches deep in the edge of…May 25, 1983 · N6758F · Substantial damageNTSB MIA83FA145Accident · 1 fatalField investigationFinal reportPiper PA-22 · Pompano Beach, FLThe surviving pax stated that about 1 mi from the rwy their alt was 1,000 ft & 'lots of speed.' The plt was cleared to land on rwy 13. The plt then reported 'we go around again...' He was advised by the tower to make left traffic. He was then observed…May 23, 1983 · N8983C · DestroyedNTSB ANC83LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Big Lake, AKThe acft collided with trees and stalled into the ground during a go-around. The plt stated that the acft was using up a lot of rwy during the landing so he initiated a go-around. He added full power but was unable to gain enough altitude to clear the trees.…May 23, 1983 · N43598 · Substantial damageNTSB MKC83FA113Accident · 1 fatalField investigationFinal reportBensen B-8M · Herington, KSThe builder/plt purchased the basic airframe & rotor kit from Bensen, but purchased the eng from another source. The eng was not modified iaw Bensen instructions. Reportedly, the plt was only going to conduct taxi & ground runs when he started at aprx 1100…May 22, 1983 · UNREG · Substantial damageNTSB CHI83FA224Accident · Minor injuriesField investigationFinal reportCessna 172P · Joliet, ILThe acft made a hard landing and nosed over during a forced landing after engine failure on the base leg. The flt was onthe base leg with power at idle and carburetor heat on when the engine lost power. The pilot was unable to restart the engine. The pilot…May 22, 1983 · N53700 · Substantial damageNTSB DEN83LU001Accident · 1 fatalFinal reportIntl Ultralight Banshee · St. George, UTReportedly, the ultralight vehicle was assembled at an abandoned arpt, then was test flown by an international ultralight company salesman. The non-rated plt, who was planning to buy the ultralight, then flew the vehicle to familiarize himself with its flt…May 21, 1983 · UNREG · DestroyedNTSB ATL83LA193Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Nashville, TNThe acft collided with a powerline while on an ILS approach. The weather was VMC but scattered clouds and a dark night necessitated the instrument approach. The pilot stated that he became distracted while re-setting his directional gyro and descended below…May 21, 1983 · N8074M · Substantial damageNTSB ATL83LA192Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Stanton, KYWhile on final apch to land, the eng lost power when the acft was at aprx 300 ft AGL. The plt stated that he switched fuel tanks & retracted the landing gear & flaps in an effort to reach the rwy. When he saw that he could not glide to the rwy, he turned to…May 20, 1983 · N3828N · Substantial damage