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 NYC93LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wyantskill, NYInadequate supervision and delayed remedial action by the flight instructor. The student pilot's failure to maintain directional control and his inexperience is a contributing factor.Jun 21, 1993 · N714WF · Substantial damageNTSB NYC93LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Louisville, KYA partial power loss of undetermined origin while operating over unsuitable terrain.Jun 20, 1993 · N1698J · Substantial damageNTSB FTW93FA192Accident · Minor injuriesField investigationFinal reportBell 206L-3 · West Monroe, LAThe pilot's inadequate planning and preparation prior to takeoff, and his failure to maintain obstacle clearance. Factors were the fog and low ceilingJun 20, 1993 · N911MT · Substantial damageNTSB LAX93LA261Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas 369D · Half Moon Bay, CAthe pilots failure to maintain an adequate clearance from the light tower and associated electrical power cables. Factors in the accident were; 1) pilot fatigue due to an excessively long duty day, and 2) glare from the lights which affected the pilot's…Jun 19, 1993 · N277SP · DestroyedNTSB SEA93LA134Accident · Minor injuriesLimited investigationFinal reportRomig FR-1 · Independence, ORFuel starvation and the pilot-in-command's not maintaining directional control. Factors contributing to the accident were the pilot-in-command's not selecting the fuel boost pump and high vegetation.Jun 18, 1993 · N876FR · Substantial damageNTSB ATL93IA113Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Savannah, GALeakage of the number 7 fuel nozzle, which resulted in an in flight engine fire.Jun 18, 1993 · N467AA · Minor damageNTSB ANC93LA094Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Dry Creek, AKThe loss of engine power for undetermined reasons.Jun 18, 1993 · N318C · Substantial damageNTSB ATL93LA112Accident · Serious injuriesLimited investigationFinal reportCessna 172 · St. Elmo, ALThe pilot's failure to maintain adequate clearance from the trees located near the departure end of the runway. Factors were the pilot's failure to use the entire runway for the takeoff, and the trees located near the departure end of the runway.Jun 16, 1993 · N8322B · Substantial damageNTSB FTW93LA190Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Wynne, ARThe engine power loss for undetermined reasons and the lack of suitable terrain for a forced landing.Jun 15, 1993 · N4955X · Substantial damageNTSB CHI93LA209Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newark, ILThe pilot's premature liftoff.Jun 15, 1993 · N381CF · Substantial damageNTSB SEA93LA130Accident · No injuriesLimited investigationFinal reportBeech H35 · Douglas, WYThe improper maintenance/replacement of a fuel hose and the blocked fuel vapor return system. A factor relating to the accident was the cattle guard fence posts beside the road.Jun 14, 1993 · N368B · Substantial damageNTSB FTW93LA189Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Weiner, ARProper rotation speed not attained by the pilotJun 14, 1993 · N3098W · Substantial damageNTSB CHI93LA205Accident · No injuriesLimited investigationFinal reportCessna 172P · Hartford, WIThe failure of the number four cylinder and unsuitable terrain.Jun 14, 1993 · N55404 · Substantial damageNTSB LAX93LA252Accident · No injuriesLimited investigationFinal reportCessna 210L · Douglas, AZThe pilot's premature retraction of the landing gear and flaps at a critical time in the takeoff initial climb and his failure to attain an adequate climb airspeed which resulted in an inadvertent stall/mush condition. A factor in the accident was the high…Jun 13, 1993 · N29133 · Substantial damageNTSB CHI93DCG01Accident · 2 fatalFinal reportEmory W. Greer, JR. VARI-EZE · Olathe, KSthe pilot's failure to secure a fuel cap during the preflight inspection of the airplane, and the pilot's failure to maintain aircraft control during the emergency landing. Factors associated with the accident are the unsecured fuel cap and the foreign object…Jun 13, 1993 · N222EG · DestroyedNTSB MIA93FA141Accident · 1 fatalField investigationFinal reportCessna 150J · Niceville, FLThe inadequate annual inspection of the airplane by other maintenance personnel and the failure of the pilot to maintain airspeed above a stall.Jun 12, 1993 · N60366 · Substantial damageNTSB CHI93LA206Accident · Serious injuriesLimited investigationFinal reportClaude E. Merrin Zenair Stol CH-701 · Grayslake, ILThe pilot-in-command's failure to maintain aircraft control. The pilot-in-command's lack of total experience in aircraft type was a factor.Jun 12, 1993 · N701CM · DestroyedNTSB ATL93LA109Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCPoor maintenance practices during the rebuilding of the aircraft which allowed the fuel system to become contaminated and resulted in the subsequent fuel starvation of the engine.Jun 12, 1993 · N1619D · Substantial damageNTSB FTW93LA186Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Edgewood, NMPower loss to the right engine due to the magneto grounding leads being loose and an inadequate annual inspection. A factor was a lack of suitable terrain.Jun 11, 1993 · N8606M · Substantial damageNTSB CHI93GA204Accident · 2 fatalFinal reportBeech 95-C55 · Fort Madison, IAthe pilot-in command's failure to maintain control of the aircraft. Factors were door not secured, checklist not followed, diverted attention of the pilot-in-command, and emergency procedure not followed.Jun 11, 1993 · N301U · Substantial damageNTSB MIA93LA140Accident · No injuriesLimited investigationFinal reportMooney M20E · Miami, FLThe pilot-in-command's improper flare during a forced landing which resulted in a hard landing. Contributing to the accident was the total loss of engine power for undetermined reasons.Jun 10, 1993 · N1305W · Substantial damageNTSB ATL93LA108Accident · No injuriesLimited investigationFinal reportCessna 421B · Attalla, ALThe failure of the left engine turbocharger due to rotor shaft seizure, which resulted in a loss of engine power.Jun 10, 1993 · N699DT · DestroyedNTSB FTW93LA184Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Canyon Lake, TXThe movement of the pilot's seat aft which resulted in his loss of control, his inability to regain control, and the ensuing inadvertent stall. A factor was the inadequate inspection of the airplane.Jun 9, 1993 · N6446B · Substantial damageNTSB NYC93LA106Accident · Serious injuriesLimited investigationFinal reportHenry J. Camacho Seahawk · Orange, MAThe pilot's excessive rotation and failure to obtain adequate airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the pilot's inexperience in the type aircraft.Jun 8, 1993 · N5857X · DestroyedNTSB FTW93LA181Accident · No injuriesLimited investigationFinal reportDrlik Falcon XC · Albuquerque, NMThe extraneous and uncommanded roll and yaw deviations caused by inadequate airplane design which precluded the pilot from taking corrective action and led to the ensuing hard landing.Jun 8, 1993 · N687RD · Substantial damageNTSB CHI93FA193Accident · 1 fatalField investigationFinal reportBeech E18S · Ypsilanti, MIThe pilot-in-command's inadequate preflight preparation, false indication (on/off) of attitude indicator, and attitude indicator switched off. Factors were fog, low ceiling, the pilot-in-command's improper use of the attitude indicator, and his lack of total…Jun 8, 1993 · N51FG · DestroyedNTSB BFO93GA102Accident · 2 fatalFinal reportBeech B24R · Manassas, VAFailure of the pilot to maintain adequate airspeed while maneuvering for a precautionary landing which resulted in an inadvertent stall. A related factor was that the pilot's attention was diverted by the open door.Jun 7, 1993 · N824V · DestroyedNTSB DEN93LA067Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5 · Watkins, COSpatial disorientation which prevented the pilot from maintaining control. A factor was: low ceiling.Jun 6, 1993 · N7129L · Substantial damageNTSB CHI93LA191Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Kewanee, ILThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the pilot's inadvertent stall/mush during the forced landing.Jun 6, 1993 · N8236C · Substantial damageNTSB ANC93FA081Accident · Minor injuriesField investigationFinal reportCessna A185E · Anchorage, AKThe pilot in command exceeding the maximum authorized gross takeoff weight of the airplane and his failure to compensate for the wind conditions. A factor in the accident was the gusty wind condition.Jun 6, 1993 · N70020 · Substantial damageNTSB FTW93LA177Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Crowley, LASevere propeller and airframe vibration for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jun 5, 1993 · N2002E · Substantial damageNTSB ATL93LA104Accident · Minor injuriesLimited investigationFinal reportHatz CB-1 · Stedman, NCThe improper positioning of the main fuel tank drain, which resulted in fuel starvation and engine stoppage. A factor were trees in the forced landing area.Jun 5, 1993 · N4426V · Substantial damageNTSB LAX93LA240Accident · No injuriesLimited investigationFinal reportCessna 150D · Biggs, CAThe first pilot's premature lift-off and his failure to maintain directional control.Jun 3, 1993 · N6030T · Substantial damageNTSB NYC93LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Gordonsville, VAWas a power loss due to fuel contamination, after the pilot refueled from cans and did not filter the fuel according to recommendations.Jun 1, 1993 · N9830W · Substantial damageNTSB ATL93LA098Accident · Minor injuriesLimited investigationFinal reportGrumman AA5B · Cummings, GAThe loss of engine power resulting from the formation of carburetor ice during the ground operation. A factor was the pilot's failure to obtain a weather briefing.May 31, 1993 · N74092 · Substantial damageNTSB ANC93LA074Accident · No injuriesLimited investigationFinal reportCessna 170 · Soldotna, AKThe inadequate handling of the airplane by the pilot-in-command.May 31, 1993 · N1260D · Substantial damageNTSB DEN93LA064Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Nimbus II · Buena Vista, COFailure to follow procedures and directives when operating the flaps.May 30, 1993 · N173 · Substantial damageNTSB MIA93LA136Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Laurel, MSA ruptured center bellows seal in the fuel servo and/or a plugged fuel injector due to contamination (rust) from the fuel servo. Factors related to the accident were: improper servicing of the aircraft, and people and trees in the emergency landing area.May 29, 1993 · N5783V · Substantial damageNTSB FTW93LA170Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Searcy, ARTotal power loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.May 27, 1993 · N5272Y · Substantial damageNTSB BFO93LA101Accident · No injuriesLimited investigationFinal reportCessna 150 · Brandenburg, KYThe pilot's failure to attain adequate airspeed prior to liftoff, leading to an inadvertent stall and loss of aircraft control. Factors related to the accident include the pilot's improper use of flaps and his failure to follow the published procedures for a…May 27, 1993 · N60347 · Substantial damageNTSB SEA93LA121Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Afton, WYA loss of engine power for an undetermined reason(s).May 25, 1993 · N7569Y · DestroyedNTSB MIA93FA129Accident · Serious injuriesField investigationFinal reportBeech F33A · Oxford, MSLoss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.May 23, 1993 · N3144H · Substantial damageNTSB SEA93LA117Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Brigham City, UTThe premature liftoff by the PIC and his failure to attain proper rate of climb. Factors relating to the accident were the gusty crosswind weather conditions, the failure of the PIC to use all available runway, and transmission wires.May 21, 1993 · N8589K · DestroyedNTSB ANC93LA066Accident · No injuriesLimited investigationFinal reportCessna 180H · Ketchikan, AKThe pilot in commands improper compensation for the wind condition. A factor in the accident was the unfavorable wind.May 19, 1993 · N8237V · DestroyedNTSB SEA93LA109Accident · Minor injuriesLimited investigationFinal reportRainey Aero Phaeton · Mead, WAThe pilot in command's inadvertently entering a stall condition. A factor contributing to the accident was gusts.May 17, 1993 · N54BR · Substantial damageNTSB SEA93LA108Accident · No injuriesLimited investigationFinal reportGrove GR-2 · Buckley, WAThe pilot's premature liftoff. The pilot's failure to maintain directional control and the high vegetation beside the runway were factors.May 16, 1993 · N84GR · DestroyedNTSB DEN93LA062Accident · No injuriesLimited investigationFinal reportSchleicher ASH 25 E · Peyton, COThe encounter with a downdraft.May 15, 1993 · N555AB · Substantial damageNTSB BFO93LA088Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairmont, WVFailure of the pilots to properly clear the engine during the approach.May 15, 1993 · N16224 · Substantial damageNTSB CHI93LA168Accident · No injuriesLimited investigationFinal reportCessna 150L · Washington, MOThe pilot's failure to maintain proper runway alignment.May 13, 1993 · N10011 · Substantial damageNTSB BFO93LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Paintsville, KYFailure of the pilot to maintain adequate altitude or clearance from the terrain. Factors related to the accident were the unfavorable wind condition and the proximity of the hill to the runway.May 13, 1993 · N6001U · Destroyed