NTSB investigations, MA

142 cases where the phase of flight was Takeoff.

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\" = 'MA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 300)
  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 NYC90LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orange, MAFailure of the pilot to maintain runway alignment while aborting the takeoff. The crosswind, turbulence, and snowbank were related factors.Feb 22, 1990 · N47644 · Substantial damageNTSB NYC89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA22-150 · Uxbridge, MAImproper maneuvering shortly after takeoff from a private grass strip of marginal length for the caliber of acft being operated. A wind change added to the already exacting conditions.Jun 3, 1989 · N9965D · DestroyedNTSB NYC89IA028Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Boston, MAFailure of the local controller to detect the red t on the departure strip on PRE659 when he cleared him into position and hold. Factors related to the accident were: darkness and the lack of positive coordination between the ground controller and local…Nov 14, 1988 · N555PE · 2 aircraft · Minor damageNTSB NYC88LA213Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Plymouth, MAThe acft was taking off on a hard packed, grassy area beside a paved rwy with a 12 kt headwind. After the tail was raised, and at a point 900 ft from the beginning of the roll, the acft suddenly nosed over. Examination of the broken right main landing gear…Aug 10, 1988 · N2232K · Substantial damageNTSB NYC88LA201Accident · No injuriesLimited investigationFinal reportBell 206B · Plymouth, MAA loss of power to the engine because the fuel control was not properly adjusted and collision with terrain due to an unsuitable landing area.Jul 13, 1988 · N543CC · Substantial damageNTSB NYC87LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stow, MAThe pilot was on takeoff roll when he decided to abort. He stated that he felt the engine was not developing adequate power and the airspeed was not up to required takeoff speed. The aircraft continued off the end of the runway and inverted in swampy soil.Sep 27, 1987 · N4332N · Substantial damageNTSB NYC86LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsfield, MAThe Cessna 152 was making a touch and go. The student pilot reported the landing was good and when he applied power, the aircraft veered left off the runway, struck a ditch and flipped over. The pilot was uninjured and the aircraft received substantial…Mar 29, 1986 · N49107 · Substantial damageNTSB NYC85LA193Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Worcester, MAThe instructor (CFI) & student were practicing touch-&-go landings. On the 4th landing, the apch & touchdown were made with full flaps extended. The CFI began to retract the flaps while the student applied full power for takeoff. The acft became airborne &…Jul 24, 1985 · N999RH · Substantial damageNTSB NYC85LA051Accident · No injuriesLimited investigationFinal reportBeech B58 · New Bedford, MAThe acft experienced a gear collapse during landing. During the first landing and takeoff the plt noticed the left main gear began to collapse. The takeoff was continued and two passes were performed in front of the ATC twr. Twr personnel advised that the…Jan 12, 1985 · N17824 · Substantial damageNTSB NYC84LA220Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Orange, MAThe plt stated that he was giving local sightseeing flights. He indicated that a 'wide' gentleman and a 'moderate' size gentleman boarded the acft. The plt moved the throttle to ensure clearance but found one of the pax restricted the movement slightly. The…Jun 23, 1984 · N32127 · Substantial damageNTSB NYC84LA188Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Pepperell, MAThe glider was attempting a tow-launch when the right wing tip struck a clump of high grass. The glider yawed right and collided with the asphalt rwy, breaking the fuselage and collapsing the landing gear. The pilot stated that the grass was too high for a…May 26, 1984 · N245JD · Substantial damageNTSB NYC84LA175Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chatham, MADirectional control was lost during the takeoff ground roll with a slight quartering tailwind. Power was reduced but the acft traveled off the left side of the rwy where it collided with a tree.May 21, 1984 · N9075H · Substantial damageNTSB NYC82FNA14Accident · 1 fatalFinal reportThurston Teal TSC-1A · Methuen, MAThe pilot was practicing takeoffs and landings on a river in an amphibian aircraft. After a landing, the pilot commenceda high speed taxi takeoff. When violent shaking started the pilot reduced power, pulled back the stick, and landed. The aircraft nosed…May 30, 1982 · N2002T · Substantial damageNTSB NYC82FNA11Accident · Minor injuriesFinal reportVarga 2150A · Marlboro, MASnow had fallen on the evening before the accident. The runway was covered with one inch of snow which had not been plowed or treated. Also, the pilot reported that he had removed snow and frost from the airframe during his preflight. He said that the leading…Mar 10, 1982 · N8419J · Substantial damageNTSB NYC82FNA06Accident · No injuriesClosedCessna 170B · Stow, MANov 22, 1981 · N2543C · Substantial damageNTSB NYC81FNA17Accident · Minor injuriesClosedCessna 172 · Haverhill, MAJun 29, 1981 · N5708T · Substantial damageNTSB NYC81FNE09Accident · No injuriesClosedPiper PA-28 · Northampton, MAFeb 9, 1981 · N1032X · Substantial damageNTSB NYC81FNA08Accident · Minor injuriesClosedPiper PA-28 · Beverly, MAJan 9, 1981 · N15993 · Substantial damageNTSB NYC80FNA18Accident · No injuriesClosedCessna 172 · Halifax, MAAug 3, 1980 · N1489E · Substantial damageNTSB NYC80FNA15Accident · No injuriesClosedPiper PA-23 · Norwood, MAJun 23, 1980 · N129RM · Substantial damageNTSB NYC80FNE18Accident · Serious injuriesClosedCessna 172M · Worcester, MAJun 14, 1980 · N64238 · DestroyedNTSB NYC79FNA29Accident · No injuriesClosedCessna 172N · Newburyport, MAAug 26, 1979 · N734QZ · Substantial damageNTSB NYC79FNE12Accident · No injuriesClosedPiper PA-28 · Chicopee, MAMar 17, 1979 · N2163T · Substantial damageNTSB NYC79FNA13Accident · No injuriesClosedCessna 500 · Boston, MAFeb 7, 1979 · N186MW · Substantial damageNTSB NYC79FNA01Accident · No injuriesClosedPiper PA-28 · Marlboro, MAOct 5, 1978 · N6006U · Substantial damageNTSB NYC78FNA48Accident · No injuriesClosedCessna 152 · Bedford, MASep 24, 1978 · N757JX · Substantial damageNTSB NYC78FNA35Accident · Serious injuriesClosedEnstrom F28C · So.Dennis, MAJul 7, 1978 · N51667 · Substantial damageNTSB NYC78FNE22Accident · Minor injuriesClosedPiper PA-28 · Barrington, MAJun 11, 1978 · N1690T · Substantial damageNTSB NYC78FNE12Accident · No injuriesClosedCessna 414 · Northampton, MAMar 3, 1978 · N7846Q · Substantial damageNTSB NYC78FNA08Accident · No injuriesClosedPiper PA-28 · Norwood, MAFeb 4, 1978 · N1036Q · Substantial damageNTSB NYC77IA074Incident · Minor injuriesClosedDouglas DC-10 · Boston, MAJul 28, 1977 · N121AA · Minor damageNTSB NYC77DNA24Accident · No injuriesClosedAero Comdr 100 · Hyannis, MAJul 26, 1977 · N2948T · Substantial damageNTSB NYC77FA066Accident · 2 fatalClosedCessna 172K · Nantucket, MAJun 13, 1977 · N79005 · DestroyedNTSB NYC77FNA16Accident · No injuriesClosedCessna 172 · Marlboro, MAApr 23, 1977 · N79879 · Substantial damageNTSB NYC77DNA12Accident · No injuriesClosedGrum Amer AA-1B · Tewksbury, MAFeb 10, 1977 · N6325L · Substantial damageNTSB NYC77FNE02Accident · Serious injuriesClosedSchweizer SGS233 · Pittsfield, MAOct 17, 1976 · N33977 · DestroyedNTSB NYC76FNA47Accident · No injuriesClosedGrum Amer AA-5 · Stow, MAJul 14, 1976 · N8899L · Substantial damageNTSB NYC76DNA33Accident · No injuriesClosedMooney M20C · Bedford, MAApr 2, 1976 · N9788M · Substantial damageNTSB NYC76FNE03Accident · Minor injuriesClosedPiper J-3 · S Deerfield, MAAug 3, 1975 · N7279H · Substantial damageNTSB NYC75AN081Accident · No injuriesClosedVolpar TC45J · Norwood, MAJan 20, 1975 · N10AS · Substantial damageNTSB NYC75FNE19Accident · No injuriesClosedPiper PA-30 · Worcester, MANov 13, 1974 · N7283Y · Substantial damageNTSB NYC75FNA21Accident · No injuriesClosedChampion 7ECA · Marshfield, MAOct 14, 1974 · N1662G · Substantial damageNTSB NYC74DNA37Accident · No injuriesClosedMooney M20F · Norwood, MAMar 9, 1974 · N3819N · Substantial damageNTSB NYC74DNA26Accident · Minor injuriesClosedPiper PA-22 · Stow, MANov 4, 1973 · N5269Z · Substantial damageNTSB NYC74FNA16Accident · No injuriesClosedCessna 206 · East Boston, MASep 9, 1973 · N50463 · Substantial damageNTSB NYC74FNE03Accident · No injuriesClosedCessna 150 · Westfield, MAAug 16, 1973 · N19488 · Substantial damageNTSB NYC73FNE33Accident · No injuriesClosedCessna 150L · Northamton, MAMay 13, 1973 · N18678 · Substantial damageNTSB NYC73DNA28Accident · No injuriesClosedPiper PA-28 · Taunton, MAOct 14, 1972 · N98289 · Substantial damageNTSB NYC73IN002Incident · No injuriesClosedDouglas DC-8 · Ea.Boston, MAJul 2, 1972 · HB-IDG · Minor damageNTSB NYC22DNA36Accident · No injuriesClosedCessna 150 · Marlboro, MAFeb 23, 1972 · N22849 · Substantial damage