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 CHI85LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · St. Cloud, MNThe plt stated that his ground speed was too fast during a landing due to no wind. During the go-around the acft collided with tree tops & crashed. The plt reported that he delayed his decision to perform a go-around.Oct 13, 1984 · N5221H · Substantial damageNTSB ATL85LA010Accident · No injuriesLimited investigationFinal reportRobinson R22 · Hueytown, ALThe acft crashed into a river while on final approach to land. The plt reported that he allowed engine RPM to drop and at the same time applied collective pitch. The acft struck the water in a steep descent. There was no report of any failures or malfunctions.Oct 13, 1984 · N90218 · DestroyedNTSB ATL85FA008Accident · Serious injuriesField investigationFinal reportCessna 150L · Cumming, GAThe arpt manager observed the acft start a go-around about 2 ft above the rwy with full wing flaps extended. Flaps remained full down as the acft attempted to climb before colliding with trees aprx 1/4 mi from the arpt. According to the plt, the go-around was…Oct 11, 1984 · N1415Q · DestroyedNTSB ATL85LA004Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Ozark, ALThe student plt was on her fourth supervised solo flt. During the ground roll of her fourth landing the acft started to go left of the rwy centerline. The plt said she over corrected twice and ended up heading off the rwy toward a ditch. Inan attempt to…Oct 9, 1984 · N5065Z · Substantial damageNTSB DEN85LA005Accident · Serious injuriesLimited investigationFinal reportPiccard AX6W · Albuquerque, NMPlt stated he observed the wire about 3 secs before collision. Electrical short circuit severed load cables to basket, which fell to the ground, causing personnel injuries. Balloon envelope drifted away, finally coming to rest 150 mi from accident site.Oct 8, 1984 · N47DP · Minor damageNTSB NYC85LA008Accident · Minor injuriesLimited investigationFinal reportGrumman American AA5A · Corinth, NYDuring an aprx 45 min flight the plt became disoriented and flew an apch to a sod area that he mistakenly identified as his desired dest. During the apch the acft contacted wires causing the acft to descend out of control into a river.Oct 7, 1984 · N26759 · Substantial damageNTSB NYC85LA004Accident · No injuriesLimited investigationFinal reportCessna 150H · Batavia, NYPlt stated en route time was longer than anticipated. On arrival at destination, deep dusk conditions combined with haze, restricted ground reference cues. In addition, plt stated he misread the altimeter. Acft collided with trees 1 mile short of runway. Plt…Oct 7, 1984 · N50157 · DestroyedNTSB CHI85FA005Accident · 1 fatalField investigationFinal reportCessna 310C · Allegan, MIThe non inst non multi-eng rated pvt plt/owner occupied the rt seat & employed the CFI for ferrying the newly purchased acft. From the start, the flt experienced comm difficulties & a compass system malfunction problem. ARTCC transcripts reveal that ATC was…Oct 7, 1984 · N9715Z · DestroyedNTSB ATL85FID01Accident · Serious injuriesFinal reportCessna 172M · Norfolk, VAThe plt was making his landing apch behind a Boeing 727 and in front of a Boeing 737. Plt was requested by ATC to make a short apch but was also cautioned about wake turbulence. On final apch at aprx 50 ft AGL, N70554 rolled sharply into a 90 deg bank,…Oct 4, 1984 · N70554 · Substantial damageNTSB ATL85LA002Accident · No injuriesLimited investigationFinal reportCessna 150L · So.Charleston, WVShortly after takeoff while on the base leg at 900 ft AGL, the engine quit. Plt stated attempts to restart the engine failed. During the forced landing apch the acft collided with trees and a high tension wire. The acft spun around 180 deg and came to rest on…Oct 3, 1984 · N10931 · Substantial damageNTSB FTW85LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Luling, LAThe plt stated that on final approach a gust of wind carried the acft to the right of the runway. Acft right wing struck a tree. Acft yawed right and contacted ground in uncontrolled flight.Oct 1, 1984 · N5360D · Substantial damageNTSB FTW84LA411Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXStudent plt departed on supervised solo cross-country flt to specific destination and return. Instead, plt landed at unimproved field without required prior operator approval and embarked his wife as a passenger for a local flight. On return from local flt, a…Sep 30, 1984 · N64902 · Substantial damageNTSB ANC84FA194Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Wasilla, AKAcft contacted pine trees while turning base to final apch to land. Plt stated all he remembers is trying to activate the plt controlled rwy lights but never seeing them illuminate. Another plt who landed just prior to N1260A'S attempt stated the airstrip was…Sep 30, 1984 · N1260A · Substantial damageNTSB MIA84LA264Accident · Minor injuriesLimited investigationFinal reportCessna 152 · La Belle, FLThe student plt was making a go-around because of a wind gust and said he added 'some power' and retracted the flaps butthe acft continued to drift left until it collided with the trees to the left of the rwy at about midfield.Sep 29, 1984 · N65457 · Substantial damageNTSB ANC84LA193Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKPlt was returning to departure point because of poor wx and darkness. During apch plt could not clearly see landing area. Attempted go-around. Plt stated acft settled into bushes and was yawed into trees because he let too much airspeed bleed off.Sep 29, 1984 · N70123 · Substantial damageNTSB DEN84LA299Accident · No injuriesLimited investigationFinal reportCessna T207A · Mexican Hat, UTPlt stated after accident that while on final approach with eng pwr reduced for landing, the acft began to descend below the desired glidepath. When the throttle was advanced there was no added thrust. An in-flight restart was unsuccesful. The acft landed…Sep 25, 1984 · N75870 · Substantial damageNTSB ATL84FLT15Accident · No injuriesFinal reportPiper PA-28-181 · Jackson, TNDuring a go-around, the engine lost all power. The pilot was able to land on the rwy. The acft went off the end of the rwy, went through a ditch, struck a fence and came to rest on an adjacent road. Examination disclosed no fuel in the left tank. The right…Sep 25, 1984 · N8325V · Substantial damageNTSB NYC84LA321Accident · No injuriesLimited investigationFinal reportBeech 58F · Titusville, PAPlt stated that during final approach with a right quartering crosswind, the acft passed an opening in the trees to the right (former intersecting runway) and the sudden increase in crosswind component caused the acft to drift left. Plt stated he elected to…Sep 24, 1984 · N72053 · DestroyedNTSB MKC84LA284Accident · No injuriesLimited investigationFinal reportCessna 150 · Campbell, MOPlt stated that the acft was low on final apch and full pwr was added to go-around. The acft continued to settle until it contacted the rwy. The acft traveled off the left side of the rwy. After continuing through grass the acft contacted a steel angle iron…Sep 24, 1984 · N222RF · Substantial damageNTSB CHI84FA402Accident · Serious injuriesField investigationFinal reportCessna 152 · Wheeling, ILWitnesses stated that the acft began to climb before it banked to the left and entered a nose down attitude. The student pilot's instructor stated that he was aware that the flt was to have taken place that evening but he did not discuss with the student…Sep 24, 1984 · N757ZG · DestroyedNTSB ATL84MA296Accident · Serious injuriesMajor investigationFinal reportPiper PA-31T3 · Atlanta, GAThe normal fuel load for the flt was 1500 lbs, but with a forecast tail wind & an estimated flt time for only 1+10, the crew accepted the lower indctd (950 lb) fuel load. The flt was uneventful until an indctn of 250 lbs per side, then the fuel 'seemed to…Sep 24, 1984 · N9193Y · Substantial damageNTSB NYC84LA320Accident · No injuriesLimited investigationFinal reportAerospatiale SA-360C · New York, NYDuring approach to heliport, the plt heard two loud 'pops' from the engine. The plt activated the emergency floats and continued the approach. The plt stated that the 'popping', recognized as a compressor stall started again on final. He lowered the…Sep 22, 1984 · N49533 · Substantial damageNTSB NYC84FA319Accident · Serious injuriesField investigationFinal reportSikorsky S-76A · Unionville, PAOn approach, acft yawed right. Plt reduced power and executed emerg lndg. Before shutdown, it was noted the t/r was stationary while the main rotor continued to turn. Investigation revealed t/r drive shaft had separted due to thermal/mechanical damage…Sep 22, 1984 · N79K · Substantial damageNTSB FTW84LA406Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sand Springs, OKAcft was on final apch to land on return leg of x-country when eng began running rough and subsequently quit. Acft contacted trees short of the rwy. Plt stated a ttl of 5 gallons of fuel were drained from both fuel tanks collectively after the accident.…Sep 22, 1984 · N2000G · DestroyedNTSB DEN84FA300Accident · 3 fatalField investigationFinal reportBeech V35 · Missoula, MTOn sept 21, 1984, a Beech 35, N3736Q crashed into the side of a mountain 16 miles NE of Missoula, MT while on a VOR/DME8INSTRUMENT approach. The plt reported icing, turbulence, and intermittant vor-dme reception. The last reported altitude by the plt was 8500…Sep 21, 1984 · N3736Q · DestroyedNTSB MKC84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Davenport, IAAcft was on VFR final approach following a practice instrument flight. Commercial pilot with instrument rating in left seat flew instrument portion of flight and declined offer to land from instructor in right seat due to her lack of proficiency. On final…Sep 19, 1984 · N155DH · Substantial damageNTSB ATL84FA292Accident · 2 fatalField investigationFinal reportMooney M20J · Lanett, ALCommunications with columbus apch revealed plt was unfamiliar with area and had difficulities finding the arpt witnesses viewed acft on final for rwy 08 with landing gear extended. Acft described as being low and slow. Witnesses stated engine sounds…Sep 19, 1984 · N201RT · DestroyedNTSB NYC84FA314Accident · 6 fatalField investigationFinal reportPiper PA-32R-300 · Linden, NJAcft collided with utility pole during a night visual lndg. The pole is located about 583' from the rwy threshold and is 58' high. The pole was unmarked. The plt made 1 previous night lndg. At the arpt and 5 total lndgs at the arpt. The investigation did not…Sep 17, 1984 · N478KT · DestroyedNTSB LAX84LA485Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Bishop, CAThe plt of the Bellanca said he saw a sailplane in front of him in the traffic pattern and pulled up to avoid a collision. The Bellanca stalled and even though it was partially recovered 500 ft before ground contact, the plt said he cut the engine and landed…Sep 17, 1984 · N14728 · Substantial damageNTSB ANC84FA175Accident · Serious injuriesField investigationFinal reportCessna 180 · Anchorage, AKThe plt reported a ttl loss of power after being cleared to land on rwy 33 at merrill field. The acft contacted trees, a moving vehicle on 15th ave and an 8 ft high arpt fence during the forced landing. Examination of the acft eng failed to disclose any…Sep 17, 1984 · N9339C · DestroyedNTSB MIA84LA255Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Rockledge, FLThe acft collided with a mound of dirt while executing a go-around at a private airstrip. The plt stated he selected rwy 27 based on winds reported at another airport and when the acft touched down about mid-point of the strip, 'I retracted flaps and applied…Sep 16, 1984 · N7431P · DestroyedNTSB ATL84LA288Accident · No injuriesLimited investigationFinal reportCessna 182 · Waynesboro, VAThe pilot stated that while on final approach the aircraft encountered a downdraft and was forced down short of the runway. Pilot suggested that he may have also encountered possible wind shear.Sep 16, 1984 · N3257U · Substantial damageNTSB ATL84LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, GAThe plt departed deland, FL, for Columbus, GA, with an intended fuel stop at americus, GA. While en route from deland to americus the ceiling became lower than forecast and the plt made the decision to fly at 8500 ft MSL staying above the cloud layer. With…Sep 16, 1984 · N757DN · Substantial damageNTSB MIA84FA253Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Culebra, PRThe plt was advised by other plts that a missed approach was not possible at this arpt on rwy 31. All other plts in the group landed on rwy 13. The accident plt elected 31 until he was on final with a tailwind and then started a go-around. The rising terrain…Sep 15, 1984 · N2225Y · DestroyedNTSB FTW84FA393Accident · Serious injuriesField investigationFinal reportBell 206B II · Dallas, TXAcft made forced autorotative landing off arpt in a residential area which was congested. Acft developed a high sink rate in the autorotation and landed hard. The forced landing was due to fuel exhaustion. 45 gallons of fuel were added to the acft at 1226 CST…Sep 14, 1984 · N49615 · Substantial damageNTSB ATL84FA286Accident · 1 fatalField investigationFinal reportPiper 602P · Dayton, TNOn arrival at destination, plt found airport obscured by fog, reported by UNICOM as 1 mi visibility. Plt circled to await improvement. 15 min later, visibility improved to 1-1/2 mi. Acft observed briefly through breaks, then heard manuvering to north and seen…Sep 14, 1984 · N6897L · DestroyedNTSB FTW84LA388Accident · No injuriesLimited investigationFinal reportCessna T210M · Austin, TXDuring arrival, the plt reduced power on base leg for for a landing. When he realized his airspeed was dissipating faster than normal, he advanced the throttle, but the eng did not respond. The plt then switched fuel tanks, turned on the boost pump & applied…Sep 11, 1984 · N761VP · Substantial damageNTSB SEA84LA225Accident · No injuriesLimited investigationFinal reportCessna 150 · Bandon, ORThe plt indicated that 15 minutes had been flown on the full fuel tank prior to the accident flight. The plt departed at 1330 on a siteseeing flt around the local area. After 3.7 hrs of flight, while on final approach to rwy 34, the engine quit. The plt…Sep 10, 1984 · N111HT · Substantial damageNTSB MKC84FA272Accident · 2 fatalField investigationFinal reportCessna 195A · Akron, IAN19JW, a Cessna 195A and N8783X, a Cessna 182 departed mapleton, IA, at aprx 0805 on a VFR flt to Akron, IA, to attend a fly-in breakfast. The two acft did not travel the same route of flight to Akron, N19JW crossed over the midpoint of the arpt on crosswind…Sep 9, 1984 · N19JW · 2 aircraft · DestroyedNTSB FTW84LA383Accident · Minor injuriesLimited investigationFinal reportCessna 140A · San Antonio, TXThe plt attempted to land on an upsloping rwy with a quartering tailwind. Plts who landed just before the accident reported downdrafts and a strong x-wind experienced during the apch. During the go-around the airspeed decreased to 40 mph as the acft flew over…Sep 9, 1984 · N5643C · Substantial damageNTSB FTW84FA382Accident · 2 fatalField investigationFinal reportCessna 172N · Quinlan, TXA witness reported that when the plt was landing, the acft descended on final apch, got too low & collided with electric power lines. The acft then nosed down & impacted the ground in a steep nose down attitude.Sep 9, 1984 · N46ER · DestroyedNTSB CHI84LA384Accident · Serious injuriesLimited investigationFinal reportHarris Goldwing · Greenville, ILPlt was performing touch and go landings below 1100 ft overcast sky. Passing north end of field at 800 ft, plt noted rain shower at south end & elected to land to the south. During apch turn the left wing dropped abruptly to a near-inverted acft attitude. Plt…Sep 9, 1984 · N3958C · Substantial damageNTSB FTW84LA381Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Alvin, TXThe helicopter experienced an unexplained power loss. An emergency landing was attempted but the helicopter collided with a ditch. Lacking sufficient rotor RPM for efective control the helicopter nosed over. The plt was mailed an NTSB 6120.1 form to complete…Sep 8, 1984 · N2161U · DestroyedNTSB ANC84FA166Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Pilot Point, AKAcft departed denai, AK, at 0730 AKDT. When manuevering for a landing apch on dog salmon river acft stalled contacting dirt bank. Plt was carrying 8 5-gallon gasoline cans. 4 cans were still secured inside the acft after the accident. Only 3 of the cans were…Sep 3, 1984 · N4012Z · Substantial damageNTSB LAX84FUG02Accident · 1 fatalFinal reportPhaneuf B8 MOD Gyro · Murrieta, CAA witness observed the gyrocopter circle the aprt. On the second time around, it dropped down low on the downwind leg and disappeared behind a small hill. He also stated the eng was running at full power and that he could hear the rotor blades strike the…Sep 2, 1984 · N8474 · DestroyedNTSB MKC84LA267Accident · No injuriesLimited investigationFinal reportCessna 150L · Marshall, MOThe acft engine lost power while descending after 1 hr of flt. During the ensueing forced lndg the plt said he changed his selection of landing site because of an auto on the selected site (a highway). The acft was landed beside the road &a collision with a…Sep 1, 1984 · N16220 · Substantial damageNTSB ATL84FLT13Accident · Serious injuriesFinal reportPiper PA-22 · Nashville, TNThe engine quit on final apch to the arpt as a result of fuel starvation. Sixteen gallons of fuel remained in the right fuel tank, but the left tank was selected. No fuel was found in the left tank. The acft collided with powerlines during the forced landing…Aug 31, 1984 · N950A · DestroyedNTSB ATL84FA274Accident · 2 fatalField investigationFinal reportCessna 402C · Albertville, ALPlt was executing an non-directional beacon approach to rwy 23. Instrument meteorological conditions prevailed at the time of the accident. Radar information obtained during the investigation revealed the plt did not stabilize the airspeed while executing the…Aug 31, 1984 · N55LP · DestroyedNTSB NYC84FA293Accident · No injuriesField investigationFinal reportCessna 150M · Meriden, CTA cesnna N45288 was above and slightly to the rear of Cessna N4669V when they collided on final approach over the displaced threshold to runway 36 at mmk. Both aircraft landed without further incident. There were no injuries.Aug 26, 1984 · N45288 · 2 aircraft · Minor damageNTSB MIA84FA240Accident · 1 fatalField investigationFinal reportCessna 152 · Pembroke Pines, FLOne min and 20 seconds after being cleared for takeoff, the plt transmitted on tower freq that he was 'coming in for a landing.' The acft was observed to bank to the left, enter a steep descent from 200 to 300 ft AGL & crash. An intense post-crash fire…Aug 26, 1984 · N48661 · Destroyed