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 FTW03LA232Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Beaumont, TXThe loss of engine power for undetermined reasons.Sep 26, 2003 · N43376 · Substantial damageNTSB NYC03LA204Accident · Serious injuriesLimited investigationFinal reportLaBarge Titan Tornado I · Charlton, MAA seizure of the forward piston during the initial climb.Sep 24, 2003 · UNREG · Substantial damageNTSB LAX03LA291Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Lone Pine, CAthe pilot's inadequate assembly of the glider and improper preflight inspection, which resulted in an inadvertent deployment of the spoilers. Also causal was the pilot's failure to maintain obstacle clearance. His diverted attention to the control problems…Sep 19, 2003 · N71DA · Substantial damageNTSB ANC03LA119Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · McGrath, AKFuel starvation due to the pilot's improper placement of the fuel selector to a nearly empty fuel tank prior to takeoff, resulting in a loss of engine power, and an in-flight collision with trees.Sep 19, 2003 · N5657A · Substantial damageNTSB ANC03LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sparrevohn, AKThe pilot's failure to maintain control of the airplane, which resulted in a collision with terrain during takeoff/initial climb. Factors contributing to the accident were mountainous/hilly terrain, the pilot's inadequate evaluation of the wind conditions,…Sep 17, 2003 · N18PX · Substantial damageNTSB NYC03FA197Accident · 3 fatalField investigationFinal reportCessna U206F · Greenville, METhe pilot's improper fuel management by which he failed to position the fuel selector in the proper position and resulted in fuel starvation during the initial climb.Sep 14, 2003 · N755FA · Substantial damageNTSB CHI03LA309Accident · Minor injuriesLimited investigationFinal reportStrother KR2 · Clarinda, IAFailure of the pilot to maintain clearance from the roadway sign. The loose gravel and the sign were contributing factors.Sep 11, 2003 · N60MS · Substantial damageNTSB ANC03LA113Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Chalkyitsik, AKThe pilot's inadequate compensation for wind conditions, and his failure to maintain adequate airspeed during takeoff, which resulted in an in-flight collision with brush, and subsequent stall of the airplane. Factors associated with the accident were a…Sep 11, 2003 · N710MH · Substantial damageNTSB MIA03LA180Accident · No injuriesLimited investigationFinal reportPiper J5A · Winter Haven, FLThe inadequate preflight of the airplane by the pilot-in-command, which failed to detect water-contaminated fuel, and his failure to maintain airspeed resulting in an inadvertent stall.Sep 10, 2003 · N33063 · Substantial damageNTSB MIA03LA179Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLA loss of engine power due to inadequate maintenance.Sep 9, 2003 · N5172B · Substantial damageNTSB NYC03LA196Accident · Minor injuriesLimited investigationFinal reportCessna 180D · Greenville, METhe inadequate installation and inspection of an aileron cable by maintenance personnel, which resulted in a loss of control in-flight and subsequent collision with water.Sep 7, 2003 · N6445X · Substantial damageNTSB CHI03LA303Accident · No injuriesLimited investigationFinal reportCessna 172G · Greenville, MIThe pilot's inadequate takeoff procedure with the use of 20 degrees of flaps. Contributing factors were the interrelated effects of high aircraft weight, the density altitude, and the relative humidity. An additional factor was the trees.Sep 7, 2003 · N3811L · Substantial damageNTSB NYC03CA194Accident · Minor injuriesData collectionFinal reportunknown Avid Flyer · Covington, NYThe pilot's failure to abort the takeoff.Sep 6, 2003 · UNREG · Substantial damageNTSB ANC03LA108Accident · No injuriesLimited investigationFinal reportCessna 206 · Kaktovik, AKThe pilot's failure to maintain airspeed during takeoff which resulted in a loss of control during initial climb. Factors associated with the accident were wet and muddy runway conditions, and the pilot's selection of an unsuitable takeoff area.Sep 5, 2003 · N206J · Substantial damageNTSB NYC03FA190Accident · No injuriesField investigationFinal reportFokker F.28 Mk 0100 · Flushing, NYAn in-flight collision with birds.Sep 4, 2003 · N1450A · Substantial damageNTSB LAX03LA276Accident · No injuriesLimited investigationFinal reportMooney M20K · Novato, CAThe pilot's decision to attempt VFR flight into instrument meteorological conditions during the dark early morning takeoff, which resulted in spatial disorientation and lead to a collision with trees off the departure end of the runway.Sep 2, 2003 · N252AK · Substantial damageNTSB MIA03LA176Accident · No injuriesLimited investigationFinal reportCessna 172F · Fajardo, PRThe pilot's inadequate aircraft preflight resulting in the airplane being operated with water contamination in the fuel system, and the loss of engine power.Sep 1, 2003 · N8578U · DestroyedNTSB ATL03FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Hilton Head Is, SCThe pilot's failure to maintain control of the airplane during a VFR pattern for a precautionary landing, which resulted in an uncontrolled descent and subsequent collision with terrain. Also causal was the pilot's inadequate preflight inspection of the…Aug 31, 2003 · N70DL · DestroyedNTSB LAX03LA268Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Gerlach, NVa loss of engine power for undetermined reasons.Aug 30, 2003 · N607D · Substantial damageNTSB CHI03LA298Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Harrisville, MIThe loss of engine power for undetermined reasons and the unsuitable terrain encountered during the forced landing. A factor to the accident was the trees.Aug 30, 2003 · N9574U · Substantial damageNTSB ATL03LA131Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hendersonville, NCThe pilot's inadequate evaluation of the weather. The downdraft was a contributing factor.Aug 30, 2003 · N19929 · Substantial damageNTSB LAX03LA267Accident · 1 fatalLimited investigationFinal reportPetz Flying Boat · Tracy, CAThe inadequate design of the engine exhaust system and inappropriate selection of propeller materials by the designer/builder, which resulted in separation of the propeller blades during takeoff/initial climb, and a subsequent in-flight collision with terrain…Aug 28, 2003 · N1216Z · DestroyedNTSB MIA03LA171Accident · No injuriesLimited investigationFinal reportBeech 23 · Punta Gorda, FLA loss of engine power for undetermined reasons.Aug 27, 2003 · N2322Q · Substantial damageNTSB SEA03LA176Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Hood River, ORA power loss due to a mis-seated intake valve on the #1 cylinder resulting in leakage during the compression stroke and low compression. Contributing factors were the rising terrain and trees.Aug 24, 2003 · N6619U · Substantial damageNTSB NYC03CA182Accident · No injuriesData collectionFinal reportKucklick Hiperbipe · Marion, OHThe pilot's improper decision to install an inadequate air filter, which subsequently failed and resulted in a power loss.Aug 23, 2003 · N258HB · Substantial damageNTSB CHI03LA268Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Tocsin, INThe pilot attempting the low altitude turn and his failure to maintain clearance from the corn crop. A factor to the accident was the corn crop.Aug 19, 2003 · N37923 · DestroyedNTSB ATL03LA129Accident · Serious injuriesLimited investigationFinal reportWilliam Allen MONI-1 · Timberlake, NCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent collision with the ground.Aug 18, 2003 · N240A · Substantial damageNTSB ANC03LA095Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tyonek, AKThe pilot's failure to adequately compensate for wind conditions and maintain aircraft control during the initial climb, which resulted in a loss of control and in-flight collision with terrain. Factors associated with the accident are a crosswind and wind…Aug 17, 2003 · N2941M · Substantial damageNTSB MIA03LA162Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · West Palm Beach, FLThe poor judgment by the pilot-in-command of the airplane for his initiation of takeoff after the helicopter pilot had announced intention to perform a 180-degree autorotation to the runway, and the failure of both pilots to maintain visual lookout resulting…Aug 16, 2003 · N8785L · 2 aircraft · Substantial damageNTSB CHI03LA266Accident · No injuriesLimited investigationFinal reportCessna 172G · Bowdon, NDThe pilot's failure to maintain adequate airspeed which led to a stall. Contributing to the accident was the pilot's lack of experience, the crosswind condition, wind gusts and power lines.Aug 16, 2003 · N6057R · Substantial damageNTSB FTW03LA196Accident · No injuriesLimited investigationFinal reportHolmes Challenger II · Eldorado, TXThe loss of engine power during the takeoff/initial climb following the separation of the front cockpit throttle control cable resulting from inadequate maintenance.Aug 15, 2003 · N20EJ · Substantial damageNTSB CHI03LA253Accident · No injuriesLimited investigationFinal reportCessna 140 · Morrilton, ARThe deterioration of the fuel line resulting in fuel contamination and the loss of engine power.Aug 10, 2003 · N72971 · Substantial damageNTSB LAX03FA254Accident · 1 fatalField investigationFinal reportCessna 340A · Bishop, CAthe pilot's in-flight loss of control due to a Somatogravic illusion and/or spatial disorientation. Factors in the accident were the dark lighting conditions and the pilot's lack of familiarity with the airplane.Aug 9, 2003 · N340DC · DestroyedNTSB CHI03IA257Incident · No injuriesIncident investigationFinal reportCessna 650 · Chesterfield, MOA partial failure of the rudder control lock fairlead which jammed the rudder cable during takeoff.Aug 9, 2003 · N122EJ · No damageNTSB ANC03FA094Accident · 3 fatalField investigationFinal reportBeech V35-B · Skagway, AKThe pilot's failure to maintain adequate airspeed and subsequent inadvertent stall, which resulted in a collision with trees during takeoff-initial climb. Factors contributing to the accident were terrain features consisting of a ravine and rising terrain on…Aug 9, 2003 · N4317S · DestroyedNTSB SEA03LA163Accident · No injuriesLimited investigationFinal reportSchulze Lancair 360 · Vancouver, WALoss of engine power for undetermined reasons during the initial climb. Collision with a vehicle during landing was a factor.Aug 7, 2003 · N360W · DestroyedNTSB ANC03CA089Accident · No injuriesData collectionFinal reportCessna 185 · Iliamna, AKThe pilot's failure to maintain clearance during takeoff, which resulted in an in-flight collision with terrain.Aug 6, 2003 · N185TB · Substantial damageNTSB NYC03LA172Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Leonardtown, MDA loss of engine power due to water contamination of the fuel. A factor was the fuel cap not being secured to the tank.Aug 2, 2003 · N33EM · Substantial damageNTSB FTW03LA191Accident · No injuriesLimited investigationFinal reportBeech 19A · Fredericksburg, TXA partial loss of engine power due to a rich mixture and reduced airflow to the engine. Contributing factors were the owner's failure to obtain an annual inspection, and improper maintenance procedures used in the installation of the air filter.Aug 2, 2003 · N7643R · Substantial damageNTSB CHI03LA244Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Chadron, NEInadequate preflight planning by the pilot to ensure the required takeoff distance was utilized, as well as a failure to abort the takeoff. Contributing factors were the uphill gradient and the hangar.Aug 2, 2003 · N70522 · Substantial damageNTSB CHI03FA239Accident · No injuriesField investigationFinal reportGerlach Skyraider II · Oshkosh, WIThe pilot's failure to abort the takeoff, his improper use of flaps during the takeoff, and his failure to attain sufficient airspeed resulting in an inadvertent stall and subsequent impact with a road.Aug 2, 2003 · N1068S · Substantial damageNTSB ATL03LA122Accident · No injuriesLimited investigationFinal reportAir Tractor AT401B · Girard, GAA loss of engine power due to the failure of the internal supercharger blower seals.Jul 30, 2003 · N61227 · Substantial damageNTSB LAX03LA245Accident · Minor injuriesLimited investigationFinal reportHogarty Lancair IV P · North Las Vegas, NVThe pilot's premature lift-off before airspeed was attained resulting in a stall. A factor associated with the accident was a high density altitude.Jul 27, 2003 · N499R · Substantial damageNTSB CHI03LA227Accident · 1 fatalLimited investigationFinal reportUllrich Auriga FT · Aberdeen, SDA loss of engine power due to the lack of design fuel pressure for undetermined reasons.Jul 27, 2003 · N512EA · DestroyedNTSB SEA03LA154Accident · Serious injuriesLimited investigationFinal reportBollinger RV-6A · Wenatchee, WAFuel starvation following the separation of a purge valve assembly as a result of the builders failure to re-safety the face retaining/stop screw on the fuel vapor purge valve after the safety wire on the subject screw was removed in order to change the…Jul 26, 2003 · N272JT · Substantial damageNTSB DEN03FA136Accident · 4 fatalField investigationFinal reportMooney M20C · Blanding, UTthe pilot's failure to maintain airspeed which resulted in a stall/spin.Jul 26, 2003 · N35KR · DestroyedNTSB CHI03LA223Accident · No injuriesLimited investigationFinal reportCessna 172H · Red Wing, MNThe pilot's failure to follow the checklist resulting in fuel starvation and subsequent loss of engine power.Jul 24, 2003 · N8226L · Substantial damageNTSB LAX03LA240Accident · Minor injuriesLimited investigationFinal reportCessna 180C · Punkin Center, AZThe pilot's inadequate preflight planning and failure to attain adequate climb rate to ensure clearance from obstacles. The tailwind and high density altitude were factors.Jul 23, 2003 · N767RK · Substantial damageNTSB NYC03FA164Accident · 1 fatalField investigationFinal reportHawker T Mk 7A · Pittston, PAThe pilot's failure to abort the takeoff, after the engine experienced a partial power loss for undetermined reasons. Factors were the pilot's improper preflight planning by his failure to determine if the airplane was airworthy, and the operators inadequate…Jul 22, 2003 · UNREG · DestroyedNTSB SEA03CA144Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Burley, IDThe pilot's failure to remove the elevator gust lock prior to flight. Factors include the pilot's inadequate preflight.Jul 21, 2003 · N2709Q · Substantial damage