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 NYC00LA029Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canandaigua, NYThe pilot's inadequate preflight which resulted in a loss of power due to fuel contamination. Factors related to the accident were the pilot's non-compliance of an airworthiness directive, failure to perform an annual inspection, and improper modifications of…Nov 9, 1999 · N93688 · Substantial damageNTSB SEA00FA015Accident · No injuriesField investigationFinal reportKaman K-1200 · Emida, IDFailure of the splined engine adaptor as a result of torsional overstress. Factors include a worn freewheeling clutch assembly.Nov 4, 1999 · N164KA · Substantial damageNTSB FTW00LA023Accident · No injuriesLimited investigationFinal reportCessna 172B · Beaumont, TXFuel exhaustion as a result of the flight instructor's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.Nov 1, 1999 · N7833X · Substantial damageNTSB FTW00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bogalusa, LAThe total loss of engine power as a result of water contamination in the fuel system.Oct 30, 1999 · N2654T · Substantial damageNTSB ATL00LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Bay Springs, MSThe pilot's failure to maintain flying speed that resulted in a loss of control and stall. A factor was a stuck exhaust valve.Oct 29, 1999 · N6444F · Substantial damageNTSB SEA00LA008Accident · No injuriesLimited investigationFinal reportCessna 150B · Sweet Home, ORCarburetor heat was not used prior to takeoff. Carburetor icing conditions and high vegetation were factors.Oct 23, 1999 · N1252Y · Substantial damageNTSB MIA00LA007Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lebanon, TNThe inadequate annual inspection of the airplane by the mechanic for his failure to note that the threaded portion of the bail wire had 2 1/2 failed threads which resulted in the inability to keep the gascolator bowl tightly secured. Also his failure to note…Oct 15, 1999 · N3013C · Substantial damageNTSB DEN00LA006Accident · No injuriesLimited investigationFinal reportKendall/Mckaughlin Rans S-10 Sakota · Hudson, COInadequate preflight planning when the pilot failed to evaluate aircraft performance and weather. Factors were high density altitude, and unsuitable terrain for a forced landing.Oct 9, 1999 · N444YB · Substantial damageNTSB ANC00LA001Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Anchorage, AKThe pilot's inadequate preflight inspection to remove all contaminated fuel from the fuel system. A factor associated with the accident was an unsuitable terrain condition for landing.Oct 3, 1999 · N4156Y · Substantial damageNTSB NYC00LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wolfeboro, NHA total loss of engine power for undetermined reasons.Oct 2, 1999 · N6921X · Substantial damageNTSB LAX00LA001Accident · No injuriesLimited investigationFinal reportIsmari Canard C3A · Henderson, NVA partial loss of engine power for undetermined nonmechanical reasons. A contributing factor was the rough nature of the terrain used for the forced landing.Oct 2, 1999 · N4526W · Substantial damageNTSB CHI00LA002Accident · Minor injuriesLimited investigationFinal reportEnstrom EN-28 · Indianapolis, INThe pilot's attempted operation of the helicopter with known deficiencies, and his improper autorotation to landing. Factors were one fouled spark plug and another partially failed spark plug in the same cylinder, and the construction area.Oct 2, 1999 · N602H · Substantial damageNTSB CHI99LA357Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Greenfield, INthe FBO employee improperly refueled the airplane with Jet A fuel instead of 100LL and the inadequate preflight by the pilot-in-command in that he failed to drain the fuel tanks during the preflight. Factors related to the accident were the low altitude at…Sep 30, 1999 · CGHOL · Substantial damageNTSB CHI99LA353Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Gran Marais, MNthe downwind turn, stall, mush, due to the pilot's decision to turn and failure to maintain flying speed.Sep 26, 1999 · N65353 · Substantial damageNTSB DEN99LA169Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Animas, NMA inadvertent stall during initial climb following takeoff. Factor were: high gross weight, high density altitude, inadequate preflight planning and preparation, and soft terrain.Sep 23, 1999 · N8731H · Substantial damageNTSB CHI99LA358Accident · No injuriesLimited investigationFinal reportBosick Pulsar · Belleville, ILA loss of engine power for undetermined reasons.Sep 23, 1999 · N9550 · Substantial damageNTSB IAD99LA068Accident · No injuriesLimited investigationFinal reportCessna 172P · Friendly, MDThe pilot's misjudgment of speed during the landing approach. The inoperative airspeed indicator was a contributing factor.Sep 21, 1999 · N63325 · Substantial damageNTSB LAX99LA314Accident · No injuriesLimited investigationFinal reportCessna 177A · Big Bear City, CAA loss of engine power due to fuel system contamination, which resulted from the mechanic's failure to fully inspect and verify the serviceability of the fuel system before returning the aircraft to service for a maintenance ferry flight. The pilot's decision…Sep 20, 1999 · N39AE · Substantial damageNTSB FTW99FA261Accident · 5 fatalField investigationFinal reportCessna 182A · Bryan, TXthe pilot's failure to maintain aircraft control resulting in an inadvertent stall. A factor was the loss of engine power as a result of fatigue cracking and separation of the #6 cylinder head.Sep 18, 1999 · N4803D · DestroyedNTSB DEN99LA163Accident · No injuriesLimited investigationFinal reportRobinson R22A · Tucumcari, NMThe pilot's inadequate visual lookout. A factor was a reduced visual detection due to background vegetation and terrain.Sep 18, 1999 · N8497Y · Substantial damageNTSB CHI99FA341Accident · 3 fatalField investigationFinal reportCessna 172H · Plattsburg, MOthe pilot's failure to maintain airspeed during the initial climb. A factor relating to this accident was the inadvertent stall/spin.Sep 16, 1999 · N1406F · DestroyedNTSB LAX99LA303Accident · 1 fatalLimited investigationFinal reportNye KR-2 · Mariposa, CAThe pilot's failure to maintain an adequate airspeed margin while performing an intentional steep right bank turning maneuver, which resulted in a stall/mush and descent into terrain.Sep 15, 1999 · N71KN · DestroyedNTSB FTW99LA257Accident · No injuriesLimited investigationFinal reportCessna 150J · Frisco, TXFuel exhaustion due to the pilot's inadequate preflight and his failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.Sep 13, 1999 · N50495 · Substantial damageNTSB NYC99LA225Accident · No injuriesLimited investigationFinal reportPiper PA-28-201RT · Toms River, NJThe pilot's failure to obtain proper clearance over an obstacle.Sep 12, 1999 · N8313R · Substantial damageNTSB FTW99FA256Accident · 1 fatalField investigationFinal reportSpagnoletti AIR Command 582 · Conroe, TXThe pilot's failure to maintain aircraft control during the takeoff/initial climb. A factor was the pilot's lack of recent experience in the type of aircraft.Sep 12, 1999 · N813AC · DestroyedNTSB CHI99LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Daleville, INA loss of engine power for undetermined reasons.Sep 11, 1999 · N172DJ · Substantial damageNTSB ANC99LA143Accident · No injuriesLimited investigationFinal reportDiehl Interstate S-4 · Anchorage, AKThe pilot's inadequate planning/decision, and his failure to maintain directional control of the airplane. Factors in the accident were a short runway/lake area for departure, and the pilot's extension of the landing gear steering system (water rudders)…Sep 11, 1999 · N4BZ · Substantial damageNTSB NYC99LA221Accident · 1 fatalLimited investigationFinal reportValenza Volksplane VP-II · Westmore, VTThe pilot's failure to maintain adequate altitude/clearance from the trees. A related factor was the pilot's lack of familiarity with the airplane.Sep 6, 1999 · N8535B · DestroyedNTSB ATL99LA123Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, MSThe pilot's failure to switch the magneto switch to the both position before attempting a takeoff that resulted in the loss of engine power and resulted in the subsequent collision with trees.Sep 6, 1999 · N9785T · Substantial damageNTSB ANC99LA142Accident · No injuriesLimited investigationFinal reportCessna 150 · Big Lake, AKThe pilot's inadequate preflight planning. Factors associated with this accident were the pilot's failure to use the takeoff performance charts, the short runway and uphill takeoff, and a sudden windshift.Sep 6, 1999 · N63460 · Substantial damageNTSB NYC99FA220Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Westerly, RIThe pilot's loss of control of the airplane during a turn.Sep 5, 1999 · N4830S · Substantial damageNTSB NYC99LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Andover, NJFatigue failure of the crankshaft.Sep 3, 1999 · N8143E · Substantial damageNTSB LAX99LA293Accident · No injuriesLimited investigationFinal reportBell 206B · Delhi, CAThe loss of engine power due to the pilot's inadequate preflight, which failed to detect water contamination of the fuel system. The operator's inadequate maintenance of the loose fitting fuel cap and the deformed filler opening, which allowed water to leak…Sep 1, 1999 · N59551 · Substantial damageNTSB ATL99LA121Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cairo, GAThe loss of engine power for undetermined reasons. Factors were weather conditions favorable for the formation of carburetor ice.Sep 1, 1999 · N8965Q · Substantial damageNTSB DEN99LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Peyton, COThe pilot's loss of control resulting in inadvertent stall/mush during initial climb following takeoff. Factors were the unfavorable, sudden windshift conditions, the high density altitude, and the manufacturer's failure to provide adequate density altitude…Aug 31, 1999 · N5172L · DestroyedNTSB NYC99FA213Accident · 3 fatalField investigationFinal reportCessna 172N · Sussex, NJThe pilot's improper decision to takeoff with a tailwind. Factor's in this accident were the tailwind condition and pressure to depart caused by other airplanes performing successful downwind departures.Aug 29, 1999 · N737CJ · Substantial damageNTSB LAX99LA288Accident · Minor injuriesLimited investigationFinal reportWirth Avid Flyer · Schellville, CAThe pilot's encounter with wind shear and a downdraft which precipitated his loss of airplane control.Aug 29, 1999 · N625F · DestroyedNTSB FTW99LA241Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Alpine, TXThe pilot's improper use of the emergency fuel boost pump, which resulted in excessive fuel flow to the engine and subsequent total loss of left engine power. Factor's were the high density altitude, the pilot exceeding the airplane's weight and balance, the…Aug 28, 1999 · N67JM · DestroyedNTSB CHI99LA313Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawnee City, NEThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Aug 28, 1999 · N5535U · Substantial damageNTSB CHI99FA311Accident · 1 fatalField investigationFinal reportWalker Breezy · Janesville, WIthe inadvertent stall. A factor relating to this accident was the pilot's excessive climb rate.Aug 27, 1999 · N12BZ · DestroyedNTSB NYC99LA211Accident · Serious injuriesLimited investigationFinal reportAeromot AMT-300 · Block Island, RIThe pilot's failure to abort the takeoffAug 25, 1999 · N111TE · DestroyedNTSB MIA99LA237Accident · No injuriesLimited investigationFinal reportDinkel-Brook SEA REY · Orlando, FLthe pilot's failure to maintain control of the airplane resulting in an inadvertent stall at too low an altitude to recover.Aug 25, 1999 · N1168D · Substantial damageNTSB LAX99LA283Accident · No injuriesLimited investigationFinal reportBell UH-1B · Lost Hills, CAFailure and separation of the 90-degree gearbox as a result of the disengagement of the pinion and gear teeth. The cause(s) of the pinion and gear disengagement were undetermined.Aug 25, 1999 · N999SJ · Substantial damageNTSB CHI99LA309Accident · 1 fatalLimited investigationFinal reportPinick Horizon 2 · Grain Valley, MOThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in this type of airplane.Aug 25, 1999 · N787TP · DestroyedNTSB ANC99LA123Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Wasilla, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were variable winds, and a downdraft.Aug 23, 1999 · N5047Y · Substantial damageNTSB MIA99LA233Accident · No injuriesLimited investigationFinal reportCessna 172RG · Miami, FLThe delay by the pilot-in-command to extend the gear resulting in collapse of the main landing gear after touchdown. Factors in the accident were the inoperative gear warning system associated with the throttle due to the broken wire at the throttle…Aug 21, 1999 · N6231V · Substantial damageNTSB LAX99LA279Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Livermore, CAThe failure of the no. 3 cylinder exhaust valve due to the operator's failure to adhere to recommended overhaul periods set by the engine manufacturer. A factor in the accident was the operator's failure to comply with the manufacturer's mandatory service…Aug 21, 1999 · N88408 · Substantial damageNTSB FTW99LA230Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Weatherford, TXThe loss of engine power during the initial takeoff climb for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Aug 21, 1999 · N8981J · Substantial damageNTSB LAX99LA276Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Lakeport, CAThe failure of engine shop maintenance personnel to tighten the fuel line fitting during assembly of the engine, and failure of the installing maintenance personnel to detect and tighten the loose fitting during the engine installation and annual inspection.Aug 20, 1999 · N6022Q · Substantial damageNTSB CHI99LA307Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Garrett, INthe pilot's improper inflight planning/decision to land and takeoff on the airstrip which was unsuitable and closed, and the pilot's failure to attain clearance with the trees during the takeoff initial climb. Factors associated with the accident were the…Aug 20, 1999 · N161BA · Substantial damage