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 SEA85FA050Accident · 2 fatalField investigationFinal reportCessna 175 · White City, ORThe acft crashed after stalling during a go-around attempt. Witnesses said the acft was on final approach to the unlighted arpt with 40 degrees of flap when the go-around attempt was made. The acft rolled and turned 180 degrees before impacting the ground…Jan 27, 1985 · N7277M · DestroyedNTSB FTW85LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · League City, TXThe acft collided with a ditch about 75 yards short of rwy 13 during a practice night forced landing. The pvt plt, an employee of the FBO operator, had taken the acft without permission and had been flying for approx 1.7 hrs when the accident occurred. The 18…Jan 27, 1985 · N82048 · Substantial damageNTSB ANC85FA041Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Savoonga, AKThe plt reported that during arrival, he overflew the arpt & made a right turn while watching the village. As he maneuvered, he encountered white-out conditions, turned too FAR & subsequently collided with rising terrain. The wx over the general area prior to…Jan 27, 1985 · N4112D · Substantial damageNTSB CHI85IA097Incident · No injuriesIncident investigationFinal reportBoeing 727-51 · St. Paul, MNShortly after takeof, the aircraft experienced an uncontained 7th to 8th stage removable sleeve compressor spacer failure in the number 3 engine. Pieces of the spacer passed through the number 2 engines duct causing compressor stalls in that engine. The…Jan 26, 1985 · N463US · Minor damageNTSB ATL85LA082Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Vicksburg, MSDuring the landing attempt, the pilot failed to ensure that the landing gear was extended. He was preoccupied with trying to locate a runway sweeper reported by the airport manager. When the gear failed to extend the pilot continued the approach knowing that…Jan 25, 1985 · N3057 · DestroyedNTSB NYC85LA055Accident · No injuriesLimited investigationFinal reportCessna 206G · Endicott, NYThe plt stated that the eng RPM dropped to idle when he made his second pwr reduction on downwind in preparation for landing. The throttle could not be pushed in when an attempt to add pwr was made. The acft touched down short of the rwy and came to rest aprx…Jan 20, 1985 · N9940Z · Substantial damageNTSB FTW85LA097Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Wichita Falls, TXPlt intentionally ran the rt fuel tank empty and switched to the left tank which was 1/2 to 3/4 full on takeoff. Plt maintained a left side slip during the landing apch to compensate for x-wind conditions. Plt stated, at 400 ft AGL he noticed a pwr loss.…Jan 18, 1985 · N5162D · Substantial damageNTSB LAX85LA112Accident · No injuriesLimited investigationFinal reportHughes 369D · Kahului,Maui, HIAccording to the plt, about 1.4 hours into a local photo flt, the fuel gage showed 125 pounds and he elected to return to the arpt for more fuel. With the fuel gage showing just under 100 pounds, engine flamed out on approach to the arpt and plt executed an…Jan 16, 1985 · N58399 · Substantial damageNTSB LAX85LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Compton, CAAs the student plt was about to touchdown on rwy 25L the acft swerved to the left. He attempted a go-around & in order to avoid parked acft to the south of the adjacent taxiway he applied aft elevator & stalled the acft, landing upon & destroying two other…Jan 13, 1985 · N9755T · DestroyedNTSB LAX85FA106Accident · Serious injuriesField investigationFinal reportCessna 177B · El Monte, CAThe engine lost pwr & was restarted twice before it quit. The acft landed in a dry riverbed two miles south of the arpt. Two ounces of fuel were found at the scene. Winds were slightly greater than forecast. Four taxi/runup/takeoff/ climbs had been made since…Jan 12, 1985 · N34212 · DestroyedNTSB ANC85LA039Accident · No injuriesLimited investigationFinal reportCessna C-207 · Nome, AKPlt obtained a special VFR to land at Nome arpt. Plt saw apch lights and made a left circle to line up with rwy. Plt stated, ceiling was 300 ft AGL, low visibility and freezing drizzle was present. Aprx 3/8 inch of ice was on airframe and windshield. Plt…Jan 11, 1985 · N7396U · Substantial damageNTSB LAX85FA102Accident · Serious injuriesField investigationFinal reportCessna T210L · Hesperia, CAThe plt reptd that shortly after entering the downwind leg for ry 03 he completed the prelanding checklist. While on final approach the acft experienced a total loss of engine powe. The acft altitude was too low to negotiate a landing on the ry & the plt…Jan 10, 1985 · N210NF · DestroyedNTSB DCA85AA009Accident · 3 fatalFinal reportLockheed 188A · Kansas City, KSDuring arrival to the Kansas City downtown arpt, the flt was vectored for a VOR rwy 3 apch, then was cleared for the apch & to circle & land on rwy 36. On final apch, the acft was hi & was not in a position to land, so the flt was cleared to circle left for…Jan 9, 1985 · N357Q · DestroyedNTSB CHI85LA086Accident · No injuriesLimited investigationFinal reportCessna 310Q · Plato Center, ILThe acft experienced a nose gear collapse during landing. The plt stated that while on final apch the acft contacted a 3-4 ft high snowbank near the end of the rwy which resulted in the nose gear collapse. He continued to state the snowbank was difficult to…Jan 9, 1985 · N7513Q · Substantial damageNTSB NYC85LA053Accident · No injuriesLimited investigationFinal reportCessna C207 · North East, PAThe acft was damaged during a forced landing in a grape vineyard. The plt stated that a ttl loss of pwr occurred during an apch to erie int'l arpt while passing through 3200 ft MSL. The plt performed emergency procedures and was able to regain partial pwr…Jan 8, 1985 · N91046 · Substantial damageNTSB CHI85IA084Incident · No injuriesIncident investigationFinal reportSwearingen SA-227-AC · Covington, KYThe aircrew reported that during flt at 6000 ft MSL, they encountered icing conditions & used the de-ice & anti-ice equipment. After they descended & were clear of icing, they deactivated the de-ice & anti-ice equipment. The capt said hechecked the prop…Jan 8, 1985 · N3110J · No damageNTSB BFO85FA011Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-25 · West Point, VAAfter being delayed at least 2 days at youngstown, OH, due to maintenance problems the plt departed at aprx 1725 hrs with the knowledge that the wx at his destination was ift to lifr. In addition, the plt was scheduled for a vacation and had expressed hopes…Jan 4, 1985 · N275MA · DestroyedNTSB NYC85FNC02Accident · Serious injuriesFinal reportPiper PA-34-200T · Hopkinton, NHThe acft collided with a tree during an ILS approach in IMC wx. The acft was on a x-cty flt and the plt declared a missed approach at this pt but did not acknowledge hitting the tree. When the rt eng quit and directional control could not be maintained the…Jan 1, 1985 · N47364 · DestroyedNTSB FTW85LA091Accident · No injuriesLimited investigationFinal reportCessna 210L · Monroe, LAThe acft suffered a collapsed nose gear after losing and regaining power during an ILS approach and finally completing an emergency landing two miles from the rwy of intended landing. There were no injuries and no fire. Examination of the acft in the field…Dec 31, 1984 · N2127S · Substantial damageNTSB ATL85FA071Accident · Serious injuriesField investigationFinal reportCessna 172N · Dothan, ALThe plt, who was also an ATC specialist assigned to a fss, crashed short of the rwy during an attempted ILS apch. Whe wx conditions were below apch minimums.Dec 30, 1984 · N6527D · Substantial damageNTSB SEA85LA037Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Boise, IDOn final approach, the pilot's wife, also a rated pilot, was reviewing the landing check list. At item 'heaters off' she inadvertently turned fuel selectors to off. Both engines lost pwr and pilot executed a forced landing short of runway in rough terrain,…Dec 27, 1984 · CGTQE · Substantial damageNTSB MKC85LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Stuttgart, ARPlt stated he had attempted an NDB approach to rwy 18 but executed a missed approach when he could not see the rwy when the acft was at 800 ft. the plt pitched the acft to a climb attitude and added full throttle. He continued to state that the acft felt…Dec 27, 1984 · N2320T · Substantial damageNTSB MKC85FA040Accident · 3 fatalField investigationFinal reportBeech S35 · Hot Springs, ARThe acft collided with trees & crashed on the east side of west mountain after the plt had made an ILS rwy 5 apch & overflew the arpt. The last wx observation before the accident was: partial obscuration, ceiling 300 ft, visibility 1 mi. The decision height…Dec 27, 1984 · N69WF · DestroyedNTSB ATL85LA069Accident · No injuriesLimited investigationFinal reportCessna 172H · Fairburn, GAThe aircraft reportedly suffered a loss of power while on the x-wing leg for a touch-&-go landing. The plt attempted to land the aircraft on the reciprical rwy from which he departed. The aircraft touched down long and ran off of the end of the runway into…Dec 27, 1984 · N9347H · Substantial damageNTSB ATL85LA066Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ft Knox, KYN6666P, contacted the ground 100 yds short of rwy 36 during landing at Ft Knox, KY, while on a personal flight. The acft sustained substantial damage to the nose, left main landing gear, both wings and the propeller. Investigation revealed the acft exceeded…Dec 25, 1984 · N6666P · Substantial damageNTSB ATL85LA065Accident · No injuriesLimited investigationFinal reportMooney M20E · Monroeville, ALPlt unable to electrically or manually fully extend landing gear in traffic pattern so he decided to make a gear up landing. Unknowingly plt had lowered gear to a transit position and gear collapsed on landing. Plt had previous problems with gear and had to…Dec 25, 1984 · N9418V · Substantial damageNTSB FTW85FA084Accident · 4 fatalField investigationFinal reportBeech A36 · Lake Charles, LAThe acft crashed 3 miles short of the Lake Charles airport while on an ILS approach. Instrument meteorological conditions prevailed at the time of the accident, and an IFR flight plan was filed by the non-instrument rated pilot. A review of the radio…Dec 24, 1984 · N2049G · DestroyedNTSB CHI85LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Troy, MIThe plt reported a loss of power while in the traffic pattern. During his manuvering to position the acft for landing, the acft stalled & impacted in a field. Investigation did not reveal any fuel/eng malfunction that would have contributed to the accident.Dec 23, 1984 · N9645W · Substantial damageNTSB LAX85LA080Accident · No injuriesLimited investigationFinal reportHardy Quickie · Hollister, CAThe plt was conducting a high speed taxi run on a newly built acft when it became airborne. He continued the takeoff & flew the acft for a short period of time, then prepared for a landing with partial power. While on final & about 15 ft AGL, he believed he…Dec 22, 1984 · N7NH · Substantial damageNTSB DEN85LA047Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Taylor, UTAcft collided with a pile of snow near the edge of rwy while landing. Plt stated he misjudged the apch and reduced power prematurely.Dec 22, 1984 · N3648A · Substantial damageNTSB MKC85FA037Accident · 1 fatalField investigationFinal reportAero Commander 690A · Pea Ridge, ARPlt was cleared for vor/dme approach to rogers arpt by fayetteville apch control; fayetteville altimeter setting of 29.85 (confirmed by recorded transcript) furnished. Plt did not read back. During apch, acft impacted trees 25 ft AGL at aprx 1320 ft MSL, 3…Dec 21, 1984 · N9229Y · DestroyedNTSB BFO85IA056Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · New Orleans, LADuring arrival, a Boeing 747, registration number d-abyp, lufthansa flight 5432, was vectored for an ILS localizer backcourse apch to rwy 19 at the new orlean intl arpt. While on the apch at 2000 ft MSL, the aircrew were instructed by the arrival controller…Dec 20, 1984 · DABYP · 2 aircraft · No damageNTSB ATL85FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Glasgow, KYThe acft crashed one mi short of rwy 07 at Glasgow municipal airport while on sdf rwy 07 inst app. There were no witnesses to the actual accident other then the surviving passenger who stated that the plt had asked her to look for the rwy lights. She stated…Dec 20, 1984 · N6077H · DestroyedNTSB FTW85FA079Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Laredo, TXThe acft was observed to enter a downwind leg of the traffic pattern at a low alt (estimated 100 ft AGL). The witness looked away for a moment. When he looked back, he did not see the acft. A search was intiated & the acft was found where it had crashed in a…Dec 19, 1984 · N9249T · DestroyedNTSB NYC85FA044Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Bainbridge, NYVFR conditions prevailed when the flt departed binghamton, NY. The destination was reported as clear until just prior to the estimated time of arrival, then fog began to form. Witnesses who heard the acft, just prior to the accident, reported heavy fog. After…Dec 18, 1984 · N6099Y · DestroyedNTSB FTW85LA080Accident · No injuriesLimited investigationFinal reportCessna 421C · Vancourt, TXAfter a complete wx brf the plt departed into known IFR cond well below apch min at the dest arpt with inadequate fuel reserves and no field alternate. After 2 missed apchs the plts desired alternate was below minimums. En route to a second alternate airport…Dec 17, 1984 · N6865D · Substantial damageNTSB BFO85FA009Accident · Serious injuriesField investigationFinal reportGrumman AA-5A · Manassas, VAAfter a higher and faster apch than usual due to conflicting traffic, the acft touched down on the nosewheel and began to porpoise, according to witnesses. After the second bounce, power was added for a go around, the pilot later stated. Witnesses saw the…Dec 17, 1984 · N14LC · DestroyedNTSB LAX85LA072Accident · No injuriesLimited investigationFinal reportCessna 150F · Glendale, AZThe acft lost power & nosed over while making an emergency landing in a muddy field. Investigation revealed that fuel was being siphoned from the fuel tank vent.Dec 15, 1984 · N7967F · Substantial damageNTSB ATL85FA055Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Burlington, KYAcft ferried VFR by owner. Radios repaired before departure, glide slope receiver found inop. At fuel stop wx was forecast IFR for destination. An IFR instructor was then hired for the remaining flt. Owner showed work order to CFI who incorrectly concluded…Dec 14, 1984 · N5211S · DestroyedNTSB MIA85FA058Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Miami, FLPlt judged by reference to acft gages that he had 156 gals of fuel remaining when infact only 120 gals of fuel remained. On approach for lndg, while operating on aux tanks, low fuel flow warning light illuminated. Plt switched to main tanks and both engines…Dec 13, 1984 · N40790 · Substantial damageNTSB ATL85LA053Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Albermarle, NCPlt saw unfamiliar mountain range and decided to land in a residential construction site to find out his exact location. Plt failed to see electrical wires during the descent until too late. Plt lost control of acft in last minute attempt to avoid wires. Acft…Dec 13, 1984 · N7401F · Substantial damageNTSB ATL85FA054Accident · Serious injuriesField investigationFinal reportBeech D18S · Norfolk, VAThe acft crashed during an ILS approach following an engine power loss while on an air taxi freight flight. The plt related that at about 550 ft on the approach to rwy 23 the left eng fuel press warning lite illuminated & the lt eng loss power. The plt opened…Dec 13, 1984 · N8517Z · DestroyedNTSB CHI85LA069Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Columbus, OHThe plt reported that he did not have the acft refueled prior to departure & once airborne encountered a stronger head wind than anticipated. He stated that most of the possible en route fuel stops were 'down due to fog.' When aprx 18 mi past port Columbus…Dec 11, 1984 · N22FP · DestroyedNTSB ANC85FA027Accident · No injuriesField investigationFinal reportCessna 140 · Wasilla, AKOn go-around during a simulated forced landing over a dirt landing strip engine began to sputter and run rough. Plt stated power was reduced and engine began to run smooth. Fuel tank was switched and 15 to 20 seconds later, engine quit. Forced landing was…Dec 10, 1984 · N77227 · Substantial damageNTSB ATL85MA049Accident · 1 fatalMajor investigationFinal reportBeech 58 · Charleston, SCPlt descended below mda during a night VOR (non-precision) apch to an uncontrolled arpt and collided with trees & groundwhich were obscured by fog. The plt had 'pushed' himself to make the trip according to friends and associates in an attempt to win an…Dec 6, 1984 · N7230R · DestroyedNTSB LAX85LA058Accident · No injuriesLimited investigationFinal reportCessna P210N · Lancaster, CAPlt elected to make a precautionary landing at Lancaster due to a low fuel state. Eng quit while on downwind in traffic pattern. Unable to make it to the rwy, an off arpt landing was made during which the acft was damaged.Dec 4, 1984 · N7606P · Substantial damageNTSB FTW85LA068Accident · No injuriesLimited investigationFinal reportCessna T310R · Lubbock, TXAccording to the plt icing conditions were encountered during the asr apch. Deicing equipment was utilized several times during the apch and worked normally. The acft broke out at 400 ft AGL. Ice accumulation on the wings resulted in an excessive rate of…Dec 4, 1984 · N4864A · Substantial damageNTSB SEA85LA023Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Pocatello, IDThe acft had descended to about 900 AGL after passing through icing conditions with a light accumulation of ice. When the landing gear was lowered the acft started yawing and the acft engine instruments were flucuating. The plt thought that the engines were…Nov 30, 1984 · N37279 · Substantial damageNTSB MKC85LA028Accident · No injuriesLimited investigationFinal reportCessna 421B · Mason City, IAThe ATP PIC knew that he would be flying into area of surface icing. Boots on horizontal stabilizer did not remove ice. Over rwy at 30 ft, acft stalled & hit the rwy hard. Manufactorer states acft cannot be certified for flt into known icing. Deice and…Nov 27, 1984 · N41097 · Substantial damageNTSB ATL85LA045Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Ahoskie, NCWhile on a night VFR local area flight the pilot noticed haze obscuring the lights on the ground. He returned to the airport and activated the REIL lights, he lost sight of the lights as he entered the traffic pattern. During the left turn to base, he entered…Nov 27, 1984 · N12946 · Destroyed