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 FTW97FA299Accident · 2 fatalField investigationFinal reportBeech 58P · Colorado Spring, COfailure of the pilot to follow IFR procedures; and his failure to maintain proper altitude, while executing a missed approach from an attempted ILS approach. Related factors included: low ceiling, rain, fog, the pilot's overconfidence in his personal ability,…Aug 5, 1997 · N258W · DestroyedNTSB NYC97LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Ashland, OHThe pilot's improper fuel management which resulted in fuel exhaustion and loss of engine power.Aug 4, 1997 · N33341 · Substantial damageNTSB CHI97FA252Accident · 2 fatalField investigationFinal reportBeech 76 · New Richmond, WIThe certified flight instructor's inadequate supervision and delayed remedial action and the flight crew's lack of aircraft control. A factor was loss of control while maneuvering downwind by one of the pilot's.Aug 4, 1997 · N18960 · DestroyedNTSB SEA97FA181Accident · 1 fatalField investigationFinal reportAvian Magnum IX · Donald, ORThe pilot's failure to maintain clearance from a tree that was located on the edge of the field in which he was attempting to land.Aug 3, 1997 · N20146 · Substantial damageNTSB FTW97LA301Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Terlingua, TXThe inadvertent stall by the pilot-in-command. A factor was the sudden wind shift.Aug 2, 1997 · N2146W · Substantial damageNTSB LAX97LA269Accident · Serious injuriesLimited investigationFinal reportMitteer Mini 500 · Agua Dulce, CAfailure of the owner/builder to obtain and comply with service literature from the kit manufacturer, which resulted in improper setting of the carburetor fuel mixture and led to loss of engine power. An additional cause was the pilot's failure to successfully…Aug 1, 1997 · N501GM · Substantial damageNTSB CHI97LA230Accident · Minor injuriesLimited investigationFinal reportJenkins RV-6 · Middleton, WIthe pilot was too low on final approach and hit the high vegetation.Jul 28, 1997 · N126JM · Substantial damageNTSB CHI97LA227Accident · Minor injuriesLimited investigationFinal reportKearns RV-6 · Harrisburg, ILThe pilot's failure to maintain adequate clearance. A factor was the marked transmission wire.Jul 27, 1997 · N35K · Substantial damageNTSB ANC97LA109Accident · No injuriesLimited investigationFinal reportCessna 208 · Naknek, AKThe pilots decision to continue the landing into adverse weather conditions and failure to maintain runway alignmet. A factor was the rain shower which resulted in reduced forward visibility.Jul 22, 1997 · N9481F · Substantial damageNTSB CHI97LA215Accident · No injuriesLimited investigationFinal reportCessna 182 · Chippewa Falls, WIthe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.Jul 20, 1997 · N5820B · Substantial damageNTSB FTW97LA272Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Chickasha, OKthe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.Jul 19, 1997 · N1878D · Substantial damageNTSB SEA97LA162Accident · Minor injuriesLimited investigationFinal reportCessna 320E · W. Yellowstone, MTThe pilot's failure to maintain directional control during landing when asymmetric power was applied. A factor was the crosswind conditions.Jul 18, 1997 · N3425Q · Substantial damageNTSB LAX97FA253Accident · 2 fatalField investigationFinal reportMooney M20J · Placerville, CAA loss of engine power for undetermined reasons.Jul 18, 1997 · N405LA · DestroyedNTSB LAX97IA243Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Ontario, CAa laser light source of undetermined origin directed toward the cockpit window of an aircraft in-flight by a person or persons unknown.Jul 15, 1997 · N956UA · No damageNTSB LAX97FA241Accident · 3 fatalField investigationFinal reportCessna TR182 · Panamint Spring, CAfailure of the pilot to attain a proper touchdown point for landing, and his delay in initiating a go-around. Factors relating to the accident were: the pilot's attempt to land at the wrong airport, uphill slope of the runway, high density altitude, and…Jul 15, 1997 · N757CF · DestroyedNTSB SEA97LA168Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Idaho Falls, IDThe pilot mismanaged his fuel supply which led to fuel exhaustion and subsequent loss of engine power. Factors contributing to the accident were the lack of adequate altitude and airspeed to successfully execute an autorotation.Jul 14, 1997 · N8494E · Substantial damageNTSB ATL97LA103Accident · No injuriesLimited investigationFinal reportHughes 269C · Johnston, SCfailure of the pilot to maintain the proper rotor RPM during the approach and flare for landing.Jul 13, 1997 · N7413F · Substantial damageNTSB CHI97IA212Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-15 · Memphis, TNthe spoiler cable was misrouted by unknown maintenance personnel.Jul 12, 1997 · N9348 · No damageNTSB SEA97LA165Accident · No injuriesLimited investigationFinal reportYoung Turbo Cruiser · Milford, UTLoss of engine power due to fuel starvation. Factors include the pilot's fuel consumption calculations based upon insufficient or erroneous information provided by the amateur-built airplane's builder and previous owner, and terrain conditions not suitable…Jul 9, 1997 · N6626W · Substantial damageNTSB NYC97LA136Accident · No injuriesLimited investigationFinal reportCessna 172P · Wildwood, NJThe pilot's inadequate use of carburetor heat, which resulted in carburetor icing.Jul 6, 1997 · N97011 · Substantial damageNTSB NYC97LA135Accident · No injuriesLimited investigationFinal reportCessna 182B · Medford, NJAn inflight engine fire of undetermined origin.Jul 6, 1997 · N166KM · DestroyedNTSB CHI97TA198Accident · Minor injuriesFinal reportCessna 182R · Peoria, ILthe pilot's improper use of carburetor heat and the carburetor icing conditions which existed at the time of the accident. Factors were the ditch and poles which the airplane contacted.Jul 6, 1997 · N661SP · Substantial damageNTSB MIA97LA205Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Mooresville, NCThe pilot's failure to obtain the proper touchdown point on landing resulting in a go-around, and a subsequent in-flight collision with trees and terrain.Jul 5, 1997 · N7636S · Substantial damageNTSB IAD97LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, NHThe pilot's poor judgement for intentionally shutting down an engine to perform a practice single engine landing, which led to a single engine go-around due to conflicting traffic.Jul 5, 1997 · N4022P · Substantial damageNTSB FTW97FA249Accident · 1 fatalField investigationFinal reportSchempp-Hirth VENTUS-2B · Hobbs, NMThe pilot's failure to select an off-field landing site with sufficient time/altitude to perform the landing which led to his failure to maintain airspeed. A factor was the unfavorable wind.Jul 5, 1997 · N80077 · DestroyedNTSB NYC97LA134Accident · Minor injuriesLimited investigationFinal reportMartin Velocity RG · Montauk, NYThe pilot's failure to maintain directional control and his inadequate compensation for wind conditions.Jul 4, 1997 · N280DM · Substantial damageNTSB LAX97LA238Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Prescott, AZThe pilot's improper placement of the unmarked fuel selector valve to off which resulted in fuel starvation. A factor in the accident was the pilot's lack of total experience in this model aircraft.Jul 4, 1997 · N70EC · Substantial damageNTSB CHI97LA201Accident · Serious injuriesLimited investigationFinal reportWeber RV-4 · Hermann, MOthe pilot's inadequate in-flight planning/decision and encounter with a stall. Related factors were the chafed throttle cable, which became jammed; and failure of the pilot to perform an engine shut down in order to land on the runway.Jul 4, 1997 · N1142J · Substantial damageNTSB ANC97FA097Accident · 4 fatalField investigationFinal reportPiper PA-32 · Skagway, AKjamming/failure of the left magneto impulse coupling, which stopped rotation of the magneto gear, and resulted in subsequent shearing of the accessory intermediate idler gear. Factors relating to the accident were: the lack of suitable terrain for a forced…Jul 4, 1997 · N15199 · DestroyedNTSB MIA97LA203Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Bay St. Louis, MSThe pilot's improper short field landing procedure and use of full flaps prior to being assured of reaching the proper touchdown point, resulting in an in-flight collision with an embankment, and subsequent nose over. Contributing to the accident was a total…Jul 2, 1997 · N5054R · Substantial damageNTSB MIA97LA200Accident · No injuriesLimited investigationFinal reportCessna 150F · Clearwater, FLthe student pilot's inadequate compensation for wind conditions during an attempted go-around, which resulted in an on-ground loss of control and subsequent collision with trees and a ditch. The crosswind, trees, and ditch were related factors.Jul 2, 1997 · N8083S · Substantial damageNTSB NYC97LA133Accident · No injuriesLimited investigationFinal reportBeech C24R · Old Bridge, NJLoss of engine power for undetermined reasons.Jul 1, 1997 · N5156M · Substantial damageNTSB ATL97LA094Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180C · Dyersburg, TNthe pilot's improper planning/decision and failure to insure the that airplane would remain clear of trees during the go-around. Factors relating to the accident included: the high temperature, high density altitude, and the proximity of trees.Jul 1, 1997 · N71VF · Substantial damageNTSB LAX97LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Rimrock, AZFuel starvation due to the pilot's failure to monitor the fuel level in the right tank, and to select a tank containing fuel during the approach and landing in accordance with the checklist.Jun 29, 1997 · N5158U · Substantial damageNTSB ATL97FA090Accident · 1 fatalField investigationFinal reportBeech 35-C33A · Lugoff, SCimproper fuel management by the pilot by not positioning the fuel selector to the fullest tank for landing, which resulted in fuel starvation, loss of engine power, and a forced landing. Trees in the emergency landing area were a factor.Jun 28, 1997 · N4863J · Substantial damageNTSB ANC97TA095Accident · No injuriesFinal reportPiper PA-18-180 · Tok, AKThe second pilot/dual student's failure to maintain a proper glidepath, and the pilot-in-command/flight instructor's inadequate supervision. A factor associated with the accident was a downdraft.Jun 27, 1997 · N3685Z · Substantial damageNTSB CHI97FA188Accident · Serious injuriesField investigationFinal reportCessna 172N · Canton, MIA loss of engine power due to fuel starvation from a binding throttle/power lever cable. Also causal was the improper maintenance, installation of the throttle arm. Contributing to the accident were the dark night and unsuitable terrain for the forced landing.Jun 26, 1997 · N7031Q · Substantial damageNTSB CHI97LA175Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Wamego, KSinaccurate preflight planning which resulted in an inadequate fuel supply for the flight and ultimately fuel exhaustion. Factors associated with the accident were the powerlines and the parachutists over the runway.Jun 21, 1997 · N6535R · Substantial damageNTSB SEA97LA145Accident · Minor injuriesLimited investigationFinal reportRoss/Stonecipher Vans RV-6 · Woods Cross, UTa bird strike, which penetrated the aircraft canopy. High grass (hay crop) in the forced landing area was a related factor.Jun 20, 1997 · N345JE · Substantial damageNTSB LAX97LA218Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The unapproved field modification of the cyclic trim switch, including the use of non-standard parts, which resulted in a hard-over lateral trim failure, and the pilot's subsequent failure to maintain control of the helicopter during a landing approach. A…Jun 20, 1997 · N4250N · DestroyedNTSB NYC97IA123Incident · No injuriesIncident investigationFinal reportBeech 1900D · Clarksburg, WVThe right outboard flap detaching from the flap aft roller bearings, at the flap track, which was a result of the manufacturer's inadequate inspection program.Jun 19, 1997 · N165YV · Minor damageNTSB CHI97LA172Accident · No injuriesLimited investigationFinal reportCessna 150K · Ypsilanti, MIthe pilot's failure to use carburetor heat, which resulted in carburetor ice, loss of engine power, and a forced landing. Factors relating to this accident were: the icing (weather) condition and sign(s) in the emergency landing area.Jun 19, 1997 · N5738G · Substantial damageNTSB CHI97LA171Accident · Serious injuriesLimited investigationFinal reportRoe-Wayne Mustang II · Portage, MIinadequate fuel system design by the owner/builder, which led to fuel starvation as the airplane was on a 'flat' approach to land. The pilot's inadequate flight planning was a factor, in that he did not fly the traffic pattern of this first test flight, in a…Jun 18, 1997 · N11WJ · DestroyedNTSB LAX97LA215Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Nimbus 3/24.5 · Macdoel, CAthe pilot's failure to see and avoid a set of power lines while making an off-airport landing due to a lack of lift.Jun 17, 1997 · N4427M · Substantial damageNTSB LAX97LA214Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Jean, NVThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's failure to retract the flaps during the go-around.Jun 16, 1997 · N22406 · DestroyedNTSB MIA97LA184Accident · No injuriesLimited investigationFinal reportCessna 150G · Greer, SCthe student pilot's improper management of fuel, which resulted in fuel exhaustion, loss of engine power, and subsequent collision with trees and terrain.Jun 15, 1997 · N2276J · Substantial damageNTSB LAX97LA211Accident · Serious injuriesLimited investigationFinal reportMaule M-4-220C · Gualala, CAcontinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude/clearance from tall trees. The weather conditions (low ceiling and fog) were related factors.Jun 14, 1997 · N40654 · DestroyedNTSB NYC97LA119Accident · Minor injuriesLimited investigationFinal reportEnstrom F-280C · Sharon, VTThe pilot's improper decision to descend and fly at 100 feet over a river and his failure to maintain adequate obstacle clearance, which resulted in the in-flight collision with wires.Jun 13, 1997 · N5700J · Substantial damageNTSB FTW97LA224Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Little Rock, ARa loss of engine power due to fuel starvation from a partially blocked fuel line which was the result of improper maintenance by unknown person(s). A factor was the lack of suitable terrain for landing.Jun 13, 1997 · N898LF · Substantial damageNTSB SEA97FA130Accident · 1 fatalField investigationFinal reportLockheed P-38L · Tillamook, ORfailure of the pilot to maintain minimum control speed (VMC), after loss of power in one engine, which resulted in a loss of aircraft control and collision with terrain. Related factors were: the pilot's improper fuel management and failure to change the fuel…Jun 7, 1997 · N7973 · Destroyed