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 LAX94LA196Accident · No injuriesLimited investigationFinal reportSchweizer 300C · Pacific Ocean (Pacific Ocean)The loss of engine power for undetermined reasons.Feb 25, 1994 · N61414 · DestroyedNTSB LAX94LA170Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Santa Paula, CAthe existing meteorological conditions that were conducive to carburetor icing.Feb 25, 1994 · N6434C · Substantial damageNTSB ATL94LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kinston, NCA loss of engine power due to a partial blockage of the induction air system by a foreign object (silicon baffling material).Feb 21, 1994 · N6253P · Substantial damageNTSB FTW94LA084Accident · Minor injuriesLimited investigationFinal reportNoble Quickie Q-200 · N. Little Rock, ARThe pilot/owner's inaccurate calculation of the airplane's center of gravity. A factor was the pilot's failure to follow the correct calculation procedure.Feb 19, 1994 · N827Q · Substantial damageNTSB ATL94LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Stockbridge, GAThe partial blockage of the induction air filter because of water soaking, which resulted in a loss of engine power, and the failure of maintenance personnel to properly wash the aircraft.Feb 17, 1994 · N98321 · Substantial damageNTSB LAX94LA143Accident · No injuriesLimited investigationFinal reportAyres S2R · Winterhaven, CAA loss of engine power for an undetermined reason.Feb 16, 1994 · N4003W · DestroyedNTSB BFO94LA039Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Chittenango, NYThe pilot's inadequate planning/decision to take off with the presence of a tailwind.Feb 12, 1994 · N1626V · Substantial damageNTSB LAX94LA119Accident · No injuriesLimited investigationFinal reportCessna T188C · Winton, CAa partial loss of engine power in the takeoff initial climb due to fuel system contamination, and the pilot's inadequate preflight inspection of the aircraft.Feb 10, 1994 · N2086J · DestroyedNTSB LAX94LA118Accident · No injuriesLimited investigationFinal reportGansheimer Evans VP2 · Tucson, AZthe pilot's failure to attain and maintain sufficient flying speed during the first flight test of his experimental homebuilt. A factor in the accident was the pilot's selection of a propeller inadequate for the airframe and engine combination.Feb 10, 1994 · N187ES · Substantial damageNTSB FTW94FA082Accident · 2 fatalField investigationFinal reportCessna 421C · San Antonio, TXImproper servicing of the airplane with jet fuel, which resulted in preignition and/or detonation and subsequent failure of pistons in both engines. A factor related to the accident was: the lack of a restrictive mating nozzle on the refueling truck.Feb 10, 1994 · N741CA · DestroyedNTSB LAX94LA117Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Corona, CAa loss of engine power due to water contamination in the fuel, and the instructor's failure to perform an adequate preflight inspection.Feb 9, 1994 · N49157 · Substantial damageNTSB SEA94LA059Accident · No injuriesLimited investigationFinal reportCessna T210N · Havre, MTAn undetermined loss of engine power.Feb 8, 1994 · N5520A · Substantial damageNTSB LAX94LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Borrego Springs, CA1) the pilot's decision to takeoff in an aircraft with a known, yet unresolved, engine performance deficiency, and 2) the pilot's failure to maintain an adequate airspeed while maneuvering back to the runway. A factor in the accident was the weld repair of…Feb 6, 1994 · N8855S · Substantial damageNTSB FTW94LA081Accident · No injuriesLimited investigationFinal reportCannon Starduster II · Brazoria, TXThe pilot's improper flare technique during the forced landing. A factor was the fuel contamination induced partial power loss.Feb 3, 1994 · N21RC · Substantial damageNTSB FTW94LA080Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Paris, ARFailure by the pilot in command to have annual maintenance inspections performed on the aircraft.Feb 3, 1994 · N7141M · Substantial damageNTSB ATL94FA046Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Centreville, ALThe pilot's failure to assure that the fuel selector was in the proper position for takeoff.Jan 28, 1994 · N6085P · Substantial damageNTSB FTW94FA074Accident · 1 fatalField investigationFinal reportAeronca 7AC · Tulsa, OKWas the inadvertent stall. Factors were the pilots failure to use carburetor heat when weather conditions existed that were conducive to carburetor icing, and his abrupt maneuver to avoid a light pole.Jan 25, 1994 · N84212 · Substantial damageNTSB ANC94LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKFuel starvation from water and/or ice crystals in the fuel system. A factor in the accident was the improper preflight of the fuel sumps by the pilot-in-command.Jan 22, 1994 · N9193W · Substantial damageNTSB MIA94FA057Accident · 3 fatalField investigationFinal reportCessna 421C · Titusville, FLFailure of the pilot-in-command to maintain VMC resulting in the inflight loss of control. Contributing to the accident was the fatigue failure of a section of pipe adjacent to a flange which connects to the turbocharger oil outlet of the left engine assembly.Jan 21, 1994 · N777BE · DestroyedNTSB ANC94FA029Accident · 1 fatalField investigationFinal reportPiper PA-18-160 · Palmer, AKLoss of engine power for undetermined reasons. A factor in the severity of the accident was the failure of the pilot-in-command to maintain control of the airplane when the engine ceased producing power.Jan 17, 1994 · N6574L · DestroyedNTSB LAX94LA093Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Rubidoux, CAthe pilot's inadequate compensation for the existing cross wind condition.Jan 13, 1994 · N8286K · Substantial damageNTSB LAX94LA091Accident · Serious injuriesLimited investigationFinal reportCessna P210N · San Martin, CAthe pilot's improper aircraft preflight inspection, and his failure to use pitot heat during the takeoff in icing conditions, which led to a blocked pitot tube. The blockage resulted in erroneous airspeed indications during the initial climb, which induced…Jan 10, 1994 · N5384W · DestroyedNTSB FTW94LA069Accident · Serious injuriesLimited investigationFinal reportNelson Ford V-6 Stol 262 · San Benito, TXA partial loss of engine power with the cause undetermined. A factor was the lack of suitable terrain for the forced landing.Jan 10, 1994 · N4288L · Substantial damageNTSB ATL94LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Jasper, ALLoss of engine power for undetermined reasons.Jan 9, 1994 · N14CL · Substantial damageNTSB ATL94FA036Accident · Serious injuriesField investigationFinal reportCessna 172H · Perry, GAThe pilot's inadequate aircraft preflight inspection, in that he did not remove the flight control gust lock prior to the flight. A factor was the use of an unapproved, unmarked rivet as a flight control lock.Jan 9, 1994 · N1432F · Substantial damageNTSB LAX94FA089Accident · 1 fatalField investigationFinal reportGrumman AA-1C · Santa Paula, CAA failure of the pilot to maintain adequate airspeed, and subsequent inadvertent stall during an undetermined loss of engine power following takeoff.Dec 31, 1993 · N39036 · DestroyedNTSB CHI94LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Little Falls, MNan improper preflight by the pilot-in-command and the pilot's failure to maintain airspeed during a turn. A factor associated with the accident was contaminated fuel.Dec 27, 1993 · N5894W · DestroyedNTSB LAX94LA082Accident · 2 fatalLimited investigationFinal reportCessna 175 · Peoria, AZthe pilot's failure to attain sufficient altitude following takeoff. A factor in the accident was the pilot's failure to use all available runway for takeoff.Dec 26, 1993 · N6623E · DestroyedNTSB LAX94FA081Accident · 1 fatalField investigationFinal reportGolightly RV-4 · La Verne, CAa loss of engine power due to the improper maintenance and installation of the fuel system lines and fittings, and the pilot's failure to ensure the engine fuel primer was locked prior to takeoff. An additional cause was the pilot's failure to maintain…Dec 26, 1993 · N312RG · DestroyedNTSB FTW94LA056Accident · No injuriesLimited investigationFinal reportBeech 35 · Crystal Beach, TXWas a total loss of engine power for undetermined reasons. Factors were a passenger door inadvertently opening in flight due to inadequate preflight by the pilot, unsuitable terrain for the forced landing, and carburetor icing conditions.Dec 26, 1993 · N3331V · Substantial damageNTSB FTW94FA050Accident · 1 fatalField investigationFinal reportCessna 172M · Lancaster, TXwas THE FAILURE OF THE PILOT TO MAINTAIN AIRCRAFT CONTROL DUE TO PHYSICAL IMPAIRMENT (ALCOHOL).Dec 20, 1993 · N13051 · Substantial damageNTSB FTW94LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Dec 11, 1993 · N8835J · Substantial damageNTSB LAX94LA069Accident · Minor injuriesLimited investigationFinal reportRotorway EXEC-90 · Chandler, AZThe flight instructor's failure to properly follow the aircraft ballasting procedures that resulted in a loss of control when the helicopter's center of gravity limits were exceeded. Inadequate supervision of the training flight was a factor in the accident.Dec 8, 1993 · N89678 · Substantial damageNTSB MIA94LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-301P · Fort Myers, FLThe failure of the pilot-in-command to abort the takeoff. A contributing factor was the soft condition of the runway surface.Dec 7, 1993 · N4391C · DestroyedNTSB CHI94LA044Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Denison, IAThe pilot-in-command's inadequate remedial action. A factor associated with the accident is the student pilot's inadequate aircraft handling.Dec 6, 1993 · N6959Q · Substantial damageNTSB LAX94LA064Accident · No injuriesLimited investigationFinal reportBraegger GL Nieuport 17 · Chandler, AZwas the pilot's improper handling of the airplane, and his failure to maintain control during his first attempted takeoff. Contributing factors were the pilot's inadvertent porpoising on the runway, and his lack of familiarity with the airplane's flight…Dec 3, 1993 · N124DK · Substantial damageNTSB CHI94LA046Accident · No injuriesLimited investigationFinal reportCessna 550 · West Chicago, ILthe collision with birds/geese shortly after takeoff. Reduced visibility in fog was a factor.Dec 3, 1993 · N550RD · Substantial damageNTSB NYC94FA029Accident · 2 fatalField investigationFinal reportAerospatiale TB-21 · Lebanon, NHThe pilot's failure to maintain adequate terrain clearance which resulted in an inflight collision with the terrain. A factor was a dark night condition.Dec 2, 1993 · N28163 · DestroyedNTSB FTW94LA042Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Parkin, ARThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain available to the pilot for the forced landing.Dec 1, 1993 · N4582 · Substantial damageNTSB FTW94FA041Accident · 1 fatalField investigationFinal reportQuicksilver MX II · Newark, TXPoor judment of the pilot after use of drugs, his improper planning/decision, and his failure to remain clear of an obstruction during takeoff. Factors related to the accident were: the pilot's overconfidence with the aircraft's ability, a tailwind condition,…Nov 29, 1993 · UNREG · Substantial damageNTSB LAX94LA059Accident · No injuriesLimited investigationFinal reportCessna 150H · Dardanelle, CAThe pilot misjudged the local weather. The wind conditions and the pilot's inability to compensate for the strong downdraft wind conditions were factors.Nov 28, 1993 · N22474 · Substantial damageNTSB CHI94LA040Accident · Minor injuriesLimited investigationFinal reportSteven Ulrich Challenger II · Escanaba, MIInadequate directional stability of the aircraft (due to installation of lexan cockpit enclosure doors), which precipitated a loss of directional control.Nov 28, 1993 · N4285V · Substantial damageNTSB SEA94LA037Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Sublimity, ORThe pilot's failure to maintain clearance from unmarked transmission wires. Factors include the pilot's inadequate visual lookout, and unmarked wires in the area of operation.Nov 26, 1993 · N59366 · Substantial damageNTSB BFO94FA017Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Ravenna, OHThe pilot attempted to fly the airplane with known deficiencies in the attitude indicator and became spatially disoriented during the takeoff climb. Factors in the accident were the low ceiling, night conditions, and an inaccurate attitude indicator.Nov 24, 1993 · N8467H · DestroyedNTSB ANC94LA019Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe frozen throttle cable due to moisture.Nov 20, 1993 · N7586Z · Substantial damageNTSB FTW94FA034Accident · Serious injuriesField investigationFinal reportCessna 172N · Fort Collins, COPower loss due to throttle linkage disconnect. Factors were missing cotter key, improper maintenance, and the lack of suitable terrain for the forced landing.Nov 15, 1993 · N4829E · DestroyedNTSB MIA94LA021Accident · Serious injuriesLimited investigationFinal reportVacey MK-1 · Altoona, FLThe pilot-in-command's failure to maintain airspeed (VS) on initial takeoff climb while maneuvering to avoid power lines, resulting in an in-flight loss of control (stall) and subsequent in-flight collision with terrain.Nov 13, 1993 · N602 · Substantial damageNTSB LAX94LA042Accident · No injuriesLimited investigationFinal reportCooprider WOODY'S Pusher 1972 · San Diego, CAa delay in the application of carburetor heat by the pilot-in- command. Carburetor icing conditions were a factor in this accident.Nov 13, 1993 · N29717 · Substantial damageNTSB BFO94LA023Accident · 1 fatalLimited investigationFinal reportQuicksilver MX · Montville, CTThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin.Nov 13, 1993 · UNREG · DestroyedNTSB MIA94FA020Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Orlando, FLWas in flight loss of control for failure of the pilot-in-command to maintain VMC shortly after takeoff. Contributing to the accident was partial loss of engine power from the left engine due to partial blockage of several of the fuel injector nozzles. Also…Nov 12, 1993 · N27687 · Destroyed