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 DEN88FA126Accident · Serious injuriesField investigationFinal reportCessna 404 · Denver, COThe plt was on a flt from greeley to Denver, Colorado to obtain minor maint on a cargo door. As the acft was being vectored on final apch, the plt rprtd that he believed the acft had fuel starvation. Subsequently, the acft was observedto make a complete roll…Jun 10, 1988 · N8827K · Substantial damageNTSB CHI88DEM06Accident · No injuriesFinal reportKoopsen Miller Sport II · Lake City, MIJust prior to turning on final approach to land, the pilot experienced a complete loss of power. He continued the approach but decelerated more rapidly than he anticipated and was unable to clear a stand of trees on the approach path. Examination revealed a…Jun 10, 1988 · N5574A · Substantial damageNTSB MIA88LA188Accident · Minor injuriesLimited investigationFinal reportCessna T210R · Tampa, FLThe plt stated that on final apch to Tampa international airport, he reduced power, put the gear down and, as he tried to add power, none was available. During an attempted forced landing, he hit the top of an office trailer and a guy wire before coming to…Jun 9, 1988 · N6390U · Substantial damageNTSB LAX88LA218Accident · No injuriesLimited investigationFinal reportRockwell 690C · Hayward, CAAt the end of a cross country flight, while on final approach to the runway, the right engine quit. Shortly thereafter, the left engine quit. The pilot made a forced landing in a field short of the runway where during the landing roll the airplane collided…Jun 8, 1988 · N47TT · Substantial damageNTSB LAX88LA217Accident · 1 fatalLimited investigationFinal reportCessna 150F · Quartzsite, AZJun 8, 1988 · N7892F · Substantial damageNTSB ATL88LA190Accident · Minor injuriesLimited investigationFinal reportSikorsky S-55C · Coaling, ALThe helo was approaching a helipad for landing after the last aerial application flight of the day when there was a pop and tail rotor control was lost. After several rotations about the vertical axis, the PIC landed the helo hard, collapsing the landing…Jun 7, 1988 · N883 · Substantial damageNTSB SEA88LA104Accident · No injuriesLimited investigationFinal reportCessna 210 · Reno, NVDuring an instructional flight and an ILS approach, a total loss of engine power occurred at about 1200 feet AGL. A forced landing was made onto rough terrain. During landing roll the nose gear separated from the aircraft. The private pilot receiving…Jun 5, 1988 · N70SA · Substantial damageNTSB MKC88LA106Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lakeview, ARWhile attempting to land crosswind on a 'one way' runway, the plt said a gust of wind blew him towards some bordering trees, so he made a decision to 'go around'. The plt said he applied full throttle and raised the flaps from the full flap setting, and…Jun 4, 1988 · N75540 · Substantial damageNTSB SEA88LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Hawthorne, NVDuring a go-around due to the pilot having difficulty landing with a gusting crosswind, the aircraft struck a barbed wire fence with the main landing gear and a fence post with the left horizontal stabilizer. The aircraft then crossed a road and came to rest…Jun 3, 1988 · N3741P · Substantial damageNTSB LAX88LA209Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Vacaville, CAAt the end of a pleasure flt, the plt extended the downwind leg for landing, thinking that the touchdown altitude was 12 ft instead of, in actuality, 220 ft. the plt normally flew out of another airport with an alt of 12 ft. from the extended downwind, the…Jun 3, 1988 · N7768S · Substantial damageNTSB CHI88IA129Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Madison, WIFailure of the right outboard flap position signalling cable due to chaffing initiated by improper installation/rigging by a manufacturer's vendor.Jun 3, 1988 · N383MQ · No damageNTSB NYC88LA153Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Latrobe, PAAccident was pilot loss of directional control during landing.Jun 2, 1988 · N90DR · Substantial damageNTSB DEN88LA117Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Ft. Collins, COJun 1, 1988 · N6638N · Substantial damageNTSB DCA88IA060Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · Jamaica, NYNone submittedJun 1, 1988 · SXOAB · Minor damageNTSB CHI88LA124Accident · No injuriesLimited investigationFinal reportBeech B-19A · Lacon, ILA hard landing made by the student pilot after attempting to recover from a bounced landing.May 31, 1988 · N4306S · Substantial damageNTSB LAX88LA206Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Long Beach, CAWhile on final approach to the runway, the engine quit. During the forced landing the empennage caught on the airport boundary fence. The airplane collided with the terrain and nosed over. Inspection of the fuel tanks revealed that one tank was empty and the…May 30, 1988 · N6178N · Substantial damageNTSB NYC88LA151Accident · 1 fatalLimited investigationFinal reportBeech 23 · Meriden, CTThe Beech 23 lost power during a go-around. During an off-airport landing, the acft struck a house. The private pilot died the following day of injuries and the flight instructor was seriously injured. There was no evidence of a large fuel spill and only…May 29, 1988 · N6042X · Substantial damageNTSB FTW88LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Denton, TXThe instructor was simulating an engine-out emergency for the dual student. The student was making an approach to an emergency field with a line of trees on the approach end. When the instructor became aware that they might not reach the field, he directed…May 29, 1988 · N98088 · DestroyedNTSB MKC88LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOFollowing a landing apch at the end of a student solo cross country flight, a full flap go around was attempted. Witnesses said the acft was higher than normal, and after passing over more than one half of the usable runway, the pilot initiated a go around.…May 28, 1988 · N89443 · Substantial damageNTSB MIA88LA180Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Williston, FLThe plt dropped off parachutists at 8,500 ft and began to descend back to arpt. The a/c was descending at 145 mph, 19 inches mp, and 2300 RPM in a long circular pattern. The flt was on final between 500 and 1000 ft MSL when the plt tried to apply pwr. The eng…May 28, 1988 · N4057D · Substantial damageNTSB DEN88FA114Accident · 2 fatalField investigationFinal reportBeech D-17S · Wheatland, WYThe witnesses said they saw the acft fly a pattern indicative of a base to final approach to rwy 35. The airstrip has a second runway oriented east and west. The wind was blowing from the east at 20 knots. The acft wreckage was found approximately 3/4 miles…May 28, 1988 · N1038M · DestroyedNTSB LAX88LA199Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Scottsdale, AZWhile on final approach, the acft began to drift to the left. The plt applied rudder control, however, the acft continued to drift off centerline. The plt initiated a go-around; however, during the climb, the landing gear caught on the arpt boundary fence.…May 27, 1988 · N30289 · Substantial damageNTSB LAX88LA195Accident · Serious injuriesLimited investigationFinal reportCessna 182N · Prescott, AZAt the end of a cross country flight, while on final approach, the pilot reported that a sudden wind gust brought the nose up and the aircraft drifted right. Before the pilot could correct the situation, the aircraft stalled. The aircraft dropped to the…May 26, 1988 · N8918G · Substantial damageNTSB MIA88FA179Accident · 1 fatalField investigationFinal reportCessna 172K · Lake City, FLThe acft, while on a local flight, struck a telephone transmission line on the approach end of runway 1. Witnesses stated that they saw the acft takeoff to the west and make a right turn and go out of sight. Aprx three to five minutes later, they heard the…May 25, 1988 · N736VS · DestroyedNTSB MKC88LA096Accident · No injuriesLimited investigationFinal reportMccurry Taylor Monoplane · Marshalltown, IAThe pilot stated that he had intentionally shut down the engine-- so as to attempt a power off 'deadstick' landing. As he was descending, the pilot changed his plans and decided to restart the engine--but the engine would not start. While attempting the…May 24, 1988 · N4256B · Substantial damageNTSB FTW88FA110Accident · Serious injuriesField investigationFinal reportCessna 320-F · San Angelo, TXDrg fam flt, CFI noted fuel quantity low with selectors on aux fuel tanks. Drg arc to ILS apch, CFI allowed the rt eng to fail due to fuel starvation. CFI selected main tks and obtained restart. Apch was cont to a touch and go lndg performed by the ATP plt…May 24, 1988 · N73AT · Substantial damageNTSB NYC88LA145Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Brookhaven, NYLoss of power due to carburetor ice during an attempted go around. Pilot landed in scrub pines and airplane nosed over.May 21, 1988 · N96193 · Substantial damageNTSB MIA88LA174Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Geneva, FLThe pilot state that he encountered turbulence over a tree line while on short final approach. The aircraft began to sink and before the sink rate could be arrested the aircraft struck a tree. The aircraft touched down short of the runway.May 21, 1988 · N45980 · Substantial damageNTSB LAX88LA191Accident · Serious injuriesLimited investigationFinal reportBeech G-35 · Bullhead City, AZMay 19, 1988 · N4472D · Substantial damageNTSB ANC88LA060Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Asigiyukpak, AKDuring the approach to the beach area the pilot stalled the aircraft. The aircraft nosed over on its back during the landing.May 18, 1988 · N32CP · Substantial damageNTSB MKC88LA090Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T1A2 · Horton, KSThe PIC was executing touch and go lndgs when he reportedly experienced a shift in wind conditions. The acft impacted the ground short of the rwy. He said that the wings suddenly lost lift resulting in a high descent rate. The PIC reported no mechanical flt…May 17, 1988 · N3502L · Substantial damageNTSB MKC88FA089Accident · 1 fatalField investigationFinal reportAero Commander 690A · Little Rock, ARThe plt had just rtrnd fm vacation in the Bahamas bfr starting a flt fm Little Rock to atlanta with an intermediate stopat memphis. This itinerary was flwd by a rtrn flt to Little Rock via a reverse routing. Witnesses rprtd the plt said he had only 2 hrs of…May 17, 1988 · N660RB · DestroyedNTSB DEN88FA109Accident · 5 fatalField investigationFinal reportCessna T210N · Albuquerque, NMMay 17, 1988 · N5402Y · DestroyedNTSB ANC88FA057Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Wasilla, AKThe private pilot and passenger were making an approach to the Wasilla airport, Wasilla, AK, when the engine lost power. The pilot made a sharp 180 degree turn to try and reach a paved street about 3/4 of a mile short of the runway. The airplane stalled and…May 17, 1988 · N7224K · Substantial damageNTSB LAX88LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · San Carlos, CADuring a post maintenance test flight prior to sign off of an annual inspection, the engine quit and the pilot performed a forced landing in a mud field colliding with a dike. Examination of the engine revealed that a fuel pressure line had disconnected from…May 15, 1988 · N9601L · Substantial damageNTSB SEA88FA095Accident · 1 fatalField investigationFinal reportCessna 172L · Ocean Shores, WAThe student pilot departed on his fifth solo flight from the airport where he had been accustomed to originating his instructional flights. After several touch and go landings he proceeded to a nearby airport and conducted at least one more touch and go.…May 14, 1988 · N7935G · DestroyedNTSB SEA88LA093Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Prineville, ORThe pilot reduced power for landing and a high sink rate developed. The pilot attempted to increase power to correct the sink rate but got no response. Rotor rpm's were diminishing, so the plt lowered the collective to regain rpm's. the pilot elected make an…May 12, 1988 · N751AM · Substantial damageNTSB MKC88LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Concordia, KSWhile attempting a crosswind landing, PIC decided to make a go-around. During the go-around the acft stalled, struck the terrain and cartwheeled.May 12, 1988 · N8240B · Substantial damageNTSB CHI88LA113Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Nauvoo, ILThe pilot was making a 'fast low approach' to a private airstrip near his home when he realized he was coming too close to a row of trees. The pilot stated he became so preoccupied with trying not to hit the trees that he did not notice how close the aircraft…May 12, 1988 · N757ZY · DestroyedNTSB MIA88IA168Incident · No injuriesIncident investigationFinal reportPiper PA-42-720 · Chicago, ILCondor flt 610 (Mcdonnell Douglas DC-10, german registration: dadso) was aprx 2 hrs late as the flt crew members were preparing to takeoff. Subsequently, flt 610 was clrd for takeoff with instructions to cross the 5 DME (on the standard instrument…May 11, 1988 · N900MP · 2 aircraft · No damageNTSB MIA88IA167Incident · No injuriesIncident investigationFinal reportBeech 200 · Chicago, ILMidway flt 172 (Mcdonnell Douglas DC-9, N1065T) was on an IFR departure from Chicago midway arpt at the same time that Beech 200, N981LL, was on an IFR arrival for a visual apch to merrill c meigs arpt, although both were in VMC. Previously, o'hare TRACON had…May 10, 1988 · N981LL · 2 aircraft · No damageNTSB CHI88FA110Accident · No injuriesField investigationFinal reportBoeing 747-136 · Chicago, ILFailure of the number three flap track due to stress corrosion cracking. Factors contributing to this failure are insufficient design of the member and inadequate inspection and maintenance procedures to detect cracks before they propagate to a critical…May 9, 1988 · GAWND · Substantial damageNTSB NYC88LA136Accident · Serious injuriesLimited investigationFinal reportBeech A23-24 · Lyons, NYPilot failed to maintain airspeed during his go around.May 8, 1988 · N7982L · DestroyedNTSB NYC88LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Blairstown, NJThe flight was on final for runway 7 following another airplane, when the pilot's attention was drawn to a glider maneuvering in the area. He yielded left to maintain a comfortable distance from the glider and failed to observe an antenna tower in his path.…May 7, 1988 · N6762P · Substantial damageNTSB SEA88LA088Accident · No injuriesLimited investigationFinal reportCessna 172M · Hood River, ORPlt had diverted back along course to land because of observed wx ahead. On late final, a strong wind gust tipped the acft to near wings-vertical attitude. Plt managed to correct to wings level but could not control altitude loss before ground contact. Plt…May 6, 1988 · N12659 · Substantial damageNTSB MKC88LA087Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Waldenburg, ARThe acft was being positioned for an aerial application operation. While landing, the acft struck a 1.5 ft levee at the end of the private grass strip. Subsequently, the main gear sheared off, the wings were buckled & the prop was damaged.May 6, 1988 · N6782K · Substantial damageNTSB ATL88LA163Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Canfield, OHThe plt reported that the he elected to go-around after realizing he was going to land long. A gust of wind lifted up the left wing as he initiated the go-around, and he lost control of the airplane. It subsequently impacted the terrain on the right side of…May 2, 1988 · N5061M · Substantial damageNTSB NYC88FA133Accident · 1 fatalField investigationFinal reportBell 206B · Long Island Cty, NYThe Bell 206B was on a sightseeing flight around the Island of manhattan when it experienced a low rotor RPM situation. The pilot said he could not recover rotor RPM and made a forced landing in the east river. The pilot and three passengers exited the…May 1, 1988 · N7094J · DestroyedNTSB ATL88FA158Accident · No injuriesField investigationFinal reportBeech E18S · Cynthiana, KYThe plt was repositioning the airplane from an on-demand air taxi freight flight. He was en route from rochester, NY to huntsville, al with a planned refuel stop at louisville, KY. Near falmouth, KY he changed his destination to lexington 'due to a developing…Apr 29, 1988 · N300W · DestroyedNTSB LAX88FA169Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Hayward, CAPilot's failure to detect an uncommanded propeller feathering procedures established in the pilot's operating handbook.Apr 27, 1988 · N3588Y · Destroyed