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 CHI00LA008Accident · No injuriesLimited investigationFinal reportCessna 150F · East Troy, WIthe pilot not maintaining directional control and not obtaining a proper climb rate. Factors were the gusts, and the ground loop that was encountered. A finding was the pilot atempted a go-around.Oct 13, 1999 · N7941F · Substantial damageNTSB LAX00LA007Accident · No injuriesLimited investigationFinal reportPitts S2B · Salinas, CAThe pilot's inadequate compensation for the effects of torque and P-factor during a go-around from a bounced landing, which led to a loss of control and the inadvertent dragging of a wing.Oct 11, 1999 · N50AL · Substantial damageNTSB NYC00LA024Accident · No injuriesLimited investigationFinal reportCessna 177 · Frankfort, KYA total loss of engine power for undetermined reasonsOct 7, 1999 · N29362 · Substantial damageNTSB LAX00LA005Accident · Serious injuriesLimited investigationFinal reportCessna 210B · Tonopah, NVThe pilot's failure to monitor his altitude and maintain an adequate terrain clearance during the approach. The dark night lighting conditions and the visual illusion created by the lack of ground reference lights were factors in the accident.Oct 6, 1999 · N9609X · Substantial damageNTSB NYC00FA004Accident · 1 fatalField investigationFinal reportCessna 182R · Killingworth, CTThe pilot's failure follow the published instrument approach procedure. A factor in the accident was the low cloud ceiling.Oct 4, 1999 · N121BG · DestroyedNTSB MIA00LA001Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in engine failure due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.Oct 3, 1999 · N49508 · Substantial damageNTSB LAX00LA002Accident · No injuriesLimited investigationFinal reportZdybel Glasair FT · Rio Linda, CAFuel starvation due to the owner/builder's improper installation of the fuel selector valve, and, his failure to placard the operating positions of the valve handle.Oct 2, 1999 · N711FZ · Substantial damageNTSB FTW00FA001Accident · 2 fatalField investigationFinal reportCessna P210N · Spicewood, TXThe pilot's delayed application of full throttle during a go-around, which resulted in a slow airspeed and inadvertent stall/spin. A factor was the pilot's habit of only applying partial power during takeoff.Oct 2, 1999 · N7542K · DestroyedNTSB DEN00LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · La Junta, COThe pilot-in-command's failure to maintain a proper altitude during final approach to landing, and his misjudgment of altitude clearances. Factors were the sudden windshift, downdraft and turbulent weather conditions, the dark night, and the pilot's lack of…Oct 2, 1999 · N6406P · Substantial damageNTSB DEN00LA001Accident · Serious injuriesLimited investigationFinal reportGray Rotorway Exec · Gallup, NMThe pilot inadvertently allowing main rotor rpm to decay while avoiding obstacles during an emergency autorotation following a loss of power for reasons undetermined. Factors were houses and powerlines.Oct 1, 1999 · N716JB · Substantial damageNTSB DEN99LA173Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Longmont, COAn inaccurate touchdown during a full autorotation, which resulted in main rotor flex which cut off the tail boom. Factors were the pilot's lack of total experience in helicopters and high density altitude.Sep 30, 1999 · N84DH · Substantial damageNTSB IAD99FA070Accident · Serious injuriesField investigationFinal reportCessna 310Q · Salisbury, MDThe improper installation of the #2 cylinder that resulted in a fractured crankshaft and a total loss of engine power. Factors in the accident were the premature deployment of the landing gear and flaps by the pilot.Sep 28, 1999 · N69945 · Substantial damageNTSB MIA99FA269Accident · 1 fatalField investigationFinal reportPiper PA-31P · Louisville, MSThe pilot's disregard for the published minimum descent altitude resulting in tree contact and separation of 51 inches of the left wing. Findings in the investigation were the pilot's two failures of the ATP checkride in a multiengine airplane.Sep 27, 1999 · N100EE · DestroyedNTSB CHI99LA349Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Detroit, MIthe pilot's failure to maintain control of the airplane which resulted in the inadvertent spin. A factor was the pilot snagged the banner pole.Sep 27, 1999 · N40LM · DestroyedNTSB LAX99FA310Accident · Minor injuriesField investigationFinal reportCessna 421C · Santa Monica, CAThe failure of the pilot to establish and maintain a stabilized approach, which resulted in a hard landing and on-ground collision with the airport VASI display.Sep 23, 1999 · N26585 · Substantial damageNTSB SEA99LA173Accident · No injuriesLimited investigationFinal reportCessna 150M · Camas, WAA misjudged approach and inadequate airspeed. Sunglare, a delayed decision to go-around, and not maintaining clearance from a fence were factors.Sep 22, 1999 · N704XA · Substantial damageNTSB MIA99FA263Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Moreland, GAThe pilot's failure to maintain the minimum descent altitude while executing a localizer approach. Contributing factors were low ceilings and dark night conditions as well as the trees.Sep 21, 1999 · N27343 · DestroyedNTSB DEN99LA166Accident · No injuriesLimited investigationFinal reportCessna 172G · Delta, COA forced landing due to fuel exhaustion. Factors were inadequate preflight planing, inadequate in-flight planing and rough uneven, unsuitable terrain for a forced landing.Sep 19, 1999 · N4262L · Substantial damageNTSB ATL99LA133Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Enterprise, ALThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was the in-flight collision with a tree during the forced landing.Sep 19, 1999 · N6736Q · DestroyedNTSB LAX99LA313Accident · No injuriesLimited investigationFinal reportCessna 172N · Merced, CAThe pilot's premature retraction of the flaps during an attempted go-around with insufficient airspeed, which led to an inadvertent stall/mush condition.Sep 17, 1999 · N2339E · Substantial damageNTSB LAX99LA307Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Azusa, CAthe pilot's delay in recognizing the settling with power condition while performing a pinnacle approach, thus delaying his attempted go-around.Sep 14, 1999 · N8328Q · Substantial damageNTSB NYC99LA224Accident · 1 fatalLimited investigationFinal reportNorth American T6-G · Falmouth, KYThe pilot's misjudgment of altitude/clearance on approach which resulted in an in-flight collision with trees.Sep 12, 1999 · N7767C · Substantial damageNTSB NYC99LA223Accident · No injuriesLimited investigationFinal reportBeech A23 · Carlisle, PAThe pilot's improper fuel management, resulting in fuel starvation.Sep 12, 1999 · N3508R · Substantial damageNTSB LAX99LA304Accident · Minor injuriesLimited investigationFinal reportGlover Teenie TWO · Chino, CAThe in-flight separation and loss of the carburetor fuel jet resulting from the pilot's improper installation of the component. Also causal was the pilot's failure to maintain an adequate airspeed margin following the loss of power, which resulted in an…Sep 12, 1999 · N925SG · DestroyedNTSB MIA99LA251Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30 · Athens, GAThe pilot's improper fuel management resulting in loss of engine power on approach due to fuel starvation and damage to the aircraft during the subsequent forced landing.Sep 11, 1999 · N6676V · Substantial damageNTSB ATL99LA131Accident · Minor injuriesLimited investigationFinal reportHiller UH-12A · Satartia, MSThe pilot's failure to maintain control of the helicopter while on approach which resulted in the uncontrolled collision with the ground. A factor was the pilot's physiological condition.Sep 11, 1999 · N212W · Substantial damageNTSB MIA99FA250Accident · Serious injuriesField investigationFinal reportMbb BO105CBS · Kenansville, FLThe pilots failure to recognize entry into settling with power during approach to land and his failure to take remedial action to escape from settling with power resulting in the helicopter descending and colliding with trees and swampy terrain.Sep 10, 1999 · N911HR · Substantial damageNTSB CHI99LA337Accident · 1 fatalLimited investigationFinal reportReichert MJ-77 · Owosso, MIthe pilot's improper preflight which resulted in a takeoff with the oil cap not secured and the subsequent loss of engine power.Sep 10, 1999 · N51MJ · Substantial damageNTSB ATL99LA128Accident · No injuriesLimited investigationFinal reportCessna 182P · Collegedale, TNThe pilot's failure to secure the fuel cap which resulted in fuel exhaustion and the loss of engine power. A factor was the collision with a fence post.Sep 9, 1999 · N78092 · Substantial damageNTSB ATL99TA126Accident · No injuriesFinal reportHughes OH-6A · Hernando, MSThe in-flight encounter with weather that resulted in the loss of tail rotor control. The pilot failed to maintain directional control and the helicopter collided with the ground.Sep 7, 1999 · N584SD · Substantial damageNTSB CHI99LA331Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Forest Lake, MNthe pilot's misjudging the proper glidepath, and his not maintaining airspeed. Factors were the pilot's lack of recent experience, the airplane's inadvertent stall, and the fence.Sep 6, 1999 · N9549S · Substantial damageNTSB LAX99LA296Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Big Bear City, CAThe pilot's failure to follow the manufacturer's procedures to fully enrich the mixture, which induced an overly lean condition during full power application on the go-around and a resulting loss of power. The high density altitude weather condition was a…Sep 5, 1999 · N849B · Substantial damageNTSB SEA99LA153Accident · No injuriesLimited investigationFinal reportCessna 210B · Dixie, IDInadequate airspeed and clearance was not maintained. Mountainous conditions, trees, and an inadequately planned approach were factors.Sep 4, 1999 · N9740X · Substantial damageNTSB MIA99FA245Accident · 8 fatalField investigationFinal reportBeech B-90 · West Palm Beach, FLa total loss of engine power due to fuel exhaustion. Contributing factors in this accident were the pilot's operation of the airplane in an overweight condition, inadequate pre-flight and in-flight planning.Sep 3, 1999 · N338AS · DestroyedNTSB CHI99LA354Accident · No injuriesLimited investigationFinal reportCessna 150L · Midland, MIthe student pilot's failure to maintain control of the airplane during an attempted go-around.Sep 2, 1999 · N1316Q · Substantial damageNTSB FTW99LA243Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Jonesboro, ARThe pilot's misjudgment of distance/altitude during the final approach to landing, resulting in an undershoot, and collision with a power line pole.Aug 30, 1999 · N3255Y · Substantial damageNTSB LAX99LA289Accident · Minor injuriesLimited investigationFinal reportCessna P210N · North Las Vegas, NVThe pilot's improper procedure in that he failed to follow the flight manual, resulting in a loss of engine power and subsequent collision with the ground.Aug 29, 1999 · N40RP · Substantial damageNTSB FTW99LA238Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 103C · San Antonio, TXThe pilot's failure to attain proper runway alignment of the glider resulting in failure to maintain obstacle clearance. A factor was the high density altitude.Aug 28, 1999 · N103MS · Substantial damageNTSB DEN99LA155Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-4 (AT-6) · Mack, COThe pilot misjudging his distance and altitude from the runway. A factor was the tall crops.Aug 28, 1999 · N7011C · Substantial damageNTSB LAX99LA282Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Kahului, HIThe pilot's initial misjudgment of the wind speed and his decision to continue a downwind landing approach when his speed and altitude profile was inadequate, and his failure to maintain main rotor rpm, resulting in settling with power and a hard landing.Aug 24, 1999 · N6094S · Substantial damageNTSB SEA99FA146Accident · 2 fatalField investigationFinal reportRepublic RC-3 · Chimacum, WAThe inadequate visual lookout by both the pilot-in-command and second pilot, and the pilot-in-command's failure to maintain sufficient flying speed to prevent a stall condition. Contributing factors were the transmission lines, gusty wind conditions, and the…Aug 23, 1999 · N6070K · DestroyedNTSB FTW99FA235Accident · 1 fatalField investigationFinal reportBeech D-35 · Seminole, OKThe loss of engine power caused by oil starvation, which resulted in the failure of the #6 cylinder connecting rod bolts. A factor was the pilot's performance of an evasive maneuver to avoid impacting buildings, trees, people on the ground, and power lines.Aug 23, 1999 · N2934B · DestroyedNTSB MIA99FA232Accident · 1 fatalField investigationFinal reportBeech C24R · Pickens, SCThe pilot's failure to properly preflight plan and prepare for the flight's fuel consumption resulting in engine loss of power due to fuel exhaustion and the subsequent inflight collision with trees.Aug 22, 1999 · N67198 · Substantial damageNTSB FTW99LA231Accident · Minor injuriesLimited investigationFinal reportAlon A-2A · Cabot, ARThe missing engine oil filler cap which resulted in the loss of engine power as a result of oil starvation. Factors were the pilot's improper aircraft preflight inspection and the lack of suitable terrain for the forced landing.Aug 22, 1999 · N5465F · Substantial damageNTSB LAX99FA275Accident · 2 fatalField investigationFinal reportMooney M20E · Las Vegas, NVThe pilot's steep turn at low altitude that resulted in an accelerated stall while in the landing configuration, leading to a loss of control and subsequent ground impact.Aug 20, 1999 · N2654W · Substantial damageNTSB NYC99LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, NJA loss of engine power for undetermined reason(s).Aug 16, 1999 · N2721R · Substantial damageNTSB FTW99LA219Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5A · Wayton, ARThe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance with trees during a go-around. Factors were the gusty wind condition, and the high density altitude. Factors associated with the accident were gusty winds, and a…Aug 12, 1999 · N9775U · Substantial damageNTSB DEN99LA149Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402A · Mead, COThe pilot's failure to follow proper approach to landing procedures as outlined in the Airplane Flight Manual. A factor was the 6-foot tall corn stalks.Aug 11, 1999 · N402RE · Substantial damageNTSB DEN99LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTAn inadvertent collision with a bird.Aug 10, 1999 · N89186 · Substantial damageNTSB MIA99LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greenville, SCThe improper position of the fuel selector by the pilot-in-command resulting in the loss of engine power due to fuel starvation. Also, the inadequate altitude flown by the pilot on final approach preventing a landing on the runway following the loss of engine…Aug 8, 1999 · N82974 · Substantial damage