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 BFO94LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Hollis, NHThe pilot's inadequate preflight inspection which failed to detect contaminated fuel which resulted in fuel starvation.Apr 30, 1994 · N5907G · Substantial damageNTSB ATL94LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bainbridge, GAThe unsecured rear seat back which fell forward and jammed the flight controls.Apr 30, 1994 · N6879B · Substantial damageNTSB LAX94IA206Incident · Minor injuriesIncident investigationFinal reportBoeing 737-209 · Honolulu, HIThe failure of the battery transfer relay resulting in multiple system failures.Apr 27, 1994 · N804AL · No damageNTSB BFO94LA078Accident · Minor injuriesLimited investigationFinal reportCameron ET-90 · Louisville, KYThe pilot-in-command's failure to maintain clearance from wires during the landing approach. A factor related to the accident is a downdraft that exceeded the balloon's available climb capability.Apr 26, 1994 · N898ET · Substantial damageNTSB BFO94LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Westminster, MDThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and the inflight loss of control. A factor is the pilot's failure to do a go around.Apr 25, 1994 · N11522 · DestroyedNTSB BFO94LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · New Carlisle, OHThe pilot's inattention to the mixture control which was inadvertently placed in the idle cut-off position by the passenger and resulted in a loss of engine power. A factor is the pilot's inadequate planning.Apr 24, 1994 · N5855W · Substantial damageNTSB LAX94LA202Accident · Minor injuriesLimited investigationFinal reportMooney M20-C · Page, AZThe failure of the pilots to assure that ample fuel would be available to reach the airport. The generator failure and an inoperative fuel quantity gage were contributing factors.Apr 23, 1994 · N6524U · Substantial damageNTSB BFO94LA074Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Plymouth, MAThe pilot's failure to maintain adequate airspeed.Apr 23, 1994 · N2167 · Substantial damageNTSB MIA94FA125Accident · 2 fatalField investigationFinal reportBell 47D1 · Marathon, FLSeparation of the tail rotor gearbox and tail rotor blades for an undetermined reason. Factors related to the accident were: failure of maintenance personnel to follow the proper maintenance procedure after a previous tail rotor strike, and failure to conduct…Apr 22, 1994 · N9660 · DestroyedNTSB BFO94FA071Accident · 4 fatalField investigationFinal reportBell 412/SP · Bluefield, VAThe pilot's failure to intercept the final approach course, and his improper execution of the instrument approach procedure. Factors which contributed to the accident were: the weather conditions, and the failure of the air traffic controller to adequately…Apr 22, 1994 · N70AM · DestroyedNTSB FTW94LA136Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Laredo, TXThe fuel exhaustion induced power loss due to the pilot's inadequate preflight and his failure to refuel the airplane prior to departure. A factor was the lack of suitable terrain for the forced landing.Apr 21, 1994 · N44AC · Substantial damageNTSB CHI94DEE01Accident · 2 fatalFinal reportRemote Sensing Cirrus VK-30 · Lk In The Hills, ILfuel starvation resulting from the modification of the fuel system. A factor was the modification to the fuel system.Apr 19, 1994 · N108P · DestroyedNTSB LAX94LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Mt Home Village, CAA loss of engine power due to undetermined reasons. The failure of the student pilot to properly plan his airport traffic pattern to reach the runway or other suitable forced landing area in the event of a loss of engine power was a factor in the accident.Apr 17, 1994 · N9276U · Substantial damageNTSB BFO94LA069Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Beverly, MAThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and collision with the ground.Apr 15, 1994 · N84409 · DestroyedNTSB ATL94LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Raleigh, NCThe pilot's inadequate in-flight fuel planning that resulted in fuel starvation.Apr 15, 1994 · N6380W · DestroyedNTSB CHI94LA130Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Chesterfield, MOFailure of the pilot to follow proper IFR procedures and maintain proper altitude during the approach. Factors related to the accident were: darkness, the weather conditions, and failure of the approach controller to issue an IFR transponder code to the…Apr 11, 1994 · N9187M · DestroyedNTSB NYC94FA075Accident · 4 fatalField investigationFinal reportCessna 152 · E. Farmingdale, NYFailure of the local tower controller to adequately control the arrival of the airplanes, and inadequate visual lookout by the Piper PA-24 pilot. A factor related to the accident was: the local controller's improper phraseology in sequencing the airplanes.Apr 9, 1994 · N757KN · 2 aircraft · DestroyedNTSB MIA94LA113Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Tallahassee, FLThe pilot-in-command's improper compensation for wind conditions and lack of rudder input during an attempted go-around that resulted in loss of control in flight and collision with terrain. Rudder input was needed to compensate for the p-factor generated by…Apr 6, 1994 · N2477E · Substantial damageNTSB CHI94FA128Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Alliance, NEThe pilot's spatial disorientation and inadvertant entry into a spiral dive. Factors were the pilot's lack of total instrument experience and the weather conditions of blowing snow and turbulence.Apr 4, 1994 · N5399Y · DestroyedNTSB LAX94LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Gasquet, CAThe failure of the pilot to adequately compensate for the cross- wind conditions, and to maintain proper alignment with the runway.Apr 3, 1994 · N6290D · DestroyedNTSB MIA94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLFailure of the instructor pilot (CFI) to maintain minimum control speed (VMC) during the go-around, which resulted in a loss of control. A factor related to the accident was: the delay by the dual student to extend the landing gear.Apr 2, 1994 · N8303G · Substantial damageNTSB MIA94IA110Incident · No injuriesIncident investigationFinal reportBoeing 727-243 · Orlando, FLThe total failure of the left main landing gear door actuator fitting due to fatigue cracking in the fitting. Contributing to the accident was inadequate written inspection procedures by the aircraft manufacturer.Apr 2, 1994 · N59412 · Minor damageNTSB FTW94FA114Accident · Serious injuriesField investigationFinal reportAerospatiale AS-350-B2 · Telluride, COFailure by the pilot to maintain control of the aircraft. Factors were unfavorable winds and improper approach planning.Apr 1, 1994 · N59715 · Substantial damageNTSB CHI94LA125Accident · No injuriesLimited investigationFinal reportCessna T210-M · Pomona, MOThe seperation of the landing gear door actuator, resulting in total loss of hydraulic fluid.Mar 31, 1994 · N732YK · Substantial damageNTSB FTW94LA112Accident · No injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe loss of engine power for undetermined reasons. Factors were the wire strike and lack of suitable terrain.Mar 30, 1994 · N4646B · Substantial damageNTSB NYC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hopedale, MAthe certified flight instructor's delay in taking remedial action by not initiating the go-around, resulting in the in-flight collision with the tree.Mar 27, 1994 · N2598Q · Substantial damageNTSB ATL94FA071Accident · 1 fatalField investigationFinal reportBeech 58TC · Gulf Shores, ALThe pilot's failure to maintain aircraft control during the base turn. Factors were the pilot's inadequate preflight, high winds with gusts at the airport, and the pilot's diverted attention due to the open baggage door.Mar 27, 1994 · N200DL · DestroyedNTSB SEA94LA091Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Woodland, WAAirspeed was not maintained.Mar 26, 1994 · N5537E · Substantial damageNTSB NYC94LA072Accident · Serious injuriesLimited investigationFinal reportRandolph Flagg Boredom Fighter · Norridgewock, METhe loss of engine power for undetermined reasons.Mar 23, 1994 · N1932F · Substantial damageNTSB FTW94LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Rayville, LAThe pilot's failure to maintain adequate airspeed during the turn to final approach.Mar 22, 1994 · N2966M · Substantial damageNTSB MIA94FA098Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Sarasota, FLFailure of the pilot(s) to maintain control of the airplane due to spatial disorientation. Factors related to the accident were: A malfunction that resulted in a loss of normal radio transmission, and the pilot(s) lack of recent experience in this make and…Mar 21, 1994 · N55999 · DestroyedNTSB NYC94FA067Accident · 1 fatalField investigationFinal reportCessna 414 · Defiance, OHThe pilot's inadequate inflight decision and planning, which resulted in fuel exhaustion and the total loss of engine power.Mar 19, 1994 · N1576T · DestroyedNTSB FTW94LA107Accident · No injuriesLimited investigationFinal reportCessna 210L · Haskell, OKWas the loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Mar 19, 1994 · N8145L · Substantial damageNTSB NYC94FA064Accident · 1 fatalField investigationFinal reportSwearingen SA-26AT · Winchester, VAThe pilot's decision to operate the airplane with known deficiencies in the fuel quantity measuring system which resulted in a power loss due to fuel starvation, followed by improper emergency procedures which resulted in a loss of control inflight and…Mar 18, 1994 · N20PT · DestroyedNTSB FTW94LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Albuquerque, NMThe CFI rated second pilot's failure to maintain the ILS glideslope. A factor was the dark night and lack of supervision.Mar 17, 1994 · N8933N · Substantial damageNTSB BFO94LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Hagerstown, MDThe loss of partial engine power for undetermined reasons.Mar 17, 1994 · N4465T · Substantial damageNTSB MIA94LA093Accident · Serious injuriesLimited investigationFinal reportSIAI-Marchetti F-260-C · Opa-Locka, FLThe failure of the pilot-in-command to assure proper positioning of the fuel selector resulting in fuel starvation.Mar 13, 1994 · N260CB · Substantial damageNTSB LAX94LA163Accident · No injuriesLimited investigationFinal reportRockwell 681 · Phoenix, AZthe failure of the hydraulic and nitrogen system pressure lines, due to an inadequate maintenance inspection program, which failed to detect the corrosion condition of the lines.Mar 13, 1994 · N78CH · Substantial damageNTSB FTW94LA094Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Duncan, OKThe pilot's selection of the wrong engine for shut down. A factor was the lack of suitable terrain for the forced landing.Mar 13, 1994 · N2297P · Substantial damageNTSB SEA94LA079Accident · Minor injuriesLimited investigationFinal reportKelley Stits SA6B · Snohomish, WAThe pilot's failure to maintain adequate airspeed. Factors include a pole off the departure end of the runway.Mar 10, 1994 · N4696 · Substantial damageNTSB CHI94LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Madison, WIThe pilot-in-command's poorly planned approach and failure to maintain the proper glidepath. The dark night was a factor.Mar 7, 1994 · N2145T · Substantial damageNTSB MIA94LA086Accident · 1 fatalLimited investigationFinal reportPiotrowski GIP-1 · Bunnell, FLThe failure of the pilot-in-command to maintain rotor RPM in the gyrocopter on approach. Contributing to the accident was the lack of total experience in gyrocopter flying.Mar 6, 1994 · N7014B · Substantial damageNTSB ATL94LA059Accident · No injuriesLimited investigationFinal reportPZL-Bielsko SZD-55-1 · Mcminnville, TNThe failure of the pilot to maintain control of the aircraft during the landing approach.Mar 5, 1994 · N551TJ · DestroyedNTSB NYC94FA052Accident · 2 fatalField investigationFinal reportCessna 340 · Westhampton, NYThe pilot's inadequate inflight decision which resulted in ice accretion on the aircraft, degradation of aircraft performance, an aerodynamic stall, loss of control and inflight collision with the ground. Factors were icing conditions.Mar 4, 1994 · N512SK · DestroyedNTSB FTW94FA090Accident · 1 fatalField investigationFinal reportCessna P337H · N. Little Rock, ARFailure of the pilot to maintain control of the aircraft, while maneuvering to land. Factors related to the accident were: darkness and possible spatial disorientation.Mar 2, 1994 · N2QY · DestroyedNTSB CHI94GA093Accident · 4 fatalFinal reportCessna 401A · Minot, NDFailure of the pilot to maintain proper altitude during a missed approach. Factors related to the accident were: the unfavorable weather and snow covered terrain.Feb 24, 1994 · N4071Q · DestroyedNTSB MIA94LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Tampa, FLThe student pilot's improper use of the flight controls and failure to maintain sufficient airspeed on final approach for landing resulting in an inadvertant stall and subsequent collision with terrain.Feb 22, 1994 · N1665Q · Substantial damageNTSB BFO94LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Berlin, NJThe pilot not maintaining clearance from obstacles (trees) during final approach which resulted in a collision with a tree and a subsequent uncontrolled descent until colliding with the ground.Feb 22, 1994 · N23AL · Substantial damageNTSB CHI94LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Grand Forks, NDFuel starvation due to the improper positioning of the fuel tank selector by the student pilot.Feb 21, 1994 · N66ND · Substantial damageNTSB LAX94LA128Accident · 1 fatalLimited investigationFinal reportStinson 108-3 · Redlands, CAThe pilot's impairment of judgment and performance due to alcohol, which led to his improper planning/decision, and his failure to maintain proper altitude. Factors related to the accident were: darkness and the pilot's lack of training/certification for…Feb 20, 1994 · N6009M · Destroyed