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 NYC98LA118Accident · No injuriesLimited investigationFinal reportMorrison Rans S-12 · Gum Spring, VAA loose/partially disconnected engine intake fuel line which resulted in a loss of engine power, and the pilot's delayed (late) flare prior to touchdown.May 16, 1998 · N91337 · Substantial damageNTSB IAD98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Princeton, NJA stuck carburetor float which restricted fuel flow to the engine that resulted in a loss of engine power.May 16, 1998 · N56969 · Substantial damageNTSB FTW98FA216Accident · 3 fatalField investigationFinal reportBeagle B-206 · Vernon, TXThe pilot's failure to maintain the airplane's minimum controllable airspeed following a loss of left engine power after takeoff, which resulted in a loss of control. Contributing factors were the fractured exhaust valve guide on the left engine's # 2…May 16, 1998 · N1885S · DestroyedNTSB NYC98LA109Accident · Minor injuriesLimited investigationFinal reportDeberry Marquart MA-5 · Westminster, MDFailure of a fuel line fitting which led to an engine failure and fire. A factor was the lack of suitable terrain for the forced landing.May 15, 1998 · N83MC · DestroyedNTSB LAX98LA159Accident · No injuriesLimited investigationFinal reportBell 206B · Temecula, CAA loss of engine power due to a deteriorated compressor air seal which resulted in the fracture and separation of several stator vanes. Deterioration was not detected as a result of an inadequate maintenance inspection frequency.May 15, 1998 · N90215 · DestroyedNTSB ATL98FA076Accident · Serious injuriesField investigationFinal reportBeech BE-45-T-34B · Montgomery, ALThe installation of an incorrect engine nose seal that subsequently dislodged from the normally installed position, and resulted in the loss of engine power. A factor was the loss of engine oil.May 14, 1998 · N9280Z · DestroyedNTSB MIA98LA160Accident · 2 fatalLimited investigationFinal reportM2 Sport 1000 · Semmes, ALThe pilot's failure to maintain control of the aircraft after an encounter with turbulence during initial climb out. A related factor was the turbulence.May 13, 1998 · UNREG · DestroyedNTSB CHI98LA146Accident · No injuriesLimited investigationFinal reportDangremond Challenger II · Wayland, MIthe pilot's improper installation of the right wing forward strut attachment bolt.May 12, 1998 · N199DD · DestroyedNTSB CHI98LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hannibal, MOa loss of engine power due to undetermined reasons. A factor was the rough field in which the forced landing was made.May 11, 1998 · N733HY · Substantial damageNTSB FTW98LA213Accident · No injuriesLimited investigationFinal reportBeech A-36 · Ruidoso, NMInadvertent post departure stall. A factor was high gusty winds.May 10, 1998 · N6150X · Substantial damageNTSB FTW98LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Georgetown, TXinadequate supervision by the flight instructor (CFI), by failing to ensure that the student obtained and/or maintained sufficient airspeed, which led to an inadvertent stall and collision with the terrain.May 10, 1998 · N99570 · Substantial damageNTSB FTW98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe loss of engine power due to water contamination of the fuel. A factor was the lack of suitable terrain available for the forced landing.May 10, 1998 · N67326 · Substantial damageNTSB SEA98LA073Accident · No injuriesLimited investigationFinal reportAero Commander 500-A · Billings, MTFailure of the main landing gear strut outer-body to inner-body needle bearing from the lack of lubrication and the development of corrosion. An inadequate manufacturer's inspection program was a factor.May 9, 1998 · N9382R · Substantial damageNTSB CHI98LA140Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Omaha, NEThe fatigue failure of the crankshaft which resulted from a spun bearing and the low altitude at which the loss of engine power occurred. A factor in the accident was the embankment on which the airplane was landed.May 5, 1998 · N24435 · Substantial damageNTSB NYC98IA106Incident · No injuriesIncident investigationFinal reportBeech 1900D · Syracuse, NYImproper maintenance which resulted in a cross threaded\ mistapped counterweight bolt hole, and the subsequent failure of the propeller counterweight clamp assembly. Also causal was the inadequate inspection of the counterweight clamp threads by maintenance…May 4, 1998 · N832CA · Minor damageNTSB ATL98LA071Accident · Serious injuriesLimited investigationFinal reportBellanca 7-GCBC · Sebring, FLThe pilot's improper handling of the airplane which led to an inadvertent stall. A factor was the loss of engine power for undetermined reasons.May 3, 1998 · N4ME · DestroyedNTSB FTW98LA202Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Levelland, TXthe pilot's inaccurate weather evaluation, subsequent encounter with a severe downdraft, and failure (or inability) to compensate for the wind (downdraft) condition. The high density altitude was a related factor.May 1, 1998 · N459U · DestroyedNTSB CHI98IA169Incident · No injuriesIncident investigationFinal reportDouglas DC-9-34 · St. Louis, MOthe yaw rate gyro of the Stab Aug Computer had been installed in a reverse position that was 180 degrees opposite from the correct position.Apr 30, 1998 · N928L · No damageNTSB LAX98LA147Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Maricopa, AZThe pilot's loss of control in flight for undetermined reasons.Apr 28, 1998 · N34187 · Substantial damageNTSB ATL98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Tampa, FLIn-flight collision with a bird, which separated a fuel line causing a loss of engine power, and resulting in an emergency landing on unsuitable terrain.Apr 28, 1998 · N2125N · Substantial damageNTSB NYC98LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · New Bedford, MAThe pilot's impairment due to alcohol, which resulted in an inadequate preflight examination and subsequent takeoff with a control lock installed.Apr 26, 1998 · N15326 · Substantial damageNTSB MIA98LA144Accident · No injuriesLimited investigationFinal reportPiper PA-18 · St. Petersburg, FLThe intentional operation of the airplane by the pilot and the company/operator with the known deficiencies in equipment (worn carburetor). Also, the poor preflight planning by the pilot for his failure to recognize that the carburetor heat control was…Apr 26, 1998 · N225NY · Substantial damageNTSB ANC98LA042Accident · No injuriesLimited investigationFinal reportCessna 172M · Anchor Point, AKThe pilot's failure to compensate for a crosswind. A related factor was the crosswind.Apr 26, 1998 · N8969V · Substantial damageNTSB FTW98FA190Accident · 2 fatalField investigationFinal reportCessna 150H · Parowan, UTThe pilot's failure to maintain sufficient airspeed and the subsequent inadvertent stall/spin. Factors were the high density altitude, the high, gusty wind condition, and the diverted attention of the pilot.Apr 23, 1998 · N50385 · DestroyedNTSB SEA98LA066Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Colstrip, MTThe pilot's operation of the aircraft above maximum gross weight, resulting in her inability to attain a sustained climb rate after becoming airborne. A factor was high density altitude conditions.Apr 22, 1998 · N2777H · Substantial damageNTSB FTW98FA189Accident · 2 fatalField investigationFinal reportCessna 150F · Muskogee, OKThe inadvertent stall as result of the pilot's failure to retract the flaps from the fully extended position prior to takeoff. Factors were the gusting winds and the pilot's failure to follow the before takeoff checklist.Apr 21, 1998 · N8720G · DestroyedNTSB SEA98LA064Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Sedro Wooley, WAFuel contamination and subsequent carburetor fuel flow restriction initiated by the use of an improper material (incorrect fuel hose). A factor was the trees.Apr 20, 1998 · N80SD · DestroyedNTSB CHI98FA130Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Kalamazoo, MIThe pilot's failure to maintain adequate flying airspeed resulting in a stall condition. Contributing factors were the tailwind condition and the pilot's exceeding the gross weight of the airplane on takeoff.Apr 20, 1998 · N1762J · DestroyedNTSB CHI98LA131Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Canton, MIThe undetermined loss of power reported by the pilot. Contributing factors were the residential nature of the landing area and unsuitable landing terrain.Apr 18, 1998 · N50566 · Substantial damageNTSB CHI98LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Barrington Hill, ILThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent in-flight collision with trees.Apr 14, 1998 · N6300E · Substantial damageNTSB IAD98FA044Accident · 2 fatalField investigationFinal reportPiper PA-20 · Beaver Falls, PAThe pilot's failure to maintain aircraft control, and his failure to attain adequate airspeed, which resulted in a stall. Contributing was the pilot's lack of familiarity with the airplane, and his misjudgment of wind information which resulted in a tailwind…Apr 12, 1998 · N2336A · DestroyedNTSB CHI98IA167Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD82 · Washington, DCThe failure of the Dual Axis Accelerometer.Apr 11, 1998 · N951U · No damageNTSB NYC98FA092Accident · 1 fatalField investigationFinal reportAerostar 600A · Mapleton, MEthe failure of the pilot to maintain control of the airplane during takeoff for undetermined reasons.Apr 10, 1998 · N7527S · DestroyedNTSB LAX98LA134Accident · Minor injuriesLimited investigationFinal reportBell OH-58A · Huron, CAA loss of engine power due to deteriorated O-ring seals in the fuel boost pump, which allowed air to enter the fuel lines. Factors in the accident were the inadequate manufacturer's inspection criteria for the fuel boost pump O-ring seals and the resulting…Apr 9, 1998 · N176SJ · Substantial damageNTSB FTW98LA178Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Del Rio, TXa loss of engine power on the right engine for undetermined reasons, and the pilot's failure to maintain control of the airplane.Apr 9, 1998 · N2083C · Substantial damageNTSB IAD98FA042Accident · 1 fatalField investigationFinal reportPiper PA-30 · Mcmechen, WVThe pilot's inadequate pre-flight planning and preparation which resulted in fuel exhaustion during takeoff.Apr 5, 1998 · N7845Y · DestroyedNTSB FTW98LA171Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cushing, OKThe total loss of engine power resulting from a sheared accessory drive due to an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Apr 4, 1998 · N8984Q · Substantial damageNTSB SEA98LA059Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Hillsboro, ORThe flight instructor's inadequate supervision and the dual student's premature lift off which resulted in inadequate airspeed, a stall, and collision with the ground.Apr 1, 1998 · N1310A · Substantial damageNTSB LAX98LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Sonoma, CAThe instructor pilot's inadequate in-flight planning/decision and subsequent inadequate supervision of the situation to simulate an engine failure on takeoff, as well as both pilot's not maintaining a visual lookout. A related factor was the diverted…Mar 26, 1998 · N2952J · Substantial damageNTSB FTW98LA160Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Fort Worth, TXThe separation of the aileron control rod due to bending overstress. A factor was the unsuitable terrain available for the precautionary landing.Mar 26, 1998 · N5530M · Substantial damageNTSB FTW98FA165Accident · 2 fatalField investigationFinal reportVelocity 173 RG Elite · N. Little Rock, ARInadequate fusion between the valve stem and head due to inadequate quality control during construction of the exhaust valve for the number three cylinder. A contributing factor was the lack of suitable terrain for the forced landingMar 26, 1998 · N173VE · DestroyedNTSB FTW98LA159Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Norman, OKThe pilot's improper compensation for wind conditions, which resulted in a loss of directional control and collision with a ditch. A contributing factor was the high crosswind.Mar 25, 1998 · N2044N · Substantial damageNTSB MIA98LA103Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Tampa, FLfailure of the student pilot to maintain directional control of the airplane and proper runway alignment, which result in an in-flight collision with a hangar.Mar 22, 1998 · N2321D · Substantial damageNTSB ATL98FA059Accident · Serious injuriesField investigationFinal reportPiper PA-31-310 · Southport, NCThe pilot's failure to follow the preflight checklist, which resulted in a loss of engine power due to fuel starvation. Contributing to the significance of the accident was the pilot's failure to maintain control of the aircraft following the loss of engine…Mar 22, 1998 · N715PM · DestroyedNTSB LAX98LA124Accident · No injuriesLimited investigationFinal reportCessna 210K · Fallon, NVThe aircraft owner/pilot's improper assembly of the engine oil pump, which resulted in failure of the unit and oil starvation failure of the engine. A factor was the lack of supervision of the owner/pilot's work by the A & P mechanic.Mar 19, 1998 · N8274M · Substantial damageNTSB LAX98LA122Accident · No injuriesLimited investigationFinal reportCessna TU206F · Avalon, CAContamination of the fuel system which led to a loss of engine power. Factors were the lack of suitable terrain for the forced landing and the barbwire fence.Mar 19, 1998 · N9674G · Substantial damageNTSB FTW98TA152Accident · Serious injuriesFinal reportBell OH-58C · Dulce, NMThe partial loss of engine power due to a disconnected bleed air line to the fuel controller and the unsuitable terrain for a forced landing. Factors were the loose B-nut, the inadequate maintenance by unknown personnel, insufficient standards/requirements…Mar 19, 1998 · N505JA · Substantial damageNTSB LAX98FA119Accident · Minor injuriesField investigationFinal reportBeech A35 · Auburn, CAfailure of the engine driven fuel pump drive coupling and the pilot's failure to perform the emergency procedure specified in the Pilot Operating Handbook.Mar 17, 1998 · N8597A · Substantial damageNTSB LAX98FA113Accident · 4 fatalField investigationFinal reportBeech B95A · Little River, CAthe pilot's inadvertent visual flight into instrument meteorological conditions. Contributing to the accident was the pilot's improper weather evaluation.Mar 15, 1998 · N569T · DestroyedNTSB CHI98LA105Accident · Minor injuriesLimited investigationFinal reportAero Commander 680FLP · Fond Du Lac, WIthe pilot's misjudged weather evaluation . Factors were turbulence, the pilot's inability to attain a proper climb rate, unsuitable terrain encountered in the landing area, and crops.Mar 13, 1998 · N777MX · Substantial damage