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 IAD00LA066Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Warrenton, VAthe loss of engine power over unsuitable terrain due to an inoperative magneto.Jul 23, 2000 · N32162 · Substantial damageNTSB NYC00LA203Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Columbus, OHa partial power loss for undetermined reason(s).Jul 19, 2000 · N80624 · Substantial damageNTSB CHI00LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Warrensburg, MOinadequate airspeed on takeoff that resulted in a stall/mush condition. Factors associated with the accident were the wet, grass runway, and the trees near the departure end of the runway.Jul 18, 2000 · N4435J · Substantial damageNTSB DEN00LA132Accident · Minor injuriesLimited investigationFinal reportSpencer Long EZE · Farmington, NMFailure of the coolant recovery system, resulting in overheating of the engine. A factor was the soft ground on which the forced landing was made.Jul 17, 2000 · N51EZ · Substantial damageNTSB NYC00LA198Accident · Serious injuriesLimited investigationFinal reportWarrington Surrel Guppy · Churchville, MDThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Factors in this accident were an open canopy and a decrease in engine power.Jul 16, 2000 · N4425W · Substantial damageNTSB MIA00LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Washington, NCThe inadvertent stall by the pilot-in-command while returning for a precautionary landing. Contributing to the accident was the loose engine cowling.Jul 16, 2000 · N2947A · Substantial damageNTSB DEN00LA130Accident · No injuriesLimited investigationFinal reportCessna 150L · Reserve, NMSeizure of the starter clutch assembly needle bearing, which caused the engine to develop less than full rated power and the airplane to achieve less than expected climb performance. Factors were noncompliance of a service bulletin, unsuitable terrain on…Jul 15, 2000 · N18124 · Substantial damageNTSB ANC00LA090Accident · No injuriesLimited investigationFinal reportMaule ML-5 · Wasilla, AKThe pilot's improper use of the fuel tank selector, resulting in fuel starvation.Jul 15, 2000 · N6194M · Substantial damageNTSB ANC00LA089Accident · Minor injuriesLimited investigationFinal reportAeronca 11BC · Wasilla, AKA loss of engine power due to the pilot's failure to use carburetor heat, and an inadvertent stall. A factor associated with the accident was the existence of carburetor icing conditions.Jul 15, 2000 · N9359E · Substantial damageNTSB NYC00LA197Accident · Serious injuriesLimited investigationFinal reportFairchild M-62C · Carthage, NYthe pilot's improper decision to depart with obstacles ahead which exceeded the climb capability of the airplane. Factors were the grass runway, and trees at the departure end of the runway.Jul 12, 2000 · N58741 · Substantial damageNTSB MIA00LA220Accident · No injuriesLimited investigationFinal reportAeronca 65-TC · Harris, NCThe unsuitable terrain encountered by the pilot while descending for a forced landing. Contributing to the accident was the partial loss of engine power due a blocked fuel line resulting in fuel starvation.Jul 12, 2000 · N29416 · Substantial damageNTSB LAX00LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Selma, CAA cracked plastic fuel selector handle that precluded proper engagement of the internal mechanism to fully select a port, and left it in an intermediate position, restricting the fuel supply to the engine, which subsequently lead to a loss of engine power.Jul 12, 2000 · N2466D · Substantial damageNTSB FTW00LA205Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Rio Grande City, TXthe loss of engine power for undetermined reasons. Contributing factors were the pilot flying the airplane with known deficiencies, and the lack of suitable terrain for the forced landing.Jul 12, 2000 · N4322P · Substantial damageNTSB FTW00FA201Accident · 1 fatalField investigationFinal reportCessna T210J · Athens, TXthe pilot's inadvertent stall during initial takeoff climb.Jul 11, 2000 · N2244R · DestroyedNTSB MIA00LA215Accident · No injuriesLimited investigationFinal reportCessna 172L · Beaufort, NCA loss of engine power due to failure of the No. 4 cylinder connecting rod during the first flight following engine overhaul for undetermined reasons. Contributing to the accident was unsuitable terrain.Jul 10, 2000 · N3875Q · Substantial damageNTSB CHI00LA187Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Topeka, KSthe restricted fuel line, and the pilot not attaining proper runway alignment during the forced landing. Factors were the low altitude at which the engine failure occurred, and the landing gear overload.Jul 10, 2000 · N9442K · Substantial damageNTSB NYC00LA186Accident · No injuriesLimited investigationFinal reportHelfer Flightstar II · Greenland, NHThe pilot-in-command's improper decision to takeoff uphill, on a short runway with 50-foot high utility wires at the end, at a high gross weight. Factors were the high weight and uphill terrain.Jul 9, 2000 · N6057U · Substantial damageNTSB MIA00LA210Accident · Minor injuriesLimited investigationFinal reportJames Browning Midget MUSTANG-I · Waycross, GAthe pilot's failure to maintain control during initial climb that resulted in the aircraft colliding with the ground and incurring damage. A factor in the accident was the pilot's diverted attention, when he inadvertently knocked the spectacles off his face…Jul 9, 2000 · N114JB · DestroyedNTSB FTW00LA198Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Leonard, TXThe inadvertent stall. A factor was the improperly positioned fuel selector.Jul 8, 2000 · N8210N · Substantial damageNTSB DEN00LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Montrose, COAn inadvertent stall/mush. Factors were high density altitude, weight and balance exceeded, and pilot fatigue.Jul 8, 2000 · N4723 · Substantial damageNTSB MIA00LA213Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belleview, FLthe loss of engine power during takeoff/initial climb due to undetermined reasons.Jul 7, 2000 · N5819V · Substantial damageNTSB MIA00LA207Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Boone, NCThe failure of the inter-cooler duct connecting the inter-cooler to the engine due to inadequate attachment of the inter-cooler to the aircraft which resulted in loss of turbocharger air overboard and loss of engine power and damage to the aircraft during a…Jul 7, 2000 · N7VZ · Substantial damageNTSB MIA00LA205Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Lake Wales, FLThe pilot's inadequate visual lookout while maneuvering to avoid a flock of birds shortly after takeoff, resulting in the aircraft colliding with a wire. A factor in the accident was the pilot's fatigue after having worked everyday for the previous 3 weeks.Jul 2, 2000 · N983K · Substantial damageNTSB LAX00LA247Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Chester, CAThe loss of engine power for undetermined reasons.Jun 30, 2000 · N933AC · DestroyedNTSB MIA00LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Winter Haven, FLthe flight instructor's failure to follow procedures/directives and his misjudgment of distance/altitude following a loss of engine power for undetermined reasons, which resulted in the proper touchdown point not being attained, an off airport landing being…Jun 29, 2000 · N3317P · Substantial damageNTSB FTW00LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Bovina, TXThe pilot's inadequate preflight planning, which resulted in the pilot exceeding the aircraft's takeoff performance. Factors were the high density altitude and the pilot's delayed load jettison.Jun 29, 2000 · N57596 · Substantial damageNTSB CHI00LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Portland, NDthe pilot intentionally operated the airplane with known damage on the left wing which resulted in the pilot's inability to maintain control of the airplane during takeoff.Jun 29, 2000 · N91891 · Substantial damageNTSB MIA00IA191Incident · No injuriesIncident investigationFinal reportDassault F2TH Falcon · Fort Lauderdale, FLthe fatigue failure of the rivets used to secure the inner casting forward static seal to the 1st-stage low-pressure turbine support/nozzle assembly. The failure of the rivets allowed the forward static seal to machine a groove into the 2nd-stage…Jun 28, 2000 · XATDU · Substantial damageNTSB FTW00LA194Accident · No injuriesLimited investigationFinal reportMooney M20R · Talihina, OKthe partial loss of engine power on takeoff, which resulted from incorrect adjustment of the fuel injector system by maintenance personnel.Jun 28, 2000 · N22166 · Substantial damageNTSB DEN00LA120Accident · No injuriesLimited investigationFinal reportNew Piper PA-46-350P · Spanish Fork, UTFailure by the pilot to maintain control of the aircraft during initial climb following takeoff.Jun 26, 2000 · N9246D · Substantial damageNTSB CHI00LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grant, MIthe pilot's failure to maintain control of the airplane which resulted in a stall/mush condition. Factors associated with the accident were the trees and gusty wind conditions which resulted in turbulence on takeoff.Jun 26, 2000 · N98117 · Substantial damageNTSB SEA00LA112Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Boardman, ORThe pilot's failure to maintain adequate airspeed through an area of turbulence, resulting in entry into a stall/mush condition. Factors included tailwind conditions, trees at the end of the runway, terrain-induced turbulence, and crops near the airstrip.Jun 23, 2000 · N3129V · DestroyedNTSB ANC00FA076Accident · 1 fatalField investigationFinal reportCessna 172N · Tuntutuliak, AKThe pilot's disregard of the existing wind conditions, and an inadvertent stall. Factors associated with the accident are a tailwind, and wind gusts.Jun 23, 2000 · N4762D · DestroyedNTSB NYC00LA176Accident · Minor injuriesLimited investigationFinal reportSchwarz Avid Amphibian · Fredericksburg, VAA failure of the propeller reduction gear assembly for undetermined reasons, which resulted in a loss of thrust.Jun 22, 2000 · N61HS · Substantial damageNTSB FTW00LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ben Wheeler, TXThe pilot's inadvertent stall of the aircraft.Jun 21, 2000 · N55769 · Substantial damageNTSB DEN00LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Orchard, COThe pilot inadvertently stalling the airplane. A factor was his failure to maintain sufficient airspeed.Jun 21, 2000 · N84105 · DestroyedNTSB ATL00LA065Accident · No injuriesLimited investigationFinal reportBeech 19B · Tampa, FLThe loss of engine power for undetermined reasons. A factor was the weather conditions were favorable for the formation of carburetor ice. Contributing to the severity of the accident was the pilots lack of experience in the airplane which led to an…Jun 21, 2000 · N25FD · Substantial damageNTSB SEA00LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Vancouver, WAThe pilot's failure to determine the aircraft's airworthiness before flight, resulting in operation of the aircraft in an unairworthy condition and consequent fuel starvation, and his subsequent failure to maintain adequate airspeed in an emergency turn back…Jun 18, 2000 · N5995H · Substantial damageNTSB CHI00LA167Accident · Serious injuriesLimited investigationFinal reportRans Employee Flying Club Rans S-12 XL · Prairie Du Sac, WIA loss of engine power due to fuel starvation as a result of an obstructed fuel nozzle.Jun 18, 2000 · N43886 · DestroyedNTSB CHI00FA165Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Westfield, INThe pilot's improper in-flight decison to maneuver back to the departure airport following the loss of engine power on initial climb, the pilot's loss of aircraft control and the pilot's inadequate preflight inspection of the airplane. Contributing factors to…Jun 18, 2000 · N1195E · Substantial damageNTSB LAX00LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Coleville, CAthe tow plane pilot's inadequate airplane performance calculations.Jun 17, 2000 · N8578L · Substantial damageNTSB LAX00LA232Accident · No injuriesLimited investigationFinal reportSchleicher AS20 · Coleville, CAthe tow plane pilot's inadequate airplane performance calculations.Jun 17, 2000 · N59WM · Substantial damageNTSB SEA00LA104Accident · 2 fatalLimited investigationFinal reportLunn RV-6A · Hammett, IDThe pilot's entering an inadvertent stall condition, and the lack of adequate altitude in which to successfully recover before ground impact.Jun 14, 2000 · N322KE · DestroyedNTSB DEN00LA107Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Santa Fe, NMThe pilot's failure to maintain control of the aircraft. A factor was gusty wind conditions.Jun 11, 2000 · N25222 · Substantial damageNTSB CHI00LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Sully, IAThe pilot inadvertently applied full flaps during the aborted landing and was not able to gain enough altitude to clear a fence post at the end of the airstrip. Factors associated with the accident were the trees at the approach end of the airstrip, the pilot…Jun 11, 2000 · N9315W · Substantial damageNTSB CHI00LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Flushing, MIaltitude/clearance from the trees not being obtained/maintained by the pilot during the initial climb after takeoff. Factors to the accident were the inadequate preflight planning/preparation by the pilot, including takeoff performance data not being…Jun 10, 2000 · N2379T · Substantial damageNTSB NYC00LA156Accident · Minor injuriesLimited investigationFinal reportStewart S-51 · Forty Fort, PAThe owner/builder's inadequate design, resulting in total failure of the reduction gear assembly accessory drive shaft.Jun 9, 2000 · N51FY · Substantial damageNTSB CHI00LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Minneapolis, MNthe failure of the engine and the unsuitable terrain for landing encountered by the pilot-in-command. Factors to the accident were the fracture of the crankshaft due to fatigue, excessive main bearing wear, and the swampy terrain condition.Jun 8, 2000 · N8189T · Substantial damageNTSB ATL00LA060Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Foley, ALThe pilot exceeding the performance capability of the airplane during takeoff. A factor was the trees.Jun 8, 2000 · N2849L · Substantial damageNTSB DEN00LA103Accident · No injuriesLimited investigationFinal reportCessna 185B · Moab, UTThe fire in the engine compartment for unknown reason.Jun 6, 2000 · N185RL · Destroyed