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 LAX89FA081Accident · 1 fatalField investigationFinal reportCessna 414 · Pleasanton, CAFailure of the pilot to properly follow the IFR (instrument flight rules) procedures by not maintaining the minimum descent altitude for that seqment of the approach. The weather conditions and mountainous terrain were considered to be related factors.Jan 9, 1989 · N1672T · DestroyedNTSB MIA89LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bunnell, FLMisjudgement of altitude and distance to the runway by the student pilot, and inadequate supervision by the instructor pilot (CFI). The exposed (raised) runway lip was a factor.Jan 7, 1989 · N81444 · Substantial damageNTSB MIA89LA061Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Margate, FLFailure of the engine driven oil pump due to foreign object(s), which resulted in oil starvation and subsequent engine failure. Factors related to the accident were: dark night and trees in the emergency landing area.Jan 5, 1989 · N736BX · Substantial damageNTSB DEN89FA056Accident · Serious injuriesField investigationFinal reportCessna 208B · Aspen, COPilot's improper IFR procedure. Contributing factors included moderate turbulence, low ceilings, obscuration and snow.Jan 5, 1989 · N945FE · DestroyedNTSB NYC89FA062Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Limington, MEFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the adverse wind conditions, lack of pilot experience in the type of aircraft, and the lack of shoulder harness/upper body…Jan 4, 1989 · N5704D · DestroyedNTSB ANC89LA031Accident · No injuriesLimited investigationFinal reportCessna 207A · Russian Mission, AKThe partial engine power loss due to undetermined reasons. Contributing to the accident was the pilot's improper inflight planning by flying at a traffic pattern altitude insufficient to insure a safe emergency landing either on or off the airport and his…Jan 3, 1989 · N7329U · Substantial damageNTSB ATL89FA065Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B · Mansfield, OHFailure of the pilot to maintain control of the aircraft, due to spatial disorientation, at about the time he was changing radio frequencies during an IFR approach.Jan 2, 1989 · N500V · DestroyedNTSB FTW89LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Austin, TXThe pilot did not have an adequate fuel supply to complete the flight. The plts flt planning was inadequate and the ignored opportunities to obtain fuel enroute led to fuel exhaustion, prior to reaching destination.Jan 1, 1989 · N66385 · Substantial damageNTSB CHI89FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Springfield, ILThe pilot's improper IFR procedure during an ILS approach in below minimum conditions, and the pilot's failure to proceed to an alternate destination. Contributing factors were the adverse weather conditions.Jan 1, 1989 · N2305U · DestroyedNTSB NYC89LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-60 · Somerville, NJImproper inflight decisions while approaching the airport on final approach with defective magnetos. The right fuel selector was placed in the closed position, the pilot attempted a go around, raised the landing gear and flaps, failed to maintain VMC, and…Dec 31, 1988 · N90393 · DestroyedNTSB MIA89LA060Accident · Serious injuriesLimited investigationFinal reportAir Command 532E · Clearwater, FLThe student pilot said he did not remember anything about the accident. Witnesses stated that at about 50 ft AGL on final approach the gyrocopter rapidly descended. It remained level and hit hard, rolling over on impact. Witnesses stated that the engine was…Dec 31, 1988 · N70319 · Substantial damageNTSB CHI89LA041Accident · No injuriesLimited investigationFinal reportCessna 152II · Grand Rapids, MIPilot's total lack of experience in this type of operation.Dec 31, 1988 · N714XV · DestroyedNTSB NYC89FA059Accident · 1 fatalField investigationFinal reportBeech A36 · Bridgeport, CTTwice prior to being established on final the pilot was asked if he was getting proper indications for the approach to land. Contact was subsequently lost while the pilot was attempting to make an ILS approach to runway 06 at Bridgeport. The aircraft was…Dec 24, 1988 · N262C · DestroyedNTSB MIA89LA058Accident · No injuriesLimited investigationFinal reportCessna 175 · Starke, FLFlt was 3 miles east of arpt returning to land at alt of aprx 2,000 ft, when the eng quit. Plt was unable to restart & elected to land in small trees as a nearby highway was congested. Acft collided with trees & fell to the ground. Examination of the eng…Dec 24, 1988 · N9373B · Substantial damageNTSB DEN89LA048Accident · No injuriesLimited investigationFinal reportCessna TR182 · Lamar, COThe pilot was making a VFR approach for landing. The landing gear was lowered and full flaps were deployed. The pilot said he allowed the airspeed to get too low and the aircraft stalled. The nose and left wing dropped and the pilot added full power. The nose…Dec 24, 1988 · N757MU · DestroyedNTSB CHI89FA035Accident · 2 fatalField investigationFinal reportCessna 310R · Madison, INPilot-in-command's disregard of IFR procedures in descending below the minimum decision height for the approach to a point where collision with towers and/or wires became possible. His abrupt maneuver to avoid such collision resulted in a stall/spin, from…Dec 24, 1988 · N5121J · DestroyedNTSB ATL89FA061Accident · 2 fatalField investigationFinal reportCessna 210B · Mt Airy, NCThe pilot attempted to locate the destination airport in instrument meteorological conditions, and his failure to maintain a sufficient altitude to avoid the terrain in the area. Factors contributing to the accident were the pilot' overconfidence in his…Dec 24, 1988 · N210RW · DestroyedNTSB ATL89LA060Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Gilbertsville, KYDuring preflt inspection fuel was noted to be up to the slots in the tab for the reduced fuel indicators, or 20 gal each tank. A 3 hour, dark night, cross country was flown to destination. PIC said acft arrived with about 5 gal fuel remaining in each tank. On…Dec 23, 1988 · N6046V · Substantial damageNTSB MKC89FA043Accident · 3 fatalField investigationFinal reportBell 206L-1 · Cape Girardeau, MOThe helicopter was dispatched at night on an emerg med svc (EMS) flt fm a hospital at Cape Girardeau, MO. Purpose of theflt was to transport a patient fm a hospital at marion, IL, to Cape Girardeau. Wx at Cape Girardeau deteriorated after the acft departed.…Dec 22, 1988 · N119CG · DestroyedNTSB MIA89LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Clearwater, FLThe plt stated that he had been given a short approach for runway 4, when the tower told him to go around. He added power, retracted the flaps, and made a sharp right turn. The acft stalled and crashed into an office building aprx 1 mile from the airport.Dec 22, 1988 · N5160F · Substantial damageNTSB LAX89LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Hesperia, CAAt the end of a pleasure flight, while on final approach, the airplane was low on the approach. Just prior to reaching the airport boundary, the airplane collided with the top of a vehicle travelling on a road perpendicular to the runway. The airplane…Dec 22, 1988 · N1542Q · Substantial damageNTSB FTW89LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Houma, LAThe airplane was on an IFR flight plan but was in VFR conditions when the communications radios failed. Pilot used hand held transceiver, but communications were not satisfactory. Pilot elected to continue to destination but did not declare an emergency nor…Dec 22, 1988 · N6444U · Substantial damageNTSB CHI89IA034Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42 · Mosinee, WIStall induced by the accretion of moderate to severe clear icing.Dec 22, 1988 · N427MQ · No damageNTSB CHI89LA033Accident · No injuriesLimited investigationFinal reportCessna 414 · Pontiac, MIDec 20, 1988 · N414CM · Substantial damageNTSB ANC89LA024Accident · No injuriesLimited investigationFinal reportCessna 170B · North Pole, AKThe plt rprtd that drg an apch to land, a x-wind caused the acft to drift to the left. Subsequently, the left wing struck trees along the edge of the rwy & the acft crashed. The plt rprtd the wind was from 120 deg at 6 gusting 10 KTS.Dec 18, 1988 · N3138B · Substantial damageNTSB SEA89LA028Accident · No injuriesLimited investigationFinal reportCessna 210D · Twin Falls, IDPrior to landing, the pilot was unable to lower the nose gear by using either the normal or emergency systems. Subsequently, he landed the acft with the main gear extended & the nose gear in the retracted position. After landing, the nose gear uplock actuator…Dec 17, 1988 · N3815Y · Substantial damageNTSB LAX89FA064Accident · 2 fatalField investigationFinal reportCessna T210L · Buena Park, CAThe pilot used poor judgement in beginning the flight with inadequate fuel; his failure to follow normal v.f.r. procedures; and his poor preflight inspection.Dec 17, 1988 · N4675Q · DestroyedNTSB LAX89DVM03Accident · 1 fatalFinal reportBeard Varieze · Palo Alto, CAThe acft crashed 200 ft short of the rwy in a pond and nosed over. Witnesses heard the sounds of low power. Evidence of low/no power was shown by the prop. Investigation revealed that unapproved engine mods were made by pilot/owner. An untested carb heat…Dec 13, 1988 · N226RB · Substantial damageNTSB ATL89FA054Accident · 2 fatalField investigationFinal reportAero Commander 720 · Alcoa, TNAfter encountering icing conditions in flight and experiencing problems maintaining altitudes and headings, the pilot elected to divert from his planned destination of dayton, oh to knoxville, TN. While on final approach after descending 1300 ft below minimum…Dec 9, 1988 · N120G · DestroyedNTSB SEA89FA021Accident · 2 fatalField investigationFinal reportCessna 335 · Arlington, WADrg a ngt arr, the plt was vectored for a LOC rwy 34 apch. After rchg the final apch fix/outer marker (om), he was clrd for the apch. Abt 5 or 6 min later, the ATC ctlr noticed the acft was aprx 7 mi nw of the arpt, climbing abv 3000' MSL. Missed apch…Dec 3, 1988 · N2706F · DestroyedNTSB NYC89LA037Accident · No injuriesLimited investigationFinal reportCessna 172 · Block Island, RIThe pilot of the Cessna 182 was on downwind when he stated that he pulled the carburetor heat on and then pulled the power back to 1500 RPM. Within a few seconds the engine quit and the pilot informed the tower. The aircraft landed about 500 feet short of the…Dec 3, 1988 · N19863 · Substantial damageNTSB MKC89LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Garnett, KSHaving just made a parachutist's drop, during a sky diving operation, the private pilot spiraled down from altitude to land, but had to extend his pattern to allow a departing acft to leave. During a long final approach, the engine failed and an emergency…Dec 3, 1988 · N5851B · Substantial damageNTSB FTW89FA028Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Tomball, TXThe airplane was being used for touch and go landings by an instructor and a low time student. It was on a base leg to land to the south when the instructor told the tower she had lost the engine and was going down. There were no witnesses to the accident.…Dec 3, 1988 · N2379V · DestroyedNTSB ATL89LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Griffin, GAAfter a preflight and runup the pilot made a takeoff and remained in closed traffic for landing practice. On downwind, opposite the desired point of touchdown, he retarded power, applied carb heat and slowed the airplane. Turning base, the acft lost power.…Dec 2, 1988 · N92388 · Substantial damageNTSB LAX89LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Modesto, CADuring an ILS approach in night instrument meteorological conditions, the pilot allowed the airspeed to diminish resulting in the airplane stalling. Before the pilot could regain control, the airplane collided with the terrain short of the runway. There were…Dec 1, 1988 · N5852V · Substantial damageNTSB LAX89FA057Accident · 1 fatalField investigationFinal reportBeech N35 · Hanford, CAThe pilot failed to maintain sufficient altitude and descended below the minimum descent altitude while executing the missed approach. Contributing to this accident was the deteriorating weather conditions and the pilot's wish to return the airplane to its…Nov 28, 1988 · N9469Y · DestroyedNTSB FTW89FA025Accident · 1 fatalField investigationFinal reportLuscombe 8E · Port Lavaca, TXThere were no records to indicate the non-instrument rated pilot received a pre-flight weather briefing from any weather reporting service. Witnesses in the area of the accident stated the night was dark and the ground was covered with fog. The airplane…Nov 27, 1988 · N2301K · DestroyedNTSB NYC89LA040Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Erwinna, PAOff airport landing in unsuitable terrain due to a power loss caused by carburetor icing.Nov 25, 1988 · N8572V · Substantial damageNTSB ANC89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe pilot misjudged the approach and failed to maintain a proper descent rate. A related factor was trees.Nov 25, 1988 · N2930M · Substantial damageNTSB CHI89LA028Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Marquette, MIAfter encountering unforecast adverse wx at his intended destn, the plt circled the area a couple of times, then diverted to Marquette, MI. However, before reaching the alternate arpt, the eng lost power due to fuel exhaustion. Subsequently, the acft collided…Nov 24, 1988 · N3662W · Substantial damageNTSB ATL89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ft Mill, SCTwo days before the acdnt, the plt had fueled the acft to capacity & flown it a short distance to his house at a pvt airstrip. After the flt, he noticed fuel on the tops of both wings, aft of the fuel filler caps. He was aware that fuel had leaked from the…Nov 23, 1988 · N6711P · Substantial damageNTSB ATL89LA043Accident · No injuriesLimited investigationFinal reportCessna 182 · Thomaston, GAThe pilot and three passengers were on a night flight in an aircraft that was equipped to carry skydivers. During the approach to land, the landing light failed. While attempting to get the light to operate, the pilot allowed an undershoot to develop.…Nov 22, 1988 · N5473B · Substantial damageNTSB NYC89LA034Accident · Serious injuriesLimited investigationFinal reportCessna 340 · Oxford, CTCollision with trees and terrain due to the pilot exceeding approach minimum altitude during an ILS approach.Nov 20, 1988 · N468CM · DestroyedNTSB MKC89FA027Accident · 6 fatalField investigationFinal reportBeech E-90 · Locust Grove, ARThe pilot's failure to maintain obstacle clearance altitude and exceeding the minimum descent altitude published in the approach procedure.Nov 19, 1988 · N308PS · DestroyedNTSB LAX89LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Van Nuys, CAThe pilot lost control of the aircraft while descending for landing and collided with a pole. The pilot stated that he was cleared to land behind a king air, on runway 16R. The pilot stated that about the time he descended to 50 feet AGL, near the threshold,…Nov 19, 1988 · N4306M · Substantial damageNTSB MIA89LA037Accident · No injuriesLimited investigationFinal reportCessna 150J · San Juan, PRThe acft departed, entered left downwind leg for touch-and-go landings. When at midfield downwind, the instructor plt stated the eng quit & he was unable to restart it. The acft continued downwind momentarily then the instructor plt turned the acft to land at…Nov 18, 1988 · N61317 · Substantial damageNTSB ATL89LA039Accident · No injuriesLimited investigationFinal reportCessna 172 · Pikeville, KYThe pilot had flown about 3.7 hours and was about 2 miles from his destination airport when the engine stopped and he was forced to land in a swamp. The pilot had topped off the acft so that it contained 42 gallons of fuel (38 gallons of usable fuel). The…Nov 18, 1988 · N2840Q · Substantial damageNTSB FTW89LA021Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Gulf-Of-Mexico (Gulf of Mexico)Engine failure for undetermined reasons and the pilot misjudging his altitude during the flare resulting in a hard landing.Nov 17, 1988 · N2780W · Substantial damageNTSB MIA89FA033Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Jacksonville, FLDrg a ngt arrival, the plt requested a special VFR clnc to the arpt & was adzd that the wx was partially obscured, vis was 1 mi with fog & the wind was calm. As he contd the apch, all flts were adzd the vis had dropped to 1/2 mi. The plt requested clnc for an…Nov 14, 1988 · N8342L · DestroyedNTSB DEN89LA033Accident · Serious injuriesLimited investigationFinal reportCessna 310H · Carlsbad, NMOn an IFR business/training flt, the ATP plt made an unscheduled fuel stop. On a practice ILS apch to rwy 3, circling to land rwy 21, the acft yawed hard rt and the plt lost directional control. The plt said it sounded and felt like the rt engine had lost…Nov 14, 1988 · N1044Q · Substantial damage