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 CHI94LA303Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gardner, KSundetermined. A factor associated with the accident is a fence at the off-airport landing site.Aug 27, 1994 · N2409G · Substantial damageNTSB BFO94LA152Accident · Minor injuriesLimited investigationFinal reportA. Le Francois Rans S-7 · Palmer, MAThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed.Aug 27, 1994 · N44AL · Substantial damageNTSB CHI94LA297Accident · No injuriesLimited investigationFinal reportBellanca 7EAC · Alexandria, MNThe second pilot's failure to remove carburetor heat during the takeoff phase resulting in a loss of power and inadvertent stall.Aug 24, 1994 · N2872Z · Substantial damageNTSB BFO94LA147Accident · 1 fatalLimited investigationFinal reportRans S-14 Airaile · Phoenixville, PAthe pilot's failure to perform a preflight inspection, which resulted in a loss of engine power due to fuel contamination.Aug 24, 1994 · UNREG · DestroyedNTSB BFO94LA146Accident · Serious injuriesLimited investigationFinal reportAdvanced Acft Waco 10 GXE · Rochester, NHthe partial loss of engine power for undetermined reasons. Related factors were unsuitable terrain (trees) and the inadvertent stall.Aug 24, 1994 · NC5852 · DestroyedNTSB FTW94LA277Accident · No injuriesLimited investigationFinal reportHodges P-51-51 · Beaumont, TXThe improper adjustment of the propeller system pitch.Aug 23, 1994 · N2073S · Substantial damageNTSB FTW94LA276Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Tulsa, OKLoss of engine power following fuel starvation caused by improper tank selection by the pilot. A factor was the lack of suitable terrain for the forced landing.Aug 23, 1994 · N94AA · Substantial damageNTSB CHI94LA294Accident · 1 fatalLimited investigationFinal reportWatson KR-2 · Pekin, ILAircraft control not maintained by the pilot and the subsequent stall. A factor associated with the accident was the pilot's lack of recent flight experience.Aug 23, 1994 · N121CW · DestroyedNTSB ATL94LA164Accident · Serious injuriesLimited investigationFinal reportAdvance Buccaneer II · Townsville, NCThe failure of the pilot to maintain airspeed and aircraft control during the initial climb.Aug 23, 1994 · UNREG · Substantial damageNTSB FTW94LA278Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lazbuddie, TXThe pilot's premature liftoff and the resultant stall during takeoff. A factor was the density altitude.Aug 22, 1994 · N4360S · Substantial damageNTSB CHI94LA295Accident · No injuriesLimited investigationFinal reportSchreiber-Stitts SA-3B · Muscatine, IAA loose intake manifold pipe on the airplane's engine which resulted from improper maintenance. Factors associated with this accident were the builder/pilot improperly installing the intake manifold pipe and the alternate landing area's high vegetation.Aug 21, 1994 · N79GJ · Substantial damageNTSB ANC94LA119Accident · No injuriesLimited investigationFinal reportCessna 150 · Delta Junction, AKThe pilot's inadequate preflight planning and preparation.Aug 21, 1994 · N2677J · Substantial damageNTSB NYC94FA161Accident · 1 fatalField investigationFinal reportRockwell 112A · Binghamton, NYThe pilot inadequate preflight preparation that resulted in the decision to attempt takeoff on a runway which was beyond the airplane takeoff performance capability to clear obstacles.Aug 20, 1994 · N1253J · DestroyedNTSB CHI94LA291Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sublette, KSimproper preflight planning by the pilot. Factors associated with the accident were the delayed jettisoning of the airplane's hopper load and the inability of the airplane to climb.Aug 19, 1994 · N133MC · Substantial damageNTSB BFO94FA140Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Roanoke, VAThe disconnection of the throttle cable from the throttle arm on the fuel injector servo.Aug 19, 1994 · N4316X · DestroyedNTSB MIA94LA197Accident · No injuriesLimited investigationFinal reportPiper PA-23 · San Juan, PRThe failure of the pilot-in-command to maintain directional control following loss of engine power during takeoff. Contributing to the accident was the pilot-in-commands improper aircraft preflight inspection and draining of fuel tanks and his lack of…Aug 18, 1994 · N556PR · Substantial damageNTSB LAX94LA326Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Chinle, AZthe pilot's premature liftoff, and his failure to attain the appropriate airspeed during a takeoff attempt under high density altitude conditions.Aug 18, 1994 · N5765R · Substantial damageNTSB SEA94LA210Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G-109B · Rock Springs, WYAircraft control was not maintained. Factors to the accident were: high density altitude and wind gusts.Aug 14, 1994 · N45GF · Substantial damageNTSB MIA94LA195Accident · Serious injuriesLimited investigationFinal reportChampion 7GCAA · Merritt Island, FLFailure of the pilot to visually verify that the tow rope was not wrapped around any flight control surface and the inadvertent stall/spin. Contributing to the accident was the entanglement of the tow equipment with the rudder horn, rudder movement was…Aug 14, 1994 · N9669S · Substantial damageNTSB ATL94FA156Accident · 2 fatalField investigationFinal reportCessna 172RG · Atlanta, GAThe pilot's inadequate preflight planning in that he operated the aircraft at a weight which exceeded the maximum takeoff weight and his improper use of flaps during takeoff.Aug 14, 1994 · N9340D · Substantial damageNTSB LAX94FA318Accident · 4 fatalField investigationFinal reportCessna 177RG · So. Lake Tahoe, CAThe pilot's decision to take off from a high density altitude airport at an over allowable gross weight condition. Factors in the accident were the high density altitude, down drafts, and the pilot's lack of familiarity operting from high density altitude…Aug 12, 1994 · N217AF · DestroyedNTSB ATL94LA155Accident · No injuriesLimited investigationFinal reportCessna 210A · Varnville, SCWater contamination in the fuel that resulted from inadequate maintenance inspection of the airplane. A factor was the rough terrain at the landing site.Aug 10, 1994 · N6601X · Substantial damageNTSB LAX94LA312Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Warner Springs, CAthe pilot's inadequate visual lookout for livestock during takeoff.Aug 9, 1994 · N25871 · Substantial damageNTSB ANC94LA115Accident · No injuriesLimited investigationFinal reportCessna 206 · Skwentna, AKThe pilots inadequate compensation for the high wind condition during takeoff. The wind was a factor.Aug 9, 1994 · N14C · Substantial damageNTSB LAX94FA308Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · San Luis Obispo, CAthe failure of the No. 4 cylinder connecting rod for undetermined reasons. The dark night lighting conditions, which hampered the ability of the pilots to detect the power lines, was a factor in this accident.Aug 7, 1994 · N6959J · DestroyedNTSB NYC94LA153Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Scriba, NYThe pilot's failure to maintain adequate airspeed which resulted in a stall and inflight collision with trees.Aug 6, 1994 · N94151 · Substantial damageNTSB NYC94LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Pittstown, NJThe pilot's premature lift off and failure to attain adequate airspeed.Aug 6, 1994 · N9686B · Substantial damageNTSB FTW94LA263Accident · No injuriesLimited investigationFinal reportBeech B36TC · Gunnison, COAn inadvertent stall. Factors were a premature lift off and high density altitude.Aug 6, 1994 · N6368C · DestroyedNTSB BFO94LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Edgewater, MDThe pilot's inadequate preflight inspection which failed to detect water contaminated fuel which resulted in fuel starvation.Aug 6, 1994 · N5242T · DestroyedNTSB ANC94LA099Accident · No injuriesLimited investigationFinal reportCessna 206 · King Salmon, AKThe pilot's failure to use the available longer portion of the lake for the takeoff run.Aug 6, 1994 · N5120X · Substantial damageNTSB ANC94LA101Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · North Pole, AKThe improper rigging of the airplane's ailerons by the pilot. A factor in the accident was the pilot's improper preflight.Aug 4, 1994 · N315C · Substantial damageNTSB ATL94LA150Accident · No injuriesLimited investigationFinal reportCessna 150J · Waxhaw, NCA loss of engine power due to a stuck, and worn, exhaust valve, and the inadequate inspection of the engine by other maintenance personnel. A factor was the trees at the forced landing area.Aug 3, 1994 · N60182 · DestroyedNTSB CHI94FA263Accident · 2 fatalField investigationFinal reportPiper PA-25 · Decatur, NELoss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.Aug 2, 1994 · N6440Z · DestroyedNTSB SEA94LA202Accident · 1 fatalLimited investigationFinal reportGroce Vans RV-4 · Glendive, MTAirspeed was not maintained after takeoff. A factor was high density altitude.Aug 1, 1994 · N7GJ · DestroyedNTSB CHI94FA258Accident · Minor injuriesField investigationFinal reportKeuthan, Charles J. Buccaneer II · Oshkosh, WIthe pilot's inadvertent stall of the airplane. Factors were the tailwind condition and the pilot's inadequate compensation for the tailwind.Aug 1, 1994 · N5296C · Substantial damageNTSB NYC94LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bridgeport, CTThe loss of engine power for undetermined reasons.Jul 31, 1994 · N8453B · Substantial damageNTSB NYC94LA142Accident · Minor injuriesLimited investigationFinal reportArthur Chase EAA Biplane · North Canaan, CTThe pilot's inadequate preflight inspection that failed to detect water contaminated fuel and which resulted in a loss of engine power. The inadequately designed fuel drain system was also a cause.Jul 31, 1994 · N35AE · Substantial damageNTSB FTW94LA254Accident · Serious injuriesLimited investigationFinal reportBoeing A75 · Comfort, TXThe pilot's inadequate compensation for the crosswind and his failure to push the propeller lever full forward. Factors were the crosswind and the pilot's failure to follow the before takeoff checklist.Jul 31, 1994 · N60459 · Substantial damageNTSB SEA94LA201Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M18S · Royal City, WAThe pilot's inadequate remedial action. Factors include high density altitude and unfavorable winds.Jul 30, 1994 · N81705 · Substantial damageNTSB LAX94LA301Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Livermore, CAThe pilot's failure to maintain an adequate airspeed margin while maneuvering and his subsequent entry into an inadvertent stall/mush. A factor was fuel starvation due to the pilot's failure to select the proper fuel tank.Jul 30, 1994 · N20707 · Substantial damageNTSB CHI94LA255Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marshalltown, IAA partial loss of engine power for undetermined reasons.Jul 29, 1994 · N8144Y · Substantial damageNTSB CHI94LA249Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Waterford, MIundetermined.Jul 29, 1994 · N93572 · Substantial damageNTSB CHI94FA248Accident · 2 fatalField investigationFinal reportConsolidated-Vultee BT-13A · Racine, WILoss of power for undetermined reason(s). The dark night was a related factor.Jul 29, 1994 · N79752 · DestroyedNTSB SEA94LA197Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Nampa, IDA cracked cylinder.Jul 27, 1994 · N6824P · Substantial damageNTSB LAX94LA298Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Corona, CAAn undetermined partial loss of engine power.Jul 27, 1994 · N8972L · Substantial damageNTSB NYC94LA139Accident · No injuriesLimited investigationFinal reportCessna 172A · Block Island, RIThe pilot's improper decision to initiate VFR flight into instrument meteorological conditions. The dark night light conditions and the fog were contributing factors.Jul 26, 1994 · N5647A · Substantial damageNTSB ANC94LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Deadhorse, AKThe partial loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.Jul 26, 1994 · N4341Z · Substantial damageNTSB FTW94LA247Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Tyler, TXThe pilot's failure to refuel.Jul 25, 1994 · N823RH · Substantial damageNTSB FTW94LA246Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pollard, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain to perform a forced landing.Jul 25, 1994 · N8092K · Substantial damageNTSB NYC94LA140Accident · Serious injuriesLimited investigationFinal reportAces High Cuby B · Waterbury, CTA loss of engine power for undetermined reasons.Jul 24, 1994 · N2282Z · Substantial damage