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 ATL88FA073Accident · Serious injuriesField investigationFinal reportCessna P210N · Huntsville, ALJan 3, 1988 · N6438W · DestroyedNTSB DEN88LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Riverton, WYThe instructor plt and student were practicing forced landings to an open field. The instructor stated that he descended to approx 50 to 75 ft AGL over the intended landing area. He initiated a go around, pulled up and banked left to go over powerlines. At an…Dec 26, 1987 · N211T · Substantial damageNTSB ATL88FA069Accident · Serious injuriesField investigationFinal reportCessna 172M · Warner-Robins, GAThe non-ifr rated plt dptd in VFR wx. He subsequently encountered IFR wx several hrs after departure and attempted to continue on to his destination arpt in IFR conditions. He made several VOR approaches to the destination arpt. But was unable to visually…Dec 26, 1987 · N13609 · Substantial damageNTSB ATL88FA068Accident · 4 fatalField investigationFinal reportPiper PA-28RT-201 · Rutherfordton, NCThe pilot was cleared for the adf approach. The aircraft was last observed on radar about one mile inside the rbn. The aircraft was located on December 27 about 4 NM NE of the airport. The aircraft impacted the trees at about the 2270-foot level of carson Mt.…Dec 25, 1987 · N2869C · DestroyedNTSB LAX88LA076Accident · No injuriesLimited investigationFinal reportCessna 210K · Chowchilla, CADuring a cross country flt, the plt had diverted to another arpt for fuel. The plt was unable to activate the rwy lights and a forced landing was made that was perpendicular to the rwy. Upon inspection of the acft, an incorrect frequency was noted on the…Dec 24, 1987 · N8221M · Substantial damageNTSB MKC88FA032Accident · 2 fatalField investigationFinal reportCessna 402C · Chadron, NEThe acft was on a flt to Chadron via Chadron VOR. Abt 30 mi sse of the VOR, the plt reqd & was clrd to fly drct to ackmeiaf for an NDB rwy 2 apch. The acft contd twd the VOR which was in the same general drctn, but 11.9 mi south of ackme. The NDB was at the…Dec 23, 1987 · N105GP · DestroyedNTSB MIA88IA068Incident · No injuriesIncident investigationFinal reportBeech 99 · Tampa, FLThe commuter air carrier crew received an unsafe nose gear indication on final approach. The approach was abandoned and all efforts to use the emergency extension procedures were to no avail. The crew secured both engines on final and landed nose gear up.…Dec 21, 1987 · N6724D · Minor damageNTSB LAX88LA072Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Fallbrook, CAThe plt stated that while on short final to rwy 36, approx 5 to 6 ft AGL ovr the rwy, he noticed another acft approaching fm the opposite direction. He initiated a climbing right turn and collided with a tree located abt 150 ft to the right of the rwy…Dec 20, 1987 · N7970B · DestroyedNTSB FTW88FA038Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Burnet, TXThe pilot arrived in the area of his planned destination and completed the outbound and inbound procedure turns for the NDB runway 17 approach without reported incident. Almost immediately thereafter, the aircraft impacted a large oak tree about 15 feet AGL…Dec 19, 1987 · N33007 · DestroyedNTSB MKC88LA030Accident · No injuriesLimited investigationFinal reportCessna 150H · Siloam Springs, ARWhen the airplane was on downwind, the pilot thought he was pulling on the carburetor heat. The pilot attempted to apply power on final and found the engine was windmilling. The pilot found he had pulled the mixture instead of the carburetor heat. During the…Dec 18, 1987 · N23303 · Substantial damageNTSB BFO88FA010Accident · Serious injuriesField investigationFinal reportSwearingen SA-226 · Chantilly, VAThe acft had descended through a cloud layer enroute for the scheduled lndg at iad and according to the crew had picked up some trace rime ice on its wing surfaces. Although pitot and sas (stall avoidance system) heat were used the captain elected not to use…Dec 18, 1987 · N23AZ · Substantial damageNTSB FTW88LA040Accident · No injuriesLimited investigationFinal reportHughes 269A-1 · Eldorado, TXWhile the pilot was attempting to land in a clearing, the main rotor blades contacted a tree causing the aircraft to descend uncontrolled for about 40 feet. The helicopter struck the ground in a nose low attitude causing damage to the skids, bubble, rotor…Dec 17, 1987 · N8945F · Substantial damageNTSB MKC88FA027Accident · Serious injuriesField investigationFinal reportBritish Aerospace BAE-3101 · Joplin, MOThe capt stated that he had planned the approach at a higher-than-normal airspeed and altitude due to a reported low level windshear. At 400 feet AGL the acft entered a light downdraft but the crew corrected the descent profile with power. At 200 feet AGL the…Dec 14, 1987 · N331PX · DestroyedNTSB ATL88LA057Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Monroe, GAThe Beech D35 was landing at a private airstrip from which it had departed fifteen minutes earlier. The final approach was to the south, into the sun. On short final the pilot looked down to verify that the gear was down. He looked outside again just in time…Dec 9, 1987 · N3441B · Substantial damageNTSB ANC88FA019Accident · Minor injuriesField investigationFinal reportCessna 402B · Anchorage, AKDrg arr in hvy traffic, reeve flt 726 (Boeing 727) & wilburs flt 304 (Cessna 402B, N969JW) recd radar adzys for visual apchs to rwys 6L & 6R, respectively. Subsequently, both flts were clrd to lnd. At 1555:04, the LCL twr ctlr transmitted that the wnd at the…Dec 9, 1987 · N969JW · Substantial damageNTSB FTW88FA036Accident · Serious injuriesField investigationFinal reportBell 412 · Galveston, TXThe acft landed hard in the gulf of Mexico during an autorotation that was entered following the separation of the 90 degree gearbox. The gearbox (with tail rotor blades) separated due to an imbalance. However, the gearbox was not recovered during the…Dec 7, 1987 · N3910U · DestroyedNTSB FTW88FA035Accident · Serious injuriesField investigationFinal reportLockheed 250 TRI-GEAR · Dallas, TXThe right engine of the aircraft failed three times in flight. After the last failure near the middle marker the pilot feathered the propeller. The aircraft collided with power lines and the ground about 400 yards short of runway 31 at the redbird airport.…Dec 7, 1987 · N400NY · DestroyedNTSB DEN88FA033Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · San Jose, CASeveral min after takeoff, the plt noted a loss of oil pressure & elected to return to the arpt. As he was returning, the eng began to overspeed, but he controlled the RPM by retarding the throttle. The wind was from 150 deg at 10 KTS. The plt was clrd to…Dec 5, 1987 · N9309N · DestroyedNTSB FTW88IA037Incident · No injuriesIncident investigationFinal reportBoeing 727-243 · Houston, TXImproper drilling of the cross hole in the slat track bearing bolt, which led to its failure from fatigue cracking.Dec 3, 1987 · N571PE · Minor damageNTSB MIA88LA050Accident · No injuriesLimited investigationFinal reportCessna A185F · Naples, FLThe plt stated that the flt was low and slow on final apch. As a result the main landing gear collided with a dirt bank located short of the rwy. The gear then collapsed and the acft slid to a stop.Dec 2, 1987 · N60925 · Substantial damageNTSB LAX88LA063Accident · Minor injuriesLimited investigationFinal reportCessna 177 · San Carlos, AZThe plt added pwr on final approach and later stated that the eng seemed to be losing pwr. He said he noticed that the fuel selector was l of ctr abt 1/2 inch, ctrd it and added carb heat, however the eng still quit. The acft was too low to land on the rwy so…Nov 30, 1987 · N2313Y · Substantial damageNTSB ATL88LA047Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Northport, ALBefore reaching the arpt, the eng lost power. Subsequently, the acft was damaged during an emerg landing on an embankment about 1.5 mi short of rwy 29. Only about 1 cup of fuel was found in each fuel tank. The plt thought there was about 12 gal of fuel…Nov 29, 1987 · N8121T · Substantial damageNTSB SEA88LA025Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Cornelius, ORThe pilot was attempting to land in a field near a farmhouse. On final approach the pilot cleared large power lines, but had not seen small power lines ahead and below the aircraft. The aircraft struck the power lines in flight with the nose gear. The…Nov 27, 1987 · N4523Z · Substantial damageNTSB LAX88FA058Accident · Minor injuriesField investigationFinal reportCessna T210N · Fullerton, CAWhile on final appr to runway 24 at Fullerton arpt, the pilot experienced a total engine power loss. The airplane's alt was insufficient to land on the runway & the plt elected to land in an open area adjacent to the arpt. The airplane's left wing collided…Nov 27, 1987 · N7627N · DestroyedNTSB ATL88FA046Accident · 1 fatalField investigationFinal reportCessna 152 · Oliver Springs, TNThe plt had deptd from a small airport nr kingston, TN mid afternoon and had landed at another about 30 nmi to the NE. He remained on the ground 30-45 min departing between 1530-1545. According to info gathered, the aircraft was observed to fly over the oak…Nov 27, 1987 · N98BS · DestroyedNTSB NYC88FA045Accident · 4 fatalField investigationFinal reportCessna T210N · Skaneateles, NYPrior to departure from holland, mi the pilot received a briefing which included flight precautions for IFR conditions over his entire route of flight and occasional light to moderate rime and/or mixed icing in clouds below 18,000 feet. The pilot elected to…Nov 26, 1987 · N5136Y · DestroyedNTSB DEN88LA028Accident · No injuriesLimited investigationFinal reportCessna 150L · Aberdeen, SDThe private plt was returning home with his son and encountered marginal VFR weather. The flight continued through freezing rain and snow at below freezing temperatures for over twenty minutes. When carburetor heat was applied for landing, the plt reported…Nov 25, 1987 · N1380Q · Substantial damageNTSB DCA88MA005Accident · 18 fatalMajor investigationFinal reportBeech 1900C · Homer, AKDrg arr, the acft (ryan flt 103) crashed short of rwy 3. The fuselage stayed intact drg impact, but the belly structure was compressed & vertical deceleration forces exceeded the design capability of the seats. Rescue psnl had difficulty shutting off the…Nov 23, 1987 · N401RA · DestroyedNTSB ATL88LA042Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Hazel Green, ALThe airplane hit a tree and crashed about 300 yds short of the rwy while on final appch to land. The plt indicated that he became preoccupied with the airspeed indicator and allowed the airplane to descend below the proper glide path. The plt had less than 1…Nov 23, 1987 · N8504T · Substantial damageNTSB MKC88FA019Accident · 2 fatalField investigationFinal reportPiper PA-32R · Fayetteville, ARThe airplane was cleared to land while on downwind. Tower saw lights and said airplane appeared to be flying around hill north of airport. Investigation revealed airplane had turned left and impacted trees below the top of the hill.Nov 20, 1987 · N3578G · DestroyedNTSB CHI88LA028Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Belle Plaine, MNAfter the acft was in the traffic pattern, the instructor (CFI) initiated a simulated forced landing. Just before touchdown on final apch, the student (a rated pvt plt) allowed the acft to drift to the right. The CFI attempted a go-around, but was delayed in…Nov 19, 1987 · N2716Z · Substantial damageNTSB NYC88LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Montoursville, PAAfter takeoff, the plt remained in the traffic pattern to practice takeoffs & landings. He made a touch-&-go, then rprtd on a right downwind for another landing. He acknowledged a clearance to continue, but moments later, an ELT signal began transmitting.…Nov 16, 1987 · N9055F · DestroyedNTSB MIA88LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLDuring an instructional flt while practicing accuracy touch-and-go landings, the student plt flared the acft for landing at low altitude, aprx 45-60 feet from the apch end of the rwy. The acft landed hard short of the runway. As a result the landing gear…Nov 16, 1987 · N539FT · Substantial damageNTSB NYC88LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Jeannette, PAThe aircraft suffered an engine failure during approach and crashed short and to the right of the runway. The acft then nosed over. Post acc investigation and engine exam by the FAA revealed no reason for the eng malfunction.Nov 12, 1987 · N8450F · Substantial damageNTSB SEA88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Winnemucca, NVThe plt was attempting to land close to the approach end of the rwy. He made the approach with full flaps at 85 mph the rate of descent became excessive and before recovery was affected the acft collided with a fence near the rwy threshold. The acc site was…Nov 11, 1987 · N400TT · Substantial damageNTSB FTW88LA026Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dallas, TXThe plt reported that the acft was no. 3 in the pattern for landing on rwy 17. He said carb heat was applied on downwind and eng power was used until the acft was on a 3 mi final. At that point pwr was reduced and a glide was established. A short time later…Nov 11, 1987 · N876Q · Substantial damageNTSB LAX88LA036Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Carmel Valley, CAThe plt & passenger were on a flt to an arpt with a 2475' rwy & a displaced threshold of 665'. The plt rprtd that when he entered the apch to lnd on rwy 11, the acft was higher than necessary. He contd the apch, but when the acft had not touched down, after…Nov 9, 1987 · N6920F · Substantial damageNTSB ATL88FA032Accident · No injuriesField investigationFinal reportBeech 95C-55 · Atlanta, GAAcft was being positioned to begin cargo revenue flt. As acft turned final and ldg gear handle was put in down position PIC noted dimming of all lights & communications were lost. PIC unaware gear were still retracted until prop tips contacted rwy. During…Nov 9, 1987 · N616G · Substantial damageNTSB NYC88LA034Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, MADuring final approach to runway 19 at Shirley, Massachusetts the aircraft rolled inverted. Pilot was able to correct and bring the aircraft upright but did not have enough altitude to clear trees. He set the aircraft into the trees and the wing folded back.Nov 8, 1987 · N8128A · Substantial damageNTSB FTW88FA024Accident · Serious injuriesField investigationFinal reportCessna 140 · Bryan, TXThe student plt took off at ngt with a passenger aboard. After takeoff, he remained in a left traffic pattern & made a low apch. Witnesses rprtd the plt then entered a rgt pattern, but the acft was lower & slower than normal as it was turning on the 2nd apch…Nov 8, 1987 · N72137 · DestroyedNTSB CHI88LA019Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Cumberland, WIAt 0112 CST, the plt telephoned the fss & requested a wx outlook for a 0600 CST departure. The wx briefer adzd the wx to the south was deteriorating & that the destn would be IFR by about the planned departure time. Also, the briefer suggested the plt could…Nov 8, 1987 · N6501S · DestroyedNTSB CHI88LA020Accident · No injuriesLimited investigationFinal reportCessna 152 · New Hudson, MIThe student pilot was on his first solo flight. Before turning onto final approach to land, he noticed another aircraft ahead, already on final approach. The student decided to s-turn for spacing, but while maneuvering, altitude was lost. Subsequently, he saw…Nov 7, 1987 · N46065 · Substantial damageNTSB ATL88LA030Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Newnan, GAThe tail rotor 90 degree gearbox mounting flange fractured during apch to land, while the helicopter was at about 75 ft AGL. The gearbox subsequently separated from the helicopter. The plt initiated an autorotation. The helicopter rolled over on ldg.…Nov 7, 1987 · N922TE · Substantial damageNTSB MIA88LA026Accident · No injuriesLimited investigationFinal reportLearjet 35A · Orlando, FLThe acft made a hard ldg during heavy rain & after being advised of wind shear. The crew stated that at one point, the acft was thrown into a 60 deg bank with airspeed fluctuations plus or minus 20 KTS about 400 to 600 ft AGL. The plt stated that at 100 to…Nov 4, 1987 · N888DJ · Substantial damageNTSB NYC88LA026Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Argyle, NYThe flight was returning to cheney farm field for landing when the pilot came in too high and fast. He added power, banked left and started a go around. At this time the engine backfired and started missing. During the emergency landing in a pasture the…Nov 1, 1987 · N5502Z · Substantial damageNTSB NYC88LA021Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F21B · Montgomery, NYThe aircraft was on approach for landing on runway 26 at orange county airport. However the aircraft collided with a tree about 200 yards from the runway threshold just outside of the airport boundary.Oct 31, 1987 · N4419C · DestroyedNTSB FTW88LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Angelo, TXWhile on a long final approach the aircraft ran out of fuel. The pilot made a forced landing in a field. During landing roll the nose gear collapsed, the main landing gear came off, and both wings were damaged. The pilot stated that he could have avoided the…Oct 31, 1987 · N3449J · Substantial damageNTSB MIA88LA021Accident · No injuriesLimited investigationFinal reportParrish Dragonfly · Boca Raton, FLWhile on short final approach the flight encountered a wind gust which caused the left canard to drop. The landing gear on the left canard then struck the raised lip of the runway causing substantial damage. The aircraft came to rest on the runway.Oct 28, 1987 · N41GK · Substantial damageNTSB MIA88IA020Incident · No injuriesIncident investigationFinal reportBoeing 727-214 · St CroixPaa flt was on visual apch and in contact with apch control who informed flt of two acft ahead also on visual apch. The controller offered vectors to clear traffic. Paa flt elected to continue current heading. The two preceding acft were on twr freq giving…Oct 28, 1987 · N375PA · 2 aircraft · No damageNTSB DEN88FA016Accident · 3 fatalField investigationFinal reportBeech A-36 · Mitchell, SDThe acft had been cleared for the VOR approach at Mitchell municipal arpt at approx 1915 CST. The acft collided with the ground in a slight nose down attitude about 12 miles northwest of the arpt at the point where the procedure turn intersected the inbound…Oct 26, 1987 · N1257E · Destroyed