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 ATL92FA181Accident · 4 fatalField investigationFinal reportCessna 210B · Andrews, NCThe pilot's attempted takeoff in foggy conditions, and his failure to maintain aircraft control during the initial climbout, which resulted in an inadvertent stall and impact with terrain. Factors were the prevailing fog and the night lighting conditions.Sep 15, 1992 · N9622X · DestroyedNTSB ATL92LA180Accident · No injuriesLimited investigationFinal reportCessna 320 · Darlington, SCThe improper servicing of the airplane with contaminated fuel by the owner pilot.Sep 14, 1992 · N5754X · Substantial damageNTSB NYC92FA185Accident · 1 fatalField investigationFinal reportCessna 150F · Lake Neepaulin, NJAn inflight collision with trees after the pilot failed to outclimb the terrain. Factors related to the accident were the pilot's improper use of the flaps and the pilot's decision to operate the airplane over the maximum allowable gross weight.Sep 13, 1992 · N8725G · Substantial damageNTSB DEN92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Greeley, COTotal loss of engine power due to a deteriorated carburetor float which resulted in engine flooding. A factor was: unsuitable terrain for a forced landing.Sep 13, 1992 · N5703E · Substantial damageNTSB CHI92LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Marlette, MIThe pilot-in-command's (CFI) inadequate supervision of the dual student pilot and the dual student's inadvertent application of the brakes.Sep 11, 1992 · N50905 · Substantial damageNTSB ANC92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot in commands failure to abort the takeoff and his misjudgment of the distance required to perform a safe takeoff under the conditions present.Sep 9, 1992 · N1999P · Substantial damageNTSB DCA92MA048Accident · 12 fatalMajor investigationFinal reportBeech C-45H · Hinckley, ILInadequate maintenance and inspection by the operator which resulted in an engine power loss during the critical takeoff phase of flight. In addition, the pilot did not, or was unable to, attain a full-feather position on the left engine propeller, which…Sep 7, 1992 · N3657G · DestroyedNTSB ATL92LA175Accident · No injuriesLimited investigationFinal reportCessna 140 · Blairsville, GAA complete loss of engine power which resulted from two stuck exhaust valves.Sep 5, 1992 · N2059V · Substantial damageNTSB ANC92LA158Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Skwentna, AKPilot misjudged performance capability for tailwind condition considering aircraft load and terrain. Factors related to the accident were: terrain, takeoff airspeed not attained, aircraft performance, pilot overconfidence in aircraft and personal ability.Sep 5, 1992 · N5106H · Substantial damageNTSB ANC92LA156Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Port Alsworth, AKThe improper maneuver that unported the low fuel tank. The unsuitable terrain at the site of forced landing was a factor.Sep 4, 1992 · N8420D · Substantial damageNTSB LAX92LA373Accident · No injuriesLimited investigationFinal reportCessna 170A · Holtville, CAThe pilot's encounter with the unforecasted dust devil.Sep 2, 1992 · N9923A · Substantial damageNTSB CHI92LA262Accident · No injuriesLimited investigationFinal reportCessna 152 · Crete, NEA premature lift-off and failure to perform remedial action. Lack of expereince in short field takeoffs was a factor.Sep 2, 1992 · N6480M · Substantial damageNTSB CHI92DEP05Accident · No injuriesFinal reportReif Avid Flyer · Shiocton, WIFailure of the pilot-in-command to obtain a proper climb rate, and his lack of total expereince in the type of airplane.Sep 2, 1992 · N4220X · Substantial damageNTSB BFO92LA121Accident · No injuriesLimited investigationFinal reportCessna 172H · New Braintree, MAWater contaminated fuel which resulted in the loss of engine power and the pilot's inadequate preflight inspection.Sep 2, 1992 · N2458L · Substantial damageNTSB FTW92LA221Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Angel Fire, NMThe pilot's inadequate evaluation of the environmental conditions which resulted in exceeding the climb capability of the aircraft. The inadvertent stall was also a cause. Factors were the downdraft and high density altitude.Aug 31, 1992 · N11080 · Substantial damageNTSB ANC92LA150Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Sparrevohn, AKPilot exercised poor preflight planning/preparation by taking off with a tailwind component. Factors relating to the accident were: the unfavorable wind in the area and the rising hilly/mountainous terrain in the takeoff path.Aug 31, 1992 · N786BH · DestroyedNTSB SEA92LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Blackfoot, IDThe pilot's failure to use proper airspeed for takeoff, resulting in loss of control during initial climb. Factors relating to the accident were the high da weather conditions, power line obstructions and a highway with a dirt bank at the end of the runway.Aug 30, 1992 · N3545Y · Substantial damageNTSB NYC92LA184Accident · Minor injuriesLimited investigationFinal reportWilliam C. Keiling Prober Pixie · Cumberland, MDAn inadvertent stall/spin, following a power loss due to fuel contamination. Factors related to the accident were the failure of the pilot to detect the rust particles and water in the fuel system prior to takeoff and his lack of total experience in the…Aug 30, 1992 · N103WK · Substantial damageNTSB NYC92LA181Accident · Minor injuriesLimited investigationFinal reportBeech A24 · Simsbury, CTA power loss due to a fuel line blocked with dirt and sludge, while operating over unsuitable terrain. A factor related to the accident was the failure of the owner/pilot to detect the dirt and sludge in the fuel system prior to takeoff.Aug 30, 1992 · N866Y · Substantial damageNTSB ANC92IA147Incident · No injuriesIncident investigationFinal reportShort Brothers SH-7 · Sheldon Point, AKThe unlatching of the left crew entrance door by means undetermined and the lack of adherence to door check items by the pilot in command on the requisite checklists. A factor relating to the incident was the separation of the door from the frame when opened…Aug 30, 1992 · N53NS · Minor damageNTSB LAX92LA369Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Atwater, CAThe partial loss of engine power for undetermined reasons and the pilots failure to attain the proper touchdown point during the subsequent forced landing attempt back on the runway. Factors in the accident were the tail wind condition encountered during the…Aug 29, 1992 · N7250F · Substantial damageNTSB DEN92FA088Accident · 4 fatalField investigationFinal reportCessna 175A · Pagosa Springs, COThe pilot experiencing spatial disorientation and his failure to maintain aircraft control. Factors were: the pilot's total lack of instrument experience and dark night conditions.Aug 29, 1992 · N7032E · DestroyedNTSB CHI92FA257Accident · 3 fatalField investigationFinal reportCessna 310D · Crystal, MNThe pilot's failure to maintain aircraft control during takeoff/initial climb in gusty, shifting crosswind conditions.Aug 29, 1992 · N6908T · DestroyedNTSB ATL92FA167Accident · 2 fatalField investigationFinal reportCessna 402B · Miramar, FLThe failure of the pilot to perform preflight planning in that the weight and balance of the aircraft were exceeded. The pilot's lack of experience in the type of aircraft and lack of multiengine certification.Aug 27, 1992 · N6AT · Substantial damageNTSB FTW92FA218Accident · 3 fatalField investigationFinal reportFairchild SA 227-AC · Hot Springs, ARInadequate maintenance and inspection by the operator's maintenance personnel, and the failure of the pilot-in-command to assure proper travel direction of the airplane's primary flight controls after being made aware of the nature of the maintenance…Aug 25, 1992 · N342AE · DestroyedNTSB FTW92DQG01Accident · Minor injuriesFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's selection of a downwind runway for takeoff. A factor was the tailwind.Aug 25, 1992 · N4334S · Substantial damageNTSB CHI92LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marseilles, ILThe pilot-in-command's failure to abort the takeoff. A factor was the partial loss of engine power.Aug 25, 1992 · N5544J · Substantial damageNTSB SEA92LA188Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Snoqualmie, WAThe pilot's not maintaining control of the aircraft because of incapacitation resulting from both hypoglycemia/diet and loss of consciousness.Aug 24, 1992 · N71183 · DestroyedNTSB ANC92LA143Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Harding Lake, AKThe partial loss of engine power for undetermined causes, and the unsuitable terrain.Aug 24, 1992 · N7887H · Substantial damageNTSB FTW92LA217Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Farmington, NMTotal loss of engine power due to carburetor ice and the pilot's delayed use of carburetor heat. A factor was unsuitable terrain.Aug 23, 1992 · N8841D · Substantial damageNTSB CHI92DEM05Accident · Serious injuriesFinal reportTaylorcraft H-2 · Holland, MINot maintaining a sufficient airspeed during the reversal turn and encountering a stall/spin maneuver.Aug 22, 1992 · N15672 · Substantial damageNTSB ANC92LA140Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Togiak, AKThe pilot's improper preflight planning/decision, and his delay in aborting the takeoff. Contributing factors were the berm and the standing water on the runway.Aug 22, 1992 · N8402S · Substantial damageNTSB LAX92LA357Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Jackpot, NVThe pilot allowing himself to become distracted while searching for a landing light switch during a critical phase of flight and the resultant failure to maintain control of the aircraft. Factors in the accident were the dark night light conditions and the…Aug 19, 1992 · N93336 · Substantial damageNTSB CHI92LA245Accident · No injuriesLimited investigationFinal reportCessna 182A · Colfax, INThe pilot's selection of the wrong runway and a premature lift off. Factors were uphill terrain and unfavorable (quartering/tail) wind.Aug 19, 1992 · N5197D · Substantial damageNTSB ATL92FA162Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Lawrenceville, GAThe pilot's failure to maintain aircraft control which resulted in an inadvertent stall, and his improper execution of emergency procedures. Factors were the pilot's overconfidence, his inadequate preflight inspection when he failed to drain the gascolator,…Aug 19, 1992 · N5640W · Substantial damageNTSB NYC92LA167Accident · No injuriesLimited investigationFinal reportCessna A188A · Felton, DEThe pilot's failure to abort the takeoff at a timely point which resulted in an inadequate climb rate an a collision with trees.Aug 18, 1992 · N6664G · DestroyedNTSB FTW92LA213Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Clarendon, ARThe pilot's failure to consult the airplane's performance data and ensure that adequate field length was available for takeoff.Aug 18, 1992 · N2357N · Substantial damageNTSB FTW92LA211Accident · No injuriesLimited investigationFinal reportBeech G35 · La Porte, TXThe loss of engine power for undetermined reasons. Factors were the dark night and the lack of suitable terrain available for the forced landing.Aug 18, 1992 · N4604D · Substantial damageNTSB ANC92LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Mackey Lake, AKA loss of power for undetermined reasons. A factor which contributed to the severity of the accident was the pilot inadvertently stalled the airplane.Aug 18, 1992 · N4714Y · Substantial damageNTSB SEA92LA180Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Pocatello, IDAn undetermined loss of engine power. A factor to the accident was: an in flight planning/decision delay.Aug 17, 1992 · N736PS · Substantial damageNTSB CHI92DET01Accident · Serious injuriesFinal reportFrost Briegleb/BG-12A · Lake Village, INInadvertent stall and spin with inadequate altitude for recovery.Aug 16, 1992 · N163MF · Substantial damageNTSB CHI92DEP03Accident · Serious injuriesFinal reportStuart J. Carter Moni · Eau Claire, WIThe pilot-in-command's failure to maintain airspeed.Aug 15, 1992 · N3944C · Substantial damageNTSB NYC92FA164Accident · Serious injuriesField investigationFinal reportBeech D55 · Oxford, METhe pilot's improper preflight and fuel tank selection for takeoff, which resulted in fuel starvation and loss of power in both engines during takeoff.Aug 14, 1992 · N14WW · Substantial damageNTSB ANC92LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Eisenmenger Crk, AKThe pilot's improper preflight planning/preparation, and his failure to attain clearance of the high vegetation during takeoff. A contributing factor to the accident was the high vegetation.Aug 13, 1992 · N3889P · Substantial damageNTSB FTW92DPG14Accident · No injuriesFinal reportAir Tractor AT-300 · Wilmont, ARPower loss due to a failed cracked cylinder. A factor was the lack of suitable terrain for the forced landing.Aug 12, 1992 · N4420S · Substantial damageNTSB FTW92LA206Accident · Serious injuriesLimited investigationFinal reportCessna T-210N · Palestine, TXThe pilot's disregard of the checklist and the resulting inadvertent stall mush during takeoff.Aug 11, 1992 · N79MM · DestroyedNTSB ATL92LA157Accident · No injuriesLimited investigationFinal reportBeech 23-B24R · Walterboro, SCThe inadequate preflight planning by the pilot in command. Factors were the soft runway, and the high density altitude which existed at the time of the attempted departure.Aug 11, 1992 · N6540R · Substantial damageNTSB ATL92LA156Accident · Serious injuriesLimited investigationFinal reportCessna 441 · Gainesville, GAThe poor inflight decision by the pilot in command in that after a partial loss of power, he shut down the wrong engine, did not follow the emergency checklist, did not raise the flaps, and did not retract the landing gear. A factor in the accident was the…Aug 10, 1992 · N920C · Substantial damageNTSB ANC92LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Cinnibar, AKThe partial loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.Aug 9, 1992 · N9557D · Substantial damageNTSB NYC92LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Baltimore, MDA power loss due to fuel starvation from a faulty rubber seal in the mechanical fuel pump while operating over unsuitable terrain. An additional cause was the use of inadequate standards for the production of the rubber seal.Aug 8, 1992 · N6384C · Substantial damage