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 SEA99FA144Accident · 1 fatalField investigationFinal reportBeech F33A · White Swan, WAInadequate preflight planning/preparation and low airspeed. A dirt embankment, soft runway, and an excessive takeoff weight were factors.Aug 19, 1999 · N2291L · Substantial damageNTSB LAX99LA264Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA 20-A1 · San Carlos, CAThe release of the aircraft's left canopy latch following takeoff resulting in the subsequent opening of the canopy in flight. The opened canopy resulted in a degradation of aircraft control and the subsequent hard landing.Aug 18, 1999 · N854DF · Substantial damageNTSB NYC99GA197Accident · Minor injuriesFinal reportBell 407 · Georgetown, DEThe pilot's improper preflight evaluation of the weather, which resulted in inadvertent flight into IMC. Factors were the fog, and night conditions.Aug 17, 1999 · N97SP · DestroyedNTSB CHI99LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Harsens Island, MIthe loss of engine power for undetermined reasons. Factors were the berm and the pond.Aug 17, 1999 · N44547 · Substantial damageNTSB FTW99FA222Accident · 1 fatalField investigationFinal reportPiper PA30 · Holdenville, OKthe pilot's failure to maintain aircraft control during takeoff initial climb. Factors were the loss of right engine power for undetermined reasons, and the pilot's lack of total experience in the make and model of aircraft.Aug 16, 1999 · N7178Y · DestroyedNTSB DEN99LA145Accident · No injuriesLimited investigationFinal reportCessna 337 · Edgewood, NMBreakage of the safety wire that secured the propeller control cable to the support bracket. Factors were the inability of the pilot to feather the propeller or change propeller rpm, and rough, uneven, and unsuitable terrain on which to make a forced landing.Aug 15, 1999 · N99MH · Substantial damageNTSB ANC99LA114Accident · No injuriesLimited investigationFinal reportCessna 206A · Cordova, AKA loss of engine power due to corrosion/blockage of the fuel flow divider vent hole. A factor was unsuitable terrain for a forced landing.Aug 15, 1999 · N4605F · Substantial damageNTSB SEA99LA143Accident · No injuriesLimited investigationFinal reportCessna 210B · Port Angeles, WAThe failure of maintenance personnel to detect cracked main landing gear saddles during required inspection, and subsequent fatigue fracture of the left main landing gear saddle resulting in separation of the saddle and disabling of the left main gear.Aug 14, 1999 · N9588X · Substantial damageNTSB FTW99LA227Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Rockwall, TXThe mechanic's improper machining of the crankshaft during a major overhaul, which resulted in a fatigue crack and subsequent failure of the crankshaft. A factor was the lack of suitable terrain for the forced landing.Aug 14, 1999 · N3184E · Substantial damageNTSB CHI99FA296Accident · 1 fatalField investigationFinal reportJohannes-Robert Acrosport RJ-2 · Campbellsport, WIThe loss of control during initial climb for undetermined reasons.Aug 14, 1999 · N42J · DestroyedNTSB CHI99LA288Accident · No injuriesLimited investigationFinal reportCessna 172G · Glenarm, ILthe pilot's selection of the wrong runway for the prevailing winds. Factors were the pilot's misunderstanding of the wind information and the tailwind.Aug 13, 1999 · N4425L · Substantial damageNTSB MIA99LA223Accident · 1 fatalLimited investigationFinal reportArnet Pereyra Aero Aventura II · Rockledge, FLThe pilot's failure to attain directional control during his attempted takeoff due to his exceeding the airplane's gross weight limit for takeoff and the resultant inflight collision with a building.Aug 11, 1999 · N303SQ · Substantial damageNTSB CHI99LA298Accident · No injuriesLimited investigationFinal reportBell 206L · Cape Girardeau, MOThe inadequate preflight planning/preparation by the pilot, in that the auxiliary power unit cord was not removed. The brick wall was a contributing factor.Aug 10, 1999 · N810F · Substantial damageNTSB NYC99FA193Accident · 2 fatalField investigationFinal reportPiper PA28R-180 · Seven Springs, PAThe pilot's failure to obtain a rate of climb after takeoff due to spatial disorientation. Factors in this accident were low ceilings, fog, and the pilot's lack experience in instrument meteorological conditions.Aug 8, 1999 · N3892T · Substantial damageNTSB FTW99LA214Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Cypress, TXThe flight instructor's failure to maintain/obtain airspeed during takeoff climb, which resulted in an inadvertent stall/mush.Aug 8, 1999 · N60784 · Substantial damageNTSB FTW99LA216Accident · No injuriesLimited investigationFinal reportCessna 172RG · Celina, TXThe failure of the pilot in command to use all of the available runway for takeoff.Aug 7, 1999 · N9620B · Substantial damageNTSB MIA99FA215Accident · 2 fatalField investigationFinal reportCessna 150F · Maple, NCthe pilot's failure to follow the aircraft's operating checklist and retract the wing flaps for takeoff as specified, as well as the pilot's failure to maintain airspeed (Vso) on initial takeoff climb, which resulted in an inadvertent stall, a spin, and…Aug 6, 1999 · N7059F · DestroyedNTSB LAX99FA262Accident · 2 fatalField investigationFinal reportCessna 177B · Tusayan, AZwas the pilot's failure to have available and consult the FAA approved flight manual for performance data and, the high density altitude. Contributing to the accident were the dual magneto and spark plug system issues affecting optimum engine performance.Aug 3, 1999 · N19113 · DestroyedNTSB SEA99LA133Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Renton, WAA loss of engine power for undetermined reasons. A factor was insufficient altitude available to return to the departure runway following the loss of power.Aug 1, 1999 · N3151G · Substantial damageNTSB MIA99FA208Accident · 1 fatalField investigationFinal reportGulfstream American AA-1B · Hilliard, FLthe pilot's failure to obtain notams and his improper planning and decision to use a closed runway for takeoff with tall trees on the departure end, resulting in a subsequent collision with the trees.Aug 1, 1999 · N9888L · DestroyedNTSB DEN99LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Edgewood, NMThe pilot's excessive rotation during takeoff, resulting in an inadvertent stall/mush. Factors were the pilot's lack of recent flight experience, and the high density altitude..Jul 31, 1999 · N7521W · Substantial damageNTSB CHI99MA269Accident · 10 fatalMajor investigationFinal reportBeech 65-A90 · Marine City, MIThe pilot's failure to maintain adequate airspeed, which resulted in a stall, inflight loss of contol, and collision with the ground.Jul 31, 1999 · N518DM · DestroyedNTSB CHI99LA268Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401B · Edelstein, ILan inadequate fuel supply which resulted in fuel exhaustion. Factors associated with the accident were the low altitude at which the power loss occurred and the corn crop the airplane contacted.Jul 31, 1999 · N61775 · Substantial damageNTSB CHI99FA264Accident · 1 fatalField investigationFinal reportBeech C23 · Detroit Lakes, MNAircraft control not obtained/maintained by the pilot. A factor to the accident was the pilot's impairment due to drugs.Jul 29, 1999 · N6996R · DestroyedNTSB FTW99LA202Accident · No injuriesLimited investigationFinal reportCessna A150M · Alvin, TXThe flight instructor's excessive rotation while performing a soft field takeoff, which resulted in a delayed lift-off and the ensuing failure to attain obstacle clearance.Jul 27, 1999 · N2721J · Substantial damageNTSB CHI99LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Salina, KSthe inadequate preflight inspection by the pilot. Factors to the accident were fuel exhaustion and the operation of the aircraft with known deficiencies in equipment by the pilot.Jul 26, 1999 · N97MA · Substantial damageNTSB ATL99LA114Accident · No injuriesLimited investigationFinal reportMaule M-5-200 · St.Simons, GAThe inadequate installation of the magneto assembly by other maintenance personnel that in resulted the separation from the engine and the subsequent loss of engine power. A factor was the swampy terrain condition.Jul 26, 1999 · N5643T · Substantial damageNTSB LAX99LA257Accident · No injuriesLimited investigationFinal reportEwertz Starduster II · Winslow, AZthe pilot's failure to attain and maintain a sufficient flying airspeed for the existing density altitude conditions, which resulted in an inadvertent stall/mush.Jul 24, 1999 · N102E · Substantial damageNTSB NYC99LA182Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Newton, NJThe pilot's failure to secure the oil cap after adding oil; the flight instructor's failure to insure the preflight was completed properly; and oil on the windshield obstructing forward vision.Jul 23, 1999 · N9712X · Substantial damageNTSB FTW99LA198Accident · Minor injuriesLimited investigationFinal reportBoeing A75L3 · Fort Worth, TXThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Jul 23, 1999 · N59646 · Substantial damageNTSB FTW99FA199Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Bethany, OKThe pilot's failure to maintain the minimum controllable airspeed. A factor was the disconnected rubber interconnect boot, which resulted in the partial loss of left engine power.Jul 23, 1999 · N345LS · DestroyedNTSB DEN99LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA28-160B · Pueblo, COTotal loss of power during initial climb for undetermined reasons.Jul 23, 1999 · N5595W · Substantial damageNTSB CHI99LA254Accident · No injuriesLimited investigationFinal reportBeech G18S · Minneapolis, MNthe premature gear retraction and proper runway alignment not maintained during takeoff by the pilot. An additional cause was the proper descent rate not maintained by the pilot. Contributing factors were the carburetor icing conditionsJul 23, 1999 · N621KE · Substantial damageNTSB FTW99LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Fabens, TXThe pilot's inadvertent flight into adverse weather conditions. A factor was the windshear weather conditions.Jul 22, 1999 · N6736Z · Substantial damageNTSB FTW99LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvel, ARThe pilot's failure to attain the proper takeoff airspeed.Jul 21, 1999 · N6073U · Substantial damageNTSB ATL99LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Asheboro, NCThe pilot's failure to maintain flying speed that resulted in a stall and the subsequent collision with trees.Jul 20, 1999 · N704ET · Substantial damageNTSB LAX99LA254Accident · No injuriesLimited investigationFinal reportPiper PA32R-300 · Mammoth Lakes, CAThe pilot's failure to attain and maintain an adequate airspeed for the prevailing density altitude. The pilot's failure to abort the takeoff is also causal.Jul 17, 1999 · N1692H · Substantial damageNTSB FTW99TA194Accident · No injuriesFinal reportBell 47G-3B-1 · Sour Lake, TXThe pilot's failure to adequately preflight the helicopter's fuel system resulting in the total loss of engine power as a result of water contamination. Factors were the incorrect filter installed on the fueling truck and the pilot's improper touchdown…Jul 17, 1999 · N4002G · Substantial damageNTSB CHI99LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Butler, MOloss of engine power for undetermined reason, and the pilot's inability to maintain clearance from the fence during the forced landing. Factors relating to this accident were the rising terrain, the rough/uneven terrain, and the fence posts.Jul 17, 1999 · N9653J · Substantial damageNTSB CHI99LA235Accident · Serious injuriesLimited investigationFinal reportPiper J-3C · Maple Lake, MNThe pilot's inadequate preflight planning that resulted in exceeding the maximum gross weight of the airplane and the subsequent inadvertent aerodynamic stall.Jul 17, 1999 · N88593 · Substantial damageNTSB ATL99LA109Accident · 1 fatalLimited investigationFinal reportBlackburn John D. Jr. Bushby M II · Daytona Beach, FLThe pilot's failure to securely reconnect the distributor coil wire during routine maintenance. Factors were the unsuitable terrain and trees.Jul 17, 1999 · N102JB · Substantial damageNTSB FTW99LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Springtown, TXThe pilot's failure to maintain clearance with the trees during the initial takeoff climb. A factor was the high density altitude.Jul 14, 1999 · N44677 · Substantial damageNTSB FTW99LA188Accident · No injuriesLimited investigationFinal reportBeech C35 · Jonesboro, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were the prevailing tailwind, and the airplane's over gross weight condition.Jul 13, 1999 · N5BH · Substantial damageNTSB CHI99LA234Accident · Serious injuriesLimited investigationFinal reportGrimm SEA Hawker · Princeton, MNThe erratic aileron control response for undetermined reasons. A factor was the tree.Jul 13, 1999 · N188AK · DestroyedNTSB SEA99LA115Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Paul, IDThe pilot's failure to attain adequate airspeed during takeoff and initial climb, resulting in stall/mush and inability of the aircraft to sustain level flight. Factors included high density altitude, a tailwind, an uphill takeoff surface, and crops in the…Jul 12, 1999 · N8005C · Substantial damageNTSB CHI99LA228Accident · Minor injuriesLimited investigationFinal reportMcmillan Zodiac CH 601 HD · Nauvoo, ILThe pilot's failure to follow the airplane checklist to pin the canopy before departure, resulting in the opening of the canopy on take off and the subsequent aerodynamic stall and ground collision.Jul 12, 1999 · N6781Z · Substantial damageNTSB DEN99FA120Accident · 4 fatalField investigationFinal reportPiper PA-22-150 · Roy, UTThe pilot inadvertently allowing the aircraft to enter a stall during initial climb following takeoff. Factors were high density altitude and gross weight which exceeded the maximum.Jul 11, 1999 · N7729D · DestroyedNTSB ANC99LA091Accident · Serious injuriesLimited investigationFinal reportCessna 337B · Seldovia, AKThe pilot's inadequate preflight planning/preparation, and subsequent fuel exhaustion.Jul 11, 1999 · N5499S · Substantial damageNTSB LAX99LA248Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · San Luis Obispo, CAThe failure/separation of the crankshaft idler gear and the fatigue failure and subsequent separation of the crankshaft dowel pin due to the improper static and dynamic balance of the propeller by maintenance personnel.Jul 10, 1999 · N6597P · Substantial damageNTSB CHI99LA255Accident · Minor injuriesLimited investigationFinal reportBuss Avid Flyer Mark IV · New London, WIthe inadequate preflight planning/preparation by the pilot. Factors to the accident were the powerplant seizing and the misjudged flare by the pilot.Jul 10, 1999 · N392SB · Substantial damage