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 BFO93FA061Accident · 1 fatalField investigationFinal reportCessna A152 · Revere, PAThe CFI failed to adequately supervise the operation. Related factors were dark night, lost/disorientation of the pilot, and her lack of experience in type of operation (night flying).Mar 28, 1993 · N761XA · DestroyedNTSB BFO93LA062Accident · Minor injuriesLimited investigationFinal reportKibiuk Quickie · Durhamville, NYThe loose battery cable to the negative terminal, resulting in total power loss. A factor related to the accident was the lack of suitable terrain for an emergency landing.Mar 27, 1993 · N12726 · Substantial damageNTSB FTW93LA111Accident · No injuriesLimited investigationFinal reportCessna 182 · Washington, OKLoss of engine power for undetermined reason(s).Mar 26, 1993 · N5520B · DestroyedNTSB CHI93FA118Accident · 1 fatalField investigationFinal reportCessna 182N · Ludington, MIthe pilot's improper instrument procedures. Related factors are the below approach minima weather conditions, fog and dark night.Mar 26, 1993 · N8945G · DestroyedNTSB ATL93LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Knightdale, NCThe failure of the student pilot to maintain control of the aircraft.Mar 26, 1993 · N68276 · Substantial damageNTSB ANC93LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Mekoryuk, AKPilot-in-command initiated VFR flight into IMC conditions. A factor in this accident was the whiteout weather conditions.Mar 25, 1993 · N9102Y · Substantial damageNTSB DEN93LA035Accident · No injuriesLimited investigationFinal reportPitts S2B · Boulder, COThe pilot in command's failure to maintain a visual lookout. A factor was: the student pilot's restricted visual lookout.Mar 24, 1993 · N876CB · Substantial damageNTSB LAX93LA158Accident · Serious injuriesLimited investigationFinal reportBoeing A75L3 · Carlsbad, CAThe pilot's inadequate preflight preparation in that he failed to refuel the aircraft prior to departure.Mar 22, 1993 · N58969 · Substantial damageNTSB DEN93LA034Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Las Animas, COFailure by the pilot in command to maintain control of the aircraft. A factor was: wind gusts.Mar 21, 1993 · N4245R · Substantial damageNTSB FTW93LA109Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Plainview, TXThe pilot's the improper flare prior to touchdown. Factors were the fuel starvation power loss and improper positioning of the fuel selector.Mar 20, 1993 · N4045B · Substantial damageNTSB BFO93FA049Accident · Minor injuriesField investigationFinal reportBritish Aerospace BAE 3101 · Beckley, WVFailure of the captain to assure proper alignment with the plowed portion of the runway (or perform a missed approach). Factors related to the accident were: darkness, the adverse weather condition, inadequate removal of snow from the runway with snow along…Mar 18, 1993 · N159PC · Substantial damageNTSB FTW93LA106Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Mena, ARThe pilot's improper in-flight planning/decision. Factors related to the accident were: the adverse weather conditions, the pilot's improper use of carburetor heat, his improper IFR procedures, darkness, and the high (mountainous) terrain.Mar 16, 1993 · N4341P · Substantial damageNTSB DEN93FA032Accident · 2 fatalField investigationFinal reportBeech A36 · Englewood, COPower loss due to fuel exhaustion as a result of failing to refuel en route. Factors were: inaccurate fuel consumption calculations, lack of suitable terrain for a forced landing, lack of total experience in the type of aircraft being flown, and becoming lost…Mar 13, 1993 · N4495W · Substantial damageNTSB CHI93LA117Accident · No injuriesLimited investigationFinal reportCessna 150J · Hastings, NEThe pilot's failure to refuel the airplane en route which resulted in an inadequate fuel supply for the flight.Mar 13, 1993 · N50467 · Substantial damageNTSB FTW93LA102Accident · No injuriesLimited investigationFinal reportMistretta Challenger II · Albuquerque, NMThe pilot's failure to maintain control of the airplane. A factor was his possible encounter with turbulence.Mar 11, 1993 · N3207C · Substantial damageNTSB CHI93LA128Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Bismarck, NDThe pilot's failure to refuel the airplane en route to ensure adequate fuel to complete the flight.Mar 11, 1993 · N88384 · Substantial damageNTSB CHI93IA115Incident · No injuriesIncident investigationFinal reportde Havilland SHD-6 · Chicago, ILFailure of the approach and local controllers to maintain IFR separation standards between all the airplanes on the approach.Mar 7, 1993 · N364MQ · No damageNTSB BFO93LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Springboro, OHThe pilot misjudged his distance, and altitude on final approach, and failed to attain the proper touchdown point.Mar 7, 1993 · N2868Y · Substantial damageNTSB BFO93LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sandusky, OHThe pilot's misjudgement of distance and altitude to the runway, while on final approach, and his failure to attain the proper touchdown point for landing. A factor related to the accident was the proximity of the snowbank to the runway threshold.Mar 7, 1993 · CGAIC · Substantial damageNTSB MIA93LA080Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Marco, FLThe pilot-in-command's failure to ensure the aircraft contained adequate fuel for the flight, resulting in loss of engine power due to fuel exhaustion.Mar 5, 1993 · N29WW · Substantial damageNTSB BFO93LA048Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-7-102 · Philadelphia, PAAn encounter with turbulence during final approach. A factor related to the accident was that the flight attendant was not seated with a seat belt fastened.Mar 5, 1993 · N175RA · No damageNTSB DCA93IA027Incident · No injuriesIncident investigationFinal reportAerospatiale ATR42-300 · Newark, NJThe flightcrew's failure to follow approved procedures that required a minimum propeller spped while flying in icing condition. Contributing to the loss of roll control were the encounters with severe turbulence and icing conditions.Mar 4, 1993 · N99838 · No damageNTSB DEN93FA031Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Panama City, FLThe pilot's poorly planned approach to the runway following an instrument approach resulting in a loss of control.Mar 3, 1993 · N90399 · DestroyedNTSB FTW93FA092Accident · 2 fatalField investigationFinal reportCessna 340A · Center Point, TXInadvertent stall. Factors were the weather and the light conditionsFeb 28, 1993 · N88KH · DestroyedNTSB CHI93LA195Accident · No injuriesLimited investigationFinal reportCessna A150L · Blaine, MNThe failure of the pilot of the Cessna 150, N6059J, and the pilot of the challenger to see and avoid each other.Feb 28, 1993 · N6059J · 2 aircraft · Minor damageNTSB BFO93FA033Accident · 1 fatalField investigationFinal reportBeech E18S · Lemont, PAImproper inflight planning decision by the pilot, and his failure to maintain proper altitude during the approach. Factors related to the accident were darkness, adverse weather conditions, and high terrain.Feb 24, 1993 · N47E · DestroyedNTSB CHI93LA094Accident · No injuriesLimited investigationFinal reportBeech B90 · Albert Lea, MNAn inadvertent stall due to ice in the pitot/static system.Feb 23, 1993 · N442TC · Substantial damageNTSB BFO93LA032Accident · 1 fatalLimited investigationFinal reportMorgan Challenger II · Quinton, VAThe pilot's impairment due to a neurological injury and drugs, and his failure to maintain control of the airplane during an approach to land. A factor related to the accident was the gusty wind condition.Feb 22, 1993 · UNREG · DestroyedNTSB ATL93FA061Accident · 4 fatalField investigationFinal reportRobinson R22B · Atlanta, GAThe failure of the pilot/applicant of the R22B, N621SG, to follow low approach procedures, and the failure of the designated examiner/observer in the R22B to maintain visual separation from the Cessna 152, N5532Q. Contributing factors to the accident were:…Feb 19, 1993 · N621SG · 2 aircraft · DestroyedNTSB FTW93LA085Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19-3A · Graham, TXThe loss of engine power due to fuel starvation due to the improper position of the fuel tank selector. Factors were the pilot's failure to follow the checklist and the lack of suitable terrain for the forced landing.Feb 12, 1993 · N8876R · Substantial damageNTSB ATL93FA060Accident · Serious injuriesField investigationFinal reportCessna 337D · Nashville, TNThe pilot's failure to ensure an adequate fuel supply for the flight, which resulted in fuel exhaustion.Feb 10, 1993 · N861CP · DestroyedNTSB MIA93LA061Accident · No injuriesLimited investigationFinal reportHughes 269A · Jacksonville, FLThe failure of the pilot-in-command to monitor fuel quantity due to inattentiveness. Contributing to the accident was the improper use of the collective flight control during the soft field autorotation.Feb 4, 1993 · N711CH · Substantial damageNTSB CHI93LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Austin, MNThe pilot's failure to maintain altitude. The pilot's continued flight into IMC, diverted attention and the environmental conditions were factors.Feb 4, 1993 · N3658W · Substantial damageNTSB LAX93LA109Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Columbia, CAThe pilot's failure to maintain a proper glidepath while on short final approach. A factor in the accident was the dark night lighting conditions which may have affected the pilot's perceptual awareness of the airport environment and the cues for a proper…Feb 1, 1993 · N16SC · Substantial damageNTSB FTW93LA077Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Marfa, TXThe pilot's continued descent below the proper altitude. Factors were the dark night, fog, and the crew's poor coordination.Jan 30, 1993 · N363N · Substantial damageNTSB CHI93FA075Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Wichita, KSAn improper use of the flight controls by the pilot-in-command.Jan 25, 1993 · N444TD · DestroyedNTSB LAX93LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe pilots inadequate compensation for the existing wind conditions and his delay in executing a go around. A factor in the accident was the pilot's lack of total experience.Jan 24, 1993 · N737EA · Substantial damageNTSB LAX93LA101Accident · No injuriesLimited investigationFinal reportRobinson R22B · Palomar Mtn, CAThe student pilot's initial failure to maintain rotor RPM during the go around and the instructor's improper use of the flight controls and failure to adequately supervise the conduct of the flight.Jan 23, 1993 · N2335Q · Substantial damageNTSB FTW93LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · El Dorado, ARThe pilot's failure to maintain clearance. A factor was the dark night.Jan 23, 1993 · N7676C · Substantial damageNTSB NYC93LA054Accident · No injuriesLimited investigationFinal reportBeech A36 · Willoughby, OHThe pilot's failure to maintain the proper glide path during an instrument approach, and his improper remedial action, resulting in a collision with trees.Jan 22, 1993 · N2890A · Substantial damageNTSB LAX93LA099Accident · No injuriesLimited investigationFinal reportCessna 172L · Ramona, CAA loss of engine power related to inadequate and improper maintenance practices concerning the carburetor.Jan 22, 1993 · N7965G · Substantial damageNTSB CHI93LA073Accident · No injuriesLimited investigationFinal reportCessna 150 · Jeffersonville, INThe pilot's failure to maintain proper airspeed. The poorly planned approach was a factor.Jan 16, 1993 · N45563 · Substantial damageNTSB ATL93LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, NCThe pilot became lost and exhausted the airplane fuel supply.Jan 14, 1993 · N25865 · Substantial damageNTSB CHI93LA070Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Susank, KSThe pilot's continued flight into adverse weather and the owner's representation that the airplane met the requirements for flight into icing conditions. The weather and airframe ice were factors in the accident.Jan 12, 1993 · N712AC · Substantial damageNTSB CHI93LA066Accident · Minor injuriesLimited investigationFinal reportCessna 310R-II · Marysville, KSThe pilot's failure to maintain sufficient airspeed. Factors contributing to the accident were the icing conditions encountered, and the windshield & airframe ice.Jan 7, 1993 · N8016M · DestroyedNTSB MIA93LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Tampa, FLPoor in-flight planning/decision by the CFI resulting in the total loss of engine power from both engines due to fuel exhaustion.Jan 6, 1993 · N1439P · Substantial damageNTSB ANC93LA024Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Scammon Bay, AKThe pilots failure to follow VFR procedures. A factor was the whiteout snow condition.Jan 5, 1993 · N7373U · Substantial damageNTSB CHI93FA063Accident · 3 fatalField investigationFinal reportCessna T337G · Smiths Creek, MIThe pilot-in-command's failure to maintain control of the airplane during the approach. Factors which contributed to the accident were the adverse weather conditions and the dark night.Jan 4, 1993 · N1ZD · DestroyedNTSB SEA93FA048Accident · 4 fatalField investigationFinal reportBell 206B3 · Ogden, UTThe pilot's continuation of VFR flight into instrument meteorological conditions, and his decision to continue his landing attempts under the adverse weather conditions. Factors contributing to the accident were the low clouds, fog and mountainous terrain.Jan 3, 1993 · N1078V · DestroyedNTSB MIA93LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Titusville, FLLoss of engine power during the downwind leg for undetermined reasons, poor in-flight planning/decision by the dual student, and inadequate supervision by the pilot-in-command (CFI).Jan 1, 1993 · N82542 · Substantial damage