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 FTW92DRA04Accident · Serious injuriesFinal reportEvans VP-1 · Friendswood, TXThe pilot's failure to maintain a proper descent rate during the forced landing. A factor was the engine power loss for undetermined reasons.Aug 8, 1992 · N73VP · Substantial damageNTSB CHI92LA234Accident · No injuriesLimited investigationFinal reportGrumman AA5 · Pinecreek, MNThe pilot-in-command's failure to obtain a proper climb rate.Aug 8, 1992 · CGRRE · Substantial damageNTSB FTW92LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Killeen, TXLoss of engine power due to a fractured number three cylinder exhaust push rod assembly.Aug 6, 1992 · N6614P · Substantial damageNTSB LAX92LA335Accident · Serious injuriesLimited investigationFinal reportErcoupe 415C · Dunsmuir, CAThe pilot's failure to perform any preflight planning or preparation and selected the wrong runway. Factors relating to this accident was the existing tailwind, high density altitude.Aug 5, 1992 · N99585 · DestroyedNTSB DEN92FA081Accident · No injuriesField investigationFinal reportCessna 402A · Holyoke, COFailure of the pilot to feather the failed engine propeller. A factor was: power loss for undetermined reasons.Aug 5, 1992 · N4504Q · Substantial damageNTSB LAX92LA328Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Burbank, CAThe binding and over temperature of an exhaust valve due to the lack of compliance with factory service instructions and bulletins regarding valve sticking by other maintenance personnel.Aug 3, 1992 · N53485 · Substantial damageNTSB FTW92LA199Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Monroe, LAThe pilot's failure to maintain adequate rotor RPM during autorotation. Factors were the tailwind and the power loss for undetermined reasons.Aug 3, 1992 · N501FH · Substantial damageNTSB CHI92LA225Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Whitman, NEWater contamination in the fuel and low magneto output.Aug 2, 1992 · N84228 · Substantial damageNTSB CHI92FA218Accident · 1 fatalField investigationFinal reportBull KR-2 · Oshkosh, WIA loss of control in flight due to pilot incapacitation as a result of a heart attack.Aug 2, 1992 · N86QT · DestroyedNTSB NYC92LA137Accident · Minor injuriesLimited investigationFinal reportDonald L. Betchan KR-II · Louisville, KYImproper use of the flight controls by the prospective buyer, and the failure of the owner/operator to adequately supervise the prospective buyer. Factors related to the accident were the lack of experience in type of airplane for the prospective buyer, and…Aug 1, 1992 · N983DB · Substantial damageNTSB FTW92LA198Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Hot Springs, ARThe partial loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.Aug 1, 1992 · N8747P · Substantial damageNTSB FTW92LA196Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Granbury, TXThe pilot's inadvertent use of carburetor heat during takeoff. The lack of suitable terrain for a forced landing was a factor.Jul 31, 1992 · N6650F · Substantial damageNTSB CHI92FA220Accident · 3 fatalField investigationFinal reportBeech V35B · Northwood, NDSpatial disorientation of the pilot in command during initial climb.Jul 31, 1992 · N8BL · DestroyedNTSB LAX92LA323Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ravendale, CAThe loss of engine power for undetermined reasons. The short length of the runway was a factor in the accident.Jul 30, 1992 · N8078H · Substantial damageNTSB DCA92MA044Accident · Serious injuriesClass 1 · MajorFinal reportLockheed L-1011-385-1 · Jamaica, NYDesign deficiencies in the stall warning system that permitted a defect to go undetected, the failure of twa's maintenance program to correct a repetitive malfunction of the stall warning system, and inadequate crew coordination between the captain and first…Jul 30, 1992 · N11002 · DestroyedNTSB BFO92LA119Accident · No injuriesLimited investigationFinal reportCessna 150F · Norfolk, MAThe loss of compression in the no. 4 cylinder due to a valve stuck in the open position, which resulted in the loss of engine power.Jul 30, 1992 · N1073P · Substantial damageNTSB ATL92LA148Accident · No injuriesLimited investigationFinal reportCessna 188 · Town Creek, ALThe inadequate preflight planning/preparation by the pilot which resulted in reduced aircraft performance and the collision with trees during climbout. Factors were the soft and wet terrain.Jul 30, 1992 · N4495Q · Substantial damageNTSB SEA92LA168Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Brigham City, UTA partial power loss for undetermined reasons and the pilot in command's inability to execute corrective action during the noseover. A factor contributing to the accident was the berm.Jul 29, 1992 · N55625 · Substantial damageNTSB BFO92LA120Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Mount Vernon, OHThe pilot's failure to maintain airspeed which resulted in a stall.Jul 29, 1992 · N76MF · Substantial damageNTSB LAX92LA342Accident · No injuriesLimited investigationFinal reportCessna 172 · Van Nuys, CAThe student pilot's improper use of the checklist to assure that the trim tab was in the proper position and failure to follow normal procedures and directives. Contributing to this accident was the pilot's lack of total experience, misreading of the trim…Jul 26, 1992 · N2781E · Substantial damageNTSB MIA92LA153Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 · Knoxville, TNThe pilot-in-command's failure to properly instruct the passenger on aircraft controls prior to takeoff, resulting in the passenger inadvertently releasing the tow cable as the glider was being towed through 150 feet.Jul 25, 1992 · N2135R · Substantial damageNTSB FTW92LA191Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · N. Little Rock, ARThe pilot's inadvertent entry into a stall.Jul 25, 1992 · N1546J · Substantial damageNTSB CHI92FA211Accident · 2 fatalField investigationFinal reportStinson 108-3 · Boonville, MOInadequate preflight planning, and exceeding the performance capability of the airplane by the pilot-in-command.Jul 25, 1992 · N948C · DestroyedNTSB SEA92FA161Accident · 1 fatalField investigationFinal reportCessna 172I · Donnelly, IDThe pilot's failure to maintain airspeed after takeoff while using improper obstacle takeoff procedures. Factors include excessive flap extension.Jul 24, 1992 · N27JF · Substantial damageNTSB FTW92DPG10Accident · No injuriesFinal reportRockwell S2R-R3S · Minturn, ARThe loss of engine power and the encounter with unsuitable terrain during the forced landing.Jul 24, 1992 · N8441V · Substantial damageNTSB BFO92LA115Accident · Minor injuriesLimited investigationFinal reportGeorge A Chaffee Kitfox II · Shelburne, VTThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing was the pilot's diverted attention to an open door, and an inadequate preflight inspection.Jul 24, 1992 · N376GC · Substantial damageNTSB BFO92LA111Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Charleston, WVThe pilot's failure to attain adequate airspeed to outclimb obstacles.Jul 23, 1992 · N12921 · DestroyedNTSB LAX92LA310Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Sierraville, CAThe pilot's inadequate preflight of the aircraft. The contaminated fuel system and the rough terrain were factors in the accident.Jul 22, 1992 · N85778 · Substantial damageNTSB FTW92LA185Accident · No injuriesLimited investigationFinal reportBeech D55 · Pineville, LAThe mechanical binding of the yoke after liftoff.Jul 22, 1992 · N2TY · Substantial damageNTSB ATL92LA141Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Americus, GAA loss of engine power due to a crack in the number three cylinder. A factor was the soft terrain at the forced landing area.Jul 22, 1992 · N8541V · Substantial damageNTSB LAX92LA306Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Kernville, CAThe pilot's selection of the wrong runway; poorly planned approach; failure to attain the proper touch down point; and delay in executing the go-around. Contributing to this accident was the existing tailwind and crosswind.Jul 19, 1992 · N5247K · DestroyedNTSB LAX92FA305Accident · 4 fatalField investigationFinal reportCessna 175A · Overgaard, AZThe pilot's improper preflight performance planning and decision to operate the airplane over the maximum certified gross weight at a high density altitude airport which resulted in an inadvertent stall. Contributing to the accident was inadequate maintenance…Jul 19, 1992 · N8048T · DestroyedNTSB FTW92LA181Accident · No injuriesLimited investigationFinal reportCessna 120 · Reserve, LAThe loss of engine power due to the valve failure. A factor was the lack of suitable terrain for the forced landing.Jul 19, 1992 · N89970 · Substantial damageNTSB LAX92LA301Accident · 1 fatalLimited investigationFinal reportRobinson R-22 · Fresno, CAThe cfi's poor in-flight decision to proceed over the trees instead of the previously performed right circling turns and both pilots inadequate visual look-out. Contributing to this accident were the trees that partially obstructed the view of the power line…Jul 17, 1992 · N83556 · DestroyedNTSB ANC92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wasilla, AKThe pilot's improper preflight planning/decision, and his delayed aborted takeoff. Contributing was the pilot's failure to use the airplane performance data.Jul 16, 1992 · N7096K · Substantial damageNTSB LAX92LA297Accident · No injuriesLimited investigationFinal reportKrug Lincoln Sportplane · Corona, CAThe pilot/builder inadequate propeller component resulting in an inadequate climb performance. Contributing to this accident was the airplane's inability to climb.Jul 14, 1992 · N377JK · Substantial damageNTSB DEN92LA073Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Ft. Collins, COImproper rate of descent and lack of flare while conducting a forced landing. Factors were: partial power loss due to stuck exhaust valves caused by engine overheat from improper leaning.Jul 13, 1992 · N66315 · Substantial damageNTSB ANC92FA106Accident · 1 fatalField investigationFinal reportShort Brothers SC7 · Bethel, AKInadequate security of the cargo which shifted rearward during the takeoff roll. Factors which contributed to the accident were: the over gross weight condition, and the improper alteration of the tie down rings by the overhauling maintenance facility.Jul 13, 1992 · N20086 · DestroyedNTSB BFO92LA099Accident · Serious injuriesLimited investigationFinal reportPiper PA28-161 · Brentwood, NHA delay by the pilot in aborting the landing which resulted in failure to clear the obstacles.Jul 12, 1992 · N31683 · DestroyedNTSB ATL92LA136Accident · No injuriesLimited investigationFinal reportCessna 172P · Auburn, ALThe failure of the pilot to maintain directional control of the aircraft as a result of his lack of total experience.Jul 11, 1992 · N9768T · Substantial damageNTSB ANC92LA104Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Molly Creek, AKThe pilot misjudged his terrain clearance when planning his takeoff. Factors include high vegetation at the end of the runway.Jul 10, 1992 · N3997Z · Substantial damageNTSB FTW92DPG08Accident · No injuriesFinal reportGrumman G-164A · Grady, ARLoss of engine power due to a failed cylinder. A factor was the unsuitable terrain.Jul 9, 1992 · N48495 · Substantial damageNTSB CHI92DCQ06Accident · Serious injuriesFinal reportPiper PA-25-235 · Scott City, KSThe failure of the pilot in command to maintain sufficent airspeed for flight resulting in an inadvertent stall.Jul 9, 1992 · N9635P · DestroyedNTSB BFO92FA095Accident · 1 fatalField investigationFinal reportAeronca 7EC · Slatington, PAThe loss of control in flight for undetermined reasons which resulted in an inadvertent stall at an altitude insufficient for recovery.Jul 9, 1992 · N7578B · DestroyedNTSB CHI92DEM03Accident · Minor injuriesFinal reportJohansen Kitfox · Gowen, MIA total failure of the ignition system spark plugs and unsuitable terrain encountered by the pilot.Jul 7, 1992 · N820FL · Substantial damageNTSB ANC92LA101Accident · Minor injuriesLimited investigationFinal reportMooney Rans S-7 Courier · Big Lake, AKThe pilot's delayed remedial action, and an inadvertent stall. Factors include wind gusts and a wind shear.Jul 3, 1992 · N48PS · Substantial damageNTSB CHI92DCD07Accident · Serious injuriesFinal reportBernard W. Resnik ACRO-SPECIAL · Earlham, IAA loss of total engine power when a failed flapper valve in the air box blocked the flow of air through the carburetor throat.Jul 2, 1992 · N79WA · Substantial damageNTSB MIA92LA144Accident · 1 fatalLimited investigationFinal reportDofka, Martin F. KR-2 · Homestead, FLInadvertent stall by the pilot while attempting to return to the airport following loss of engine power. Contributing to the accident was the loss of power due to a sticking exhaust valve, and failure of the pilot to assure all ignition leads were connected…Jun 30, 1992 · N9667N · DestroyedNTSB DEN92LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Leadville, COThe pilot's failure to compensate for wind conditions and maintain directional control. Factors included: the pilot allowing the airplane to lift off prematurely, and gusty crosswinds.Jun 30, 1992 · N109RH · DestroyedNTSB FTW92DRA02Accident · 2 fatalFinal reportJimi Youngblood Rans Coyote II · Bryan, TXThe pilot's inadvertent stall of the airplane.Jun 29, 1992 · N12CY · Destroyed