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 SEA88LA152Accident · 1 fatalLimited investigationFinal reportCassutt III · Shelton, WAAcft had been restored and recertificated since last flight in 1969. On initial test flight takeoff, plt immediately turned to and flew low, slow landing pattern circuit with sounds of reduced power, colliding with trees in final approach turn. Investigation…Aug 13, 1988 · N2984G · DestroyedNTSB NYC88LA211Accident · Minor injuriesLimited investigationFinal reportMooney M20C · E. Stroudsburg, PAThe plt said that during an attempted landing the acft floated during the flare. After using about half the rwy he decided to go-around. The temp was 90 deg f resulting in a density alt of 3200 ft. the plt said he applied full pwr but the acft did not climb…Aug 9, 1988 · N2HV · DestroyedNTSB FTW88LA148Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Edna, TXA delay in initiation of the go-around during the pilot's second attempt to land in the dark night conditions. Contributing to the accident was the runway closure due to construction, which resulted in no runway lights illuminated, and the fact that the pilot…Aug 8, 1988 · N8355L · Substantial damageNTSB DEN88LA181Accident · No injuriesLimited investigationFinal reportCessna 180 · Cascade, MTThe plt was landing at an unattended airstrip with a 1000' dirt rwy. There was a northerly wind, but due to the sloping rwy terrain, he elected to use rwy 19 & land uphill with a tailwind. The plt rprted that as he was about to flare, the acft pitched down &…Aug 8, 1988 · N1509C · Substantial damageNTSB MKC88LA152Accident · No injuriesLimited investigationFinal reportCessna 150 · Coy, ARWhile practicing for his pvt plt check ride, the student pilot returned to the airstrip to practice takeoffs and ldgs. He lost all power on final approach, and due to aircraft on the departure end of the runway, he attempted an emergency ldg on an adjacent…Aug 7, 1988 · N8697S · Substantial damageNTSB NYC88LA210Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ashburnham, MAA student pilot and flight instructor were making a practice pinnacle approach. The student pilot tried to terminate the descent, but was unable and a landing on rough terrain took place. The helicopter rolled over and received substantial damage but the two…Aug 5, 1988 · N90789 · Substantial damageNTSB MIA88LA245Accident · No injuriesLimited investigationFinal reportStanford Monofly · Jacksonville, FLFlt experienced total loss of engine power while on a downwind position for landing. The runway could not be reached and a forced landing was made in trees. The fuel pump was mounted directly to the engine block and auto fuel was being used. After the…Aug 3, 1988 · N70061 · Substantial damageNTSB MIA88LA242Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Greenville, MSThe pilot reported that while on short final during a personal flt, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a levee, small trees, then the terrain.Aug 2, 1988 · N1948W · Substantial damageNTSB CHI88DEI03Accident · Minor injuriesFinal reportPiper PA-28-140 · Salem, OHThe airplane engine failed to respond when the throttle was advanced during the recovery from a practice forced landing. The airplane struck wires while attempting to reach a suitable landing area during the resulting forced landing. The wires did not break;…Aug 2, 1988 · N7024R · Substantial damageNTSB LAX88LA276Accident · Serious injuriesLimited investigationFinal reportRaven RX-6 · Sun City, CAThe pilot & pax departed on a local area balloon flt. After 30 minutes the pilot began a descent to an open feild north of some power lines. During the descent the balloon began to drift to the right and the pilot realized that his ground crew did not have…Jul 31, 1988 · N1183R · Substantial damageNTSB MIA88FA239Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Avon Park, FLThe CFI radioed that he would be conducting a simulated engine-out aprch. 2 plt witnesses, 1 of whom was a CFI, stated that acft was seen on final aprch at about 200 ft with the left prop feathered & the gear & flaps down. They stated that although the acft…Jul 30, 1988 · N3464P · DestroyedNTSB LAX88FA274Accident · 2 fatalField investigationFinal reportLearjet 23 · Perris, CAThe pilot decided to conduct his flight with known aircraft deficiencies. Induced company pressure to deliver the aircraft to its destination is considered to have been a factor in the accident.Jul 30, 1988 · N745F · DestroyedNTSB LAX88LA271Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Healdsburg, CASolo student pilot failed to maintain airspeed above the stall speed during the go around attempt, thereby losing control of the airplane and stalling and mushing until colliding with a tree.Jul 29, 1988 · N91352 · Substantial damageNTSB NYC88FA196Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pocantico Hills, NYThe non-instrument rated private pilot departed in instrument flight conditions against the advice of several people he talked to. Approximately 1 hour and 30 minutes after departure the first of four or five mayday calls were heard by bridgeport radio and an…Jul 27, 1988 · N9715W · DestroyedNTSB CHI88LA174Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Neillsville, WIJul 27, 1988 · N5700A · DestroyedNTSB SEA88LA139Accident · No injuriesLimited investigationFinal reportCessna 172 · Monroe, WAThe pilot reported that he encountered a downdraft on final. He added power for a go-around; however, a wingtip struck the ground. The aircraft cartwheeled and came to rest to the left of the runway.Jul 26, 1988 · N46692 · Substantial damageNTSB MKC88MA134Accident · 1 fatalMajor investigationFinal reportLearjet 35A · Morristown, NJThe crew was positioning the aircraft in preparation for a revenue flight and executing a non-directional beacon (NDB) apch to rwy 05. The captain reported that the copilot was flying the acft. However, the capt stated that he took controlof the acft during…Jul 26, 1988 · N442NE · DestroyedNTSB BFO88LA069Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Windsor, VAWhile on long final after a glider tow flight the eng lost power. A forced landing was made in an open field and when the plt applied brakes, the acft nosed over. Post accident exam of the acft revealed 1 gallon of fuel remained. The plt reported that he…Jul 24, 1988 · N31253 · Substantial damageNTSB LAX88DUD01Accident · Minor injuriesFinal reportFerris VARI-EZE · Hawthorne, CADuring a local flight, while on final approach, the pilot reported that a gust of wind from the right raised the right wing resulting in the left wing contacting the runway. The pilot lost control of the airplane which nosed over during the landing roll.…Jul 23, 1988 · N7YE · Substantial damageNTSB FTW88DPA05Accident · No injuriesFinal reportLuscombe 8A · Burleson, TXThe airplane was on downwind when the pilot pulled on the carburetor heat and reduced the RPM. When he reapplied power, the engine would not respond. During the forced landing, the pilot got the airplane on the airport but hit the right wing and tailwheel on…Jul 23, 1988 · N25236 · Substantial damageNTSB MKC88LA133Accident · No injuriesLimited investigationFinal reportGrumman 164A · Poplar Bluff, MOThe pilot experienced an engine failure while attempting to land during an aerial application flight. Altitude was not adequate to select a suitable forced landing area. The aircraft impacted in a pipeline right of way and came to rest in a small stream,…Jul 19, 1988 · N8706H · Substantial damageNTSB MKC88LA132Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Knobel, ARProper touchdown point not attained, and aircraft control not maintained by the pilot in command.Jul 19, 1988 · N6553 · Substantial damageNTSB LAX88LA263Accident · No injuriesLimited investigationFinal reportCessna 182 · Ajo, AZThe plt rprtd that while on final apch to land, the eng suddenly lost power. A forced landing was made about 400' short of the rwy. Drg the landing roll, the acft hit a ditch & nosed over. The airplane was disassembled & moved before it was examined by…Jul 18, 1988 · N6223A · Substantial damageNTSB MIA88FA224Accident · 2 fatalField investigationFinal reportBeech 95 · Destin, FLPlt reported arpt in sight and was cleared for visual approach. Witnesses reported seeing acft on left downwind & said it flew into a thundershower. The flt was not heard from again. The acft's wreckage was found in the bay 1 1/4 miles north of the runway.…Jul 17, 1988 · N669Q · DestroyedNTSB DEN88LA160Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Boulder, COAccording to the plt, he was returning to Boulder after making a flt to aspen. He said he started the morning flt with 2/3 fuel load (about 40 gallons) but didn't know how much flt time he accumulated during the day. During his VFR approach to the Boulder…Jul 17, 1988 · N2815A · Substantial damageNTSB MIA88LA226Accident · No injuriesLimited investigationFinal reportEvans Maxair MU503 · Fort Walton Bch, FLWhile on a personal flt with reported thunderstorms in the vicinity, the plt lost control of the homebuilt acft while on final aprch to land. The acft descended & collided with terrain.Jul 16, 1988 · N5358G · Substantial damageNTSB DEN88LA157Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Gillette, WYJul 15, 1988 · N5903B · Substantial damageNTSB CHI88DEX09Accident · Serious injuriesFinal reportSollars Rotorway Executive · Newburgh, INThe eng lost power as the homebuilt helicopter was on an apch to land at a private heliport. The student plt rprtd the helicopter was at aprx 50 ft AGL when the power loss occurred. Subsequently, during an autorotation, the helicopter touched down hard. No…Jul 15, 1988 · N3047 · Substantial damageNTSB CHI88DEP05Accident · No injuriesFinal reportGriffin Pitts S-1S · Rio, WIWhen the pilot of the amateur built biplane initiated a go-around from a VFR approach, he found that he had no response to throttle application. He then executed an intentional forced landing in an adjacent field. During this landing the aircraft collapsed a…Jul 11, 1988 · N77LG · Substantial damageNTSB ATL88LA212Accident · Minor injuriesLimited investigationFinal reportCessna 310 · New Bern, NCThe plt rptd the lt engine lost pwr on 'very short final'. Shortly thereafter, he heard the stall warning. The airplane rolled and yawed left, and crashed nose-down short of the rwy. The acft was examined the next day by an FAA inspector; he rptd finding no…Jul 10, 1988 · N670R · Substantial damageNTSB CHI88LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Moraine, OHWhile on final approach N7222W experienced a midair collision with N8611U on a similar approach. N8611U was a high wing aircraft and was in front of and below N7222W which was a low wing aircraft. The pilot of N8611U stated that he had no knowledge of the…Jul 7, 1988 · N7222W · 2 aircraft · Substantial damageNTSB FTW88LA128Accident · No injuriesLimited investigationFinal reportCessna 170 · Marble Falls, TXThe pilot lost directional control during the lndg on runway 17. The aircraft collided with the terrain and trees after veering off the right side of the runway. The pilot reported a left quartering headwind of 25 knots gusting to 35 knots. The acft was…Jul 4, 1988 · N2642V · Substantial damageNTSB CHI88LA151Accident · No injuriesLimited investigationFinal reportCessna 177 · Lowell, INThe student pilot was on final approach for landing when the aircraft began to drift to the left of the runway. The pilot decided to go-around and added full power, pushed the carburetor heat in and retracted the flaps to '1/2'. According to the pilot he…Jul 3, 1988 · N30238 · Substantial damageNTSB NYC88DHD03Accident · Serious injuriesFinal reportSchweizer SGS 1-23H-15 · Hammonton, NJThe glider pilot's failure to avoid the stall/spin encountered during low altitude operation in the traffic pattern.Jul 2, 1988 · N8619R · DestroyedNTSB LAX88DVD06Accident · Serious injuriesFinal reportLocolce/Blackwell Falcon XP · Antioch, CAWhile entering downwind for landing, the rudder did not respond. The airplane began to yaw to the left at a 30 degree banking spiral turn. The pilot deployed the emergency parachute and the airplane collided with the terrain. Inspection of the airplane…Jul 2, 1988 · N607AA · Substantial damageNTSB NYC88LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · East Hampton, NYThe pilot reported that he had experienced a partial power loss on downwind of a VFR traffic pattern. He stated that just after entering downwind he lowered the landing gear. As the speed decreased below 132 knots he advanced the throttles. There was no…Jul 1, 1988 · N62771 · DestroyedNTSB LAX88LA243Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Lancaster, CAJul 1, 1988 · N4179K · Substantial damageNTSB DEN88LA143Accident · No injuriesLimited investigationFinal reportMooney M-20K · Gunnison, COJul 1, 1988 · N231PG · Substantial damageNTSB CHI88FA145Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Detroit Lakes, MNJun 29, 1988 · N44140 · Substantial damageNTSB SEA88LA118Accident · 1 fatalLimited investigationFinal reportI.C.A. Brasov IS-29D · Athol, IDPlt was on third flt in make/model. Witness stated approach was too low and slow to make airport. Acft made a turn to the left and then to the right. Wing dropped and acft entered stall/spin to the right and continued rotation to the ground.Jun 26, 1988 · N91419 · DestroyedNTSB DEN88LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Ogden, UTThe low time private plt and his non-pilot wife were practicing touch and go landings. The plt used the right seat and his wife used the left seat. While on final apch, the plt recognized that the airplane was too high, added full flaps and cut the power. The…Jun 25, 1988 · N5113W · Substantial damageNTSB LAX88FA230Accident · 4 fatalField investigationFinal reportCessna 310 · Big Bear Lake, CAThe recently certificated multiengine pilot and friends flew to big Bear airport for lunch. The density altitude at the airport was about 8,000 feet. The pilot entered a south downwind leg for runway 07 at the airport following a Mooney 231. Ground witnesses…Jun 23, 1988 · N170R · DestroyedNTSB LAX88LA205Accident · No injuriesLimited investigationFinal reportCessna 150J · Calistoga, CAJun 20, 1988 · N61175 · Substantial damageNTSB MIA88LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Coldwater, MSThe physician student plt made 3 attempts to land in this short unimproved field. On the 3rd pass, he collided with trees at the end of the rwy while attempting a go-around. The student plt did not have his cfi's permission to land there nor had he received…Jun 19, 1988 · N95056 · Substantial damageNTSB LAX88LA225Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Santa Barbara, CAJun 19, 1988 · N37354 · Substantial damageNTSB CHI88DEC03Accident · Minor injuriesFinal reportCessna 150 · Jackson, MITotal loss of engine power due to carburetor icing.Jun 18, 1988 · N5810E · Substantial damageNTSB MIA88FA195Accident · 1 fatalField investigationFinal reportPiper PA-31-P · Miami Lakes, FLThe instructor (CFI), who survived, was flying the acft fm the rgt fnt seat while the owner/plt was in the left seat. The flt had progressed normally until the plts rtrnd to the arpt to lnd. Clnc was received to lnd on rwy 9L. According to the CFI, he lowered…Jun 17, 1988 · N560JB · DestroyedNTSB LAX88LA226Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6-100 · Tau, AntarcticaThe captain, who was flying the twin otter from the right seat, entered a right hand traffic pattern for landing. A left quartering, 15 knot headwind, was gusting across the airport. Upon turning to the final approach the captain reduced the aircraft's engine…Jun 17, 1988 · N202RH · DestroyedNTSB ATL88LA194Accident · No injuriesLimited investigationFinal reportCessna 150F · Newnan, GAAfter making a local flt, the student plt returned to the arpt, but drg the landing, the acft touched down abt 60' short of the rwy. Shortly after touching down, the nose gear sheared off. The acft then traveled abt 370 ft further before coming to rest beside…Jun 14, 1988 · N7776F · DestroyedNTSB BFO88FA054Accident · Serious injuriesField investigationFinal reportCessna 177RG · Clinton, MDEng pwr loss occurred when the instrument student advanced the throttle to do a go-around when the acft was too high to lnd on rwy 5 following a simulated instrmt apch. The instr took control of the acft and about half-way down the rwy, at about 300 ft AGL,…Jun 11, 1988 · N2070Q · Substantial damage