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 FTW96LA187Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Carlsbad, NMThe pilot's inadequate compensation for wind conditions. Factors relating to the accident were: the sudden windshift and/or windshear.Apr 28, 1996 · N7256P · Substantial damageNTSB FTW96LA189Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Malvern, ARfailure of the pilot to apply carburetor heat during the approach to land, which resulted in a loss of engine power due to carburetor ice. A factor relating to the accident was: the carburetor icing (weather) condition.Apr 27, 1996 · N8552T · DestroyedNTSB ATL96LA081Accident · No injuriesLimited investigationFinal reportCessna 210 · Knoxville, TNThe pilot's failure to heed known operating information by not correcting the flight attitude to prevent fuel unporting during a prolonged slipped descent.Apr 27, 1996 · N9432T · Substantial damageNTSB ANC96LA058Accident · No injuriesLimited investigationFinal reportCessna 180H · Palmer, AKThe pilot-in-command's inadvertent stall during the go around attempt. Factors in the accident were the pilot-in- command's lack of a high performance endorsement and the pilot/passenger's decision to allow the pilot-in-command to manipulate the controls…Apr 27, 1996 · N91304 · Substantial damageNTSB FTW96LA179Accident · No injuriesLimited investigationFinal reportCessna 172P · Colorado Spgs, COthe student pilot'S failure to maintain control of the aircraft during a go-around.Apr 23, 1996 · N55126 · Substantial damageNTSB FTW96LA178Accident · No injuriesLimited investigationFinal reportCessna 152 · Bullard, TXfailure of an engine exhaust valve, which resulted in a loss of engine power, a forced landing, and subsequent damage to the airplane. Factors relating to the accident were: the tailwind, and the wet grass runway.Apr 23, 1996 · N46748 · Substantial damageNTSB MIA96LA125Accident · No injuriesLimited investigationFinal reportRans S6ES · Bayou La Batre, ALthe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.Apr 22, 1996 · N5144X · Substantial damageNTSB LAX96LA175Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Santa Barbara, CAThe pilot's failure to select a fuel tank containing an adequate quantity of fuel prior to landing, which resulted in fuel starvation.Apr 21, 1996 · N8711V · DestroyedNTSB LAX96LA173Accident · No injuriesLimited investigationFinal reportCessna 150K · Mojave, CAthe pilot's failure to clear the engine during an idle power descent, as required by the engine manual.Apr 17, 1996 · N6466G · Substantial damageNTSB MIA96LA120Accident · No injuriesLimited investigationFinal reportMooney M20C · St Augustine, FLinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid each other's airplane. A factor relating to the accident was: the lack of traffic pattern position reports from the Christian Eagle, due to the…Apr 16, 1996 · N9206V · 2 aircraft · Minor damageNTSB MIA96FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Kissimmee, FLthe pilot's improper planning/decision, which resulted in fuel starvation and a forced landing in a residential area. A factor relating to the accident was: the inaccuracy of the expected fuel consumption.Apr 15, 1996 · N6902F · DestroyedNTSB FTW96LA170Accident · No injuriesLimited investigationFinal reportExplorer Post 51 AA Cubette · Dell City, TXthe pilot's failure to maintain obstacle clearance during a go-around. Factors were the gusty wind and the pilot's inadequate compensation for the wind.Apr 14, 1996 · N7891 · Substantial damageNTSB MIA96FA115Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Lakeland, FLthe pilot's failure to maintain airspeed (Vs) while turning on approach from base to final resulting in an inadvertent stall.Apr 12, 1996 · N6243P · DestroyedNTSB LAX96LA166Accident · No injuriesLimited investigationFinal reportRockwell 112TCA · Independence, CAthe pilot's inadequate compensation for the wind conditions. The wind was a factor.Apr 12, 1996 · N1008R · Substantial damageNTSB CHI96LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Sikeston, MOThe pilot's delay in applying carburetor heat, which resulted in carburetor icing and subsequent loss of engine power. Factors relating to the accident were: carburetor icing (weather) conditions, and the pilot's lack of recent experience in the make and…Apr 9, 1996 · N6689G · Substantial damageNTSB ATL96LA078Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B · Batesville, MSan anomaly in the fuel system that allowed a pressure differential to occur between the center and outer portions of the main integral fuel tank, which in turn resulted in fuel starvation of both engines. A factor relating to the accident was: failure of…Apr 7, 1996 · N310MA · Substantial damageNTSB NYC96LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmingdale, NYloss of engine power for undetermined reasons.Apr 6, 1996 · N67562 · Substantial damageNTSB ANC96LA043Accident · No injuriesLimited investigationFinal reportCessna 180 · Big Lake, AKfuel starvation due to unporting of the fuel tank inlet, and the pilot's use of a steep, nose-low attitude during descent on the approach to land. The low level of fuel remaining was a related factor.Apr 5, 1996 · N9600B · DestroyedNTSB ATL96LA075Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Bunnell, FLThe pilot's failure to obtain a preflight weather briefing and his failure to apply carburetor heat that resulted in a loss of engine power. A factor was weather conditions were favorable for the formation of carburetor icing at cruise flight.Apr 2, 1996 · N7355S · Substantial damageNTSB FTW96LA158Accident · Minor injuriesLimited investigationFinal reportStafford RV-4 · Longmont, COthe pilot's inadequate preflight planning and preparation in that he failed to ensure the aircraft had sufficient fuel to complete the flight. A factor was the soft terrain.Apr 1, 1996 · N84PS · Substantial damageNTSB ATL96LA073Accident · No injuriesLimited investigationFinal reportCanadair CL-600S · Raleigh, NCthe flight crew's inadequate emergency procedure in that they did not manually extend the landing gear, as specified in the airplane flight manual. A factor relating to the accident was: the intermittent operation of the extend solenoid in the nose gear…Apr 1, 1996 · N999TF · Substantial damageNTSB NYC96LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Matawan, NJthe pilot's misjudgment of altitude and distance during final approach.Mar 31, 1996 · N9101P · Substantial damageNTSB LAX96LA150Accident · Minor injuriesLimited investigationFinal reportLampert Revolution M500 · San Carlos, CAthe pilot's failure to recognize a drive train disengagement and initiate an autorotation. The inadequate engine-to-transmission drive belt/pulley design, and the pilot's limited training and experience in rotorcraft operations were factors in this accident.Mar 31, 1996 · N750GL · Substantial damageNTSB NYC96FA078Accident · 1 fatalField investigationFinal reportCessna 150J · Warwick, NYthe pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion. A related factor was the pilot's lack of recent experience.Mar 24, 1996 · N5587G · DestroyedNTSB FTW96LA154Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Slidell, LAthe pilot's failure to maintain aircraft control during the approach, and his failure to execute a go-around. A factor was the gusting wind.Mar 24, 1996 · N9385T · Substantial damageNTSB CHI96FA117Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Carrollton, OHthe pilot's inadequate compensation for the crosswind condition, his failure to maintain directional control, and his failure not raise the landing flaps during the go-around. The crosswind was a factor.Mar 24, 1996 · N7452W · DestroyedNTSB FTW96LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Fredericksburg, TXfailure of the pilot to maintain adequate airspeed during the approach and go-around, which resulted in a stall and subsequent collision with the ground. Factors relating to the accident were: the high, gusty, crosswind conditions, and the pilot's lack of…Mar 22, 1996 · N73356 · DestroyedNTSB IAD96FA050Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Marion, VAthe pilot's failure to maintain adequate altitude/clearance during the instrument approach (FAF/Outer Marker to Threshold IFR), which resulted in the in-flight collision with trees. A related factor was the foggy weather conditions.Mar 18, 1996 · N54839 · DestroyedNTSB FTW96LA150Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Salado, TXthe pilot's failure to maintain altitude/clearance from the power line.Mar 16, 1996 · N26923 · Substantial damageNTSB LAX96LA135Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 · Minden, NVthe pilot's misjudgment of distance and altitude from the airport, which resulted in an off-airport forced landing.Mar 14, 1996 · N851BG · Substantial damageNTSB NYC96FA073Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Bridgeport, WVThe pilot's inablility to maintain aircraft control due to a full nose down trim condition, which resulted in a loss of control and collision with terrain.Mar 11, 1996 · N222WR · DestroyedNTSB ATL96LA063Accident · No injuriesLimited investigationFinal reportCessna 172RG · Gulf Shores, ALThe failure of both pilots to maintain an adequate visual lookout. A factor was the lack of position reports via radio by the pilot of the helicopter.Mar 10, 1996 · N6612V · 2 aircraft · Substantial damageNTSB ATL96LA062Accident · No injuriesLimited investigationFinal reportCessna 152U · Rincon, GAInaccurate fuel consumption calculations by the pilot, and an inadequate supply of fuel, which resulted in fuel exhaustion and subsequent nose over of the airplane, during a forced landing on uneven terrain with high vegetation (small trees).Mar 10, 1996 · N68129 · DestroyedNTSB MIA96LA097Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLthe failure of the pilot-in-command to apply caburetor heat before reducing the throttle to simulate an engine failure. Contributing to the accident was the carburetor icing conditions and the unsuitable terrain encountered during the emergency descent.Mar 9, 1996 · N704XQ · Substantial damageNTSB ATL96LA060Accident · No injuriesLimited investigationFinal reportCessna 172D · Macon, GAThe pilot's improper planning/decision, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.Mar 9, 1996 · N2681U · Substantial damageNTSB MIA96IA094Incident · 1 fatalIncident investigationFinal reportPiper PA-31-310 · Charlotte, NCfatal incapacitation of the pilot due to a heart attack.Mar 6, 1996 · N7451L · No damageNTSB ATL96LA057Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cummings, GAthe pilot's abrupt retraction of the flaps and his failure to coordinate airspeed with flap retraction which resulted in the lack of airplane performance.Mar 4, 1996 · N7176G · DestroyedNTSB MIA96FA089Accident · 2 fatalField investigationFinal reportCessna 172D · Hawthorne, FLthe pilot's failure to maintain the proper glidepath during an instrument approach.Mar 2, 1996 · N2456U · DestroyedNTSB FTW96LA137Accident · Minor injuriesLimited investigationFinal reportBell B206-BIII · Chandler, OKthe reported loss of engine power during a go-around for undetermined reason(s).Mar 2, 1996 · N312RS · DestroyedNTSB SEA96LA065Accident · No injuriesLimited investigationFinal reportNicholson Thorp T18CWS · Grantsville, UTthe pilot's failure to maintain clearance from a powerline. A transmission wire and an oil pressure reading of zero were factors.Feb 28, 1996 · N24WN · Substantial damageNTSB CHI96FA095Accident · 1 fatalField investigationFinal reportCessna 310 · Portland, INthe pilot's failure to maintain an altitude adequate for terrain clearance. A factor was the weather.Feb 22, 1996 · N5024J · DestroyedNTSB MIA96LA085Accident · Minor injuriesLimited investigationFinal reportPiper PA-30-160 · St. Petersburg, FLthe pilot's failure to maintain the glide slope and becoming distracted by a passenger.Feb 21, 1996 · N8740Y · Substantial damageNTSB FTW96LA127Accident · No injuriesLimited investigationFinal reportCessna 175A · San Angelo, TXa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the forced landing.Feb 21, 1996 · CGROA · Substantial damageNTSB FTW96LA123Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Dallas, TXfailure of the pilot to use a more favorable runway, and his failure to go-around, when he realized the airplane would not touch down at the proper touchdown point. Factors relating to the accident were: the inoperative flap motor, failure of the pilot to…Feb 21, 1996 · N4825J · Substantial damageNTSB IAD96IA048Incident · Minor injuriesIncident investigationFinal reportBoeing 767-2B7 · Pittsburgh, PAthe in-flight encounter with unforecast turbulence.Feb 20, 1996 · N656US · No damageNTSB MIA96LA081Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Miami, FLFailure of the pilot to maintain proper runway alignment during a go-around, resulting in a collision with trees beside the runway. The crosswind was a related factor.Feb 18, 1996 · N2923B · Substantial damageNTSB LAX96LA112Accident · 1 fatalLimited investigationFinal reportSteeves KR2 · San Diego, CAfailure of the pilot to maintain an adequate airspeed margin above stall, while at low altitude in the traffic pattern. His decision to explore the slow speed envelope of the aircraft at low altitude was a related factor.Feb 17, 1996 · N395DS · DestroyedNTSB FTW96LA122Accident · No injuriesLimited investigationFinal reportCessna 182P · New Orleans, LAThe pilot not following procedures and directives in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing weather conditions and lack of suitable terrain for landing.Feb 17, 1996 · N9901M · Substantial damageNTSB ATL96FA049Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Johns Island, SCthe pilot's inadequate evaluation of the weather conditions and the continued flight into icing conditions which resulted in the loss of engine power. A factor was conditions favorable for the formation of carburetor icing.Feb 17, 1996 · N3052T · Substantial damageNTSB CHI96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Warren, MNthe dual student's failure to maintain a proper glidepath and inadequate supervision by the instructor.Feb 13, 1996 · N145ND · Substantial damage