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 CHI94FA089Accident · 5 fatalField investigationFinal reportBeech A36 · Grain Valley, MOThe instrument rated private pilot's inadvertent stall while circling to land. The weather was a factor.Feb 20, 1994 · N58325 · DestroyedNTSB ATL94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Smithfield, NCThe pilot's failure to maintain adequate clearance from power lines. Factors were the unmarked power lines located under the final approach path, and the sun glare that existed at the time of the accident.Feb 19, 1994 · N2964M · Substantial damageNTSB CHI94DCA01Accident · 1 fatalFinal reportPiper PA-39 · Viburnum, MOThe pilot's failure to maintain adequate airspeed during the turn to final. The gusty tailwind during the turn was a contributing factor.Feb 18, 1994 · N8913Y · DestroyedNTSB MIA94GA072Accident · Minor injuriesFinal reportRobinson R-22B · Pompano Beach, FLFailure of the pilot-in-command to use carburetor heat during a poweroff autorotation, resulting in the engine not responding to throttle input during recovery due to carburetor ice buildup.Feb 14, 1994 · N591PD · Substantial damageNTSB LAX94LA124Accident · No injuriesLimited investigationFinal reportSchweizer 2-33-A · Dillingham, HIthe pilot's failure to maintain an adequate airspeed margin while maneuvering in the traffic pattern and his inadvertent entry into a stall/mush condition.Feb 13, 1994 · N3622Z · Substantial damageNTSB CHI94LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Eden Prairie, MNThe pilot's poorly planned approach and remaining below a proper glide path during final approach. The pilot's lack of total expereince was a factor.Feb 13, 1994 · N23797 · DestroyedNTSB ATL94IA048Incident · Minor injuriesIncident investigationFinal reportBoeing DHC-8-102 · Charlotte, NCAn inflight encounter with turbulence, and the flight attendant's failure to fasten her seatbelt.Feb 11, 1994 · N882CC · No damageNTSB MIA94FA069Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Vicksburg, MSFailure of the pilot-in-command to maintain the proper glidepath while on a straight in approach resulting in the inflight collision with trees short of the runway. Contributing to the accident was the dark night condition.Feb 9, 1994 · N1645H · Substantial damageNTSB CHI94FA080Accident · 1 fatalField investigationFinal reportCessna 320F · Goshen, INthe pilot-in-command's continued operation with known deficiencies in equipment. Factors were ice on the windshield and the pilot-in-commands visual outlook not possible.Feb 9, 1994 · N618X · Substantial damageNTSB ANC94LA031Accident · No injuriesLimited investigationFinal reportCessna 207 · Kwigillingok, AKThe pilot-in-command's failure to maintain the proper airspeed which resulted in an inadvertent stall and his failure to initiate a go-around when the runway environment was not clearly defined. A factor in the accident was the fog.Feb 8, 1994 · N6470H · Substantial damageNTSB CHI94LA079Accident · Serious injuriesLimited investigationFinal reportRoberts RV-6A · Richland, MOLoss of engine power (during flight) for an undetermined reason, after the pilot experienced loss of engine power before takeoff for an unknown reason.Feb 6, 1994 · N63JR · Substantial damageNTSB CHI94FA076Accident · 2 fatalField investigationFinal reportBeech 95 · Chesterfield, MOincorrect installation of the fuel selector valves during mandatory service bulletin modification which resulted in fuel starvation to both engines and failure of the pilot-in-command to maintain aircraft control during emergency descent. A factor was…Feb 6, 1994 · N9903R · DestroyedNTSB FTW94LA079Accident · Minor injuriesLimited investigationFinal reportCessna T210H · Mcallen, TXThe pilot's inadvertent stall of the airplane. Factors were the pilot's failure to refuel and the resultant fuel exhaustion.Feb 3, 1994 · N6914R · DestroyedNTSB CHI94LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Burlington, WIThe student pilot's failure to maintain the proper glideslope.Feb 2, 1994 · N5094S · Substantial damageNTSB CHI94LA075Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Chesterfield, MOThe pilot-in-command's poorly planned approach. A factor in the accident was the loss of engine power for an undetermined reason.Jan 31, 1994 · N810BP · Substantial damageNTSB MIA94LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Leesburg, FLThe pilot-in-command's poor evaluation of the weather and failure to remain in visual meteorological conditions, resulting in an in-flight collision with water.Jan 29, 1994 · N599LG · Substantial damageNTSB CHI94LA073Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Olathe, KSthe pilot's failure to follow procedures and directives regarding the positioning of the fuel tank selector to the fullest tank for the landing portion of flight.Jan 27, 1994 · N1215M · Substantial damageNTSB FTW94LA075Accident · Serious injuriesLimited investigationFinal reportCessna T-210J · Hobart, OKThe pilot's continued VFR flight into IMC. Factors were the weather, the pilot's failure to obtain a weather briefing for the flight, and the dark night conditions.Jan 26, 1994 · N2298R · Substantial damageNTSB MIA94IA059Incident · No injuriesIncident investigationFinal reportLearjet LR-35A · Key Largo, FLThe failure of the pilot-in-command to maintain the proper glidepath.Jan 24, 1994 · N30HJ · Minor damageNTSB FTW94LA068Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Dallas, TXThe pilot's failure to attain the proper touchdown point. A factor was the pilot's disorientation and dark night conditions.Jan 20, 1994 · N123AH · Substantial damageNTSB MIA94LA055Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Zellwood, FLInadvertent stall/spin by the pilot-in-command while executing a spiral to landing maneuver during the base to final turn.Jan 16, 1994 · N59528 · Substantial damageNTSB NYC94LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Monticello, NYThe pilot allowed the speed of the airplane to get too slow, resulting in an inadvertent stall at too low an altitude to allow recovery.Jan 10, 1994 · N3999Z · Substantial damageNTSB DCA94MA027Accident · 5 fatalClass 1 · MajorFinal reportJetstream 4101 · Columbus, OH(1) An aerodynamic stall that occurred when the flightcrew allowed the airspeed to decay to stall speed following a very poorly planned and executed approach characterized by an absence of procedural discipline; (2) Improper pilot response to the stall…Jan 8, 1994 · N304UE · DestroyedNTSB FTW94FA060Accident · 5 fatalField investigationFinal reportPalmer Hawk BM-4 · Pearland, TXInadequate visual lookout by the pilot of the hawk BM-4, which resulted in his failure to see-and-avoid the Cessna 172. The BM-4 pilot's non-standard procedure for entering the traffic pattern was a related factor.Jan 2, 1994 · N75DL · 2 aircraft · DestroyedNTSB MIA94FA044Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Destin, FLAirspeed not maintained, inadvertent stall/mush, and altitude inadequate for recovery from the inflight loss of control by the pilot-in-command while circling for landing.Jan 1, 1994 · N243KW · Substantial damageNTSB FTW94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mckinney, TXThe pilot's improper approach angle.Jan 1, 1994 · N44015 · Substantial damageNTSB LAX94LA079Accident · 1 fatalLimited investigationFinal reportAero Commander 100 · Chico, CAIssuance of an improper (special VFR) clearance by the tower controller, while the visibility was less than one mile, continued VFR flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain control of the…Dec 25, 1993 · N4042X · DestroyedNTSB ATL94LA031Accident · 2 fatalLimited investigationFinal reportCarson Piel Emeraude CP305 · Morrison, TNThe pilot's inadvertent flight into instrument meteorological conditions (IMC), and failure to maintain aircraft control after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and the pilot's improper…Dec 25, 1993 · N447TB · DestroyedNTSB LAX94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain a proper glidepath.Dec 24, 1993 · N2501X · Substantial damageNTSB CHI94LA059Accident · No injuriesLimited investigationFinal reportBeech C23 · Eden Prairie, MNan inadequate preflight by both the CFI and student pilot. Factors contributing to the accident was poor communications between the CFI and student pilot, and hilly terrain.Dec 23, 1993 · N9228S · Substantial damageNTSB CHI94LA058Accident · Serious injuriesLimited investigationFinal reportMooney M-20E · Chesterfield, MOthe pilot's failure to assure an adequate fuel supply for the planned flight. Factors associated with the accident were the trees, unreliable fuel gauges and the pilot's decision to operate the airplane with the known unreliable fuel gauges.Dec 23, 1993 · N1249X · DestroyedNTSB ANC94LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKThe pilot-in-command not maintaining the proper clearance from the terrain during the approach.Dec 23, 1993 · N7121P · Substantial damageNTSB CHI94LA052Accident · No injuriesLimited investigationFinal reportCessna 404 · Big Rapids, MIThe pilot's descent below the minimum descent altitude.Dec 17, 1993 · N8919G · Substantial damageNTSB LAX94FA073Accident · 5 fatalField investigationFinal reportIsrael Aircraft Industries 1124A · Santa Ana, CAThe pilot-in-command's failure to maintain adequate separation behind the Boeing 757 and/or remain above its flight path during the approach, which resulted in an encounter with wake vortices from the 757. Factors related to the accident were: an inadequacy…Dec 16, 1993 · N309CK · DestroyedNTSB SEA94FA040Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Spokane, WAThe pilot's failure to maintain proper alignment with the instrument landing system approach course. The pilot's failure to perform a missed approach was a factor.Dec 15, 1993 · N999VP · DestroyedNTSB CHI94FA050Accident · 3 fatalField investigationFinal reportMitsubishi MU-300 · Goodland, KSThe pilot-in-command's inadvertent stall of the airplane. A factor associated with the accident is the pilot-in-command's poor IFR procedures.Dec 15, 1993 · N710MB · DestroyedNTSB CHI94FA048Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Antigo, WIthe failure of the pilot in command to maintain proper altitude.Dec 10, 1993 · N550BC · Substantial damageNTSB ATL94FA028Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Lagrange, GAWas the pilot's failure to correct a known low battery condition before departing, which resulted in a loss of electrical power during an instrument approach. Factors were the dark night and the low scattered cloud layer.Dec 10, 1993 · N4195B · DestroyedNTSB ANC94LA025Accident · Serious injuriesLimited investigationFinal reportAeronca BL-7AC · Circle City, AKThe pilot in commands intentional flight into known adverse weather conditions which lead to an inadvertent aerodynamic stall of the aircraft. Factors contributing to the accident were the ice fog and the icing conditions.Dec 9, 1993 · N84903 · Substantial damageNTSB FTW94IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-33A · Dfw Airport, TXA failure by the pilot-in-command to attain a stabilzed approach. Factors were the fog and failure of the copilot to monitor the approach.Dec 8, 1993 · N166AW · Minor damageNTSB NYC94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lumberton, NJThe pilot's failure to maintain a proper glidepath due to improper compensation for the wind conditions. A factor was a crosswind.Dec 7, 1993 · N4920J · Substantial damageNTSB ANC94LA023Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Northway, AKThe pilot-in-command did not maintain the proper glidepath.Dec 7, 1993 · N29532 · Substantial damageNTSB CHI94LA045Accident · Serious injuriesLimited investigationFinal reportCessna 210B · Dubuque, IAFlight by the pilot into known icing conditions, which resulted in airframe icing and an inability of the aircraft to maintain altitude on the ILS glidepath, once the landing gear was lowered. The weather conditions were related factors.Dec 6, 1993 · N9684X · Substantial damageNTSB NYC94FA033Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · New Haven, CTThe pilot's failure to maintain control of the airplane during a night approach in adverse weather conditions. Factors which contributed to the accident were the weather conditions and dark night. In addition, the radar controller's vectoring of the pilot to…Dec 4, 1993 · N1488X · DestroyedNTSB NYC94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Hopkinsville, KYthe pilot's improper IFR procedure by conducting flight below minimum descent altitude (MDA) without visual referece which resulted in an inflight collision with wires. A factor was the wire.Dec 3, 1993 · N39595 · Substantial damageNTSB FTW94LA043Accident · Minor injuriesLimited investigationFinal reportBell 412 · Cameron, LAThe copilot's continued flight into adverse weather conditions, and the captain's inadequate supervision. The haze and fog were factors.Dec 3, 1993 · N356EH · DestroyedNTSB ANC94LA021Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Napakiak, AKThe pilot-in-command's failure to maintain proper approach airspeed.Dec 3, 1993 · N38393 · Substantial damageNTSB MIA94LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Punta Gorda, FLThe pilot-in-command's improper use of carburetor heat during a VFR approach for landing. This resulted in a loss of engine power due to fuel system carburetor icing.Dec 2, 1993 · N6053K · Substantial damageNTSB DCA94MA022Accident · 18 fatalClass 1 · MajorFinal reportJetstream BA-3100 · Hibbing, MNThe captain's actions that led to a breakdown in crew coordination and the loss of altitude awareness by the flightcrew during an unstabilized approach in night instrument meteorological conditions. Contributing to the accident were: the failure of the…Dec 2, 1993 · N334PX · DestroyedNTSB LAX94LA061Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Panoche, CAthe pilot's improper approach speed and glide path, and his delayed initiation of a go-around. A factor in the accident was the wind shear condition created by the hills immediately off the departure end of the dirt airstrip.Nov 28, 1993 · N65922 · Substantial damage