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 ATL83FA377Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-23 · Battleboro, NCThe acft spun into the ground short of the rwy on final approach. This glider was towed aloft and flew in the local area for over an hour prior to the accident. A witness observed the glider enter the traffic pattern, turn base and overshoot the turn to…Sep 24, 1983 · N124M · Substantial damageNTSB MIA83IA236Incident · No injuriesIncident investigationFinal reportBeech E18S · Opa-Locka, FLBoth normal and emergency landing gear systems failed duringthe landing apch. The gear motor cutout switch was struck anthe emergency instruction plate in the cockpit was installed backwards. The pilot states that he had tried turning the handle in both…Sep 22, 1983 · N967 · Minor damageNTSB CHI83LA436Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Pontiac, MIWhile returning from a traffic reporting flt, the plt elected to practice an autorotation. He stated that while he was in the process, the eng failed. He reported that he had initiated standard autorotation procedures, but impacted hard during the landing.…Sep 21, 1983 · N5692L · Substantial damageNTSB ANC83FA180Accident · 2 fatalField investigationFinal reportCessna 185 · Valdez, AKThe plt had tried to fly to silver lake, earlier that morning, but had to abort the mission due to low ceiling & visibility. When he had returned at 1110 adt, the ceiling had improved, but there was still layers of stratus & fog below the main cloud base.…Sep 21, 1983 · N4559F · Substantial damageNTSB SEA83FU009Accident · Serious injuriesFinal reportCGS Hawk · Richland, WAAfter being assembled, the ultralight vehicle was taxi tested, and on 9/19/83, it was flown on its 1st flt. The next morning it was taxi tested again. At aprx 0855 PDT, the plt took off on a local flt. At aprx 0945, after making a touch-and-go landing, the…Sep 20, 1983 · UNREG · DestroyedNTSB ANC83FA177Accident · No injuriesField investigationFinal reportPiper PA-12 · Anchorage, AKWhile approaching merrill field the eng quit. The acft landed on a city road & the gear collapsed. The wx in the vicinity of the accident site had marginal conditions with both rain & fog. The temp/dew point spread was 2 deg f. the plt attributed the eng…Sep 20, 1983 · N2810M · Substantial damageNTSB MIA83LA234Accident · No injuriesLimited investigationFinal reportBeech M35 · Bartow, FLDuring arrival, the plt had intended to reposition the fuel selector from the right main to the left main position. However, he left the selector positioned at the right main tank. While on final apch, the eng lost power. The plt activated the boost pump &…Sep 19, 1983 · N658V · Substantial damageNTSB MIA83FA235Accident · Serious injuriesField investigationFinal reportBeech 65-80 · Miami, FLSeveral days prior, a fam flt was intended in the acft to be given to the plt by another person who represented himself as a plt. The flt was cancelled due to a problem with the left eng. On the day of the accident, the other person told the plt that the eng…Sep 19, 1983 · N55ED · DestroyedNTSB LAX83LA445Accident · No injuriesLimited investigationFinal reportCessna P210N · Burbank, CAWhile on final apch for a night landing, the eng lost power & the plt was unable to reach the rwy. Subsequently, during an emergency landing, the acft hit the top of a cyclone fence, damaging the nose gear, then the acft slid into a blast barrier. An eng…Sep 19, 1983 · N4845W · Substantial damageNTSB FTW83FA431Accident · 2 fatalField investigationFinal reportRockwell 690A · Nacogdoches, TXAfter transporting passengers from longview, TX to Oklahoma city, ok & return to longview, the acft was refueled for a flt back to Nacogdoches, TX, where the acft was based. About 12 min after takeoff, the plt was cleared for an NDB apch to Nacogdoches &…Sep 19, 1983 · N111QL · DestroyedNTSB LAX83LA443Accident · Minor injuriesLimited investigationFinal reportFueslein Quickie · San Andreas, CAThe home built acft was equipped with a kawasaki TA-440A eng & an unspecified propeller, both of which were different than the original plans called for. The plt stated that on the 1st test flt with the new eng & prop combination, the eng RPM & thrust would…Sep 18, 1983 · N19Q · Substantial damageNTSB NYC83FA244Accident · No injuriesField investigationFinal reportSud SA316B · Pittsburgh, PAThe helicopter was on a flt to transport an acutely ill patient from one hospital to another. The aircrew consisted of a plt & two flt nurses. During arrival at the destination, the plt began an apch to an athletic field that was surrounded by tall bldgs & a…Sep 17, 1983 · N72590 · DestroyedNTSB LAX84LA020Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Santa Ynez, CAThe plt made his apch to land on rwy 26 with winds reportedly from 270 deg at 10 gusting 15 KTS. During the landing, the acft touched down short of the runway in an area containing deep furrows. Subsequently, the main gear collapsed & the fuselage & wings of…Sep 17, 1983 · N5156X · Substantial damageNTSB LAX83LA447Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Fremont, CAAccording to the student plt, he had found an area of lift after releasing from the tow plane & had soared to 2100 ft. however, while he was returning to the arpt, he realized that he would be too low to reach the rwy. He attempted to land on a highway, but…Sep 17, 1983 · N57835 · Substantial damageNTSB MIA83LA232Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Quincy, FLWhile turning fm downwind to base the eng ran rough and quit. The acft stalled at 50 ft and came to rest in a soybean field. Examination of the wreckage revealed no evidence of fuel in the eng or the rt tk with the fuel selector positioned to the rt tk.Sep 15, 1983 · N4344E · DestroyedNTSB MIA83FU006Accident · 2 fatalFinal reportAmerican Aerolights EAGLE-2 · Miami, FLAfter taking off from a grass field, the 2 place, ultralight vehicle remained in a normal right traffic pattern. As the vehicle was on a base leg for landing, witnesses saw the right wing trailing edge area flutter, then the right wing dropped & the…Sep 15, 1983 · UNREG · DestroyedNTSB ATL83LA371Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Saluda, VAThe acft landed off the rwy and cartwheeled into the tiedown area after the plt lost control during landing. The plt said the wind shifted while he was on final approach. He compensated with power and rudder but does not recall his airspeed. The acft snapped…Sep 15, 1983 · N5070N · Substantial damageNTSB NYC83FA242Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Collier Twnshp, PADuring arrival, the plt contacted apch control & was provided radar vectors for a visual apch. While on the apch, he was instructed to keep his speed up until he was 1 1/2 mi on final. Vectors were provide with turns as necessary until the acft was 6 1/2 to 7…Sep 14, 1983 · N84703 · DestroyedNTSB LAX83FVM10Accident · No injuriesFinal reportRobinson R22 · San Jose, CAThe private plt was certificated for fixed wing, single eng, land acft, but was not rated in helicopters. While on a solo flt, practicing landings, he was on final apch to land when he encountered a decrease in eng power & rotor RPM. Subsequently, the…Sep 13, 1983 · N8398Q · Substantial damageNTSB LAX83LA460Accident · No injuriesLimited investigationFinal reportCessna 150 · Sparks, NVThe stu plt stated he encountered wind shear on short final and applied full pwr but the nose wheel struck a dirt bank at the rwy threshold. The acft bounced back into the air and came down on the rwy at which time the nose gear departed the acft as it slid…Sep 11, 1983 · N11491 · Substantial damageNTSB LAX83LA433Accident · No injuriesLimited investigationFinal reportCessna 182A · S. Lake Tahoe, CAAccording to the flt instructor (CFI), he & the student took off with 21 gal of fuel on board. Aprx 1.3 hrs. Later, the eng lost power as the student turned onto final apch for a landing. The CFI took control of the acft & made a forced landing on a river…Sep 11, 1983 · N4812D · Substantial damageNTSB ATL83LA368Accident · No injuriesLimited investigationFinal reportCessna 310J · Birmingham, ALThe acft landing gear collapsed during landing. An FAA inspector said the gear made grinding noises when extended. During a fly-by the left gear door appeared to be jammed. Reportedly the landing gear transmission assembly failed.Sep 11, 1983 · N3199L · Substantial damageNTSB MKC83FU006Accident · Serious injuriesFinal reportEipper Quicksilver MXL · Ozark, MOThe acft collided with a tree during the approach to land. A witness to the accident, who had landed his ultralight, said the plt circled to land & then aborted to make another approach to land closer to the witnesss. As he made a right descending turn to…Sep 10, 1983 · UNREG · Substantial damageNTSB MKC83FA216Accident · 1 fatalField investigationFinal reportPiper PA-14 · Trenton, MOThe acft had just received extensive maintenance at buffalo, MO, which included internal & external recovering & an STC modification. During arrival at Trenton, MO, the acft was observed on a short final apch. At a position of aprx 200 ft short of the rwy &…Sep 10, 1983 · N372T · Substantial damageNTSB MKC83FA215Accident · Serious injuriesField investigationFinal reportCessna 150G · Perry, IAThe plt was participating in a spot landing contest. A witness near the apch end of the rwy reported that when the acft was on final apch, it suddenly settled below tall trees about 1/8 mi from the rwy. He reported that it then went into a right bank, nose up…Sep 9, 1983 · N2452J · Substantial damageNTSB FTW83LA426Accident · No injuriesLimited investigationFinal reportCessna 210L · Austin, TXThe acft was landed wheels-up in an open muddy field after the engine quit. The plt said that just prior to turning downwind he reduced power and extended the landing gear. Then the RPM was increased and mixture set to full rich at which time the engine quit.…Sep 9, 1983 · N1667X · Substantial damageNTSB MKC83FA214Accident · Serious injuriesField investigationFinal reportBeech C35 · Grain Valley, MOThe plt reported that when he was on final apch to land, the eng quit running & he was unable to glide to the rwy. Reportedly, the acft touched down in a vacant lot about 75 ft short & 15 ft below the level of the end of the rwy. After touching down, it…Sep 8, 1983 · N5843C · Substantial damageNTSB LAX83FU016Accident · 1 fatalFinal reportEipper MX · Visalia, CAThis ultralight plt, according to witnesses, expressed some anxiety about flying on the day of the accident. The instructor reviewed the procedures with her on the ground, but did not fly with her. The acft, prior to takeoff, had less than 2 gallons of fuel.…Sep 7, 1983 · UNREG · Substantial damageNTSB CHI83IA418Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Chicago, ILThe acft experienced a left walking beam failure when the landing gear was extended during approach, the acft log was noted 'during gear extension at 230 KTS tremendous bang occurred which dropped panels at rows 15-7 02 masks at row 18. Three green normal…Sep 7, 1983 · N1984 · Minor damageNTSB CHI83LA414Accident · No injuriesLimited investigationFinal reportCessna 140 · Waynesville, OHThe plt reported that while in the traffic pattern to land, he slipped the acft on downwind, and again on final apch, to lose altitude. Also, he stated that the right control wheel had hit an attache' case on the right seat & the apch was not good, so he…Sep 5, 1983 · N2562N · DestroyedNTSB NYC83LA237Accident · No injuriesLimited investigationFinal reportCessna 150H · Boonville, NYDuring an approach, the plt lowered 40 deg of flaps for a spot landing. As he approached the rwy, he banked left & added power to avoid hitting a tree. However, contact was made & he initiated a go-around. As the acft clipped some trees to the left, the nose…Sep 4, 1983 · N22853 · Substantial damageNTSB LAX83LA421Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Clearlake, CADuring arrival, the plt made an apch to rwy 30 at night in calm wind conditions. He reported that on final apch, he allowed the airspeed to get low & the acft stalled and struck the ground approximately 300 feet short of the rwy. The rwy was equipped with…Sep 4, 1983 · N252EZ · DestroyedNTSB DEN83LA210Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Durango, COAfter releasing from an aerial tow about 2,000 ft AGL, the plt was unable to find lifting thermals. The glider began to descend about 800 fpm so the plt maneuvered to return to the airstrip. The glider collided with several small trees short of the rwy.Sep 4, 1983 · N7590 · Substantial damageNTSB ATL83LA357Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Simons Isl., GADuring arrival, the plt began an apch to rwy 04 on a dark night. The apch to the rwy was over a bay inlet & river confluence. The plt thought that the acft was high when it was on final approach. However it collided with trees, impacted on a road short of the…Sep 4, 1983 · N4992S · Substantial damageNTSB ANC83LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Skwentna, AKThe acft stalled into the ground on final approach landing in gusty turbulent wind conditions. The pilot stated that he was trying to land when a gust of wind flipped the acft over at 500 ft AGL. He said he corrected with left aileron but by the time he could…Sep 4, 1983 · N4097Z · Substantial damageNTSB FTW83LA413Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Fort Smith, ARThe acft had departed laredo, TX, on a flt to ft Smith, AR, with an intermediate stop at brinkley, AR. The fuel tanks were 'topped' at laredo, but no fuel was added at brinkley. During arrival at ft Smith, the plt declared an emergency for 'extremely low…Sep 3, 1983 · N3594G · DestroyedNTSB CHI83LA411Accident · No injuriesLimited investigationFinal reportPiper J-3 · Rockford, ILThe plt stated the engine quit, sputtered and quit again before he landed in a bean feild and nosed over. Plt who is also an A&P mechanic had been using sloshing/sealing compound (randolph tank sealer #802) in the fuel tank. After the accident the compound…Sep 3, 1983 · N99163 · Substantial damageNTSB ATL83LA350Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Odum, GAThe plt stated he ran out of fuel about 1/2 mi from the rwy.Sep 3, 1983 · N8636L · Substantial damageNTSB SEA83LA191Accident · No injuriesLimited investigationFinal reportGulfstream American AA-1 · Eatonville, WAThe acft collided with a tree during a go-around. The pilot was able to continue flt to another arpt and complete a landing. During the attempted landing at the accident arpt the pilot stated she 'did not touch down when I expected'. During the go-around the…Sep 1, 1983 · N6106L · Substantial damageNTSB MIA83IA218Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-30 · Miami, FLThe acft experienced the separation of a flap vane while on final approach to land. 50 inches of the right flap vane separated and caused slight damage to a parked auto on the street below. The acft continued on to an unevently landing. The incident was not…Sep 1, 1983 · YV134 · Minor damageNTSB SEA83FA189Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Everett, WAThe acft collided with trees and the ground in an attempt to return to the arpt after takeoff. The acft crashed one milesouth of the arpt in IMC weather in the early hours of the morning. Witnesses said dense fog existed at the time with zero visibility. The…Aug 31, 1983 · N6874J · DestroyedNTSB CHI83LA399Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Columbia Sta., OHAccording to the non-rated plt, he was on downwind to land when he applied carburetor heat, then the eng RPM began to decrease. He stated that he pushed the throttle forward, but got no response from the eng. He further stated that the acft continued to lose…Aug 30, 1983 · N3540S · DestroyedNTSB ATL83LA356Accident · No injuriesLimited investigationFinal reportCessna 172C · Portsmouth Isl., NCBefore hauling passengers, the plt elected to make a flt to survey the area & to practice a landing on Portsmouth island. He estimated that the wind at Portsmouth was from the north at 15 to 20 KTS. Also, he said that the arpt was oriented toward the…Aug 30, 1983 · N8338X · Substantial damageNTSB SEA83LA188Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Quincy, WAThe acft collided with a car on the rwy during an aborted landing at a private airstrip. The pilot saw the auto as he turned base but believed the driver would cross and clear the rwy. Instead the driver went down the rwy in the directionof landing. When the…Aug 29, 1983 · N48719 · Minor damageNTSB NYC83LA230Accident · No injuriesLimited investigationFinal reportPiper PA-22 · West Bloomfield, NYReportedly, the plt was returning to the departure arpt to land when the eng lost power. Subsequently, the acft was damaged during a forced landing in a corn field. An exam of the eng revealed excessive carbon in the exhaust stack. Also, the primer was found…Aug 29, 1983 · N5185Z · Substantial damageNTSB NYC83LA229Accident · No injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G103 · Julian, PAThe student plt & instructor (CFI) were practicing pattern work & landings. During the 1st 3 patterns, the wind was calm, however, by the time they were on their 4th pattern, the wind increased & became gusty. While the student was flying the pattern, he…Aug 29, 1983 · N906BG · Substantial damageNTSB NYC83FGM05Accident · 1 fatalFinal reportCessna 152 · Butler, PAThe acft crashed on approach to the final destination arpt after completion of a multi-legged x-ctry flt in foggy weather. The flt had 5 enroute stops which entailed 6 takeoffs and climbs during 3.6 hours. According to the FAA the acft contained 5 or 6…Aug 29, 1983 · N4793Q · DestroyedNTSB MKC83FA205Accident · 2 fatalField investigationFinal reportPiper PA-24-151 · Chesterfield, MOThe plt landed a lawrenceburg, TN, on the evening of 8/28/83. Thunderstorms were reported in the area at that time. At lawrenceburg, fuel was available during daylight hours. At 0203 the next morning, the plt called the muscle shoals fss & obtained a wx…Aug 29, 1983 · N7993C · Substantial damageNTSB LAX83LA413Accident · No injuriesLimited investigationFinal reportCatto Acro X · Jackson, CAAfter takeoff the plt made a turn into the downwind leg. At about 500 ft AGL while the plt rocked the winged to friends on the ground, the canopy blew off & became lodged in the right wing's flying wires. The acft began to roll to the right& pitch upwards.…Aug 29, 1983 · N83AX · DestroyedNTSB NYC83FA228Accident · Serious injuriesField investigationFinal reportBeech 58PA · Danbury, CTInbound to Danbury the plt was advised that the arpt was closed, & was given the last wx which was an hour old. The acft was observed to pass over the arpt 300-400 ft AGL & circle to land rwy 8. The acft turned base & final in a tight turn with the gear down.…Aug 28, 1983 · N158JB · Destroyed