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 FTW95FA270Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Lake Dallas, TXThe pilot's failure to maintain airspeed and the resulting inadvertent stall/spin. A factor was inadequate maintenance resulting in the partial loss of engine power due to the number one cylinder exhaust valve being stuck open.Jul 5, 1995 · N11064 · Substantial damageNTSB NYC95LA140Accident · No injuriesLimited investigationFinal reportNicolas Beasely NB-8 · Bayport, NYThe loss of power for undetermined reasons.Jul 4, 1995 · N583Y · Substantial damageNTSB LAX95LA240Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Long Beach, CAthe inadvertent entanglement of the banner tow cable with the rudder control system, which resulted in a full and uncorrectable deflection of the rudder, and the pilot's inability to control the aircraft.Jul 4, 1995 · N8634 · DestroyedNTSB ATL95LA127Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fairview, TNThe pilot's failure to maintain flying speed during climbout. A factor was the wind gust.Jul 4, 1995 · N6051G · Substantial damageNTSB NYC95LA151Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · North Benton, OHFuel starvation for an unknown reason, resulting in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.Jul 3, 1995 · N88631 · Substantial damageNTSB FTW95LA274Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Colorado Spgs, COAn inadvertent windshear encounter. A factor was the high density altitude.Jul 3, 1995 · N55365 · Substantial damageNTSB SEA95LA135Accident · No injuriesLimited investigationFinal reportCessna 172L · Stanley, IDThe pilot's failure to use all available runway, his improper use of flaps, and his failure to maintain airspeed. A factor contributing to the accident is high density altitude.Jul 2, 1995 · N4319Q · Substantial damageNTSB CHI95LA206Accident · Serious injuriesLimited investigationFinal reportBeech 23A · Spearfish, SDThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. Factors associated with this accident were remedial action by the pilot was not possible due to the low altitude at which the stall took place.Jul 2, 1995 · N2397Q · DestroyedNTSB LAX95LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Payson, AZa loss of power for undetermined reasons.Jul 1, 1995 · N2820Z · Substantial damageNTSB LAX95LA233Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Carmel Valley, CAfuel starvation due to the pilot's inadequate preflight preparation in that he failed to position the fuel selector to a tank known to contain fuel.Jul 1, 1995 · N8399T · DestroyedNTSB FTW95LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Farmington, NMThe pilot's failure to verify the fuel tank selector position and the resultant fuel starvation induced power loss.Jul 1, 1995 · N4823T · Substantial damageNTSB ATL95LA122Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Andalusia, ALThe pilot's failure to maintain airspeed in a climbing turn, that resulted in an inadvertent stall.Jun 30, 1995 · N1254W · Substantial damageNTSB FTW95LA273Accident · No injuriesLimited investigationFinal reportCessna A188A · Pharr, TXThe pilot's inadequate aircraft preflight which failed to purge the aircraft fuel system of contaminants. A factor was the unsuitable terrain in the emergency landing area.Jun 29, 1995 · N5631J · Substantial damageNTSB ATL95LA120Accident · No injuriesLimited investigationFinal reportPierce Kitfox III · Arlington, TNThe pilot's premature rotation on takeoff that resulted in low airspeed and an inadvertent stall.Jun 28, 1995 · N101GP · Substantial damageNTSB FTW95LA264Accident · No injuriesLimited investigationFinal reportCessna 404 · Alamosa, COFBO personnel improperly serviced the aircraft with jet fuel. A factor was the lack of suitable terrain for a forced landing.Jun 27, 1995 · N36998 · Substantial damageNTSB ATL95LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Summerville, SCThe disconnected carburetor mixture control linkage that resulted in a loss of engine power, and the subsequent collision with trees.Jun 27, 1995 · N16345 · Substantial damageNTSB MIA95LA158Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Brooksville, FLA loss of engine power after takeoff for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.Jun 26, 1995 · N3431W · DestroyedNTSB NYC95LA177Accident · No injuriesLimited investigationFinal reportPincince Corbin Baby ACE · Palmer, MAcontamination in the carburetor which resulted in fuel starvation, a total loss of engine power and forced landing.Jun 24, 1995 · N88856 · Substantial damageNTSB CHI95FA200Accident · 1 fatalField investigationFinal reportCocchi Lancair 320 · Marengo, ILpilot incapacitation due to cardiac arrhythmia (heart attack).Jun 24, 1995 · N3118J · DestroyedNTSB ATL95LA118Accident · No injuriesLimited investigationFinal reportPiper J3 · York, SCThe loss of engine power for undetermined reasons.Jun 24, 1995 · N41105 · Substantial damageNTSB MIA95FA154Accident · 2 fatalField investigationFinal reportBeech 58 · Orlando, FLThe failure of the pilot-in-command to insure the landing gear was retracted following loss of power in one engine resulting in the aircraft being unable to climb and clear trees in the aircraft's flight path.Jun 23, 1995 · N4403Q · DestroyedNTSB FTW95LA257Accident · 1 fatalLimited investigationFinal reportRocky Mountain Buccaneer 11 B2B · Longmont, COThe pilot's failure to maintain flying speed, resulting in an inadvertent stall while attempting to make a forced landing. Factors were the pilot's lack of total experience in airplane make/model, improper maintenance of the airplane, and operation of the…Jun 23, 1995 · N4093F · DestroyedNTSB ANC95LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Minto, AKThe pilot's failure to abort the takeoff in a timely manner. A factor relating to the accident was: the pilot's failure to use all of the available area (waterway) for the takeoff.Jun 23, 1995 · N5177E · Substantial damageNTSB ANC95LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's inadvertent stall of the airplane.Jun 22, 1995 · N82022 · Substantial damageNTSB FTW95LA256Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hearne, TXThe loss of engine power as result of the failure of the number two cylinder. Factors were the unsuitable terrain available for the forced landing and the pilot's restricted vision due to oil on the windshield.Jun 21, 1995 · N4537L · DestroyedNTSB CHI95IA189Incident · No injuriesIncident investigationFinal reportBell 222UT · Des Moines, IAdelamination of the left engine air inlet duct.Jun 21, 1995 · N274SM · Minor damageNTSB BFO95LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Factoryville, PAthe loss of engine power for undetermined reasons, and the subsequent hard landing by the student pilot.Jun 20, 1995 · N4876F · Substantial damageNTSB BFO95LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Phillips, MEthe private pilot's failure to obtain/maintain altitude/clearance from obstacles during the takeoff/initial climb. Related factors are the grass/turf runway, the improper weight and balance, and the tailwind.Jun 19, 1995 · N91469 · DestroyedNTSB MIA95LA151Accident · No injuriesLimited investigationFinal reportBeech C24R · Houston, MSPartial loss of engine power due to a fuel injector being clogged with carbon. This resulted in a landing on unsuitable terrain.Jun 18, 1995 · N24024 · Substantial damageNTSB LAX95LA216Accident · No injuriesLimited investigationFinal reportBell 47-G5 · Coalinga, CAclutch slippage for undetermined reasons. A factor in the accident was the helicopter's low above ground altitude, which limited the pilot's time and ability to recover main rotor rpm.Jun 18, 1995 · N7923J · DestroyedNTSB CHI95LA184Accident · Serious injuriesLimited investigationFinal reportBeech B23 · Neligh, NEthe pilot's selection of the wrong runway for takeoff, and his failure to compensate for the tailwind. A factor was the tailwind.Jun 17, 1995 · N7632R · Substantial damageNTSB ATL95LA112Accident · Minor injuriesLimited investigationFinal reportGrumman AA1C · Mocksville, NCThe pilot's improper short field takeoff procedure which resulted in the inadvertent stall/mush during the takeoff.Jun 17, 1995 · N9980U · Substantial damageNTSB FTW95LA246Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Jennings, LAThe partial power loss for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Jun 15, 1995 · N7070U · Substantial damageNTSB CHI95LA180Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lowell, MIthe pilot's failure to obtain/maintain altitude/clearance.Jun 14, 1995 · N3625R · Substantial damageNTSB CHI95FA182Accident · 2 fatalField investigationFinal reportGrumman G-21E · West Chicago, ILThe pilot allowed excessive nose-up rotation of the airplane during lift-off, and failed to obtain and/or maintain adequate airspeed, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's…Jun 14, 1995 · N121H · DestroyedNTSB SEA95LA117Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Challis, IDInadequate preflight/planning preparation. Factors to the accident were: downdraft and tailwind.Jun 11, 1995 · N7142M · Substantial damageNTSB ANC95LA074Accident · Serious injuriesLimited investigationFinal reportChampion 11BC-S · Anchorage, AKThe pilot's improper compensation for the wind conditions. Factors associated with the accident are gusty winds and associated downdrafts.Jun 11, 1995 · N86135 · Substantial damageNTSB ANC95LA070Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKThe pilot's premature liftoff and subsequent inadvertent stall.Jun 10, 1995 · N8570C · Substantial damageNTSB MIA95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Sarasota, FLThe pilot's improper draining of the fuel sumps during preflight inspection of the airplane. This resulted in a partial loss of engine power on the left engine on initial take off climb due to water contamination, subsequent forced landing, collapse of the…Jun 9, 1995 · N949BW · Substantial damageNTSB CHI95LA176Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Viroqua, WIThe loss of engine power for undetermined reasons.Jun 9, 1995 · N5762W · Substantial damageNTSB FTW95LA237Accident · Minor injuriesLimited investigationFinal reportStokes Smith DSA-1 · Brookshire, TXOwner/builder's inadequate maintenance resulting in a loss of engine power due to corroded magneto coils. A factor was the lack of suitable terrain for the forced landing.Jun 8, 1995 · N33BS · Substantial damageNTSB ATL95LA107Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Fayetteville, GAA malfunction of the carburetor needle valve which resulted in fuel starvation to the engine.Jun 8, 1995 · N53232 · Substantial damageNTSB BFO95LA057Accident · 1 fatalLimited investigationFinal reportCGS Hawk · Quarryville, PAthe pilot's failure to attain proper altitude/clearance from obstacles during takeoff.Jun 6, 1995 · UNREG · DestroyedNTSB CHI95LA165Accident · 1 fatalLimited investigationFinal reportGrumman AA-1 · Osage Beach, MOa low altitude maneuver performed by the pilot and the pilot not maintaining the airplane's airspeed. A factor in this accident was the pilot encountering a stall/mush.Jun 5, 1995 · N6122L · DestroyedNTSB FTW95LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Guthrie, OKThe loss of engine power due to water contamination of the fuel. A factor was the lack of suitable terrain for the forced landing.Jun 4, 1995 · N5134B · Substantial damageNTSB CHI95LA167Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Williston, NDThe failure of the pilot to maintain directional control on takeoff. The soft condition of the field was a factor.Jun 3, 1995 · N5328H · Substantial damageNTSB NYC95LA131Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12 · Geneseo, NYThe pilot's inadequate preflight inspection, which failed to detect water-contaminated fuel which resulted in the loss of engine power. Also causal was the pilot's failure to maintain airspeed during the forced landing, which resulted in the inadvertent…Jun 1, 1995 · N43705 · Substantial damageNTSB MIA95FA141Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Opa-Locka, FLA loss of engine power due to water contamination of the fuel, the pilot's inadequate preflight, and his intentional operation of the airplane with known deficiencies in equipment which resulted in an inadvertent stall at an altitude inadequate for recovery.…Jun 1, 1995 · N5832Y · DestroyedNTSB LAX95LA203Accident · No injuriesLimited investigationFinal reportBeech B23 · Mariposa, CAthe pilot's premature liftoff and his failure to attain and maintain sufficient airspeed during the intial climb which resulted in an inadvertent stall/mush back onto the runway. The pilot's failure to maintain directional control as the aircraft touched down…Jun 1, 1995 · N6985Q · Substantial damageNTSB MIA95FA142Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Corinth, MSThe pilots decision to continue his VFR flight into instrument meteorological conditions after being advised that VFR flight should not be attempted, resulting in spatial disorientation and loss of control. Factors in the accident were: the pilot's…May 31, 1995 · N4207B · Destroyed