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 DEN82DA130Accident · Serious injuriesFinal reportAerospatiale SA316B · Meeteetse, WYPrior to this flight, a long line had been attached to the helicopter for an external load operation. However, there wasa change in the schedule and the pilot was instructed to return to the base camp with six passengers. When the pilot took off, he was…Jul 8, 1982 · N67081 · DestroyedNTSB MKC82DA119Accident · No injuriesFinal reportGulfstream AA-5B · Mankato, KSDuring a flight from des moines, Iowa to lamar, Colorado, the pilot elected to land at Mankato, Kansas for fuel. Reportedly, the pilot landed on runway 17 with the wind from 190 at 18 gusting 24 knots. The pilot stated that he established a steep, no flap,…Jul 5, 1982 · N74023 · Substantial damageNTSB DEN82AA127Accident · 2 fatalFinal reportCessna 310I · Denver, COUpon arriving in the Denver area, the plt had penetrated 15 mi into the tca before being radar identified. He was instructed by the apch ctlr to contact tower by telfon after landing. After switching to tower freq he had to modify hisright base to rwy 8L to a…Jul 5, 1982 · N8818N · DestroyedNTSB NYC82DA145Accident · No injuriesFinal reportPiper PA-23-250 · Ludlow, VTThe pilot stated that during the landing, he encountered wind shear and the aircraft touched down about two feet short of the runway. He reported a 30 degree slope at the lip of the runway. All of the landing gear failed. The aircraft slid off the runway and…Jul 4, 1982 · N5343Y · Substantial damageNTSB CHI82FA234Accident · 1 fatalField investigationFinal reportGoans G-5 · Kankakee, ILThe pilot was making his first flight since a special airworthiness certificate was issued. This aircraft was unique in that the rotor controls were cable instead of push-pull rods. The aircraft after takeoff started pitching up and down. This pitching…Jul 4, 1982 · N59CG · DestroyedNTSB CHI82DA232Accident · No injuriesFinal reportCessna 152 · Harlan, INReportedly, the pilot was demonstrating a forced landing to the passenger by moving the mixture to cut-off. He stated that another aircraft interferred with his approach and he was unable to restart the engine to go around. Subsequently, the aircraft nosed…Jul 3, 1982 · N65609 · Substantial damageNTSB MKC82DA112Accident · Minor injuriesFinal reportPiper PA-24-250 · Oberlin, KSThe pilots aborted a landing because of suspected landing gear problems. On the subsequent approach the engine stopped when the fuel selector was correctly changed by one pilot and reset incorrectly by the other pilot. During the forced landing the aircraft…Jul 2, 1982 · N5540P · DestroyedNTSB LAX82FUQ15Accident · 1 fatalFinal reportQuickie QAC-1 · Mojave, CAThe acft was built as a one-time only acft for record breaking distance flying, presumably for an around-the-world flight without refueling. Immediately after takeoff, the plt radioed the chase plane that he had some minor problem & was going to land. After…Jul 2, 1982 · N82X · DestroyedNTSB NYC82DA135Accident · No injuriesFinal reportPiper PA-28-140 · Ambler, PAThe student pilot stated that during the landing approach, she experienced windshear resulting in the aircraft landing short of the intended touchdown point. The nose gear and the left main gear were sheared off after the aircraft collided with a dirt…Jul 1, 1982 · N75286 · Substantial damageNTSB MKC82DA111Accident · No injuriesFinal reportGrumman AA1C · St. Louis, MODuring a dual training flight the aircraft was allowed to descend into a corn crop short of the runway. The aircraft continued to the runway but landed hard and collapsed the landing gear.Jul 1, 1982 · N9565U · Substantial damageNTSB DEN82DA122Accident · No injuriesFinal reportCessna 340 · Las Animas, COThe aircraft collided with a four foot high irrigation ditch 50 feet from the approach end of runway 8 during short final. The pilot stated that he had planned the touch down point close to the end of the runway because the runway was only 3800 feet long.…Jun 30, 1982 · N2745B · Substantial damageNTSB NYC82FA134Accident · No injuriesField investigationFinal reportPiper PA-31 · Bennington, VTWhile on approach to land, the pilot noticed the aircraft's gear warning lights were out and the circuit breakers were tripped. The pilot advised operations and started a fly-by when he noticed a fire in the left engine. The pilot feathered the left engine…Jun 28, 1982 · N620WF · Substantial damageNTSB MIA82DA144Accident · No injuriesFinal reportCessna 210N · Pensacola, FLThe pilot stated that the engine stopped running while on final approach to runway 18, at an altitude of about 250 to 300 feet. Unable to restore power the pilot elected to land wheels-up in an open field about 1/4 mile north of the approach end of the…Jun 28, 1982 · N6392Y · Substantial damageNTSB SEA82DA097Accident · Minor injuriesFinal reportMooney M20A · Twin Falls, IDDuring his preflight inspection, the pilot noted that the right fuel tank was partially full, but the left tank was nearly empty. The left tank was serviced with 12 gallons of fuel, but the pilot reported that the fuel selector was inadvertently left in the…Jun 27, 1982 · N8380E · Substantial damageNTSB NYC82FNA18Accident · Serious injuriesFinal reportCallair A-9 · Salisbury, MAAfter taking off, the pilot began an approach to pick up an advertising banner. A witness observed the plane circling to the right. He reported that as the plane turned right, it suddenly plunged straight to the ground. The aircraft crashed in a marshland.Jun 27, 1982 · N3590G · DestroyedNTSB NYC82DA132Accident · Minor injuriesFinal reportPiper PA-28-180 · Presque Isle, MEDuring a cross-country flight the pilot made two stops to avoid a slow moving front, the pilot stated he reached the destination later than planned and departed with less fuel on board than planned. The engine quit during the return flight. A forced landing…Jun 27, 1982 · N9592J · Substantial damageNTSB MKC82FCJ03Accident · Serious injuriesFinal reportCessna 177 · Near Qgallala, NEThe pilot reported that during the preflight, there was about 4 inches of fuel in one tank and about 3 inches in the other tank. However, he did not remember the accident or what happended for about a week thereafter. Witnesses reported that the engine quit…Jun 27, 1982 · N29397 · DestroyedNTSB MIA82DA143Accident · Minor injuriesFinal reportCessna 150 · Hollywood, FLWhile on final approach for landing, the pilot noticed a loss of power at about 500 ft AGL. He verified that his carburetor heat was on and pushed the throttle forward. Power was restored for a second, but once again, it was lost. While landing on hospital…Jun 27, 1982 · N6064G · DestroyedNTSB FTW82DA290Accident · Minor injuriesFinal reportRyan Aeronautics ST3KR (PT 21) · Friendswood, TXThe student pilot took off with a passenger to practice landings. On the second landing, the aircraft collided with a ditch short of the runway and flipped inverted.Jun 27, 1982 · N53999 · Substantial damageNTSB FTW82DA255Accident · No injuriesFinal reportCessna 172XP · Kennedale, TXThe aircraft collided with light unmarked aluminum wires during an approach to land at a private airport. These wires were not noticed when an overflight was made prior to landing. The aircraft was landed ok after the collision. The instructor was flying the…Jun 27, 1982 · N7319K · Substantial damageNTSB ATL82DA177Accident · Minor injuriesFinal reportPiper PA-22-150 · Hixson, TNThe pilot elected to takeoff on a dark night without runway lights. He stated that the runway lights were not available at the time since the operator was out of town. According to the pilot and other witnesses, at least part of the airport environment was…Jun 27, 1982 · N2604P · Substantial damageNTSB NYC82DA133Accident · No injuriesFinal reportGrumman AA-5A · Lincoln Park, NJOn final approach the aircraft seemed to sink and full power was applied. The aircraft collided with a fence at the approach end of runway 19 resulting in substantial damage. There was no preimpact malfunction or failure of the aircraft engine determined.Jun 26, 1982 · N26870 · Substantial damageNTSB LAX82AA235Accident · 3 fatalFinal reportCessna 320B · San Jose, CAThe C-172M had departed reid-hillview arpt (6 mi east) & improperly entered a right downwind for rwy 30R at San Jose. The C-320B had executed a go-around from rwy 30R due to other traffic & was in a climbing turn also entering downwind for rwy 30R. The C-320B…Jun 26, 1982 · N510BC · 2 aircraft · DestroyedNTSB FTW82DA254Accident · No injuriesFinal reportDowner Aircraft Industries Republic RC-3 · Llano, TXThe pilot was on a test flight to check the engine in the amphibious aircraft. As the landing gear was being lowered to land at the airport, a "pop" was heard. Reportedly, the noise occurred when the clevis on the rod end of the retract/extend cylinder…Jun 26, 1982 · N6441K · Substantial damageNTSB DEN82DA117Accident · No injuriesFinal reportCessna 188 · 25nm Sw Santa R, MTAfter dispensing his second load, the pilot returned to the airport where he circled to wait for traffic to clear the runway. About 1/2 way through the circle, the engine lost power and the pilot observed that the fuel gauges indicated empty. He landed on a…Jun 25, 1982 · N2066J · Substantial damageNTSB SEA82DA094Accident · No injuriesFinal reportPiper PA-28-180 · Toledo, WAThe pilot reported that before landing, he turned the fuel boost "on", applied carburetor heat, and set the power at roughly 1500 RPM. He reported that the mixture had been in the full rich position during the entire flight. He encountered a crosswind on…Jun 24, 1982 · N9544J · Substantial damageNTSB CHI82FER22Accident · Serious injuriesFinal reportAeronca 7AC · Maple Plain, MNThe pilot reported that he circled the farm area several times to find a suitable landing site. He decided on a portion of the farmer's field next to the house and made a final pass to inspect the area. During the pass, he saw some trees and reportedly…Jun 24, 1982 · N84554 · Substantial damageNTSB ANC82DA052Accident · Minor injuriesFinal reportCessna 182 · Kenai, AKWhile on a flight from mckinley park to Kenai, AK, the pilot flew around the east side of anchorage, so a passenger could take pictures. About half way through the flight, the pilot became concerned about his fuel supply but believed he could reach his…Jun 24, 1982 · N6347A · Substantial damageNTSB FTW82DA241Accident · Serious injuriesFinal reportPiper PA-38-112 · French Settleme, LAThe pilot departed shreveport, LA at 1400 CDT on the return part of a cross-country to jackson, MS. A VFR flight plan had been filed listing 3 1/2 hrs of fuel on board. At about 1706 CDT, the plane crashed near French settlement, LA, about 140 miles south…Jun 22, 1982 · N2495N · DestroyedNTSB LAX82FA230Accident · 1 fatalField investigationFinal reportCessna P210N · Jamul, CAThe plt was being vectored for another approach after executing a missed approach. At 1642 the plt was cleared for 5,000 ft. at 1643 the plt was given a heading of 090, vector for the final approach course. At 1647 the plt was given a heading of 340. The…Jun 21, 1982 · N6690P · DestroyedNTSB DEN82FTE19Accident · Serious injuriesFinal reportCessna 182 · Loma, COThe pilot while attempting to straighten the aircraft and go around collided with small trees and nosed over. The pilot stated that probably the indecision of trying to stop or abort the landing slowed the aircraft during the attempted go around.Jun 21, 1982 · N9886 · DestroyedNTSB MKC82DA109Accident · No injuriesFinal reportBalloon Works Firfly 7 · Ballwin, MOThe student pilot was demonstrating his ability to make 3 landings to meet the flight requirements for a private pilot rating. The first 2 landing were without incident. After the third takeoff, an increase in the wind velocity was encountered. For the third…Jun 20, 1982 · N1506A · Substantial damageNTSB LAX82DA227Accident · No injuriesFinal reportCessna 172 · Fremont, CAThe pilot reported that while on a final approach for landing, a sudden loss of altitude occurred when he was at about 150 ft AGL and the landing gear collided with powerlines near the approach end of the runway. Airspeed was lost after hitting the powerlines…Jun 20, 1982 · N1846V · DestroyedNTSB CHI82DA218Accident · Serious injuriesFinal reportMooney M20J · Duluth, MNPlt wx briefed at 2148 by kenora fss, ontario, Canada. Area & terminal forecasts indicated VFR conds to exist at Duluth. Subsequently, at 2151, Duluth arpt notamed closed, all rwy & approach lites out. The ILS rwy 9 g/s later went out of service, but not…Jun 20, 1982 · N201EC · DestroyedNTSB ATL82IA170Incident · No injuriesIncident investigationFinal reportMooney M20J · Dauphin Island, ALAfter a normal flight from birmingham, AL, the pilot executed a visual full circuit approach to runway 12 at Dauphin Island, AL. The pilot stated that he stabilized on final at 72 knots with full flaps and that he had a 5-10 knot crosswind from the south. The…Jun 20, 1982 · N201WX · Minor damageNTSB NYC82FNA20Accident · No injuriesFinal reportSmith Aerostar 601 · Martha'S Vineyard, MADuring an ILS with the autopilot coupler on, a high sink rate developed toward the end of the approach. The pilot uncoupled the autopilot and began a missed approach, but the aircraft hit the top of a tree. He diverted and landed at providence, RI without…Jun 19, 1982 · N71MA · Substantial damageNTSB NYC82DA130Accident · No injuriesFinal reportStinson 180-2 · Richland, NYWhile on a local flight, the pilot observed a front moving in, so he decided to return to the airport and land. He reported that there was no turbulence while he was on downwind or base and the wind sock was favoring runway 16. However, on final approach,…Jun 19, 1982 · N9513K · Substantial damageNTSB FTW82DA234Accident · No injuriesFinal reportBeech 77 · Jackson, LAWhile in the vicinity of Jackson, LA, the instructor pilot (ip) had the student make a simulated forced landing. The landing was to be to a full stop on the Jackson airport. According to the initial modification, the student allowed the aircraft to drift left…Jun 19, 1982 · N3726Z · Substantial damageNTSB DEN82DA107Accident · No injuriesFinal reportPiper PA-28-151 · Jackson, MTThe pilot stated that he overshot the runway by being too high and that it was his intention to go around for a second pass. He further stated that his airspeed was too low and that he was behind the power curve and was not able to climb out of the valley at…Jun 19, 1982 · N4346F · Substantial damageNTSB CHI82FER21Accident · Serious injuriesFinal reportBarrett BG-5 · Maple Plain, MNDuring landing approach the gyrocopter collided with a powerline. The student pilot lost control and crashed beyond the powerlines. The pilot was attempting to land in a farm field adjacent to a relative's house.Jun 19, 1982 · N8066B · DestroyedNTSB SEA82DA090Accident · Minor injuriesFinal reportHughes 269B · Mt St Helens, WAThe pilot intended to proceed to Mt St Helens to land near spirit lake. The winds in the vicinity of the desired landing point were too strong for a safe landing. Therefore, an alternate spot was selected below the ridge line and presumably sheltered from the…Jun 18, 1982 · N9352F · DestroyedNTSB ATL82FIG09Accident · 2 fatalFinal reportBellanca 7GCBC · Woodbine, MDAfter taking off from runway 21, the pilot made a left turn-out then reentered a downwind for runway 03. At about the same time, a Cessna 150 was departing from runway 21 and a glider entered the pattern to land on runway 03. Two witnesses observed the…Jun 18, 1982 · N5153X · DestroyedNTSB NYC82AA125Accident · 4 fatalFinal reportPiper PA-28RT-201 · Dunkirk, NYThe flt was cleared for a VOR rwy 24 apch. At 2226 the plt reported the arpt in sight. At 2228 the acft crashed 4,000 ftsouth of the departure end of rwy 24 on a heading of 115 deg. The jamestown,NY 2250 wx observation was partial obscuration, estimated 200…Jun 17, 1982 · N8192A · DestroyedNTSB SEA82DA107Accident · No injuriesFinal reportCessna U206 · Dry Bay, AKThe pilot reported that he arrived in marginal VFR weather conditions with rain and variable winds gusting to 12 knots. He stated that the windsock favored a landing to the east, downhill, to a wet grass runway. He reported that during a short field approach,…Jun 16, 1982 · N1952U · Substantial damageNTSB ATL82DA166Accident · Minor injuriesFinal reportPiper 22-160 · Lynchburg, VAThe pilot took off from newport news, VA on a VFR flight to south boston, VA. Later at dusk, he contacted the roanoke fss and asked for an "accurate fix" of his position. At that time, the pilot indicated that he was low on fuel. Fss personnel reported that…Jun 16, 1982 · N9843D · Substantial damageNTSB LAX82DA221Accident · Minor injuriesFinal reportWeatherly 201B · Greenfield, CAThe pilot took off with 1150 lbs of sulfur dust and a full load of fuel. When he arrived at the field to be dusted, he was unable to dispense his load due to the presence of laborers in an adjacent field. When the pilot returned to the airport with his load,…Jun 15, 1982 · N1280W · DestroyedNTSB CHI82FA209Accident · No injuriesField investigationFinal reportCessna 421 · Racine, WIThe plt stated he experienced moderate to severe turbulence enroute. A coupled ILS approach was flown without problems, but the plt stated he had to work hard. The flt broke out at about 1,000 ft MSL & at this time he acquired visual contact with the rwy. He…Jun 15, 1982 · N421CB · Substantial damageNTSB LAX82DA220Accident · No injuriesFinal reportCessna 172 · Lancaster, CADuring flight, the pilot landed at an airport to refuel. However, the fuel trucks were locked up and no one was at the UNICOM office, even though, the airport directory indicated the field was attended and fuel should have been available. The pilot…Jun 14, 1982 · N1580Y · Substantial damageNTSB FTW82FPG15Accident · Serious injuriesFinal reportPiper PA-28-140 · Gould, ARThe student pilot stated that he was making a landing over wires when he stalled and the aircraft nosed into the ground.Jun 14, 1982 · N4531X · DestroyedNTSB MKC82FCQ10Accident · Serious injuriesFinal reportBeech A35 · Bird City, KSThe pilot entered traffic to land on runway 26 at a private airport with no UNICOM and no usable windsock. He stated that on final approach, the aircraft encountered a gust of wind and rolled to the right. He was unable to recover. The right wing hit the…Jun 13, 1982 · N5200A · Substantial damage