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 ANC83LA047Accident · No injuriesLimited investigationFinal reportCessna 150G · North Pole, AKThe student & instructor plt (CFI) were on an instructional flt on a cold winter day (temp -10 deg f). The CFI stated that while practicing turns at 3000 ft MSL, he closed the throttle to give the student a forced landing excercise. He stated that carburetor…Feb 21, 1983 · N8541J · Substantial damageNTSB ATL83LA111Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Jackson, MSThe plt intended to refuel at starkville, MS, but the FBO was closed. He continued to his intended destination of raymond, MS, but was unable to turn on the rwy lights. He then diverted to Jackson, MS. The plt realized the acft was low on fuel, but didn't…Feb 20, 1983 · N2975K · Substantial damageNTSB LAX83LA109Accident · Minor injuriesLimited investigationFinal reportMidget Mustang I · Bermuda Dunes, CAThe acft crashed on a road near the active runway while making a go-around to avoid an acft which taxied on the runway as he approached. At about 400 feet AGL on final approach the pilot of the accident acft realized a safe landing was notpossible. He stalled…Feb 19, 1983 · N138X · DestroyedNTSB DEN83FTK03Accident · Serious injuriesFinal reportBeech V35A · Sioux Falls, SDDuring an ILS approach to rwy 3 the acft collided with 50 ft powerlines 3 mi sw of the arpt. The acft then collided witha mobile home & pickup truck. Half of the 60 ft mobile home & the truck were destroyed. Minimum altitude at the lim, located 5.2 mi from…Feb 16, 1983 · N8478N · DestroyedNTSB DCA83AA017Accident · Serious injuriesFinal reportde Havilland DHC-6-300 · Hailey, IDThe acft was less than 2 miles from the arpt of intended landing during the approach when the crew experienced a loss ofelevator control. The acft started diving toward the ground when the power was reduced. The plt applied full power to try and restore level…Feb 15, 1983 · N361V · DestroyedNTSB MKC83LA068Accident · No injuriesLimited investigationFinal reportCessna R182 · Olathe, KSPrior to landing, the pilot was unable to extend the left main gear and elected to land with all gear retracted. An investigation revealed that a bolt in the left main gear brake assembly was loose and jammed the wheel in the wheel well. An annual inspection…Feb 14, 1983 · N9886C · Substantial damageNTSB CHI83FA114Accident · Serious injuriesField investigationFinal reportPiper PA-44-180T · Indianapolis, INDuring an ILS apch to rwy 22R, apch control asked the plt to keep his speed up as much as practical. At a later inter- view, the plt could not remember details of the apch. He recalled putting the gear down at the outer marker (om) & using the autopilot to…Feb 14, 1983 · N8278T · DestroyedNTSB FTW83LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Hennessey, OKWhile on a short final to land at a private ag strip, the acft struck power lines, then flipped over & impacted on the apch end of the rwy. Although the plt was unfaamilar with the arpt, she had been briefed on the existance of the wires before her departure.…Feb 13, 1983 · N1139C · Substantial damageNTSB CHI83LA112Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Three Oaks, MIThe acft collided with a wire during the landing approach and landed hard enough to collapse the nose gear. According to the owner the flt was not authorized and the person at the controls held no pilot certificate. The pilot made the following statement, 'I…Feb 13, 1983 · N6487W · Substantial damageNTSB MKC83FA066Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Wichita, KSThe acft was cleared to make the approach and to descend not below 2300 ft. the pilot descended from 3000 after he reported passing hance, the final appoach fix. He descended to 2300 ft at 500 ft a minute and leveled the acft and lowered the landing gear. The…Feb 12, 1983 · N8981C · DestroyedNTSB MIA83LA076Accident · No injuriesLimited investigationFinal reportBeech 23 · Naples, FLAccording to the pilot the engine lost power while on a short final due to water in the fuel. The acft impacted the ground at a high rate of sink, the nose gear collapsed and the acft was damaged substantially.Feb 12, 1983 · N2302L · Substantial damageNTSB FTW83LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXDuring a touch & go landing on runway 17, the student pilot allowed the acft to touch down short. The landing gear struck a 1 ft dirt bank aprx 2 ft short of the paved runway. A NOTAM was in effect to alert plts that the first 400 ft of runway 17 & 35 was…Feb 12, 1983 · N5283P · Substantial damageNTSB CHI83LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNDuring final the acft started to drift & the rate of descent increased. The plt was late in adding power & the acft touched down 75 ft short of the rwy in 20 inches of snow & nosed over.Feb 12, 1983 · N93214 · Substantial damageNTSB CHI83FA108Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Reedsburg, WIThe acft impacted a quonset-type bldg while apparently on an unusual type approach for landing. One witness observed theacft make a low south to north pass over the rwy & then pull up into a loop that culminated in the quonset impact. Another witness observed…Feb 12, 1983 · N5277X · DestroyedNTSB DEN83LA057Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Burlington, COThe acft crashed during an attempted go-around. The pilot had landed downwind with an approach speed of 80 KTS and 25 degrees flaps. The pilot said he used rwy 13 instead of 31 because of a NOTAM prohibiting landing on rwy 31. There was no NOTAM to that…Feb 11, 1983 · N94618 · DestroyedNTSB LAX83FA098Accident · No injuriesField investigationFinal reportBeech H35 · Tucson, AZDuring arrival, the plt was advised of the position of a Boeing 727 that was landing on rwy 29R & he reported seeing theacft. He also was cautioned about possible wake turbulence from the Boeing & he acknowledged. The plt reported that while he was on an…Feb 7, 1983 · N4687D · Substantial damageNTSB FTW83LA106Accident · No injuriesLimited investigationFinal reportRobinson R22 · Stillwater, OKA simulated autorotational landing was initiated at about 450 ft AGL. During the approach, a 90 deg arc was flown toward an open field. A flare was begun with a power recovery at about 40 ft AGL when a wire was observed in the flight path. By this time, the…Feb 7, 1983 · N90763 · Substantial damageNTSB DCA83IA016Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-50 · Greer, SCAcft drifted to the right before a missed apch was initiated during which it made an inadvertent touchdown & struck a rwy light. The plt erroneously used RVR as his landing minimum. Actual RVR was below the published minimum. The sequenceflasher lights were…Feb 7, 1983 · N421EA · Minor damageNTSB LAX83LA088Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Napa, CAThe passenger, who was the owner of the acft, preflighted the acft & stated the fuel tanks were over half full. The plt also noted that both fuel gauges read over half full. The flt departed oakland at 1310. About 10 mi from Napa the plt briefly applied carb…Feb 4, 1983 · N9907M · Substantial damageNTSB SEA83LA051Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Oregon City, ORDuring arrival at dusk, the plt made an apch to rwy 9 with a headwind at 19, gusting 30 KTS. While on final apch, the acft collided with power lines near the apch end of the rwy. The plt reported that he did not see the lines until just prior to impact, then…Feb 3, 1983 · N30356 · Substantial damageNTSB SEA83LA050Accident · No injuriesLimited investigationFinal reportCessna 182N · Chiloquin, ORDuring a long straight in approach from about 3 miles out the aircraft lost power. The pilot figured he could not make the runway so he tried for a highway. In diving to avoid wires he drove the nose gear onto the ground. The nose gear was sheared off and the…Feb 2, 1983 · N92353 · Substantial damageNTSB ANC83LA040Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12-D · White Mountain, AKThe plt was demonstrating ski landings on river ice. The OAT was at least minus 20 deg f. after a prolonged power-off descent he recognized a need for additional power but the eng would not respond. The plt attempted to stretch his glide but the acft stalled…Jan 31, 1983 · N39196 · Substantial damageNTSB MKC83FA059Accident · No injuriesField investigationFinal reportRockwell 500-S · Kansas City, KSA gear up, forced landing was made on the east bank of the Kansas river after both engines quit due to fuel exhaustion. The pilot had landed at new orleans for fuel and requested the tanks be topped off. En route to Kansas City,the pilot stopped at Nevada, MO…Jan 30, 1983 · N57222 · Substantial damageNTSB NYC83FA054Accident · 4 fatalField investigationFinal reportCessna 310R · Atlantic City, NJThe flt proceeded routinely from chicago to Atlantic City. Communications and procedures all seemed routine and normal and at 1901 local control at Atlantic City informed the pilot that he was one mile out and should be picking up the 'rabbit' momentarily. At…Jan 29, 1983 · N310TA · DestroyedNTSB LAX83LA085Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tucson, AZThe acft crashed about one mile north of the runway after engine failure during a go-around. The student pilot on a solotraining flight had returned to Tucson international airport and could not land because of cross-winds. He diverted to davis-monthan afb.…Jan 29, 1983 · N48406 · DestroyedNTSB FTW83FA102Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-26B · Hempstead, TXThe glider was observed to stall/spin during turn from base to final. The plt was endorsed for solo in the heavier blanik L-13 & Schweizer 2-33, but not in the 1-26B. His logbook revealed four instructor entries concerning airspeed control. The acft was being…Jan 29, 1983 · N2465W · DestroyedNTSB MKC83LA058Accident · No injuriesLimited investigationFinal reportBeech D55 · Cape Girardeau, MOThe aircraft was landed gear up on the runway after a business flight. The pilot said he lowered the landing gear handleand observed the green landing gear down light illuminate after receiving clearance to land. The pilot said he did not cross check the nose…Jan 25, 1983 · N7815R · DestroyedNTSB MIA83FA062Accident · Serious injuriesField investigationFinal reportBeech C45H · Leesburg, FLThe acft crashed into a lake during a forced landing after the engines quit. The PIC had gone for a local flt with a plt/passenger. After a few minutes of flt he announced that they did not have any fuel. The acft was on an approach to return when both…Jan 21, 1983 · N69K · Substantial damageNTSB ANC83FAG03Accident · 3 fatalFinal reportCessna A185F · Nyac, AKThe aircraft crashed after colliding with a tree near the destination airport at Nyac, AK. The pilot had tried this flight from aniak to Nyac the day before and had returned to aniak because of weather. The weather at the time of the accident was snowing and…Jan 21, 1983 · N61764 · DestroyedNTSB DEN83LA051Accident · No injuriesLimited investigationFinal reportCessna 172XP · Harmony, WYThe acft collided with a fence at the departure end of a pasture field during a go-around. The pilot had decided to land in an easterly direction to avoid powerlines and did not consider direction of the wind. Full flaps did not slow the acft effectively…Jan 19, 1983 · N736YA · Substantial damageNTSB ATL83LA089Accident · No injuriesLimited investigationFinal reportCessna 182M · Columbia, SCDuring arrival, the pilot entered the traffic to land at owens field, an uncontrolled airport. He stated that the wind sock was limp despite a weather briefing to expect northwesterly winds at 8 to 20 KTS. He stated that he had allowed for strong winds by…Jan 18, 1983 · N70872 · Substantial damageNTSB SEA83LA043Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Pocatello, IDDuring a missed approach a partial power loss occurred during the transition to climb. The plt executed a course reversal to return visually to the arpt. Shortly thereafter he chose to execute an emergency landing on a frontage road which paralleled rr…Jan 17, 1983 · N28163 · Substantial damageNTSB FTW83FA088Accident · Serious injuriesField investigationFinal reportCessna 172N · Carrollton, TXThe plt reported that during arrival, he entered the downwind with no problem; however, when he attempted to turn on a left base, the aileron control locked up. He stated he could turn neither left nor right by using ailerons. Reportedly, the acft would bank…Jan 16, 1983 · N737VQ · Substantial damageNTSB LAX83LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · San Martin, CAThe acft made a hard landing short of the runway while practicing an approach with a simulated engine failure. On turning final, the instructor decided the acft was too low to make the runway. She estimated they would be several hundred feet short. She took…Jan 14, 1983 · N9927V · Substantial damageNTSB CHI83FA080Accident · No injuriesField investigationFinal reportPiper PA-28-140 · Glenview, ILDuring a long final approach to o'hare intl arpt the eng quit at 1,900 ft MSL. The plt was over a residential area but found a short field in which to land. The left main landing gear separated & then the left wing separated. The fuel selector was found…Jan 13, 1983 · N6347W · DestroyedNTSB CHI83LA077Accident · Serious injuriesLimited investigationFinal reportRutan Varieze · Youngstown, OHThe pilot took off with minimum fuel to practice touch and go landings. After 20 minutes of flight he turned on final approach and advanced the throttle with no power response. Due to low altitude and a wooded area on final he attempted a right turn to land…Jan 9, 1983 · N441EZ · DestroyedNTSB ATL83FKJ02Accident · Serious injuriesFinal reportLuscombe 8E · Elba, ALThe plt had received a wx briefing aprx 4 hrs before departure. He stated that on arrival, the arpt beacon light was not on & patches of ground fog were in the area. During the arrival, he approached from the south, flew north over the arpt, circled to the…Jan 8, 1983 · N1860K · Substantial damageNTSB LAX83LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bakersfield, CAThe non-instrument rated pilot received a weather briefing before take-off and was advised that VFR flight was not recommended. During arrival at night, he circled twice over the airport and noticed that the runway lights were clear, then entered the pattern…Jan 7, 1983 · N38916 · Substantial damageNTSB FTW83LA080Accident · No injuriesLimited investigationFinal reportBeech B35 · Canadian, TXThe acft collided with a tree during rollout after a forced landing following engine power loss on final approach. The pilot said he was one and a half miles out on final at 200 ft AGL when the engine quit. He was operating on the right main fuel tank. He…Jan 7, 1983 · N8849A · Substantial damageNTSB DEN83FA044Accident · 1 fatalField investigationFinal reportPiper Aerostar 602P · Almy, WYBefore departing, the plt obtained a wx briefing & was advised of a SIGMET which forecasted severe turbulence below 18,000 ft, strong up/downdrafts, strong surface winds & wind shear near mountains & in passes. He took off with full fuel tanks & aprx 400 lbs…Jan 6, 1983 · N6893L · DestroyedNTSB CHI83FA075Accident · 3 fatalField investigationFinal reportMooney M-20D · Lindenwood, ILAt 0306 the plt contacted rockford fss requesting local wx. He then requested an ILS apch to rockford & stated he had noapproach plates. After being cleared for an ILS apch to rwy 36, the plt reported he was unable to pick up the ILS & was low on fuel. ARTCC…Jan 5, 1983 · N1968Y · DestroyedNTSB LAX83FUA02Accident · 2 fatalFinal reportPiper PA-28-161 · Avalon, CAThe aircraft crashed during an attempted go-around at catalina island. The front seat occupants were fatally injured andthe two rear seat passengers received serious injuries. The pilot had not had the specified three takeoffs and landings within the…Jan 3, 1983 · N2239M · DestroyedNTSB DCA83AA010Accident · 2 fatalFinal reportCanadair CL-600-1A11 · Hailey, IDThe acft crashed into the side of a mountain ridge during a VFR attempt to land at an arpt with no instrument approach. The mountain ridge was obscured by broken clounds. The plt had cancelled his IFR clearance, & during the descent to the arpt, he had…Jan 3, 1983 · N805C · DestroyedNTSB SEA83LA036Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Newport, ORThe engine lost power when the pilot was on an extended base leg for landing. From that position, he could not glide to the runway, so he elected to land on a nearby beach. The location of people walking on the beach prevented an upwind landing, so the pilot…Jan 2, 1983 · N1296M · Substantial damageNTSB LAX83LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Sedona, AZWhile enroute, the plt noticed that he had lost his airspeed indication. Observing the pitot head on the wing with a flashlight, he stated that the flip-up cover was down, covering the ram tube. Unable to maintain proper airspeed, the plt inadvertently…Jan 1, 1983 · N5262U · DestroyedNTSB LAX83FUG11Accident · Minor injuriesFinal reportPiper PA-28R-200 · Upland, CAThe aircraft crashed 150 yards short of the runway during landing. The pilot said the manifold pressure kept falling as he progressed around the field in the traffic pattern. The engine went to idle on the base leg. The pilot had lowered the gear but not the…Jan 1, 1983 · N3084R · Substantial damageNTSB MKC83LA048Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Olathe, KSThe aircraft was on downwind when the engine stopped. The aircraft touched down 1000 ft short of the runway. Investigation revealed there was no fuel in the fuel tanks.Dec 31, 1982 · N94291 · Substantial damageNTSB MIA83FA055Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201T · St. Augustine, FLApproach control advised the flt at the time of the initiation of the approach that weather for the general area was 300 ft overcast, 2 mi in fog. The flt was cleared for the VOR rwy 13 approach. The acft struck trees about 65 ft AGL in an area about 4 mi nw…Dec 31, 1982 · N8412F · DestroyedNTSB LAX83LVG06Accident · No injuriesFinal reportBeech G35 · Chico, CAThe aircraft was on a flight from arcata, CA to sacramento, CA with en route stops at redding, red bluff and Chico. The pilot reported that when he was on final approach to land at Chico, the engine lost power. Subsequently, the aircraft struck elements of…Dec 29, 1982 · N4428D · Substantial damageNTSB ATL83IA085Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Washington, DCThe acft was observed by witnesses to descend below its normal descent path and to horizontially stray off course to thepoint that office bldg occupants and persons on the ground were concerned by the appearance and noise of the acft duringa vor/dme approach…Dec 28, 1982 · N752N · No damage