NTSB investigations, SC

193 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.\"eventStateOrRegion\" = 'SC' AND c.\"eventCountry\" = 'USA'
    AND 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 ATL83FA093Accident · Minor injuriesField investigationFinal reportPiper PA-28-140 · Johns Island, SCThe acft crash landed in a swamp as the pilot tried to return to the arpt during a forced landing. The engine lost powerduring takeoff climb at about 300 ft AGL. Witnesses said the acft was trailing black smoke as it departed. During the last annual…Jan 30, 1983 · N4548R · Substantial damageNTSB ATL83FA067Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Johns Isle, SCThe plt stated both engs lost power after takeoff & the acft ditched in the stono river. No preimpact failure and/or malfunction of either eng could be found. The plt did not hold any airman certificate.Dec 19, 1982 · N713BT · DestroyedNTSB ATL83LA066Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Anderson, SCAfter takeoff, while several hundred feet in the air, the engine backfired & quit. The plt was able to turn around & head back toward the arpt, but could not quite reach the rwy. The acft landed 1,000 ft short of the rwy, hit a ditch & flipped over. The plt…Dec 16, 1982 · N61857 · Substantial damageNTSB ATL83FLG02Accident · Serious injuriesFinal reportPiper 32RT-300T · Hilton Head, SCThe aircraft collided with trees after takeoff. The pilot stated he held 80 or 90 KTS indicated and started what he thought was a normal climb. During gear retraction, the aircraft hit the trees.Dec 5, 1982 · N36447 · DestroyedNTSB ATL83LA043Accident · No injuriesLimited investigationFinal reportAerosport Champ · Spartanburg, SCThe aircraft collided with trees during a forced landing following an engine failure during climbout after takeoff. The engine developed full power during runup and takeoff. During a left turn to crosswind the engine began to lose power andcontinued to lose…Nov 22, 1982 · N27SS · Substantial damageNTSB ATL83LA011Accident · No injuriesLimited investigationFinal reportTomcat MK68 · Cope, SCBefore starting his takeoff from a trailer, the pilot failed to insure that his helper had released the right rear tiedown chain. During lift-off, the helicopter raised the trailer about 2 to 3 ft before the chain. Broke. Simultaneously, the helicopter was…Oct 15, 1982 · N9080T · DestroyedNTSB ATL82DA232Accident · No injuriesFinal reportCessna 150 · Horrell Hill, SCPilot making touch and go landings at private airstrip. After takeoff aircraft would not maintain altitude. Pilot made an emergency landing in a bean field. Aircraft flipped over. Pilot forgot to retract full flaps and carb heat was on during takeoff.Aug 8, 1982 · N18019 · Substantial damageNTSB ATL82DA222Accident · Serious injuriesFinal reportBeech C23 · Greer, SCThe student pilot had received about three hours in this make and model of aircraft. After about 45 minutes of dual instruction, he was indorsed for solo flight, the instructor deplaned, and the student took off to fly locally. About 25 minutes later, the…Aug 1, 1982 · N1831F · Substantial damageNTSB ATL82FA184Accident · 1 fatalField investigationFinal reportCessna 152 · Charleston, SCPlt made steep turn after takeoff & stalled. Acft came to rest on the arpt about 1500 ft from the point where the takeoff run was initiated & about 200 ft north of rwy 9. It was necessary for the plt to be airborne by 0700 in order for him to make his first…Jul 13, 1982 · N6234L · DestroyedNTSB ATL82FLG08Accident · No injuriesFinal reportMooney M-20J · Hilton Head, SCDuring takeoff at about 200 to 300 feet the engine malfunctioned and the pilot elected to make a gear up landing. Investigation revealed that the left wing fuel tank contained over a quart of water. Water and a red substance similar in appearance to tank…Jan 6, 1982 · N201NH · Substantial damageNTSB ATL82FA024Accident · 2 fatalClosedCessna 210N · Rock Hill, SCDec 1, 1981 · N5339Y · DestroyedNTSB ATL81DLG19Accident · No injuriesClosedAir Tractor AT-301 · Manning, SCAug 6, 1981 · N4358S · Substantial damageNTSB ATL81DLG10Accident · No injuriesClosedCessna 150 · North, SCJun 10, 1981 · N5679G · Substantial damageNTSB ATL81FLG09Accident · Serious injuriesClosedSchempp STD CS · Chester, SCApr 24, 1981 · N15PE · DestroyedNTSB ATL81FLG07Accident · No injuriesClosedCessna 150H · Greer, SCNov 30, 1980 · N7075S · Substantial damageNTSB ATL80FLG11Accident · Minor injuriesClosedCessna 120 · Union, SCMay 31, 1980 · N72812 · Substantial damageNTSB MIA80FA008Accident · 5 fatalClosedPiper PA-31 · Greenville, SCNov 2, 1979 · N66893 · DestroyedNTSB MIA79FA129Accident · No injuriesClosedBeech D18S · Sumter, SCSep 28, 1979 · N646B · Substantial damageNTSB MIA79FLG32Accident · No injuriesClosedCallair A-9 · Johnsonville, SCSep 11, 1979 · N3582G · DestroyedNTSB MIA79FLG24Accident · No injuriesClosedCessna 421B · Trenton, SCJun 21, 1979 · N41022 · Substantial damageNTSB MIA79FA085Accident · 1 fatalClosedCessna 182P · Eastover, SCMay 17, 1979 · N78744 · DestroyedNTSB MIA79FLG14Accident · No injuriesClosedCessna 150 · Mccoll, SCDec 23, 1978 · N3010S · Substantial damageNTSB MIA79FA028Accident · 1 fatalClosedCessna 182 · Union, SCDec 5, 1978 · N7535N · DestroyedNTSB MIA79FLG01Accident · No injuriesClosedCessna 182P · Hilton Head, SCOct 10, 1978 · N7419Q · Substantial damageNTSB MIA78FLG39Accident · Minor injuriesClosedPiper PA-15 · Isle Of Palms, SCSep 18, 1978 · N4390H · Substantial damageNTSB MIA78DLG36Accident · No injuriesClosedBell 47D1 · Summerville, SCAug 26, 1978 · N4116A · Substantial damageNTSB MIA78FLG34Accident · No injuriesClosedBell 47G · Murrels Inlet, SCAug 16, 1978 · N25802 · Substantial damageNTSB MIA78FLG30Accident · No injuriesClosedMooney M20E · Lexington, SCJul 27, 1978 · N6992U · Substantial damageNTSB MIA78FLG29Accident · Minor injuriesClosedCessna 182P · Ehrhardt, SCJul 22, 1978 · N9437M · Substantial damageNTSB MIA78FLG25Accident · Serious injuriesClosedPiper J3C · Harleyville, SCJun 21, 1978 · N70998 · Substantial damageNTSB MIA78FLG23Accident · No injuriesClosedGrumman G-164B · Lane, SCJun 14, 1978 · N6648Q · DestroyedNTSB MIA78FLG21Accident · Serious injuriesClosedCessna 150L · Columbia, SCJun 12, 1978 · N6751G · DestroyedNTSB UNK78X0100Accident · No injuriesClosedCessna 188B · St Matthews, SCOct 1, 1977 · N53354 · Substantial damageNTSB MIA77FLG32Accident · No injuriesClosedPiper PA-25 · Belton, SCAug 13, 1977 · N6370Z · Substantial damageNTSB MIA77FA076Accident · 2 fatalClosedChampion 7ECA · Greenville, SCAug 7, 1977 · N9103L · DestroyedNTSB MIA77FLG23Accident · Serious injuriesClosedCessna 140 · Isle Of Palms, SCJul 17, 1977 · N2418N · DestroyedNTSB MIA77FLG08Accident · No injuriesClosedAero Comdr 100 · Georgetown, SCJan 23, 1977 · N4046X · DestroyedNTSB MIA76FLG17Accident · Serious injuriesClosedBantam W-3 · Georgetown, SCSep 21, 1975 · N422 · DestroyedNTSB MIA76DLG10Accident · Minor injuriesClosedCessna 172H · Nichols, SCAug 19, 1975 · N3292L · Substantial damageNTSB MIA75FLG40Accident · No injuriesClosedBoeing A75N1 · Fairfax, SCJun 30, 1975 · N63624 · Substantial damageNTSB MIA75AM082Accident · 1 fatalClosedPiper PA-22 · Conway, SCMay 23, 1975 · N5723Z · DestroyedNTSB MIA75AM016Accident · 6 fatalClosedBeech A100 · Hilton Head Is, SCApr 26, 1975 · N700SP · DestroyedNTSB MIA76FLG31Accident · No injuriesClosedAero Comdr 200-D · Charlestown, SCApr 10, 1975 · N202GM · Substantial damageNTSB MIA75FLG28Accident · No injuriesClosedCessna 177 · Blacksburg, SCMar 31, 1975 · N2995X · Substantial damageNTSB MIA75FLG22Accident · No injuriesClosedPiper PA-28R · Myrtle Beach, SCFeb 7, 1975 · N5107S · Substantial damageNTSB MIA75DLG14Accident · No injuriesClosedPiper PA-28 · Edisto Beach, SCSep 28, 1974 · N56543 · Substantial damageNTSB MIA75FLG13Accident · Serious injuriesClosedLuscombe 8E · Chester, SCSep 12, 1974 · N2845K · Substantial damageNTSB MIA75FLG06Accident · No injuriesClosedCessna A188B · Fairfax, SCJul 25, 1974 · N8438G · Substantial damageNTSB MIA74FLG05Accident · No injuriesClosedPiper J3L · Landrum, SCJul 17, 1974 · N32966 · Substantial damageNTSB MIA74FLGI7Accident · Minor injuriesClosedCessna 172E · Beaufort, SCApr 15, 1974 · N5796T · Substantial damage