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 CHI02CA267Accident · No injuriesData collectionFinal reportTomash Avid Flyer · Camp Lake, WIThe total failure of the engine ignition system, and the unsuitable terrain encountered during the forced landing. The low altitude was a contributing factor.Aug 31, 2002 · N369AF · Substantial damageNTSB NYC02LA180Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Louisa, VAA loss of engine power for an undetermined reason.Aug 29, 2002 · N60425 · Substantial damageNTSB LAX02FA259Accident · No injuriesField investigationFinal reportCessna 172N · Mesa, AZAn electrical fire of unknown origin centered near the circuit breaker/throttle area of the instrument panel.Aug 23, 2002 · N4796E · DestroyedNTSB LAX02LA256Accident · Minor injuriesLimited investigationFinal reportDodd RV-4 · Tehachapi, CAthe owner/builder's improperly fabricated and installed fuel line, which cracked at the point of the flare, resulting in a fuel leak and loss of engine power during the takeoff climb. A contributing factor was the soft terrain that jammed the landing gear…Aug 21, 2002 · N62VR · Substantial damageNTSB SEA02LA161Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Rigby, IDThe failure of one or more compressor turbine blades resulting in a shutdown of the engine during initial climb resulting in a forced landing. Contributing factors were the eroded condition of the compressor turbine guide vane nozzles and the ditch which the…Aug 20, 2002 · N6146G · Substantial damageNTSB FTW02LA239Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Simmesport, LAthe contamination of the fuel system with water and a foreign material.Aug 20, 2002 · N991QC · Substantial damageNTSB NYC02FA166Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Deerfield, VAThe pilot's improper preflight decision to takeoff on an up-sloping runway with a tailwind, which resulted in an inadvertent stall and collision with a tree. Factors were the pilot's lack of familiarity with the geographic area, and a tailwind.Aug 18, 2002 · N5295L · DestroyedNTSB IAD02LA087Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman E75L300 · Fostoria, OHA missing flight control sealed bearing, which resulted in a loss of control in flight.Aug 17, 2002 · N65BH · Substantial damageNTSB IAD02FA086Accident · 2 fatalField investigationFinal reportCessna 172S · Plainville, CTAn in-flight engine compartment fire of unknown origin, and a loss of engine power for undetermined reasons. Also causal, was the pilot's failure to maintain airspeed during a turn back to the airfield, which resulted in an inadvertent stall and subsequent…Aug 17, 2002 · N35073 · DestroyedNTSB MIA02FA152Accident · 1 fatalField investigationFinal reportCessna 150J · Brunswick, GAthe pilot's failure to maintain an adequate airspeed during takeoff, which resulted in an inadvertent stall. A contributing factor was the pilot's decision to takeoff in an over gross weight condition.Aug 15, 2002 · N5603G · DestroyedNTSB SEA02LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Darrington, WALoss of engine power during takeoff due to an undersized gascolator gasket resulting in a loss of fuel flow to the engine. A ditch was a factor.Aug 14, 2002 · N4334E · Substantial damageNTSB ANC02LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Red Devil, AKA partial loss of engine power for an undetermined reason during the initial climb after takeoff that resulted in a collision with trees. A contributing factor in the accident was rising terrain which was unsuitable for a forced landing.Aug 14, 2002 · N3853W · Substantial damageNTSB NYC02FA160Accident · Serious injuriesField investigationFinal reportBoeing 747-256 · Jamaica, NYAn accessory gearbox fire of the number 2 engine, due to hot air bypassing a damaged compressor air seal stack, which resulted in an emergency evacuation.Aug 11, 2002 · EC-DNP · Minor damageNTSB MIA02FA148Accident · 3 fatalField investigationFinal reportBeech C23 · Centerville, TNthe pilot's failure to maintain airspeed which resulted in an inadvertent stall shortly after takeoff. A contributing factor was the pilot's decision to takeoff in an over gross weight condition and his lack of familiarity with the aircraft.Aug 11, 2002 · N24041 · DestroyedNTSB IAD02LA084Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · West Milford, NJThe private pilot's excessive rotation and the flight instructor's delayed remedial action.Aug 11, 2002 · N6257R · Substantial damageNTSB NYC02FA159Accident · 1 fatalField investigationFinal reportSchempp-Hirth Standard Cirrus · Hilltown, PAThe pilot's improper pre-flight, and failure to follow procedures in the flight manual to determine that the stabilator was properly connected prior to flight, and which resulted in a loss of control while under tow, and uncontrolled impact with the ground.Aug 10, 2002 · N47SS · DestroyedNTSB LAX02LA250Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Casa Grande, AZThe partial loss of engine power for undetermined reasons.Aug 10, 2002 · N17678 · Substantial damageNTSB CHI02TA239Accident · Serious injuriesFinal reportHughes 369A · Springfield, MOOverload failure of the tail rotor transmission housing (gearbox) for undetermined reasons, which resulted in an inability to adequately control the aircraft.Aug 7, 2002 · N98MP · Substantial damageNTSB ANC02LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKA jammed flight control system yoke/stick, which made directional control of the airplane not possible, and resulted in an in-flight collision with terrain.Aug 5, 2002 · N4151Z · Substantial damageNTSB FTW02LA224Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Marietta, OKThe pilot's failure to maintain adequate airspeed which resulted in a stall.Aug 4, 2002 · N431ME · Substantial damageNTSB CHI02FA228Accident · 1 fatalField investigationFinal reportAeronca 7AC · Caro, MIThe passenger became incapacitated as a result of a stroke which lead to the inadvertent interference with the flight controls.Aug 3, 2002 · N84546 · Substantial damageNTSB ATL02FA150Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Spartanburg, SCThe pilot's failure to maintain airspeed during the takeoff initial climb which resulted in an inadvertent stall and subsequent collision with an embankment.Aug 3, 2002 · N7362J · DestroyedNTSB NYC02FA152Accident · 4 fatalField investigationFinal reportGrumman American AA-5B · Marietta, PAThe pilot's improper decision to operate an airplane with known mechanical deficiencies, his improper decision to return to the airport with inadequate altitude remaining, and his failure to maintain airspeed. A factor related to the accident was the…Aug 2, 2002 · N81310 · DestroyedNTSB DEN02LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Collins, COthe student pilot's failure to maintain aircraft control and subsequent inadvertent stall/mush into terrain during a soft field take off. Contributing factors include the pilot's lack of experience and the high density altitude conditions.Jul 31, 2002 · N5088K · Substantial damageNTSB DEN02FA084Accident · 1 fatalField investigationFinal reportCessna 172K · Greeley, COthe student pilot's improper handling of the airplane's controls (for reason undetermined), and the inadequate supervision of the flight instructor. A contributing factor was the high density altitude weather condition.Jul 31, 2002 · N7383G · DestroyedNTSB CHI02LA219Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Abilene, KSThe pilot failed to achieve clearance over the trees and wires. Factors associated with the accident were the pilot failed to use all available runway, a downwind takeoff was performed, the tailwind, trees, and wires.Jul 29, 2002 · N90TC · Substantial damageNTSB NYC02LA148Accident · Minor injuriesLimited investigationFinal reportBird CK · Harrisonburg, VAThe pilot's improper decision to perform a 180-degree turn with insufficient altitude remaining after experiencing a total loss of power. A factor related to the accident was the inadequate alignment of the fuel selector placard markings, resulting in an…Jul 28, 2002 · N99754 · Substantial damageNTSB MIA02LA150Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Leesburg, FLLoss of engine power for undetermined reasons during takeoff, resulting in the airplane colliding with the ground and nosing over during the subsequent forced landing.Jul 28, 2002 · N1242V · DestroyedNTSB IAD02IA076Incident · No injuriesIncident investigationFinal reportFairchild Dornier DO-328-300 · New York, NYThe partial loss of flight display information for undetermined reasons.Jul 28, 2002 · N409FJ · No damageNTSB CHI02LA220Accident · No injuriesLimited investigationFinal reportCessna R172K · Flushing, MIA loss of engine power for undetermined reasons. Contributing to the accident was the wet runway.Jul 28, 2002 · N1086V · Substantial damageNTSB ANC02LA084Accident · No injuriesLimited investigationFinal reportCessna 206 · Old Harbor, AKThe pilot's failure to maintain altitude/clearance from terrain during initial climb, which resulted in an in-flight collision with water. A factor associated with the accident was the pilot's diverted attention.Jul 26, 2002 · N756BW · Substantial damageNTSB NYC02LA140Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Bardstown, KYThe pilot's inadequate preflight inspection, which resulted in fuel contamination and subsequent loss of engine power. A factor in this accident was that the wing tank fuel drains were wire closed and could not be used.Jul 17, 2002 · N64567 · Substantial damageNTSB DEN02FA076Accident · 2 fatalField investigationFinal reportWheeler Doug 2000 · Ogden, UTthe pilot's failure to obtain and maintain adequate main rotor rpm, resulting in blade flapping and subsequent blade contact with the airframe, severing of the tailboom, and causing loss of aircraft control. Contributing factors were the high gusty winds, and…Jul 17, 2002 · N2058T · DestroyedNTSB NYC02FA138Accident · Serious injuriesField investigationFinal reportYakovlev YAK 52 · Matawan, NJThe pilot's excessive maneuvering and failure to maintain aircraft control, following a partial power loss during the initial climb, which resulted in an inadvertent stall/spin. A factor in the accident was an inadequate annual condition inspection performed…Jul 13, 2002 · N69GC · Substantial damageNTSB LAX02LA223Accident · 1 fatalLimited investigationFinal reportSteen SE-1 · Tucson, AZthe loss of engine power during takeoff for undetermined reasons.Jul 13, 2002 · N2018S · DestroyedNTSB IAD02LA072Accident · No injuriesLimited investigationFinal reportDesimone Zodiac CH-601-H · Wadsworth, OHThe pilot's overrotation after take off, which resulted in an inadvertent stall/mush. A factor was the pilot's decision to take off with a tailwind.Jul 13, 2002 · N422EZ · Substantial damageNTSB CHI02CA198Accident · No injuriesData collectionFinal reportBaughman KR-2 · Scribner, NEThe pilot's excessive rotation and his failure to attain climb which resulted in a stall/mush.Jul 13, 2002 · N290KB · Substantial damageNTSB ANC02LA079Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Toksook Bay, AKA bird strike during takeoff, which resulted in damage to the right wing.Jul 13, 2002 · N885EA · Substantial damageNTSB ANC02LA074Accident · No injuriesLimited investigationFinal reportCessna U206F · Koliganek, AKThe pilot's premature lift-off which precipitated an in-flight loss of control, and subsequent collision with terrain.Jul 12, 2002 · N696TK · Substantial damageNTSB CHI02LA190Accident · No injuriesLimited investigationFinal reportCessna 150F · Ft. Wayne, INThe corroded throttle cable resulting in a loss of engine power. Factors were the inadequate annual inspection, the unsuitable terrain encountered during the forced landing, the ditch, and the fence.Jul 10, 2002 · N8798S · Substantial damageNTSB FTW02LA201Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Waco, TXThe partial loss of engine power due to undetermined reasons. A contributing factor was the pilot's inadequate landing flare which resulted in a hard landing.Jul 7, 2002 · N61439 · Substantial damageNTSB LAX02LA216Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Sacramento, CAPropeller blade failure due to fatigue. A contributing factor was the rising embankment.Jul 6, 2002 · N3631B · Substantial damageNTSB CHI02LA181Accident · No injuriesLimited investigationFinal reportBell 206B · Three Rivers, MIA loss of tail rotor effectiveness.Jul 6, 2002 · N60EA · Substantial damageNTSB LAX02FA214Accident · 4 fatalField investigationFinal reportCessna 310I · San Dimas, CAthe pilot's failure to maintain control of the airplane following a loss of power in one engine during takeoff. The reason for the loss of power in the left engine could not be determined. Contributing factors to the accident were the pilot's failure to…Jul 4, 2002 · N8145M · DestroyedNTSB MIA02LA127Accident · 2 fatalLimited investigationFinal reportThomas Outback · Edenton, NCThe pilot/owner's failure to establish an adequate climb rate and his failure to maintain obstacle clearance.Jul 3, 2002 · N74PT · DestroyedNTSB ATL02FA137Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Lebanon, TNThe certified flight instructor attempted flight with known deficiencies in equipment, inoperative magneto, and subsequent lost engine power and collided with a transmission line while maneuvering for a forced landing.Jul 2, 2002 · N8143B · Substantial damageNTSB IAD02LA064Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Mifflintown, PAOn-ground carburetor icing.Jun 30, 2002 · N6678M · Substantial damageNTSB CHI02LA180Accident · Serious injuriesLimited investigationFinal reportAune Glastar GS-1 · South St Paul, MNThe pilot's failure to utilize carburetor heat. Factors included ambient conditions for the formation of carburetor ice, and the unsuitable terrain for the forced landing.Jun 29, 2002 · N699S · Substantial damageNTSB NYC02LA125Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · York, PAThe pilot's failure to maintain proper airspeed, which resulted in a stall/mush into a corn field. A factor was the high density altitude.Jun 26, 2002 · N5684L · Substantial damageNTSB CHI02LA176Accident · 1 fatalLimited investigationFinal reportBar/Curtiss JN-4D · Owatonna, MNThe pilot's failure to maintain adequate airspeed during the takeoff climb resulting in an inadvertent stall. A factor associated with the accident was the low altitude at which the stall occurred.Jun 26, 2002 · N38057 · Substantial damage