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 FTW98LA292Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Lubbock, TXThe loss of engine power due to the collapsed of the engine induction air ducting. Factors were the inadequate maintenance inspection and the lack of suitable terrain for the pilot to execute the forced landing.Jul 2, 1998 · N8866H · Substantial damageNTSB CHI98LA233Accident · Minor injuriesLimited investigationFinal reportWicks FLY Baby · Blissfield, MIthe pilot's misjudging of the fuel supply and his inadequate aircraft preflight. A factor was fuel exhaustion,Jul 2, 1998 · N40349 · Substantial damageNTSB FTW98FA291Accident · 1 fatalField investigationFinal reportCessna 140A · Edgewood, TXThe pilot's failure to maintain minimum required airspeed for flight. Factors were the worn fuel line, which separated, and the failure of the maintenance personnel to locate the worn fuel line during the annual inspection.Jul 1, 1998 · N9689A · Substantial damageNTSB LAX98FA208Accident · 1 fatalField investigationFinal reportFrandsen Midget Mustang MM-1 · Tracy, CAinadequate maintenance/inspection by the owner/pilot that resulted in an obstructed fuel vent system and a subsequent loss of engine power during takeoff.Jun 30, 1998 · N76JF · DestroyedNTSB FTW98LA285Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Uvalde, TXThe pilot's improper use of the flaps which resulted in an inadvertent stall during the initial takeoff climb. Factors were his lack of recent experience in the make and model of airplane and the high density altitude.Jun 28, 1998 · N8445J · Substantial damageNTSB CHI98LA227Accident · Minor injuriesLimited investigationFinal reportCommonwealth 185 · Oregon, WIthe improper adjustment of the carburetor by an unqualified person. Factors to the accident were the annual inspection not being complied with and the lack of recent experience of the pilot.Jun 28, 1998 · N92997 · Substantial damageNTSB CHI98LA226Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Osceola, WIthe student pilot's incomplete preflight, and the instructor pilot's inadequate supervision of the student's preflight. Factors were the fuel contaminated with water, and the roadway encountered during the forced landing rollout.Jun 28, 1998 · N50433 · Substantial damageNTSB SEA98LA111Accident · No injuriesLimited investigationFinal reportKoster Murphy Rebel · Arlington, WAThe pilot/builder's attachment inadequate installation of the aileron control pushrods to the control stick assembly, resulting in the ailerons deflecting in a direction opposite of the input applied by the pilot. Also causal was the pilot's inadequate…Jun 27, 1998 · N265KK · Substantial damageNTSB SEA98LA106Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Oakdale, WAA fatigue failure of the number three cylinder exhaust rocker box assembly, compromising the ability of the exhaust valve to operate. Factors include a ditch at the end of the runway.Jun 27, 1998 · N7502C · Substantial damageNTSB MIA98LA190Accident · Serious injuriesLimited investigationFinal reportAviat A-1A · Daytona Beach, FLThe pilot's failure to maintain airspeed, which resulted in a stall. A contributing factor was the pilot's delay in initiating remedial action.Jun 27, 1998 · N32HU · Substantial damageNTSB LAX98LA214Accident · No injuriesLimited investigationFinal reportCessna 172 · Flagstaff, AZOil system contamination with an unidentified metal substance that traveled through the oil system and blocked the number 4 main bearing and number 6 connecting rod bearing oil ports, resulting in oil starvation and failure of the engine. The source of the…Jun 27, 1998 · N7188A · Substantial damageNTSB CHI98LA224Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Liberal, KSthe inadvertent stall, the pilot's inadequate preflight planning, which led to performing a takeoff with insufficient distance to clear the utility pole. A factor which contributed to this accident was the utility pole.Jun 27, 1998 · N8903W · DestroyedNTSB LAX98LA212Accident · No injuriesLimited investigationFinal reportNorth American Navion · San Andreas, CAThe pilot's improper reinstallation of the fuel selector valve handle, which led to the selection of the wrong fuel tank and fuel starvation.Jun 26, 1998 · N1400Z · Substantial damageNTSB CHI98LA223Accident · No injuriesLimited investigationFinal reportRockwell S2-R · Williams, MNthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Jun 26, 1998 · N5682X · Substantial damageNTSB CHI98LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ipswich, SDthe pilot's inadequate evaluation of the weather conditions and his failure to maintain aircraft control which resulted in a stall/mush. Factors associated with the accident were the tailwind condition and the soft terrain.Jun 25, 1998 · N31677 · Substantial damageNTSB CHI98LA218Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Park Rapids, MNthe pilot's failure to maintain control of aircraft. Factors were the congested helipad conditions and wind gusts.Jun 24, 1998 · N86663 · Substantial damageNTSB CHI98LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rush City, MNthe pilot inadvertently stalled the airplane during the initial takeoff climb. Factors associated with the accident were the pilot's inattentiveness at lowering excessive flaps for takeoff.Jun 22, 1998 · N8450J · DestroyedNTSB CHI98LA211Accident · Minor injuriesLimited investigationFinal reportHartzler Nieuport 11 · Gardner, KSthe pilot's inadequate weather evaluation and the aircraft stall. A factor to the accident was the gusting wind.Jun 21, 1998 · N921DH · Substantial damageNTSB CHI98LA213Accident · No injuriesLimited investigationFinal reportCessna 310N · Janesville, WIother maintenance personnel not installing nose landing gear door linkage. Factors were the unsecured landing gear door, the nose landing gear becoming jammed and the gear extension not possible by the pilot.Jun 20, 1998 · N5030Q · Substantial damageNTSB FTW98LA270Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Douglas, WYThe pilot's inadequate judgement in attempting to takeoff from unsuitable rough terrain.Jun 17, 1998 · N8531L · Substantial damageNTSB LAX98LA200Accident · 2 fatalLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The improper shimmying of the tail rotor driveshaft by maintenance personnel which induced fatigue in the tail rotor driveshaft coupling causing it to fail, which resulted in a loss of tail rotor control. A factor is the failure of the pilot to recognize the…Jun 16, 1998 · N95MS · DestroyedNTSB SEA98LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Blackfoot, IDA loss of power for undetermined reasons.Jun 15, 1998 · N8553L · DestroyedNTSB ANC98LA073Accident · No injuriesLimited investigationFinal reportLake LA-4 · Saint Mary'S, AKThe pilot's diverted attention during takeoff, and his failure to maintain a proper climb rate. A factor associated with the accident was the presence of birds.Jun 15, 1998 · N19AK · Substantial damageNTSB SEA98LA096Accident · No injuriesLimited investigationFinal reportCessna 172R · Independence, ORA loss of power due to fatigue failure and cracking of an engine cylinder barrel.Jun 14, 1998 · N9514P · Substantial damageNTSB FTW98LA266Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Mcgehee, ARA loss of engine power for undetermined reasons.Jun 13, 1998 · N4911R · Substantial damageNTSB ANC98LA081Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Homer, AKThe loss of engine power due to fuel starvation, and an improper fuel selector valve. Factors in the accident were turbulent wind conditions, the improper replacement of the fuel selector valve by an airplane mechanic, and the failure of an FAA inspector to…Jun 12, 1998 · N1023H · Substantial damageNTSB NYC98FA127Accident · 3 fatalField investigationFinal reportPiper 601P · Martinsburg, PAThe pilot's failure to maintain airspeed due to spatial disorientation, which resulted in an inadvertent stall and subsequent collision with terrain. A factor in the accident was the low ceiling.Jun 10, 1998 · N60721 · DestroyedNTSB FTW98LA261Accident · Minor injuriesLimited investigationFinal reportGisclair Murphy Renegade SP · Galliano, LAA loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.Jun 10, 1998 · N96VG · DestroyedNTSB LAX98LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · El Cajon, CAThe certified flight instructor's inadequate preflight which led to fuel exhaustion and subsequent loss of engine power. A related factor was the unsuitable terrain.Jun 7, 1998 · N84451 · Substantial damageNTSB CHI98LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harrison, NEthe pilot's improper positioning of the magneto switch and his improper use of the mixture control.Jun 6, 1998 · N4541R · Substantial damageNTSB MIA98LA192Accident · No injuriesLimited investigationFinal reportCessna 310K · Opa-Locka, FLThe fuel leak due to improper installation of the left auxiliary fuel tank by maintenance personnel. Also, inadequate annual inspection of the airplane by maintenance personnel for failure to identify the missing screw from the adel clamp resulting in chafing…Jun 5, 1998 · N366J · Substantial damageNTSB CHI98LA186Accident · Minor injuriesLimited investigationFinal reportSheets Kitfox II · Greenfield, IAthe initial climb airspeed not obtained/maintained after liftoff by the pilot in command. A factor was the improper compensation for wind conditions by the pilot in command.Jun 2, 1998 · N487JS · DestroyedNTSB CHI98LA188Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Norfolk, NEthe pilot's misjudged wind conditions and his not obtaining/maintaining compensation for wind conditions. A factor was a sudden wind shift.Jun 1, 1998 · N6847E · DestroyedNTSB LAX98LA178Accident · Serious injuriesLimited investigationFinal reportFields Baby Belle · Inyokern, CAThe failure of the pilot to recover from a low rotor rpm condition, which resulted in a loss of aircraft control.May 31, 1998 · N656VK · DestroyedNTSB FTW98LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Balko, OKThe pilot's inadequate preflight planning which failed to assure adequate climb performance to clear an obstacle (fence) during takeoff climb.May 31, 1998 · N200HA · Substantial damageNTSB CHI98LA183Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Montague, MIthe pilot's improper use of carburetor heat which resulted in the formation of carburetor ice and the loss of engine power. Factors to the accident were the carburetor icing conditions and the trees.May 30, 1998 · N1968K · Substantial damageNTSB FTW98LA242Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Roanoke, TXThe loss of engine power resulting from an excessively rich mixture for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.May 29, 1998 · N9606U · Substantial damageNTSB CHI98LA179Accident · No injuriesLimited investigationFinal reportCessna 177RG · Tocsin, INthe pilot's failure to obtain adequate airspeed during the takeoff climb and the resulting inadvertant stall. A factor in the accident was the pilot's premature raising of the flaps.May 28, 1998 · N1849Q · Substantial damageNTSB CHI98LA178Accident · Minor injuriesLimited investigationFinal reportCessna 414 · North Platte, NEthe slipped number two bearing in the airplane's right engine, which blocked the bearing's oil feed line, causing the bearing and the crankshaft to overheat and fracture. A factor contributing to this accident was the trees.May 28, 1998 · N888AA · DestroyedNTSB FTW98FA239Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Springdale, ARThe failure of maintenance personnel to properly assemble the engine's accessory gearbox, which resulted in a total loss of engine power due to partial blockage of the main oil passage by an o-ring. The blockage reduced oil flow to the turbine shafting, which…May 24, 1998 · N27AE · Substantial damageNTSB CHI98LA173Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Augusta, KSthe pilot's inadequate evaluation of the current local weather conditions and his failure to maintain a climb after takeoff. Factors related to the accident were the fog, the powerlines, and spatial disorientation.May 24, 1998 · N5247J · Substantial damageNTSB CHI98LA170Accident · 2 fatalLimited investigationFinal reportKreatz Genesis · Maple Lake, MNthe pilot inadvertently stalled the airplane. A factor was the failed reduction drive belts.May 21, 1998 · N68474 · DestroyedNTSB CHI98LA158Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffith, INThe aircraft's speed not maintained by the pilot, which resulted in the aircraft stalling in close proximity to the ground.May 21, 1998 · N2916J · Substantial damageNTSB CHI98LA160Accident · Serious injuriesLimited investigationFinal reportPitts S-2A · Benton, KSthe pilot did not flare the airplane properly during the forced landing. A factor was the engine failure for undetermined reasons.May 18, 1998 · N31517 · Substantial damageNTSB NYC98LA110Accident · 1 fatalLimited investigationFinal reportCessna 337B · Montgomery, NYthe pilot's improper decision to initiate a takeoff with the rear engine inoperative, which resulted in an airplane that could not climb sufficiently to clear obstacles (trees).May 17, 1998 · N5471S · Substantial damageNTSB LAX98LA162Accident · No injuriesLimited investigationFinal reportSchweizer G164D · Richvale, CAThe separation of four compressor/turbine blades resulting in a sudden loss of engine power with a subsequent forced landing into unsuitable terrain.May 17, 1998 · N8177K · DestroyedNTSB IAD98FA059Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Fort Washington, MDThe pilot's failure to maintain adequate airspeed, which resulted in a stall and collision with trees.May 17, 1998 · N4537R · DestroyedNTSB FTW98LA225Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Parkin, ARthe pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees at the departure end of the airstrip. Related factors were: high density altitude and trees at the departure end of the airstrip.May 17, 1998 · N502JF · DestroyedNTSB CHI98LA161Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Manhattan, KSthe pilot did not attain proper flying speed. Factors included the high density altitude and crosswind condition.May 17, 1998 · N954OU · Substantial damageNTSB CHI98FA165Accident · 2 fatalField investigationFinal reportCessna 172 · S. Sioux City, NEThe pilot's failure to maintain adequate flying airspeed during the climbing left turn resulting in a stall condition. Contributing factors were the gusty, crosswind conditions, and the pilot's excessively tight turn maneuver during the initial climb.May 17, 1998 · N8919B · Destroyed