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 LAX86LA087Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Crown King, AZThe acft collided with a 5600 ft ridge line shortly after executing a go-around at a privately owned dirt, upward sloping airstrip. Ground witnesses reported the acft was on short final on rwy 05 when the plt applied full pwr. When the acft was at the…Jan 10, 1986 · N8535S · Substantial damageNTSB LAX86FA085Accident · 1 fatalField investigationFinal reportBeech D-50 · Santa Rosa, CAThe plt, who was the mechanic for the acft & who possesses FAA inspection authorization, was familiar with this acft and had flown it the day before the accident. The plt failed to refuel the acft after making two additional flts. The main fuel tank gages…Jan 9, 1986 · N666GK · DestroyedNTSB CHI86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · Charlotte, MIThe student was performing a practice approach to an emergency landing on a frozen, snow covered lake. After he had flown to an altitude low over the lake the instructor took over the controls. At this point the aircraft struck a ridge of snow and came to a…Jan 8, 1986 · N50255 · Substantial damageNTSB LAX86LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Peoria, AZThe acft landed short of the intended rwy and collided with a cement block wall surrounding a trailer park on the apch path to the rwy. The plt stated that the eng quit on the final apch to landing due to apparent fuel starvation. He reported that he checked…Jan 6, 1986 · N7049P · Substantial damageNTSB FTW86FA031Accident · 2 fatalField investigationFinal reportPiper PA-31P-350 · Norco, LAThe plt initiated an ILS apch in below minimum weather conditions shortly after night fall. He was given a low alt alert, but continued the apch. He announced a missed apch, and indicated problems climbing to alt. He then declared an unspecified emergency,…Jan 5, 1986 · N9253Y · DestroyedNTSB ATL86FA049Accident · 1 fatalField investigationFinal reportCessna 177RG · Hazard, KYThe plt called the arpt on UNICOM and asked how to find the arpt, stated that he needed fuel and asked if fuel was available. He was given directions and asked if he had landed there before. He replied no, and inquired about the traffic pattern. It was…Jan 5, 1986 · N97TC · DestroyedNTSB ATL86FA055Accident · 2 fatalField investigationFinal reportCessna T337B · Talladega, ALThe acft collided with trees during the final approach to landing. The light conditions were dark, skies were clear and winds were calm. Prior to the accident, the plt had landed and visited the FBO from where the acft was recently purchased to correct some…Jan 4, 1986 · N2407S · DestroyedNTSB NYC86FA057Accident · 2 fatalField investigationFinal reportCessna 182L · So.Glastonbury, CTThe acft was on a VOR instrument apch when it collided with 250 ft high terrain approx 6 miles south of the arpt and approx 2 miles north of the vor/faf. Shortly before the accident the pilot notified ATC that he was in turbulence; then reported he was clear…Jan 3, 1986 · N3349R · DestroyedNTSB LAX86FA079Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · El Cajon, CADrg arrival at an arpt near his home, the plt contacted apch control (ctl) & asked the ctlr for assistance in landing & said that the wx looked a little foggy. The ctlr informed the plt of the acft's position in relation to the arpt. As the acft was dscndg…Jan 3, 1986 · N4318V · DestroyedNTSB DEN86LA059Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Alamogordo, NMUpon returning to the arpt, the plt decided to make a fly-by. The plt reported that while on a modified downwind at an alt of aprx 50 ft AGL, the glider which he was piloting encountered adverse winds and downdrafts. Control of the acft was lost and it…Jan 1, 1986 · N166JD · DestroyedNTSB MKC86LA039Accident · No injuriesLimited investigationFinal reportCessna 182RG · Wentzville, MOThe pilot stated that he winds were calm when he made the tou long, on the runway, attempted a go around and ran off the end of the runway into a field when the airplanefailed to get airborne.Dec 30, 1985 · N9199C · Substantial damageNTSB DEN86FA056Accident · 6 fatalField investigationFinal reportCessna T210L · West Valley, UTDuring apch to rwy 34L, the rt horizontal stab, elevators and wings separated in-flt. Investigation revealed the plt was not instr current. Ntap data revealed N2082S at an alt of 7,400 ft and 203 KTS grnd speed at outer marker. The mca at the marker is 6,100…Dec 29, 1985 · N2082S · DestroyedNTSB BFO86FA011Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Westminster, MDThe student pilot was flying in a flight of three returning from having lunch at a nearby airport. The first pilot made a go-around after bouncing during touchdown on the downhill 1830 foot long by 30 foot wide airstrip. He then came aroundand made a…Dec 29, 1985 · N41204 · DestroyedNTSB NYC86LA055Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Ellington, CTWhile on apch for landing, about 50 ft from the rwy, the landing gear contacted a bridge and the acft bounced into the air. Pwr was added at this time and again the acft bounced. The acft was then landed on the rwy and it skidded to a stop. The plt stated she…Dec 28, 1985 · N7571P · Substantial damageNTSB FTW86FA027Accident · 2 fatalField investigationFinal reportCessna 172B · Caddo Mills, TXMid-air occurred at uncontrolled arpt with the S-2B executing rt traffic, as published, and the C-172 executing a long final or an arcing lft turn to final. Both acft were attempting to land on rwy 17R. Acdt occurred during late afternoon and there was…Dec 28, 1985 · N6876X · 2 aircraft · DestroyedNTSB LAX86MA074Accident · 7 fatalMajor investigationFinal reportBeech 95-A55 · Concord, CADrg arr, the acft was vectored for an lda rwy 19R apch. After being clrd for the apch, the plt was advised that radar svc was terminated & told to contact the twr. At 2033 PST, he rprtd inbnd at the final apch fix & was clrd for the apch. Aprx 2 min later, he…Dec 24, 1985 · N1494G · DestroyedNTSB LAX86LA073Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Santa Paula, CAThe student plt & his CFI successfully performed 8 landings. On final apch to the 9'TH ldg the acft was low & the CFI delayed in directing his student to increase eng pwr. The student responded but the acft did not gain alt soon enough to avoid colliding with…Dec 22, 1985 · N714GG · Substantial damageNTSB BFO86LA010Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Stevensville, MDAfter landing at the bay bridge airport, the CFI got out of the aircraft and told the student-pilot to take it around the pattern. The aircraft was taxied to runway 28 and while waiting for other traffic to depart the CFI called over UNICOM that the landing…Dec 22, 1985 · N6147Q · DestroyedNTSB NYC86LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rochester, NYThe acft contacted the terrain following a loss of control during an attempted go-around.Dec 21, 1985 · N98240 · Substantial damageNTSB DCA86AA011Accident · No injuriesFinal reportBoeing 747-136 · Boston, MAAprx 16 ft of the left inboard trailing edge flap separated while the acft was on final apch to land. The apch and landing were completed without further incident. Investigation revealed 5 of the 8 bolts which hold the no. 3 flap trackforward attach fitting…Dec 15, 1985 · GAWNE · Substantial damageNTSB ATL86FA041Accident · 1 fatalField investigationFinal reportMooney M20K · Langhorne, PAAcft collided with marked but unlighted transmission lines 670 ft fm rwy threshold. The lines are 81 ft above the threshold elevation and are marked but unlighted. They are also 1193 ft from the displaced threshold. The pilot did not have a current medical or…Dec 15, 1985 · N231A · Substantial damageNTSB ANC86FA014Accident · Serious injuriesField investigationFinal reportCessna C-207 · Napaskiak, AKAccording to the pilot-in-command, the weather at his destination was deteriorating so he diverted to Napaskiak where he encountered freezing drizzle rain and fog. While attempting to align himself with the runway for a landing to the south, the windshield…Dec 15, 1985 · N6497H · Substantial damageNTSB CHI86MA047Accident · 5 fatalMajor investigationFinal reportBeech B-60 · Carp Lake, MIDrg arrival, the plt reported a problem with his #1 nav, but said he would try to make an ILS apch. He said he would return to pontiac, if his ILS did not work. ARTCC cleared him for the ILS rwy 32 apch & instructed him to contact pellston radio (fss). At…Dec 14, 1985 · N24RT · DestroyedNTSB BFO86LHD01Accident · No injuriesFinal reportCessna 414 · Georgetown, DEThe acft impacted trees during a VOR apch and descended to ground impact. The plt flew the apch with the autopilot coupled. The alt hold and alert were set for the mda. When visual contact with the arpt enviroment was established, the plt disconnected the alt…Dec 13, 1985 · N13FH · DestroyedNTSB LAX86LA064Accident · Minor injuriesLimited investigationFinal reportCessna 335 · Yuba City, CAUpon completing a 35 min sight-seeing flight the plt entered the traffic pattern & prepared for landing. While descending, both engines lost all power. The plt stated that he repositioned the fuel selectors to the aux tanks, power was restored to the left…Dec 11, 1985 · N2708X · DestroyedNTSB ATL86FA039Accident · 1 fatalField investigationFinal reportPiper PA-30 · Corning, NYDuring ILS runway 6 approach acft hit high terrain short of the outer marker. When on downwind for approach pilot said he was not receiving the localizer and asked for a surveillance approach. Controller said he could not provide. When cleared for the ILS…Dec 11, 1985 · N7770Y · DestroyedNTSB MIA86LA041Accident · No injuriesLimited investigationFinal reportCessna 337F · Sarasota, FLThe plt stated that all attempts to extend the landing gear were to no avail. He then intentionally landed gear up on the left side of rwy 4.Dec 8, 1985 · N1158M · Substantial damageNTSB CHI86FA042Accident · 3 fatalField investigationFinal reportLearjet 35A · Rochester, MNThe aircraft had just successfully completed a series of practice approaches to a full stop. The training flight was being conducted to give refresher training to the pilot who had not flown a lear jet in over a year and had never flown a lear model 35. The…Dec 8, 1985 · N15TW · DestroyedNTSB SEA86LA029Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Idaho Falls, IDA total loss of power occurred during an ILS approach due to induction ice. During touchdown on 12 inches of snow a nose over occurred.Dec 7, 1985 · N5635D · Substantial damageNTSB FTW86LRG04Accident · No injuriesFinal reportCessna 150J · Temple, TXThe acft nosed over during a forced landing on soft terrain following a total loss of eng pwr. The plt reported that the eng quit while on a 45 deg entry to the downwind leg for rwy 15. The plt then attempted to restart the eng and maneuver the acft toward…Dec 7, 1985 · N51079 · Substantial damageNTSB LAX86FA057Accident · 1 fatalField investigationFinal reportBeech F33A · Sacramento, CAOn December 4, 1985 at 2230 PST, a Beech F33A, operated by the owner, collided with trees during a missed approach at Sacramento metropolitan airport, Sacramento, California, while on a business flight. Instrument meteorological conditions prevailed at the…Dec 5, 1985 · N6541A · DestroyedNTSB CHI86LA040Accident · No injuriesLimited investigationFinal reportCessna 177 · Crookston, MNWhile doing a 270 degree turn on base leg for runway realignment the pilot permitted the acft to fly into the ground.Dec 5, 1985 · N3386T · Substantial damageNTSB DEN86FA034Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Englewood, COThe plt had been flying aprx 7 hrs and was completing the flt at night when the accident occurred. He was using visual cues (the arpt enviroment) to position the acft at a proper alt for a visual apch and landing. The terrain south of the arpt rises several…Dec 2, 1985 · N9250Y · Substantial damageNTSB ATL86FA034Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Dacula, GAThe acft collided with trees 3.5 miles from the arpt during an instrument approach in dense fog. The approach required an adf receiver and the acft did not have one. The mda on the approach was 1600 ft. the acft impacted the trees at 1200 ft MSL. The acft was…Dec 2, 1985 · N9289J · DestroyedNTSB NYC86LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Hazleton, PAPiper aircraft ran off the runway during landing at Hazleton Pennsylvania. According to the pilot the first approach was missed due to bad visibility. The flight returned to the initial aprroach fix for a second attempt. The pilot broke out of the clouds at…Dec 1, 1985 · N4324D · Substantial damageNTSB LAX86MA050Accident · 1 fatalMajor investigationFinal reportBell 206L-1 · San Pedro, CATwo Bell 206L'S (N3913Z oprd by helitrans, N5759Y oprd by island express) deptd avalon 2 min apart on flts to San Pedro. Arr route at destn was ovr a RVR with angling fnl acph arnd a floating restaurant (fr). Heliport (HP) was in congested area nr bridge,…Dec 1, 1985 · N3913Z · 2 aircraft · DestroyedNTSB LAX86LA051Accident · No injuriesLimited investigationFinal reportPitts S1-C · San Jose, CAThe plt was practicing takeoff and landings on rwy 13 at reid-hillview airport, San Jose, CA. The plt reported that during the base leg to final turn, while negotiating a 'power-off' apch, he attempted by apply pwr but was unable to do so. The acft crashed in…Dec 1, 1985 · N75PB · Substantial damageNTSB LAX86LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Likely, CAWhile practicing power-off forced landings in an open, snow covered field, the pilot said he applied the throttle to abort the approach but the engine 'sputtered then quit.' The aircraft landed in the snow covered field and flipped over. The pilot said he…Nov 27, 1985 · N6878B · Substantial damageNTSB ATL86FA032Accident · 2 fatalField investigationFinal reportBeech C90 · East Greenwich, RIThe acft crashed about nine miles short of the rwy during an ILS approach to warwick, RI in IMC wx. The acft had been cleared to descend from 13000 to 3000 ft. the acft crashed outside the outer marker. The co-plt had reported the acft as inside the outer…Nov 27, 1985 · N220F · DestroyedNTSB SEA86FVW01Accident · 1 fatalFinal reportGriffin, Thomas Modified KR-Z · Panaca, NVA witness to the accident observed the aircraft climb straight ahead and make a shallow left 90 degree turn. The aircraft was then observed to resume level flight. The aircraft then slowly wen into a bank and fell off into a dive striking the ground. This was…Nov 26, 1985 · N999TG · DestroyedNTSB NYC86LA044Accident · Minor injuriesLimited investigationFinal reportPiper Aztec · North Adams, MAThe flight departed albany new york under VFR conditions and picked up IFR clearance to pittsfield, MA. The pilot flew the approach until reaching VFR under a cloud layer at about 2500 ft. continuing VFR toward no. Adams at an altitude of 2000 ft, the pilot…Nov 26, 1985 · N6LQ · DestroyedNTSB MKC86MA031Accident · 7 fatalMajor investigationFinal reportRockwell 500-S · Des Moines, IAN81589 was flwg a Boeing 727 on ILS apch in IFR conds. Aprx 2.5 mi fm rwy, N81589 suddenly deviated left nrly 90 deg. 39 sec later, plt rprtd he enctrd svr turbc, then said he was trying to clb. N81589 subsequently flew thru tree tops on rising trrn for aprx…Nov 25, 1985 · N81589 · DestroyedNTSB MKC86FA030Accident · 2 fatalField investigationFinal reportCessna P210N · Tontitown, ARAfter completing two erratic 360 deg turns in a holding pattern west of the razorback VORTAC station, the plt was instructed to proceed via the 218 deg radial of the razorback VORTAC until reaching the elmie intersection and to hold. A couple of minutes later…Nov 25, 1985 · N86JB · DestroyedNTSB DEN86LA029Accident · No injuriesLimited investigationFinal reportCessna C-152 · Franktown, COAccording to the plt, upon initiating a pwr recovery after a simulated forced landing, the acft in which he and his pax were in, encountered turbulence. The plt stated that the acft contacted the ground shortly thereafter. The plt said he allowed the acft to…Nov 24, 1985 · N6122P · Substantial damageNTSB ATL86LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Huntsville, ALDuring a cross country flight, the pilot elected not to refuel at his proposed refueling point and continued to another airport. While on a visual approach to the runway, the aircraft lost power due to fuel exhaustion.Nov 24, 1985 · N45920 · Substantial damageNTSB LAX86LA044Accident · No injuriesLimited investigationFinal reportCessna 177 · Stockton, CAAfter performing a preflight inspection of his acft, the PIC along with a CFI who was acting as his safety plt, and another passenger departed. The CFI reportedly had logged over 19,000 hours & possessed an ATP certificate. The PIC did not report having any…Nov 22, 1985 · N3459T · Substantial damageNTSB LAX86LA040Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · San Jose, CAWhile on final apch for San Jose muni airport at the end of a cross country flt, the acft experienced total fuel exhaustion. Plt diverted a/c to ried hillview airport & established power-off glide. On final for rwy 31R, plt said he realized the a/c would not…Nov 18, 1985 · N41309 · Substantial damageNTSB FTW86LRD03Accident · No injuriesFinal reportCessna 185 · Leeville, LAThe acft collided with a power line during an off arpt landing on a canal. It was an intentional landing to transport company employees of la-tex gulf drilling, inc. the wx was VMC and no flt plan was filed.Nov 18, 1985 · N4732E · Substantial damageNTSB NYC86LA036Accident · No injuriesLimited investigationFinal reportCessna C182 · Gardiner, NYThe acft contacted power lines on final apch and descended uncontrolled to ground impact. The plt reported that turbulence was encountered when he entered the traffic pattern. He then proceeded onto final apch at a 'normal altitude'and full flaps were added.…Nov 17, 1985 · N5634B · Substantial damageNTSB MKC86FA029Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Osage Beach, MOWitnesses observed N80426 lt of the final apch course for rwy 14 heading toward the arpt for landing. One witness said the acft was at 300 to 400 ft AGL when the nose of the acft rose abruptly, the lt wing went down and the acft descended to the ground. Other…Nov 17, 1985 · N8042C · Destroyed