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 ATL86FA001Accident · 2 fatalField investigationFinal reportCessna 172 · Chapel Hill, NCN2765U crashed shortly after making a low pass over a private air strip near Chapel Hill. The aircraft was seen in a nose high attitude prior to impacting a tree about 40 above the ground. The aircraft also collided with a power transmission line. The…Oct 1, 1985 · N2765U · DestroyedNTSB DEN85IA250Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Denver, CODuring gear extn for lndg, the flt crew noted a 'loud & very noticeable jolting of the acft.' Shortly thereafter, they also noticed that a portion of the right main gear had punctured the upper surface of the rgt wing. The crew then declared an emergency &…Sep 30, 1985 · N721PC · Minor damageNTSB ATL86LMG01Accident · No injuriesFinal reportCessna 310R · Rocky Mount, NCThe acft touched down 150 ft short of rwy 04 at the Rocky mountain-wilson arpt. The acft contacted two rows of apch lights and a ground drop off which sheared all three landing gears. The flt departed wilson municipal arpt and upon reaching 3700 ft the plt…Sep 30, 1985 · N1771G · Substantial damageNTSB NYC85LA254Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Preble, NYA Schweizer N33920, collided with a utility pole while executing a go around at Preble airport, NY. The acft was destroyed. The plt and passenger received minor injuries. The plt stated that the first two flights were uneventful, but noticed the stall speed…Sep 29, 1985 · N33920 · Substantial damageNTSB CHI85LA389Accident · No injuriesLimited investigationFinal reportDouglas Maselink XTC · Caledonia, MIThe acft struck power lines while on apch for landing. The plt stated that he did not see the power lines; however, witnesses reported they warned the plt of the electrical lines prior to the accident.Sep 29, 1985 · N5272M · Substantial damageNTSB NYC85LA253Accident · No injuriesLimited investigationFinal reportCessna C-170A · Marathon, NYDuring an approach to land on a 1600 ft private grass airstrip the plt noticed the acft was too high. The landing attempt was continued until the plt thought there would not be sufficient runway to stop the acft. A go around was initiated and the tail wheel…Sep 28, 1985 · N5709C · Substantial damageNTSB DEN85LA249Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Evanston, WYThe plt said the eng quit as he was turning from base leg to final apch for rwy 24 at Evanston (WY) arpt. The acft crashed as the plt maneuvered for an emerg landing. Disassembly and examination of the eng disclosed no reason on why the engine failed. The…Sep 27, 1985 · N5322U · No damageNTSB ATL85FA285Accident · 2 fatalField investigationFinal reportBeech A36 · Lafayette, GAThe acft crashed in a trailer parking lot after a steep left turn & uncontrolled descent. The acft impacted the ground in a nose low attitude. The rt wing had struck a parked trailer prior to the nose striking the ground. The acc occurred about 1/4 mile from…Sep 27, 1985 · N136BS · DestroyedNTSB ATL85LA284Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Holly Springs, MSThe stu plt on his fourth solo flt elected to make a touch-and-go lng prior to going to the practice area. After turning base on the closed VFR traffic pattern, he states that he could not find the runway and allosed the airspeed to decrease too low. When he…Sep 26, 1985 · N8760S · DestroyedNTSB ATL85FA283Accident · 1 fatalField investigationFinal reportBeech D18S · Huntington, WVThe acft contacted the terrain with the left wing tip, cartwheeled and came to rest inverted during an ILS rwy 12 apch at Huntington (hts). Minimum apch visibility for the ILS is 3/4 of a mile. While en route the plt was informed the hts visibility was 1/8 of…Sep 25, 1985 · N25Q · DestroyedNTSB ANC85MA183Accident · Minor injuriesMajor investigationFinal reportBoeing 737-2X6C · Unalaska, AKAcft was dispatched to rstrctd arpt with a 3900' rwy & notamed: 3' stndg wtr on north end of rwy. SIGMET was in effect for mod to svr turbc blo 10,000' due to strong low lvl wnd & assoc wndshear. Capt made a shallow ovrwtr apch to rwy 12, which had a nr vert…Sep 25, 1985 · N674MA · Substantial damageNTSB DCA85AA037Accident · 14 fatalFinal reportBeech B99 · Grottoes, VAAcft arr fm the NE, crossed ovr the arpt in IMC conds & contd twd the sw to the initial apch fix (iaf) for an ILS rwy 4 apch. The iaf was ovr the outer marker (om), 4.2 mi sw of the arpt. As the acft deptd the iaf, it contd outbnd twd the sw on an imprecise…Sep 23, 1985 · N339HA · DestroyedNTSB DEN85FA246Accident · 1 fatalField investigationFinal reportCessna 172R · Santa Rosa, NMThe student plt was on his first x-country. His last solo flt was approx two months prior to accident. Witnesses saw acft on a rt downwind for rwy 26. The plt was told a left traffic patter was in use. The acft was observed to be flying slow at a low alt, on…Sep 22, 1985 · N758UA · DestroyedNTSB ATL85MA282Accident · 2 fatalMajor investigationFinal reportGates Learjet 35A · Auburn, ALDrg arrival, the aircrew of a Gates lear jet 35A, N873LP, canceled their IFR clearance & contacted the Auburn UNICOM, then entered the traffic pattern to land on rwy 18. The UNICOM operator rprtd that the lear jet crew had rprtd their position on each portion…Sep 22, 1985 · N873LP · 2 aircraft · DestroyedNTSB ATL85LLT11Accident · No injuriesFinal reportCessna T210L · Elizabethton, TNDuring a dual instructional flt the eng stopped due to fuel starvation during a go-around. During the attempted restart, the instructor failed to switch fuel tanks. The acft touched down in a fld and ran into a wooded area which separated both wings from the…Sep 19, 1985 · N2045S · DestroyedNTSB NYC85LA242Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Ware, MAThe student plt and CFI were practicing full stop night landings when the accident occurred. While on final apch for thefourth landing, the acft collided with trees 1.7 NM short of the rwy.Sep 18, 1985 · N738SA · DestroyedNTSB CHI85FA379Accident · 1 fatalField investigationFinal reportGulfstream 500-S · Cloquet, MNThe pilot expected the weather to be below minimums but flew the approach anyway. He did not have a second pilot on board per company rules. The aircraft collided with trees about 3 miles from the approach end of runway 17.Sep 17, 1985 · N8139P · DestroyedNTSB DEN85LA242Accident · Minor injuriesLimited investigationFinal reportCessna 172 M · Wray, COThe student pilot was on her first solo flight. She stated that she was attempted her first landing and while on approach to the runway shw decided that it 'wasn't quite right.' She executed a go-around but the aircraft struck the ground and cartwheeled.Sep 16, 1985 · N61788 · Substantial damageNTSB NYC85LA235Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, CTWhile on the downwind leg for rwy 24, the instructor reduced power to idle for engine failure simulation. The student made a short approach and upon reaching 700 ft AGL the student headed directly toward the approach end of the rwy at a 30 deg angle from rwy…Sep 15, 1985 · N2387P · Substantial damageNTSB ATL85LA277Accident · No injuriesLimited investigationFinal reportPiper PA-22-125 · Shinnston, WVThe plt reported that he initiated a normal apch to land on rwy 27. However, when he flared, he failed to stop the descent. Subsequently, the acft landed hard just short of the rwy. During the landing, the nose gear collapsed & the acft nosed over.Sep 15, 1985 · N909A · Substantial damageNTSB CHI85LA378Accident · Minor injuriesLimited investigationFinal reportSchweizer 134 · Hampshire, ILThe pilot reportedly failed to use spoilers on final. The approach was high so he attempted a 180 degree turn at the departure end of the runway. The glider stalled and collided with the ground.Sep 14, 1985 · N7627 · Substantial damageNTSB MIA85FA253Accident · No injuriesField investigationFinal reportCessna 152 · Panama City, FLThe plt of 757 hm stated that he understood he was second to land so he processed to turn final unknowningly cutting off threeother acft on final apch to twy 05. The tower told him 'break left there is two acft on final', he applied power to go around and…Sep 13, 1985 · N4894B · 2 aircraft · Substantial damageNTSB LAX85LA389Accident · No injuriesLimited investigationFinal reportCessna 150E · Apple Valley, CAWhile practicing stop and go takeoffs and landings, the solo student plt flared too high on the second landing and lost directional control. The plt applied power to negotiate a go around. The nose ptiched up and the acft stalled. The acft contacted the gnd…Sep 11, 1985 · N3926U · Substantial damageNTSB SEA85LA209Accident · No injuriesLimited investigationFinal reportCessna 180 · Issaquah, WAThe acft landed nose down short of the rwy during a forced landing following fuel starvation. Investigation disclosed the main fuel line was blocked by pieces of the primer valve piston 'o' ring which had deteriorated due to the continuouuse of automotive…Sep 10, 1985 · N7694A · Substantial damageNTSB MIA85LA250Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLThe plt stated that while attempting a touch & go landing he lost control of the acft & landed in a muddy area on the north side of the rwy.Sep 9, 1985 · N25590 · Substantial damageNTSB LAX85LA386Accident · No injuriesLimited investigationFinal reportPeterson J-4 · Tucson, AZThe student pilot stated that he observed a tow airplane and a glider on the runway as he turned onto the final aproach to land. He said that he continued his approach and when the tow aircraft and glider failed to take off he attempted to turn off the…Sep 8, 1985 · N29899 · Substantial damageNTSB FTW85LA354Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26C · Rockdale, TXThe pilot observed and cleared serveral obstructions in the approach path of his intended landing area. However, he did not see one small and unmarked electrical power line until too late to take evasive action. This line was about 30 feet above ground level…Sep 8, 1985 · N126P · Substantial damageNTSB MIA85FA247Accident · No injuriesField investigationFinal reportCessna 150 · Pensacola, FLThe commercial plt & CFI departed from gulfport, ms on a night VFR x-country flt to gulf shores. Al. The flt landed at foley, al after the plt mistook foley for gulfshores 10 mi south. The flt departed again & was advised by ATC to fly a heading of 170 deg…Sep 7, 1985 · N6177K · 2 aircraft · Substantial damageNTSB SEA85LA207Accident · No injuriesLimited investigationFinal reportStolt-Adams Starduster SA101 · Yerington, NVWhile attempting to land the plt allowed the acft to become too low on short final. The plt did not add pwr soon enough and an undershoot occurred.Sep 4, 1985 · N3635G · Substantial damageNTSB DEN85LA237Accident · No injuriesLimited investigationFinal reportCessna 172P · Monument Valley, UTThe pilot said that during his approach to ldg he encountered a downdraft. He subsequently lost control of the a/c. the a/c stalled and impacted the grd hard causing subst damage.Sep 4, 1985 · N52456 · Substantial damageNTSB ATL85LA268Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Florence, SCThe plt was unable to extend the landing gear & performed a gear-up landing. Post accident examination revealed that the nose gear door was restricting the movement of the landing gear due to improper repair of the landing gear door attachment.Sep 4, 1985 · N7991P · Substantial damageNTSB LAX85LA379Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Glendale, AZThe stop at the airport was a planned fuel stop on a flt from conroe, TX to bullhead city, AZ. The flt departed controe,TX about 12 hours prior to the accident. Witnesses saw the acft make two 'high & very erratic' aborted approaches prior to impacting in the…Sep 3, 1985 · N9950B · Substantial damageNTSB CHI85LA367Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Blaine, MNThe one hour balloon sightseeing flight was uneventful. During his approach to land in a clear area he decided that his forward velocity was too high to land without hitting houses or powerlines below the balloon. According to him he burned fuel to attempt a…Sep 2, 1985 · N4196N · Substantial damageNTSB FTW85LA339Accident · Minor injuriesLimited investigationFinal reportCessna 150B · Drumright, OKThe pilot's landing approach was long and fast. The aircraft touched down but the pilot decided he would be unable to stop on the remaining runway and intiated a go-around. He then realized he would not be able to clear trees beyond the end of the runway. He…Sep 1, 1985 · N1257Y · DestroyedNTSB MKC85LA202Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Kahoka, MOThe plt stated that as he turned final, the airspeed increased and he could not slow down so the acft touched down fast. When he attempted a last minute go-around, the acft hit a concrete filled metal pole, went off the end of the rwy, across a street and…Aug 31, 1985 · N64264 · Substantial damageNTSB DEN85LA238Accident · No injuriesLimited investigationFinal reportCessna 182D · Monument Valley, UTThe pilot said that during app to ldg he encountered unfavorable winds in sheer or wind direction change causing the a/c to drop 4-5 ft onto the r/w resulting in substantial damage to the a/c.Aug 31, 1985 · N707UR · Substantial damageNTSB DEN85LA232Accident · No injuriesLimited investigationFinal reportCessna P210N · Hayden, COPlt said eng began surging during descent from curise alt. After adjusting boost pump, throttle, and mixture, surging ceased. Plt said he dropped flaps and lowered landing gear at 2000 ft AGL and 5 mi from arpt. Eng began to surge again. Adjustment of…Aug 31, 1985 · N4780K · Substantial damageNTSB DEN85LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Englewood, COThe pilot stated after the accident that he had approximately 1/2 full tanks of fuel when he departed the airport on a local night flight. He stated that he flew burning fuel from the left fuel tank. The pilot was returning to the airport after a flight of…Aug 31, 1985 · N5418F · Substantial damageNTSB ANC85LA167Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Cape Yakataga, AKThe plt elected to land on a sandy/gravel area about 600 ft long & 100 ft wide which was located between hills that were 100 to 150 ft high. During a x-wind apch, the acft's rate of descent began increasing. The plt applied full power to arrest the descent,…Aug 31, 1985 · N5188H · Substantial damageNTSB NYC85LA256Accident · No injuriesLimited investigationFinal reportSwearingen 226T · Hamilton, NYThe aircraft was on approach for landing at Hamilton, new york when the cross power levers were pulled back to flight idle. The left prop went into beta mode stalling the left wing at about 8 feet above the runway. The aircraft rolled about 20 degrees to the…Aug 30, 1985 · N92RC · Substantial damageNTSB NYC85LA229Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Danville, PADuring an apch, the acft was configured with full flaps & was trimmed for 65 KTS. At about 150 feet from the desired touchdown point, the plt reduced power to land. Momentarily after that, the stall warning horn sounded & the acft fell 10 to 20 ft, impacting…Aug 29, 1985 · N3319F · Substantial damageNTSB MIA85LA240Accident · No injuriesLimited investigationFinal reportCessna 310B · Hawthorne, FLWhile on a x-country flt the plt stated that the autoplt was erratic, hot and smoking. The plt further stated that he continued to use the autoplt. At about 1000 ft on final apch the autoplt failed for unknown reasons and the acft nosed down. The acft crashed…Aug 29, 1985 · N543GT · DestroyedNTSB CHI85LA366Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Germantown, OHOn return to the airfield, the acft lost pwr in the turn to final apch. The plt turned to an unprepared fld in order to avoid obstacles. During the landing roll the acft struck a fence post and fence. The plt stated the accident could have been avoided by…Aug 29, 1985 · N53982 · Substantial damageNTSB CHI85FEP03Accident · Serious injuriesFinal reportRoger W. Stigen EAA Biplane SR-1 · Sprimg Greem, WIEaa bi plane N3541, piloted by john boatright, and registered to freeborn county aircraft inc., albert lea, Minnesota, sustained substantial damage during a landing approach to runway 27 at the lone rock airport at approximately 1900 CDT on August 26, 1985.…Aug 27, 1985 · N3541 · DestroyedNTSB LAX85LA369Accident · No injuriesLimited investigationFinal reportCessna 152 · Grass Valley, CAAt the conclusion of a local solo instructional flt, the plt lost control during a go around attempt and crashed off the left side of the runway. While approaching the airport, the plt said the UNICOM advised the winds as light and variable. On short final…Aug 26, 1985 · N67488 · Substantial damageNTSB DCA85AA035Accident · 8 fatalFinal reportBeech 99 · Auburn, MEDrg arr, aprx 12 mi south of the final apch fix (faf), flt 1808 was clrd for an ILS rwy 4 apch. Aprx 3 min later, ATC controller (ctlr) noted acft was tracking east of the localizer (LOC) course. He asked if the flt was rcvg the ILS LOC. Capt replied 'not yet…Aug 26, 1985 · N300WP · DestroyedNTSB LAX85LA366Accident · Minor injuriesLimited investigationFinal reportPiper PA38-112 · San Martin, CAThe acft stalled & collided with the ground during an attempted go-around. The plt was a student on her 1st solo ftl. During the maneuver the flaps remained fully extended and the plt tried to turn rt at slow airspeed.Aug 25, 1985 · N25660 · Substantial damageNTSB LAX85FA368Accident · 2 fatalField investigationFinal reportDuce Project Bakeng Duce · St. Helena, CAAccording to witnesses, the plt had attempted a landing on the private ranch airstrip and a go around was performed. The acft then reversed direction and descended, striking a 6 foot high metal fence post before coming to rest. The acft was destroyed by post…Aug 25, 1985 · N113CP · DestroyedNTSB FTW85LA333Accident · Serious injuriesLimited investigationFinal reportCessna 305A · League City, TXThe plt, while setting up for an aerial banner tow pick up, failed to properly divide his attention between his flt duties and observing another acft which was also in the traffic pattern. He allowed the acft to stall without sufficientalt to recover before…Aug 25, 1985 · N6393T · DestroyedNTSB ATL85LKG11Accident · Minor injuriesFinal reportLet L-13 · Huntsville, ALThe commercial plt was in training for a glider rating & was on a supervised solo flt to practice a landing. During the traffic pattern, he rolled out hi on final & extended the spoilers to adjust to the desired glide path, then retracted the spoilers to the…Aug 24, 1985 · N99954 · Substantial damage