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 MKC82DA102Accident · No injuriesFinal reportBalloon Works Firefly 6 · Hudson, IAThe Balloon was in a descent and was approaching the landing area when the burner pilot-light went out. Without the burner, the pilot was forced to land short of his selected field. He spilled the air from the Balloon and touched down just short of an 8000…Jun 13, 1982 · N2067F · Substantial damageNTSB FTW82DA225Accident · Minor injuriesFinal reportCessna 175 · Fort Worth, TXDuring a go-around the aircraft's engine quit. The pilot attempted an off-airport emergency landing; however, collided with bushes and nosed over. Investigation revealed there was a minimum amount of fuel onboard.Jun 13, 1982 · N9419B · Substantial damageNTSB MKC82DA100Accident · No injuriesFinal reportCessna 182B · Milford, IAThe pilot reported that he was low on fuel and was flying over the airstrip before landing to drop a banner that he was towing. Shortly after the banner was released, the aircraft encountered turbulence causing the aircraft to go into a steep bank. At about…Jun 12, 1982 · N5392B · Substantial damageNTSB SEA82DA084Accident · No injuriesFinal reportBeech B19 · Quincy, WADuring a simulated forced landing, the student pilot initially turned the wrong direction, then turned correctly toward the runway. He was lower then normal at his initial and downwind points but after being prompted by the instructor (ip), the student angled…Jun 11, 1982 · N2048A · Substantial damageNTSB NYC82FHD15Accident · Minor injuriesFinal reportGregg KR-2 · Middletown, DEThe eng failed on the downwind leg after the plt applied carb heat. The plt attempted a power-off approach to the rwy but encountered turbulence from another acft passing below him on final causing him to lose control & enter a spin. After recovery the acft…Jun 11, 1982 · N38DR · Substantial damageNTSB FTW82DA218Accident · No injuriesFinal reportBeech 35 · Terrell, TXWhile en route, the cabin door of the aircraft popped open, approximately 10 miles from the destination. The pilot reported that he was distracted by the open door and lost airspeed while on final approach. The aircraft touched down hard just short of the…Jun 8, 1982 · N3803N · Substantial damageNTSB ATL82FKG14Accident · Minor injuriesFinal reportFokker DR-1 · Hampton, GAThe pilot was also the owner of the fixed tri-wing, amateur-built aircraft. After returning from a local flight, he entered the traffic pattern. He flew a large pattern to maintain spacing behind a Cessna 150. After making a low approach, he positioned…Jun 7, 1982 · N1387B · Substantial damageNTSB CHI82FA200Accident · 2 fatalField investigationFinal reportPiper PA-38 · Niles, MIAt about 1300 EDT, the aircraft took off on a local training flight with a student and a certified flight instructor on board. Later at about 1325, the plane crashed in a wooded area about 1 mi northeast of the approach end of runway 21. One witness reported…Jun 6, 1982 · N2588K · DestroyedNTSB ATL82FA155Accident · 2 fatalField investigationFinal reportPiper PA-30 · Snow Hill, MDThe pilot/owner and another occupant with a commercial certificate and an instrument rating took off on a IFR flight plan. The weather at the departure point and destination was characterized by low ceilings and reduced visibilities in fog and rain.…Jun 5, 1982 · N8193Y · DestroyedNTSB ATL82DA156Accident · No injuriesFinal reportPiper PA-23-250 · Auburn, ALWhile on a downwind for a landing in multi-engine training, the nose gear would not extend. All efforts to extend the nose gear, including a bounced landing, were unsuccessful. The aircrew intended to land on the main gear and then hold the nose off until the…Jun 5, 1982 · N1AU · Substantial damageNTSB NYC82FA116Accident · 1 fatalField investigationFinal reportCessna 152 · Elma, NYThe pilot was performing a flight exam for a private pilot certificate. An approach was made to a field bordered by high tension lines. During the approach the aircraft collided with wires and descended nose first to the ground.Jun 4, 1982 · N757GY · DestroyedNTSB LAX82DA207Accident · No injuriesFinal reportPitts S-1 (Bartoe/Skyote) · Santa Cruz, CAThe pilot of the Piper PA-28 reported that he was on final approach at approximately 50 ft AGL when his aircraft was struck from behind and below by a Pitts/skyote S-1, N25PB. He continued the landing, but during the landing roll, the Piper PA-28 veered off…Jun 2, 1982 · N25PB · 2 aircraft · No damageNTSB LAX82FXQ09Accident · 1 fatalFinal reportCessna 182 · Truckee, CAThe pilot had returned to the airport after a glider towing operation of about 10 minutes. Runway 19 was in use. Reportedly, the terrain to the north of runway 19 was about 100 ft lower than the airport elevation. A witness reported that he heard the sound of…May 31, 1982 · N5056D · DestroyedNTSB LAX82DA204Accident · No injuriesFinal reportBeech C-24R · Big Bear, CAA witness observed the aircraft to pitch and roll while on final approach. At about 30-40 feet above the ground the nose pitched downward and the aircraft collided with the runway. Moderate turbulence and gusty winds were reported on final approach.May 31, 1982 · N6716T · Substantial damageNTSB MKC82DA094Accident · No injuriesFinal reportContinental Mk5a Bell 47 · Neligh, NEThe pilot departed the airport helipad with 12 gallons of fuel. After landing in the loading area, he left the engine and spray pumps running to mix the solution in his spray tanks. After spraying the field, he ran out of fuel about one mile from his planned…May 30, 1982 · N9008T · Substantial damageNTSB LAX82DA200Accident · No injuriesFinal reportCessna TP206A · Sedona, AZDuring touchdown the aircraft started to porpoise. The pilot elected to go-around and added power however the aircraft departed the left side of the runway and came to rest nose down in the dirt.May 29, 1982 · N4637F · Substantial damageNTSB FTW82FRG33Accident · 4 fatalFinal reportCessna R182 · Bergheim, TXAt 0010 the plt contacted san antonio tower approximately 10 mi north of san antonio intl arpt. He stated he was at 3100 ft in the clouds. The controller instructed the plt to turn left heading 030, maintain 3,000, & asked the plt if hewanted an IFR…May 29, 1982 · N737RK · DestroyedNTSB CHI82DA191Accident · No injuriesFinal reportConvair 240 · Detroit, MIThe captain stated that during an ILS approach, he saw the approach lights about 3 miles from the touchdown point. Reportedly, the plane was on the glide slope and localizer as he continued on final approach. After passing minumums, the aircraft went into a…May 29, 1982 · N153PA · Substantial damageNTSB ATL82FA145Accident · Serious injuriesField investigationFinal reportCessna U206G · Norfolk, VAThe eng quit during final approach. The acft had a history of problems with water in fuel system leading to engine problems. On 2/8/82 significant quantities of water was found in the fuel system. Post crash examination revealed water in the fuel system.…May 29, 1982 · N777HD · Substantial damageNTSB ANC82DA043Accident · No injuriesFinal reportArctic S1B2 · Near Big Lake, AKThe purpose of the flight was to provide dual instruction to a rated single-engine-land pilot in basic float plane training. After practicing a number of landings, the instructor (ip) simulated an engine-out by reducing the power to 1000-1200 RPM. At this…May 29, 1982 · N65AT · Substantial damageNTSB DCA82AA023Accident · 5 fatalFinal reportBeech D95A · Columbia, MDThe acft was vectored to intercept the localizer course for an ILS approach to rwy 10 at balt-wash-intl arpt. It was then observed to fly through & to the north of the localizer course. The acft was then directed to turn left to a heading of 360 for…May 28, 1982 · N187Q · DestroyedNTSB ANC82DA042Accident · No injuriesFinal reportCessna U206 · Ouzinkie, AKDuring arrival, the pilot made his landing approach over the village so as to land the float plane on the bay and into a 30 knot head wind. While on final approach, the aircraft's rate of descent increased. The pilot added full power and started to raise the…May 27, 1982 · N4877X · Substantial damageNTSB ATL82DA143Accident · No injuriesFinal reportCessna 172P · Jonesboro, GAThe pilot stated that after applying brakes on landing roll the aircraft began to hydroplane on water that was on the runway. He elected to raise the flaps and apply full power in a attempt to go-around but was unable to clear trees off the end of the runway.May 25, 1982 · N54527 · Substantial damageNTSB LAX82DA189Accident · Minor injuriesFinal reportPiper PA-44-180 · Chandler, AZThe pilot departed Chandler, AZ with the fuel gauges indicating 40 plus gallons in each tank. After a 1.2 hr flight to lake havasu city, AZ, the gauges indicated 20 plus gallons in each tank. During the return trip to Chandler at night, both engines lost…May 23, 1982 · N2091K · DestroyedNTSB NYC82DA102Accident · Minor injuriesFinal reportPiper PA-22-150 · Seneca Falls, NYWhile trying to roll out of a left turn on downwind the pilot experienced a jammed rudder control. Full aileron control was not available because of the aileron-rudder interconnect system and a considerable buffet was induced during an attempt to level the…May 21, 1982 · N6086D · Substantial damageNTSB SEA82FYM16Accident · Minor injuriesFinal reportHughes 369D · Birkenfeld, ORThe pilot stated that the fuel gauge indicated 150 lbs of fuel remaining when he began the flight. Since the drop point was within 2 to 3 minutes of the departure point, he elected to proceed without refueling. While hovering and being guided into the drop…May 19, 1982 · N1096L · Substantial damageNTSB CHI82DA173Accident · No injuriesFinal reportCessna 210 · Loganville, WIDuring landing approach the engine lost power and the pilot attempted to land in an open field. The aircraft failed to clear a terrace and the nose gear separated from the airplane. The pilot stated, "while concentrating on the various aspects of operation in…May 18, 1982 · N9698T · Substantial damageNTSB MKC82DA089Accident · No injuriesFinal reportPiper PA-38-112 · Scottsbluff, NEThe pilot stated that during an approach for a touch and go landing, at an altitude of about 50 feet above the runway the aircraft began to drop. He applied throttle and the engine hesitated, failing to accelerate until just before impact with the runway. The…May 17, 1982 · N25718 · Substantial damageNTSB ATL82FKM04Accident · Serious injuriesFinal reportCessna 172G · Worthville, NCDuring arrival, the pilot entered a left downwind for runway 11 and proceeded to make a low pass over the strip to chase off cows. At approximately midfield, he initiated a climb and according to the passenger, when power was applied, the engine did not…May 17, 1982 · N5884R · DestroyedNTSB DCA82AA022Accident · Serious injuriesFinal reportde Havilland DHC-6-200 · Hooper Bay, AKAt 0833 adt, the acft departed bethel, AK on a scheduled pax/cargo commuter flt to chevak, scammon bay & Hooper Bay, AK. The operator's commuter flts had not landed at scammon bay for svrl days since the rwy was soft & muddy from meltingsnow. Bfr departing…May 16, 1982 · N103AQ · DestroyedNTSB CHI82DA169Accident · Serious injuriesFinal reportSchweizer SGU 2 22E · Belden, OHDuring dual flight in a glider practicing stalls the pilot recovered at a low altitude and collided with wires.May 16, 1982 · N2732Z · DestroyedNTSB ATL82DA134Accident · No injuriesFinal reportCessna 150M · Hagerstown, MOOn final approach the student pilot felt the aircraft sink and realized she was not going to make the runway. Simultaneously power was applied and the nose of the aircraft was pulled up in an attempt to reach the runway. The aircraft stalled and nosed over…May 16, 1982 · N3167V · Substantial damageNTSB DEN82DA087Accident · No injuriesFinal reportCessna 185A · Marion, MTThe pilot reported that when he was on final approach, he lost all control, while at an airspeed of about 74 mph, and the aircraft struck the ground in a nose low attitude. He reported that the wind was variable at 10 gusting 20 KTS. About 35 miles away at…May 15, 1982 · N4175Y · Substantial damageNTSB NYC82FA091Accident · Serious injuriesField investigationFinal reportCessna 172P · Sanford, MEA Piper PA-28, N81029, and a Cessna 172P, N53442, were approaching to land on runway 14, when they collided about 1000 ft from the threshold. The pilot of the Piper stated that he had entered the traffic pattern and began to explain the mechanics of the…May 12, 1982 · N53442 · 2 aircraft · Substantial damageNTSB LAX82FA170Accident · Minor injuriesField investigationFinal reportCessna 172K · Huntington Beac, CAThe pilot reported that while he was on final approach to runway 19, he applied full flaps near the airport boundary and the aircraft veered to the right. He said that the aircraft did not respond to aileron control inputs. The aircraft continued to the…May 12, 1982 · N7394G · Substantial damageNTSB MKC82DA074Accident · No injuriesFinal reportBellanca 8KCAB · Hayitt, MOThe pilot stated that he came in slightly low on final to avoid crossing a road that ran through the center of the airstrip. The wheat field at the south end of the strip blended in with the colors and texture of the runway. The landing gear caught the tall…May 9, 1982 · N5067K · Substantial damageNTSB ATL82DA128Accident · No injuriesFinal reportCessna A150L · Greensboro, NCWhile landing the pilot reported his misjudgement caused him to undershoot and touchdown short of the runway. The pilot stated he touched down hard on the left main gear and suggested that the nose gear failed to the right, possibly prior to contact with a…May 9, 1982 · N5938J · Substantial damageNTSB LAX82FA164Accident · 4 fatalField investigationFinal reportCessna 172 · Upper Lake, CAWitnesses observed the acft rolling right & left during the final approach. The acft drifted to the right & power was applied prior to the collision with the trees. Nw winds in excess of 25K prevailed. A CFI witness stated that it appeared the plt was not…May 8, 1982 · N8313E · DestroyedNTSB LAX82FA162Accident · 2 fatalField investigationFinal reportBellanca 17-30 · Santa Barbara, CAThe pilot visited fresno fss for a weather briefing on route to Santa Barbara. He was advised of weather and told VFR flight was not recommended. The pilot then said he would go VFR and make an instrument approach at Santa Barbara if weather was as bad as…May 8, 1982 · N4907V · DestroyedNTSB SEA82DA066Accident · No injuriesFinal reportCessna 150F · Grande Ronde, ORThe student pilot stated that on landing approach the sun was in his eyes. The landing occurred about 50 feet short of the runway threshold when the tail collided with a fence post and the nose wheel contacted a ditch.May 6, 1982 · N6701F · Substantial damageNTSB LAX82DA158Accident · No injuriesFinal reportPiper PA-28-161 · North Las Vegas, NVDuring an instructional flight the instructor was demonstrating a short field landing using the minimum length of the runway. On final the aircraft hit a dirt bank separating the right main landing gear. The instructor stated there were no markings on the…May 4, 1982 · N29500 · Substantial damageNTSB CHI82DA152Accident · Minor injuriesFinal reportPiper PA-12 · Quincy, INDuring a pleasure flight, the pilot elected to make an approach to a new runway that he was building. His approach was made from west to east; the wind was reported to be from the north at 7 KTS. The pilot stated that he throttled the engine back to a normal…May 3, 1982 · N7606H · Substantial damageNTSB LAX82FVG22Accident · Minor injuriesFinal reportOsprey 2 · Lakeport, CAThe pilot reported that after takeoff, he made a few turns and then headed downwind for a landing when he lost the control of an aileron. He reported that he encountered a bad vibration, so he cut the power and brought the plane into a small field by crossing…May 2, 1982 · N58ED · Substantial damageNTSB MKC82DA067Accident · No injuriesFinal reportCessna 150 · Nevada, IAAfter returning from a cross-country flight, the pilot made one go-around when he thought he was too fast. Just beyond the end of the runway at about 200 ft AGL, the engine stopped running due to fuel exhaustion. The pilot attempted to turn and land on the…May 1, 1982 · N11894 · Substantial damageNTSB LAX82FA156Accident · Minor injuriesField investigationFinal reportBeech A24R · Camarillo, CAThe pilot took off from the Camarillo airport on a local flight to practice touch and go landings. He had made two touch and go patterns and was on his third and final landing when the collision occurred. He had transmitted his position on downwind and base…May 1, 1982 · N24584 · 2 aircraft · Substantial damageNTSB DEN82FA075Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Wheatland, WYThe acft struck a tree approximately 1/2 mi from the approach end of rwy 08. No fuel was on board the acft. The gear were down & the flaps were in the 10 deg position.May 1, 1982 · N6695P · DestroyedNTSB CHI82DA147Accident · Serious injuriesFinal reportMong Sport MS-1 · Pendleton, INWhen the pilot arrived at anderson, Indiana, he was unable to find the ace airport. He saw huntzinger airport, a private strip, and decided to land to find out exactly where ace airport was located. During an approach to the sod runway, the aircraft collided…May 1, 1982 · N98L · DestroyedNTSB ATL82DA118Accident · No injuriesFinal reportPiper PA-18A · Timmonsville, SCThe pilot reported that he reduced power at 1000 ft and applied carburetor heat for an extended glide to the sod strip. While on final approach over a wheat field, the airspeed bled off and he moved the throttle to add power. However, he reported that the…May 1, 1982 · N3192Z · Substantial damageNTSB DEN82FTM11Accident · Serious injuriesFinal reportBell 47G-3B-1 · Vermal, UTThe pilot stated that he experienced a partial loss of engine power during landing at an elevation of about 5280 ft MSL. The temperature was about 50 degrees fahrenheit. He applied full throttle, but the RPM decayed and the plane crash landed. A partial…Apr 28, 1982 · N48217 · Substantial damageNTSB NYC82DA079Accident · No injuriesFinal reportPiper 601P · New Castle, PAA witness who observed the accident stated that he saw N31EH on a very close right base at 150-200 ft above the ground. The aircraft was moving at a rapid rate of speed and was in a very steep right turn. As the aircraft got closer to the runway it became…Apr 27, 1982 · N31EH · Substantial damage