OpenAirDocs.org

NTSB investigations

14,036 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.\"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 DCA24LA330IncidentClass 2 · LimitedFinal reportBoeing 737-8 · Kenner, LAA partial loss of engine power due to bird ingestion in the No. 1 (left) engine, which resulted in the activation of the load reduction device to prevent vibration. The load reduction device activation resulted in smoke and fumes entering the cockpit.Dec 20, 2023 · N8830Q · Minor damageNTSB DCA24WA067IncidentClass 5 · ForeignBoeing 737 · Amsterdam, NetherlandsDec 19, 2023 · EI-STW · No damageNTSB DCA24WA059IncidentClass 5 · ForeignBoeing 737 · Brazzaville, Congo - KinshasaDec 17, 2023 · TN-AKCNTSB WPR24FA056Accident · 1 fatalClass 3 · FieldFinal reportVans RV8 · Corona, CAFuel contamination from the pilot’s improper application of a sealant to the fuel tank, which resulted in a partial loss of engine power on takeoff.Dec 16, 2023 · N6948L · Substantial damageNTSB ERA24LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Newport News, VAAn inflight collision with a bird during initial climb.Dec 11, 2023 · N733QJ · Substantial damageNTSB ERA24LA063Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lajas, PRThe pilot’s failure to maintain adequate clearance from bushes alongside the runway, which resulted in a loss of directional control during the takeoff.Dec 10, 2023 · N1707Q · Substantial damageNTSB ENG24WA041OccurrenceClass 5 · ForeignBoeing 777 · Karachi, PakistanDec 2, 2023 · AP-BMH · No damageNTSB GAA24WA048AccidentClass 5 · ForeignEnstrom 280 · Madrid, SpainDec 1, 2023 · F-HPUX · Substantial damageNTSB DCA24WA040OccurrenceClass 5 · ForeignBoeing 737 · East Midlands, United KingdomDec 1, 2023 · G-JMCV · No damageNTSB GAA24WA054Accident · No injuriesClass 5 · ForeignCessna A188 · Ipiranga do Norte, BrazilNov 30, 2023 · SCF-PP · Substantial damageNTSB DCA24WA084IncidentClass 5 · ForeignBoeing 747 · Frankfurt, GermanyNov 30, 2023 · TF-AMKNTSB DCA24WA041OccurrenceClass 5 · ForeignBoeing 737 · Alger, AlgeriaNov 21, 2023 · 7T-VJJNTSB ERA24LA032Accident · Minor injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-65 · Columbia, TNA partial loss of engine power due to an accumulation of carburetor ice, resulting in an off-airport landing and substantial damage to the airplane.Nov 11, 2023 · N29868 · Substantial damageNTSB GAA24WA026Accident · No injuriesClass 5 · ForeignAerospatiale SA341G Gazelle · Spalding, United KingdomNov 5, 2023 · N150SF · Substantial damageNTSB GAA24WA021IncidentClass 5 · ForeignCessna 525 · Paris, FranceOct 28, 2023 · F-HMSG · Minor damageNTSB GAA24WA029Accident · Minor injuriesClass 3 · ForeignTecnam P2008 · Baramati, IndiaOct 22, 2023 · VT-RBT · Substantial damageNTSB ERA24LA086Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Morganton, NCThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and an impact with the runway’s precision approach path indicator (PAPI) lights.Oct 22, 2023 · N5954Q · Substantial damageNTSB GAA24WA042Accident · 1 fatalClass 5 · ForeignBeech C23 · Bram Fischer International Airpor, South AfricaOct 21, 2023 · ZS-JKE · Substantial damageNTSB GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaOct 21, 2023 · ZK-JKE · Substantial damageNTSB GAA24WA030Accident · Minor injuriesClass 3 · ForeignTecnam P2008 · Baramati, IndiaOct 19, 2023 · VT-RBC · DestroyedNTSB DCA24WA018Incident · No injuriesClass 5 · ForeignBoeing 737-800 · Frankfurt am Main, GermanyOct 18, 2023 · D-ABKM · No damageNTSB CEN24LA018Accident · No injuriesClass 3 · LimitedFinal reportCessna 210B · Pueblo, COThe fatigue failure of the right main landing gear hydraulic actuator, which resulted in a loss of hydraulic fluid that prevented the pilot from lowering the landing gear to the fully extended position.Oct 18, 2023 · N9597X · Substantial damageNTSB ERA24LA011Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P2010 · Ocala, FLA total loss of engine power for reasons that could not be determined. Contributing to the accident was the flight instructor’s failure to maintain adequate airspeed and exceedance of the airplane’s critical angle of attack during the forced landing, which…Oct 17, 2023 · N118T · Substantial damageNTSB GAA24WA011Accident · 2 fatalClass 5 · ForeignCessna 208 · Pacencia-Yacma, BelizeOct 16, 2023 · V3-HIN · DestroyedNTSB ERA24LA009Accident · Minor injuriesClass 4 · LimitedFinal reportMonocoupe 90AL-115 · Myakka City, FLThe pilot’s failure to maintain adequate clearance from a fence during takeoff.Oct 14, 2023 · N87621 · Substantial damageNTSB ERA24LA008Accident · Serious injuriesClass 3 · LimitedFinal reportRotorsport UK Mtosport 2017 · Easton, MDThe pilot’s failure to maintain control of the gyroplane on takeoff.Oct 13, 2023 · N975CD · Substantial damageNTSB CEN24FA010Accident · 2 fatalClass 3 · FieldFinal reportCessna 414 · Patterson, LAThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.Oct 12, 2023 · N880A · DestroyedNTSB CEN24LA008Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Warrenton, MOThe pilot’s failure to maintain directional control during the touch-and-go landing. Contributing was the pilot’s decision to land with a quartering tailwind.Oct 8, 2023 · N211BL · Substantial damageNTSB GAA24WA004Accident · 3 fatalClass 5 · ForeignBeech 90 · Cuiaba, BrazilOct 4, 2023 · PS-JCO · DestroyedNTSB ERA24FA001Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Placid, NYA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s inadequate preflight weight and balance planning and his aggressive low altitude maneuvering, which resulted in an aerodynamic stall and loss of control.Oct 1, 2023 · N545PZ · Substantial damageNTSB DCA23LA468Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Denver, COOverheated brakes due to the extended taxi at a higher power setting in an attempt to burn off fuel to achieve the proper takeoff weight that resulted in a wheel fire during takeoff.Sep 30, 2023 · N37560 · Substantial damageNTSB ERA23LA387Accident · No injuriesClass 4 · LimitedFinal reportJohn W Moll Vans RV-7 · Liberty, SCThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and substantial damage to the left wing and left horizontal stabilizer.Sep 29, 2023 · N557JM · Substantial damageNTSB CEN23LA424Accident · Serious injuriesClass 3 · LimitedFinal reportPowrachute Pegasus · Caddo Mills, TXThe pilot’s inadequate rolling preflight, which resulted in a loss of directional control in flight and subsequent collision with an object during landing.Sep 28, 2023 · N31520 · Substantial damageNTSB WPR23LA357Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot’s loss of airplane control during takeoff, which resulted in a bounced landing and impact with the airport’s windsock.Sep 27, 2023 · N17274 · Substantial damageNTSB ERA23LA379Accident · Minor injuriesClass 4 · LimitedFinal reportDorr Dan W Sequoia F.8L Falco · Sanford, FLThe pilot’s failure to maintain airplane control after an engine access cover opened during the initial climb.Sep 26, 2023 · N708WC · Substantial damageNTSB GAA23WA270Accident · Serious injuriesClass 5 · ForeignCessna 172 · Monacalieri, ItalySep 23, 2023 · I-FFSW · Substantial damageNTSB WPR23LA356Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Eatonville, WAThe pilot's failure to maintain directional control during the takeoff roll, in gusty wind conditions, which resulted in a runway excursion.Sep 22, 2023 · N7955H · Substantial damageNTSB WPR23LA350Accident · No injuriesClass 3 · LimitedFinal reportCessna U206C · Challis, IDThe failure of the left main landing gear spring assembly due to a fatigue crack. Contributing to the accident was the improper maintenance on the landing gear spring assembly which allowed corrosion to develop.Sep 20, 2023 · N3923G · Substantial damageNTSB WPR23LA349Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Compton, CAThe total loss of engine power on takeoff due to water-contaminated fuel. Contributing to the accident was the inadequately maintained fuel system, which resulted in water entering the fuel tanks through the filler caps.Sep 20, 2023 · N733ZN · Substantial damageNTSB WPR23LA348Accident · No injuriesClass 3 · LimitedFinal reportChampion 7KCAB · Benson, AZThe pilots’ failure to maintain control of the aircraft during takeoff.Sep 19, 2023 · N998B · Substantial damageNTSB ERA23LA381Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75 · Erwinna, PAThe pilot’s failure to maintain control of the airplane while taking off in a crosswind.Sep 19, 2023 · N46Y · Substantial damageNTSB DCA23WA460Incident · Serious injuriesClass 5 · ForeignBoeing 787 · Melbourne, AustraliaSep 18, 2023 · VN-A819 · No damageNTSB GAA23WA262AccidentClass 5 · ForeignBeech 36 · San Luis, ArgentinaSep 17, 2023 · LV-GLQ · Substantial damageNTSB GAA23WA259Accident · 1 fatalClass 5 · ForeignCessna 182 · Bamberg, GermanySep 17, 2023 · D-EOLP · Substantial damageNTSB WPR23FA344Accident · 1 fatalClass 3 · FieldFinal reportSeawind 3000 · Bellevue, WAThe pilot’s loss of airplane control after encountering a lake swell and skipping during takeoff.Sep 15, 2023 · N57TJ · Substantial damageNTSB GAA23WA261Accident · Serious injuriesClass 5 · ForeignExtra EA300 · Graz, AustriaSep 13, 2023 · D-EXJW · Substantial damageNTSB ANC23FA074Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-18-150 · St. Mary's, AKThe pilot’s decision to operate the airplane above its maximum certificated gross weight, and his installation of an unapproved external load that degraded takeoff performance and flight characteristics resulting in a loss of airplane control during takeoff…Sep 13, 2023 · N109T · Substantial damageNTSB DCA23WA450IncidentClass 5 · ForeignBoeing 757 · Manchester, United KingdomSep 8, 2023 · G-LSAA · No damageNTSB WPR23LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Marble Canyon, AZThe pilot’s loss of airplane control after an encounter with windshear during takeoff which resulted in collision with terrain.Sep 4, 2023 · N9328U · Substantial damageNTSB WPR23LA334Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Prescott, AZThe pilot-in-command’s inadequate preflight planning for the high density altitude and relative humidity conditions and his failure to recognize the need to reject the takeoff, allowing the student pilot to execute an abnormally long takeoff roll and apply…Sep 2, 2023 · N6834W · Substantial damage