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 LAX03CA266Accident · No injuriesData collectionFinal reportCessna 172M · Riverside, CAThe student pilot's misjudged distance and altitude, and the instructor's inadequate supervision of the flight. Also causal was the instructor's delayed remedial action.Aug 24, 2003 · N64291 · Substantial damageNTSB LAX03LA260Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Saint Johns, AZThe failure of the exhaust valve on the number two engine cylinder, which resulted in a partial loss of engine power during the final approach to land, and an on ground collision with a ditch during the subsequent off-airport landing roll.Aug 22, 2003 · N3182H · Substantial damageNTSB MIA03FA167Accident · 2 fatalField investigationFinal reportPiper PA-31 · Clearwater, FLThe failure of the flightcrew to maintain airspeed (Vs) resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with the ground.Aug 21, 2003 · N93DC · DestroyedNTSB CHI03LA274Accident · No injuriesLimited investigationFinal reportBoeing A-75 · La Crosse, WIThe total loss of engine power due to a fatigue fracture of the engine's crankshaft. A factor was the corn crop.Aug 20, 2003 · N806RB · Substantial damageNTSB NYC03CA179Accident · No injuriesData collectionFinal reportCessna 172RG · Glens Falls, NYThe pilot's failure to maintain control during the flare/touchdown, which resulted in a hard landing. Factors in this accident were wind gusts and the pilot's improper decision to land during thunderstorm activity.Aug 16, 2003 · N9673B · Substantial damageNTSB LAX03LA256Accident · No injuriesLimited investigationFinal reportCessna 150G · Angwin, CAThe pilot's failure to maintain control of the airplane during an attempted go-around, which resulted in a hard landing. Also causal was the pilot's failure to maintain directional control.Aug 12, 2003 · N8515J · Substantial damageNTSB IAD03FA070Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Factoryville, PAThe pilot's improper in-flight decision to descend below the published minimum descent altitude while executing a non-precision approach in instrument meteorological conditions, which resulted in collision with trees. A factor was the fog.Aug 8, 2003 · N6373C · DestroyedNTSB CHI03LA249Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Brookings, SDThe inadequate fuel supply for the flight, and the inadequate preflight by the pilot resulting in exhaustion of the fuel supply and subsequent loss of engine power. The tree was a contributing factor.Aug 7, 2003 · N9272K · Substantial damageNTSB NYC03FA176Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Pleasantville, PAThe pilot's improper IFR procedure by his failure to maintain published altitudes, which resulted in the in-flight collision with terrain. A factor was his impairment due to prescription medication.Aug 6, 2003 · N28788 · Substantial damageNTSB LAX03LA251Accident · Serious injuriesLimited investigationFinal reportBeech 77 · French Valley, CAThe pilot's attempted low altitude flight maneuver during a go-around, which resulted in his loss of control of the airplane and subsequent in-flight collision with terrain.Aug 1, 2003 · N972V · Substantial damageNTSB ATL03LA121Accident · Minor injuriesLimited investigationFinal reportLancair 235 · Fort Payne, ALThe pilot's failure to properly reconnect the mixture control cable resulting in a total loss of engine power, and subsequent in-flight collision with the trees.Jul 30, 2003 · N7156W · Substantial damageNTSB LAX03GA244Accident · 2 fatalFinal reportBell 206L-3 · Whiteriver, AZThe pilot's failure to maintain a minimum translational lift airspeed while maneuvering in high density altitude conditions at near maximum required torque and above the in ground effect hover altitude, that resulted in a loss of tail rotor effectiveness and…Jul 26, 2003 · N6184D · DestroyedNTSB NYC03LA165Accident · No injuriesLimited investigationFinal reportBeltram Glasair-TD · London, KYThe pilot's failure to follow published procedures, which resulted in fuel starvation during approach.Jul 25, 2003 · N22VB · Substantial damageNTSB SEA03LA151Accident · No injuriesLimited investigationFinal reportHughes 269C · Snohomish, WAThe dual students failure to maintain clearance from the terrain during the go-around from a simulated autorotational flare, and the instructor pilot's failure to take adequate remedial action to keep the dual student from allowing the aircraft to impact the…Jul 24, 2003 · N53KF · Substantial damageNTSB CHI03LA230Accident · No injuriesLimited investigationFinal reportMurch Rotec Rally 3 · Searcy, ARThe frayed rudder cable that failed during the turn to final. A factor was the ditch the airplane encountered during the forced landing.Jul 24, 2003 · N317RE · Substantial damageNTSB CHI03LA224Accident · Serious injuriesLimited investigationFinal reportAerostar S81A · Highland, MIFailure of the pilot to maintain a proper descent rate. Contributing factors were the pilot's failure to maintain clearance from the trees, the reported high winds and gusts, the trees, the power lines and the house.Jul 23, 2003 · N11BQ · No damageNTSB CHI03LA221Accident · Minor injuriesLimited investigationFinal reportNavion L-17A · Canton, ILA complete loss of engine power during landing approach for undetermined reasons, as well as the unsuitable terrain for a forced landing encountered by the pilot. Contributing factors were the berm and the crops.Jul 22, 2003 · N2968C · Substantial damageNTSB SEA03LA152Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hermiston, ORThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power. Rocky terrain was a factor.Jul 21, 2003 · N4250X · Substantial damageNTSB NYC03LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Sandusky, OHThe pilot's failure to maintain the engine mixture control during the go-around, which resulted in a loss of power, and in-flight collision with trees.Jul 20, 2003 · N8199D · Substantial damageNTSB MIA03LA189Accident · No injuriesLimited investigationFinal reportCessna 182P · Tampa, FLThe pilot's failure to attain the proper touchdown point which resulted in an undershoot.Jul 18, 2003 · N9913E · Substantial damageNTSB FTW03LA189Accident · Serious injuriesLimited investigationFinal reportBeech 35-A33 · Fort Worth, TXThe loss of engine power due to the pilot's improper use of the mixture control. Contributing factors were the pilot's failure to select the battery/alternator circuit, resulting in a loss of battery power, the pilot's failure to follow a checklist and the…Jul 18, 2003 · N44CN · Substantial damageNTSB SEA03LA141Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Newman Lake, WAThe pilot's failure to maintain clearance from an object while on final approach for landing. Trees and inadequate visual lookout were factors.Jul 17, 2003 · N16GL · Substantial damageNTSB SEA03LA134Accident · No injuriesLimited investigationFinal reportArcher S-18T · Arlington, WAThe pilot's failure to maintain an airspeed above Vs (stalling speed) while making a close-in base-to-final turn.Jul 11, 2003 · N102PM · Substantial damageNTSB SEA03LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stuart Island, WAThe pilot's failure to maintain clearance while maneuvering to land. Contributing factors included the tree and the sunglare condition.Jul 10, 2003 · N125ER · Substantial damageNTSB DEN03LA129Accident · Minor injuriesLimited investigationFinal reportDavis Zenair Stol 701 · Aurora, COthe pilot's failure to attain adequate airspeed and establish a climb resulting in a stall/mush and collision with the ground. Contributing factors were his premature turn onto the downwind leg, and the plowed/furrowed terrain.Jul 10, 2003 · N20584 · Substantial damageNTSB DEN03FA125Accident · 2 fatalField investigationFinal reportCASA 2.111 · Cheyenne, WYA loss of engine power for reasons undetermined, and the pilot's failure to maintain aircraft control. Contributing factors were the unsuitable terrain on which to make a forced landing, low airspeed, the fence, automobile, and the school bus wash barn.Jul 10, 2003 · N72615 · DestroyedNTSB DEN03LA124Accident · No injuriesLimited investigationFinal reportPZL Wilga 104-80 · Santa Fe, NMthe pilot's failure to maintain airspeed which resulted in a stall.Jul 8, 2003 · N214AL · Substantial damageNTSB ANC03LA068Accident · No injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's misjudged distance and altitude during an approach to land at an off-airport landing site, which resulted in an undershoot, and subsequent in-flight collision with terrain.Jul 6, 2003 · N63DJ · Substantial damageNTSB NYC03LA150Accident · Minor injuriesLimited investigationFinal reportGrumman American AA5B · Block Island, RIThe pilot's failure to maintain directional control while landing, after a loss of engine power as reported by the pilot. Factors in this accident were the pilot's improper flare, which resulted in a hard landing, and the crosswind condition.Jul 5, 2003 · N1966L · Substantial damageNTSB SEA03LA127Accident · Minor injuriesLimited investigationFinal reportLockheed 402-2 · Headquarters, IDThe pilot's improper preflight planning and improper fuel consumption calculations. Factors contributing to the accident included the unfavorable wind condition, the downdraft, and the trees.Jul 4, 2003 · N3380G · Substantial damageNTSB CHI03LA197Accident · No injuriesLimited investigationFinal reportCessna 175 · Wessington Spri, SDThe pilot not obtaining/maintaining clearance from the barbed wire fence during the go-around. Factors to the accident were the fence, and the brush.Jul 4, 2003 · N7256M · DestroyedNTSB ATL03FA115Accident · 2 fatalField investigationFinal reportBeech 58P · Memphis, TNAn encounter with wake turbulence on approach, which resulted in the pilot's inability to maintain control and subsequent in-flight collision with the ground.Jul 2, 2003 · N36TL · Substantial damageNTSB LAX03CA220Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Chandler, AZThe student's failure to maintain adequate main rotor rpm and his failure to relinquish the controls.Jul 1, 2003 · N7508E · Substantial damageNTSB LAX03LA218Accident · No injuriesLimited investigationFinal reportCessna 210 · Henderson, NVA bolt in the fuel selector that restricted the flow of fuel to the engine, which resulted in fuel starvation and a partial loss of engine power during the final approach to land.Jun 30, 2003 · N9544T · Substantial damageNTSB DEN03LA118Accident · Minor injuriesLimited investigationFinal reportCessna 210K · Durango, COthe pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the high altitude on base turn and final approach, the low airspeed, the pilot's improper use of flaps, the inadvertent…Jun 29, 2003 · N8264M · Substantial damageNTSB LAX03CA215Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Prescott, AZThe pilot's failure to maintain adequate main rotor rpm, and, his improper use of the collective, throttle, and anti-torque controls during the attempted recovery. Factors in the accident were the pilot's failure to completely relinquish the controls, and the…Jun 28, 2003 · N332MD · Substantial damageNTSB ANC03LA062Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-226T · Goodnews, AKThe flight crew's inadequate evaluation of the weather conditions, which resulted in their inadequate compensation for the wind conditions, and subsequent undershoot. A contributing factor in the accident was a downdraft.Jun 28, 2003 · N512FS · Substantial damageNTSB IAD03CA061Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Nashua, NHThe pilot's failure to determine the wind direction, which resulted in a hard, tailwind landing.Jun 27, 2003 · N185MH · Substantial damageNTSB SEA03LA118Accident · 1 fatalLimited investigationFinal reportHerrin Hornet · Newberg, ORAircraft control not maintained while maneuvering for landing.Jun 26, 2003 · N1424 · Substantial damageNTSB MIA03FA135Accident · 2 fatalField investigationFinal reportCessna 414 · N. Fort Myers, FLThe failure of the pilot to maintain airspeed (Vs) following a total loss of engine power from the right engine due to fuel starvation, resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with trees and terrain. Factors in the…Jun 26, 2003 · N749AA · Substantial damageNTSB NYC03LA142Accident · No injuriesLimited investigationFinal reportBeech 24 · Rome, NYThe pilot's failure to maintain directional control during a go-around which resulted in the airplane impacting trees. A factor in the accident was the shifting wind.Jun 25, 2003 · N1485L · Substantial damageNTSB DEN03FA111Accident · 1 fatalField investigationFinal reportHammond Vans RV-6A · La Junta, COthe pilot's failure to maintain airspeed resulting in a stall during the turn from base leg to final approach.Jun 24, 2003 · N199LH · DestroyedNTSB CHI03LA180Accident · No injuriesLimited investigationFinal reportCessna 170B · Widener, ARThe pilot's failure to maintain clearance from the wires and his failure to maintain adequate airspeed, resulting in a stall. A factor contributing to the accident was the unmarked wires.Jun 24, 2003 · N4478B · Substantial damageNTSB CHI03LA175Accident · No injuriesLimited investigationFinal reportCessna 210M · Carlisle, ARThe pilot's improper in-flight decision to descend for landing, at night, without the runway environment insight. Contributing factors were the pilot's disorientation, the embankment and the dark night condition.Jun 23, 2003 · N9TK · Substantial damageNTSB LAX03CA208Accident · No injuriesData collectionFinal reportCessna 172K · Overton, NVthe student pilot's failure to maintain an adequate airspeed and his premature raising of the flaps during a go-around, which led to an inadvertent stall/mush. The flight instructor's inadequate supervision of the flight is also causal.Jun 22, 2003 · N7342G · Substantial damageNTSB ATL03FA111Accident · 3 fatalField investigationFinal reportMaule M-5-235C · Rockvale, TNLoss of engine power for undetermined reasons.Jun 22, 2003 · N555MR · Substantial damageNTSB SEA03FA110Accident · 1 fatalField investigationFinal reportHarshbarger W/Reed RV-8 · Grants Pass, ORCorrosion and contamination within the fuel servo unit and the pilot's delayed turn back to the runway. Contributing factors were trees and the pilot's impairment due to prescription medication.Jun 20, 2003 · N863Y · Substantial damageNTSB ATL03LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Mill, SCThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power.Jun 18, 2003 · N685BW · Substantial damageNTSB SEA03CA102Accident · No injuriesData collectionFinal reportPiper PA-18 · Silver City, MTProper descent rate not maintained while on final approach. A wind gust is a factor in the accident.Jun 14, 2003 · N82946 · Substantial damageNTSB LAX03LA192Accident · 1 fatalLimited investigationFinal reportArgus CA-7 · Angleton, TXthe pilot's loss of lateral aircraft control. Also causal was the pilot's intentional flight with an asymmetrical fuel loading, and his improper use of the fuel system. A factor in the accident was the insufficient information provided by the kit manufacturer…Jun 11, 2003 · N9043L · Destroyed