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 ATL85LA257Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Portland, TNThe plt made a visual aprch to the wrong airport & attempted to go-around. During the go-around the acft coll ided with trees on the departure end of the rwy.Aug 24, 1985 · N7369Y · Substantial damageNTSB DEN85LA228Accident · No injuriesLimited investigationFinal reportBeech V35B · Angel Fire, NMThe aircraft collided with the ground off to the side of the runway during a go around. The pilot had retracted the flaps and gear prior to ground contact. The pilot said he should not have retracted the flaps to the full up position.Aug 23, 1985 · N25AB · Substantial damageNTSB ATL85LA255Accident · No injuriesLimited investigationFinal reportCessna 172E · Villa Rica, GAThe plt took off from the stockmar arpt on a local flt. After flying in the local area, he returned at dusk to land, but inadvertently made an approach to another arpt that was located about 1/2 mi from the stockmar arpt. He did not realized that he was…Aug 22, 1985 · N8499U · Substantial damageNTSB LAX85LA359Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Jose, CAThe pilot stated he was on the downwind leg of the traffic pattern when the engine quit. He was unable to glide to the runway and landed in a construction area where the aircraft collided with a dirt pile and flipped over. He further stated that he had flown…Aug 21, 1985 · N6900S · Substantial damageNTSB ATL85LA253Accident · No injuriesLimited investigationFinal reportPiper PA-18S · Carlisle, MSAfter aprx 1 hr of LCL flt, the 67 hr pvt plt returned to his pvt grass strip for landing. He made a full left traffic pattern. At the 180 deg point, carb heat was applied and pwr reduced. After turning final and lowering full flaps, the plt added throttle…Aug 20, 1985 · N3267N · Substantial damageNTSB ANC85MA157Accident · 3 fatalMajor investigationFinal reportGates Learjet 24D · Gulkana, AKDuring a night arrival, the flt was on an instrument apch to the Gulkana arpt when radio contact with the acft was lost. A search was initiated & the wreckage was found 7.4 mi north of the terminal VOR on the 330 deg radial. The inbound course for the VOR rwy…Aug 20, 1985 · N455JA · DestroyedNTSB DEN85LA224Accident · No injuriesLimited investigationFinal reportCessna 172 M · Aurora, COThe student pilot stated that he was attempting to land on runway 14. He executed a go-around because the aircraft was not aligned with the runway. The pilot applied full power and raised the flaps. Because of the flap switch design, when the pilot put the…Aug 19, 1985 · N9880V · Substantial damageNTSB NYC85FHJ05Accident · No injuriesFinal reportMaule M-4-220C · Somers, NYThe acft stalled & nosed over during an attempted go-around after a fast approach to a gravel landing strip which was 5 miles from the planned destination. The plt said he added power to go around when he thought his airspeed was too high. The acft dropped on…Aug 17, 1985 · N40326 · DestroyedNTSB FTW85LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Llano, TXThe plt stated he entered the traffic pattern at 2000 ft for a left downwind to rwy 17. He then reduced pwr to 1700 RPM and placed the mixture control into the full rich position. He assured that carburetor heat was off and then started his descent. The eng…Aug 17, 1985 · N2217G · Substantial damageNTSB BFO85LIA01Accident · No injuriesFinal reportCessna U206 · Leesburg, VAThe acft was on a round-robin x-country flt from Leesburg to manassas, VA, gaithersburg, MD & return to Leesburg. When the plt departed gaithersburg on the final leg of the flt, he estimated he had 11 gal of fuel. He reported that during arrival at Leesburg,…Aug 16, 1985 · N7144Q · Substantial damageNTSB ATL85LA260Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Prestonburg, KYThe pilot stated that while on short final the aircraft encountered a down draft which caused a sudden loss of altitude resulting in a hard landing. The aircraft tire blew on landing and the aircraft veered off of the side of the runway and was substantially…Aug 15, 1985 · N9763Q · Substantial damageNTSB MIA85FA234Accident · Serious injuriesField investigationFinal reportCessna C-172M · Immokalee, FLThe acft had departed from the north-south oriented grass strip for a local flt and was returning to land toward the north. On short final the acft collided with an umarked power transmission line aprx 100 ft AGL and 0.25 mile south of the apch end of the…Aug 14, 1985 · N13750 · DestroyedNTSB BFO85FA067Accident · 2 fatalField investigationFinal reportBellanca 17-31A · Woodbridge, VAThe acft departed saratoga springs, NY, en route to manassas, VA. Wx was VFR and as the acft approached gaithersburg, MD, at 2132 LCL the plt contacted dulles apch for vectors through the area to manassas. The acft was issued a heading to manassas. Shortly…Aug 13, 1985 · N8242R · DestroyedNTSB MIA85FA233Accident · No injuriesField investigationFinal reportCessna C-150 · Kissimmee, FLThe acft collided with another acft at about 300 ft AGL during the aproach to a practice precision lndg. After the collision both acft landed saftely.Aug 12, 1985 · N704MH · 2 aircraft · Minor damageNTSB FTW85LA316Accident · No injuriesLimited investigationFinal reportCessna 150M · Mcallen, TXThe acft lost eng pwr while on downwind for rwy 12. The plt was cleared to land on any rwy and he chose rwy 36. (The south end of this rwy joins rwy 13 at midfield). However, a strong tail wind prevailed and the acft was high and fast. It touched down on rwy…Aug 12, 1985 · N714DM · Substantial damageNTSB NYC85LA206Accident · Serious injuriesLimited investigationFinal reportCessna C150 · Eliot, MEAircraft collided with trees when the aircraft stalled during an attempted go around. The student pilot was on his first solo supervised flight. On landing he came in long and prior to the wheels touching down, power was added. However during the climb, with…Aug 10, 1985 · N714NC · Substantial damageNTSB LAX85LA346Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Santa Paula, CAThe CFI, who was a retired airline captain, and his student pilot, embarked on a round-robin flight which included landings at four arpts. The fuel tanks were not completely filled prior to th initial departure and no additional fuel was obtained during the…Aug 9, 1985 · N3359V · Substantial damageNTSB CHI85LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILThe student plt stated that he began the flt with 13 gallons of fuel. Following 1 3/4 hrs in the traffic pattern he turned onto left base leg for a full-stop landing on rwy 09. At this point the eng began to lose pwr. He could not reach the rwy and performed…Aug 8, 1985 · N65619 · Substantial damageNTSB FTW85FA308Accident · No injuriesField investigationFinal reportFairchild Swearingen SA226TC · Dallas, TXThe aircraft sustained substantial damage when it landed with the gear up. The pilots reported lowering the gear, but did not confirm the gear position. The tower transmitted a warning, but the crew did not respond. Subsequent investigation revealed a…Aug 7, 1985 · N5356M · Substantial damageNTSB CHI85LA337Accident · No injuriesLimited investigationFinal reportCessna 402B · Moline, ILThe acft was landed on soft terrain 1500 ft short of the rwy following a total loss of pwr. The plt reported he failed to use fuel from the aux tanks during the flt and he exhausted the fuel in the main tanks. The fuel boost pumps are located in the main…Aug 7, 1985 · N100FG · Substantial damageNTSB ANC85LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-20-135 · Anchorage, AKLow time student plt lost control during attempted go-around & crashed into two parked acft. 8 to 12 kt crosswind was reported.Aug 7, 1985 · N7070K · Substantial damageNTSB FTW85LA305Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sand Springs, OKThe plt allowed the acft to get too low on the VFR final apch. He added pwr and stated a gust of wind tipped the acft tothe left. When he corrected for this the acft's nose dropped and the nose sheel contacted the ground and separated. The acft then nosed…Aug 5, 1985 · N47300 · DestroyedNTSB ANC85FA146Accident · 2 fatalField investigationFinal reportPiper PA-30 · Kodiak, AKDuring a wx briefing at 0719 adt, the plt was advised that VFR flt was not recommended. Later, at 0827. He called the fss to update his wx & filed an IFR clearance. At 0938, the acft departed anchorage. During arrival at Kodiak, the acft was cleared for an…Aug 5, 1985 · N7811Y · DestroyedNTSB NYC85LA198Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Quakertown, PAThe acft collided with wires during a lndg attempt. The acft was thrown out of control and dragged a wing after which it nosed over. The plt said that he thought the wires had been cleared. He was trying to put the acft right at the edge of the field because…Aug 3, 1985 · N92279 · Substantial damageNTSB FTW85LA294Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Port Isabel, TXThe acft was substantially damaged when it undershot the runway and cartwheeled during an emergency landing following an engine failure in the traffic pattern. The plt reported that initial examination of the engine revealed that initial examination of the…Aug 3, 1985 · N4434N · Substantial damageNTSB ATL85LA232Accident · No injuriesLimited investigationFinal reportCessna 150L · Hattiesburg, MSDuring a full-flap approach to landing, the pilot saw that the acft was going to land long and he initiated a go-around. He began retracting the flaps at the same time, and the acft started to settle. The pilot then elected to continue the landing straight…Aug 3, 1985 · N7952G · Substantial damageNTSB ATL85FA230Accident · No injuriesField investigationFinal reportCessna 210N · Chamblee, GAPlt had obtained check out in acft prior to departure on x-cflt. About 3.35 hrs into flt called atl ctr exp concern about fuel. At that time acft was about 4 mi w of rome ga VOR and about 15 mi from rome apt. Plt nor center were sure if fuel was avail at rome…Aug 3, 1985 · N6419N · Substantial damageNTSB DCA85AA031Accident · 135 fatalFinal reportLockheed L-1011-385-1 · Dallas/Ft Worth, TXThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-86/05. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Psbl…Aug 2, 1985 · N726DA · DestroyedNTSB NYC85LA210Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Stormville, NYAccording to the pilot, during the second touch and go landing, at abut 30 feet from touchdown, a wind gust lifted and veered the aircraft left of the runway centerline. The pilot attempted to go around applied full power; however, the left wing collided with…Aug 1, 1985 · N52503 · Substantial damageNTSB ANC85LA140Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Anchorage, AKWhile the plt was approaching a field to land, the wind shifted & gusted, blowing the Balloon toward a light standard. The envelope grazed the standard, ripping the material near the top of the Balloon. The Balloon then landed in the field. The wind was…Aug 1, 1985 · N7404X · Substantial damageNTSB LAX85LA335Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Kamuela, HIOn July 31, 1985, a Beech BE-23 operated by a student pilot, crashed during an attempted go-around at the waimea-kohala airport in Hawaii. The acft sustained substantial damage and the plt received minor injuries. The plt indicated he had not used full flaps…Jul 31, 1985 · N2354Z · Substantial damageNTSB ANC85LA141Accident · No injuriesLimited investigationFinal reportCessna 188 · Dry Creek Mine, AKThe plt reported that while on final apch aprx 100 ft from touchdown, the acft yawed to the left and the left wing dropped. The acft contacted the ground aprx 25 ft left of the rwy and nosed over.Jul 31, 1985 · N53135 · Substantial damageNTSB SEA85LA186Accident · Minor injuriesLimited investigationFinal reportCessna T210-L · Las Vegas, NVThe pilot failed to insure that adequate fuel was available for the flight. A visual inspection of the fuel in the fuel tanks was not done. To make matters worse landing was accomplished with gear down and flaps up-contrary to the recommended procedure for…Jul 30, 1985 · N15ES · DestroyedNTSB DEN85LA206Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Boulder, COAccording to the plt, he was approaching the Boulder municipal arpt, Boulder, Colorado, for a VFR landing when his engine failed to develop sufficient power to sustain flight. A forced landing was made to a farmer's field. The acft sustained substantial…Jul 30, 1985 · N5430Z · Substantial damageNTSB CHI85LA340Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Sharonville, OHAccording to the plt, the eng quit 4 hrs into the flt due to 'apparent fuel exhaustion.' He had entered the blue ash traffic pattern instead of going to his original destination because his fuel gages read 1/8 full instead of 1/4 full as he had expected. The…Jul 28, 1985 · N51405 · Substantial damageNTSB CHI85LA317Accident · No injuriesLimited investigationFinal reportStinson L-5 · Waynesville, OHThe plt took off on a test flt to check the eng after it had been inspected & the carburetor had been overhauled. He made a ground check & full eng run-up before taking off. Intending to stay in a closed traffic pattern, he took off, made a normal climb in…Jul 28, 1985 · N1156V · Substantial damageNTSB NYC85LA195Accident · No injuriesLimited investigationFinal reportCessna 182C · West Lebanon, METhe acft nosed over after overrunning the airstrip following a loss of pwr. The plt reported the eng began running rough and the application of carb heat did not increase the pwr. During the landing apch the eng began runnin rougher and about 1/2 of the…Jul 27, 1985 · N8951T · Substantial damageNTSB MKC85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Leon, IAThe plt reported that when he was on final apch to land, the acft encountered a downdraft & its rate of descent increased. He applied power to correct the situation, but the left main gear hit a fence post aprx 10 ft short of the rwy & failed. Subsequently,…Jul 27, 1985 · N8089C · Substantial damageNTSB SEA85LA176Accident · Minor injuriesLimited investigationFinal reportBeech A-24-R · Tuscarora, NVThe plt was attempting to land on a dirt road uphill at about 6,200 ft with gear and flaps down a go-around was attempted at about 50 ft AGL when the plt decided not to land. The acft failed to climb and a barn was struck before it hit the ground. The density…Jul 25, 1985 · N8026R · DestroyedNTSB ANC85LA133Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKPlt stated, '... On the go-around attempt I got behind the power curve & could not clear the trees. It stalled & turned to the left, hitting the trees about 15 ft off the ground which cushioned the fall & then slid down to the ground.' The plt was attempting…Jul 25, 1985 · N8688D · Substantial damageNTSB NYC85LA191Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Plymouth, MAThe aircraft was towed to an alt of 3000 ft. the plt set up for landing and entered the pattern at the initial point at about 1200 ft. the apch went normally until the base leg. After turning onto the base leg, the plt experienced a high sink rate. The plt…Jul 24, 1985 · N2039T · Substantial damageNTSB MIA85IA217Incident · No injuriesIncident investigationFinal reportCessna 402B · West Palm Beach, FLAircraft experienced unsafe right main gear indication several days prior to the incident. Mechanics found a damaged micro switch mounting plate which they repaired enough to hold until a new plate could be ordered and installed. On day of incident pilot…Jul 24, 1985 · N1554G · Minor damageNTSB DEN85LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bountiful, UTThe student plt departed the arpt to practice touch-&-go landings. On the 5th apch, the acft was observed to be low. The plt failed to add pwr and the acft contacted an arpt boundary fence.Jul 23, 1985 · N2203D · Substantial damageNTSB DEN85FA196Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 7 · Brighton, COA hot air Balloon owned and flown by the plt collided with electrical power lines during an attempted landing. The basket of the Balloon caught fire upon contact with the wires. The occupants leaped from the burning basket sustaining serious injuries. The…Jul 23, 1985 · N40501 · DestroyedNTSB CHI85LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Culver, INThe student plt was attempting his first solo landing and had difficulty correcting for the crosswind. When he was over the threshold, he initiated a go-around. The acft drifted to the left of the rwy and collided with trees 200 ft from the rwy centerline.…Jul 23, 1985 · N32858 · Substantial damageNTSB CHI85LA309Accident · No injuriesLimited investigationFinal reportCessna 150D · Lincoln, ILWhen the plt added pwr on final apch, the eng did not respond. An emergency landing was made in a rough fld. The relative humidity was aprx 60%. No mechanical failures/malfunctions were discovered during an eng examination.Jul 23, 1985 · N4460U · Substantial damageNTSB LAX85LA339Accident · Minor injuriesLimited investigationFinal reportCessna 310D · Kahului, HIOn July 22, 1985, a Cessna 3100, N6740T experienced a loss of engine power while on final approach to the Kahului arpt in maui, Hawaii. The ac sustained substantial damage and the plt received minor injuries. The ac has a fuel capacity of 90 gal useable. The…Jul 22, 1985 · N6740T · Substantial damageNTSB DEN85LA198Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Durango, COThe plt reported that prior to landing, the UNICOM operator reported that the wind was from the northwest at 10 to 20 KTS & was gusty. Also, he said that while on base leg, he encountered a severe downdraft. He stated that he applied pwr & retracted the flaps…Jul 22, 1985 · N3866H · Substantial damageNTSB CHI85LA308Accident · No injuriesLimited investigationFinal reportCessna 150M · Mt Pleasant, MIThe student plt was on a solo x-country flt between maple grove arpt & houghton lake arpt. During the flt, the plt requested radar assistance to locate houghton lake. Due to her solo student status & the close proximity of Mt Pleasant arpt, she was advised to…Jul 22, 1985 · N6350K · Substantial damageNTSB LAX85LUJ01Accident · Minor injuriesFinal reportAerotek Pitts S-1 · Page, AZThe acft contacted the ground during an attempted go-around. The plt had tried to perform a x-wind landing.Jul 21, 1985 · N1LM · Destroyed