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 NYC97LA152Accident · Serious injuriesLimited investigationFinal reportKenneson Merlin GT · Kensington, NHthe pilot's inability to obtain and/or maintain control of the airplane after takeoff.Jul 23, 1997 · N912AK · Substantial damageNTSB CHI97LA221Accident · 1 fatalLimited investigationFinal reportGoble RV-4 · Rosemount, MNthe pilot's failure to maintain adequate airspeed after takeoff, which resulted in a stall/spin and collision with the terrain. His excessive climb rate after takeoff was a related factor.Jul 23, 1997 · N36JG · DestroyedNTSB SEA97LA176Accident · Minor injuriesLimited investigationFinal reportGarner RAF 2000 GTX-SE · Bandon, ORThe pilot's failure to maintain sufficient rotor RPM. A factor was the pilot's limited flight experience in gyroplanes.Jul 22, 1997 · N6281Y · Substantial damageNTSB NYC97LA150Accident · No injuriesLimited investigationFinal reportCessna 172E · Fitchburg, MAA loss of engine power for undetermined reasons.Jul 22, 1997 · N3553S · Substantial damageNTSB ATL97LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Portland, TNThe pilot's attempt to perform a short field takeoff in unsuitable terrain. A related factor was the pilot's desire to impress his co-workers.Jul 22, 1997 · N10744 · Substantial damageNTSB FTW97LA277Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Blackwell, OKpartial loss of engine power for undetermined reasons. Factors relating to the accident were: the high vegetation and ditch in the emergency landing area.Jul 21, 1997 · N8784L · Substantial damageNTSB CHI97LA217Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Hill City, KSthe sustained partial loss of engine power due to low compression on one cylinder and the rough, uneven terrain.Jul 21, 1997 · N268JW · Substantial damageNTSB CHI97FA220Accident · 4 fatalField investigationFinal reportBeech B-60 · Springfield, MOThe pilot's fuel mismanagement and his failure to maintain adequate airspeed which resulted in fuel exhaustion followed by the loss of power in one engine and the loss of aircraft control. Contributing was the pilot's failure to refuel the aircraft, the…Jul 20, 1997 · N3359P · DestroyedNTSB ANC97LA108Accident · No injuriesLimited investigationFinal reportGoode Avid Flyer MK-IV · Nikiski, AKThe pilot's inadequate compensation for wind conditions. Factors were the sudden windshift, and the pilot's lack of seaplane certification.Jul 20, 1997 · N4356H · Substantial damageNTSB LAX97LA252Accident · No injuriesLimited investigationFinal reportCessna 182N · Sacramento, CAFailure of maintenance personnel to adequately repair the pitch trim system and ensure that it was properly rigged, and the pilot's failure to maintain pitch control due to the distraction at liftoff of the mistrim condition.Jul 18, 1997 · N9099G · Substantial damageNTSB SEA97LA169Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Newdale, IDThe pilot's inadequate preflight/planning preparation which resulted in the aircraft exceeding the maximum gross weight, and inability to climb. A factor was high density altitude.Jul 17, 1997 · N9022H · Substantial damageNTSB NYC97LA147Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Napoleon, OHThe pilot's decision to take off with inadequate fuel.Jul 17, 1997 · N2550N · Substantial damageNTSB FTW97LA270Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Amelia, LApartial loss of engine power due to frog(s) being ingested into the engine. Factors relating to the accident were: the lack of altitude and lack of suitable terrain for a forced landing.Jul 17, 1997 · N3892R · Substantial damageNTSB CHI97LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fessenden, NDthe pilot's premature liftoff and/or failure to abort the takeoff while there was sufficient runway remaining.Jul 17, 1997 · N41371 · Substantial damageNTSB ATL97LA104Accident · No injuriesLimited investigationFinal reportCessna 177RG · Knoxville, TNthe pilot's inadequate preflight by failing to ensure the oil filler cap was secured during his preflight inspection, and loss of engine oil (oil exhaustion), which resulted in subsequent engine failure. A factor relating to the accident was: the lack of…Jul 16, 1997 · N52120 · Substantial damageNTSB MIA97LA210Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Woodeberry, TNin-flight collision with a fence during takeoff. Factors in this accident were the pilot's inadequate pre-flight by not calculating the total weight of the airplane, and high temperatures.Jul 13, 1997 · N7981 · DestroyedNTSB CHI97LA210Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNloss of engine power for undetermined reason(s). A factor relating to the accident was: the wet/soft terrain in the emergency landing area.Jul 13, 1997 · N9746G · Substantial damageNTSB FTW97LA278Accident · Minor injuriesLimited investigationFinal reportWatts RAF 2000 Gyroplane · Conroe, TXThe pilot's failure to maintain aircraft control. A factor was his premature liftoff at low airspeed.Jul 10, 1997 · N6826Z · Substantial damageNTSB NYC97LA140Accident · No injuriesLimited investigationFinal reportCessna 182A · Hayfield Twnshp, PAThe pilot's improper decision to attempt a takeoff from unsuitable terrain and failure to maintain airspeed. A factor in this accident was the gusty wind conditions.Jul 8, 1997 · N4951D · DestroyedNTSB MIA97LA208Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Altha, FLthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain control of the airplane.Jul 8, 1997 · N1509C · DestroyedNTSB ATL97LA101Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Fajardo, PRa malfunction (jamming) of the elevator flight control system for undetermined reason(s).Jul 6, 1997 · N4515T · Substantial damageNTSB ATL97LA099Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Destin, FLa loss of engine power for undetermined reasons.Jul 6, 1997 · N222WE · Substantial damageNTSB SEA97LA161Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Bend, ORthe pilot's failure to attain a proper climb rate. High density altitude and the pilot's failure to use all of the available runway were factors.Jul 5, 1997 · N37RA · Substantial damageNTSB CHI97LA202Accident · Minor injuriesLimited investigationFinal reportNiquette Pietenpol GN-1 · Lake Village, INthe pilot's inability to maintain sufficient airspeed and climb.Jul 5, 1997 · N46844 · Substantial damageNTSB CHI97FA200Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · St. Paul, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. Related factors were the pilot's diverted attention and gusty wind conditions.Jul 2, 1997 · N83353 · Substantial damageNTSB ATL97FA095Accident · 1 fatalField investigationFinal reportBoeing Stearman B75N1 · Locust Grove, GAThe inadvertent stall encountered by the pilot after experiencing an in-flight cylinder head separation.Jul 2, 1997 · N450GC · DestroyedNTSB ATL97LA093Accident · Minor injuriesLimited investigationFinal reportConvair 240-53 · San Juan, PRa loss of engine power for undetermined reasons, the pilot's improper emergency procedure after the powewr loss, and the overloading of the airplane, resulting in an inability to maintain altitude and terrain clearance.Jun 30, 1997 · N344MM · Substantial damageNTSB FTW97LA240Accident · Serious injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Ardmore, OKThe pilot's failure to maintain clearance from the power line. Factors were his improper decision to continue the flight after he noted a loss of engine power during initial takeoff climb and the loss of engine power for an undetermined reason.Jun 29, 1997 · N2308H · Substantial damageNTSB CHI97LA192Accident · No injuriesLimited investigationFinal reportCessna A188B · Mcgregor, MNthe pilot's improper planning/decision, his failure to abort the takeoff while sufficient runway was remaining, and/or his failure to jettison his load in order to achieve sufficient climb rate to clear trees. His lack of certification and training to perform…Jun 29, 1997 · N4485Q · Substantial damageNTSB IAD97LA093Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Charlton, MAThe loss of engine power for undetermined reasons..Jun 28, 1997 · N39CC · Substantial damageNTSB ATL97LA091Accident · Serious injuriesLimited investigationFinal reportBeech E50 · Tullahoma, TNimproper operation of the engine that produced internal damage, and improper servicing of the airplane by the owner/pilot mechanic that resulted in the subsequent mechanical failure of the engine crankshaft counterweight. Contributing to the accident was the…Jun 28, 1997 · N4265R · Substantial damageNTSB FTW97LA237Accident · Serious injuriesLimited investigationFinal reportRans S-12 Airaile S-12 · Fort Collins, COAttempt by the pilot to fly the aircraft with the center of gravity out of limits. A factor was a disconnected lift strut support cable.Jun 27, 1997 · N2117X · Substantial damageNTSB ANC97LA091Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Chugiak, AKwater contamination in the fuel, the second pilot's inadequate preflight/preparation to ensure all water was drained from the airplane fuel tanks, and inadequate supervision by the first pilot (CFI). A factor relating to the accident was: the lack of suitable…Jun 26, 1997 · N1386A · Substantial damageNTSB SEA97LA151Accident · No injuriesLimited investigationFinal reportCessna 182P · Yakima, WAThe loss of engine power for undetermined reasons. Contributing to the accident was the soft terrain.Jun 25, 1997 · N9932E · Substantial damageNTSB ANC97LA090Accident · No injuriesLimited investigationFinal reportBeech D18S · Willow, AKThe loss of engine power for an undetermined reason.Jun 25, 1997 · N765D · DestroyedNTSB LAX97LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe dual student's premature rotation and failure to attain/maintain an adequate airspeed, which lead to a stall/mush and loss of control in-flight, and the flight instructor's inadequate supervision of the flight. A factor in this accident was the flight…Jun 24, 1997 · N96736 · Substantial damageNTSB NYC97LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Highgate, VTThe pilot's failure to secure the cargo. A factor was the pilot's failure to perform weight and balance calculations.Jun 23, 1997 · N8321Y · DestroyedNTSB CHI97LA179Accident · No injuriesLimited investigationFinal reportCessna A150M · Cumberland, INthe pilot's failure to use (or improper use of) carburetor heat. Factors associated with the accident were: carburetor icing (weather) conditions, and the lack of airspeed (or altitude) to clear an obstruction (barn) without stalling the airplane.Jun 23, 1997 · N9842J · Substantial damageNTSB ATL97LA088Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402B · Ridgely, TNThe pilot's inadequate preflight planning in that he failed to account for the high temperature and high density altitude, which resulted in an aerodynamic stall and loss of control. Factors were the tall crops and the ditch.Jun 23, 1997 · N6128W · Substantial damageNTSB NYC97LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Hammonton, NJA loss of engine power due to a partially blocked engine muffler.Jun 21, 1997 · N43464 · DestroyedNTSB MIA97FA188Accident · 1 fatalField investigationFinal reportBeech 77 · Fort Lauderdale, FLloss of engine power for undetermined reason(s), and failure of the student pilot to remain clear of obstructions, while attempting to make a forced landing.Jun 21, 1997 · N1821B · DestroyedNTSB SEA97LA150Accident · No injuriesLimited investigationFinal reportCorben Junior ACE · East Wenatchee, WAThe dual student's improper attempt to abort the takeoff and the flight instructor's inadequate supervision of the flight.Jun 20, 1997 · N9017 · Substantial damageNTSB LAX97FA217Accident · 3 fatalField investigationFinal reportPiper PA 31-310 · San Diego, CAThe loss of power in the left engine for undetermined reasons and the pilot's subsequent failure to maintain minimum single-engine control airspeed. A contributing factor was the pilot's decision to fly with known deficiencies in the equipment.Jun 20, 1997 · N266MM · DestroyedNTSB CHI97LA173Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Kaiser, MOwas fuel starvation for undetermined reasons. A factor was the failure of the pilot to refuel the aircraft.Jun 19, 1997 · N25643 · Substantial damageNTSB LAX97IA209Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Las Vegas, NVthe maintenance/overhaul facility's improper repair, which led to obstructed oil supply hole(s) at the #5 bearing inner race, then oil starvation and subsequent uncontained engine failure.Jun 18, 1997 · N875RA · Minor damageNTSB FTW97LA228Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Pond Creek, OKloss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.Jun 18, 1997 · N4859X · DestroyedNTSB CHI97LA168Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Franklin, INthe instructor pilot stalled the aircraft as a result of inadequate preflight planning. Factors included the transmission wire, the rising terrain, and the trees at the departure end of the runway.Jun 17, 1997 · N3787J · DestroyedNTSB NYC97LA116Accident · 1 fatalLimited investigationFinal reportGoodwin Rans S-4 · Cedar Bluff, VAThe pilot's failure to maintain airspeed during the initial takeoff climb which resulted in an inadvertent stall. A related factor was the pilot's lack of familiarity with the airplane.Jun 16, 1997 · N495J · DestroyedNTSB NYC97FA118Accident · 2 fatalField investigationFinal reportCessna 152 · Edgewater, MDThe pilot's excessive maneuver at a low altitude, and the flight instructor's inadequate supervision of the pilot, which resulted in an inadvertent stall/spin.Jun 15, 1997 · N93908 · DestroyedNTSB FTW97LA219Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Biggers, ARThe total blockage of a fuel line by a silicone rubber contaminant which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.Jun 13, 1997 · N6133X · Destroyed