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 SEA82DA141Accident · No injuriesFinal reportPiper PA-28-161 · Olympia, WAThis was the student pilot's first night flight. The instructor pilot reported that on the second landing, the aircraft struck an elevated set of approach lights, short of the runway.Aug 13, 1982 · N8436B · Substantial damageNTSB MKC82IA143Incident · Minor injuriesIncident investigationFinal reportBoeing 737-291 · North Platte, NEThe pilot stated that the first officer was hand flying the aircraft on the IFR approach. Both flight crew members saw the approach and runway lights and confirmed the cloud ceiling was 300 ft and visibility was 3/4 mile. The approach was continued and the…Aug 13, 1982 · N7345F · Minor damageNTSB MKC82DA142Accident · 2 fatalFinal reportCessna 210J · Lees Summit, MOThe aircraft had been repainted at topeka, KS. On a return flight to Kansas city, MO, the pilot diverted to olathe, KS after finding clouds at the intended destination. He then departed on a night flight to Lees Summit, MO. After entering the traffic pattern…Aug 13, 1982 · N3331S · DestroyedNTSB DEN82FTA11Accident · 2 fatalFinal reportPiper PA-18 · Hardin, MIThe wreckage was found 3/4 mi west of the nw end of a farm rwy in the approximate position of where a right turn would occur from the downwind leg to the base leg of a right pattern to the se rwy. The wreckage showed evidence of a right rotational moment at…Aug 13, 1982 · N83620 · DestroyedNTSB CHI82DA306Accident · No injuriesFinal reportCessna 172 · Strongville, OHDuring a touch-and-go landing, the nose gear collided with wires about 1/4 mile short of the runway and the aircraft nosed over into trees. No malfunctions in the equipment were reported. The pilot reported that prior to impact, he was aware of the wires and…Aug 13, 1982 · N61775 · Substantial damageNTSB NYC82DA195Accident · No injuriesFinal reportChampion 7ECA · Lawrence, MAThe instructor pilot reported that there was a loss of power after the student had adjusted his pattern for another aircraft and turned on final approach. The instructor took control of the aircraft and landed on a street. During the landing the aircraft…Aug 12, 1982 · N2830G · DestroyedNTSB ATL82DA234Accident · No injuriesFinal reportGrumman American AA-5A · Providence, KYDense ground fog developed before the plt returned to land. He made two approaches & go-arounds before the accident, & each time he had to fly very low to see the rwy lights. The plt stated that during the third approach he was looking for the arpt & not…Aug 12, 1982 · N9722U · Substantial damageNTSB LAX82DA293Accident · Minor injuriesFinal reportBeech E55 · Payson, AZThe aircraft crashed on the runway after the pilot completed a flight of about four hours. He reported that both engines lost power in the traffic pattern. An investigation revealed there was no fuel remaining. The aircraft had a total usable fuel supply of…Aug 10, 1982 · N235J · Substantial damageNTSB NYC82FA188Accident · 1 fatalField investigationFinal reportCessna 310R · Danbury, CTApproaching the destination arpt, the plt was advised to plan a VOR rwy 24 approach & that he would be turned just inside the faf. At 0055, newark a/c identified the acft 3 mi north of the arpt still at 2,000 ft & asked the plt if he was able to execute the…Aug 9, 1982 · N98841 · DestroyedNTSB LAX82FA291Accident · 1 fatalField investigationFinal reportCessna 152 · Weaverville, CAThe student pilot was practicing takeoffs and landings at a unidirectional runway. The airport procedure was to takeoff downhill on runway 18 and to land uphill on runway 36. Pilots, who flew at the airport, stated that go-arounds were not made on runway 36…Aug 8, 1982 · N48754 · DestroyedNTSB NYC82DA185Accident · No injuriesFinal reportGrumman AA-5A · Wiscasset, METhe student pilot was making an approach and was low and slow. By the time the instructor took over the aircraft the recovery was slow and the aircraft touched down in rough terrain 500 feet short of the runway. The nose gear snapped offduring landing.Aug 7, 1982 · N8476B · Substantial damageNTSB NYC82DA184Accident · Minor injuriesFinal reportAeronca 11BC · Long Lake, NYThe pilot was making a 360 degree turn to survey a lake landing area when he lost airspeed and stalled as he spotted a landing area. The aircraft sank in 15 feet of water.Aug 6, 1982 · N4011E · Substantial damageNTSB LAX82DA289Accident · No injuriesFinal reportCessna 152 · Phoenix, AZDuring a dual instructional flight, the instructor pilot (ip) initiated a forced landing for a student by pulling the mixture control out. The forced landing was taken to an altitude of about 400 ft AGL, then the ip pushed the mixture control in and told the…Aug 5, 1982 · N6349M · Substantial damageNTSB FTW82DA313Accident · No injuriesFinal reportBellanca 8KCAB · Alvin, TXThe pilot was making an approach to land in calm wind conditions. About 100 ft from the approach end of the runway, the aircraft stalled and crashed.Aug 5, 1982 · N5503K · Substantial damageNTSB NYC82FA181Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Concord, NHThe plt was advised during the 0028 & 0203 wx briefings that VFR flt was not recommended. At 0304 the plt called fss to activate his flt plan & was again advised VFR flt was not recommended. At 0403 the flt was given Concord wx & at 0406WAS cleared into the…Aug 4, 1982 · N81786 · DestroyedNTSB CHI82DA302Accident · No injuriesFinal reportSonerai II · Peru, ILThe pilot stated this was the first cross-country in the aircraft the fuel consumption calculations were based on an estimated 4 gallons per hour. When the pilot realized a low fuel condition he decided to land enroute. During the landing approach at Peru, IL…Aug 3, 1982 · N52VM · Substantial damageNTSB ATL82DA225Accident · No injuriesFinal reportPiper PA-38-112 · Keyser, WVPilot was making a go-around over a 1700 foot runway. Full flaps were left down until end of runway and then raised to 21 degrees. Terrain was rising faster then aircraft was climbing. Aircraft struck trees and nosed down into the ground. Temperature was 85…Aug 1, 1982 · N2386K · DestroyedNTSB SEA82DA132Accident · Minor injuriesFinal reportCessna 172M · Donnelly, IDThe aircraft floated the entire length of the runway without touching down before a go-around was started. During the go-around, the left wing collided with a tree at near-stall speed. The aircraft yawed 180 degrees and impacted the ground going backwards.Jul 31, 1982 · N13359 · Substantial damageNTSB NYC82FNE04Accident · Serious injuriesFinal reportBellanca 7KCAB · Agawam, MAWhile setting up to land on rwy 23, the plt throttled back the eng & it quit. The acft crashed into a wooded area approximately 1/4 mi from the end of the rwy. During the post-accident eng run, the eng would not maintain 700 RPM at idle (manufacturers…Jul 31, 1982 · N57507 · DestroyedNTSB MKC82DA136Accident · Minor injuriesFinal reportCessna 210L · North Platte, NEDuring the flight, the pilot had managed his fuel by switching tanks at one to two hour intervals. While arriving, he had been using fuel from his right tank and elected to continue using it. As he was aligning the aircraft with the runway, he made a sharp…Jul 31, 1982 · N22447 · Substantial damageNTSB FTW82FRG34Accident · 1 fatalFinal reportBeech C23 · Port Aransas, TXWitnesses observed the acft on a high final approach to rwy 12 when a go-around was initiated over the rwy at approximately 150 to 200 ft AGL. The acft started a steep banked right turn to a downwind position. The bank continued and the acft descended rapidly…Jul 31, 1982 · N6631D · Substantial damageNTSB CHI82IA284Incident · No injuriesIncident investigationFinal reportCessna 182P · Oshkosh, WIThe pilot entered traffic pattern downwind as number 3 for landing. Traffic pattern spacing required a three mile final approach over lake winnebago. The pilot stated that there were two slower aircraft preceeding him and that spacing between aircraft was…Jul 31, 1982 · N21254 · Minor damageNTSB MKC82FCG18Accident · 2 fatalFinal reportThorp T-18 · Neosho, MOThe aircraft crashed after it entered the traffic pattern for a landing. A witness reported that he observed the aircraft close in on a base leg as the pilot began a turn to final approach. He estimated that the pilot was in a 60 deg turn at about 150 ft AGL,…Jul 30, 1982 · N75A · Substantial damageNTSB SEA82DA131Accident · No injuriesFinal reportCessna 172N · Roche Harbor, WAThe pilot flew to a private airstrip that was open to grazing animals. During arrival, he made a low pass to check that the runway was clear of animals and other obstructions. He then circled to land. During final approach, he noticed sheep coming onto the…Jul 29, 1982 · N9528G · Substantial damageNTSB NYC82IA170Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Flushing, NYTwa flt 524, a Boeing 727-231, was executing an ILS rwy 22 apch to laguardia airport when it encountered low level windshear on final apch. The apch was conducted in IMC. The crew reported that they broke out and observed the rwy centerline lights at 100FT…Jul 28, 1982 · N64323 · Minor damageNTSB DEN82DA147Accident · No injuriesFinal reportBell UH1B · Bryce Canyon, UTThe pilot was making an approach to a 10,000 ft mountain, let the RPM decay and made a hard landing. The density altitude was 12,500 feet. There was about 500 or 600 pounds of cargo on the long line.Jul 28, 1982 · N88389 · Substantial damageNTSB CHI82DA278Accident · No injuriesFinal reportPiper PA-23 · Ladysmith, WIA ferry permit was issued to fly the aircraft to the rusk county airport for an annual inspection. The previous annual inspection had been on 8/20/80. During the arrival at the destination, the approach was high, so the pilot elected to go around. At about…Jul 28, 1982 · N3092P · Substantial damageNTSB CHI82DA283Accident · No injuriesFinal reportQ-Berry Hawk · Noble, ILAbout 30 min after taking off on a local test flight, the pilot had entered the traffic pattern and was preparing to turn onto a crosswind leg, when the engine lost power. He attempted to restart the engine, but was unable. He attempted to glide to a runway,…Jul 27, 1982 · N72HQ · Substantial damageNTSB LAX82FUJ44Accident · Serious injuriesFinal reportHallquist Thunderbolt · Mesa, AZFormation flight came over the rwy upwind at 2,000 ft MSL. Plt was cleared #2 to land, peeled off & stalled during left turn to downwind. The plt recovered about 100 ft AGL but collided with a tall tree.Jul 25, 1982 · N125GH · Substantial damageNTSB LAX82DA276Accident · No injuriesFinal reportMorrisey 2150 · San Carlos, CAThe eng quit from fuel exhaustion & the acft made a forced landing 1/2 mi short of the destination arpt.Jul 25, 1982 · N5107V · Substantial damageNTSB DEN82DA142Accident · No injuriesFinal reportBeechcraft C-45H · Aurora, COThe pilot reported that he was unable to extend the landing gear by using either the normal or emergency systems. After repeated attempts to extend the gear, he elected to land with it configured in a free-fall position. He shut down and feathered both…Jul 25, 1982 · N444Q · Substantial damageNTSB ATL82DA211Accident · No injuriesFinal reportCessna 150 · Louisville, KYThe pilot took off on a local flight intending to make a touch and go landing. He reported that the engine operated normally at full power during takeoff, but when the power was reduced on downwind, the engine began to run rough, miss and would not hold a…Jul 25, 1982 · N63379 · Substantial damageNTSB CHI82DA269Accident · No injuriesFinal reportCessna 172N · Isle, MNThe pilot was on a cross-country flight and began an approach to a private airstrip. He reported that the weather conditions were good with light turbulence. About 100 ft from the threshold, the aircraft began to settle and the pilot added power. However, the…Jul 23, 1982 · N733CH · Substantial damageNTSB SEA82DA120Accident · No injuriesFinal reportHughes 369D · 35 W. Of Ketchi, AKThe pilot was conducting a sling load operation with a 50 ft cable attached. After the last sling load was moved to a new drilling site, the pilot elected to leave the cable attached since there was no suitable landing area nearby. He stated that the cable…Jul 21, 1982 · N58414 · DestroyedNTSB ATL82FLJ07Accident · Serious injuriesFinal reportGrumman American AA-1B · Gatesville, NCWhile on final approach for landing, the pilot added 1/3 flaps and adjusted the throttle to clear obstacles. He reported that when he was on short final, he was distracted by several deer that were approaching the touchdown point. The pilot theorized that…Jul 18, 1982 · N8870L · Substantial damageNTSB SEA82FYM21Accident · No injuriesFinal reportCessna TU206G · Hood River, ORThe eng failed as the plt switched from the left to right tank while turning base. He turned on the boost pump but the eng did not start. He switched back to the left tank & turned on the high boost. The eng failed to start & the acft crashed into an apple…Jul 17, 1982 · N756XW · Substantial damageNTSB DEN82DA135Accident · No injuriesFinal reportBeech A23 · Oakes, NDDuring a night landing, the aircraft touched down about 220 ft short of the approach end of the runway. Reportedly, the wheels struck a "washout" and the plane was substantially damaged.Jul 16, 1982 · N8878M · Substantial damageNTSB CHI82DA258Accident · No injuriesFinal reportLuscombe 8F · Belleville, MIDuring the approach the acft stalled about 20 ft AGL. The plt added power but the acft touched down short of the rwy & collided with a ditch.Jul 16, 1982 · N5PL · Substantial damageNTSB ATL82FIG10Accident · 1 fatalFinal reportWindwagon · Frederick, MDThis was the initial test flight for the experimental amateur built aircraft. Two gallons of fuel was added to the aircraft which did not completely fill the tank. After refueling, numerous high speed taxi runs and low altitude lift-offs and landings were…Jul 16, 1982 · N8519F · DestroyedNTSB SEA82FA111Accident · 4 fatalField investigationFinal reportCessna 172F · Oxbow, ORDuring the final approach the aircraft was observed to descend to approximately 50 feet above the river and then execute a pullup and begin a left turn to either reenter a left downwind or reverse the direction of landing. The pilot lost control, the left…Jul 15, 1982 · N8230U · DestroyedNTSB NYC82DA159Accident · No injuriesFinal reportCessna R172E · Latham, NYPilot reduced power to idle on final approach and when he tried to add power there was no response. No reason for failure was found.Jul 15, 1982 · N26209 · Substantial damageNTSB LAX82FA256Accident · 1 fatalField investigationFinal reportCessna 195 · Carson City, NVIt was reported the plt was going to make some touch & go landings before starting out on the cross-country. On the third approach the acft was observed on final approach, about 300 yds from the rwy, making a left turn of about 360 deg at a low altitude. At…Jul 14, 1982 · N301M · DestroyedNTSB DEN82DA134Accident · No injuriesFinal reportPiper PA-28RT-201 · Englewood, COWhile practicing power off approaches the pilot undershot the runway and landed short. Power was added but not soon enough to prevent an accident. The aircraft contacted the ground, turned 90 degrees, slid 50 yards and stopped.Jul 13, 1982 · N8277D · Substantial damageNTSB CHI82DA323Accident · No injuriesFinal reportPiper PA-18 · Ranier, MIPilot stalled turning on final approach and crashed into water. No malfunctions found.Jul 12, 1982 · N41039 · Substantial damageNTSB SEA82DA108Accident · No injuriesFinal reportGrumman AA-5B · Corvallis, ORThe aircraft contacted the surface while the pilot was making a low pass over the private airport. Fresh cut hay was windrowed at the edge of the strip. The hay caught on the landing gear and blew up into the elevators and the aircraft was damaged when it…Jul 11, 1982 · N81382 · Substantial damageNTSB LAX82DA254Accident · No injuriesFinal reportBlanik L-13 · Murrieta, CAPilot landed short of runway in a glider and impacted the ground at high speed with high sink rate. He had released early from an aerotow and descended at high airspeed with dive brakes open which accelerated his rate of sink. He was not injured in the…Jul 11, 1982 · N90639 · Substantial damageNTSB CHI82DA244Accident · No injuriesFinal reportFairchild 24R-46A · Franklin, WIThe pilot took off and remained in the traffic pattern to land on runway 27. He estimated that the wind was from 300 degrees at 10 knots. He reported that on final approach, he got too low; then about 200 ft short of the runway, his head wind was blocked by…Jul 11, 1982 · N77697 · Substantial damageNTSB FTW82DA275Accident · Serious injuriesFinal reportCessna 402B · Austin, TXBoth acft were approaching from the ssw & flying assigned headings. Neither acft had been assigned an altitude. Just prior to impat, approach control (a/c) told the C-402B to fly 360 to follow traffic & asked what his altitude was. When the plt responded he…Jul 10, 1982 · N87280 · 2 aircraft · Substantial damageNTSB DEN82AA132Accident · 1 fatalFinal reportPiper PA-24-250 · Billings, MTPlt decided to land enroute due wx. At 0803 he contacted Billings fss & was advised Billings wx was 5,000 ft broken. At 0809 he called Billings approach control (a/c) & advised he was 20 mi for landing. Enroute to arpt he was unable to locate the arpt due wx…Jul 9, 1982 · N5356P · Substantial damageNTSB ANC82DAG34Accident · Minor injuriesFinal reportJunior Ace D · Ninilchik, AKThe pilot reported that while he was maneuvering to land, the right rudder pedal became locked in the"full up position." This caused the aircraft to move through the air in uncoordinated flight. The pilot applied full power and banked the aircraft to the…Jul 9, 1982 · N8537P · Substantial damage