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 SEA05LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Sunriver, ORThe loss of engine power as a result of both sets of magneto points failing to open due to excessive wear of the nylon cam followers. The excessive wear of the cam followers was due to maintenance personnel's failure to follow the magneto manufacturer's…Jul 28, 2005 · N110MP · Substantial damageNTSB NYC05LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Caldwell, NJThe pilot's improper flare, which resulted in a hard landing. A factor was a partial loss of engine power, as reported by the pilot, for undetermined reasons.Jul 28, 2005 · N98730 · Substantial damageNTSB CHI05LA200Accident · Minor injuriesLimited investigationFinal reportVans RV-9A · Neenah, WIThe pilot failed to maintain sufficient airspeed on final approach to avoid a stall, resulting in an inadvertent stall and uncontrolled descent to the terrain.Jul 27, 2005 · N219CC · Substantial damageNTSB CHI05FA199Accident · 1 fatalField investigationFinal reportGlasair GS-2 · Wautoma, WIthe abrupt maneuver that was performed while failing to maintain airpeed, resulting in a stall, and uncontrolled impact with the ground without sufficient altitude to recover.Jul 27, 2005 · N105TW · DestroyedNTSB IAD05FA110Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Georgetown, DEThe pilot's misjudged distance/altitude while on final approach to land, which resulted in an in-flight collision with a vehicle. Factors associated with the accident are the pilot's improper use of the flaps, and the state of Delaware's insufficient…Jul 26, 2005 · N59RK · Substantial damageNTSB MIA05CA141Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Kissimmee, FLFailure of the student pilot to maintain control of the airplane during a go around resulting in the airplane descending and colliding with the ground.Jul 22, 2005 · N280FT · Substantial damageNTSB SEA05CA149Accident · Minor injuriesData collectionFinal reportHughes 269A · Laurel, MTthe pilot's failure to maintain rotor rpm while executing a pinnacle approach, which resulted in a loss of control and collision with terrain.Jul 21, 2005 · N801CP · Substantial damageNTSB LAX05LA239Accident · 1 fatalLimited investigationFinal reportAs+ AC4 · Sparks, NVthe pilot's failure to maintain an adequate airspeed while performing S-turns on final approach, which resulted in a stall and uncontrolled descent into terrain. A contributing factor in the accident was the pilot's impairment due to ingestion of an…Jul 19, 2005 · N9276Y · DestroyedNTSB CHI05CA193Accident · Minor injuriesData collectionFinal reportPiper PA-22 · Plainwell, MIThe loss of engine power on downwind due to carburetor icing, and the unsuitable terrain the pilot encountered during the forced landing. A factor was the soft terrain.Jul 19, 2005 · N2654A · Substantial damageNTSB MIA05LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Gulfport, MSA loss engine power for undetermined reasons, that resulted in a forced landing, and damage to the helicopter during the landing.Jul 16, 2005 · N2614D · Substantial damageNTSB IAD05CA098Accident · No injuriesData collectionFinal reportGrumman G164A · Williamstown, NJThe pilot's misjudgment of distance/altitude, and his failure to maintain obstacle clearance.Jul 15, 2005 · N48408 · Substantial damageNTSB DFW05CA181Accident · No injuriesData collectionFinal reportMesserschmitt BK-117 B-2 · Houston, TXThe separation of the left passenger door due to worn attaching hardware.Jul 14, 2005 · N440HH · Substantial damageNTSB DEN05LA106Accident · Serious injuriesLimited investigationFinal reportClarke YAK 3UR 2000 · Heber City, UTloss of engine power due to a leaking carburetor and an inoperative float, and the pilot's failure to maintain aircraft control during the restart attempt. Contributing factors were the sudden engine power surge during the attempted restart, and unsuitable…Jul 9, 2005 · N134US · Substantial damageNTSB DEN05LA104Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Rocky Ford, COthe pilot's misjudged distance/altitude. A contributing factor was the inadvertent flap retraction.Jul 8, 2005 · N6839G · Substantial damageNTSB ANC05FA098Accident · 1 fatalField investigationFinal reportMaule M-7-235 · Seward, AKThe pilot's failure to maintain minimum airspeed during final approach, which resulted in an inadvertent stall, and impact with the surface of the lake.Jul 7, 2005 · N5661J · Substantial damageNTSB ANC05CA096Accident · No injuriesData collectionFinal reportPiper PA-18-160 · Hope, AKThe pilot's misjudged distance and altitude during an approach to land at an off-airport landing site, which resulted in an undershoot, and subsequent in-flight collision with trees and tundra-covered terrain. A factor in the accident was trees.Jul 6, 2005 · N18VF · Substantial damageNTSB CHI05LA163Accident · 1 fatalLimited investigationFinal reportBecker RAF 2000 · Gladwin, MIThe pilot's failure to maintain control of the gyrocopter while in the traffic pattern. A factor associated with the accident was the pilot's lack of gyrocopter experience.Jul 4, 2005 · N481KB · Substantial damageNTSB CHI05CA170Accident · No injuriesData collectionFinal reportMooney M20K · Kennett, MOThe fuel starvation, inadequate preflight planning and preparation, and inadequate in-flight planning/decision by the pilot.Jul 4, 2005 · N5791U · Substantial damageNTSB ATL05LA121Accident · 1 fatalLimited investigationFinal reportDenmark Mini-Max · Covington, GAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, uncontrolled descent, and subsequent collision with the ground.Jul 3, 2005 · N11949 · DestroyedNTSB LAX05LA223Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yuma, AZthe pilot's misjudged distance and altitude, which resulted in an undershoot and collision with a airport boundary fence short of the runway. A factor in the accident was the pilot's lack of familiarity flying the airplane at a high gross weight with a center…Jul 2, 2005 · N9254J · Substantial damageNTSB CHI05LA171Accident · Serious injuriesLimited investigationFinal reportYonchak Skybolt · El Dorado, KSThe pilot's failure to maintain airspeed while maneuvering in the traffic pattern which resulted in an inadvertent stall. A factor was the low altitude.Jul 2, 2005 · N112MK · Substantial damageNTSB DEN05FA103Accident · 3 fatalField investigationFinal reportAgusta A119 · Mancos, COa loss of engine power for undetermined reasons and the pilot's inability to get into autorotation prior to impacting the ground. A factor contributing to the accident was the helicopter's low altitude when power was lost.Jun 30, 2005 · N403CF · Substantial damageNTSB LAX05CA219Accident · Minor injuriesData collectionFinal reportCessna 180A · Big Bend, CAthe pilot misjudged his clearance altitude above the surface of the lake, resulting in a collision with water.Jun 29, 2005 · N2929C · Substantial damageNTSB DEN05FA101Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Marble, COthe pilot's improper decision to perform a go-around, and failure to maintain clearance from terrain and obstacles during a go-around. Factors contributing to the accident include the pilot's lack of recency of experience and lack of mountain flying…Jun 29, 2005 · N44269 · Substantial damageNTSB SEA05LA134Accident · 1 fatalLimited investigationFinal reportJones Long EZ · Marsing, IDThe pilot's failure to maintain airspeed during landing, and his subsequent delay in attempting a recovery from a bounced landing. A contributing factor was the taxiway berm.Jun 28, 2005 · N58LD · Substantial damageNTSB NYC05FA109Accident · 4 fatalField investigationFinal reportCessna 182Q · Groton, CTThe pilot's failure to maintain aircraft control while executing an ILS (Instrument Landing System) approach to minimums.Jun 27, 2005 · N5155N · DestroyedNTSB DEN05FA100Accident · 1 fatalField investigationFinal reportCGS Hawk Two Place Arrow · Jackson, WYThe loss of airplane pitch control resulting from the pilot/owner's improper reinstallation of the rear locking collar on the elevator control torque tube, which allowed the torque tube to move rearward during flight and loosen the elevator control cable…Jun 27, 2005 · UNREG · DestroyedNTSB SEA05LA129Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Hailey, IDThe pilot's failure to maintain aircraft control while on final approach for undetermined reasons.Jun 26, 2005 · N201U · Substantial damageNTSB SEA05FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Yamhill, ORThe flight instructor's excessive climb and failure to maintain adequate airspeed during an attempted go-around, which resulted in an inadvertent stall and subsequent collision with the ground. Contributing factors were the flight instructor's improper…Jun 24, 2005 · N4368R · Substantial damageNTSB DFW05FA170Accident · 5 fatalField investigationFinal reportBeech E90 · New Roads, LAThe pilot's failure to maintain airspeed and subsequent loss of control during a go-around maneuver.Jun 24, 2005 · N62BL · DestroyedNTSB CHI05CA156Accident · Minor injuriesData collectionFinal reportBell 206L-3 · Algonac, MIThe pilot not maintaining helicopter control, the loss of tail rotor effectiveness he encountered, and his not maintaining clearance from objects during the approach. Factor were the low altitude, the transmission lines, and the garage.Jun 24, 2005 · N311JX · Substantial damageNTSB NYC05LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Edgartown, MAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall and subsequent impact with terrain. [This report was modified on June 10, 2008]Jun 23, 2005 · N5118D · Substantial damageNTSB LAX05LA215Accident · Minor injuriesLimited investigationFinal reportBeech BE76 · Glendale, AZthe flight instructor's decision to attempt a single engine go-around with multiple aircraft system failures, and his improper in-flight decision to pass up one airport for landing and continue the flight to the home base airport with known mechanical…Jun 23, 2005 · N5274M · DestroyedNTSB CHI05CA153Accident · Minor injuriesData collectionFinal reportS C Aerostar S A YAK-52 · Columbus, NEThe mechanic's inadequate installation of fuel lines, the obstruction of fuel lines, and the fuel starvation leading to the non-mechanical loss of engine power during approach and the unsuitable terrain the pilot encountered during the forced landing.Jun 21, 2005 · N962KY · Substantial damageNTSB IAD05CA081Accident · Minor injuriesData collectionFinal reportPZL Swidnik PW-5 · Bloomingburg, NYThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent impact with terrain.Jun 20, 2005 · N341PW · Substantial damageNTSB DFW05LA165Accident · Minor injuriesLimited investigationFinal reportCessna 401A · Houston, TXThe loss of engine power to both engines due to fuel starvation as a result of the pilot's improper fuel management. A contributing factor was the lack of suitable terrain for the forced landing.Jun 20, 2005 · N7KF · Substantial damageNTSB CHI05CA150Accident · No injuriesData collectionFinal reportCessna 172P · St. Francis, KSThe pilot's failure to compensate for the crosswind conditions during landing and the unsuccessful go-around. A factor was the crosswind.Jun 19, 2005 · N53462 · Substantial damageNTSB ATL05CA104Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe CFI's mismanagement of the fuel supply, which resulted in fuel exhaustion.Jun 19, 2005 · N625PA · Substantial damageNTSB LAX05LA210Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Phoenix, AZthe pilot's delay in executing a timely go-around and failure to raise the flaps, which resulted in a collision with terrain.Jun 18, 2005 · N626Z · Substantial damageNTSB CHI05CA151Accident · No injuriesData collectionFinal reportKirby Christen Eagle · Wheeling, ILThe pilot's inadequate compensation for the wind conditions, and his failure to maintain obstacle clearance, which resulted in the airplane drifting during the landing flare and impacting the taxiway light.Jun 17, 2005 · N92RK · Substantial damageNTSB ATL05CA099Accident · Minor injuriesData collectionFinal reportCessna 150M · Panama City, FLThe pilot's misjudgment of distance/altitude while on final approach with a tailwind, which resulted in an undershoot of the runway.Jun 16, 2005 · N45372 · Substantial damageNTSB DEN05FA080Accident · Serious injuriesField investigationFinal reportSchweizer 269C · Pueblo, COthe flight instructor's failure to maintain control of the helicopter during the attempted autorotation after the loss of engine power for reasons undetermined. Contributing factors include the flight instructor's improper preflight planning, the high density…Jun 15, 2005 · N311CP · DestroyedNTSB SEA05CA116Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Yellow Pine, IDThe pilot's delay in executing a go-around which resulted in his failure to obtain altitude/clearance with trees.Jun 13, 2005 · N96156 · Substantial damageNTSB LAX05LA203Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Marble Canyon, AZthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around, which resulted in a stall.Jun 13, 2005 · N49LL · Substantial damageNTSB LAX05FA202Accident · No injuriesField investigationFinal reportBombardier Aerospace CL-600-2B19 · Los Angeles, CAfailure of the nose landing gear to extend to the down and locked position for undetermined reasons.Jun 13, 2005 · N960SW · Substantial damageNTSB CHI05LA138Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Jefferson City, MOThe pilot's delay in diverting to an alternate destination due to low fuel indications which led to the fuel exhaustion, loss of engine power and the subsequent forced landing. Factors were the pilot's improper preflight inspection which resulted in an…Jun 13, 2005 · N231HX · Substantial damageNTSB IAD05LA076Accident · Serious injuriesLimited investigationFinal reportAeronca C-3 · Toughkenamon, PAThe failure of the crankshaft, which resulted in a forced landing and subsequent collision with wires. A factor was the wires.Jun 12, 2005 · N13002 · Substantial damageNTSB NYC05CA097Accident · Minor injuriesData collectionFinal reportBurkhart Grob G103 Twin Astir · Wellington, OHThe pilot's misjudgment of distance and altitude which resulted in an undershoot of the runway.Jun 11, 2005 · N3872G · Substantial damageNTSB CHI05CA139Accident · Minor injuriesData collectionFinal reportGrimes SNS-9 · Niles, MIThe pilot's failure to maintain airspeed which led to the inadvertent stall/mush, and subsequent impact with the ground.Jun 10, 2005 · N143WW · Substantial damageNTSB NYC05IA093Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Dulles, VAFailure of the right main landing gear to extend and lock for undetermined reasons, which resulted in the right main landing gear collapsing during touchdown.Jun 9, 2005 · N40SZ · Minor damage