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 DEN91LA006Accident · No injuriesLimited investigationFinal reportCessna T210M · Englewood, COEngine failiure resulting from maintenance discrepancies.Oct 10, 1990 · N565RA · Substantial damageNTSB NYC91FA006Accident · 2 fatalField investigationFinal reportCessna 152 · Griswold, CTA broken ehaust valve spring that resulted in a partial loss of power. Factors related to the accident were: darkness, lack of suitable terrain, and failure of the occupants to use their shoulder harnesses.Oct 8, 1990 · N4708M · DestroyedNTSB NYC91FA005Accident · 4 fatalField investigationFinal reportBeech V35B · Ottawa, OHFailure of the pilot to follow the proper instrument procedure and maintain the minimum descent altitude (mda) during an approach to the airport at night in instrument meteorological conditions.Oct 8, 1990 · N409E · DestroyedNTSB DEN91FA005Accident · Serious injuriesField investigationFinal reportBeech P35 · Aurora, COInadvertent stall. Factors were his decision to disregard in-flight weather advisories, continued flight into known adverse weather, and icing conditions and the flight into the known adverse weather.Oct 8, 1990 · N1568S · Substantial damageNTSB ATL91LA002Accident · No injuriesLimited investigationFinal reportMooney M20E · Greensboro, NCThe failure of the rubber/metal coupling in the landing gear actuator assembly, which resulted in the inability of the pilot to lower and lock the landing gear.Oct 7, 1990 · N9315V · Substantial damageNTSB MIA91LA004Accident · No injuriesLimited investigationFinal reportRobinson R22 B · Opa Locka, FLFailure to use carburetor heat.Oct 3, 1990 · N224SW · Substantial damageNTSB MIA91LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLPartial loss of engine power for undetermined reasons resulting in a forced landing.Oct 2, 1990 · N66945 · Substantial damageNTSB MIA91FA001Accident · 1 fatalField investigationFinal reportErik K. Van Der Kaay Marco J-5 · Clearwater, FLThe pilot's inadvertent deployment of the air brakes at a low altitude.Oct 2, 1990 · N10EK · DestroyedNTSB ATL90FA183Accident · 2 fatalField investigationFinal reportGrumman AA5B · Gallatin, TNThe pilot's failure to maintain the proper altitude which resulted in the inadvertent descent into the ground, and his diverted attention to another airplane. Factors in the accident were fog, dark night, fatigue from lack of sleep, and a lack of recent night…Sep 30, 1990 · N81099 · DestroyedNTSB NYC90FA231Accident · 2 fatalField investigationFinal reportCessna 182Q · Nantucket, MAThe pilot's improper IFR operation in attempting an ILS approach in an airplane not equipped with an ILS glide slope receiver. The weather conditions were factors in the accident.Sep 29, 1990 · N5289N · DestroyedNTSB LAX90LA338Accident · Serious injuriesLimited investigationFinal reportMooney M-20-M · Flagstaff, AZEngine failure due to a ruptured fuel pump diaphragm. A factor in the accident was the unsuitable nature of the terrain to make a forced landing.Sep 29, 1990 · N9161D · DestroyedNTSB DEN90LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Erie, COThe student pilot's misjudgement of distance and altitude, and the instructor's inadequate supervision.Sep 28, 1990 · N6581M · DestroyedNTSB LAX90DVA13Accident · Serious injuriesFinal reportBlaise Midget Mustang · Kernville, CAThe pilot's failure to maintain an airspeed sufficient to sustain flight during landing. A factor was the pilot's lack of expereince in this aircraft.Sep 27, 1990 · N7148B · DestroyedNTSB ANC90LA185Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotes Lakes, AKThe pilot-in-command's encounter with turbulence while on final approach, and failure to maintain aircraft control.Sep 27, 1990 · N3897Z · Substantial damageNTSB NYC90DNC01Accident · Serious injuriesFinal reportCessna 180E · Kingston, NHAn inflight collision with water while maneuvering for a forced landing. A factor to the accident was a power loss due to the pilot's improper use of the mixture control.Sep 26, 1990 · N2620Y · DestroyedNTSB LAX90FA332Accident · 4 fatalField investigationFinal reportCessna 500 · San Luis Obispo, CAThe pilot's improper IFR (instrument) procedure, and his failure to maintain the minimum descent altitude (mda) for the approach. The adverse weather was a related factor.Sep 24, 1990 · N79DD · DestroyedNTSB CHI90LA272Accident · Minor injuriesLimited investigationFinal reportCessna A150L · Terre Haute, INAn undetermined loss of engine power.Sep 24, 1990 · N6073J · Substantial damageNTSB LAX90DXQ05Accident · Minor injuriesFinal reportGlaser-Dirks DG 400/17 · Truckee, CAThe uncommanded deployment of the right spoiler system due to the absence of a spring pin not fitted to the quick disconnect as recommended which resulted in the pilot losing control of the glider during a critical phase of flight.Sep 23, 1990 · N567DA · Substantial damageNTSB LAX90LA333Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Reno, NVThe pilot's failure to maintain sufficient airspeed resulting in an inadvertent stall. A factor in the accident was the strong crosswind conditions.Sep 22, 1990 · N6617D · Substantial damageNTSB CHI90LA270Accident · Serious injuriesLimited investigationFinal reportBeech F-33A · Osage Beach, MOThe pilot's failure to establish a proper glide path, resulting in contact with trees short of the intended runway.Sep 22, 1990 · N6368B · Substantial damageNTSB CHI90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Wayne, INThe failure of the pilot of the accident airplane to maintain sufficient speed for flight. The pilots lack of total experience and the crosswinds that were present during the approach and the attempted go-around are contributing factors to the accident.Sep 22, 1990 · N24296 · Substantial damageNTSB LAX90LA327Accident · No injuriesLimited investigationFinal reportCessna 150L · Palm Springs, CAFuel exhaustion. Contributing factors related to the pilot's improper preflight preparation, and his lack of total experience.Sep 21, 1990 · N10797 · Substantial damageNTSB LAX90FA331Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Flagstaff, AZVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude during the approach to land. Factors related to the accident were: darkness, the adverse weather conditions, and failure of…Sep 21, 1990 · N3558 · DestroyedNTSB CHI90LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Huntington, INThe student pilot's improper preflight planning ensuring sufficient fuel for the intended flight.Sep 21, 1990 · N8259U · DestroyedNTSB NYC90FA223Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Livingston, NYThe pilot failed to maintain control of the aircraft while maneuvering for an ILS approach. Factors related to the accident were the pilot's lack of recent instrument flight experience, low cloud ceilings and fog, and failure to follow IFR procedures.Sep 19, 1990 · N3100P · DestroyedNTSB BFO90FA076Accident · 1 fatalField investigationFinal reportPiper PA-601P · Wiley Ford, WVThe pilot's improper IFR procedure by not maintaining sufficient altitude, while circling to land. Factors related to the accident were: the low ceiling and visibility conditions in fog.Sep 19, 1990 · N8249J · DestroyedNTSB MIA90LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Orlando, FLFailure of the pilot to follow proper procedures.Sep 18, 1990 · N7229F · Substantial damageNTSB SEA90FA182Accident · 1 fatalField investigationFinal reportCessna 150M · Prospect, ORThe pilot's failure to maintain a proper altitude during his approach. The dark night condition was a contributing factor.Sep 14, 1990 · N3420V · DestroyedNTSB LAX90LA322Accident · Serious injuriesLimited investigationFinal reportCessna 152 · San Fernando, CAFuel exhaustion. Contributing factors related to the pilot's improper preflight preparation and improper in-flight planning.Sep 13, 1990 · N714XD · DestroyedNTSB CHI90FA263Accident · 2 fatalField investigationFinal reportCessna 172N · Paris, ILThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors contributing to the accident were the fog and the dark night.Sep 13, 1990 · N75785 · DestroyedNTSB DEN90LA185Accident · No injuriesLimited investigationFinal reportCessna 172M · Parker, COThe dual student pilot's improper use of the aircraft power plant controls, resulted in a complete loss of engine power.Sep 11, 1990 · N1241U · Substantial damageNTSB FTW90FA177Accident · Serious injuriesField investigationFinal reportPiper PA-32RT-300T · Addison, TXFatigue failure of the throttle cable. Factors related to the accident were: darkness and objects (fence and utility poles) in the emergency landing area.Sep 10, 1990 · N36720 · DestroyedNTSB SEA90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Ogden, UTThe failure of the pilot to correct the position of the fuel tank selector, causing erratic engine operation and loss of power.Sep 9, 1990 · N5146D · Substantial damageNTSB NYC90LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Quarryville, PAThe pilot in commands failure to maintain airspeed while climbing to avoid wires.Sep 9, 1990 · N4268E · DestroyedNTSB DEN90LA183Accident · 1 fatalLimited investigationFinal reportBeech E 33 · Tulsa, OKThe pilot's failure to select the right tank prior to the approach resulting in fuel starvation.Sep 9, 1990 · N7155N · Substantial damageNTSB NYC90FA215Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Montgomery, NYAn inadequate preflight by the pilot which resulted in a power loss due to fuel exhaustion.Sep 8, 1990 · N9327C · DestroyedNTSB LAX90LA314Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Barbara, CAA disconnect of the throttle control.Sep 8, 1990 · N51362 · Substantial damageNTSB BFO90FA074Accident · 1 fatalField investigationFinal reportBeech C35 · Forest Hill, MDThe pilot's failure to maintain aircraft control during the turn from base to final approach. A factor was the pilot's abrupt aircraft handling during the turn.Sep 8, 1990 · N1540V · DestroyedNTSB LAX90LA315Accident · Serious injuriesLimited investigationFinal reportCessna U206F · Las Vegas, NVThe pilot's loss of visual references during a night approach and his failure to detect and correct a descent. A factor in the accident was the dark night lighting conditions.Sep 6, 1990 · N51299 · Substantial damageNTSB CHI90LA259Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lebanon, ILthe loss of engine power for undetermined reasons while executing a go-around with insufficient runway remaining for a forced landing. A factor in the accident was the structures at the end of the runway that the pilot was attempting to avoid. This report was…Sep 6, 1990 · N2229B · Substantial damageNTSB ATL90LA167Accident · No injuriesLimited investigationFinal reportWSK PZL-104 · Smithfield, NCThe pilot's failure to properly preflight fuel requirements for the additional landing. The engine quit due to fuel exhaustion.Sep 6, 1990 · N7169Z · DestroyedNTSB DEN90LA181Accident · No injuriesLimited investigationFinal reportCessna T210N · Durango, COThe loss of control of the airplane when the pilot encountered turbulence on short final to land.Sep 5, 1990 · N5241C · Substantial damageNTSB FTW90LA173Accident · No injuriesLimited investigationFinal reportBeech BE19 · Dallas, TXThe instructor pilot's failure to maintain crew coordination in the cockpit, and the student pilot's premature retraction of the flaps during a critical maneuver. Factors were the certified flight instructors inadequate supervision and the inadvertent low…Sep 2, 1990 · N23848 · Substantial damageNTSB DEN90LA180Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Canon City, COThe pilot's failure to maintain an adequate pattern altitude and the possible existence of adverse winds due to the surrounding terrain.Sep 2, 1990 · N73957 · Substantial damageNTSB NYC90LA209Accident · 1 fatalLimited investigationFinal reportCessna 172L · Montauk, NYPilot failed to attain airspeed during a go around, resulting in the airplane stalling at a low altitude. Contributing factor was the pilot's attention was diverted to airport maintenance personnel working near the approach end of the runway.Sep 1, 1990 · N4324Q · DestroyedNTSB LAX90LA309Accident · No injuriesLimited investigationFinal reportBoeing E75 · Petaluma, CAThe pilot failed to maintain directional control by improperly using the rudder.Aug 31, 1990 · N5358N · Substantial damageNTSB NYC90LA206Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Palmyra, NYPilot's failure to maintain airspeed during approach resulting in the airplane stalling and descending uncontrolled to ground impact.Aug 30, 1990 · N17109 · DestroyedNTSB DEN90DTE09Accident · No injuriesFinal reportTrammel Avid Flyer · Trinidad, COThe failure of the pilot to follow published procedures when he inadvertently shut off the magnetos while on final approach.Aug 30, 1990 · N5002L · Substantial damageNTSB CHI90FA250Accident · 1 fatalField investigationFinal reportBeech A23A · St Paul, MNImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall/spin.Aug 30, 1990 · N8871M · Substantial damageNTSB CHI90LA246Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Reeds Spring, MOA delayed go-around.Aug 28, 1990 · N2973S · Destroyed