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 FTW95LA142Accident · Minor injuriesLimited investigationFinal reportRyan Aeronautical ST3-KR · Blue Ridge, TXThe loss of engine power for undetermined reason. A factor was the lack of suitable terrain for the forced landing.Mar 20, 1995 · N54430 · Substantial damageNTSB ATL95LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · Nashville, TNThe pilot's improper use of the flight controls during takeoff which resulted in the inflight collision with the ground.Mar 17, 1995 · N1815X · Substantial damageNTSB BFO95FA033Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Cambridge, MDthe commercial/instrument rated pilot's failure to obtain/maintain adequate altitude/clearance during the initial climb after takeoff. Related factors are the pilot's poor planning/decision making, and the fog.Mar 15, 1995 · N166CP · DestroyedNTSB NYC95LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Kingston, NYThe pilot's failure to assure that the fuel selector was positioned to a tank containing ample fuel.Mar 14, 1995 · N3665R · DestroyedNTSB ANC95LA033Accident · No injuriesLimited investigationFinal reportChampion 8GCBC · Fairbanks, AKThe pilot's inadequate pre-flight planning. A short takeoff area that was covered with soft snow were factors in the accident.Mar 9, 1995 · N88297 · Substantial damageNTSB BFO95LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · London, OHthe loss of engine power (both engines, cause undetermined) shortly after lift off. Related factors are the foggy, dark night conditions, and the unsuitable terrain encountered during the subsequent forced landing.Mar 7, 1995 · N2299M · DestroyedNTSB FTW95FA125Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Midway, ARThe pilot's impairment of judgment and performance due to drugs, his lack of qualification/training, and his resultant inability to maintain control of the airplane.Feb 28, 1995 · N207Q · DestroyedNTSB LAX95LA123Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 Astir CS · Jean, NVthe pilot's decision to fly in known adverse weather conditions which resulted in a wind shear encounter at low altitude during the takeoff initial climb.Feb 27, 1995 · N57GE · DestroyedNTSB CHI95LA093Accident · No injuriesLimited investigationFinal reportBell 206L · Maryland Hts, MOFatigue failure of two attachment bolts that connected the driveshaft to the geared portion of a driveshaft coupling. Factors relating to the accident were: inadequate maintenance, uneven terrain in the touchdown area for the forced landing, and the…Feb 27, 1995 · N970CC · Substantial damageNTSB LAX95FA119Accident · Serious injuriesField investigationFinal reportBellanca 7ECA · San Jose, CAThe pilot's improper climb attitude which resulted in a momentary loss of engine power due to fuel starvation.Feb 26, 1995 · N9198L · DestroyedNTSB FTW95LA122Accident · Minor injuriesLimited investigationFinal reportMorrison, Marvin E. RV-4 · Brighton, COA total loss of power for unknown reasons. A factor was the lack of suitable terrain for a forced landing.Feb 25, 1995 · N872MM · Substantial damageNTSB LAX95LA113Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Sonoma, CAthe pilot's failure to maintain an adequate visual lookout for obstructions during initial climb. Factors which contributed to the accident were the pilot's inadequate preflight inspection, and his decision to fly with an inadequately cleaned bubble which…Feb 20, 1995 · N1309X · Substantial damageNTSB CHI95LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Washington, MOthe CFI's failure to verify the fuel quantity prior to takeoff which resulted in fuel exhaustion. Factors related to the accident were the student's misjudgment of the fuel quantity and the soft terrain.Feb 20, 1995 · N5255Q · Substantial damageNTSB CHI95LA091Accident · No injuriesLimited investigationFinal reportBeech 23 · Hutchinson, KSinadequate preflight planning by the pilot. Contributing factors to this accident were the pilot selecting the wrong runway for takeoff and the tailwind condition.Feb 18, 1995 · N833KS · Substantial damageNTSB CHI95LA090Accident · No injuriesLimited investigationFinal reportCessna 180J · Cotton, MNthe pilot's failure to gain sufficient clearance over the trees during the aborted landing.Feb 18, 1995 · N52172 · Substantial damageNTSB CHI95LA088Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIdelayed remedial action by the flight instructor. Factors in the accident were the student pilot not maintaining directional control once airborne.Feb 18, 1995 · N79569 · Substantial damageNTSB NYC95LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Mount Snow, VTThe pilot's inadequate compensation for wind which resulted in the airplane drifting into a snow bank and nosing over.Feb 14, 1995 · N757SG · Substantial damageNTSB DCA95MA019Accident · 8 fatalMajor investigationFinal reportPiper PA-31-350 · Tusayan, AZa loss of power on one engine for an undetermined reason(s), and the pilot's improper decision to return to the departure airport for landing which neccessitated maneuvering over increasingly higher terrain. Factors in the accident were: the high gusting…Feb 13, 1995 · N27245 · DestroyedNTSB SEA95LA045Accident · No injuriesLimited investigationFinal reportCessna 185 · Mccall, IDThe pilot's premature lift-off during the takeoff, leading to an aerodynamic stall. A factor contributing to the accident was the pilot's attempt to perform a formation takeoff.Feb 6, 1995 · N9CR · Substantial damageNTSB MIA95LA069Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · St. Augustine, FLThe improper adjustment of the turbocharger inlet pipe securing clamp by unknown maintenance personnel.Feb 5, 1995 · N14032 · Substantial damageNTSB CHI95LA110Accident · No injuriesLimited investigationFinal reportCessna 172 · Nevis, MNthe loss of engine power due to a blockage caused by ice. A factor in the accident was the snow.Feb 5, 1995 · N739FZ · Substantial damageNTSB MIA95LA064Accident · No injuriesLimited investigationFinal reportBeebe, Dale G. RV-6 · Zellwood, FLThe improper in-flight decision by the pilot to abort takeoff with insufficient runway remaining.Jan 28, 1995 · N109DB · Substantial damageNTSB LAX95FA088Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Big Bear City, CAthe pilot's improper preflight inspection during which he failed to insure removal of the induction air system inlet covers. This action resulted in a partial loss of engine power during initial climb. A factor which contributed to the accident was the…Jan 28, 1995 · N9602J · DestroyedNTSB CHI95LA075Accident · No injuriesLimited investigationFinal reportBeech C45H · New Hudson, MIThe owner/pilot's inadequate maintenance practices which resulted in a loss of engine power shortly after takeoff and the pilot's inadequate emergency procedure after the power loss occurred. Related factors are trees, diminished airspeed and abrupt touchdown.Jan 24, 1995 · N618K · Substantial damageNTSB CHI95LA077Accident · No injuriesLimited investigationFinal reportCessna 150F · Castlewood, SDthe pilot's inadequate preflight planning and preparation. Factors associated with the accident are the snow covered/drifted runway, and a fence.Jan 21, 1995 · N8981S · Substantial damageNTSB ANC95LA029Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Akiak, AKThe partial loss of engine power due to an erratic spark plug.Jan 20, 1995 · N4480X · Substantial damageNTSB FTW95FA094Accident · Minor injuriesField investigationFinal reportCessna 208B · Lubbock, TXThe pilot's failure to remove ice from the airframe prior to takeoff. Factors were freezing rain the night before and the pilots' incomplete preflight inspection.Jan 18, 1995 · N9461R · DestroyedNTSB FTW95LA093Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Roanoke, TXLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jan 14, 1995 · N9734K · Substantial damageNTSB FTW95LA092Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Miami, OKThe pilot's failure to maintain control of the airplane during takeoff due to his attention being diverted. Factors were the passenger's seat belt buckle blocking the gear up latching mechanism, and his lack of familiarity with the airplane.Jan 14, 1995 · N4024N · Substantial damageNTSB LAX95FA076Accident · 1 fatalField investigationFinal reportCessna 208B · Flagstaff, AZThe pilot's failure to properly configure the aircraft fuel system prior to takeoff, and his failure maintain an adequate terrain clearance altitude while maneuvering to return to the airport. Factors in the accident were the dark night lighting conditions,…Jan 12, 1995 · N746FE · DestroyedNTSB ANC95LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKA failure of the pilot to perform an adequate pre-flight inspection of the airplane. Factors in the accident were a frozen gascolator, and restricted fuel supply.Jan 8, 1995 · N9264D · Substantial damageNTSB FTW95FA080Accident · 2 fatalField investigationFinal reportBeech 65-90 · Royal, ARThe pilot inadvertently allowed the airplane to descend and collide with trees, after he became diverted by an inoperative cabin heater. Darkness was a related factor.Jan 4, 1995 · N101GA · DestroyedNTSB MIA95LA052Accident · Minor injuriesLimited investigationFinal reportCessna 152 · New Smyrna Bch., FLIntentional flight into known instrument meteorological conditions by a noninstrument-rated pilot, and the pilot's subsequent spatial disorientation. Contributing to the accident was the pilots' overconfidence in his personal ability.Jan 1, 1995 · N24457 · Substantial damageNTSB ATL95FA031Accident · 2 fatalField investigationFinal reportCessna 310Q · St. Augustine, FLThe non-instrument rated pilot's attempted flight into known instrument meteorological conditions which resulted in spatial disorientation and loss of control.Dec 30, 1994 · N30LC · DestroyedNTSB CHI95LA058Accident · No injuriesLimited investigationFinal reportMooney M20K · Minneapolis, MNthe pilot's misjudging of distance and airspeed during the approach to landing which resulted in an overrun. Factors associated with the accident were the separation of the exhaust pipe and the pilot's not understanding communications from the air traffic…Dec 28, 1994 · N3983H · Substantial damageNTSB FTW95LA074Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Monahans, TXThe pilot's failure to use the carburetor heat and failure to maintain airspeed. A factor was the icing conditions.Dec 27, 1994 · N6417S · DestroyedNTSB FTW95LA073Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Erie, COThe pilot's failure to maintain airspeed resulting in the inadvertent stall.Dec 23, 1994 · N8389Q · Substantial damageNTSB FTW95FA071Accident · 3 fatalField investigationFinal reportCessna 182G · Muskogee, OKFailure of the pilot to maintain control of the airplane due to spatial disorientation after inadvertently flying into adverse weather. Factors related to the accident were: darkness, the low ceiling, the pilot's inadequate evaluation of the weather, and his…Dec 21, 1994 · N3229S · DestroyedNTSB LAX95LA054Accident · No injuriesLimited investigationFinal reportCessna 120 · Torrance, CAA blockage in the carburetor heat air duct which limited the effectiveness of the system's ability to prevent the formation of carburetor ice and resulted in a loss of power. A factor in the accident was the soft nature of the recently plowed ground in the…Dec 19, 1994 · N89885 · Substantial damageNTSB LAX95FA053Accident · 2 fatalField investigationFinal reportNorth American NAVION-A · Big Bear City, CAthe pilot's initial overrotation, his failure to attain the proper climb airspeed, and an inadvertent entry into a stall mush condition. A factor in the accident was the high-density altitude.Dec 19, 1994 · N8794H · DestroyedNTSB FTW95LA088Accident · No injuriesLimited investigationFinal reportBeech 1900D · Farmington, NMGround personnel failed to properly secure the cargo door.Dec 15, 1994 · N39ZV · Substantial damageNTSB BFO95LA021Accident · Minor injuriesLimited investigationFinal reportElvin N. Kier Varieze · Cleveland, OHA fatigue crack in the right elevator torque tube resulting in the disconnection of the elevator torque tubes and subsequent loss of airplane control.Dec 14, 1994 · N59MW · DestroyedNTSB ANC95LA017Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Takotna, AKThe pilot's inadequate preflight planning for the departure. A snow covered runway, flat lighting conditions, and a snowbank were factors in the accident.Dec 12, 1994 · N4552F · DestroyedNTSB LAX95LA047Accident · Serious injuriesLimited investigationFinal reportBenson B8M · Adelanto, CAthe pilot's inadequate compensation for the wind conditions during the downwind turn and his resulting failure to maintain adequate rotor rpm. A factor in the accident was the lack of an airspeed indicator.Dec 10, 1994 · UNREG · DestroyedNTSB NYC95LA039Accident · 1 fatalLimited investigationFinal reportWilliam MC Glumphy Kitfox III · Cadiz, OHThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall, and uncontrolled collision with the ground. A factor was pilot's lack of total experience in this make and model.Dec 4, 1994 · N345WM · DestroyedNTSB CHI95LA051Accident · 2 fatalLimited investigationFinal reportP. D. Chambers Swift PC-1V8 · Lincoln, NEThe pilot's failure to maintain control of the airplane, resulting in a stall-spin. Factors were an inadequate preflight and the loss of engine power resulting from water contamination in the automotive fuel.Dec 3, 1994 · N234PC · Substantial damageNTSB FTW95LA057Accident · 1 fatalLimited investigationFinal reportCessna 172 · Lawton, OKThe pilot's failure to attain sufficient airspeed during takeoff resulting in a stall. Factors were the pilot's selection of the downwind runway and his failure to use all availabble runway.Nov 30, 1994 · N7099A · Substantial damageNTSB NYC95LA036Accident · No injuriesLimited investigationFinal reportPiper J3C · Waldoboro, METhe pilot's premature lift off which resulted in insufficient climb performance and collision with trees.Nov 25, 1994 · N98542 · Substantial damageNTSB NYC95LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glenburn, METhe pilot's (1) improper decision to initiate a takeoff with ice on the wing.Nov 24, 1994 · N112KF · Substantial damageNTSB LAX95LA040Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Santa Monica, CAfuel starvation to both engines due to the CFI's inadequate fuel consumption calculations during the flight, and his failure to ensure that adequate fuel existed in the main tanks to complete the traffic pattern circuit.Nov 23, 1994 · N1898W · Destroyed