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 NYC94LA138Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Waynesburg, OHThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. A factor was a tailwind.Jul 24, 1994 · N601RF · Substantial damageNTSB NYC94FA134Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Minford, OHThe pilot's failure to follow the published instrument departure procedure. A factor in the accident were the weather conditions.Jul 24, 1994 · N33468 · DestroyedNTSB FTW94LA250Accident · No injuriesLimited investigationFinal reportLet L-23 · Stillwater, OKThe certified flight instructor's failure to maintain flying speed.Jul 24, 1994 · N923SB · Substantial damageNTSB CHI94LA243Accident · Serious injuriesLimited investigationFinal reportInman Acro Sport 1 · Albert Lea, MNthe pilot's failure to make a precautionary landing on the remaining runway. Factors in the accident were the blocked fuel injector and inadvertent stall.Jul 23, 1994 · N869M · Substantial damageNTSB CHI94LA240Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Wymore, NEfailure of the fuel injector pump due to improper assembly.Jul 23, 1994 · N9140G · DestroyedNTSB ANC94LA093Accident · No injuriesLimited investigationFinal reportCessna 150 · Melozzi Hot Sps, AKThe pilot's premature lift off below the stall speed of the airplane.Jul 23, 1994 · N3947U · Substantial damageNTSB FTW94LA252Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Waller, TXThe pilot's failure to maintain proper clearance during takeoff.Jul 22, 1994 · N70580 · Substantial damageNTSB FTW94LA244Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Englewood, COAn inadvertent stall. Factors were the airplane's maximum gross weight and climb capability were exceeded, and a high density altitude.Jul 22, 1994 · N6086R · Substantial damageNTSB NYC94LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Chatham, MAThe pilot's failure to see and avoid the birds. The presence of the birds at the airport was a contributing factor.Jul 21, 1994 · N76090 · Substantial damageNTSB FTW94LA249Accident · No injuriesLimited investigationFinal reportCessna 140 · Archer City, TXFuel contamination induced power loss. Factors were the improper refueling techniques used by the pilot and the lack of suitable terrain onto which a forced landing could be executed.Jul 21, 1994 · N2260V · Substantial damageNTSB MIA94FA181Accident · Serious injuriesField investigationFinal reportBellanca 14-9 · Lakeland, FLThe improper modification of the engine driven fuel pump mechanical arm by an unknown person, restricting the fuel systems ability to supply fuel to the engine at full power.Jul 20, 1994 · N25310 · DestroyedNTSB CHI94LA234Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Traverse, MIpoor preflight planning and preparation by the pilot for not calculating the weight and balance of his airplane before departure. Factors associated with the accident were the airplane's weight and balance was exceeded, and the pilot's lack of recent…Jul 20, 1994 · N8255N · DestroyedNTSB NYC94LA131Accident · No injuriesLimited investigationFinal reportDonovan DER Kricket 17K-1 · Brockport, NYThe loss of engine power as a result of a sticking valve in the carburetor due to dirt contamination.Jul 19, 1994 · N41MD · Substantial damageNTSB LAX94FA292Accident · 1 fatalField investigationFinal reportCessna 414 · Taft, CAThe pilot's inadequate preflight planning/preparation and selection of the wrong runway for takeoff. Factors related to the accident were: the uphill slope of the runway, tailwind, high density altitude, and failure of the pilot to correctly configure the…Jul 19, 1994 · N414RH · DestroyedNTSB FTW94LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-501 · Marianna, ARA premature liftoff. Factors were the tall, wet grass and a tail wind component.Jul 19, 1994 · N6073J · DestroyedNTSB ATL94LA143Accident · No injuriesLimited investigationFinal reportCessna 182F · Raeford, NCAn engine power loss due to water in the fuel system, and the pilot's inadequate preflight of the aircraft. A factor was the presence of trees at the forced landing area.Jul 19, 1994 · N3513U · Substantial damageNTSB LAX94LA290Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Banning, CAthe pilot's failure to obtain and maintain an appropriate climb airspeed after lift-off which resulted in an inadvertent stall mush condition. Factors in the accident were the high-density altitude condition, the pilot's selection of a runway with an uphill…Jul 18, 1994 · N4487X · DestroyedNTSB LAX94FA289Accident · 4 fatalField investigationFinal reportCessna 172M · Sacramento, CAthe failure of the pilot to maintain adequate airspeed while maneuvering after takeoff and his failure to retract the flaps prior to departure. A factor in this accident was the pilot's lack of recent experience.Jul 17, 1994 · N1259U · DestroyedNTSB NYC94FA128Accident · 4 fatalField investigationFinal reportCessna K172R · Tremont City, OHFailure of the pilot to maintain control of the airplane. A factor related to the accident was: the pilot's lack of experience in the type of operation.Jul 16, 1994 · N1124V · DestroyedNTSB LAX94LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Elko, NVthe pilots attempted takeoff with a strong and gusty tailwind.Jul 16, 1994 · N6785W · Substantial damageNTSB CHI94LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kankakee, ILThe pilot's poor preflight planning preparation by the improper loading of the airplane.Jul 16, 1994 · N7079R · Substantial damageNTSB ATL94LA139Accident · Minor injuriesLimited investigationFinal reportTaylorcraft 15A · Dobson, NCThe vehicle driver's failure to remain clear of a runway in use.Jul 15, 1994 · N70BL · Substantial damageNTSB NYC94LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Lancaster, OHThe loss of engine power for undetermined reasons.Jul 13, 1994 · N800CE · DestroyedNTSB CHI94LA229Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Watersmeet, MIthe pilot's failure to maintain control of the airplane, and his inadequate preflight planning and preparation. Factors associated with the accident were the fog and the trees.Jul 13, 1994 · N6579G · DestroyedNTSB NYC94LA120Accident · No injuriesLimited investigationFinal reportFreeman PRO-STAR II · Sanford, METhe pilot's failure to maintain airspeed resulting in an inadvertent stall and collision with the terrain.Jul 12, 1994 · N43579 · Substantial damageNTSB ATL94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, GAThe pilot's inadequate aircraft pre-flight inspection, his failure to abort the takeoff, and his failure to maintain airspeed that resulted in a stall. A factor was the inadequate aircraft inspection that did not identify the worn fuel cell caps.Jul 11, 1994 · N3381P · Substantial damageNTSB LAX94LA279Accident · Minor injuriesLimited investigationFinal reportFrank M. Kopecky Quickie · Camarillo, CAthe failure or malfunction of the engine ignition system.Jul 10, 1994 · N8036W · Substantial damageNTSB SEA94FA174Accident · 3 fatalField investigationFinal reportPiper PA-22-135 · Leavenworth, WAThe pilot's inadequate preflight planning/preparation. Factors related to the accident were: high density altitude, the runway condition (with areas of soft or uneven terrain and tall grass), and obstructions (trees) near the departure end of the runway.Jul 9, 1994 · N3645A · DestroyedNTSB ATL94LA133Accident · Minor injuriesLimited investigationFinal reportPilatus PC-6/B1-H2 · Raeford, NCThe improper inspection of the aircraft by company maintenance personnel, which resulted in an unsafetied and disconnected fuel control arm.Jul 9, 1994 · N111FX · DestroyedNTSB ATL94LA132Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Tifton, GAThe pilot's failure to follow the aircraft checklist, resulting in an attempted takeoff with the elevator trim improperly set. A factor was the trees at the perimeter of the airstrip.Jul 8, 1994 · N9583G · DestroyedNTSB SEA94FA168Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Arco, IDThe pilot's diversion of his attention of controlling the airplane which led to his failure to maintain adequate airspeed. A factor which contributed to the accident was the pilot's failure to assure that the cabin door was closed and locked.Jul 7, 1994 · N5919Y · Substantial damageNTSB FTW94LA225Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · England, ARThe inadvertent stall during initial takeoff climb. A factor was the tall grass.Jul 7, 1994 · N1382T · Substantial damageNTSB CHI94FA222Accident · 4 fatalField investigationFinal reportBeech A36 · Wichita, KSthe pilot's attempt to take off into known adverse weather and the subsequent stall. Factors were the thunderstorm, the tailwind, and the excessive airplane gross weight and aft center of gravity.Jul 7, 1994 · N107JT · DestroyedNTSB CHI94DEV01Accident · Minor injuriesFinal reportHucke, Ronald L. PARSON-2P · Monmouth, ILThe pilot's failure to maintain flying speed which resulted in a stall/mush.Jul 5, 1994 · N589RH · Substantial damageNTSB LAX94LA273Accident · Minor injuriesLimited investigationFinal reportAdams Thorpe T-18 · Stockton, CAA vapor lock induced engine failure due to inadequate thermal shielding of the fuel pump and lines. Soft terrain in the landing area was a factor.Jul 3, 1994 · N51079 · Substantial damageNTSB LAX94FA272Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · So. Lake Tahoe, CAthe pilot's failure to maintain adequate airspeed during initial climb under high-density altitude weather conditions and a resultant inadvertent stall/spin. Factors which contributed to the accident were the pilot's overconfidence in his personal ability,…Jul 3, 1994 · N4321N · DestroyedNTSB ATL94LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Autaugaville, ALThe pilot's inadequate preflight planning, in that he did not properly evaluate the condition of the runway prior to takeoff, and his failure to abort the takeoff when adequate acceleration was not observed. Factors were the high vegetation (grass) on the…Jul 3, 1994 · N3659D · Substantial damageNTSB ATL94LA129Accident · No injuriesLimited investigationFinal reportCessna 152 · Chamblee, GAThe student pilot's improper use of the rudder, and his failure to maintain directional control during takeoff.Jul 3, 1994 · N67524 · Substantial damageNTSB SEA94LA165Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mccall, IDThe pilot's inadequate preflight planning and attempted operation which exceeded the performance capability of the airplane. Factors include his overconfidence in the aircraft's ability.Jul 1, 1994 · N24201 · Substantial damageNTSB NYC94LA104Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenville, METhe premature retraction of the wing flaps by the pilot after takeoff, resulting in a loss of lift and collision with trees.Jul 1, 1994 · N5482K · Substantial damageNTSB FTW94LA219Accident · No injuriesLimited investigationFinal reportCameron V-77 · Littleton, COA total failure of the balloon's heater system (pilot light) for undetermined reasons. A factor was unsuitable terrain on which to make a forced landing.Jul 1, 1994 · N748CB · Substantial damageNTSB CHI94LA227Accident · No injuriesLimited investigationFinal reportCessna 441 · Flint, MIAn inadequate preflight inspection of the airplane by the pilot. Factors associated with this accident were unlatched nose cargo doors and the pilot's failure to extend the landing gear.Jul 1, 1994 · N815MC · Substantial damageNTSB CHI94LA216Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Shiocton, WIthe pilot's failure to maintain Vso during takeoff. Factors related to the accident was the disregard for performance data and trees.Jul 1, 1994 · N7472X · DestroyedNTSB LAX94LA269Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Schurz, NVthe pilot's inability to maintain an adequate airspeed in the takeoff initial climb due to an encounter with a windshear.Jun 30, 1994 · N733AA · DestroyedNTSB FTW94LA216Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Searcy, ARThe total loss of engine power due to water contamination of the fuel system. A factor was the lack of suitable terrain available to the pilot for the forced landing and his inadequate preflight inspection.Jun 30, 1994 · N526Y · Substantial damageNTSB FTW94LA215Accident · No injuriesLimited investigationFinal reportPiper J4A · Granite Shoals, TXFuel system starvation due to the pilot's failure to secure the engine fuel primer. A factor was the lack of suitable terrain for the forced landing.Jun 30, 1994 · N30342 · Substantial damageNTSB LAX94LA267Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Wickenburg, AZLoss of engine power for an unknown reason, and failure of the pilot to maintain airspeed, which resulted in an inadvertent stall and collision with the ground.Jun 28, 1994 · N5512N · Substantial damageNTSB CHI94FA212Accident · 3 fatalField investigationFinal reportBeech A35 · Lakeville, MNThe jamming of the elevator control which resulted in the pilot's inability to control the pitch attitude of the airplane. The airplane encountered a stall-spin and impacted level terrain in an uncontrolled descent.Jun 28, 1994 · N3042V · DestroyedNTSB SEA94LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Prineville, ORThe pilot's inadequate compensation for wind conditions. A factor was gusty wind conditions.Jun 27, 1994 · N3992P · Substantial damageNTSB FTW94LA211Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dumas, ARThe pilot's failure to establish the proper airspeed before beginning a turn after takeoff.Jun 25, 1994 · N4222P · Destroyed