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 ATL98TA054Accident · No injuriesFinal reportCessna 172 · Arcadia, FLThe pilot's inadequate pre-flight and in-flight planning, which resulted in fuel exhaustion and the loss of power. Trees and rough/uneven terrain are contributing factors.Mar 13, 1998 · N54634 · Substantial damageNTSB NYC98LA076Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Blue Ash, OHThe failure of a cooling fan blade and the pilot's improper flare.Mar 12, 1998 · N4884 · Substantial damageNTSB LAX98LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Santa Rosa, CAThe loss of engine power for undetermined reasons.Mar 9, 1998 · N5704B · Substantial damageNTSB IAD98LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fogelsville, PAThe pilot's failure to maintain control of the aircraft upon glider release. A contributing factor was the high vegetation (corn).Mar 7, 1998 · N9977B · Substantial damageNTSB MIA98LA094Accident · 1 fatalLimited investigationFinal reportNickelson Martin Coot · New Port Richey, FLfailure of the pilot to obtain/maintain adequate airspeed, while maneuvering after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain.Mar 6, 1998 · N84MN · DestroyedNTSB NYC98LA074Accident · No injuriesLimited investigationFinal reportBeech A36 · Lynchburgh, VAFailure of the number six connecting rod bolt due to improper maintenance.Mar 5, 1998 · N1559X · Substantial damageNTSB LAX98LA102Accident · Minor injuriesLimited investigationFinal reportLawrence Kitfox · Cottonwood, AZThe pilot's failure to maintain directional control and attain the proper airspeed for takeoff. A factor in the accident was his lack of recent experience in the make and model of airplane.Mar 3, 1998 · N99TL · Substantial damageNTSB LAX98LA101Accident · Minor injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot's improper use of the mixture controls.Mar 2, 1998 · N608G · Substantial damageNTSB IAD98FA032Accident · 2 fatalField investigationFinal reportCessna 172P · Langley Afb, VAThe pilot's inadvertent VFR flight into IMC conditions, and the subsequent loss of aircraft control due to spatial disorientation. A factor in the accident was the low ceiling.Mar 1, 1998 · N62082 · DestroyedNTSB ATL98LA049Accident · Serious injuriesLimited investigationFinal reportTankersley Europa MONO-WHEEL · Fernandina Bch, FLa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed.Feb 21, 1998 · N6173K · Substantial damageNTSB MIA98LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Graniteville, SCfailure of the number three exhaust valve, which resulted in loss of engine power and a forced landing. Related factors were: the obstructions (earthen embankment and fence) in the emergency (forced) landing area.Feb 20, 1998 · N3965K · Substantial damageNTSB ATL98FA047Accident · 2 fatalField investigationFinal reportSchweizer SA 2-37A · Green Cove Sprg, FLloss of engine power for undetermined reason(s); and failure of the pilot to maintain adequate airspeed, while maneuvering the airplane for a forced landing, which resulted in an inadvertent stall, uncontrolled descent, and collision with a house boat…Feb 19, 1998 · N61474 · DestroyedNTSB LAX98LA090Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Wasco, CAThe pilot overboosting the engine on takeoff which resulted in a cracked cylinder and subsequent loss of engine power.Feb 18, 1998 · N3656C · Substantial damageNTSB NYC98LA122Accident · Serious injuriesLimited investigationFinal reportGoins Sonerai II LTS · Suffolk, VAThe pilot's failure to maintain directional control during the initial takeoff climb. Factors related to the accident were habit interference, the pilot's lack of experience in the make and model, and the trees.Feb 14, 1998 · N426AG · Substantial damageNTSB FTW98MA126Accident · Serious injuriesMajor investigationFinal reportEmbraer 145-ER · Beaumont, TXThe first officer's improper use of the rudder when given a simulated engine failure on takeoff and the pilot-in-command's delayed remedial action which resulted in a loss of control. A factor was the first officer's lack of experience in the regional jet…Feb 11, 1998 · N14931 · Substantial damageNTSB IAD98LA026Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Davis, WVA loss of power due to blockage of the fuel screen and one of the four fuel injector nozzles. A contributing factor was snow covered terrain.Feb 8, 1998 · N4120H · Substantial damageNTSB ANC98FA019Accident · 1 fatalField investigationFinal reportCessna 207 · Homer, AKA fatigue failure, and partial separation of the number 6 engine cylinder head assembly, the operator's inadequate progressive inspection performed by company maintenance personnel, and the pilot's inadvertent stall during a maneuvering turn toward an…Feb 6, 1998 · N91029 · DestroyedNTSB CHI98LA091Accident · No injuriesLimited investigationFinal reportCessna 210G · Springfield, ILThe failure of left main landing gear saddle resulting in the pilot's inability to extend the left gear. A factor was maintenance personnel's failure to comply with the related airworthiness directive.Feb 4, 1998 · N5842F · Substantial damageNTSB NYC98FA063Accident · 1 fatalField investigationFinal reportCessna 172K · Boxborough, MAThe failure of the pilot to remove the frost on the wings before departure, which resulted in a stallFeb 2, 1998 · N79588 · DestroyedNTSB CHI98LA089Accident · No injuriesLimited investigationFinal reportChinese A/F Aero Ind Dev CTR PL-1B · Sugar Grove, ILinadequate design of the carburetor heat system by the manufacturer, and subsequent carburetor ice, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: carburetor icing (weather) conditions, and obstructions and…Feb 1, 1998 · N830JT · Substantial damageNTSB MIA98LA061Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-602 · Wrightsville, GAThe failure of the pilot to maintain airspeed (Vs) resulting in the inadvertent stall during the initial climb.Jan 29, 1998 · N50929 · Substantial damageNTSB ATL98LA041Accident · No injuriesLimited investigationFinal reportCessna 177 · New Port Richey, FLpartial loss of engine power for undetermined reasons, which led to a forced landing and collision with trees.Jan 27, 1998 · N30192 · Substantial damageNTSB MIA98LA078Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Sarasota, FLinadequate clearance and fretting wear of the fitting/beam attachment to the angle/top beam, due to inadequate design, which resulted in fatigue and subsequent failure of the fitting/beam attachment ear.Jan 24, 1998 · N2994P · Substantial damageNTSB FTW98LA105Accident · No injuriesLimited investigationFinal reportCessna 140A · Justin, TXthe pilot's improper planning/decision and failure to ensure that the airplane would be able to remain clear of the fence during takeoff. Factors relating to the accident were: the wet/soft/short runway (and terrain) conditions.Jan 24, 1998 · N377V · Substantial damageNTSB ATL98LA035Accident · No injuriesLimited investigationFinal reportPiper J5-A · Vero Beach, FLloss of engine power for undetermined reasons.Jan 20, 1998 · N38645 · Substantial damageNTSB NYC98LA061Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lake Placid, NYwas the pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.Jan 17, 1998 · N150JH · DestroyedNTSB IAD98LA022Accident · No injuriesLimited investigationFinal reportCessna 182M · Mount Pleasant, PAThe pilot's failure to initiate a go-around, and his failure to maintain adequate airspeed.Jan 14, 1998 · N71763 · DestroyedNTSB FTW98FA093Accident · 4 fatalField investigationFinal reportBell 222UT · Sandy, UTflight by the pilot into known adverse weather conditions, and his failure (or inability) to maintain sufficient clearance or altitude from mountainous terrain. Related factors were: darkness, heavy snow, high winds, the pilot's perception of pressure that…Jan 12, 1998 · N222UH · DestroyedNTSB CHI98LA073Accident · 1 fatalLimited investigationFinal reportCessna 402B · Watertown, SDthe pilot's failure to perform an aircraft preflight and to remove the ice which had accumulated on the airframe. A factor involved in the accident was the icing weather conditions which existed and the ice which accumulated on the airplane.Dec 31, 1997 · N5087Q · DestroyedNTSB CHI98FA074Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-30 · Wayne, ILthe pilot in command failed to maintain control of the aircraft. A factor was the lack of experience of the pilot and copilot in the type and model of aircraft. An additional factor was the pilot did not follow the proper procedure when the flaps were raised…Dec 30, 1997 · N999WB · DestroyedNTSB NYC98LA055Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Mansfield, MAThe pilot's failure to remove snow and ice from the aircraft prior to takeoff resulting in degraded climb performance and a subsequent stall/mush condition.Dec 28, 1997 · N9604H · DestroyedNTSB CHI98LA067Accident · Serious injuriesLimited investigationFinal reportBeech 35-B33 · Troy, MIloss of engine power for undetermined reason(s). Factors associated with the accident were: the lack of a suitable forced landing site, and the embankment (dirt bank), which the airplane contacted.Dec 27, 1997 · N512WM · Substantial damageNTSB MIA98FA045Accident · 1 fatalField investigationFinal reportCessna 172M · Raleigh-Durham, NCWas loss of control of the airplane on initial climb after entering instrument flight conditions resulting in a turn opposite in direction from that given by ATC, and eventual collision with terrain.Dec 25, 1997 · N12172 · DestroyedNTSB ATL98LA029Accident · 1 fatalLimited investigationFinal reportLutz EAA Biplane P-2 · Wellington, FLfailure of the pilot to ensure the fuel selector was properly positioned to a tank with adequate fuel before takeoff, which resulted in fuel starvation and loss of engine power; failure of the pilot to accomplish the emergency procedure (restart the engine…Dec 22, 1997 · N913AM · Substantial damageNTSB LAX98LA058Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Truckee, CAinternal mechanical failure of the engine due to a progressive failure of the No. 3 connecting rod assembly. A contributing factor was the snow pack which covered the only accessible emergency landing area.Dec 20, 1997 · N5058L · Substantial damageNTSB IAD98FA018Accident · 3 fatalField investigationFinal reportBeech A 36 · Findlay, OHThe pilot-in-command's failure to obtain/maintain clearance with objects during the initial climb. Contributing factors were trees, fog, and the flying pilot's failure to maintain runway heading during the initial climb.Dec 20, 1997 · N5050G · DestroyedNTSB ATL98LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Jacksonville, NCthe pilot's improper preflight inspection by failing to ensure the fuel selector was properly positioned, which led to fuel starvation, loss of engine power, and a forced landing on rough/uneven terrain. The lack of suitable terrain for a forced landing was a…Dec 20, 1997 · N5258Z · Substantial damageNTSB ATL98LA027Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Monticello, FLthe pilot's inadequate preflight planning/preparation, and failure to ensure that the airplane would be able to clear trees during takeoff. Related factors were: the high/wet vegetation on the grass runway, and the proximity of trees to the runway.Dec 19, 1997 · N5789L · DestroyedNTSB NYC98LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Perkasie, PAThe flight instructor failure to maintain directional control, which resulted in an off runway landing, after the left engine was reported to have lost power.Dec 18, 1997 · N6962Y · Substantial damageNTSB NYC98LA044Accident · Minor injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Oxford, CTThe loss of power for undetermined reasons.Dec 18, 1997 · N67868 · Substantial damageNTSB IAD98LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Steubenville, OHCollision with deer on runway during initial takeoff and climb.Dec 18, 1997 · N28122 · DestroyedNTSB CHI98LA071Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Valley Center, KSthe pilot's excessive pull up after lift-off and failure to maintain adequate airspeed during the initial climb, which resulted in a stall and collision with wooded terrain.Dec 17, 1997 · N32737 · Substantial damageNTSB CHI98FA068Accident · 1 fatalField investigationFinal reportBeech C35 · Evansville, INImproper maintenance by the use of a loose fitting unapproved fuel line, which resulted in fuel starvation and the loss of engine power.Dec 17, 1997 · N782D · Substantial damageNTSB FTW98FA068Accident · 4 fatalField investigationFinal reportBell 407 · Littleton, COThe pilot's inability to maintain adequate visual lookout due to the lighting conditions and his failure to follow company procedures for departure from a landing zone. Factors were dark night conditions, bright lights in the landing zone which prevented…Dec 15, 1997 · N771AL · DestroyedNTSB NYC98LA042Accident · No injuriesLimited investigationFinal reportCessna 182P · Chatham, MAloss of engine power for undetermined reason(s). The tail wind component and an encounter with a ditch were related factors.Dec 11, 1997 · N20710 · Substantial damageNTSB CHI98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dawson, NDThe pilot's improper use of carburetor heat. Factors were carburetor icing conditions and a fence.Dec 9, 1997 · N55259 · Substantial damageNTSB ATL98LA019Accident · 2 fatalLimited investigationFinal reportSiggi's Airplane Works D-4 Fascination · Leesburg, FLstructural failure of the right wing, during the initial climb after takeoff, which resulted in an uncontrolled descent to the ground.Dec 6, 1997 · DMSMV · DestroyedNTSB CHI98LA054Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Lee'S Summit, MOthe pilot's inadequate remedial action concerning the loss of engine power, after inadvertently switching off the magnetos. Factors relating to the accident were: the broken springs for magneto cover guard; excessive drag from the extended landing gear and…Dec 5, 1997 · N8189P · DestroyedNTSB NYC98FA034Accident · 2 fatalField investigationFinal reportBeech BE-S35 · Chatham, MAThe pilot's failure to maintain adequate airspeed during initial climb which resulted in an inadvertent stall and subsequent impact into trees. Related factors were high wind and turbulence.Nov 27, 1997 · N5667K · DestroyedNTSB LAX98FA048Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Carson City, NVThe failure of the pilot to maintain airspeed after being distracted by the nose baggage door opening in-flight resulting in a stall/spin. Factors contributing to the accident were the pilot's inadequate preflight inspection and lack of experience in the type…Nov 27, 1997 · N6933Y · Destroyed