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 SEA00LA156Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hillsboro, ORAn inadequately planned approach. The encounter of wake turbulence and not being able to maintain aircraft control were factors.Aug 10, 2000 · N6434H · Substantial damageNTSB LAX00LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Avalon, CAThe pilot's inadequate compensation for the downdraft condition and subsequent failure to maintain proper glide path. A factor in the accident was the upsloping runway and nature of the terrain around the runway, which presented an optical illusion and lead…Aug 10, 2000 · N200EG · Substantial damageNTSB IAD00LA072Accident · Serious injuriesLimited investigationFinal reportAero Commander 114-B · Somerset, PAPilot's improper pre-flight planning, which resulted in a loss of engine power due to fuel exhaustion.Aug 10, 2000 · N6101T · Substantial damageNTSB NYC00LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA28-235 · Chester, CTThe CFI's delayed remedial action.Aug 8, 2000 · N8809W · Substantial damageNTSB NYC00LA219Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Post Mills, VTwas the pilot's improper fuel management which resulted in power loss due to fuel starvation.Aug 5, 2000 · N73044 · Substantial damageNTSB CHI00LA245Accident · No injuriesLimited investigationFinal reportCessna 152 · Arthur, NDthe water contamination found in the fuel and the pilot misjudging his altitude during the emergency procedure. A factor was the terrain condition of the corn crop.Aug 5, 2000 · N7385W · Substantial damageNTSB CHI00LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Eastport, MIthe maneuver, performed by the pilot, to avoid obstructions on highway US.31. Factors were the carburetor icing weather condition, no suitable terrain conditions, the ground terrain condition, and the impacted fence.Aug 4, 2000 · N6712F · Substantial damageNTSB ATL00LA074Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Clarksville, TNThe pilot's failure to follow published instrument approach procedures, and collided with a tree while executing a missed approach. Factors were low clouds, fog and a tree.Aug 2, 2000 · N86BC · Substantial damageNTSB MIA00FA229Accident · 1 fatalField investigationFinal reportde Havilland DHC-6-200 · Raleigh, NCthe pilot's continued VFR flight into IMC conditions, by failing to maintain altitude, and descending from VFR conditions into IMC, which resulted in him subsequently impacting with trees. Factors in this accident were: reduced visibility due to dark night…Jul 31, 2000 · N201RH · DestroyedNTSB IAD00FA067Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Bluffton, OHPilot's improper fuel calculations, which resulted in fuel exhaustion. Also causal, was his abrupt maneuver during the forced landing, which resulted in an inadvertent stall.Jul 30, 2000 · N5271P · Substantial damageNTSB FTW00LA220Accident · No injuriesLimited investigationFinal reportAero Tek Zuni · Uvalde, TXThe pilot's inadvertent flight into adverse weather conditions which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.Jul 30, 2000 · N6ZF · Substantial damageNTSB NYC00LA213Accident · 2 fatalLimited investigationFinal reportSchwarz Zodiac CH 601 · Wooster, OHThe pilot's loss of control of the airplane while turning from base onto final, which resulted in an inadvertent stall/spin. A factor was the pilot's improper loading of the airplane, outside the weight and balance limitations.Jul 29, 2000 · N601GS · DestroyedNTSB ATL00LA071Accident · Minor injuriesLimited investigationFinal reportRyskamp Sonex · Greenville, SCThe pilot's misjudgment of airspeed and altitude resulting in an undershoot.Jul 29, 2000 · N202BA · Substantial damageNTSB LAX00LA281Accident · No injuriesLimited investigationFinal reportCessna 180 · North Las Vegas, NVThe pilot's improper recovery from a bounced landing and subsequent failure to maintain directional control of the aircraft. Wind shear on landing approach was a factor in the accident.Jul 28, 2000 · N3386D · Substantial damageNTSB FTW00LA221Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kingfisher, OKThe pilot's failure to maintain aircraft control. A factor was the downdraft weather condition.Jul 27, 2000 · N71620 · DestroyedNTSB CHI00LA226Accident · 1 fatalLimited investigationFinal reportHalsmer Crazy 8 · Lafayette, INAircraft control not being maintained by the pilot during the forced landing. Factors to the accident were the engine failure due to an overtemperature, the pilot's lack of familiarity with the aircraft, and the trees.Jul 27, 2000 · N9034L · DestroyedNTSB FTW00LA216Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Sherman, TXthe total failure of the clutch cable during landing, which resulted from fatigue cracking of the cable's individual wires.Jul 25, 2000 · N298SH · Substantial damageNTSB NYC00LA205Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Logan, WVFuel exhaustion of the engine due to improper fuel consumption calculations performed by the pilot.Jul 22, 2000 · N12SF · Substantial damageNTSB SEA00LA137Accident · No injuriesLimited investigationFinal reportBeaver Ferguson F-II · Benton City, WAThe pilot's failure to approach the strip with adequate airspeed for the conditions (resulting in a stall/mush situation), and his failure to maintain adequate altitude and/or clearance above a power line on the approach path. Factors included crosswind…Jul 21, 2000 · N8228R · Substantial damageNTSB DEN00LA131Accident · Minor injuriesLimited investigationFinal reportRotorway Executive 162F · Tooele, UTThe pilot's inadequate weather evaluation, which resulted in a downwind landing, and his failure to maintain aircraft control. A factor was the tailwind.Jul 16, 2000 · N6399L · Substantial damageNTSB LAX00LA267Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Lancaster, CAThe pilot's inadequate compensation for gusty winds conditions that resulted in the collision with a power line during final approach.Jul 15, 2000 · N8768D · Substantial damageNTSB LAX00LA265Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Las Vegas, NVThe pilot's failure to refuel the airplane and his improper fuel consumption calculations.Jul 15, 2000 · N738XP · Substantial damageNTSB FTW00LA211Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Decatur, ARThe inadvertent stall while maneuvering to avoid obstructions during a forced landing. A factor was the pilot's failure to extend the landing gear, which resulted in a partial loss of engine power due to the propeller blades striking the runway.Jul 15, 2000 · N3424B · Substantial damageNTSB SEA00LA131Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 Dromader · Burley, IDImproper airstrip operations by ground personnel, and the pilot's failure to visually detect a vehicle on the airstrip in time to avoid a collision. Factors included a vehicle on the airstrip, tailwind conditions, and high density altitude conditions.Jul 11, 2000 · N2054S · DestroyedNTSB NYC00LA196Accident · No injuriesLimited investigationFinal reportCessna 337C · Chesapeake, VAThe pilot's failure to follow the published go-around procedure. Factors were the pilot's improper evaluation of the wind conditions, and a tailwind.Jul 11, 2000 · N2574S · Substantial damageNTSB ANC00IA088Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Anchorage, AKAn inoperative traffic alert and collision avoidance system (TCAS).Jul 11, 2000 · N935AS · No damageNTSB SEA00LA128Accident · No injuriesLimited investigationFinal reportKeith Kinden Rebel · Libby, MTAn improper installation of a rudder control cable Nicopress sleeve by the owner/builder. The rudder control cable disconnection and the slipped cable from the sleeve were factors.Jul 10, 2000 · N6317Y · Substantial damageNTSB LAX00LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Maria, CAThe pilot's failure to ensure that an adequate fuel supply was on board at last departure, which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane at the en route stop was also causal.Jul 10, 2000 · N4209T · Substantial damageNTSB DEN00LA124Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Logan, UTin-flight collision with a jacket, which blew out of the helicopter because the left passenger door was not properly secured prior to takeoff. A contributing factor was the pilot's failure to ensure the door was properly closed prior to takeoff.Jul 7, 2000 · N38903 · Substantial damageNTSB CHI00LA182Accident · No injuriesLimited investigationFinal reportCessna 172R · Athens, MIthe failure of the student pilot to maintain control of the aircraft, the inadequate supervision by the flight instructor, and the delayed remedial action performed by the flight instructor. A factor to the accident was the runway edge light that was struck…Jul 5, 2000 · N996WW · Substantial damageNTSB ANC00IA083Incident · No injuriesIncident investigationFinal reportCessna 207A · Deadhorse, AKAn in-flight fracture of the engine crankshaft propeller flange. A factor associated with the accident was the manufacturer's inadequate quality control standards.Jul 5, 2000 · N73100 · Minor damageNTSB MIA00LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ocracoke, NCThe pilot's failure to compensate with rudder control for engine torque and 'p' factor during a go-around resulting in the aircraft drifting to the left, colliding with brush, and spinning around coming to rest in the brush.Jul 3, 2000 · N5381L · Substantial damageNTSB NYC00LA184Accident · 2 fatalLimited investigationFinal reportHartzell Rans S-12 · Strattanville, PAThe pilot's failure to maintain adequate airspeed during low level maneuvering, which resulted in an inadvertent stall/spin.Jul 2, 2000 · UNREG · DestroyedNTSB CHI00LA193Accident · No injuriesLimited investigationFinal reportSchleicher K8B · Manchester, MIthe downdraft experienced during final approach and altitude/clearance from the fence post not being maintained by the pilot. A factor to the accident was the fence post.Jul 1, 2000 · N885D · Substantial damageNTSB FTW00LA190Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Whitney, TXThe partial loss of engine power, which resulted from the worn carburetor.Jun 29, 2000 · N6932N · Substantial damageNTSB CHI00LA172Accident · No injuriesLimited investigationFinal reportCessna 172N · Canton, MIthe CFI delayed initiating a go-around during the landing. Factors associated with the accident were the student pilot's inadequate handling of the airplane, the crosswind condition, and the soft terrain on which the airplane touched down.Jun 26, 2000 · N3416E · Substantial damageNTSB DEN00LA116Accident · No injuriesLimited investigationFinal reportCessna 310C · Erie, COA sudden and unexpected encounter with a downdraft while on final approach. A factor was the transmission wire.Jun 24, 2000 · N1779H · Substantial damageNTSB CHI00LA173Accident · Minor injuriesLimited investigationFinal reportMcclish Funk B85C · Gardner, KSan improper modification to the engine which allowed a bearing to be misaligned, thus restricted the flow of oil through the engine. A factor associated with the accident was the wet field in which the forced landing was made.Jun 24, 2000 · N24120 · Substantial damageNTSB CHI00FA170Accident · 1 fatalField investigationFinal reportAeronca 7AC · Lakeville, MNthe pilot not maintaining aircraft control and the stall/spin she encountered during the approach on base to final. A factor was the pilot passenger not detecting the remedial action needed to correct the aircraft's nose up attitude during the approach.Jun 24, 2000 · N81681 · Substantial damageNTSB LAX00LA240Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26C · Tehachapi, CAThe pilot's failure to maintain aircraft speed and control while maneuvering to land.Jun 23, 2000 · N2792Z · Substantial damageNTSB NYC00LA167Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Cheswold, DEThe instructor's delayed remedial action. Factors included the instructor's failure to take positive control of the airplane, and the student's failure to maintain adequate airspeed during the approach.Jun 18, 2000 · N407DS · Substantial damageNTSB LAX00LA226Accident · No injuriesLimited investigationFinal reportHughes 269C · Santa Clarita, CASettling with power precipitated by a wind direction change during the approach to land sequence and the check pilot's delayed remedial action to correct the event. Factors in the accident were crew resource management coordination concerning flight control…Jun 14, 2000 · N9692F · Substantial damageNTSB DEN00LA108Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Englewood, COFailure of the instructor pilot-in-command and the pilot receiving instruction to maintain directional control. Factors were the pilot receiving instruction allowing the airplane to approach low and slow, and failure of the instructor to maintain adequate…Jun 12, 2000 · N838PC · 2 aircraft · Minor damageNTSB NYC00LA160Accident · Minor injuriesLimited investigationFinal reportBryant/Rhodus LONG-EZ · West Chester, PAWas the failure of the pilot to attain his proper touchdown point. Factors were the downdraft and rising terrain leading to the runway.Jun 11, 2000 · N5534V · Substantial damageNTSB ATL00LA064Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Palmetto, FLThe pilot's failure to maintain airspeed during final approach to landing, resulting in an inadvertent stall.Jun 10, 2000 · N83972 · Substantial damageNTSB ATL00LA063Accident · Minor injuriesLimited investigationFinal reportHughes 369A · Hampton, GAA total loss of engine power due to foreign object damage to the turbine wheel assembly.Jun 10, 2000 · N330CM · Substantial damageNTSB NYC00LA157Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti SF260TP · Norfolk, VAFuel starvation of the engine, caused by the failure of the fuel transfer pump.Jun 9, 2000 · N43GP · Substantial damageNTSB NYC00LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172R · West Milford, NJA loss of engine power for undetermined reasons.Jun 9, 2000 · N7274D · Substantial damageNTSB IAD00LA049Accident · Minor injuriesLimited investigationFinal reportBeech BE-55 · Erie, PAthe pilot's improper fuel management which resulted in fuel starvation and a loss of power to both engines. A factor was the pilot's inadequate pre-flight planning and takeoff with inadequate fuel for the flight.Jun 9, 2000 · N777K · DestroyedNTSB FTW00LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Nacogdoches, TXthe loss of engine power during a go-around resulting from the failure of the worn carburetor heat control cable. A contributing factor was the lack of suitable terrain for the forced landing.Jun 8, 2000 · N29383 · Substantial damage