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 FTW87LA026Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe student plt noted a partial power loss while practicing multiple touch-and-go landings. She stated that after she had turned on a downwind, she heard 'a different sound' from the eng and it appeared to lose power. During an apch for an off arpt landing,…Dec 4, 1986 · N25532 · DestroyedNTSB MIA87FA041Accident · Serious injuriesField investigationFinal reportCessna 320 · Panama City, FLWhile executing an ILS approach with aircraft radios that were not operating properly and using a hand held transceiver, the right engine failed due to a broken fuel pressure sensor wire, and the pilot lost control of the aircraft in IMC conditions and…Dec 2, 1986 · N1FD · DestroyedNTSB FTW87LA024Accident · Serious injuriesLimited investigationFinal reportMooney M20D · Kerrville, TXThe pilot was unable to extend the landing gear in preparation for landing. Troubleshooting and several attempts to extend the gear failed. The pilot then made a 360 degree turn over the airport to lose altitude during which, he secured the engine and stopped…Dec 2, 1986 · N1970Y · Substantial damageNTSB CHI87FA040Accident · 4 fatalField investigationFinal reportMooney M20E · Hanna City, ILThe aircraft struck power lines and crashed two miles from the end of the runway on final approach ground track after being cleared for an ILS approach. The accident occurred at the end of a three leg cross-country flight from the Bahamas which began aprx 8…Dec 2, 1986 · N9210M · DestroyedNTSB LAX87DUJ01Accident · Minor injuriesFinal reportRobinson R-22 · Tucson, AZAfter 50 minutes of cruise flight, the pilot observed a decrease in oil pressure to zero and the illumination of the low oil pressure light. The pilot landed the helicopter and had an airframe and powerplant mechanic inspect the aircraft. There were no…Nov 30, 1986 · N9006W · DestroyedNTSB LAX87FA057Accident · No injuriesField investigationFinal reportCessna 172N · Santa Paula, CAA Cessna 172 & a Dehavilland gipsy moth collided at 150 ft. AGL while on short final approach to the uncontrolled arpt. On base leg the plt flying the moth failed to observe & yield the right of way to the Cessna which was already established on the final…Nov 28, 1986 · N2371E · 2 aircraft · Substantial damageNTSB LAX87MA052Accident · 4 fatalMajor investigationFinal reportBeech A36TC · Bakersfield, CAOn an instructional flt, the student plt & instructor (CFI) made an ILS low apch to rwy 30R. Drg a go-arnd (missed apch)a twr ctlr obsvd a 'light trace of smoke' emanating fm the eng exhaust. Shortly thereafter, the acft 'banked hard to the left and appeared…Nov 27, 1986 · N6750L · DestroyedNTSB NYC87FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Glen Mawr, PADrg arrival, the acft was vectored to intercept the ILS rwy 27 localizer (LOC) bfr reaching the munci initial apch fix (iaf), which was 21.5 mi fm the rwy. The ATC controller (ctlr) told the plt to maint 4000' until on the LOC, then clrd him for the apch.…Nov 26, 1986 · N8130A · DestroyedNTSB MIA87LA037Accident · No injuriesLimited investigationFinal reportCessna 182E · Chiefland, FLThe plt stated that he was on final apch & attempted to go around due to gusting winds. He applied power, the eng quit & he collided with the trees at the end of the rwy. No determination could be made as to the malfunction of the eng as described by the plt.Nov 26, 1986 · N2945Y · Substantial damageNTSB ATL87FA029Accident · 4 fatalField investigationFinal reportBeech 35-B33 · Winston-Salem, NCThe flt departed rochester, NY, and received and IFR clearance. The flt and ATC handling were normal. The plt was cleared for the ILS rwy 33 apch to Winston-Salem, NC. The flt was established on the final apch but collided with trees about 2 miles southeast…Nov 26, 1986 · N9592Y · DestroyedNTSB LAX87LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Fresno, CADuring a solo instructional cross-country flight the engine quit while on the base leg at the Fresno airport. The pilot did not feel that he could make the runway due to an extended downwind and low altitude. The pilot decided to try and land in a plowed…Nov 25, 1986 · N11185 · DestroyedNTSB BFO87DHD02Accident · No injuriesFinal reportHughes 369D · Newark, DEThe acft was being flown on a maintenance check flt. As the plt was returning to land, the eng lost power from fuel exhaustion. During an autorotative landing, the main rotor blades & tail boom were extensively damaged. The plt rprtd the fuel quantity gage…Nov 25, 1986 · N8670F · Substantial damageNTSB ANC87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Mcgrath, AKThe plt-in-command stated he was executing a shallow approach to runway 16 and prior to reaching the runway the engine stopped producing power. He further stated that during his descent he did not use any carburetor heat. The plt lost control of the airplane…Nov 24, 1986 · N23CP · Substantial damageNTSB MKC87LA024Accident · No injuriesLimited investigationFinal reportCessna 177XP · Camden, ARThe pilot stated he was on approach during IMC and had the airport in sight when he flew into another cloud and had started a missed approach when he collided with a tree. He completed the missed approach and diverted to monroe, LA.Nov 23, 1986 · N736UF · Substantial damageNTSB LAX87LA046Accident · Serious injuriesLimited investigationFinal reportGulfstream AA-5B · Fullerton, CAA Gulfstream American AA-5B lost power and collided with a tree short of the runway while on an IFR training flight. The flight instructor had just switched fuel tanks when the engine began to run rough and then quit running. He was unable to restart the…Nov 21, 1986 · N4520D · Substantial damageNTSB FTW87LA019Accident · Serious injuriesLimited investigationFinal reportCessna 337 · New Orleans, LADuring an instrument approach and the subsequent missed approach, both engines failed due to fuel starvation. It has been determined that as much as six gallons of fuel was contained in the auxillary tanks at the time of the accident but that none was…Nov 20, 1986 · N879SA · Substantial damageNTSB ATL87LA023Accident · No injuriesLimited investigationFinal reportHughes 269C · Eden, NCPilot related that he had placed the helicopter at triad for a 50 hour inspection. Aircraft reportedly defueled to dry tank. Six days later fuel truck log shows aircraft refueled with 23.2 gallons as payback. According to information furnished by owner and…Nov 19, 1986 · N9665F · Substantial damageNTSB CHI87LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bethalto, ILThe pilot attempted an ILS approach into an airfield (runway 29) that was reporting a zero foot obscured ceiling with 1/16 mile visibiltiy and fog. He stated that he became confused during the last portion of the approach and was beginning a missed approach…Nov 17, 1986 · N1631E · DestroyedNTSB ATL87FA021Accident · 2 fatalField investigationFinal reportCessna 210L · Buford, GAAccording to the operator, cylinders had recently been replaced on the eng & plts had been instructed to operate the eng at 75% power with the mixture richer than normal during a break-in period. On this flt, the plt took off with a full load of fuel. As he…Nov 17, 1986 · N2192S · Substantial damageNTSB NYC87LA040Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stormville, NYThe plt reported that during the landing apch, aprx 1/2 mile from touchdown, the acft descended below the visual glidepath. Recovery was attempted with the application of power, however, the acft mushed into a field short of the rwy. The acft rolled, struck a…Nov 16, 1986 · N93523 · Substantial damageNTSB NYC87LA034Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Jackman, METhe pilot attempted a landing on a runway marked with a x. the runway was closed because it had been extended and was very close to some powerlines. The pilot hit the power lines on final and the aircraft received substantial damage. The pilot was seriously…Nov 15, 1986 · N6863N · Substantial damageNTSB LAX87FA040Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Corona, CAThe plt of N621SR said that as he entered the pattern downwind he saw only one low wing acft which was just turning final for rwy 25. On short final the plt said he noticed the wing and cockpit of the other acft in his left side periphial vision one second…Nov 15, 1986 · N621SR · 2 aircraft · Substantial damageNTSB LAX87LA053Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Perris, CAA Schweizer sgs 2-33 glider collided with a drainage ditch after a forced landing two miles short of the airport. The glider lost lift and was unable to return to the airport due to power lines in the flight path. The pilot made a 180 degree turn and landed…Nov 9, 1986 · N50CS · Substantial damageNTSB LAX87LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Sun City, AZWhile on a solo instructional flight, the pilot was unable to find sufficient lift & decided to turn back toward the airport for landing. Due to his low altitude, he was not able to fly a normal pattern entry. A downwind landing was attempted; however, before…Nov 9, 1986 · N7558 · Substantial damageNTSB MKC87FA017Accident · 1 fatalField investigationFinal reportBeech E18S · Texarkana, ARThe airplane was on a positioning flight so it would be in place for an early Monday morning freight run. Pilot called for missed approach and after receiving clearance, declared he was in VFR conditions and thought he would land on rwy 31. During a turn, the…Nov 8, 1986 · N149AA · DestroyedNTSB MIA87LA028Accident · No injuriesLimited investigationFinal reportGlasair Glasair · Ft. Lauderdale, FLThe plt stated that while in the pattern, the engine started to run rough and then quit. He attempted to return to the runway, but the aircraft crashed into trees about one mile from the airport. No reason was found for the loss of power as described by the…Nov 8, 1986 · N3241W · Substantial damageNTSB ATL87FA017Accident · 1 fatalField investigationFinal reportCessna 210L · Montgomery, ALThe acft was flown for slightly less than 3 hrs on an instructional flt. The acft was reportedly nearly full of fuel before takeoff. Capacity is 89 gals. At max consumption of 22 gph the acft should have still had fuel available when the eng quit. During the…Nov 8, 1986 · N59034 · DestroyedNTSB LAX87DJA02Accident · No injuriesFinal reportCessna 172N · Honolulu, HIThe acft experienced a loss of engine power while descending during a practice instrument apch. The temperature was 81 degrees (f) with the dew point of 71 degrees (f). According to the icing probability chart, there is a possibility of serious carburetor…Nov 7, 1986 · N6184D · DestroyedNTSB DEN87FA017Accident · Serious injuriesField investigationFinal reportPiper PA-32-301T · Cheyenne, WYThe plt and his two pax were on a VFR x-country to scottsbluff, NE, when IMC was encountered near grand junction, CO. The plt then called ATC and obtained an IFR clearance. The plt elected to land at Cheyenne, WY. Wx was reported to be 500 overcast, 1/4 mi…Nov 7, 1986 · N8216V · Substantial damageNTSB MIA87LA023Accident · No injuriesLimited investigationFinal reportCessna 421C · Tampa, FLThe flt had been cleared for a visual approach behind a Lockheed L-1011 aircraft and was warned to use caution against wake turbulence. The flight encountered the wake turbulence of the L-1011 at 1600 feet. Control could not be maintained and the aircraft…Nov 6, 1986 · N37359 · Substantial damageNTSB LAX87LA033Accident · Minor injuriesLimited investigationFinal reportBeech K35 · San Diego, CAAt the end of a night cross country flight, the pilot attempted an instrument approach to the montgomery airport after being advised the weather was below basic VFR minimums. He was cleared for an ILS approach and reported that he had the runway in sight at…Nov 6, 1986 · N399WM · DestroyedNTSB DEN87FA016Accident · 1 fatalField investigationFinal reportCessna 421C · Butte, MTPlt was attempting the vor-b instrument apch to Butte, MT arpt. Plt reported over the coppertown VORTAC inbound on the arpt. The procedure turn inbound course to the VORTAC is 124 degrees. The inbound course to the arpt is 094 degrees. The acft wreckage was…Nov 6, 1986 · N421AR · DestroyedNTSB DCA87MA010Accident · 1 fatalClass 1 · MajorFinal reportPiper PA-23-150 · Tampa, FLAt aprx 0612 EST, an eastern airline capt (owner of Piper PA-23, N2185P) departed a rwy near his home in VFR conds to commute to work at Tampa, FL. Shortly after takeoff, he contacted a fss & updated the wx info he had obtained on the previous evening. At…Nov 6, 1986 · N2185P · 2 aircraft · DestroyedNTSB NYC87LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Haverhill, MAThe student plt was on an approved solo x-counrty flt when he became lost. He attempted a landing at an arpt 10 sm away from his arpt of intended landing. Realizing he was high on his first apch, he made a go-around. While making a 360 deg turn with full…Nov 3, 1986 · N49427 · Substantial damageNTSB LAX87LA032Accident · No injuriesLimited investigationFinal reportLearjet 24 · Lake Tahoe, CAAt the end of a cross country flight, the pilot experienced light to moderate turbulence on short final while executing a down wind approach to the Lake Tahoe airport. Approximately 50 feet AGL over the runway, the aircraft exited the turbulence and touched…Nov 2, 1986 · N711TJ · Substantial damageNTSB FTW87LA014Accident · No injuriesLimited investigationFinal reportCessna 150H · Portland, TXThe plt had initiated a go-around and was on a left crosswind when a loss of power occurred. A forced landing was made in 4 feet of water in the nueces bay. Post accident exam of the acft revealed both fuel tanks were empty.Nov 2, 1986 · N22968 · Substantial damageNTSB ATL87LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Winston-Salem, NCWhile conducting touch and go landings, N2373G lost power during a go-around. The flight was instructed to go-around due to another aircraft on runway 03. The pilot reversed his course toward runway 21. The aircraft crashed into trees short of runway 21.…Oct 31, 1986 · N2373G · Substantial damageNTSB CHI87DEM03Accident · No injuriesFinal reportRalley 3A · Gowen, MIThe pilot stated that the aircraft stalled while practicing an emergency landing. He also stated that he should have pulled up from the practice emergency procedure sooner.Oct 30, 1986 · N3782W · Substantial damageNTSB LAX87IA027Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Los Angeles, CADrg arr, united flt 282 (Boeing 727, N7255U) was vectored by Los Angeles (lax) TRACON for an ILS rwy 25L apch. While in a dscndg turn at 2100' MSL to intercept the ILS LOC at 2000', the capt saw a helicopter (hel) ahead & pulled up. He estdhis acft passed w/i…Oct 29, 1986 · N7255U · 2 aircraft · No damageNTSB DEN87LA010Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Richardton, NDThe plt attempted a landing on an unlighted dirt strip at dusk. He stated he intentionally flew low because it was getting dark. On final apch acft struck trees and then impacted the terrain, nosing over.Oct 27, 1986 · N9051H · Substantial damageNTSB BFO87FA004Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Mount Pleasant, MDThe acft was on the second apch attempt for ILS rwy 23 when the accident occurred- on the first attempt the pilot flew outbound instead of inbound on the localizer course. For the second attempt the pilot was cleared for a full apch for ILS rwy 23; which…Oct 26, 1986 · N4347X · DestroyedNTSB BFO87LA005Accident · Serious injuriesLimited investigationFinal reportRobinson R22B · Harborton, VADuring an apch to land, the plt expereinced a loss of tail rotor effectiveness and the acft rotated to the right. The airspeed was reported as 30 mph with a descent rate of 150 fpm and the acft was less than 50 ft AGL. The acft then descended to a collision…Oct 24, 1986 · N24684 · Substantial damageNTSB CHI87FA010Accident · Serious injuriesField investigationFinal reportBeech 58 · Chicago, ILThe pilot departed home base with an undetermined amount of available fuel, after being advised by the lineman/refueler of the uncertainty of the amount of fuel onboard. The pilot assumed the aircraft had been refueled the previous evening and departed on…Oct 23, 1986 · N7305R · DestroyedNTSB ATL87FA007Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Nashville, TNThe flight was cleared for the localizer approach to rwy 31. The pilot reported the airport in sight. The flight descended into the cloud layer and crashed about 1000 feet short of the middle marker. The pilot did not report any aircraft problem. The approach…Oct 20, 1986 · N5260F · DestroyedNTSB MKC87DCQ01Accident · 1 fatalFinal reportJames Olivier Quickie · Harper, KSA witness stated that he observed the aircraft in slow level flight at a low altitude. The a/c then pulled up in a steep right turn, then it descended to the ground. Examination of the wreckage found no pre-impact problems with engine or controls.Oct 19, 1986 · N3241N · DestroyedNTSB ATL87FA006Accident · No injuriesField investigationFinal reportCessna 140A · Hamilton, OHThe Cessna high wing was in the traffic pattern doing touch and go's and was on the third apch when the homebuilt biwing entered the traffic pattern. The homebuilt overtook the Cessna on short final. The collision occurred about 100-200 feet AGL. Both acft…Oct 19, 1986 · N9612A · 2 aircraft · Substantial damageNTSB ATL87DEG01Accident · No injuriesFinal reportCessna T210N · Cleves, OHThe plt reported that he initiated a go-around during an apch T0 a private strip. He stated that he misjudged the height of the acft and stalled it into trees and brush while climbing over rising terrain. He also said he was suffering from a cold and sinus…Oct 19, 1986 · N6567Y · Substantial damageNTSB MKC87IA007Incident · No injuriesIncident investigationFinal reportSwearingen SA-226-TC · Springfield, MODuring the approach, the right main landing gear would not extend by normal or emergency means. Airplane was intentionally landed with all landing gear retracted. Inspection indicated gear doors pulled closed farther than normal due to right main landing gear…Oct 17, 1986 · N251AM · Minor damageNTSB CHI87FA004Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Charleston, ILN8267W was on practice NDB approach to rwy 29 under ATC clrnc with hooded stu at controls in left seat, ip in right seat, proceeding level at mda for low pass. Evidence indicates N30019 had entered downwind for rwy 24 and was in left turn VFR approach for rwy…Oct 15, 1986 · N8267W · 2 aircraft · Substantial damageNTSB SEA87LA012Accident · Serious injuriesLimited investigationFinal reportLet L-13 · Boulder City, NVThe plt stated that a downdraft was encountered and an undershoot occurred while on base leg. A high sink rate developed and the plt did not take corrective action soon enough. The acft struck the ground, rolled a short distance through bushes, and across a…Oct 12, 1986 · N2NV · Minor damage