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 FTW92LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Grove, OKThe pilot failed to maintain aircraft contyrol. A factor was turbulence.Jul 7, 1992 · N3562J · Substantial damageNTSB CHI92FA201Accident · 4 fatalField investigationFinal reportCessna 172N · St Paul, MNInadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid conflicting traffic, and failure of the relieving controllers to use the radar display to identify and sequence an airplane entering the pattern.…Jul 7, 1992 · N6376F · 2 aircraft · DestroyedNTSB LAX92LA281Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Agua Caliente, CAThe failure of the pilot to maintain an adequate approach airspeed and an inadvertent stall/mush condition which resulted in a collision with the ground short of the runway. A factor in the accident was the pilots lack of total experience in type of aircraft.Jul 5, 1992 · N78669 · Substantial damageNTSB CHI92LA197Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Manchester, MIThe pilot's improper inflight planning/decisions, failure to make a precautionary landing when he realized he was too low to reach the airport, and attempting to stretch his glidepath to reach the runway.Jul 5, 1992 · N2524H · Substantial damageNTSB ATL92LA135Accident · No injuriesLimited investigationFinal reportCessna 182 · Kennesaw, GAThe inadequate preflight planning by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the soft terrain at the forced landing site.Jul 2, 1992 · N5544B · Substantial damageNTSB NYC92LA136Accident · 1 fatalLimited investigationFinal reportBeech N35 · Middletown, NYImproper altitude control by the pilot which resulted in a collision with trees.Jun 30, 1992 · N1211Z · Substantial damageNTSB LAX92LA266Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Coalinga, CAThe failure of the pilot to maintain the proper glide path during the night VFR approach which resulted in a landing undershoot and a subsequent collision with the raised asphalt lip of the runway edge.Jun 29, 1992 · N4065R · Substantial damageNTSB DEN92LA066Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Glade Park, COThe pilot delayed initiation of the go around. A factor was: high density altitude.Jun 29, 1992 · N1874A · Substantial damageNTSB SEA92LA139Accident · Minor injuriesLimited investigationFinal reportHarriman N-3 Ultra PUP · Arlington, WAThe partial loss of engine power, cause undetermined.Jun 28, 1992 · N30843 · DestroyedNTSB CHI92LA192Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Erie, ILThe pilot's failure to maintain a proper glidepath.Jun 28, 1992 · N3195T · Substantial damageNTSB ANC92IA100Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Dillingham, AKThe pilot in command's failure to maintain a visual lookout. Factors were the drizzle and fog and the impossibility of updating the recorded weather information by ATC personnel.Jun 26, 1992 · N620PA · 2 aircraft · No damageNTSB SEA92LA132Accident · No injuriesLimited investigationFinal reportCessna 210D · Burley, IDThe pilot's inadequate visual lookout. Factors include FAA NOTAMS not being obtained, flight service station services not being used, and an object (temporary barrier) on the runway.Jun 23, 1992 · N3739Y · Substantial damageNTSB NYC92LA126Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-26E · Waynesboro, VAThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall while on approach. Factors related to the accident were: the pilot's lack of experience, an improperly planned approach, and the gusty winds.Jun 23, 1992 · N2781H · Substantial damageNTSB NYC92FA123Accident · 1 fatalField investigationFinal reportMBB BK-117 · Middletown, CTA wire strike after the pilot made a decision to continue the approach into an area of hazards. Factors related to the accident were the failure of the pilot and the hospital communicator to request all available information about the landing area and…Jun 21, 1992 · N117HH · DestroyedNTSB ATL92LA128Accident · Minor injuriesLimited investigationFinal reportBoeing D75N1 · Stockbridge, GAThe improper compensation for the downwind condition by the pilot in command. A factor in the accident was the improper in flight planning to attempt a downwind landing on the short runway with rising terrain by the pilot in command.Jun 21, 1992 · N53232 · Substantial damageNTSB NYC92LA122Accident · Serious injuriesLimited investigationFinal reportVictor E. Nigro KR-2 · Lebanon, PAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and uncontrolled descent to the ground. Factor related to the accident were the pilot's lack of expereince in the type of airplane and the partial loss of engine power.Jun 20, 1992 · N21144 · DestroyedNTSB FTW92FA165Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Addison, TXFailure of the left elevator assembly due to corrosion.Jun 20, 1992 · N3128M · Substantial damageNTSB ATL92LA127Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Dunn, NCThe pilot's inadequare visual lookout to see and avoid the 8 foot high pole adjacent to the landing strip.Jun 20, 1992 · N55464 · Substantial damageNTSB SEA92LA128Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Seattle, WAThe pilot's failure to follow procedures. A factor to the accident was: diverted attention.Jun 17, 1992 · CGRJA · Substantial damageNTSB FTW92FA163Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Bethany, OKThe pilot's failure to maintain control which resulted in an inadvertent stall. The gusty wind was a factor.Jun 17, 1992 · N7419J · DestroyedNTSB CHI92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28-180D · Troy, MIThe pilot's failure to maintain control of the airplane.Jun 17, 1992 · N429HD · DestroyedNTSB NYC92FA118Accident · 4 fatalField investigationFinal reportBeech BE-200 · New Castle, DEThe pilot's improper execution of an emergency procedure, after an engine failure, which resulted in a loss of airspeed and subsequent stall at an altitude too low for recovery. A factor related to the accident was the fatigue failure of a compressor turbine…Jun 16, 1992 · N32HG · DestroyedNTSB ANC92LA091Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Memory Lake, AKFuel exhaustion. Factors include inadequate preflight planning, lack of familiarity with the aircraft, and unsuitable terrain.Jun 15, 1992 · N1480H · Substantial damageNTSB NYC92LA113Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hadley, MAA power loss of undetermined origin while operating over unsuitable terrain.Jun 13, 1992 · N5220X · Substantial damageNTSB MIA92LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bradenton, FLThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.Jun 13, 1992 · N7979H · Substantial damageNTSB LAX92LA244Accident · No injuriesLimited investigationFinal reportCessna 172 · Blythe, CAThe improper engine overhaul performed by the mechanic. Factors relating to this accident were the intake and exhaust valve leaks and the soft terrain.Jun 13, 1992 · N8014L · Substantial damageNTSB CHI92LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Evansville, INThe pilot's misjudgement of fuel supply.Jun 11, 1992 · N21906 · Substantial damageNTSB CHI92FA169Accident · 1 fatalField investigationFinal reportMooney M20J · Bloomington, ILThe pilot's failure to maintain aircraft control during the turn from base leg to final approach.Jun 11, 1992 · N302FW · DestroyedNTSB FTW92IA158Incident · No injuriesIncident investigationFinal reportPiper PA-31T · Addison, TXThe failure of the pilot-in-command of the PA-38, N2603B, to follow ATC instructions.Jun 10, 1992 · N182TC · 2 aircraft · No damageNTSB ATL92LA120Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG 300 · Arabi, GAThe pilot's inadequate visual lookout when he failed to see and avoid obstacles. Factors were the loss of thermal lift and the pilot's diverted attention.Jun 10, 1992 · N433TT · Substantial damageNTSB NYC92FA103Accident · 1 fatalField investigationFinal reportCessna 180G · Reynoldsville, PAThe pilot's failure to refuel resulting in fuel exhaustion and subsequent forced landing in trees.Jun 9, 1992 · N4731U · Substantial damageNTSB LAX92LA239Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Chino, CAThe loss of engine power for undetermined reasons. The pilot's misjuding the flare was a factor.Jun 9, 1992 · N31961 · Substantial damageNTSB ATL92MA118Accident · 3 fatalClass 1 · MajorFinal reportBeech C99 · Anniston, ALThe failure of senior management of gp express to provide adequate training and operational support for the startup of the southern operation, which resulted in the assignment of an inadequately prepared captain with a relatively inexperienced first officer…Jun 8, 1992 · N118GP · DestroyedNTSB SEA92LA120Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Panguitch, UTShorting of the grounding wire (p lead) to the magnetos followed by overloading of the nose wheel strut. A factor contributing to the accident was: rough/uneven terrain.Jun 7, 1992 · N9035V · Substantial damageNTSB MIA92MA131Accident · 5 fatalMajor investigationFinal reportCASA 212 · Mayaguez, PRThe failure of the beta blocking device for undetermined reason(s), and the second-pilot's inadvertent activation of the power lever, or levers, aft of the flight idle position and into the beta range, resulting in a loss of airplane control.Jun 7, 1992 · N355CA · DestroyedNTSB FTW92LA170Accident · No injuriesLimited investigationFinal reportCessna 182D · Beeville, TXEngine power loss for undetermined cause. A factor was the pilots' failure to lower flaps for the short field landing.Jun 6, 1992 · N8979X · Substantial damageNTSB LAX92LA230Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Redding, CAThe internal failure of the airplane's throttle control cable.Jun 3, 1992 · N8574T · Substantial damageNTSB NYC92DHA03Accident · Serious injuriesFinal reportParrish, Paul SKY Bolt · Mehoopany, PAThe pilot inadvertently stalled and spun the airplane at too low an altitude to allow recovery. Contributing to the accident was an engine vibration caused by a broken number 3 exhaust valve. The exhaust valve caused extensive internal damage to the engine.Jun 2, 1992 · N261P · Substantial damageNTSB ATL92LA110Accident · 1 fatalLimited investigationFinal reportWicks Bobcat · White House, TNThe pilot/owner's improper design change of the wing spar which resulted in the overload failure of the left wing. A factor was the pilot/owner's failure to perform a periodic inspection.May 31, 1992 · N9CK · DestroyedNTSB SEA92LA117Accident · No injuriesLimited investigationFinal reportCessna 172L · Yakima, WAThe pilot's failure to maintain the proper descent rate and inadequate remedial action.May 30, 1992 · N7583G · Substantial damageNTSB SEA92LA112Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Wenatchee, WAThe pilot in command's inadequate visual lookout. Factors contributing to the accident were: object (fence post) and windshield dirty (foggy)May 30, 1992 · N86239 · Substantial damageNTSB MIA92FA127Accident · 1 fatalField investigationFinal reportCessna 172-H · Clewiston, FLThe failure of the pilot-in-command (student pilot) to maintain an airspeed above stall, and his inadvertent stall and spin.May 30, 1992 · N3793R · DestroyedNTSB BFO92LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Johnstown, NYThe pilot misjudged altitude and distance which resulted in a landing undershood. Contributing to the accident was night conditions.May 27, 1992 · N9541M · Substantial damageNTSB FTW92LA140Accident · Minor injuriesLimited investigationFinal reportArdovino Mariucci CRI-CRI MC-12 · Arlington, TXTotal power loss caused by blocked carburetor screen and ignition points open beyond manufacturer's specification. A factor was inadequate annual inspection and ignition point maintenance adjustment not performed.May 23, 1992 · N71AM · Substantial damageNTSB BFO92LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172N · St Francis, MEFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. The wind condition was a related factor.May 22, 1992 · N739GM · DestroyedNTSB ANC92LA081Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Port Bainbridge, AKCarburetor ice and the pilot's failure to follow procedure. A factor relating to the accident was the rough/uneven terrain in the forced landing area.May 22, 1992 · N3717M · Substantial damageNTSB CHI92LA155Accident · No injuriesLimited investigationFinal reportCessna 172RG · Dekalb, ILThe pilot not maintaining a proper glidepath to the landing runway.May 21, 1992 · N6510V · Substantial damageNTSB CHI92DEX01Accident · No injuriesFinal reportJames D. Bierly VARI-EZ · Jeffersonville, INA collapsed carburetor air intake duct. Factors related to the accident were soft, unsuitable terrain on which to make a forced landing.May 20, 1992 · N64SJ · Substantial damageNTSB BFO92LA057Accident · Serious injuriesLimited investigationFinal reportCessna 210M · West Mifflin, PAThe pilot's inadequate preflight preparation. Contributing to the accident was the unreliable fuel quantity gauges.May 11, 1992 · N1411P · DestroyedNTSB ANC92LA071Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Chitina, AKThe pilot's failure to maintain proper alignment with the landing area. Contributing factors were the gusty wind and the trees.May 9, 1992 · N2669G · Substantial damage