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 DEN99LA007Accident · No injuriesLimited investigationFinal reportCessna 210A · Provo, UTThe pilot's abrupt throttle control movement that caused the engine to flood, and his failure to follow emergency procedures contained in the Airplane Flight Manual. Factors were increasing the mixture control to full rich and switching the fuel pump to high…Oct 10, 1998 · N9449X · Substantial damageNTSB ATL99LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Spartanburg, SCThe pilot's failure to manage the fuel supply which resulted in fuel starvation to the engine.Oct 10, 1998 · N21491 · Substantial damageNTSB ANC99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's misjudgment of a proper touchdown point. Factors associated with the accident were darkness, and the pilot's inadequate preflight planning.Oct 10, 1998 · N98900 · Substantial damageNTSB NYC99FA012Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Provincetown, MAThe failure of the pilot to follow the published instrument approach procedure, which resulted in inadvertent collision with water. Factors in the accident were the dark night and low ceiling.Oct 9, 1998 · N7100L · DestroyedNTSB CHI99FA003Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Howell, MIThe pilot's failure to maintain/exceed the Vmc airspeed during a go-around maneuver. Contributing factors were the shutting down of the left engine and the lack of recent experience in the type operation.Oct 9, 1998 · N3040A · DestroyedNTSB NYC99LA005Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Ravenna, OHThe pilot's improper decision to continue to operate the airplane with inoperative equipment which resulted in fuel exhaustion. Factors were the inoperative fuel quantity gauges, and the night conditions.Oct 8, 1998 · N3543A · DestroyedNTSB NYC99LA004Accident · Minor injuriesLimited investigationFinal reportEnstrom F280 · Bow, NHThe pilot's inadequate visual lookout and his failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tower. A factor in this accident was the gusty wind conditions.Oct 5, 1998 · N8618N · DestroyedNTSB DEN99FA004Accident · 1 fatalField investigationFinal reportCameron A-250 · Albuquerque, NMThe pilot not planning his approach to a landing so as to fly over the transmission wires (on the approach edge of the landing field) in level flight or ascending flight, and the pilot not pulling out the rip panel for emanate contact with transmission wires…Oct 5, 1998 · N4557W · DestroyedNTSB CHI99LA001Accident · 2 fatalLimited investigationFinal reportPiper PA-28-140 · Bad Axe, MIThe pilot's failure to maintain adequate altitude/clearance from the wires.Oct 5, 1998 · N648FL · DestroyedNTSB ANC98LA165Accident · Serious injuriesLimited investigationFinal reportMaule ML-7 · Wasilla, AKThe pilot's inadequate compensation for the wind conditions, resulting in an inadvertent stall. Contributing factors were the gusty and turbulent weather conditions.Sep 30, 1998 · N6110C · Substantial damageNTSB NYC98LA193Accident · Serious injuriesLimited investigationFinal reportBoeing DHC-8-102 · Islip, NYClear air turbulence.Sep 28, 1998 · N810EX · Minor damageNTSB FTW98LA413Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Belen, NMThe pilot inadvertently stalling the airplane.Sep 27, 1998 · N29572 · Substantial damageNTSB LAX98LA308Accident · No injuriesLimited investigationFinal reportRockwell Commander 114 · Atwater, CAAn internal capacitor failure and melting of the point cam followers, which resulted in failure of both magnetos, and subsequent total loss of engine power.Sep 26, 1998 · N114AL · Substantial damageNTSB CHI98LA363Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Lamar, MOthe pilot improperly positioned the fuel selector to the closed position causing fuel starvation.Sep 26, 1998 · N5029P · Substantial damageNTSB MIA98LA256Accident · No injuriesLimited investigationFinal reportCessna 152 · Reidsville, NCThe pilot's delay in the initiation of a go-around, and his failure to maintain obstacle (tree) clearance.Sep 25, 1998 · N152DD · Substantial damageNTSB IAD98GA110Accident · 1 fatalFinal reportHughes OH-6A · Newark, TXFailure of the Instructor Pilot to control the helicopter's rate of descent during a demonstrated autorotation. Contributing to the accident were the Operator's lack of: a. Instructor Pilot standardization procedures, and b. Specific or adequate flight…Sep 25, 1998 · N234ZM · DestroyedNTSB FTW98LA406Accident · 1 fatalLimited investigationFinal reportNicks PW-5 · Waller, TXThe pilot's failure to maintain terrain clearance.Sep 23, 1998 · N110WN · Substantial damageNTSB SEA98LA185Accident · Serious injuriesLimited investigationFinal reportDuncan DX4 · Priest River, IDThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. Factors include allowing his attention to be diverted by what he perceived to be a lateral control problem.Sep 22, 1998 · N4DX · Substantial damageNTSB ATL98LA128Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Goodway, ALThe pilot's continued approach into known adverse weather which resulted in the pilot's loss of control, and subsequent inflight collision with terrain. A factor was the weather conditions.Sep 22, 1998 · N9774 · Substantial damageNTSB SEA98LA184Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Flying M Ranch, ORThe pilot's failure to maintain an airspeed above stalling speed (Vs), and the resultant stall/mush of the aircraft into the terrain. Factors include the pilot's improper decision to attempt a go-around into rising terrain, landing with a tailwind, and trees…Sep 20, 1998 · N95318 · Substantial damageNTSB CHI98LA351Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILthe wake turbulence encountered by Flight 146.Sep 18, 1998 · N233RM · No damageNTSB NYC98LA188Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellington, CTWas the flight instructors lack of supervision over the student pilot's preflight inspection of the airplane, and which resulted in fuel exhaustion. Factors were the night conditions and the soft terrain.Sep 17, 1998 · N307DW · Substantial damageNTSB LAX98LA295Accident · 1 fatalLimited investigationFinal reportHughes Cassutt 111M2 · Reno, NVthe pilot's failure to maintain an adequate airspeed margin while maneuvering in gusty wind conditions, which led to an inadvertent stall/spin at low altitude.Sep 17, 1998 · N94HA · Substantial damageNTSB FTW98FA380Accident · No injuriesField investigationFinal reportBoeing 767-34AF · Houston, TXThe flight crew's decision to land with convective activity over the airport with a prevailing crosswind to a quartering tailwind, on an ungrooved, flooded runway, which resulted in hydroplaning and a loss of directional control. Factors contributing to the…Sep 11, 1998 · N316UP · Substantial damageNTSB SEA98LA175Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Stanley, IDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Sep 5, 1998 · N1048G · Substantial damageNTSB NYC98LA183Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Chatham, MAthe failure of the pilot to maintain airspeed during a go-around and which resulted in an inadvertent stall. Factors in the accident were the pilot's lack of total experience and the gusting crosswinds.Sep 5, 1998 · N28764 · Substantial damageNTSB NYC98LA181Accident · No injuriesLimited investigationFinal reportCessna 305A · Louisville, KYThe pilot's improper inflight decision, and his failure to maintain adequate airspeed which resulted in a stall.Sep 5, 1998 · N5245G · Substantial damageNTSB LAX98LA281Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Phoenix, AZFuel starvation due to the pilot's inadequate in-flight fuel management and his failure to select a tank containing fuel prior to the loss of power.Sep 3, 1998 · N55038 · Substantial damageNTSB FTW98FA384Accident · 2 fatalField investigationFinal reportCessna 172 · West Jordan, UTThe pilot's failure to maintain proper airport traffic pattern altitude. Factors were night lighting conditions and the unseen static line.Sep 3, 1998 · N8232B · DestroyedNTSB SEA98LA173Accident · No injuriesLimited investigationFinal reportKoskella Long EZ · Cascade, IDThe pilot's failure to maintain airspeed on final approach. Factors include inadequate remedial action and erroneous airspeed indications.Sep 2, 1998 · N5159P · Substantial damageNTSB MIA98LA231Accident · Minor injuriesLimited investigationFinal reportBibb RV-4 · Chapel Hill, NCThe failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion.Aug 29, 1998 · N144KT · Substantial damageNTSB MIA98LA230Accident · No injuriesLimited investigationFinal reportBell 47D1 · Dawson, GAThe pilot's selection of unsuitable terrain for landing resulting in debris being blown up during landing resulting in damage to the tail rotor and loss of control.Aug 29, 1998 · N4702S · Substantial damageNTSB FTW98LA381Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mineola, TXThe flight instructor's failure to maintain clearance from the fence post. A factor was the flight instructor's delay in taking remedial action to remedy the student's improper glidepath.Aug 29, 1998 · N235CF · Substantial damageNTSB FTW98FA378Accident · 2 fatalField investigationFinal reportMooney M20F · Fort Collins, COThe pilot's inadvertent stall/mush due to his excessive angle of bank during his traffic pattern turn to base. Factors were the pilot's improper downwind altitude, the pilot not properly setting his Kollsman Window in his altimeter, and the high density…Aug 29, 1998 · N377X · DestroyedNTSB CHI98LA342Accident · No injuriesLimited investigationFinal reportMBB BK-117 · Topeka, KSthe pilot's failure to assure the engine cowling was secured during the aircraft preflight which resulted in the cowling separating from the helicopter and damaging the main rotor and tail rotor system. Factors associated with the accident were the cowling…Aug 28, 1998 · N230H · Substantial damageNTSB CHI98LA341Accident · No injuriesLimited investigationFinal reportCessna 210D · Sturgis, MIthe cracked left main landing gear saddle, resulting in the pilot's inability to get the gear into the down and locked position.Aug 27, 1998 · N524BL · Substantial damageNTSB NYC98LA172Accident · No injuriesLimited investigationFinal reportEkstrom-Farrington Twinstar · Paducah, KYFailure of a through-bolt that attached the lateral control arms to the yoke assembly, due to unanticipated rotor brake forces through the flight control system.Aug 25, 1998 · N72DE · Substantial damageNTSB ATL98LA118Accident · No injuriesLimited investigationFinal reportPiper PA-30-39 · Greenville, NCA loose wiring connection at the landing gear motor relay that prevented the electrical extension of the landing gear.Aug 20, 1998 · N7298Y · Substantial damageNTSB NYC98LA170Accident · 1 fatalLimited investigationFinal reportKite Kitfox IV 1200 · Granby, NYThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Aug 19, 1998 · N4038T · DestroyedNTSB LAX98FA267Accident · Serious injuriesField investigationFinal reportCessna 177 · Los Angeles, CAThe failure of the pilot to accurately determine that an adequate quantity of fuel was aboard the aircraft for the intended flight, and the failure to monitor fuel quantity remaining while en route to ensure an adequate quantity of reserve fuel prior to…Aug 17, 1998 · N177GS · DestroyedNTSB IAD98FA094Accident · 1 fatalField investigationFinal reportBeech A-36 · Amelia, OHthe pilot's loss of control in flight due to spatial disorientation. A related factor was the fog.Aug 15, 1998 · N8EM · DestroyedNTSB MIA98LA224Accident · Minor injuriesLimited investigationFinal reportLesemann Pulsar XP · Fort Pierce, FLThe pilot's improper fuel management during a cross country flight which resulted in a total loss of engine power during the approach for landing and subsequent in-flight collision with wires and terrain.Aug 13, 1998 · N701JL · Substantial damageNTSB NYC98FA166Accident · 2 fatalField investigationFinal reportChampion 7FC · Alliance, OHThe pilot's failure to maintain altitude/clearance during the approach which resulted in an in-flight collision with trees. A factor in the accident was the pilot's lack of recent experience and lack of experience in the make and model of the accident…Aug 12, 1998 · N8520E · Substantial damageNTSB CHI98LA320Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Lac Du Flambeau, WIthe pilot's failure to maintain adequate airspeed and the subsequent inadvertant stall.Aug 9, 1998 · N9044D · Substantial damageNTSB FTW98LA350Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Alamosa, COImproper major overhaul of the engine by the overhaul facility. Factors were failure of the V-band clamp, the melting of the baffle and manifold clamp, and the pilot not being able to extend the landing gear.Aug 8, 1998 · N27196 · Substantial damageNTSB FTW98LA349Accident · No injuriesLimited investigationFinal reportCessna 210M · Albuquerque, NMA power loss for reasons undetermined. A factor was unsuitable terrain on which to make a forced landing.Aug 7, 1998 · N732RD · Substantial damageNTSB ATL98LA105Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Marathon, FLThe inadequate inspection of the fuel pump during the last engine overhaul, that subsequently resulted in a worn diaphragm, fuel venting overboard, and loss of engine power from fuel exhaustion during a critical phase of flight.Aug 7, 1998 · N8385E · Substantial damageNTSB MIA98FA219Accident · 4 fatalField investigationFinal reportSocata TBM-700 · Spearfish, SDThe pilot's failure to maintain control of the airplane while turning to base leg. Contributing factors were low ceilings, clouds, and the pilot's failure to adhere to both the published approach procedures and the published minimum decent altitude.Aug 4, 1998 · N69BS · DestroyedNTSB CHI98FA299Accident · 2 fatalField investigationFinal reportCessna 140 · St. Joseph, MOthe pilot not maintaining a proper final approach glide path to avoid an encounter with wake turbulence. A factor in this accident was the pilot not being able to control the airplane after its encounter with wake turbulence.Aug 4, 1998 · N2364V · DestroyedNTSB MIA98LA217Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLA loss of engine power due to undetermined reasons, resulting in an inadvertent stall at too low an altitude to allow recovery.Aug 3, 1998 · N29927 · Destroyed