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 FTW84LA285Accident · No injuriesLimited investigationFinal reportCessna T210N · Monahans, TXThe plt made several unsuccessfull downwind landing attempts. The last attempt was long & fast & upon go around, the acft struck the arpt boundry fence & came to rest 700 ft past the departure end of the rwy.Jun 25, 1984 · N5278Y · Substantial damageNTSB DCA84IA029Incident · No injuriesIncident investigationFinal reportBoeing 707-323C · Chicago, ILAbout 26 min before landing crew received SIGMET 1C advising of line of thunderstorms from milwaukee to st. louis movingse at 15 KTS. They also became aware of a thunderstorm west of arpt. At about 20 mi NE of arpt they could see the storm visually & on radar…Jun 24, 1984 · GSAIL · Minor damageNTSB ANC84LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-180 · Bear Creek, AKThe acft crashed into a river bank during an attempted go-around. The plt reported that upon initial touchdown the acft bounced and he applied full throttle. The engine reportedly responded with a maximum RPM of about 1600. The acft bouncedagain on the…Jun 24, 1984 · N5408Y · Substantial damageNTSB SEA84LA142Accident · No injuriesLimited investigationFinal reportCessna 150M · Fall City, WAThe plt was approaching a strange arpt with a rwy elevation of 140 ft and surrounding terrain of 1000 to 3000 ft. the plt said as he approached the threshold he felt the acft was too high so he executed a go-around. With the flaps at 20 degrees he said his…Jun 23, 1984 · N3184V · Substantial damageNTSB SEA84LA141Accident · No injuriesLimited investigationFinal reportCessna 207 · Anacortes, WAThe plt stated he added 10 degrees of flaps on downwind and applied full flaps on final. A rapid rate of descent was experienced 200 yards from touchdown. The pilot said he added power to arrest the sink rate. The acft collided with trees on final. The pilot…Jun 23, 1984 · N1755U · Substantial damageNTSB NYC84LA217Accident · No injuriesLimited investigationFinal reportCessna 50M · Middletown, PAThe solo student plt was approaching the rwy to make a landing when the twr gave him go-around instructions due to an shorts 3-30 acft on final. During the go-around the student said he encountered wake turbulence. The acft cartwheeled and came to rest with…Jun 22, 1984 · N704UL · DestroyedNTSB SEA84FU002Accident · 1 fatalFinal reportSorrell SNS-8 · Wenatchee, WAThe ultralight dove into the ground from 200 ft AGL with full power on. The plt had complained of chest pains and was under medication for dyspepsia. Some of the medicine was found in the operators auto. No evidence of pre-impact malfunction of acft or plt…Jun 19, 1984 · UNREG · DestroyedNTSB MKC84LA177Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7GC · Columbia, MOThe student plt was practicing emergency procedures during a solo flt. During a simulated forced landing apch to a field of tall fescue grass, he descended too low & the wheels encountered the grass which was 3 to 4 ft tall. The grass slowed the acft, it…Jun 19, 1984 · N4889E · Substantial damageNTSB MIA84LA187Accident · No injuriesLimited investigationFinal reportCessna 172E · Vero Beach, FLThe plt reported that the acft ran out of fuel & landed just short of the rwy. He said that the acft impacted palmettos on the rwy extension & the nose gear was torn off.Jun 18, 1984 · N5463T · Substantial damageNTSB DEN84LA200Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Stratford, SDAcft touched down short of apch end of rwy and collided with a fence which surrounds the private airstrip boundry. The plt stated too much alt was lost at slow speed on final.Jun 18, 1984 · N9389T · Substantial damageNTSB CHI84LA243Accident · Minor injuriesLimited investigationFinal reportCessna 152 · South Webster, OHThe plt selected a farm field with obstructions at each end to practice short field takeoffs and landings. He had previously walked the field to check for obstacles and to get the owners permission. He said that during his approach toland everything seemed…Jun 18, 1984 · N6273M · DestroyedNTSB ATL84LA202Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Hogdenville, KYAccording to the plt, during a low turn to final a power loss occurred. The acft landed short in a plowed field and nosed over. Examination of the engine revealed no mechanical malfunctions.Jun 18, 1984 · N82989 · No damageNTSB ANC84LA093Accident · Minor injuriesLimited investigationFinal reportCessna 182D · Tok, AKThe aircraft lost power while on final approach at 350 feet. The pilot changed course 90 degrees and crash landed in a church yard. No reason for the loss of power was found. However, the acft fuel tanks contained a mixture of 80-87 octane aviation fuel &…Jun 18, 1984 · N8798X · Substantial damageNTSB SEA84LA136Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Burns, ORDuring flt over a mountainous area, the plt became lost & called a flt service station. Subsequently, he was located & given vectors to the Burns arpt. However, the eng lost power from fuel exhaustion & the plt made a forced landing about 2 from the arpt.…Jun 17, 1984 · N49853 · Substantial damageNTSB MKC84LA173Accident · No injuriesLimited investigationFinal reportCessna 152 · Benton, KSWhile performing practice engine out procedures the student plt positioned the acft for a simulated landing to a wheat field. At practice alt the eng was shut down to simulate eng out flt characteristics. The eng was re-started & left in idle position. At…Jun 17, 1984 · N67711 · Substantial damageNTSB LAX84LA357Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Coalinga, CAThe plt was #2 behind another acft. He reported that he was so intent on the acft ahead (taxiing off the rwy) that he had decided to go around. He then changed his mind & decided to land instead. The acft touched down short of the rwy. He reported that during…Jun 17, 1984 · N74431 · Substantial damageNTSB CHI84LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Indianapolis, INPlt stated airspeed appeared too fast on final so a go-around was initiated. Power was advanced and plt raised the flaps which were full down. Plt stated, when flaps came up the acft started sinking and it settled into trees off the end of rwy. Plt stated…Jun 17, 1984 · N93023 · Substantial damageNTSB DEN84LA229Accident · No injuriesLimited investigationFinal reportCessna T-206 · Kalispell, MTThe pilot reported complete power loss while turning final. Attempts to restore pwr were unsuccessful and the aircraft was landed hard in the grass short of rwy. Investigation failed to reveal evidence of engine malfunction or failure.Jun 16, 1984 · N3985G · Substantial damageNTSB LAX84IA353Incident · No injuriesIncident investigationFinal reportPiper PA-32-300 · Chowchilla, CAThe acft collided with VASI lights during an unscheduled landing when plt became ill & according to the passengers became unconscious. The passenger, a non-plt, landed the acft. The plt was transported by ambulence to a nearby hospitalwhere doctors stated…Jun 15, 1984 · N32139 · Minor damageNTSB ATL84LA201Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Williamsburg, VAThe acft collided with a dirt mound during a go-around. The plt recalled that the wind was variable & gusty, but generally, the wind sock showed a x-wind of 30 to 90 degs. After bouncing on 1 wheel & then on another, the plt initiated a go-around. The acft…Jun 15, 1984 · N28812 · Substantial damageNTSB ANC84LA095Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Mccarthy, AKThe acft was equipped with a robertson stol modification. The owner/student plt stated that when he was on final apch to land at his private strip, the stall warning horn S0UNDED. At that time, he increased power & the acft turned sharply to the left & struck…Jun 14, 1984 · N714HP · Substantial damageNTSB DCA84AA028Accident · Minor injuriesFinal reportMcdonnell Douglas DC-9-31 · Detroit, MIDuring arrival, the aircrew (visually & by use of wx radar) noted thunderstorms (tstms) west & southwest of the arpt. The crew elected to continue & make an ILS apch. At 1636, a spcl wx obsn had tstm info, but was not noted. At 1650, the vis dropped to 1/4 mi…Jun 13, 1984 · N964VJ · Substantial damageNTSB MIA84LA183Accident · No injuriesLimited investigationFinal reportWilliam A. Waas Wizard T38 · Miami, FLWhile landing, the copilot, a commercial helicopter plt from venezuela, was at the controls. According to the pilot-in-command (PIC), they encountered turbulence & possible wind shear from air blowing over buildings, while on final apch. The PIC took control,…Jun 12, 1984 · N3962N · Substantial damageNTSB LAX84IA350Incident · No injuriesIncident investigationFinal reportBoeing 747-122 · San Francisco, CAJust inside the outer marker, a 'loud bang' was heard & left aileron input was needed to control acft heading. The landing was made without incident until the flaps were raised while taxiing & the flt engineer reported a #4 hydraulic system failure. The capt…Jun 12, 1984 · N4712U · Minor damageNTSB MIA84LA182Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ft. Lauderdale, FLPlt witnesses reported that the acft stalled during the final approach. The plt was not multi-end rated.Jun 11, 1984 · N29994 · Substantial damageNTSB DEN84LA177Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Granby, COThe helicopter plt was on a reconnaissance flt to survey a hilltop landing site in mountainous terrain. When he arrived, he made a high reconnaissance pass, then began a low reconnaissance apch. He estimated the wind was from 210 deg at 10 to 15 KTS with…Jun 11, 1984 · N504HA · Substantial damageNTSB CHI84LU005Accident · Serious injuriesFinal reportLycan Nomad II · Harrisburg, OHAccording to witnesses, the plt was on an apch to land in a field near his home when the ultralight vehicle's tailwheel caught onto a power line. The ultralight then crashed nose 1st into the terrain.Jun 11, 1984 · UNREG · Substantial damageNTSB SEA84LA127Accident · No injuriesLimited investigationFinal reportBreezy RLU-1A · Jean, NVThe acft departed on rwy 20 and turned crosswind at an alt of 200 ft AGL. The plt stated that after turning downwind for a non-standard traffic pattern at an airspeed of 60 to 65 mph the acft began to lose altitude. The acft continued the descent even though…Jun 10, 1984 · N3184 · Substantial damageNTSB CHI84LA235Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Wadsworth, OHThe acft touched down 200 ft short of the rwy after the engine lost power on the final approach. During landing the acftcollided with a creek embankment. The plt stated that while on final approach he applied carburetor heat and throttled back. When he…Jun 10, 1984 · N9882J · Substantial damageNTSB CHI84FA226Accident · 1 fatalField investigationFinal reportHiller UH-12E · Merrimac, WIThe acft crashed and burned after an in-flt explosion at about 75 ft AGL as the acft approached to land. The acft had experienced electrical problems of overheating generators and irregular voltage outputs on 2 previous occasions. The pltwas told after some…Jun 10, 1984 · N93431 · DestroyedNTSB FTW84LA269Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · San Antonio, TXAcft struck a marked transmission line on final apch. Plt could not maintain full control of acft on landing. Acft touched down rt wing low and a go-around was initiated. Upon application of pwr, acft went into trees off rt side of airstrip. Both plts stated…Jun 9, 1984 · N23413 · Substantial damageNTSB FTW84LA267Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2N · Sugarland, TXThe short flight from hobby to hull airport was conducted in VFR conditions. A visual approach was made to runway 17 at hull airport. The pilot reported that he was high on the approach path when he turned to the final approach heading. He reduced power to…Jun 9, 1984 · N850MA · Substantial damageNTSB FTW84LA266Accident · Minor injuriesLimited investigationFinal reportBell 212 · Milton, LAThe pilot had consumed alcohol in 2 different bars prior to the flt. He took the helicopter without authorization & departed with 2 passengers that he had met in a bar. He stated that he was returning to the arpt when he experienced an unusual oscillation in…Jun 9, 1984 · N1082G · Substantial damageNTSB CHI84FA225Accident · 1 fatalField investigationFinal reportSchleicher AS-K13 · Stanton, MNThe tow plane and the sailplane it had towed to pattern alt collided on final approach of the pattern. The tow plane was supposed to follow the sailplane to land after it had dropped the tow rope. There was a low sun glare facing the towplt on the heading of…Jun 9, 1984 · N3313 · 2 aircraft · DestroyedNTSB ANC84LA086Accident · No injuriesLimited investigationFinal reportDouglas C-118A · Deadhorse, AKThe acft struck a non-directional radio beacon tower while on an ILS DME rwy 05 instrument approach to the kuparak oil field airport. Investigation revealed that wx issued to the acft included an indefinate 200 ft sky obscured condition & visibility of 1 1/4…Jun 9, 1984 · N4206L · Substantial damageNTSB NYC84FA201Accident · 1 fatalField investigationFinal reportCessna 172P · Haverhill, MAWitnesses observed the acft on a high final apch to rwy 05 when a go-around was initiated over the rwy at aprx 50 ft AGL with the flaps fully extended. The acft climbed to aprx 100 ft AGL & then suddenly entered a stall, descended to the ground & crashed. The…Jun 6, 1984 · N65491 · DestroyedNTSB DCA84AA027Accident · 3 fatalFinal reportLearjet 23A · Windsor Locks, CTAccording to witnesses, the acft made a normal apch to rwy 33 with no apparent abnormalities. However, when it was about 200 ft over the apch lights, they heard an increase in the eng thrust & the acft's descent stopped. Two plt witnesses thought the aircrew…Jun 5, 1984 · N101PP · DestroyedNTSB SEA84LA124Accident · No injuriesLimited investigationFinal reportCessna 206 · Yakutat, AKThe plt elected to land on a gravel road that was surrounded by brush with a quartering headwind aprx 30 deg from his left. While on final apch, a rapid rate of descent developed. Subsequently, the left wing tip contacted a tree top & the acft yawed to the…Jun 4, 1984 · N7418Q · Substantial damageNTSB SEA84FA123Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · North Bend, ORThe acft was cleared for an ILS rwy 4 apch while 9 miles north of oth (North Bend) VOR. Instructions were given to cross oth VOR at or above 3700 ft MSL. 14 min later, the plt reported to North Bend fss 'my needle doesn't seem to be moving on my localizer…Jun 4, 1984 · N1067U · DestroyedNTSB NYC84FGT02Accident · No injuriesFinal reportBell 47G-3 · Landisburg, PAThe helicopter lost eng power while turning on approach for landing, autorotated to a hard landing with main rotor contact to the tail boom. Two gals of fuel were drained from the acft fuel tank at the accident site. An eng run up was performed & found…Jun 4, 1984 · N49882 · Substantial damageNTSB CHI84LA217Accident · No injuriesLimited investigationFinal reportCessna 172M · Mt. Pleasant, MIThe student plt was in the traffic pattern practicing touch-&-go landings when the eng lost power. He suspected a carburetor problem because of recent problems. He used the primer, at which time the engine responded momentarily. Subsequent, the plt made a…Jun 4, 1984 · N9801V · Substantial damageNTSB FTW84FA264Accident · 2 fatalField investigationFinal reportCessna A185F · Houma, LAPlt was returning to home base of operations, executing standard visual approach along intercoastal waterway on westerly base heading prior to turn on final. Acft collided with overhead ground wires of power transmission array spanning the waterway at an…Jun 3, 1984 · N4665E · DestroyedNTSB NYC84LA195Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Saratoga, NYGlider was on final approach in severe turblence. Acft drifted on final apch and plt used full control deflection with no effect. A collision with trees resulted. The plt said that the wind before takeoff was greater then 30 KTS from 360 degrees. The apch was…Jun 2, 1984 · N5708S · Substantial damageNTSB MKC84LA160Accident · No injuriesLimited investigationFinal reportCessna 188 · Mcgehee, ARThe acft ran out of fuel during an approach to the arpt & landed short of the strip. During the landing, the left main gear collapsed. The plt thought he had about 8 gal of fuel remaining.Jun 1, 1984 · N4816R · Substantial damageNTSB MKC84LA150Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Morrilton, AROn short final the plt advanced the throttle to maintain alt but the engine failed to respond. Power remained at idle RPM and the acft landed short of the rwy. On touchdown the landing gear sank in the soft ground and all three gears were broken off.…May 28, 1984 · N1045J · Substantial damageNTSB LAX84LA327Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS1-26D · Lucerne Valley, CAThe plt reported that his glider was the 3rd to launch (using an auto tow) on a distance completion flt. He released the tow cable at about 900 ft & began searching for lift. No lift was found. After a short time, he attempted to return to the departure…May 28, 1984 · N7710S · Substantial damageNTSB LAX84FA319Accident · 2 fatalField investigationFinal reportCessna 152 · Half Moon Bay, CAThe two acft collided after N1920Y declared his intention to takeoff and was airborne aprx Half way down the rwy. The other acft was in a steep descent at mid-field when he dove into N1920Y. Both acft then crashed uncontrolled into the ground from an alt of…May 28, 1984 · N5157B · 2 aircraft · DestroyedNTSB FTW84LA247Accident · No injuriesLimited investigationFinal reportGermany Wetherell Sonerai I · Leander, TXPrior to the flight the plt adjusted the carburetor. A local flight was made to test the carburator. During the gliding apch to the rwy the plt noticed the eng idle power was 1400 RPM. While on base leg the plt advanced the throttle, however, eng pwr remained…May 28, 1984 · N92CL · Substantial damageNTSB CHI84LA215Accident · Serious injuriesLimited investigationFinal reportIstenes Oldfield Baby Lakes · Middlefield, OHIt was reported that the acft had performed two tight left traffic pattern turns after takeoff. On the downwind turn the acft banked 60 degrees. The plt lost control of the acft and crashed in a wooded area. It was reported that the plt had no previous…May 27, 1984 · N120R · DestroyedNTSB ATL84FIJ02Accident · Serious injuriesFinal reportTaylorcraft F-19 · Middlebourne, WVAfter returning to the arpt, the plt made an apch to rwy 10, which had a drop-off on the apch end. The winds were reported as variable & occasionally gusty. On the 1st apch, the acft encounter 'slight air turbulence' & the plt elected to go around. He stated…May 27, 1984 · N2001K · Substantial damage