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 CEN14FA377Accident · 1 fatalField investigationFinal reportOden Weldon Pat Kitfox IV Speedster · Blackwell, TXThe pilot's loss of airplane control following a loss of engine power for reasons that could not be determined based on the available evidence.Jul 20, 2014 · N622P · Substantial damageNTSB CEN14LA385Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Wichita Falls, TXA partial loss of engine power, which resulted in a forced landing on unsuitable terrain. The reason for the loss of engine power could not be determined during postaccident examination.Jul 19, 2014 · N636EV · Substantial damageNTSB WPR14LA298Accident · No injuriesLimited investigationFinal reportPiper PA 30 · Othello, WAThe partial loss of engine power for reasons that could not be determined based on the available information.Jul 17, 2014 · N7981Y · Substantial damageNTSB ERA14FA337Accident · 1 fatalField investigationFinal reportCulver LFA · Limington, METhe pilot’s failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Jul 12, 2014 · N41716 · Substantial damageNTSB ENG14IA019Incident · No injuriesIncident investigationFinal reportBoeing 767 332 · Los Angeles, CAThe combination of fuel leaking from the integrated drive generator (IDG) fuel/oil heat exchanger and the coincident arcing of the IDG power feeder cables that ignited the leaking fuel. Contributing to the ignition of the fuel was the misrouting of the IDG…Jul 11, 2014 · N139DL · Minor damageNTSB ERA14CA349Accident · No injuriesData collectionFinal reportPekola James W Ridge Runner III · Andrews, NCThe pilot's failure to open the fuel tank valves during the preflight examination of the airplane, which resulted in a total loss of engine power due to fuel starvation.Jul 10, 2014 · N39ZT · Substantial damageNTSB WPR14FA286Accident · 1 fatalField investigationFinal reportCessna 182 · Fall City, WAThe pilot’s decision to depart in low-ceiling conditions and his continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Jul 8, 2014 · N5816B · Substantial damageNTSB CEN14LA357Accident · No injuriesLimited investigationFinal reportCessna TR182 · Wichita, KSMaintenance personnel’s improper landing gear system repair, which resulted in a hydraulic leak and subsequent gear collapse during landing.Jul 7, 2014 · N4602S · Substantial damageNTSB ERA14LA338Accident · Serious injuriesLimited investigationFinal reportLawson Ronald S Explorer · East Bend, NCA total loss of engine power likely due to a failure of a rotary valve shaft seal and the pilot’s failure to detect and diagnose the impending failure during the preflight inspection.Jul 5, 2014 · N6663K · Substantial damageNTSB ERA14LA329Accident · 1 fatalLimited investigationFinal reportFlight Design CT-SW 2006 · Gasport, NYThe pilot's failure to maintain adequate airspeed following a left turn during takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jul 5, 2014 · N508CT · Substantial damageNTSB CEN14RA340Accident · 11 fatalForeign investigationPiper PA 31P · Czestochowska, PolandJul 5, 2014 · N11WB · DestroyedNTSB WPR14WA318Accident · 1 fatalForeign investigationCessna T210N · Inverell, Australia, AustraliaOn July 4, 2014, at 1325 local time, a Cessna T210N, VH-ZFW, collided with terrain shortly after takeoff from Inverell, Australia. The airplane was operated by the pilot under the pertinent civil regulations of the government of Australia. The airplane was…Jul 4, 2014 · VH-ZFW · DestroyedNTSB CEN14FA339Accident · 2 fatalField investigationFinal reportNorth American/Aero Classics P 51D · Durango, COThe pilot's failure to compensate for the high-performance airplane's tendency to enter a torque roll during the initial climb, which resulted in the airplane entering a torque roll and the subsequent loss of control at too low of an altitude to recover.…Jul 4, 2014 · N1451D · Substantial damageNTSB DCA14WA138Accident · 4 fatalForeign investigationFokker F27 - 50 · Nairobi, KenyaJul 2, 2014 · 5Y-CET · DestroyedNTSB CEN14FA337Accident · Serious injuriesField investigationFinal reportPiper PA30 · Harrison, ARThe pilot's loss of control of the airplane during initial climb because he failed to correctly compensate for the loss of power in the left engine. Contributing to the accident was water contamination in the fuel and the lack of an adequate preflight…Jul 2, 2014 · N7762Y · Substantial damageNTSB CEN14LA333Accident · No injuriesLimited investigationFinal reportCessna 172R · Joplin, MOThe partial loss of engine power for reasons that could not be determined because an operational test run of the engine did not reveal any anomalies that would have precluded normal operation.Jul 1, 2014 · N468CM · Substantial damageNTSB ERA14LA316Accident · Serious injuriesLimited investigationFinal reportCzech Sport Piper Sport · Peachtree City, GAThe pilot's incomplete assessment of the risk presented by operating an airplane with an unresolved history of engine power losses; a partial loss of engine power during takeoff due to operation of the engine with an excessively rich fuel/air mixture; and the…Jun 29, 2014 · N957MD · Substantial damageNTSB CEN14LA305Accident · 1 fatalLimited investigationFinal reportBollinger Robert L BD 4 · Fairfield, IAThe pilot’s loss of airplane control due to the in-flight separation of the propeller blades for reasons that could not be determined based on the available evidence.Jun 22, 2014 · N108BC · DestroyedNTSB WPR14LA257Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Agua Dulce, CAThe pilot's decision to continue the takeoff from the upsloping runway with full-flap deflection in high density altitude conditions, which led to a decreased climb rate and impact with terrain.Jun 20, 2014 · N4606L · Substantial damageNTSB WPR14CA254Accident · No injuriesData collectionFinal reportMaule MX 7-235 · Port Orchard, WAThe pilot's delayed remedial action and failure to maintain directional control.Jun 20, 2014 · N5665A · Substantial damageNTSB ERA14LA309Accident · Minor injuriesLimited investigationFinal reportSimmons William E Aventura 2 · Rockledge, FLThe pilot’s failure to maintain airspeed during a forced landing following a loss of engine power, which resulted in a hard landing. Contributing to the accident was the pilot’s inadequate inspection of the engine, which resulted in a loose ground wire lug on…Jun 20, 2014 · N700WS · Substantial damageNTSB ERA14LA308Accident · No injuriesLimited investigationFinal reportTaylor J-2 · Lock Haven, PAThe airplane owner’s failure to clean and lubricate the engine valve guides and stems, which resulted in a partial loss of engine power during the initial climb due to an exhaust valve failure.Jun 20, 2014 · N16667 · Substantial damageNTSB ERA14LA321Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Farmington, DEThe pilot's inadequate preflight planning for a takeoff in high-density altitude conditions and his decision to reduce power during the initial climb, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jun 18, 2014 · N891JC · Substantial damageNTSB ERA14LA294Accident · No injuriesLimited investigationFinal reportCub Crafters CC18-180 · Pennsboro, WVA loss of engine power during initial climb for reasons that could not be determined because the postaccident engine examination did not reveal any anomalies that would have precluded normal operation.Jun 17, 2014 · N696RP · Substantial damageNTSB ERA14LA302Accident · Minor injuriesLimited investigationFinal reportBailey Robert Moyes Dragonfly · Melfa, VAThe pilot’s failure to maintain roll control during the initial takeoff and his decision to take off with only partial power applied.Jun 16, 2014 · N286A · Substantial damageNTSB WPR14LA249Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Quincy, CAThe partial loss of engine power during takeoff due to the separation of the exhaust baffling, which resulted in a partial blockage of airflow to the engine. Contributing to the accident was maintenance personnel’s inadequate inspection of the exhaust system…Jun 15, 2014 · N4931L · Substantial damageNTSB ERA14FA289Accident · 1 fatalField investigationFinal reportMeyer Clair O 2/3 P 51B/C Mustang · Marion, SCThe airplane's impact with terrain shortly after takeoff due to a physiological incapacitation of the pilot.Jun 13, 2014 · N51BM · Substantial damageNTSB ERA14FA288Accident · 1 fatalField investigationFinal reportPiper PA-46-500TP · White Plains, NYThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion). Contributing to the accident was the pilot's self-induced pressure to depart and his decision to depart in low-ceiling and…Jun 13, 2014 · N5335R · DestroyedNTSB WPR14LA242Accident · No injuriesLimited investigationFinal reportAdams Dragonfly · Mesa, AZA partial loss of engine power due to a reduction in the No. 3 cylinder’s compression as a result of the exhaust valve not having consistent uniform contact with the cylinder head valve seat.Jun 12, 2014 · N85TL · Substantial damageNTSB ERA14FA283Accident · 2 fatalField investigationFinal reportCessna 172S · Daytona Beach, FLA partial loss of engine power during the initial climb after takeoff for reasons that could not be determined due to the postaccident condition of the wreckage. Contributing to the accident was the pilots' decision to turn back to the airport, which led to…Jun 10, 2014 · N5524L · DestroyedNTSB ERA14LA281Accident · Serious injuriesLimited investigationFinal reportBelew Marshall D II Steen Skybolt · Chapmansboro, TNThe pilot's failure to maintain airspeed while performing an emergency landing, which led to the airplane exceeding its critical angle-of-attack and experiencing a subsequent aerodynamic stall. Contributing to the accident was a partial loss of engine power…Jun 8, 2014 · N863SB · DestroyedNTSB WPR14LA233Accident · 1 fatalLimited investigationFinal reportNorth Wing Apache Sport · Polson, MTThe pilot’s loss of airplane control during initial climb due to his experiencing an incapacitating medical event.Jun 7, 2014 · N2804P · DestroyedNTSB WPR14FA234Accident · 2 fatalField investigationFinal reportPiper J3C · Paso Robles, CAThe pilot's steep right turn shortly after takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jun 7, 2014 · N24918 · Substantial damageNTSB ERA14LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Newport, VTThe pilot's failure to maintain adequate airspeed during an aborted landing, which resulted in an aerodynamic stall and collision with the ground. Contributing to the accident was the pilot's alcohol impairment.Jun 7, 2014 · N5169T · Substantial damageNTSB WPR14LA232Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Ronan, MTA loss of engine power for reasons that could not be determined due to insufficient evidence.Jun 6, 2014 · N3376B · Substantial damageNTSB CEN14LA279Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Sauk Centre, MNThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s failure to retract the flaps after beginning the go-around.Jun 6, 2014 · N30537 · Substantial damageNTSB WPR14LA220Accident · Serious injuriesLimited investigationFinal reportAero Commander Callair A 9B · Gardiner, MTThe pilot’s inadequate preflight planning and his subsequent takeoff with the airplane over its allowable gross weight in high density altitude conditions, which degraded the airplane’s climb performance and led to a subsequent forced landing.Jun 2, 2014 · N7292V · Substantial damageNTSB CEN14LA267Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA20-C1 · Longmont, COA loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.Jun 1, 2014 · N206ND · Substantial damageNTSB ERA14FA255Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Fountain, FLThe pilot's decision to depart from a soft runway with a tailwind and toward obstructions, and his failure to follow the manufacturer's recommended procedures for the takeoff. Contributing to the accident were the degradation of airplane and engine…May 25, 2014 · N43113 · Substantial damageNTSB CEN14LA259Accident · Serious injuriesLimited investigationFinal reportSibley Glasair · Midlothian, TXThe pilot’s failure to maintain lateral control during the initial climb. Contributing to the accident was the pilot’s failure to obtain sufficient training and experience to operate the high-performance airplane.May 24, 2014 · N4VX · DestroyedNTSB WPR14CA197Accident · Minor injuriesData collectionFinal reportCessna 140 · Vacaville, CAThe pilot's use of excessive brakes during landing, which resulted in a nose over. Contributing to the accident was a partial loss of engine power during takeoff initial climb, likely due to carburetor ice.May 21, 2014 · N2256N · Substantial damageNTSB ERA14LA248Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron Canada 206 L4 · Beverly, MAMaintenance personnel’s inadequate inspection of the engine’s outer combustion case, which resulted in the failure of the case due to fatigue cracks that initiated on the inside surface of the case and the subsequent total loss of engine power.May 21, 2014 · N55SL · Substantial damageNTSB WPR14FA194Accident · 1 fatalField investigationFinal reportAero Commander 500 S · Fort Huachuca, AZThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack after a total loss of engine power during the takeoff initial climb, which resulted in an aerodynamic stall and impact with terrain. The reason for…May 17, 2014 · N40TC · Substantial damageNTSB ERA14LA222Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Bardwell, KYThe failure of the pilot to maintain airspeed while maneuvering shortly after takeoff, resulting in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, uncontrolled descent, and impact with the ground.May 4, 2014 · N9588S · Substantial damageNTSB ANC14CA027Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Wasilla, AKThe pilot's inadequate weather evaluation, which resulted in a turbulence encounter at low altitude and collision with trees. Contributing to the accident was the pilot's lack of knowledge of local wind conditions.May 4, 2014 · N64518 · Substantial damageNTSB WPR14FA181Accident · 1 fatalField investigationFinal reportAero Tek Zuni · Aguila, AZThe pilot's inability to maintain control of the glider after the tow cable separated prematurely due to an incomplete engagement of the cable in the control tow release system due to a missing spring.May 3, 2014 · N22DA · Substantial damageNTSB ENG14RA014Incident · No injuriesForeign investigationBAE AVRO146RJ - 100 · Perth, Australia, AustraliaOn April 29, 2014, a British Aerospace BAE AVRO 146-RJ100, registration VH-NJI, experienced a No. 2 engine (left inboard) fire from the Honeywell LF507-1F turbofan engine during climb from Perth, Australia. The airplane was returned to Perth where an…Apr 29, 2014 · VH-NJI · Minor damageNTSB ERA14LA208Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Apex, NCA total loss of engine power during initial climb for reasons that could not be determined during postaccident examination and testing.Apr 27, 2014 · N6364V · Substantial damageNTSB CEN14LA205Accident · 1 fatalLimited investigationFinal reportQuicksilver GT400 · Hillsboro, KSThe pilot’s failure to maintain control of the unregistered airplane in gusting wind conditions.Apr 18, 2014 · UNREG · Substantial damageNTSB ERA14FA464Accident · 1 fatalField investigationFinal reportFortuna Dave Sonex · Dunnellon, FLThe in-flight collision with a tree in a heavily wooded area during controlled flight while the pilot was attempting a forced landing for reasons that could not be determined based on the available evidence. Contributing to the delay in locating the wreckage…Apr 5, 2014 · N229P · Substantial damage