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 ANC92LA068Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai, AKThe pilot's improper use of carburetor heat which resulted in loss of engine power due to carburetor ice.May 9, 1992 · N2940C · Substantial damageNTSB LAX92FA201Accident · 3 fatalField investigationFinal reportPiper PA-32-301 · Camarillo, CAThe pilot's failure to follow the published instrument missed approach procedure, and his failure to initiate a timely climb after being given a low altitude alert. Factors contributing to the accident were: the controller's failure to take positive action…May 6, 1992 · N8408V · DestroyedNTSB ATL92LA095Accident · No injuriesLimited investigationFinal reportCessna 180B · Jacksonville, NCThe pilot's failure to ensure an adequate supply of fuel for the planned flight; which resulted in fuel exhaustion. A factor was the high vegetation in the forced landing field.May 5, 1992 · N5127E · Substantial damageNTSB MIA92LA122Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Boynton Beach, FLPremature extension of the spoilers by the pilot during approach to land. Contributing to the accident was his lack of total experience in the type of aircraft and in-flight encounter with a downdraft.May 4, 1992 · N99946 · Substantial damageNTSB LAX92LA197Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Shelter Cove, CAThe complete loss of engine power for undetermined reasons.May 3, 1992 · N5468V · Substantial damageNTSB FTW92LA125Accident · Serious injuriesLimited investigationFinal reportShewmaker BD5 · Castroville, TXThe pilot's failure to maintain aircraft control during the flare. Factors were the engagement of the propeller feathering system and the pilot's total lack of experience in type aircraft and the slipped propeller pitch change system.May 3, 1992 · N68DS · DestroyedNTSB FTW92LA124Accident · No injuriesLimited investigationFinal reportCessna 172M · Canton, TXThe pilot's failure to maintain adequate airspeed and directional control during the attempted go around following an encounter with adverse wind conditions on approach.May 2, 1992 · N9623V · Substantial damageNTSB ATL92LA093Accident · 1 fatalLimited investigationFinal reportSchreder RS-15 · Benton, TNThe pilot's misjudged approach to the open field, which resulted in the forced landing on the obstacle lined road.May 2, 1992 · N17TM · Substantial damageNTSB BFO92LA054Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · South Boston, VAThe pilot failed to maintain obstacle clearance which resulted in inflight collision with a powerline.May 1, 1992 · N1837G · Substantial damageNTSB SEA92LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Dixie, IDThe pilot's inadequate compensation for the wind conditions. Factors relating to the accident were the high density attitude and the downdraft.Apr 30, 1992 · N8409T · Substantial damageNTSB CHI92DCQ02Accident · Serious injuriesFinal reportLarry E. Medlin Challenger II SPEC. · Maize, KSFailure of the pilot to maintain an airspeed above stalling speed while turning from base leg to final approach. Factors in the accident are the pilot's lack of total and recent aviation experience.Apr 27, 1992 · N4268R · Substantial damageNTSB LAX92FA188Accident · 3 fatalField investigationFinal reportBeech 35 · Reno, NVThe pilot's poorly planned approach to compensate for the existing wind conditions, and his failure to maintain adequate airspeed.Apr 26, 1992 · N3121V · DestroyedNTSB SEA92FA083Accident · 1 fatalField investigationFinal reportCessna 172M · Shaw Island, WAA delayed go-around, and procedures not being followed. Factors include a lack of total experience in this type of operation, trees near the runway, and an uphill runway slope.Apr 22, 1992 · N64156 · Substantial damageNTSB SEA92LA080Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Sunriver, ORThe pilot did not accurately calculate fuel consumption. A factor to the accident was: fuel exhaustion.Apr 21, 1992 · N60754 · Substantial damageNTSB NYC92FA079Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Hamburg, PAThe pilot's improper in-flight decision, his failure to follow proper IFR procedures, and an improperly planned approach, which resulted in an inflight collision with rising terrain during the execution of the missed approach procedure. Factors related to the…Apr 17, 1992 · N62774 · DestroyedNTSB NYC92DEK01Accident · Minor injuriesFinal reportFlight Works Capella · Fredonia, OHAn in Flight collision with telephone wires while on approach for landing.Apr 15, 1992 · UNREG · Substantial damageNTSB ATL92LA079Accident · No injuriesLimited investigationFinal reportGuy Whisenant Skybolt · Gadsden, ALThe pilot's inadequate preflight planning and preparation, resulting in fuel exhaustion due to an inadequate fuel supply for the planned flight.Apr 14, 1992 · N12TJ · Substantial damageNTSB SEA92LA073Accident · No injuriesLimited investigationFinal reportEnstrom 280 FX · Mount Vernon, WAA hard landing by the pilot, after a power loss due to fuel exhaustion.Apr 11, 1992 · N377JD · Substantial damageNTSB MIA92GA107Accident · 2 fatalFinal reportBeech C90 · St. Augustine, FLThe pilot's failure to properly adhere to the published instrument approach procedure which resulted in descent below the minimum descent altitude. Factors which contributed to the accident were the low ceiling and fog.Apr 9, 1992 · N105FL · DestroyedNTSB FTW92FA107Accident · Minor injuriesField investigationFinal reportCessna 150 II · Fort Worth, TXA fuel exhaustion induced engine power loss due to the pilot's failure to refuel. A factor was the pilot's inadvertent disorientation.Apr 9, 1992 · N67816 · Substantial damageNTSB CHI92DCQ01Accident · No injuriesFinal reportGeorge Adrian Rands/ Coyote · Agusta, KSFailure of the pilot to maintain a proper descent rate, and an airspeed above stalling speed during a VFR final approach.Apr 9, 1992 · N3181N · Substantial damageNTSB SEA92LA065Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Ione, WAAn inadvertent stall as a result of the pilot's failure to raise the flaps during a go-around.Apr 8, 1992 · N5294Q · DestroyedNTSB CHI92LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Brookfield, WIFailure of the pilot (CFI) to attain the proper touchdown point for landing. Factors related to the accident were: the unfavorable wind condition, the excessive descent rate that developed on final approach, and the cfi's delay in taking remedial action to…Apr 5, 1992 · N6350A · Substantial damageNTSB FTW92LA105Accident · No injuriesLimited investigationFinal reportCessna 182A · Stanton, TXPower loss for undetermined reasons. A factor was soft terrain.Apr 4, 1992 · N2171G · Substantial damageNTSB CHI92LA122Accident · No injuriesLimited investigationFinal reportCessna 150F · Centralia, ILThe pilot's failure to maintain the proper altitude during the final approach to landing. A factor in the accident was the pilot's delayed remedial action.Apr 4, 1992 · N6878F · Substantial damageNTSB ANC92LA058Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Kotzebue, AKPilot factor in that the proper glidepath and altitude was not maintained. Factors to the accident were: inattentiveness and snow.Apr 4, 1992 · N3555C · Substantial damageNTSB LAX92FA161Accident · 1 fatalField investigationFinal reportBeech A33 · Paradise, CAThe student pilot's inadvertent use of the mixture control instead of the cowl flaps at a critical phase of flight, his misuse of the flight controls after the engine failure and the instructor's inadequate supervision of the student. Contributing factors in…Apr 3, 1992 · N9367Y · DestroyedNTSB FTW92LA110Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Denver, COThe loss of hydraulic fluid due to a ruptured hydraulic line in the landing gear system.Apr 3, 1992 · N6460Y · Substantial damageNTSB LAX92FA160Accident · 2 fatalField investigationFinal reportCessna 182P · Arcata, CAThe pilot's descent below decision height, and his alcoholic impairment of efficiency and judgement. Factors contributing to the accident were: the adverse weather conditions and the dark night light conditions.Apr 2, 1992 · N1362M · DestroyedNTSB NYC92LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Palmer, MAThe improper use of carburetor heat which resulted in a power loss due to carburetor ice over unsuitable terrain. Factors related to the accident were the carburetor icing conditions and the failure of the pilot to be aware of the temperature/dewpoint spread.Mar 31, 1992 · N3047N · Substantial damageNTSB LAX92LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Prescott, AZThe other airplane's flight instructor's poor supervision of the flight; the other airplane's flight instructor's and dual student's misidentification of the airplane the student pilot was following and the other airplane's flight instructor's and dual…Mar 31, 1992 · N250ER · 2 aircraft · Substantial damageNTSB BFO92FA048Accident · 2 fatalField investigationFinal reportMooney M20M · Youngs Bottom, WVThe pilot's inadequate inflight decision to continue flight in icing condition which resulted in degraded aircraft performance, inadequate airspeed, and aerodynamic stall. A related factor is the pilot's inadequate evaluation of the weather.Mar 27, 1992 · N9136J · DestroyedNTSB ATL92LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Tifton, GAThe pilot's improper single engine go-around procedure, in that he failed to raise the flaps and landing gear, and failed to maintain minimum control airspeed. A factor was the unfavorable wind conditions.Mar 27, 1992 · N16209 · Substantial damageNTSB FTW92LA097Accident · No injuriesLimited investigationFinal reportCessna R182RG · Little Rock, ARThe complete loss of engine power due to carburetor icing, and the pilot's delayed application of carburetor heat. Factors were the weather conditions which were highly conducive to carburetor icing, and the unsuitable terrain at the pilot's disposal to…Mar 26, 1992 · N5529S · Substantial damageNTSB BFO92LA047Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Pikeville, KYDelamination and subsequent failure of a main rotor blade.Mar 24, 1992 · N2831B · DestroyedNTSB FTW92LA095Accident · No injuriesLimited investigationFinal reportCessna 150F · Baytown, TXThe pilot's improper use of carburetor heat during the approach in carburetor icing conditions and his improper flare during the emergency landing.Mar 22, 1992 · N35RJ · Substantial damageNTSB SEA92LA063Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31A · Eugene, ORAn improper fuel boost pump selector position, and incorrect procedures. Factors include an improper fuel tank selector position, and fuel starvation.Mar 19, 1992 · N8266R · Substantial damageNTSB CHI92LA114Accident · Minor injuriesLimited investigationFinal reportBellanca 7 Gcbc · Quinn, SDThe pilot's inadequate visual lookout.Mar 19, 1992 · N1013E · Substantial damageNTSB BFO92FA044Accident · 2 fatalField investigationFinal reportCessna 172P · Accokeek, MDThe pilot experienced spatial disorientation which resulted in loss of control of the airplane.Mar 19, 1992 · N65737 · DestroyedNTSB ATL92LA066Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Kennesaw, GAThe dual student's inadequate compensation for wind conditions and inadequate supervision by the flight instructor. Factors were: wind gusts, wind shear and turbulence.Mar 19, 1992 · N21040 · Substantial damageNTSB MIA92IA100Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe total failure of the main landing gear uplock and sequencing valve for undetermined reasons.Mar 18, 1992 · N69SC · Minor damageNTSB BFO92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Stevensville, MDThe certificated flight instructor's (cfi's) inadequate supervision during the simulated emergency landing. Soft terrain in the touchdown area was a related factor.Mar 17, 1992 · N5276Z · Substantial damageNTSB SEA92FA061Accident · 1 fatalField investigationFinal reportErcoupe 415-D · Winthrop, WAThe student pilot's alcoholic impairment of efficiency and judgement resulting in his failure to maintain airspeed during a go-around.Mar 16, 1992 · N86952 · DestroyedNTSB LAX92LA150Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Austin, NVThe pilot's loss of control due to the failure of his control wheel during an attempted go around.Mar 16, 1992 · N4075R · Substantial damageNTSB SEA92LA060Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Vancouver, WAThe pilot's failure to maintain the proper rate of descent.Mar 15, 1992 · N1127B · Substantial damageNTSB ATL92LA062Accident · Minor injuriesLimited investigationFinal reportWilliam D. Weeks Glasair I · Timmonsville, SCThe improper selection of the fuel sector valve to the off position by the pilot.Mar 13, 1992 · N169DW · Substantial damageNTSB CHI92FA110Accident · 2 fatalField investigationFinal reportCessna 310R · Superior, WIInadequate airspeed, which resulted in an inadvertent stall/spin, and failure of the instructor pilot to take sufficient remedial action to prevent the loss of control.Mar 11, 1992 · N1328G · DestroyedNTSB BFO92LA037Accident · No injuriesLimited investigationFinal reportPiper 46-310P · Lima, OHThe pilot failure to maintian adequate airspeed during final approach which resulted in a stall. Contributing to the accident was ice on the wings.Mar 10, 1992 · N4321L · Substantial damageNTSB FTW92DPG01Accident · 1 fatalFinal reportWind Ryder · Little Rock, ARA loss of control for undetermined reason(s).Mar 8, 1992 · N123ZT · DestroyedNTSB CHI92LA106Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Elkhart, INProper glidepath was not maintained and minimum descent altitude was not maintained by the pilot resulting in collision with trees. Factors relate to the accident were the pilot's lack of total experience in type of operation and over confidence in personal…Mar 8, 1992 · N105A · Substantial damage