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 CHI93FA302Accident · 5 fatalField investigationFinal reportRockwell 690-A · Norfolk, NEThe failure of the pilots of the Rockwell 690-A, N707BP, and the Piper PA-28R, N33056, to see and avoid each other. A factor which contributed to the accident was the failure of both pilot's to follow recommended communication procedures contained in the…Jul 30, 1993 · N707BP · 2 aircraft · DestroyedNTSB CHI93LA291Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Houghton, MIthe pilot-in-command not following instrument procedures by not using the correct altimeter setting as issued by Air Traffic Control.Jul 28, 1993 · N4518S · DestroyedNTSB CHI93LA287Accident · No injuriesLimited investigationFinal reportCessna T210M · Neosho, MOIs the pilot in command's failure to maintain proper clearance. Factors relating to this accident are the pilot in command's inadequate preflight preparation and the loss of total engine power as a result of fuel exhaustion.Jul 27, 1993 · N761DD · Substantial damageNTSB MIA93LA165Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31A · Columbus, MSThe pilot-in-command's improper decision to turn the fuel selector off prematurely during his attempted landing.Jul 26, 1993 · N39850 · Substantial damageNTSB LAX93FA300Accident · 6 fatalField investigationFinal reportCessna 310H · Lancaster, CAthe pilot's improper in-flight planning/decision and his failure to maintain the minimum control airspeed which progressed to an inadverent stall/spin. Factors relating to this accident were fuel exhaustion and the pilot's lack of experience in the accident…Jul 26, 1993 · N310HJ · DestroyedNTSB CHI93LA284Accident · No injuriesLimited investigationFinal reportCessna 177RG · Columbus, INthe pilot in command's failure to maintain proper clearance. A factor involved in this accident is the pilot in command's failure to maintain a proper glidepath.Jul 26, 1993 · N1850Q · Substantial damageNTSB MIA93FA163Accident · 3 fatalField investigationFinal reportBeech C23 · St Petersburg, FLFailure of the pilot to maintain adequate airspeed during the go-around, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's lack of familiarity with the airport, and his selection of the wrong runway.Jul 25, 1993 · N60093 · DestroyedNTSB LAX93LA363Accident · No injuriesLimited investigationFinal reportCessna 210A · Salinas, CAAn undetermined loss of engine power during the final approach phase of landing resulting in a collision with terrain during the forced landing.Jul 25, 1993 · N9520X · Substantial damageNTSB BFO93FA138Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clearfield, PAThe pilot's failure to maintain airspeed during the go-around.Jul 25, 1993 · N6697W · DestroyedNTSB SEA93LA158Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Troutdale, ORThe pilot's poor inflight decision, and fuel exhaustion. Factors include unfavorable winds, a dark night, and trees in the attempted landing area.Jul 24, 1993 · N30170 · Substantial damageNTSB LAX93LA298Accident · No injuriesLimited investigationFinal reportCessna 172 · Vacaville, CAThe pilot's improper in-flight planning/decision by failing to allow enough time for the rotor wash to dissipate before attempting the approach. The wake turbulence (rotor wash) was a factor in this accident.Jul 24, 1993 · N51409 · Substantial damageNTSB BFO93LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittsfield, MAThe failure of the pilot of the PA-28, N9044J, to properly tune his radios, and his failure to see and avoid the PA-38, N91357.Jul 24, 1993 · N9044J · 2 aircraft · Substantial damageNTSB LAX93LA294Accident · No injuriesLimited investigationFinal reportCessna 150L · Hanford, CAThe student pilot's failure to maintain aircraft control. Factors related to this accident were the pilot's poorly planned approach, failure to maintain the proper glide path, delay in raising the flaps, and the improper use of the carburetor heat.Jul 22, 1993 · N7457G · Substantial damageNTSB BFO93FA128Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-65 · Danbury, CTUndetermined.Jul 18, 1993 · N34009 · DestroyedNTSB CHI93LA259Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Vassar, MIThe pilot's inadequate compensation for the crosswind.Jul 15, 1993 · N2695Z · Substantial damageNTSB ATL93LA128Accident · Minor injuriesLimited investigationFinal reportBrown Glassair SH-2 · Timmonsville, SCThe pilot's inadequate fuel planning which resulted in the exhaustion of the fuel supply and the loss of engine power. A factor was the pilot's failure to comply with a manufacturer's service bulletin.Jul 14, 1993 · N412NV · Substantial damageNTSB SEA93LA157Accident · No injuriesLimited investigationFinal reportCessna 150L · Ontario, ORThe pilot in command's failure to maintain proper clearance. A factor contributing to the accident was the pilot in command's delayed go around.Jul 10, 1993 · N10050 · Substantial damageNTSB LAX93LA285Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Rialto, CALoss of engine power for undetermined reasons, and the flight instructor's improper flare during the autorotation which resulted in a tail boom strike.Jul 8, 1993 · N9588F · Substantial damageNTSB LAX93LA278Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Columbia, CAa loss of engine power for undetermined reasons.Jul 6, 1993 · N3837N · Substantial damageNTSB LAX93FA274Accident · 5 fatalField investigationFinal reportCessna T303 · Prescott, AZThe pilot misjudging distance and altitude during a night approach. Factors which contributed to the accident were: the pilot's impairment due to fatigue exacerbated by alcohol consumption, the dark night, and the high density altitude and turbulent weather…Jul 4, 1993 · N9667C · DestroyedNTSB FTW93LA204Accident · No injuriesLimited investigationFinal reportCessna 177B · Shawnee, OKFuel system exhaustion induced power loss for undetermined reasons. A factor was a lack of suitable terrain.Jul 4, 1993 · N18739 · Substantial damageNTSB CHI93LA243Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Mount Morris, ILThe pilot in command's failure to maintain adequate airspeed.Jul 4, 1993 · N6097G · Substantial damageNTSB BFO93LA108Accident · No injuriesLimited investigationFinal reportBurkhart Grob Speed Astir II · Chester, VTThe pilot's inadequate inflight planning and an in flight encounter with a downdraft while on final approach.Jul 4, 1993 · N164SS · DestroyedNTSB SEA93LA147Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Heber City, UTThe pilot's improper in-flight planning/decision and failure to maintain runway alignment during the go-around. The weather conditions were related factors.Jul 2, 1993 · N1379R · Substantial damageNTSB SEA93LA145Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31ATC · Jackson Hole, WYThe pilot's selection of an empty fuel tank, and fuel starvation. Factors include rough/uneven terrain.Jun 30, 1993 · N127WZ · Substantial damageNTSB LAX93LA269Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAA failure of the pilot to maintain directional control of the airplane during a go-around maneuver, subsequent improper remedial actions and an inadvertent stall. A factor in this accident was the pilot's lack of total aeronautical experience.Jun 29, 1993 · N714UW · Substantial damageNTSB FTW93LA199Accident · Serious injuriesLimited investigationFinal reportMaule MX-7-180 · Eufaula, OKThe pilots improper compensation for the wind conditions. A factor was the crosswindJun 29, 1993 · N4UM · Substantial damageNTSB CHI93LA240Accident · No injuriesLimited investigationFinal reportCessna R172K · Rice, MNThe pilot in command's failure to maintain proper clearance.Jun 29, 1993 · N758KQ · Substantial damageNTSB NYC93LA132Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Mitchellville, MDThe failure of the pilot to maintain a proper glide path during the final approach, which resulted in the airplane striking a moving vehicle.Jun 27, 1993 · N7563Y · Substantial damageNTSB LAX93LA266Accident · No injuriesLimited investigationFinal reportGlenn BD-4 · Somerton, AZThe second pilot's misjudgement of altitude and distance from the runway which resulted in an undershoot, and the pilot-in-command's inadequate supervision in not taking timely corrective action. In addition, neither pilot had any experience in the airplane,…Jun 26, 1993 · N2849 · Substantial damageNTSB CHI93LA230Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Ionia, MIThe pilot in command's failure to maintain the proper glidepath.Jun 26, 1993 · N4101M · Substantial damageNTSB ANC93LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · Nondalton, AKThe inadequate preflight preparation by the pilot-in-command. A factor in the accident was the encounter with unsuitable terrain during the emergency descent.Jun 24, 1993 · N23224 · Substantial damageNTSB NYC93LA130Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Beach City, OHThe pilot's failure to maintain adequate airspeed and his diverted attention which resulted in an inadvertent stall and inflight collision with the ground.Jun 20, 1993 · N71155 · Substantial damageNTSB DEN93LA071Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Watkins, COTotal loss of power resulting from a blocked carburetor fuel filter. A factor was: soft terrain encountered during the forced landing.Jun 20, 1993 · N2915E · Substantial damageNTSB NYC93LA122Accident · 1 fatalLimited investigationFinal reportSmitrvich Starduster SA-300A · Millville, NJThe pilot's inflight planning which resulted in fuel exhaustion. A factor was inadequate preflight planning.Jun 19, 1993 · N390BG · DestroyedNTSB LAX93LA259Accident · 1 fatalLimited investigationFinal reportRaymond Long EZ · Groveland, CAThe pilot's failure to maintain a proper glide path during final approach. A factor in the accident was sun glare in the pilot's line of vision.Jun 19, 1993 · N16LZ · Substantial damageNTSB CHI93LA213Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Birch Tree, MOThe pilot's failure to maintain aircraft control.Jun 18, 1993 · N8476G · Substantial damageNTSB NYC93LA112Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Kutztown, PAThe pilot's failure to maintain the proper glidepath and execute a proper flare. Lack of familiarity is a contributing factor.Jun 13, 1993 · N6795Z · Substantial damageNTSB NYC93LA111Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Woodstock, CTA complete loss of engine power for undetermined reasons.Jun 13, 1993 · N6158B · Substantial damageNTSB LAX93LA253Accident · No injuriesLimited investigationFinal reportCessna 152 · Tracy, CAThe failure of dual student to maintain an adequate airspeed during the go around initiation, and, the inadequate supervision of the flight by the instructor.Jun 13, 1993 · N6457L · Substantial damageNTSB CHI93LA207Accident · No injuriesLimited investigationFinal reportRobert L. Kennedy Avid Flyer · White Pigeon, MIThe pilot in command's inability to attain proper touch down point. The improperly adjusted idle setting which resulted in the loss of engine power was also a cause.Jun 13, 1993 · N138RK · Substantial damageNTSB ATL93LA110Accident · Serious injuriesLimited investigationFinal reportAerotek Zuni · Brownsboro, ALThe pilot's misjudgment of distance and altitude which resulted in the collision with trees short of the runway.Jun 12, 1993 · N12ZW · Substantial damageNTSB NYC93LA108Accident · Serious injuriesLimited investigationFinal reportMooney M20J · New Haven, CTThe loss of airplane control as a result of the pilot encountering spatial disorientation. Factors in this accident were the low ambient light conditions and the lack of runway end identifier lightsJun 9, 1993 · N1157B · Substantial damageNTSB NYC93LA100Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Cincinnati, OHThe pilot's improper inflight planning and decision resulting in fuel exhaustion, and the subsequent forced landing and collision with power lines.Jun 7, 1993 · N24938 · Substantial damageNTSB MIA93LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLPilot in command's failure to ensure the aircraft contained enough fuel to complete the flight resulting in the engine failing due to fuel exhaustion.Jun 5, 1993 · N215JA · Substantial damageNTSB LAX93FA241Accident · 3 fatalField investigationFinal reportLancair 320 · Chino, CAInadequate visual lookout by the pilot of the Lancair 320, N69WD, that precluded him from recognizing a collision hazard and taking action to avoid a midair collision with the Cessna 152, N80203. In addition, the local controller failed to advise the pilot of…Jun 5, 1993 · N69WD · 2 aircraft · DestroyedNTSB ATL93LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Ravenel, SCThe continuation of the landing attempt into the short sod field without the use of flaps and the use of excessive airspeed by the pilot. Factors in the accident were the failure of the aircraft flaps to extendJun 5, 1993 · N8279U · Substantial damageNTSB LAX93LA237Accident · Minor injuriesLimited investigationFinal reportSchmidt JURCA-MJ55 · Bakersfield, CALoss of engine power for undetermined reasons.Jun 2, 1993 · N5045 · Substantial damageNTSB ATL93LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Tuskegee, ALThe pilot's failure to establish a final approach course to the runway surface during a night landing. A factor was the inoperative aircraft landing light.Jun 2, 1993 · N64206 · Substantial damageNTSB CHI93LA186Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Derby, KSThe pilot in command's misjudged approach to landing.May 31, 1993 · N37139 · Substantial damage