Final NTSB investigations, GA

266 cases where the phase of flight was Takeoff.

Cases per year

19642026
Final NTSB investigations, GA per year, 1964–2026: 266 cases
19647
19655
19666
19678
19685
19694
19709
19717
19726
19734
197410
19756
19769
197714
19785
19796
19805
19811
19827
198311
19843
19855
19863
19884
19894
19905
19924
19933
19943
19953
19966
19975
19985
19996
20003
20013
20024
20032
20052
20073
20084
20091
20104
20115
20124
20131
20144
20154
20165
20174
20182
20193
20202
20212
20223
20233
20242
20262

Latest cases

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\" = 'GA' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    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 ERA26LA272Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Hartwell, GAThe pilot’s failure to compensate for the gusty and variable wind conditions, which resulted in a loss of control and collision with trees during takeoff.Jul 10, 2026 · N1838C · Substantial damageNTSB ERA26LA210Accident · No injuriesClass 4 · LimitedFinal reportJohn Bradley Vans RV-7 · Athens, GAContamination of the left wheel brake system with debris, which resulted in a loss of directional control during takeoff.May 15, 2026 · N519JS · Substantial damageNTSB ERA24FA221Accident · 1 fatalClass 3 · FieldFinal reportRadley Vincent Quicksilver Sport 2S · Cleveland, GAThe pilot’s failure to maintain control of the airplane during the takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin at low altitude. Contributing to the accident was the pilot’s lack of…May 20, 2024 · N960B · Substantial damageNTSB ERA24LA183Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 11AC · Conyers, GAAn encounter with shifting wind conditions, which resulted in the airplane using more runway than anticipated, an aborted takeoff, and subsequent runway excursion. Contributing to the accident was the pilot’s failure account for the potential of variable and…Mar 31, 2024 · N3420E · Substantial damageNTSB ERA23LA297Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150L · Elberton, GAThe pilot’s decision to take off with a known engine issue, which resulted in a partial loss of power on the initial climb due to the No. 1 cylinder’s exhaust valve becoming stuck. Contributing to the outcome, was the pilot’s delay in aborting the takeoff.Jul 12, 2023 · N16071 · Substantial damageNTSB ERA23LA279Accident · Serious injuriesClass 4 · LimitedFinal reportEdmisten Robert Eugene SR Rans S-14 Airaile · Bonaire, GAThe pilot’s failure to properly adjust the propeller’s pitch angle, which resulted in a loss of thrust and an inability to maintain altitude.Jun 25, 2023 · N528RE · Substantial damageNTSB ERA23LA268Accident · Minor injuriesClass 3 · LimitedFinal reportJabiru J250 · Louisville, GAThe pilot’s decision to take off in wind conditions that exceeded his ability to maintain directional control, resulting in a runway excursion and substantial damage to the airplane.Jun 3, 2023 · N828WD · Substantial damageNTSB ERA22LA419Accident · No injuriesClass 4 · LimitedFinal reportAutogyro USA Calidus · Jasper, GAThe pilot’s failure to maintain control of the gyroplane during a touch-and-go landing.Sep 11, 2022 · N451AG · Substantial damageNTSB ERA22LA265Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-23 · Stockbridge, GAA total loss of right engine power during initial climb for reasons that could not be determined.Jun 11, 2022 · N3477P · Substantial damageNTSB ERA22LA188Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Calhoun, GAThe pilot’s failure to maintain clearance from wires during takeoff.Apr 12, 2022 · N426DB · Substantial damageNTSB ERA21LA181Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · Stockbridge, GAThe flying pilot’s failure to configure the flaps for a short field takeoff and delayed decision to abort the takeoff, which resulted in a runway overrun.Apr 9, 2021 · N1664H · Substantial damageNTSB ERA21LA167Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Vienna, GAThe pilot’s improper decision to attempt a takeoff with a quartering tailwind and his failure to reject the takeoff in a timely manner, which resulted in a runway excursion.Mar 31, 2021 · N3299X · DestroyedNTSB ERA20LA311Accident · No injuriesClass 4 · LimitedFinal reportZenith CH650LS · Villa Rica, GAA loss of directional control during the landing roll.Sep 5, 2020 · N232PA · Substantial damageNTSB ERA20CA232Accident · No injuriesClass 4 · Data collectionFinal reportAyres S2R · Perry, GAThe reported malfunction of the aileron flight control system during takeoff for reasons that could not be determined.Jun 27, 2020 · N4032L · Substantial damageNTSB ERA20LA035Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Griffin, GAThe pilot’s failure to ensure that the airplane was properly configured for takeoff, which resulted in the inadvertent retraction of the landing gear during the takeoff roll and the airplane’s subsequent runway excursion.Nov 9, 2019 · N686DR · Substantial damageNTSB ERA19LA219Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 4 · Williamson, GAThe pilot's inadvertent misplacement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.Jun 27, 2019 · N102GL · Substantial damageNTSB ERA19LA152Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Dublin, GAA partial loss of engine power on takeoff due to separation of the diffuser assembly as a result of incomplete braze joint surfaces on the vane airfoils.Apr 15, 2019 · N395AE · Substantial damageNTSB GAA19CA088Accident · No injuriesData collectionFinal reportPiper PA28 · Cornelia, GAThe flight instructor's failure to maintain the runway heading during an attempted takeoff in gusting crosswind conditions, which resulted in a collision with trees.Dec 5, 2018 · N839AL · Substantial damageNTSB GAA18CA282Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · LaGrange, GAThe student pilot’s failure to maintain lateral control during a soft-field takeoff.May 13, 2018 · N143MA · Substantial damageNTSB GAA18CA047Accident · No injuriesData collectionFinal reportCessna 140 · Macon, GAThe pilot's incorrect pitch control during takeoff, which resulted in a nose-over.Nov 8, 2017 · N76238 · Substantial damageNTSB ERA17LA324Accident · No injuriesLimited investigationFinal reportCessna 195 · Newman, GAThe improper rigging of the tailwheel assembly, which resulted in a loss of directional control during takeoff. Contributing to accident was the pilot’s decision to operate the airplane despite knowing it required excessive right rudder inputs for it to move…Aug 10, 2017 · N2100C · Substantial damageNTSB ERA17LA217Accident · No injuriesLimited investigationFinal reportBarnes Richard B/Howe Michael Vans RV 10 · Blairsville, GAThe pilot’s loss of directional control upon landing.Jun 26, 2017 · N865HB · Substantial damageNTSB GAA17CA283Accident · No injuriesData collectionFinal reportCessna 172 · Atlanta, GAThe student’s incorrect use of the go-around procedure, which resulted in an aerodynamic stall, and the flight instructor’s delayed remedial action.May 2, 2017 · N704RB · Substantial damageNTSB ERA17LA020Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12 D · Vaughn, GAA total loss of engine power for reasons that could not be determined because postaccident examination of the airplane and engine did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.Oct 17, 2016 · N94919 · Substantial damageNTSB GAA16CA497Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brunswick, GAThe total loss of engine power during takeoff due to a loose B-nut on the fuel flow divider input fuel line fitting, which resulted in a fuel leak and fuel starvation.Aug 22, 2016 · N204AK · Substantial damageNTSB GAA16CA240Accident · No injuriesData collectionFinal reportMills Gregory T AIR Commander LRT · Tybee Island, GAThe pilot's decision to perform a touch-and-go on unsuitable terrain, which resulted in a loss of directional control and a rollover.May 14, 2016 · N962GT · Substantial damageNTSB ERA16LA120Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Atlanta, GAA total loss of engine power due to fuel vapor lock. Contributing to the accident was the absence of a fuel return line.Feb 28, 2016 · N187SF · Substantial damageNTSB GAA16CA129Accident · No injuriesData collectionFinal reportPilatus PC12 · Lawrenceville, GAAn unintentional collision with a white-tailed deer during the takeoff roll in night visual conditions.Jan 27, 2016 · N338PC · Substantial damageNTSB GAA15CA216Accident · No injuriesData collectionFinal reportCessna 150M · Ellijay, GAThe pilot's failure to attain and maintain sufficient airspeed during takeoff which resulted in a descent, loss of directional control, and a runway excursion.Aug 5, 2015 · N3568V · Substantial damageNTSB ERA15LA270Accident · No injuriesLimited investigationFinal reportAyres S2R T34 · Climax, GAA loss of thrust on takeoff for reasons that could not be determined, because postaccident examination of the engine and propeller assembly did not reveal any mechanical anomalies that would have precluded normal operation.Jul 9, 2015 · N524SL · Substantial damageNTSB GAA15CA047Accident · Minor injuriesData collectionFinal reportPiper PA 16 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll.Apr 22, 2015 · N5616H · Substantial damageNTSB ERA15CA152Accident · No injuriesData collectionFinal reportCessna 182L · Waycross, GAThe pilot's failure to use any airport guidance while taxiing, which resulted in geographic disorientation and a takeoff attempt from an inadequate length and unsuitable surface.Mar 10, 2015 · N42667 · Substantial damageNTSB ERA15LA075Accident · 1 fatalLimited investigationFinal reportJohnson David Earl Renegade Spirit · Brunswick, GAThe pilot's decision to fly the airplane with known engine deficiencies and his subsequent exceedance of the airplane's critical angle of attack following a loss of engine power, which resulted in an aerodynamic stall and loss of control after takeoff.Dec 13, 2014 · N955R · Substantial damageNTSB ERA14LA422Accident · No injuriesLimited investigationFinal reportAckland Jeffrey Dean SH 3R · Columbus, GAThe mechanic’s improper installation of the landing gear extend/retract switch, which resulted in the retraction of the landing gear during the aborted takeoff.Sep 3, 2014 · N333AW · Substantial damageNTSB ERA14CA365Accident · No injuriesData collectionFinal reportCessna 182B · Clayton, GAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a tree and then obstacles during the subsequent aborted takeoff.Jul 27, 2014 · N2275G · Substantial damageNTSB ERA14LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Millen, GAThe pilot's failure to fully seat the fuel selector in the left tank position before takeoff, which resulted in fuel starvation and a subsequent loss of engine power.Jan 26, 2014 · N36086 · Substantial damageNTSB ERA13LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, GAThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the airplane's perceived lack of performance for reasons that could not be determined due to insufficient information.Jul 27, 2013 · N371JB · Substantial damageNTSB ERA12CA424Accident · No injuriesData collectionFinal reportBeech 58 · Atlanta, GAThe pilot's inadvertent retraction of the landing gear during the landing.Jul 1, 2012 · N827EB · Substantial damageNTSB ERA12CA369Accident · No injuriesData collectionFinal reportCessna 172 · Gainesville, GAThe student pilot's improper use of the flight controls during the takeoff and the flight instructor's delayed remedial action. Contributing to the accident was the student pilot’s interference with the flight instructor’s attempted remedial actions.May 27, 2012 · N787LF · Substantial damageNTSB ERA12LA315Accident · No injuriesLimited investigationFinal reportBerry Dean Glasair I · Columbus, GAThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane make and model, resulting in and his…May 2, 2012 · N540GZ · Substantial damageNTSB ERA12CA283Accident · No injuriesData collectionFinal reportCessna 150M · Cedartown, GAThe pilot’s failure to maintain directional control during takeoff.Apr 14, 2012 · N714JJ · Substantial damageNTSB ENG12IA001Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Atlanta, GAthe return to service of overhauled airplane engine parts with undetected fatigue cracks, resulting in complete loss of engine power and uncontained engine failure. A contributing factor was the inadequate diffuser and HPT case inspection procedure.Oct 10, 2011 · N553NW · Minor damageNTSB ENG11IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Atlanta, GAThe probable cause of the No. 2 engine failure and subsequent aborted takeoff was the high cycle fatigue failure of a fan blade near the blade root that resulted in extensive low pressure compressor damage and compressor case breach.Aug 6, 2011 · N676MC · Minor damageNTSB ENG11IA035Incident · Minor injuriesIncident investigationFinal reportBoeing 757-232 · Atlanta, GAFuel leaking from the fuel flow transmitter that ignited on contact with the engine’s hot cases which resulted in an engine undercowl fire. The fuel leak resulted from the fuel flow transmitter end housing backing off from the main housing, creating a gap…Jun 21, 2011 · N6714Q · No damageNTSB ERA11CA343Accident · No injuriesData collectionFinal reportCessna 172S · Covington, GAThe pilot's failure to maintain directional control during takeoff.Jun 14, 2011 · N6026P · DestroyedNTSB ERA11CA256Accident · No injuriesData collectionFinal reportVans RV8 · Locust Grove, GAThe pilot's failure to maintain aircraft control during the takeoff roll.Apr 21, 2011 · N190GE · Substantial damageNTSB ERA11LA014Accident · 1 fatalLimited investigationFinal reportEngineering & Research Ercoupe 415-D · Lawrenceville, GAInadequate maintenance performed on the airplane, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the corrosion within the carburetor.Oct 9, 2010 · N89331 · Substantial damageNTSB ERA11LA003Accident · Minor injuriesLimited investigationFinal reportYost Edwin S Glasair SH-2 · Jackson, GAThe pilot's loss of aircraft control for undetermined reasons.Oct 1, 2010 · N2117S · Substantial damageNTSB ERA10LA483Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Clyo, GAThe pilot's failure to maintain a proper aircraft pitch attitude during the takeoff roll, which allowed the tailwheel to contact the grass runway and increase drag on the airplane.Sep 18, 2010 · N3348K · Substantial damageNTSB ERA10LA164Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Savannah, GAThe pilot's failure to maintain airspeed and inadvertent stall after takeoff.Mar 5, 2010 · N45976 · Substantial damage