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 LAX93LA139Accident · No injuriesLimited investigationFinal reportAcro Sport Acro Sport · Lake Riverside, CAThat the pilot misjudged the landing/flare altitude. Contributing to this accident was the loss of power for undetermined reasons.Mar 6, 1993 · N98GS · Substantial damageNTSB FTW93LA093Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Fort Worth, TXInadvertent stall. A factor was the tailwindMar 3, 1993 · N714AT · Substantial damageNTSB BFO93LA042Accident · Minor injuriesLimited investigationFinal reportAsselyn Xenair CH701 · Durham, METhe pilot's inadequate compensation for wind conditions and failure to maintain directional control after lift-off. Factors related to the accident were: the unfavorable wind condition and proximity of the power line.Mar 3, 1993 · N942PS · Substantial damageNTSB BFO93LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boonville, NYThe pilot failed to compensate for wind conditions and encountered a stall. The windshear was a factor.Feb 28, 1993 · N1554P · Substantial damageNTSB MIA93LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Blountstown, FLInadequate visual lookout by the pilot resulting in failure to avoid the powerline.Feb 27, 1993 · N3064J · Substantial damageNTSB BFO93LA035Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Xenia, OHLoss of partial power for undetermined reasons.Feb 27, 1993 · N63369 · Substantial damageNTSB BFO93FA034Accident · 1 fatalField investigationFinal reportCessna 180F · Brewer, MELoss of engine power due to undetermined reasons, and the failure of the pilot to maintain adequate airspeed during the forced landing which resulted in a stall.Feb 27, 1993 · N4607U · DestroyedNTSB ANC93LA039Accident · No injuriesLimited investigationFinal reportCessna A185F · Fairbanks, AKThe fuel system selector valve being placed in the off position due to the improper installation of the fuel selector placard by an unqualified person. The snow covered forced landing area was a factor.Feb 23, 1993 · N37BC · Substantial damageNTSB LAX93LA131Accident · Minor injuriesLimited investigationFinal reportSchicora Osprey 2 · Joshua Tree, CAThe failure of the pilot flying to attain adequate airspeed for lift off and the resulting inadvertent stall mush condition during the initial climb.Feb 22, 1993 · N186S · Substantial damageNTSB ANC93FA034Accident · No injuriesField investigationFinal reportCessna 402C · Nome, AKThe pilot in command not removing the ice from the plane's airfoil surfaces before takeoff. The weather condition was a factor.Feb 20, 1993 · N4182G · DestroyedNTSB ATL93FA058Accident · 2 fatalField investigationFinal reportCessna 402B · Geneva, ALThe pilot's failure to maintain minimum controllable airspeed during the initial climb, which resulted in a loss of aircraft control and collision with trees and terrain.Feb 14, 1993 · N69402 · DestroyedNTSB LAX93LA120Accident · No injuriesLimited investigationFinal reportBell 47G · Bakersfield, CAThe clutch slippage and failure of the pilot to jettison the load.Feb 13, 1993 · N1185W · Substantial damageNTSB CHI93LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Weeping Water, NEThe pilot's failure to abort the takeoff when the airplane first touched down on the clear area adjacent to the departure runway.Feb 13, 1993 · N6640A · Substantial damageNTSB LAX93LA134Accident · Minor injuriesLimited investigationFinal reportBeech D35 · San Manuel, AZThe pilot's improper use of carburetor heat. Contributing to this accident were weather conditions which were conducive to the formation of carburetor ice.Feb 11, 1993 · N2908B · Substantial damageNTSB LAX93LA114Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Rachael, NVThe pilot poor preflight planning and preparation. The road sign was a factor relating to this accident.Feb 11, 1993 · N8805D · Substantial damageNTSB LAX93FA112Accident · 4 fatalField investigationFinal reportCessna 414 · Truckee, CAThe decision of the pilot not to follow instrument flight rule procedures during instrument meteorological conditions and poor preflight planning which resulted in operation of the airplane over the maximum gross weight and reduced performance. Factors in the…Feb 10, 1993 · N711LT · DestroyedNTSB LAX93LA111Accident · No injuriesLimited investigationFinal reportCobb Intl Exec 90 · Chandler, AZThe manufacturer's inadequate quality control which resulted in the fatigue of the valve stem. The soft terrain contributed to this accident.Feb 9, 1993 · N89678 · Substantial damageNTSB NYC93LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · New Cumberland, PAThe loss of engine power for undetermined reasons, resulting in a forced landing in the river.Feb 7, 1993 · N32307 · Substantial damageNTSB FTW93LA078Accident · No injuriesLimited investigationFinal reportRans S-7 · Lancaster, TXAircraft control not maintained by pilot. Turbulence due to strong, gusty winds was a factorJan 31, 1993 · N4312C · Substantial damageNTSB SEA93LA059Accident · No injuriesLimited investigationFinal reportCessna A185F · Inglewood, WAFuel exhaustion, the pilot in command's inadequate preflight, and his failure to flare on landing. A factor contributing to the accident was fog.Jan 30, 1993 · N5391R · Substantial damageNTSB SEA93LA057Accident · No injuriesLimited investigationFinal reportCessna 180E · Riggins, IDThe improper preflight planning by the pilot and his failure to attain proper airspeed for takeoff from a short strip in tailwind weather conditions. A factor relating to the accident was the tailwind weather conditions.Jan 28, 1993 · N8691X · Substantial damageNTSB LAX93FA103Accident · Serious injuriesField investigationFinal reportPiper PA-23-150 · Eloy, AZPartial loss of engine power due to fuel system contamination and a partially obstructed carburetor venturi, and the pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's inadequate preflight inspection.Jan 25, 1993 · N2144P · DestroyedNTSB LAX93FA097Accident · 2 fatalField investigationFinal reportBeech A35 · Tulare, CAThe installation of an unapproved wing tip fuel tank system; an inadequate annual inspection which did not note, or correct, the unapproved fuel system addition; a wing tank fuel selector valve installation without adequate placards to show position or…Jan 21, 1993 · N595B · DestroyedNTSB MIA93FA051Accident · Serious injuriesField investigationFinal reportCessna 140 · Niceville, FLA loss of engine power for undetermined reasons over terrain that was not suitable for the subsequent forced landing.Jan 18, 1993 · N89968 · Substantial damageNTSB ATL93LA052Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Mebane, NCThe pilot's mismanagement of the fuel supply which resulted in fuel starvation to the engine.Jan 17, 1993 · N3523R · DestroyedNTSB BFO93LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Poestenkill, NYThe total loss of engine power due to undetermined reasons.Jan 16, 1993 · N7804W · Substantial damageNTSB FTW93FA068Accident · 2 fatalField investigationFinal reportCessna 150J · Porter, TXInadvertent stall. Factors were the pilot's failure to follow the published checklist and the improper flap settingJan 15, 1993 · N5563G · DestroyedNTSB BFO93LA020Accident · No injuriesLimited investigationFinal reportDornier DO-228-202 · Manchester, NHIncorrect installation of the seals in the nose gear assembly, which prevented the nose gear from locking in the down position.Jan 10, 1993 · N245RP · Substantial damageNTSB BFO93FA018Accident · 1 fatalField investigationFinal reportCessna 182P · Stow, MAAn inadequate preflight by the pilot, which allowed water contamination in the fuel and subsequent loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall.Jan 10, 1993 · N52785 · DestroyedNTSB ATL93LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Roanoke Rapids, NCThe pilot-at-control's failure to use carburetor heat resulting in a loss of engine power due to carburetor ice. A factor which contributed to the accident was weather conducive to carburetor ice.Jan 3, 1993 · N8024T · Substantial damageNTSB ATL93FA046Accident · 2 fatalField investigationFinal reportBeech A23 · Ft. Bragg, NCThe loss of engine power for undetermined reasons and the loss of control during the forced landing.Jan 3, 1993 · N5774V · DestroyedNTSB MIA93FA058Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Brilliant, ALThe pilot-in-command's intentional flight into adverse weather which resulted in a loss of control. In addition, the pilot was overconfident in his ability. Factors which contributed to the accident were the weather conditions and the dark night.Jan 1, 1993 · N8205N · DestroyedNTSB LAX93LA083Accident · No injuriesLimited investigationFinal reportRotorway Executive · Chandler, AZAn engine compartment fire for undetermined reasons.Dec 31, 1992 · N43385 · DestroyedNTSB SEA93LA047Accident · No injuriesLimited investigationFinal reportAero Commander AC-500B · Billings, MTLoss of engine power on both engines for undetermined reasons and left main landing gear not down and locked on touchdown.Dec 29, 1992 · N2783Q · Substantial damageNTSB LAX93LA076Accident · Minor injuriesLimited investigationFinal reportCurtiss JN-4D · Livermore, CAThe shearing of the number 8 cylinder rocker arm support pedestal/coolant housing retaining bolts. Contributing to the accident was a loss of engine coolant.Dec 26, 1992 · N5001 · Substantial damageNTSB FTW93LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Slaton, TXThe total loss of engine power due to fuel starvation as a result of improper fuel tank selection. A factor the unsuitable terrain.Dec 26, 1992 · N4578R · DestroyedNTSB MIA93LA033Accident · Minor injuriesLimited investigationFinal reportMaule M-5-180C · Moultrie, GAThe pilot-in-command's failure to maintain airspeed on initial takeoff climb resulting in an in flight loss of control (stall) and subsequent in flight collision with terrain.Dec 23, 1992 · N1TK · Substantial damageNTSB LAX93LA072Accident · No injuriesLimited investigationFinal reportCessna 180K · Fullerton, CAThe airplane's owners (including the pilot) poor maintenance and the pilot's inadequate preflight inspection. Contributing to this accident was the deteriorated overwing fuel caps seals and the tailwind.Dec 23, 1992 · N61798 · Substantial damageNTSB CHI93LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · West Bend, WITotal loss of engine power due to the failure of the pilot to select the fuel tank with the most fuel.Dec 21, 1992 · N8806J · Substantial damageNTSB MIA93LA029Accident · Minor injuriesLimited investigationFinal reportHighcraft Buccaneer II · Rockledge, FLThe total failure of the engine-driven fuel pump on takeoff initial climb. A factor was unsuitable terrain.Dec 16, 1992 · UNREG · Substantial damageNTSB NYC93FA044Accident · 1 fatalField investigationFinal reportBeech 18T · Cleveland, OHThe improper installation of the elevator by company maintenance personnel and the lack of proper inspections by a company certified mechanic/inspector and the FAA certified mechanic with inspector authorization. A factor in this accident was an…Dec 15, 1992 · N706M · DestroyedNTSB LAX93LA065Accident · No injuriesLimited investigationFinal reportCessna 185F · Lanai, HIThe failure of the engine for undetermined reasons. A factor in the accident was that obstructions were hidden in the grass of the landing area chosen by the pilot for the forced landing.Dec 13, 1992 · N4742E · Substantial damageNTSB ANC93LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe total loss of engine power due to a short in the voltage regulator, and the lack of suitable terrain for the pilot to make the forced landing on.Dec 13, 1992 · N1954P · Substantial damageNTSB FTW93IA048Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120RT · Houston, TXThe assigned mechanic's failure to reinstall the attachment screws and the quality inspector's inadequate inspection of the completed work. A factor was the complacency of the maintenance personnel.Dec 9, 1992 · N16729 · No damageNTSB MIA93LA026Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Groveland, FLThe pilot's encounter with shifting winds on the takeoff roll, that caused the airplane to overrun the runway. Contributing to the accident was the failure of the pilot in command to perform an aborted takeoff.Dec 5, 1992 · N5915L · Substantial damageNTSB CHI93LA045Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Milwaukee, WIThe pilot's failure to maintain a proper altitude.Dec 1, 1992 · N6761E · Substantial damageNTSB SEA93FA031Accident · 1 fatalField investigationFinal reportBeech S35 · Rexburg, IDThe pilot in command's failure to maintain clearance with objects/terrain. Factors contributing to the accident were low ceilings, snow, dark night conditions, trees, improper preflight planning and self induced pressure.Nov 30, 1992 · N8634Q · DestroyedNTSB ATL93FA030Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Pike Road, ALThe failure of the pilot in command to maintain airspeed during the initial climb, which resulted in an inadvertent stall and collision with the ground. Factors were the inadequate preflight planning and preparation of the pilot in command in that he operated…Nov 30, 1992 · N7622S · DestroyedNTSB LAX93LA054Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Rialto, CAThe pilot's poor preflight inspection and his failure to maintain flying speed during the forced landing. Conributing to this accident was the inadvertent stall, the preceding sand/dust storm, the engine assembly low compression due to sand in the intake and…Nov 27, 1992 · N6115P · Substantial damageNTSB ATL93LA029Accident · Minor injuriesLimited investigationFinal reportChampion 7AC · Troy, TNThe pilot's inadequate preflight planning, his failure to attain a proper climb rate, and the inadvertent stalling of the aircraft while attempting to avoid high obstructions (trees). Factors were the rough, uneven runway conditions, the high obstructions,…Nov 26, 1992 · N1115E · Substantial damage