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 ATL86LA225Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Ardmore, ALDuring the landing attempt, the pilot elected to go-around after he realized that a safe landing could not be completed. During the go-around the acft settled to the rwy after the pilot retracted the flaps. The acft rolled off the departure end of the rwy at…Aug 24, 1986 · N285G · Substantial damageNTSB BFO86LA041Accident · No injuriesLimited investigationFinal reportBellanca Citabria · Pasadena, MDOne witness who watched N41464 make the approach indicated that the aircraft appeared to be too fast as it passed the 1/2 way point on the runway and that it bounced back up into the air after nosing down onto the turf runway. The nose of the aircraft came up…Aug 23, 1986 · N41464 · Substantial damageNTSB LAX86LA327Accident · No injuriesLimited investigationFinal reportCessna P210N · Coalinga, CAThe flight was a repositioning flight back to the aircraft's home base at the conclusion of an on demand air taxi flight. The pilot said that he departed without visually checking the fuel tank level. The pilot said the fuel gauges indicated one half tanks…Aug 22, 1986 · N4831A · Substantial damageNTSB CHI86LA210Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lodi, WIDuring a practice emergency landing approach, the instructor told the student to go around at an altitude of about 600 feet AGL. The student failed to add power and pulled the yoke all the way back. The aircraft then stalled. The instructor took control,…Aug 22, 1986 · N2430E · Substantial damageNTSB MKC86LA172Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Republic, MOThe pilot was flying a pattern around a field where he intended to land later. During a low pass, he applied power for a go- around but full power was not sufficient to prevent a touchdown. At touchdown, a side load collapsed the landing gear. The pilot is…Aug 17, 1986 · N84055 · Substantial damageNTSB MKC86FCD03Accident · Serious injuriesFinal reportRoger Warnell KR-1 · Waterloo, IAThe pilot reported that he had carburetor problems. The engine quit and the pilot made a forced landing about one mile from airport. This was the pilots first flight in this aircraft.Aug 17, 1986 · N49RW · DestroyedNTSB CHI86LA208Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Ionia, MIAccording to the plt, at approximately 20 miles south of Ionia county airport, Ionia, Michigan, he used frontal zone lift to climb to 4600 MSL (3800 AGL), and he encountered no further lift. The plt stated that he anticipated an increase in wind gradient…Aug 17, 1986 · N12GH · Substantial damageNTSB BFO86FA042Accident · 3 fatalField investigationFinal reportPiper PA-30 · Bowleys Qrtrs, MDDrg arr, TRACON gave the plt the arpt wx & provided vectors for an ILS rwy 32 apch. The plt inquired about a cell that he understood was over the arpt & was advised to standby while the controller (ctlr) checked on it. The ctlr contacted twr psnl who adzd the…Aug 17, 1986 · N31AB · DestroyedNTSB FTW86LA149Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Tulsa, OKThe pilot was on an approach into Tulsa international airport when the engine began to surge after the landing gear had been lowered. The pilot informed the tower he thought he was experiencing fuel exhaustion. The aircraft landed 2,000 feet short of runway…Aug 14, 1986 · N9998Y · Substantial damageNTSB SEA86LA206Accident · No injuriesLimited investigationFinal reportCessna 340 · Prairie City, ORThe plt was attempting to land the acft on an unlit airstrip during dusk conditions. While attempting to align the acft with the center of the 30 foot wide airstrip the plt heard the stall warning horn sounding. During an attempted go around an inadvertent…Aug 13, 1986 · N2696U · Substantial damageNTSB ATL86FA220Accident · Serious injuriesField investigationFinal reportBellanca 14-19-3A · Toccoa, GAThe plt checked on the acft the day prior to this flt and stated that he did not want it refueled. On the day of the flt he was observed draining fuel from the acft. He air filed an IFR flt plan and stated that he had 3 hrs and 45 mins of fuel and his en…Aug 13, 1986 · N1297R · DestroyedNTSB MIA86LA231Accident · No injuriesLimited investigationFinal reportPiper PA24-180 · Orlando, FLPlt was unable to completely extend landing gear via electric and manual means. A landing was made with gear partially extended. Examination of the aircraft after the accident revealed the landing gear extention mechanism was binding in the manual extention…Aug 11, 1986 · N55UA · Substantial damageNTSB LAX86LA318Accident · No injuriesLimited investigationFinal reportGlasflugel Standard Libelle · Markleville, CAThe pilot of the glass fugel glider reported no malfunctions with the airplane prior to the crash after attempting a circle to land maneuver. The pilot indicated he misjudged his altitude with the up hill sloping runway. During the circling maneuver he forgot…Aug 10, 1986 · N7190 · Substantial damageNTSB NYC86LA205Accident · Serious injuriesLimited investigationFinal reportCessna T-210 · Spring Valley, NYThe pilot took off in the Cessna T-210N with 3 passengers. The landing gear would not retract, so he returned for landing. Just prior to touchdown, the aircraft dropped and bounced. The pilot initiated a go-around and the aircraft bounced once more lightly.…Aug 9, 1986 · N4879U · Substantial damageNTSB FTW86LRA12Accident · No injuriesFinal reportMolino PIK-20B · College Station, TXThe glider collided with trees during an off arpt landing due to lack of lift. The plt complained that flaps are not as efficient as spoilers for approach control. Plt used flaps and mushed into trees short of the intended landing area.Aug 9, 1986 · N20EK · Substantial damageNTSB DEN86LA226Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Durango, COThe plt was attempting to land his glider. He said that he was unable to reach the airport and elected to land in a nearby pasture. Prior to touchdown he discovered some cattle in the field but was unable to avoid a collision with one of the animals. The…Aug 9, 1986 · N7590 · Substantial damageNTSB DEN86LA228Accident · No injuriesLimited investigationFinal reportE. E. Schilling Q-2 · Billings, MTPlt stated after accident that he had a minor eng problem prior to departure from big timber. He stated that the problem was corrected and the flight commenced to Billings. While on final approach to rwy 04 at Billings the plt experienced a partial loss of…Aug 8, 1986 · N21QQ · Substantial damageNTSB DEN86LA224Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Monument Valley, UTThe plt was on an approach for landing when the acft began to settle. He said that increasing power did not seem to have an effect. Subsequently, the acft landed hard, collapsing the nose gear. The plt believed that he had encountered wind shear during the…Aug 8, 1986 · N8544P · Substantial damageNTSB ATL86LA221Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Bowling Green, KYPlt reported that he failed to reposition the fuel selector from auxillary fuel tank to main fuel tank during the landing check. Engine quit due to fuel starvation on short final approach at too low an altitude for corrective action.Aug 8, 1986 · N78261 · Substantial damageNTSB SEA86LA196Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Stibnite, IDThe pilot executed a steep, reduced power descent into the destination airstrip. He then reported that when he attempted to reduce the rate of descent with a power application, the engine did not respond. There was no evidence of any mechanical malfunction…Aug 7, 1986 · N7459E · DestroyedNTSB FTW86FRG30Accident · Serious injuriesFinal reportSchleicher ASW-20 · Uvalde, TXAcft was competing in the natl soaring championships and had just crossed the finish line at 50' AGL and 85 kns a/s when it entered a maneuver to reverse direction and climb to pattern alt for landing. During the turn the acft stalled and struck a power line…Aug 4, 1986 · N20TS · DestroyedNTSB MIA86LA226Accident · No injuriesLimited investigationFinal reportCessna 152 · San Juan, PRThe acft had been in the air for about 1 hr & was aprching the arpt. While on final aprch, the eng quit & the plt radioed 'mayday,mayday,fuel exhaustion' & ditched the acft in the water. The CFI plt stated that he checked the fuel supply by looking at the…Aug 3, 1986 · N914DF · DestroyedNTSB SEA86LA197Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Nimbus Iiit · Hawthorne, NVAfter a 5 hour flight in the motorized glider during which the engine was utilized on several occasions the pilot returned to his destination. Upon arrival he executed a number of low passes over the runway for photographers. The pilot executed a fly by…Jul 30, 1986 · N141V · Substantial damageNTSB SEA86LA160Accident · No injuriesLimited investigationFinal reportCessna 172G · Carson City, NVThe plt stated a dust devil was encountered during final approach. He then added full power, but neglected to lower the nose of the acft. A full stall occurred and recovery was not possible due to the low altitude. The acft then struck the ground, nose first,…Jul 30, 1986 · N41041 · Substantial damageNTSB NYC86FGM06Accident · 1 fatalFinal reportKenneth Patsch FLY Baby II · Franklin Center, PAThe plt reported that the acft banked excessively during the left turn from base to final. Opposite control input was applied, however, the plt reported the 'stick seemed to have no right movement.' Full power was applied but the bank steepened so power was…Jul 28, 1986 · N14OP · DestroyedNTSB ATL86FA212Accident · 2 fatalField investigationFinal reportCessna 172 · Bridgeport, WVThe aircraft collided with a tree while on final approach to runway 21. The flight had been cleared for the approach after the pilot reported having the airport in sight. There was no current weather observation available at that time, but a local air taxi…Jul 28, 1986 · N96701 · DestroyedNTSB SEA86LA180Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Colville, WAWhile making a power off approach to simulate a forced landing an over shoot was assured. The plt added pwr and the engine ceased operating. In order to avoid trees at the end of the runway the pilot made a 90 degree turn to land in a plowed field. The acft…Jul 27, 1986 · N9425A · Substantial damageNTSB LAX86LA305Accident · No injuriesLimited investigationFinal reportNavion A · Grass Valley, CAA Navion a landed hard on rwy 01 after an attempted go-around. The plt indicated that he was landing to the north with full flaps and discovered he had a gusting tailwind. He initiated a go-around and at 50 ft AGL he brought the flaps up halfway. The acft…Jul 27, 1986 · N111T · Substantial damageNTSB ATL86LA210Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Huntersville, NCPlt was practicing touch-and-go and emer proc. He was high on base and attempted to correct alt, struck a ditch 200 feet short of the rwy with rt ldg gear. Acft came to a stop 100 feet short of rwy in second grass filled ditch.Jul 27, 1986 · N7689S · Substantial damageNTSB ANC86LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Umiat, AKPilot stated the engine quit due to fuel exhaustion during final approach, forcing him to land on a short unsuitable gravel bar. Aircraft nosed over upon landing and came to rest in 10 feet of water.Jul 27, 1986 · N3366Z · Substantial damageNTSB MKC86LA160Accident · No injuriesLimited investigationFinal reportHuizenga SEA Hawk · Clinton, IADuring a test flt of an experimental sea plane, the plt rptd a loss of eng pwr during a turn in the traffic pattern at Clinton airport. The plt stated he had 5 gallons of fuel onboard and had flown about 2 tenths of an hour. Inspection of the fuel system…Jul 25, 1986 · N85CK · Substantial damageNTSB SEA86LA209Accident · No injuriesLimited investigationFinal reportLet L-13 · Issaquah, WAPlt undershot approach after encountering downdraft, collided with perimeter fence.Jul 24, 1986 · N65141 · Substantial damageNTSB ATL86LA207Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mobile, ALThe plt received a wx briefing prior to takeoff which forecasted widely scattered thunderstorms. On arrival at destination a thunderstorm was over the arpt. The plt executed an ILS rwy 14 apch. A preceding DC-9 made a missed approach due to tower reported…Jul 23, 1986 · N2952D · Substantial damageNTSB NYC86DNC06Accident · Minor injuriesFinal reportHansen Hawk 304 · Wolfeboro, NHThe experimental aircraft equipped with a buick V-8 aluminum block engine experienced power loss on approach for landing. The pilot decided that the distance and terrain was too great for a glide to the airport, and an emergency water landing in a nearby lake…Jul 22, 1986 · N13CH · Substantial damageNTSB MKC86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-23-250T · Norfolk, NEA fire started inflight in the left wheel well and nacelle area just after the pilot turned on the electric fuel pumps during the turn to final approach. The airplane was landed and the pilot evacuated safely. According to witnesses, the airplane appeared to…Jul 22, 1986 · N62719 · Substantial damageNTSB NYC86LA186Accident · Minor injuriesLimited investigationFinal reportMooney M20F · West Milford, NJDrg the landing roll, the plt believed there was insufficient braking, so he initiated a go-around. He rprtd that on climb-out, the tail of the acft impacted a 'hill.' The acft then crashed nose down & was destroyed. No preimpact part failure or malfunction…Jul 21, 1986 · N7040V · DestroyedNTSB LAX86LA296Accident · Serious injuriesLimited investigationFinal reportGlasflugel ST Libelle · Vacaville, CAAccording to witnesses the sailplane was too low on the landing appraoch and in an attempt to stretch the glide the pilot stalled the sailplane and entered a spin prior to contact with the ground.Jul 20, 1986 · N74162 · Substantial damageNTSB MIA86IA213Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Miami, FLFlt was unable to extend nose gear and a nose gear up landing was made. Investigation revealed the nose gear drag brace to be locked in the up position. Disassembly of the drag brace revealed the link assemblies which connect the locking pawls to the locking…Jul 19, 1986 · N8872Z · Minor damageNTSB LAX86MA309Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Morgan City, LAThe plt flew to a nearby arpt to practice takeoffs & lndgs. He rprtd that after 3 lndgs 'out of a hover,' he returned to the departure heliport & lndd again from a hover. Drg touchdown, the helicopter bgn to rock fm side to side & enteredground resonance. The…Jul 18, 1986 · N57967 · DestroyedNTSB CHI86LA173Accident · No injuriesLimited investigationFinal reportLake LA-250 · Frankfort, MIThe plt rprtd that during an attempted go-around, a crosswind caught the right wing and blew the acft to the left. The left wing hit a hangar door & was torn off, then the acft crashed to the ground & came to rest upside down. The wind was rprtd to be gusting…Jul 18, 1986 · N1402X · DestroyedNTSB SEA86LA171Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Ketchikan, AKThe plt was attempting to land when the engine ceased operating as the throttle was advanced. Subsequently, the acft struck an embankment short of the runway. The plt had selected the right fuel tank, although the normal procedures in the operating manual…Jul 16, 1986 · N6336E · DestroyedNTSB CHI86FA172Accident · 3 fatalField investigationFinal reportCessna 441 · Norton Shores, MIN6857E was transporting executives from holland, MI, to muskegon. The pilot was executing an asr approach to runway 06. The mda is 537 ft AGL. Co-pilot called out 1200 feet then below 1000 feet, pilot continued approach. Aircraft struck trees two miles from…Jul 16, 1986 · N6857E · DestroyedNTSB CHI86FA171Accident · 1 fatalField investigationFinal reportAero Commander 100 · Crivitz, WIFollowing one approach to land under conditions of low visibility (less than 1/4 mile) the pilot attempted to land again. On base leg, according to witnesses, the aircraft fell to the ground. In the wreckage the stall warning light bulb filament was grossly…Jul 16, 1986 · N3667X · DestroyedNTSB ANC86LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Blackburn, AKAcft undershot apch and crashed into a river while executing a low circling apch to land at a nearby gravel bar. Plt stated that he had been on duty for about 18 hrs, had flown 8.4 hrs that day hauling fish and that he was tired and 'playing around'. Acft…Jul 15, 1986 · N4649C · Substantial damageNTSB LAX86FA288Accident · 6 fatalField investigationFinal reportCessna T210N · Bullhead City, AZThe private pilot, who had accumulated approximately 450 hours of flight experience and his 5 passengers, arrived at the destination airport during darkness. This was the pilot's first landing at the uncontrolled airport and he was not familiar with the…Jul 13, 1986 · N5534Y · DestroyedNTSB CHI86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Benson, MNThe pilot reported that he ran the right fuel tank dry before switching to the left tank in cruise flight. On final approach for a landing the engine began to falter and quit running shortly thereafter. The aircraft was landed short of the runway gear up in…Jul 13, 1986 · N3731T · Substantial damageNTSB ATL86LA204Accident · No injuriesLimited investigationFinal reportCessna C-152 · Conway, SCThe acft was based at an uncontrolled airstrip without fuel facilities. Prior to take-off, the plt refueled the acft from a 5 gal can and draining the fuel sumps. During an approach to land at Conway, SC, the acft lost power and a forced landing was made on a…Jul 13, 1986 · N6521B · Substantial damageNTSB DEN86LA199Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Hobbs, NMThe plt was participating in a soaring competion meet. While on the return portion of the flt, the plt encountered an area of insufficient lift & was unable to reach the arpt. During an off arpt landing, the left wing of the glider struck a mesquite bush &…Jul 12, 1986 · N13JR · Substantial damageNTSB DEN86LA195Accident · No injuriesLimited investigationFinal reportCessna 320C · Cedar City, UTThe plt said that while on downwind during his apch to land, he advanced the mixtures to full rich and retarded the throttles. On final approach when throttles were advanced, he discovered the right eng was not running and the left eng would not respond…Jul 12, 1986 · N3030T · Substantial damageNTSB SEA86FA165Accident · 2 fatalField investigationFinal reportThorp T-18 · Richland, WAAt time of mishap, acft presumed to be in rt-hand approach to land in 20-KT, 40 degree rt crosswind. Witnesses first observed acft descending vertically, out of control, in an area consistent with the 90 degree approach position. Evidence indicates acft…Jul 11, 1986 · N2056 · Destroyed