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 MKC84FA084Accident · 1 fatalField investigationFinal reportPiper PA-31P · El Dorado, ARThe acft crashed into trees 2 miles short of the rwy during an instrument approach in IMC weather. A plt in the right front seat said that just prior to impact, the acft was descending at 2500 fpm, & when he looked ahead, he saw trees. Hesaid he yelled at the…Feb 26, 1984 · N33BP · DestroyedNTSB ATL84LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Alma, GAThe plt was on downwind and reduced power,he stated,before application of carburetor heat. The engine lost RPM and when the plt tried to regain RPM. The engine stopped. The plt said he tried to restart but failed and then made a forced off arpt landing. The…Feb 26, 1984 · N23JT · Substantial damageNTSB ATL84LA108Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Walterboro, SCThe plt did not get a green gear down indication when the landing gear was lowered. A fly-by was performed and he was told that the landing gear looked down. The plt did not properly operate the emergency system. During landing, the gear collapsed. The…Feb 26, 1984 · N6720P · Substantial damageNTSB NYC84FA092Accident · Minor injuriesField investigationFinal reportCessna 425 · Dryden, NYThe plt stated that he was utilizing the autopilot and flt director to execute the ILS appch to rwy 32. The autopilot was tracking the localizer while the pilot controlled the rate of descent along the glideslope with pitch command wheel on the autopilot,…Feb 25, 1984 · N6886D · DestroyedNTSB CHI84FA118Accident · 2 fatalField investigationFinal reportCessna 310K · Monticello, INAfter taking off, the acft was observed to climb to about 400 ft AGL, then enter a steep left bank. The acft then leveled off & rolled out on a downwind that was angling toward the rwy. On downwind, the aircrew transmitted that they were 'coming back.'…Feb 25, 1984 · N3805X · DestroyedNTSB NYC84FA090Accident · 1 fatalField investigationFinal reportBeech 76 · Beverly, MAA commercially rated plt (student) was receiving multi-eng training from an instructor plt (CFI). The student stated that on final apch to landing, he noticed the airspeed was slow when the CFI shut down the right eng by using the mixture control. The acft…Feb 22, 1984 · N60132 · DestroyedNTSB CHI84IA114Incident · No injuriesIncident investigationFinal reportBeech 99 · Champaign, ILThe plt reported that during arrival to the destination arpt, he heard a loud bang & the acft began rolling to the right. He reported that he was unable to control the roll with the ailerons, so he reduced power on the left eng & applied left rudder. The crew…Feb 22, 1984 · N313BA · Minor damageNTSB MKC84LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Mountain View, ARThe acft collided with trees during a forced landing after the engine lost power. The plt had taken off for a x-country without full fuel tanks. After the accident a mechanic found no useable fuel aboard the acft.Feb 21, 1984 · N3826L · Substantial damageNTSB SEA84FA058Accident · 3 fatalField investigationFinal reportPiper PA-28-J3A5D · Mountaindale, ORThe acft crashed during an instrument approach to hillsboro airport. Witnesses reported seeing the acft below a very low overcast sky condition prior to impact. Examination of the wreckage revealed that the stabilator failed in overload before the point of…Feb 20, 1984 · N83382 · DestroyedNTSB LAX84LA185Accident · No injuriesLimited investigationFinal reportCessna 310 · Tucson, AZThe acft was for sale & the plt, who represented himself as being qualified to fly it, was performing a pre-purchase flt. He reported that he initially felt uncomfortable flying this acft although he had prevously owned a Cessna 310. He was unfamiliar with…Feb 20, 1984 · N667R · Substantial damageNTSB LAX84FA183Accident · No injuriesField investigationFinal reportBeech A36 · Santa Monica, CAThe plt stated that after takeoff, the electrical sys failed as he retracted the gear. He elected to return to the arpt & land. Shortly thereafter, the eng lost power. He further stated that he hand cranked the gear to the down position & received a light…Feb 19, 1984 · N9876T · Substantial damageNTSB DEN84LA094Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Townsend, MTThe acft engine lost power on the base leg when the plt retarded the throttle. The plt landed on the rwy, but the acft started to veer to the right. The plt said he applied the brakes which did not seem to operate. Later, he said he may have had his feet on…Feb 18, 1984 · N1264W · Substantial damageNTSB ATL84MA101Accident · 4 fatalMajor investigationFinal reportBeech V35B · Charlottesville, VAWhile proceeding on an IFR flt plan, the plt requested he be assigned an alt below 8000 ft due to 'a passenger with an ear problem.' Otherwise, the en route portion of the flt proceeded without incident. During arrival, the plt was cleared for an ILS apch to…Feb 17, 1984 · N9353Q · DestroyedNTSB FTW84LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Acuff, TXThe CFI simulated an engine failure during flt at about 1000 ft AGL. When throttle was advanced the engine did not respond. The CFI made a forced landing in a plowed field and the acft nosed over in the soft furrowed dirt. An exam revealed no eng problems,…Feb 16, 1984 · N49126 · Substantial damageNTSB NYC84FGM02Accident · Minor injuriesFinal reportCessna 172P · New Castle, PAThe flt tookoff to practice touch and go landings with about 1/4 tank of fuel showing on the gauges. After bout 15 minutes of flt and one touch and go landing the plt turned to final approach and the engine quit. A forced landing was made 1 mile off the arpt.…Feb 15, 1984 · N64666 · Substantial damageNTSB MKC84FA077Accident · 2 fatalField investigationFinal reportCessna 414A · Mena, ARAcft cleared for Mena NDB apch and to maintain 5000 ft MSL until established on the apch. Acft descended to 4800 ft MSL on aprx grnd track of 040 to 030 deg after NDB passage. Acft then turned to a ground track of 116 deg. After 12 seconds the acft turned to…Feb 15, 1984 · N6815Z · Substantial damageNTSB ATL84LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Grove, VAThe acft collided with trees during an approach to land in IMC weather. The plt had taken off about 10 minutes earlier and when fog rolled in he tried to land. After one go-around he made a 2nd approach and descended to 75 ft AGL to obtainbetter visibility…Feb 12, 1984 · N5546F · DestroyedNTSB MIA84IA074Incident · No injuriesIncident investigationFinal reportBeech 95-A55 · Opa Locka, FLThe acft was intentionally landed with the landing gear retracted when the lt main gear could not be extended. Inspection of the acft revealed that the spring which pulls the lt main gear uplock out of the way when released had become disconnected from the…Feb 11, 1984 · N9707Y · Minor damageNTSB DEN84LA090Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Laramie, WYThe plt stated that when he was 10 miles southeast with airport lights in sight, a convair plt reported inbound on an IFR clearance to land. Not wanting to possibly cause the convair plt to make a missed approach he elected to make a turn. In the turn, he…Feb 11, 1984 · N7519D · Substantial damageNTSB DEN84FA089Accident · 2 fatalField investigationFinal reportBeech 58P · Durango, COWhen the plt called the fss at 1341 MST, he stated he had already received some 'real time' wx & requested only the wx at Durango & farmington, NM. He filed an IFR flt plan to Durango & took off at 1437. Drg arrival, the plt attempted to get into VFR…Feb 11, 1984 · N6400E · DestroyedNTSB NYC84LA139Accident · No injuriesLimited investigationFinal reportBalloon Works Fire FLY 6B · Butler, PADuring a descent to land, the plt of a Balloon tried to level off to reach a desired touch down point. The plt added heat, but the Balloon continued to descend. After a hard bounced landing, the Balloon began to ascend, but it collided with tree limbs & was…Feb 10, 1984 · N3738H · Substantial damageNTSB CHI84LA104Accident · Minor injuriesLimited investigationFinal reportBryan Dragon FLY · Vanolia, OHThe plt stated that after takeoff, while on downwind, the eng failed. He attempted to land back on the runway when the left wing struck the ground. The acft then struck a 55 gal concrete drum and a chain link fence. Examination of the acftrevealed that a…Feb 8, 1984 · N1711D · DestroyedNTSB LAX84LA166Accident · No injuriesLimited investigationFinal reportCessna 150M · Fremont, CAThe plt said he was doing a precautionary landing because he heard a 'pop' during a practice spin. During the landing the wing of the acft struck a tree. The acft was successfully flown back to the arpt and landed without further incident.Feb 5, 1984 · N3189V · Substantial damageNTSB LAX84LA165Accident · Serious injuriesLimited investigationFinal reportCessna 180J · Hayward, CADuring arrival, the plt had descended to stay below the tca & was approaching his destination when the eng lost power. He turned back toward the Hayward arpt, but was unable to reach it or restart the eng. During a forced landing at night, the acft was…Feb 5, 1984 · N52034 · Substantial damageNTSB MKC84LA070Accident · No injuriesLimited investigationFinal reportCessna 182 · Derby, KSDuring an apch from the south in gusty wind conditions, the acft crossed over wires & shrubbery with 20 deg of flaps. The plt reported that before reaching the rwy, the'lost air & descended straight down.' The acft touched down in mud, short of the rwy. The…Feb 4, 1984 · N6466A · Substantial damageNTSB MIA84FA072Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Hoboken, GAWhile on base leg for landing, the forward right wing strut failed causing the right wing to separate. The acft then entered an uncontrolled descent & crashed. The non-certificated plt owned the acft. He had not complied with airworthiness directive 77-03-08.…Feb 4, 1984 · N8771D · DestroyedNTSB LAX84FA164Accident · No injuriesField investigationFinal reportPiper PA-38-112 · Fullerton, CAThe acft engine lost power during a go around following a long power-off glide during which carburetor heat was not used. During the forced landing in a soft cultivated field the acft nose wheel' dug in' and the acft nosed over. The weatherreport indicated…Feb 4, 1984 · N91522 · Substantial damageNTSB CHI84LA102Accident · No injuriesLimited investigationFinal reportPiper Aerostar 602P · Bellaire, MIDuring the flare round out, 100 ft from the rwy at 10 ft AGL the acft stalled at 100 KIAS. Aprx 1/8 inch of ice was present on the airfoils. Moderate rhime ice was reported in the clouds along the route of flight. The plt did not activate the de-ice boots…Feb 3, 1984 · N6895D · Substantial damageNTSB CHI84LA101Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Lacon, ILThe plt was ferrying the acft to the Lacon arpt for winter storage. On final apch she touched down short & struck a snow bank on the apch end of the rwy. The plt stated that difficulty in depth perception due to the snow covered terrain resulted in touchdown…Feb 1, 1984 · N91469 · Substantial damageNTSB ATL84FA088Accident · 2 fatalField investigationFinal reportCessna P210N · Greensboro, NCDuring arrival, the plt was advised that the arpt wx had just changed to IFR. He was assigned an alt (2900 ft MSL) & provided a vector for an ILS apch. Shortly thereafter, the plt advised that he was 'having motor difficulty & needed to come straight-in.' He…Jan 30, 1984 · N4447F · DestroyedNTSB CHI84LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Greenville, ILThe plt received a weather briefing the night before the accident and did not have it updated on the day of the accident. The acft was descended below the mda during the approach in fog and collided with high tension lines.Jan 26, 1984 · N76AP · Substantial damageNTSB ATL84IA087Incident · No injuriesIncident investigationFinal reportBritish Aerospace 1-11 · Richmond, VAFlt 498, experienced a partial power loss on one eng during the final approach. Both plts stated that the eng spool down occurred moments after selecting tcc(top temp control). A eng runup of the acft failed to repeat the discrepancy & a precautionary change…Jan 26, 1984 · N1113J · No damageNTSB NYC84FA074Accident · 3 fatalField investigationFinal reportCessna P210N · Groton, CTThe acft was blown off course during a procedure turn for an ILS approach. The plt made a missed approach because of themisalignment and tried a non standard means of orientation for the 2nd attempt and intercepted the middle marker unexpectedly. Radar shows…Jan 25, 1984 · N900FE · DestroyedNTSB MKC84LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kennett, MOThe acft crashed in IMC weather after the engine lost power due to fuel exhaustion. The plt had received a briefing on the weather prior to departure. Post accident investigation revealed less than 2 gallons of fuel remained aboard the acft.Jan 25, 1984 · N78FR · DestroyedNTSB ATL84FLT02Accident · Serious injuriesFinal reportPiper PA-22-150 · Memphis, TNThe acft struck a powerline and crashed 1.5 mi south of Memphis airport while on a ILS localizer app to rwy 36R. The wx at the time of acc was ceiling 200 ft, visibility 3/4 mile with fog. The acft was equipped with a VOR localizer, but no glide sloop…Jan 25, 1984 · N46RS · Substantial damageNTSB CHI84LA092Accident · No injuriesLimited investigationFinal reportBeech B-19 · Crystal Lake, ILThe acft hit a snow bank during an approach for landing. The plt added power and made a go-around. The CFI took control of the acft and made the final landing when the main landing gear collapsed.Jan 22, 1984 · N173S · Substantial damageNTSB CHI84LA088Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Holman, WIAfter flying in the local area for aprx 40 minutes the plt decided to shoot a landing at an airpark before returning to his home arpt. The plt stated that he applied carb heat on the downwind leg and then returned it to off position. He flew the remainder of…Jan 18, 1984 · N9555T · Substantial damageNTSB CHI84LA087Accident · No injuriesLimited investigationFinal reportCessna 150L · Rock Falls, ILThe instructor plt stated that the student plt was flying the aircraft. While on final approach he advised the student plt to add engine power. The student did so very rapidly causing the engine to stall. Before the engine could be restarted the aircraft…Jan 18, 1984 · N10502 · Substantial damageNTSB ATL84FA084Accident · 4 fatalField investigationFinal reportRockwell 690B · Greenville, SCAs the plt was making an ILS approach in IMC weather, the acft descended into trees & crashed about 1-1/2 mi from the rwy threshold. The descision height for this approach was 1316 ft MSL & was located less than a mile from the threshold.a controller said…Jan 17, 1984 · N81717 · DestroyedNTSB ATL84FA083Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Attalla, ALDuring a VOR approach to land in IMC wx, the acft collided with a tree. The non-instrument rated plt had filed an IFR flt plan on this and other occasions even though he was not qualified. During this approach, the descent was continued past the mda of 960…Jan 16, 1984 · N31844 · DestroyedNTSB MIA84LA059Accident · Minor injuriesLimited investigationFinal reportCessna 411A · Gainsville, FLThe acft crashed while on a ILS approach to the Gainsville, airport. Investigation revealed that the plt had advised approach control that he was 'low on fuel.' After two missed approaches the plt radioed that he was 'out of fuel.' The plt did not have charts…Jan 12, 1984 · N4500Q · DestroyedNTSB LAX84IA153Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-30 · Los Angeles, CAAn aeromexico DC-9 encountered wake turbulence from a twa L-1011 on the approach to rwy 24L. The aeromexico acft was 6 miles (1 min & 10 sec) behind the twa acft & 800 ft below its glideslope at 6100 ft when the incident occurred.Jan 10, 1984 · XAAMF · No damageNTSB DEN84LA069Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Alamosa, COThe plt reported the wx deteriorated en route & he decided to land at a small arpt due to the fog & poor visibility. The arpt beacon was operating, but the rwy lights were not illuminated. During a 2nd apch, he encountered fog & started to go-around. The acft…Jan 10, 1984 · N3344F · Substantial damageNTSB CHI84LA082Accident · Minor injuriesLimited investigationFinal reportBeech BE-33A · Crystal, MNThe acft collided with trees and a residence near the destination airport after experiencing a total non-mechanical loss of power resulting from fuel starvation. The pilot reported he had estimated the fuel on board by a visual inspection of the tanks. This…Jan 10, 1984 · N32637 · Substantial damageNTSB MIA84LA057Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Eustis, FLThe plt stated that she attempted to make a low downwind turn to final from approximately 300 ft AGL and the acft encountered a roll effect over some pine trees on the west side of the rwy. The left wing tip struck the ground and pulled the nose into the…Jan 8, 1984 · N2521H · DestroyedNTSB ANC84LA029Accident · No injuriesLimited investigationFinal reportCessna 172RG · Big Lake, AKThe dual student and instructor were practicing emergency procedures. During the turn onto final approach the left main landing gear and left wing struck a snowbank. Flying club procedures state that no emergency practice procedure will be conducted below 500…Jan 7, 1984 · N4856V · Substantial damageNTSB DEN84FA065Accident · 1 fatalField investigationFinal reportCessna 320C · Provo, UTThe acft had been cleared for an ILS rwy 13 apch. A witness, located just north of the rwy, saw an acft pass overhead & stated that the acft was not an a correct apch. The acft then began heading west as if to circle for a 2nd apch. The witness also estimated…Jan 6, 1984 · N3037T · DestroyedNTSB SEA84IA033Incident · No injuriesIncident investigationFinal reportBoeing B-727-90C · Seattle, WAThe acft struck the approach lights to rwy 16R while on an ILS approach. Analysis of the FDR readout showed an increased descent rate following visual sighting of the rwy environment.Jan 5, 1984 · N766AS · Minor damageNTSB LAX84LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Sedona, AZThe acft landed short of the rwy during an emergency landing. The plt said the acft ran out of fuel about 1 mile from the arpt at 6200 ft MSL. He said he miscalculated the fuel consumption due to head winds.Jan 4, 1984 · N8300G · Substantial damageNTSB NYC84IA066Incident · No injuriesIncident investigationFinal reportLockheed 1329-25 · Teterboro, NJN322CS landed with the left main landing gear partially extended after emergency gear extention procedures failed. Investigation revealed the left actuator cover door & strut cover doors jammed where the two pass in close proximity during the gear extention…Jan 2, 1984 · N322CS · Minor damage