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 DEN06CA123Accident · Serious injuriesData collectionFinal reportParsons JN4-D Jenny Replica · Crossville, TNA loss of control in flight due to a disconnected rudder control cable. Contributing to the accident was the pilot's inability to control the roll.Sep 9, 2006 · N5309 · Substantial damageNTSB DFW06LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Newton, MSThe total loss of engine power due to fuel contamination. A factor was the pilot's inadequate preflight inspection.Sep 7, 2006 · N330PL · DestroyedNTSB LAX06CA286Accident · Serious injuriesData collectionFinal reportAgeton MXL Sport II · Marana, AZThe loss of engine power for undetermined reasons.Sep 6, 2006 · N503RX · Substantial damageNTSB MIA06LA135Accident · 2 fatalLimited investigationFinal reportLuscombe 8A · Ocala, FLThe pilot's failure to maintain airspeed during initial climb.Sep 3, 2006 · N71927 · Substantial damageNTSB LAX06FA283Accident · 3 fatalField investigationFinal reportCessna 337G · Prescott, AZA loss of power in the rear engine for undermined reasons. Contributing to the accident was the pilot's failure to promptly and correctly configure the airplane for single engine flight, and to maintain an adequate airspeed, which resulted in a stall mush.Sep 2, 2006 · N1893M · DestroyedNTSB LAX06CA282Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Auburn, CAthe pilot's failure to comply with weight and balance limitations and failure to attain an adequate airspeed, which resulted in a stall and loss of control.Sep 2, 2006 · N4813T · Substantial damageNTSB DFW06FA205Accident · 1 fatalField investigationFinal reportBeech BE95 A-55 · McGregor, TXThe pilot's failure to maintain airspeed resulting in a stall and loss of control of the airplane.Sep 2, 2006 · N181Y · DestroyedNTSB ANC06CA128Accident · No injuriesData collectionFinal reportPiper PA-18 · Aniak, AKThe pilot's inadequate compensation for wind conditions during the takeoff initial climb, which resulted in a loss of control and in-flight collision with terrain. A factor contributing to the accident was a windshear.Sep 1, 2006 · N1858A · Substantial damageNTSB SEA06LA169Accident · 1 fatalLimited investigationFinal reportCurtiss-Wright Travel Air C-4000 · Elmira, ORThe pilot's failure to maintain an airspeed above stall speed (Vs) while turning to avoid trees along the side of the runway during the initial climbout after takeoff. Factors include, a variable wind that became a tailwind, and trees growing near the side of…Aug 27, 2006 · N6298 · Substantial damageNTSB ANC06CA123Accident · Minor injuriesData collectionFinal reportFrisby CH801 · Palmer, AKThe pilot's inadequate compensation for wind conditions, which resulted in an in-flight collision with trees during takeoff. Factors associated with the accident were wind gusts, and trees bordering the airstrip.Aug 27, 2006 · N801ZA · Substantial damageNTSB DEN06LA118Accident · 1 fatalLimited investigationFinal reportScheibe Flugzeugbau SF-24A Motorspatz · Wichita, KSThe pilot's failure to maintain aircraft control. Factors were the low airspeed and the inadvertent stall and spin.Aug 25, 2006 · N41FA · DestroyedNTSB SEA06LA166Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Auburn, WAThe failure of the landing gear's normal retraction/extension assembly due to an overload condition.Aug 19, 2006 · N6249P · Substantial damageNTSB LAX06LA267Accident · Serious injuriesLimited investigationFinal reportBeach Baby Ace C · Fallon, NVThe pilot's failure to obtain and maintain an adequate airspeed that resulted in a stall/mush.Aug 19, 2006 · N86677 · Substantial damageNTSB ANC06LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Chugiak, AKThe pilot's failure to properly preflight the airplane and remove all water from the fuel system, which resulted in a loss of engine power during takeoff/initial climb, and subsequent loss of control. Factors associated with the accident are the pilot's…Aug 19, 2006 · N5280H · Substantial damageNTSB LAX06LA270Accident · No injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G109 · Glendale, AZThe failure and separation of one propeller blade for undetermined reasons.Aug 18, 2006 · N39262 · Substantial damageNTSB LAX06LA265Accident · Minor injuriesLimited investigationFinal reportCessna A150M · Red Bluff, CAThe pilot's improper mixture leaning technique, which lead to thermal damage and seizure of the exhaust valves.Aug 18, 2006 · C-GOBC · Substantial damageNTSB LAX06LA264Accident · 1 fatalLimited investigationFinal reportSchifferer Breezy RLU-1 · Ramona, CAThe pilot's failure to maintain adequate airspeed during the takeoff climb, that resulted in a stall/spin.Aug 17, 2006 · N577JS · Substantial damageNTSB LAX06FA258Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Saipan, SarkA loss of engine power during the initial climb due to fuel starvation resulting from the pilot's improper fuel selector valve position selection and his failure to select a tank containing an adequate fuel supply. Contributing to the accident was the high…Aug 11, 2006 · N4509T · DestroyedNTSB NYC06LA197Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Bellefonte, PAImproper maintenance of the throttle linkage, which resulted in a lack of engine power during takeoff. Factors were the pilot's premature retraction of the flaps, an improper elevator trim setting, a high gross takeoff weight, and a high density altitude;…Aug 6, 2006 · N9227U · Substantial damageNTSB ANC06CA108Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tyonek, AKThe pilot's failure to maintain a minimum airspeed to avoid a stall, which resulted in a loss of control and a collision with terrain during takeoff initial climb. A factor associated with the accident was an inadvertent stall.Aug 6, 2006 · N57778 · Substantial damageNTSB CHI06FA215Accident · No injuriesField investigationFinal reportManarin/Johnson Lancair IVP · Omaha, NEThe selection of an unsuitable landing area by the pilot of the other airplane, and his failure to maintain separation during landing.Aug 4, 2006 · N330RM · 2 aircraft · Substantial damageNTSB CHI06CA237Accident · No injuriesData collectionFinal reportSpittler Rans S-16 · Plattsmouth, NEA loss of engine power due to fuel starvation which resulted from a binding within the fuel servo. A factor associated with the accident was the high vegetation that was encountered during the forced landing.Aug 4, 2006 · N116GS · Substantial damageNTSB LAX06CA252Accident · No injuriesData collectionFinal reportCessna 172M · San Andreas, CAthe student pilot's improper soft-field takeoff technique and failure to obtain and maintain an adequate airspeed, which resulted in a stall mush. The certificated flight instructor's inadequate supervision of the maneuver was also causal.Aug 3, 2006 · N12626 · Substantial damageNTSB ATL06LA115Accident · 1 fatalLimited investigationFinal reportMcWhorter Skystar Vixen · Peachtree City, GAThe pilot's failure to maintain airspeed while maneuvering to reverse his direction following loss of engine power shortly after takeoff resulting in an inadvertent stall and collision with the ground. A factor in the accident was a loss of engine power for…Aug 3, 2006 · N93TR · Substantial damageNTSB ATL06LA114Accident · Minor injuriesLimited investigationFinal reportBeech D45 · Bainbridge, GAThe improper maintenance installation of the fuel inlet line by other maintenance personnel resulting in a partial loss of engine power after takeoff due to fuel starvation.Aug 2, 2006 · N342MN · Substantial damageNTSB ANC06LA109Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 MK.1 · Anaktuvuk Pass, AKThe pilot's failure to abort the takeoff at his predetermined reference point, which resulted in a collision with the shore during takeoff-initial climb, and structural damage to the airplane.Aug 2, 2006 · N4040W · Substantial damageNTSB ANC06LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Anchorage, AKThe possible loss of engine power during takeoff/initial climb for an unknown reason, which resulted in a forced landing in rough terrain and a nose over.Jul 31, 2006 · N738LJ · Substantial damageNTSB NYC06LA187Accident · 1 fatalLimited investigationFinal reportBurleigh SeaRey · Ringoes, NJThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall. Factors included a partial loss of engine power for undetermined reasons.Jul 30, 2006 · N4293S · DestroyedNTSB ATL06CA113Accident · No injuriesData collectionFinal reportCessna 208 · Riceboro, GAThe pilot's failure to achieve the proper takeoff distance on a short water runway resulting in an in-flight collision with a berm and a marshy area on initial takeoff climb.Jul 29, 2006 · N415GA · Substantial damageNTSB NYC06LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Blacksburg, VAA partial loss of engine power for undetermined reasons, which resulted in a forced landing after takeoff, and subsequent collision with trees.Jul 27, 2006 · N43945 · Substantial damageNTSB DEN06CA105Accident · No injuriesData collectionFinal reportSchweizer G-164B · Joes, COA loss of engine power due to the failure of the supercharger. Contributing to the accident was a lack of suitable terrain for a forced landing.Jul 27, 2006 · N8459K · Substantial damageNTSB CHI06CA201Accident · Minor injuriesData collectionFinal reportBeech A36 · Mason, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush on takeoff. Factors associated with the accident were the building and vehicles that were contacted.Jul 26, 2006 · N9205Q · Substantial damageNTSB ATL06CA112Accident · No injuriesData collectionFinal reportCessna 170B · Griffin, GAAn in-flight encounter with weather on initial take off climb resulting in a loss of directional control and collision with the ground.Jul 24, 2006 · N4556C · Substantial damageNTSB CHI06CA194Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Marine City, MIA loss of engine power due to the partial blocked carburetor fuel screen which resulted in partial fuel starvation and the pilot's failure to maintain adequate airspeed during the forced landing which resulted in an inadvertent stall. A factor associated with…Jul 20, 2006 · N1026K · Substantial damageNTSB MIA06LA125Accident · Minor injuriesLimited investigationFinal reportDouglas DC-3 · St. ThomasThe airplane's inability to maintain altitude for undetermined reasons, following a loss of power from the left engine.Jul 19, 2006 · N782T · Substantial damageNTSB DFW06FA187Accident · 2 fatalField investigationFinal reportCessna 172N · Petal, MSThe pilot's improper use of flaps, which resulted in an impact with trees during takeoff-initial climb.Jul 19, 2006 · N738KE · DestroyedNTSB MIA06LA122Accident · 1 fatalLimited investigationFinal reportCessna 320E · Wimauma, FLPilot's inadequate preflight planning and exceeding the weight and balance limitations of the airplane.Jul 16, 2006 · N227DG · DestroyedNTSB LAX06LA232Accident · Minor injuriesLimited investigationFinal reportCessna R172K II · HagatnaThe failure of the number four connecting rod during takeoff-initial climb.Jul 15, 2006 · N1209V · Substantial damageNTSB DEN06LA099Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Parker, COthe flight instructor's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and subsequent impact with terrain. Contributing factors were the high density altitude, rising terrain, and improper in-flight planning.Jul 15, 2006 · N85086 · DestroyedNTSB CHI06LA190Accident · 1 fatalLimited investigationFinal reportArmpriest Breezy · South Haven, MIThe inadvertent stall by pilot during climb following propeller blade damage from the compartment door separation after takeoff. The low altitude and airspeed not maintained by the pilot were additional causes. Contributing factors were the compartment door…Jul 15, 2006 · N316DA · Substantial damageNTSB LAX06LA230Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAa loss of engine power due to the failure of maintenance personnel to tighten the top spark plugs, and install the leads for the ignition harness to the top spark plugs.Jul 14, 2006 · N25512 · Substantial damageNTSB CHI06LA191Accident · No injuriesLimited investigationFinal reportCessna 120 · Laporte, MNThe inadequate preflight planning/preparation by the pilot and the loss of engine power due to fuel exhaustion during takeoff. A contributing factor was the runway marker.Jul 14, 2006 · N3089N · Substantial damageNTSB DEN06LA097Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Holcomb, KSthe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jul 13, 2006 · N4422S · Substantial damageNTSB DFW06CA182Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Marvell, ARThe pilot's failure to maintain clearance with terrain during takeoff.Jul 12, 2006 · N90614 · Substantial damageNTSB ANC06CA088Accident · No injuriesData collectionFinal reportCessna 206F · Fairbanks, AKThe pilot's inadequate weather evaluation, which resulted in the airplane encountering a severe downdraft during takeoff initial climb, and an in-flight collision with terrain. Factors associated with the accident were a thunderstorm and a downdraft.Jul 12, 2006 · N8440Q · Substantial damageNTSB LAX06LA228Accident · No injuriesLimited investigationFinal reportPalmer Seawind 3000 · Havasu Lake, CAan electrical fire due to improper wiring of the electrical system by other maintenance personnel.Jul 11, 2006 · N8025Q · DestroyedNTSB NYC06CA181Accident · Serious injuriesData collectionFinal reportCarlson Sparrow · New Galilee, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and impact with terrain. A factor in the accident was the partial loss of engine power for undetermined reasons.Jul 10, 2006 · UNREG · Substantial damageNTSB NYC06LA129Accident · No injuriesLimited investigationFinal reportChevrier, Armand J-3K · Charlotte, VTA complete loss of engine power on takeoff for undetermined reasons, which resulted in a forced landing.Jul 7, 2006 · N43432 · Substantial damageNTSB NYC06FA169Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Block Island, RIThe pilot's inadequate preflight decision making and his failure to maintain terrain clearance during departure. Contributing, were low ceilings, rain, and thunderstorms.Jul 5, 2006 · N5012S · Substantial damageNTSB DFW06FA173Accident · 1 fatalField investigationFinal reportCessna 180K · Owasso, OKThe pilot's selection of unsuitable terrain, a residential street, for both takeoff and landing, which resulted in a collision with a static wire and terrain during takeoff-initial climb.Jul 2, 2006 · N1SE · Substantial damage