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 LAX97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Furnace Creek, CAFuel starvation resulting from disconnection of the fuel selector valve. Factors which contributed to the accident were the pilot's intentional operation with known airplane deficiencies and the rough terrain.Apr 5, 1997 · N2294D · Substantial damageNTSB IAD97LA061Accident · Minor injuriesLimited investigationFinal reportTheis Quickie · Fostoria, OHa disconnect of electrical wires to the engine ignition, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: the lack of suitable terrain for a forced landing, and the wheat (crop) that was encountered during…Apr 2, 1997 · N53ET · Substantial damageNTSB LAX97LA139Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Mokuleia, HIAn unintentional stall for undetermined reasons.Apr 1, 1997 · N3652U · DestroyedNTSB MIA97LA112Accident · Serious injuriesLimited investigationFinal reportCharles J. Keuthan Zephyr II · Bunnell, FLInadvertent stall/mush by the pilot while maneuvering for a forced landing. Contributing to the accident was the partial loss of engine power due to a partial failure of the top compression ring of one of the cylinders.Mar 31, 1997 · N52958 · Substantial damageNTSB MIA97LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · St Matthews, SCthe pilot's improper decision to take off downwind with gusty wind conditions.Mar 31, 1997 · N738NC · Substantial damageNTSB IAD97LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Cincinnati, OHthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during takeoff, which resulted in a collision with tree(s) and a ditch.Mar 31, 1997 · N73455 · Substantial damageNTSB FTW97LA147Accident · No injuriesLimited investigationFinal reportBeech M35 · Iowa Park, TXThe pilot's refueling of the airplane with automotive grade fuel which resulted in engine failure due to detonation. A factor was the lack of suitable terrain for the forced landing.Mar 30, 1997 · N223C · Substantial damageNTSB LAX97LA133Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Sacaton, AZthe pilot's improper use of the collective by not maintaining rotor rpm during takeoff from a confined area.Mar 27, 1997 · N294SB · Substantial damageNTSB CHI97FA093Accident · 1 fatalField investigationFinal reportStinson 108 · Greenfield, INa loss of engine power due to restricted movement in the exhaust valve and rotted/weathered ignition harness, and the pilot's failure to maintain airspeed which resulted in an inadvertant stall.Mar 27, 1997 · N97120 · DestroyedNTSB ANC97LA042Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Grayling, AKThe partial loss of engine power due to a fractured connecting rod bolt, which was precipitated by fatigue. A factor associated with the accident was the snow covered terrain in the emergency landing site.Mar 27, 1997 · N1747U · Substantial damageNTSB CHI97LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Leavenworth, KSfatigue failure and separation of the number 2 cylinder. A factor was the rough terrain.Mar 26, 1997 · N6359M · Substantial damageNTSB ANC97LA036Accident · Minor injuriesLimited investigationFinal reportWilliams Kitfox · Wasilla, AKa broken electrical wire, which resulted in an inoperative electrical fuel pump, an overly lean mixture, fuel starvation, and loss of engine power.Mar 22, 1997 · N9KF · Substantial damageNTSB LAX97FA126Accident · 4 fatalField investigationFinal reportPiper PA-22-160 · Bagdad, AZfailure of the pilot to obtain and/or maintain adequate airspeed during takeoff/initial climb, which resulted in an inadvertent stall and collision with the terrain. High density altitude was a related factor.Mar 19, 1997 · N3629Z · DestroyedNTSB FTW97LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Broomfield, COthe student pilot's improper use of the fuel tank selector which led to fuel starvation and loss of engine power. Factors were the pilot's inadequate fuel management and the lack of suitable terrain for the forced landing.Mar 19, 1997 · N2572Y · Substantial damageNTSB FTW97IA128Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-32 · Houston, TXThe failure of company maintenance personnel to perform a proper inspection of the combustion chamber outer case, thus allowing a detectable crack to grow to a length at which the case ruptured.Mar 18, 1997 · N12508 · Minor damageNTSB LAX97FA123Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Pacoima, CAimproper maintenance/installation of electrical wiring, the lack of circuit protection, and subsequent in-flight electrical fire.Mar 15, 1997 · N3030H · DestroyedNTSB FTW97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Collins, COThe pilot's failure to remove completely ice/frost from the wing, impeding the airplane's aerodynamic performance. Factors were wing contamination by frost and ice.Mar 15, 1997 · N4860T · DestroyedNTSB NYC97LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, MEthe pilot's premature raising of the flaps during the initial climb after takeoff, which resulted in a stall/mush. A factor relating to the accident was: the pilot's failure to maintain proper runway alignment after lift-off, which allowed the airplane to…Mar 14, 1997 · N2914A · Substantial damageNTSB FTW97LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, OKThe pilot/mechanic's improper installation of the spark plug, resulting in its separation from the engine. A factor was the unsuitable terrain available in the runway's overrun area.Mar 10, 1997 · N65753 · Substantial damageNTSB LAX97LA115Accident · No injuriesLimited investigationFinal reportRyan Navion · Marina, CAFuel exhaustion due to the pilot's improper preflight inspection and his inaccurate fuel consumption calculations.Mar 9, 1997 · N4969K · Substantial damageNTSB ANC97LA033Accident · No injuriesLimited investigationFinal reportCessna 337T · Fairbanks, AKa leaking landing gear actuator seal, which resulted in an inability of the landing gear to lock in the down position. Failure of the emergency gear extension handle was a related factor.Mar 9, 1997 · N922EJ · Substantial damageNTSB FTW97LA118Accident · No injuriesLimited investigationFinal reportRyan Navion A · Hudson, COA total power loss due to fuel starvation as a result of the pilot's inadequate preflight inspection of the airplane and its fuel system. Factors include: the pilot's failure to refuel the airplane, the improper fuel tank selector position that would not…Mar 6, 1997 · N800PS · Substantial damageNTSB LAX97LA114Accident · No injuriesLimited investigationFinal reportHoac Austria DV-20 · Galt, CAa disconnect of a fuel line fitting, due to the manufacturer's inadequate design and/or lack of adequate installation procedure for replacement of the fuel filter; which resulted in fuel starvation, loss of engine power, and a forced landing. Soft terrain in…Feb 26, 1997 · N194DV · Substantial damageNTSB SEA97LA062Accident · Serious injuriesLimited investigationFinal reportHall Kitfox · Billings, MTThe pilot-in-command's failure to maintain flying airspeed while executing a downwind turn at low altitude immediately following takeoff.Feb 22, 1997 · N87TJ · Substantial damageNTSB LAX97FA108Accident · Minor injuriesField investigationFinal reportBeech H18 · Honolulu, HIloss of aircraft control for undetermined reason(s).Feb 22, 1997 · N7969K · DestroyedNTSB ATL97LA043Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Brooksville, FLinadequate supervision by the flight instructor (CFI), and his failure to ensure that adequate airspeed was obtained/maintained, which resulted in a stall and collision with the ground. The crosswind was a related factor.Feb 20, 1997 · N9987V · Substantial damageNTSB NYC97LA053Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Nanjemoy, MDthe pilot's inadequate compensate for the wind conditions and failure to maintain adequate obstacle clearance during the initial climb after takeoff. The unfavorable wind condition and proximity of trees were related factors.Feb 19, 1997 · N2558 · Substantial damageNTSB IAD97LA050Accident · No injuriesLimited investigationFinal reportCessna 150 · Turner, MELoss of engine power for undetermined reasons. A related factor was the snowbank.Feb 19, 1997 · N7811E · Substantial damageNTSB IAD97GA049Accident · Serious injuriesFinal reportEnstrom 280C · Lucasville, OHThe pilot in command failure to maintain rotor rpm.Feb 19, 1997 · N51662 · Substantial damageNTSB FTW97FA103Accident · 5 fatalField investigationFinal reportPiper PA-24-250 · Farmington, NMloss of aircraft control for undetermined reason(s).Feb 15, 1997 · N6433P · DestroyedNTSB CHI97LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILThe loss of power for undetermined reasons.Feb 8, 1997 · N13611 · Substantial damageNTSB CHI97FA067Accident · 1 fatalField investigationFinal reportCessna 150 · Larchwood, IAthe noninstrument-rated pilot's takeoff into instrument meteorological conditions. The weather was a factor.Feb 7, 1997 · N714EE · DestroyedNTSB ANC97FA026Accident · 1 fatalField investigationFinal reportPiper PA-18 · Circle, AKinadequate preflight by the pilot; and his subsequent loss of aircraft control, during the initial climb after takeoff. Factors relating to the accident were: the pilot failed to ensure that the cargo was properly secured, and he allowed the aircraft's weight…Feb 7, 1997 · N121BB · DestroyedNTSB FTW97FA099Accident · 2 fatalField investigationFinal reportAeronca 65-TC · Moriarty, NMThe pilot's failure to maitain airspeed resulting in an inadvertent stall/spin. Factors were gusty winds, turbulence, a high density altitude, and the pilot's lack of total experience in the make and model of aircraft.Feb 3, 1997 · N31794 · Substantial damageNTSB FTW97LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Waxahachie, TXThe loss of engine power for undetermined reasons. A factors was the lack of suitable terrain for the forced landing.Feb 1, 1997 · N5598T · DestroyedNTSB FTW97LA094Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Lake Jackson, TXThe failure of the #2 cylinder for an undetermined reason which resulted in an exhaust leak that melted an oil line.Jan 30, 1997 · N51774 · DestroyedNTSB MIA97LA076Accident · No injuriesLimited investigationFinal reportCessna U206D · Tampa, FLInadequate torque of the cylinder base nuts and through bolt nuts by company maintenance personnel which allowed movement of the crankcase halves. As a result the No. 2 main bearing failed which allowed excessive movement of the crankshaft resulting in…Jan 27, 1997 · N72074 · Substantial damageNTSB SEA97LA052Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Chehalis, WAThe failure of the first pilot to conduct an adequate preflight inspection, and his failure to properly manage the aircraft fuel supply. This led to fuel starvation and a subsequent loss of engine power. Factors contributing to the accident are the false…Jan 26, 1997 · N344LC · DestroyedNTSB LAX97LA092Accident · 2 fatalLimited investigationFinal reportCrane Thorp T-18 · San Diego, CAInstallation by the pilot/owner of an unairworthy check valve in the fuel system of the amateur built aircraft, which resulted in inadequate fuel flow to the engine and subsequent engine failure. A factor in the accident was the owner's operation of the…Jan 25, 1997 · N40918 · DestroyedNTSB MIA97LA072Accident · Serious injuriesLimited investigationFinal reportNavion G · Indiantown, FLTotal loss of engine power due to undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing. Findings of the follow-up investigation were 1) The airplane had not been operated and no annual inspections…Jan 24, 1997 · N2417T · Substantial damageNTSB FTW97LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sulphur, OKThe loss of engine power due to fuel starvation and the pilot's improper use of the fuel tank selector. Factors were the pilot's failure to follow the checklist and the lack of suitable terrain for the forced landing.Jan 23, 1997 · N15754 · Substantial damageNTSB CHI97IA075Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Charleston, WVa fractured fusion weld in the piston of the roll spoiler servoactuator, which allowed the plug at the base of the piston to separate and jam the piston. A factor relating to the incident was: the inadequate design of the airplane's roll spoiler servoactuator…Jan 22, 1997 · N852MA · No damageNTSB CHI97FA059Accident · Minor injuriesField investigationFinal reportCessna 401 · Crystal, MNfailure of the pilot-in-command to ensure adequate removal of airframe ice from the aircraft during preflight.Jan 22, 1997 · N5AS · Substantial damageNTSB SEA97LA050Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Lopez, WAThe pilot's improper decision to initiate flight into marginal VFR conditions at night which led to inadvertent flight into instrument meteorological conditions, and his failure to maintain adequate clearance from terrain. Factors contributing to the accident…Jan 20, 1997 · N42376 · Substantial damageNTSB FTW97LA086Accident · Serious injuriesLimited investigationFinal reportMahan Starduster II · Atlanta, TXimproper maintenance by unknown person(s), which resulted in the failure of the throttle cable and a substantial loss of engine power. A factor relating to the accident was: the lack of suitable terrain for the forced landing.Jan 19, 1997 · N45227 · Substantial damageNTSB IAD97LA044Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · University Park, PAthe pilot's inability to control the airplane due to a damaged/bent elevator control lever and resultant lack of elevator authority.Jan 18, 1997 · N2803A · Substantial damageNTSB NYC97FA043Accident · 2 fatalField investigationFinal reportCessna 150L · Collegeville, PAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed during the forced landing, which resulted in a stall and collision with the ground. A contributing factor was wind gusts.Jan 12, 1997 · N10809 · DestroyedNTSB LAX97LA088Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Kamuela, HIfuel system contamination resulting in a partial loss of power, and the failure of the pilot to maintain adequate rotor rpm to cushion the autorotative landing and prevent main rotor blade contact with the tailboom. Factors were the inadequacy of…Jan 12, 1997 · N7012G · Substantial damageNTSB NYC97FA045Accident · Minor injuriesField investigationFinal reportBeech 1900D · Bangor, METhe inadequate flight and winter operations training provided by the operator, and the pilot's improper decision to abort the takeoff while airborne above V1, due to a false stall warning horn. Also casual was the airport operations improper decision to…Jan 10, 1997 · N139ZV · Substantial damageNTSB ANC97LA017Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Nome, AKthe pilot's failure to properly verify the position of a fractured fuel selector handle, which resulted in fuel starvation and subsequent loss of engine power. A factor related to the accident was: the fractured handle that allowed the fuel selector to be…Jan 2, 1997 · N23CB · Substantial damage