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 CHI94DEP01Accident · No injuriesFinal reportKrotje Kolb Mark III · Oshkosh, WIThe lack of carburetor heat for the engine. A factor related to the accident was: the weather condition, which was favorable for formation of carburetor ice.Nov 28, 1993 · N393PK · Substantial damageNTSB BFO94FA021Accident · 1 fatalField investigationFinal reportPiper PA32R-301 · Butler, PAThe pilot's inadvertent flight into IMC conditions and his failure to maintain proper altitude. The weather conditions were a factor.Nov 28, 1993 · N707JS · DestroyedNTSB LAX94LA060Accident · Serious injuriesLimited investigationFinal reportAlbrecht Polywagon · Vacaville, CAthe pilot's failure to maintain control of the aircraft during a go-around. Factors in the accident were the wind shear conditions and the pilot's failure to adequately balance the fuel load during the flight.Nov 26, 1993 · N320PW · Substantial damageNTSB FTW94FA038Accident · 2 fatalField investigationFinal reportCessna T303 · Rogers, ARThe pilot's continued flight into known adverse weather conditions, and the ensuing inadvertent stall. Factors were the icing conditions, the fog, the drizzle, the dark night light conditions, and the pilot's disregard for the forecasted weather conditions.Nov 26, 1993 · N2297C · DestroyedNTSB BFO94LA018Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Stowe, VTThe pilot did not follow the emergency procedure after loss of power in the right engine, by failing to feather the right engine and failing to maintain minimum single-engine control speed. A factor related to the accident was: failure of the pilot to adhere…Nov 26, 1993 · N4VG · DestroyedNTSB BFO94LA016Accident · No injuriesLimited investigationFinal reportTaylorcraft J-2 · Pittstown, NJThe pilot failed to maintain a proper glidepath. A factor in the accident was the presence of sunglare.Nov 22, 1993 · N19565 · Substantial damageNTSB LAX94LA055Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Santa Paula, CAThe pilot's failure to follow proper procedures/directives prohibiting night operations at the airport and failure to maintain the proper glidepath. The pilot's diverted attention was a factor in this accident.Nov 21, 1993 · N6405Q · Substantial damageNTSB ATL94LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Kinston, NCWas the student pilot's failure to maintain aircraft control during the go around. A factor was the wind gusts which occurred at the time of the accident.Nov 21, 1993 · N5340Q · Substantial damageNTSB FTW94IA035Incident · No injuriesIncident investigationFinal reportGrumman G159 · Pineville, LAAn encounter with a wet microburst, on final approach at 200 feet AGL, which exceeded the performance capability of the aircraft.Nov 16, 1993 · N806W · Minor damageNTSB CHI94FA039Accident · No injuriesField investigationFinal reportBoeing 727-227 · Chicago, ILThe captain's failure to assure that the landing gear was extended for landing. Factors related to the accident were: traffic alert distractions, the flight crew's failure to use the checklist, and inadequate company systems training.Nov 15, 1993 · N16762 · Substantial damageNTSB ATL94LA017Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235 · Lake City, SCThe pilot's failure to maintain a proper glidepath which resulted in collision with trees near the approach end of the runway.Nov 14, 1993 · N9226M · Substantial damageNTSB BFO94LA006Accident · Minor injuriesLimited investigationFinal reportCessna 150M · West Milford, NJThe loss of engine power due to an undetermined reason. A factor in this accident was the lack of suitable terrain to complete a forced landing.Nov 11, 1993 · N3481V · Substantial damageNTSB SEA94GA024Accident · Minor injuriesFinal reportCessna 182R · Salt Lake City, UTThe pilot in command's maintaining inadequate altitude while crossing over the ground track of the landing Boeing 757. A factor contributing to the accident was wake turbulence.Nov 10, 1993 · N9652X · DestroyedNTSB ATL94LA013Accident · Serious injuriesLimited investigationFinal reportBowermaster B-8M · Cowpens, SCFuel starvation which resulted from unported fuel in the fuel tank due to inadequate design of the tanks.Nov 10, 1993 · N10343 · Substantial damageNTSB LAX94LA040Accident · No injuriesLimited investigationFinal reportBeech D95A · Hollister, CAThe improper position of the fuel selector switch by the dual student during the before landing checklist and inadequate supervision by the CFI. Fuel starvation to both engines was a factor in this accident.Nov 9, 1993 · N566KK · Substantial damageNTSB BFO94LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Manassas, VAThe loss of total engine power for undetermined reasons. A factor in the accident was the lack of suitable terrain to enable the completion of a power-off forced landing.Nov 8, 1993 · N8223T · Substantial damageNTSB FTW94LA027Accident · No injuriesLimited investigationFinal reportCessna 150G · Salem, ARPartial loss of engine power for undetermined reasons. A factor was unsuitable terrain for the forced landing.Nov 7, 1993 · N2225J · Substantial damageNTSB MIA94FA015Accident · 1 fatalField investigationFinal reportCessna 182Q · Crestview, FLWas incapacitation of the pilot due to cardiovascular disease during an instrument approach resulting in the aircraft descending uncontrolled until tree and ground impact. Contributing to the accident was the pilot's decision to fly with known cardiovascular…Nov 6, 1993 · N97450 · DestroyedNTSB CHI94MA032Accident · 5 fatalMajor investigationFinal reportCessna 421B · Greensburg, INan inadvertent stall by the pilot in command. Factors associated with the accident are the icing conditions and low ceilings.Nov 6, 1993 · N41010 · DestroyedNTSB SEA94LA023Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Mckenzie Bridge, ORA partial loss of engine power for undetermined reasons.Nov 1, 1993 · N6629H · Substantial damageNTSB NYC94FA025Accident · 1 fatalField investigationFinal reportMooney M20K · Blue Ash, OHThe pilot's inadequate inflight decision to conduct flight into known icing conditions and his failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were icing conditions and the pilot's failure to follow the preflight briefing…Oct 31, 1993 · N252G · DestroyedNTSB SEA94LA022Accident · No injuriesLimited investigationFinal reportBeech A-35 · Billings, MTThe pilot's failure to maintain directional control during the go-around. Factors include proper airspeed not being maintained, and gusty crosswinds.Oct 30, 1993 · N575B · Substantial damageNTSB LAX94LA032Accident · No injuriesLimited investigationFinal reportCessna 172N · Joshua Tree, CAthe pilot's failure to maintain a proper descent rate on final approach. A factor in the accident was the student's limited total experience.Oct 30, 1993 · N8279E · Substantial damageNTSB SEA94LA021Accident · Serious injuriesLimited investigationFinal reportHannah Avid Amphibian · Scappoose, ORThe pilot's poor inflight decision, and failure to maintain sufficient airspeed. Factors include contaminated fuel.Oct 27, 1993 · N6664K · Substantial damageNTSB SEA94LA020Accident · Serious injuriesLimited investigationFinal reportAero Commander AC-100-180 · Oregon City, ORThe pilot's failure to maintain clearance from transmission wires. Factors include light conditions at dusk, and transmission wires near the approach end of the runway.Oct 27, 1993 · N3723X · Substantial damageNTSB LAX94LA025Accident · 2 fatalLimited investigationFinal reportWittman Tailwind W8L · San Jose, CAThe loss of engine power for an undetermined reason(s). A factor in the accident was the unsuitable nature of the terrain encountered during the forced landing.Oct 27, 1993 · N9052C · DestroyedNTSB FTW94LA020Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · San Antonio, TXThe pilot's failure to maintain a visual lookout. Factors were: inadequate altitude and distracted attention.Oct 25, 1993 · N94BG · Substantial damageNTSB NYC94LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Bowling Green, OHThe flight instructor's inadequate supervision of an attempted go-around by the student pilot which resulted in a loss of control and subsequent impact with the terrain. Factors were noncompliance with published procedures.Oct 24, 1993 · N2874T · Substantial damageNTSB LAX94LA023Accident · No injuriesLimited investigationFinal reportCessna 172 · Murrieta, CAThe unexpected windsheer that was encountered on final approach. The surrounding mountain/hilly terrain was a factor in this accident.Oct 24, 1993 · N96353 · Substantial damageNTSB CHI94LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Byron, WIthe pilot's inaccurate fuel consumption calculations which resulted in his not refueling during the flight. A factor related to the accident was the pilot's failure to maintain proper airspeed during the forced landing.Oct 24, 1993 · N5390B · DestroyedNTSB NYC94LA013Accident · Serious injuriesLimited investigationFinal reportCessna C-150 · Cynthiana, KYThe pilot's abrupt control of the airplane on short final to the runway, with the flaps retracted, which resulted in an inadvertent stall and the subsequent collision with the trees. A factor in this accident was the poor judgement of the student pilot to go…Oct 23, 1993 · N704US · DestroyedNTSB LAX94LA021Accident · No injuriesLimited investigationFinal reportBeech 76 · Scottsdale, AZthe flight instructor's failure to adequately supervise the flight, follow proper procedures/directives regarding leaning and clearing the idling engine, and his delay in applying power to the idling engine. The fouled spark plugs were a factor in this…Oct 22, 1993 · N5148M · Substantial damageNTSB FTW94LA015Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Pueblo, COA complete, non mechanical failure of the power plant for unknown reasons. A factor was the lack of suitable terrain for the forced landing.Oct 22, 1993 · N321TJ · Substantial damageNTSB LAX94LA016Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Sunland, CAthe CFI's poor inflight planning/decision and failure to follow normal procedures. The tailwind was a factor in this accident.Oct 18, 1993 · N192KC · Substantial damageNTSB ATL94LA005Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Maryville, TNFailure of the pilot to maintain airspeed control, which resulted in a low altitude stall.Oct 16, 1993 · N6823V · Substantial damageNTSB NYC94LA010Accident · Minor injuriesLimited investigationFinal reportSchlappi RV3 · Hatfield, MAThe pilot misjudged his distance and altitude which resulted in an undershoot of the runway. A factor was his delay in intiating a go around.Oct 15, 1993 · N669CP · Substantial damageNTSB LAX94LA013Accident · No injuriesLimited investigationFinal reportCessna 150L · Van Nuys, CAthe pilot's poor preflight planning/preparation and fuel consumption calculations. Fuel exhaustion is a factor in this accident.Oct 15, 1993 · N150GS · Substantial damageNTSB FTW94LA016Accident · No injuriesLimited investigationFinal reportBeech A36 · Tomball, TXWas the pilot's disregard for and continued descent below mda and his delay in executing a go around.Oct 13, 1993 · N6198A · Substantial damageNTSB ATL94LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Blountville, TNImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.Oct 12, 1993 · N12657 · Substantial damageNTSB CHI94LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Independence, MOThe pilot's misjudgment of distance, altitude, and speed on final approach to land, and failure to maintain obstacle clearance from the vehicle. The proximity of the vehicle to the approach path was a related factor.Oct 10, 1993 · N738LX · Substantial damageNTSB NYC94FA007Accident · 1 fatalField investigationFinal reportBeech A36 · Topsfield, MAFailure of the pilot to follow the published IFR procedure, and his failure to correct a spiral after becoming spatially disoriented.Oct 9, 1993 · N6AP · DestroyedNTSB FTW94FA008Accident · 2 fatalField investigationFinal reportBalloon Works FIREFLY-7 · Albuquerque, NMThe p[ilot's improper decision to attempt continued flight under the existing wind conditions. The adverse wind was a contributing factor.Oct 9, 1993 · N4058A · DestroyedNTSB NYC94FA004Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · East Hampton, NYInadvertent feathering of both propellers by the student pilot, which resulted in a loss of power, and failure (or inability) of the instructor pilot (CFI) to attain remedial action. A factor related to the accident was: the student pilot's habit…Oct 6, 1993 · N10GL · DestroyedNTSB FTW94LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · San Angelo, TXWas malfunction of the throttle control push/pull rod and cable. A factor was unsuitable terrain for the forced landing.Oct 6, 1993 · N68108 · DestroyedNTSB ANC94LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Bear Creek, AKThe pilot's delayed go-around procedure. A factor in the accident was the improper use of carburetor heat during the go-around.Oct 4, 1993 · N2765A · Substantial damageNTSB LAX94FA004Accident · 4 fatalField investigationFinal reportCessna 177RG · Petaluma, CAVFR flight by the pilot(s) into instrument meteorological conditions (IMC), and failure to maintain a proper altitude and/or clearance from terrain, while approaching the destination airport. Factors related to the accident were: the low ceiling and terrain.Oct 3, 1993 · N45022 · DestroyedNTSB LAX94LA002Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Fallon, NVwas the pilot's failure to maintain an adequate approach path to the runway and his inadequate altitude. Contributing factors were the pilot's delayed remedial action and his lack of recent experience in the airplane.Oct 2, 1993 · N4266V · Substantial damageNTSB ANC93LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Rocky River, AKThe pilot misjudging his altitude on final approach.Sep 26, 1993 · N3862Z · Substantial damageNTSB SEA93LA213Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Detroit Lake, ORFailure of a second stage turbine wheel too low for a successful autorotation. Factors include a tree in the approach path.Sep 24, 1993 · N70NW · Substantial damageNTSB MIA93LA199Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Deland, FLFailure of both pilots to maintain adequate visual lookout. Factors related to the accident were: the conflicting right traffic pattern procedures for landing that were briefed to the Boeing E75 pilot by the owner of the airstrip, and failure of both pilots…Sep 23, 1993 · N43320 · 2 aircraft · Substantial damage