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 LAX82AA106Accident · 6 fatalFinal reportBoeing KC-135A · Glendale, AZThe USAF KC-135 was on an IFR flt plan & executing a tacan 3L apch to luke afb. The AA-1 had departed sky harbour arpt &had been released by phoenix trsa. The AA-1 was heading westerly in airspace designated as a special traffic area & was required to have…Mar 13, 1982 · KC135 · 2 aircraft · DestroyedNTSB ANC82DA026Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Willow, AKThe owner of the aircraft was a student pilot. She asked a private pilot to accompany her after she had skis installed on the aircraft. She had been indorsed for solo flight in the aircraft, but had no qualified instruction on ski operations. The private…Mar 13, 1982 · N5621M · Substantial damageNTSB NYC82FFJ12Accident · Minor injuriesFinal reportPiper PA-32 · Syracuse, NYThe pilot took off on a VFR flight plan with a litter patient and 3 other passengers onboard. The right main fuel tank was used for about the first 30 minutes of flight, then the pilot switched to the left main tank. While en route, an IFR flight plan was…Mar 12, 1982 · N260BB · Substantial damageNTSB DEN82DA042Accident · No injuriesFinal reportBeech A36TC · Boulder, COThe pilot reported that during a normal approach, he encountered a severe downdraft in winds gusting about 40 to 60 knots. He started to abort the landing by raising the gear and applying full power. The pilot stated that he turned right to avoid a hill, but…Mar 12, 1982 · N3738J · Substantial damageNTSB NYC82FA050Accident · 1 fatalField investigationFinal reportCessna T337C · Bloomfield, CTAt 0630 & 0800 the plt received wx briefing for an IFR flt to bridgeport, CT & was advised of flt precautions for icing, low ceilings & visibilities. The flt departed at 0907. At 1118 the plt diverted to windsor locks for landing at bradley intl arpt because…Mar 11, 1982 · N7721X · DestroyedNTSB CHI82DA081Accident · No injuriesFinal reportPiper PA-23 250 · Grand Marais, MNAfter clearing trees located approximately 1000 feet from the end of the runway the pilot reduced power and added flaps in an attempt to land close to the approach end. The aircraft struck a snowbank on short final for the snow covered runway 27.Mar 8, 1982 · N6625Y · Substantial damageNTSB ATL82DA067Accident · No injuriesFinal reportPiper PA-28-181 · Murfreesboro, TNThe pilot estimated his fuel consumption to be 10 gal/hr. The actual consumption was about 12 gal/hr. Approximately 20 miles from his destination, he decided to make an enroute stop for fuel. While turning to final approach for landing, the engine quit. From…Mar 8, 1982 · N75029 · Substantial damageNTSB CHI82DA078Accident · No injuriesFinal reportPiper PA-30 · Valparaiso, INThe pilot reported encountering severe icing conditions after he had canceled his IFR flight plan and had the airport in sight. At that point, he felt that the safest alternative was to continue the approach. The approach was flown at 120 mph with no flaps.…Mar 5, 1982 · N34EE · Substantial damageNTSB LAX82DA092Accident · Minor injuriesFinal reportPiper J3F-65 · Chandler, AZWhile on a downwind leg of the traffic pattern, the pilot noticed a very loud grinding noise as if the engine was coming apart. He stated that the engine RPM became very high. He attempted to maneuver for a landing on the runway but entered a high sink rate.…Mar 2, 1982 · N38857 · Substantial damageNTSB FTW82DA075Accident · 2 fatalFinal reportBell 206B · High Island BlkThe aircraft was low on the approach and during the flare, the vertical fin and tail boom contacted the safety netting extending beyond the boundaries of the platform landing area. The aircraft then settled back off the platform with one main rotor blade…Mar 2, 1982 · N63AL · DestroyedNTSB ATL82DA063Accident · Minor injuriesFinal reportSmith Mini · Brownsboro, ALThe pilot took off with a malfunctioning fuel quantity guage. Before takeoff, he visually checked the fuel and estimated that the tank was about 1/2 full. After returning from a local flight, the engine lost power during a turn to final approach for landing.…Mar 2, 1982 · N37WS · Substantial damageNTSB LAX82FVA13Accident · 1 fatalFinal reportBeech T-34B · Lemoore, CAThe T-34 pilot entered a downwind behind a Cessna 150 aircraft. When the T-34 pilot was abeam the approach end of runway 32R, he was cleared for a touch and go. By this time, the Cessna 150 was on the runway. The Cessna pilot requested a 180 degree turn to…Feb 28, 1982 · N1410Z · DestroyedNTSB LAX82DA087Accident · Minor injuriesFinal reportPiper J3-F65 · Yerington, NVDuring final approach for a hard dirt field the pilot reported that the bottom fell out and he hit short resulting in substantial damage to the aircraft.Feb 28, 1982 · N23209 · Substantial damageNTSB NYC82FA041Accident · Serious injuriesField investigationFinal reportCessna 150G · Erwinna, PAThis was the student's first solo in powered aircraft. He held a private pilot certificate with a glider rating. His takeoff and traffic pattern appeared normal until the last part of his final approach for landing. About 600 ft short of the runway, the…Feb 27, 1982 · N3318J · Substantial damageNTSB MIA82DA059Accident · No injuriesFinal reportHughes 269C · Ft. Myers, FLDuring flight engine rpm's dropped and pilot immediately landed on a road. The pilot stated he attempted to check the engine power by bringing the helicopter to a hover and moving it approximately 30 feet three times. The power appeared normal so he elected…Feb 27, 1982 · N1100W · Substantial damageNTSB LAX82FUJ29Accident · Minor injuriesFinal reportCessna 182C · Eloy, AZThe aircraft crashed near the end of a runway on a dark night. The pilot stated to the police that he had run out of fuel. The police found weapons, drugs, and liquor in the pilot's possession. An estimated 3 gallons of fuel was found in each tank. According…Feb 27, 1982 · N8588T · Substantial damageNTSB CHI82DA074Accident · No injuriesFinal reportCessna 152 · Williamsburg, MIDuring a VFR approach the pilot stated he was concentrating on not landing long. The aircraft touched down in snow about 50 feet short of the landing area and slid, nose down, for approximately 50 feet. The pilot had flown a total of 3.2 hours in the last 90…Feb 27, 1982 · N47559 · Substantial damageNTSB FTW82FPA11Accident · No injuriesFinal reportBeech D18S · Dallas, TXDuring a night, ILS approach, the plane struck a powerline about two miles short of the runway after the pilot was provided a low altitude alert. The left engine lost power and was feathered. The pilot feared possible gear damage and left it extended. Unable…Feb 26, 1982 · N8517Z · Substantial damageNTSB LAX82DA082Accident · 1 fatalFinal reportCessna 172L · Gustine, CAThe pilot was familiar with the airport and the 35 ft power lines near the approach end of runway 36. During a night landing approach, the plane got low and the left wing struck a power line pole.Feb 21, 1982 · N4307Q · DestroyedNTSB CHI82DA067Accident · No injuriesFinal reportPiper PA-28-140 · Lakerville, MNWhile on downwind, the pilot moved the fuel selector to what he believed was the left tank position. He also moved the throttle to idle to simulate an engine failure. He extended his pattern to allow time for another pilot to back-taxi down the runway to the…Feb 21, 1982 · N1GF · Substantial damageNTSB CHI82DA061Accident · No injuriesFinal reportCessna 150 · Franklin, WIWhile practicing a no-flap landing, the student allowed the aircraft to descend below the normal glide path. The instructor told the student that they were going to be low and to add power. Power was added, but soon thereafter, the aircraft touched down short…Feb 20, 1982 · N63213 · Substantial damageNTSB CHI82DA058Accident · No injuriesFinal reportBeech 58 · St. Charles, ILDuring an IFR approach the pilot stated he picked up about 1/2 to 1 inch of ice on the leading edge of the wings after activating all icing equipment. After breaking out of the clouds the pilot descended with full flaps at 110 to 115 knots. He began to flare…Feb 19, 1982 · N1847X · Substantial damageNTSB NYC82DA037Accident · No injuriesFinal reportCessna T210N · Scotia, NYWhile on final approach, the engine lost power as the pilot pushed the prop control to high RPM. The pilot initiated emergency procedures but was unable to restart the engine. All switches were turned off and the aircraft was pulled up to a full stall and…Feb 18, 1982 · N510PE · Substantial damageNTSB DEN82FA034Accident · No injuriesField investigationFinal reportPiper PA-23 · Mitchell, SDAs the pilot approached sioux falls he received information that it was below minimums, so he started to divert. As he passed over sioux falls he could see Mitchell, SD, which appeared to be clear, therefore, he elected to land there. It continued to look…Feb 18, 1982 · N5799Y · Substantial damageNTSB FTW82DA060Accident · No injuriesFinal reportBellanca 7ECA · Henderson, TXAfter reducing power to idle, gliding for some distance, and then applying carburetor heat he realized that additional power would be needed to reach the runway. Power was added with no results and the aircraft was set down in a rough field approximately 1/4…Feb 17, 1982 · N53769 · Substantial damageNTSB DEN82DA032Accident · Minor injuriesFinal reportCessna 210 · Blanding, UTThe pilot reported that the visibility was five miles when he landed. However, according to the airport manager, it was less than one mile with ground fog. During the landing, the left wing struck the ground when the plane touched down short of the runway…Feb 17, 1982 · N4814K · Substantial damageNTSB ATL82FA055Accident · 8 fatalField investigationFinal reportPiper PA-31T2 · Springfield, KYThe flt was cleared to maintain 3,000 ft MSL until over the arpt, then cruise. The plt had previously stated that he could see the lights on the ground & that he was 15 mi from the arpt. At 2013 the plt stated "we oughta be able to cancel here." The acft…Feb 17, 1982 · N2517X · DestroyedNTSB LAX82IA075Incident · No injuriesIncident investigationFinal reportBoeing B737-2H4 · Ontario, CABecause the glide slope had been removed from service, air cal flight 754 was vectored by the Ontario TRACON 'n' controller for a localizer only approach to runway 26L. The first officer stated he descended to 1,200 ft after passing the faf/om. The captain…Feb 16, 1982 · N73717 · Minor damageNTSB DCA82AA015Accident · Minor injuriesFinal reportNihon YS-11A · King Salmon, AKThe acft was on a scheduled flt from anchorage to cold bay, AK with intermediate stops at King Salmon & dutch harbor, AK. En route between anchorage & King Salmon, the air temps at cruise altitude were between -36 & -40 deg fahrenheit. While entering donwnd…Feb 16, 1982 · N169RV · Substantial damageNTSB ATL82DLJ05Accident · Minor injuriesFinal reportCessna 150M · Fayetteville, NCWhile attempting a night landing to an airport runway marked only with reflectors, the aircraft contacted an embankment to the left of the runway.Feb 16, 1982 · N63536 · Substantial damageNTSB MIA82DA047Accident · No injuriesFinal reportCessna 172 · San Juan, PROn final approach the tower controller told the flight that other aircraft had reported wind shear below 800 feet. The pilot landed the aircraft and ran off the right side of the runway. The pilot reported wind gusts to 21 knots.Feb 15, 1982 · N21732 · Substantial damageNTSB CHI82DA047Accident · No injuriesFinal reportBeech 35 · Ottawa, OHThe aircraft contacted a 4-foot snowberm located between the approach lights and the end of the pavement during the approach. The pilot was aware of the snow berm by the published NOTAM.Feb 15, 1982 · N3859B · Substantial damageNTSB NYC82DA034Accident · No injuriesFinal reportBellanca 17-30A · Factoryville, PADuring the previous flight, there was a landing gear malfunction. A mechanic checked the gear and a decision was made to fly the plane with the gear down to another airport for maintenance. During the subsequent flight, the "gear down" speed was not exceeded.…Feb 14, 1982 · N14908 · Substantial damageNTSB CHI82DA055Accident · No injuriesFinal reportPiper PA-38-112 · Lebanon, INWhile the instructor was demonstrating recovery procedures from a low approach, the main gear struck snow on a small rise about 400 feet short of the runway. Subsequently, the pilot was forced to land in about 18 inches of snow and the gear failed. The…Feb 14, 1982 · N24007 · Substantial damageNTSB NYC82DA032Accident · No injuriesFinal reportCessna 172K · Plymouth, MAAfter entering the traffic pattern, the pilot completed his prelanding checklist while opposite of the numbers on downwind. After turning to final approach, there was a loss of engine power. He stated that he reached down and switched the fuel selector…Feb 10, 1982 · N84330 · Substantial damageNTSB MIA82FLD16Accident · Serious injuriesFinal reportCessna 310 · Lake Wales, FLThe flt encountered bad wx over the Lake Wales arpt. The plt put the gear down & was maneuvering for an approach. The pax stated that acft then crashed. The fuel tanks had approximately one pint of fuel remaining.Feb 10, 1982 · N5207J · DestroyedNTSB ATL82FID06Accident · No injuriesFinal reportCessna 402B · Newport News, VAThe pilot stated that during his first ILS approach, the localizer needle fluctuated to the left. He made corrective turns to the left. When he broke out of the clouds at the decision height (dh), he observed the runway to the right and made a missed…Feb 9, 1982 · N5218J · Substantial damageNTSB ATL82FKW04Accident · Minor injuriesFinal reportCessna 182P · Nashville, TNAfter entering a long final approach for landing, the engine lost power. While attempting to restart the engine, the pilot noted that he had not previously turned on the carburetor heat. He was unable to start the engine and maneuvered the plane to land in a…Feb 8, 1982 · N9479M · Substantial damageNTSB CHI82DA037Accident · No injuriesFinal reportErcoupe 415-C · Brownsburg, INThe pilot reported that during his visual approach for landing, he used full carburetor heat and cleared his engine during the base turn. While entering his final approach, he was too high and reduced his power below 1000 RPM for about 10 to 20 seconds. He…Feb 6, 1982 · N93607 · Substantial damageNTSB NYC82FHD06Accident · No injuriesFinal reportTed Smith Aerostar 600 · Toms River, NJThe pilot stated that during a VOR approach, he broke out at 600 ft and got the runway in sight. He reported that the visibility dropped frequently, but he was able to keep the runway in sight until he was about 200 yards from the runway. He stated that the…Feb 3, 1982 · N9759Q · Substantial damageNTSB NYC82FA029Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Newburgh, NYAt 2234 the plt was issued a vector to the initial approach fix for the ILS rwy 9 apch. He was also issued the followingwx "...stewart weather thirty minutes ago is estimated one thousand overcast six miles in light rain and haze." At 2238 the plt was advised…Feb 3, 1982 · N62481 · DestroyedNTSB NYC82AA028Accident · Serious injuriesFinal reportBeech 99 · Groton, CTAfter crossing the mondi intersection inbound for an ILS rwy 5 apch, the captain felt that a proper descent was not possible due to a strong tailwind & their present altitude. They turned & proceeded outbound to loose altitude. The crewthen established…Feb 1, 1982 · N451C · DestroyedNTSB NYC82DA017Accident · No injuriesFinal reportCessna 150L · Caldwell, NJThe student pilot was at the controls during a landing on runway 04. The wind was from 330 degrees at 15 knots. The instructor reported that the plane was slipped to the left on short final, and shortly thereafter, the right wheel struck a snowbank. The…Jan 31, 1982 · N17065 · Substantial damageNTSB MIA82DA039Accident · No injuriesFinal reportPiper PA-28-161 · Deland, FLWhile practicing normal approaches and landings the student allowed the aircraft to get too low on final approach. The instructor took the controls but was unable to prevent a touchdown short of the runway threshold.Jan 31, 1982 · N21481 · Substantial damageNTSB MKC82DA022Accident · No injuriesFinal reportCessna 172H · Wentzville, MODuring a cross-country flight, the pilot switched the fuel selector from both tanks to the right tank to balance the fuel. After the tanks were balanced, he failed to switch the selector back to both. During a night, final approach at his destination, the…Jan 29, 1982 · N5333T · Substantial damageNTSB ATL82FID05Accident · No injuriesFinal reportPiper PA-38-112 · Charlottesville, VAAfter performing four successful night approaches the pilot attempted a short field approach with the landing light off. On final he stated it appeared he was getting too low so he turned the landing light on and continued the approach. The aircraft struck a…Jan 28, 1982 · N2466B · Substantial damageNTSB ATL82DA043Accident · No injuriesFinal reportPiper PA-32-260 · Louisville, KYAt 600FT AGL while on a 3 mile straight in visual approach,the engine quit. The pilot stated he had insufficient time to attempt a restart and commenced a 180 degree turn toward a golf course. Upon landing the aircraft struck a tree. Investigation revealed no…Jan 28, 1982 · N3654W · Substantial damageNTSB SEA82FYK07Accident · 1 fatalFinal reportCessna 172 · Lapine, ORWhen the pilot landed at lakeview,OR,he checked the weather but reported to his passenger that although the weather was bad he did not want to stay in lakeview. The aircraft departed lakeview, following a highway, when the weather conditions continued to…Jan 24, 1982 · N8172B · DestroyedNTSB NYC82FNA10Accident · Minor injuriesFinal reportCessna 172 · Taunton, MAThe student pilot took off at night on an unsupervised pleasure flight. His passenger did not hold any type of pilot certificate. After takeoff, the pilot encountered fog. He used the nbd for orientation and was able to return to the airport. He reported…Jan 24, 1982 · N80420 · Substantial damageNTSB FTW82AA046Accident · 7 fatalFinal reportRobertson C-402B · Laredo, TXThe acft was observed to be extremely slow throughout the approach & that the plt appeared to be having some difficulty with over-controlling the acft. It then leveled out at 50-80 ft AGL on final over the threshold, entered a nose-high attitude & then…Jan 24, 1982 · N4244Z · Destroyed