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 NYC85LA184Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Nantucket, MAThe acft was observed in a medium left bank turning through a south southwest heading as it appeared from the clouds. The acft continued to descend in that attitude until it collided with the trees about 3.5 miles southeast of the arpt. The plt and passenger…Jul 19, 1985 · N8247A · DestroyedNTSB SEA85LA168Accident · No injuriesLimited investigationFinal reportCessna 172N · Juneau, AKPlt returning from local flight lost visual contact with runway during flare due to sunglare. ATCT had cleared acft to runway and no request for chc initiated by plt, or go around attempted.Jul 17, 1985 · N4931G · Substantial damageNTSB LAX85LA319Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Thermal, CAThe acft crashed during a night visual approach while practicing landings. The pax stated that the acft was high on the approach and the pilot was adjusting his rate of descent when the acft went down.Jul 16, 1985 · N6322B · Substantial damageNTSB CHI85LA293Accident · Serious injuriesLimited investigationFinal reportJohn H. MC Clain, JR. Rand KR2 · Mechanicstown, OHThe acft landed short of the rwy after a power loss. The plt said he was approaching to ladn at 1800 RPM when he added power to clear some power lines. The eng did not respond and the acft was flown under the wires where it collided with a tree during landing…Jul 16, 1985 · N717J · Substantial damageNTSB MKC85LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Springfield, MODuring a wx briefing, the plt was advised of possible thunderstorms at his destination. While en route, he was told that thunderstorm activity at his destination was confirmed by radar. During the last 40 min of the flt, the plt flew past aprx 15 arpts where…Jul 15, 1985 · N5424W · Substantial damageNTSB DEN85FA189Accident · 1 fatalField investigationFinal reportCessna 320F · Rapid City, SDThe acft crashed during an attempted VFR go-around. The plt said he didn't recall touching down and he thought he was 'floating.' When the acft began drifting left of rwy centerline, the plt initiated a go-aroung. He said he applied full power and rotated. He…Jul 15, 1985 · N90HC · DestroyedNTSB NYC85LA177Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Hartford, CTThe apch to the pvt helipad was uneventful up to the last 100 ft where the plts noticed a high sink rate. The plt increased collective to correct for the situation. At about 20 ft from touchdown point the plt noticed a decrease in RPM and realized that they…Jul 14, 1985 · N3124L · Substantial damageNTSB NYC85LA171Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-109B · Pittstown, NJThe approach to runway 08 was normal, however it was long. Although the approach was not too long to land, the student applied full power and decided to go around. The ins tructor took control of the aircraft after realizing that clearing the trees would be…Jul 13, 1985 · N44GF · DestroyedNTSB MKC85LA157Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Earle, ARThe plt reports that the propeller ran away when the acft was at 75 ft AGL on final apch for landing at a pvt airstrip. The plt said he was to low to correct the propeller malfunction and was forced to land in a bean field adjacent to the strip. An FAA…Jul 13, 1985 · N1391M · Substantial damageNTSB CHI85LA289Accident · No injuriesLimited investigationFinal reportBensen B8M · Hebron, OHThe gyrocopter lost partial pwr while in the traffic pattern and the plt executed an autorotation into a corn field. The throttle cable was found loose after the accident.Jul 12, 1985 · N9729N · DestroyedNTSB NYC85LA194Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Savoy, MAThe pilot was attempting to land on a dirt runway approximately 800 feet long with a small dirt embankment at the threshold. During the approach, the aircraft landed short and the landing gear collided with the embankment. The aircraft nosed over and came to…Jul 11, 1985 · N70LB · Substantial damageNTSB MKC85FCQ05Accident · Serious injuriesFinal reportCessna 150M · Manhattan, KSThe acft contacted the terrain aprx 175 yds short of rwy 21 and aprx 50 ft right of the centerline. A witness reported the acft appeared slow on final apch and it was rolling slightly from side to side. The nose of the acft then suddenly dropped and the acft…Jul 11, 1985 · N3201V · Substantial damageNTSB ATL85LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · Enterprise, ALWhile on a solo training flight the aircraft lost power while on downwind and the student pilot made an mergency landing on the runway, however, during landing roll the aircraft went off the side of the rwy and nosed over in the soft soil. Post crash…Jul 10, 1985 · N22553 · Substantial damageNTSB LAX85FA310Accident · 2 fatalField investigationFinal reportPolliwagen Unknown · Bakersfield, CAOn July 7, 1985, at 1917 PDT, a Polliwagen, N81PW, collided with the ground during an attempted go around at bakersfieldairpark, Bakersfield, California, while on a personal flight. VMC prevailed at the time; no flight plan was filed. The aircraft was…Jul 8, 1985 · N81PW · DestroyedNTSB LAX85LA309Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Durham, CAThe purpose of the LCL flight was for the CFI to demo the newly acquired helicopter to its owner. The CFI reported that during the flt a 'somewhat common' vibration was detected, & he associated the vibration with the acft's wooden main rotor blades. He…Jul 7, 1985 · N1048P · Substantial damageNTSB FTW85LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Brownsville, TXWhile practicing touch-and-go landings the plt allowed the acft to descend below the proper glide slope while on final apch. The acft impacted a power line aprx 1000 ft short of the rwy and crashed on the side of a drainage ditch levee. The elevation of the…Jul 7, 1985 · N21698 · Substantial damageNTSB CHI85LA282Accident · No injuriesLimited investigationFinal reportCessna 172L · Akron, OHThe acft contacted trees during a forced landing in a cemetery following a loss of pwr while on final apch at Akron fulton arpt. After the accident, 10 gallons of fuel were added to the acft and the eng operated normally when started. An A&P mechanic…Jul 7, 1985 · N7841G · Substantial damageNTSB SEA85LA157Accident · No injuriesLimited investigationFinal reportMeyers 2000 · Reno, NVA loss of pwr occurred just as the acft was entering the traffic pattern. The acft was landed 650 ft short of the rwy. The reason for the pwr loss could not be determined by an a & p mechanic. The plt did not plan the apch accurately enough to touchdown on…Jul 6, 1985 · N200AW · Substantial damageNTSB DEN85FA180Accident · 4 fatalField investigationFinal reportHughes 369HS · Keystone, SDMain rotor hub was overhauled by a repair station that was not authroized by Hughes helicopters for hub overhauls. The main rotor hub and blades separated in-flt 279 hrs after overhaul. The acft crashed in a densily wooded area. Post accident exam of the main…Jul 6, 1985 · N5410W · DestroyedNTSB CHI85LA276Accident · No injuriesLimited investigationFinal reportCessna 210MII · Detroit, MIThe acft contacted a tree during a forced landing in a residential area following a loss of pwr. Post accident inspection revealed the right fuel tank contained fuel and the left tank was dry, the left wing fuel vent was installed backwards and the fuel…Jul 6, 1985 · N29008 · Substantial damageNTSB MKC85LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · La Porte City, IAThe plt reported that the acft had the proper airspeed when it was on final apch about 1/2 mi from the rwy. However, he reported that it quickly lost 500 ft, landed short of the rwy & was damaged. The acft came to rest in a corn field beside the rwy.Jul 5, 1985 · N5116P · Substantial damageNTSB MIA85LA206Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Daytona Beach, FLThe student plt entered the traffic pattern after making a local solo training flt. He stated that during the landing pattern, he reduced the the throttle incrementally & did not use carburetor heat. As the acft was on final apch at about 50 ft AGL, the…Jul 4, 1985 · N92ER · Substantial damageNTSB LAX85LA303Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Santa Maria, CAThe pilot reported to the tower, while on base leg, that he was out of fuel. He then landed short and contacted a fence and a tree on the landing roll. The pilot stated that the aircraft contained 45 gallons of fuel when he departed and that he had flown for…Jul 4, 1985 · N7198P · Substantial damageNTSB ANC85LA117Accident · No injuriesLimited investigationFinal reportCessna 207 · Jakolok Bay, AKPlt landed short of gravel beach and substantially damaged airplane on large rocks.Jul 4, 1985 · N1686U · Substantial damageNTSB MKC85LA164Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Denison, IAPlt reports that the eng idle setting was too low and the eng quit when he reduced power during a practice autorotation. The acft touched down hard and the main rotor contacted tail boom.Jul 3, 1985 · N6799D · Substantial damageNTSB BFO85LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDAfter not obtaining surface wind info and not observing the wind sock, the student plt entered final apch without observing any significant drift. When the acft was at nose-up attitude. It floated and stopped descending for a few seconds. Suddenly, the plt…Jun 30, 1985 · N757MP · Substantial damageNTSB ANC85FA112Accident · No injuriesField investigationFinal reportDouglas DC-3 · King Salmon, AKDuring an instrument apch, the acft's right eng lost power. The plt moved the right fuel selector to the left main tank & began emergency procedures. Shortly after that, the acft broke out of the overcast & the aircrew saw the arpt. However, the left eng also…Jun 30, 1985 · N168Z · Substantial damageNTSB ATL85FA197Accident · 2 fatalField investigationFinal reportPiper PA-42 · Charlotte, NCThe acft collided with a tree and a pole short of the rwy during a night VFR approach to land. The plt changed from rwy 18 to 36 during the approach. He was seen low & fast on dwnwind which ended in a steep descending turn to ground contact. The twr had…Jun 28, 1985 · N542TW · DestroyedNTSB MKC85LA142Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Maryville, MOThe plt slowed the airspeed on final apch & the acft stalled. Subsequently, the acft impacted on the rwy & was damaged beyond economical repair. The plt stated that he did not hear the stall warning sys; however, it operated normally during a post-crash check.Jun 27, 1985 · N3621X · DestroyedNTSB FTW85LA267Accident · Serious injuriesLimited investigationFinal reportCessna 172E · New Orleans, LAThe pilot stated the engine quit while he was being vectored for an approach to msy airport, New Orleans. He stated orally that he did not run out of fuel. A successful test run was made with adequate power for flight available. The cause of the engine power…Jun 27, 1985 · N888W · Substantial damageNTSB SEA85LA145Accident · Serious injuriesLimited investigationFinal reportCessna 310L · Albany, ORThe plt was attempting to bracket the low bar on the 2 bar VASI to avoid landing long on the rwy. On final, the acft landing gear struck unmarked powerlines. The acft then struck the ground in a level attitude. A small fire ensued in the left tip tank. The 4…Jun 25, 1985 · N222MR · Substantial damageNTSB ATL85LA196Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mt. Airy, NCWhile nearing completion of a solo x-country flt, the eng quit. The student plt selected an open area, but overshot the intended touchdown point & the acft crashed in the backyard of a single family dwelling. An investigation failed to disclose any system…Jun 25, 1985 · N2395G · Substantial damageNTSB SEA85LA144Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Orofino, IDDuring strong gusting winds the private plt was attempting to give dual instruction. During short final for rwy 27 and the wind from 270 at 8 to 12 knots gusting to 18 knots an approach stall was entered into a about 50 feet AGL. Although an attempted…Jun 23, 1985 · N25231 · Substantial damageNTSB MKC85FA137Accident · Serious injuriesField investigationFinal reportCessna 152 · Independence, MOStudent pilot and instructor were practicing pre-solo landings. When airplane was 30 feet AGL and on very short final approach, airplane dropped to ground, went through top of two dikes and two ditches, impacted bank of second ditch and flipped forward to…Jun 23, 1985 · N95496 · Substantial damageNTSB LAX85LA288Accident · Serious injuriesLimited investigationFinal reportStarduster II · Glendale, AZThe plt crossed the arpt at midfield and made a left turn for a close in downwind. Witnesses estimated that he made a 180 deg descending turn to final. While on final the plt observed another acft which was already on final slightly aheadand slightly below…Jun 23, 1985 · N17RM · DestroyedNTSB FTW85FA261Accident · 1 fatalField investigationFinal reportCessna 150 · Temple, TXA midair collision occurred between a Cessna 150 in the traffic pattern and a Cessna 152 on a long low final to the same runway. The Cessna 152'S radio was mistuned, and the Cessna 150 had no radio installed. Neither could have heard warnings broadcast by…Jun 23, 1985 · N8496J · 2 aircraft · Substantial damageNTSB DEN85FTM03Accident · 1 fatalFinal reportKillian Briegleb BG-12B · Heber City, UTThe acft was a george Killian/briegleb BG-12B, experimental, home built glider. An owner reported that the plt had come from new Mexico to buy the glider. After spending about 3 hrs in familiarization training, the plt went on his 1st flt which was…Jun 23, 1985 · N997 · DestroyedNTSB DEN85FTI04Accident · 1 fatalFinal reportFailing/Rand-Robinson KR-2 · Laurel, MTDrg a test flt, the plt made a fast taxi run, then took off on rwy 21. After takeoff, he made a gradual climb & shallow left turns to a downwind, circled the arpt & reentered a downwind for rwy 21. Witnesses reported that the plt made a power reduction &…Jun 22, 1985 · N8483Y · DestroyedNTSB NYC85LA153Accident · Minor injuriesLimited investigationFinal reportCessna R-182RG · Spring Valley, NYDuring the final approach to runway 25, the aircraft encountered a downdraft and began to descend, the pilot added power but but unable to recover prior to the aircraft contacting the trees.Jun 21, 1985 · N109MD · Substantial damageNTSB ANC85LA106Accident · No injuriesLimited investigationFinal reportPiper PA-18 · King Salmon, AKThe plt stated that he was making an apch to the arpt when the acft ran out of fuel. Subsequently, the acft crash landed about 1-1/2 mi nw of the arpt.Jun 21, 1985 · N3684Z · Substantial damageNTSB NYC85LA160Accident · No injuriesLimited investigationFinal reportCessna 182P · Newport, NHThe acft collided with trees during an attempted go-around following a loss of directional control. The plt was advised by UNICOM that a 'bit of a crosswind' existed at the arpt. The plt initiated a go-around after a gust of wind was misaligned the acft…Jun 19, 1985 · N9977E · Substantial damageNTSB NYC85FA152Accident · 1 fatalField investigationFinal reportSchempp-Hirth VENTUS-B · Waitsfield, VTThis glider was involved in a soaring championship course. About 52 minutes after starting the course witnesses observed the aircraft maneuvering for a landing on an open field. While in a steep bank the aircraft stalled and impacted the ground.Jun 19, 1985 · N240WT · DestroyedNTSB LAX85LA279Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Apple Valley, CAEng failed due to fuel exhaution while the acft was on final apch to rwy 18 at Apple Valley. A forced landing on rough terrain short of the rwy resulted in substantial damage to the acft.Jun 17, 1985 · N4382N · Substantial damageNTSB CHI85LA235Accident · No injuriesLimited investigationFinal reportBeech V35B · Boscobel, WIThe engine failed on final approach. The aircraft did not clear a wooded area resulting in an uncontrolled descent. The camshaft had failed at the number 1 journal oil groove.Jun 17, 1985 · N18382 · Substantial damageNTSB LAX85LA278Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Van Nuys, CAAn eng failue was experienced while on final apch to rwy 16R and the plt elected to make the forced landing on a sod farm near the arpt. He stated he had plenty of alt to reach the selected touchdown point, but he made a slight left turn to avoid large trees.…Jun 16, 1985 · N30738 · Substantial damageNTSB FTW85LA260Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Houston, TXThe pilot stated he first saw another aircraft ahead of and below him on final to the runway. He maneuvered to establish interval, then decided to go around. He added fullthrottles but left the flaps and gear down. Unalbe to climb,he decided to land behind…Jun 16, 1985 · N66887 · Substantial damageNTSB NYC85LA147Accident · No injuriesLimited investigationFinal reportCessna 210M · Linden, NJDuring the preflt inspection, the plt visually checked the fuel tanks and determined them to be full. The flt was made with the fuel selector on the left wing tank. During the apch to Linden arpt, the eng stopped operating. The plt attempted to restart the…Jun 15, 1985 · N732VU · Substantial damageNTSB LAX85FUG04Accident · Serious injuriesFinal reportBriegleb Amature Built BG-12-BD · Hemet, CAIn was reported that Mr. Campbell departed perris airport, perris, CA at approximately 1215 PDT. It is unknown in what area he was flying. Mr. Campbell was sighted a few minutes prior to attempting to land in a field near 36875 menlo street, Hemet, CA. A…Jun 15, 1985 · N2310B · DestroyedNTSB LAX85FA275Accident · Serious injuriesField investigationFinal reportCessna 31OQ · Chino, CAThe acft collided with the terrain following a total loss of power while circling for landing. The left fuel selector was in the auxiliary tank position and the right fuel selectorwas in the left main tank position. A limited quanity of fuel was drained from…Jun 14, 1985 · N7649Q · Substantial damageNTSB DEN85LA165Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Clearfield, UTThe plt/owner was receiving a cap check ride with an instructor plt & a passenger aboard the acft. The plt reported that during a simulated eng out excercise, the acft got within 200 ft of the ground when the insturctor 'gave me engine power back.' The acft…Jun 14, 1985 · N7259P · Substantial damage