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 ATL84FU004Accident · 1 fatalFinal reportUltraflight Lazair II · Blichton, GAThe ultralight was low and flat during an approach to land. The acft was aligned with a tree, and according to witnesses, there was no evasive maneuver to avoid the obstruction. The vehicle collided with the tree about 40 ft alg and fell to the ground. No…May 26, 1984 · UNREG · Substantial damageNTSB MIA84LA171Accident · No injuriesLimited investigationFinal reportCessna 182 · San Juan, PRWhile the plt was in the traffic pattern (on base) to land at isla grande arpt, the eng lost power. Subsequently, the acft was ditched & sank in about 40 ft of water. The acft was not recovered, so the eng could not be examined.May 25, 1984 · N3838D · DestroyedNTSB DEN84IA157Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Albuquerque, NMWhen gear was lowered for landing rt main gear would not extend although persons on the ground stated the gear doors appeared open. Remedial action by the flt crew did not rectify the situation and a gear up landing was performed. When acft was raised from…May 24, 1984 · N237AM · Minor damageNTSB DEN84FA159Accident · Serious injuriesField investigationFinal reportGrumman American AA-1C · Rapid City, SDThe acft collided with rolling terrain while on a dual training flt. The CFI stated that the student plt was in the process of doing a simulated engine out forced landing when he raised the nose too high. The CFI and student were discussing the terrain when…May 23, 1984 · N9803U · Substantial damageNTSB SEA84LA114Accident · No injuriesLimited investigationFinal reportMorrisey 2150 · Enumclaw, WAThe plt was on a local test flt to check the flt controls that had just been adjusted. Before taking off, he visually inspected the fuel tanks, but could not see fuel since anything less than 1/2 tank was not visible. He said the fuel gages indicated both…May 21, 1984 · N5601B · Substantial damageNTSB LAX84LA305Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Waipahu,Oahu, HIThe CFI gave the student a simulated forced landing and the student spiraled down to 400 ft AGL. When the CFI said 'i'vegot the airplane' the acft nose came up and the acft started to settle. The CFI stated he applied power but the acft continued to settle,…May 20, 1984 · N4166Y · Substantial damageNTSB LAX84LA302Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5B · Ruth, CAWhile attempting to land on rwy 31, the plt elected to go-around. He made a low pass down the rwy, pulled up at the end of the rwy for a downwind entry & began to mush. The acft hit a tall tree & impacted the ground.May 20, 1984 · N74848 · Substantial damageNTSB LAX84FA304Accident · 1 fatalField investigationFinal reportBrubaker Q-2 · Corona, CAThe plt of a quickie Q-2 had returned to the arpt & made 2 low passes, then began a normal apch to rwy 25. When the Q-2 was on a low final, the plt of a Mooney acft turned onto the rwy & began taking off. At about that time, a ground witness heard the…May 20, 1984 · N82QQ · DestroyedNTSB CHI84LA200Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Millstadt, ILThe acft was stalled during the landing approach over trees to an 1800 ft strip. After clearing the trees the plt reduced the power to idle while aprx 30 ft AGL. The acft stalled, contacted the soft plowed soil and nosed over about 150 ft short of the rwy.May 20, 1984 · N8973L · Substantial damageNTSB ATL84LA181Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Jessup, GAThe acft landed off the rwy during a forced landing following a power loss. Wx conditions were conducive to carburetor icing.May 20, 1984 · N22815 · Substantial damageNTSB ATL84LA179Accident · No injuriesLimited investigationFinal reportCondor III · Kennesaw, GAThe two place ultralight actt crashed 30FT short of the rwy due to fuel exhaustion. The acft had been flying into a headwind of 13 knots at an indicated airspeed of 40 knots. The acft impacted in some underbrush.May 20, 1984 · N4443M · Substantial damageNTSB ATL84LA177Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tallassee, ALThe plt stated he departed fulton county arpt with aprx 12 gals of fuel on board. About 20 mins later, the left fuel tank ran dry & the plt selected the right tank & continued the flt with the intention of refueling at either tuskegee ortallassee. Upon…May 20, 1984 · N9907L · Substantial damageNTSB CHI84LA202Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Ortonville, MIThe acft landed hard short of the rwy, bounced, & both landing gear collapsed.May 19, 1984 · N455C · Substantial damageNTSB DEN84FTE01Accident · 1 fatalFinal reportHarper/Cricri MK-12 · Longmont, COThe homebuilt acft was on downwind leg of the traffic pattern, after initial takeoff, when it went into a dive & collided with the ground. A witness said he heard a power reduction before the dive & power added again as it started down. The plt's son said his…May 18, 1984 · N42JH · DestroyedNTSB CHI84LA198Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Sardinia, OHThe acft collided with trees during the landing approach. Witnesses said the wind was gusty but no gusts were officiallyreported. No malfunctions of equipment were reported. Due to a head injury the student plt has no recall of the accident.May 18, 1984 · N64676 · DestroyedNTSB LAX84LA291Accident · No injuriesLimited investigationFinal reportTaylorcraft F21 · Payson, AZThe acft was landed 200 ft short of the rwy in bushes after the engine hesitated during the plts application of throttle in an attempt to reach the rwy. An FAA inspector found the magneto timing set to 23 plus degrees rather than the prescribed 20 degrees.May 13, 1984 · N2005U · Substantial damageNTSB FTW84LA232Accident · No injuriesLimited investigationFinal reportCessna 170 · Victoria, TXThe pilot stated that while on a long final approach power was reduced for descent. Shortly thereafter the throttle was applied but the engine failed to respond. The aircraft landed 100 yards short of rwy 17. The pilot stated after the accident that he…May 13, 1984 · N2539V · Substantial damageNTSB NYC84LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Montrose, PAPilot attempted to land on a 2200 foot grass runway. The plt overshot the runway and attempted to go-around. The aircraft collided with trees at the end of the runway.May 12, 1984 · N33339 · Substantial damageNTSB LAX84LA289Accident · No injuriesLimited investigationFinal reportCessna 172 · Montague, CAAn improper ldg flare by the dual student plt caused the acft to balloon to 15 to 20 ft AGL. The CFI called for power, but the student delayed adding power & raised the nose. At the sound of the stall warning horn, a go-around was called for by the CFI &…May 12, 1984 · N5654A · Substantial damageNTSB FTW84LA231Accident · Minor injuriesLimited investigationFinal reportStarduster SA-300 · El Paso, TXWhile in the arpt traffic pattern for landing, the plt experienced an engine failure and landed short of the rwy. The acft collided with a sand dune. The plt stated that he had experienced a loss of fuel pressure on previous flts but had not corrected the…May 12, 1984 · N3168 · Substantial damageNTSB CHI84LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcarthur, OHThe plt stated that during final approach at about 5 ft above the ground the acft was struck by a gust of wind that lifted the acft about 20 to 30 ft up and to the left of the runway. He stated tha a downdraft placed the acft in a position where 'maximum…May 12, 1984 · N94702 · Substantial damageNTSB CHI84LA185Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Minneapolis, MNThe plt was in the process of buying the Cessna 172. He took off on a local flt and after doing some airwork, he returned to the arpt. On final apch to rwy 27L, the acft was observed at a low alt. It continued descending and collided with microwave landing…May 12, 1984 · N758CC · DestroyedNTSB LAX84LA286Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Hayward, CAAccording to a plt/operator statement, the private plt (PIC) was on an instruction flt. The other occupant, was a person whose commercial plt certificate had been suspendended. The PIC reported that the helicopter had just received an annual inspection & had…May 11, 1984 · N589H · DestroyedNTSB NYC84FA163Accident · 2 fatalField investigationFinal reportCessna 310K · New Cumberland, PAThe plt departed VFR without a formal wx briefing or filing a flt plan. The wx at dest was VFR when the plt departed. The forecast indicated that ceilings would lower. The wx did, in fact, deteriorate while the flt was enroute and the plt obtained an IFR…May 8, 1984 · N6907L · DestroyedNTSB MIA84FA163Accident · Serious injuriesField investigationFinal reportBeech 65-80 · Opa Locka, FLThe plt stated that he did not check the acft fuel visually prior to departure. About 10 minutes after takeoff, while using auxiliary fuel tanks, the right eng lost power. The plt selected crossfeed & the eng restarted. He then turned off the right fuel…May 8, 1984 · N741H · Substantial damageNTSB NYC84LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · No.Stonington, CTWhile on a x-country flt, the student plt became lost & his fuel supply became low. He had difficulty contacting a ground station, but finally did so after receiving assistance from other plts. He was requested to squawk 7700 on his transponder, but the…May 7, 1984 · N25369 · Substantial damageNTSB MIA84FA162Accident · No injuriesField investigationFinal reportPiper PA-31-325 · Eglin Afb, FLAfter arriving at Eglin Afb, the plt determined he would need more fuel to complete the next leg of the flt. However, there was no avgas refueling available at Eglin. The plt disembarked the pax & flew IFR to ft walton beach to refuel. A missed approach was…May 7, 1984 · N3586W · Substantial damageNTSB ATL84LA167Accident · No injuriesLimited investigationFinal reportCessna 188B · Paxville, SCThe acft nosed over short of the rwy after the engine failed to respond to the plts attempt to add power to reach the rwy. It was found after the accident that the carb heat control door brackets were worn which allowed the butterfly valve door to separate…May 7, 1984 · N21672 · Substantial damageNTSB SEA84FA102Accident · 2 fatalField investigationFinal reportCessna 140 · Lovelock, NVThe plt had originally requested a wx briefing at 0444 for a flt from cheyenne,WY to loverlock,NV. Prior to departing cheyenne at 0630, the FBO told the plt that the Lovelock arpt was flooded. The plt replied he would land at a strip in town. Fuel receipts…May 5, 1984 · N1978N · DestroyedNTSB MIA84FA161Accident · Serious injuriesField investigationFinal reportBeech 35 · Sanford, FLThe eng lost power when the acft was on final apch to land. The plt stated that he then switched fuel tanks, activated the electric fuel boost pump & worked the related wobble pump as fast as he could, but was unable to restore eng power. Subsequently, the…May 5, 1984 · N2830V · DestroyedNTSB LAX84LA282Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Visalia, CAWhen the plt arrived at his destination, he was unable to fully extend the gear. He diverted to Visalia, CA. After reducing the fuel load, he made an intentional, power-off, wheels-up landing. An exam revealed that nose gear bellcrank assy had caught on the…May 5, 1984 · N5597P · Substantial damageNTSB MKC84LA133Accident · No injuriesLimited investigationFinal reportBeech V35B · Lee'S Summit, MOThe plt reported that the acft landed hard, bounced and landed hard again breaking the nose gear off the acft. The pilot stated he encountered a strong downdraft on approach.May 4, 1984 · N3138W · Substantial damageNTSB FTW84LA221Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Putnam, OKThe acft bounced during landing and the plt attempted to abort the landing. A truck was parked near the end of the field. The acft collided with the truck which it failed to clear in an attempt to fly over it. There were no reported malfunctions of equipment.May 4, 1984 · N5194X · Substantial damageNTSB DEN84FU004Accident · Serious injuriesFinal reportEipper Quicksilver MX · Berthoud, COThe ultralights were flying in loose formation on a short x-country. During the flt, the wind shifted to the east and created some turbulence and downdrafts near the end of the journey on final approach. The lead vehicle landed without knowledge that his…May 4, 1984 · UNREG · DestroyedNTSB LAX84FA277Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Ukiah, CADuring arrival, the plt was cleared for a loc/dme rwy 15 apch to the Ukiah arpt. At 1307 PDT, he began the apch at the tucci intersection, 15.5 mi north of the rwy. At 1311:04 the last radar contact showed that the acft was about 5 mi north of the arpt. At…May 1, 1984 · N63813 · DestroyedNTSB LAX84LA279Accident · No injuriesLimited investigationFinal reportCessna 150J · Fort Ord, CABefore taking off, the plt noted that the left fuel gage indicated a little less than 1/2 full & the right gage showed aprx 1/2 full. He stated that a 'visual inspection showed about the same, as much as I could see.' The flt was uneventful until the eng…Apr 29, 1984 · N5559G · Substantial damageNTSB NYC84LA154Accident · Serious injuriesLimited investigationFinal reportBryan RS-15 · Colts Neck, NJDuring arrival to land, the plt circled over the arpt while gliders were being removed from the active rwy. He then made a tight downwind leg & started a 180 deg apch from 200 ft at 55 KTS. He stated that the 'roll rate (to the left) was rapid and by the time…Apr 28, 1984 · N24876 · DestroyedNTSB LAX84LA270Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Fair Oaks, CABefore departing on a x-country flt, the plt was warned to refuel midway on his route. He recalculated his fuel while en route & thought sufficient fuel was remaining. During arrival, the plt activated the rwy lights, but did not see them until he was nearly…Apr 28, 1984 · N81784 · DestroyedNTSB FTW84FA214Accident · 3 fatalField investigationFinal reportCessna 310Q · Mckinney, TXPlt entered the landing pattern behind a slower acft (stearman) and reduced speed to maintain a proper interval. The nominal approach speed differential between the two acft makes is 26 mph. A right hand traffic pattern was in use and a right crosswind…Apr 28, 1984 · N69789 · DestroyedNTSB ATL84LA155Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Shaw, MSThe acft was landed gear up in a precautionary landing after a control difficulty in flt. On base leg a loud bang was heard and the acft started to roll right. Control forces were heavy so the other plt in the front seat tried to help on the controls. They…Apr 28, 1984 · N3882Y · Substantial damageNTSB ANC84FA059Accident · No injuriesField investigationFinal reportCessna 152 · Anchorage, AKA student plt in a Cessna 152, N45928, was inbound to land on rwy 33 at merrill field at the same time that another student plt in Cessna 152, N6479L, was departing from rwt 15. The student in N6479L was cleared for a 'city high' departure. After taking off,…Apr 25, 1984 · N45928 · 2 aircraft · Substantial damageNTSB DEN84LA133Accident · No injuriesLimited investigationFinal reportCessna 150M · Boulder, CODuring final approach the acft encountered a downdraft & impacted the ground about 50 ft short of the rwy. The possibility of downdrafts at the approach end of rwy 26 was well known to local plts including the instructor plt (CFI).the CFI reported the wind…Apr 24, 1984 · N714ED · Substantial damageNTSB NYC84FIG01Accident · Minor injuriesFinal reportPiper PA-28-161 · Gathersburg, MDWhile on a second attempt to intercept the LOC on the ILS 23 apch at frederick, MD, the plt reported a low fuel condition to baltimore ATC. At this time ATC suggested the plt fly to either baltimore (34 miles se) or to dulles (25 miles sw) for an apch. A…Apr 23, 1984 · N84400 · Substantial damageNTSB ATL84MA148Accident · 6 fatalMajor investigationFinal reportPiper PA-34-220T · Mt Airy, GADrg arrival, the plt reqd & rcvd clnc to fly drct to the unctld arpt, altho the arpt had no terminal nav fac & the acft had no RNAV type equip. Nrby at athens, the 0745 spl wx OBS was in part: indef cig, sky obscd, vsby 1/4 mi with fog. At 0801, atl ctr clrd…Apr 23, 1984 · N8443H · DestroyedNTSB NYC84LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Westerly, RIOn final approach to runway 32, the aircraft contacted trees located approximately 600 yard short of the approach end of the runway. The passenger stated after the accident that as the aircraft approached the runway, he noticed the acft was 'a bit too close…Apr 22, 1984 · N7634F · Substantial damageNTSB DEN84LA135Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Mcville, NDThe acft collided with the ground, left wing 1st, during an apch to land. The plt stated that the acft apparently stalled. A patrolman noted an odor of alcohol in the plt's breath. A blood/alcohol test showed an alcohol level of 0.19%. The plt's last medical…Apr 22, 1984 · N631C · Substantial damageNTSB ATL84FA147Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Athens, GABefore starting an apch, the plt was advised the wx was: 300 ft obscured, visibility 3/4 mi with light rain & fog. The minimums for a straight-in VOR apch to rwy 2 were 400 ft mda & 1 mi visibility; for a circling apch, the minimums were 433 ft & 1 mi. The…Apr 22, 1984 · N5009T · DestroyedNTSB FTW84LA207Accident · Serious injuriesLimited investigationFinal reportMooney M-18C · Lockhart, TXThe plt related that the acft was not performing well from the initial takeoff roll. Since he had only previously flown the acft in winter months & the temp was quite warm, he thought the lack of performance was due to the temp. He stayed in the traffic…Apr 21, 1984 · N4083 · Substantial damageNTSB NYC84FA143Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Concord, MAThe acft crashed into a house while on an ILS approach to rwy 11 at hanscom field. Shortly before the acft had reached the outer marker (and after the hand off from boston approach control to hanscom tower) an altitude alert on N4467X was received by the…Apr 19, 1984 · N4467X · DestroyedNTSB NYC84FA138Accident · Serious injuriesField investigationFinal reportBeech 35-C33 · Toms River, NJPlt stated that when using his bifocal corrective lenses, he had to tilt his head back to include the altimeter in his instrument scan. In the final phase of the approach, he failed to note the altimeter and collided with the terrain.Apr 16, 1984 · N15VP · Destroyed