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 SEA96LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Klamath Falls, ORthe pilot's inadequate compensation for wind conditions, and his failure to maintain proper alignment with the runway during the landing/go-around. Factors relating to the accident were: strong, gusty crosswinds, and the encounter with a runway…Aug 6, 1996 · N26414 · Substantial damageNTSB ANC96LA120Accident · No injuriesLimited investigationFinal reportCessna 185 · Kaktovik, AKThe pilot's inadequate compensation for the existing wind conditions. A factor associated with the accident was the windshear.Aug 6, 1996 · N8536L · Substantial damageNTSB MIA96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Live Oak, FLfailure of the pilot to use carburetor heat during the approach to land, which resulted in loss of engine power due to carburetor ice. The weather (carburetor icing condition) was a related factor.Aug 4, 1996 · N3399W · Substantial damageNTSB IAD96LA125Accident · No injuriesLimited investigationFinal reportCessna 172M · Cincinnati, OHfailure of the student pilot to maintain sufficient airspeed during an attempted go-around, which resulted in a stall/spin and an uncontrolled collision with the ground. A factor related to the accident was: an improper (premature) flare for landing.Aug 4, 1996 · N172PS · Substantial damageNTSB IAD96LA124Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Waverly, OHthe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) with subsequent loss of visual contact and collision with the ground. Darkness and fog were related factors.Aug 4, 1996 · N61049 · DestroyedNTSB ANC96LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot's improper approach to landing, and his delay in initiating a go-around.Aug 4, 1996 · N8995D · Substantial damageNTSB CHI96LA274Accident · No injuriesLimited investigationFinal reportBeech 35 · Yankton, SDan improper in-flight decision by the pilot when he shut the engine off as the airplane approached the landing runway. Factors associated with this accident were an inadequate maintenance inspection by the mechanic when the actuating arm fracture was not…Aug 3, 1996 · N3392V · Substantial damageNTSB CHI96LA266Accident · Serious injuriesLimited investigationFinal reportCessna 404 · Benton Harbor, MIthe pilot's delay in initiating a go-around after not attaining the proper touchdown point during the landing, and his failure to remain clear of obstructions (trees) during the go-around. Factors relating to the accident were the adverse weather condition…Aug 3, 1996 · N8919G · DestroyedNTSB CHI96LA267Accident · No injuriesLimited investigationFinal reportYakovlev YAK-3UA · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations, and his inadequate in-flight planning and decision making. The pilot's failure to declare an emergency fuel condition (inadequate communication) was a related factor.Aug 1, 1996 · N33UA · Substantial damageNTSB MIA96LA198Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Sarasota, FLthe pilot's inadequate preflight inspection of the fuel tanks resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Jul 31, 1996 · N397MS · Substantial damageNTSB SEA96LA173Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Portland, ORThe pilot's failure to maintain a proper glide path above the MD-80's wake turbulence.Jul 28, 1996 · N3135S · Substantial damageNTSB CHI96LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Backus, MNthe pilot's failure to maintain adequate altitude and his abrupt maneuver to avoid the tree tops. The dark night was a factor.Jul 27, 1996 · N1620V · Substantial damageNTSB NYC96FA157Accident · 2 fatalField investigationFinal reportCessna 182P · Brewer, MEfailure of the pilot to maintain control of the airplane, during a missed approach, after diverting to an alternate destination, while on his first solo flight in instrument meteorological conditions (IMC).Jul 24, 1996 · N9920E · DestroyedNTSB CHI96LA253Accident · No injuriesLimited investigationFinal reportYasecko LONG-EZE · Waukesha, WIFailure of the throttle cable.Jul 24, 1996 · N303Y · Substantial damageNTSB NYC96LA155Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Turner, MEthe pilot's inadequate preflight inspection, by failing to remove the pitot tube cover, which resulted in false airspeed indications, and his failure to maintain adequate obstacle clearance from a utility pole.Jul 23, 1996 · N3269J · Substantial damageNTSB MIA96LA193Accident · No injuriesLimited investigationFinal reportCessna 210L · Fort Myers, FLfailure of the pilot (PIC) to ensure that an adequate preflight inspection was performed; a missing (or loose) fuel cap on the left wing; probable fuel siphoning; and fuel exhaustion, which resulted in a loss of engine power and a subsequent forced landing…Jul 22, 1996 · N1623X · Substantial damageNTSB FTW96LA314Accident · No injuriesLimited investigationFinal reportBarton Sylkie 1 · Erie, COThe pilot passenger's failure to maintain clearance from the fence due to his failure to maintain a proper glide path, and the pilot-in-command's failure to take remedial action in a timely fashion.Jul 22, 1996 · N711WB · Substantial damageNTSB ATL96LA112Accident · No injuriesLimited investigationFinal reportCessna 180 · Memphis, TNInadequate annual inspection that resulted in the in-flight loss of the fuel system strainer and subsequent fuel starvation. A factor was the lack of suitable terrain for a forced landing.Jul 22, 1996 · N3122C · Substantial damageNTSB FTW96LA312Accident · No injuriesLimited investigationFinal reportCessna 182A · Skiatook, OKa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Jul 21, 1996 · N2182G · Substantial damageNTSB FTW96LA328Accident · No injuriesLimited investigationFinal reportCessna T210L · Santa Fe, NMthe pilot's improper decision to continue the flight after noting the low fuel quantity indication, which resulted in fuel starvation before reaching the airport. A factor was the lack of suitable terrain for the forced landing.Jul 20, 1996 · N210RE · Substantial damageNTSB CHI96LA249Accident · No injuriesLimited investigationFinal reportCessna 172 · Emily, MNthe pilot misjudged his altitude and distance to the runway on final approach, and he failed to maintain obstacle clearance during landing. A factor relating to the accident was: the parked car.Jul 20, 1996 · N7101T · DestroyedNTSB CHI96LA248Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Rose Hill, KSthe worn carburetor, and inadequate inspection of the aircraft by other maintenance personnel.Jul 20, 1996 · N5335B · Substantial damageNTSB IAD96LA120Accident · No injuriesLimited investigationFinal reportCessna 172 · Stowe, VTfailure of the pilot to follow proper IFR procedures and to maintain proper terrain clearance (altitude) during an NDB approach. Factors related to the accident were: the pilot's lack of instrument experience, low ceiling, and mountainous terrain.Jul 19, 1996 · N5091G · DestroyedNTSB LAX96LA273Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Pacoima, CAa total loss of engine power for undetermined reasons.Jul 16, 1996 · N87107 · DestroyedNTSB CHI96LA244Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Versailles, MOthe student pilot's failure to maintain airplane control during a go-around.Jul 16, 1996 · N11303 · Substantial damageNTSB ANC96FA099Accident · 1 fatalField investigationFinal reportRotorway Exec 90 · Anchorage, AKthe pilot's excessive control inputs and the lack of familiarity with the helicopter. A factor associated with the accident was the pilot's failure to follow the prescribed operating limitations.Jul 16, 1996 · N9297H · DestroyedNTSB IAD96LA117Accident · No injuriesLimited investigationFinal reportBeech A100 · Manchester, NHThe pilots failure to maintain control of the aircraft during a coupled approach. A related factor was the unmonitored inoperative glide slope.Jul 15, 1996 · N4391W · Substantial damageNTSB CHI96LA242Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Belle Plaine, MNthe pilot's misjudgment of the distance and speed during the landing, and his delay in initiating a go-around. Factors relating to the accident were: the tall grass and ravine at the end of the runway.Jul 15, 1996 · N5026K · Substantial damageNTSB FTW96LA306Accident · No injuriesLimited investigationFinal reportSmith RV4 · Mandeville, ARa loss of engine power for undetermined reasons.Jul 14, 1996 · N83FS · Substantial damageNTSB SEA96LA154Accident · Minor injuriesLimited investigationFinal reportColonial C-1 · Halls Crossing, UTthe pilot's inadequate preflight of the airplane, and subsequent fuel exhaustion due to an inadequate supply of fuel, which resulted in loss of engine power and an emergency landing. Uneven terrain in the emergency landing area was a related factor.Jul 13, 1996 · N248B · Substantial damageNTSB FTW96LA302Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Rogers, ARfuel exhaustion due to the pilot's failure to refuel. Factors were the below landing minimums weather conditions and the lack of suitable terrain for the forced landing.Jul 13, 1996 · N810EM · Substantial damageNTSB CHI96LA234Accident · No injuriesLimited investigationFinal reportCessna 172L · Vicksburg, MIthe pilot's premature raising of the flaps during a go-around. The presence of birds was a factor.Jul 11, 1996 · N7545G · Substantial damageNTSB SEA96LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTthe student pilot's improper recovery from a bounced landing, and his failure to maintain adequate airspeed during go-around. The student pilot's improper level-off was a factor.Jul 10, 1996 · N4897P · Substantial damageNTSB MIA96LA178Accident · No injuriesLimited investigationFinal reportCessna 140 · Holt, FLLoss of engine power for undetermined reason(s) during a go-around, which result in the aircraft being unable to climb above trees at the departure end of the runway.Jul 10, 1996 · N2102N · Substantial damageNTSB CHI96LA233Accident · No injuriesLimited investigationFinal reportCessna 172 · Freeport, ILThe pilot's misjudgment of altitude and distance on final approach, and his failure to attain the proper touchdown point for landing.Jul 10, 1996 · N5542R · Substantial damageNTSB FTW96LA294Accident · Minor injuriesLimited investigationFinal reportO'Day Sonerai II-LS · Friendswood, TXa loss of engine power for undetermined reasons, and the pilot's failure to attain the proper traffic pattern altitude on the downwind leg prior to turning the base leg.Jul 9, 1996 · N30155 · Substantial damageNTSB LAX96LA266Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Chino, CAFuel starvation due to the pilot's failure to monitor and correctly configure the fuel system for landing prior to entering the traffic pattern, and the pilot's premature lowering of full flaps which led to the runway undershoot. A factor in the accident was…Jul 7, 1996 · N50814 · Substantial damageNTSB SEA96LA143Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sun Valley, IDthe pilot's inadequate compensation for wind conditions and failure to obtain/maintain adequate airspeed for the go-around. The crosswind, downdraft, and high density altitude were related factors.Jul 5, 1996 · N95658 · Substantial damageNTSB NYC96LA142Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenwood Lake, NJfailure of the pilot to maintain adequate airspeed, during the approach/go-around, which resulted in an inadvertent stall and collision with the terrain.Jul 5, 1996 · N6137H · Substantial damageNTSB LAX96LA262Accident · 2 fatalLimited investigationFinal reportRyan ST3KR · Santa Paula, CAa partial loss of engine power for undetermined reasons and the pilot's failure to maintain control of the airplane while maneuvering toward the runway following the power loss.Jul 5, 1996 · N57017 · DestroyedNTSB CHI96LA229Accident · Minor injuriesLimited investigationFinal reportHewitt Cassutt 3M · Vermillion, SDthe failure of the unapproved fuel pump.Jul 4, 1996 · N290E · Substantial damageNTSB MIA96LA174Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Kinston, NCfailure of the pilot to maintain minimum descent altitude (MDA) during approach because of fatigue.Jul 3, 1996 · N23806 · Substantial damageNTSB NYC96LA139Accident · 1 fatalLimited investigationFinal reportTitan Tornado · Richland, NYfailure of the student pilot to maintain adequate airspeed, during an apparent go-around, which resulted in an inadvertent stall and subsequent collision with the terrain. Factors relating to the accident were: the pilot's lack of certification, and…Jul 2, 1996 · UNREG · DestroyedNTSB FTW96TA289Accident · Minor injuriesFinal reportCessna 182RG · Broomfield, COfailure of the pilot to maintain directional control and runway alignment during a go-around, and the lack of power response from the engine for undetermined reason(s). The sudden wind shift was a related factor.Jul 2, 1996 · N4314R · Substantial damageNTSB FTW96FA288Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Huffman, TXcorroded flight control components, due to the operator's inadequate maintenance and inspection of the airplane; the pilot's failure to follow procedures and directives, by flying the airplane without proper maintenance and annual inspection; and subsequent…Jul 2, 1996 · N501JS · Substantial damageNTSB CHI96LA226Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 Viking · Alexandria, MNthe flight instructor's failure to assure a proper fuel tank selector position. Factors associated with the accident were improper preflight preparation and complacency by the flight instructor.Jul 1, 1996 · N838MM · Substantial damageNTSB MIA96LA172Accident · No injuriesLimited investigationFinal reportCharles Raymond Glasair 2SFT · Apalachicola, FLInadequate application of throttle input and up elevator input by the pilot-in-command. Contributing to the accident was the in-flight encounter with a downdraft and inadequate design of the airplane by the kit manufacturer.Jun 30, 1996 · N16CD · Substantial damageNTSB LAX96LA255Accident · No injuriesLimited investigationFinal reportCessna 172 · Frazier Park, CAthe failure of the pilot to maintain terrain clearance after a misjudged approach and landing that necessitated a go-around and subsequent collision with some wires. Factors were high density altitude and an inadequate evaluation by the pilot-in-command of…Jun 30, 1996 · N6819H · Substantial damageNTSB LAX96LA254Accident · Minor injuriesLimited investigationFinal reportGray Berkut · Santa Paula, CALoss of engine power during final approach for undetermined reasons. A factor in the accident was the nature of the terrain for the forced landing.Jun 29, 1996 · N260DG · DestroyedNTSB LAX96LA252Accident · No injuriesLimited investigationFinal reportCessna 402A · Grand Canyon, AZFailure of the pilot to properly judge his altitude during final approach resulting in an undershoot. A factor was a downdraft weather condition.Jun 29, 1996 · N13GM · Substantial damage