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 NYC05LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · West Carrollton, OHThe pilot's inadequate preflight inspection that resulted in fuel contamination and a subsequent loss of engine power. A factor related to the accident was the deteriorated fuel cap seals.Jul 1, 2005 · N3992R · Substantial damageNTSB MIA05LA126Accident · 1 fatalLimited investigationFinal reportJSH Air LLC II Comp Air 7SLX · Winter Haven, FLThe abrupt steep pitch-up during the initial climb for undetermined reasons resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with terrain.Jul 1, 2005 · N657TT · DestroyedNTSB MIA05TA124Accident · Minor injuriesFinal reportBell OH-58A · St. Augustine, FLThe failure of the compressor section of the engine for undetermined reasons resulting in the total loss of engine power during the initial climb. A factor in the accident was the operator's use of a confined area for takeoff during non-emergency or routine…Jun 29, 2005 · N244RP · Substantial damageNTSB LAX05LA216Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Mojave, CAthe pilot's encounter with a downdraft or wind shear during takeoff the initial climb.Jun 26, 2005 · N3BZ · Substantial damageNTSB NYC05FA105Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Fairview, PAA partial loss of engine power for undetermined reasons, which resulted in a forced landing after takeoff and subsequent collision with a residence.Jun 25, 2005 · N235G · DestroyedNTSB DEN05CA096Accident · No injuriesData collectionFinal reportAviat A-1B · Dove Creek, COthe pilot's failure to maintain airspeed during initial climb which resulted in an inadvertant stall and impact with terrain.Jun 24, 2005 · N42HY · Substantial damageNTSB CHI05CA155Accident · No injuriesData collectionFinal reportCessna 172 · Willis, MIThe pilot's inability to maintain directional control of the airplane due to undetermined reasons. A factor associated with the accident were the trees that the airplane contacted during the aborted takeoff.Jun 23, 2005 · N6324E · Substantial damageNTSB SEA05FA124Accident · Serious injuriesField investigationFinal reportCessna 320E · Missoula, MTTerrain clearance was not possible as a result of a right engine failure. Factors contributing to the accident included the rising terrain, foreign material being ingested into the engine's turbocharger, which obstructed the turbocharger's impeller, the…Jun 21, 2005 · N3438Q · DestroyedNTSB NYC05LA103Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Beverly, MAThe pilot's failure to attain the proper touchdown point while conducting a precautionary landing. A factor was the partial loss of power to one engine for undetermined reasons.Jun 20, 2005 · N615SN · Substantial damageNTSB DFW05CA169Accident · No injuriesData collectionFinal reportRobinson R44 · Rayville, LAThe pilot's loss of control following an encounter with loss of tail rotor effectiveness. A contributing factor was the high density altitude.Jun 19, 2005 · N744MD · Substantial damageNTSB DEN05LA093Accident · No injuriesLimited investigationFinal reportCessna 172N · Hudson, COThe flight instructor's improper use raising of the flaps. Contributing factors were the student pilot's misunderstanding of the instructor's intentions, the instructor's inadequate supervision of the student pilot, the density altitude, and the soft terrain.Jun 19, 2005 · N733RL · Substantial damageNTSB NYC05CA101Accident · No injuriesData collectionFinal reportValentin Taifun 17E · Waterbury, CTThe pilots inadvertent encounter with a downdraft, which resulted in the airplane impacting trees.Jun 17, 2005 · N13BH · Substantial damageNTSB SEA05LA118Accident · Minor injuriesLimited investigationFinal reportRash Vans RV-6A · Palouse, WALoss of engine power for undetermined reasons. Rising terrain was a factor.Jun 16, 2005 · N330CJ · DestroyedNTSB ATL05FA098Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Williamson, GAThe pilot's failure to follow the before takeoff checklist and attempted a takeoff with flaps extended, which resulted in an in-flight collision with trees.Jun 16, 2005 · N26GA · Substantial damageNTSB LAX05CA205Accident · Minor injuriesData collectionFinal reportCessna 177B · Fallon, NVthe pilot's inadequate preflight planning, which resulted in fuel exhaustion.Jun 15, 2005 · N177BJ · Substantial damageNTSB MIA05FA123Accident · Serious injuriesField investigationFinal reportDouglas R4D-8 · Fort Lauderdale, FLThe inadequate maintenance inspection by company maintenance personnel/pilot and other maintenance personnel of the left engine resulting in a total failure of the master rod bearing, and nose case partial separation, which prevented the left propeller from…Jun 13, 2005 · N3906J · DestroyedNTSB NYC05LA098Accident · 1 fatalLimited investigationFinal reportNorcutt Hornet · Shelby, OHThe pilot's failure to obtain\maintain the proper climb airspeed during departure, which resulted in an inadvertent stall. A factor in the accident was the pilot's lack of flight experience in the accident airplane make and model.Jun 12, 2005 · UNREG · Substantial damageNTSB MIA05LA122Accident · Serious injuriesLimited investigationFinal reportHighsmith Fergy FII B · Chipley, FLThe seizing of the rear engine cylinder during takeoff-initial climb, which resulted in a collision with power lines and structural damage to the airplane during the forced landing.Jun 12, 2005 · N456MH · Substantial damageNTSB CHI05LA140Accident · Serious injuriesLimited investigationFinal reportCessna 310C · Ray, MIThe loss of power on the left engine for undetermined reasons and the flightcrew's failure to maintain aircraft control following the loss of power.Jun 11, 2005 · N311V · Substantial damageNTSB SEA05CA112Accident · No injuriesData collectionFinal reportCessna 150G · Buckley, WAThe pilot's failure to use carburetor heat which resulted in a loss of engine power due to carburetor ice and a forced landing. Contributing factors were the carburetor icing conditions and the lack of suitable terrain for the forced landing.Jun 8, 2005 · N2751S · Substantial damageNTSB DFW05CA149Accident · No injuriesData collectionFinal reportBell 206L-1 · Moulton Cove, LAThe loss of engine power due to foreign object ingestion into the compressor. A contributing factor was the lack of suitable terrain (swampy) for the forced landing.Jun 8, 2005 · N2761X · Substantial damageNTSB ATL05CA096Accident · Serious injuriesData collectionFinal reportPiper PA-18A-150 · Griffin, GAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was the pilot's inadequate preflight preparation which failed to verify the fuel amount.Jun 8, 2005 · N8680D · Substantial damageNTSB MIA05CA118Accident · No injuriesData collectionFinal reportHerbert O. Kellerman 173 RG · Venice, FLThe owner/pilot mechanic's inadequate maintenance inspection resulting in a partial loss of engine power due to a loose fuel line.Jun 7, 2005 · N27BK · Substantial damageNTSB LAX05LA196Accident · Minor injuriesLimited investigationFinal reportElan DG 300 · Jean, NVthe glider pilot's failure to release from the towline in a timely manner, and to maintain adequate airspeed. Contributing to the accident was the glider pilot's failure to recognize and correctly recover from the stall in a timely manner, and the inadequate…Jun 7, 2005 · N303LV · Substantial damageNTSB LAX05CA195Accident · No injuriesData collectionFinal reportBoeing A75N-1 · Paulden, AZthe pilot's inadequate compensation for wind conditions, and his failure to maintain airspeed which resulted in a stall mush and collision with objects.Jun 5, 2005 · N351AH · Substantial damageNTSB DFW05LA147Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lake Charles, LAThe failure of the propeller governor which resulted in a forced landing. A contributing factor was the transmission wire.Jun 4, 2005 · N6832K · Substantial damageNTSB DFW05FA145Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Jeanerette, LAThe pilot's failure to obtain/maintain sufficient airspeed to maintain control. A contributing factor was the loss of engine power for undetermined reason.Jun 3, 2005 · N656RS · Substantial damageNTSB IAD05LA071Accident · No injuriesLimited investigationFinal reportPiper E2 · Hastings, NYFuel starvation due to a blocked fuel line, which resulted in a loss of engine power.Jun 2, 2005 · N2122 · Substantial damageNTSB MIA05LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fort Myers, FLInadequate maintenance and repair of the engine top cowling by company maintenance personnel, resulting in failure and separation of the cowling in flight.May 31, 2005 · N333TG · Substantial damageNTSB SEA05CA108Accident · No injuriesData collectionFinal reportFisher Mini Max 1300 · Sandy, ORThe pilot's inadequate preflight (his inability to get full elevator down deflection with the flight control stick with shoulder harness and seat belt on) and subsequent loss of aircraft control which resulted in a stall/spin into the trees. Contributing…May 30, 2005 · N548AF · Substantial damageNTSB MIA05LA119Accident · 1 fatalLimited investigationFinal reportWatson Slip Stream · Wildwood, FLAn in-flight loss of control during takeoff/initial climb for an undetermined reason, which resulted in a stall/spin, and impact with terrainMay 30, 2005 · N7066T · DestroyedNTSB DFW05CA142Accident · No injuriesData collectionFinal reportWestland Wasp · Denison, TXThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.May 30, 2005 · N108RA · Substantial damageNTSB MIA05LA111Accident · Minor injuriesLimited investigationFinal reportHamilton Stoddard Glassair II S · Palm City, FLImproper maintenance by other maintenance personnel, which resulted in the throttle cable being loose and detaching from the throttle arm during takeoff, resulting in a loss of engine power.May 27, 2005 · N401KY · Substantial damageNTSB IAD05LA070Accident · Minor injuriesLimited investigationFinal reportSnyder Sky Scout · Round Lake, NYA loss of engine power for undetermined reasons. A factor was the soft field.May 27, 2005 · N314ES · Substantial damageNTSB DFW05CA137Accident · Minor injuriesData collectionFinal reportPZL-Mielec M18 · Clover Bend, ARThe pilot's failure to maintain directional control during takeoff. A contributing factor was the dust devil (whirlwind) encountered.May 26, 2005 · N93982 · Substantial damageNTSB SEA05FA105Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-25 · Hillsboro, ORThe pilot's failure to obtain minimum controllable airspeed during the takeoff climb, which resulted in a loss of aircraft control when the left engine lost partial power. A fatigue failure to an oil tube, which resulted in the partial power loss to the left…May 25, 2005 · N312MA · Substantial damageNTSB DFW05CA133Accident · No injuriesData collectionFinal reportGrumman 164-B · Fontaine, ARThe pilot's failure to maintain clearance during a downwind takeoff with a full load of fertilizer. Factor contributing to the accident were the prevailing tailwind and the high density altitude.May 24, 2005 · N3629K · Substantial damageNTSB LAX05LA186Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Santa Barbara, CAa loss of engine power due to carburetor ice aggravated by the poor operating condition of the magnetos and the improper magneto-to-engine timing.May 22, 2005 · N181AS · Substantial damageNTSB DFW05CA130Accident · Serious injuriesData collectionFinal reportCessna 182P · Lowell, ARThe instructor's inadequate supervision and the second pilot's inadequate planning/decision to assure adequate takeoff performance to clear obstacles. Contributing factors were the prevailing quartering tailwind, the pilots selection of the wrong runway, and…May 22, 2005 · N9425M · Substantial damageNTSB MIA05LA107Accident · Serious injuriesLimited investigationFinal reportC.W. Smith Rans S6 Coyote II · Louisville, MSGalling of the front piston and cylinder of the Rotax 503 2-stroke engine, consistent with the engine running hot and lean for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.May 21, 2005 · UNREG · Substantial damageNTSB DFW05LA129Accident · 1 fatalLimited investigationFinal reportMiller Rand Robinson KR-2 · Galliano, LAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin during initial takeoff climb. A contributing factor was the pilot's lack of experience for the make/model airplane.May 21, 2005 · N684LM · DestroyedNTSB CHI05LA122Accident · Serious injuriesLimited investigationFinal reportCessna R182 · Vandalia, ILThe pilot's failure to maintain control of the airplane due to undetermined reasons.May 21, 2005 · N7361Y · Substantial damageNTSB ATL05LA084Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82-C · Franklin, GAThe total failure of the left magneto resulting in a partial loss of engine power on initial takeoff climb, forced landing, and in-flight collision with wires and the ground.May 21, 2005 · N82CQ · Substantial damageNTSB DFW05LA123Accident · Serious injuriesLimited investigationFinal reportBell 206B · Huffman, TXThe pilot's inadequate preflight and his failure to disconnect the external load cable prior to takeoff.May 18, 2005 · N276M · DestroyedNTSB ATL05LA081Accident · 1 fatalLimited investigationFinal reportPaul E. Conner Rotor-EZ · St Elmo, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. The pilot failed to maintain airspeed resulting in an inadvertent stall.May 16, 2005 · N2992 · Substantial damageNTSB SEA05LA098Accident · 1 fatalLimited investigationFinal reportCessna 150M · Elk River, IDThe pilot's inability to control the airplane during initial climb due to the restricted movement of the control yoke and rudder control by the passenger, which resulted in a loss of control and impact with trees.May 14, 2005 · N704JJ · DestroyedNTSB NYC05LA084Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Saluda, VAA loss of engine power due to an unsecured mixture control cable, which was not properly secured by maintenance personnel during a recent annual inspection. Also causal was the airplane owner's continued operation of the airplane with known deficiencies.May 14, 2005 · N2406H · Substantial damageNTSB LAX05LA173Accident · Minor injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Sonoma, CAa partial loss of engine power, which resulted from the fuel servo leaking and generating an excessively rich fuel/air mixture. A factor was the owner's failure to comply with a service bulletin.May 14, 2005 · N765GL · Substantial damageNTSB DEN05LA077Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Denver, COthe failure of the nose gear actuator resulted in penetration of the forward pressure bulkhead and a loss of pressurization.May 14, 2005 · N949DL · Substantial damageNTSB LAX05LA164Accident · No injuriesLimited investigationFinal reportRobinson R44 · Gustine, CAthe improper installation of the nut/bolt assembly connecting the left cyclic push-pull tube to the non-rotating swashplate by maintenance personnel, which led to a loss of roll control during takeoff.May 11, 2005 · N144SM · Substantial damage