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 LAX06CA060Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Irwindale, CAThe pilot failed to maintain adequate main rotor rpm.Dec 19, 2005 · N177LH · DestroyedNTSB NYC06LA035Accident · No injuriesLimited investigationFinal reportRobinson R44 · Linden, NJA loss of engine power for undetermined reasons.Dec 18, 2005 · N44EK · Substantial damageNTSB MIA06LA028Accident · No injuriesLimited investigationFinal reportMestas Felix R Velocity LWFG-E · Punta Gorda, FLA loss of engine power for undetermined reasons.Dec 10, 2005 · N535BM · DestroyedNTSB SEA06CA025Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Prineville, ORAircraft control not maintained by the private pilot during the initial takeoff climb, and the improper remedial action by the flight instructor. A factor was the wind gust.Dec 9, 2005 · N2584S · Substantial damageNTSB DFW06FA037Accident · 3 fatalField investigationFinal reportPiper PA-30 · Raymond, MSThe pilot's failure to maintain Vmc (velocity minimum control) on initial climb resulting in a loss of control. Contributing factors were the loss of engine power to the right engine and the prevailing gusty wind conditions.Dec 1, 2005 · N7315Y · DestroyedNTSB CHI06CA039Accident · Serious injuriesData collectionFinal reportLarson Aero Comp-6 · Brainerd, MNThe pilot/builder inadvertently reversed the aileron control systems during installation and failed to maintain control of the airplane during takeoff. A factor associated with the accident was the pilot/builder’s failure to perform an adequate aircraft…Nov 30, 2005 · N4334Z · Substantial damageNTSB DFW06CA034Accident · No injuriesData collectionFinal reportCessna 210M · Kirbyville, TXThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Nov 28, 2005 · N761FL · Substantial damageNTSB DFW06CA035Accident · No injuriesData collectionFinal reportCessna P206 · New Braunfels, TXThe pilot's improper compensation for the existing wind conditions resulting in a loss of control. A contributing factor was the gusty crosswind.Nov 23, 2005 · N2564X · Substantial damageNTSB SEA06IA019Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G-5 · Hillsboro, ORThe failure of the right main landing gear (MLG) door uplock linkage actuator due to corrosion, which resulted in jamming of the right MLG during the initial takeoff climb.Nov 21, 2005 · N225GV · Minor damageNTSB LAX06LA041Accident · 2 fatalLimited investigationFinal reportTingle Special · Tucson, AZThe pilot's excessive use of power during takeoff, which resulted in an inadvertent torque roll shortly after lift off. Also causal was the pilot's failure to abort the takeoff when directional control could not be maintained during the takeoff roll.Nov 19, 2005 · N660T · DestroyedNTSB NYC06FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Leesburg, VAThe flight instructor's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with trees and terrain.Nov 9, 2005 · N4171T · Substantial damageNTSB NYC06LA028Accident · No injuriesLimited investigationFinal reportCessna 172L · Lehighton, PAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during takeoff due to fuel contamination, and a subsequent forced landing to a field.Nov 8, 2005 · N7684G · Substantial damageNTSB LAX06LA029Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Mesa, AZthe failure of the flap motor fuse that rendered the flaps inoperable during a critical phase of flight. Factors in the accident were the lack of suitable terrain to perform an emergency landing and the owner's use of nonapproved fuses for the flap motor…Nov 8, 2005 · N8903S · Substantial damageNTSB ATL06CA118Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe student pilot's failure to maintain airspeed during a touch-and-go landing on initial takeoff climb, resulting in a hard landing on the departure runway.Nov 7, 2005 · N3015E · Substantial damageNTSB DFW06FA019Accident · 2 fatalField investigationFinal reportCessna 500 · Houston, TXThe pilot's failure to maintain directional control of the airplane resulting in an inadvertent stall/mush. Contributing factors were the unsecured passenger door and the pilot's diverted attention.Nov 5, 2005 · N505K · DestroyedNTSB CHI06CA024Accident · Minor injuriesData collectionFinal reportColson/Goodbread Rans S-12 · Flushing, MIThe loss of engine power on initial climb for undetermined reasons. A factor was the tree the airplane impacted during the forced landing.Oct 29, 2005 · N62078 · Substantial damageNTSB SEA06CA014Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Yelm, WAThe complete loss of engine power during the initial climb for undetermined reasons, and the excessive descent rate during the ensuing forced landing.Oct 27, 2005 · N85534 · Substantial damageNTSB ANC06CA006Accident · No injuriesData collectionFinal reportCessna 172 · Naknek, AKThe pilot's inadequate removal of frost from the wings, and his failure to attain adequate airspeed during takeoff initial climb, which resulted in a stall and collision with terrain. Factors contributing to the accident were the pilot's delayed aborted…Oct 23, 2005 · N6832A · Substantial damageNTSB DFW06CA015Accident · Minor injuriesData collectionFinal reportChamberlain Vans RV6 · Eunice, LAThe loss of engine power for undetermined reason. A contributing factor was lack of suitable terrain for the forced landing.Oct 22, 2005 · N296PC · Substantial damageNTSB MIA06FA007Accident · 1 fatalField investigationFinal reportCessna 172P · La Belle, FLThe student pilot's failure to maintain airspeed during the initial takeoff climb, resulting in an inadvertent stall/spin and uncontrolled descent to ground impact. A contributing factor was the failure of the wing flap control, which resulted in the flaps…Oct 16, 2005 · N99173 · Substantial damageNTSB DEN06LA007Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · New Century, KSloss of engine power due to the pilot's improper use of carbuetor heat and his improper inflight planning/decision. Contributing factors were the inadequate supervision of the student by the flight instructor, conditions conducive to carburetor ice, dark…Oct 12, 2005 · N8875D · Substantial damageNTSB LAX06CA007Accident · No injuriesData collectionFinal reportAppel RDA 04 · Clovis, NMa loss of engine power due to water contamination of the fuel system. The inadequate placement of the fuel system drain by the builder was a factor.Oct 11, 2005 · N835RA · Substantial damageNTSB LAX06FA005Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Oroville, CAThe certified flight instructor and the private pilot's failure to maintain adequate airspeed while attempting a return to runway maneuver, which resulted in an inadvertent stall.Oct 10, 2005 · N943D · DestroyedNTSB MIA06LA004Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Lakeland, FLThe failure of the pilot-in-command to abort the takeoff.Oct 9, 2005 · N6413S · DestroyedNTSB MIA06LA001Accident · Serious injuriesLimited investigationFinal reportPilatus PC-6/B2-H2 · Deland, FLThe pilot's incorrect setting of the stabilizer trim and his failure to maintain adequate airspeed during takeoff initial climb, which resulted in a stall. A factor contributing to the accident was an inadvertent stall. A factor contributing to the severity…Oct 3, 2005 · N7895J · Substantial damageNTSB SEA06CA001Accident · Minor injuriesData collectionFinal reportCessna 150D · Greenwater, WAThe pilot's inadvertently flying into IMC weather conditions, his failure to maintain sufficient airspeed for flight, and his subsequent inadvertent stall/mush into trees. Contributing factors were the fog and the trees.Oct 2, 2005 · N4175U · DestroyedNTSB IAD05LA144Accident · Serious injuriesLimited investigationFinal reportHoward Whyte Nieuport 28 · Dayton, OHA loss of engine power due to the installation of incorrect spring type terminal contacts which were accidentally supplied by the engine distributor.Sep 30, 2005 · N62610 · Substantial damageNTSB DFW05CA253Accident · No injuriesData collectionFinal reportCessna 172S · Batesville, TXThe pilot's failure to maintain clearance from the tree. A contributing factor was the gusty winds.Sep 29, 2005 · N5343U · Substantial damageNTSB SEA05FA201Accident · 2 fatalField investigationFinal reportCessna P210N · Salmon, IDThe pilot's failure to obtain airspeed during the initial takeoff climb, which resulted in a stall/mush and subsequent collision with terrain.Sep 28, 2005 · N45SE · DestroyedNTSB LAX05LA319Accident · Minor injuriesLimited investigationFinal reportRose Kitfox · Hesperia, CAa loss of engine power due to a loose master ignition relay wire.Sep 27, 2005 · N656T · Substantial damageNTSB LAX05LA317Accident · No injuriesLimited investigationFinal reportCessna A185F · Tracy, CAloss of engine power for undetermined reasons.Sep 26, 2005 · N8548Q · Substantial damageNTSB SEA05CA197Accident · No injuriesData collectionFinal reportCessna 180H · Yelm, WAThe mixture control linkage separation as a result of a missing retaining nut and washer on the mixture cable attach bolt. Inadequate maintenance inspection and fences were factors.Sep 22, 2005 · N1037V · Substantial damageNTSB LAX05IA312Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320 · Los Angeles, CAThe fatigue failure of two anti-rotation lugs due to repeated cyclic pre-landing tests, which allowed the nosewheels to deviate from the 0-degree position on landing gear retraction. A contributing factor was the design of the Brake Steering Control Unit…Sep 22, 2005 · N536JB · Minor damageNTSB DFW05CA247Accident · Minor injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Mexia, TXThe pilot's failure to maintain clearance from the barn. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.Sep 22, 2005 · N909KF · DestroyedNTSB LAX05LA309Accident · Serious injuriesLimited investigationFinal reportThomas RV4 · Kernville, CAa loss of engine power due to fuel starvation caused by the pilot's failure to select a tank containing fuel for takeoff. A factor in the accident was the lack of a runway overrun area beyond the departure end of the runway.Sep 21, 2005 · N3882N · Substantial damageNTSB NYC05LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Millville, NJThe flight instructor's improper in-flight decision to perform a emergency landing to a runway, with a tailwind, and his failure to maintain airspeed after aborting that landing, which resulted in an inadvertent stall and subsequent impact with terrain.…Sep 20, 2005 · N6494J · Substantial damageNTSB LAX05LA305Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Bisbee, AZthe pilot's failure to lean the mixture in accordance with the pilot operating handbook specified procedures, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush…Sep 19, 2005 · N5757D · Substantial damageNTSB SEA05CA195Accident · Minor injuriesData collectionFinal reportEiland RAF-200 Gyro · Bend, ORThe malfunction of the flight controls for an undetermined reason, which resulted in a loss of control and in-flight collision with terrain.Sep 18, 2005 · N4416N · Substantial damageNTSB DFW05FA241Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Houston, TXThe pilot's improper in-flight decision to maneuver back to the departure airport following a loss of engine power on initial climb. Contributing factors were the loss of engine power for undetermined reasons, and the dark night conditions.Sep 18, 2005 · N69146 · DestroyedNTSB MIA05LA158Accident · 2 fatalLimited investigationFinal reportCessna 172C · Saint Cloud, FLThe pilot's failure to maintain the airspeed while maneuvering following loss of engine power resulting in a stall/mush, an uncontrolled descent, and collision with trees and the ground.Sep 16, 2005 · N1814Y · DestroyedNTSB SEA05LA194Accident · No injuriesLimited investigationFinal reportCessna 182P · Yellow Pine, IDThe pilot's improper preflight planning/preparation during takeoff. A factor was the windshear.Sep 15, 2005 · N58717 · Substantial damageNTSB CHI05CA271Accident · No injuriesData collectionFinal reportBell 206B · Elk Point, SDThe loss of directional control for undetermined reasons which led to the pilot not being able to maintain clearance from the embankment during the forced landing. The rising embankment was a factor.Sep 15, 2005 · N2995W · Substantial damageNTSB DFW05CA237Accident · Minor injuriesData collectionFinal reportCessna 172M · Amarillo, TXThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall. Contributing factors were the reported loss of engine power for undetermined reasons and the high density altitude.Sep 14, 2005 · N19998 · DestroyedNTSB SEA05CA191Accident · No injuriesData collectionFinal reportGleason Sky Star Kitfox · Klamath Falls, ORThe binding of the flaperon push pull tube due to deformation of the front seat, which resulted in a loss of control on takeoff initial climb and collision with the runway.Sep 12, 2005 · N852PG · Substantial damageNTSB LAX05FA296Accident · 2 fatalField investigationFinal reportCessna 152 · Lakewood, CAthe certified flight instructor's failure to maintain an adequate airspeed resulting in a stall and loss of control. Also causal was the engine's loss of partial power due to inadequate maintenance, worn spark plugs, worn pistons, and broken piston rings.Sep 11, 2005 · N6565L · DestroyedNTSB LAX05CA295Accident · Minor injuriesData collectionFinal reportRicardo Lopez RAF 2000 Gtxse · Wickenburg, AZthe pilot's failure to obtain and maintain an adequate airspeed and rotor speed during takeoff.Sep 11, 2005 · N282SL · Substantial damageNTSB NYC05LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marstons Mills, MAThe pilot's failure to attain a climb during takeoff which resulted in a diminished climb rate and subsequent collision with trees. Factors were the turf runway and a tailwind.Sep 10, 2005 · N6777W · Substantial damageNTSB LAX05CA294Accident · No injuriesData collectionFinal reportSchweizer SGS2-33A · Peoria, AZthe pilot's encounter with obstacles and unsuitable terrain in the landing area during the pilot's attempted precautionary landing. A factor in the accident was the loose wing root gap seal fairing.Sep 10, 2005 · N2054T · Substantial damageNTSB SEA05LA192Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Chehalis, WAThe pilot's failure to follow the checklist to switch to the fullest fuel tank prior to departure which resulted in fuel starvation and a loss of engine power during the initial takeoff climb. Subsequently, the aircraft landed hard damaging the landing gear…Sep 9, 2005 · N3617F · Substantial damageNTSB CHI05LA261Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Faulkton, SDThe pilot's failure to maintain control of the airplane due to spatial disorientation during initial climb after takeoff into night instrument meteorological conditions. Factors were the fog and the dark night.Sep 9, 2005 · N8523W · Destroyed