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 MKC85LA130Accident · No injuriesLimited investigationFinal reportCessna 172M · Bingham, NEThe plt reports that the acft began to settle while on final apch for landing. Full power was applied but the acft continued to settle. The acft hit nose gear collapsed and the acft nosed over. The plt had flown 11 hrs since receiving private plt certificate…Jun 13, 1985 · N80747 · Substantial damageNTSB FTW85LA253Accident · Serious injuriesLimited investigationFinal reportBeech 95 · New Braunfels, TXThe instructer pilot and student single engine rated pilot were practicing single eng full stop landings. The acft was on final apch with the right eng shut down and the prop feathered. A vehicle was observed near the rwy. The instructor directed a go-around.…Jun 13, 1985 · N2091C · Substantial damageNTSB CHI85FA229Accident · 1 fatalField investigationFinal reportLuscombe 8A · Jeffersonville, OHThe airplane had circled the north-south grass runway twice before attempting a south landing with an estimated 20 to 30 mph crosswind from the west. The airplane staled and made a 360 degree roll. The pilot was unable to recover and the aircraft struck the…Jun 13, 1985 · N23004 · DestroyedNTSB ATL85LA184Accident · No injuriesLimited investigationFinal reportCessna T337G · Knoxville, TNThe acft made an emergency gear up landing when both the normal and emergency extension systems failed to function properly. A mechanic was later able to extend the gear with the acft on jacks by repeatedly cycling the selector switch. It was determined that…Jun 12, 1985 · N30S · Substantial damageNTSB MKC85IA131Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · St. Louis, MOWhile on an IFR approach to land at stl and the plt initiated flaps. The no.3 outboard flap vane separated from its mounting and fell to the ground. Upon separation the flap vane struck the leading edge of the trailing edge flap knocking a hole in the skin.…Jun 11, 1985 · N31013 · Minor damageNTSB NYC85FA141Accident · 2 fatalField investigationFinal reportBeech BE-200 · Hamptonburgh, NYPlt filed IFR for 2 flight legs; baltimore, MD to teterboro, NJ & teterboro to montgomert, NY (orange co arpt). The plt received a preflight wx briefing & was advised that the forecast for stewart, NY, about 10 mis form montgomery was sky partially obscured…Jun 9, 1985 · N148CP · DestroyedNTSB FTW85LA250Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dallas, TXThe plt filed and flt planned for an overwater route between clearwater, FL, and Dallas, TX, which was denied due to ATC restrictions. On arrival over new orleans, a planned re-fueling stop, the plt determined that he would make it to Dallas. On arrival in…Jun 9, 1985 · N7697L · Substantial damageNTSB DEN85LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Los Almos, NMThe plt was making an apch to rwy 27 at the los alamos muni arpt in gusty x-wind conditions. The arpt was located atop a mesa & rwy 27 had a 1.5% uphill rwy gradient. The plt said he selected 2 notches (25 deg) of flaps. The winds were reported to be from 210…Jun 9, 1985 · N8651C · Substantial damageNTSB CHI85LA231Accident · Serious injuriesLimited investigationFinal reportJenkins HP-18 · Wellington, OHFollowing an aprx one-half hour flt, witnesses stated that the glider did not appear to flare for landing, but instead, impacted the ground without arresting the rate of descent. The plt eported he had very poor ventilation in the cockpit and feels that he…Jun 8, 1985 · N8036X · Substantial damageNTSB CHI85LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Osceola, WIThe solo student plt attempted to land the acft with an aprx 90 deg x-wind of 24 KTS gusting to 32 KTS. Feeling unsure of the conditions on his first apch, he decided to make a go around. This he successfully accomplished. On his second attempt, he was able…Jun 8, 1985 · N1644P · Substantial damageNTSB LAX85LA267Accident · No injuriesLimited investigationFinal reportCessna 152 · Compton, CADuring a dual instructional flt, in preparation for the student's private plt flt exam, the instructor plt failed to confirm that adequte fuel was on board. Despite the fact that the fuel gauges were indicating nearly empty, the instructor plt permitted her…Jun 7, 1985 · N4874H · Substantial damageNTSB CHI85LA233Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Frankenmuth, MIDuring the approach power was added & the aircraft was observed to bounce after touchdown. The acft entered a left turn & from about 50 ft AGL was observed to collide with the ground in a nose down attitude. The flaps were found in the down position.Jun 7, 1985 · N5347Q · DestroyedNTSB ATL85IA180Incident · No injuriesIncident investigationFinal reportFairchild Swearingen SA226TC · Cherry Point, NCDuring an appch for ldg at new bern NC, the crew was unable to get the right main ldg gear to extend. Ground observers reported that the right gear door was partially open. The crew elected to divert the commuter air carrier flt. To mcas Cherry Point where…Jun 5, 1985 · N1007W · Minor damageNTSB SEA85LA115Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCB · Yakutat, AKDuring arrival, the plt extended his traffic pattern to allow another acft to depart. He reported that after he turned on final apch, his acft encountered a downdraft & hit the ground short of the rwy.Jun 2, 1985 · N3JK · Substantial damageNTSB ATL85LA178Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSPlt was returning to arpt with known low fuel state. The planned landing was to be on rwy 18 but while approaching the arpt, the eng missed. The plt elected to land on rwy 36 with a tailwind and conflicting traffic. The conflicting traffic cleared the rwy and…Jun 2, 1985 · N49995 · Substantial damageNTSB NYC85FNA01Accident · Serious injuriesFinal reportGulfstream AA-5B · Boxborough, MAThe pilot made six attempts at landing with a left crosswind of 24 knots. On the last attempt he was observed to lose control and crash into the trees off he departure end of the runway. The aircraft burnded and the pilot received serious injuries.Jun 1, 1985 · N4523B · DestroyedNTSB MKC85LA118Accident · No injuriesLimited investigationFinal reportEagle DW1-0062 · Mcpherson, KSDuring a go-around attempt the plt who was landing at the harrison airport encountered turbulent wind condition. The plt stated the acft stalled and dropped into a field off the side of the rwy. Strong wind conditions were forecast fro the area of landing.May 31, 1985 · N8810B · Substantial damageNTSB MKC85LA117Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Harrison, NEThe acft stalled during an attempted go-around. The plt initiated the go-around while attempting to land on rwy 30 with winds from 270 degs at 40 KTS gusting to 60 KTS. The acft stalled, contacted the rwy and veered left off the rwy surface. The plt received…May 30, 1985 · N71407 · Substantial damageNTSB MIA85LA181Accident · No injuriesLimited investigationFinal reportCessna 182 · St. Marys, GAThe plt stated that he established a normal apch over the trees to the 2000 ft dry sod rwy. After clearing the trees, a high sink rate developed which was not arrested until the acft impacted the rwy on all three wheels, slid 66 ft, then nosed over. The plt…May 30, 1985 · N21211 · DestroyedNTSB CHI85IA212Incident · No injuriesIncident investigationFinal reportBoeing 727-023 · Chicago, ILAmerican airlines flt 57 had departed baltimore for Chicago. On final approach at ohare the crew discovered the nose gear would not extend. The fe made three attempts to crank down the gear all of which were unsucessful. After landing with nose gear up all…May 28, 1985 · N1984 · Minor damageNTSB CHI85LA214Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Marshall, MIThe student became disoriented at one of his check points on a x-county flt. With assistance from fss and approach control he arrived at his destination. The student, however, selected the rwy with a tailwind component & was unable to land after two…May 26, 1985 · N18066 · Substantial damageNTSB CHI85FA213Accident · Serious injuriesField investigationFinal reportHughes 369E · Indianapolis, INAs the helicopter was on downwind for the heliport, the plt experienced an pwr interruption and eventually a eng failure. He was attempting an autorotation to railroad tracks when he saw wires. He managed to miss the wires but by doing so he expended the…May 25, 1985 · N5219A · DestroyedNTSB ATL85LKG06Accident · Serious injuriesFinal reportPiper PA-28-140 · Brooklet, GAThe plt stated that 2 approaches were made to rwy 09 and he could not locate a wind indicator. He was also unable to contact anyone over the UNICOM to obtain wind information. The plt attempted a landing on rwy 09 during which the acft bounced and a go-around…May 25, 1985 · N32826 · DestroyedNTSB DEN85FA141Accident · 1 fatalField investigationFinal reportCessna 414 · Billings, MTThe plt was making a short (35 minutes) local flt to 'check N333AA over' before turning it over to its new owner. The acft collided with the ground in a steep descent, wings level, attitude during an entry into the traffic pattern at Billings, Montana. VMC…May 24, 1985 · N333AA · DestroyedNTSB FTW85FPA02Accident · Serious injuriesFinal reportBeech H35 · Wichita Falls, TXThe acft made a shallow rt turn and descended to ground contact during a go-around after the plt was informed by radio that his landing gear was not fully extended. Investigation revelaed also that the main fuel tanks were empty and the tank selector was on…May 23, 1985 · N4697D · Substantial damageNTSB MKC85FA111Accident · 1 fatalField investigationFinal reportBedeell BD-5 · Belton, MOWhile turning from downwind to base a loss of pwr was experienced after which the acft stalled and impacted a corn fld. The wreckage revealed no evidence of fuel in the left tank and only about an ounce of fuel in the carburetor. Fuel burn on the terrain…May 22, 1985 · N500BR · Substantial damageNTSB MKC85FA110Accident · 2 fatalField investigationFinal reportCessna 501 · Harrison, ARAt 2003 CDT, the flt was cleared for an ILS localizer apch to rwy 36 at the Harrison/boon county arpt. About 7 min later, the aircrew reported making a missed apch & the flt was cleared to the outer compass locator for another apch. The crew asked the…May 22, 1985 · N10GE · DestroyedNTSB MKC85LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · Adams, NEPlt was making first landing at an ag strip and collided with 30 foot high utility wires which cross the apch end of thestrip. The wires are not marked.May 21, 1985 · N25868 · Substantial damageNTSB FTW85LA229Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · San Angelo, TXA piece of unidentified equipment reportedly was not properly secured during previous maintenance. The equipment reportedly was mounted immediately above the nose wheel extension/retraction mechanism and moved due to acft vibration preventing the nose gear…May 21, 1985 · N711LL · Substantial damageNTSB ATL85FA168Accident · No injuriesField investigationFinal reportEmbraer EMB-110-P1 · Atlanta, GAThe acft was on final apch when the circuit breaker caution light illuminated. The PIC failed to verify which cb tripped and assumed it was the gear control cb. PIC then activated emerg hydraulic sys and manually lowered the gear. After landing the hydraulic…May 20, 1985 · N903FB · Substantial damageNTSB NYC85LA128Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Ellington, CTThe acft colldied with a stump during a landing attempt at Ellington arpt. The acft had touched dwn about 25 ft short of the rwy. The left aileron was damaged but the acft made a go-around & returned to westover air base & landed. According to the plt,…May 19, 1985 · N300UM · Substantial damageNTSB BFO85LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warrenton, VAThe plt was obtaining transition tng fm pwrd acft to gliders and had flown 3 dual flts n N2885H on the morning of the accident with an instruction on board. The CFI then authorized him to fly his list solo flt and acft tkof obsvd the glider make what he…May 19, 1985 · N2885H · Substantial damageNTSB NYC85FA125Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Latrobe, PADrg an IFR arrival, the acft was vectored for an NDB rwy 23 apch to the westmoreland county arpt. At the NDB final apch fix (8.1 mi from the rwy), the crew turned inbound & contd to the arpt. They contacted the tower & reported over the ILS outer marker (an…May 18, 1985 · N66892 · DestroyedNTSB SEA85LA117Accident · No injuriesLimited investigationFinal reportCessna 172M · Couer D'Alene, IDThe eng lost power after carb heat was applied & the throttle was retarded on base leg. Subsequently, the acft nosed over during a forced landing on freshly plowed ground short of the rwy. No preimpact part failure or malfunction was found during the…May 17, 1985 · N13403 · Substantial damageNTSB MIA85LA172Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Orlando, FLThe plt reported that after he arrived & was on an apch to land, he noted 'tape' across the rwy. He remained airborne until the acft passed over 'the taped off area.' He then landed the acft on the rwy which was rough & bumpy. The plt stated that the acft was…May 17, 1985 · N210JA · Substantial damageNTSB SEA85LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tacoma, WAThe engine ceased operative while on right base for rwy 35 due to fuel exhaustion. The plt ran the left tank dry. The right tank contained full fuel. The plt had been used to flying Cessna's.May 16, 1985 · N8300Z · Substantial damageNTSB LAX85LA257Accident · Serious injuriesLimited investigationFinal reportCessna T303 · Mesa, AZPlt took off from scottsdale at 1934 MST for a 13 NM flt to reposition the acft to home base. Within minutes the plt advised ATC that he was 6 mi out with minimum fuel and requested no delay. He then asked for clearance to rwy 22R and was cleared to land on…May 14, 1985 · N4661V · DestroyedNTSB FTW85LA223Accident · No injuriesLimited investigationFinal reportCessna 210D · Austin, TXThe plt touched down long on rwy 17 with 30 degs of flaps, apparently goind downwind. He attempted a go-around, drifted to the right and the left main gear hit a large boulder separating the gear from the acft. The plt then flew to another nearby arpt and…May 13, 1985 · N3835Y · Substantial damageNTSB MIA85FLD02Accident · No injuriesFinal reportPiper PA-22-150 · Fort Pierce, FLPrior to a flt from the Bahamas to west palm beach, FL, the plt noted a problem with the quick-drain for the left fuel tank. After landing in west palm beach, fuel was only added to the right tank since the plt anticipated replacing the left quick-drain. On…May 12, 1985 · N7315D · Substantial damageNTSB ATL85LA162Accident · No injuriesLimited investigationFinal reportCessna 172N · Broxton, GAThe acft collided with power lines on final apch to a private airstrip. The acft was landed in a field next to the rwy. The wires were not marked. The plt reported he was aware of the large power lines near the apch end of rwy 36 but was unaware of the small…May 12, 1985 · N739UD · Substantial damageNTSB FTW85LA216Accident · No injuriesLimited investigationFinal reportGrumman AA1A · Sweetwater, TXThe acft was destroyed when it flipped over during a forced landing following fuel starvation. The fuel selector was positioned on an empty tank. The right fuel tank was full of fuel. The plt stated he must have forgotten to switch tanks.May 8, 1985 · N6399L · DestroyedNTSB CHI85LA192Accident · No injuriesLimited investigationFinal reportCessna A152 · West Bend, WIPlt departed fondulac, WI, with full fuel (24.5 gallons usable) and flew aprx 25 miles south where 2 1/2 hrs were spent taking aerial photographs. Flt then proceeded aprx 60 miles to manitowoc, WI where a landing was made. Departure was then made with aprx 9…May 8, 1985 · N4799A · Substantial damageNTSB ATL85LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Ozark, ALThe plt was on a x-country flt from Ozark, AL to columbia, SC & return. He used 22 gal of fuel en route to columbia. Before returning, he refueled the acft to its full capacity of 24.5 usable gals. However, on the return flt, he encountered headwinds, did not…May 8, 1985 · N6097M · Substantial damageNTSB LAX85LA244Accident · No injuriesLimited investigationFinal reportCessna 152 · Wickenburg, AZThe plt departed bullhead city with an estimated 12 gal of fuel on board. While en route, he realized that the acft was low on fuel, so he decided to land at Wickenburg. Before reaching the arpt, the eng lost power from fuel exhaustion. The acft was damaged…May 6, 1985 · N24970 · DestroyedNTSB CHI85LA187Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Strongsville, OHWhile on final apch the headwind changed to a quartering left crosswind. A sudden loss of alt occurred and the acft contacted the displaced threshold and weathervaned into the wind. The acft traveled off the side of the rwy and nosed over in an area of grass.May 5, 1985 · N89599 · Substantial damageNTSB NYC85FHA03Accident · 1 fatalFinal reportCessna 172M · Auburn Center, PADuring attempted landing on a non-certificated strip, plt attempted a go around. The acft struck a grounding cable which was stretched between two telephone poles near the end of the airstrip. The acft then traveled aprx 120 ft before contacting trees. When…May 4, 1985 · N6851H · Substantial damageNTSB LAX85LA236Accident · No injuriesLimited investigationFinal reportFairchild SA226T · Livermore, CAThe acft landed hard and short of the runway. The impact collapsed the right main landing gear and the acft was destroyed by the post crash fire. The plt reported that on short final a muffled 'pop' was heard and the acft yawed to the right. Directional…May 4, 1985 · N444LM · DestroyedNTSB LAX85FA239Accident · No injuriesField investigationFinal reportEarnst Skybolt · Paso Robles, CAA Cessna 150 and a home built skybolt acft collided while on a downwind leg of a traffic pattern to land. The skybolt was a competitor in a local aerobatic competition east of the arpt. The C-150 was returning from a student plt training x-country flt. Both…May 4, 1985 · N10DE · 2 aircraft · Substantial damageNTSB SEA85LA101Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Bandon, ORThe plt was ferrying the acft to Bandon to have the landing gear repaired. The flt was made with the gear secured in the down position. The acft had locking fuel caps & the plt did not visually check the fuel level before taking off; instead, he relied of the…May 3, 1985 · N5543 · Substantial damageNTSB MIA85IA161Incident · No injuriesIncident investigationFinal reportBritten-Norman BN-2A-27 · Miami, FLThe acft had a total of 75 gals of fuel on board for the round trip from Miami to orlando & return. The plt stated that the flight normally required 3 flt hrs & fuel consumption was 25 gph. The acft was returning to Miami when both engs quit. The plt made a…May 2, 1985 · N48VM · Minor damage