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 MIA91LA187Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Meridian, MSLoss of power from the right engine due to undetermined reasons. The failure of the propeller to feather was a factor in the accident.Jul 17, 1991 · N711SF · DestroyedNTSB ANC91LA101Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Chataniak Vly, AKPartial loss of engine power for an undetermined reason.Jul 17, 1991 · N84903 · Substantial damageNTSB SEA91LA169Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Bend, ORPoor preflight planning/preparation by the pilot in command. Factors to the accident were: high density altitude, excessive climb rate, inadequate remedial action, and lack of total flight expereince.Jul 14, 1991 · N24576 · Substantial damageNTSB NYC91LA181Accident · No injuriesLimited investigationFinal reportErcoupe 415D · Sacramento, KYThe pilot's decision to conduct flight with a known deficiency that adversely affected the aerodynamic characteristics of the aircraft.Jul 14, 1991 · N980DD · DestroyedNTSB LAX91FA310Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Hesperia, CAThe pilot's improper refueling and inadequate preflight which resulted in fuel contamination and the inadvertent stall.Jul 14, 1991 · N515TW · DestroyedNTSB SEA91LA168Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Naches, WAThe pilot's poor in-flight decision. Factors include high density altitude, high winds and downdrafts.Jul 13, 1991 · N2184G · DestroyedNTSB MIA91LA185Accident · 1 fatalLimited investigationFinal reportDonald R. Lee AIR Command · Quitman, MSThe pilot in commands failure to maintain control resulting in an uncontrolled descent and an in flight collision with terrain.Jul 13, 1991 · N7165P · DestroyedNTSB CHI91FA208Accident · 1 fatalField investigationFinal reportTemco D-16A · Eau Claire, MIThe improper replacement of the fuel selector lever which resulted in loss of engine power due to fuel staration.Jul 13, 1991 · N88T · Substantial damageNTSB CHI91DEM06Accident · 1 fatalFinal reportAeronca 11-AC · Central Lake, MIA result of the pilot in command not maintaining aircraft control and not performing remedial action after the airplane entered the steep descent. A factor contributing to this accident was the pilot in command's lack of recent experience.Jul 11, 1991 · N86083 · DestroyedNTSB LAX91LA302Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAThe erection of a construction sign on an active runway by county workers without notifying the airport operators, and, the inability of the pilot to detect the presence of the sign during the dark night takeoff.Jul 10, 1991 · N4538K · DestroyedNTSB LAX91LA296Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Minden, NVThe flight instructor's inadequate supervision of the student pilot during a simulated emergency.Jul 8, 1991 · N9598H · Substantial damageNTSB ATL91LA126Accident · Serious injuriesLimited investigationFinal reportMoeckel Bakeng Duce · Dawson, GAThe pilot's abrupt rotation after failing to maintain directional control during takeoff roll, and his failure to maintain airspeed during the initial climb, which resulted in a stall. A factor in the accident was: the pilot's lack of familiarity with the…Jul 8, 1991 · N28372 · Substantial damageNTSB SEA91LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bryce Canyon, UTThe pilot's entry into a stall/mush condition shortly after take off. Contributing to the accident was the high density altitude.Jul 7, 1991 · N5961U · Substantial damageNTSB LAX91LA293Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Shoshone, CAAn electrical short of the battery cable.Jul 7, 1991 · N29BB · DestroyedNTSB MIA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Valparaiso, FLPartial loss of engine power due to fuel contamination due to an inadequate preflight by the pilot in command and failure of the pilot to extend the landing gear during the forced landing.Jul 6, 1991 · N5953P · Substantial damageNTSB ANC91LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Eureka, AKThe pilot-in-command's failure to maintain airspeed and directional control of the airplane during the initial climb.Jul 6, 1991 · N9579D · Substantial damageNTSB SEA91LA153Accident · Minor injuriesLimited investigationFinal reportDerego Avid Flyer/B · Myrtle Creek, ORLoss of engine power for an undetermined reason.Jul 4, 1991 · N220B · Substantial damageNTSB NYC91LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAImproper use of the flight controls by the pilot which resulted in an inadvertent stall on takeoff with insufficient altitude for recovery. Factors related to the accident was the failure of the pilot to properly set the elevator trim prior to takeoff and the…Jul 4, 1991 · N7315D · Substantial damageNTSB CHI91LA209Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hill City, SDPoor preflight planning by the pilot and over confidence in the aircrafts ability. Factors related to the accident were a high density altitude and a proper climb rate not attained.Jul 4, 1991 · N1844G · Substantial damageNTSB NYC91LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rhinebeck, NYThe pilot did not calculated the airplane's performance data to insure that he had enough runway to clear an obstacle at the end of the field, which resulted in the airplane's landing gear striking high hedges, subsequently the pilot elected to land in a…Jul 2, 1991 · N5002F · Substantial damageNTSB NYC91LA166Accident · Minor injuriesLimited investigationFinal reportCessna C-172 · Clarence Center, NYFailure of the pilot to maintain airspeed during a heavy weight takeoff, resulting in a stall and landing in rough terrain.Jul 2, 1991 · N733FB · DestroyedNTSB FTW91LA114Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus CM · Marfa, TXThe pilot misjudged the approach. Factors were the high density altitude, the downdraft, and the dteriorted climb performance.Jul 2, 1991 · N9999R · Substantial damageNTSB NYC91LA162Accident · No injuriesLimited investigationFinal reportMaule M6-235 · Arcade, NYThe failure of the pilot to attain the proper lift-off speed during a takeoff on a grass runway, resulting in a loss of control and collision with power lines. A factor related to the accident was the pilot's lack of understanding of the airplane's…Jul 1, 1991 · N43LH · Substantial damageNTSB NYC91LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Nayville, NYFailure of the pilot to attain adequate airspeed to climb, which resulted in a stall/mush. The trees were a related factor.Jul 1, 1991 · N8670D · Substantial damageNTSB CHI91DER10Accident · Serious injuriesFinal reportKolb Twinstar MK II · Staples, MNThe disconnected elevator trim cable. Related factors are the inadequate maintenance/installation, and the pilot's inability to maintain aircraft control.Jun 30, 1991 · N503BP · DestroyedNTSB DEN91LA092Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Albuquerque, NMThe pilot's improper maintenance of the aircraft. Factors were: a loose oil filter and loss of engine oil.Jun 29, 1991 · N21420 · Substantial damageNTSB MIA91FA172Accident · Serious injuriesField investigationFinal reportCessna 411 · North Ft. Myers, FLThe pilot in commands failure to follow emergency procedures and his failure to maintain airspeed following loss of power in one engine resulting in an inadvertent stall and the inflight loss of control with subsequent inflight collision with an object and…Jun 28, 1991 · N4940T · DestroyedNTSB FTW91LA110Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Addison, TXEntry door opening in flight, inadequate emergency procedures published by the manufacturer, and poor emergency training by the student's instructor. Factors were inadequate design/installation of the door locking mechanism, deteriorated airplane performance,…Jun 28, 1991 · N18989 · Substantial damageNTSB FTW91FA109Accident · Serious injuriesField investigationFinal reportNorth American NA1 · Mountain Home, ARThe contamination of the airplane's fuel system and the foreign object blockage of the vapor return orifice which induced the power loss. A factor was the lack of suitable terrain.Jun 28, 1991 · N91108 · DestroyedNTSB CHI91DER09Accident · No injuriesFinal reportEagle Eagle DW-1 · Windom, MNThe pilot's improper aircraft handling. Related factors are the pilot's inattention and the airplane's deteriorated performance capability.Jun 28, 1991 · N88142 · Substantial damageNTSB ANC91LA078Accident · No injuriesLimited investigationFinal reportMaule M4-220-C · Fairbanks, AKThe pilot's failure to maintain airspeed during the initial climb and exceeding the gross weight of the airplane. Contributing to the accident was high vegetation.Jun 21, 1991 · N40304 · Substantial damageNTSB ANC91LA076Accident · 2 fatalLimited investigationFinal reportTaylorcraft BC-65 · Kakhonak, AKThe uncertificated pilot failed to maintain aircraft control during the initial climb and the physical impairment by drugs (marijuana) of the pilot. Contributing to the accident was the stall which was not identified by the nonrated pilot.Jun 18, 1991 · N37611 · Substantial damageNTSB FTW91DRA04Accident · No injuriesFinal reportCessna 188B · Wallis, TXThe partial power loss during a critical phase of flight. A factor was the lack of suitable terrain onto which a successful forced landing could have been executed.Jun 17, 1991 · N4719Q · DestroyedNTSB ATL91LA113Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Camilla, GARestricted exhaust valve movement, low cylinder compression, and fouling of the engine spark plugs, which resulted in the loss of engine power. Factors were the improper servicing of the aircraft, and the use of an improper fuel grade.Jun 17, 1991 · N8549V · Substantial damageNTSB CHI91LA193Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Spirit Lake, IAImproper use of carburetor heat by the pilot and unsuitable terrain.Jun 16, 1991 · N9008X · Substantial damageNTSB CHI91DTG03Accident · No injuriesFinal reportSchweizer G164 · Gwinner, NDInadvertent closing of the mixture by the pilot. Factors related to the accident are inadequate control shape, or size, and inattentiveness of the pilot.Jun 16, 1991 · N48687 · Substantial damageNTSB ANC91LA075Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Beluga, AKThe pilot's failure to use proper takeoff procedures. Contributing to the accident was the tailwind, and the rising terrain.Jun 16, 1991 · N1846P · Substantial damageNTSB SEA91LA132Accident · Minor injuriesLimited investigationFinal reportDuffy Smith Mini Plane · Ogden, UTA premature liftoff and subsequent stall.Jun 15, 1991 · N27JD · Substantial damageNTSB FTW91LA100Accident · No injuriesLimited investigationFinal reportCessna 150 · Berryville, ARThe loss of engine power for unknown reasons and the pilot's improper flare which resulted in a hard landing.Jun 15, 1991 · N5954E · Substantial damageNTSB ATL91FA110Accident · 1 fatalField investigationFinal reportCessna 150J · Monroe, GAThe pilots attempted flight in adverse weather and the physical impairment of the student pilot from the consumption of alcoholic beverages prior to flight. A factor in the accident was the foggy weather condition at the airport.Jun 15, 1991 · N60466 · Substantial damageNTSB CHI91DER07Accident · No injuriesFinal reportPiper PA-36-375 · Breckentidge, MNThe pilot's failure to take adequate remedial action during the attempted climb out. A related factor is the premature lift off.Jun 14, 1991 · N3866E · Substantial damageNTSB LAX91LA259Accident · Minor injuriesLimited investigationFinal reportPiper J3L · Shasta Lake, CAThe pilot-in-command's failure to maintain airspeed on initial takeoff climb resulting in an in flight loss of control, stall, and inflight collision with terrain/water.Jun 12, 1991 · N23195 · Substantial damageNTSB NYC91FA144Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · East Haddam, CTThe non-mechanical loss of engine power due to the failure of the pilot to use the auxiliary fuel boost pump during takeoff.Jun 9, 1991 · N2876Z · Substantial damageNTSB LAX91LA257Accident · 1 fatalLimited investigationFinal reportSchweizer 269B · Cottonwood, CAThe pilot's inadequate visual lookout. The transmission wire was a factor in the accident.Jun 9, 1991 · N103AB · DestroyedNTSB LAX91FA252Accident · 3 fatalField investigationFinal reportCessna 182 · Bermuda Dunes, CAThe pilot-in-command's failure to maintain airspeed while maneuvering to return to the departure airport, resulting in an in flight loss of control, stall, and in flight collision with terrain. Factors related to the accident were: partial loss of engine…Jun 8, 1991 · N7299E · DestroyedNTSB ANC91FA067Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · Wasilla, AKThe powerplant failure for undetermined reasons and the collision with the wires.Jun 8, 1991 · N4319Z · Substantial damageNTSB FTW91LA093Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Angleton, TXThe pilot's loss of consciousness due to a pre-existing infection.Jun 6, 1991 · N26785 · Substantial damageNTSB LAX91LA245Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Williams, AZThat the flight encountered windshear and that aircraft control was not possible.Jun 5, 1991 · N484ER · Substantial damageNTSB ATL91LA107Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Spring Creek, NCThe pilot's inadequate preflight planning/preparation, and his failure to attain adequate airspeed to avoid obstructions and terrain, which resulted in a stall/mush. Factors related to the accident were: the unfavorable wind, obstructions, and terrain…Jun 5, 1991 · N96743 · Substantial damageNTSB DEN91LA078Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Fayetteville, ARThe pilot failed to apply carburetor heat.Jun 3, 1991 · N76404 · Substantial damage