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 MIA86LA204Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Kissimmee, FLThe plt rprtd that he initiated a flt around the pattern, but stalled the acft during the apch to land. The acft crashed outside the arpt boundry, just short of the rwy. Prior to the flt, a mechanic, who had been working on the acft, told the plt that the…Jul 11, 1986 · N1448F · Substantial damageNTSB DEN86LA200Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20B · Hobbs, NMThe plt said that he was participating in a glider soaring contest when the accident occurred. He stated that he was flying on the second leg of the flt when he ran out of thermals to keep his glider flying, and he was forced to land prematurely. On a…Jul 11, 1986 · N26EE · Substantial damageNTSB MIA86FA202Accident · 1 fatalField investigationFinal reportGrumman G-164B · Sidon, MSThe right wings of the ag operator's bi-plane collided with the ground support cables of a 322 ft high microwave tower while on a base leg for landing. The right wings separated & the acft crashed & burned killing the plt. The 25000 hr plt knew of the tower…Jul 10, 1986 · N48593 · DestroyedNTSB NYC86FHD02Accident · Minor injuriesFinal reportCessna 172K · Jobstown, NJWhile on the third landing attempt, the student pilot was high and fast, the instructor allowed the landing to be accomplished, on the last third of the runway, the CFI attempted a go-around, the flaps were not retracted. The aircraft cleared power lines, but…Jul 8, 1986 · N7456G · DestroyedNTSB CHI86LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Selfridge Ang, MIThe plt became lost at night over a large body of water and requested assistance. When identified by ATC, the acft did not have enough fuel remaining to reach an arpt. The acft suffered fuel exhaustion on final apch and was landed on a golf course 2000 ft…Jul 7, 1986 · N8095F · Substantial damageNTSB MIA86LA201Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Marco Island, FLDuring landing apch, the plt stated that he switched from the left fuel tank to the right tank & shortly thereafter, the eng failed. He was unable to restart the eng and a forced ldg was made. An exam of the left tank revealed it to be empty while the right…Jul 6, 1986 · N9031S · DestroyedNTSB LAX86FA279Accident · 5 fatalField investigationFinal reportCessna 172M · Havasu Lake, CAAt about 2100 PDT on 7/5/86, the flt departed lake Havasu city, AZ for an unkn destn. On the next morning at aprx 0330, witnesses, who were fishing on lake Havasu, heard the acft circle twice, then crash about 2 mi west of the arpt on the California side of…Jul 6, 1986 · N80503 · DestroyedNTSB ATL86IA187Incident · No injuriesIncident investigationFinal reportCessna U206C · Bucyrus, OHThe plt was returning to the airport after transporting skydivers to altitude and while on final aprch he allowed the acft to stall & crash short of the rwy.Jul 6, 1986 · N29095 · Minor damageNTSB DEN86LA187Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Richfield, UTPlt stated after the accident, '...I noticed the wind sock and it was drooping...I went to final approach (for rwy 1) ... Noticed a little wind so I crabbed into it, and I noticed my approach didn't look good so I went to do a go-around. I went to raise the…Jul 4, 1986 · N8291E · Substantial damageNTSB MKC86LA144Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Davenport, IAThe owner of the airplane had not flown since 1980 and was receiving instruction to become current and was to receive a bfr on this trip also. The airplane had been rebuilt after a forced landing and also had just received an annual inspection. The airplane…Jul 3, 1986 · N6FF · Substantial damageNTSB MKC86LA142Accident · No injuriesLimited investigationFinal reportStevens Akro · Conway, ARThe PIC stated he allowed the acft to develop a high sink rate on final approach to the rwy, and was late in applying pwr to arrest the descent. Subsequently the acft impacted the terrain and sustained substantial damage.Jul 3, 1986 · N6009N · Substantial damageNTSB LAX86LA276Accident · No injuriesLimited investigationFinal reportCessna 320D · Compton, CAThe plt attempted a night landing after he was unable to extend the acft's landing lights. He stated that, over the end of the rwy at about 25 ft AGL, everything blended into a large black spot. As the plt attempted a go-around, the acft contacted the rwy,…Jul 2, 1986 · N4153T · Substantial damageNTSB BFO86FA038Accident · 4 fatalField investigationFinal reportBeech 95-B 55 · Lynchburg, VAThe non-instrument rated pilot filed an IFR flight plan into known and forecast IFR weather. During his second ILS approach to the airport, after the control tower had closed, he failed to utilize the aircraft radio to illuminate the approach lighting system.…Jul 2, 1986 · N133P · DestroyedNTSB ATL86LA186Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Robbinsville, NCThe acft was flown from troy, mi to knoxville, TN and landed, but it was not refueled. The plt proceeded on to the assume destination, but the acft did not arrive. According to the plt's original flt plan (from troy to andrews, NC), the estimated time en…Jun 30, 1986 · N8153C · DestroyedNTSB NYC86LA165Accident · No injuriesLimited investigationFinal reportCessna 150E · Hammondsport, NYWhile on final apch over high terrain east of the arpt, the plt inadvertently pulled the mixture control when he intended to apply carburetor heat. The eng stopped running & the plt was unable to obtain a restart before the acft collided with trees. The acft…Jun 29, 1986 · N4067U · Substantial damageNTSB CHI86LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Int'L Falls, MNAcft struck power lines on approach to private airstrip. The plt stated that an air pocket pulled the plane down. Weather at international Falls, six miles from the accident site, reported winds at 7 KTS with no gusts. The plts flt time was not reported.Jun 29, 1986 · N19528 · Substantial damageNTSB NYC86LA161Accident · Minor injuriesLimited investigationFinal reportAlon A2 · South Sutton, NHThe plt rprtd that during a landing, the flight encountered a severe downdraft and impacted the ground hard, collapsing the nose gear and incurring other damage to the aircraft.Jun 28, 1986 · N5474E · DestroyedNTSB MIA86LA193Accident · Minor injuriesLimited investigationFinal reportCulver V · Deland, FLThe plt stated that on his landing apch he reduced the power too soon, the acft stalled and collided with trees and crashed 150 feet short of the runway.Jun 28, 1986 · N80273 · Substantial damageNTSB LAX86LA269Accident · No injuriesLimited investigationFinal reportBeech B-19 · Scottsdale, AZThe acft was fast and long during a landing attempt according to the student plt. He elected to make a go-around but in doing so he raised the flaps too rapidly and the acft landed hard after which it bounced into the dirt off to the side of the rwy.Jun 25, 1986 · N5420M · Substantial damageNTSB BFO86FIA01Accident · Minor injuriesFinal reportGrumman AA1B · Brandywine, MDPrior to reaching the lom during an ILS rwy 01L apch, a loss of pwr was experienced. The plt applied carb heat and pwr was momentarily restored. A total pwr loss was then experienced and the plt executed a forced landing in a field during which the acft nosed…Jun 24, 1986 · N9628L · DestroyedNTSB MIA86LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Punta Gorda, FLThe plt stated that after a 20 minute flight on a long final approach the engine sputtered & quit. A forced landing was made in a residential area and the acft went through a ditch severing the landing gear. Post crash examination of the carburetor revealed…Jun 22, 1986 · N9625J · Substantial damageNTSB NYC86LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wayne, NJThe aircraft developed engine problems while on approach to the airport at caldwell, new jersey and collided with trees during the forced landing. Upon examination of the aircraft, debris was found in the vent line from the fuel vent tube to the left fuel…Jun 21, 1986 · N89720 · DestroyedNTSB DEN86FA170Accident · 1 fatalField investigationFinal reportCessna A150K · Silver City, NMThe student plt took a private plt for a sight seeing ride. The acft was over gross weight and the density alt was calculated to be 9,292 feet. On an approach to landing the student plt elected to go around. The surviving plt said that in a steep bank the…Jun 21, 1986 · N6DW · DestroyedNTSB ATL86LA179Accident · Serious injuriesLimited investigationFinal reportAndrew D. Moore HP-18 · Chester, SCThe pilot related that while turning from base to final he heard a loud bang from the left side of the aircraft. The aircraft entered a steep left turn and crashed left of final approach course. Post crash examination of the aircraft revealed that the flap…Jun 21, 1986 · N9700P · Substantial damageNTSB FTW86FPJ09Accident · Serious injuriesFinal reportQuick Silver Mxii · Ardmore, OKThe acft landed short of the rwy after losing eng pwr during the apch. Post acc inspection showed that the bearing on the pwr shaft failed. This allowed the belt tension to become slack which reduced the prop RPM. No other discrepancies were noted.Jun 20, 1986 · N4410W · Substantial damageNTSB CHI86LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Shiocton, WICFI delayed corrective action during a practice forced landing by a student. Aircraft touched down with insufficient runway remaining to stop safely. During the subsequent go-around attempt the aircraft rolled into a plowed field and nosed over.Jun 20, 1986 · N5220M · Substantial damageNTSB LAX86MA268Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Galveston, TXThe plt rprtd that while apchg an oil drilling platform for a lndg, he observed the main rotor blades go out of track about 8 to 10 inches. He also rprtd the helicopter developed a 1:1 vertical vibration. Drg the lndg, the helicopter entered into ground…Jun 18, 1986 · N5796T · Substantial damageNTSB CHI86LA157Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Griffith, INThe student plt & instructor (CFI) were on a dual instructional flt, practicing landings. During an apch to rwy 8, the student began to undershoot on final apch. As the helicopter was apchg a fence near the apch end of the rwy, he became alarmed & applied aft…Jun 17, 1986 · N2295U · Substantial damageNTSB ATL86FA174Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-36 · Waynesville, OHThe plt was attempting to achieve a club duration/altitude gain goal and released from the tow plane at 1,000 ft as opposed to the requested 3,000 ft tow. The plt communicated with another glider plt in the area and stated he was getting low and had to land.…Jun 17, 1986 · N36175 · DestroyedNTSB ANC86FA080Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Settlers Bay, AKThe instructor (CFI) gave the front seat plt a simulated forced lndg while the airplane was aligned with rwy 20 & the wind. The front seat plt elected to fly a traffic pattern to rwy 2. As the front seat plt maneuvered to line up with rwy 2, much alt was lost…Jun 16, 1986 · N11864 · Substantial damageNTSB MKC86LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Liberty, MOThe instructor stated that the student had done well during this dual session, and he felt that traffic pattern airwork would be appropriate. Traffic pattern entry and letdown were normal, but the student got too low and slow on the full flap final approach.…Jun 15, 1986 · N68729 · Substantial damageNTSB FTW86LA108Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Odessa, TXAccording to the pax, the plt had been drinking prior to the flt. After takeoff, the plt decided that perhaps he was not in any condition to fly, so he elected to return to the arpt & land. Rprtdly, his seat belt had gotten caught in the door, & on final…Jun 13, 1986 · N34889 · Substantial damageNTSB DEN86LA159Accident · No injuriesLimited investigationFinal reportCessna 150L · Bountiful, UTThe plt said he had been airborne for about 1.25 hrs when the eng began to cut out. Emerg procedures did not remedy the situation and an off arpt forced landing was necessary. The plt said he did not look in the fuel tanks prior to takeoff but relied on the…Jun 12, 1986 · N1739Q · Substantial damageNTSB FTW86FRG26Accident · 1 fatalFinal reportBenson B-8M · New Braunfels, TXThe acft crashed out of control after the eng stopped during a landing approach, the acft had almost completed the 1st pattern around the field when the eng stopped. Investigation revealed a 1/4 inch nylon rope wrapped and tied around the rotor blade about 30…Jun 10, 1986 · N632X · DestroyedNTSB LAX86FA248Accident · 1 fatalField investigationFinal reportBeech V35B · Del Rey Oaks, CAApproaching the destination arpt the plt informed ATC that he did not feel well and desired to land 'as quickly as possible.' The plt was cleared to land. While on a right base leg the acft pitched 45 degrees nose down, and collided with terrain and a…Jun 9, 1986 · N4457W · DestroyedNTSB SEA86LA140Accident · Minor injuriesLimited investigationFinal reportVarga 2050A · Bear Trap, IDDuring a simulated forced landing the instructor pilot allowed the student to enter into a stall while turning from base to final. Although the instructor attempted to correct the student's mistakes he allowed the student to go too FAR with the task before…Jun 7, 1986 · N5077V · DestroyedNTSB LAX86FA247Accident · Serious injuriesField investigationFinal reportBeech M35 · Swall Meadows, CAThe civil air patrol (cap) organized & provided instructors to teach cap mission plts techniques of 'high altitude' search flying during a 2-DAY course. The curriculum included making a landing approach to a 6080 ft elevation airstrip. The approach was to be…Jun 7, 1986 · N398Z · DestroyedNTSB CHI86FA151Accident · No injuriesField investigationFinal reportBeech 55 · Kenosha, WIThe acft was on a positioning flt returning from traverse city, MI, to Kenosha, WI. The reported milwaukee weather was ceiling 300 ft and visibility 2 miles. The pilot was cleared for a VOR 14 approach and given vectors to the final approach course. The pilot…Jun 7, 1986 · N1268Z · Substantial damageNTSB ATL86LA159Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fayetteville, GAThe plt reported that while on downwind the engine started to run rough. The plt applied carburetor heat and the engine quit. A turn toward a landing area was made; however, the acft collided with trees. Weather conditions at the time were favorable for…Jun 7, 1986 · N28044 · Substantial damageNTSB LAX86LA241Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Sonoma, CAThe acft collided with a pole and crashed in a flooded field while on final approach. The pilot indicated that he flew a 20 minute local VFR flight prior to the accident. He stated he had suffered head injuries and was unable to recall any details of the…Jun 5, 1986 · N62763 · Substantial damageNTSB NYC86LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Oxford, CTDuring an attempted go around, the aircraft stalled. The aircraft then veered left and collided with the ground. The aircraft came to rest about 100 feet off to the side of the runway on the grassy area.Jun 3, 1986 · N7475G · Substantial damageNTSB NYC86LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Syracuse, NYDuring descent about six miles from Syracuse hancock airport, the flight experienced engine vibration. Engine lost power and restarted. However when flight was at 3500 feet, power was lost again. Pilot set up for best glide and crashed in a grassy field. Full…Jun 3, 1986 · N61316 · Substantial damageNTSB DEN86FA147Accident · 1 fatalField investigationFinal reportPiper PA-20-160 · Buena Vista, COWhen the plt took off, the wind was light & variable. However, when he returned to the arpt about 20 to 30 min later, dark threatening clouds had moved into the area. He attempted to land on rwy 14. During the landing, the acft bounced & went off the right…May 31, 1986 · N5394Z · Substantial damageNTSB CHI86FET01Accident · Serious injuriesFinal reportPiper PA-20 · Rolling Prairie, INDuring a go-around from an aborted landing the acft struck unmarked power lines at the departure end of the landing rwy. The acft collided with terrain during the resulting uncontrolled descent. The rwy being used was a 2400 ft long and 50 ft wide sod private…May 31, 1986 · N7734K · Substantial damageNTSB BFO86FID05Accident · No injuriesFinal reportMaule M-4-210C · Saluda, VAWhile on final apch, the acft struck the top side of a van which was on a road off the apch end of the rwy. Both main landing gear were sheared off and the plt landed the acft in a grass area along the side of the rwy. The plt reported that a high sink rate…May 31, 1986 · N9861M · Substantial damageNTSB LAX86LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Long Beach, CAThe airplane crashed on final approach to runway 16L at Long Beach airport (lgb), Long Beach, California. The pilot reported that both engines sustained a total loss of power. The airplane's altitude was insufficient to land on the airport. The left fuel tank…May 30, 1986 · N8306Z · Substantial damageNTSB MIA86LA166Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Pensacola, FLThe pvt glider plt with a total of 47 hours of flt time departed his local field with one passenger. At about 2000 ft AGL he disengaged the aero tow and proceeded to glide for about one hour. The plt stated that when he started back to his local airport and…May 26, 1986 · N11TR · Substantial damageNTSB DEN86LA145Accident · No injuriesLimited investigationFinal reportMooney M20 · Fargo, NDThe plt reports that he experienced difficulty in retracting the landing gear after departure but it did retract after several attempts. He said the gear system seemed to be hanging up. Upon reaching destination the gear again seemed to hang up when extension…May 26, 1986 · N6519B · Substantial damageNTSB FTW86IA093Incident · Minor injuriesIncident investigationFinal reportBoeing 727-224 · Corpus Christi, TXThe pilot made an intentional gear-up landing (left main only) after numerous attempts to lower it were unsuccessful. The small steel nut which had jammed the left main gear door unlatching mechanism fell into that position sometime after the gear was…May 25, 1986 · N88711 · Minor damageNTSB NYC86LA134Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Pittsfield, MAThe student pilot on a solo cross-country flight in a Piper cherokee PA-28-140 became lost and attempted a landing at another airport. The weather was 500 ft broken, 1000 ft overcast. Visibility 8 miles and rain showers. On his first approach, the aircraft…May 24, 1986 · N6848W · Destroyed