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 SEA91FA121Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12-D · Naches, WAThe in flight physical incapacitation of the pilot in command.Jun 2, 1991 · N39976 · DestroyedNTSB NYC91LA147Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Rhinebeck, NYThe failure of the pilot to attain flying speed, resulting in an inadvertent stall. Factors related to the accident were: improper use of the flight controls by the pilot, and the pilot's decision to make the takeoff under the existing conditions.Jun 2, 1991 · N201YS · Substantial damageNTSB NYC91LA146Accident · No injuriesLimited investigationFinal reportCessna 120 · Delaware, OHCarburetor ice and the pilot in command's improper use of carburetor heat. A factor in the accident was the carburetor icing conditions.Jun 2, 1991 · N2858N · Substantial damageNTSB LAX91LA239Accident · Minor injuriesLimited investigationFinal reportMaule M-4-220C · Byron, CAThe failure of the pilot-in-command to perform an adequate preflight inspection by taking the necessary steps to eliminate water contamination of the airplane's fuel system.Jun 2, 1991 · N40693 · Substantial damageNTSB BFO91FA053Accident · Serious injuriesField investigationFinal reportBeech B65 · California, MDThe loss of power in one engine for undetermined reasons.Jun 2, 1991 · N655KJ · DestroyedNTSB LAX91LA237Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Antioch, CAThat the pilot's preflight was improper; that he departed with the carburetor heat on; failed to abort when it became evident that the airplane was not going to take off; and abruptly lifting the airplane so that it became airborne in ground effect, but then…Jun 1, 1991 · N49173 · Substantial damageNTSB BFO91LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Elkins, WVThe loss of engine power for undetermined reasons.Jun 1, 1991 · N6904B · Substantial damageNTSB MIA91LA156Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Quincy, FLThe pilot's inadequate preflight inspection and the blocked vent line.May 31, 1991 · N9646S · Substantial damageNTSB CHI91LA177Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Depere, WIThe pilot's failure to correct a mushed stall during liftoff. A factor in the accident was the pilot's failure to compensate for wind conditions.May 31, 1991 · N4090N · DestroyedNTSB ATL91LA103Accident · No injuriesLimited investigationFinal reportCessna 150F · Monroe, NCThe pilot's selection of unsuitable terrain for takeoff. The unmowed grass runnway was a related factor.May 30, 1991 · N8026S · Substantial damageNTSB NYC91LA143Accident · No injuriesLimited investigationFinal reportCessna 120 · Wellsville, PAA power loss due to a fuel system blockage which resulted in a forced landing.May 28, 1991 · N2714N · Substantial damageNTSB CHI91LA173Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA1A · Evansville, INThe failure by maintenance personnel to identify the proper replacement cylinder.May 28, 1991 · N5675L · Substantial damageNTSB CHI91LA168Accident · No injuriesLimited investigationFinal reportCessna 150 · Cambridge, MNPartial loss of engine power due to improper use of carburetor heat and a stall encountered by the pilot.May 28, 1991 · N8845S · Substantial damageNTSB LAX91LA226Accident · Serious injuriesLimited investigationFinal reportPiper PA28-140 · Truckee, CAThe failure of the pilot to maintain airspeed and the inadvertent entry into a stall mush which led to a loss of control and an uncontrolled descent. Factors in the accident were: the pilot's poor preflight planning and the high density altitude.May 27, 1991 · N5777F · Substantial damageNTSB ATL91FA099Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Surf Side Beach, SCThe improper preflight inspection of the aircraft by the pilot, in that he failed to turn the aircraft fuel selector 'on' prior to starting the engine. A factor in the accident was the aircraft fuel selector valve leaking enough fuel to the engine in the…May 27, 1991 · N6634W · Substantial damageNTSB NYC91FA140Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Shelburne, VTPremature lift-off by the pilot, which resulted in a subsequent stall/mush and collision with trees. Factors related to the accident were: the pilot's inadequate preflight planning/preparation, and the unfavorable wind condition.May 25, 1991 · N8433C · DestroyedNTSB NYC91DHD02Accident · 1 fatalFinal reportBeamont Skybolt · Pennington, NJThe pilot's inadvertent lift off and failure to maintain aircraft control which resulted in an inadvertent stall. The pilot's lack of recent experience and lack of experience in type of airplane were factors in the accident.May 25, 1991 · N69JB · DestroyedNTSB LAX91LA229Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-500M · Minden, NVAn engine failure produced as a result of the pilot improperly adjusting the carburetor mixture jet.May 25, 1991 · N503V · Substantial damageNTSB BFO91LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Danville, VAAn inadequate preflight inspection which resulted in water contaminated fuel. Contributing was noncompliance with an airworthiness directive.May 25, 1991 · N5931D · Substantial damageNTSB SEA91LA118Accident · No injuriesLimited investigationFinal reportBeech A36TC · Ogden, UTLoss of control by the pilot due to inadequate preflight planning and preparation which resulted in over gross weight aircraft loading. A factor relating to the accident was the high density altitude weather conditions.May 24, 1991 · N3671F · Substantial damageNTSB FTW91DPG09Accident · No injuriesFinal reportGrumman G-164A · Goodwin, ARPower loss due to failure of the number five cylinder assembly. A factor was the soft terrain.May 21, 1991 · N542D · Substantial damageNTSB CHI91LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Mankato, MNPartial loss of engine power due to an unlocked engine primer. Factors related to the accident were that the pre takeoff check list was not followed by the pilot and the lack of suitable terrain for the forced landing.May 21, 1991 · N2906Z · Substantial damageNTSB ANC91LA058Accident · 1 fatalLimited investigationFinal reportBell UH-1B · Dog Fish Bay, AKThe pilot's exceeding the gross weight of the aircraft and inadequate supervision by company management. Contributing to the accident was the high vegetation.May 21, 1991 · N87966 · DestroyedNTSB SEA91FA110Accident · 1 fatalField investigationFinal reportBeech 35 · Harrison, IDImproper preflight planning/preparation by the pilot. The terrain condition and the pilot's lack of total experience were related factors.May 20, 1991 · N3842N · DestroyedNTSB LAX91LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · San Jose, CAFuel starvation due to the flight instructor's improper use of the fuel selector valve and his failure to properly supervise the conduct of the flight.May 20, 1991 · N9135T · Substantial damageNTSB ATL91LA097Accident · No injuriesLimited investigationFinal reportBeech 23 · Dothan, ALThe failure of the cylinder head because of previous overheated operations. Factors in the accident were the pilot's inaccurate approach which resulted in the loss of directional control and subsequent swerve into the fence.May 18, 1991 · N3549R · Substantial damageNTSB SEA91LA107Accident · No injuriesLimited investigationFinal reportCessna 182A · Mead, WACarburetor ice and the pilot not using the carburetor hear. Factors to the accident were: carburetor icing conditions, and the pilot did not adequately evaluate the weather conditions.May 17, 1991 · N5048D · Substantial damageNTSB FTW91DPG04Accident · No injuriesFinal reportGrumman G-164B · Vanndale, ARThe pilot's failure to verify his weight and balance. A factor was the soft terrain.May 17, 1991 · N8106K · DestroyedNTSB CHI91LA153Accident · No injuriesLimited investigationFinal reportCessna 177 · Decatur, INFailure to obtain airspeed for positive lift off and climb. Factors related to the accident were a grass/sod runway and a high density altitude.May 12, 1991 · N3345T · Substantial damageNTSB LAX91FA207Accident · 4 fatalField investigationFinal reportCessna 205 · Fallon, NVThe pilot-in-command's improper handling of the airplane and failure to maintain airspeed on initial takeoff climb resulting in an in flight loss of control, stall/spin, and subsequent in flight collision with terrain.May 11, 1991 · N8360Z · DestroyedNTSB MIA91FA140Accident · 2 fatalField investigationFinal reportMcdonnell Douglas DC-3C · Aguadilla, PRThe pilot in command's failure to maintain airspeed (vs) after a partial loss of engine power on the left engine due to failure of the no. 8 engine assembly cylinder. This resulted in an in flight loss of control (stall), and in flight collision with terrain.May 10, 1991 · N134FS · DestroyedNTSB CHI91LA148Accident · No injuriesLimited investigationFinal reportCessna 182L · Port Huron, MIThe pilot's inadequate landing flare during the forced landing. The pilot's failure to use carburetor heat was a factor.May 10, 1991 · N2432Q · Substantial damageNTSB MIA91LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Clearwater, FLInadequate annual inspection of the airplane by maintenance personnel who failed to detect a deteriorated oil line. This resulted in oil exhaustion causing the total loss of engine power due to failure of one of the connecting rods. Also inadvertent…May 9, 1991 · N55653 · Substantial damageNTSB LAX91LA206Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Redding, CAThat the pilot failed to brief the passenger and the passengers intentional control interference.May 8, 1991 · N140ED · Substantial damageNTSB MIA91LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bunnell, FLLoss of control in flight due to a foreign object which restricted the movement of the elevator flight control.May 7, 1991 · N7270G · Substantial damageNTSB SEA91LA098Accident · Serious injuriesLimited investigationFinal reportRichard Cheney Teratorn Tierra II · Morgan, UTThe inadvertant stall and the pilot's steep banked turn. Factors relating to the accident were the pilot's lack of qualification to conduct the flight and the strong tailwind conditions.May 5, 1991 · N134TA · DestroyedNTSB LAX91LA197Accident · No injuriesLimited investigationFinal reportCessna 150 · Fernley, NVThe failure of the pilot to adequately assess the climb performance of the accident airplane due to being under the influence of alcohol.May 5, 1991 · N45301 · Substantial damageNTSB LAX91LA195Accident · Serious injuriesLimited investigationFinal reportCessna U206 · Tulare, CAAn in-flight fire in the cabin/crew compartment area of the aircraft, due to failure of a fuel line located in the left doorpost area.May 5, 1991 · N2160F · DestroyedNTSB FTW91DRA02Accident · Serious injuriesFinal reportW. R. Mathis Midget Mustang · Nacogdoches, TXPower loss due to engine starter failure for undetermined reasons.May 4, 1991 · N43WM · Substantial damageNTSB FTW91LA075Accident · No injuriesLimited investigationFinal reportCessna 337D · Alpine, TXThe pilot's failure to maintain directional control of the airplane. A factor was the pilot's continued takeoff in unfavorable wind.May 2, 1991 · N86116 · Substantial damageNTSB DEN91LA066Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Englewood, COPower loss on both engines as a result of exhaust system failure.May 1, 1991 · N18DF · Substantial damageNTSB MIA91LA128Accident · 1 fatalLimited investigationFinal reportDonald L. Hedeman SONERAI-II · Jacksonville, FLThe pilot's improper adjustment of the carburetor.Apr 27, 1991 · N4FD · Substantial damageNTSB MIA91LA127Accident · No injuriesLimited investigationFinal reportTravel Air 2000 · Homestead, FLAn on ground encounter with weather conditions that were favorable for carburetor icing at a low power setting (glide power), and failure of the pilot to abort the takeoff after recognizing that the eng was not developing full power during the initial climb.Apr 27, 1991 · N1572 · Substantial damageNTSB NYC91FA120Accident · 1 fatalField investigationFinal reportPiper J5A · Newbury, MAThe loss of inflight control, which was the result of a jammed right aileron bellcrank assembly. Factors related to the accident were; the improper maintenance of the flight control system, and the incomplete preflight by the pilot.Apr 23, 1991 · N35826 · DestroyedNTSB CHI91DCJ02Accident · No injuriesFinal reportFagerberg Longeze · Wahoo, NEThe improper installation/maintenance of the carburetor heat control. A factor was the pilot's restricted visual outlook.Apr 20, 1991 · N459EZ · Substantial damageNTSB CHI91DCG02Accident · Serious injuriesFinal reportHuff Pulsar · Missouri City, MOOil fouled spark plugs resulting in a partial loss of engine power. Soft terrain in the forced landing area was a factor.Apr 17, 1991 · N89PB · Substantial damageNTSB LAX91LA175Accident · Serious injuriesLimited investigationFinal reportSnider RV6 · Paulden, AZThe pilot's poor preflight preparation and his failure to ensure that the fuel selector was properly positioned for flight.Apr 16, 1991 · N2165U · Substantial damageNTSB SEA91IA081Incident · Minor injuriesIncident investigationFinal reportBoeing 737-222 · Seattle, WATurbine blade failure from fatigue. Factors to the incident were inoperative engine fire extinguisher, inadequate service of aircraft and delayed deployment of emergency slide.Apr 10, 1991 · N9003U · Minor damageNTSB CHI91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Griffith, INContaminated fuel in the carburetor, and inadequate inspection/maintenance of the airplane by the pilot in command.Apr 10, 1991 · N1375F · Substantial damageNTSB ATL91LA078Accident · 1 fatalLimited investigationFinal reportLewis Challenger II · Thomaston, GAThe pilot's failure to properly maintain the airplane in accordance with prescribed procedures which resulted in fuel contamination, fouled spark plugs, and a loss of engine power. The pilot also failed to follow normal emergency procedures for the loss of…Apr 8, 1991 · N283EL · Substantial damage