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 ATL02LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · St. Simons Island, GAThe pilot's failure to maintain airspeed during a simulated emergency landing, and his delayed remedial action that resulted in a stall, and an uncontrolled collision with trees. A factor was the check pilot's inadaquate supervision of the check ride.Sep 21, 2002 · N607JW · Substantial damageNTSB ATL02FA171Accident · 2 fatalField investigationFinal reportMooney M20R · Burnsville, NCThe pilot's failure to maintain airspeed during final approach, which resulted in an inadvertent stall and uncontrolled descent into trees and terrain. Factors were wind gusts and terrain-induced turbulence.Sep 20, 2002 · N574DJ · DestroyedNTSB LAX02FA288Accident · 3 fatalField investigationFinal reportMooney M-20E · Carlsbad, CAfailure of the pilots of both airplanes to maintain an adequate visual lookout and to see and avoid each other. A contributing factor was the failure of the controller to detect and resolve the conflict between the airplanes.Sep 17, 2002 · N7199U · 2 aircraft · DestroyedNTSB FTW02LA257Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601P · Piedmont, OKA fuel leak at the left boost pump to bladder tank flange, which resulted in fuel exhaustion and the subsequent loss of power to both engines.Sep 16, 2002 · N90652 · Substantial damageNTSB SEA02FA175Accident · 3 fatalField investigationFinal reportCessna TR182 · Twin Falls, IDThe pilot's failure to maintain runway alignment and his failure to execute a timely go-around maneuver resutling in the aircraft's impacting a parked fuel truck well clear of the runway safety area. Contributing factors were the strong crosswind/gusty wind…Sep 15, 2002 · N738GX · DestroyedNTSB IAD02LA093Accident · No injuriesLimited investigationFinal reportCessna 177 · Dayton, OHThe pilot's failure to maintain adequate airspeed, resulting in a stall.Sep 13, 2002 · N2916X · Substantial damageNTSB FTW02LA253Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Rector, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Sep 7, 2002 · N6369Q · Substantial damageNTSB CHI02LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Brooklyn Park, MNThe pilot's inadequate preflight preparation/planning, which resulted in fuel exhaustion and the loss of engine power. A factor to the accident was the power transmission line and the trees.Sep 5, 2002 · N48969 · Substantial damageNTSB LAX02LA273Accident · 1 fatalLimited investigationFinal reportPetrik Questair Venture · Crescent City, CAThe pilot's loss of control for undetermined reasons. A contributing factor was low ceiling.Sep 4, 2002 · N6UN · Substantial damageNTSB FTW02FA243Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-34 · Decatur, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. A contributing factor was lack of total experience in the make and model of the accident aircraft.Sep 2, 2002 · N2691H · Substantial damageNTSB MIA02LA165Accident · Serious injuriesLimited investigationFinal reportCessna T337D · Fort Pierce, FLThe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.Sep 1, 2002 · N33N · Substantial damageNTSB MIA02LA164Accident · Minor injuriesLimited investigationFinal reportClarence F. Callahan Challenger II · Plymouth, FLThe pilot's failure to maintain the proper alignment which resulted in the airplane impacting trees on the south side of the approach end of the landing runway.Sep 1, 2002 · N521CF · Substantial damageNTSB ATL02FA162Accident · 2 fatalField investigationFinal reportAmerican General AA-5B · Zephyrhills, FLThe pilots continued visual flight into instrument conditions (fog), and subsequent collision with a tree and a residence.Sep 1, 2002 · N81189 · DestroyedNTSB ANC02FA107Accident · 2 fatalField investigationFinal reportCessna A185F · Kodiak, AKThe pilot's failure to maintain adequate airspeed and his operation of the airplane in an over gross condition. A contributing factor was noncompliance with written company weight and balance procedures.Aug 28, 2002 · N7300R · Substantial damageNTSB IAD02LA090Accident · No injuriesLimited investigationFinal reportCessna T210N · Glastonbury, CTA partial loss of engine power for undetermined reasons. A factor in the airplane's damage was the standing corn.Aug 26, 2002 · N4908C · Substantial damageNTSB DEN02TA100Accident · Serious injuriesFinal reportBell 206L-3 · Saguache, COthe pilot's inadequate in-flight planning and decision making, and the loss of tail rotor effectiveness. A contributing factor was the right quartering tailwind.Aug 26, 2002 · N801HM · Substantial damageNTSB LAX02LA263Accident · No injuriesLimited investigationFinal reportPravecek Lawrence Varieze · Rio Linda, CAthe loss of engine power caused by fuel exhaustion due to a fuel tank leak. Also causal was the inadequate maintenance performed on the repair of the fuel tank by unknown maintenance personnel.Aug 25, 2002 · N42231 · Substantial damageNTSB IAD02LA089Accident · 1 fatalLimited investigationFinal reportPuhl Genesis · Petersburg, WVThe pilot's failure to maintain airspeed after a loss of engine power, which resulted in an inadvertent stall/spin. Factors included the pilot's inadequate preflight planning which resulted in fuel exhaustion, and the transmission wires in the pilot's glide…Aug 25, 2002 · N51XT · DestroyedNTSB CHI02LA263Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Seneca, ILThe loss of engine power for undetermined reasons. Factors were the low altitude, the trees, and the unsuitable terrain encountered for the forced landing.Aug 24, 2002 · N102MH · Substantial damageNTSB NYC02FA173Accident · 1 fatalField investigationFinal reportPiper PA-22-108 · Mayville, NYThe student pilot's failure to maintain adequate altitude during the landing approach and the private pilot's inadequate supervision, which resulted in a collision with a marked utility pole. A factor in this accident was the student pilot's lack of…Aug 21, 2002 · N5221Z · Substantial damageNTSB NYC02LA167Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Chatham, MAThe pilot's improper in-flight decision to continue the landing after losing visual contact with the runway, which resulted in his failure to obtain the proper touchdown point, and the subsequent overrun. Factors in this accident were the clouds and low…Aug 16, 2002 · N20787 · Substantial damageNTSB CHI02LA252Accident · Minor injuriesLimited investigationFinal reportLancair 320 · Iola, KSthe engine failure for undetermined reasons and the lack of a suitable landing area to execute a forced landing.Aug 15, 2002 · N83WS · Substantial damageNTSB NYC02LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Sangerville, METhe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall.Aug 14, 2002 · N56BC · Substantial damageNTSB ANC02FA097Accident · 2 fatalField investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's failure to maintain adequate airspeed while on approach to land, which resulted in an inadvertent stall, and subsequent collision with trees.Aug 14, 2002 · N4065Z · DestroyedNTSB SEA02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bellingham, WAThe pilot's improper decision to continue en route in cruise flight when his fuel supply became low, eventually leading to fuel exhaustion while on final approach to the destination airport. Factors include the fact that the final approach course took the…Aug 12, 2002 · N6420A · Substantial damageNTSB LAX02FA251Accident · 4 fatalField investigationFinal reportAero Commander 690A · Bishop, CAThe pilot's failure to maintain an appropriate terrain clearance altitude while maneuvering in the traffic pattern due to the sensory and visual illusions created by a lack of ground reference lights and/or terrain conspicuity, and the dark nighttime…Aug 11, 2002 · N690TB · DestroyedNTSB FTW02LA236Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · El Paso, TXThe pilot's inadequate recovery from a bounced landing, and his failure to maintain directional control. Contributing factors were the cross wind, and the pilot's lack of experience in the make and model of the accident airplane.Aug 10, 2002 · N7718V · Substantial damageNTSB ATL02IA155Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Tampa, FLThe failure of the left main landing gear retract cylinder support frame due to fatigue.Aug 10, 2002 · N388FE · Minor damageNTSB MIA02LA146Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Fort Lauderdale, FLthe pilot's abrupt pull up and his failure to maintain airspeed during a go-around, which resulted in an inadvertent stall/spin and impact with the terrain during the resultant uncontrolled descent.Aug 9, 2002 · N8180R · DestroyedNTSB LAX02LA248Accident · Minor injuriesLimited investigationFinal reportMooney M20M · Gualala, CAThe pilot's delayed decision in executing a go-around. Contributing factors were the pilot's limited experience landing on short fields and the rising terrain.Aug 8, 2002 · N1038K · DestroyedNTSB CHI02FA237Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Festus, MOThe pilot's lack of recent experience and his failure to maintain adequate airspeed which resulted in a stall and collision with the ground. The pilot's failure to execute a go-around was a factor.Aug 7, 2002 · N13MS · DestroyedNTSB NYC02LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PAThe pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision to not land and refuel which led to fuel exhaustion and subsequent loss of engine power.Aug 6, 2002 · N31SW · Substantial damageNTSB CHI02LA240Accident · No injuriesLimited investigationFinal reportCessna 150H · Dyersville, IAThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent loss of engine power. A related factor was the bean field.Aug 6, 2002 · N6995S · Substantial damageNTSB NYC02LA153Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Bluffton, OHThe pilot's fuel mismanagement with his failure to position the fuel selector to the proper tank which resulted in engine fuel starvation.Aug 4, 2002 · N110CF · Substantial damageNTSB MIA02FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Cheraw, SCThe misrouting of the fuel lines to the fuel selector, which resulted in the use of a fuel tank with inadequate fuel supply, fuel starvation, and the loss of engine power. Contributing was the pilot's inadequate remedial action for conducting an emergency…Aug 3, 2002 · N3450R · Substantial damageNTSB IAD02LA080Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Patuxent River, MDThe pilot's inadequate fuel calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.Aug 1, 2002 · N1177M · Substantial damageNTSB SEA02LA141Accident · No injuriesLimited investigationFinal reportCessna 210L · Cascade, IDThe pilot's failure to maintain the proper rate of descent on short final resulting in a touchdown short of the runway threshold. Contributing factors were the variable winds and swampy terrain at the touchdown site.Jul 30, 2002 · N732EK · Substantial damageNTSB SEA02LA138Accident · No injuriesLimited investigationFinal reportCessna T188C · Choteau, MTFuel exhaustion as a result of the pilot's inattention to fuel consumption (flight duration) which resulted in a total loss of power and subsequent hard landing.Jul 29, 2002 · N2802J · Substantial damageNTSB NYC02LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Kelleys Island, OHThe pilot-in-command's failure to obtain a proper touchdown point. A factor was the downdraft.Jul 28, 2002 · N15442 · Substantial damageNTSB DCA02MA054Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 727-232 · Tallahassee, FLThe captain's and first officer's failure to establish and maintain a proper glidepath during the night visual approach to landing. Contributing to the accident was a combination of the captain's and first officer's fatigue, the captain's and first officer's…Jul 26, 2002 · N497FE · DestroyedNTSB CHI02LA209Accident · No injuriesLimited investigationFinal reportBeech S35 · Minneapolis, MNThe proper glide path not obtained/maintained by the pilot. The approach lights were a contributing factor.Jul 24, 2002 · N6162G · Substantial damageNTSB CHI02CA201Accident · Minor injuriesData collectionFinal reportSchweizer 1-26B · New Douglas, ILThe probable cause of this accident was a failure to maintain the proper glide path and sufficient obstacle clearance while on final approach.Jul 20, 2002 · N111HK · Substantial damageNTSB LAX02LA230Accident · Serious injuriesLimited investigationFinal reportViolet Dragonfly · Tucson, AZThe pilot's loss of control resulting from his improperly planned approach and an inadvertent encounter with wake turbulence.Jul 18, 2002 · N48RV · DestroyedNTSB CHI02FA197Accident · 1 fatalField investigationFinal reportPiper PA-60 · Columbus, INThe pilot's failure to maintain control of the airplane during a missed approach. Additional factors included the operator's inadequate oversight, the pilot's improper in-flight decision, conditions conducive to pilot fatigue, fog, and night.Jul 18, 2002 · N158GA · DestroyedNTSB FTW02LA208Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Sherman, TXfuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.Jul 16, 2002 · N9466X · Substantial damageNTSB IAD02LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Barre, VTThe pilot's failure to maintain airspeed during a go-around attempt, which resulted in an inadvertent stall and a subsequent impact with trees. A factor was the pilot's delayed initiation of the go-around.Jul 15, 2002 · N43860 · Substantial damageNTSB FTW02LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Omaha, ARthe pilot's failure to maintain adequate airspeed during the go-around resulting in an inadvertent stall. A contributing factor was haze.Jul 15, 2002 · N22715 · Substantial damageNTSB FTW02CA206Accident · Serious injuriesData collectionFinal reportAero Commander Callair A-9B · El Paso, TXthe loss of control due to the encounter with the dust devil.Jul 13, 2002 · N7791V · Substantial damageNTSB CHI02LA185Accident · Minor injuriesLimited investigationFinal reportEskildsen P · Olathe, KSThe pilot's improper planning and decision making during the emergency descent and landing. The total loss of engine power due to fuel exhaustion and the pilot's inadvertent stall were contributing factors.Jul 7, 2002 · N2882 · Substantial damageNTSB SEA02FA124Accident · No injuriesField investigationFinal reportUnrein Productmatch 80 P51D · Battle Ground, WAThe pilot's failure to maintain the proper airspeed (80 mph) on final approach resulting in a bounced landing and a loss of control during an attempted go-around and ultimately the on ground collision with a residence. Contributing factors were the pilot's…Jul 6, 2002 · N51PL · Substantial damage