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 IAD96LA095Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Versailles, OHFuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.Jun 14, 1996 · N3197T · Substantial damageNTSB CHI96IA207Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320 · Boston, MAan undetermined intermittent fault in the trimmable horizontal stabilizer actuator system.Jun 14, 1996 · N347NW · No damageNTSB LAX96FA229Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Big Bear City, CAimproper preflight by the pilot, by failing to ensure that the fuel selector was positioned to an approved fuel tank with adequate fuel before takeoff; his failure to reposition the fuel selector (per emergency procedures) after the loss of engine power; and…Jun 13, 1996 · N7280P · DestroyedNTSB CHI96LA199Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Charlotte, MIthe pilot's inadequate preflight planning and failure to use all the available runway for takeoff. Factors associated with the accident were the wet grass airstrip and the powerlines.Jun 13, 1996 · N16047 · Substantial damageNTSB SEA96LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-150 · Bountiful, UTinadequate fuel management by the student pilot, which resulted in fuel starvation, due to an improperly positioned fuel selector. Factors relating to the accident were: the pilot's inadequate remedial action, and a ditch in the emergency landing area.Jun 11, 1996 · N5172W · Substantial damageNTSB SEA96LA128Accident · 1 fatalLimited investigationFinal reportBailey Antares MA30 · Woodland, WAfailure of the uncertificated pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall and collision with the terrain. The pilot's abrupt pull-up was a related factor.Jun 10, 1996 · UNREG · Substantial damageNTSB CHI96LA192Accident · No injuriesLimited investigationFinal reportCarrison-Seiman Schukert D-1 · Gardner, KSan aileron control malfunction of undetermined origin. A factor was the pilot's inability to control the airplane.Jun 10, 1996 · N51CQ · Substantial damageNTSB CHI96LA197Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Custer, SDthe pilot did not maintain aircraft control or abort the takeoff. The factors involved were the pilot encountered a stall/mush condition, exhaust valves were leaking, low compression on all cylinders, and all pistons were scored.Jun 8, 1996 · N39048 · Substantial damageNTSB LAX96LA221Accident · No injuriesLimited investigationFinal reportBeech 23-A24R · Modesto, CAfuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft.Jun 7, 1996 · N102KB · DestroyedNTSB FTW96LA238Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Leadville, COInadequate preflight planning and preparation and failure to follow aircraft operating procedures and directives. Factors were high density altitude, inadequate training of the flight instructor and insufficient standards and requirements for flight…Jun 6, 1996 · N9431D · Substantial damageNTSB ANC96LA083Accident · No injuriesLimited investigationFinal reportChampion 7AC · Clear, AKthe pilot's inadequate preflight inspection in that he failed to ensure that the cabin door was properly secured for takeoff. Factors associated with the accident were: the open cabin door and rough/uneven terrain.Jun 5, 1996 · N83995 · Substantial damageNTSB FTW96LA236Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Dumas, ARFailure of all personnel concerned to identify the unsafe/hazardous condition, which resulted from a visual restriction, due to trees near the intersection of the road and runway.Jun 4, 1996 · N3646X · Substantial damageNTSB CHI96LA189Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Greenville, MIforeign material, probably due to improper maintenance, which blocked the main fuel metering jet of the carburetor, and resulted in fuel starvation and loss of engine power.Jun 3, 1996 · N2887K · Substantial damageNTSB MIA96IA146Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Miami, FLfatigue failure of a segment of the elevator trim cable.Jun 2, 1996 · N826BE · No damageNTSB SEA96LA110Accident · No injuriesLimited investigationFinal reportStelly Kolb Firestar II · Independence, ORfailure of the pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. The aircraft's excessive gross weight was a related factor.Jun 1, 1996 · N2213U · Substantial damageNTSB LAX96LA216Accident · No injuriesLimited investigationFinal reportRockwell 112TCA · Eureka, NVa loss of engine power for undetermined nonmechanical reasons. A contributing factor was the lack of suitable terrain for use during an aborted takeoff.May 31, 1996 · N4674W · Substantial damageNTSB FTW96FA230Accident · 5 fatalField investigationFinal reportPiper PA-31T · Malvern, ARThe pilot's failure to maintain control of the airplane after takeoff.May 29, 1996 · N333LM · DestroyedNTSB ATL96LA088Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Jesup, GAthe pilot's inadequate preflight planning/preparation, and his failure to remain clear of the fence during takeoff.May 29, 1996 · N3797X · Substantial damageNTSB IAD96LA086Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Stevensville, MDThe pilot's misjudgment of the amount of fuel he had onboard the airplane which resulted in an engine failure due to fuel exhaustion. Contributing to the severity of the accident was the high vegetation encountered during the forced landing which resulted in…May 25, 1996 · N456JE · Substantial damageNTSB CHI96LA174Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Osage Beach, MOa partial loss of power for undetermined reasons.May 25, 1996 · N40933 · Substantial damageNTSB NYC96LA115Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Macedon, NYa blocked gascolator, inadequate maintenance, and the pilot's decision to fly with a known fuel flow deficiency, which resulted in a loss of engine power, forced landing, and subsequent nose over.May 24, 1996 · N2189B · Substantial damageNTSB NYC96FA113Accident · No injuriesField investigationFinal reportBeech A36 · Meriden, CTthe pilot's improper planning/decision, his failure to use takeoff power, and his premature lift-off of the airplane, which resulted in an inadvertent stall/mush and subsequent collision with terrain. Factors relating to the accident were: the pilot allowing…May 24, 1996 · N59WW · DestroyedNTSB MIA96LA149Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Orlando, FLloss of power in both engines for undetermined reason(s).May 24, 1996 · N441CB · Substantial damageNTSB IAD96FA085Accident · Minor injuriesField investigationFinal reportPiper PA-31-310 · Stevensville, MDThe pilot's improper short field takeoff/procedure and selection of the wrong runway for takeoff.May 24, 1996 · N103RW · DestroyedNTSB ANC96FA078Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Point Hope, AKThe pilot's inadequate preflight to ensure the nose baggage door was properly latched, and the subsequent opening of the baggage compartment door, which allowed items to collide with the left propeller, resulting in propeller damage and loss of thrust from…May 24, 1996 · N4109E · Substantial damageNTSB FTW96LA225Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXthe pilot's improper preflight by failing to ensure the mixture control was properly set before takeoff, and his failure to abort the takeoff (while there was sufficient runway remaining).May 23, 1996 · N52MA · DestroyedNTSB IAD96LA082Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Clinton, MDthe pilot's failure to assure that an adequate supply of fuel was available for the flight. Related factors were the pilot's inadequate airplane preflight inspection and the unsuitable terrain (horses, fence, house, barn, trees) encountered during the landing…May 22, 1996 · N2594B · Substantial damageNTSB LAX96LA198Accident · No injuriesLimited investigationFinal reportBeech 58 · Los Angeles, CAan interruption of fuel flow to the right engine for undetermined nonmechanical reasons. A contributing factor was the pilot's failure to keep the right engine's propeller feathered which reduced the airplane single engine performance capabilities.May 18, 1996 · N58KD · Substantial damageNTSB CHI96LA164Accident · No injuriesLimited investigationFinal reportSchlitter Rans S6ES Coyote II · Hays, KSfailure of the pilot to maintain control of the airplane, when it settled back to the runway after lift-off. A factor relating to the accident was: premature raising of the flaps after lift-off.May 18, 1996 · N4307N · Substantial damageNTSB FTW96LA215Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · Houston, TXfailure of the pilot to obtain/maintain proper airspeed and flap setting for single engine flight. A factor relating to the accident was: Loss of power in the left engine for an undetermined reason.May 16, 1996 · N40AM · Substantial damageNTSB NYC96LA105Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Vineland, NJfailure of the number 8 cylinder, which resulted in loss of engine power, a forced landing in soft terrain, and subsequent nose over of the airplane.May 14, 1996 · N6620Q · Substantial damageNTSB MIA96LA139Accident · Serious injuriesLimited investigationFinal reportEzekiel Velocity 173 · Pembroke Pines, FLloss of engine power for undetermined reason(s), resulting in a forced landing, and impact with a private residence and the ground.May 14, 1996 · N28KJ · DestroyedNTSB ANC96LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKthe pilot's improper planning/decision, which resulted in his failure (or inability) to maintain clearance from trees after encountering gusty crosswind conditions. The wind condition and close proximity of trees were related factors.May 14, 1996 · N5760D · Substantial damageNTSB LAX96LA195Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Adelanto, CAfuel exhaustion as a result of an improper preflight inspection and operating with a known malfunctioning fuel gauge.May 12, 1996 · N6844Z · Substantial damageNTSB MIA96GA138Accident · 1 fatalFinal reportWsk Pzl Mielec M18A · Kinston, NCa cracked/fractured #5 cylinder and subsequent failure/jamming of the #5 exhaust valve, which resulted in a partial loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall and collision with the terrain. Factors…May 11, 1996 · N2065K · DestroyedNTSB FTW96LA207Accident · Minor injuriesLimited investigationFinal reportBowers Midget Mustang M-1 · Mesquite, TXThe pilot's failure to maintain aircraft control following the separation of the propeller spinner installed by the pilot. A factor was the pilot's failure to obtain the required FAA inspection for the installation.May 10, 1996 · N9516 · DestroyedNTSB LAX96LA191Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Page, AZthe pilot's inadequate compensation for a gusty crosswind condition, and his failure to obtain and maintain an adequate airspeed during the takeoff initial climb in a high density altitude situation, which resulted in an inadvertent stall/mush. Related…May 7, 1996 · N100YJ · DestroyedNTSB ATL96LA085Accident · Minor injuriesLimited investigationFinal reportMerle Musson Cozy · Covington, TNThe clogged fuel strainer that resulted in an engine stoppage. A factor was the lack of a suitable landing site.May 7, 1996 · N86LM · Substantial damageNTSB IAD96LA071Accident · No injuriesLimited investigationFinal reportBeech A36 · Hot Springs, VAthe pilot's failure to attain adequate aircraft speed during takeoff. Related factors were the density altitude and gusty wind conditions.May 6, 1996 · N12JE · Substantial damageNTSB ANC96LA070Accident · No injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's failure to maintain control of the airplane during takeoff.May 6, 1996 · N3193B · DestroyedNTSB SEA96LA090Accident · Serious injuriesLimited investigationFinal reportMiller MA-5 Charger · Kennewick, WAfailure of the pilot to maintain adequate airspeed, during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's lack of total and recent flight experience.May 5, 1996 · N36CM · Substantial damageNTSB SEA96LA089Accident · No injuriesLimited investigationFinal reportCessna A185E · Cascade, IDthe pilot's improper planning/decision, his failure to ensure that the airplane would maintain proper clearance from obstructions (trees), and his delay in aborting the takeoff. The soft/wet runway and tailwind were related factors.May 5, 1996 · N185MP · Substantial damageNTSB NYC96LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Harwinton, CTthe operator's failure to eliminate water-contaminated fuel from the airplane, which resulted in the loss of engine power and collision with an obstacle during the forced landing. Also causal was an improperly maintained fuel storage facility.May 5, 1996 · N25414 · Substantial damageNTSB FTW96LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Mountain Home, ARthe pilot's failure to visually check the fuel quantity during the preflight inspection. A factor was the unsuitable terrain for the forced landing.May 1, 1996 · N9869K · Substantial damageNTSB NYC96FA094Accident · 2 fatalField investigationFinal reportCessna 172RG · Duanesburg, NYfailure of the pilot to attain adequate airspeed (or abort the takeoff while there was sufficient runway remaining), which resulted in a stall after liftoff and collision with the terrain. A factor relating to the accident was: the pilot's distraction due to…Apr 29, 1996 · N9678B · DestroyedNTSB LAX96LA180Accident · No injuriesLimited investigationFinal reportCessna 320 · Mammoth Lakes, CAthe partial failure of the right engine turbocharger wastegate butterfly valve to fully close due to mechanical binding and the low setting of its associated absolute pressure controller. A related factor was the high density altitude which reduced the…Apr 28, 1996 · N5752X · Substantial damageNTSB ANC96LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kasilof, AKfuel starvation due to a kinked fuel supply line from the left main tank, and the pilot's improper rebuild/remanufacture of the airplane. A smaller than standard fuel line from the fuel strainer to the carburetor, a smaller than standard fuel cap vent, and a…Apr 28, 1996 · N1930A · Substantial damageNTSB NYC96LA091Accident · No injuriesLimited investigationFinal reportCessna 140 · Houlton, MEthe pilot's failure to select the fullest fuel tank prior to takeoff which resulted in fuel starvation during the initial takeoff climb.Apr 25, 1996 · N2001N · Substantial damageNTSB NYC96LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Toms River, NJThe loss of engine power for undetermined reasons.Apr 24, 1996 · N602U · DestroyedNTSB CHI96LA142Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Naperville, ILthe pilot allowed the airplane to become airborne prematurely, which resulted in a stall after liftoff.Apr 24, 1996 · N680V · Substantial damage