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 NYC04LA016Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Swanton, OHThe pilot's improper fuel tank selection, which resulted in fuel starvation, and subsequent loss of engine power.Oct 26, 2003 · N5452V · Substantial damageNTSB MIA04LA012Accident · No injuriesLimited investigationFinal reportHeadburg RV6 · Wellington, FLthe failure of the dual student pilot to maintain airspeed, and the CFI to properly supervise the dual student, which resulted in an inadvertent stall, and subsequent impact with an embankment, during a simulated loss of engine power.Oct 26, 2003 · N331JH · Substantial damageNTSB LAX04LA028Accident · No injuriesLimited investigationFinal reportMooney M20K · San Diego, CAthe pilot's failure to configure the airplane properly for the go-around which resulted in degraded climb performance, and his failure to maintain adequate airspeed which resulted in a stall. The tailwind was a contributing factor.Oct 26, 2003 · N1147N · DestroyedNTSB LAX04LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Pacoima, CAthe pilot's failure to maintain an adequate glide path on final approach and his failure to ensure adequate clearance from obstacles. The dark night was a factor.Oct 25, 2003 · N15192 · Substantial damageNTSB MIA04LA011Accident · Serious injuriesLimited investigationFinal reportLet NP Kinovice Z37A · Oak Hill, FLThe pilots failure to maintain airspeed while maneuvering to re-enter the pattern resulting in an inadvertent stall and impact with trees and the ground during the subsequent uncontrolled descent.Oct 24, 2003 · N137MS · Substantial damageNTSB CHI04IA018Incident · No injuriesIncident investigationFinal reportEnstrom F-28C · Lapeer, MIComplete failure of the right anti-torque cable while on final approach for landing. A factor was the diminished tail rotor control resulting from the broken cable.Oct 22, 2003 · N77HX · Minor damageNTSB NYC04LA014Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Athol, MAThe loss of power due to disengagement of the magneto idler gear. Also causal was the improper reinstallation of the magneto during the annual inspection.Oct 21, 2003 · N3419S · Substantial damageNTSB LAX04FA019Accident · 2 fatalField investigationFinal reportBeech 35-C33 · Mesquite, NVfuel starvation due to the pilot's inadequate in-flight planning and fuel system management, and failure to select a fuel tank containing fuel. Also causal was the certified flight instructor's inadequate supervision.Oct 19, 2003 · N9438S · DestroyedNTSB SEA04LA008Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Spanaway, WAThe pilot's misjudgment of distance and altitude resulting in an undershoot of the runway and collision with a fence. A fence was a factor in the accident.Oct 18, 2003 · N1806K · Substantial damageNTSB LAX04TA017Accident · No injuriesFinal reportMD Helicopter 900 · Fredonia, AZthe pilot's in-flight loss of control due to the fatigue fracture and separation of the force limiting control rod (an integral part of the anti-torque system), which resulted in the helicopter's uncommanded yaw/spin and subsequent collision with terrain.Oct 16, 2003 · N179PA · Substantial damageNTSB CHI04LA014Accident · No injuriesLimited investigationFinal reportCroke Zenith CH 701 · Brussels, WIA partial loss of engine power for undetermined reasons.Oct 16, 2003 · N701US · Substantial damageNTSB LAX04TA018Accident · No injuriesFinal reportBell UH-1H · Sacramento, CAThe loss of engine power due to the fatigue failure of a planetary reduction gear.Oct 15, 2003 · N114FD · Substantial damageNTSB FTW04LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Manvel, TXThe pilot's failure to maintain airspeed during the attempted go-around resulting in an inadvertent stall. A contributing factor was the pilot's failure to maintain directional control during the crosswind landing.Oct 15, 2003 · N3760R · Substantial damageNTSB NYC04LA007Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Cheswold, DEThe pilot's failure to maintain a proper glide path to the runway, and his failure to maintain obstacle clearance which resulted in an in-flight collision with an unlit utility pole. Factors related to the accident were the unlit utility pole, and the dark…Oct 12, 2003 · N5320L · Substantial damageNTSB DEN04LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Las Cruces, NMthe CFI's failure to maintain aircraft control during a go-around resulting in an inadvertent stall/mush and impact with terrain. Contributing factors include the CFI's inadequate supervision, the private pilot's delayed relinquishing of control, and the…Oct 12, 2003 · N891GP · Substantial damageNTSB DEN04LA007Accident · No injuriesLimited investigationFinal reportAviat Pitts S2B · Santa Teresa, NMthe instructor's improper in-flight planning/decision making and fuel mismanagement which resulted in fuel starvation/exhaustion, the loss of engine power and the subsequent forced landing. Contributing factors include the instructor's inadequate preflight…Oct 11, 2003 · N331DM · Substantial damageNTSB NYC04CA009Accident · No injuriesData collectionFinal reportCessna 182C · Clarence Center, NYThe pilot's delayed go-around decision. A factor in this accident was the night light condition.Oct 10, 2003 · N8511T · Substantial damageNTSB CHI04LA008Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Harvard, ILThe pilot misjudged his altitude and distance from the approach end of the airstrip, along with his decision to land at an unlit airstrip at night. Factors involved in the accident were the the night lighting conditions, the unlit airstrip, and the corn crop…Oct 10, 2003 · N3848H · Substantial damageNTSB FTW04FA006Accident · Serious injuriesField investigationFinal reportTwin Commander Acft. 680FL · Harrison, ARThe loss of power to both engines due to fuel starvation as a result of the pilot's failure to complete the landing checklist while on final approach. A factor contributing to the accident was the lack of suitable terrain for the forced landing.Oct 8, 2003 · N680WS · DestroyedNTSB ATL04LA003Accident · 1 fatalLimited investigationFinal reportWhitty Mustang II · Holly Ridge, NCThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed while maneuvering for a forced landing.Oct 3, 2003 · N888PW · Substantial damageNTSB LAX03LA302Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Show Low, AZThe pilot-in-command's (CFI) selection of the wrong runway (downwind) for the approach and landing. The failure of the left engine to respond to throttle application for undetermined reasons during the go-around was also causal. The high density altitude was…Oct 1, 2003 · N4167B · Substantial damageNTSB SEA03CA200Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Basin City, WAClearance not maintained while on short approach to the runway. A factor was the corn stalks near the runway.Sep 30, 2003 · N4451Z · Substantial damageNTSB LAX03LA290Accident · No injuriesLimited investigationFinal reportCessna 172RG · Santa Ana, CAthe failure of the right main landing gear pivot assembly.Sep 30, 2003 · N9564B · Substantial damageNTSB SEA03LA196Accident · Serious injuriesLimited investigationFinal reportBeech T-34 (A-45) · McCall, IDThe inadequacy of the pilot's remedial action taken in an attempt to fly out of an encounter with the wake vortex turbulence created by a preceding aircraft while on short final to land. Factors include calm winds in the area of the final approach course, and…Sep 28, 2003 · N234KC · Substantial damageNTSB CHI03LA323Accident · No injuriesLimited investigationFinal reportCessna 150L · Siloam Springs, ARA loss of engine power due to the pilot's inadequate planning/decision resulting in fuel exhaustion. Factors were the trees and the night conditions.Sep 28, 2003 · N21915 · Substantial damageNTSB NYC03FA205Accident · 2 fatalField investigationFinal reportCessna 182T · Concord, MAThe pilot's failure to maintain aircraft control due to spatial disorientation. A factor was the low ceilings.Sep 27, 2003 · N963LP · DestroyedNTSB NYC03FA203Accident · 1 fatalField investigationFinal reportCessna 402C · Nantucket, MAThe pilot's failure to maintain aircraft control during a missed approach. Factors in this accident were fog and the night light conditions.Sep 23, 2003 · N405BK · Substantial damageNTSB LAX03CA299Accident · No injuriesData collectionFinal reportCessna 150F · Reedley, CAthe pilot's failure to maintain the proper glide path and airspeed during final, which resulted in an inadvertent stall/mush.Sep 22, 2003 · N3093X · Substantial damageNTSB ATL03LA145Accident · No injuriesLimited investigationFinal reportCessna 180 · Pavo, GAThe pilot's failure to maintain airspeed, resulting in an inadvertent stall.Sep 21, 2003 · N2807A · Substantial damageNTSB DEN03LA154Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Byers, COThe pilot not maintaining adequate clearance from the ground and his improper in-flight planning/decision. Factors contributing to the accident were the tailwind, the low altitude, the tree, the people, the embankment, and the ravine.Sep 20, 2003 · N41698 · Substantial damageNTSB ANC03LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Ninilchick, AKThe pilot's failure to maintain control of the airplane which resulted in a collision with terrain during an approach to landing on a ridgeline. Factors contributing to the accident were the pilot's inadequate evaluation of the wind conditions, and an…Sep 17, 2003 · N6978B · Substantial damageNTSB NYC03LA201Accident · No injuriesLimited investigationFinal reportRaytheon B36TC · Batavia, OHA loss of engine power during an approach for undetermined reasons.Sep 16, 2003 · N3212D · Substantial damageNTSB FTW03FA225Accident · 2 fatalField investigationFinal reportCessna 310J · New Orleans, LAThe pilot's failure to maintain aircraft control of the airplane during a go-around. A contributing factor was the crosswind.Sep 15, 2003 · N2010E · DestroyedNTSB ATL03LA138Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Seymour, TNThe pilot's failure to maintain clearance during the final approach to land which resulted in an inflight collision with a tree.Sep 15, 2003 · N22TE · Substantial damageNTSB FTW03LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Ardmore, OKThe failure of the pilot to adequately compensate for existing wind conditions. A contributing factor was the gusty crosswind conditions from the east.Sep 11, 2003 · N9651Q · Substantial damageNTSB NYC03LA198Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Rockford, OHThe pilot's failure to maintain the proper altitude/clearance, which resulted in an in-flight collision with a utility wire. The owner's improper decision to allow the airplane to be operated by an uncertificated pilot was also causal.Sep 9, 2003 · N1072B · DestroyedNTSB LAX03LA283Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Monterey, CAThe pilot’s inadequate in-flight planning/decision, which resulted in a loss of engine power during an instrument approach to land, and an in-flight collision with a tree and terrain.Sep 9, 2003 · N93860 · Substantial damageNTSB DEN03LA150Accident · No injuriesLimited investigationFinal reportCessna 182A · Pine Haven, WYThe loss of engine power for undetermined reasons. The lack of suitable terrain is a contributing factor.Sep 7, 2003 · N6384B · Substantial damageNTSB DEN03LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Farmington, NMthe pilot's improper procedures/directives, and the delayed activation of carburetor heat which resulted in the loss of engine power and subsequent impact with terrain. Contributing factors include the carburetor icing conditions, and the rough/uneven and…Sep 6, 2003 · N60571 · Substantial damageNTSB ANC03CA109Accident · No injuriesData collectionFinal reportMaule M-6-235 · Kenai, AKThe pilot's failure to maintain adequate altitude/clearance during an intentional go-around, which resulted in an in-flight collision with trees.Sep 6, 2003 · N4564B · Substantial damageNTSB NYC03LA195Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJThe pilot's delay in executing a go-around, which resulted in an encounter with wake turbulence from a helicopter. A factor in the accident was the wake turbulence.Sep 5, 2003 · N6183J · Substantial damageNTSB CHI03FA291Accident · 3 fatalField investigationFinal reportBeech B36TC · Uniondale, INThe pilot's inaccurate preflight planning which resulted in an inadequate fuel supply and subsequent fuel exhaustion. Factors associated with the accident were the low ceiling, dark night conditions, and the utility pole which the airplane contacted during…Sep 2, 2003 · N8018J · DestroyedNTSB SEA03LA182Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Hillsboro, ORThe pilot's failure to maintain the proper distance and altitude while on final approach which led to touching down short of the runway. The pilot's restricted visual lookout was a factor.Sep 1, 2003 · N5301W · DestroyedNTSB LAX03LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · North Las Vegas, NVthe pilot's failure to maintain an adequate airspeed during approach for the airplane's flight configuration, which resulted in an inadvertent stall and impact with terrain.Sep 1, 2003 · N103TK · Substantial damageNTSB LAX03CA272Accident · No injuriesData collectionFinal reportCessna 182J · Marble Canyon, AZthe failure of the pilot to retract the flaps and attain a sufficient airspeed during the attempted go-around, which resulted in a stall. The full nose-up trim was a contributing factor.Aug 31, 2003 · N2898F · Substantial damageNTSB LAX03LA270Accident · 1 fatalLimited investigationFinal reportBeech K35 · Gerlach, NVthe pilot's failure to maintain an adequate airspeed resulting in a stall mush and collision with terrain.Aug 30, 2003 · N5343E · Substantial damageNTSB NYC03LA184Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Pawtucket, RIA loss of engine power for undetermined reasons.Aug 29, 2003 · N2550A · Substantial damageNTSB CHI03FA296Accident · 2 fatalField investigationFinal reportBeech 58P · Grand Marais, MNThe continued descent below minimum descent altitude and the altitude/clearance not maintained by the pilot during approach to the airport. The low ceiling was a contributing factor.Aug 28, 2003 · N285V · DestroyedNTSB SEA03FA173Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Warm Lake, IDThe pilot's failure to maintain adequate airspeed during final approach resulting in a stall/spin. Contributing factors were the rapidly rising terrain and trees.Aug 26, 2003 · N6126J · DestroyedNTSB NYC03FA180Accident · 1 fatalField investigationFinal reportAero Vodochody L-39ZO · Forest Hill, MDThe pilot's in-flight decision to delay application of engine power to account for the engine's slow response to throttle input, which resulted in an inadvertent stall and subsequent collision with a residential area. A factor related to the accident was the…Aug 24, 2003 · N298RD · Destroyed