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 FTW02FA112Accident · 1 fatalField investigationFinal reportNorth American T-28B · Uvalde, TXThe pilot's failure to maintain control of the aircraft for undetermined reasons.Apr 4, 2002 · N13RW · DestroyedNTSB LAX02LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder City, NVa loss of engine power due to an undetermined malfunction of the carburetor.Apr 3, 2002 · N48908 · Substantial damageNTSB ATL02FA072Accident · 2 fatalField investigationFinal reportNorth American T-6-AT6D · Gainesville, GAA loss of engine power following a supercharger bearing failure and subsequent collision with the ground while maneuvering for an emergency landing.Apr 1, 2002 · N7471C · Substantial damageNTSB SEA02LA062Accident · Minor injuriesLimited investigationFinal reportStadden Flybaby · Buhl, IDThe pilot's failure to return the carburetor heat to the OFF (cold) position prior to applying full power following a touch and go landing, which resulted in poor climb performance and the subsequent impact with a fence and collision with the ground. A…Mar 31, 2002 · N1432 · Substantial damageNTSB ATL02LA071Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Naples, FLThe loss of engine power for undetermined reasons.Mar 31, 2002 · N122SE · Substantial damageNTSB LAX02FA120Accident · 2 fatalField investigationFinal reportPiper J3F-65 · Parker, AZThe failure of the student to attain and maintain an adequate airspeed following liftoff, which resulted in a stall/mush condition. Also causal was the certified flight instructor's inadequate supervision of the flight and failure to take timely remedial…Mar 30, 2002 · N40770 · DestroyedNTSB ATL02LA070Accident · No injuriesLimited investigationFinal reportCessna 210 · Naples, FLTotal loss of engine power due to improper maintenance by company maintenance personnel which allowed the mixture control linkage to disconnect in flight which resulted in an emergency descent to landing into unsuitable terrain.Mar 30, 2002 · N1844F · Substantial damageNTSB NYC02LA077Accident · No injuriesLimited investigationFinal reportPiper J4A · Cincinnati, OHThe maintenance technician's failure to properly adjust the carburetor float. Factors were the unsuitable terrain.Mar 28, 2002 · N27838 · Substantial damageNTSB FTW02LA105Accident · Minor injuriesLimited investigationFinal reportCessna 210-M · Buena Vista, COThe pilot's encounter with adverse weather. A factor was the unexpected downdraft after takeoff.Mar 28, 2002 · N29795 · Substantial damageNTSB LAX02LA117Accident · Serious injuriesLimited investigationFinal reportBeech A35 · Rio Linda, CAthe loss of engine power as a result of fuel starvation due to the pilot's inadequate fuel system management and failure to follow procedures and directives in the Pilot Operating Handbook listed by the manufacturer.Mar 27, 2002 · N8428A · Substantial damageNTSB FTW02LA098Accident · Serious injuriesLimited investigationFinal reportRepublic P-47N-20-RE · Albuquerque, NMthe pilot/mechanic's failure to properly re-install the engine's #10 cylinder exhaust interconnect tube, which resulted in an in-flight fire and forced landing. Contributing factors were the burned fuel and oil supply lines, which were not fire shielded.Mar 21, 2002 · N47TB · Substantial damageNTSB NYC02LA073Accident · Minor injuriesLimited investigationFinal reportAnnis Fisher FP-202 · Parksley, VAThe pilot's decision to continue the takeoff. A factor in the accident was the soft wet runway.Mar 16, 2002 · N4348V · Substantial damageNTSB FTW02LA096Accident · Minor injuriesLimited investigationFinal reportMooney M20A · Norman, OKMaintenance personnel's improper clamp installation on the mixture control cable, which resulted in a loss of engine power.Mar 16, 2002 · N8390E · Substantial damageNTSB ATL02LA064Accident · 1 fatalLimited investigationFinal reportKopp Robert E GYRO-KOPP-TER · Citra, FLThe pilots failure to maintain flight control, followed by a subsequent collision with the terrain.Mar 16, 2002 · N6158F · Substantial damageNTSB FTW02IA097Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Tulsa, OKThe failure of the horizontal stabilizer control system for undetermined reasons.Mar 14, 2002 · N960CA · No damageNTSB FTW02LA093Accident · No injuriesLimited investigationFinal reportTillman Long EZ · Lockhart, TXthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Mar 13, 2002 · N126DT · Substantial damageNTSB NYC02FA068Accident · 1 fatalField investigationFinal reportCessna T210N · Teterboro, NJImproper maintenance by other maintenance personnel, which resulted in the air filter element being sucked into and blocking the turbocharger inlet, and a subsequent power loss. Factors in the accident were the pilot's failure to maintain airspeed and the…Mar 9, 2002 · N2BS · DestroyedNTSB LAX02LA104Accident · No injuriesLimited investigationFinal reportCessna 172L · Bullhead City, AZThe pilot's failure to comply with maintenance/inspection requirements that resulted in a propeller failure.Mar 7, 2002 · N7774G · Substantial damageNTSB LAX02LA100Accident · Serious injuriesLimited investigationFinal reportAeronca C-3 · Sonoma, CAthe pilot's excessive remedial control inputs in response to a passenger's control inputs, which led to a failure to maintain an adequate airspeed and an inadvertent stall/mush. The pilot's inadequate preflight decision to allow a student pilot to occupy the…Mar 3, 2002 · N17438 · Substantial damageNTSB MIA02LA064Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marion, SCThe loss of engine power during takeoff/initial climb due to undetermined reasons, resulting in a landing on unsuitable terrain.Feb 28, 2002 · N1915V · Substantial damageNTSB LAX02LA090Accident · Minor injuriesLimited investigationFinal reportYoung Mini-500 · Paso Robles, CAthe pilot's inadequate visual lookout and his failure to maintain obstacle clearance.Feb 22, 2002 · N500JY · Substantial damageNTSB FTW02LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Mount Selman, TXthe loss of engine power for an undetermined reason, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.Feb 20, 2002 · N238NY · Substantial damageNTSB DEN02LA027Accident · No injuriesLimited investigationFinal reportKnight BD-4 · Kemmerer, WYThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a snowbank. A contributing factor was the high crosswind.Feb 20, 2002 · N84RL · Substantial damageNTSB IAD02LA032Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Harwinton, CTpilot's failure to obtain adequate airspeed during take-off, which resulted in an aerodynamic stall.Feb 16, 2002 · N81072 · Substantial damageNTSB MIA02LA060Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-V · West Palm Beach, FLThe flight crew's failure to follow preflight inspection/checklist procedures, which resulted in their failure to detect wooden sticks in the landing gear weight-on-wheel switches and their failure in flight to respond to crew alert messages to disarm the…Feb 14, 2002 · N777TY · Substantial damageNTSB MIA02FA059Accident · 4 fatalField investigationFinal reportCessna TR182 · Cedar Key, FLthe failure of the pilot to maintain control of the airplane due to spatial disorientation resulting in the airplane descending and colliding with water. A factor in the accident was a dark night .Feb 11, 2002 · N5136S · DestroyedNTSB LAX02LA078Accident · No injuriesLimited investigationFinal reportRobinette Ultra Pup · Rio Vista, CAThe loss of engine power for undetermined reasons.Feb 2, 2002 · N2221X · Substantial damageNTSB CHI02LA070Accident · 2 fatalLimited investigationFinal reportBellanca 17-30A · Alexandria, MNThe pilot's disregard of the weather evaluation and his attempt to fly into known adverse weather without an instrument rating. Factors in the accident were the low ceiling, the low visibility, and the icing conditions.Jan 27, 2002 · N4002B · DestroyedNTSB SEA02LA031Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Glasgow, MTThe pilot's failure to maintain adequate flying airspeed resulting in a stall/mush condition and loss of control at low altitude. A contributing factor was the pilot's distraction from flying the aircraft while attempting to retract the landing gear.Jan 19, 2002 · N38AJ · Substantial damageNTSB IAD02LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, MAThe pilot's delayed aborted landing and his failure to attain obstacle clearance. The pilot's misjudgment of distance is a contributing factor.Jan 14, 2002 · N3997R · Substantial damageNTSB DEN02LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Pagosa Springs, COthe total power failure of the right engine due to the failure of its lubricating system. Contributing factors were the lack of suitable terrain for a forced landing, and the terrain being above the airplane's single engine performance capability.Jan 14, 2002 · N6935Y · Substantial damageNTSB ATL02LA037Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee 108-M · Bayou La Batre, ALThe loss of engine power for undetermined reasons.Jan 13, 2002 · N9315K · Substantial damageNTSB SEA02FA023Accident · No injuriesField investigationFinal reportBeech 58P · Boise, IDImproper clearance between an alternator wire and a pneumatic line and fuel fumes. The alternator wire chafe and arcing were factors.Jan 2, 2002 · N132Z · Substantial damageNTSB ANC02LA008Accident · No injuriesLimited investigationFinal reportBoeing 747-128 · Anchorage, AKThe flight crew's inadequate preflight planning, and failure to calculate the airplane weight and balance prior to departure.Dec 28, 2001 · N3203Y · Substantial damageNTSB MIA02LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172M · New Smyrna Bch, FLthe failure of the pilot to maintain airspeed, during initial climb out, which resulted in an inadvertent stall, and subsequent impact with the terrain.Dec 19, 2001 · N9882V · Substantial damageNTSB FTW02LA057Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-24E · El Paso, TXthe pilot's failure to maintain minimum airspeed for flight, resulting in an inadvertent stall while maneuvering. A contributing factor was the failure of the tow rope.Dec 16, 2001 · N134EK · DestroyedNTSB ANC02IA007Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71F · Anchorage, AKThe asymmetrical activation of the left wing spoiler due to a broken retraction cable during takeoff. A factor associated with the incident was the operator's inadequate inspection of the cable.Dec 14, 2001 · N825BX · No damageNTSB CHI02LA053Accident · No injuriesLimited investigationFinal reportCessna 172L · Reedsburg, WIThe pilot inadvertently released the seat adjustment mechanism which resulted in the seat sliding back during takeoff, and his subsequent failure to maintain control of the airplane. A factor associated with the accident was the runway light control box,…Dec 9, 2001 · N4303Q · Substantial damageNTSB LAX02FA041Accident · 2 fatalField investigationFinal reportCessna 182E · Prescott, AZthe pilot's failure to adequately deice the airplane prior to takeoff, which resulted in the airplane's degraded aerodynamic and climb performance capability, failure to maintain an adequate airspeed, and a stall/spin. Contributing factors were the pilot's…Dec 5, 2001 · N3049Y · DestroyedNTSB CHI02LA046Accident · No injuriesLimited investigationFinal reportMiller Lancair 235 · Tecumseh, MIThe pilot's failure to maintain aircraft control during the takeoff. Factors relating to the accident were the crosswind and the wind gusts.Dec 5, 2001 · N417EM · Substantial damageNTSB DEN02LA013Accident · Serious injuriesLimited investigationFinal reportBell 206B · Bryce, UTloss of engine power for reasons undetermined. Contributing factors were the low airspeed and altitude at which to perform an autorotation.Dec 1, 2001 · N911KH · Substantial damageNTSB MIA02LA036Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1C · Pompano Beach, FLThe failure of the pilot-in-command to maintain airspeed (Vs), while maneuvering for an emergency landing, resulting in an inadvertent stall and subsequent in-flight collision with terrain. A contributing factor in the accident was the loss of engine power…Nov 29, 2001 · N9515U · Substantial damageNTSB FTW02LA043Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20D · Alamogordo, NMThe pilot's failure to maintain altitude and clearance with small trees during a precautionary landing.Nov 23, 2001 · N2078D · Substantial damageNTSB IAD02FA018Accident · 2 fatalField investigationFinal reportGates Learjet 25B · Pittsburgh, PAThe (undetermined) pilot-at-the-controls' early, and over rotation of the airplane's nose during the takeoff attempt, and his failure to maintain directional control. Also causal, was the captain's inadequate remedial action, both during the takeoff attempt…Nov 22, 2001 · N5UJ · DestroyedNTSB FTW02LA041Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Marion, TXthe pilot's inadvertent stall during takeoff, which resulted in a loss of control and the airplane colliding with a fence and a tree. A contributing factor was his lack of experience in the make and model of aircraft.Nov 22, 2001 · N3209K · Substantial damageNTSB MIA02LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Deland, FLThe loss of engine power during takeoff/initial climb due to undetermined reasons.Nov 19, 2001 · N85TT · Substantial damageNTSB FTW02FA037Accident · 1 fatalField investigationFinal reportGrumman American AA-1B · Patterson, LAThe pilot's mismanagement of fuel with the positioning of the fuel selector in the off position and his failure to maintain airspeed resulting in fuel starvation, and the airplane entering into a stall.Nov 19, 2001 · N6530L · Substantial damageNTSB MIA02LA022Accident · 1 fatalLimited investigationFinal reportRobert N. Gilmore Rans S-10 · Oneonta, ALThe failure of the pilot to maintain airspeed following loss of engine power resulting in the airplane stalling and entering a spin from which it crashed. Factors in the accident was improper repair of the front cylinder intake manifold seal by the pilot…Nov 18, 2001 · N96AU · DestroyedNTSB DEN02LA012Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Montrose, COthe loss of engine power during initial climb for undetermined reason. A factor was the lack of suitable terrain for a forced landing.Nov 16, 2001 · N210GB · DestroyedNTSB SEA02LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Brewster, WAThe magneto was inadvertently switched off by the pilot during the climb. A tree was a factor.Nov 13, 2001 · N5762A · Substantial damage