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 CHI94LA210Accident · No injuriesLimited investigationFinal reportTaylorcraft BL-65 · Peshtigo, WIthe pilot's failure to maintain airspeed during the takeoff which resulted in an inadvertent stall. A factor related to the accident was the tall grass on the airstrip.Jun 25, 1994 · N26690 · Substantial damageNTSB BFO94LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Seven Springs, PAThe pilot's failure to attain adequate airspeed and his premature liftoff which resulted in a stall mush and collision with trees.Jun 23, 1994 · N40051 · Substantial damageNTSB FTW94LA210Accident · No injuriesLimited investigationFinal reportHiller UH-12L4 · West Helena, ARA total loss of power due to a leak in the main fuel line which occurred as a result of an electrical short which burned a hole in the fuel line. Factors were a failure by the pilot to perform recommended maintenance and the lack of suitable terrain for a…Jun 22, 1994 · N90453 · DestroyedNTSB CHI94DTK02Accident · No injuriesFinal reportAyres S2R · Letcher, SDthe loss of engine power due to the failure of the engine driven fuel pump and shaft.Jun 22, 1994 · N3102E · DestroyedNTSB LAX94LA260Accident · No injuriesLimited investigationFinal reportMooney M20J · Big Bear, CAa loss of engine power from a malfunctioning magneto due to a loose oil seal in an overhauled magneto.Jun 20, 1994 · N201NK · Substantial damageNTSB FTW94LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brinkley, ARA supercharger impeller bearing failure. A factor was the lack of suitable terrain for the forced landing.Jun 20, 1994 · N112JM · Substantial damageNTSB CHI94LA203Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Terre Haute, INthe pilot-in-command's inadvertant stall of the airplane. A factor associated with the accident was the elevator trim position.Jun 19, 1994 · N81TW · DestroyedNTSB ATL94LA123Accident · 1 fatalLimited investigationFinal reportMarvin E. Eubanks VP-1 · New Bern, NCThe loss of engine power for unknown reasons, and the failure of the pilot to maintain control of the aircraft during the emergency landing.Jun 19, 1994 · N5163R · DestroyedNTSB LAX94LA259Accident · Serious injuriesLimited investigationFinal reportMascari Discovery S-12 · Salinas, CAThe failure of the muffler assembly due to preexisting cracking in the oxidized area of the weld, with subsequent damage and separation of the propeller and reduction gear box. A related factor was the excessive taxispeed which resulted in the airplane…Jun 18, 1994 · N999 · DestroyedNTSB CHI94LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lambertville, MIThe inadequate maintenance of the airplane resulting in a foreign object in the induction system.Jun 17, 1994 · N737YW · Substantial damageNTSB CHI94LA201Accident · Serious injuriesLimited investigationFinal reportAeronca 15AC · Napoleon, MIa loss of engine power for unknown reasons. A factor related tot he accident were the trees encountered.Jun 17, 1994 · N5114Y · Substantial damageNTSB BFO94LA105Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Elizabethtown, KYThe pilot's failure to maintain directional control. A factor related to the accident was: the helicopter was outside the height-velocity envelope (for a successful autorotation), when loss of directional control occurred.Jun 17, 1994 · N2346J · Substantial damageNTSB FTW94LA200Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Pioneer, LAFuel exhaustion due to the pilot's failure to refuel. A factor was a lack of suitable terrain for the forced landing.Jun 16, 1994 · N10112 · Substantial damageNTSB LAX94FA257Accident · 2 fatalField investigationFinal reportCessna 421C · Carlsbad, CAA loss of engine power for undetermined reasons. The pilot's failure to raise the flaps and maintain altitude were factors in the accident.Jun 15, 1994 · N421AG · DestroyedNTSB LAX94FA256Accident · 2 fatalField investigationFinal reportFouga CM 170 · Long Beach, CAA loss of power to both engines due to fuel contamination and, the pilot-in-command's failure to maintain an adequate airspeed during the subsequent emergency, which resulted in an inadvertent stall. Factors in the accident were: 1) the manufacturer's…Jun 15, 1994 · N344FM · DestroyedNTSB MIA94LA160Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140D · Pine Island, FLThe pilot-in-command's failure to obtain takeoff performance data pertinent to the present conditions, his attempted excessive climb rate for conditions, and his failure to maintain airspeed while in a climb after takeoff. This resulted in the inadvertent…Jun 13, 1994 · N888HA · Substantial damageNTSB CHI94DET01Accident · Minor injuriesFinal reportArthur Alan Blind FOX III Speedster · Watervliet, MIa total loss of engine power due to carburetor icing.Jun 12, 1994 · N61AB · Substantial damageNTSB LAX94LA246Accident · 1 fatalLimited investigationFinal reportMcCulloch J-2 · Willits, CAa loss of engine power for undetermined reasons.Jun 11, 1994 · N22GR · DestroyedNTSB BFO94LA095Accident · Minor injuriesLimited investigationFinal reportCessna 172 · York, PAthe loss of total engine power for undetermined reasons.Jun 10, 1994 · N5522R · Substantial damageNTSB ATL94LA118Accident · 1 fatalLimited investigationFinal reportMonnett Moni · Ashville, NCThe failure of the pilot to maintain control of the aircraft. A factor in the accident was the thunderstorm off the departure end of the runway.Jun 10, 1994 · N112MX · Substantial damageNTSB BFO94FA091Accident · 1 fatalField investigationFinal reportMooney M20J · Edgartown, MAThe pilot's inadequate preflight inspection that failed to remove the pitot tube cover which led to loss of control of the aircraft.Jun 7, 1994 · N4393H · DestroyedNTSB ANC94LA065Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Wassila-Cheri, AKCarburetor ice collecting in the carburetor throat and the pilot's failure to use carburetor heat during the extended water taxi.Jun 6, 1994 · N96330 · Substantial damageNTSB SEA94LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Culbertson, MTThe pilot's failure to maintain directional control. Factors include gusty crosswinds, and a fence near the point of takeoff.Jun 5, 1994 · N4509Y · Substantial damageNTSB ATL94LA113Accident · Serious injuriesLimited investigationFinal reportBeech E18S · Laurens, SCThe loss of engine power on one engine followed by failure of the propeller to feather or be feathered.Jun 4, 1994 · N70CB · Substantial damageNTSB LAX94LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Simi Valley, CAThe student pilot's failure to properly align the airplane's flightpath over the runway during initial climb. A contributing factor was the student pilot's total lack of recent flying experience.Jun 2, 1994 · N32532 · Substantial damageNTSB BFO94LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Montgomery, NYThe pilot's mismanagement of the fuel supply with an improper fuel selector position which resulted in fuel starvation and the loss of engine power. A factor is the instructor's inadequate supervision of the flight.Jun 2, 1994 · N9041P · Substantial damageNTSB BFO94FA086Accident · 1 fatalField investigationFinal reportCessna 150F · Bloomingburg, OHThe failure of the pilot-in-command to maintain adequate airspeed. This led to a stall during the initial takeoff and climb at an altitude that did not permit a recovery. A factor related to the accident was the presence of sunglare during the takeoff, which…Jun 2, 1994 · N7972F · DestroyedNTSB MIA94LA153Accident · 1 fatalLimited investigationFinal reportMaxair MU532 · Kissimmee, FLInadvertent stall/mush by the pilot-in-command resulting in the uncontrolled descent and collision with terrain.Jun 1, 1994 · UNREG · Substantial damageNTSB NYC94LA099Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Taunton, MAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was unfavorable winds.May 31, 1994 · N33P · Substantial damageNTSB LAX94FA232Accident · 2 fatalField investigationFinal reportBeech A-36 · Fullerton, CAthe pilot's lack of familiarity with the performance change of the airplane, and the lack of proper training/transition in the modified airplane. Contributing to the accident was inadequate substantiation process and insufficient review by the FAA; the…May 31, 1994 · N4323W · DestroyedNTSB CHI94LA183Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Bolivar, MOThe partial blockage of the carburetor's induction air opening by a plastic bag.May 31, 1994 · N11286 · Substantial damageNTSB LAX94LA229Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Calexico, CA1) the pilot's failure to correctly position the fuel selectors prior to takeoff, 2) the resultant fuel starvation failure of the left engine in the takeoff initial climb, and 3) the failure of the pilot to maintain directional control of the aircraft.May 30, 1994 · N814U · Substantial damageNTSB CHI94LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lake City, MIThe pilot-in-command's inadequate compensation for wind conditions. Factors were the pilot-in-command's not using all available runway, premature lift off, and a crosswind.May 29, 1994 · N9691W · Substantial damageNTSB CHI94LA179Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lodi, WIthe pilot's failure to maintain direction control which resulted from a inadequate compensation for the crosswind conditions. Factors related to the accident were the pilot's diverted attention, the crosswind, the trees which were contacted.May 29, 1994 · N55835 · Substantial damageNTSB SEA94LA143Accident · No injuriesLimited investigationFinal reportWray KR-2 · Puyallup, WAAn improperly functioning fuel boost pump.May 28, 1994 · N786RW · Substantial damageNTSB FTW94LA184Accident · Minor injuriesLimited investigationFinal reportLockheed P-38 · Breckenridge, TXThe fuel starvation induced loss of power due to improper positioning of the fuel selector. Factors were the pilot's lack of experience in the type airplane, and the lack of suitable terrain for the forced landing.May 28, 1994 · N38LL · Substantial damageNTSB ANC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe failure of an exhaust valve. The lack of suitable terrain for a forced landing was a factor.May 28, 1994 · N6174D · Substantial damageNTSB FTW94FA176Accident · 1 fatalField investigationFinal reportPraker Thorp T18C · Phoenix, AZThe pilot's inability to prevent an inadvertent stall and his inability to recover due to a restriction in the movement of the stabilator for undetermined reasons. A factor was the failure of the owner/builder and the pilot to accomplish a control rigging…May 24, 1994 · N86BP · DestroyedNTSB FTW94FA168Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Wingate, TXWas the pilot's failure to maintain proper alignment. Factors were the wind, and the pilot's improper corrections.May 21, 1994 · N8895W · DestroyedNTSB CHI94DCG01Accident · 1 fatalFinal reportDavis TRI-Q 200 · Joplin, MOLoss of engine power for undetermined reasons, and the pilot's failure to maintain control of the airplane. Factors which contributed to the accident were: the pilot intentionally operating an airplane with known deficiencies, his lack of experience in the…May 21, 1994 · N800Q · DestroyedNTSB FTW94LA175Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Del Rio, TXFuel starvation induced power loss due to an exhaust system leak resulting in an electrical system inflight fire in the area of the fuel pump. A factor was the lack of suitable terrain for the forced landing.May 20, 1994 · N14773 · Substantial damageNTSB MIA94LA144Accident · Minor injuriesLimited investigationFinal reportBell 206B · St. Petersburg, FLThe failure of the number five bearing, shaft, or thomas coupling for undetermined reasons. Contributing to the accident was the pilot-in-command's delayed response in conducting the emergency procedure by not reducing the throttle to idle position, and…May 19, 1994 · N72Z · Substantial damageNTSB FTW94LA162Accident · No injuriesLimited investigationFinal reportRockwell 112A · Henderson, NVThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.May 17, 1994 · N1349J · Substantial damageNTSB FTW94LA159Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · De Witt, ARA stall/mush into terrain after the pilot inadvertently raised the flaps.May 16, 1994 · N448AT · Substantial damageNTSB SEA94LA117Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Yuba City, CAAn inadvertent stall/mush after takeoff. The over-weight loading of the aircraft was a factor.May 12, 1994 · N8214S · Substantial damageNTSB CHI94LA156Accident · No injuriesLimited investigationFinal reportCessna 150F · Chippewa Falls, WIthe loss of engine power due to a binding carburetor heat door.May 12, 1994 · N6872F · Substantial damageNTSB CHI94LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Anthony, KSthe pilot's failure to obtain sufficient airspeed prior to liftoff. A factor in the accident was the pilot's lack of total experience in type of airplane.May 11, 1994 · N7313F · Substantial damageNTSB FTW94LA147Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Crystal Beach, TXThe pilot's improper autorotation touchdown, which rsulted in the hard landing. A factor was the power loss due to water contaminated fuel.May 8, 1994 · N6417V · Substantial damageNTSB FTW94LA145Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · El Campo, TXThe partial loss of engine power due to one magneto being weak and the other magneto arcing inside its case. A factor was the lack of suitable terrain for the forced landing.May 7, 1994 · N9682 · DestroyedNTSB CHI94LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Sikeston, MOa fatigue failure of a compressor blade which resulted in a catostrophic engine failure.May 5, 1994 · N91966 · Substantial damage