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 CHI83AA326Accident · 6 fatalFinal reportAero Commander 685 · Cleveland, OHWhile turning from downwind to base leg, the acft was observed descending rapidly in a steep bank. Witnesses reported smoke was trailing from the acft. The acft crashed in an industrial area. An exam of the right eng revealed that the exhaust-to-turbo…Jul 20, 1983 · N3711T · DestroyedNTSB MKC83LA160Accident · Minor injuriesLimited investigationFinal reportRockwell 112A · Kansas City, MOThe pilot said the right cabin door came open after takeoff and he reentered the traffic pattern to land. He was cleared to land on rwy 21 but the aircraft overshot final approach, stalled and landed in the grass. It then collided with a fence and crossed a…Jul 19, 1983 · N1459J · DestroyedNTSB LAX83FA346Accident · 1 fatalField investigationFinal reportVarieze 1 · Mojave, CAThe plt purchased the acft a week before the accident. The day before the accident the plt stated to rutan aircraft factory personnel that he had never flown this type of acft in the past & was afraid of the acft. On the day of the accident witnesses observed…Jul 19, 1983 · N69EZ · DestroyedNTSB FTW83LA339Accident · Minor injuriesLimited investigationFinal reportHackett/Mckown KR-2 · Albuquerque, NMThe plt/owner stated that the home built acft had poor forward visibility, was not equipped with flaps & required a high apch speed. Also, he said it tended to float after flaring to land & had poor brakes. Additionally, the arpt elevation was 5270 ft & the…Jul 19, 1983 · N3924N · Substantial damageNTSB ATL83LA283Accident · No injuriesLimited investigationFinal reportCessna 310 · Wheeling, WVDuring the apch, the plt was unable to get a safe down indication for the right main gear. He changed the light bulb & still did not get a safe indication. A tower flyby was made, but the tower operator was unable to confirm if the right gear was locked. To…Jul 19, 1983 · N3066L · Substantial damageNTSB FTW83LA338Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Garland, ARThe plt-in-comand (PIC) & the designated flt examiner (fe) were on a flt to give the PIC a commercial plt flt exam. During a simulated forced landing apch, the PIC spiraled the acft down to the proposed landing spot. The proper check list procedures were…Jul 18, 1983 · N4549Q · DestroyedNTSB CHI83FA319Accident · 1 fatalField investigationFinal reportBellanca 17-30 · Hibbing, MNPrior to departure, the plt obtained a wx briefing & was advised to check back before departing to see if anything had developed. Reportedly, he took off at 0815 CDT, and at 0831 CDT, he radioed the Hibbing fss for wx info. The fss specialist advised that the…Jul 18, 1983 · N4831V · DestroyedNTSB DEN83LA181Accident · No injuriesLimited investigationFinal reportCessna 182 · Forsyth, MTThe flt originated at cambridge, id with a planned refueling stop at billings, MT. The plt stated the acft was 'topped off' at cambridge before takeoff. En route, southerly winds were encountered which drifted the acft north, so a refueling stop was made at…Jul 17, 1983 · N5479B · Substantial damageNTSB SEA83LA150Accident · No injuriesLimited investigationFinal reportGulfstream American AA-1A · Sekiu, WAThe acft collided with a fence during an attempted go-around after a loss of directional control during the approach. The pilot stated that a crosswind carried the acft to the rt of the runway which necessitated the go-around. He further stated his airspeed…Jul 16, 1983 · N9357L · Substantial damageNTSB ATL83FA277Accident · No injuriesField investigationFinal reportAero Commander 680 · Jacksonville, ALBefore takeoff, the acft had aprx 40 gal of fuel in the main tanks & 10 gal was added to each of the auxiliary tanks. The plt took off in hazy conditions for a short flt of apprx 10 min. While on downwind for a landing, he switched from the auxiliary to the…Jul 15, 1983 · N6256D · Substantial damageNTSB FTW83LA337Accident · No injuriesLimited investigationFinal reportBeech C23 · Longview, TXThe acft crashed during a forced landing after the engine quit on the downwwind leg of the traffic pattern. The flt had taken off shortly before with one tank almost full and one almost empty. The fuel selector valve was found in the 'off' position after the…Jul 13, 1983 · N60104 · Substantial damageNTSB CHI83LA315Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-36 · Ionia, MIThe glider struck the ground on the nose during the appraoac. The plt stated that nose pitch oscillations were due to his overcontrolling the glider because of his lack of experience in the glider's pitch sensitivity.Jul 13, 1983 · N36193 · Substantial damageNTSB ATL83FA271Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Remington, VAAbout 15 min after takeoff, the eng lost power while the acft was on the downwind leg for a landing on a private strip. Subsequently, the acft hit the tops of two trees, crashed & came to rest aprx 100 yards south of the rwy. An exam of the wreckage did not…Jul 13, 1983 · N27111 · DestroyedNTSB LAX83FUA05Accident · No injuriesFinal reportCessna 150 · Long Beach, CAWhile turning downwind in a closed pattern the eng lost power. The acft crash landed in a risidential street & struck power lines & poles. A portion of the sponge material attached to the carburetor inlet screen had become detached & lodged in the throat of…Jul 12, 1983 · N6554S · Substantial damageNTSB ATL83LA274Accident · No injuriesLimited investigationFinal reportCessna 150M · Muscle Shoals, ALThe acft made a hard landing and nosed over during an attempted go-around. The acft according to the pilot was operatingat nearly max gross weight and the density alt was 2300 ft. he tried a go-around with full flaps extended. A turn was made to avoid…Jul 12, 1983 · N66185 · Substantial damageNTSB LAX83FU010Accident · 1 fatalFinal reportMitchell A-10 · Porterville, CAAfter takeoff, the plt of the ultralight vehicle climbed to an altitude of 700 ft AGL in the pattern & turned downwind. According to the plt's partner, the ultralight began a dutch roll type of maneuver, and after several oscillations, the vehicle stalled &…Jul 11, 1983 · UNREG · DestroyedNTSB NYC83FNE04Accident · 1 fatalFinal reportBede BD-5B · Westfield, MAThe acft crashed short of the rwy during an attempted landing. There were some confusing and garbled transmissions and some mistaken instructions from the tower during the problem experienced by the accident plt. This plt did not make it clear that he had an…Jul 10, 1983 · N83SK · Substantial damageNTSB CHI83LA304Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Middle Bass Isl, OHThe acft collided with wires during a go-around attempt. The pilot reported that as he approached at about 10-15 ft AGL some people walked onto the rwy. He added full power and while gaining control of the acft it collided with the wires and crashed into the…Jul 10, 1983 · N33544 · Substantial damageNTSB ATL83LA266Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Warrenton, VAThe pilot collided with a tree while landing in windy conditions. The pilot had flown one dual flt on this day and then went up for a 39 minute solo flt. Upon her return she was low on downwind so she made a close in base but drifted to theright on final in…Jul 9, 1983 · N2743H · Substantial damageNTSB MIA83FA178Accident · Serious injuriesField investigationFinal reportGilbert L. Houston Moni · Vero Beach, FLThe plt made a local flt from the indian river aerodrome to the new hibiscus arpt. According to witnesses at new hibiscus, the acft was in a nose hi attitude when they saw it turn onto base & final apch. After turning final, the acft entered a spin, turning…Jul 8, 1983 · N64GM · DestroyedNTSB DEN83LA160Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Salt Lake City, UTThe acft landed short of the rwy after a power loss at about 100 ft AGL on final approach. The weather was VMC with the temperature at 80 degrees f and the dewpoint 42 degrees f. the pilot had started a let down at 11,500 ft to descend 5700FT for landing.…Jul 6, 1983 · N8935T · Substantial damageNTSB ATL83LA256Accident · No injuriesLimited investigationFinal reportPiper PA-25-235B · Weaver, ALAfter making 5 swath runs which expended about 1/2 of his load, the plt stated his fuel gage read 5 gals. He diverted to mcminn arpt to refuel. On final the eng quit & the acft touched down in the muddy overrun. The wheels sank in the mudshearing off the main…Jul 6, 1983 · N7649Z · Substantial damageNTSB NYC83LA166Accident · Minor injuriesLimited investigationFinal reportRotec/Botsford Rally 3 · Kirkville, NYThe 2 place ultralight acft was on final apch to land when the propeller began to freewheel on the propeller shaft. The eng continued to operate & respond to throttle inputs, but the propeller did not produce thrust. The ultralight began to lose altitude…Jul 4, 1983 · N104RE · Substantial damageNTSB LAX83FUG16Accident · No injuriesFinal reportEiriavion PIK 20E · Hemet, CAThe acft made a hard landing off the runway surface after the engine lost power during a go-around. This was a motor glider and the pilot said he planned this missed approach go-around maneuver prior to his approach. At about 400 ft AGL he applied full…Jul 4, 1983 · N83FU · Substantial damageNTSB ATL83FMG02Accident · Serious injuriesFinal reportCessna 150 · Monroe, NCThe acft crashed into trees during a night landing attempt. The student pilot was taking a friend to a grass unlighted 2200 ft airstrip for a night landing. A friend in an automobile was shining her car lights on the rwy. The pilot made anunsuccessful attempt…Jul 4, 1983 · N6728G · DestroyedNTSB LAX83LA318Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Clearlake, CAThe acft crashed in a flat area covered with 6 ft bushes after the engine quit during a go-around. The engine had quit on the downwind and started again after the plt switched tanks. The acft was high on final and after go-around was initiated the engine quit…Jul 2, 1983 · N7593W · DestroyedNTSB ATL83FA249Accident · 2 fatalField investigationFinal reportHamilton T-28R-2 · Martinez, GAThe acft was 1 of 2 that made a low pass over rwy 24. After the pass, the plt made a right turn, establishing the acft in a right traffic pattern for rwy 24. According to 1 witness, while the acft was turning on a right base, intermittent bursts of dark smoke…Jul 2, 1983 · N182U · DestroyedNTSB FTW83FA310Accident · 2 fatalField investigationFinal reportBeech A36 · Enid, OKPrior to takeoff the plt was advised the winds were from 180 deg at 20 KTS gusting to 27 KTS. During takeoff from rwy 17THE plt advised the tower that he was 'bringing it around to land on 30.' When asked if he was experiencing any difficulties the plt…Jul 1, 1983 · N23684 · DestroyedNTSB NYC83LA159Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Nashua, NHThe student plt was practicing full flap landings during a solo flt. While on a final approach to land, she observed another acft taxiing on the end of the rwy. So she elected to go around. At that time, the acft was about 25 to 30 ft AGL. Reportedly, she…Jun 30, 1983 · N11394 · Substantial damageNTSB FTW83LA309Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Elk City, OKThe acft landed short of the rwy during a night landing following a x-country. The plt stated that he was on the approach to land and attempted to add power. The engine sputtered without an increase in power. The acft touched down 5 ft short of the rwy…Jun 30, 1983 · N93624 · Substantial damageNTSB LAX83FA310Accident · No injuriesField investigationFinal reportDouglas DC-4-C55B · Kahului, HIDuring arrival, a descent was begun from 8000 to 7000 ft MSL at 0151 HST. At 0155 HST, the aircrew was cleared for a visual apch from 7000 ft MSL & a rapid descent was started with 20 deg of flaps & aprx 25 inches map (manifold pressure). The acft was…Jun 29, 1983 · N300JT · Substantial damageNTSB SEA83FU005Accident · 1 fatalFinal reportPterodactyl Ascender II · Sumner, WAReportedly, a father & his 14 yr old son had been receiving ground & taxi instruction, and had received 'crow-hop' practice in the previous few weeks. On 6/27/83, the vehicle became airborne with the son on board. He flew it in a pattern around the open field…Jun 28, 1983 · UNREG · DestroyedNTSB MIA83FA168Accident · Serious injuriesField investigationFinal reportBeech V35A · Lehigh Acres, FLAccording to the pilot he started to make a go around after he realized that he would not be able to stop the aircraft on the wet runway. He failed to gain sufficient altitude to clear the trees just beyond the airport boundary. He said he landed at the…Jun 28, 1983 · N485B · DestroyedNTSB FTW83FA299Accident · 2 fatalField investigationFinal reportAero Commander 680-F · Norman, OKThe acft crashed after starting a go-around or aborted landing at normal ok. The acft was on a x-country from dallas to wichita. There was no radio communication with the acft after it was cleared to land. The approach looked ok but on short final the acft…Jun 28, 1983 · N6139X · DestroyedNTSB NYC83LA156Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Shelter Island, NYThe acft crashed off the departure end of the rwy in a swamp during an attempted go-around. The pilot said the approach was normal but that the acft floated more than normal. A go-around was initiated. The pilot could not remember if the acft touched down but…Jun 27, 1983 · N5615V · Substantial damageNTSB ANC83LA105Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Skwentna, AKThe pilot stated that he approached the river on final at 60 mph in a 5 degree bank to follow the curve of the water. When he dropped below trees at about 50 ft AGL the left wing stalled. He added full power and lowered the nose but the left wing hit the…Jun 27, 1983 · N87822 · Substantial damageNTSB NYC83FA157Accident · Minor injuriesField investigationFinal reportCessna 150L · Hackensack, NJAccording to the student's flt instructor (CFI), he (the CFI) had informed ground control that the student was going to be on his 1st solo flt & was going to fly once around the pattern. Reportedly, this radio call was made before the CFI deplaned after dual…Jun 26, 1983 · N10049 · DestroyedNTSB NYC83LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Millbrook, NYThe plt reported that on final apch, the acft began an unexpected descent below the intended glide path. Reportedly, full power was applied to reduce the dwscent, but the acft touched down aprx 20 ft short of the rwy on an upgrade. The acft bounced in the…Jun 24, 1983 · N6438P · Substantial damageNTSB CHI83FA279Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar 601A · Celina, OHWhen the plt arrived at the destination arpt, there was construction on the rwy, about 2500 ft from the apch end. He contacted UNICOM & was advised that the rwy was closed, but was told he could land on the grass beside the rwy. The plt responded that the…Jun 24, 1983 · N727NM · DestroyedNTSB LAX83LA299Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Tracy, CAThe acft made a hard landing while on an instructional flt. On the seventh approach for landing the nose gear green light did not come on. The CFI continued the approach while tapping on the bulb. When he decided to go around the acft had descended so low…Jun 23, 1983 · N7449J · Substantial damageNTSB ATL83LA239Accident · No injuriesLimited investigationFinal reportCessna 150M · Ashland, VAThe acft bounced, went off the runway and nosed over during landing. The student pilot was on a supervised solo flight and was practicing touch and go landings. During this landing he made a hard landing and bounced back into the air. The student attempted to…Jun 23, 1983 · N63143 · Substantial damageNTSB ATL83FA237Accident · 2 fatalField investigationFinal reportLockheed L-18 · Millhaven, GAThe acft collided with trees during an attempted off arpt landing at night for marijuana unloading. The acft was being followed by a u.s customs helicopter, the occupants of this helicopter said the acft had made one missed approach and during the go-around…Jun 23, 1983 · N333FB · DestroyedNTSB NYC83LNC07Accident · Minor injuriesFinal reportBölkow B-1 · Groton, VTThe plt was on a x-country flt of aprx 100 miles. She reported that on the last leg of the flt, a lack of 'lift' was encountered & an off arpt landing was initiated. While on final apch to land in a field, the glider struck a telephone wire aprx 30 ft AGL.…Jun 22, 1983 · N911CW · Substantial damageNTSB LAX83FA295Accident · Serious injuriesField investigationFinal reportCessna 172G · Huntington Bch, CAThe plt-in-command (PIC) & student plt were on an aerial photography flt when the PIC noticed a loss of eng oil pressure. They saw meadowlark arpt & began an emergency apch. The PIC stated that she relinquished her PIC duties to the student because she…Jun 22, 1983 · N4655L · DestroyedNTSB CHI83LA276Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Saint Cloud, MNShortly after takeoff, the plt's door came open. He tried to close it, but was unable, so he turned back toward the arpt to land. While making a turn before landing, the eng lost power. Shortly after that, the acft started falling to the right & crashed. An…Jun 22, 1983 · N6718M · Substantial damageNTSB MIA83FU004Accident · 1 fatalFinal reportEipper Quicksilver MX · Williston, FLThe plt of the ultralight vehicle took off from an open field near his residence. Witnesses near the crash site stated that they observed the ultralight approach an open field for a landing. As the plt was in a left descending turn to the field, the…Jun 21, 1983 · UNREG · DestroyedNTSB CHI83LA274Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wadsworth, OHThe CFI said the student pilot tried to correct for a gust of wind. After the acft turned 30 0R 40 degrees the CFI took control. During the go-around the right wing contacted the ground and the acft cartwheeled.Jun 21, 1983 · N714NN · Substantial damageNTSB FTW83LA289Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Pineville, LAPrior to landing, the plt moved the gear switch to the extend position & noted that the gear indicated down. However, the left main gear did not extend. While landing with the left gear retracted, the acft settled on the left wing & prop. The acft spun 180…Jun 20, 1983 · N7712R · Substantial damageNTSB NYC83FU006Accident · Serious injuriesFinal reportEastern Ultralight Snoop · Norton, MAThe non-rated plt had purchased the ultralight vehicle about 1 month prior to the accident. He had completed aprx 8 hrs of taxi & low flts along a grass rwy. Earlier on the day of the accident, he had made 2 flts & reportedly had accumulated 1 hr of flt time…Jun 19, 1983 · UNREG · Substantial damageNTSB MIA83FU003Accident · Serious injuriesFinal reportEipper Quicksilver · Lake Worth, FLThe ultralight collided with a tree while on final approach to land in an open area. This was the pilot's first flt in an ultralight acft. He said that the accident happened when he made an improper weight shift in an effort to avoid a collision with the…Jun 19, 1983 · UNREG · Destroyed