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 MIA84FA241Accident · 4 fatalField investigationFinal reportCessna 152 · Valdosta, GAThe two acft collided about a mile east of the arpt on the downwind leg of the traffic pattern. One of the acft, N25853,called Valdosta radio and reported left downwind for rwy 17.Valdosta advised that another acft had just departed rwy 17 2 minutes prior.…Aug 25, 1984 · N25853 · 2 aircraft · DestroyedNTSB LAX84FU032Accident · 1 fatalFinal reportUltralight UFM East Riser · Cloverdale, CAThe Ultralight was observed by witnesses on the downwind leg of the traffic pattern for landing. The acft was flying level at about 300 ft AGL when it started a series of roller-coaster maneuvers which increased into a steep ascent and nose over followed by a…Aug 25, 1984 · UNREG · Substantial damageNTSB CHI84LA360Accident · No injuriesLimited investigationFinal reportBeech B-24-R · Independence, WIThe acft collided with trees near the departure end of the field during an attempted go-around. A passenger reported that the go-around was initiated at about 100 ft AGL, 1/2 way down the fld. The plt said the fld was in a valley, it wasa hot (reported temp…Aug 25, 1984 · N2217L · Substantial damageNTSB ATL84LA270Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108-3 · Reidsville, SCThe accident occurred on a low approach to a sloping airstrip with power lines at the uphill end. A go-around was commenced from a low pass, but insufficient climb performance was available, and a pull-up to clear the obstruction resulted in a stall/mush into…Aug 25, 1984 · N6771M · Substantial damageNTSB NYC84FHJ02Accident · No injuriesFinal reportCessna 305A · East Moriches, NYAt the completion of a banner tow flt the banner was released and a climbing right turn to downwind was initiated. A loss of power was experienced on downwind. Unable to return to the arpt to land, a forced landing was made in a wooded area. Investigators…Aug 24, 1984 · N5291G · Substantial damageNTSB NYC84FA294Accident · 2 fatalField investigationFinal reportCessna 414 · Wallingford, VTThe plt was executing second attempt for a instrument apch, lda rwy 19, following a missed apch on the first attempt. The plt last reported over the iaf, 9 mis north of the arpt. The acft collided with a mountain at a elevation of 1700 ftand 5 mis south of…Aug 24, 1984 · N18SM · DestroyedNTSB SEA84LA212Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Medford, ORThe pilot had been advised by his CFI to avoid using this airstrip during midday due to thermal disturbances. During power-off approach, updrafts were encountered and a right turn out for go-around was initiated; however, power was not added. The aircraft…Aug 23, 1984 · N5153M · Substantial damageNTSB MIA84LA237Accident · No injuriesLimited investigationFinal reportCessna 150 · Ft. Pierce, FLThe student plt on first solo flt misjudged his alt and landed the acft about 30 ft short of the rwy in the grass. This was his instructors assessment of the accident.Aug 23, 1984 · N704XH · Substantial damageNTSB LAX84FU031Accident · 1 fatalFinal reportCalypso N/A · Chula Vista, CAOperator/company personnel had been flying the calypo ultralight for about 2 hrs when the marketing director was approached by a plt who wanted to fly the vehicle. They noted that the plt had been teaching students in an eipper ultralight. Company personnel…Aug 23, 1984 · UNREG · DestroyedNTSB CHI84LU010Accident · Serious injuriesFinal reportPioneer Flightstar · Westfield, INThe ultralight dove into the ground from about 100 ft AGL while in the traffic pattern. The plt at first interview said the engine quit. Later, the plt's father said he was told by the plt that the vehicle just stalled. Witnesses heard the engine running and…Aug 22, 1984 · UNREG · DestroyedNTSB ATL84LA263Accident · 1 fatalLimited investigationFinal reportRotorway Scorpion 133 · West Hamlin, WVAcft was observed proceeding over open field used as air strip in level flt, aprx 130 ft AGL, at 50 KTS. At end of field acft began left turn, nose dropped to steep descent attitude which continued to ground impact. Post-mortem showed triple-bypass surgery…Aug 20, 1984 · N4230S · DestroyedNTSB NYC84LA283Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-E · Charlestown, RIWhile on final approach, the left main gear contacted some brush and becoming entangled in vines followed by the propeller becoming entangled. The propeller stopped and the aircraft swung around 180 degrees coming to rest about 500 ft from the grass runway.Aug 19, 1984 · N2328H · Substantial damageNTSB CHI84LU009Accident · Serious injuriesFinal reportQuicksilver MX · Aurora, ILThe plt was practicing power-off, simulated forced landing patters over farm fields. During a turn at aprx 200 ft AGL, the ultralight decelerated to a very slow speed & subsequently stalled. The plt was unable to recover from the stall before the ultralight…Aug 19, 1984 · UNREG · DestroyedNTSB CHI84FA352Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Put In Bay, OHThe pilot attempted a go-around when he saw an aircraft still on the runway. Witnesses saw the aircraft approach the runway and just before touchdown, make a sharp rt turn to go-around. The aircraft made a sharp right turn, describedas the wings being 90…Aug 19, 1984 · N8635W · DestroyedNTSB SEA84LA202Accident · No injuriesLimited investigationFinal reportCessna 210N II · Elko, NVFuel exhaustion occurred on final approach to destination airport. The nose landing gear contacted the top of the chain link airport perimeter fence breaking a connector and allowing the nose gear to retract. The main gear were not damaged. On landing roll…Aug 18, 1984 · N4674U · Substantial damageNTSB NYC84LA281Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · White Marsh, MDThe acft was descended for aprx 7 miles at low power & slow rate for the landing at White Marsh arpt. The descent started at 2800 ft & continued straight in to rwy 27. At about 200 yds from the rwy & at 200 ft AGL the plt decided he needed power to land…Aug 18, 1984 · N44325 · DestroyedNTSB FTW84LU008Accident · Serious injuriesFinal reportMattison MAC MU-200 · Orange, TXAccording to law enforcement officers, who responded to the scene, the plt of the ultralight vehicle was attempting to land in a field when he encountered a x-wind & initiated a go-around. During the go-around, the vehicle struck a 30 ft tree while in a left…Aug 18, 1984 · UNREG · DestroyedNTSB CHI84LA356Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Palmyra, WIPlt entered landing pattern after maintenance ferry flt, checked lighted wind indicator & evaluated wind as calm. Plt executed tight, close-in base due to electric billboard drag factor & noted strong wind blowing acft away from runway. Acft began to lose…Aug 18, 1984 · N18683 · DestroyedNTSB NYC84LA286Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYCommunications with twr indicate plt intended to touch down as close to the end of the runway as possible. Acft touched down 20 yds short of hard surface in gravel. Rwy NOTAM stated 18 in depression at threshhold edge.Aug 17, 1984 · N739SF · Substantial damageNTSB FTW84LA350Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Minden, LADuring a night instructional flt on landing approach, the instructor pilot reported that the student over corrected for a high approach by closing the throttle. The acft hit the ground before he could establish control of the resulting high rate of sink.Aug 17, 1984 · N3962W · Substantial damageNTSB FTW84FA372Accident · No injuriesField investigationFinal reportCessna 402 · Dfw Airport, TXAccording to the plt, a rwy change accepted late in the apch required a steep turn and rapid descent. At aprx 400 ft AGL both throttles were advanced but neither eng responsed. The acft landed in unimproived terrain short of the rwy collapsing the left main…Aug 17, 1984 · N19DA · Substantial damageNTSB ATL84LA259Accident · No injuriesLimited investigationFinal reportCessna 210L · Conway, SCThe acft crashed into trees and after a loss of power during final apch. Plt reported the acft had 70 gallons of avgas onboard at departure from Conway, SC, at 0900 EDT. The proposed flt from Conway to florence, SC, and back to Conway was a distance of 72 NM.…Aug 17, 1984 · N29276 · Substantial damageNTSB BFO84FU003Accident · Serious injuriesFinal reportUltralight Flight Phantom · South Boston, VAThe plt arrived at the arpt about 1530 for a demo flt & possible purchase of a phantom Ultralight. The FBO had the plt fly a C-152 from the right seat to familiarize the plt to fly with the control stick on the right & the throttle on the left since this is…Aug 14, 1984 · UNREG · DestroyedNTSB NYC84FA269Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Richmond, NHThe plt was flying inbound for the ILS rwy 02 apch via the gardner VOR transition. While on the transition, the acft descended below the 4000 ft MSL min alt to 2600 ft MSL. The plt was alerted by ATC. He responded that his chart read 3000 ft. the acft then…Aug 13, 1984 · N4323G · DestroyedNTSB CHI84LA347Accident · No injuriesLimited investigationFinal reportLindsay Davis Benson B8M · Gross Ile, MIThe student pilot was in the airport traffic pattern when he noticed the eng cylinder head temp exceeding the red line. He attempted to lower the temp by reducing the eng RPM but could not maintain alt. The pilot maneuvered the acft toward the airport and at…Aug 13, 1984 · N4453D · Substantial damageNTSB SEA84FA196Accident · 1 fatalField investigationFinal reportPiper PA-22-160 · Bonners Ferry, IDThe plt took off with 3 adult passengers & a 2 yr old child on board & flew aprx 1.3 hrs. Just prior to the accident, he reported on a left downwind for rwy 20. As the plt continued the apch, the acft was observed over the rwy at aprx 100' AGL, reportedly at…Aug 12, 1984 · N9050D · DestroyedNTSB NYC84FA274Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Sydney, NYDuring a night arrival, the plt was cleared for a vor/circling apch to the sidney muni arpt. The published apch was from the hancock VOR with a northerly heading to the arpt of 354 deg. Subsequently, the acft crashed & burned on wooded terrain about 1 mi…Aug 12, 1984 · N9232P · DestroyedNTSB CHI84LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Manchester, OHThe accident occurred when the pilot was flying low on a fly-by for photographs. Adjusting her seat, the passenger hit the control yoke, the aircraft pitched down and collided with a tree. The pilot recovered control and completed a safe landing at an airport…Aug 12, 1984 · N3573C · Substantial damageNTSB ANC84LA135Accident · No injuriesLimited investigationFinal reportCessna 170B · Kenai, AKThe plt was trying to land on a gravel oil drilling pad. The acft landed short of the pad and collided with a beam. After a bounce and a yaw the acft touched down again and the rt main landing gear failed. The plt said his selection of landing area was poor.Aug 12, 1984 · N4691C · Substantial damageNTSB SEA84FYK01Accident · Serious injuriesFinal reportCessna 172N · Creswell, ORThe acft collided with wires during an attempted go-around. The plt stated that he had made one go-around and on the 2NDLANDING attempt he landed hard in gusty wind & bounced. During the 2nd go-around he collided with wires & crashed.Aug 11, 1984 · N3278E · DestroyedNTSB MKC84LA246Accident · No injuriesLimited investigationFinal reportCessna 305A · Blakesburg, IAThe acft mushed into tall corn off the end of the rwy during an attempted go-around. The plt said he landed long on the 2170 ft turf rwy in calm air and did not think he could stop so a go-around was initiated. He said a seat belt interfered with the…Aug 11, 1984 · N6735Q · Substantial damageNTSB LAX84LA433Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Coulterville, CAThe plt reported that on his apch to land, the sink rate became greater than anticipated & the right main gear hit the top of a fence. Subsequently, the right main gear collapsed & the acft veered off the rwy & hit an embankment.Aug 11, 1984 · N210AV · Substantial damageNTSB LAX84FVM02Accident · Minor injuriesFinal reportGrumman American AA-5B · Monterey, CAThe acft collided with hilly terrain aprx 6 miles east of the arpt during the second attempted ILS rwy 10 apch. The plt stated that communication and navigation problems were experienced during the flt. He also stated he changed fuel tanks every 1/2 hr during…Aug 11, 1984 · N1544R · Substantial damageNTSB FTW84FA343Accident · Serious injuriesField investigationFinal reportCessna 150J · Justin, TXThe acft collided with a power line and nosed over during an attempt to recover from a simulated forced landing. The cfireportedly 'cleared' the engine during the approach but when she took over and added power to climb she claimed the engine did not fully…Aug 10, 1984 · N60660 · DestroyedNTSB ATL84LA254Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nashville, TNThe pilot reportedly set up a high rate of descent on final approach so that he could land the aircraft near the approach end of the rwy to avoid excessive braking on the wet rwy. The pilot descended the aircraft below the glide slope provided by the VASI and…Aug 10, 1984 · N66AU · Substantial damageNTSB ATL84FA247Accident · Serious injuriesField investigationFinal reportCessna 172H · Ellijay, GAThe student pilot and passenger were on unauthorized flight in the local area at 0145 when the accident occured. According to the student pilot he had returned from a local flt, picked up a pax, departed again and had flown for 30 to 45 mins before returning…Aug 8, 1984 · N3272L · DestroyedNTSB MIA84LA220Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Pelham, GAThe acft landed short of the rwy during a forced landing after the engine quit on final approach. The plt reported that he had experienced trouble keeping the engine running at low power settings.Aug 7, 1984 · N3310J · DestroyedNTSB ATL84LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, NCThe instructor pilot retarted the throttle to simulate an engine failure on daownwind at 800 ft AGL after his student had completed a touch and go landing. The CFI then turned to land in the direction opposite the last takeoff, but was unable to achieve…Aug 6, 1984 · N9549T · Substantial damageNTSB NYC84FNC08Accident · Serious injuriesFinal reportZappia Gabriel J QUICKIE-2 · Augusta, METhe pilot stated that he noticed he was unexpectedly low on fuel. As he approached the Augusta, Maine airport. He radioed the Augusta fss and transmitted the fact. Shortly thereafter the engine quit and the pilot executed an emergency landing in a wooded…Aug 4, 1984 · N56U · DestroyedNTSB FTW84LA339Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW12 · Georgetown, TXOn final apch the plt encountered a 20 to 40 mph gust & subsequent 600 fpm downdrafts. Unable to reach the clear zone atthe apch end of the rwy. The plt attempted to stall into a tree but caught the left wing and slid down the side of the tree impacting the…Aug 4, 1984 · N6135 · DestroyedNTSB CHI84LA333Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Bloomington, ILPlt departed on local flt shortly before the twr closed. Plt recalled final twr transmission included altimeter setting which was a significant change on his instrument. On return to the arpt, 35 mins after departure, fog and haze had reduced visibility to…Aug 4, 1984 · N5881Z · Substantial damageNTSB NYC84LA261Accident · No injuriesLimited investigationFinal reportTeal TSC 1A · Moultonboro, NHThe acft struck the tail of an acft as it was beginning to proceed in a go-around. The plt said he was unaware of the collision with the parked acft until the subsequent landing. The collision was the result of the acft in flt drifting downwind off the rwy…Aug 3, 1984 · N2002T · Substantial damageNTSB BFO84FU002Accident · 1 fatalFinal reportAmerican Aerolights Eagle XL · Smithfield, VAThe plt of the ultralight vehicle, a student, was in radio contact with his instructor thru use of a portable hand-held UHF transceiver. About 10 min after takeoff, the instructor asked him to return to the airstrip for a practice power off landing. During…Jul 31, 1984 · UNREG · Substantial damageNTSB CHI84LA318Accident · No injuriesLimited investigationFinal reportCessna 172 · Urbana, OHThe pilot stated after the accident that he arrived at his flight planned destination 15 minutes early so he continued the flight an additional hour. The plt experienced an eng failure while on final apch to the rwy at the revised destination arpt. The plt…Jul 29, 1984 · N3891S · Substantial damageNTSB LAX84LA419Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Laveen, AZDuring flt on the downwind leg of the traffic pattern the plt inadvertantly knocked the ignition switch to the 'off' position. Since the prop stopped and the acft was not equipped with a starter, the acft engine could not be restarted. The acft landed 20 ft…Jul 28, 1984 · N45743 · Substantial damageNTSB CHI84LA316Accident · No injuriesLimited investigationFinal reportCessna 150H · Menomonie, WIThe plt was disoriented during a x-country and circled the wrong area looking for an arpt until low fuel demanded a landing. During the approach the engine quit and the acft nosed over in a bean field during landing.Jul 28, 1984 · N6707S · Substantial damageNTSB CHI84FU007Accident · 1 fatalFinal reportCollins Fisher FP-202 · Ludington, MIThe ultra-light was constructed by the pilot and two other persons. This group had no previous experience in aircraft construction. This was the third known flight for this aircraft. It had been flown two days prior to the accident and an adjustment to the…Jul 28, 1984 · UNREG · DestroyedNTSB SEA84LA184Accident · Serious injuriesLimited investigationFinal reportHeveron Sandpiper 83B · Mcminnville, ORA student pilot lost control of an ultralight vehicle when he encountered a local gusty wind condition at 200' AGL and collided with the ground in an uncontrolled descent. The ultralight was built for registration as an experimental aircraft, but…Jul 27, 1984 · N4751N · Substantial damageNTSB ATL84LA236Accident · No injuriesLimited investigationFinal reportCessna T210L · Toccoa, GAPlt made a forced landing in a grove of trees 1 1/2 miles north of the arpt after reporting an engine failure due to fuel exhaustion. Plt stated adequate fuel was on board to complete the flt however, an en route course deviation was made to avoid various…Jul 27, 1984 · N30237 · Substantial damageNTSB NYC84IA271Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Buffalo, NYDuring the departure from newark, NJ, the aircrew noted a vibration which ceased after the gear was retracted. The crew suspected that a tire was out-of-round or a gear door was vibrating & continued the flt. During the apch to Buffalo, NY, the vibration…Jul 26, 1984 · N518PE · Minor damage