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 ANC83IA010Incident · Minor injuriesIncident investigationFinal reportShort Bros. SC7 Series 3 · Barrow, AKThe aircraft was on a round trip flight from Barrow, AK to point hope, AK and return. After landing at point hope, there was a 20 min delay while waiting for the ground crew. The pilot stated that he ran the engines for some 10 min or so due to the high winds…Nov 1, 1982 · N50DA · Minor damageNTSB SEA83LA014Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Cascade Locks, ORPlt was making a precautionary landing after encountering fog enroute. Two approaches to rwy 24 were aborted due to gusting winds. A downwind approach was then made to rwy 06. When the acft descended below the height of surrounding trees the prevailing…Oct 31, 1982 · N6936P · Substantial damageNTSB ANC83LA008Accident · No injuriesLimited investigationFinal reportArctic S1B2 · Shishmaref, AKThis pilot flew into the ground short of the runway, the pilot has visual deficiencies especially at twilight or in darkness. This accident took place at twilight. The pilot was hauling reindeer meat and stated the elevator jammed during final approach. An…Oct 30, 1982 · N63AT · Substantial damageNTSB NYC83LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Watertown, NYThe pilot reported that he made two touch-and-go landings at the Watertown, new york intl airport. He then returned to his private airstrip in the local area. While executing a night approach to the private strip he got too low. The pilot stated that he added…Oct 29, 1982 · N1277Q · Substantial damageNTSB FTW83LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mcallen, TXWhile on approach the pilot encountered wind shear and downdrafts and subsequently struck the number 2 approach light stanchion. The gear assembly sheared off and the aircraft touched down on the runway and veered to the right.Oct 28, 1982 · N47916 · Substantial damageNTSB FTW83AA024Accident · 4 fatalFinal reportPiper PA-31P · Carrollton, TXA PA-31, N100FD, was being vectored by dfw approach control (apch ctl) for a landing on rwy 13L at dallas-love fld. The plt's last received & acknowledged instructions were to descend & maintain 2000' & turn left to 190 deg. Simultaneously,a Cessna 337,…Oct 27, 1982 · N100FD · 2 aircraft · DestroyedNTSB DEN83FTE01Accident · Serious injuriesFinal reportJ.A.Mullan Dragonfly · Erie, COThe pilot was on a flight to accumulate flight time on a home built aircraft. A mayday call was received on the UNICOM. Several witnesses indicated that the pilot was trying to land on the runway when the plane entered a left bank. And suddenly crashed.…Oct 26, 1982 · N21SH · DestroyedNTSB MIA83LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Ft. Myers, FLThe plt stated that during his solo x-country the throttle became stuck several times enroute. While approaching Ft. Myers he retarded the throttle but was unable to advance it again. Unable to maintain altitude, the plt made a forced landing. Post…Oct 24, 1982 · N739WY · Substantial damageNTSB FTW83LA021Accident · Minor injuriesLimited investigationFinal reportCessna 310C · Bastrop, LAThe pilot was preparing for an enroute landing when he got an unsafe gear light. While trouble-shooting, the left engine stopped. He feathered the left engine and almost immediately the right engine quit. The pilot failed to reach therunway during the power…Oct 24, 1982 · N1739H · DestroyedNTSB LAX83FUJ02Accident · 1 fatalFinal reportHobbs B8M · Eloy, AZThe gyrocopter crashed approximately 125 ft short of & 30-45 ft to the right of the rwy threshold during proficiency flying.Oct 23, 1982 · N1335G · Substantial damageNTSB CHI83FA024Accident · 1 fatalField investigationFinal reportC. EFF VARI-EZE · Seymour, INAircraft was being taxi tested when it became airborne and flew a fast, low tentative pattern. Turning final the turn was very steep and aircraft descended to ground impacting a tree prior to ground impact. The pilot had no recorded flight time in this…Oct 23, 1982 · N122EF · DestroyedNTSB ATL83FA014Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Athens, TNThe plt had not flown for a couple of years. On 10/15/82 he received dual instruction in a C-172 & on the day of the accident was checked out in the PA-28. His certificate was not valid for night flight. At 1716 the plt activated a VFR flt plan. At…Oct 22, 1982 · N21678 · Substantial damageNTSB LAX83FUJ01Accident · 1 fatalFinal reportGrumman American AA-1B · New River, AZAfter entering the traffic pattern, the aircraft was observed in a steep descending turn from downwind to final approach. A witness reported that the pilot kept increasing the bank, while turning to final, as if to keep from overshooting the final approach…Oct 19, 1982 · N9897L · Substantial damageNTSB LAX83LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA28-180 · Reno, NVAircraft impacted on a hillside at 5200 feet level while on approach to cannon international airport Reno, NV at night. The weather was VMC. No malfunctions in equipment were found the pilot said the aircraft "fell from under me". He saw the terrain, pulled…Oct 18, 1982 · N8176W · DestroyedNTSB MKC83FCQ02Accident · Serious injuriesFinal reportPiper PA-22-108 · Baxter Springs, KSA witness observed the acft's nose pitch up when the acft was on a right base turning final. The acft started turning left & hit the ground.Oct 17, 1982 · N4581Z · Substantial damageNTSB CHI83LA017Accident · No injuriesLimited investigationFinal reportCessna 206 · Cleveland, OHBefore taking off on a night flight, water was drained from the fuel sumps. When the pilots were satisfied that all of the water was drained from the tanks, they departed. The flight was routine until the aircraft was on final approach for landing. About 1…Oct 17, 1982 · N5379U · Substantial damageNTSB MKC83FCQ01Accident · Serious injuriesFinal reportMooney M20A · Halstead, KSDuring arrival, the pilot noted that the wind was from the northwest. He estimate it was from 330 deg at 20, gusting 35 KTS. On final approach, the aircraft was reportedly unstable due to gusty winds and turbulence. The pilot observed and was aware of the…Oct 12, 1982 · N8311E · Substantial damageNTSB NYC83LA007Accident · No injuriesLimited investigationFinal reportGlobe Swift GC-1B · Elmira, NYDuring takeoff, the right side of the canopy separated from the aircraft as it was climbing through about 150 to 200 ft AGL. The pilot notified the tower of the situation and clearance was obtained to land on any runway. According to the pilot, he turned…Oct 10, 1982 · N50BS · Substantial damageNTSB LAX83LVD01Accident · Minor injuriesFinal reportBoeing A75 · Ft. Bragg, CAThe pilot reported that he was long and fast on his landing approach, so he decided to go around. Due to a noise sensitivity problem in the area, he elected not to use full throttle. Subsequently, the aircraft hit the tops of trees at the end of the runway.…Oct 10, 1982 · N56772 · DestroyedNTSB LAX83FUM01Accident · 4 fatalFinal reportBeech A35 · Oceanside, CADuring arrival, the aircraft entered downwind for a right traffic pattern to runay 24. At that time, a witness (a well qualified pilot) noted that the wind was from the northeast at about 8 KTS. Another pilot-witness stated that the wind was from the…Oct 10, 1982 · N696B · Substantial damageNTSB FTW83FQA02Accident · Serious injuriesFinal reportRaven Industries S-66A · Albuquerque, NMThe pilot was landing the balloon in strong gusty winds when he saw power lines approaching and told everyone to jump. Those jumping, except the pilot, were injured. One passenger stayed in the basket and was unharmed.Oct 10, 1982 · N1980M · Substantial damageNTSB FTW83LA011Accident · Serious injuriesLimited investigationFinal reportRaven AX-7 · Albuquerque, NMThe balloonist attempted to abort a landing due to wind conditions and believes he encountered a downdraft. The balloon descended and landed on a fence and became airborne again. The wind had picked up to about 15 or 20 knots so the balloonwas traveling…Oct 7, 1982 · N40222 · No damageNTSB MIA83FA006Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Lake Placid, FLAircraft was transporting marijuana and during an attempted road landing at Lake Placid collided with wires which damagethe landing assembly. Aircraft continued on to north about 4 miles and ditched in a lake. The aircraft sank with both occupants and cargo.Oct 6, 1982 · N13785 · Substantial damageNTSB NYC83LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bernville, PAThe pilot reported that the plane crashed after the right wing tip hit the top of a tree during landing. He reported that he had flown only 2 hrs in the last 90 days. He noted that this was only a 13 minute flight. He thought that he would have been more…Oct 3, 1982 · N3849M · Substantial damageNTSB MKC83LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcpherson, KSThe pilot estimated there was about 10 gallons of fuel on board before he took off. After making three takeoffs and landings, he picked up a passenger and flew in the local area. After flying about one hour and 17 minutes, the engine lost power. While landing…Oct 3, 1982 · N757PF · Substantial damageNTSB ATL83FA001Accident · 3 fatalField investigationFinal reportEagle C-7 · Piedmont, SCBalloon was inflated with difficulty because of gusty winds. Balloon did not have a skirt. During the flight which ended in the accident the balloon seemed to have trouble and during the final moments it was in a descent which ended with the envelope as a…Oct 3, 1982 · N70014 · DestroyedNTSB DEN83FA001Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Wolsey, SDThe pilot had been issued an instrument rating on 8/6/82 and had logged 5.6 hrs since that time. The pilot's instructor believed this would have been his first low approach in actual instrument conditions since he completed his check flight. A witness stated…Oct 1, 1982 · N6553C · DestroyedNTSB ANC82IA103Incident · No injuriesIncident investigationFinal reportPiper PA31-350 · Kenai, AKThe commuter flight departed Kenai, destined for anchorage AK. The pilot stated that while on approach he could not obtain a positive gear down and locked indication on the nose gear. The pilot elected to return to Kenai airport due to weather at anchorage.…Sep 30, 1982 · N61366 · Minor damageNTSB FTW82DA400Accident · No injuriesFinal reportCessna 152 · Dumas, TXDuring the student's first solo takeoff & landing, she was not lined up with the runway & elected to go around. Power was applied & the flaps were fully retracted. The acft immediately dropped to the ground left of the runway.Sep 27, 1982 · N24313 · Substantial damageNTSB ANC82DA101Accident · No injuriesFinal reportFairchild C-82A · Karluk, AKThe pilot reported that during arrival, the approach to landing seemed normal until just before touchdown. The aircraft touched down short of the runway threshold marks on relatively steep terrain in the safety zone. The pilot estimated that the touchdown…Sep 27, 1982 · N9701F · Substantial damageNTSB SEA82DA174Accident · No injuriesFinal reportTanke Goldwing · Harrington, WAAfter a local pleasure flight, the pilot returned to a farm strip for landing. Due to a windshift, the pilot attempted a landing 90 degrees from that of the takeoff. The aircraft struck powerlines while on the approach.Sep 26, 1982 · N123DT · DestroyedNTSB DEN82DA204Accident · No injuriesFinal reportCessna 172 · Rock Springs, WYAccording to the pilot, a strong gust of wind lifted the aircraft during the landing and power was applied for a go-around. Another gust of wind forced the aircraft off the runway into the dirt next to the runway. When the aircraft departed the runway, the…Sep 26, 1982 · N55404 · Substantial damageNTSB CHI82FA366Accident · 1 fatalField investigationFinal reportCessna 340A · Sugargrove, ILAircraft collided with terrain after a missed approach in a descending turn left wing hit the ground first. Aircraft broke up and caught fire. No malfunctions found.Sep 26, 1982 · N2676A · DestroyedNTSB FTW82FPM17Accident · 1 fatalFinal reportCessna 421B · Afton, OKAt about 1930 CDT, the aircraft departed yukon, OK on a direct flight to alton, IL. It landed at alton at about 2200 CDT, and about 10 minutes later, it departed on a return flight to yukon. Before departing alton, the pilot stated that he would refuel at…Sep 25, 1982 · N8019Q · DestroyedNTSB FTW82DA395Accident · Minor injuriesFinal reportCessna 182B · Albuquerque, NMThe pilot undershot the runway following an engine failure on final approach. The pilot had been flying 4.7 hours on a cross-country flight when engine quit. The aircraft was out of fuel. The optimum endurance is 4.6 hours. The pilot had figured on 7 gallon…Sep 25, 1982 · N2389G · Substantial damageNTSB CHI82FA365Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Mankato, MNAt about 1530 CDT, the aircraft departed mattoon, IL on a flight to Mankato, MN. However, the pilot landed at albert lea, MN where he refueled and topped the tanks with 45.5 gal of fuel. The aircraft's usable supply was 48 gal. While refueling, he reportedly…Sep 25, 1982 · N82717 · DestroyedNTSB LAX82DA353Accident · No injuriesFinal reportGrumman G-164A · Magma, AZShortly after takeoff the eng became rough & losing power. The plt observed long streaks of red flame pouring from the exhaust. The pesticide was jettisoned & an attempt was made to return to the strip. The eng continued to lose power & quit completely just…Sep 23, 1982 · N6602 · Substantial damageNTSB LAX82DA352Accident · No injuriesFinal reportBellanca 14-13-2 · San Jose, CAThe acft landed short of the rwy. The plt stated he was demonstrating a 3-point landing & his attention was diverted by answering a question.Sep 22, 1982 · N74440 · Substantial damageNTSB FTW82DA386Accident · No injuriesFinal reportGrumman AA-5A · Tulsa, OKThe student pilot stated that he made several touch-and-go landings without incident, when the engine started "cutting out" on final approach. He reported that carburetor heat was not applied until after the power loss began. He was unable to restore power…Sep 22, 1982 · N26171 · Substantial damageNTSB LAX82DA351Accident · No injuriesFinal reportPiper PA-28181 · Visalia, CAThe aircraft crashed short of the runway during final approach. The pilot reported a loss of power which could not be duplicated by FAA maintenance. No engine malfunction was found.Sep 20, 1982 · N5889V · Substantial damageNTSB FTW82DA385Accident · No injuriesFinal reportCessna 501SP · Crystal City, TXThe aircraft touched down 10 feet short of the runway. The right main gear failed when it contacted the raised lip of the runway threshold. After the gear failure, directional control was lost and the aircraft collided with fence posts. The six occupants were…Sep 20, 1982 · N50US · Substantial damageNTSB LAX82DA348Accident · No injuriesFinal reportPiper PA-28R-200 · Prescott, AZAccording to the pilot, he planned a fuel stop at needles, CA, but was unaware that services were not available until after arrival. He departed needles with low fuel in both tanks and attempted to reach Prescott, AZ before dark. However, darkness occurred…Sep 19, 1982 · N7675C · Substantial damageNTSB ATL82FID13Accident · No injuriesFinal reportBeech B-19 · Franklin, VAN7698R crashed while on final approach, approximately one half mile east of Franklin airport. The father of the pilot stated that the aircraft had been taken without permission. The pilot holds an expired student pilot certificate. In addition, the pilot was…Sep 19, 1982 · N7698R · Substantial damageNTSB NYC82DA226Accident · No injuriesFinal reportPiper PA-24 · Erie, PAThe aircraft was on final approach for landing when the engine lost power. The power loss occurred when the plane was about 40 to 50 ft AGL and 1/4 mile from the runway. The plane touched down short of the runway and collided with approach lights. After…Sep 18, 1982 · N6253P · Substantial damageNTSB SEA82FA163Accident · 2 fatalField investigationFinal reportde Havilland DHC-II · Mahoney Creek, IDThe acft was observed flying over the strip in what appeared to be a normal downwind pattern. It crashed about 300 ft below windy ridge on the northwest face. The autopsy report indicated the plt had a "patchy healed myocardial infarct" prior to the accident.…Sep 14, 1982 · N5157G · DestroyedNTSB SEA82DA161Accident · Minor injuriesFinal reportPiper PA-38-112 · Corvallis, ORThe flight instructor stated that while on a low final approach, a sudden downdraft of windshear occurred causing the aircraft to drop and the right wing to hit the top of a tree. Upon impact the aircraft spun out of control and impacted the ground.Sep 12, 1982 · N2535P · DestroyedNTSB FTW82DA379Accident · Minor injuriesFinal reportCessna 172 · Corpus Christi, TXAircraft landed short after engine quit on final approach. The fuel was down to minimum usable quantity.Sep 12, 1982 · N8233U · Substantial damageNTSB LAX82FA341Accident · Minor injuriesField investigationFinal reportBell 47G-2 · San Diego, CAThe plt was in the local pattern practicing maneuvers. After completing a quick stop maneuver & hovering, another takeoff was initiated. The plt stated that it seemed to take an unusual amount of forward cyclic to initiate forward flt. During the final…Sep 11, 1982 · N4242A · DestroyedNTSB LAX82DA340Accident · Serious injuriesFinal reportBeech C23 · Bear Valley, CAThe pilot landed long and fast on the runway. He was using runway 19 and the wind was from the north at 15-20 KTS. He landed and while still rolling at 65 KTS initiated a go-around. He did not climb high enough to clear small tree and after colliding with…Sep 11, 1982 · N4357W · DestroyedNTSB FTW82DA375Accident · No injuriesFinal reportCessna 172N · Katy, TXDuring a biennial flight review, the pilot/owner began a simulated emergency landing. Reportedly, the engine was not cleared during a long power-off descent from 900 ft. when it became apparent that the field would not be reached, the flight instructor took…Sep 11, 1982 · N73922 · Substantial damage