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 MIA97LA123Accident · No injuriesLimited investigationFinal reportCumberland Skybolt · Smithfield, NCInstallation by a student mechanic of a counterweight retaining washer that did not meet engine manufacturers specifications resulting in partial separation of the counterweight, failure of the No.5 connecting rod adjacent to the counterweight, and seizure of…Apr 8, 1997 · N4TZ · Substantial damageNTSB FTW97LA157Accident · No injuriesLimited investigationFinal reportBeech BE-95 · San Antonio, TXThe failure of the right main gear due to improper repair by the company maintenance personnel.Apr 7, 1997 · N2702Y · Substantial damageNTSB NYC97FA069Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Farmingville, NYthe pilot's improper inflight planning/decision, which subsequently resulted in fuel exhaustion and loss of engine power. Related factors were: excessive fuel consumption rate, and obstructions (trees and house) in the emergency landing area.Apr 6, 1997 · N4400T · Substantial damageNTSB MIA97LA122Accident · Minor injuriesLimited investigationFinal reportKunc KR-1 · Deland, FLthe pilot's improper planning/decision, by failing to ensure there was sufficient fuel to safety complete the flight, which resulted in fuel exhaustion, loss of engine power, a forced landing, and subsequent collision with tree(s).Apr 6, 1997 · N7KR · Substantial damageNTSB NYC97LA068Accident · No injuriesLimited investigationFinal reportCessna 650 · Buffalo, NYA combination hydraulic fluid and fuel-fed fire which originated from electrical arcing, due to the lack of an adequate production standard from Cessna for the separation of flammable fluid lines and electrical lines. A factor was the lack of oversight from…Apr 4, 1997 · N553AC · Substantial damageNTSB LAX97LA141Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Avalon, CAThe pilot's misjudging the airplane's altitude and distance to the runway and an excessive descent rate, which led to an undershoot, and the pilot's failure to maintain an adequate airspeed during the approach. Contributing factors were the pilot's delay in…Apr 4, 1997 · N733CN · DestroyedNTSB SEA97LA082Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Manzanita, ORThe pilot's failure to adequately compensate for wind conditions, and his failure to maintain directional control of the airplane during the go-around attempt. Factors contributing to the accident are gusty crosswinds.Apr 3, 1997 · CGICR · Substantial damageNTSB FTW97LA149Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Bartlesville, OKthe pilot's selection of an empty fuel tank, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the pilot's lack of familiarity with the aircraft.Apr 3, 1997 · N940MD · Substantial damageNTSB ANC97LA047Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Teller, AKthe pilot's inadequate compensation for wind conditions, and failure to maintain directional control during the landing. Factors related to the accident were: a crosswind, a downdraft, the pilot's delayed go-around, improper raising of the flaps, and…Apr 3, 1997 · N6299H · Substantial damageNTSB ANC97LA044Accident · No injuriesLimited investigationFinal reportCessna 175 · Naknek, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. Factors associated with the accident were the pilot's inadequate preflight preparation and planning by failing to obtain information about the out of service runway lighting, and the rough…Apr 1, 1997 · N9261B · Substantial damageNTSB MIA97LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sarasota, FLa loss of engine power for undetermined reasons.Mar 30, 1997 · N109LD · Substantial damageNTSB FTW97IA144Incident · No injuriesIncident investigationFinal reportBoeing 767-232 · Dfw Airport, TXThe manufacturer's improper installation of the flap, which resulted in fatigue cracking of the flap attach bolts and separation of the flap.Mar 27, 1997 · N105DA · Minor damageNTSB ANC97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nome, AKa fuel leak from an engine driven fuel pump which initiated an engine fire, and the fuel pump manufacturer's inadequate quality control of the fuel pump.Mar 27, 1997 · N4105D · Substantial damageNTSB NYC97LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Lincoln Park, NJThe pilot's failure to maintain adequate obstacle clearance due to his diverted attention in attempting to re-illuminate the runway lights, which resulted in an inflight collision with a tree.Mar 25, 1997 · N3604W · DestroyedNTSB ATL97LA052Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103-TWIN II · Lancaster, SCthe pilot's improper use of the spoilers, while approaching to land, which allowed the glider to get low on final approach and strike trees. The pilot's lack of recent flying experience and lack of experience in the make and model of glider were related…Mar 22, 1997 · N54553 · Substantial damageNTSB LAX97LA120Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD 369HS · Pacific Ocean (Pacific Ocean)A loss of engine power due to a deteriorated compressor air seal, which resulted from inadequate maintenance inspection of the helicopter to detect corrosion in the compressor case while being operated in a marine environment.Mar 11, 1997 · N95MS · DestroyedNTSB IAD97LA053Accident · No injuriesLimited investigationFinal reportCessna 175 · Weirs Cave, VAthe pilot's inadequate preflight planning/preparation, and inaccurate fuel calculations, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Darkness and high vegetation in the forced landing area were related factors.Mar 10, 1997 · N9485B · Substantial damageNTSB IAD97LA062Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-233A · Woodbine, MDThe pilot misjudged his altitude during approach.Mar 9, 1997 · N2559H · Substantial damageNTSB SEA97FA067Accident · 1 fatalField investigationFinal reportBeech 200 · Salt Lake City, UTThe pilot's failure to maintain adequate airspeed on the ILS approach, resulting in a stall. Factors included: low visibility; the pilot's selection of the improper DME for the approach; his resulting failure to attain the proper descent profile for the…Mar 3, 1997 · N117WM · Substantial damageNTSB LAX97LA110Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mountain Spring, NVthe pilot's poor weather evaluation and the decision to continue to attempt to land during forecast adverse weather conditions.Feb 24, 1997 · N42SS · DestroyedNTSB FTW97LA108Accident · No injuriesLimited investigationFinal reportCessna R172K · Brownsville, TXthe pilot's failure to refuel the airplane which resulted in a loss of engine power due to fuel exhaustion.Feb 24, 1997 · N98DE · Substantial damageNTSB ANC97LA078Accident · No injuriesLimited investigationFinal reportCessna 185F · Ketchikan, AKthe pilot allowed an excessive rate of descent to develope during an approach to land, and delayed in initiating a go-around.Feb 23, 1997 · N4471R · Substantial damageNTSB ANC97LA027Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKthe pilot's continued VFR flight into instrument meteorological conditions, his misjudgment of distance and altitude during the approach to land, and his failure to attain a proper touchdown point during the landing. A factor relating to the accident was: the…Feb 22, 1997 · N7389U · Substantial damageNTSB SEA97LA064Accident · No injuriesLimited investigationFinal reportCessna 150J · Price, UTThe flight instructor's failure to ensure that the dual student maintained adequate airspeed.Feb 15, 1997 · N5514G · Substantial damageNTSB NYC97LA054Accident · No injuriesLimited investigationFinal reportCessna 208B · Covington, KYThe pilot's failure to maintain the airplane on the ILS glide slope, which resulted in a descent below the glide path, and the inadvertent in-flight collision with a utility pole. Contributing factors were sleet/snow, dark night conditions, and the pole.Feb 14, 1997 · N922FE · Substantial damageNTSB FTW97LA102Accident · Serious injuriesLimited investigationFinal reportCessna 210-5 · Hobbs, NMThe loss of engine power due to fuel starvation for undetermined reasons. A factor was the pilot's continued flight after a fuel consumption anomaly was encountered.Feb 11, 1997 · N1866Z · Substantial damageNTSB ATL97LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLthe student pilot's inadvertent movement of the mixture control to idle cut-off during the approach to land, which resulted in engine shut-down, and the student's failure to follow emergency procedures for restarting the engine.Feb 9, 1997 · N6679F · Substantial damageNTSB LAX97LA097Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Los Angeles, CAFuel starvation resulting from the pilot's improper fuel tank selector position and failure to perform correct emergency procedures.Feb 8, 1997 · N10ML · Substantial damageNTSB SEA97LA058Accident · No injuriesLimited investigationFinal reportCessna 421C · Cedar City, UTwater contamination in the hydraulic system, which froze in the (right) main gear hydraulic actuator, and restricted movement of the (right) main gear retraction and extension system.Feb 6, 1997 · N45MV · Substantial damageNTSB IAD97LA046Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHthe pilot's failure to maintain proper altitude during the approach at night. Related factors were: darkness, and the pilot's lack of night flying experience.Feb 4, 1997 · N62332 · Substantial damageNTSB NYC97LA050Accident · No injuriesLimited investigationFinal reportBerry Vans RV-4 · York, PAthe pilot's delay in initiating a go-around, and his failure to maintain airspeed, which resulted in an inadvertent stall/mush and contact with the terrain.Feb 2, 1997 · N42BN · Substantial damageNTSB LAX97LA096Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Payson, AZa loss of engine power for undetermined reasons.Feb 2, 1997 · N61DE · Substantial damageNTSB MIA97LA077Accident · 1 fatalLimited investigationFinal reportBeech 95-B55 · Monroe, NCpilot incapacitation as result of Ischemic heart disease.Feb 1, 1997 · N70F · Substantial damageNTSB CHI97LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INthe pilot's inadequate fuel management and fuel system exhaustion. A factor involved was the inadequate in-flight planning/decision.Feb 1, 1997 · N4696G · Substantial damageNTSB LAX97LA098Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Scottsdale, AZfuel exhaustion due to the pilot's improper fuel management.Jan 31, 1997 · N6638V · Substantial damageNTSB NYC97LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · North Andover, MAFuel vents blocked by frozen moisture which resulted in restricted fuel flow to the engine and subsequent loss of engine power.Jan 29, 1997 · N67898 · DestroyedNTSB FTW97LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Brownsville, TXthe pilot's failure to refuel the airplane which led to fuel exhaustion and subsequent loss of engine power. Factors were the pilot's lack of preflight planning and the lack of suitable terrain for the forced landing.Jan 27, 1997 · N8478F · Substantial damageNTSB FTW97LA089Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brownsville, TXThe pilot's delayed go-around and subsequent inadvertent stall. A factor was the gusty winds.Jan 26, 1997 · N2422N · Substantial damageNTSB MIA97LA074Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Clermont, FLthe pilot's improper planning/decision by electing to be towed aloft with a cold front nearby, which resulted in an in-flight encounter with wind gusts from the nearby cold front and subsequent in-flight collision with trees.Jan 25, 1997 · N233HH · Substantial damageNTSB FTW97LA091Accident · No injuriesLimited investigationFinal reportCessna 182A · Midland, TXThe pilot's failure to periodically clear the engine during an extended glide. Factors were the carburetor icing weather conditions and the lack of suitable terrain for the forced landing.Jan 25, 1997 · N4723D · Substantial damageNTSB SEA97IA051Incident · No injuriesIncident investigationFinal reportBeech 1900D · Seattle, WAan axial shift of the aft flap track bearing's outer roller, resulting in erosion and failure of the flap track bracket/bearing assembly. A factor relating to the incident was: inadequate inspection of the flap roller bearing/bracket assemblies.Jan 21, 1997 · N75ZV · Minor damageNTSB CHI97FA058Accident · 2 fatalField investigationFinal reportMooney M20J · Cottage Grove, MNfailure of the pilot to maintain control of the airplane during an ILS approach. Factors relating to the accident were: the IFR weather conditions, the pilot's lack of recent instrument experience, and the pilot's lack of familiarity in flying the accident…Jan 21, 1997 · N1160G · DestroyedNTSB NYC97LA044Accident · Serious injuriesLimited investigationFinal reportMooney 20F · Jaffrey, NHThe pilot's failure to maintain aircraft control during a go around attempt, which resulted in a loss of control and collision with trees.Jan 19, 1997 · N7112V · DestroyedNTSB ANC97LA023Accident · No injuriesLimited investigationFinal reportMaule M-5 · Chugiak, AKThe pilot's failure to attain the proper touchdown point during landing. The snow-covered runway was a factor.Jan 18, 1997 · N5654N · Substantial damageNTSB CHI97LA055Accident · No injuriesLimited investigationFinal reportBeech D95A · Olathe, KSthe pilot improperly selecting the 'off' position on the left engine fuel selector valve, his failure to verify the fuel selector valve's proper position prior to landing, and his inability to obtain best rate-of-climb single-engine speed.Jan 17, 1997 · N44BP · Substantial damageNTSB MIA97LA064Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLInadequate inspection of the fuel caps by company maintenance personnel resulting in a cap with a deteriorated seal being allowed to continue in service. This allowed water to leak into the fuel tank which resulted in loss of engine power due to water…Jan 16, 1997 · N69219 · Substantial damageNTSB MIA97LA061Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Lincolnton, NCThe student pilot's improper use of flaps and failure to maintain airspeed during a go-around.Jan 14, 1997 · N2236L · Substantial damageNTSB ANC97LA019Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Dillingham, AKthe pilot's failure to maintain sufficient altitude or clearance from terrain during a go-around. A factor related to the accident was: the dark, night condition.Jan 13, 1997 · N2491U · Substantial damageNTSB DCA97MA017Accident · 29 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Monroe, MIThe Federal Aviation Adminstration's (FAA) failure to establish adequate aircraft certification standards for flight in icing conditions, the FAA's failure to ensure that at Centro Tecnico Aeroespacial/FAA-approved procedure for the accident airplane's deice…Jan 9, 1997 · N265CA · DestroyedNTSB MIA97FA057Accident · 2 fatalField investigationFinal reportCessna 208B · Edenton, NCthe pilot's continued VFR flight into instrument meteorological conditions. Factors in this accident were: fog, the low ceiling, and the dark night.Jan 2, 1997 · N802TH · Destroyed