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 LAX94FA211Accident · 1 fatalField investigationFinal reportAero Commander 100 · Ocotillo Wells, CAthe failure of the pilot to maintain flying speed after experiencing a partial power failure while maneuvering. A factor in the accident was the failure of the pilot to drain accumulated water from the aircraft fuel system during the preflight inspection.May 4, 1994 · N3661X · DestroyedNTSB LAX94LA207Accident · 1 fatalLimited investigationFinal reportGriffin Titan Tornado · Buckeye, AZthe pilot's failure to maintain control of the aircraft. A factor in the accident was his complete lack of any flight experience or instruction.May 2, 1994 · UNREG · DestroyedNTSB MIA94LA129Accident · Serious injuriesLimited investigationFinal reportTaylor Osprey · Sanford, FLThe failure of the pilot in command to use the checklist before takeoff. The engine failed due to the fuel selector being in the off position. Contributing to the accident was the unsuitable terrain for a forced landing.May 1, 1994 · N323ET · Substantial damageNTSB FTW94LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lindon, COInaccurate preflight planning and preparation for the flight. A factor was soft terrain on the landing strip.May 1, 1994 · N8559H · Substantial damageNTSB FTW94FA141Accident · 2 fatalField investigationFinal reportMooney M20E · Broomfield, COFatigue failure of the engine crankshaft; and failure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in a stall and collision with the terrain. Factors related to the accident were: the undesirable engine/propeller…May 1, 1994 · N1905Y · DestroyedNTSB SEA94LA112Accident · No injuriesLimited investigationFinal reportBeech A24R · Everett, WAFuel system pump contamination and procedures/directives were not followed.Apr 30, 1994 · N24661 · Substantial damageNTSB MIA94LA127Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Bushnell, FLThe pilot-in-command's improper landing flare during a forced landing, resulting in a hard landing and separation of the right main landing gear. Contributing to the accident was a partial loss of engine power due to a loose exhaust valve seat on the No. 3…Apr 26, 1994 · N9530A · Substantial damageNTSB ATL94LA086Accident · No injuriesLimited investigationFinal reportFerguson Fergy II · Nashville, TNThe pilot's failure to maintain clearance from a utility wire during climbout.Apr 25, 1994 · N71797 · Substantial damageNTSB MIA94LA126Accident · Minor injuriesLimited investigationFinal reportParsons BP Gyro · Bunnell, FLThe pilot-in-command's improper use of the flight controls during landing flare touchdown, resulting in the gyroplane touching down on the nose gear, and subsequent nose over. The loss of engine power was also a cause.Apr 24, 1994 · N54WP · Substantial damageNTSB FTW94LA131Accident · Minor injuriesLimited investigationFinal reportGulfstream G-164B · Delaplaine, ARThe loss of engine power for undetermined reasons. A factor was the low altitude at which the power loss occurred.Apr 21, 1994 · N8402K · Substantial damageNTSB FTW94LA128Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Monticello, ARThe loss of power for undetermined reasons and the inadvertant stall during the forced landing. A factor was the lack of suitable terrain.Apr 18, 1994 · N8958Q · Substantial damageNTSB LAX94FA193Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Nogales, AZa failure of the pilot to maintain adequate airspeed which resulted in an inadvertent stall.Apr 17, 1994 · N6331P · DestroyedNTSB CHI94DER01Accident · Minor injuriesFinal reportJohnson Avid Flyer Mark IV · New Richmond, WICarburetor ice, and the owner/builder's inadequate airplane/equipment design, in that there was no carburetor heat/control installed in the airplane. Factors related to the accident were: the weather (carburetor icing conditions), and obstacles (trees) in the…Apr 17, 1994 · N312RJ · Substantial damageNTSB SEA94LA160Accident · No injuriesLimited investigationFinal reportNewgard Kitfox III · Yelm, WAFuel starvation due to an inadequately installed fuel line.Apr 16, 1994 · N82QU · Substantial damageNTSB LAX94LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hesperia, CALoss of engine power due to an air leak at the gascolator gasket, which was improperly installed during maintenance. Darkness was a related factor.Apr 16, 1994 · N4129J · Substantial damageNTSB FTW94LA125Accident · Minor injuriesLimited investigationFinal reportHiller UH-12 · Alvin, TXThe pilot's failure to maintain rotor speed, delay of the flare, and the improper touchdown. A factor was the loss of engine power for undetermined reasons.Apr 16, 1994 · N41319 · Substantial damageNTSB SEA94LA101Accident · Minor injuriesLimited investigationFinal reportAsher RV-6 · Enterprise, ORA loss of power due to a partially blocked induction air filter. Factors include no suitable terrain on which to execute a forced landing.Apr 15, 1994 · N7057G · Substantial damageNTSB CHI94LA131Accident · No injuriesLimited investigationFinal reportCessna 172 · Edina, MOthe pilot in commands' failure to obtain obstruction clearance from trees during a visual takeoff from a short, soft, wet field in instrument meteorological conditions. A factor was the pilot in commands' misjudgment of the takeoff climb performance of the…Apr 11, 1994 · N4253L · DestroyedNTSB ANC94LA048Accident · No injuriesLimited investigationFinal reportCessna A185F · Paxson, AKThe pilot-in-command did not maintain proper clearance from the snow berm. A factor in the accident was the snow berm.Apr 8, 1994 · N8191Q · Substantial damageNTSB LAX94LA177Accident · 2 fatalLimited investigationFinal reportGardner E-RACER Mark II · Parker, AZthe failure of the pilot to maintain control of the aircraft while maneuvering in the traffic pattern following a failure of the throttle control. A factor in the accident was a throttle linkage separation after takeoff.Apr 4, 1994 · N96WM · DestroyedNTSB BFO94LA060Accident · Serious injuriesLimited investigationFinal reportTalago Thundergull JT2 · Clarksburg, WVThe builder's inadequate maintenance adjustment which resulted in the aileron control assembly becoming disconnected.Apr 4, 1994 · N73ST · Substantial damageNTSB FTW94LA116Accident · Serious injuriesLimited investigationFinal reportAero Commander 100-180 · Steamboat Sprgs, COAn inadvertent stall after liftoff. Factors were an unfavorable wind and high density altitude.Apr 3, 1994 · N4015X · Substantial damageNTSB LAX94LA180Accident · Serious injuriesLimited investigationFinal reportCurry FLY-BABY · Bisbee, AZa loss of engine power due a blockage in the fuel tank outlet which caused fuel starvation.Apr 2, 1994 · N183RC · DestroyedNTSB FTW94LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · San Angelo, TXThe partial loss of engine power. A factor was the lack of suitable terrain.Apr 2, 1994 · N3521K · Substantial damageNTSB CHI94DCQ01Accident · 1 fatalFinal reportRobert O. ELY STARDUSTER-II SA300 · Baxter Springs, KSthe pilot's failure to maintain altitude during an aerobatic maneuver on takeoff. A factor related to the accident was the pilot performing an aerobatic maneuver.Apr 2, 1994 · N107UP · DestroyedNTSB BFO94LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Berea, KYThe pilot-in-command's failure to maintain adequate airspeed during the takeoff. A factor related to the accident is the gusty wind conditions.Apr 2, 1994 · N5868B · DestroyedNTSB CHI94LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-300 · Beloit, KSthe pilot's failure to maintain sufficient airspeed during the initial takeoff climb.Apr 1, 1994 · N3735E · Substantial damageNTSB MIA94LA103Accident · No injuriesLimited investigationFinal reportCessna 172RG · Boca Raton, FLThe failure of the aircraft operator to comply with engine manufacturers service bulletins which resulted in improper inspection of exhaust valves and subsequent sticking of the no. 4 exhaust valve.Mar 26, 1994 · N9781B · Substantial damageNTSB MIA94LA102Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Key West, FLThe failure of the pilot-in-command to ensure the aircraft was at an adequate altitude above the water before initiating a turn which resulted in the right float contacting the water during the turn and the aircraft cartwheeling.Mar 26, 1994 · N5087R · Substantial damageNTSB MIA94LA100Accident · Serious injuriesLimited investigationFinal reportBell 206L · Orlando, FLThe pilot's failure to cross-check a faulty engine speed indication with other engine performance indications to verify whether an engine malfunction had actually occurred, and his failure to maintain adequate rotor RPM during an emergency landing. The…Mar 25, 1994 · N16705 · Substantial damageNTSB CHI94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Romeo, MIthe pilot's improper use of carburetor heat. A factor in the accident is weather conducive to the formation of carburetor ice.Mar 20, 1994 · N4373X · Substantial damageNTSB NYC94FA065Accident · 2 fatalField investigationFinal reportPiper Aerostar 601P · Limerick, PAThe pilot's failure to ensure that ice was properly removed from the airplane before flight, possibly due to impairment of judgment caused by a prescription drug (valium) that was not approved for use while flying. Factors related to the accident were: the…Mar 18, 1994 · N36444 · DestroyedNTSB MIA94FA097Accident · 2 fatalField investigationFinal reportGrumman G-73T · Key West, FLFailure of the pilot-in-command to assure the bilges were adequately pumped free of water (adequately preflighted), which resulted in the aft center of gravity limit to be exceeded, and failure of the aircrew to follow the checklist. A factor related to the…Mar 18, 1994 · N150FB · DestroyedNTSB ATL94LA063Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Nashville, TNA loss of engine power for undetermined reasons.Mar 15, 1994 · N732HA · Substantial damageNTSB SEA94FA084Accident · 4 fatalField investigationFinal reportBellanca 14-19-3A · Wendover, UTInadequate in flight planning/decision. Factors to the accident were: clearance was not maintained and dark night conditions.Mar 14, 1994 · N8885R · DestroyedNTSB SEA94LA082Accident · No injuriesLimited investigationFinal reportCessna 185 · Fort Lewis, WAThe fuel shutoff valve seized in a partially open position.Mar 13, 1994 · N4732E · Substantial damageNTSB FTW94LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Olla, LAThe loss of engine power due to a blocked fuel line. A factor was the lack of suitable terrain for the forced landing.Mar 13, 1994 · N8645D · Substantial damageNTSB MIA94LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sebring, FLThe failure of the muffler in flight for unknown reasons, allowing hot exhaust gasses to impinge on the carburetor igniting the fuel and the subsequent fire.Mar 12, 1994 · N8938W · Substantial damageNTSB LAX94FA159Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Los Angeles, CAthe failure of the upper engine compartment cowl to remain attached to the lower cowl during initial climb as a result of inadequate maintenance and replacement practices by the aircraft owner.Mar 12, 1994 · N8129W · DestroyedNTSB MIA94FA085Accident · 1 fatalField investigationFinal reportDaffron, Harold C. Varieze · Oxford, MSPoor planning/decision by the pilot-in-command for failure to perform high and low speed taxi tests before the flight after repairs and modification of the airplane. Additionally, failure or malfunction of the flight control system for undetermined reasons,…Mar 6, 1994 · N3769D · DestroyedNTSB LAX94LA152Accident · 1 fatalLimited investigationFinal reportCessna 210-5A · Jackpot, NVthe pilot's failure to maintain control of the aircraft's flight path while maneuvering after takeoff in an area of no ground reference lights. Factors in the accident were the pilot's lack of instrument flight experience and the dark nighttime lighting…Mar 6, 1994 · N4810U · DestroyedNTSB MIA94LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, FLThe failure of the pilot to maintain airspeed during the forced landing resulting in an inadvertent stall/mush. The total loss of engine power caused by fuel starvation due to inattentiveness by the pilot-in-command (CFI) to the fuel supply was also a cause.Mar 5, 1994 · N9134A · Substantial damageNTSB LAX94LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-180 · Fairfield, AZThe flight instructor's inadvertent movement of the left engine propeller control into the feather position, his decision to by-pass suitable landing sites in an attempt to restart the left engine as the aircraft energy and performance capability…Mar 5, 1994 · N2142P · Substantial damageNTSB CHI94DEP02Accident · No injuriesFinal reportCorby Starlet · Watertown, WIThe pilot-in-command's improper use of the elevator and his lack of familiarity with the aircraft.Mar 5, 1994 · N754RG · Substantial damageNTSB LAX94LA155Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Chico, CAthe failure of the pilot to obtain/maintain sufficient flying speed during a downwind takeoff and climb, compounded by his reluctance to use full available takeoff power.Mar 4, 1994 · N6528K · Substantial damageNTSB LAX94LA148Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Jackpot, NVthe failure of the pilot to maintain control of the aircraft after his loss of visual contact with outside references. Factors in the accident were the dark night lighting conditions and spatial disorientation.Mar 4, 1994 · N9192W · DestroyedNTSB FTW94LA088Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Longmont, COAn inadvertent stall due to improper preflight and the pilot's failure to adequately remove ice from the aircraft. A factor was airframe icing.Mar 1, 1994 · N2181Q · Substantial damageNTSB BFO94LA053Accident · No injuriesLimited investigationFinal reportPiper PA-24- 260 · Stow, MAThe pilot's failure to follow the checklist which resulted in fuel starvation and subsequent loss of engine power. The lack of suitable terrain to complete a forced landing was a factor.Feb 28, 1994 · N9322P · Substantial damageNTSB MIA94LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Miami, FLLoss of engine power for undetermined reasons.Feb 25, 1994 · N7313J · Substantial damageNTSB MIA94LA080Accident · No injuriesLimited investigationFinal reportCessna 150M · Pierson, FLThe failure of the pilot-in-command to maintain alignment with the runway and airspeed resulting in the aircraft stalling.Feb 25, 1994 · N704BY · Substantial damage