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 NYC82FHD09Accident · Minor injuriesFinal reportLuscombe 8F · Essington, PAThe float equipped Luscombe stalled during fanal approach to a water landing near a dock. There was considerable rotorcraft activity near the seaplane base due to the presence of the queen elizabeth ii ocean liner.Apr 25, 1982 · N1552B · DestroyedNTSB NYC82DNC08Accident · Serious injuriesFinal reportSchleicher ASW-19 · Moultonboro, NHSeveral witnesses saw the glider circle over the airport before it crashed. One of the witnesses reported that the glider was about 50 to 100 ft high and was coming in normally when it suddenly nose-dived and headed almost vertically toward the ground. The…Apr 25, 1982 · N79RC · DestroyedNTSB LAX82FVD14Accident · Minor injuriesFinal reportCessna 172N · Hayward, CAWhile on final approach for a simulated short field landing, the engine lost power. The pilots were unable to restart the engine, and the aircraft struck a fence and nosed over during the landing. Conditions were favorable for carburetor ice, but the…Apr 25, 1982 · N21551 · Substantial damageNTSB CHI82DA139Accident · No injuriesFinal reportCessna 150M · Cortland, OHThe pilot stated that he was on final approach with flaps at 40 degrees and with an airspeed of 60 mph. The tail of the aircraft collided with a high tension wire forcing the nose down into a rail airport fence. The weather information for denman field was…Apr 25, 1982 · N45476 · Substantial damageNTSB CHI82DA137Accident · No injuriesFinal reportCessna 150 · Blaine, MNWhile on final approach the pilot stated that the engine lost power. The aircraft landed about 700 feet short of the runway in rough terrain. Investigation disclosed at least 1 1/2 pints of water in the left fuel tank, water in the carburetor bowl, and the…Apr 24, 1982 · N5729E · Substantial damageNTSB CHI82DA131Accident · No injuriesFinal reportHartman KR-II · Columbus, OHOn final approach the aircraft settled and collided with trees that were located approximately 75 ft from the approach end of the runway. The pilot stated that he allowed his airspeed to become too slow and that he applied power but the right wing caught a…Apr 24, 1982 · N58RH · Substantial damageNTSB ATL82FKG11Accident · 2 fatalFinal reportCessna 210 · Lexington, GAIn the early morning hours on 4/23/82, the aircraft departed covington, GA and proceeded on an undetermined route. At about 2300 PST that night, residents near the accident site heard the sounds of a crash. The wreckage was found the next morning about 1000…Apr 24, 1982 · N4614Q · DestroyedNTSB NYC82DA077Accident · No injuriesFinal reportCessna 172D · Endicott, NYWhile en route from poughkeepsie to utica, NY, the pilot became disoriented and obtained radar vectors. He elected to land at the tri-cities airport, Endicott, NY when the plane was getting low on fuel. Gusty winds were encountered during the approach. The…Apr 22, 1982 · N2456Y · Substantial damageNTSB LAX82DA146Accident · 1 fatalFinal reportPiper PA-38-112 · Apple Valley, CAWitnesses observed the aircraft to be gliding on final approach with the engine at idle when it abruptly pitched nose down and struck the ground. The engine and both leading edges of the wings contacted the ground at the same time with no turning movement.…Apr 22, 1982 · N24082 · DestroyedNTSB MKC82IA059Incident · No injuriesIncident investigationFinal reportRockwell NA-265-65 · St. Louis, MOWhile enroute from grand island, NE to nashville, TN, the pilot noticed that the aircraft would not trim nose down, but that it would trim nose up normally. The pilot reduced speed and altitude and diverted to St. Louis, MO in order to have the problem…Apr 20, 1982 · N2N · Minor damageNTSB NYC82DA073Accident · No injuriesFinal reportFairchild PT-19 · Butler, PAThe instructor pilot was flying with the owner of the aircraft to help him get acquainted with his plane. While on final approach, the owner let the aircraft get low. He corrected by adding power, but reportedly raised the nose beyond the stall angle. The…Apr 18, 1982 · N49942 · Substantial damageNTSB FTW82DA134Accident · No injuriesFinal reportMaule M-5-210C · Kirbyville, TXOn 4/17/82, N62003 departed woodville, TX under visual meteorological conditions on a flight to Kirbyville, TX. The pilot stated that the attitude gyro had always been slow to erect and was still showing 10 degrees right bank when he arrived at Kirbyville. He…Apr 18, 1982 · N62003 · Substantial damageNTSB CHI82FA127Accident · 5 fatalField investigationFinal reportCessna 411 · Middlefield, OHThe purpose of the flt was to prepare for a FAA part 135 air taxi check ride which was scheduled later that week. The acft was observed during the approach with one eng shut down. During the turn to final the acft crashed 1/2 mi from rwy 28.Apr 18, 1982 · N3228R · DestroyedNTSB CHI82DA124Accident · No injuriesFinal reportCessna 172 · Salem, OHAfter returning from a local flight, the engine lost power before landing. The plane crashed about 35 ft from the approach end of runway 27. Two telephone poles were damaged. The wind was gusting to 35 knots. An examination of the engine revealed a…Apr 18, 1982 · N13226 · Substantial damageNTSB ATL82DA108Accident · No injuriesFinal reportBeech C23-180 · Greensboro, NCThe pilot stated that he experienced a failure of the right brake system preventing him from maintaining directional control during ground roll after landing on runway 09. The mechanic who removed the aircraft from the accident scene reported that tire tracks…Apr 18, 1982 · N2229L · Substantial damageNTSB MKC82DA066Accident · No injuriesFinal reportBeech B-19 · West Union, IAThe pilot was flying his newly purchased aircraft from cedar rapids, Iowa to West Union, Iowa. He had purchased the aircraft on the previous day and had received a checkout from the seller. The pilot reported that when he was on final approach, the aircraft…Apr 17, 1982 · N24582 · Substantial damageNTSB LAX82DUJ35Accident · Serious injuriesFinal reportSchweizer SGS 1-126E · Near Tucson, AZThe pilot was on a triangular round-robin course. On the third leg of the flight, he encounter unfavorable lift conditions and elected to land on a dirt road. He started a 270 deg turn to final approach. Reportedly, a strong, turbulent, wind shear condition…Apr 17, 1982 · N65937 · DestroyedNTSB DEN82DA064Accident · No injuriesFinal reportSchweizer SGS-2-33A · Colorado Spring, COThe student pilot reported that he came over the airport at about 1200 ft AGL to enter a downwind for landing. He stated that he encountered a moderate to strong sink and strong southerly winds. He estimated that the wind velocity was 45 to 50 mph at 1000 ft…Apr 17, 1982 · N2045T · Substantial damageNTSB SEA82DA054Accident · Minor injuriesFinal reportEvans VP2 · Athol, IDDuring the initial flight test of a homebuilt aircraft the engine quit just as the aircraft was entering downwind. The pilot selected a field and executed a forced landing during which the gear collapsed. The pilot stated that he felt the nose of the aircraft…Apr 16, 1982 · N13809 · Substantial damageNTSB MIA82DA097Accident · No injuriesFinal reportCessna 182G · Lake Wales, FLThe pilot stated that while on short final the engine would not respond to power increases and remained at idle speed. The pilot swerved around a building and dove the aircraft under wires finally coming to rest in a ditch. Examination of the fuel system…Apr 16, 1982 · N3212S · Substantial damageNTSB ATL82FA104Accident · 4 fatalField investigationFinal reportCessna 210-5 · Hendersonville, NCThe aircraft crashed on tree covered/rising terrain after the pilot was cleared for a night ILS approach to runway 34 at the asheville regional airport. The crash occurred about 1 to 2 mi south of the final approach fix while the aircraft was on an outbound…Apr 16, 1982 · N8113Z · DestroyedNTSB FTW82DA131Accident · Minor injuriesFinal reportCessna 150G · Lamesa, TXThe pilot was circling the airport at night when the engine began losing power. He applied carburetor heat, but power could not be regained. The propeller was windmilling when he landed in a flat, plowed field and nosed over. The pilot had suspected…Apr 14, 1982 · N3645J · Substantial damageNTSB CHI82DA120Accident · No injuriesFinal reportPiper PA-34 · Gaylord, MIDuring a night visual approach the aircraft landed about 90 ft short of the runway. The aircraft slid across the ground onto the runway pavement and swerved to the right striking a runway light and ending up on a snowbank.Apr 14, 1982 · N8691E · Substantial damageNTSB ATL82DA100Accident · Minor injuriesFinal reportS.N.I.A.S. AS350D Astar · Alcoa, TNWhile preparing to land, the pilot experienced a tail rotor drive failure at a speed of less than 60 knots. At that speed, he was unable to make the necessary right turn from his position to land on the runway. Instead, he climbed about 50 ft in a left turn…Apr 12, 1982 · N3605B · Substantial damageNTSB MKC82FA055Accident · Serious injuriesField investigationFinal reportMartin-Pitts S1S · Grain Valley, MOThe plt estimated the fuel gauge indicated about 10 gals during preflight. The fuel gauge is a clear tube extending from the bottom of the tank up the right side of the cockpit. A dipstick was not available. The plt flew to liberty, MO made two landings &…Apr 11, 1982 · N61RM · Substantial damageNTSB FTW82DA121Accident · Minor injuriesFinal reportCessna 172P · Albuquerque, NMThe aircraft with a full load at a high density altitude (7800 feet) failed to climb. Upon turning downwind at low altitude the aircraft appeared to stall and collide with the ground.Apr 11, 1982 · N62619 · Substantial damageNTSB NYC82DA071Accident · No injuriesFinal reportPiper PA-28-181 · Allentown, PADuring final approach the landing gear collided with a snowbank and the aircraft skidded on its nose and main landing gear, coming to rest approximately 30-50 yards from the approach end of the runway.Apr 10, 1982 · N2531U · Substantial damageNTSB MIA82FA092Accident · Minor injuriesField investigationFinal reportCessna 421B · Ft. Lauderdale, FLReportedly, the left engine quit during an approach to land while the aircraft was at about 500 ft AGL with the gear and flaps down. The pilot stated that he immediately checked the fuel selector handles to be sure they were both in the indent, which they…Apr 6, 1982 · Y207P · Substantial damageNTSB ATL82FA093Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Bostic, NCThe aircraft crashed in a steep nose down attitude about 5 mi east of the destination airport. When the airport operator went home at about 1830 EST, he noted that a 350 ft mountain peak near his home was obscured by clouds. At about that same time, he…Apr 6, 1982 · N9610J · DestroyedNTSB ANC82DA031Accident · Minor injuriesFinal reportCessna A185E · Juneau, AKDuring an approach to land, the pilot of the amphibious aircraft extended the gear and performed his prelanding checks. He stated that while he was descending, he noticed an excessive loss of altitude and began to add power. However, the engine did not…Apr 6, 1982 · N4745Q · Substantial damageNTSB CHI82IA113Incident · No injuriesIncident investigationFinal reportCessna 402B · Waukegan, ILPilot reported an oil leak in the right engine to controller while on an instrument approach to Waukegan airport. Several minutes later, pilot reported that he had lost sight of the airport and due to loss of power in the right engine, elected to land in a…Apr 5, 1982 · N69341 · Minor damageNTSB CHI82DA114Accident · Minor injuriesFinal reportCessna T210L · Detroit, MIThe pilot elected to land at an alternate airport when he encountered poor visibility and icing conditions. While receiving vectors to Detroit metro the pilot reported he was low on fuel and needed to land. During the approach the engine quit. The aircraft…Apr 5, 1982 · N210LV · Substantial damageNTSB SEA82DA042Accident · No injuriesFinal reportCessna 150H · Camas, WADuring the pilot's sixth touch and go landing the aircraft struck a tree on short final. The pilot maintained control of the aircraft and completed his landing.Mar 30, 1982 · N22609 · Substantial damageNTSB ANC82DA029Accident · No injuriesFinal reportCurtiss-Wright C-46A · Wulik River Str, AKDuring arrival, the pilot noted that there was a cargo plane being unloaded at the end of a 4100 ft, snow covered runway. He elected to land from the opposite end within the first 4000 ft. the wind was calm. During the landing flare, the right main gear…Mar 28, 1982 · N9852F · Substantial damageNTSB CHI82IA102Incident · No injuriesIncident investigationFinal reportBeech 65-88 · Kalamazo, MIPrior to landing the pilot could not extend the right main landing gear. He attempted to extend the gear by recycling the system and by using the manual extension, but to no avail. Subsequently, the aircraft was landed on a paved runway with the gear…Mar 26, 1982 · N20HR · Minor damageNTSB DEN82IA049Incident · No injuriesIncident investigationFinal reportGulfstream G159-C · Denver, COOn final approach after a normal flight, the copilot became incapacitated while reading the final approach checklist. The captain continued the approach and made an uneventful landing. After the passengers had deplaned, the copilot suffered a seizure while he…Mar 25, 1982 · N857H · No damageNTSB FTW82DA114Accident · No injuriesFinal reportRockwell 690A · Conroe, TXThe pilot was too high on an IFR approach and elected to circle and land. During the turn he collided with trees but continued the approach and landed. The left wing and stabilizer were damaged.Mar 24, 1982 · N9101F · Substantial damageNTSB MIA82DA080Accident · No injuriesFinal reportPiper PA-38-112 · Near Opalocka, FLThe pilot stated that he was practicing forced landings in a soft field environment. The passenger added that the landing area was a levee bordered by water, trees, and vegetation. He further stated that the aircraft bounced hard and to the left off the…Mar 23, 1982 · N2463F · Substantial damageNTSB LAX82FUQ12Accident · 1 fatalFinal reportCessna 150M · Oxnard, CAThe student pilot departed hawthorne, CA at approximately 1000 PST on a solo cross-country flight to porterville, CA and return. During the flight the pilot became lost and landed at visalia, CA. While there he obtained fuel and directions to porterville and…Mar 23, 1982 · N63331 · DestroyedNTSB ATL82FA083Accident · Serious injuriesField investigationFinal reportBellanca 8KCAB · Carrollton, GAThe student completed a touch & go & was climbing out when the instructor took control. He told the student that he was going to show him what to do if the eng quit shortly after takeoff. At 150-180 ft above the rwy near the upwind numbers the instructor cut…Mar 23, 1982 · N50468 · DestroyedNTSB LAX82DA115Accident · No injuriesFinal reportCessna 152 · Winslow, AZThe pilot stated that he did a touch and go on runway 29, then pulled the power off at approximately 300 ft AGL over the intersection of runways 29 and 22. He reported that from there, he attempted to land on runway 22 with no power, failed to maintain…Mar 22, 1982 · N25782 · Substantial damageNTSB FTW82DA100Accident · No injuriesFinal reportCessna 310B · West Memphis, ARDuring a dual instruction engine out in a two engine aircraft a go around was attempted by the student pilot because of conflicting traffic in the pattern. The aircraft developed a high sink rate and the CFI landed the aircraft wheels up. The student raised…Mar 22, 1982 · N5417A · Substantial damageNTSB ATL82DA082Accident · Minor injuriesFinal reportCessna 177 · Jefferson, GADuring arrival, the wind shifted favoring runway 27. The pilot reported that he started his final approach at 80 mph and then slowed to 60 mph as he approached the threshold. Just as the aircraft crossed over a treeline, the aircraft suddenly dropped and hit…Mar 22, 1982 · N30569 · Substantial damageNTSB NYC82FA059Accident · 5 fatalField investigationFinal reportCessna T210M · Williamsport, PAThe acft impacted a mountain about 5 mi sw of the arpt at an elevation of approximately 1,400 ft while executing a missed approach from an ILS approach to rwy 27. The published missed approach procedure requires a climbing right turn to 3,700 ft via a heading…Mar 21, 1982 · N761MZ · DestroyedNTSB CHI82FA091Accident · 1 fatalField investigationFinal reportCessna 421 · Richmond, INDuring a VOR approach to runway 05 when 3 miles away from the airport at minimums ground contact was not made. The pilot stated that she elected to perform a missed approach but before power was applied the copilot raised the flaps. She further stated that…Mar 18, 1982 · N33KC · DestroyedNTSB ATL82FLJ06Accident · 2 fatalFinal reportBede BD-4 · Knightdale, NCTwo witnesses observed the aircraft on a low final approach for runway 19. They reported that the aircraft then turned to an easterly heading. One witness reported that the left turn appeared to be coordinated. The other witness heard the pilot add power…Mar 18, 1982 · N223LW · DestroyedNTSB SEA82DA038Accident · No injuriesFinal reportCessna 340 · Idaho Falls, IDThe pilot reported that during an ILS approach, he broke out at about 500 ft AGL. He stated that he did not properly arrest the sink rate and struck the runway. He also stated that there probably was some ice under the wings that had accumulated during…Mar 17, 1982 · N340RA · Substantial damageNTSB DEN82DA046Accident · No injuriesFinal reportBell 206B · Marble, COThe purpose of the flight was to transport ski guides to the top of a 13,000 ft mountain ridge. After climbing in moderate to high winds, the pilot approached the intended landing area from the lee side at an angle of about 45 degrees to the ridgeline. He…Mar 16, 1982 · N2169X · Substantial damageNTSB SEA82DA037Accident · Minor injuriesFinal reportPiper PA-18-135 · Richland, WAThe pilot was practicing short field landings. On this approach, he added power to arrest a high sink rate, but felt that the engine did not respond adequately. A hard landing occurred. The engine was examined, and during a test run, it operated…Mar 14, 1982 · N1578P · Substantial damageNTSB NYC82FNC05Accident · Serious injuriesFinal reportCessna 210 · Carrabassett, MEDuring a straight-in approach to runway 35, the aircraft touched down short of the threshold. It decelerated rapidly in deep packed snow, slid over a snow bank, and came to rest on the paved runway. The nosewheel collapsed and the pilot suffered serious head…Mar 14, 1982 · N3942Y · Substantial damage