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 IAD02LA048Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fairfield, PAThe pilot's failure to attain proper runway alignment. A factor in the accident was the pilot's delay in retracting the spoilers.May 5, 2002 · N5364G · Substantial damageNTSB CHI02LA122Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hastings, MIThe failure to attain airspeed, inadequate supervision of the flight, and delayed remedial action which resulted in a stall.May 4, 2002 · N2494B · Substantial damageNTSB CHI02FA120Accident · 1 fatalField investigationFinal reportCessna 182S · Sheboygan, WIThe pilot failed to maintain control of the airplane during the go-around for undetermined reasons.May 3, 2002 · N293MA · DestroyedNTSB CHI02LA118Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Racine, WIThe inadequate weather evaluation and delayed application of carburetor heat by the pilot, and the unsuitable terrain encountered during the forced landing. The carburetor icing conditions and the low altitude were factors.Apr 30, 2002 · N6RP · Substantial damageNTSB ATL02LA093Accident · No injuriesLimited investigationFinal reportCessna 150B · Enterprise, ALThe pilot's failure to maintain airspeed during an attempted go-around that resulted in an inadvertent stall and the subsequent collision with the ground.Apr 26, 2002 · N1299Y · Substantial damageNTSB CHI02LA114Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe pilot's improper fuel management resulting in the total loss of engine power due to fuel starvation and the pilot's failure to use the checklist.Apr 23, 2002 · N563PU · Substantial damageNTSB SEA02LA071Accident · No injuriesLimited investigationFinal reportBrunger Osprey II · Orofino, IDThe aircraft's inadequate carburetor heat air box system, leading to an accumulation of ice in the carburetor throat during final approach to landing. Factors include carburetor icing conditions, the pilot's failure to correctly judge the height of the…Apr 21, 2002 · N56GB · Substantial damageNTSB LAX02LA139Accident · No injuriesLimited investigationFinal reportBeech 76 · Petaluma, CAThe flight instructor's decision to execute a simulated single engine go-around at an altitude insufficient to preclude the inadvertent ground contact of the airplane and the resultant loss of directional control. The flight instructor's delayed remedial…Apr 19, 2002 · N6636J · Substantial damageNTSB NYC02LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Clifford, PAThe pilot's failure to maintain a proper visual lookout for trees. A factor was sunglare.Apr 17, 2002 · N4480M · Substantial damageNTSB LAX02LA138Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319-114 · Reno, NVThe failure of an undetermined cabin crewmember to securely close an aft galley compartment door, which necessitated the injured crewmember leaving her seat to secure the compartment door.Apr 15, 2002 · N325NB · No damageNTSB ATL02LA085Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Gainesville, FLThe pilot's failure to maintain clearance from the ground during an attempted go-around.Apr 15, 2002 · N91GD · Substantial damageNTSB IAD02FA043Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Oxford, CTThe pilot's failure to follow the published instrument approach procedure. Factors were the night and low ceiling conditions.Apr 13, 2002 · N82284 · DestroyedNTSB FTW02LA121Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Conway, ARThe pilot's failure to land the airplane at a proper touchdown point on the runway and his delayed decision to initiate a go-around over high obstacles.Apr 13, 2002 · N4090D · Substantial damageNTSB ATL02LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Smithfield, NCThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power.Apr 13, 2002 · N8458U · Substantial damageNTSB FTW02LA124Accident · No injuriesLimited investigationFinal reportCessna 172R · Longview, TXThe in-flight collision with a bird.Apr 12, 2002 · N61LU · Substantial damageNTSB CHI02LA102Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Council Bluffs, IAThe student pilot's failure to maintain control of the airplane and the subsequent inadvertent stall. A factor associated with the accident was the student's lack of total experience.Apr 9, 2002 · N53066 · Substantial damageNTSB FTW02FA113Accident · 2 fatalField investigationFinal reportBeech D-45 · Minden, LAThe private pilot's failure to maintain aircraft control during a go-around. Contributing factors were the private pilot's impairment due to drugs, the pilot-rated passenger's lack of experience in the airplane, and the prevailing gusty crosswind conditions.Apr 6, 2002 · N6VY · Substantial damageNTSB ATL02FA074Accident · 1 fatalField investigationFinal reportPiper PA-16 · Lakeland, FLThe failure of the PA-16 pilot to maintain a visual lookout and to yield the right-of-way to a lower aircraft while on final approach resulting in a midair collision. Contributing to the accident was the failure of both pilot's to adhere to an ATC clearance…Apr 5, 2002 · N5293H · 2 aircraft · Substantial damageNTSB IAD02LA041Accident · No injuriesLimited investigationFinal reportCessna U206F · Matinicus, MEA partially blocked fuel metering unit inlet screen, which resulted in a partial loss of engine power. Also causal, was the operator's lack of inlet screen inspection procedures.Apr 3, 2002 · N1523U · Substantial damageNTSB IAD02LA040Accident · Serious injuriesLimited investigationFinal reportCessna T310R · Mount Holly, NJThe pilot's misjudgment of distance, his subsequent improper recovery from a bounced landing, and the failure to maintain airspeed which resulted in an inadvertent stall.Apr 3, 2002 · N5079J · Substantial damageNTSB LAX02LA121Accident · Serious injuriesLimited investigationFinal reportRotorway Exec 165F · Chandler, AZThe tail rotor drive system failure as a result of incorrect installation procedures by the manufacturer's personnel.Apr 1, 2002 · N21901 · Substantial damageNTSB ATL02FA069Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Apex, NCThe pilot experienced spatial disorientation that resulted in the loss of control and the overload failure of the airframe. A factor was low visibility and ceilings.Mar 31, 2002 · N2BX · DestroyedNTSB SEA02FA060Accident · No injuriesField investigationFinal reportBoeing S-307 · Seattle, WALoss of all engine power due to fuel exhaustion that resulted from the flight crew's failure to accurately determine onboard fuel during the pre-flight inspection. A factor contributing to the accident was a lack of adequate crew communication regarding the…Mar 28, 2002 · N19903 · Substantial damageNTSB NYC02LA074Accident · No injuriesLimited investigationFinal reportCessna 182C · Moneta, VAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion.Mar 24, 2002 · N8667T · Substantial damageNTSB MIA02LA071Accident · No injuriesLimited investigationFinal reportBeech C-24R · Bayou La Batre, ALThe pilot's failure to maintain aircraft directional control while executing a go-around, resulting in an inflight collision with trees.Mar 24, 2002 · N18891 · Substantial damageNTSB DEN02FA034Accident · 4 fatalField investigationFinal reportCessna 340 · Englewood, COthe pilot not following procedures/directives (flying a landing approach with the left fuel selector in the auxiliary position). Contributing factors were the loss of the left engine power due to fuel starvation, the pilot's failure to maintain aircraft…Mar 24, 2002 · N341DM · DestroyedNTSB FTW02LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Terrell, TXthe inadequate supervision by the flight instructor resulting in the dual student's failure to maintain the proper glidepath during the short field approach. A contributing factor was the downdraft.Mar 22, 2002 · N3687M · Substantial damageNTSB CHI02FA094Accident · 2 fatalField investigationFinal reportPiper PA-31P · Daleville, INThe pilots failure to maintain control of the airplane during the instrument approach. The low overcast ceiling and the pilot's in-flight decision to execute the instrument approach in below minimum weather conditions were factors.Mar 18, 2002 · N125TT · DestroyedNTSB NYC02LA071Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR-20 · Lexington, KYThe pilot's failure to maintain aircraft control. Factors in this accident were the undetermined failure of the turn coordinator, as reported by the pilot, and the instrument meteorological conditions.Mar 16, 2002 · N244CD · Substantial damageNTSB IAD02FA037Accident · 4 fatalField investigationFinal reportCessna 172P · Ocean City, MDThe pilot's spatial disorientation, which resulted in his subsequent loss of control of the airplane. A factor was the dark night, over water visual conditions.Mar 16, 2002 · N96811 · DestroyedNTSB SEA02LA054Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Rainier, WAThe pilot's failure to maintain the proper decent rate on approach. A factor was the trees in close proximity to the airport.Mar 14, 2002 · N8065A · Substantial damageNTSB LAX02FA108Accident · Serious injuriesField investigationFinal reportBeech E90 · Reno, NVThe pilot's inadequate approach airspeed for the existing adverse meteorological conditions followed by his delayed remedial action to avert stalling and subsequent loss of airplane control. Contributing factors were the pilot's reduced visibility due to the…Mar 14, 2002 · N948CC · DestroyedNTSB ATL02FA063Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Laurens, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with terrain. Factors were low clouds and dark-night.Mar 9, 2002 · N160D · DestroyedNTSB ATL02FA062Accident · 2 fatalField investigationFinal reportEurocopter France AS355 F1 · Savannah, GAThe pilot's failure to follow operating procedures and, experienced spatial disorientation while attempting a night landing to an offshore platform. A factor was a dark night.Mar 9, 2002 · N355D · Substantial damageNTSB LAX02TA105Accident · No injuriesFinal reportPiper PA-18-150 · Winnemucca, NVThe pilot's inadequate fuel consumption calculations that lead to fuel exhaustion.Mar 8, 2002 · N742 · Substantial damageNTSB SEA02LA050Accident · No injuriesLimited investigationFinal reportUnander Velocity 173RG · West Jordan, UTThe pilot's failure to ensure that the gear was extended prior to landing. Factors included a failure of a hydraulic down-pressure switch, and the pilot's attention diverted to another aircraft executing an opposite-direction traffic pattern.Mar 6, 2002 · N278GJ · Substantial damageNTSB MIA02FA066Accident · 2 fatalField investigationFinal reportCessna 172N · Bunnell, FLInadequate maintenance inspection of the airplane by comapny maintenance personnel which resulted in corrosion in an aileron control cable going undetected, failure of the aileron control cable, and impact with terrain following loss of control of the…Mar 6, 2002 · N75908 · Substantial damageNTSB ANC02LA021Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Whittier, AKThe pilot's Failure to maintain a proper descent rate during landing. Factors associated with the accident are variable wind conditions, and the pilot's improper approach to the landing site.Mar 6, 2002 · N8316N · Substantial damageNTSB ANC02FA020Accident · No injuriesField investigationFinal reportCessna 208B · Barrow, AKThe pilot's continued flight into adverse weather conditions, and an inadvertent stall. Factors associated with the accident are fog, obscuration, and icing conditions.Mar 6, 2002 · N208TF · Substantial damageNTSB FTW02LA089Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Tulsa, OKthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Mar 4, 2002 · N227H · Substantial damageNTSB LAX02LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · San Diego, CAfuel starvation due to the pilot's mismanagement of the fuel system.Mar 3, 2002 · N1775T · Substantial damageNTSB SEA02LA046Accident · No injuriesLimited investigationFinal reportCessna 421C · Hailey, IDWater contamination within the aircraft's landing gear hydraulic line(s) which froze and blocked the line(s) preventing extension of the right main gear. A factor was the below freezing environmental conditions which the aircraft was operating in prior to and…Mar 2, 2002 · N421DG · Substantial damageNTSB LAX02LA098Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Peoria, AZFailure of the cyclist to coordinate and communicate that he was on the active runway. A contributing factor was the sun glare encountered by the pilot on final approach.Mar 1, 2002 · N2466W · Substantial damageNTSB FTW02FA087Accident · 2 fatalField investigationFinal reportBeech A36 · Austin, TXThe pilot's failure to maintain airspeed, resulting in a stall. Contributing factors were the low ceiling, fog, and the unforecast weather conditions..Mar 1, 2002 · N7236L · DestroyedNTSB ANC02LA019Accident · No injuriesLimited investigationFinal reportCessna 207A · Kotlik, AKThe failure of the pilot-in-command to maintain the proper glide path to the runway during the final approach for a VFR landing.Mar 1, 2002 · N7373U · Substantial damageNTSB SEA02LA045Accident · No injuriesLimited investigationFinal reportGunderson Floatmaster · Elma, WALoss of engine power for undetermined reasons. Soft terrain was a factor.Feb 27, 2002 · N2425D · Substantial damageNTSB LAX02FA097Accident · 1 fatalField investigationFinal reportGrumman American AA1B · Pomona, CAa total loss of engine power due to an excessively rich mixture setting in the carburetor. The overly rich operation of the carburetor was due to the overhaul shop's failure to obtain the proper clearance between the float and chamber walls, which allowed the…Feb 27, 2002 · N1628R · Substantial damageNTSB LAX02LA095Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAThe pilot's inadequate planning and improper fuel consumption calculation, which resulted in fuel exhaustion.Feb 25, 2002 · N7604P · Substantial damageNTSB IAD02LA035Accident · Serious injuriesLimited investigationFinal reportBeechcraft C23 · Wilmington, DEthe flight instructor's improper fuel management which resulted in fuel starvation. A factor in the accident was the flight instructor's failure to follow the published checklist procedures.Feb 25, 2002 · N2192W · Substantial damageNTSB LAX02LA091Accident · No injuriesLimited investigationFinal reportBeech V35 · San Jose, CAa loss of engine power for undetermined reasons, which resulted in a forced landing into a residential area.Feb 23, 2002 · N131Y · Substantial damage