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 FTW87LA167Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Quitman, TXDuring final approach for landing, the pilot allowed the airspeed to drop. The aircraft stalled at approximately 30 to 40 feet AGL. Substantial damage occurred when the aircraft bounced, cartwheeled and slid to a stop backwards 300 feetbeyond the threshold.Jul 12, 1987 · N5594T · Substantial damageNTSB ATL87LA208Accident · No injuriesLimited investigationFinal reportSchleicher K8B · Monroe, GAThe private plt was on his first flt of the day in a glider that he had not flown recently. He reported the takeoff, tow and traffic pattern as normal. He used the spoilers sparingly until he turned final. He was most surprised, he said, when one of the…Jul 12, 1987 · N7624 · Substantial damageNTSB MIA87IA204Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Washington, DCDrg arr, the acft's radar showed tstms in the area of the arpt. As the flt contd, ATIS info chgd. When the plts ctcd Washington apch ctl with old ATIS info, the ctlr did not correct the flt. They were adzd of hvy rain, strong wnds & a PIREP of wndshr nr the…Jul 11, 1987 · N8892Z · Minor damageNTSB MKC87LA132Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Russellville, ARDuring the night approach, the pilot saw the reflection of orange balls on a powerline. He added power and went over the powerline, then reduced power to land and stalled the aircraft short of the runway. The nose gear broke off and the airplane slid 200…Jul 10, 1987 · N3604Q · DestroyedNTSB LAX87LA263Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Keams Canyon, AZDuring a business flight to a private dirt strip, while on final approach the plt was distracted for a few seconds. When his attention was back on the acft, it had drifted east of the strip. The plt applied pwr, however, he stated that the engine did not…Jul 10, 1987 · N3598U · Substantial damageNTSB MIA87LA201Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Naples, FLThe plt stated that his aprch speed was too fast & he touched down about half way down the 3400 ft rwy. Believing that he would not get stopped during the ldg roll, he attempted to go around, but the gear struck a fence near the end of the rwy & dragged the…Jul 8, 1987 · N5005E · Substantial damageNTSB LAX87LA258Accident · No injuriesLimited investigationFinal reportCessna 172 · Hawthorne, CADrg an apch to rwy 25, the acft collided with the omni directional apch lighting system (odals). The plt indcd that she enctrd a downdraft on short final & applied full power; however, the acft contd to dscnd & struck one of the odals light cover lenses with…Jul 8, 1987 · N1466U · Substantial damageNTSB FTW87LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Baton Rouge, LAThe plt rprtd that after taking off to practice touch & go lndgs, the eng lost pwr. He atmtd to make a forced lndg on the arpt, but was unable. While lndg short of the rwy, the acft hit the top of a tree & the arpt security fence. Maintenance had just been…Jul 8, 1987 · N8485L · Substantial damageNTSB FTW87LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Roanoke, TXDuring final approach the aircraft developed an excessive sink rate and the pilot elected to go-around. When the pilot applied power the nose and right wing pitched up, causing the aircraft to turn 90 degrees, and stall. The aircraft contacted some power…Jul 5, 1987 · N15491 · Substantial damageNTSB ATL87LA199Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Mt. Airy, NCThe instructor stated this was the second flight of the day with the student. They had released from an air tow at 1,500 feet AGL. The instructor was demonstrating glide slope control for best final glide. When the sailplane was about 1,000 feet AGL and one…Jul 5, 1987 · N930BG · Substantial damageNTSB ATL87LA198Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · St Marys, GAAfter returning fm a local ngt flt, the acft was lndd gear up when the lndg gear did not extend. The acft bgn burning after it came to rest. It was extensively damaged by fire & the cause of the gear malfunction was not determined. Local police, who responded…Jul 5, 1987 · N6165P · Substantial damageNTSB SEA87FA129Accident · 2 fatalField investigationFinal reportCessna 150G · Vashon, WAAircraft departed on a routine instructional flight. Radar track indicated aircraft engaging in maneuvers typical of instructional high work (stalls/turn/slow flight) followed by left orbit about grass airstrip used only for practice emergency landing…Jul 4, 1987 · N3736J · DestroyedNTSB MIA87LA197Accident · Minor injuriesLimited investigationFinal reportCessna TU-206F · Ft. Lauderdale, FLThe pilot refueled for the flight by topping off the fuel tanks. He then utilized the left tank until it was empty and switched to the right for the remainder of the flight. About 2 miles short of the destination the engine failed. The right fuel cap was…Jul 4, 1987 · N744AP · Substantial damageNTSB DEN87FA167Accident · 1 fatalField investigationFinal reportMooney M20F · Mitchell, SDThis non-licensed plt made an unauthorized flt at night. The acft crashed one half mile north of the arpt. The occupant of the acft was fatally injured. No records of the plt's flt experience was found.Jul 4, 1987 · N6933V · DestroyedNTSB CHI87DEC04Accident · 2 fatalFinal reportBeech S35 · Pontiac, MIAcft was making a low pass about 200 ft AGL over rwy 27L to allow ATCT personnel to inspect landing gear position after reporting landing gear difficulties. After twr personnel informed the plt that the gear appeared to be down, the plt requested to land on…Jul 4, 1987 · N9011S · DestroyedNTSB ATL87LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fayetteville, NCDuring approach the pilot noticed that he was too high and fast for a normal approach. He reduced power and slowed the aircraft and increased the descent rate to attempt the landing. When he attempted to add power and arrest the increasing descent rate the…Jul 4, 1987 · N1162F · DestroyedNTSB CHI87DEP08Accident · No injuriesFinal reportUnknown Avid Flyer · Cottage Grove, WIOn return from the second test flight in the experimental aircraft, the pilot failed to maintain the proper descent rate on short final. An attempt to add power to correct the situation was unsuccessful, and the aircraft touched down on a highway short of the…Jul 3, 1987 · N169AF · Substantial damageNTSB ATL87LA200Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Greenville, SCBalloon dtpted launch site about six miles sw of landing airport for a key grab during a Balloon ralley. Wind was about seven KTS according to PIC. Approaching field to land basket was dragged through tree tops to slow Balloon. Power line hidden by the trees…Jul 3, 1987 · N7420U · Minor damageNTSB ANC87LA087Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Chistochina, AKDuring a telephone interview the pilot stated the aircraft did not produce full power and believed the reason was the propeller setting was not set to high RPM before landing. The aircraft stalled on final approach to the airport and the aircraft impacted the…Jul 2, 1987 · N3403S · Substantial damageNTSB MIA87LA194Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Opa Locka, FLThe plt stated that he was on a long final apch for Opa Locka airport & he lost all power. During a forced landing in an open field he struck a pile of logs, collapsing the nose gear. Post crash run of the eng revealed no evidence that would suggest a failure…Jul 1, 1987 · N8889T · Substantial damageNTSB LAX87LA248Accident · No injuriesLimited investigationFinal reportBeech A36 · Temecula, CAThe aircraft made a hard landing when the pilot encountered turbulent crosswinds in the final stages of the landing approach. Both U.S. Government and aopa's airport directories contain warnings in the airport remarks sections of occasional strong turbulent…Jun 30, 1987 · N2025L · Substantial damageNTSB ATL87LA195Accident · No injuriesLimited investigationFinal reportCessna 172E · Denmark, GAThe acft struck power lines and severed the nose gear during landing. When the nose was lowered to ground on landing roll acft nosed over inverted. Acft was being delivered to mechanics new airstrip for annual inspection. The plt was unaware of power lines…Jun 29, 1987 · N7734U · Substantial damageNTSB ANC87FA084Accident · No injuriesField investigationFinal reportCessna 185 · Anchorage, AKThe acft was stalled on short final for landing. It touched down hard on the rwy and directional control was lost. The acft veered off the right side of the rwy and struck two parked acft.Jun 28, 1987 · N70018 · Substantial damageNTSB LAX87LA245Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tucson, AZAt the end of a business flt, the plt extended the landing gear and noted that the left main landing gear indicated that it was not down and locked. The plt activated the emergency landing gear extension which still indicated it was not down. While on final…Jun 27, 1987 · N4364X · Substantial damageNTSB NYC87FA187Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Boston, MAThe en route portion of the flt was uneventful, except that the plt used the call sign 'N251DE' instead of 'N33670' which was the registration number of his acft. Drg arrival at Boston, he was provided radar vectors, cleared for an ILS rwy 4R apch &…Jun 26, 1987 · N33670 · DestroyedNTSB SEA87LA123Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ketchikan, AKOn landing at Ketchikan airport the pilot stated he made a last minute runway change due to departing traffic. Turning base the pilot reduced power to idle. He then advanced the throttle and received no response. The pilot could not make the runway and…Jun 25, 1987 · N1454T · Substantial damageNTSB BFO87LA042Accident · No injuriesLimited investigationFinal reportCessna 177A · Oakland, MDAfter flying around for about one hour to check out some radios in the aircraft, the pilot elected to return to the airport. On short final he elected to do a go-around and midway down runway 26 he pushed in carburetor heat, added full throttle and decreased…Jun 25, 1987 · N30454 · Substantial damageNTSB ATL87FA187Accident · 1 fatalField investigationFinal reportBeech V35A · Augusta, GAThe plt ctcd apch ctl for radar svc & wx info. The destn arpt had hvy rain & thunderstorm activity, but the plt rprtd he had the arpt in sight. Radar svc was terminated & the plt began a visual apch. Witnesses rprtd the visibility dropped to 1/2 mi in hvy…Jun 25, 1987 · N2334A · DestroyedNTSB NYC87LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Olyhant, PAThe cross country personal transportation flight arrived in the scranton, Pennsylvania area for a planned refueling stop and encountered heavy fog conditions. Six attempts to land were made, but were aborted. An attempt to land at another airport was also…Jun 24, 1987 · N35354 · Substantial damageNTSB MKC87LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, NEAfter completing an IFR simulated NDB approach to runway 35L, PIC side-stepped to land VFR on 35R. During base leg acft had a partial power loss followed shortly by total power loss. PIC informed control tower of the emergency and made a forced ldg in a farm…Jun 24, 1987 · N66686 · Substantial damageNTSB BFO87DIG07Accident · Minor injuriesFinal reportCessna 150/Horton Stol · Maysville, WVThe plt/owner was flying a Cessna 150 which was equipped with a horton stol kit. Drg an apch to rwy 3, he used an airspeed of 40 KTS. While apchg the rwy, the acft settled & the nose gear struck a bump on the apch edge of the rwy. The plt rprtd that the…Jun 24, 1987 · N150VA · Substantial damageNTSB ATL87LA182Accident · No injuriesLimited investigationFinal reportBeech B200 · Jasper, ALThe plt obtained a weather briefing for his proposed flt from birmingham, AL to Jasper, AL to allentown, PA. He did not file a flight plan for the 35 mile flt from birmingham to Jasper, however, he did file a flight plan for the proposed flt fm Jasper to…Jun 23, 1987 · N859DD · DestroyedNTSB CHI87FA153Accident · 2 fatalField investigationFinal reportPiper PA-28R · Milwaukee, WIDrg arr at the Milwaukee/lawrence j timmerman arpt, the plt made 2 atmts to use the localizer 15L apch. After the 2nd missed apch, he elected to divert to Milwaukee/general mitchell fld (mke). At that time, he was adzd the mke wx was 300' ovc, 1/4 mi vis with…Jun 22, 1987 · N2678R · DestroyedNTSB LAX87FA239Accident · 2 fatalField investigationFinal reportRockwell 690 · Bridgeport, CAThe flt conditions for the air ambulance trip consisted of a clear, moonless, dark night and the dest arpt was in a mtn valley with the only ground reference lights the town adjacent to the arpt. Witnesses saw the acft overfly the town and arpt at pattern alt…Jun 21, 1987 · N662DM · DestroyedNTSB CHI87LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILWhile on final approach just past the threshold of runway 32 at about 10 feet AGL, a helicopter crossed in front of the Cessna 152. The student pilot added power and pulled back on the yoke. The instructor pilot then took the controls and attempted to get the…Jun 20, 1987 · N94739 · Substantial damageNTSB CHI87FA151Accident · 2 fatalField investigationFinal reportCessna 182D · Marine City, MIA witness rprtd that drg takeoff, the acft rotated to a steep (nose up) attitude, & immediately after lift-off, the plt made a steep left turn & entered a downwind for lndg on the same rwy. He described the downwind as being a little tighter than normal & a…Jun 20, 1987 · N275T · DestroyedNTSB BFO87DIG06Accident · 1 fatalFinal reportStriplin SKY Ranger · Easton, MDAfter taking off on a test flt, the plt remained in the traffic pattern & was on downwind when the eng surged or sputtered, then lost power. Soon thereafter, the acft entered a steep dscnt & crashed. The experimental, home built acft had only 11 hrs of flt…Jun 20, 1987 · N4925S · DestroyedNTSB NYC87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Tewksbury, MAThe pilot switched the fuel selector from what he thought was the left tank to both while on final approach. He then decided to make a go-around during the flare because he felt his a/s was to fast. The engine quit at 40 ft AGL during the go-around. He was…Jun 18, 1987 · N53060 · DestroyedNTSB CHI87LA146Accident · No injuriesLimited investigationFinal reportCessna 210M · La Porte, INThe acft was damaged when the left main gear collapsed drg a landing. An investigation revealed that a swaged fitting at the end of a hydraulic line in the gear sys had failed. The plt rprtd that with this failure, the left main gear only partially extended.Jun 14, 1987 · N761Q · Substantial damageNTSB NYC87LA177Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Quakertown, PAThe pilot came in high and fast on the approach. He reduced pwr initially to increase rate of descent. As he apched trees, he applied power to stop the descent, but collided with the tops of the trees. The acft yawed to the right about 30 degrees and touched…Jun 13, 1987 · N94383 · Substantial damageNTSB NYC87FA172Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Nantucket, MAThe weather at the Nantucket airport was below the prescribed minima for the ILS approach to runway 24. A blanket broadcast had been made on the air traffic frequencies that the Nantucket weather was below the minima for most users and, thereafter, the…Jun 13, 1987 · N222HF · DestroyedNTSB MIA87FA176Accident · No injuriesField investigationFinal reportBell 206L-1 · Winter Haven, FLThe pilot stated that on short final approach the engine began surging and losing power. He attempted to stretch the glide and the aircraft landed hard, short of the intended point of touchdown. The engine was removed, examined, partially disassembled and…Jun 10, 1987 · N3177L · Substantial damageNTSB SEA87FA112Accident · Serious injuriesField investigationFinal reportCessna 150L · The Dalles, ORThe student plt's instructor became seriously ill after the first leg of a dual, cross country flight. Another instructor/pilot examiner signed off on the student pilot's logbook to return solo to the departure airport. The instructor/pilot examiner failed to…Jun 9, 1987 · N6528G · Substantial damageNTSB ATL87LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Unity, OHThe CFI reported that he reduced pwr to near idle with the throttle, to have his student practice a simulated forced ldg. The engine subsequently lost pwr completely at about 400-500 ft AGL when he attempted to add pwr back so that the student could initiate…Jun 9, 1987 · N3965M · Substantial damageNTSB NYC87LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Grove City, PAThe plt rprtd that while on final apch to lnd at night, the acft stalled. He stated that he applied full power, but the acft 'just dropped.' It struck the ground short of the rwy. Drg impact, all three gear collapsed, the rgt main spar was damaged & the lower…Jun 8, 1987 · N7678F · Substantial damageNTSB LAX87LA231Accident · Serious injuriesLimited investigationFinal reportMooney M-18L · Maricopa, CADuring a pleasure flight the plt stated that while on final approach to a private airstrip, he noticed some turbulence. On short final the plt stated that a severe wind shear dropped the acft into a ravine. The plt added full pwr, however, the acft did not…Jun 7, 1987 · N115C · Substantial damageNTSB LAX87LA226Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Santa Barbara, CADuring an instrument landing system approach which is positioned partially over the water, the engine quit just after passing the faf. The pilot was unable to land the aircraft at the airport, instead, the aircraft was ditched in the ocean aprx 4 miles west…Jun 6, 1987 · N8985N · DestroyedNTSB LAX87IA230Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Los Angeles, CAOver the outer marker, the captain extended the flaps to 50 degrees. As the flaps extended past 35 degrees, the airplane rolled to the left. The flaps were retracted to the 35 degree position and a go-around was executed. The flaps were set at 22 degrees and…Jun 6, 1987 · N105AA · Minor damageNTSB FTW87FA134Accident · No injuriesField investigationFinal reportRockwell Commander 112 · Ft.Worth, TXOn 6/6/87 a Rockwell commander 112, N1153J, impacted the terrain near meacham field, forth worth, Texas while on a photography flight. The pilot had been cleared to land on runway 16L when the tower changed the runway assignment to 16R. The pilot added power…Jun 6, 1987 · N1153J · Substantial damageNTSB BFO87LA041Accident · 1 fatalLimited investigationFinal reportPiccard AX-6 · Gaithersburg, MDAfter two aborted landings the pilot saw a field in the distance and attempted to land. Although two other balloons had landed nearby, the field he was blown towards had numerous powerlines surrounding it, some of them at treetop height. During the approach…Jun 6, 1987 · N2496Z · Destroyed