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 LAX03LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · Early, TXThe student pilot's inadequate in-flight planning/decision, which resulted in a loss of engine power while on approach to land, and subsequent off-airport landing.Jun 8, 2003 · N78690 · Substantial damageNTSB CHI03LA152Accident · No injuriesLimited investigationFinal reportZimmerman Glastar · Pierce, NEThe pilot's operation of the airplane with known deficiencies in equipment and his selection of unsuitable terrain for landing. Factors contributing to this accident were the overtemperature of the engine cooling system, the long grass, and the collapse of…Jun 7, 2003 · N109BZ · Substantial damageNTSB ANC03LA055Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Anchorage, AKThe pilot's incorrect positioning of the fuel tank selector to a nearly empty tank, which resulted in a loss of engine power due to fuel starvation, and subsequent emergency landing at an off-airport site.Jun 7, 2003 · N343WB · Substantial damageNTSB ATL03LA101Accident · No injuriesLimited investigationFinal reportBeech 58P · Gatlinburg, TNThe pilot's misjudgment of altitude and distance to the runway during final approach, and his failure to attain the proper touchdown point for landing.Jun 2, 2003 · N60BR · Substantial damageNTSB LAX03LA165Accident · No injuriesLimited investigationFinal reportPZL-Bielsko SZD-50-3 · Minden, NVThe flight instructor's failure to adequately supervise the student, which resulted in the improper deployment of the spoilers by the student. A factor was the high vegetation on the landing surface.May 26, 2003 · N503HC · Substantial damageNTSB FTW03MA160Accident · No injuriesMajor investigationFinal reportBoeing 737-300 · Amarillo, TXthe flight crew's failure to align the airplane's ground track with the runway centerline before touchdown and the flight crew's failure to maintain directional control of the airplane after touchdown. Contributing to the accident was the flight crew's…May 25, 2003 · N343SW · Substantial damageNTSB MIA03LA112Accident · No injuriesLimited investigationFinal reportBeech C23 · Ormond Beach, FLThe pilot's inadequate preflight and his failure to refuel the airplane before departure resulting in the total loss of engine power due to fuel exhaustion and a hard landing during the subsequent forced landing.May 24, 2003 · N18936 · Substantial damageNTSB DEN03LA085Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · West Jordan, UTThe loss of power for undetermined reasons. Also causal was the student's failure to maintain aircraft control and the instructor's inadequate supervision. The instructor's delayed remedial action as a contributing factor.May 24, 2003 · N7176S · Substantial damageNTSB FTW03LA157Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Temple, TXThe total loss of engine power for an undetermined reason. Contributing factors were the night conditions and the lack of suitable terrain for the forced landing.May 20, 2003 · N6520G · Substantial damageNTSB FTW03TA156Accident · No injuriesFinal reportBell 407 · Franklin, LAThe loss of tail rotor effectiveness due to the inadequate maintenance performed by other company personnel.May 19, 2003 · N991SP · Substantial damageNTSB CHI03LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Blaney Park, MIThe pilot's failure to maintain clearance with the tree line. Factors contributing to this accident were the wind gusts and the trees.May 19, 2003 · N9181P · Substantial damageNTSB CHI03LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Freeport, ILThe pilot's misjudgment of distance and altitude, and his failure to maintain obstacle clearance.May 18, 2003 · N2842V · Substantial damageNTSB SEA03LA087Accident · No injuriesLimited investigationFinal reportCessna 210N · Lewistown, MTThe loss of engine power for undetermined reasons. The condition of the runway overrun was a factor.May 16, 2003 · N4804P · Substantial damageNTSB FTW03LA152Accident · No injuriesLimited investigationFinal reportCessna A188B · Fabens, TXThe pilot's failure to maintain terrain clearance. The pilot's attempt to avoid an obstacle was a contributing factor.May 16, 2003 · N478RD · Substantial damageNTSB NYC03LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gaithersburg, MDThe pilot’s failure to maintain airspeed, resulting in an inadvertent stall.May 15, 2003 · N1514X · Substantial damageNTSB CHI03LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-135 · Prescott, WIThe pilot delaying the go-around and the maneuver to avoid the treeline. Factors to the accident were the treeline and the airplane's low altitude.May 15, 2003 · N2581A · Substantial damageNTSB CHI03LA126Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cedar Springs, MIThe pilot's inadequate glidepath and his failure to maintain obstacle clearance. A factor to the accident was the semi-trailer.May 15, 2003 · N1528Q · Substantial damageNTSB CHI03LA125Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wilmot, WIThe loss of engine power for an undetermined reason, and the unsuitable terrain encountered for the forced landing. A factor was the fence.May 14, 2003 · N70971 · Substantial damageNTSB IAD03FA053Accident · 3 fatalField investigationFinal reportBeech 24R · Wauseon, OHThe pilots failure to maintain control during the approach-to-landing. Factors were the high wind gusts and turbulence, and the pilot's decision to fly in those conditions.May 11, 2003 · N4347W · Substantial damageNTSB NYC03LA102Accident · No injuriesLimited investigationFinal reportCessna 140 · Suffolk, VAThe pilot's misjudgment of his altitude from the wheat field during the execution of a go-around.May 9, 2003 · N72942 · Substantial damageNTSB NYC03LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Buffalo, NYThe pilot's failure to maintain sufficient airspeed to prevent an inadvertent stall. Factors were the variable and gusty winds.May 5, 2003 · N448VP · Substantial damageNTSB NYC03FA095Accident · 1 fatalField investigationFinal reportBeech A36 · Farmingdale, NJThe pilot's delayed decision to refuel, which resulted in fuel exhaustion and the subsequent loss of engine power.May 5, 2003 · N111TW · Substantial damageNTSB ATL03LA084Accident · No injuriesLimited investigationFinal reportBeech A23 · Brunswick, GAMaintenance personnel's failure to secure the fitting on a fuel line, which resulted in a loss of engine power.Apr 27, 2003 · N1483L · Substantial damageNTSB SEA03LA072Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Ephrata, WAThe pilot's failure to maintain aircraft control while on final approach for landing. Low airspeed was a factor.Apr 26, 2003 · N3839 · Substantial damageNTSB DEN03LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Colo. Springs, COthe student pilot's failure to obtain and maintain adequate altitude during the go-around. Factors contributing to the accident were the encountered windshear, the student pilot's premature raising of the flaps, the instructor pilot's inadequate supervision,…Apr 26, 2003 · N54202 · Substantial damageNTSB CHI03LA116Accident · No injuriesLimited investigationFinal reportWalker Lancair IV · Wamego, KSThe pilot not maintaining altitude/clearance from the runway while maneuvering on final approach. A factor to the accident was the pilot's misjudgment of his altitude while on final approach.Apr 26, 2003 · N7441W · Substantial damageNTSB ATL03FA082Accident · 1 fatalField investigationFinal reportSocata TBM 700B · Mobile, ALThe improper installation of the power control linkage on the engine fuel control unit by maintenance personnel which resulted in a loss of power lever control, and the pilot's failure to follow emergency procedures and his intentional engine shutdown which…Apr 25, 2003 · N705QD · Substantial damageNTSB NYC03LA087Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Waterford, PAThe pilot's inadequate visual lookout which resulted in the collision with the wire. Factors in the accident were the concealment of the poles by trees, the lack of contrast between the wire and grass field.Apr 20, 2003 · N7192M · Substantial damageNTSB SEA03LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Orofino, IDThe pilot's misjudgment of speed and distance resulting in a loss of airspeed, stall and undershoot of runway.Apr 19, 2003 · N6268W · Substantial damageNTSB IAD03LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Sterling, MAThe student pilot's misjudgment of his traffic pattern altitudes, which resulted in a premature descent into a tree.Apr 19, 2003 · N1241S · Substantial damageNTSB DEN03FA068Accident · 3 fatalField investigationFinal reportCessna 310D · Provo, UTfailure of the student to maintain aircraft control. Contributing factors were the instructor's inattention to the fuel supply, fuel exhaustion, an inadvertent stall/spin during the turn from base leg to final approach. and the instructor's inadequate…Apr 17, 2003 · N6861T · DestroyedNTSB CHI03IA108Incident · No injuriesIncident investigationFinal reportPiper PA-31T1 · Wheeling, ILThe pilot's failure to maintain obstacle clearance and the inadequate glidepath which resulted in a collision with a utility pole. Contributing factors were the lack of experience in the incident airplane by the left seat pilot, the visual illusion of a…Apr 17, 2003 · N855JL · Minor damageNTSB DEN03LA076Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Denver, COThe failure of the landing gear system and the flight crew's failure to ascertain that the landing gear was down and locked. A contributing factor was the inadequate maintenance inspections performed by maintenance personnel.Apr 16, 2003 · N229AM · Substantial damageNTSB MIA03CA095Accident · No injuriesData collectionFinal reportCessna 152 · Olive Branch, MSThe CFI's improper positioning of the fuel selector valve to the off position which resulted in fuel starvation and the subsequent loss of engine power.Apr 13, 2003 · N757AZ · Substantial damageNTSB IAD03FA045Accident · 1 fatalField investigationFinal reportBeech A36 · Pomona, NJThe pilot's failure to follow instrument approach procedures. Factors in the accident included the pilot's lack of recent instrument experience and the instrument weather conditions.Apr 11, 2003 · N256PR · DestroyedNTSB NYC03LA081Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-30 · Du Bois, PAThe captain's failure to maintain the proper glidepath during the instrument approach, and his failure to perform a go-around. Factors were a low ceiling and reduced visibility due to mist.Apr 9, 2003 · N805SW · Substantial damageNTSB NYC03FA080Accident · 3 fatalField investigationFinal reportDassault DA-20 · Swanton, OHThe flight instructor's inadequate supervision of the flight, including his failure to maintain an approach airspeed consistent with the airplane's configuration, which resulted in an aerodynamic stall due to slow airspeed, and subsequent uncontrolled descent…Apr 8, 2003 · N183GA · DestroyedNTSB NYC03FA079Accident · 2 fatalField investigationFinal reportRaytheon V35A · Delaware City, DEThe pilot's failure to maintain aircraft control. A factor in the accident was instrument meteorological conditions.Apr 8, 2003 · N7144N · Substantial damageNTSB CHI03FA099Accident · Serious injuriesField investigationFinal reportDassault DA-20C · St Louis, MOThe pilot in command's improper in-flight decision not to divert to an alternate destination resulting in the exhaustion of the airplane's fuel supply, and his failure to relay his low fuel state to air traffic control in a timely manner.Apr 8, 2003 · N179GA · DestroyedNTSB IAD03FA043Accident · 6 fatalField investigationFinal reportBeechcraft B200 · Leominster, MAThe pilot's low altitude maneuver using an excessive bank angle, and his failure to maintain airspeed which resulted in an inadvertent stall and subsequent collision with a building. A factor was the pilot's impairment from prescription medications.Apr 4, 2003 · N257CG · Substantial damageNTSB SEA03LA054Accident · No injuriesLimited investigationFinal reportCessna T210L · Gig Harbor, WAA total loss of power for undetermined reasons during base turn.Apr 2, 2003 · N701TM · Substantial damageNTSB ANC03LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKA loss of engine power for an undetermined reason. A contributing factor in the accident was the lack of suitable terrain for a forced landing.Mar 31, 2003 · N8106Y · Substantial damageNTSB SEA03LA052Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Mabton, WAA partial loss of power, for undetermined reasons, during a shallow approach, that ultimately lead to a situation where the pilot found it necessary to attempt a forced landing while the helicopter was moving slightly sideways. Factors include rough/uneven…Mar 30, 2003 · N2629Z · Substantial damageNTSB LAX03LA119Accident · No injuriesLimited investigationFinal reportEnstrom F280FX · San Carlos, CAFuel exhaustion due to the pilot's inadequate fuel consumption calculations and his inadequate in-flight planning decision. A factor was the low altitude from which the autorotation was attempted.Mar 29, 2003 · N5698M · Substantial damageNTSB NYC03FA067Accident · Serious injuriesField investigationFinal reportBoeing 717-200 · Flushing, NYA failure of the left power control distribution unit (PCDU).Mar 27, 2003 · N957AT · Minor damageNTSB CHI03LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · South Haven, MIThe inadequate fuel consumption calculations by the pilot and the fuel exhaustion. The inadequate traffic pattern distance from the runway, which precluded his reaching the runway.Mar 24, 2003 · N43456 · Substantial damageNTSB IAD03FA039Accident · 1 fatalField investigationFinal reportMooney M20R · Leesburg, VAThe pilot's failure to maintain control of the airplane while on final approach for undetermined reasons.Mar 21, 2003 · N1005P · DestroyedNTSB FTW03FA114Accident · 1 fatalField investigationFinal reportCessna 182S · Fayetteville, ARThe pilot's failure to fly a stabilized, published instrument approach procedure, which resulted in a collision with trees and terrain. Factors were the low clouds and night conditions.Mar 21, 2003 · N97TD · DestroyedNTSB DEN03LA053Accident · Minor injuriesLimited investigationFinal reportBeech E-90 · Kremmling, COthe pilot's improper in-flight planning and his failure to maintain safe clearance from the high terrain. Factors contributing to the accident were the high terrain and the dark night.Mar 20, 2003 · N711TZ · Substantial damageNTSB CHI03LA087Accident · No injuriesLimited investigationFinal reportAero Commander 500-B · Mankato, MNFuel exhaustion due to the pilot's inadequate preflight and not verifying the airplane had been refueled.Mar 20, 2003 · N553RA · Substantial damage