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 NYC96LA089Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, NYThe pilot's failure to gain adequate airspeed due to inadequate planning in which he conducted a downwind takeoff, resulting in a stall mush, and collision with trees.Apr 21, 1996 · N89414 · Substantial damageNTSB NYC96LA087Accident · Serious injuriesLimited investigationFinal reportMooney M20K · West Milford, NJloss of engine power for undetermined reason(s), which resulted in a forced landing on unsuitable terrain and subsequent collision with trees.Apr 21, 1996 · N231KS · Substantial damageNTSB IAD96LA065Accident · No injuriesLimited investigationFinal reportCessna 150H · Clinton, MDa loss of engine power for undetermined reasons.Apr 19, 1996 · N6508S · Substantial damageNTSB IAD96LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Dover, DEthe overhaul maintenance personnel's improper major overhaul procedure (improper torque on the engine block center through bolts), which resulted in an in flight loss of engine power. A related factor was the lack of suitable terrain available for a forced…Apr 19, 1996 · N3506A · Substantial damageNTSB SEA96LA081Accident · Minor injuriesLimited investigationFinal reportForth Acro 2 · Rock Springs, WYthe pilot's improper decision to attempt a takeoff from a road with gusting crosswinds, and his failure to adequately compensate for wind conditions during the takeoff. Factors contributing to the accident were gusts, crosswinds, and windshear.Apr 18, 1996 · N565HF · Substantial damageNTSB FTW96LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pond Creek, OKThe pilot's improper planning/decision and failure to obtain/maintain sufficient airspeed to climb after takeoff, which resulted in a stall/mush and subsequent collision with terrain. Factors relating to the accident were: failure of the pilot to follow short…Apr 18, 1996 · N6050D · Substantial damageNTSB CHI96FA135Accident · 2 fatalField investigationFinal reportPiper J-3 · Raymond, NEfailure of the pilot to ensure that the fuel selector was properly positioned to the full 'on' position before takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb after takeoff; and the pilot's failure to maintain…Apr 18, 1996 · N6510H · DestroyedNTSB ANC96LA049Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKfailure of the pilot to maintain sufficient altitude/clearance above terrain, after becoming spatially disoriented, while maneuvering after takeoff. Factors relating to the accident were: fog, snow, partial obscuration, 'flat' conditions of light, and the…Apr 17, 1996 · N6282H · DestroyedNTSB FTW96LA171Accident · 1 fatalLimited investigationFinal reportCessna U206G · Venice, LAthe pilot's inadvertent flight into instrument meteorological conditions. A factor was the fog.Apr 14, 1996 · N734QW · DestroyedNTSB IAD96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Akron, OHa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Apr 12, 1996 · N16188 · Substantial damageNTSB SEA96MA079Accident · 3 fatalClass 1 · MajorFinal reportCessna 177B · Cheyenne, WYthe pilot-in-command's improper decision to take off into deteriorating weather conditions (including turbulence, gusty winds, and an advancing thunderstorm and associated precipitation) when the airplane was overweight and when the density altitude was…Apr 11, 1996 · N35207 · DestroyedNTSB ANC96LA046Accident · No injuriesLimited investigationFinal reportStinson ST-75 · Anchorage, AKThe pilot's failure to select the proper fuel tank prior to takeoff resulting in fuel starvation. A factor in the accident was the pilot's failure to follow the checklist.Apr 11, 1996 · N235C · Substantial damageNTSB FTW96LA166Accident · No injuriesLimited investigationFinal reportCessna 182RG · Welsh, LAa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the emergency landing.Apr 10, 1996 · N2385C · Substantial damageNTSB FTW96LA164Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Boerne, TXThe pilot's improper planning/decision, and his failure to use all of available runway. Factors relating to the accident were: the pilot's overconfidence in the ability of the airplane, the high density altitude, the tailwind, and trees at the departure end…Apr 8, 1996 · XBCHP · Substantial damageNTSB LAX96LA159Accident · Serious injuriesLimited investigationFinal reportGage VARI-EZE · Chino, CAthe pilot's excessive initial climb attitude and his failure to maintain adequate airspeed. The pilot's diverted attention to the unlatched canopy warning light, and his lack of familiarity with the aircraft were factors.Apr 7, 1996 · N88VE · Substantial damageNTSB SEA96LA078Accident · Minor injuriesLimited investigationFinal reportSport Flight Talon · Salem, ORloss of engine power for undetermined reason(s), and failure of the pilot to properly flare the aircraft during the emergency landing.Apr 6, 1996 · UNREG · Substantial damageNTSB LAX96LA161Accident · No injuriesLimited investigationFinal reportVan Dyke GVD1 · Sacramento, CAthe pilot's failure to maintain adequate airspeed during a low altitude turn after takeoff.Apr 5, 1996 · N94GV · Substantial damageNTSB ANC96IA039Incident · No injuriesIncident investigationFinal reportHelio H295 · Angoon, AKthe pilot's inadequate compensation for the gusty wind conditions. A factor associated with the accident was the gusty wind conditions.Mar 29, 1996 · N5462E · Minor damageNTSB SEA96LA075Accident · No injuriesLimited investigationFinal reportRyan Navion · Kent, WAthe pilot's attempted operation with known deficiencies in the equipment, and a loose fuel system fitting. The pilot's failure to maintain maintenance service on the airplane was a factor.Mar 28, 1996 · N4826K · Substantial damageNTSB MIA96IA109Incident · No injuriesIncident investigationFinal reportBeech 1900D · Jacksonville, FLFailure of a blade counterweight clamp retaining screw due to cadmium embrittlement which occurred during the manufacture process. This resulted in the counterweight clamp separating and striking the adjacent blade causing it to separate.Mar 28, 1996 · N29YV · Minor damageNTSB SEA96LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Lynnwood, WAa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Mar 26, 1996 · N5638H · Substantial damageNTSB LAX96LA143Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Upland, CAfuel system contamination and the pilot's intentional operation of a known unairworthy aircraft.Mar 23, 1996 · N7044T · Substantial damageNTSB MIA96LA108Accident · No injuriesLimited investigationFinal reportBoeing 737-200 · Jacksonville, FLfailure of the nose gear taxi light support bracket due to in service damage, which resulted in debris being ingested by the engines. Contributing to the accident was the failure of company maintenance personnel to comply with a Grimes Service Bulletin and a…Mar 21, 1996 · EICLK · Substantial damageNTSB MIA96FA100Accident · 5 fatalField investigationFinal reportCessna U206G · Key West, FLThe pilot's improper decision to continue the flight rather than making an immediate water landing due to the low altitude of the airplane and obstructions ahead, which led to his intentional maneuver to avoid the obstructions and subsequent inadvertent stall…Mar 17, 1996 · N9983Z · DestroyedNTSB IAD96LA049Accident · Minor injuriesLimited investigationFinal reportKitfox IV-1200 · Saluda, VAa partial loss of engine power due to spark plug failure, and the pilot's evasive maneuver to avoid lights at the end of the runway.Mar 14, 1996 · N32495 · Substantial damageNTSB NYC96LA072Accident · No injuriesLimited investigationFinal reportCessna 182L · Weedsport, NYthe pilot's decision to takeoff on a closed snow-covered runway, and his inadequate compensation for a crosswind. A factor in the accident was the pilot's lack of recent flying experience.Mar 10, 1996 · N3407R · Substantial damageNTSB LAX96FA131Accident · 2 fatalField investigationFinal reportVarga 2180A · Peoria, AZfailure of the pilot to obtain or maintain adequate airspeed for turning (maneuvering) after takeoff, which resulted in an inadvertent stall/spin. The lack of altitude for stall/spin recovery was a related factor.Mar 10, 1996 · N5065V · DestroyedNTSB FTW96LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Gladewater, TXfuel starvation due to the pilot inadvertently turning the fuel selector to the OFF position. A factor was the lack of suitable terrain for the forced landing.Mar 9, 1996 · N8726N · Substantial damageNTSB ANC96LA031Accident · No injuriesLimited investigationFinal reportCessna 150H · Anchorage, AKloss of engine power for an undetermined reason.Mar 3, 1996 · N22053 · Substantial damageNTSB LAX96LA126Accident · Serious injuriesLimited investigationFinal reportWorthington BD-5B · San Martin, CAthe pilot/builder's improper installation (overtorque) of the ignition switch on the instrument panel, which caused an internal switch failure and subsequent malfunction of the ignition system.Mar 2, 1996 · N69SW · Substantial damageNTSB NYC96LA066Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Linden, NJthe pilot's inadequate preflight and failure to follow the checklist to ensure that the fuel selector valve was in the ON position, which resulted in fuel starvation and subsequent loss of engine power. In addition, the pilot failed to maintain airspeed…Feb 26, 1996 · N6964S · Substantial damageNTSB MIA96LA087Accident · Serious injuriesLimited investigationFinal reportMarks Kitfox II · Panama City, FLthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve and subsequent collision with a ditch. Factors relating to the accident were: failure of the…Feb 24, 1996 · N915PK · Substantial damageNTSB IAD96LA047Accident · No injuriesLimited investigationFinal reportBeech F35 · Mt. Sterling, KYa loss of engine power due to the failure of the number one piston. Related factors were the unsuitable terrain available for the forced landing, and the strong tailwind encountered during the forced landing.Feb 23, 1996 · N3850B · Substantial damageNTSB LAX96LA124Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Tracy, CAoverheating and failure of the engine's master rod and master rod bearing due to oil starvation. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.Feb 21, 1996 · N6674Q · Substantial damageNTSB ATL96LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Jackson, MSloss of engine power during takeoff for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.Feb 18, 1996 · N166F · Substantial damageNTSB LAX96LA110Accident · Serious injuriesLimited investigationFinal reportStolp Starduster II · Kahului, HIa faulty engine magneto, and decision by the pilot-in-command to operate the airplane with known deficiencies. A factor relating to the accident was: the airplane was overdue for an annual inspection.Feb 10, 1996 · N1457 · DestroyedNTSB NYC96LA059Accident · No injuriesLimited investigationFinal reportCessna 180D · Islesboro, MEa loss of engine power for an undetermined reason.Feb 5, 1996 · N6423X · Substantial damageNTSB LAX96FA106Accident · 4 fatalField investigationFinal reportConvair C-131E · Saint Johns, AZinadequate preflight planning and preparation by the first pilot (PIC), his failure to ensure the aircraft was properly loaded within limitations, his failure to use proper flaps for takeoff, his failure to use ADI assisted takeoff, and his resultant failure…Feb 5, 1996 · N131T · DestroyedNTSB LAX96FA103Accident · 1 fatalField investigationFinal reportCessna 402B · Kamuela, HIfailure of the copilot (pilot-rated cargo loader, who was flying the aircraft) to establish and maintain a positive rate of climb after taking off at night; and inadequate supervision by the pilot-in-command (PIC), by failing to ensure that proper altitude…Jan 29, 1996 · N999CR · DestroyedNTSB ATL96FA037Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Fort Pierce, FLimproper re-assembly of the engine induction air filter by maintenance personnel, during an annual inspection, which resulted in a loss of engine power during takeoff; failure of the pilot to abort the takeoff before lift-off; and failure of the pilot to…Jan 19, 1996 · N114AV · Substantial damageNTSB MIA96LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lake City, FLFailure of the pilot to select a fuel tank with adequate fuel for takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb, and improper flare by the pilot during the subsequent forced land.Jan 13, 1996 · N7498P · Substantial damageNTSB FTW96FA088Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Wichita Falls, TXThe inadvertent stall by the pilot in command. Factors were the impeded airplane takeoff performance, the rudder trim not corrected by the pilot, and the pilot's failure to comply with the checklist.Jan 13, 1996 · N8894E · DestroyedNTSB MIA96FA059Accident · Minor injuriesClass 1 · FieldFinal reportDouglas DC-9-32 · Nashville, TNthe flight crew's improper procedures and actions (failing to contact system operations/dispatch, failing to use all available aircraft and company manuals, and prematurely resetting the ground control relay circuit breakers) in response to an in-flight…Jan 7, 1996 · N922VV · Substantial damageNTSB SEA96LA037Accident · No injuriesLimited investigationFinal reportCessna 170B · Baker City, ORthe pilot's premature lift-off and inadequate airspeed following liftoff. His use of a public highway as a takeoff area, and a motor vehicle on the highway, were factors.Jan 2, 1996 · N2761D · Substantial damageNTSB ANC96LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Tanana, AKThe icing of the induction/intake screen and the pilot's improper planning/decision by electing to takeoff into suspended snow and ice crystals.Dec 30, 1995 · N4762B · Substantial damageNTSB CHI96LA069Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12 · Winner, SDthe pilot's failure to maintain airspeed during takeoff. A factor was the pilot's diversion of his attention to a perceived engine problem.Dec 29, 1995 · N39244 · Substantial damageNTSB LAX96LA084Accident · Minor injuriesLimited investigationFinal reportNicholson Sonerai II · Ramona, CAan interruption of fuel flow to the engine due to a misrouted fuel vent line.Dec 28, 1995 · N68676 · Substantial damageNTSB FTW96LA079Accident · No injuriesLimited investigationFinal reportMeyers MY-200A · Madill, OKthe deterioration of the fuel supply line resulting in line blockage, fuel starvation, and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.Dec 27, 1995 · N484C · Substantial damageNTSB FTW96LA077Accident · Minor injuriesLimited investigationFinal reportStinson ST-108-2 · Lake Dallas, TXthe failure of the #6 connecting rod assembly. A factor was the lack of suitable terrain for a forced landing which resulted in a water landing.Dec 27, 1995 · N135C · DestroyedNTSB LAX96FA080Accident · Minor injuriesField investigationFinal reportCessna 152 · Compton, CAa push rod failed from fatigue as a result of longitudinal stress corrosion cracking.Dec 26, 1995 · N6110Q · Destroyed