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 DEN99LA035Accident · No injuriesLimited investigationFinal reportMooney M20E · Albuquerque, NMThe pilot's failure to maintain aircraft control during takeoff.Jan 31, 1999 · N5658Q · Substantial damageNTSB MIA99LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-210T · Washington, NCLoss of engine power for undetermined reasons on initial takeoff climb resulting in a forced landing and in-flight collision with trees and terrain.Jan 30, 1999 · N28235 · DestroyedNTSB LAX99LA084Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Jean, NVFuel starvation due to the pilot's failure to ensure that a tank containing an adequate fuel supply was selected for takeoff. A factor in the accident was the contamination in the engine driven fuel pump, which likely was not capable of providing full system…Jan 30, 1999 · N474W · Substantial damageNTSB CHI99LA069Accident · No injuriesLimited investigationFinal reportCessna 150C · Middleton, WIinadequate aircraft preflight by the pilot and the ice in the fuel system. A factor associated with the accident was the ravine which the airplane contacted during the forced landing.Jan 20, 1999 · N1956Z · Substantial damageNTSB LAX99LA076Accident · No injuriesLimited investigationFinal reportCessna 140 · Burson, CAThe pilot's failure to maintain adequate airspeed while maneuvering to avoid an obstacle immediately after takeoff. A factor in the accident was the pilot's inadequate examination of the off-airport takeoff area in order to identify potential hazards.Jan 17, 1999 · N89513 · Substantial damageNTSB MIA99LA065Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Perry, GAThe maintenance personnel incorrect adjustment of the intake and exhaust valves resulting in the induction system fire and subsequent loss of engine power.Jan 6, 1999 · N4542Z · Substantial damageNTSB NYC99LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Methuen, MAThe pilot's failure to ensure the engine primer was in and locked prior to takeoff which resulted in a loss of engine power. A factor in this accident was the pilot's lack of experience in airplanes equipped with reciprocating engines.Jan 5, 1999 · N9683C · Substantial damageNTSB MIA99LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pahokee, FLThe pilot-in command's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the lack of total experience by the pilot-in-command.Jan 5, 1999 · N9225N · Substantial damageNTSB LAX99IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Phoenix, AZThe failure of the ground handling personnel to properly secure the aft cargo door following the loading of the late arriving baggage. A factor in the incident was an intermittent cargo door warning light circuit due to contamination in the proximity switch…Jan 5, 1999 · N804MA · Minor damageNTSB LAX99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Santa Barbara, CAA loss of engine power due to an internal left magneto coil primary circuit short. Factors were insufficient altitude and inadequate terrain to make an emergency landing.Jan 4, 1999 · N3585V · Substantial damageNTSB IAD99FA025Accident · 1 fatalField investigationFinal reportLake LA-4-250 · Laconia, NHA loss of engine power during initial climb due to oil starvation. Contributing to the accident was the failure to perform an engine overhaul.Jan 4, 1999 · N14001 · DestroyedNTSB NYC99LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-24R · Farmingdale, NYThe pilot's inadequate preflight examination of the airplane, which resulted in a power loss due to fuel contamination.Jan 2, 1999 · N1857G · Substantial damageNTSB FTW99LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Bowie, TXThe hard landing due to the flight instructor's delayed remedial action to take control of the airplane when the engine lost power. Factors were the loss of engine power for an undetermined reason, and the rough and uneven terrain.Dec 31, 1998 · N46285 · Substantial damageNTSB MIA99LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Immokalee, FLThe certified flight instructor's inadequate supervision and his inadequate management of the fuel, which resulted in fuel exhaustion.Dec 28, 1998 · N3293T · Substantial damageNTSB MIA99LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Conyers, GAThe pilot's decision to attempt a touch-and-go landing with insufficient runway remaining, and his failure to maintain adequate clearance from an object (tree).Dec 27, 1998 · N8253E · Substantial damageNTSB DEN99LA028Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Canon City, COThe glider pilot's failure to follow proper preflight procedures, and his failure to control the aircraft when the latch opened during flight. A factor was his failure to properly latch the canopy, and to utilize all available runway during the forced landing.Dec 27, 1998 · N173SS · Substantial damageNTSB MIA99LA054Accident · No injuriesLimited investigationFinal reportDean Kolb Firestar 1 · Davenport, FLThe pilot's failure to perform weight and balance calculations, resulting in a loss of directional control on initial takeoff climb due to an aft center of gravity flight condition, in flight collision with trees and terrain. Contributing to the accident was…Dec 24, 1998 · N643FS · Substantial damageNTSB MIA99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Clearwater, FLThe delay by the pilot-in-command (CFI) to take control of the airplane and inadvertent stall/mush resulting in the uncontrolled descent and impact with the runway.Dec 19, 1998 · N5836P · Substantial damageNTSB ANC99LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Anchorage, AKA loss of engine power due to fuel contamination. A factor associated with the accident was the pilot's failure to maintain directional control.Dec 19, 1998 · N4185P · Substantial damageNTSB LAX99FA052Accident · 1 fatalField investigationFinal reportParkman VARI-EZE · Tucson, AZThe pilot's failure to attain and maintain an adequate flying airspeed during the aircraft's maiden flight, which resulted in a stall/mush condition. Also causal was the pilot/builder's decision to modify the engine and the fuel system control microchip,…Dec 18, 1998 · N81EZ · DestroyedNTSB LAX99LA056Accident · Serious injuriesLimited investigationFinal reportWeber CA-65 · Red Bluff, CAThe failure of the pilot to remove the right seat belt from around the right control stick, which resulted in a loss of aircraft control. An additional cause is the pilot's failure to use a checklist.Dec 17, 1998 · N5656 · Substantial damageNTSB ATL99LA029Accident · No injuriesLimited investigationFinal reportCessna 150B · Adjuntas, PRThe loss of engine power due to the restricted movement of the intake and exhaust valves on number 3 cylinder.Dec 5, 1998 · N5957T · Substantial damageNTSB ATL99LA028Accident · Minor injuriesLimited investigationFinal reportSid Champion Jurca MJ-5 · Madison, MSA loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.Dec 5, 1998 · N9772N · Substantial damageNTSB CHI99LA045Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Ankeny, IAthe elevator control system jammed for undetermined reasons.Dec 3, 1998 · N7278R · Substantial damageNTSB DEN99LA022Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Carrizozo, NMThe loss of engine power for undetermined reasons.Nov 30, 1998 · N2PE · Substantial damageNTSB FTW99LA039Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Braithwaite, LAThe pilot's inadvertent stall/spin. Factors were the terrain induced turbulence and the insufficient altitude for recovery.Nov 28, 1998 · N567G · Substantial damageNTSB FTW99LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Greenville, TXThe partial loss of engine power due to a blocked muffler exhaust pipe/manifold as a result of a loose internal baffle. Factors were the improper maintenance by other maintenance personnel and the lack of suitable terrain for the forced landing.Nov 25, 1998 · N5087W · Minor damageNTSB LAX99LA035Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Upland, CALoss of engine power due to water contaminated fuel and the pilot's inadequate preflight inspection of the airplane. A factor was the failure of the owner/pilot to properly maintain the airplane.Nov 19, 1998 · N3500X · DestroyedNTSB IAD99LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Melfa, VAThe loss of engine power for undetermined reasons.Nov 19, 1998 · N1685H · DestroyedNTSB FTW99LA029Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Monroe, LAThe pilot's spatial disorientation which resulted in a loss of aircraft control. Factors were fog, low ceilings, and dark night conditions.Nov 18, 1998 · N30ML · Substantial damageNTSB SEA99LA011Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Auburn, WAA partial loss of engine power due to carburetor ice formation. Factors included insufficient altitude/time available for remedial action, a tail wind during the forced landing attempt, and a fence at the end of the runway.Nov 7, 1998 · N6312P · Substantial damageNTSB MIA99LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Lauderdale, FLThe failure of the pilot-in-command to note that the flaps did not retract while the pilot-rated student performed a touch-and-go landing on a 6,001 foot-long runway. Factors in the accident were the total failure of the flap system for undetermined reasons…Nov 7, 1998 · N1901S · Substantial damageNTSB LAX99LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Mammoth, CAThe pilot's failure to ensure that the autopilot was off prior to takeoff, and, his failure to maintain pitch control during the resultant pitch trim excursion during the takeoff ground roll.Nov 4, 1998 · N50JG · Substantial damageNTSB CHI99LA021Accident · Minor injuriesLimited investigationFinal reportJordan Acey Deucy P70 · Ava, MOthe pilot's attempted operation of the airplane with known deficiencies, and his not obtaining control of the airplane in flight. A factor was asymmetrical ailerons.Oct 30, 1998 · N597HJ · Substantial damageNTSB ANC99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Aniak, AKA loss of engine power due to fuel contamination. A factor in the accident was unsuitable terrain for a forced landing.Oct 26, 1998 · N73533 · Substantial damageNTSB FTW99LA012Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Eagle Pass, TXA downdraft, which exceeded the aircraft's climb performance. A factor was the thunderstorms in the vicinity of the airport.Oct 18, 1998 · N19MH · DestroyedNTSB ANC99LA007Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Chitina, AKThe pilot's inadequate preflight which failed to detect water contamination in the fuel system. A factor was the unsuitable terrain in the emergency landing area.Oct 18, 1998 · N94DC · Substantial damageNTSB FTW99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Conroe, TXThe pilot's failure to maintain clearance with trees. Factors were the fogged front windshield and side windows.Oct 16, 1998 · N2513L · Substantial damageNTSB NYC99LA011Accident · No injuriesLimited investigationFinal reportZeidler Sonerai II · Kenton, OHThe pilot's premature rotation and failure to obtain/maintain airspeed during the takeoff, which resulted in a stall and impact with the ground. Factors in this accident were the pilot's lack of total experience in tail-wheeled aircraft, and the nose high…Oct 15, 1998 · N5DZ · Substantial damageNTSB FTW99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Oct 9, 1998 · N757XC · Substantial damageNTSB CHI99LA004Accident · No injuriesLimited investigationFinal reportCessna 182N · Genesee, MIthe pilot's failure to maintain directional control and the subsequent failure to attain clearance with the trees during takeoff. Factors associated with the accident were the trees, dark night conditions, and fog which resulted in the lack of visual…Oct 9, 1998 · N92322 · Substantial damageNTSB FTW99LA011Accident · No injuriesLimited investigationFinal reportWilson Teenie TWO · Abilene, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Oct 7, 1998 · N5576 · Substantial damageNTSB IAD99FA004Accident · 1 fatalField investigationFinal reportCessna 305A · Warren, VTThe glider pilot's failure to perform the emergency tow release and abort the takeoff. A factor in the accident was the glider pilot's improper decision to make repeated attempts to close the canopy in flight.Oct 5, 1998 · N5213G · 2 aircraft · DestroyedNTSB ANC99LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Russian Mission, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are rising terrain, and a downdraft.Oct 4, 1998 · N6867X · Substantial damageNTSB NYC99LA002Accident · 1 fatalLimited investigationFinal reportForeit Super CAT · Middlebury, CTThe pilot's failure to utilize his seat belt and shoulder harness.Oct 3, 1998 · N132TF · DestroyedNTSB MIA99LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Punta Gorda, FLThe failure of maintenance personnel to refill the engine oil following the draining of the oil and changing of the oil filter. Also, inadequate preflight of the airplane by the pilot for his failure to noted the absence of engine oil.Oct 3, 1998 · N53EN · Substantial damageNTSB NYC99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Toughkenamon, PAThe pilot's inadequate preflight inspections which failed to detect an open fuel strainer valve, which resulted in a loss of engine power.Oct 2, 1998 · N2535A · Substantial damageNTSB IAD99LA001Accident · No injuriesLimited investigationFinal reportCessna 172K · Middlefield, OHThe pilot's inadequate preflight inspection which resulted in fuel exhaustion.Oct 2, 1998 · N78624 · Substantial damageNTSB ATL99LA003Accident · No injuriesLimited investigationFinal reportAuxier Herschel A Jr. SEA REY Amphibian · Keystone Height, FLThe pilots failure to attain adequate airspeed, which resulted in a stall, and loss of control.Oct 2, 1998 · N54114 · Substantial damageNTSB FTW99LA062Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Tomball, TXThe pilot's failure to follow the checklist and secure the canopy, which resulted in the canopy separating from the airplane during takeoff initial climb. A factor was the pilot's failure to detect the canopy warning light prior to takeoff.Oct 1, 1998 · N527SS · Substantial damage