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 CHI82FA350Accident · 2 fatalField investigationFinal reportMooney M20E · Houghton, MIThe acft crashed into trees while making an ILS approach to Houghton county memorial arpt, hancock, MI. The weather was IMC and an IFR flt plan had been filed. The two occupants were held in the acft by seat belts and were fatally injured in the crash and…Sep 11, 1982 · N5518Q · DestroyedNTSB ATL82DA266Accident · No injuriesFinal reportAero Commander 112 · Fayetteville, WVUpon arrival at the destination arpt, the rwy lights were off & the plt diverted to the fayette arpt. During final the acft struck a tree 200 ft from the displaced threshold of rwy 21. The tree was 13 ft above the rwy end elevation.Sep 11, 1982 · N1072J · Substantial damageNTSB ANC82FAA18Accident · Minor injuriesFinal reportStinson 108 · Fairbanks, AKThe acft collided with power lines during final approach. The plt reported he encountered a downdraft type of windshear.Sep 10, 1982 · N9489K · Substantial damageNTSB SEA82DA159Accident · No injuriesFinal reportCessna 172 · Prineville, ORDuring the landing attempt the aircraft was blown to the right side of runway 28. The pilot was unable to correct for the wind drift and attempted to execute a go-around but the left wing tip caught in sagebrush off the left side of the runway and the…Sep 9, 1982 · N6220Z · Substantial damageNTSB NYC82DA220Accident · Minor injuriesFinal reportCessna 150G · East Haddam, CTThe pilot reported that just prior to flaring, the aircraft had started drifting to the left; therefore, a decision was made to abort the landing. A go-around was initiated and flap retraction was started. However, the aircraft stalled and landed in a swamp.Sep 9, 1982 · N3601J · Substantial damageNTSB LAX82DA336Accident · Minor injuriesFinal reportCessna T207A · Riverside, CADuring the second approach the acft struck an approach light. The acft was catipulted downward & to the left striking a moving camper truck on the highway. Visibility was described as zero on the rwy minutes after the accident.Sep 9, 1982 · N7349U · Substantial damageNTSB NYC82DA214Accident · No injuriesFinal reportAero Commander 112TC · Morristown, NJWhen pilot extended gear for landing a fire started. The fire continued after landing and pilot was unable to extinguish it. Fire department arrived within 30 minutes but aircraft was destroyed.Sep 7, 1982 · N1547J · Substantial damageNTSB MKC82DA168Accident · No injuriesFinal reportCessna 150B · Wyoming, IAThe pilot used his aircraft to commute to his place of employment at east moline, IL. After work, he prepared a flight to his home in Wyoming, IA. He obtained ATIS weather information which in part was: 900 ft overcast, 4 miles visibility, fog, temperature…Sep 7, 1982 · N1106Y · Substantial damageNTSB FTW82DA371Accident · Minor injuriesFinal reportCessna 150 · Tulsa, OKAircraft collided with trees on final after engine quit due to lack of fuel. Aircraft had 1 gallon of fuel on board when it crashed.Sep 7, 1982 · N4747X · Substantial damageNTSB CHI82DA340Accident · No injuriesFinal reportCessna 150H · Genoa City, WIReturning from a cross-country flight the pilot overshot the touchdown point. During the go-around, the engine quit and the aircraft hit a tree. The pilot stated that he did not evaluate his fuel consumption properly.Sep 7, 1982 · N50318 · Substantial damageNTSB SEA82DA156Accident · Minor injuriesFinal reportCessna 172N · Cle Elum, WAThe pilot elected to get additional cross-country and mountain flying time, so she elected to fly to Cle Elum, WA. Upon arrival, she flew over and observed the wind sock to be limp. While on approach to runway 25, she decided she was too low and executed a…Sep 5, 1982 · N1295F · Substantial damageNTSB DEN82DA181Accident · Serious injuriesFinal reportErcoupe 415C · Englewood, COWhile on the downwind leg of the traffic pattern, a strong odor of fuel was detected by the aircrew. A few seconds later, there was a considerable loss of power. The engine continued to operate at reduced power, but the sink rate was too great to reach the…Sep 3, 1982 · N87141 · Substantial damageNTSB CHI82FA335Accident · 1 fatalField investigationFinal reportBell 206B · Dublin, OHA flight of 2 helicopters proceeded without incident from cumberland to the vicinity of Dublin, OH without incident. After they circled the area to determine the direction and the location of obstacles, the first helicopter landed without incident. The pilot…Sep 3, 1982 · N16969 · DestroyedNTSB LAX83FVM03Accident · Serious injuriesFinal reportFalkenthal Varieze · Palo Alto, CADuring final approach the acft suddenly pitched down about 45 deg & crashed into a duck pond containing approximately 4-5 ft of water. During examination of the wreckage it was noted a bolt was missing that secures the elevator control stick, at the…Sep 2, 1982 · N78EV · Substantial damageNTSB CHI82DA332Accident · No injuriesFinal reportHiller 12B · Detroit, MIThe plt entered the Detroit city arpt area from the west with winds from 280 degrees at 18K gusting to 23K. At 150-175 ft AGL the plt added power in order to reduce his closure rate, traveling southeasterly at the time. The acft then started yawing to the…Sep 2, 1982 · N48209 · Substantial damageNTSB FTW82DA361Accident · No injuriesFinal reportCessna 172P · Plainview, TXWhile receiving traffic advisories enroute to Plainview, the plt of the C-172 was given the traffic advisory freq for hale county arpt as 120.7. However the plt copied 127.7 & reached ftw center instead. The plt made no further attempts to obtain the correct…Sep 1, 1982 · N62405 · 2 aircraft · Substantial damageNTSB ATL82DA259Accident · No injuriesFinal reportChampion 7ECA · Middletown, VADuring approach to an uphill & narrow strip, animals crossed the rwy. A go-around was initiated & the acft drifted into trees.Sep 1, 1982 · N2530F · Substantial damageNTSB MKC82DA167Accident · Minor injuriesFinal reportPiper PA-22-150 · Higginsville, MOWhile attempting a power-off landing at a private airstrip, the pilot added power for a go-around. The engine sputtered, lost power and the pilot made a forced landing in a terraced area. The nose gear collapsed and the aircraft nosed over. Water was found in…Aug 31, 1982 · N6914D · Substantial damageNTSB MKC82FA160Accident · 2 fatalField investigationFinal reportCessna T310R · Council Bluffs, IAThe omaha weather was reported (in part) to be 3500 ft scattered, estimated 6000 ft broken, 18000 ft broken, visibility 4 mi with fog and haze, wind 200 deg at 5 KTS. However, the aircrew of a preceeding flight that arrived about 8 min earlier said they…Aug 30, 1982 · N2906A · DestroyedNTSB CHI82FA329Accident · 1 fatalField investigationFinal reportCessna 310Q · Near Woodruff, WIAt approximately 2050, the acft was cleared for a NDB approach to lakeland arpt. At 2100, the acft crashed into a heavily wooded area 8.5 mi nw of the arpt.Aug 30, 1982 · N7746Q · DestroyedNTSB NYC82FGM15Accident · Serious injuriesFinal reportWayne Ison PDQ-II · Mars, PAWitnesses stated that prior to the accident, the aircraft appeared to be operating normally, overhead and in the vicinity of the traffic pattern. One witness also stated the aircraft was in a turn as if to return for landing. He further stated that the…Aug 29, 1982 · N41835 · DestroyedNTSB NYC82FA210Accident · 2 fatalField investigationFinal reportCessna 150M · Fairfield, NJThe C-172 had been cleared for an overhead approach to enter a right downwind. The plt reported overhead & rogered that he saw the traffic coming up on midfield. He also okayed that he could follow the traffic. He was then instructed to start his right turn.…Aug 29, 1982 · N9121U · 2 aircraft · Substantial damageNTSB FTW82DA353Accident · No injuriesFinal reportCessna 183P · Spearman, TXThe pilot reported that when he was on final approach for a night landing, the aircraft encountered a downdraft. He added power to stop the descent. However, as power was added, the nose gear struck and severed a power line and the aircraft pitched over and…Aug 29, 1982 · N91MR · Substantial damageNTSB ATL82IA287Incident · No injuriesIncident investigationFinal reportPiper PA-28-140 · Beltsville, MDDuring a practice flight in preparation for a bfr, the pilot was practicing VFR go arounds at a closed airport. On the second circuit while on downwind, the engine failed while at idle. The pilots attempts to restart the aircraft were unsuccessful and he…Aug 29, 1982 · N8245N · Minor damageNTSB ATL82DA248Accident · Minor injuriesFinal reportCessna 172M · Perry, GAThe student pilot departed Perry, GA on a solo cross-country flight to augusta and jessup, GA. He was expected to return to Perry at about 1600 EDT. The flight progressed uneventfully to jessup where it was delayed by a thunderstorm. After departing jessup,…Aug 29, 1982 · N1586V · Substantial damageNTSB NYC82DFJ19Accident · No injuriesFinal reportSchweizer 2-33A · Elmira, NYThe plt stated he was too high on base & started slipping to lose excessive altitude. He lost too much altitude & speed,striking the ground short of the rwy.Aug 28, 1982 · N65850 · Substantial damageNTSB CHI82FEG04Accident · 1 fatalFinal reportBently B8M · Williamsburg, OHAfter takeoff the acft climbed to about 250 ft AGL & then made a gradual shallow 180 deg left turn heading back toward the strip. It gradually started loosing altitude without any noticable variations or disruptions in its flt path when it clipped the trees &…Aug 28, 1982 · N2774L · DestroyedNTSB CHI82DA328Accident · Minor injuriesFinal reportCessna 172 · Kenosha, WIN8186X crashed 300 feet short of Kenosha airport, runway 06. The pilot stated the elevator control failed to respond during the approach. However, an on-site investigation failed to reveal any mechanical failure or malfunction.Aug 28, 1982 · N8186X · DestroyedNTSB LAX82LUQ19Accident · No injuriesFinal reportBellanca 8GCBC · Santa Ynez, CAThe acft crashed short of the rwy during a local flt. The landing approach was to rwy 26 and the wind according to a witness was from 225 degrees at 10 KTS. Another witness account stated that the acft approached the rwy at a 90 degree angel with the right…Aug 27, 1982 · N5049U · Substantial damageNTSB NYC82DA213Accident · No injuriesFinal reportMooney M20J · Matawan, NJThe pilot stated that he had never been at this airport before. During arrival, he landed on runway 27 toward the setting sun with a crosswind from the left. He stated that he touched down firmly on the first 1/3 of the runway, then the aircraft floated…Aug 26, 1982 · N1156U · Substantial damageNTSB NYC82DA209Accident · No injuriesFinal reportCessna 421C · Saratoga Spring, NYThe aircraft was on a flight to reposition it for an air taxi operation. The pilot-in-command (PIC) was in the right seat while the second-in-command (SIC) was flying in the left seat. During arrival to the Saratoga county airport, the aircrew were cleared…Aug 25, 1982 · N88572 · Substantial damageNTSB ANC82IA076Incident · No injuriesIncident investigationFinal reportCessna 206B · Scammon Bay, AKWhen on short final the pilot attempted to add power for glide path correction but received no engine response. He switched tanks and opened the strainer drain valve because of previous water contamination problems. He made a left turn to make an emergency…Aug 25, 1982 · N3870G · Minor damageNTSB NYC82DA240Accident · Minor injuriesFinal reportPiper PA-28-140 · Honeoye Falls, NYThe pilot departed rochester, NY on a cross country flight destined for ithaca NY. Enroute she became disoriented and called on 121.5 to receive help from the local controlling facility and was vectored towards Honeoye airport. While approaching the airport,…Aug 24, 1982 · N41419 · Substantial damageNTSB CHI82FA326Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Athens, MIThe acft was landing on rwy 27 which has a 350 ft displaced threshold due to 24 ft high power lines on the approach. A witness stated the plt was low & narrowly missed the wires on the first touch & go. During the second approach the plt was noticeably lower…Aug 24, 1982 · N2928H · DestroyedNTSB SEA82DA148Accident · No injuriesFinal reportPiper PA-22-135 · Weiser, IDDuring a simulated forced landing, the instructor pilot took control of the aircraft at the go-around point. He followed the normal procedure for the go-around (full power) carb heat, etc), except that he continued the low approach to provide the student with…Aug 23, 1982 · N3762A · Substantial damageNTSB LAX82FA308Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Los Angeles, CAThe flt departed santa monica at 0830 for a local flt. At 0926 the plt called from downtown Los Angeles for landing at santa monica. At 9028 the plt 3 mi east of a VFR reporting point with eng trouble & that he had to come down. The acft wing struck the roof…Aug 22, 1982 · N6825P · DestroyedNTSB CHI82DA325Accident · No injuriesFinal reportCameron 0-77 · Wall Lake, MIThe pilot reported that during flight, he encountered unexpected light turbulence and elected to land at the next available spot. He stated that during a landing approach at about 50 ft above the treetops, a gust of wind was encountered that forced hot air…Aug 22, 1982 · N89MW · Substantial damageNTSB ATL82DA246Accident · No injuriesFinal reportCessna 182P · Batesville, GAThe pilot reported that during the landing, he flared normally at what he perceived to be the runway threshold. He was surprised when he touched down hard on an upslope, about 15 feet short of the marked threshold and several feet below the runway level. The…Aug 22, 1982 · N9398G · Substantial damageNTSB SEA82FYM23Accident · No injuriesFinal reportHughes 369HS · Troutdale, ORThe flt originated at the plt's residence 20 mi south of the Troutdale arpt. The plt stated the purpose of the flt was to refuel the acft since he figured he had about 8 gals of fuel on departure. As the acft approached the ground at about 50 ft AGL the plt…Aug 21, 1982 · N56AD · Substantial damageNTSB MKC82FA149Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Kansas City, MODuring the approach to topeka the crew was unable to extend the left gear. The crew diverted to Kansas City, and after many unsuccessful attempts to lower the left gear elected to land wheels-up. The left main gear was jammed into the geardoors. The aft hinge…Aug 20, 1982 · N237AM · Substantial damageNTSB MKC82DA146Accident · No injuriesFinal reportMitsubishi MU-2B-20 · Camdenton, MOThe pilot landed hard damaging the landing gear on a paved area short of the displaced threshold. Flaps were set at 20 degrees instead of 40 degrees. After initial landing, the aircraft swerved right and went off the runway.Aug 18, 1982 · N550MA · Substantial damageNTSB DEN82DA167Accident · Serious injuriesFinal reportPiper PA-28-235 · Englewood, COThe engine quit on downwind and the pilot attempted to land downwind on the runway but crashed off the airport. The fuelselector was found on an auxiliary tank. According to the pilot and other operators of the aircraft, only about three gallons of fuel are…Aug 18, 1982 · N16541 · Substantial damageNTSB FTW82DA335Accident · No injuriesFinal reportPiper PA-32R-300 · Alexandria, LAThe purpose of the flight was to prepare the pilot in the left seat for a commercial flight rating. After a power-off descent from 4000 ft to 2000 ft, the instructor gave the student a simulated forced landing. Reportedly, the throttle was opened briefly at…Aug 17, 1982 · N7744C · Substantial damageNTSB SEA82DA143Accident · No injuriesFinal reportPiper PA-28-161 · Redmond, ORThe student pilot was on a solo cross-country flight from hillsboro, OR to yakima, WA, to Redmond, OR and then return to hillsboro. The pilot reported a number of altitude and course deviations during the first two legs of the cross-country to avoid clouds.…Aug 15, 1982 · N38918 · DestroyedNTSB NYC82FA199Accident · 3 fatalField investigationFinal reportBeech C24R · Trenton, NJDuring an approach to the mercer county airport at Trenton, n.j., the aircraft lost power and landed off airport in trees. The fuel selector was found positioned between left tank and off. The pilot attempted to fly to the runway, but unable. The aircraft…Aug 15, 1982 · N18958 · DestroyedNTSB NYC82DA198Accident · No injuriesFinal reportCessna R182 · Endicott, NYAfter making an approach and go-around, the pilot turned to a downwind and moved the gear selector to the down position. However, the gear would not extend by using either the normal system or emergency hand pump. Subsequently, the aircraft was landed on a…Aug 15, 1982 · N9083C · Substantial damageNTSB ATL82DA239Accident · No injuriesFinal reportPiper PA-38 · Huntsville, ALThe student pilot was on a flight check to obtain a private pilot certificate. The flight examiner had instructed him to stay in the pattern and demonstrate a short field approach and landing. The flight examiner stated that on final approach, the aiming…Aug 15, 1982 · N2514E · Substantial damageNTSB LAX82FUD04Accident · No injuriesFinal reportPiper PA-28R-201 · Hawthorne, CAThe acft crashed on final approach after the engine lost power. The plt stated that on final the engine backfired, lost power and would not respond to throttle movement. The engine had been the subject of previous write-ups & work orders, which included fuel…Aug 14, 1982 · N9342C · Substantial damageNTSB LAX82FA297Accident · 2 fatalField investigationFinal reportCessna 172 · Lompoc, CAA student plt in a Cessna 152, N4603L, was departing from rwy 25 while Cessna 172, N733HV, was arriving from the north. After taking off, the student made a right climbing turn toward the north, then began another turn to the east in accordance with published…Aug 14, 1982 · N733HV · 2 aircraft · DestroyedNTSB ATL82DA237Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Spout Springs, NCThe pilot stated that the wind was gusting and shifting as he was landing with a cumulus build-up nearby. He reported that during his landing, he increased his airspeed to compensate for a gusty crosswind. The pilot stated that the mechanical brakes did not…Aug 14, 1982 · N96046 · Substantial damage