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 LAX85LA234Accident · No injuriesLimited investigationFinal reportCessna 182 · Parker, AZThe pilot stated that he encountered shifting winds on landing at his destination airport and that turbulence was severe. There is no record of a weather briefing prior to departure.Apr 30, 1985 · N2444R · Substantial damageNTSB LAX85FA232Accident · Serious injuriesField investigationFinal reportAero Commander Callair A-9A · Fremont, CAThe purpose of the local flight was to tow a glider aloft to a launch point. The pilot said he had no memory of the accident flight. Witnesses saw the aircraft make a go around form short final as a pedestrian walked across the runway approach end, and then…Apr 30, 1985 · N7713V · DestroyedNTSB FTW85FA204Accident · 1 fatalField investigationFinal reportHolder Midget Mustang I · Yukon, OKThe relatively low time pilot (99 total hours) had no recorded experience in high performance aircraft. He had just purchased the midget mustang and had practiced both low and high speed taxi runs on two occasions in the aircraft. He was observed to make one…Apr 30, 1985 · N66H · DestroyedNTSB NYC85LA113Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Pittstown, NJThe plt reported that he preflighted the acft & decided there was sufficient fuel to haul skydivers on 2 more flts. On the 2nd flt, he had to make three passes instead of one. During the apch to the arpt, the eng lost power from fuel exhaustion. The plt tried…Apr 28, 1985 · N5685B · Substantial damageNTSB MKC85LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Kingman, KSDuring a landing attempt, the acft was high and fast and subsequently touched down long. The plt attempted a go around with 40 degrees of flaps. The acft stalled and contacted the terrain one fourth mile past the end of the rwy, right wing first.Apr 28, 1985 · N79011 · DestroyedNTSB LAX85FA229Accident · 2 fatalField investigationFinal reportGreer Sidewinder "S" · Tracy, CAThe acft crashed short of rwy 25 at Tracy, CA, while on a night apch for landing. A ground witness observed the acfts lights descending straight down into a gravel pit. The acft impacted the ground in a 20 deg nose down, 15 deg left roll attitude. The rwy…Apr 28, 1985 · N9008X · DestroyedNTSB DEN85FTM01Accident · Minor injuriesFinal reportGamble Sonerai II · Salt Lake City, UTThe acft nosed over during a forced landing short of the rwy following a loss of pwr. The plt stated that after takeoff he noticed a rise in the cylinder head temperature. He attempted a landing and overshot the rwy. During the plt's second landing attempt,…Apr 28, 1985 · N922GG · Substantial damageNTSB LAX85LA224Accident · Minor injuriesLimited investigationFinal reportJack Boldt BD-5A · Madera, CAOn base leg, the acft's honda eng lost power. Unable to glide to the arpt, the plt made an emergency landing on an underlying alfalfa field. During the landing, he stalled the acft & landed hard. No preimpact part failure or malfunction was found.Apr 27, 1985 · N831SP · Substantial damageNTSB CHI85LA177Accident · No injuriesLimited investigationFinal reportCessna T210L · Minneapolis, MNAfter lowering the landing gear, the pilot heard a loud 'thump'. A gear down & locked indication was not obtained, however, the main gear appeared to be down to the pilot. Upon landing the acft swerved off the side of the runway. Only the right main gear was…Apr 27, 1985 · N29134 · Substantial damageNTSB LAX85LA221Accident · Minor injuriesLimited investigationFinal reportCessna TU-206G · Pinon, AZAt the conclusion of a cross country business flt, plt initiated a straight in approach after monitoring the wind conditions by observing a flag, which he reported as 'limp.' Plt reported that touchdown occurred at '50 knots' following a full flap approach at…Apr 25, 1985 · N4877U · Substantial damageNTSB BFO85LA040Accident · No injuriesLimited investigationFinal reportBeech E18S · Fishersville, VAWeather conditions in charlottesville, Virginia, the intended destination, resulted in a missed approach and diversion to shenandoah valley airport, where two more missed approaches were executed. On the climb out from the second missed approach, the left…Apr 25, 1985 · N67A · Substantial damageNTSB ANC85FA070Accident · No injuriesField investigationFinal reportCessna 336 · Anchorage, AKWitness near the crash site stated that both aircraft engines were stopped prior to the accident. The plt reported that before taking off, the fuel quantity gages indicated there was sufficient fuel for the flight, the plt did not preflightthe aircraft.…Apr 25, 1985 · N1716Z · Substantial damageNTSB MIA85FLD01Accident · Serious injuriesFinal reportCessna 172B · Brooksville, FLAccording to a plt statement, he entered the traffic pattern at about 800 ft & held 70 mph with 10 deg of flaps & the carb heat on. After turning onto final apch, he advanced the throttle for a power adjustment, but the eng did not respond. Subsequently, the…Apr 24, 1985 · N7846X · Substantial damageNTSB ANC85LA071Accident · No injuriesLimited investigationFinal reportCessna 180 · Willow, AKThe plt stated that the acft encountered a downdraft while he was on final apch for a touch-&-go landing. Subsequently, the acft touched down in wet snow about 30 yards short of the rwy & nosed over. The plt estimated the wind was from 010 deg at 5 KTS.Apr 22, 1985 · N5206E · Substantial damageNTSB NYC85FA110Accident · 2 fatalField investigationFinal reportCessna R182 · Hamilton Twnshp, NJThe plt's original destn was bader field at atlantic city. However, during arrival, he diverted to the atlantic city arpt, since bader field was below mins. Vectors were provided for an ILS rwy 13 apch & the plt was cleared for the apch. He was then cleared…Apr 21, 1985 · N4972S · DestroyedNTSB NYC85FA109Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · No. Hampton, NHOn April 20, 1985, a Piper PA-28-140, flown by a student plt, crashed during an attempted go-around at north Hampton, NH, while on a pleasure flt. The wx was clear, winds were light and variable with unlimited visibility. The tough rwy is 2050 ft long and 300…Apr 20, 1985 · N95043 · DestroyedNTSB FTW85LA189Accident · No injuriesLimited investigationFinal reportCessna A185F · Slidell, LAThe plt reported that during a water landing, the left float dragged, but he was able to 'pull it out' & started to add power to go around. However, he saw power lines ahead & realized that a go-around was not possible. He said he 'planted it back on the…Apr 20, 1985 · N93485 · Substantial damageNTSB CHI85MA169Accident · 7 fatalMajor investigationFinal reportCessna 310R · St James, MIDuring a night arrival, the plt reported that he had the arpt in sight & canceled his IFR flt plan. A witness saw the lights of the acft as it circled the destination arpt. He reported the acft had turned left to a southerly heading, & shortly thereafter, he…Apr 20, 1985 · N1334G · DestroyedNTSB CHI85LA168Accident · No injuriesLimited investigationFinal reportWheat Pitts S-1-S · Marlette, MI100 Yards from end of rwy on final apch plt lost rudder control. During landing roll as airspeed and aileron control effectiveness decreased the acft veered off the side of the rwy. The lower left wing contacted a VASI light. Inspection revealed right side…Apr 20, 1985 · N3FW · Substantial damageNTSB CHI85FEI02Accident · Serious injuriesFinal reportCessna 172F · Akron, OHThe acft contacted trees during a night forced landing following a loss of pwr. State patrol personnel reported there was no sign of fuel on board the acft at the accident site. The eng was test run after the accident, during which time it functioned normally.Apr 20, 1985 · N5608R · Substantial damageNTSB BFO85LA037Accident · Minor injuriesLimited investigationFinal reportSlingsby Type 43 Series 3F · Lovettsville, VAThe plt stated that he normally avoided landing on the rwy since the glider landed on a skid & it took a few minutes to remount it on a ground handling dolly. On this flt, he planned to land on the grass beside the apch end of the rwy. However, he allowed an…Apr 20, 1985 · N5563V · Substantial damageNTSB FTW85LA193Accident · No injuriesLimited investigationFinal reportCessna 210L · Midland, TXThe plt estimated that the duration of flt would be about 5 to 5-1/2 hrs & that he had aprx 7 hrs of fuel on board. However, the acft encountered head winds during the flt, & as it was approaching the destination, the eng lost power after aprx 6 hrs of flt.…Apr 19, 1985 · N93V · Substantial damageNTSB DEN85IA117Incident · No injuriesIncident investigationFinal reportHiller UH-12E · Broomfield, COPilot was taking FAA checkride for atp-rotocraft. Examiner requested autorotation demonstration with power recovery due to high gusty winds. Pilot said autorotation was normal until 75-100 ft AGL when rate of descent became excessive. Pilot said before he…Apr 17, 1985 · N7411N · Minor damageNTSB ATL85LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Southern Pines, NCThe acft stalled during a practice go-around attempt at a private airstrip. The plt stated that he applied full throttel after descending to about 20 ft above the rwy during the practice go-around. He stated that he then tried to push the carb heat control…Apr 17, 1985 · N52778 · DestroyedNTSB FTW85LA185Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Liberty, TXThe plt experienced an inflight partial loss of pwr after which he shut off the master switch, and the fuel valve and attempted to make a forced landing on a nearby arpt. However, there was insufficient alt to clear a powerline. A steep turn was made and the…Apr 16, 1985 · N80577 · Substantial damageNTSB NYC85LA095Accident · No injuriesLimited investigationFinal reportLet L-13 · Mansfield, MAThe plt reported that he turned onto final apch at about 500 ft AGL & the pattern was normal until he was about 1/3 mi from the rwy threshold. The glider then began to sink rapidly. The plt realized that he would be unable to glide to the rwy, so he decided…Apr 13, 1985 · N90862 · Substantial damageNTSB LAX85LA204Accident · No injuriesLimited investigationFinal reportCessna 172 · Page, AZThis was the return leg of a student plt solo x-country flt. On landing the acft stalled 15 ft above the rwy and the left wing contacted the rwy. The plt stated he was perhaps over confident in his flying ability.Apr 13, 1985 · N7245Q · Substantial damageNTSB CHI85LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Phillipsburg, OHDuring a night VFR approach to a strange airport the acft struck power lines located one-half mile from the end of the rwy. The plt stated that she was unaware of the wires & was not aware that her acft had collided with them until her forward progress was…Apr 13, 1985 · N55211 · Substantial damageNTSB CHI85FA158Accident · 1 fatalField investigationFinal reportCessna T210N · Ravenna, OHThe plt departed port columbus uneventfully, flew for aprx 40 mins then shot a VOR apch to the mda at portage county. This fld does not have a wx reporting facility. The plt then performed a missed apch upon reaching mda. During the missed apch and after…Apr 11, 1985 · N9596Y · DestroyedNTSB NYC85FA104Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · East Haddam, CTDuring approach to runway 14 pilot decided to go around. Aircraft turned left about 90 degrees and collided with rising terrain .2 NM east of the runway. The rising terrain parallels runway 14.Apr 10, 1985 · N55408 · DestroyedNTSB LAX85FA197Accident · Serious injuriesField investigationFinal reportCessna 177 · Fallbrook, CAAlthough aware of existing IMC conditions and reduced lighting with the setting of the sun, the plt attempted a visual apch to his home arpt which did not have an approved apch. His remarks to mcclellen-palomar twr, regarding the use of the on-board loran…Apr 10, 1985 · N2907X · DestroyedNTSB CHI85IA160Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Dayton, OHOn short final at an airspeed bet 120 and 125 KTS full flaps were lowered for landing. When the flaps reached the full down position, the stall warning horn came on and the stick pusher on the rosemont stall avoidance system activated. The captain disengaged…Apr 10, 1985 · N163MA · No damageNTSB SEA85LA088Accident · No injuriesLimited investigationFinal reportCessna 172M · Mulino, ORThe plt pushed the throttle forward to add power during final approach and the engine ceased operating. A forced landing was made onto a cabbage patch and the nose gear sheared off. The acft then nosed over. Investigation revealed the throttle cable housing…Apr 8, 1985 · N80241 · Substantial damageNTSB CHI85LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Port Huron, MIAfter a practice instrument apch, the plt (PIC) entered the traffic pattern to land on rwy 23. While in the pattern, theair became very turbulent. UNICOM reported the wind was from 270 deg at 20 gusting 35 KTS. On final apch with the flaps fully extended, the…Apr 7, 1985 · N2135A · Substantial damageNTSB CHI85LA154Accident · No injuriesLimited investigationFinal reportSmelko Cvjetkovic CA-65 · Ravenna, OHA forced landing was made in an open soft field after a total loss of power occurred while on final apch. The acft nosed over during the landing. The plt attempted to transfer fuel from the rear fuel tank to the empty front tank but did not have sufficient…Apr 7, 1985 · N3280 · Substantial damageNTSB NYC85FA099Accident · Serious injuriesField investigationFinal reportPiper PA-31-310 · Nantucket, MAAcft collided with trees during final approach to runway 24. No evidence of pre-impact failure or malfunction of the acft was found. Reported wx at crash site indefinite 100 feet sky obscured. RVR 2400 feet. Acft should have encountered a decreasing headwind…Apr 6, 1985 · N68DD · DestroyedNTSB FTW85LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Matagorda Is., TXThe pilot executed a VFR go-around while on final approach due to livestock on the runway and reportedly experienced engine power loss. The aircraft made a forced landing on the beach and flipped inverted, coming to rest in the water alongside the beach. The…Mar 31, 1985 · N3562X · DestroyedNTSB DEN85LA104Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Casper, WYBefore reaching the destination, the acft encountered turbulence & the passenger became ill. The plt tried to land on the east-west rwy, but the x-wind was too strong, so he then entered a pattern for rwy 3. After turning into the wind for a landing, the acft…Mar 31, 1985 · N2482K · DestroyedNTSB FTW85LA167Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Roanoke, TXThe aircraft's engine quit on downwind leg. Unable to glide to the rwy, a forced landing was performed on soft terrain off the apch end of the rwy. The left main gear collapsed in the soft terrain and the nose wheel broke off as the acft slid to a stop.…Mar 25, 1985 · N52690 · Substantial damageNTSB FTW85LA164Accident · No injuriesLimited investigationFinal reportCessna 172M · Angola, LAThe acft touched down short of the rwy following an approach to land after the plt had accomplished a x-country flt with a pass'g on board. The plt stated that he became momentarily disoriented due to haze & bright sunlight during the approach. During this…Mar 24, 1985 · N73616 · Substantial damageNTSB FTW85FA159Accident · 1 fatalField investigationFinal reportCessna 152 · Bixby, OKA flt school student working on his instructor rating made several low and slow approaches to an open fld. Witnesses saw the acft's nose pitch up slightly then drop. The acft rolled to the right and impacted the terrain in a steep dive. A witness stated the…Mar 23, 1985 · N757LV · DestroyedNTSB LAX85LA184Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Shafter, CAThe student plt was on his 1st supervised solo flt. He reported that on downwind, the acft was too hi, so he extended 10 deg of flaps. On base, he extended the flaps to 20 deg, & before turning onto final apch, he further extended them to 30 deg. The student…Mar 22, 1985 · N67001 · Substantial damageNTSB CHI85LA146Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Brighton, MIWhile attempting to execute a go-around with a 90 degree crosswind, velocity 16 kmph, gusting to 28 kmph, the acft apparently stalled just after becoming airborne. It impacted the ground about 300 feet west of the rwy. Witnesses stated that the acft appeared…Mar 21, 1985 · N2839Q · Substantial damageNTSB NYC85FNE01Accident · Serious injuriesFinal reportMarr/Eckburg Long EZE · Waterbury, CTThe acft crashed into an embankment short of rwy 36 after a loss of pwr on final approach. The plt said he was operating on the rt tank when the eng quit. He immediately awitched to the left tank and activated the boost pump. The prop had stopped and the acft…Mar 19, 1985 · N49EZ · Substantial damageNTSB FTW85LA155Accident · No injuriesLimited investigationFinal reportCessna 177 · Monroe, LAAprx 15 mins after departure, on final apch to Monroe regional arpt the eng lost pwr due to fuel exhaustion. During the forced landing the acft struck cable tv lines and trees causing a right yaw and uncontrolled descent to the ground. The student plt stated…Mar 19, 1985 · N2207Y · Substantial damageNTSB LAX85IA175Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · San Jose, CAA Piper seminule was vectored to the final apch course & cleared for an ILS apch at 3000FT MSL. A DC-9, in trail at 5000FT MSL, was overtaking the seminule. The controller elected to change their sequence & cleared the seminule to climb to 4000FT MSL due to…Mar 16, 1985 · N2138G · 2 aircraft · No damageNTSB ATL85LA121Accident · Minor injuriesLimited investigationFinal reportBell 47G · Erin, TNAfter a power loss at low alt. During approach to touchdown,the pilot bled off rotor RPM attempting to clear power lines across his approach path. This resulted in a lack of rotor energy necessary for an autorotaiton landing. A hard landing resulted.…Mar 16, 1985 · N73DB · Substantial damageNTSB ATL85LA119Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Tarboro, NCThe plt was attempting a simulated emergency landing on an ag airstrip & collided with several unmarked power lines while on final approach. The student plt was not authorized to land at the ag strip according to his flight instructor.Mar 16, 1985 · N2624J · Substantial damageNTSB MKC85LA072Accident · No injuriesLimited investigationFinal reportHughes 369HS · Princeton, MOThe helicopters tail rotor collided with power lines during an apch to an open field. According to the plt, upon descending onto the fld, the acft began to vibrate severely. Consequently, the plt lost control and the helicopter made two 360 degree revolutions…Mar 15, 1985 · N1040Z · Substantial damageNTSB DEN85LA094Accident · No injuriesLimited investigationFinal reportEnstrom F-28L · Salt Lake City, UTThe acft eng lost pwr on final apch at aprx 100 ft AGL. The tail boom was severed during the autorotational landing on soft ground. Post accident exam of the eng revealed that the left magneto point gap was excessively closed. During eng test run, when the…Mar 14, 1985 · N51671 · Substantial damage