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 FTW04LA189Accident · Serious injuriesLimited investigationFinal reportCalhoun RV-4 · Latexo, TXThe pilot's failure to maintain directional control and attain adequate airspeed resulting in a stall. Contributing factors were the pilot's diverted attention with closing the canopy, and the quartering crosswind.Jul 18, 2004 · N996NC · DestroyedNTSB FTW04LA183Accident · 1 fatalLimited investigationFinal reportBeech C23 · Morrilton, ARThe pilot's inadequate preflight planning/preparation to assure adequate takeoff performance to clear obstacles.Jul 14, 2004 · N48DB · DestroyedNTSB CHI04MA182Accident · 4 fatalMajor investigationFinal reportBell 407 · Newberry, SCThe pilot's failure to maintain terrain clearance as a result of fog conditions. A contributing factor was inadequate weather and dispatch information relayed to the pilot.Jul 13, 2004 · N503MT · DestroyedNTSB ATL04IA156Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-233 · Atlanta, GAThe failure of company maintenance personnel to secure the nacelle/cowl doors, which resulted in a separation of the doors during takeoff initial climb.Jul 13, 2004 · N951LF · Minor damageNTSB LAX04LA261Accident · No injuriesLimited investigationFinal reportEurocopter France AS350 B2 · Peach Springs, AZThe pilot's selection of downwind takeoff direction and improper use of the collective control prior to reaching translational lift, which resulted in a settling with power condition and a collision with the ground. Also causal was the pilot's failure to…Jul 12, 2004 · N91MH · Substantial damageNTSB FTW04LA182Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eagle Lake, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jul 12, 2004 · N8222K · Substantial damageNTSB NYC04LA163Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Hackettstown, NJThe pilot's inadequate preflight inspection, which resulted in the total loss of engine power due to fuel contamination, during the initial climb after takeoff.Jul 11, 2004 · N302SB · Substantial damageNTSB ANC04CA076Accident · No injuriesData collectionFinal reportCessna 180J · Bettles, AKThe pilot's inadequate compensation for the wind conditions during takeoff/initial climb, which resulted in a loss of control and in-flight collision with terrain. Factors contributing to the accident were the pilot's inadequate weather evaluation, and a…Jul 11, 2004 · N888FF · Substantial damageNTSB ATL04LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Cumming, GAThe pilot's failure to obtain takeoff performance data, and his intentional takeoff from a closed and short runway which resulted in an in-flight collision with a tree.Jul 10, 2004 · N56776 · Substantial damageNTSB NYC04LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Jaffrey, NHThe loss of engine power for undetermined reasons.Jul 7, 2004 · N2489M · Substantial damageNTSB NYC04LA158Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Batavia, OHThe pilot's inadequate preflight preparation which failed to assure the takeoff performance needed to out climb obstacles. Factors in this accident were the up sloping runway, the high density altitude, and airplane being loaded above it's maximum gross…Jul 6, 2004 · N5903L · Substantial damageNTSB FTW04LA174Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Gordonville, TXThe pilot's premature lift-off and his failure to abort the takeoff. Contributing factors were the soft and muddy runway conditions and the unfavorable winds.Jul 4, 2004 · N6241L · Substantial damageNTSB NYC04LA151Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Morgantown, WVThe pilot's improper fuel management, which resulted in fuel starvation and a subsequent loss of engine power.Jul 1, 2004 · N5345E · Substantial damageNTSB NYC04CA150Accident · No injuriesData collectionFinal reportHenes Zenair CH 701 · Mansfield, OHThe pilot's failure to maintain directional control during a precautionary landing. A factor was the pilot's unapproved maintenance modification resulting in the loss of oil pressure and partial loss of engine power.Jul 1, 2004 · N98EH · Substantial damageNTSB CHI04LA167Accident · No injuriesLimited investigationFinal reportBeech 200 · Green Bay, WIThe loss of engine power after takeoff for an undetermined reason.Jun 30, 2004 · N432FA · Substantial damageNTSB ANC04LA067Accident · No injuriesLimited investigationFinal reportRufli Theodore J Rufli · Fairbanks, AKThe loss of engine power for an undetermined reason during takeoff-initial climb, which resulted in a forced landing and an on ground collision with a parked and unoccupied airplane.Jun 24, 2004 · N6191R · Substantial damageNTSB NYC04CA146Accident · No injuriesData collectionFinal reportCessna 172P · Springfield, OHThe pilot's failure to maintain adequate airspeed resulting in a stall and hard landing.Jun 23, 2004 · N65612 · Substantial damageNTSB FTW04LA166Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Crowley, LAThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.Jun 23, 2004 · N60713 · Substantial damageNTSB CHI04CA169Accident · Minor injuriesData collectionFinal reportBellanca 8GCBC · Mankato, MNThe pilot's improper decision to initiate the flight given the crosswind wind condition. Additional causes were the pilot's inadequate compensation for the crosswind and his subsequent failure to maintain aircraft control. The crosswind and the runway light…Jun 23, 2004 · N88089 · Substantial damageNTSB CHI04CA163Accident · No injuriesData collectionFinal reportGrumman G-164A · Hutchinson, MNThe pilot's failure to maintain airspeed during the low altitude turn after takeoff. A factor to the accident was the low altitude and the swampy terrain condition.Jun 23, 2004 · N5339 · Substantial damageNTSB ATL04FA139Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Fort Lauderdale, FLThe pilot's inadequate preflight planning which resulted in the loss of engine power due to fuel exhaustion, and the pilot's failure to maintain flying speed which resulted in an inadvertent stall, and the subsequent collision with a building.Jun 23, 2004 · N9578C · Substantial damageNTSB MIA04LA099Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Deland, FLA loss of engine power due to an engine master rod bearing failure for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.Jun 20, 2004 · N28BZ · Substantial damageNTSB ATL04CA136Accident · Serious injuriesData collectionFinal reportBeech A23 · Columbia, TNThe pilot's failure to maintain clearance from trees during climb and the pilot's failure to execute a go-around before completing the approach to land.Jun 20, 2004 · N1435L · Substantial damageNTSB CHI04CA140Accident · No injuriesData collectionFinal reportCessna 150H · Mount Pleasant, MIThe pilot's improper decision to takeoff downwind from the rough field and his failure to maintain aircraft control. A factor to the accident was the rough/uneven alfalfa field and the tailwind experienced during the takeoff.Jun 16, 2004 · N3915V · Substantial damageNTSB LAX04LA240Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's failure to maintain a proper pitch attitude during tow operations and his failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.Jun 13, 2004 · N4602Y · Substantial damageNTSB DEN04LA089Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200 · Pueblo, COThe pilot's failure to maintain adequate airspeed resulting in an accelerated stall at an altitude too low for recovery. A factor was the pilot's lack of experience in the aircraft make and model.Jun 12, 2004 · N611HA · DestroyedNTSB ATL04CA129Accident · No injuriesData collectionFinal reportCessna 172N · Dover, TNThe certified flight instructor initiated flight into thunderstorm activity that resulted in a loss of control and the subsequent collision with trees.Jun 12, 2004 · N5153E · Substantial damageNTSB LAX04LA267Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Richvale, CAthe loss of engine power during takeoff due to the engine's deteriorated fuel control unit's inner drive shaft bearing. The reason for the bearing's deteriorated condition could not be determined.Jun 7, 2004 · N3626T · Substantial damageNTSB CHI04LA145Accident · Minor injuriesLimited investigationFinal reportBetchan KR II · Rapid City, SDFailure of the engine rocker arm installation resulting in a loss of engine power. A contributing factor was the power lines.Jun 7, 2004 · N250KB · DestroyedNTSB SEA04LA103Accident · No injuriesLimited investigationFinal reportD'Amico Kitfox Series 7 · Caldwell, IDThe disconnection of the elevator pitch control assembly and the pitch rod during the takeoff as a result of an unsecured bolt.Jun 5, 2004 · N1852N · Substantial damageNTSB FTW04LA152Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Dumas, ARThe loss of engine power for undetermined reasons.Jun 5, 2004 · N161RA · Substantial damageNTSB CHI04LA147Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Manitowoc, WIFailure of the number 4 piston articulating rod resulting in a complete loss of engine power during initial climb. The ditch was a contributing factor.Jun 4, 2004 · N404DK · Substantial damageNTSB MIA04LA092Accident · 1 fatalLimited investigationFinal reportNorth American T-28B · Wesley Chapel, FLThe pilot's failure to verify security of the left engine cowling and its subsequent separation in-flight and collision with the vertical stabilizer resulting in the loss of aircraft control.Jun 3, 2004 · N261FM · Substantial damageNTSB LAX04LA225Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Susanville, CAthe pilot's failure to perform a proper preflight inspection of the airplane and ensure that the oil cap was secured, which resulted in a descent into terrain due to his obstructed view out of the windshield.May 31, 2004 · N9816K · Substantial damageNTSB LAX04FA226Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Columbia, CAThe loss of engine power for undetermined reason during takeoff-initial climb, and the pilot's failure to maintain sufficient airspeed to avoid a stall/mush. Factors associated with the accident are an inadvertent stall/mush, and the pilot's failure to abort…May 31, 2004 · N7626J · DestroyedNTSB SEA04LA094Accident · No injuriesLimited investigationFinal reportBeech P-35 · Havre, MTA loss of engine power due to fuel starvation during the initial climb after takeoff as a result of an unsecured fuel sender unit which resulted in a false fuel quantity indication.May 29, 2004 · N7DR · Substantial damageNTSB CHI04LA131Accident · 1 fatalLimited investigationFinal reportZorn EAA Sport Bi-Plane · Mazon, ILThe pilot's failure to maintain airspeed while maneuvering which resulted in a stall. A factor associated with the accident was the pilot's unfamiliarity with the handling characteristics of the airplane.May 29, 2004 · UNREG · Substantial damageNTSB LAX04LA228Accident · Minor injuriesLimited investigationFinal reportWilson Avid Bandit · Paso Robles, CAthe loss of engine power during takeoff climb due to a cold seizure of the rear cylinder.May 28, 2004 · N55368 · Substantial damageNTSB NYC04LA133Accident · Serious injuriesLimited investigationFinal reportMosher Avid Heavy Hauler · Fitchburg, MAThe malfunction of the elevator control system, resulting in a forced landing.May 27, 2004 · N5139W · DestroyedNTSB FTW04CA141Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Tarzan, TXThe pilot's failure to maintain proper airspeed suitable for flight. Contributing factors were the high density altitude and tail wind condition.May 26, 2004 · N61407 · Substantial damageNTSB ANC04LA057Accident · Minor injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe pilot/owner's failure to ensure that the airplane was in an airworthy condition prior to flight, which resulted in a partial loss of engine power and subsequent in-flight collision with a residence during an emergency landing after takeoff. Factors…May 26, 2004 · N70233 · Substantial damageNTSB DEN04FA078Accident · 1 fatalField investigationFinal reportAir Borne Windsports Pty. Edge Wing X · Carter, WYThe non-certificated pilot's failure to maintain adequate airspeed resulting in a stall. Factors contributing to the accident include the non-certificated pilot's improper judgment and the his lack of experience.May 25, 2004 · UNREG · DestroyedNTSB NYC04CA129Accident · Minor injuriesData collectionFinal reportGrumman American AA-5 · Greene, RIThe pilots improper decision to depart with the flaps set to 10 degrees, and his failure to obtain proper airspeed, which resulted in a collision with trees.May 23, 2004 · N7132L · Substantial damageNTSB ANC04LA055Accident · No injuriesLimited investigationFinal reportCessna 185E · King Salmon, AKThe pilot's inadequate compensation for wind conditions during takeoff and initial climb, which resulted in a loss of control, and an in-flight collision with water. A factor contributing to the accident was gusty wind conditions.May 20, 2004 · N1932U · Substantial damageNTSB CHI04CA122Accident · No injuriesData collectionFinal reportCessna 180J · South St. Paul, MNThe total loss of engine power during takeoff climb due to fuel starvation as a result of the pilot's failure to follow the aircraft's checklist and leaving the fuel selector in the OFF positon.May 19, 2004 · GNQK · Substantial damageNTSB DEN04CA076Accident · No injuriesData collectionFinal reportWilford J. Tolman Kitfox 6 · Montrose, COthe pilot's failure to maintain aircraft control during takeoff initial climb. A contributing factor was the gusting left tailwind weather condition.May 18, 2004 · N3079H · Substantial damageNTSB MIA04LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Everglades City, FLThe failure of the pilot to maintain airspeed during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and impact in a wooded area.May 16, 2004 · N33840 · Substantial damageNTSB NYC04FA123Accident · 1 fatalField investigationFinal reportCessna 310R · Willoughby, OHThe pilot's failure to maintain aircraft control during the initial climb after takeoff. Factors in this accident were clouds and the night conditions.May 15, 2004 · N3161M · DestroyedNTSB FTW04LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oil City, LAA loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed resulting in a stall..May 10, 2004 · N24007 · Substantial damageNTSB CHI04CA118Accident · No injuriesData collectionFinal reportPiper PA-12 · Hartford, WIThe loss of engine power for undetermined reasons. A factor to the accident was the soft terrain encountered during the forced landing.May 9, 2004 · N2368M · Substantial damage