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 ATL00LA059Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Indiantown, FLThe student pilot's failure to maintain altitude clearance during initial climb following takeoff during the commission of a crime, resulting in an in-flight collision with a tree.Jun 5, 2000 · N337VH · Substantial damageNTSB LAX00LA215Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Carson City, NVa loss of engine power due to contamination of the fuel system resulting in partial blockage of the cylinder number 2 fuel injection nozzle. A factor in the accident was the high density altitude.Jun 4, 2000 · N201CE · Substantial damageNTSB IAD00LA048Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Northampton, MAThe student pilot's failure to maintain directional control during takeoff.Jun 4, 2000 · N6340L · Substantial damageNTSB CHI00LA162Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Joliet, ILthe engine failure for undetermined reasons. Factors were the low altitude, remedial action not possible by the pilot, and the ditch.Jun 4, 2000 · N3232H · Substantial damageNTSB FTW00LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKthe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.Jun 1, 2000 · N7271W · Substantial damageNTSB MIA00FA177Accident · 2 fatalField investigationFinal reportBeech C23 · Smyrna, TNThe failure of the dual student to maintain airspeed following total loss of engine power resulting in an inadvertent stall and subsequent uncontrolled descent. Also, inadequate supervision by the CFI for her failure to note the position of the fuel selector…May 30, 2000 · N6645P · Substantial damageNTSB FTW00LA164Accident · Serious injuriesLimited investigationFinal reportGeiling Sonerai II · Victoria, TXThe failure of the pilot to maintain airspeed during the takeoff initial climb, which resulted in a stall.May 30, 2000 · N10GX · DestroyedNTSB MIA00LA176Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Fort Walton Bch, FLThe unsuitable terrain encountered by the pilot-in-command during the forced landing and the loss of engine power for undetermined reasons.May 27, 2000 · N96MB · Substantial damageNTSB DEN00LA096Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Hurricane, UTThe complete loss of power due to the separation of the magneto ground lead and the rough and unsuitable terrain during the forced landing.May 27, 2000 · N35LP · Substantial damageNTSB LAX00FA206Accident · 2 fatalField investigationFinal reportBeech F33A · Columbia, CAThe pilot's failure to abort the downwind takeoff and his failure to attain flying speed.May 26, 2000 · N2RM · DestroyedNTSB IAD00FA044Accident · 1 fatalField investigationFinal reportKurzenburger Stuka JU-87 · Urbana, MDThe pilot's failure to obtain/maintain aircraft control after takeoff.May 26, 2000 · N87DK · DestroyedNTSB NYC00LA141Accident · 1 fatalLimited investigationFinal reportCarlson Criquet · East Palestine, OHThe failure of the powerplant to produce adequate power for undetermined reasons, and the pilot's continued operation of the airplane with known deficiencies.May 24, 2000 · N22CA · DestroyedNTSB LAX00LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Borrego Springs, CAThe pilot's inadequate compensation for a crosswind condition during initial takeoff climb, which resulted a failure to maintain alignment and the airplane drifting into a nearby tree.May 15, 2000 · N25213 · Substantial damageNTSB NYC00LA135Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Wellington, OHThe pilot's failure to maintain aircraft control. A factor was the pilot's improper in-flight decision to abort the initial climb due to an open canopy.May 13, 2000 · N3872G · Substantial damageNTSB CHI00LA134Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Ham Lake, MNcarburetor ice. Factors relating to this accident were the icing conditions, the pilot's attempted emergency landing and the low altitude.May 11, 2000 · N8321K · DestroyedNTSB SEA00LA084Accident · No injuriesLimited investigationFinal reportOveross Vans RV-8 · Independence, ORThe rotation of the right fuel tank elbow fitting within the tank during previous maintenance. The improper alignment resulted in the fuel pick-up tube being mis-positioned and a subsequent starvation of fuel to the engine. Contributing factors were the…May 7, 2000 · N998TT · Substantial damageNTSB CHI00FA129Accident · 3 fatalField investigationFinal reportCessna 172M · Cornell, WIthe pilot not maintaining aircraft control and the stall/spin he encountered. A factor was the extended flaps.May 2, 2000 · N13145 · DestroyedNTSB LAX00FA178Accident · 4 fatalField investigationFinal reportCessna 172P · Chester, CAThe pilot's encounter with a wind shear at low altitude, which resulted in a loss of control and a stall/spin. Factors in the accident were the high density altitude and the pilot's lack of experience and training in high density altitude operations. The…Apr 28, 2000 · N216PB · DestroyedNTSB LAX00LA174Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Healdsburg, CAFailure of the flight review pilot to compensate for the crosswind and maintain flying speed during takeoff.Apr 27, 2000 · N146TM · Substantial damageNTSB NYC00LA120Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lancaster, OHThe pilot's improper recovery from a bounced landing. A factor in the accident was the pilot's decision to operate the airplane over the maximum gross weight and his improper landing flare.Apr 23, 2000 · N66430 · Substantial damageNTSB LAX00FA160Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Grand Canyon, AZA snow ingestion caused loss of engine power due to the pilot's inadequate preflight inspection and failure to remove the accumulated snow from the engine inlet area. Also causal was the pilot's failure to maintain main rotor rpm while maneuvering to avoid…Apr 18, 2000 · N2267N · DestroyedNTSB LAX00GA158Accident · 3 fatalFinal reportGrumman US-2C · Reno, NVthe flying pilot's failure to maintain directional control following a loss of engine power. Also causal was the failure of the flight crew to follow the published checklist and use the rudder assist system, and the decision not to abort the takeoff.Apr 17, 2000 · N7046U · DestroyedNTSB FTW00LA124Accident · No injuriesLimited investigationFinal reportLuscombe 8C · Galveston, TXThe pilot's inadequate preflight inspection, which resulted in the pilot attempting to takeoff with the elevator and ailerons locked by the passenger side seatbelt.Apr 16, 2000 · N25270 · Substantial damageNTSB CHI00LA114Accident · No injuriesLimited investigationFinal reportCessna 404 · Lansing, MIA loss of engine power due to improper fuel. Also causal was the improper aircraft service by the fixed base operator personnel and the unsuitable terrain for the forced landing encountered by the pilot. Factors were the improper grade of fuel and the lack of…Apr 15, 2000 · N26SA · Substantial damageNTSB SEA00LA073Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Acequia, IDThe pilot's failure to obtain/maintain adequate clearance with the irrigation system during initial climb. A contributing factor was the irrigation pivot.Apr 14, 2000 · N1524H · Substantial damageNTSB LAX00LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAThe loss of engine power for undetermined reasons during takeoff climb.Apr 14, 2000 · N81019 · Substantial damageNTSB ANC00LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Igiugig, AKThe pilot's intentional flight into known adverse weather. Factors associated with the accident were the variable crosswind conditions, and the pilot's inadequate compensation for those wind conditions.Apr 13, 2000 · N2790C · Substantial damageNTSB DEN00LA073Accident · No injuriesLimited investigationFinal reportHelio H-295 · Albuquerque, NMThe flight instructor's failure to maintain aircraft control during takeoff initial climb.Apr 12, 2000 · N3MA · Substantial damageNTSB LAX00FA151Accident · 1 fatalField investigationFinal reportBeech B36TC · Fullerton, CAThe pilot's failure to maintain adequate airspeed while in the traffic pattern, which resulted in an inadvertent stall/spin. Contributing factor was the pilot's diverted attention with the loss of engine power from his inadvertent activation of the auxiliary…Apr 11, 2000 · N6791P · DestroyedNTSB DEN00IA076Incident · No injuriesIncident investigationFinal reportBeech A60 · Englewood, COThe failure of a number one cylinder connecting rod bolt due to under-torquing during engine major overhaul.Apr 8, 2000 · N928PT · Minor damageNTSB CHI00FA107Accident · 1 fatalField investigationFinal reportAeronca 7AC · Embarrass, MNthe inadvertent stall/spin the pilot encountered. A factor was the wind gusts.Apr 8, 2000 · N84424 · DestroyedNTSB LAX00LA143Accident · No injuriesLimited investigationFinal reportMuxlow Pitts S-1C · Phoenix, AZA loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and the rough/uneven terrain on which the airplane landed.Apr 5, 2000 · N27DM · Substantial damageNTSB MIA00LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNA loss of engine power during takeoff climb for undetermined reasons resulting in an attempted emergency landing to unsuitable terrain and collision with a tree and transmission wires.Apr 4, 2000 · N46912 · DestroyedNTSB MIA00FA126Accident · 1 fatalField investigationFinal reportCessna 177RG · Chipley, FLThe failure of the pilot to maintain runway alignment during the initial climb from the grass airstrip. Also, the excessive pull-up by the pilot and inadvertent stall. Findings in the investigation were 1) in-flight collision with the tops of trees and 2) the…Apr 3, 2000 · N1997Q · Substantial damageNTSB CHI00LA104Accident · Minor injuriesLimited investigationFinal reportWilson RAF 2000 GTX SE · Monroe City, MOthe pilot not obtaining clearance from the trees. Factors were the trees and the ravine terrain condition.Apr 2, 2000 · N1964 · Substantial damageNTSB NYC00LA108Accident · No injuriesLimited investigationFinal reportSportavia Putzer RF-5B · Gillespie, PAThe pilot's improper weather evaluation, resulting in a tailwind departure.Apr 1, 2000 · N55GS · Substantial damageNTSB FTW00LA115Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Addison, TXThe loss of engine power for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.Mar 31, 2000 · N6046J · Substantial damageNTSB NYC00FA106Accident · 2 fatalField investigationFinal reportCessna 172P · Ballston Spa, NYa loss of control for undetermined reason(s).Mar 30, 2000 · N98574 · DestroyedNTSB LAX00FA144Accident · 4 fatalField investigationFinal reportCommander 114 · Hanford, CAundetermined. The pilot's failure to reject the takeoff and his failure to retract the landing gear following liftoff were factors.Mar 30, 2000 · N516CA · DestroyedNTSB ATL00LA039Accident · Serious injuriesLimited investigationFinal reportAlon A-2A · Hernando, FLLoss of power due to carburetor contamination. Factors, were the trees, and the weather conditions were conducive to carburetor icing.Mar 28, 2000 · N67HS · Substantial damageNTSB NYC00LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Sissonville, WVThe pilot's failure to maintain runway alignment during takeoff. A factor in the accident was wind gusts.Mar 26, 2000 · N7879T · Substantial damageNTSB CHI00LA097Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DC-65 · Joplin, MOan inadequate rate of climb and the failure to attain clearance with the trees during the aborted landing. Factors associated with the accident were the pilot's failure to attain a proper touchdown point during the landing, the trees which were contacted, and…Mar 25, 2000 · N67754 · Substantial damageNTSB NYC00LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Farmingdale, NJThe pilot's failure to maintain control of the airplane which resulted in an inadvertent stall. A factor in the accident was the pilot's use of excessive nose-down elevator trim.Mar 24, 2000 · N52633 · Substantial damageNTSB FTW00LA104Accident · Serious injuriesLimited investigationFinal reportCessna 195A · Roanoke, TXThe pilot's inadequate preflight resulting in loss of engine power due to water and rust contamination of the fuel. A factor was the lack of suitable terrain for the forced landing.Mar 24, 2000 · N9847A · Substantial damageNTSB MIA00LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean Springs, MSThe pilot's failure to maintain control of the aircraft while making a forced landing following loss of engine power for undetermined reasons, resulting in the aircraft impacting hard on the runway, bouncing into the air, and colliding with powerlines off the…Mar 21, 2000 · N6684J · DestroyedNTSB NYC00FA094Accident · 1 fatalField investigationFinal reportBeech A23 · Akron, OHThe pilot's improper decision to operate the airplane with known deficiencies. A factor in this accident was the inability of the engine to attain full power for undetermined reasons.Mar 19, 2000 · N1410L · DestroyedNTSB NYC00LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYa power loss over unsuitable terrain, for undetermined reason(s).Mar 18, 2000 · N18AV · Substantial damageNTSB LAX00IA127Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · San Francisco, CAfailure of the right main landing gear to fully extend for undetermined reasons.Mar 14, 2000 · N516DA · Minor damageNTSB DEN00LA059Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Rifle, COLoss of engine power for undetermined reasons. A factor was unsuitable terrain on which to make a forced landing.Mar 14, 2000 · N8236M · Substantial damageNTSB DEN00LA058Accident · No injuriesLimited investigationFinal reportBeech A23A · Rawlins, WYThe pilot's failure to abort the landing in a timely manner. Factors were the tailwind and high density altitude, resulting in inadequate climb performance.Mar 13, 2000 · N2337W · Substantial damage