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 NYC95LA189Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Erwinna, PAthe flight instructor's inadequate supervision during the final approach which resulted in the student flying a low approach and a subsequent collision with the trees. A factor relating to the accident was the student pilot's failure to maintain a proper…Aug 13, 1995 · N5750S · Substantial damageNTSB LAX95LA293Accident · No injuriesLimited investigationFinal reportPitts S-2B · Phoenix, AZThe inadequate supervision by the instructor pilot by allowing the trainee to initiate a late go-around from a simulated forced landing.Aug 12, 1995 · N540RJ · Substantial damageNTSB LAX95LA291Accident · Serious injuriesLimited investigationFinal reportKinner Sportster K · Los Banos, CAthe pilot's failure to maintain minimum control airspeed resulting in a stall, and not maintaining proper altitude on final approach. Contributing to the accident was the unfavorable wind condition.Aug 12, 1995 · N100AA · Substantial damageNTSB CHI95LA277Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · New Prague, MNthe failure of the pilot to maintain adequate airspeed to permit control of the aircraft and to prevent an inadvertent stall. Contributing factors include gusty wind conditions and turbulence.Aug 12, 1995 · N70369 · DestroyedNTSB CHI95LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Wheeling, ILthe pilot's abrupt raising of the flaps during the attempted go-around and the resulting stall.Aug 12, 1995 · N43847 · Substantial damageNTSB MIA95LA201Accident · No injuriesLimited investigationFinal reportCessna 150L · Opa Locka, FLThe pilot-in-command's improper use of flaps during an attempted go-around.Aug 10, 1995 · N19561 · Substantial damageNTSB LAX95LA286Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Overgaard, AZthe pilot's improper use of the mixture controls, failure to maintain a proper glidepath, failure to maintain an adequate approach airspeed, and failure to maintain directional control of the aircraft.Aug 10, 1995 · N14361 · Substantial damageNTSB ANC95LA132Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's abrupt (improper) use of the throttle.Aug 8, 1995 · N144Q · Substantial damageNTSB SEA95LA173Accident · No injuriesLimited investigationFinal reportCessna TU206F · Ennis, MTThe pilot-in-command's inaccurate weather evaluation and continued flight into adverse weather. The microburst was a factor.Aug 7, 1995 · N777FN · Substantial damageNTSB ATL95LA160Accident · No injuriesLimited investigationFinal reportBell UH-1H · Montgomery, ALthe pilot's failure to maintain clearance from the trees.Aug 7, 1995 · N794CF · Substantial damageNTSB NYC95LA182Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Owego, NYThe pilot's inadequate evaluation of weather conditions which resulted in an encounter with a downdraft, inflight loss of control, and a collision with a vehicle.Aug 6, 1995 · N3716G · Substantial damageNTSB FTW95LA331Accident · No injuriesLimited investigationFinal reportGrumman G-164A · St.Francisville, LAThe pilot's failure to maintain clearance with the obstruction on short final. A factor was the low visibility.Aug 5, 1995 · N732Y · Substantial damageNTSB CHI95LA261Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Mecosta, MIthe student's failure to maintain adequate airspeed, and the pilot-in-command's (CFI) inadequate remedial action.Aug 5, 1995 · N74PB · Substantial damageNTSB LAX95LA278Accident · 1 fatalLimited investigationFinal reportFox Peregrine PJ-2 · Minden, NVa failure of the wing flap control system due to inadequate design, which led to an asymmetrical flap deployment during a critical flight condition and in-flight loss of control. A related factor was the lack of a split-flaps warning system.Aug 4, 1995 · N62PJ · DestroyedNTSB FTW95LA328Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Searcy, ARThe inadvertent stall as a result of the pilot's failure to maintain airspeed during the approach.Aug 2, 1995 · N526Y · Substantial damageNTSB SEA95LA169Accident · No injuriesLimited investigationFinal reportCessna 172C · Red Lodge, MTThe pilot's failure to maintain airspeed. The pilot's inadequate preflight planning/preparation and selection of unsuitable terrain for landing were factors.Aug 1, 1995 · N1364Y · Substantial damageNTSB NYC95LA180Accident · No injuriesLimited investigationFinal reportWright JUNGSTER-I · Mansfield, MAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and subsequent uncontrolled descent and collision with the terrain.Jul 31, 1995 · N26241 · Substantial damageNTSB LAX95LA275Accident · 1 fatalLimited investigationFinal reportBeech P35 · Elko, NVthe failure of the pilot to maintain airspeed in a turn during high wind conditions while executing a go-around at a low altitude, which resulted in an inadvertent stall and an uncontrolled descent into the ground.Jul 29, 1995 · N9599Y · DestroyedNTSB FTW95LA317Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mccrory, ARThe loss of engine power due to a cracked cylinder. A factor was the lack of suitable terrain for the forced landing.Jul 27, 1995 · N6636Q · Substantial damageNTSB ANC95LA115Accident · Minor injuriesLimited investigationFinal reportBell 206B · Talkeetna, AKThe inadvertent restriction of the anti-torque pedal by the pilot's foot, while the pilot (an incomplete paraplegic) was attempting to land.Jul 26, 1995 · N85CA · Substantial damageNTSB ANC95LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot-in-command's failure to maintain airspeed.Jul 26, 1995 · N8792D · Substantial damageNTSB SEA95LA162Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Cody, WYThe pilot's failure to refuel which resulted in a loss of power due to fuel exhaustion.Jul 25, 1995 · N9492T · Substantial damageNTSB NYC95IA178Incident · No injuriesIncident investigationFinal reportBritish Aerospace RJ-70 · New York, NYthe aileron interconnect became uncoupled, when an abrupt and/or large aileron movement was made in response to a wake turbulence encounter, while on a VOR approach with the autopilot engaged. A factor relating to the incident was: inadequate in-flight…Jul 25, 1995 · N833BE · No damageNTSB CHI95LA235Accident · No injuriesLimited investigationFinal reportCessna 172 · Springfield, MOimproper in-flight planning/decision by the pilot, and his continued flight into adverse weather conditions, which resulted in an uncontrolled altitude deviation and collision with terrain. Factors relating to the accident were: the adverse weather conditions.Jul 24, 1995 · N55212 · Substantial damageNTSB NYC95LA171Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Avoca, PAthe pilot's poor inflight decision and improper fuel management resulting in fuel exhaustion and a subsequent forced landing over rocky terrain.Jul 23, 1995 · N1613P · Substantial damageNTSB ATL95LA141Accident · Minor injuriesLimited investigationFinal reportWheeler Fisher Classic · Marietta, GAimproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power; and the pilot's failure to maintain adequate airspeed, while turning to make a forced landing, which resulted in a stall and impact with the terrain.Jul 22, 1995 · N942RW · Substantial damageNTSB FTW95FA306Accident · 1 fatalField investigationFinal reportMooney M20J · Crawford, COpilot incapacitation due to preexisting medical condition.Jul 19, 1995 · N700CF · DestroyedNTSB NYC95FA162Accident · 1 fatalField investigationFinal reportCessna 140 · Danielsville, PAThe flight crew's improper in-flight planning/decision, and failure to maintain adequate clearance (or altitude) from mountainous terrain. Factors relating to the accident were: darkness, fog, low clouds, and the high terrain.Jul 18, 1995 · N72546 · DestroyedNTSB SEA95LA150Accident · No injuriesLimited investigationFinal reportCessna 170B · Afton, WYDirectional control was not maintained. Factors to the accident were: inadequate remedial action and a stall not identified.Jul 17, 1995 · N3165B · Substantial damageNTSB FTW95LA299Accident · Serious injuriesLimited investigationFinal reportSlingsby T-51 · Odessa, TXThe pilot's failure to maintain airspeed required for flight, resulting in an inadvertent stall/spin at low altitude. A factor was the windshear.Jul 15, 1995 · N88966 · Substantial damageNTSB FTW95LA298Accident · 1 fatalLimited investigationFinal reportBradley Dragonfly · Silver City, NMPilot incapacitation due to a heart attack.Jul 15, 1995 · N826DB · Substantial damageNTSB FTW95FA300Accident · Serious injuriesField investigationFinal reportBeech C35 · Plano, TXFuel starvation due to the improper position of the fuel selector, and failure the pilot to follow emergency procedures.Jul 15, 1995 · N1997D · Substantial damageNTSB NYC95LA161Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Warren, VTa failed elevator cable which resulted in an inflight loss of control and uncontrolled contact with trees.Jul 13, 1995 · N5204G · DestroyedNTSB MIA95LA182Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Goodman, MSThe pilot's failure to maintain flying airspeed which resulted in an aerodynamic stall.Jul 13, 1995 · N76LS · Substantial damageNTSB MIA95FA183Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Hilton Head Isl, SCloss of engine power for undetermined reasons, and the unsuitable terrain encountered during the emergency landing. A factor in the accident was the pilot's extension of the downwind leg which prevented landing on the intended runway following loss of engine…Jul 13, 1995 · N38188 · DestroyedNTSB FTW95LA295Accident · No injuriesLimited investigationFinal reportCessna 172L · Porter, TXThe loss of engine power for undetermined reasons, and the pilot's misjudgment of distance and speed resulting in overshooting the landing.Jul 13, 1995 · N3967Q · Substantial damageNTSB FTW95LA292Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Van Buren, ARA partial loss of engine power for undetermined reasons, and the pilot's misjudgment of distance and speed during the precautionary landing resulting in an overshoot.Jul 13, 1995 · N9869K · Substantial damageNTSB FTW95FA294Accident · Serious injuriesField investigationFinal reportCessna 310D · Alamosa, COTotal loss of power in both engines due to flooding after the pilot had placed both fuel pump switches in the high boost position and moved the mixture controls to the full rich position. A factor related to the accident was: the lack of suitable terrain for…Jul 13, 1995 · N6976T · DestroyedNTSB SEA95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mccall, IDImproper planning/decision by the pilot, which resulted in his failure (or inability) to remain clear of terrain after initiating a go-around. Factors relating to the accident were: the unfavorable terrain and wind conditions (including downdrafts).Jul 11, 1995 · N82555 · Substantial damageNTSB NYC95LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Minersville, PAthe student pilot's improper go-around procedure, which resulted in an inadvertent stall/mush into trees.Jul 11, 1995 · N15157 · Substantial damageNTSB LAX95LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Van Nuys, CAfuel starvation resulting from the failure of the pilot to properly configure the fuel selector to a tank containing fuel during the landing approach.Jul 11, 1995 · N243CV · Substantial damageNTSB NYC95LA145Accident · Serious injuriesLimited investigationFinal reportMooney M-20C · Monogahela, PAThe failure of the pilots of the monney M20C, N2763W, and the Piper PA-28, N7416R, to see and avoid each other.Jul 9, 1995 · N2763W · 2 aircraft · DestroyedNTSB NYC95LA144Accident · 1 fatalLimited investigationFinal reportKoval Quickie II · Akron, OHthe pilot's improper maneuver during the turn to final approach, which resulted in an inadvertent stall/spin, and collision with the terrain. Factors in this accident were the pilot's lack of experience in this make and model, and his lack of recent…Jul 9, 1995 · N4372V · DestroyedNTSB MIA95LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLThe failure of the pilot to maintain directional control during a go-around from a bounced landing.Jul 7, 1995 · N95633 · Substantial damageNTSB CHI95LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Culver, INThe student pilot's failure to maintain directional control of the airplane, while performing a go-around. A factor relating to the accident was: the proximity of trees beside the runway.Jul 7, 1995 · N632FL · Substantial damageNTSB ATL95FA128Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCThe pilot's failure to follow proper IFR procedures by descending below the decision height. Factors relating to the accident were the weather conditions and the dark night.Jul 5, 1995 · N15743 · DestroyedNTSB SEA95LA139Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Orting, WAThe pilot's failure to see and avoid the cable.Jul 4, 1995 · N9196F · Substantial damageNTSB ATL95LA130Accident · No injuriesLimited investigationFinal reportCessna 150L · Holly Ridge, NCthe pilot diverted his attention and failed to maintain clearance from obstacles.Jul 2, 1995 · N28445 · Substantial damageNTSB ATL95LA125Accident · No injuriesLimited investigationFinal reportLuscombe 8A/E · Williamson, GAThe pilot in command's failure to compensate for wind conditions which resulted in a failure to maintain control of the aircraft when a windshear was encountered.Jul 2, 1995 · N2853K · Substantial damageNTSB SEA95LA131Accident · No injuriesLimited investigationFinal reportCessna 172F · Homedale, IDThe pilot misjudged distance and altitude during the approach. The downdraft was a factor.Jun 27, 1995 · N4298C · Substantial damage