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 SEA00LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Wallowa, ORThe pilot's failure to maintain proper runway alignment upon encountering a wind gust, and his subsequent failure or inability to maintain clearance with a tree during a go-around attempt. Factors included a short and narrow airstrip, gusty wind conditions,…Apr 4, 2000 · N78DE · Substantial damageNTSB MIA00IA128Incident · No injuriesIncident investigationFinal reportDassault DA-20 · Opa Locka, FLThe failure of the PIC to execute the complete procedure for emergency extension of the landing gear and the subsequent landing with the left main landing gear not locked fully down, resulting in an excursion off the runway and collision with a runway…Apr 4, 2000 · N175GA · Minor damageNTSB IAD00LA031Accident · No injuriesLimited investigationFinal reportBeech 23 · Selinsgrove, PAThe student pilot's inadequate correction for torque, which resulted in a loss of directional control of the airplane.Apr 3, 2000 · N1923L · Substantial damageNTSB LAX00LA145Accident · No injuriesLimited investigationFinal reportOwens/Richburg Vans RV6-A · Sacramento, CAFailure to maintain sufficient altitude while on the base to final turn for landing subsequently striking the wing tip on the runway.Apr 2, 2000 · N4419Q · Substantial damageNTSB ANC00LA040Accident · No injuriesLimited investigationFinal reportCessna 150M · Skwentna, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were the pilot's disorientation, landing at the wrong airport, flat lighting conditions, and his delay in initiating a go-around.Apr 2, 2000 · N704GK · Substantial damageNTSB MIA00LA125Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Rocky Mount, NCThe pilot's inadvertent VFR flight into IMC conditions and the failure of the pilot to maintain altitude/clearance resulting in the in-flight collision with trees and unmarked power lines during a visual approach to the runway.Mar 31, 2000 · N8230V · Substantial damageNTSB LAX00LA140Accident · 1 fatalLimited investigationFinal reportStuart RAF 2000 GTX SE · Overton, NVFailure of the pilot to obtain/maintain aircraft control. A factor in the accident was the pilot's inexperience in rotorcraft.Mar 27, 2000 · N60739 · DestroyedNTSB MIA00LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe partial loss of engine power due to undetermined reasons.Mar 26, 2000 · N757JE · Substantial damageNTSB MIA00LA119Accident · Minor injuriesLimited investigationFinal reportBair Helicopters Searey · Kill Devil Hill, NCThe inadvertent stall by the pilot-in-command while on final approach resulting in the uncontrolled descent and in-flight collision with water.Mar 26, 2000 · N246DB · Substantial damageNTSB FTW00FA103Accident · 1 fatalField investigationFinal reportCessna 525 · Buda, TXthe pilot's inadequate in-flight decision to continue a visual approach in instrument meteorological conditions which resulted in his failure to maintain terrain clearance. Contributing factors were the fog, drizzle, and low ceilings.Mar 26, 2000 · N130MR · DestroyedNTSB DEN00LA065Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Hanksville, UTThe pilot inadvertently allowing the airplane to porpoise after landing hard, and inadvertently stalling the airplane after aborting the landing attempt. Factors were wind gusts, and the pilot failing to reconfigure the airplane (resetting the elevator trim…Mar 25, 2000 · N2722Q · DestroyedNTSB LAX00FA134Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Rialto, CAThe pilot's in-flight loss of control for undetermined reasons.Mar 24, 2000 · N8328Q · DestroyedNTSB DEN00LA064Accident · Minor injuriesLimited investigationFinal reportJohnson Zodiac CH 601 HDS · West Jordan, UTTotal failure of an oil line fitting, resulting in oil exhaustion and subsequent engine seizure. Factors were the poor fitting installation by the pilot, and unsuitable terrain on which to make a forced landing.Mar 24, 2000 · N984J · DestroyedNTSB MIA00FA117Accident · 1 fatalField investigationFinal reportCessna 177RG · Columbia, SCThe PIC's inadequate planning and preparation resulting in refueling not being performed and the subsequent fuel exhaustion and forced landing into trees. A factor in the accident was the erratic operation of the right fuel tank quantity indicating system.Mar 22, 2000 · N1556H · DestroyedNTSB NYC00LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · New Brighton, PAThe pilot's inadequate compensation for the gusty wind conditions. A factor was the windshear encountered on final approach.Mar 19, 2000 · N6261E · Substantial damageNTSB ANC00LA036Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKThe pilot's inadvertent stall during an attempted go-around. A factor associated with the accident was the pilot's failure to maintain proper runway alignment.Mar 19, 2000 · N96082 · Substantial damageNTSB IAD00LA027Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Erwinna, PAthe improper entry into the traffic pattern by the pilot of the Piper airplane and the inadequate lookout by the pilots in both airplanes. A factor in the accident was that radio communication was not possible because the Piper was not so equipped, and the…Mar 18, 2000 · N2520Z · 2 aircraft · Substantial damageNTSB MIA00FA107Accident · No injuriesField investigationFinal reportCessna 310D · Stuart, FLthe failure of both pilots to maintain an adequate visual lookout, resulting in both airplanes colliding in flight. Contributing to the accident were: 1) inadequate approach/departure control service by ATC approach/departure personnel, and the failure of the…Mar 14, 2000 · N6744T · 2 aircraft · Minor damageNTSB FTW00LA094Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe failure of the pilot to refuel the airplane which resulted in fuel exhaustion. Factors were the pilot's poor preflight planning, failure to lean the mixture in accordance with the POH, and lack of suitable terrain for the forced landing.Mar 10, 2000 · N68333 · Substantial damageNTSB CHI00LA089Accident · No injuriesLimited investigationFinal reportBeech A36 · Pontiac, MIthe pilot's decision to fly into known adverse weather conditions which included icing and his inability to maintain aircraft control and a proper glidepath during the approach. Factors associated with the accident were the icing weather conditions and the…Mar 10, 2000 · N311JR · Substantial damageNTSB ATL00LA036Accident · 2 fatalLimited investigationFinal reportTrike Unknown · Dalton, GAThe pilot's failure to maintain appropriate clearance with objects during final approach to landing. A factor was the tree.Mar 7, 2000 · NONE · DestroyedNTSB LAX00LA117Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Palo Alto, CAThe pilot's failure to obtain/maintain the proper visual glide path resulting in an undershoot and collision with the runway edge.Mar 5, 2000 · N43412 · Substantial damageNTSB NYC00LA087Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Rome, NYThe pilot inadvertently selecting the mixture control to off, resulting in a total loss of engine power.Mar 4, 2000 · N3719H · Substantial damageNTSB IAD00LA025Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Blairstown, NJthe encountering of wind conditions in flight that inhibited the pilot from maintaining altitude.Mar 4, 2000 · N97VT · DestroyedNTSB ATL00LA031Accident · 1 fatalLimited investigationFinal reportunknown unknown · Manatee, FLThe pilot's impairment due to the use of unapproved medication which led to loss of control in flight.Mar 3, 2000 · UNREG · DestroyedNTSB MIA00LA099Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Brooksville, FLTotal loss of engine power for undetermined reasons on appr oach for landing resulting in an in-flight collision with a dirt bank, separation of the main landing gear, and subsequent nose over. Contributing to the accident was carburetor icing conditions.Feb 28, 2000 · N717NC · Substantial damageNTSB ATL00LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Titusville, FLThe pilot's improper decision to attempt a flight on minimal fuel, which resulted in a total loss of engine power due to fuel exhaustion. A factor was the closed fuel pumps at the departure airport.Feb 28, 2000 · N441WA · Substantial damageNTSB DEN00LA054Accident · No injuriesLimited investigationFinal reportMooney M-20C · Boulder, COThe pilot not following procedures in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing, weather conditions conducive to carburetor ice, and lack of suitable terrain for landing.Feb 26, 2000 · N90MR · Substantial damageNTSB CHI00LA082Accident · 1 fatalLimited investigationFinal reportEllis Q2 · Shelbyville, INaircraft control not being maintained by the pilot during the attempted go-around. Factors to the accident were the inadequate preflight by the pilot, which resulted in fuel exhaustion. An additional factor to the accident was the inadvertent stall/mush.Feb 25, 2000 · N84DG · DestroyedNTSB CHI00FA080Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Moorhead, MNthe pilot's failure to maintain aircraft control during the missed approach. Factors to the accident were, the pilot's improper decision to attempt the approach in weather conditions below the approach/landing minimums, the weather, the pilot's lack of…Feb 24, 2000 · N7736R · DestroyedNTSB IAD00FA023Accident · 1 fatalField investigationFinal reportAerotechnik L-13 SEH Vivat · Plymouth, MAthe flight instructor's inadequate compensation for the wind conditions. A factor was the flight instructor's improper use of speed brakes and the strong gusty winds with downdrafts.Feb 23, 2000 · N64RG · DestroyedNTSB ANC00LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-T3 · Kotzebue, AKThe pilot descended below the minimum descent altitude. Factors associated with this accident were the task overload of the pilot during the instrument approach, and not performing a level off.Feb 21, 2000 · N219CS · Substantial damageNTSB MIA00LA093Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Miami, FLthe pilot planned the approach too low, which resulted in inadequate altitude to clear powerlines, and the subsequent in-flight collision with the ground.Feb 19, 2000 · N65819 · Substantial damageNTSB ATL00LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.Feb 19, 2000 · N68197 · Substantial damageNTSB DEN00IA052Incident · No injuriesIncident investigationFinal reportCessna TR182 · Fort Carson, COThe pilot electing to fly the aircraft with known deficiencies which resulted in a catastrophic engine failure. Factors were a connecting rod failure, and low engine oil level.Feb 17, 2000 · N155HC · No damageNTSB LAX00FA101Accident · Minor injuriesField investigationFinal reportCessna 172N · Palm Springs, CAthe failure of both flight crews to see and avoid the other airplane while operating in the traffic pattern, which resulted in a mid-air collision. A contributing factor was the failure of the arriving aircraft to comply with air traffic control requests by…Feb 16, 2000 · N6479D · 2 aircraft · Substantial damageNTSB FTW00LA082Accident · Minor injuriesLimited investigationFinal reportBeech BE-35K · Houston, TXThe pilot's failure to refuel resulting in fuel exhaustion and a total loss of engine power. Factors were the low ceilings, mist, and the pilot's inability to fly the ILS approach.Feb 15, 2000 · N6089E · Substantial damageNTSB FTW00LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · College Station, TXThe loss of engine power due to fuel system contamination. A factor was the lack of suitable terrain for the forced landing.Feb 13, 2000 · N7878P · Substantial damageNTSB CHI00LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Olathe, KSthe pilots improper use of powerplant controls. A factor in the accident was the plowed farm field.Feb 12, 2000 · N711VS · Substantial damageNTSB CHI00FA070Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Lewiston, IDthe pilot failed to follow the flight manual procedures and did not engage the Continuous Ignition system resulting in both engines flaming out when the air induction system was blocked with ice. Additional factors to the accident included the hilly terrain,…Feb 11, 2000 · N152BK · DestroyedNTSB CHI00LA067Accident · No injuriesLimited investigationFinal reportBeech V35 · Schaumburg, ILinadequate aircraft preflight by the pilot and fuel consumption calculations not being preformed by the pilot. Factors to the accident were fuel exhaustion, the rocks/boulders, and the high vegetation.Feb 10, 2000 · N9582Q · DestroyedNTSB ATL00FA024Accident · 2 fatalField investigationFinal reportMooney M20J · Odessa, FLThe pilot's failure to maintain a safe altitude and his failure to attain the proper touchdown point during landing. A factor was the utility pole.Feb 10, 2000 · N201RC · Substantial damageNTSB ANC00LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-T3 · Wales, AKThe pilot's inadequate evaluation of the weather conditions, and his inadvertent flight into adverse weather conditions. Factors in the accident were terrain induced turbulence and a tailwind.Feb 9, 2000 · N110JK · Substantial damageNTSB CHI00MA066Accident · 3 fatalMajor investigationFinal reportMoravan Z242L · Zion, ILClearance not maintained by the pilot of the other airplane. A factor relating to the accident was the airport control tower's local controller's failure to provide effective sequencing.Feb 8, 2000 · N5ZA · 2 aircraft · DestroyedNTSB LAX00LA253Accident · No injuriesLimited investigationFinal reportCessna 310L · Flagstaff, AZthe fracture across the eyelet of the nose gear retraction rod, which prevented the extension of the nose gear.Feb 7, 2000 · N867MF · Substantial damageNTSB MIA00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fayette, ALThe pilot's failure to maintain directional and altitude control of the airplane during a ago-around maneuver, resulting in collision with a fence and utility pole.Feb 4, 2000 · N8924T · Substantial damageNTSB LAX00LA086Accident · No injuriesLimited investigationFinal reportRobinson R44 · Palo Alto, CAThe pilot's failure to use carburetor heat, resulting in a loss of engine power, and, his misjudged autorotation approach that resulted in a collision with the ground during the landing flare. Contributing to the accident was the conditions conducive to…Feb 2, 2000 · N999EV · Substantial damageNTSB LAX00LA085Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF260 · Napa, CAFuel exhaustion due to the pilot's inadequate en route fuel consumption calculations.Jan 30, 2000 · N65FD · Substantial damageNTSB FTW00LA084Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Dallas, TXThe diminished effectiveness of the anti-skid brake system due to the slush contaminated runway. Factors were the freezing rain encountered during the approach, coupled with a failure of the horizontal stabilizer heat.Jan 27, 2000 · N900WJ · Substantial damageNTSB SEA00FA038Accident · No injuriesField investigationFinal reportHughes 269C · Sherwood, ORThe pilots failure to arrest the helicopter's descent rate during a planned approach to a hover. Factors include uneven terrain.Jan 18, 2000 · N9297F · Substantial damage