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 NYC88DGM02Accident · Serious injuriesFinal reportBarker Quickie Q2 · Martinsburg, PAThe pilot reported he was practicing takeoffs and landings, and that he was 'determined to hold the approach speed to 80 and rate of descent to 500 feet per minute . . .' The approach was flown at dusk as light was beginning to fail. The pilot stated, 'I…Sep 28, 1988 · N244GB · Substantial damageNTSB NYC88LA243Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Keene, NHThe plt received a head inj and was not able to relate the details of the acdt. The acft crashed into trees about 3 mi short of the landing rwy at the conclusion of a cross country flt. An FAA insp examined the wreckage and reported that the fuel selector was…Sep 26, 1988 · N8289T · DestroyedNTSB NYC88DHM02Accident · Serious injuriesFinal reportAir Command 532 · Stormville, NYThe acdnt occurred as the non-certificated plt was operating the non-registered gyroplane in the traffic pattern. Witnesses heard a 'loud crack.' They then observed the gyroplane descending in an apparent unusual attitude. The gyroplane collided with trees,…Sep 26, 1988 · UNREG · DestroyedNTSB NYC88LA241Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Millbrook, NYThe private plt-in-command was seated in the right seat and his commercial plt-pax was seated in the left seat. The plt in command was at the controls. The acft was on final apch. The plt said the wind was from 170 deg. He did not give the wind velocity. He…Sep 25, 1988 · N94228 · DestroyedNTSB MKC88LA177Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Omaha, NEThe plt rprtd that when the acft was at aprx 150' to 200' AGL on final apch, the eng lost pwr & would not restart. Unable to rch the rwy, he lndd about 50' short on soft trrn, where the gear collapsed & the acft was dmgd. Only about 12 ounces of fuel was…Sep 25, 1988 · N31TB · Substantial damageNTSB LAX88LA328Accident · No injuriesLimited investigationFinal reportCentrair 101 · Vacaville, CAThe pilot flew over a field at 700 ft. a.g.l. to see if it was safe for landing. He turned the glider to establish a downwind leg. He then turned to the base leg. While turning onto final approach at a low altitude, the glider pitched up and rolled to the…Sep 25, 1988 · N101LV · Substantial damageNTSB NYC88LA240Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Burlington, CTThe plt was attempting to land at the mountain arpt. Patwas indicated the winds were from the north at 15 KTS. Gusts were not reported. The plt made her apch at 70 mph IAS and with 20 deg of flaps deployed. As she flared the acft, she encountered a gust of…Sep 24, 1988 · N3099X · Substantial damageNTSB CHI88LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orleans, INThe pilot failed to maintain an adequate visual lookout and to maintain adequate clearance from the utility pole and transmission wire. Contributing to the cause were the pilot's total lack of experience, task overload, and anxiety, stemming from a partial…Sep 24, 1988 · N21985 · Substantial damageNTSB SEA88LA184Accident · No injuriesLimited investigationFinal reportPiper PA-31T-620 · Eugene, ORPlt had IFR clrnc and was on ILS approach in VMC above thin fog layer at night. Plt had visual contact with runway environment but collided with 10 foot tall ILS middle marker antenna/building 1/2 mile from runway threshold, separating left main lndg gear and…Sep 23, 1988 · N234K · Substantial damageNTSB FTW88IA165Incident · Minor injuriesIncident investigationFinal reportBoeing 727-200 · Dfw Airport, TXFatigue failure of the left main landing gear door actuator pivot trunnion shaft which subsequently became lodged in the actuator clevis preventing the door unlock mechanism from actuating during gear extension.Sep 22, 1988 · N710AA · Minor damageNTSB MIA88LA270Accident · No injuriesLimited investigationFinal reportCessna 172 · Panacea, FLThe pilot stated that while attempting a go-around he inadvertently selected all flaps up and the aircraft crashed into the trees at the end of the runway.Sep 21, 1988 · N7048A · DestroyedNTSB CHI88LA238Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Kenosha, WIWhile on a VFR approach to the airport, at night, the pilot misidentified the street lights in a mobile home park as the runway lights and descended into wires. Afterward the pilot was able to continue to the intended runway and made a successful landing.…Sep 18, 1988 · N6252J · Substantial damageNTSB ANC88LA143Accident · No injuriesLimited investigationFinal reportMaule M-4 · Cordova, AKWhile on base leg to the airport, the engine stopped producing power forcing the pilot to land the airplane on the tundra short of the runway. Upon landing the airplane nosed over. Subsequent examination of the engine showed water in the carburetor. The water…Sep 18, 1988 · N2044U · Substantial damageNTSB LAX88LA325Accident · No injuriesLimited investigationFinal reportBell 206L · Lihue, HIDuring a local sightseeing flight, the pilot reported that while on final approach for landing, the audio and light for low RPM sounded and illuminated. The helicopter was autorotated. It initially bounced when it touched down, then landed hard. The engine…Sep 17, 1988 · N278KA · Substantial damageNTSB ANC88LA142Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Figure 8 Lake, AKThe pilot-in-command was landing in one foot tall grass near a duck hunting shack and struck a log. He landed the airplane after striking the log and during the landing roll, the main landing gear collapsed. The plt stated that he overflew the lndg area and…Sep 17, 1988 · N64CW · Substantial damageNTSB ATL88LA250Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Surf City, NCA landing was attempted at a private turf strip in gusty wind conditions. At level off for a 3-point landing on rwy 24, the right wing was lifted sharply by a wind gust. Right aileron and rudder were applied and power was added to go-around. As the airplane…Sep 13, 1988 · N96522 · Substantial damageNTSB SEA88LA178Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Shelton, WAAbout 10 mins after t/o, the plt noted the engine running rough and elected to return to the point of departure for precautionary lndg. Approach was high and fast, leading to balked lndg. On throttle application, eng quit. Acft collided with trees beyond…Sep 11, 1988 · N54867 · DestroyedNTSB FTW88DRG09Accident · Serious injuriesFinal reportSchempp-Hirth Standard Cirrus · Briggs, TXPilot's failure to maintin sufficient airspeed as he maneuvered to re-align the glider during final approach for landing. This resulted in 45-60 degree bank angle at very low altitudes, which culminated in the less of control and collision with the fence.Sep 10, 1988 · N8083 · Substantial damageNTSB SEA88LA174Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Gasquet, CAThe pilot stated that as he turned final approach, intense sunglare was encountered. The plt executed a go-around 'in the blind,' and collided with trees in approach path. The acft remained flyable and the pilot diverted to medford, Oregon.Sep 9, 1988 · N8541P · Substantial damageNTSB NYC88FA235Accident · 3 fatalField investigationFinal reportCessna 182RG · Greenville, METhe non-instrument rated pilot apparently could not locate the destination airport because of low ceilings and ground fog. Before the pilot started his trip he was advised by the fss that VFR flight to his destination was not recommended. It appears that the…Sep 9, 1988 · N6064C · DestroyedNTSB LAX88LA313Accident · No injuriesLimited investigationFinal reportCessna 172K · Fresno, CAThe pilot stated that he had mistakenly lined up for final approach on taxiway rather than runway 29L as instructed. When he was on short final the control tower informed him of his mistake. While maneuvering to line up on runway 29L, the pilot lost control…Sep 8, 1988 · N79226 · Substantial damageNTSB LAX88FA314Accident · 1 fatalField investigationFinal reportCessna 177RG · San Luis Obispo, CAPilots erroneous interpretation of his missed approach clearance, and, his performance of the published missed approach procedure for the santa maria ILS instead of the San Luis Obispo localizer.Sep 8, 1988 · N33283 · DestroyedNTSB MIA88LA266Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Punta Gorda, FLThe plt was returning from VFR xc flt during which many climbs, descents & detours were made to avoid adverse wx & maintain VFR. He stated the strong headwinds considerably reduced his grndspeed. At his 1st intended ldg arpt, strong gusty x-winds made the…Sep 6, 1988 · N8670P · Substantial damageNTSB FTW88FA162Accident · 1 fatalField investigationFinal reportCessna 172P · Marietta, OKThe plt elected to land on rwy 17 with wind from 300 degrees at 6 knots. During the second go-around the airplane's left wing struck a tree at a point 30 feet above the ground and the aircraft ended up inverted in a parking lot. Plt stated he had landed at…Sep 5, 1988 · N99144 · DestroyedNTSB DEN88FA199Accident · 1 fatalField investigationFinal reportGlasflugel H-301 · Salida, COWitnesses said the acft was aprx 200 ft AGL on the downwind leg, but close in to the rwy as it returned to the arpt for landing. Acft entered a 60 deg right bank to base leg. Nose rose slightly and acft rolled inverted. Acft made one-half to three-quarters…Sep 5, 1988 · N71949 · DestroyedNTSB CHI88DER13Accident · No injuriesFinal reportPiper PA-22-150 · Cohasset, MNFailure of the PIC to maintain a proper glide path in order to clear obstructions along the flight path of his final approach.Sep 5, 1988 · N7222D · Substantial damageNTSB FTW88FA161Accident · 5 fatalField investigationFinal reportPiper PA-34-220T · Carthage, TXDrg a night arrival, the plt rprtd he could make a visual apch. At 2341:37 CDT, the ARTCC controller informed him the destn arpt was straight ahead at 12 mi & requested that he rprt when the arpt was in sight. At 2343:30, he rprtd the rwyin sight & the…Sep 4, 1988 · N83874 · DestroyedNTSB SEA88LA168Accident · Serious injuriesLimited investigationFinal reportCessna 180B · Dixie, IDWhile on final apch to land at the high alt arpt, the plt elected to go around & land at a slower speed. He rprtd that as he neared the rwy on the 2nd apch, the acft enctrd a sudden wind shear, which caused it to drop & bank to the left. Subsequently, the…Sep 3, 1988 · N5085E · Substantial damageNTSB DEN88LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260C · Hamilton, MTThe private plt was descending to the destination arpt at the conclusion of a 3.5 hr x-country flight. The plt said he selected the right main fuel tank and flew until the 'fuel was low to the point of exhaustion.' During a right turn, with the gear extended,…Sep 2, 1988 · N9436P · Substantial damageNTSB CHI88LA229Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Schaumburg, ILDuring an attempted night landing at an airport with inoperative pilot-controlled runway lights, the pilot made a series of low passes (approximately 6 passes) before trying to land. The aircraft collided with the top of a tree located slightly to the left of…Sep 2, 1988 · N28774 · Substantial damageNTSB FTW88DPJ11Accident · No injuriesFinal reportCessna 150F · Oklahoma City, OKThe student pilot had just returned to flying after an extended time. During the approach he failed to add carburetor heat and the engine failed when power was added. Automotive fuel was being used in the aircraft but the STC had not been complied with.Aug 31, 1988 · N6474F · Substantial damageNTSB BFO88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Charleston, WVThe plt was executing the ILS rwy 5 apch when he entered fog about 350 ft above the dh. According to the plt, upon reaching the dh he sighted the rwy and continued the apch. Afterward the plt said he deviated left of the localizer centerline and as he was…Aug 31, 1988 · N15948 · Substantial damageNTSB ATL88IA242Incident · No injuriesIncident investigationFinal reportBeech 23 · Frankfort, KYEngine quit during go-around from simulated engine failure. During completion of emergency procedure the fuel selector position was changed to opposite wing fuel tank. Later exam of the acft revealed that when the fuel selector valve handle indicated right…Aug 31, 1988 · N2341J · Minor damageNTSB CHI88FA226Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Toledo, OHFatigue fracture, for reasons undetermined, which lead to the loss of a propeller blade from the right engine. This in turn lead to the marginal controllability of the aircraft.Aug 30, 1988 · N4049P · DestroyedNTSB LAX88DUQ05Accident · Serious injuriesFinal reportSchleicher ASW-20BL · Red Mountain, CAAug 29, 1988 · N300Y · Substantial damageNTSB FTW88LA157Accident · No injuriesLimited investigationFinal reportCessna 150M · Killeen, TXAccording to the pilot/operator aircraft accident report, the private pilot had not flown in the previous 90 days. The pilot was practicing landings on a dark night and collided with power lines 1000 feet short of the runway. After colliding with the wires,…Aug 29, 1988 · N704SB · DestroyedNTSB SEA88LA165Accident · No injuriesLimited investigationFinal reportLatham Alco Coupe · Bremerton, WAPlt had about 4 hrs exp in make and model and 116 hrs total pilot time. Flew 'about 2 hrs' on 15 gals fuel and was making touch and go lndgs when power was lost. Acft nosed over during forced lndg in soft terrain. There was no evidence of fuel on board.Aug 28, 1988 · N2936 · Substantial damageNTSB MKC88DCA03Accident · Serious injuriesFinal reportLuscombe 8A · Painton, MOPilot did not maintian the proper decent rate on the final approach to the airport.Aug 28, 1988 · N1404K · DestroyedNTSB LAX88LA299Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chino, CAWhile on final approach, the instructor noticed the airspeed fall below 55 knots. He took control of the airplane from the student. The instructor pushed forward on the yoke and added full power to regain airspeed. He lost control of the airplane and it…Aug 27, 1988 · N67649 · Substantial damageNTSB FTW88LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Katy, TXFuel exhaustion induced power loss, which necessitated the forced landing. Contributing to this accident was the pilot's decision to attempt to continue the flight without being able to refuel, and becoming lost during that effort.Aug 27, 1988 · N7746U · Substantial damageNTSB CHI88LA225Accident · Minor injuriesLimited investigationFinal reportBeech B-95 · Alma, MIDuring approach to landing the pilot entered a steep (45 degree bank) left turn from base to final. The pilot stated that he did not realize it at the time, but this action unported the fuel line to the left engine, causing the engine to fail due to fuel…Aug 27, 1988 · N9673R · Substantial damageNTSB CHI88LA222Accident · Serious injuriesLimited investigationFinal reportPiper J-3 · Youngstown, OHThe aircraft experienced a total loss of engine power due to fuel exhaustion while on final approach to the runway. The aircraft sustained substantial damage, and the pilot was seriously injured when the aircraft impacted the ground approximately 25' short of…Aug 27, 1988 · N38346 · Substantial damageNTSB CHI88FA223Accident · Minor injuriesField investigationFinal reportBoeing 727-31 · Chicago, ILImproper procedural checklist in which a critical step was not listed.Aug 27, 1988 · N852TW · Substantial damageNTSB FTW88LA150Accident · Minor injuriesLimited investigationFinal reportAeronca 65-TL · Texarkana, TXThe airport operator stated he saw the airplane turn in to land. He said it appeared to stall and then make a quick turn to the left, into a tree.Aug 21, 1988 · N18460 · DestroyedNTSB ANC88LA113Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Dillingham, AKThe pilot-in-command was beginning his descent for landing at Dillingham, Alaska and did not apply carburetor heat until his engine began to sputter. The engine stopped producing power and the pilot was unable to restart the engine. He landed on the tundra…Aug 20, 1988 · N2542K · Substantial damageNTSB CHI88IA217Incident · No injuriesIncident investigationFinal reportBell 206L · Indianapolis, INAug 19, 1988 · N295CK · No damageNTSB FTW88LA153Accident · No injuriesLimited investigationFinal reportBell 206B · Pearland, TXThe helicopter was at 300 feet AGL, making an approach after a maintenance test flight, when the engine overtemped and engine power was lost. During the autorotation landing, the helicopter touched down hard. The acft eng began to decelerate prior to…Aug 18, 1988 · N16962 · Substantial damageNTSB ATL88FA231Accident · 1 fatalField investigationFinal reportCessna 172 · Adel, GAThe pilot had been briefed on the weather conditions along the intended route of flight. VFR flight was not recommended. The pilot elected to land at his alternate, and had reported visual contact. Local witnesses reported low ceilings and reduced visibility.…Aug 17, 1988 · N65790 · DestroyedNTSB ATL88FA230Accident · 3 fatalField investigationFinal reportBeech 60 · Pageland, SCThe airplane was observed to approach the airport from the northwest. As it crossed the northeast end of the runway, it initiated a right turn to cross the runway about the midpoint to a position for a left downwind for landing on runway 5. Its altitude was…Aug 16, 1988 · N21TP · DestroyedNTSB SEA88LA151Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Fallon, NVEng lost power on practice missed approach. Forced landing made in rough terrain. Investigation revealed right fuel tank empty, left tank contained about 25 gals. Fuel selector had no positive stop at 'off' position, no detent for right tank position. Left…Aug 14, 1988 · N25EM · Substantial damage