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 MKC87FA078Accident · 2 fatalField investigationFinal reportLake LA-4-200 · Nixa, MOThe normal procedure for operating at this airstrip was to always take off to the east and land to the west when winds were not excessive. Winds elsewhere in area were from southeast at 13 knots while at this strip, they were from the east at 30 knots. After…Apr 12, 1987 · N2847P · DestroyedNTSB MKC87FA077Accident · 1 fatalField investigationFinal reportCessna 150-H · Council Bluffs, IAAcquaintances stated that the student pilot was very motivated in the pursuit of his private pilot certificate and that, on the day of the accident, he was looking forward to this first solo flight. According to his instructor-pilot, who also witnessed the…Apr 12, 1987 · N50223 · DestroyedNTSB ATL87LA110Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Branchville, ALThe plt was ldg at the private airstrip to the north with a tailwind, because trees located on the north end of the rwy precluded ldg to the south into the wind. He made three attempts to land on the 1,754 ft runway; witnesses reported that a 7-12 kt tailwind…Apr 12, 1987 · N6021X · Substantial damageNTSB ATL87LA109Accident · No injuriesLimited investigationFinal reportCessna 150F · Branchville, ALThe plt reported that the acft appeared to be 'hot' on final approach due to a tailwind, while ldg at the private airstrip. He initiated a go-around to avoid 50-60 ft trees at the FAR end of the rwy and made a climbing right turn. The stall warning system…Apr 11, 1987 · N8960S · Substantial damageNTSB NYC87DNE02Accident · 1 fatalFinal reportSprague Christian Eagle II · North Adams, MAThe christian eagle was coming in for a touch and go when it sank into trees, turned around and became involved in a postcrash fire. The acft was destroyed and the plt fatally injured. A pilot who preceded the accident aircraft said the winds were gusty and…Apr 10, 1987 · N11GS · DestroyedNTSB DCA87MA024Accident · 5 fatalMajor investigationFinal reportLockheed L-382G · Travis Afb, CACrashed in steep left turn drg go-around after balked landing. Instructor took controls and initiated go-around after student lndd in improper attitude. Engines number 1 & 2 failed to respond when throttles advanced. Both engines decelerated. Airspeed…Apr 9, 1987 · N517SJ · DestroyedNTSB NYC87LA116Accident · No injuriesLimited investigationFinal reportErcoupe 415D · Warwick, NYThe flight was on approach for landing on runway 3 at Warwick airport when the engine started to sputter. The pilot continued to pump the throttle but overshot the runway and landed in a swamp. It was not determined what caused the loss of power to the engine.Apr 5, 1987 · N2833H · Substantial damageNTSB FTW87LA091Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Horizon City, TXThe pilot delayed in initiating recovery from a simulated forced landing. Then when the throttle was advanced from idle to full open the engine hesitated briefly and full power was restored too late to recover. A hard left bank was initiated to align the…Apr 5, 1987 · N85397 · DestroyedNTSB SEA87LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Alkali Lake, ORDuring a windy crosswind approach the pilot lost control of the aircraft. The aircraft struck the ground short of the runway breaking off the nose gear and then nosing over inverted.Apr 4, 1987 · N1770J · Substantial damageNTSB SEA87LA073Accident · Minor injuriesLimited investigationFinal reportCessna TU206-F · Reno, NVWhile on base leg a loss of power occurred. The student pilot selected right fuel tank and applied the fuel boost pump. A restart was not successful. The instructor pilot then took the controls of the aircraft. He selected a road to land on because there was…Apr 4, 1987 · N71068 · Substantial damageNTSB MIA87FA124Accident · Serious injuriesField investigationFinal reportEagle C-7 · Ft. Lauderdale, FLThe balloon struck powerlines while attempting to locate a suitable ldg site. The plt stated that a gust of wind blew the balloon into the wires & he was unable to climb to avoid the wires prior to impact. The surface winds were from the north at about 8 KTS…Apr 2, 1987 · N7321R · Substantial damageNTSB ANC87MA057Accident · 2 fatalMajor investigationFinal reportCessna 402 · Anchorage, AKThe acft was on the last leg of a scheduled commuter flight, when it crashed in a heavily wooded area while making a VFR approach to merrill field, Anchorage, AK. The capt and his sole passenger were killed in the crash when the airplane struck the ground…Apr 2, 1987 · N967JW · Substantial damageNTSB MKC87LA072Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dodge City, KSThe pilot stated that the aircraft was operating normally when he established himself on final approach for rwy 32. Winds were from the northeast at 25 KTS, the pilot further stated, so he abandoned the approach and was in the process of circling the field…Apr 1, 1987 · N48564 · Substantial damageNTSB ATL87LA103Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Oliver Springs, TNThe plt reported that the acft encountered heavy turbulence and a strong gusty x-wind close to the ground while on short final to his private airstrip. The plt attempted a go-around and encountered 'extremely heavy turbulence' during a turning climbout…Apr 1, 1987 · N2510Y · Substantial damageNTSB LAX87LA165Accident · Minor injuriesLimited investigationFinal reportCessna T206F · Grand Canyon, AZThe plt said that on short final the acft began to drift off the left side of the rwy and control inputs to correct the drift had no effect. The plt added pwr to initiate a go around and he said that the 'airspeed suddenly dropped to 40 and we were in a stall…Mar 31, 1987 · N9026B · Substantial damageNTSB ANC87LA056Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Nikolai, AKThe student pilot stated that he was on a solo cross country flight when he reported that he was lost and low on fuel. He attempted an emergency landing but crashed 200 feet short of the runway. The flight instructor stated that the aircraft was out of fuel…Mar 30, 1987 · N67767 · Substantial damageNTSB FTW87NA086Accident · 3 fatalFinal reportLearjet 24A · Eagle, COMar 28, 1987 · N31SK · DestroyedNTSB ATL87FA100Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Georgetown, DEThe plt was cleared for approach with instructions to close flt plan upon landing. Aprx thirty min later approach control called the fss and asked if the plt had been in contact. The reply was negative. No further action was taken by approach control.…Mar 28, 1987 · N2221E · DestroyedNTSB MIA87LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Gainesville, FLThe non instument rated private pilot filed an instrument flight plan for a 5 hour flight. The flight lasted 5 hours and 26 minutes when the pilot radioed controllers that he had run out of fuel and the engine failed. The aircraft crashed at the destination…Mar 26, 1987 · N6143P · Substantial damageNTSB ATL87LA093Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Waynesville, OHDuring the instructional flt to demonstrate emergency procedures, the instructor stated that he allowed the student to get too low on approach before he took corrective action. The aircraft collided with trees and subsequently the ground approx. 600 feet…Mar 22, 1987 · N2959H · Substantial damageNTSB NYC87LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-31T · Lawrence, MAThe crew of the PA-31T cheyenne had made one missed approach and the co-pilot was calling out the altitudes to the pilot. The pilot's reply to the co-pilot was that he was just going to descend to 400 ft. the approach minimums were published for an mda of 660…Mar 21, 1987 · N200FD · DestroyedNTSB MIA87LA115Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Oxford, MSDuring final apch the eng quit. The plt then attempted to land the acft on a road, during which, it collided with trees. Inspection of the acft revealed that the adjusting screw on the eng driven fuel pump backed out aprx 8 turns. Bench test of the pump…Mar 21, 1987 · N9504Y · Substantial damageNTSB ATL87LA094Accident · Serious injuriesLimited investigationFinal reportBarlow Quickie 2 · Stockbridge, GAThe homebuilt Q-2 was on final approach when it impacted the trees about 300 feet short of the touchdown point. There were no witnesses and the pilot has no memory of the accident. He reported that he does not recall any problem with the aircraft except the…Mar 21, 1987 · N14QP · DestroyedNTSB CHI87DEC02Accident · Minor injuriesFinal reportCessna 172G · Linden, MIThe student pilot was attempting to land when he decided he was too high, and aborted the landing attempt. The engine failed to develop power despite throttle and mixture adjustments, and the pilot made a forced landing in a cornfield. Examination of the…Mar 20, 1987 · N3630L · Substantial damageNTSB FTW87LA077Accident · No injuriesLimited investigationFinal reportBell 206B · Austin, TXAcft was damaged during a hard landing on a roof top heliport following a partial power loss as a result of an uncommanded engine deceleration. As the acft was 40' above and 40' out from the heliport pad, the power loss occurred and the plt stretched his…Mar 19, 1987 · N666TV · Substantial damageNTSB LAX87FA149Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · Jamestown, CADuring the night cross country flt, the accident acft, in company with 2 others, was trying to land at the dest airport in hilly terrain. As the 3 acft approached the airport they encountered bkn to ovrcst conditions of about 400 ft AGL and vis of 2 mi in…Mar 18, 1987 · N5393P · DestroyedNTSB MIA87LA113Accident · Serious injuriesLimited investigationFinal reportKenny Deward B-8M · Escatawpa, MSWhile practicing power off landings downwind the flight encountered a gust at which time the pilot lost control. The aircraft descended rapidly striking the ground and then cartwheeling.Mar 16, 1987 · N1389X · Substantial damageNTSB LAX87LA143Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Saugus, CAUpon contacting ATC, the plt requested an ILS apch and that he was low on fuel. The controller cleared the plt to the ILS. Just inside the outer marker the controller advised the plt that he was dangerously low and to climb immediately. The plt was observed…Mar 13, 1987 · N8185K · Substantial damageNTSB ATL87FA082Accident · 1 fatalField investigationFinal reportBeech K35 · Arden, NCPlt departed charleston, SC for raleigh earlier in the day. While at raleigh he discussed pending legislation with assoc. He departed raleigh about 2228 EST in wx of indef 100 and 1/2 mile visibility. His destination was forecast to have occasional ceilings…Mar 9, 1987 · N621M · DestroyedNTSB MIA87LA100Accident · No injuriesLimited investigationFinal reportCessna 337E · New Smyrna Bch, FLThe plt stated that on short final the auto-plt activated resulting in an uncontrolled 50-60 degree nose low left bank. The acft then veered from the apch path off the arpt property where it then collided with a vehicle & tree before coming to rest.…Mar 8, 1987 · N100LT · Substantial damageNTSB CHI87LA092Accident · No injuriesLimited investigationFinal reportMooney M-20G · Kenosha, WIWhile on downwind leg the pilot heard another aircraft call downwind. When he turned to final the other aircraft turned base. As he descended on final approach the other aircraft turned sharply inside the acft on final and landed. The following aircraft…Mar 8, 1987 · N3960N · Substantial damageNTSB CHI87DEP02Accident · 1 fatalFinal reportCessna 182N · Wissota, WIWhile attempting a night landing, by use of car headlights, the aircraft struck wires and descended out of control into the terrain. Witnesses stated that the pilot seemed low during the final approach. The private airport was not lighted.Mar 8, 1987 · N92840 · DestroyedNTSB CHI87LA091Accident · Minor injuriesLimited investigationFinal reportBeech BE 36 · Alma, MIAccording to the plt, during the preflight inspection, he determined that both gas tanks were full and 'everything was in order.' After aprx one hour of local flight, the plt entered a left downwind for rwy 27 at gratiot community airport, Alma, Michigan. The…Mar 7, 1987 · N12KT · Substantial damageNTSB CHI87LA090Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Hopkins, MIThe plt stated that 'everything was normal' on downwind and base, but that he experienced rough air and 'side to side motion' of the acft on final approach to rwy 27. According to the plt, he held an airspeed of 70 mph with 'some power' until he had the rwy…Mar 7, 1987 · N22793 · Substantial damageNTSB LAX87FA135Accident · 3 fatalField investigationFinal reportGrumman American AA-5A · Tucson, AZA witness observed the airplane entering downwind with smoke trailing behind it. The pilot communicated to UNICOM that: 'the engine has quit; I have to get down'. The witness then observed the airplane making a tighter-than- normal 'base to final' turn. The…Mar 6, 1987 · N9917U · DestroyedNTSB ATL87LA079Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Waycross, GADuring a normal approach to a sod strip, the pilot reported that the gusty wind condition ceased and the acft stalled to the ground short of the intended landing area. The pilot was not able to recover from the sinking condition. The impact caused substantial…Mar 6, 1987 · N3871D · DestroyedNTSB FTW87LA072Accident · No injuriesLimited investigationFinal reportCessna P206B · Hooker, OKThe pilot closed the throttle after crossing the approach end of the runway and while at 10 feet or less above ground level. He bled off airspeed to the point that the aircraft stalled and dropped to the surface, resulting in a hard landing with substantial…Mar 5, 1987 · N4783F · Substantial damageNTSB DCA87MA022Accident · 9 fatalMajor investigationFinal reportCASA C-212-CC · Romulus, MIThe capt made a steep, short, fast visual approach to the runway behind a departing DC-9. The evidence indicates the capt placed the power levers into beta mode to slow the aircraft rapidly and make a short field landing. An asymmetric thrust condition…Mar 4, 1987 · N160FB · DestroyedNTSB MIA87LA095Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Clearwater, FLThe private pilot attempted to reduce throttle and land but the throttle control did not reduce the power. He then landed and attempted to use the brakes to stop the aircraft but it slid off the end of the runway into a ditch. Post accident examination of the…Feb 26, 1987 · N93977 · Substantial damageNTSB NYC87LA093Accident · No injuriesLimited investigationFinal reportMooney M20J · Plainville, CTDuring landing, the pilot came in high and fast, pilot stated that aircraft seemed to float down the runway and when the wheels touched down, the aircraft bounced. Bouncing for the third time, the pilot added full throttle and raised the flaps. However the…Feb 22, 1987 · N222NS · Substantial damageNTSB NYC87LA092Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Tunkhannock, PAThe plt was lndg on a grass rwy with an access road bordering the apch end. Across the road from the rwy threshold, there was a pile of snow which previously had been plowed from the rwy. In reference to lndg at ngt, the plt stated, 'coming in on final, I…Feb 22, 1987 · N3045Z · Substantial damageNTSB SEA87FA060Accident · 2 fatalField investigationFinal reportCessna 182 · North Bend, ORPlt was inbound to VORTAC in clouds for localizer approach to rwy 4. Wx at arpt reporting 1500 ft bkn. Plt expected to make missed approach to continue VFR to another arpt. Plt reported inbound in and out of clouds at 1300 ft. acft crashed 4 NM beyond arpt,…Feb 21, 1987 · N3266Y · DestroyedNTSB LAX87FA119Accident · 2 fatalField investigationFinal reportCessna 441 · Flagstaff, AZThe acft was on an emerg med svc (ems/med-evac) flt with a plt & flt nurse aboard to transport a maternity patient fm Flagstaff to phoenix. Drg a ngt arrival, the plt bgn a vor-a apch in IMC, then he rprtd a problem with his avionics & elected to make a…Feb 21, 1987 · N6858S · DestroyedNTSB MIA87LA090Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedar Key, FLThe plt was attempting to go around after landing fast, due to a tail wind that was stronger that anticipated. Unable to climb, the acft was then blown off the rwy, collided with trees, & came to rest in the gulf of Mexico.Feb 20, 1987 · N12198 · Substantial damageNTSB MIA87LA087Accident · No injuriesLimited investigationFinal reportCessna 172 M · San Juan, PRThe instructor plt stated that the flt was over San Juan bay aprx 2.5-3 miles from the arpt at aprx 700 feet when the eng began to run rough. The eng then quit. However it restarted momentarily. Realizing the flt would not reach the arpt the acft was then…Feb 19, 1987 · N20350 · Substantial damageNTSB MIA87FA086Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Oxford, MSThe acft struck an embankment about 5 feet below the crest & just short of the rwy while attempting to land at dusk & in reduced lighting conditions. The acft exploded & bounced out of the impact crater & came to rest about on the extended rwy centerline. An…Feb 19, 1987 · N3571X · DestroyedNTSB MKC87LA050Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A-600 · Hazen, ARThe pilot stated that he had flown six loads of wheat seeds and was returning to a private airstrip for another load when he ran out of daylight while on final approach to a landing. During the time he was considering the option of a rejected landing and a…Feb 14, 1987 · N5495 · DestroyedNTSB MKC87LA049Accident · No injuriesLimited investigationFinal reportMooney M20E · St.Louis, MOThe PIC was clrd by twr to lnd rwy 30L. The twr advzd the PIC that his gear was not extended. The PIC rspnd with 'I know that and I have lost eng pwr too'. The acft subsequently impacted short of the rwy. FAA maint insp of the acft revealed no fuel in the…Feb 8, 1987 · CFDRN · Substantial damageNTSB MKC87LA047Accident · No injuriesLimited investigationFinal reportCessna 182C · Rolla, MOThe engine started running rough enroute and pilot was able to get it running smoothly but he continued to his destination. Airplane was too high on approach so pilot went around. On downwind, engine started running rough again and pilot was unable to correct…Feb 5, 1987 · N9017T · Substantial damageNTSB FTW87LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Kingfisher, OKThe pilot stated that he was demonstrating emergency landing procedures to the student pilot. At about 1000 AGL he instructed the student to apply full power for a go around. According to the pilot, the engine developed full power for about 30 sec. And…Feb 4, 1987 · N26RF · Substantial damage