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 CHI90LA112Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Manistique, MIThe pilot allowing the airplane to run out of fuel.Apr 11, 1990 · N42417 · DestroyedNTSB LAX90FA138Accident · 3 fatalField investigationFinal reportBeech A36 · Kneeland, CAThe pilot's improper use of IFR procedures by failing to maintain the minimum descent altitude for the segment of the approach that he was flying. The hilly/mountainous terrain was a related factor.Apr 7, 1990 · N3674B · DestroyedNTSB CHI90FA108Accident · 1 fatalField investigationFinal reportBeech M35 · Romeo, MIA loss of control due to physical incapacitation (heart attack).Apr 5, 1990 · N9829R · DestroyedNTSB LAX90LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chino, CAFuel starvation due to the fuel tank outlets becoming unported as the aircraft maneuvered for landing. A factor was the pilot's preflight planning failed to insure that he had adequate fuel for the flight.Apr 3, 1990 · N9426K · Substantial damageNTSB FTW90DPJ04Accident · 1 fatalFinal reportMooney M20F · Bethany, OKLoss of control in flight when the pilot stalled and spun the airplane inadvertently while turning to the base leg. A factor was lack of night flying time.Apr 3, 1990 · N3514X · DestroyedNTSB CHI90IA106Incident · No injuriesIncident investigationFinal reportNihon YS-11A-600F · West Lafayette, INAn undetected accumulation of ice on the horizontal stabilizer. Relating factors were the manufacturer's lack of information and aircraft manuals relative to the understanding of, and appropriate procedures to prevent the loss of control.Apr 3, 1990 · N112MP · No damageNTSB ATL90LA091Accident · No injuriesLimited investigationFinal reportPZL 80 · Wilmington, NCPilot's failure to properly adjust the throttle friction which resulted in the disconnection of the entire assembly.Apr 3, 1990 · N2246U · Substantial damageNTSB MKC90LA078Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Belleville, KSThe pilot's inadequate remedial action in response to the loss of power in the right engine, which resulted in his failure to attain the proper touchdown point for landing.Apr 2, 1990 · N18HF · Substantial damageNTSB ANC90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKThe pilot failed to maintain proper obstacle clearance altitude during his final approach.Apr 1, 1990 · N6981B · Substantial damageNTSB LAX90FA128Accident · 2 fatalField investigationFinal reportCessna P210N · La Verne, CAThe pilot's improper use of powerolant controls which resulted in an excessive rich mixture and power loss. In addition, the pilot failed to maintain adequate airspeed during the forced landing.Mar 30, 1990 · N732CG · DestroyedNTSB ANC90FA046Accident · No injuriesField investigationFinal reportCessna 150 · Birchwood, AKCarburetor ice due to the pilot's improper use of the carburetor heat. Factors related to the accident were: carburetor icing conditions, unfavorable wind, and the snow covered terrain.Mar 29, 1990 · N61272 · Substantial damageNTSB FTW90LA087Accident · Serious injuriesLimited investigationFinal reportBeech 100 · Uvalde, TXImproper IFR procedure by the pilot by not maintaining the minimum descent altitude (mda) for that segment of the approach. Factors related to the accident were: darkness, low ceiling, fog, and rain.Mar 28, 1990 · N696JB · DestroyedNTSB NYC90LA082Accident · Serious injuriesLimited investigationFinal reportSchweizer S2-33A · Brookhaven, NYCause of the accident was a hard landing after the pilot stalled the glider while turning onto final approach.Mar 25, 1990 · N2055T · Minor damageNTSB LAX90LA124Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Sandy Valley, NVThe pilot's poor flight planning and poor inflight decisions resulting in becoming lost and exhausting fuel before landing.Mar 25, 1990 · N6181B · Substantial damageNTSB LAX90DUK01Accident · Serious injuriesFinal reportKolb Twinstar · Halfmoon Bay, CAFailure of the pilot to maintain adequate airspeed and altitude.Mar 25, 1990 · N287PH · Substantial damageNTSB ANC90FA042Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Wasilla, AKThe failure of the PIC to maintain sufficient airspeed to preclude a stall.Mar 24, 1990 · N68596 · Substantial damageNTSB SEA90LA054Accident · 1 fatalLimited investigationFinal reportde Havilland DH 82A · White City, ORPilot's delay in taking remedial action to prevent an undershoot. His misjudgement of distance and altitude on final approach were related factors.Mar 20, 1990 · N353FG · Substantial damageNTSB LAX90FA123Accident · 1 fatalField investigationFinal reportCessna 172N · Buena Park, CAThe pilot not maintaining the prescribed minimum descent altitude during an instrument approach.Mar 19, 1990 · N2985E · DestroyedNTSB NYC90LA079Accident · No injuriesLimited investigationFinal reportCessna 172H · Andover, NJThe pilot failed to maintain control of the aircraft after encounter with turbulence during landing.Mar 18, 1990 · N8213L · Substantial damageNTSB MIA90FA091Accident · 2 fatalField investigationFinal reportWohlers Steen/Skybolt · Quincy, FLInflight loss of control for undetermined reasons.Mar 17, 1990 · N98LW · DestroyedNTSB LAX90LA119Accident · No injuriesLimited investigationFinal reportRobinson R22 · Paso Robles, CAThe dual student pilot failed to maintain proper rotor/engine power and to relinquish the throttle control when the CFI attempted to reduce the power.Mar 16, 1990 · N8079Q · Substantial damageNTSB MIA90LA089Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Margate, FLLoss of power in both engines due to fuel exhaustion, resulting in a forced landing. A factor in the accident was that the pilot did not follow the flight manual to ensure that the fuel tanks were filled to capacity.Mar 15, 1990 · N7114Y · Substantial damageNTSB NYC90LA078Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Philadelphia, PAThe failure of the pilot to ensure sufficient fuel was on board for the intended flight, resulting in a power loss due to fuel exhaustion. Factors related to the accident were unsuitable terrain, and the failure of the pilot to divert in a timely manner.Mar 14, 1990 · N6513Z · Substantial damageNTSB DEN90LA084Accident · No injuriesLimited investigationFinal reportCessna 172I · Isabel, SDPilot's inadequate compensation for the wind conditions.Mar 11, 1990 · N35485 · Substantial damageNTSB FTW90LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bastrop, LAFailure of the pilot to maintain adequate airspeed for a go-around, which resulted in an inadvertent stall. Factors related to the accident were: the unfavorable wind condition and turbulence.Mar 10, 1990 · N3530E · Substantial damageNTSB FTW90LA080Accident · No injuriesLimited investigationFinal reportCessna 172N · Arlington, TXInstructor pilot's inadequate preflight procedures and failure to assure an adequate fuel supply for the proposed flight which led to the ensuing engine failure due to fuel exhaustion. Factors in the accident were the left fuel gauge's erroneous quantity…Mar 10, 1990 · N5193F · Substantial damageNTSB MIA90FA085Accident · 3 fatalField investigationFinal reportCessna 152 · Miramar, FLThe failure of the local controller to provide adequate traffic advisories to N7510H, the local controller's improper clearance to N7510H to descend through the traffic pattern, and the failure of the pilots of both aircraft to see and avoid each other.…Mar 9, 1990 · N48977 · 2 aircraft · DestroyedNTSB ANC90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-11 · King Salmon, AKPilot-in-command's failure to maintain airplane control.Mar 9, 1990 · N42239 · Substantial damageNTSB FTW90FA079Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Grand Prairie, TXThe CFI pilot failed to maintain flying speed, and the resultant inadvertent stall. Contributing to the accident was the existing low ceiling.Mar 8, 1990 · N2456P · DestroyedNTSB MIA90LA083Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rolling Fork, MSThe in-flight separation of the left aileron due to improper maintenance procedures and an inadequate aircraft preflight.Mar 6, 1990 · N23509 · Substantial damageNTSB LAX90DVM02Accident · Minor injuriesFinal reportLink VARI-EZE · Hollister, CAThe pilot's misjudgement of altitude and distance to the runway, while on final approach to land. The sunglare was a related factor.Mar 6, 1990 · N144BE · DestroyedNTSB FTW90LA076Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Mesquite, TXThe flight instructor's (cfi's) poor planning/decision, and his inadequate supervison of flight.Mar 4, 1990 · N5433M · Substantial damageNTSB CHI90LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wonder Lake, ILThe pilot's inadequate compensation for wind conditions, and his faiiure to maintain proper altitude on final approach to land. Factors related to the accident were: the trees & snowbank.Mar 3, 1990 · N55030 · Substantial damageNTSB FTW90LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Tomball, TXThe pilot in command's inaccurate fuel consumption calculations, which resulted in loss of engine power due to fuel exhaustion. Factors in this accident were: the dark night, and the soft/wet terrain.Feb 28, 1990 · N51402 · Substantial damageNTSB DEN90FA068Accident · 1 fatalField investigationFinal reportCessna 208A · Denver, COThe accumulation of structural ice and subsequent stalling of the aircraft. The icing condition was a related factor.Feb 28, 1990 · N820FE · DestroyedNTSB LAX90DUD02Accident · 1 fatalFinal reportReid Long EZ · Santa Monica, CAThe pilot's inflight loss of control due to spatial disorientation.Feb 26, 1990 · N100PY · DestroyedNTSB FTW90LA074Accident · No injuriesLimited investigationFinal reportHughes 269C · Houma, LALoss of engine power for an unknown reason.Feb 24, 1990 · N7504A · Substantial damageNTSB DEN90LA067Accident · Minor injuriesLimited investigationFinal reportHeindenreich Fokker DR-1 · Kalispell, MTFailure of the pilot to maintain adequate airspeed, which resulted in a stall. His lack of familiarity with this aircraft was a related factor.Feb 23, 1990 · N72517 · Substantial damageNTSB DEN90FA058Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Pueblo, COThe pilot's failure to maintain a proper glide path and sufficient altitude to clear obstacles.Feb 21, 1990 · N1666H · DestroyedNTSB ATL90LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Roxboro, NCThe pilot's failure to use the before landing checklist which requires the application of carburetor heat. Factors were soft terrain at accident site, and condition favorable for the formation of carburetor ice.Feb 21, 1990 · N6845G · Substantial damageNTSB MIA90IA072Incident · No injuriesIncident investigationFinal reportPiper PA-30 · Tallahassee, FLProper glidepath not maintained.Feb 19, 1990 · N7574Y · Minor damageNTSB CHI90IA084Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Chicago, ILFatigue failure of a first stage power turbine blade.Feb 19, 1990 · N361MQ · Minor damageNTSB BFO90LA027Accident · No injuriesLimited investigationFinal reportBeech H35 · College Park, MDThe pilot's inadequate compensation for wind conditions. The adverse wind was a related factor.Feb 19, 1990 · N7958D · Substantial damageNTSB BFO90DIG01Accident · 1 fatalFinal reportRolladen-Schneider LS-6 · Cabins, WVThe pilot failed to detect and remain clear of the power line which crossed the field in which he was attempting to land. Contributing to the accident was the moderate to severe turbulence in the area at the time of the accident.Feb 19, 1990 · N511M · Substantial damageNTSB LAX90LA096Accident · Serious injuriesLimited investigationFinal reportCessna A150M · Inyokern, CAThe pilot's failure to refuel which led to fuel exhaustion.Feb 17, 1990 · N9843J · Substantial damageNTSB BFO90IA028Incident · No injuriesIncident investigationFinal reportBoeing B-727-29 · Washington, DCThe accident was fatigue failure of the right main landing gear support link shaft because of overtorque.Feb 17, 1990 · N902TS · Minor damageNTSB FTW90FA069Accident · 2 fatalField investigationFinal reportBeech C-90 · Burlington, NCThe double engine power loss due to fuel starvation, the pilot's failure to follow procedures and directives by not engaging the right fuel transfer pump, and the inadvertent stall during the forced landing approach. A factor was the pilot's failure to refuel…Feb 13, 1990 · N110LT · DestroyedNTSB BFO90FA025Accident · 1 fatalField investigationFinal reportCessna 150F · Arden, NCThe pilot failure to maintain adequate altitude and clearance from a powerline during the landing approach. A factor was the unmarked powerline.Feb 13, 1990 · N8615S · DestroyedNTSB LAX90LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Long Beach, CAThe pilot's failure to raise the gear and flaps during a go-around resulting in a loss of control. A contributing factor was the pilot's lack of experience in a PA-23.Feb 10, 1990 · N2118P · DestroyedNTSB LAX90LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Bullhead City, AZThe pilot's miscalculation of the fuel remaining, which caused the engine to quit.Feb 10, 1990 · N1272Q · Substantial damage