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 LAX07CA259Accident · Serious injuriesData collectionFinal reportSix Chutter SR7 · Toledo, WAA hard landing following the pilot's in-flight loss of control.Aug 5, 2007 · UNREG · Substantial damageNTSB SEA07FA223Accident · 4 fatalField investigationFinal reportRobinson R44 II · Easton, WAThe pilot's improper planning/decision in attempting a downwind takeoff under high density altitude conditions that resulted in a loss of control and impact with terrain. Contributing to the accident were the helicopter's gross weight in excess of the maximum…Aug 2, 2007 · N7531D · DestroyedNTSB MIA07LA129Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Andersonville, GAThe pilot's improper decision to make a 180-degree turn at low altitude to return to the departure runway following a loss of engine power during takeoff-initial climb. A factor in the accident was contamination in the carburetor.Aug 1, 2007 · N5721N · Substantial damageNTSB CHI07CA248Accident · No injuriesData collectionFinal reportBeech B60 · Bismark, NDThe improper fuel grade due to the improper fueling of the airplane by the fixed base operator, which led to the loss of engine power of both engines. A factor was the unsuitable terrain encountered during the forced landing.Aug 1, 2007 · N529R · Substantial damageNTSB CHI07LA238Accident · 1 fatalLimited investigationFinal reportSwanson Aventura II · Lakewood, WIThe pilot's excessive pull up, his not maintaining airspeed, and the inadvertent stall resulting in the loss of control. A factor contributing to the accident was the trees.Jul 28, 2007 · N914JS · Substantial damageNTSB DEN07LA130Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cooperstown, NYThe loss of engine power due to carburetor icing. Contributing factors were the lack of suitable terrain for a forced landing and the weather conditions conducive for carburetor icing.Jul 27, 2007 · N19052 · Substantial damageNTSB NYC07FA176Accident · 2 fatalField investigationFinal reportCessna 150B · Campbellton, FLThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in an inadvertent stall.Jul 26, 2007 · N1299Y · Substantial damageNTSB CHI07CA225Accident · Serious injuriesData collectionFinal reportRyan ST3KR · Coldwater, MIThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an inadvertent stall/mush condition. A contributing factor was the low altitude at the time of the inadvertent stall.Jul 22, 2007 · N59220 · Substantial damageNTSB SEA07FA208Accident · 2 fatalField investigationFinal reportGlobe GC-1B · Cottage Grove, ORThe partial/momentary loss of engine power during the takeoff initial climb for undetermined reasons, and the pilot's failure to maintain an airspeed above stall speed while maneuvering following the loss of engine power. Contributing to the accident was the…Jul 21, 2007 · N3867K · Substantial damageNTSB DEN07LA124Accident · No injuriesLimited investigationFinal reportCessna A185F · Englewood, COThis case was revised 10/31/2007. Low compression in number 2 cylinder, which reduced the airplane's climb capability. Contributing factors in this accident were the high density altitude conditions, and the tree.Jul 20, 2007 · N78011 · Substantial damageNTSB MIA07CA126Accident · Minor injuriesData collectionFinal reportPhantom Sport XI · Anderson, ALThe failure of the unqualified person (pilot) to maintain airspeed during the initial climb, resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with a residence.Jul 18, 2007 · UNREG · Substantial damageNTSB NYC07CA165Accident · No injuriesData collectionFinal reportPiper J3C-65 · Uxbridge, MAA partial loss of engine power for undetermined reasons.Jul 17, 2007 · N7088H · DestroyedNTSB SEA07CA221Accident · No injuriesData collectionFinal reportBritten-Norman BN-2A-20 · Stanley, IDThe pilot's failure to verify that the airplane was refueled, which resulted in a loss of engine power from both engines due to fuel exhaustion and a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.Jul 15, 2007 · N6561B · Substantial damageNTSB SEA07CA198Accident · No injuriesData collectionFinal reportCessna 182B · Leadore, IDThe pilot's inadequate compensation for the gusty wind conditions and his failure to maintain aircraft control, which resulted in a loss of control and collision with terrain during the takeoff initial climb. A contributing factor was the gusty wind condition.Jul 15, 2007 · N2625G · Substantial damageNTSB CHI07LA211Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Eden Prairie, MNThe pilot's inability to maintain control of the airplane for undetermined reasons. Contributing to the accident were the embankment and the fence.Jul 15, 2007 · N4785H · Substantial damageNTSB CHI07CA214Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Sheldon, ILThe pilot's inability to maintain a proper rate of climb during takeoff. Factors associated with the accident were the pilot's failure to dump the chemical load and the ditch which the airplane contacted.Jul 15, 2007 · N8449K · Substantial damageNTSB DFW07CA161Accident · No injuriesData collectionFinal reportRodgers Zodiac 601XL · Levelland, TXThe loss of engine power for undermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jul 14, 2007 · N4589 · Substantial damageNTSB NYC07LA167Accident · No injuriesLimited investigationFinal reportOntario Avia. Hist. Soc. Fokker D VII · Geneseo, NYA loosening of the fuel filter, which resulted in a partial loss of engine power.Jul 13, 2007 · C-GWWI · Substantial damageNTSB DEN07LA119Accident · Serious injuriesLimited investigationFinal reportCessna T206H · Gunnison, COAn inadvertent stall during takeoff/initial climb. Contributing factors in this accident were a partial loss of engine power for reasons undetermined, and high density altitude conditions.Jul 11, 2007 · N97PP · Substantial damageNTSB CHI07CA212Accident · No injuriesData collectionFinal reportBell 47G-5 · Jesup, IAThe pilot's inability to maintain control of the helicopter when it unexpectedly encountered a whirlwind shortly after takeoff.Jul 10, 2007 · N8140J · Substantial damageNTSB DEN07LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Ulysses, KSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jul 9, 2007 · N9076R · Substantial damageNTSB DFW07LA153Accident · No injuriesLimited investigationFinal reportZenair CH701 · Huntington, PAThe loss of engine power for undetermined reasons.Jul 8, 2007 · N7654Z · Substantial damageNTSB ANC07LA063Accident · No injuriesLimited investigationFinal reportCessna 177RG · Pedricktown, NJThe first pilot's inadequate preflight inspection, and water contamination of the airplane's fuel system. A factor contributing to the accident was rough/uneven terrain.Jul 6, 2007 · N52650 · Substantial damageNTSB DEN07CA112Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Joes, COthe pilot's improper takeoff planning and subsequent failure to maintain aircraft control during the takeoff. Contributing factors were the high density altitude and tailwind.Jul 4, 2007 · N8459K · Substantial damageNTSB LAX07FA200Accident · 2 fatalField investigationFinal reportBeech E90 · Carlsbad, CAThe pilot's failure to maintain clearance from wires during an instrument takeoff attempt. Contributing to the accident were fog, reduced visibility, and the low ceiling.Jul 3, 2007 · N47LC · DestroyedNTSB LAX07CA201Accident · No injuriesData collectionFinal reportCessna 172K · Newcastle, UTThe pilot's inadequate compensation for the gusty and crosswind condition, and his failure to maintain control of the airplane during takeoff.Jul 2, 2007 · N84888 · Substantial damageNTSB ATL07CA101Accident · No injuriesData collectionFinal reportSchempp-Hirth Discus-CS · Freehold, NYThe pilot's inadvertent activation of the tow release handle at a low altitude following an encounter with turbulence.Jul 1, 2007 · N42CA · Substantial damageNTSB SEA07LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502A · Chowchilla, CAThe loss of engine power as the result of the fatigue fracture and separation of two compressor turbine blades, which induced a catastrophic failure of the compressor turbine section.Jun 30, 2007 · N6176L · Substantial damageNTSB LAX07LA197Accident · Minor injuriesLimited investigationFinal reportEvenson Roger J Vans RV-9A · Tucson, AZthe loss of engine power during takeoff-initial climb, which resulted from the owner/builder's improper adjustment of the supercharger waste gate valve, that resulted in the failure of the waste gate servo motor.Jun 29, 2007 · N394RS · Substantial damageNTSB ANC07LA058Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKA partial loss of engine power due to a stuck engine exhaust valve during takeoff initial climb. A contributing factor was the airplane's excessive gross weight.Jun 28, 2007 · N66655 · Substantial damageNTSB MIA07CA112Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Greenville, SCThe pilot's inadvertent use of the wrong rudder during initial climb which resulted in a loss of control and collision with the ground.Jun 27, 2007 · N812EV · Substantial damageNTSB LAX07CA194Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Fresno, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall.Jun 27, 2007 · N1054E · Substantial damageNTSB ANC07LA057Accident · No injuriesLimited investigationFinal reportCessna 182RG · Tok, AKThe pilot's failure to maintain control of the airplane during takeoff initial climb.Jun 27, 2007 · N6110T · Substantial damageNTSB SEA07CA183Accident · No injuriesData collectionFinal reportCessna 172N · Greenwater, WAThe in-flight encounter with a sudden windshift during the takeoff initial climb, to which the certified flight instructor responded by aborting the takeoff and landing off the end of the runway. The ditch was a contributing factor.Jun 26, 2007 · N733XW · Substantial damageNTSB CHI07LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Rio Creek, WIThe pilot's improper aircraft weight and balance, and his failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb.Jun 24, 2007 · N4422R · Substantial damageNTSB ANC07CA052Accident · No injuriesData collectionFinal reportCessna 175 · Stoney River, AKThe pilot's failure to maintain altitude/clearance during takeoff-initial climb, which resulted in the airplane colliding with a tree, and an uncontrolled descent.Jun 23, 2007 · N7624M · Substantial damageNTSB SEA07CA176Accident · Minor injuriesData collectionFinal reportCommonwealth 185 · Redlands, CAThe pilot's inadequate weather evaluation which resulted in the airplane's lack of climb performance and subsequent collision with terrain. Contributing factors included the downdraft and the high temperature.Jun 22, 2007 · N92827 · Substantial damageNTSB DFW07CA145Accident · No injuriesData collectionFinal reportEvektor sportstar · Grand Prairie, TXLoss of control due to an unexpected crosswind gust. *This report was modified on May 23, 2008.*Jun 22, 2007 · N676EV · Substantial damageNTSB SEA07LA160Accident · No injuriesLimited investigationFinal reportCessna 182D · Phoenix, AZThe loss of engine power due to the intake manifold disconnection to the engine's cylinders on the left side.Jun 18, 2007 · N807X · Substantial damageNTSB SEA07LA163Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Tonopah, NVThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall during the takeoff initial climb. The pilot's diverted attention to an open door, high density altitude, and wind gusts were contributing factors.Jun 17, 2007 · N6511R · Substantial damageNTSB NYC07LA140Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Washington, NCA loss of engine power for undetermined reasons. Contributing to the accident was the proximity of trees.Jun 17, 2007 · N267C · DestroyedNTSB CHI07LA170Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Lansing, ILThe loss of engine power during takeoff-initial climb due to a bent exhaust valve and fouled spark plugs.Jun 17, 2007 · N5651L · Substantial damageNTSB LAX07LA148Accident · 2 fatalLimited investigationFinal reportHill Europa XS · Livermore, CAthe loss of engine power for an undetermined reason during the initial climb, and the pilot's failure to maintain adequate airspeed while attempting a return to runway maneuver, which resulted in a stall/spin.Jun 16, 2007 · N214KS · DestroyedNTSB NYC07CA137Accident · Minor injuriesData collectionFinal reportPiper PA-28RT-201 · Tinicum, PAThe instrument-rated pilot's failure to maintain runway alignment by instruments after encountering fog during the initial climb. A factor was the foggy weather conditions.Jun 13, 2007 · N3023U · Substantial damageNTSB CHI07CA165Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Manito, ILThe pilot's failure to maintain proper airspeed and his decision to attempt flight over maximum gross weight. A factor to the accident was the stall encountered while attempting to avoid obstacles.Jun 11, 2007 · N26756 · Substantial damageNTSB ATL07LA088Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Taylorsville, KYThe pilot's improper prefight inspection of the helicopter.Jun 11, 2007 · N93GP · Substantial damageNTSB ANC07FA047Accident · No injuriesField investigationFinal reportPiper PA-32-300 · Kake, AKA fractured exhaust manifold, which resulted in an in-flight fire, and the inadequate inspection of the airplane by the operator's maintenance personnel.Jun 11, 2007 · N6117J · DestroyedNTSB SEA07LA147Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Troy, ORThe inadvertent entanglement of the crewmemeber's helmet's communication cord with the structure of the helicopter during the helicopter's ascent, which resulted in the crewmember being elevated above ground level before the helmet's cord separated, resulting…Jun 6, 2007 · N48MP · No damageNTSB DFW07CA129Accident · No injuriesData collectionFinal reportGrumman G-164A · Sayre, OKThe partial loss of engine power on takeoff-initial climb for an undetermined reason. A factor associated with the accident was the lack of suitable terrain for a forced landing.Jun 6, 2007 · N4673 · Substantial damageNTSB CHI07CA161Accident · No injuriesData collectionFinal reportWeatherly 201C · Mc Clusky, NDThe pilot's failure to check for fuel contamination during the preflight inspection, which resulted in a loss of engine power shortly after takeoff due to water contamination. Contributing factors to the accident included the rough/uneven field and the…Jun 5, 2007 · N1246W · Substantial damage