NTSB investigations
14,034 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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ANC26LA050Accident · No injuriesClass 4 · LimitedInvestigation openCessna A185F · Steele Creek, AKNTSB CEN26LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Colorado Springs, COThe student pilot’s failure to maintain directional control of the airplane during the takeoff, which resulted in a runway excursion and collision with runway signs.NTSB CEN26LA204Accident · Minor injuriesClass 3 · LimitedPreliminary reportMustang Aeronautics Mustang II · Richmond, TXOn May 28, 2026, about 1440 central daylight time, a Mustang Aeronautics Mustang II airplane, N160MT, sustained substantial damage when it was involved in an accident near Richmond, Texas. The pilot sustained minor injuries. The airplane was operated as a…NTSB WPR26LA213Accident · Serious injuriesClass 4 · LimitedFinal reportMoose SR 2500 · Sonoma, CAThe pilot's failure to maintain airspeed during a go-around in shifting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB CEN26LA201Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172H · Berryville, ARThe pilot in command’s decision to continue the takeoff when the airplane was not airborne at midfield, and the student pilot’s likely improper technique that resulted in a lack of sufficient climb performance and subsequent loss of control.NTSB WPR26LA199Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206-L4 · Cedar City, UTThe flight instructor's failure to maintain helicopter control while manipulating the engine governor reference rpm adjustment during hover operations, which resulted in a loss of control and impact with the ground.NTSB ERA26LA216Accident · No injuriesClass 3 · LimitedPreliminary reportCessna A188B · Doerun, GAOn May 23, 2026, about 1500 eastern daylight time, a Cessna A188B, N8288G, was substantially damaged when it was involved in an accident near Doerun, Georgia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB CEN26LA198Accident · No injuriesClass 4 · LimitedFinal reportCommander 114TC · Woodruff, WIThe pilot’s failure to maintain airplane control during the go-around.NTSB ANC26LA043Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18A 150 · Tyonek, AKNTSB ERA26LA209Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Harrison, NYThe student pilot’s excessive pitch up attitude during takeoff, which resulted in an aerodynamic stall and loss of control.NTSB DCA26WA209Incident · No injuriesClass 5 · ForeignAirbus 220 · Split, CroatiaNTSB CEN26LA191Accident · Minor injuriesClass 3 · LimitedPreliminary reportVertical Hummingbird · Lee's Summit, MOOn May 16, 2026, about 0950 central daylight time, a Vertical Aviation Technologies 300L Hummingbird helicopter, N284ST, was substantially damaged when it was involved in an accident near Lee’s Summit, Missouri. One passenger sustained minor injuries. The…NTSB 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.NTSB DCA26WA212AccidentClass 3 · ForeignBoeing 737 · Muscat, OmanNTSB WPR26LA197Accident · Serious injuriesClass 3 · LimitedPreliminary reportMooney M20J · Lake Havasu City, AZOn May 14, 2026, at 1523, a Mooney M20J, N4665H, was substantially damaged when it was involved in an accident near Lake Havasu City, Arizona. The pilot and two passengers sustained serious injuries. The airplane was operated under Title 14 Code of Federal…NTSB CEN26LA187Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Denton, TXOn May 13, 2026, about 1815 central daylight time, a Cessna 172S, N2134M, sustained substantial damage when it was involved in an accident near Denton, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB CEN26LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-201 · West Chicago, ILThe pilot’s improper decision to attempt an intersection takeoff and delay to abort the takeoff which resulted in a subsequent runway excursion.NTSB WPR26LA179Accident · No injuriesClass 4 · LimitedFinal reportCessna A150L · Superior, AZThe pilot's failure to retract the flaps during takeoff following a touch-and-go landing, which resulted in degraded climb performance and an impact with an object during an off-field landing.NTSB CEN26LA177Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · El Campo, TXThe pilot’s failure to maintain aircraft control during takeoff resulting in a collision with a building during takeoff.NTSB ENG26WA028IncidentClass 5 · ForeignAirbus A321 · Ciudad de México, MexicoNTSB ANC26LA035Accident · No injuriesClass 4 · LimitedInvestigation openChampion 7EC · Hollis, OKNTSB GAA26WA180Incident · Minor injuriesClass 5 · ForeignCostruzioni Aeronautiche Tecna P92 Eaglet · Dajabon, Dominican RepublicNTSB ERA26LA187Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Quakertown, PAThe pilot receiving instruction’s failure to maintain aircraft directional control during the takeoff roll. Contributing was the flight crew’s failure to ensure a positive exchange of flight controls during the takeoff roll.NTSB GAA26WA182IncidentClass 5 · ForeignPiper PA60 · Villavicencio, ColombiaNTSB ANC26LA031Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Lapeer, MIThe flight instructor’s failure to maintain airplane control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and on ground collision with an object. Contributing to the accident was the flight instructor’s decision to…NTSB ERA26LA186Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172M · Crystal River, FLNTSB CEN26LA169Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8E · Meeker, COThe pilot’s inability to maintain climb performance and clearance from terrain due to the airplane’s encounter with windshear during takeoff.NTSB ERA26LA183Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 421 · Richmond, VAOn April 18, 2026, about 1410 eastern daylight time, a Cessna 421C, C-GTGR, was substantially damaged when it was involved in an accident near Richmond, Virginia. The pilot and four passengers were uninjured. The airplane was operated as a Title 14 Code of…NTSB WPR26LA159Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s loss of control during takeoff, due to the seat sliding aft.NTSB ERA26LA172Accident · No injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-3 · Dry Tortugas, FLOn April 11, 2026, about 0845 eastern daylight time, an amphibious DeHavilland DHC-3, N708KA, was substantially damaged when it was involved in an accident near Dry Tortugas, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA169Accident · Serious injuriesClass 3 · LimitedPreliminary reportEric Vargosko SW-51 · Iron Station, NCOn April 10, 2026, about 1732 eastern daylight time, an experimental amateur built SW-51 airplane, N551EV, sustained minor damage when it was involved in an accident near Iron Station, North Carolina. The front seat pilot sustained minor injuries, and the…NTSB WPR26LA149Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna T-41B · Fort Mohave, AZOn April 7, 2026, about 1300 mountain standard time, a Cessna T-41B, N39ND, was substantially damaged when it was involved in an accident near Fort Mohave, Arizona. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14 Code…NTSB ERA26LA159Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172M · Lakeland, FLOn April 05, 2026, at 0007 eastern daylight time, a Cessna 172M airplane, N61972, was substantially damaged when it was involved in an accident near Lakeland, Florida. The pilot and certified flight instructor (CFI) rated passenger were uninjured. The…NTSB WPR26LA146Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Chimney Rock, MTThe pilot’s failure to maintain adequate clearance from the terrain while performing a low altitude circling takeoff maneuver, which resulted in a dynamic rollover.NTSB GAA26WA144Accident · No injuriesClass 5 · ForeignCessna 182 · Pucallpa, PeruNTSB ERA26LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Mount Pleasant, SCThe airplane’s encounter with uneven terrain during takeoff, which resulted in a runway excursion and impact with water.NTSB CEN26LA152Accident · No injuriesClass 4 · LimitedFinal reportEla ELA10 · Boulder, COThe pilot’s failure to maintain directional control during the takeoff in gusting wind conditions.NTSB DCA26WA220Occurrence · No injuriesClass 5 · ForeignBoeing 737-832 · San Miguel de Cozumel, MexicoNTSB ERA26LA227Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Maiden, NCThe flight instructor’s inadequate preflight planning, which resulted in a rejected takeoff from a tailwind departure and subsequent runway excursion.NTSB WPR26LA131Accident · Minor injuriesClass 3 · LimitedPreliminary reportAerospatiale SA341G Gazelle · Winslow, AZOn March 21, 2026, about 1406 mountain daylight time, a Aerospatiale SA341G Gazelle, N71FR, sustained substantial damage when it was involved in an accident near Winslow, Arizona. The pilot and passenger sustained minor injuries. The airplane was operated as…NTSB ERA26LA153Accident · Minor injuriesClass 3 · LimitedPreliminary reportTextron T206H · Fort Myers, FLOn March 21, 2026, about 0905 eastern daylight time, a Cessna T206H, N2469H, was substantially damaged when it was involved in an accident near Fort Myers, Florida. The pilot and four passengers sustained minor injuries. The airplane was operated as a Title…NTSB CEN26LA146Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain proper airspeed during takeoff and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN26LA143Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172P · Denton, TXOn March 20, 2026, about 1415 central daylight time, a Cessna 172P airplane, N65614, was substantially damaged when it was involved in an accident near Denton, Texas. The pilot sustained minor injuries, and the pilot-rated sensor operator sustained serious…NTSB WPR26LA133Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · West Linn, OROn March 18, 2026, about 1700 Pacific daylight time, a Piper PA-12, N7632H, was substantially damaged when it was involved in an accident near West Linn, Oregon. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN26FA140Accident · 1 fatalClass 3 · FieldPreliminary reportAero Commander 500-B · Chesterfield, MOOn March 17, 2026, about 0024 central daylight time, an Aero Commander 500-B airplane, N444CA, was destroyed when it was involved in an accident near Chesterfield, Missouri. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB DCA26WA162Accident · No injuriesClass 5 · ForeignBoeing 737 · Misawa, JapanNTSB ERA26LA147Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA24-180 · Leonardtown, MDThe pilot’s failure to maintain control during a crosswind takeoff, which resulted in a runway excursion and impact with a drainage ditch.NTSB ANC26LA018Accident · No injuriesClass 3 · LimitedPreliminary reportBell Textron Canada 505 · Fort Worth, TXOn March 7, 2026, at 2210 Central daylight time, a Bell Textron 505 helicopter, N911FW, was substantially damaged when it was involved in an accident near Fort Worth, Texas. The pilot and crew member were not injured. The helicopter was operated as a Title 14…NTSB CEN26LA137Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · Lockhart, TXOn March 7, 2026, about 1323 central standard time, a Piper PA-12, N2511M, was substantially damaged when it was involved in an accident near Lockhart, Texas. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB CEN26LA134Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Sonora, TXThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in a loss of control and hard landing.