OpenAirDocs.org

NTSB investigations

20,559 cases where the phase of flight was Initial climb.

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 = 350)
  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 CHI93DER02Accident · No injuriesFinal reportMiller Quickie · Glencoe, MNThe disconnection of the ignition switch wiring.May 11, 1993 · N5589N · Substantial damageNTSB CHI93IA167Incident · No injuriesIncident investigationFinal reportCessna 550 · West Chicago, ILInadequate control tower service by the local air traffic controller by providing conflicting clearances to the pilots of two aircraft.May 10, 1993 · N41SM · No damageNTSB BFO93LA078Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Frederick, MDInadequate preflight by the pilot and fuel contamination, which resulted in loss of engine power.May 9, 1993 · N28681 · Substantial damageNTSB BFO93LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Towanda, PAThe failure of the aileron control cable which resulted in loss of control in flight.May 8, 1993 · N3914F · DestroyedNTSB ATL93LA089Accident · No injuriesLimited investigationFinal reportFairchild 24G · Athens, TNThe pilot's failure to use carburetor heat in weather conditions which were conducive to the formation of carburetor iceMay 8, 1993 · N16897 · Substantial damageNTSB LAX93LA207Accident · Serious injuriesLimited investigationFinal reportCassutt III M · Corona, CAthe pilot improper maintenance modification and total failure of the magneto.May 7, 1993 · N250P · DestroyedNTSB LAX93LA211Accident · No injuriesLimited investigationFinal reportCessna 140 · Ramona, CAA jammed control yoke.May 6, 1993 · N76194 · Substantial damageNTSB LAX93LA204Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Pixley, CAthe pilot's failure to maintain flying speed during the turn. The inadvertent stall was a factor in this accident.May 6, 1993 · N4749Y · Substantial damageNTSB CHI93DEX01Accident · No injuriesFinal reportZeigler Moni · Seymour, INan inadvertent stall. Factors relating to the accident are the major alteration of the airframe, and failure of the pilot-in- command to obtain new performance data.May 6, 1993 · N10GZ · Substantial damageNTSB LAX93LA203Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Davis, CAThe pilot's failure to follow a safety tip in the pilot's operating handbook to never make a downwind takeoff, his failure to maintain rotor RPM, and his improper use of the helicopter flight controls. A factor which contributed to the accident was the…May 5, 1993 · N80156 · Substantial damageNTSB CHI93LA162Accident · 1 fatalLimited investigationFinal reportBeech A33-35 · Theodosia, MOPoor preflight planning/preparation by the pilot. Factors related to the accident were the tailwind, a heavy weight load, and unsuitable terrain in which to land the airplane.May 5, 1993 · N397Z · DestroyedNTSB CHI93FA161Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paoli, INThe pilot-in-command's inadequate preflight preparations and his failure to maintain airspeed. Factors were the instructor's inadequate training of the pilot-in-command, unqualified maintenance personnel's inadequate inspection of the aircraft and the…May 5, 1993 · N2487T · DestroyedNTSB FTW93LA149Accident · Minor injuriesLimited investigationFinal reportHaltom Avid Flyer · Houston, TXEngine power loss with cause undetermined. A factor was the lack of suitable terrainMay 4, 1993 · N567WH · DestroyedNTSB BFO93LA080Accident · No injuriesLimited investigationFinal reportMcmillin Fisher 404 · Wampum, PAThe overtorque of a safety wire on a plastic fuel line, causing the line to split.May 1, 1993 · UNREG · Substantial damageNTSB BFO93LA064Accident · No injuriesLimited investigationFinal reportBeech E18S · Xenia, OHInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.May 1, 1993 · N665M · Substantial damageNTSB LAX93FA186Accident · 2 fatalField investigationFinal reportBeech 58 · Tucson, AZThe pilots improper preflight inspection, his failure to compeltely secure the aft utility door, and his failure to reconfigure the trim tabs to a takeoff setting. The utility door's sudden opening just after rotation and the effect of the nose up trim…Apr 26, 1993 · N158WB · DestroyedNTSB CHI93LA146Accident · No injuriesLimited investigationFinal reportChampion 7GCBA · Duluth, MNPilot in command failed to maintain directional control.Apr 25, 1993 · N9902Y · Substantial damageNTSB SEA93LA101Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Forest Grove, ORThe pilot in command's inadequate preflight planning. Factors contributing to the accident were the wet terrain, tailwind, trees, and wires.Apr 24, 1993 · N9637P · Substantial damageNTSB MIA93LA106Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Zephyrhills, FLThe pilot-in-command's failure to maintain best single-engine rate-of-climb speed which resulted in a forced landing. A factor which contributed to the accident was a possible exhaust system clamp failure.Apr 20, 1993 · N8056 · Substantial damageNTSB MIA93LA105Accident · Minor injuriesLimited investigationFinal reportSiegel Glasair III · Zephyrhills, FLContamination (fiberglass dust) in the fuel system and/or a piece of plastic (foreign) material in the fuel injector, which resulted in restricted flow of fuel to the engine, loss of engine power, and subsequent collision with trees and terrain during a…Apr 19, 1993 · N540PS · DestroyedNTSB MIA93LA103Accident · Minor injuriesLimited investigationFinal reportIseman Fokker VII · Tampa, FLLoss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.Apr 19, 1993 · N11VD · Substantial damageNTSB ATL93LA077Accident · No injuriesLimited investigationFinal reportMyers Avid Aircraft Flyer · Winnsboro, SCThe pilot's failure to maintain the airspeed above the stall speed, during the forced landing. A factor was the undetermined engine malfunction.Apr 18, 1993 · N31187 · Substantial damageNTSB LAX93LA180Accident · No injuriesLimited investigationFinal reportBeech B24R · Aguila, AZThe loss of engine power due to fuel starvation. The fuel starvation was caused by the pilot's failure to select a tank containing fuel and the intermittent operation of the electric boost pump due to a faulty cockpit switch. A factor in the accident was the…Apr 17, 1993 · N9203S · Substantial damageNTSB SEA93LA093Accident · No injuriesLimited investigationFinal reportCessna 172K · Pony, MTThe improper preflt planning by the PIC and his failure to attain takeoff airspeed during ground roll on a soft snow covered airstrip. A factor relating to the accident was the soft snow on the airstrip.Apr 14, 1993 · N79505 · DestroyedNTSB LAX93LA170Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Torrance, CAFailure of the pilot to attain sufficient lift off airspeed. Factors in this accident were the pilot's overconfidence in his piloting skills, and the inadvertent stall of the airplane.Apr 12, 1993 · N460JA · DestroyedNTSB MIA93LA099Accident · 1 fatalLimited investigationFinal reportKojima, Jun Lewis Cavalier · Dekalb, MSFailure of the pilot-in-command to maintain adequate airspeed resulting in an inadvertent stall. Contributing to the accident was the lack of total experience by the pilot-in-command in the type operation.Apr 11, 1993 · N191DJ · DestroyedNTSB LAX93FA173Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Novato, CAA loss of control for an undetermined reason(s).Apr 11, 1993 · N7041L · DestroyedNTSB SEA93LA092Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Spokane, WAFailure of the number 4 cylinder exhaust valve seat and the inadvertent stalling of the aircraft by the pilot in command. Factors contributing to the accident were buildings and power lines.Apr 10, 1993 · N29553 · Substantial damageNTSB NYC93LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Dowingtown, PAThe loss of engine power for undetermined reasons.Apr 9, 1993 · N6340K · Substantial damageNTSB NYC93FA076Accident · 4 fatalField investigationFinal reportPiper PA-28-235 · Oxford, MAThe pilot's selection of the wrong runway for takeoff which resulted in not being able to obtain adequate airspeed for climbout. A factor which contributed to the accident was the tailwind.Apr 9, 1993 · N9349W · DestroyedNTSB NYC93LA072Accident · 1 fatalLimited investigationFinal reportCessna 140 · Doylestown, PAFailure of the pilot passenger to maintain adequate airspeed and the failure of the pilot in command to adequately supervise the flight.Apr 7, 1993 · N46TM · Substantial damageNTSB FTW93LA116Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Fort Worth, TXPartial power loss due to improper maintenance and resultant discrepancies. A factor was the lack of suitable terrain.Apr 3, 1993 · N9337M · Substantial damageNTSB ANC93LA051Accident · No injuriesLimited investigationFinal reportCessna 170 · Anchorage, AKThe pilot in command's premature lift-off. Contributing factors were the pilot's failure to abort the takeoff, his lack of total expereince in the type airplane and type operation, and the slush covered runway.Apr 3, 1993 · N4190V · Substantial damageNTSB ATL93FA066Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Kennesaw, GAFailure of the flight instructor (CFI) to assure that a proper rate of climb was established after takeoff to maintain proper clearance above the terrain/obstacles. Factors related to the accident were: darkness and the excessive weight condition of the…Mar 31, 1993 · N4218E · DestroyedNTSB FTW93LA112Accident · No injuriesLimited investigationFinal reportCessna 150C · El Paso, TXThe fuel exhaustion induced power loss and the failure of the pilot to refuel. A factor was the lack of suitable terrain.Mar 27, 1993 · N2015Z · Substantial damageNTSB SEA93LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Laurel, MTThe loss of engine power, undetermined.Mar 26, 1993 · N6581T · Substantial damageNTSB ATL93FA062Accident · 1 fatalField investigationFinal reportCessna 402B · Tullahoma, TNThe pilot's failure to maintain control of the airplane during takeoff. Factors which contributed to the accident were: the pilot's failure to ensure that the airplane maximum gross takeoff weight was not exceeded, the dark night, and rain.Mar 23, 1993 · N405PC · DestroyedNTSB FTW93FA108Accident · 2 fatalField investigationFinal reportChampion 7ECA · Dublin, TXThe pilot's attempted maneuver which led to his entry into an inadvertent stallMar 22, 1993 · N11052 · DestroyedNTSB MIA93LA088Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S1-T · Naples, FLThe installation of an improper designed intake tube and air filter by the nonmechanic rated pilot-in-command, which resulted in moisture build up and collapse of the air filter, which resulted in blockage of air flow to the engine and loss of engine power.…Mar 21, 1993 · N218MC · Substantial damageNTSB BFO93LA052Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · New Gloucester, MELoss of engine power during takeoff due to undetermined reasons, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.Mar 19, 1993 · N25881 · Substantial damageNTSB LAX93LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Vacaville, CAa loss of engine power for undetermined reason(s).Mar 16, 1993 · N8120H · DestroyedNTSB DEN93FA033Accident · 3 fatalField investigationFinal reportHiller UH-12E · Applegate, ORThe pilot initiating flight into known adverse weather. Factors were: low ceiling, fog, and turbulence.Mar 16, 1993 · N5344V · DestroyedNTSB SEA93LA076Accident · No injuriesLimited investigationFinal reportBarr Kitfox II · Sheridan, WYA partial power loss for undetermined reasons. Factors include a strong crosswind on landing.Mar 15, 1993 · N569F · Substantial damageNTSB NYC93IA059Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Newark, NJInadequate maintenance/inspection by company maintenance personnel, the manufacturer's inadequate inspection and/or replacement procedures for the aileron cables, and subsequent failure of the 'down' aileron control cable due to wear.Mar 15, 1993 · N14212 · No damageNTSB CHI93IA126Incident · No injuriesIncident investigationFinal reportATR ATR 42 · Chicago, ILAn improper clearance by the north local controller, which resulted in a failure to maintain proper IFR separation. A factor related to the incident was: inadequate coordination among the tower personnel.Mar 13, 1993 · N426MQ · No damageNTSB ANC93LA043Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Ketchikan, AKThe pilot selected unsuitable terrain for takeoff. A factor in the accident was the building situated at the end of the takeoff site.Mar 12, 1993 · N67667 · Substantial damageNTSB CHI93IA125Incident · No injuriesIncident investigationFinal reportATR ATR 72 · Chicago, ILthe local controller's failure to issue a proper heading clearance which resulted in a loss of radar separation between two departing airplanes.Mar 8, 1993 · N248AT · No damageNTSB MIA93FA082Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Kissimmee, FLThe pilot-in-command's attempt to climb at a high pitch attitude after takeoff and his failure to maintain airspeed which resulted in a stall mush condition until the aircraft descended to the ground. Contributing to the accident was the pilot-in-command's…Mar 7, 1993 · N5314S · DestroyedNTSB LAX93LA143Accident · No injuriesLimited investigationFinal reportE.L. Erickson Tierra II · Rio Linda, CAThe flight's encounter with a downdraft. A factor relating to this accident was the trees.Mar 7, 1993 · N4474E · Substantial damageNTSB LAX93LA140Accident · Serious injuriesLimited investigationFinal reportBeech C-45H · Oakland, CAA premature lift off and inadvertent stall by the pilot-in-command. Contributing to the accident was insufficient available aircraft performance data after a ferry tank installation and both pilots lack of total experience in the airplane.Mar 7, 1993 · N494 · Destroyed