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 CHI84LA312Accident · Serious injuriesLimited investigationFinal reportBurns Soneria II · Woodsfield, OHThe a/c departed clinton, MD, for a VFR flt to Woodsfield, OH, with a planned refueling stop at manassas, VA. En route the plt observed an abnormal fuel comsumption rate but still attempted to reach the destination arpt. About 3NM out the eng quit due to fuel…Jul 26, 1984 · N423ST · Substantial damageNTSB MKC84LA230Accident · No injuriesLimited investigationFinal reportMooney M20C · Hannibal, MON7702M experienced an electrical failure en route & diverted to Hannibal. Plt stated he circled the arpt, saw no traffic& decided to land to the south. N38455 had just landed to the north and was on the rwy when the plt saw N7702M attempting to land in the…Jul 25, 1984 · N7702M · 2 aircraft · Substantial damageNTSB CHI84FU008Accident · 1 fatalFinal reportMattison MAC Ultralight · Three Lakes, WIThe recently purchased ultralight was taxied for about 40 minutes prior to the new owner trying his first flt. He had been advised by the former owner to make short hops at low altitude during a familiarization period. The former owner wanted to be present…Jul 24, 1984 · UNREG · DestroyedNTSB NYC84LA251Accident · Minor injuriesLimited investigationFinal reportCessna C172 · Bloomsburg, PAThe acft was ditched in a river during an attempted go-around. The plt said he approached the arpt with full flaps at about 70 mph. During the aborted landing he applied full power and then experienced a sudden low left wing, a mushy control feeling and a…Jul 23, 1984 · N2627L · Substantial damageNTSB SEA84LA180Accident · No injuriesLimited investigationFinal reportCessna 150K Aerobat · Blaine, WAThe student pilot had just returned to his home airport after a x-country flight. He had not refueled at the last airport and was aware that both fuel gages were below one quarter tank. He said that his first approach was two high. The second approach was…Jul 22, 1984 · N8315M · Substantial damageNTSB MIA84LA207Accident · No injuriesLimited investigationFinal reportMosley High School Acro - Sport #1 · Panama City, FLThe plt inadvertantly shut off the mixture when he retarded the throttle for landing. When the throttle was later advanced the engine did not respond. The plt took no corrective action to restart the engine and made a forced landing short of the arpt. The plt…Jul 22, 1984 · N3783G · Substantial damageNTSB SEA84LA181Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Creswell, ORThe acft was on a night VFR flt from san carlos, CA, to eugene, OR, when the plt asked apch control how for away the arpt was. ATC informed the plt that the arpt was 16 miles further. About 3 minutes later, the left fuel tank was emptied. The plt switched to…Jul 21, 1984 · N8732E · Substantial damageNTSB NYC84LA253Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Seboomook Lake, METhe acft was on final for a water landing when a bird hit the windscreen according to the plts statement. A witness who observed a dark object (thought to be a cormorant, since several were seen in the area before & after the accident) saidthe object floated…Jul 21, 1984 · N9276D · Substantial damageNTSB LAX84FA415Accident · 1 fatalField investigationFinal reportde Havilland DHC-6-300 · Tau, AntarcticaThe acft crash landed after the plt used flaps and power to semi-control pitch after the elevator down control cable failed at about 300 ft AGL on final approach. The left wing of the acft hit the terminal roof during the stall mush FROM50 ft AGL. The company…Jul 21, 1984 · N43SP · Substantial damageNTSB MIA84FA204Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · St.Simons Is., GAThe acft crashed during a forced landing after a power loss on final apch. The plt reported to fss on a 3 mile final and then reported the power loss and said he would make a 'dead stick' landing. Shortly thereafter, fss received an ELT signal. The acft was…Jul 20, 1984 · N8553N · Substantial damageNTSB ATL84LA228Accident · No injuriesLimited investigationFinal reportCessna 175 · Enterprise, ALA witness observed the airplane slipping on final apch. The aircraft lost too much altitude and hit the terrain short of the runway. The airplane damage indicated that the pilot failed to correct the slip condition in time to arrest the descent.Jul 20, 1984 · N7278M · Substantial damageNTSB MKC84FA221Accident · 1 fatalField investigationFinal reportMorgan T. Melton SKY Rider · West Plains, MOThe owner/bulder stated that he & his brother had been having an eng problem which they assumed was due to a vapor lock. They had installed a metal box around the electric fuel pump to insulate it from the heat of the exhaust pipe. The brother initiated a hi…Jul 19, 1984 · N39963 · DestroyedNTSB MKC84IA220Incident · No injuriesIncident investigationFinal reportBeech C-45H · Columbia, MOThe plt reported that he was unable to get a down & locked indication on the main landing gear when arriving at Columbia. He stated that he went thru the emergency procedures & made two landing attempts but felt the gear was about to collapse & made…Jul 18, 1984 · N492DM · Minor damageNTSB SEA84LA176Accident · No injuriesLimited investigationFinal reportCessna 182D · Eugene, ORThe plt estimated that the acft had about 1 hr of fuel remaining in the tanks prior to departure. However, after he had flown about 15 min, the eng lost power & would not restart. An emergency landing was made in a meadow about 2 mi from the arpt. The acft…Jul 17, 1984 · N8820X · Substantial damageNTSB SEA84FA175Accident · 1 fatalField investigationFinal reportCessna 182H · Elko, NVAbout 5 min after taking off on rwy 23, the plt reported on a downwind leg of the traffic pattern. Shortly after that, the acft crashed about 2 mi south of the arpt while on a southerly heading in a left wing low attitude. During impact, the left wing tip hit…Jul 17, 1984 · N1828X · DestroyedNTSB NYC84FFJ03Accident · Serious injuriesFinal reportRaven S55A · Lakeville, NYWitnesses stated that as the balloon approached a field for landing, in dim light, it became apparent that the gondola was going to hit power lines. The wooden gondola hit the top wire and the plt jumped approximately 33 ft to the ground sustaining serious…Jul 15, 1984 · N40238 · DestroyedNTSB FTW84LA303Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane DSA-1 · Brookshire, TXThe acft collided with an unmarked wire after the engine quit on final apch. After the collision the plt was able to level the acft and crash landed about 250 ft short of the rwy. The impact snapped off one gear and folded the other. Theacft skidded to a stop…Jul 15, 1984 · N1674 · Substantial damageNTSB LAX84MA392Accident · 6 fatalMajor investigationFinal reportPiper PA-31T · Concord, CAThe Piper PA-31T was a foreign registered acft (federal republic of germany). The owner/plt in the left front seat held a german commercial certificate with airplane instrument, single eng land & multi-eng land ratings. The plt in the right front seat held an…Jul 14, 1984 · DIKKS · DestroyedNTSB CHI84LA298Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Almont, MIOn 7/13, the plt departed fraser, MI, with full fuel tanks & flew to lakes of the north. The next day he flew to mackinac island. He then departed mackinac island without refueling. Near flint, MI, the plt contacted apch control & informed them he was low on…Jul 14, 1984 · N2492B · Substantial damageNTSB CHI84LA295Accident · No injuriesLimited investigationFinal reportCessna 172M · Southgate, MIAfter takeoff, the plt climbed to 8500 ft MSL to practice maneuvers. He then made a descent to 4500 ft & began heading back to the arpt, then continued descending to 1800 ft & entered the tca. The eng lost power aprx 7 miles from the airport. Later, during an…Jul 14, 1984 · N20218 · Substantial damageNTSB NYC84LA241Accident · No injuriesLimited investigationFinal reportCessna 152 · Mountville, PAThe student plt landed in a corn field short of the rwy on his 3rd solo landing. The plt stated that he 'misjudged the end of the rwy.' He also said he should have had a 'higher approach speed.'Jul 13, 1984 · N757ER · Substantial damageNTSB CHI84LA293Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Richmond Hts, OHThe aircraft was being flown back from an annual inspection. The pilot stated after the accident that he experienced a loss of power while on downwind leg for landing on rwy 23. The pilot attempted a landing on rwy 5 but the acft landed 1500 feet short.…Jul 13, 1984 · N93752 · Substantial damageNTSB LAX84LA386Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Llano, CAAccording to the plt, the glider did not sink as fast as expected on the downwind leg, so he extended flaps to 30 to 40 deg, used spoilers & extended the downwind. On base leg he entered an area of high sink; therefore, he closed the spoilers & angled toward…Jul 9, 1984 · N99966 · Substantial damageNTSB NYC84LA237Accident · No injuriesLimited investigationFinal reportSchleicher ASW-15 · Fairfield, PAThe glider was landed off arpt during a return from a round robin flt after experiencing a high sink rate. During the landing approach power lines hidden in a tree line were not cleared and the collision caused the acft to yaw about 45 degrees. The acft…Jul 8, 1984 · N111SP · Substantial damageNTSB NYC84LA236Accident · No injuriesLimited investigationFinal reportBeech 58 · Oneonta, NYPlt stated he was making multiple communications on base leg, talking on company freq as well as UNICOM, while adjusting his pattern to accomodate slow traffic on the runway and maintaing acft handling in gusty wind conditions. Gear handle was selected to…Jul 8, 1984 · N66534 · Substantial damageNTSB CHI84LA284Accident · No injuriesLimited investigationFinal reportCessna 172M · Lake Geneva, WIAccording to the plt, he was on a short final apch to land when the acft encountered sudden turbulence. At that time, the passenger in the right front seat lurched against the control wheel, causing the nose to pitch down & the acft to bank left.…Jul 8, 1984 · N6700H · Substantial damageNTSB CHI84LA271Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Flint, MIThe plt stated that during preflight, he noticed that after straining the fuel sump, the strainer handle did not go backin as FAR as it should have. He checked to make sure no fuel was leaking & decided to take off. En route, he smelled fuel vapors. The eng…Jul 8, 1984 · N49185 · Substantial damageNTSB FTW84LA305Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Welch, TXThe plt was participating in a national x-country contest. After aprx 6 hrs of flt, he elected to land in a circular irrigated cotton field. During a 2nd 360 deg turn over the intended landing area, at aprx 100 ft AGL, the glider's left wing dropped about 60…Jul 7, 1984 · N2961H · DestroyedNTSB DEN84LA212Accident · No injuriesLimited investigationFinal reportCessna 172 · Minnewaukan, NDThe pilot of this aircraft overflew his intended landing site, a gravel road, in an attempt to observe any power lines or other obstructions that might be in his way. He did not see anything that would prevent a safe landing. While turning to make the actual…Jul 7, 1984 · N8917V · Substantial damageNTSB ANC84LA113Accident · No injuriesLimited investigationFinal reportMaule M-4 · Wasilla, AKThe acft landed short of the rwy during a forced landing. The plt said he switched fuel tanks 3 minutes piror to landingand the engine quit on downwind leg. Restart attempts were unsuccessful. Attempts to further question the plt have been unsuccessful.Jul 7, 1984 · N4606T · Substantial damageNTSB DEN84LA210Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Eagle, COThe acft was turned at a low alt in high density alt on final approach and stalled at about 20 ft AGL. The glider contacted the rwy and ground looped.Jul 5, 1984 · N2463W · Substantial damageNTSB NYC84LA229Accident · No injuriesLimited investigationFinal reportMaule M5-180C · Millbrook, NYPlt was practicing touch-&-go landings. On final apch a high sink rate developed. Plt added full pwr but sink rate was not arrested. Acft contacted terrain before apch end of rwy.Jul 3, 1984 · N56424 · Substantial damageNTSB MIA84LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Port St. Joe, FLWhile on final apch to land at a private arpt, the acft collided with power lines near the apch end of the rwy. The plt stated that he did not see the power lines until just prior to impact. He attempted to fly under the lines, but the vertical stabilizer of…Jul 3, 1984 · N4980L · Substantial damageNTSB LAX84LA380Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · El Mirage, AZThe plt was practicing takeoffs & landings with about 800 lbs of water on board. After turning downwind for his second landing, he experienced a loss of airspeed & the acft started to sink into power lines. He released the emergency dump gate, at which time,…Jul 3, 1984 · N7202 · Substantial damageNTSB FTW84LA299Accident · No injuriesLimited investigationFinal reportBell 222UT · E Brake Blk 397While in a hovering approach to land on the deck of an oil platform in the gulf of Mexico a piece of plastic sheeting flew up from the platform into the tail rotor blades. The aircraft then slid in to a building on the deck following a hovering autorotation.Jul 3, 1984 · N222PV · Substantial damageNTSB SEA84LA153Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Mt. St. Helens, WAThis accident occurred at the 5500 ft level on Mt. St. Helens. Density alt at the time was 7500 ft. at aprx 40-50 ft aglengine and rotor RPM began to decay rapidly. The acft landed hard on a rock ledge with one skid partially off the ledge. As rotor RPM…Jul 2, 1984 · N58397 · DestroyedNTSB DEN84FA207Accident · 2 fatalField investigationFinal reportBell 206B · Englewood, COWitnesses stated the helicopter entered a 'hard left turn' into a near inverted position before 'it went down hard and fast.' Inspection disclosed the metal connection for the left cyclic stick was broken in half. (Plt was flying from left seat.) Exam of the…Jul 2, 1984 · N3173L · DestroyedNTSB DEN84LA205Accident · Minor injuriesLimited investigationFinal reportMooney 20E · Albuquerque, NMThe pilot fueled the aircraft with minimum fuel for the intended flight and did not recalculate consumption after a route change which extended flight. Power loss occurred about 1/4 mile from destination. The pilot attempted to glide to the rwy, but was…Jul 1, 1984 · N2166X · DestroyedNTSB ATL84LA215Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hickory, NCAcft landed with the nose gear retracted. Examination revealed that the nose gear was hung up in the wheel well because an AN4-12 bolt, which secured the nose gear centering spring ass'y, was hung up in the gear door linkage. An annual inspection was…Jul 1, 1984 · N4886T · Substantial damageNTSB NYC84FA227Accident · 1 fatalField investigationFinal reportCessna 402C · Boston, MADuring arrival, the flt was cleared for an ils/dme apch to rwy 27. While on the apch, the acft crashed in the ocean about 2.7 mi east of the rwy threshold. The plt reported that he was making the apch, using instruments, & landed short for unknown reasons. He…Jun 30, 1984 · N120PB · DestroyedNTSB MIA84FA196Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Niceville, FLThe acft crashed into trees short of the rwy after the engine quit on final approach. The engine failed from internal failure of the crankshaft gear retention system. A teardown revealed that the crankshaft gear bolt had backed out & the bolt head was noted…Jun 30, 1984 · N32538 · DestroyedNTSB FTW84LA293Accident · No injuriesLimited investigationFinal reportMooney M20C · Marshall, TXThe plt reported initial landing extension indicated an unsafe condition. The landing gear was recycled & a safe down & locked position was indicated. On landing roll the acft veered left off of the rwy & collided with trees. Tire marks on the rwy indicated…Jun 30, 1984 · N6261U · Substantial damageNTSB ATL84LA212Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Grenada, MSDuring arrival to an uncontrolled arpt, the plt made an apch while following about 1/4 mi behind a UH-1 helicopter. At that time, there was a quartering head wind at about 4 KTS. While on final apch at an alt of about 200 ft AGL, the Cessna 172 encountered…Jun 30, 1984 · N4650L · Substantial damageNTSB FTW84FA290Accident · 1 fatalField investigationFinal reportGriffin FG-1A · Mt Pleasant, TXAccording to witnesses, the gyrocopter plt took off & turned onto a left downwind to stay in the traffic pattern for rwy 17. One witness stated that the gyrocopter turned onto final apch at about 300 to 400 ft AGL. Two other witnesses, who reside aprx 1/4 mi…Jun 29, 1984 · N455FG · DestroyedNTSB DEN84LA201Accident · No injuriesLimited investigationFinal reportCessna 177RG · Cheyenne, WYThe aircraft collided with a tree during an emergency landing following loss of throttle control at a low RPM. Examination revealed that an uncertified throttle cable had been installed, it failed at the attachment to the throttle body.Jun 29, 1984 · N33215 · Substantial damageNTSB NYC84FU005Accident · 1 fatalFinal reportCGS Hawk B · Neshanic, NJThis ultralight was being flown by a plt who had about 80 hours of flt time in a C-172 and C-150 acft. He had soloed, but most of his time was dual and the last recorded flt was about 11 years ago. There are no records of any flt instruction in an ultralight.…Jun 28, 1984 · UNREG · DestroyedNTSB LAX84FA367Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Weaverville, CAWhen the plt filed a VFR flt plan, he stated that he was aware that the arpt at Weaverville, CA, was a one way strip & that he had a guide book which showed this info. Published procedures called for acft to 'land on rwy 36, take-off rwy 18.' A caution note…Jun 26, 1984 · N3070G · DestroyedNTSB DEN84LA195Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Dillon, MTThe plt reported that a nature movie was being made & he was making a short field landing for a film sequence. On the 3rd apch, he made a shorter base leg than normal, then on final apch, the acft stalled & 'slid in'. The left maincollapsed and the left wing…Jun 26, 1984 · N88399 · Substantial damageNTSB ANC84IA103Incident · No injuriesIncident investigationFinal reportFairchild C-82A · Anchorage, AKDuring arrival at the destination arpt, the aircrew was unable to extend the landing gear by using either the normal or emergency systems. They elected to return to Anchorage where emergency equipment was available. Fuel was reduced & subsequently a wheels up…Jun 26, 1984 · N4753C · Minor damageNTSB LAX84LA366Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Concord, CAAccording to a plt/operator statement, the student plt was cleared for a downwind apch to land on 'pad 3.' The student stated that the apch was normal until he slowed to 40 mph & 'made left turn to final approach into a cross wind.' During the turn to final…Jun 25, 1984 · N953 · Destroyed