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 ATL94LA015Accident · Serious injuriesLimited investigationFinal reportLuscombe 8F · Griffin, GAThe pilot's failure to maintain airspeed while maneuvering following a loss of engine power for unknown reasons.Nov 12, 1993 · N822B · Substantial damageNTSB ATL94LA014Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 Soloy · Atmore, ALThe pilot's inadequate pre-flight inspection. Factors were the lack of a filter on the refueling pump which would preclude water passage, and the high trees.Nov 12, 1993 · N3078G · Substantial damageNTSB FTW94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fredericksburg, TXThe pilot's utilization of unsuitable terrain for takeoff.Nov 9, 1993 · N6776W · Substantial damageNTSB SEA94LA026Accident · 1 fatalLimited investigationFinal reportBird RAF-2000 · Redmond, UTThe pilot in command's exceeding the proper climb rate. A factor contibuting to the accident was the pilot's lack of experience in make/model.Nov 6, 1993 · N70334 · DestroyedNTSB CHI94LA031Accident · No injuriesLimited investigationFinal reportBeech B36TC · Rockford, ILA loose fuel line fitting, due to improper maintenance, which resulted in an interuption of fuel to the engine.Nov 3, 1993 · N8006R · Substantial damageNTSB FTW94LA022Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Gulf Of MexicoThe pilot in command's inadequate preflight inspection in that he failed to remove a tie down rope. A factor was the pilot's self-induced pressure.Oct 29, 1993 · N5370V · Substantial damageNTSB LAX94LA030Accident · No injuriesLimited investigationFinal reportBeech 200 · Reno, NVThe improper overhaul of the right main landing gear actuator by maintenance personnel, and the operator's failure to assure that the airplane manufacturer's mandatory service bulletin requiring modification of the gear motor circuit protection was…Oct 28, 1993 · N191FL · Substantial damageNTSB FTW94LA019Accident · Minor injuriesLimited investigationFinal reportBell 206B · High Island 467Were the pilot's inadequate preflight inspection and his failure to remove all of the aircraft tie-downs.Oct 25, 1993 · N22841 · Substantial damageNTSB NYC94LA020Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Griswold, CTThe pilot's inadequate compensation for wind conditions during takeoff, and the subsequent loss of control and collision with trees. A factor related to the accident were the adverse winds.Oct 24, 1993 · N2111W · DestroyedNTSB LAX94LA015Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Yuma, AZa failure of the pilot-in-command to maintain adequate airspeed and subsequent inadvertent stall while maneuvering the airplane. Contamination of the fuel in the carburetor that produced a partial power loss was a factor in the accident.Oct 16, 1993 · N94981 · DestroyedNTSB CHI94FA018Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Atkinson, NEthe instrument rated commercial pilot's failure to maintain adequate clearance from terrain/obstructions during the initial climb after takeoff. Related factors are the weather conditions (fog) and the pilot's failure to maintain the proper rate of climb.Oct 16, 1993 · N4147Q · DestroyedNTSB FTW94LA010Accident · Serious injuriesLimited investigationFinal reportEmmert Tierra II · Yukon, OKWas an inadvertent stall. A factor was the gusty tailwind.Oct 11, 1993 · N246RE · Substantial damageNTSB NYC94LA006Accident · No injuriesLimited investigationFinal reportCessna T210F · Frederick, MDThe mechanic's inadequate inspection and the pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, resulting in a loss of engine power and a forced landing.Oct 6, 1993 · N6773R · Substantial damageNTSB FTW94LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180C · Albuquerque, NMThe pilot's failure to maintain adequate airspeed. The high density altitude was a factor.Oct 5, 1993 · N9317J · DestroyedNTSB ATL94LA003Accident · No injuriesLimited investigationFinal reportCessna T188C · Rogersville, ALWas the pilot's inadequate pre-flight preparation which resulted in fuel exhaustion during take off.Oct 5, 1993 · N42402 · Substantial damageNTSB ANC94LA003Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Kenney Lake, AKThe pilot's intentional VFR takeoff into instrument meteorological conditions which resulted in spatial disorientation and a loss of control. Factors in the accident were the weather and low light conditions.Oct 5, 1993 · N9230E · DestroyedNTSB ANC94LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe pilot-in-command's improper preflight planning/preparation. A factor was rising terrain.Oct 4, 1993 · N81648 · Substantial damageNTSB ANC94LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Point, AKThe Pilot's improper preflight procedures in that the frost removal was not adequately performed resulting in aerodynamic stall of flight surfaces on takeoff.Oct 4, 1993 · N82231 · DestroyedNTSB SEA94LA003Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Denton, MTThe pilot in command's failure to maintain adequate clearance with terrain. Factors contributing to the accident were unfavorable winds and the pilot in command's inadquate compensation (premature crosswind turn) for the wind conditions.Oct 3, 1993 · N9002M · Substantial damageNTSB LAX94LA001Accident · No injuriesLimited investigationFinal reportCessna O-2A · Tucson, AZwas the partial loss of engine power during initial climb due to partial clogging of the engine's fuel injectors. Blockage of the fuel injectors was due to inadequate maintenance of the fuel system by contract maintenance personnel.Oct 1, 1993 · N5151A · Substantial damageNTSB LAX93LA373Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lompoc, CAwas fuel starvation. A factor in the accident was the mechanic's inadequate inspection of the airplane.Sep 30, 1993 · N430FL · Substantial damageNTSB FTW93FA274Accident · Serious injuriesField investigationFinal reportRobinson R22 Beta · Deming, NMThe pilot's inadequate preflight planning and preparation. Factors were high density altitude and the over gross weight condition of the aircraft.Sep 30, 1993 · N2360B · Substantial damageNTSB FTW93LA275Accident · No injuriesLimited investigationFinal reportKelm Zenair CH-701 · South Bend, ARThe engine power loss for undetermined reasons. A factor was the lack of available runway onto which the forced landing could be executed.Sep 29, 1993 · N27DK · Substantial damageNTSB SEA93LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Salt Lake City, UTA power loss for undetermined reasons. Factors include a fence, an animal, and a ditch in the landing roll path.Sep 27, 1993 · N200X · Substantial damageNTSB ATL93FA162Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · Boone, NCThe pilot's improper preflight planning, his failure to retract the landing gear after departure, and his failure to maintain control of the aircraft. Factors in the accident were the high density altitude, and the mountainous terrain.Sep 26, 1993 · N5586P · DestroyedNTSB LAX93LA370Accident · No injuriesLimited investigationFinal reportBeech A-36 · Firebaugh, CAthe CFI's inadequate supervision of the flight and his delay in taking remedial action; the dual student's premature liftoff and improper use of the flight controls. The high vegetation and soft terrain were factors in this accident.Sep 25, 1993 · N7246Z · Substantial damageNTSB LAX93LA364Accident · No injuriesLimited investigationFinal reportMcinroy DER Jager DIX · Hesperia, CAFailure of the pilot to lean the aircraft's fuel mixture for the airport's density altitude.Sep 21, 1993 · N16RM · Substantial damageNTSB ANC93LA186Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Point, AKThe Pilot failed to adequately compensate for the wind conditions. A factor was the unfavorable wind.Sep 20, 1993 · N6721L · Substantial damageNTSB LAX93LA358Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Napa, CAThe loss of engine power for undetermined reasons. The rough/uneven terrain was a factor in this accident.Sep 19, 1993 · N2485K · Substantial damageNTSB CHI93LA367Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Crivitz, WIfuel starvation caused by foreign matter in the fuel tank strainer.Sep 19, 1993 · N6752N · Substantial damageNTSB FTW93LA261Accident · Minor injuriesLimited investigationFinal reportCulver V · Carlsbad, NMAn inadvertent stall when the pilot lowered the landing gear. A factor was a leaking o-ring in the propeller governor.Sep 17, 1993 · N44680 · DestroyedNTSB CHI93LA366Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Madison, WIthe loose fuel selector handle/valve which resulted in an inability to properly switch fuel tanks.Sep 17, 1993 · N823PJ · Substantial damageNTSB ATL93LA158Accident · Serious injuriesLimited investigationFinal reportBeech A-23-19 · Resaca, GANot determined.Sep 12, 1993 · N4763J · Substantial damageNTSB ANC93LA174Accident · 1 fatalLimited investigationFinal reportCessna 206 · Swikshak Bay, AKThe pilot-in-command's failure to attain a proper climb rate.Sep 12, 1993 · N9707Z · Substantial damageNTSB LAX93LA349Accident · Serious injuriesLimited investigationFinal reportCulver LFA · Sonoma, CAthe airport management's failure to provide notice of the banner operation and to close the runway. An additional cause was the banner operator's failure to ensure that the runway on which he placed his banner equipment was closed.Sep 11, 1993 · N41729 · Substantial damageNTSB ATL93LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Roxboro, NCThe pilot's inadequate compensation for the wind conditions at the time of the takeoff. Factors were the wind gusts and windshear existing at the airport.Sep 10, 1993 · N410SF · Substantial damageNTSB SEA93LA195Accident · No injuriesLimited investigationFinal reportCessna A188B · Ringling, MTThe pilot's failure to maintain airspeed.Sep 9, 1993 · N731ED · Substantial damageNTSB BFO93LA166Accident · Minor injuriesLimited investigationFinal reportWilson KIT FOX Model 4 · Bowdoinham, MELoss of engine power for an undetermined reason.Sep 8, 1993 · N193CW · Substantial damageNTSB ANC93FA172Accident · Serious injuriesField investigationFinal reportInterstate S-1B2 Arctic Tern · Talkeetna River, AKThe pilot in command's improper preflight planning. Factors in the accident were: the rough/uneven takeoff location, the excess weight of the airplane, the inadequate design of the add-on tank by the manufacturer affecting the weight and balance, and the…Sep 8, 1993 · N64AT · DestroyedNTSB MIA93FA190Accident · Serious injuriesField investigationFinal reportBeech 35 · Frisco, NCThe pilot's failure to maintain airspeed (vso) resulting in a stall/mush. Contributing to the accident was the near total loss of engine power due to separation of one of the two counterweights for undetermined reasons.Sep 6, 1993 · N88V · Substantial damageNTSB SEA93LA192Accident · No injuriesLimited investigationFinal reportWestholm Vans RV-6 · Salmon, IDThe inadequate preflight planning/preparation by the PIC in his failure to close the fuel drain valve. A factor relating to the accident was the fence post located in the landing area.Sep 5, 1993 · N16JL · Substantial damageNTSB SEA93LA191Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bryce Canyon, UTLoss of engine power for an undetermined reason. Factors related to the forced landing were: high density altitude and rough terrain.Sep 5, 1993 · N7148Y · Substantial damageNTSB LAX93LA343Accident · No injuriesLimited investigationFinal reportCessna TU206G · Marble Canyon, AZfuel starvation due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft either prior to departure or enroute.Sep 5, 1993 · N9454G · Substantial damageNTSB BFO93LA159Accident · No injuriesLimited investigationFinal reportCessna 206 · Inlet, NYthe blocked header tank fuel port which resulted in fuel starvation. A factor to the accident were the high obstructions in the emergency landing area.Sep 5, 1993 · N2147F · Substantial damageNTSB ATL93FA150Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stone Mountain, GAThe pilot-in-command's improper use of the aircraft stabilator during the takeoff, and his failure to maintain airspeed, which resulted in an inadvertant stall. A factor was the high obstructions (trees) located near the departure end of the runway.Sep 5, 1993 · N6312W · DestroyedNTSB FTW93LA256Accident · No injuriesLimited investigationFinal reportJones Dominator · Magnolia, ARTotal loss of engine power for undetermined reasons. A factor was the lack of suitable terrain.Sep 4, 1993 · N44VJ · Substantial damageNTSB ATL93LA149Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Tuscaloosa, ALFouled spark plugs on the number 2 and 3 cylinders, and a lack of compression on the number 1 and 4 cylinders, which resulted in a loss of engine power. A factor was the high vegetation at the forced landing site.Sep 4, 1993 · N5765L · Substantial damageNTSB CHI93LA350Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Clay Center, NEinadequate preflight planning by the pilot. Factors associated with this accident were a soft runway with high grass and the airplane's failure to attain a climb once airborne.Sep 3, 1993 · N5942D · Substantial damageNTSB BFO93FA153Accident · Serious injuriesField investigationFinal reportMooney M20J · Mitchellville, MDCorrosion in the fuel control unit, which resulted in fuel starvation and loss of engine power. Related factors were: inadequate maintenance, and the lack of suitable terrain for an emergency landing.Sep 3, 1993 · N7666P · Substantial damageNTSB MIA93LA187Accident · No injuriesLimited investigationFinal reportMooney M20J · Daytona Beach, FLContamination/blockage of the fuel injection control system.Sep 2, 1993 · N191ER · Substantial damage