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 NYC04LA057Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Bradford, PAA total loss of engine power for undetermined reasons during approach.Jan 10, 2004 · N1XF · Substantial damageNTSB LAX04LA087Accident · No injuriesLimited investigationFinal reportCessna 421C · Window Rock, AZthe pilot's failure to maintain adequate airspeed in the landing flare to compensate for airframe icing, which resulted in a premature stall and hard landing. The degraded aircraft performance due to airframe ice was a contributing factor.Jan 3, 2004 · N911EA · Substantial damageNTSB LAX04CA086Accident · No injuriesData collectionFinal reportCessna 172F · Redlands, CAthe pilot's inadequate compensation for the existing gusty crosswind condition, and his failure to maintain directional control. Contributing factors were a crosswind and wind gusts.Jan 3, 2004 · N5184F · Substantial damageNTSB FTW04FA054Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Beaumont, TXThe flight instructor's failure to maintain clearance with a static line. Contributing factors were the low cloud ceiling weather conditions and night light conditions.Jan 3, 2004 · N396HP · DestroyedNTSB CHI04LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Fishers, INThe pilot not maintaining altitude/clearance from the trees during the circling approach, his continued descent below minimum descent altitude, and the pilot not performing a missed approach. A factor was the trees the pilot impacted during the circling…Jan 2, 2004 · N21992 · Substantial damageNTSB LAX04LA083Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Rialto, CAThe pilot's inadequate in-flight planning/decision by his fuel mismanagement and his delay in initiating remedial action which resulted in fuel exhaustion and the loss of engine power.Dec 30, 2003 · N6539X · Substantial damageNTSB ATL04LA064Accident · 1 fatalLimited investigationFinal reportAtkinson SA 102.5 · Trenton, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent in-flight collision with terrain.Dec 28, 2003 · N8117L · DestroyedNTSB ANC04FA016Accident · 4 fatalField investigationFinal reportPiper J3C-65 · Peoria, AZThe inadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid each other's aircraft and a subsequent midair collision. A factor associated with the accident was the airplane pilot's failure to determine that…Dec 28, 2003 · N2094M · 2 aircraft · DestroyedNTSB SEA04LA030Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Elk City, IDThe pilot's failure to maintain clearance from trees during a go-around. Factors include dark night conditions and trees.Dec 26, 2003 · N1363U · Substantial damageNTSB LAX04FA077Accident · 5 fatalField investigationFinal reportPiper PA-34-200T · Avalon, CAThe failure of both pilots to properly execute the published missed approach procedure.Dec 24, 2003 · N3747U · DestroyedNTSB CHI04LA046Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · St. Paul, MNThe failure of the worm drive bearing that resulted in the failure of the landing gear extension/retraction gearbox, which ultimately resulted in the extension of the landing gear not being possible. A factor to the accident was the airport sign that the…Dec 22, 2003 · N221Q · Substantial damageNTSB NYC04CA049Accident · No injuriesData collectionFinal reportBell B407 · Morehead, KYThe ground personnel's failure to identify the hazardous condition. Factors were blowing snow and night conditions.Dec 21, 2003 · N508MT · Substantial damageNTSB FTW04LA047Accident · No injuriesLimited investigationFinal reportCessna T210N · Marfa, TXThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.Dec 21, 2003 · N4689Y · Substantial damageNTSB FTW04FA045Accident · 2 fatalField investigationFinal reportCessna 172K · Grand Saline, TXThe pilot's failure to maintain control of the airplane while on final approach. Factors were the high winds and prevailing crosswind.Dec 21, 2003 · N78189 · Substantial damageNTSB FTW04LA046Accident · No injuriesLimited investigationFinal reportBell 206B · Henryetta, OKThe pilot's inadequate visual look out and failure to maintain clearance from guy wire while maneuvering for landing.Dec 20, 2003 · N62HF · Substantial damageNTSB LAX04LA069Accident · Serious injuriesLimited investigationFinal reportAllison KR-2 · Glendale, AZloss of engine power due to a loose carburetor jet. A contributing factor was the owner/operators failure to have a condition inspection performed on the aircraft.Dec 16, 2003 · N82KR · Substantial damageNTSB LAX04FA066Accident · 1 fatalField investigationFinal reportCessna 421C · Claremont, CAthe pilot became lost/disoriented during the approach, failed to maintain course alignment with the missed approach procedure, and subsequently lost control of the airplane.Dec 15, 2003 · N6887L · DestroyedNTSB FTW04FA037Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Sugar Land, TXThe pilots failure to maintain clearance with powerlines during a VFR approach. Contributing factors were the prevailing dark night conditions,and the high winds.Dec 10, 2003 · N47413 · DestroyedNTSB FTW04FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Livingston, TXThe pilot's failure to compensate for the wind conditions and maintain control of the airplane during the final approach. Contributing factors were the gusty and high wind conditions.Dec 9, 2003 · N98287 · DestroyedNTSB ANC04LA013Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Anchorage, AKThe pilot's misjudged altitude during final approach, which resulted in an undershot landing, and subsequent nose over.Dec 8, 2003 · N44047 · Substantial damageNTSB ATL04FA046Accident · 1 fatalField investigationFinal reportAeronca 11AC · San Antonio, FLThe pilot's failure to maintain clearance above objects on approach, which resulted in an in-flight collision with trees and the subsequent collision with terrain.Dec 5, 2003 · N9085F · Substantial damageNTSB ATL04FA045Accident · 2 fatalField investigationFinal reportBeech B200 · Morlan, GAThe pilot's inadequate in-flight planning/decision when he continued the flight below the decision height and collided with trees. A related factor was the low ceiling.Dec 5, 2003 · N85BK · DestroyedNTSB LAX04LA055Accident · Minor injuriesLimited investigationFinal reportGoodyear GZ-20A · Gardena, CAThe pilot's delayed go-around during final approach to land, which resulted in an in-flight collision with a fence. A factor associated with the accident is the pilot's failure to maintain adequate altitude/clearance from obstructions.Dec 4, 2003 · N10A · Substantial damageNTSB FTW04FA036Accident · 2 fatalField investigationFinal reportBeech S35 · Harrison, ARThe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall. Contributing factors were the pilot's failure to follow the published instrument approach procedures, and his failure attain the proper glidepath.Dec 4, 2003 · N350JL · DestroyedNTSB CHI04LA039Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe loss of engine power for undetermined reasons. A factor to the accident was the tree line and the unsuitable terrain.Dec 3, 2003 · N65455 · Substantial damageNTSB ATL04LA044Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Birmingham, ALA loss of engine power due to the throttle/power lever cable becoming disconnected in-flight, as a result of maintenance personnel failure to comply with Airworthiness Directive (AD) 86-24-07 and Cessna information letter SE79-6.Dec 3, 2003 · N3056Q · Substantial damageNTSB NYC04LA041Accident · Minor injuriesLimited investigationFinal reportRussell Cozy MK III · Holbrook, NYThe pilot's improper fuel management, which resulted in fuel starvation and subsequent loss of engine power.Dec 2, 2003 · N238CZ · Substantial damageNTSB FTW04LA031Accident · No injuriesLimited investigationFinal reportCessna 310-H · Oklahoma City, OKThe pilot's mismanagement of the fuel by which he failed to position the fuel selector on the appropriate fuel tanks resulting in fuel starvation. A contributing factor was the pilot's diverted attention.Dec 2, 2003 · N815M · Substantial damageNTSB DEN04LA025Accident · No injuriesLimited investigationFinal reportCessna T210K · Deming, NMThe pilot's improper in-flight planning and decision. Factors contributing to the accident were fuel exhaustion and the fence.Nov 30, 2003 · N81PC · Substantial damageNTSB SEA04FA023Accident · 1 fatalField investigationFinal reportFairchild Swearingen SA227-AT · Spokane, WAThe pilot-in-command's failure to maintain proper glidepath alignment during an ILS approach in poor weather resulting in collision with trees and terrain. Contributing factors were the unreliable status of the primary (NAV 1) ILS receiver (leaving the pilot…Nov 29, 2003 · N439AF · DestroyedNTSB DEN04IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-3M8 · Denver, COThe restricted movement of the flight control yoke and tiller wheel steering for reasons undetermined.Nov 29, 2003 · N303FL · No damageNTSB ANC04LA010Accident · No injuriesLimited investigationFinal reportdeHAVILLAND DHC-2 · Kodiak, AKThe pilot's inadequate evaluation of the weather conditions, and his failure to maintain adequate altitude/clearance, which resulted in a collision with terrain during the final landing approach. A factor contributing to the accident was the presence of a…Nov 29, 2003 · N13VF · Substantial damageNTSB MIA04FA029Accident · 1 fatalField investigationFinal reportSwearingen SA-26-AT · Jacksonville, FLThe pilot's descent below decision height while performing an ILS approach with low ceilings and fog, resulting in an in-flight collision with trees and the ground. A factor associated with the accident was the pilot's decision to attempt the instrument…Nov 27, 2003 · N698X · Substantial damageNTSB LAX04LA053Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fountain Hills, AZThe flight instructor's delayed remedial action and inadequate altitude during a go-around following a simulated forced landing, which resulted in an in-flight collision with terrain.Nov 24, 2003 · N97056 · Substantial damageNTSB ANC04LA009Accident · No injuriesLimited investigationFinal reportBeech 1900C · Juneau, AKThe pilot's failure to maintain altitude/clearance from obstacles when approaching the airport, which resulted in an in-flight collision with a tree. Factors associated with the accident were the dark night, snow showers, and the pilot's failure to maintain…Nov 24, 2003 · N112AX · Substantial damageNTSB ATL04LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Columbia, SCThe pilot's mismanagement of the fuel supply, and his inadequate preflight planning which resulted in fuel exhaustion.Nov 22, 2003 · N5041T · Substantial damageNTSB FTW04FA024Accident · Serious injuriesField investigationFinal reportCessna 550 · Mineral Wells, TXThe pilot-in-command's failure to maintain control of the airplane while executing a simulated engine failure on final approach. A factor was the windshear.Nov 18, 2003 · N418MA · DestroyedNTSB ATL04LA036Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Suches, GAThe pilot's failure to maintain airspeed during a go-round that resulted in an inadvertent stall and the subsequent collision with trees.Nov 15, 2003 · N2521D · Substantial damageNTSB CHI04LA033Accident · No injuriesLimited investigationFinal reportSaab-Scania Saab 340B · Minneapolis, MNThe in-flight collision with geese during approach. The contributing factor was the bright night conditionsNov 13, 2003 · N442XJ · Substantial damageNTSB ANC04LA011Accident · No injuriesLimited investigationFinal reportCessna 402 · Galena, AKWater contamination and freezing of the landing gear actuator that prevented the extension of the right main landing gear, resulting in a gear-up landing. Factors contributing to the accident were freezing temperatures at the accident location, and inadequate…Nov 13, 2003 · N402ET · Substantial damageNTSB NYC04LA029Accident · No injuriesLimited investigationFinal reportWalters Kolb Mark III · Ashtabula, OHA power loss for undetermined reason(s).Nov 9, 2003 · N456GW · Substantial damageNTSB SEA04LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Kapowsin, WAThe loss of engine power for undetermined reasons. A contributing factor to the accident was the trees.Nov 8, 2003 · N2106G · Substantial damageNTSB NYC04LA027Accident · No injuriesLimited investigationFinal reportBeech M35 · Bellefonte, PAA total loss of engine power during approach for undetermined reasons.Nov 7, 2003 · N9730R · Substantial damageNTSB CHI04FA025Accident · 1 fatalField investigationFinal reportCommander 114TC · Hutchinson, KSThe pilot's diverted attention during the missed approach which resulted in aircraft control not being maintained. Factors to the accident included the pilot not being current for instrument operations and the low cloud ceiling at night.Nov 3, 2003 · N6107Z · DestroyedNTSB NYC04CA022Accident · No injuriesData collectionFinal reportCessna 182M · Laytonsville, MDThe pilot's abrupt evasive maneuver to avoid the deer, which resulted in the loss of airspeed and an inadvertent stall.Nov 1, 2003 · N70800 · Substantial damageNTSB CHI04LA026Accident · 1 fatalLimited investigationFinal reportMaster Donald C BD5B · Traverse City, MIThe pilot in command not maintaining control of the aircraft during the final approach.Nov 1, 2003 · N515KH · DestroyedNTSB DEN04LA018Accident · No injuriesLimited investigationFinal reportCessna 182A · Albuquerque, NMthe pilot's delayed use of carburetor heat and his inadequate flare resulting in a loss of engine power and a hard landing. Also causal was the inadequate supervision of the flight. Carburetor icing conditions was a contributing factor.Oct 31, 2003 · N5127D · DestroyedNTSB DEN04MA015Accident · 1 fatalMajor investigationFinal reportCessna 208B · Cody, WYthe pilot's failure to maintain aircraft control. Contributing factors include the pilot's failure to divert to an alternate airport, an inadvertent stall, and the snow and icing conditions.Oct 29, 2003 · N791FE · Substantial damageNTSB SEA04LA013Accident · No injuriesLimited investigationFinal reportCessna 172M · Bandon, ORThe pilot's failure to maintain clearance from objects while on final approach. Dark night conditions, trees and a low glidepath were factors.Oct 28, 2003 · N80628 · Substantial damageNTSB ATL04FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Spartanburg, SCThe pilot's failure to follow IFR procedures and descent below the glide path, which resulted in an inflight collision with trees during an instrument approach. A factor was the pilot's impairment due to the sedating effects of medication.Oct 27, 2003 · N7799Y · Destroyed