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 LAX95LA038Accident · Minor injuriesLimited investigationFinal reportCessna T210H · Mount Hamilton, CAthe pilot's failure to obtain/maintain an adequate airspeed and inadvertent entry into a stall/mush condition during the initial climb due to frost on the airframe which impeded the airplane's climb performance. Contributing factors were the pilot's improper…Nov 22, 1994 · N2221R · Substantial damageNTSB FTW95LA052Accident · No injuriesLimited investigationFinal reportCessna 172P · Blanco, TXThe pilot's use of unsuitable terrain for takeoff. Factors were the uphill terrain, the long vegetation, and short takeoff area available.Nov 21, 1994 · N65275 · Substantial damageNTSB NYC95LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Freeport, PAThe pilot's attempted takeoff in an overweight airplane, his failure to follow approved short field takeoff procedures, not attaining a positive rate of climb, and attempting an operation beyond his experience level.Nov 19, 1994 · N1470T · Substantial damageNTSB FTW95LA045Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Haskell, OKThe total loss of engine power due to contaminated fuel. Factors were the improper maintenance procedures resulting in fuel contamination, the pilot's inadequate preflight inspection, and the lack of suitable terrain available for the forced landing.Nov 16, 1994 · N5931J · Substantial damageNTSB NYC95LA024Accident · Serious injuriesLimited investigationFinal reportAlon A-2 · Goode, VAthe inadequate preflight by the pilot, resulting in engine failure due to water ingestion.Nov 13, 1994 · N888JL · Substantial damageNTSB CHI95FA041Accident · 4 fatalField investigationFinal reportCessna P210N · Savoy, ILThe failure of the pilot to maintain a positive rate of climb during the night takeoff. Factors related to the accident were: lack of visual cues, the weather conditions, and the dark night.Nov 13, 1994 · N4895K · DestroyedNTSB CHI95LA036Accident · 1 fatalLimited investigationFinal reportLessel KR-2 · Portland, INthe failure of the elevator control cable attach point and the pilot's subsequent inability to control the airplane.Nov 12, 1994 · N95RJ · DestroyedNTSB FTW95LA042Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Seguin, TXThe pilot's failure to attain a proper climb rate after takeoff. A factor was the dark night light condition.Nov 11, 1994 · N9237U · Substantial damageNTSB CHI95LA034Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Mc Cordsville, INthe pilot's improper use of the cyclic control. Factors were the diversion of attention and total lack of experience in the type of aircraft, by the pilot.Nov 8, 1994 · N317GB · Substantial damageNTSB LAX95FA031Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Honolulu, HIImproper loading of the airplane. Contributing to the accident was the pilot's failure to maintain minimum control airspeed.Nov 4, 1994 · N3198Q · DestroyedNTSB LAX95IA027Incident · No injuriesIncident investigationFinal reportFairchild SA-227AC · Oakland, CAthe company maintenance personnel's improper installation of the aileron cable.Oct 29, 1994 · N191AF · No damageNTSB FTW95FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Aurora, COTHE CFI's FAILURE TO MAINTAIN AIRCRAFT CONTROL DUE TO SPATIAL DISORIENTATION. FACTORS WERE: A DARK, MOONLESS NIGHT WITH NO VISIBLE HORIZON AND RECENCY OF NIGHT EXPERIENCE BY THE FLIGHT INSTRUCTOR.Oct 26, 1994 · N8954W · DestroyedNTSB SEA95FA010Accident · 2 fatalField investigationFinal reportBeech 58 Foxstar · Shaw Island, WAFailure of the pilot to maintain adequate airspeed during takeoff and initial climb, which resulted in a stall and subsequent collision with the ground. Factors related to the accident were: darkness, the pilot's improper decision to take off on an unlighted…Oct 24, 1994 · N333KS · DestroyedNTSB FTW95LA029Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Tomball, TXA partial power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Oct 24, 1994 · N2166U · Substantial damageNTSB FTW95LA026Accident · Serious injuriesLimited investigationFinal reportGeorge Spacewalker 1 · Mountain View, OKThe pilot's failure to maintain minimum required airspeed for flight.Oct 23, 1994 · N64BG · Substantial damageNTSB CHI95LA016Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Ft. Wayne, INthe in-flight collision with birds(geese). A factors associated with the accident was the building which was contacted.Oct 18, 1994 · N83KK · Substantial damageNTSB CHI95LA014Accident · Serious injuriesLimited investigationFinal reportMooney M-20J · Aberdeen, SDthe pilot's failure to assure adequate maintenance was performed on the airplane and the resulting intentional flight with known deficiencies. Factors associated with the accident were the pilot's failure to follow the aircraft flight manual and the improper…Oct 16, 1994 · CGJRA · Substantial damageNTSB NYC95LA028Accident · No injuriesLimited investigationFinal reportRans/Hine S-10 · Hampton, NHa seized piston in the foward cylinder due to a lean mixture.Oct 15, 1994 · N104AH · Substantial damageNTSB FTW95IA023Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11 · Dfw Airport, TXImproper maintenance by unknown persons resulting in a jammed spoiler. A factor was the reversed aileron fitting.Oct 14, 1994 · N1758B · No damageNTSB NYC95LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Farmington, MELoss of engine power for undetermined reasons.Oct 11, 1994 · N2450V · Substantial damageNTSB BFO95LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ebensburg, PAThe loss of partial engine power due to the failure of the right magneto's nylon gear on the rotating magnet and the low compression in the number three cylinder.Oct 10, 1994 · N8908J · DestroyedNTSB SEA95LA005Accident · Minor injuriesLimited investigationFinal reportLarsen Avid Heavy Hauler · Nampa, IDLoss of engine power for undetermined reasons and the lack of suitable terrain for the forced landing.Oct 8, 1994 · N21LJ · Substantial damageNTSB CHI95LA006Accident · Serious injuriesLimited investigationFinal reportJohnson A-4 · Laporte, INthe pilot's inadvertant stall of the airplane while conducting a forced landing. A factor was the engine failure which occurred for an undetermined reason.Oct 6, 1994 · N1730H · DestroyedNTSB LAX95LA001Accident · 1 fatalLimited investigationFinal reportCessna 170B · Ramona, CAthe noninstrument-rated pilot's failure to maintain aircraft control due to spatial disorientation after encountering instrument meteorological conditions after the pilot decided to takeoff in adverse weather conditions. A factor in the accident was the dark…Oct 2, 1994 · N170CT · DestroyedNTSB CHI94DEV02Accident · Serious injuriesFinal reportThomas E. Georges Z-MAX · Palmyra, ILThe pilots's inadvertently stalled the airplane while maneuvering to land. Factors were the loss of engine power due to carburetor ice, carburetor icing conditions, and the unavailability of carburetor heat.Sep 25, 1994 · N4592M · DestroyedNTSB LAX94LA375Accident · 2 fatalLimited investigationFinal reportCorley Lancair · Ramona, CAthe pilot's premature lift-off and failure to obtain the requisite minimum airspeed for flight, failure to maintain control of his airplane, and inadvertent stalling during initial climb. Factors which contributed to the accident related to the pilot's…Sep 24, 1994 · N6RC · DestroyedNTSB CHI94LA345Accident · No injuriesLimited investigationFinal reportCessna 150G · New Town, NDThe pilot's improper use of wing flaps and premature lift-off. The pilot's poor preflight preparation was a factor.Sep 23, 1994 · N6685F · Substantial damageNTSB NYC94LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Oakland, MDthe pilot's inadequate preflight planning and preparation in which the pilot attempted a high density altitude takeoff, up-slope, with the airplane over the maximum allowable gross weight, utilizing a rolling takeoff technique with an improper flap setting.…Sep 20, 1994 · N2815T · DestroyedNTSB SEA94LA242Accident · Minor injuriesLimited investigationFinal reportCessna P206D · Lopez, WAA worn throttle control lever.Sep 18, 1994 · N8761Z · Substantial damageNTSB NYC94LA179Accident · Minor injuriesLimited investigationFinal reportCessna 172M · New London, PAThe pilot failed to maintain adequate airpseed which resulted in an inadvertent stall and inflight collision with terrain.Sep 18, 1994 · N13510 · Substantial damageNTSB MIA94LA213Accident · 1 fatalLimited investigationFinal reportRans S-12 Airaile · Clearwater, FLThe loss of engine power for undetermined reasons.Sep 18, 1994 · N4123N · DestroyedNTSB FTW94FA299Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Lakeside, TXThe pilot's failure to maintain minimum required airspeed for flight. A factor was the loss of engine power for undetermined reasons.Sep 18, 1994 · N68529 · Substantial damageNTSB CHI94LA336Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNAn inadequate pre-flight inspection by the pilot when he did not insure that all the water was drained from the airplane's fuel tanks. Factors associated with this accident were contaminated fuel and powerlines.Sep 18, 1994 · N4271V · Substantial damageNTSB ANC94LA141Accident · Serious injuriesLimited investigationFinal reportArtic S-1B2 · Wasilla, AKA failure of the pilot to maintain adequate airspeed. A lack of total aeronautical experience was a factor in the accident.Sep 18, 1994 · N74AT · Substantial damageNTSB CHI94LA333Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Elkhart, INthe pilot's improper use of the fuel selector position which resulted in fuel starvation.Sep 17, 1994 · N732HS · Substantial damageNTSB ANC94LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Port Alsworth, AKThe pilot's failure to maintain a positive rate of climb.Sep 15, 1994 · N3930Z · Substantial damageNTSB FTW94FA295Accident · 2 fatalField investigationFinal reportCessna 175 · Oklahoma City, OKImproper maintenance of the engine by unknown person(s), the installation of unapproved parts, and subsequent bearing seizure. The lack of suitable terrain in the forced landing area was a related factor.Sep 10, 1994 · N7554M · Substantial damageNTSB FTW94FA293Accident · Minor injuriesField investigationFinal reportEurocopter AS-350-B2 · Cascade, COA power loss due to contaminated fuel from an unknown source that clogged the fuel filter and internally damaged the fuel control unit. A factor was unsuitable terrain for a forced landing.Sep 8, 1994 · N99TV · DestroyedNTSB CHI94LA317Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Princeton, WIthe pilot's premature liftoff.Sep 8, 1994 · N4188Q · Substantial damageNTSB SEA94LA233Accident · No injuriesLimited investigationFinal reportCessna 150 · Cheyenne, WYFuel deterioration and/or contamination, and the pilot's decision to operate the airplane with a known problem.Sep 6, 1994 · N1396Q · Substantial damageNTSB NYC94LA171Accident · Serious injuriesLimited investigationFinal reportCessna 152-II · Enfield, NYThe pilot-in-command's attempt to take off under conditions beyond the performance capabilities of the airplane.Sep 6, 1994 · N80235 · Substantial damageNTSB LAX94FA354Accident · 4 fatalField investigationFinal reportStinson 108-3 · Shelter Cove, CAInadequate preflight by the pilot, which resulted in fuel starvation and loss of engine power, improper (or delayed) positioning of the fuel selector to the fullest tank, and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced…Sep 5, 1994 · N6446M · DestroyedNTSB LAX94FA353Accident · 4 fatalField investigationFinal reportCessna 172RG · Truckee, CAFailure of the pilot to obtain/maintain adequate airspeed to climb after takeoff, which resulted in a stall and subsequent collision with the ground. Factors related to the accident were: high density altitude, improper trim setting for takeoff, the…Sep 5, 1994 · N3745B · DestroyedNTSB CHI94FA310Accident · 1 fatalField investigationFinal reportCessna 182H · Plymouth, MICarburetor ice, and improper use of (or failure to use) the carburetor heat. Factors related to the accident were: carburetor icing (weather) conditions, and the lack of suitable terrain for a forced landing.Sep 3, 1994 · N8470S · DestroyedNTSB CHI94LA308Accident · No injuriesLimited investigationFinal reportThalman Thorp T-18 · Kenosha, WIthe pilot's failure to use carburetor heat in carburetor icing conditions. A factor associated with the accident is the prevailing carburetor icing conditions.Sep 2, 1994 · N2911 · Substantial damageNTSB ANC94LA129Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tok, AKThe worn cam shaft lobe and worn valve lifter.Sep 2, 1994 · N8597D · Substantial damageNTSB BFO94LA158Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Ravenswood, WVThe poorly planned approach which resulted in unporting of fuel from the left fuel tank and loss of engine power due to fuel starvation.Aug 30, 1994 · N2150N · Substantial damageNTSB FTW94FA282Accident · Minor injuriesField investigationFinal reportCessna 402 · Harlingen, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall. Factors were a partial loss of power on all engines due to worn and fouled spark plugs and inadequate maintenance by company maintenance personnel, aircraft weight beyond limitations,…Aug 28, 1994 · N966JW · Substantial damageNTSB CHI94LA289Accident · No injuriesLimited investigationFinal reportCessna 172 · Plato Center, ILThe pilot's attempt to take off on a short runway with a gross weight which exceeded the maximum allowable weight and an improper flap setting. A factor was the location of obstructions (trees) at the departure end of the runway.Aug 28, 1994 · N97618 · Substantial damageNTSB FTW94LA283Accident · 2 fatalLimited investigationFinal reportWalton Skybolt · Collinsville, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall.Aug 27, 1994 · N113BW · Destroyed