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 LAX03LA238Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lomita, CAThe partial loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat. Also causal was the pilot's failure to attain and maintain an adequate airspeed during the aborted landing, which resulted in a stall/mush.Jul 20, 2003 · N3091M · DestroyedNTSB LAX03LA237Accident · 1 fatalLimited investigationFinal reportThompson Quickie Q2 · Tehachapi, CAThe pilot's inadvertent entry into a pilot induced oscillation and failure to maintain airplane control during the takeoff initial climb. A contributing factor was the pilot's likely impairment by an over-the-counter drug substance that degraded his physical…Jul 20, 2003 · N218DT · DestroyedNTSB CHI03FA218Accident · Serious injuriesField investigationFinal reportRobinson R22-Beta · Flint, MIThe loss of engine power for undetermined reasons, and the pilot's inadequate decision to land on an unsuitable area.Jul 20, 2003 · N131MH · Substantial damageNTSB ANC03LA083Accident · Minor injuriesLimited investigationFinal reportMaule M-4 · Kobuk, AKThe pilot's inadvertent use of diesel fuel in a gasoline engine which resulted in a partial loss of engine power, and subsequent collision with trees during a forced landing after takeoff. A factor contributing to the accident was the pilot's inadequate…Jul 20, 2003 · N40344 · Substantial damageNTSB NYC03FA161Accident · 1 fatalField investigationFinal reportCessna T210L · Quakertown, PAA loss of engine power for undetermined reasons.Jul 18, 2003 · N700PR · DestroyedNTSB DEN03LA134Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Logan, UTthe loss of engine power due to partial mechanical failure, which resulted in a forced landing. Contributing factors include the pilot's improper preflight planning/preparation, the improper rigging of the propeller governor control, the high density altitude…Jul 18, 2003 · N8036D · Substantial damageNTSB CHI03LA216Accident · 1 fatalLimited investigationFinal reportCessna 172H · Isle, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. The trees, high density altitude, and the soft field were additional factors.Jul 18, 2003 · N1606F · DestroyedNTSB IAD03LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-180 · Akron, OHthe pilot's failure to maintain minimum control single engine airspeed (Vmc) during a loss of power on one engine, which resulted in a loss of control in flight an in-flight collision with terrain. A factor was a shifted main journal, which resulted in a…Jul 12, 2003 · N825SA · DestroyedNTSB CHI03LA205Accident · No injuriesLimited investigationFinal reportCessna 182Q · Empire, MIThe pilot's failure to abort the takeoff. A contributing factor to the accident included the pilot not utilizing all available engine power during the entire takeoff. Additional factors were the improper wing flap setting and the cherry-tree orchard.Jul 9, 2003 · N95890 · Substantial damageNTSB CHI03FA202Accident · 1 fatalField investigationFinal reportCessna 150L · Schaumburg, ILThe pilot not maintaining airplane control and the inadvertent stall he encountered during initial climb.Jul 8, 2003 · N10257 · DestroyedNTSB NYC03LA154Accident · Serious injuriesLimited investigationFinal reportWohlers Falco F.8L · Ashland, OHA loss of engine power due to the failure of the engine air intake duct tubing, which resulted in a total blockage of the induction inlet duct. A factor related to the accident was the inadequate 100-hour inspection by maintenance personnel. (This narrative…Jul 7, 2003 · N33LW · Substantial damageNTSB NYC03FA153Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Montauk, NYA loss of control during climb for undetermined reasons.Jul 7, 2003 · N5636V · Substantial damageNTSB ANC03LA070Accident · No injuriesLimited investigationFinal reportHelio H-391B · Big Lake, AKA loss of engine power for an undetermined reason during takeoff initial climb, which resulted in an in-flight collision with trees.Jul 7, 2003 · N17081 · Substantial damageNTSB NYC03LA151Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Manorville, NYThe pilot's failure to obtain the proper airspeed and his delayed remedial action to jettison the banner.Jul 6, 2003 · N86985 · Substantial damageNTSB DEN03LA123Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Englewood, COthe pilot's improper flare which resulted in a hard landing. Contributing factors were the out-of-calibration waste gate actuator, a blown tire, and the airport sign.Jul 6, 2003 · N4386G · Substantial damageNTSB DEN03LA122Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Leadville, COthe pilot's inadequate compensation for wind conditions and his failure to attain adequate airspeed resulting in an inadvertent stall/mush. Contributing factors were the wind shear, runway light, fence post, and unsuitable terrain.Jul 6, 2003 · N37JK · Substantial damageNTSB SEA03LA128Accident · No injuriesLimited investigationFinal reportMooney M20-J · Renton, WAIn-flight failure of the electric landing gear motor during the initial takeoff climb.Jul 4, 2003 · N201DV · Substantial damageNTSB LAX03FA207Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Truckee, CAan in-flight loss of control due to the pilot's rotation to an excessive pitch up attitude after takeoff and his failure to maintain an adequate airspeed, which resulted in a stall. Factors in the accident were the high density altitude and the lack of stall…Jul 4, 2003 · N78053 · Substantial damageNTSB CHI03LA192Accident · Serious injuriesLimited investigationFinal reportDebay Dragonfly Mark II · Eden Prairie, MNThe pilot's intentional operation of the airplane with a known deficiency with regard to an improper carburetor calibration that led to the loss of engine power. The improperly calibrated carburetor and the trees were contributing factors.Jul 3, 2003 · N25JD · Substantial damageNTSB NYC03LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Linden, NJThe mechanic's improper installation of the carburetor, and his failure to secure the mixture control wire to the mixture control arm pivot bolt.Jul 2, 2003 · N314TM · Substantial damageNTSB CHI03LA186Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Douglass, KSThe pilot's failure to attain adequate airspeed and his premature liftoff, which resulted in a stall. A factor to the accident was the tree.Jun 30, 2003 · N564B · Substantial damageNTSB ATL03LA113Accident · 1 fatalLimited investigationFinal reportAero Vodochody Aero Works L39C · Gadsden, ALThe loss of engine power during takeoff due to foreign object damage, which resulted in an in-flight collision with terrain during forced landing. Factors were the pilot's inadequate preflight inspection of the airplane, his failure to secure the…Jun 30, 2003 · N8125R · DestroyedNTSB CHI03LA189Accident · Serious injuriesLimited investigationFinal reportBowers Fly Baby · Altus, ARA loss of engine power for undetermined reasons. Factors associated with the accident were the tree and evasive maneuver performed during the forced landing.Jun 29, 2003 · N1878 · Substantial damageNTSB DEN03FA114Accident · 2 fatalField investigationFinal reportStugart Vans RV-6A · Fort Collins, COthe pilot's improper preflight planning/decision resulting in the fuel selector positioned improperly and fuel starvation, and his failure to maintain adequate airspeed. A factor contributing to the accident was the low altitude.Jun 28, 2003 · N29PT · DestroyedNTSB LAX03LA213Accident · Serious injuriesLimited investigationFinal reportMcanally Glasair JM-1 · Hollister, CAthe pilot's failure to follow the checklist and apply the electric fuel pump prior to takeoff, which resulted in vapor lock.Jun 27, 2003 · N104JM · Substantial damageNTSB NYC03LA137Accident · No injuriesLimited investigationFinal reportCessna 150F · Williamson, NYThe failure of a rocker arm shaft boss, which resulted in a partial loss of power and subsequent forced landing. A factor was the unsuitable terrain.Jun 26, 2003 · N8517G · Substantial damageNTSB ANC03CA088Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's incorrect selection of the fuel selector valve position during takeoff which resulted in fuel starvation. A factor associated with the accident was inadequate transition training provided to the pilot by the company/operator management.Jun 25, 2003 · N930TG · Substantial damageNTSB MIA03LA131Accident · Serious injuriesLimited investigationFinal reportBeech Be-35-33 · Raymond, MSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.Jun 24, 2003 · N929TP · Substantial damageNTSB NYC03LA134Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mount Holly, NJA loss of engine power for undetermined reasons.Jun 23, 2003 · N18146 · Substantial damageNTSB MIA03CA132Accident · Minor injuriesData collectionFinal reportParsons Trainer · New Smyrna, FLFailure of the pilot to maintain control of the gyrocopter.Jun 23, 2003 · UNREG · Substantial damageNTSB LAX03LA209Accident · Serious injuriesLimited investigationFinal reportDavis LG2H · Salome, AZThe pilot's excessive use of the controls during an aborted takeoff, and his failure to maintain airspeed which resulted in a stall/mush. Factors in the accident include the pilot's lack of familiarity with the airplane and an excessively rich mixture setting…Jun 23, 2003 · N128RD · Substantial damageNTSB NYC03LA133Accident · Serious injuriesLimited investigationFinal reportMBB BO-105C · Buffalo, NYThe pilot's improper interpretation of a descent as a power loss and subsequent decision to autorotate, which resulted in a hard landing. A factor in the accident was the collective friction.Jun 20, 2003 · N105SJ · Substantial damageNTSB DEN03LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Green River, UTpilot's improper preflight planning and failure to maintain obstacle clearance. Contributing factors include improper short field takeoff procedures and the high vegetation at the end of the runway.Jun 19, 2003 · N2537R · Substantial damageNTSB LAX03LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Williams, CAthe loss of engine power on takeoff for undetermined reasons.Jun 17, 2003 · N2558Z · Substantial damageNTSB MIA03LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocean Springs, MSA loss of engine power due to starvation as a result of the pilot's continued operation of an airplane with known deficiencies.Jun 16, 2003 · N8378W · Substantial damageNTSB FTW03LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Gruver, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jun 16, 2003 · N3715E · Substantial damageNTSB ATL03FA107Accident · 2 fatalField investigationFinal reportPiper PA-31P · Augusta, GAThe pilot's failure to maintain airspeed while maneuvering on initial take off climb resulting in an inadvertent stall, loss of control, and subsequent in-flight collision with trees and a swamp. A factor in the accident was a reported loss of engine power…Jun 16, 2003 · N577FS · DestroyedNTSB SEA03LA105Accident · No injuriesLimited investigationFinal reportCessna T337G · Lewistown, MTInadequate preflight planning/preparation prior to takeoff, and the pilot's failure to maintain aircraft control during the takeoff. An inadvertent stall and rough terrain were factors.Jun 15, 2003 · N4TD · Substantial damageNTSB NYC03FA131Accident · 4 fatalField investigationFinal reportCessna 205 · Jeannette, PAThe loss of power caused by fragments of the air filter being ingested in the engine. A factor was the pilot's delayed decision to perform a forced landing after experiencing a partial loss of engine power.Jun 15, 2003 · N124A · Substantial damageNTSB CHI03LA183Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · West Branch, MIThe loss of engine power due to the fatigue failure of the connecting rod cap. A related factor was the unsuitable terrain the pilot encountered.Jun 15, 2003 · N5695D · Substantial damageNTSB CHI03LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Gridley, ILThe checklist not followed by the pilot and the fuel starvation of the engine. The incorrect fuel tank selector position by the pilot,, and the lack of recurrent training were contributing factors.Jun 15, 2003 · N20553 · Substantial damageNTSB MIA03CA128Accident · Minor injuriesData collectionFinal reportKolb Mkiii · Bunnell, FLThe inadequate preflight inspection of the airplane by the pilot-in-command (pilot) for his failure to assure that the forward attachment of the right horizontal stabilizer was secured and safetied before flight resulting in rotation of the leading edge of…Jun 14, 2003 · UNREG · Substantial damageNTSB ANC03LA060Accident · No injuriesLimited investigationFinal reportLongren Centaur L-13 · Chickaloon, AKThe loss of engine power during the takeoff initial climb for an undetermined reason, which resulted in an in-flight collision with water.Jun 14, 2003 · N4062H · Substantial damageNTSB IAD03CA057Accident · Minor injuriesData collectionFinal reportBoeing A75N1(PT17) · Sutton, WVThe pilot's failure to abort the takeoff in a timely manner. Factors included the high density altitude conditions, and the pilot's lack of familiarity with the airplane's high density altitude performance characteristics.Jun 13, 2003 · N55175 · Substantial damageNTSB SEA03LA098Accident · No injuriesLimited investigationFinal reportCessna R182 · Kent, WAThe failure of the flaps to operate properly for undetermined reasons during the initial climb and subsequent aborted takeoff. A factor was the collapse of the main landing gear due to an inadequate amount of time for the gear extension process to be…Jun 12, 2003 · N7568T · Substantial damageNTSB SEA03FA100Accident · 2 fatalField investigationFinal reportAviat A-1 · Atlanta, IDClearance from trees was not maintained during the initial climb. A proper touchdown point was not attained, the pilot's lack of familiarity with the geographic area and trees were factors.Jun 12, 2003 · N104CA · Substantial damageNTSB NYC03FA129Accident · 2 fatalField investigationFinal reportCessna 150H · Pittsfield, METhe inadvertent resumption of power during a forced landing that resulted in a subsequent spin. Factors related to the accident were the CFI's delayed remedial action, the loss of engine power due to contaminated fuel, an obstructed fuel screen, and the…Jun 12, 2003 · N6566S · DestroyedNTSB DEN03TA102Accident · Minor injuriesFinal reportCessna 182R · Hobbs, NMThe pilot's failure to maintain airspeed, which resulted in a stall.Jun 12, 2003 · N6319H · DestroyedNTSB MIA03LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Olive Branch, MSThe pilot's operation of the airplane with known deficiencies (water contamination of the fuel) resulting in loss of engine power shortly after takeoff and damage to airframe during the subsequent forced landing.Jun 10, 2003 · N4658J · Substantial damageNTSB NYC03LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Aurora, NYThe pilot's failure to obtain the proper climb rate.Jun 8, 2003 · N560FL · Substantial damage