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 FTW90DRD14Accident · 1 fatalFinal reportGrumman G-164A · Sommerset, LAThe pilot's failure to attain adequate clearance above crops at the end of the runway.Jul 25, 1990 · N7854 · DestroyedNTSB LAX90FA265Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Apple Valley, CAImproper preflight planning/decision by the pilot. Factors related to the accident were: failue of the pilot to configure the aircraft's flaps for a soft field takeoff, his improper use of stabilator trim, high density altitude, soft runway, and trees near…Jul 24, 1990 · N41455 · DestroyedNTSB NYC90FA169Accident · Serious injuriesField investigationFinal reportDavid B. Robertson VARI-EZE · Cincinnati, OHA power loss due to improper installation of a fuel line fitting and inadequate maintenance and inspection.Jul 23, 1990 · N45DR · DestroyedNTSB CHI90DCG01Accident · Serious injuriesFinal reportGeorge R. Losey J6-KARATOO · Grain Valley, MOThe propeller blade separation during initial climb, and the failure of the pilot in command to maintain flying speed during the emergency descent.Jul 23, 1990 · N89BD · Substantial damageNTSB FTW90DRD13Accident · 1 fatalFinal reportde Havilland DH-82A · Youngsville, LAThe pilot's failure to touch down at the proper point on the landing surface. A contributing factor was the late initiation of the aborted landing.Jul 22, 1990 · N5984 · DestroyedNTSB MIA90LA157Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Plant City, FLEngine failure for undetermined reasons resulting in the forced landing.Jul 21, 1990 · N4429N · Substantial damageNTSB LAX90LA263Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Clarksburg, CAThe failure of the airplane's muffler during initial climb.Jul 21, 1990 · N1570J · Substantial damageNTSB FTW90DRA07Accident · 1 fatalFinal reportBensen B-8M · Hearne, TXThe pilot's loss of control in flight due to excessive control inputs and his abrupt attempts to recover control of the aircraft prior to impact.Jul 21, 1990 · N130MP · DestroyedNTSB CHI90DEE08Accident · No injuriesFinal reportRonald D. Cothern Quickie · Plainfield, ILSeparation of an ignition lead, resulting in loss of engine power. A factor in the accident was the pilot's inadequate preflight inspection.Jul 21, 1990 · N701RC · Substantial damageNTSB LAX90DVG12Accident · Serious injuriesFinal reportE.J. Novotny Steen Skybolt · Fall River Mill, CALoss of power for undetermined reasons.Jul 20, 1990 · N78EJ · Substantial damageNTSB CHI90IA181Incident · No injuriesIncident investigationFinal reportBell 206A · Lake Ozark, MOCompression assembly blade and emergency floatation gear failure.Jul 19, 1990 · N206AT · Minor damageNTSB ANC90LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-400 · Bettles, AKPilot-in-command's failure to attain airspeed during takeoff.Jul 19, 1990 · N8508P · Substantial damageNTSB LAX90LA259Accident · No injuriesLimited investigationFinal reportCessna 421C · Lancaster, CAThe accident was eroded ignition spark plug electrodes and maintenance personnel neglecting to adjust spark plug electrodes and maintenance personnel neglecting to adjust spark plug gap. The rough terrain in which the aircraft landed was a factor in the…Jul 18, 1990 · N6089X · Substantial damageNTSB ANC90LA119Accident · No injuriesLimited investigationFinal reportBell 206B · Goodnews Bay, AKThe pilot selected unsuitable terrain. The wet & soft tundra was a factor.Jul 18, 1990 · N4796B · Substantial damageNTSB NYC90LA163Accident · No injuriesLimited investigationFinal reportBellanca 17-31A · Wilmington, OHA power loss caused by fuel exhaustion when the pilot took off with the fuel selector on the empty fuel tank.Jul 16, 1990 · N93666 · Substantial damageNTSB FTW90DPG03Accident · No injuriesFinal reportGrumman G164-A · Rondo, ARThe power loss for undetermined reasons.Jul 16, 1990 · N7802 · Substantial damageNTSB CHI90LA175Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Tecumseh, MIA loss of engine power due to unknown reasons.Jul 15, 1990 · N8854M · Substantial damageNTSB NYC90LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Shirley, NYThe pilot's lack of qualifications, the improper use of flight controls, the second pilot's lack of qualifications, and his decision to simulate the engine failure.Jul 14, 1990 · N44HH · Substantial damageNTSB NYC90LA158Accident · No injuriesLimited investigationFinal reportCessna 182 · Liverpool, OHThe pilot in command's failure to detect contaminated fuel by draining the fuel system prior to takeoff resulting in engine failure and a forced landing.Jul 14, 1990 · N92839 · Substantial damageNTSB DEN90LA164Accident · No injuriesLimited investigationFinal reportMooney M20F · Torrington, WYA partial loss of power due to a failed exhaust valve. A factor was the lack of suitable terrain for the forced landing.Jul 14, 1990 · N6456Q · Substantial damageNTSB CHI90LA186Accident · Minor injuriesLimited investigationFinal reportCessna 152 II · Grand Marais, MNUndetermined partial loss of engine power during the initial climbout. A factor was the lack of suitable terrain for a forced landing.Jul 14, 1990 · N21LA · Substantial damageNTSB DEN90FA161Accident · 2 fatalField investigationFinal reportCessna 150L · Hettinger, NDThe pilot's failure to maintain airspeed during climbout. Contributing factors were: the pilot's lack of recent experience, and the over maximum gross weight condition of the aircraft.Jul 13, 1990 · N11580 · DestroyedNTSB ANC90FA116Accident · Minor injuriesField investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's failure to maintain flying speed during climbout which resulted in a stall.Jul 13, 1990 · N1756A · Substantial damageNTSB CHI90DER01Accident · No injuriesFinal reportPiper PA-28-140 · New Richmond, WIThe pilot's inadequate preflight inspection, which resulted in the gascolator drain being left open.Jul 12, 1990 · N5330F · Substantial damageNTSB NYC90LA183Accident · No injuriesLimited investigationFinal reportCessna 310R · Mansfield, OHAn unavoidable collision with a deer while taking off which bent the drag brace and prevented it from locking. Factors related to the accident were the night conditions which reduced the pilots visibility to the illuminated area of the landing lights.Jul 11, 1990 · N3463G · Substantial damageNTSB LAX90FA250Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Pleasant Valley, AZAn inadvertent spin after failure to maintain airspeed. Factors include inadequate preflight, and an improperly maintained lap belt.Jul 11, 1990 · N6763Z · Substantial damageNTSB MIA90LA150Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · ChristianstedThe failure of the pilot to evaluate weight, temperature, and power available prior to takeoff and then performing a left pedal turn after takeoff resulting in the helicopter desending even though full power was applied.Jul 10, 1990 · N2284U · Substantial damageNTSB DEN90FA155Accident · Serious injuriesField investigationFinal reportCessna 170 · Fillmore, UTThe pilot's failure to maintain airspeed which resulted in inadvertent stall.Jul 10, 1990 · N4068V · Substantial damageNTSB CHI90DEP07Accident · No injuriesFinal reportBell 47-G2 · Hatley, WIThe partial loss of power due to sticking intake valves.Jul 10, 1990 · N6768D · Substantial damageNTSB ATL90FA141Accident · 1 fatalField investigationFinal reportCessna 150G · Lanett, ALFailure of the pilot to maintain adequate airspeed, which resulted in a stall.Jul 9, 1990 · N2947S · Substantial damageNTSB SEA90FA125Accident · Serious injuriesField investigationFinal reportCessna T210K · Everett, WAInadequate preflight by the pilot by not assuring that the rudder pedals were properly engaged. A factor related to the accident was: the pilot's lack of familiarity with this make and model of aircraft.Jul 8, 1990 · N9407M · DestroyedNTSB SEA90LA124Accident · No injuriesLimited investigationFinal reportPiper J-2 · Concrete, WAThe pilot's improper planning/decisions and failure to maintain clearance from the trees.Jul 5, 1990 · N19236 · Substantial damageNTSB ATL90LA140Accident · No injuriesLimited investigationFinal reportBeech C24R · Brunswick, NCEngine malfunction for undetermined reasons. A factor in the accident was the unseen ditch with which the airplane collided.Jul 5, 1990 · N2249L · Substantial damageNTSB ANC90FA111Accident · No injuriesField investigationFinal reportCessna 170B · Anchorage, AKThe pilot-in-command's failure to maintain airspeed on initial climbout.Jul 4, 1990 · N3261A · Substantial damageNTSB ANC90LA110Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cantwell, AKThe pilot failed to understand the performance parameters of the airplane and his lack of total experience. A contributing factor to the accident was operating the airplane at a greater than allowable gross weight.Jul 3, 1990 · N25759 · Substantial damageNTSB ANC90LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKThe pilot inadvertently stalled the airplane.Jul 3, 1990 · N4878A · Substantial damageNTSB LAX90FA235Accident · 3 fatalField investigationFinal reportCessna 177 · Lake Havasu, AZThe pilot's inflight loss of control due to failure to maintain adequate airspeed. Contributing to the accident was the high density altitude, overweight airplane, and the pilot's alcohol level.Jul 2, 1990 · N2307Y · DestroyedNTSB ANC90FA105Accident · 2 fatalField investigationFinal reportCessna 185 · Iliamna, AKThe pilot's failure to follow proper procedures and directives (excessive flaps); failure to operate the airplane within the allowable gross weight limitations; improper compensation for wind conditions and failure to maintain minimum safe flying speed,…Jul 2, 1990 · N185KA · Substantial damageNTSB MKC90FA142Accident · Serious injuriesField investigationFinal reportCessna T210M · Kiowa, KSThe pilot's failure to maintain control of the airplane during takeoff.Jul 1, 1990 · N1273M · DestroyedNTSB MIA90LA147Accident · No injuriesLimited investigationFinal reportCessna 150F · Pensacola, FLInstructor pilots failure to assure that the flaps were in the proper position for takeoff resulting in reduced climb performance. This resulted in the forced landing, during which, the airplane collided with a power line, stalled, then crashed to the ground.Jun 30, 1990 · N7048B · Substantial damageNTSB FTW90FA126Accident · Minor injuriesField investigationFinal reportCessna C172 · Fort Worth, TXFailure of the pilot to follow published procedures when he elected to take-off with full flaps.Jun 30, 1990 · N179FR · Substantial damageNTSB CHI90LA164Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Cornell, WIThe pilot's inadequate preflight resulted in a loss of engine power due to contamination in the fuel system.Jun 30, 1990 · N41RP · DestroyedNTSB NYC90LA141Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Lawrence, MAThe failure of the pilot to maintain control of the airplane with an open door. Factors related to the accident was the failure of the pilot to maintain airspeed and the door opening at liftoff.Jun 29, 1990 · N67990 · DestroyedNTSB LAX90LA218Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82A · Sonoma, CAThe pilot failed to maintain airspeed causing the airplane to inadvertently enter into a stall/mush condition.Jun 29, 1990 · N7966 · DestroyedNTSB LAX90DUA01Accident · Minor injuriesFinal reportHomebuilt JP-350-1 · Torrance, CAThe aircraft collision with the ground after the pilot experienced a loss of engine thrust due to propeller overspeed condition. Contributing to the accident was the pilot's improper servicing of the propeller hub that allowed the overspeed to occur.Jun 28, 1990 · N350JP · Substantial damageNTSB DEN90LA146Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edgeley, NDA momentary power interruption during initial climb for unknown reasons.Jun 28, 1990 · N6887Q · Substantial damageNTSB SEA90LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Reno, NVThe pilot's use of an inappropriate runway. The gusty tailwind and the pilot's lack of experience were factors related to the accident.Jun 27, 1990 · N64845 · Substantial damageNTSB MKC90LA139Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARFailure of the engine driven blower assembly. A factor was the lack of suitable terrain for the forced landing.Jun 27, 1990 · N5203 · Substantial damageNTSB DEN90LA145Accident · Minor injuriesLimited investigationFinal reportGrumman AA5B · Monte Vista, COThe pilot's premature rotation and liftoff.Jun 27, 1990 · N28421 · DestroyedNTSB MIA90FA145Accident · 2 fatalField investigationFinal reportPiper PA-31 · Panama City, FLA loss of power on both engines during takeoff as a result of inadequate maintenance. In addition, the pilot failed to abort the takeoff.Jun 26, 1990 · N18PA · Destroyed