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 CHI98LA064Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Wichita, KSthe pilot-in-command misjudged the fuel supply and selected an empty fuel tank which resulted in fuel exhaustion. A factor associated with the accident was the rough terrain encountered when the airplane touched down short of the runway.Dec 17, 1997 · N6377L · Substantial damageNTSB NYC98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Philadelphia, PAThe pilot's failure to maintain proper distance and altitude during approach which resulted in an undershoot and collision with a fence.Dec 16, 1997 · N2932X · Substantial damageNTSB ANC98LA012Accident · No injuriesLimited investigationFinal reportCessna 207 · Alakanuk, AKthe pilot's mismanagement of the airplane's fuel which led to the loss of engine power due to fuel starvation.Dec 15, 1997 · N707FY · Substantial damageNTSB SEA98FA023Accident · 2 fatalField investigationFinal reportAero Commander 690A · Yakima, WAA loss of aircraft control for undetermined reasons.Dec 13, 1997 · N72VF · DestroyedNTSB CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.Dec 13, 1997 · N5454S · DestroyedNTSB ATL98FA023Accident · 1 fatalField investigationFinal reportBeech A100 · Charlotte, NCThe pilot's continued approach below decision height without reference to the runway environment, and his failure to execute a missed approach.Dec 11, 1997 · N30SA · DestroyedNTSB LAX98LA056Accident · Serious injuriesLimited investigationFinal reportJohnson Bushrod · Corona, CAAn in-flight loss of control resulting from a malfunction in the wing flap operating system. The malfunction produced asymmetrical drag and induced a roll which could not be overcome by the pilot's flight control inputs.Dec 9, 1997 · N6232F · DestroyedNTSB CHI98LA057Accident · No injuriesLimited investigationFinal reportCessna 402A · Milwaukee, WIInadequate preflight planning/preparation, which resulted in fuel exhaustion.Dec 9, 1997 · N728QA · Substantial damageNTSB LAX98LA053Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369HS · Saipan, IndiaThe failure of the maintenance facility to comply with the service bulletins, which resulted in the development of a corrosion pit, subsequent leakage and failure of the acceleration bellows of the fuel control.Dec 6, 1997 · N9068F · DestroyedNTSB SEA98LA019Accident · Serious injuriesLimited investigationFinal reportBlue Denney Kitfox Model 3 · Caldwell, IDThe pilot's failure to maintain adequate airspeed.Dec 4, 1997 · N89DD · Substantial damageNTSB LAX98LA049Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Union City, CABlockage of the fuel flow transducer, which resulted in fuel starvation and the loss of engine power. Unsuitable terrain for an emergency landing was a contributing factor.Dec 2, 1997 · N1396U · Substantial damageNTSB FTW98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Lubbock, TXThe inadequate maintenance of the landing gear assembly by maintenance personnel resulting in a partial gear extension, and the pilot's misjudgment of a proper touchdown point to intentionally shut down the engine resulting in the airplane landing short of…Dec 1, 1997 · N6661P · Substantial damageNTSB CHI98LA050Accident · No injuriesLimited investigationFinal reportCessna 402B · Spencer, IAThe pilot failure to comply with the prescribed IFR procedure and his not following his company's operations specifications. Low clouds and fog were are contributing factors.Nov 29, 1997 · N22NC · Substantial damageNTSB NYC98FA035Accident · 2 fatalField investigationFinal reportCessna 310R · St Mary'S, PAwas the pilot's descent below the minimum descent altitude and his failure to comply with published procedures.Nov 28, 1997 · N6923 · DestroyedNTSB MIA98LA036Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Hazel Green, ALthe pilot's miscalculating the aircraft's fuel consumption for the flight, resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Nov 28, 1997 · N3908L · Substantial damageNTSB LAX98LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Saipan, MaliThe loss of engine power for undetermined reasons that resulted in the pilot ditching the aircraft into the ocean.Nov 26, 1997 · N1256H · DestroyedNTSB LAX98FA045Accident · 1 fatalField investigationFinal reportCessna 152 · El Cajon, CAThe solo student's failure to see and follow the other aircraft on the downwind as he had been instructed. Factors influencing this accident was the failure of the pilots in the other aircraft to see and avoid the aircraft encroaching on his flight path; the…Nov 25, 1997 · N757FT · 2 aircraft · DestroyedNTSB FTW98LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Watkins, COloss of engine power for undertermined reason(s).Nov 24, 1997 · N738LC · Substantial damageNTSB CHI98LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodstock, ILthe pilot's failure to see-and-avoid the powerlines on short final. The location of the powerlines was a related factor.Nov 24, 1997 · N49908 · Substantial damageNTSB CHI98LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lakeville, MNgeese that were encounter on an ILS final approach. Darkness was a related factor.Nov 23, 1997 · N1447H · Substantial damageNTSB ATL98LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · Waycross, GAa loss of engine power for undetermined reasons.Nov 23, 1997 · N48310 · Substantial damageNTSB LAX98LA041Accident · Minor injuriesLimited investigationFinal reportRans S91 · Phoenix, AZThe pilot's failure to maintain an adequate airspeed margin during the forced landing, which resulted in an inadvertent stall/mush.Nov 22, 1997 · N9291T · Substantial damageNTSB ATL98LA013Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Opa Locka, FLthe pilot's continued flight into adverse weather conditions, and failure to maintain clearance above the ground while attempting a VFR approach to an airport with low clouds. The low clouds (ceiling) and condition of light at dusk were related factors.Nov 22, 1997 · N45834 · Substantial damageNTSB FTW98LA053Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Tomball, TXThe total loss of engine power resulting from the loss of oil and resultant seizure of a cylinder due to inadequate maintenance by maintenance personnel. A factor was the lack of suitable terrain for the forced landing and the low ceiling.Nov 19, 1997 · N88WC · Substantial damageNTSB LAX98LA040Accident · No injuriesLimited investigationFinal reportAero Commander 200D · San Carlos, CAThe pilot's failure to verify that there was an adequate supply of fuel in the selected fuel tank prior to takeoff.Nov 18, 1997 · N2910T · Substantial damageNTSB ATL98FA009Accident · 1 fatalField investigationFinal reportBeech B100 · Madison, MSthe pilot's failure to maintain control of the aircraft due to spatial disorientation. A related factor was: the instrument weather conditions.Nov 13, 1997 · N500ML · DestroyedNTSB LAX98LA035Accident · No injuriesLimited investigationFinal reportBeech C23 · Corona, CAThe loss of engine power for undetermined reasons. A factor was the rough terrain that resulted in a nose over during the landing roll.Nov 8, 1997 · N3724Z · Substantial damageNTSB FTW98LA047Accident · No injuriesLimited investigationFinal reportReid Capella XS · Leander, TXThe loss of engine power due to an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Nov 8, 1997 · N89FW · Substantial damageNTSB MIA98LA024Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Memphis, TNThe pilot-in-command's improper management of fuel resulting in a total loss of engine power on both engines during an instrument approach due to fuel exhaustion.Nov 7, 1997 · N59316 · Substantial damageNTSB MIA98LA019Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe pilot's improper management of fuel resulting in a total loss of engine power on both engines due to fuel exhaustion.Nov 2, 1997 · N69312 · DestroyedNTSB MIA98LA023Accident · No injuriesLimited investigationFinal reportLet L-13 · Elkin, NCThe instructor's pilot's misjudgment of altitude and distance, and his inadequate compensation for the wind conditions. Unfavorable winds and a fence were contributing factors.Nov 1, 1997 · N65140 · Substantial damageNTSB NYC98LA025Accident · No injuriesLimited investigationFinal reportHughes 269B · Cleveland, OHthe pilot's failure to recover from settling-with-power. Factors relating to the accident were: the pilot's downwind approach and low airspeed.Oct 31, 1997 · N2273W · Substantial damageNTSB NYC98FA024Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Fitchburg, MAThe flight instructor's inadequate in-flight decision and his failure to maintain adequate airspeed which resulted in a loss of control. Contributing was the flight instructor's failure to follow standard practices while simulating and practicing emergency…Oct 31, 1997 · N3EV · DestroyedNTSB LAX98LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Santa Rosa, CALoss of engine power for undetermined reasons.Oct 31, 1997 · N1655H · Substantial damageNTSB FTW98LA033Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Counselor, NMthe pilot inadvertently allowing the helicopter to settle with power.Oct 28, 1997 · CFPWH · Substantial damageNTSB SEA98LA009Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Midvale, IDThe student pilot's failure to maintain adequate clearance with the pole. A factor contributing to the accident was the pole.Oct 27, 1997 · N9332J · DestroyedNTSB NYC98LA021Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Ocean City, NJThe pilot's failure to maintain sufficient altitude. Factors in the accident were the rain and fog.Oct 26, 1997 · N252MY · Substantial damageNTSB LAX98LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Fernley, NVthe pilot's failure to maintain terrain clearance during a delayed go-around after an improper decision to continue an approach to an unlighted runway without adequate visual references. Ground fog was a factor in this accident.Oct 24, 1997 · N3155A · Substantial damageNTSB ATL98LA006Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-A1 · West Palm Beach, FLthe pilot's inadvertent use of the wrong runway, and his improper decision to continue the approach behind a large airplane (MD-80), which resulted in a wake turbulence encounter, loss of aircraft control, and collision with terrain.Oct 21, 1997 · N534SS · Substantial damageNTSB LAX98LA015Accident · Minor injuriesLimited investigationFinal reportBeech D17S · Chino, CAfuel starvation resulting from the pilot's inadequate in-flight planning and improper fuel management. Contributing factors were the nighttime conditions and the rough/uneven terrain.Oct 20, 1997 · N67736 · Substantial damageNTSB ANC98IA004Incident · No injuriesIncident investigationFinal reportCessna 208B · Kasigluk, AKinadequate inspection of the aileron by company maintenance personnel, and the pilot's inadequate preflight inspection of the aileron, which led to the jamming of the left aileron due to loose balance weight retaining screws.Oct 20, 1997 · N9304F · No damageNTSB FTW98LA018Accident · Serious injuriesLimited investigationFinal reportMooney M20F · College Station, TXThe pilot's failure to maintain airspeed during a go-around. Factors were :the pilot's premature retraction of the flaps, his lack of total experience in the airplane, the dark night illumination, pilot fatigue, and pressure induced by the passengers to…Oct 19, 1997 · N7433V · Substantial damageNTSB SEA98LA004Accident · Serious injuriesLimited investigationFinal reportBeech V-35 · Medford, ORthe pilot's failure to refuel the airplane.Oct 18, 1997 · N5482U · Substantial damageNTSB LAX98LA017Accident · No injuriesLimited investigationFinal reportSchweizer 126-D · Peoria, AZThe pilot's failure to maintain an adequate clearance from obstacles during the landing approach.Oct 18, 1997 · N7583 · Substantial damageNTSB CHI98LA018Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Rapid City, SDthe windshear, the pilot's inability to maintain the airplane's landing approach speed, and the inadvertent stall.Oct 18, 1997 · N88119 · Substantial damageNTSB CHI98LA021Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDthe pilot's inadequate preflight planning which resulted in a low fuel state, and his inability to see the wire which the helicopter contacted. Factors associated to the accident were the precautionary landing, the dark night conditions, and the wire which…Oct 15, 1997 · N557DC · Substantial damageNTSB CHI98LA014Accident · 2 fatalLimited investigationFinal reportCessna 172N · Terre Haute, INThe pilot's failure to maintain adequate airspeed during a go-around attempt which resulted in an inadvertent stall.Oct 12, 1997 · N734WT · Substantial damageNTSB CHI98LA013Accident · Minor injuriesLimited investigationFinal reportSchweizer FGS-233 · Ionia, MIthe pilot misjudged the landing approach which resulted in his failure to attain a proper touchdown point. A factor was the trees.Oct 12, 1997 · N5762S · Substantial damageNTSB CHI98LA006Accident · Serious injuriesLimited investigationFinal reportBeech V35A · West Lafayette, INthe pilot's improper decision not to land before his airplane ran out of fuel, fuel exhaustion and the inadvertent stall.Oct 5, 1997 · N1566A · Substantial damageNTSB CHI98FA010Accident · 3 fatalField investigationFinal reportAero Commander 100-180 · Auburn, NEthe pilot misjudged distance/altitude to the runway, while on final approach to land, allowing the airplane to get too low and collide with a truck. A related factor was: the proximity of the truck (and highway) to the runway.Oct 5, 1997 · N4028X · Destroyed