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 LAX92LA366Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Fresno, CAThe loss of engine power due to carburetor icing and the failure of the pilot to use carburetor heat.Aug 27, 1992 · N3015S · Substantial damageNTSB CHI92FA254Accident · 1 fatalField investigationFinal reportCessna 172N · Marquette, MIThe pilot's failure to maintain proper altitude during the approach.Aug 25, 1992 · N738HM · DestroyedNTSB ATL92LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greensboro, NCThe failure of the pilot in command to maintain control of the airplane, and his improper use of the rudder during a go-around.Aug 25, 1992 · N9749W · Substantial damageNTSB SEA92LA189Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Concrete, WAThe loss of engine power due to fuel exhaustion, resulting from the IMPR0PER in-flight planning by the pilot in command and his failure to select a proper touchdown point for an emergency forced landing. A factor relating to the accident was the uneven…Aug 24, 1992 · N37667 · Substantial damageNTSB NYC92LA169Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Put-In-Bay, OHThe pilot's improper use of carburetor heat, resulting in a loss of engine power and subsequent forced landing in trees.Aug 19, 1992 · N18176 · Substantial damageNTSB LAX92LA355Accident · No injuriesLimited investigationFinal reportCessna T210L · Fallbrook, CAFuel exhaustion due to the failure of the pilot to refuel the aircraft prior to departure.Aug 18, 1992 · N60856 · Substantial damageNTSB LAX92LA352Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Flugzeugbau · Truckee, CAThe pilot's poorly planned approach. Lack of supervision in the type of aircraft was a factor.Aug 17, 1992 · N3872H · Substantial damageNTSB CHI92LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Owosso, MIFuel starvation which resulted from the pilot having selected the wrong fuel tank. Factors related to the accident were poor aircraft preflight and the unreliable fuel quantity gauges.Aug 15, 1992 · N5749P · Substantial damageNTSB CHI92LA241Accident · Serious injuriesLimited investigationFinal reportBeech A36TC · Valentine, NEThe pilot's failure to maintain adequate airspeed. Factors related to the accident were the weather obscuration and failure to attain proper runway alignment.Aug 14, 1992 · N1812E · DestroyedNTSB ANC92LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Talkeetna, AKThe pilot's improper in flight planning/decision, and his premature touch down. Contributing to the accident were the downdraft and the unsuitable terrain.Aug 14, 1992 · N3042M · Substantial damageNTSB CHI92LA238Accident · No injuriesLimited investigationFinal reportBeech A36 · Ann Arbor, MIFuel starvation for undetermined reasons. Factors related to the accident were in blown fuse which rendered the boost pump inoperative and the rough terrain in which the emergency landing was made.Aug 11, 1992 · N377RB · Substantial damageNTSB NYC92LA154Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Keene, NHAn inadvertent stall during flap retraction, following an aborted landing.Aug 10, 1992 · N738FW · Substantial damageNTSB LAX92LA343Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 103 · Truckee, CAThe inadequate aircraft maintenance and flight manuals and unavailable information pertaining to the inspection of the spoiler system. Contributing to this accident was the worn and jammed spoiler attachment limiting block.Aug 10, 1992 · N103FB · Substantial damageNTSB ANC92LA123Accident · No injuriesLimited investigationFinal reportBeech C99 · Nuiqsut, AKThe pilot's improper inflight planning/preparation, and his failure to attain the proper touchdown point. Contributing to the accident was the downdraft.Aug 9, 1992 · N216CS · Substantial damageNTSB CHI92LA236Accident · Minor injuriesLimited investigationFinal reportRockwell 112TC · Winner, SDFailure of the carburetor mixture control, resulting in loss of engine power. A factor related to the accident was: lack of compliance with marvel-schebler service bulletin (sb) #A1-78.Aug 7, 1992 · N30MT · Substantial damageNTSB ATL92FA153Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Waynesboro, GAThe pilot misjudged his distance and altitude during final approach as a result of his alcoholic impairment of efficiency and judgement. A factor which contributed to the accident was the dark night.Aug 7, 1992 · N3058R · Substantial damageNTSB NYC92LA145Accident · Minor injuriesLimited investigationFinal reportJohn K. Groff JR. Q-2 · Caldwell, NJThe failure of the pilot to monitor his fuel supply which resulted in the power loss. A factor in the accident was unsuitable terrain.Aug 6, 1992 · N87JG · DestroyedNTSB CHI92LA237Accident · No injuriesLimited investigationFinal reportBeech C90 · Pontiac, MIThe pilot's not understanding the fuel system, and his subsequent inadvertent discontinuance of fuel to both engines.Aug 6, 1992 · N90RG · Substantial damageNTSB DEN92LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Littleton, COInadvertent stall during final approach to landing.Aug 5, 1992 · N4037E · Substantial damageNTSB MIA92FA158Accident · 4 fatalField investigationFinal reportCessna 172K · Rockledge, FLFailure of the pilot to maintain adequate airspeed during the final approach resulting in an inadvertent stall. Contributing to the accident was the pilot's lack of recent experience in the type operation, lack of experience at the airport in the type…Aug 2, 1992 · N1196M · DestroyedNTSB NYC92LA138Accident · No injuriesLimited investigationFinal reportBeech 58 · West Chester, PAAn encounter with windshear which resulted in the airplane landing hard and short of the runway. A factor related to the accident was the gusty wind conditions.Aug 1, 1992 · N38CL · Substantial damageNTSB NYC92FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Honesdale, PAA loss of control in flight due to pilot incapacitation as a result of a heart attack.Aug 1, 1992 · N56692 · DestroyedNTSB DEN92FA078Accident · 2 fatalField investigationFinal reportCessna 337A · Ruidoso, NMThe pilot experiencing spatial disorientation and the resultant excessive descent rate. Factors were: the dark night conditions.Aug 1, 1992 · N337LS · DestroyedNTSB CHI92DEC02Accident · 1 fatalFinal reportRans S-9 · Mason, MIThe pilot's over-confidence in his personal ability, his lack of experience in the type airplane he was flying, and the fact the pilot did not maintain a proper airspeed.Aug 1, 1992 · N5301A · DestroyedNTSB FTW92FA197Accident · 1 fatalField investigationFinal reportBoeing A75 · Cibolo, TXFailure of the engine crankshaft due fatigue and the resultant collapsing of the left wing.Jul 31, 1992 · N62552 · DestroyedNTSB SEA92LA169Accident · No injuriesLimited investigationFinal reportGreth Cirrus VK30 · Rawlins, WYThe pilot in command's failure to maintain control of the aircraft. Factors contributing to the accident were: crosswinds and gusts.Jul 29, 1992 · N303VK · Substantial damageNTSB FTW92LA193Accident · No injuriesLimited investigationFinal reportCessna 172F · Lubbock, TXThe pilot under instruction misjudged his distance and altitude during a simulated forced landing, and the CFI failed to take timely action to prevent the accident as a result of his alcoholic impairment of efficiency and judgement.Jul 29, 1992 · N5718R · Substantial damageNTSB ANC92LA127Accident · No injuriesLimited investigationFinal reportCessna 180 · Eureka, AKThe loss of engine power and undetermined reasons.Jul 28, 1992 · N3266D · Substantial damageNTSB MIA92LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26E · Ridgeland, SCThe pilot's inadequate inflight planning resulting in an encounter with a windshift on final approach.Jul 27, 1992 · N1139S · Substantial damageNTSB LAX92LA314Accident · No injuriesLimited investigationFinal reportJames Schwarzman Avid Flyer Heavy · Truckee, CAFuel starvation due to the aircraft builder locating the fuel filter in an improper location during the construction of the airplane's fuel system.Jul 26, 1992 · N771AF · DestroyedNTSB ATL92LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fairhope, ALThe pilot's failure to maintain flying speed during final approach which resulted in a stall and an uncontrolled collision with the ground short of the runway.Jul 26, 1992 · N2521Y · Substantial damageNTSB FTW92LA194Accident · No injuriesLimited investigationFinal reportCessna 172L · Ozona, TXThe pilot's failure to maintain obstacle clearance.Jul 25, 1992 · N9880G · Substantial damageNTSB SEA92LA162Accident · No injuriesLimited investigationFinal reportKaman HH-43F · Headquarters, IDFuel exhaustion and the pilot in command's delay in refueling.Jul 24, 1992 · N90944 · Substantial damageNTSB ATL92LA143Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Eufaula, ALThe failure of the fuel injector servo as a result of the sticking bushing between the diaphragms.Jul 23, 1992 · N6730N · Substantial damageNTSB LAX92LA312Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Las Vegas, NVThe failure of the maintenance personnel to safety the engine oil drain plug and the poor engine overhaul. Factors relating to this accident are: oil starvation; the failure of the connecting rods; the incorrect connecting rod bolts; and the connecting rod…Jul 22, 1992 · N3074F · Substantial damageNTSB LAX92FA313Accident · 3 fatalField investigationFinal reportBeech 23 · Fall River Mill, CAThe pilots decision to turn down wind at a critical phase of the go around with inadequate airspeed resulting in a stall mush uncontrolled descent. Contributing to the accident was the unfavorable wind conditions and a stabilator interference caused by a…Jul 22, 1992 · N2359J · DestroyedNTSB SEA92LA158Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Burley, IDFuel exhaustion when anticipated fuel consumption was not adequately calculated.Jul 21, 1992 · N4317P · Substantial damageNTSB DEN92IA074Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 RT · Denver, COOpen air ground circuit breakers that allowed the propellers to overspeed. A factor was: clear air turbulence.Jul 21, 1992 · N221YV · No damageNTSB LAX92LA309Accident · No injuriesLimited investigationFinal reportPiper PA32-301T · Van Nuys, CAAn on ground collision with terrain subsequent to an engine failure for undetermined reasons.Jul 20, 1992 · N83211 · Substantial damageNTSB BFO92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Norwalk, OHLoss of engine power due to undetermined reasons and the lack of suitable terrain for a forced landing.Jul 20, 1992 · N7727J · DestroyedNTSB MIA92LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Ft Walton Beach, FLThe pilot misjudged his altitude while turning on final approach over water to land at an airport.Jul 19, 1992 · N3292Z · Substantial damageNTSB BFO92LA104Accident · No injuriesLimited investigationFinal reportCessna 172K · Piqua, OHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.Jul 19, 1992 · N78483 · Substantial damageNTSB LAX92LA303Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Simi Valley, CAThe company's maintenace personnel improper adjustment of the aircraft's idle RPM and the failure of the instructor pilot to maintain adequate rotor RPM after the engine failed. The instructor pilot's lack of total experience in type of operation is a factor…Jul 18, 1992 · N280CA · Substantial damageNTSB SEA92LA156Accident · Minor injuriesLimited investigationFinal reportThomsen, Horst Rotorway "EXEC" · Quilcene, WAA misjudged descent rate, and delayed corrective action. Factors include a lack of experience in this type of aircraft, and a building near the landing area.Jul 16, 1992 · UNREG · Substantial damageNTSB FTW92IA184Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Oklahoma City, OKHydraulic fluid exhaustion due to the chafed 'a' system hydraulic line and the improper installation by unknown maintenance personnel of the 'b' system line.Jul 15, 1992 · N12235 · No damageNTSB MIA92LA148Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sanford, FLInadequate visual lookout by both pilots, which resulted in their failure to see-and-avoid of the power line. The proximity of the power line was a related factor.Jul 11, 1992 · N2135E · Substantial damageNTSB CHI92DEX02Accident · No injuriesFinal reportTownsend-Snyder Rultan Varieze · Indianapolis, INFuel starvation due to improper fuel tank selection.Jul 9, 1992 · N40TS · Substantial damageNTSB FTW92DRD04Accident · Minor injuriesFinal reportAir Tractor AT-502 · Mamou, LAThe pilot's failure to maintain proper clearance.Jul 8, 1992 · N7315L · Substantial damageNTSB DEN92IA072Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Lamar, COFractured nose landing gear bolt due to fatigue.Jul 8, 1992 · N3030K · Minor damageNTSB CHI92DCG03Accident · Minor injuriesFinal reportDaniel M. Dent BD-5 B · Ft. Levenworth, KSA complete loss of engine power following an electrical short to ground in the aircraft's 'ignition kill' electric circuit.Jul 8, 1992 · N583BD · Substantial damage