NTSB investigations
3,824 cases where the sequence of events included Loss of engine power (total).
Cases, newest first
Query with SQL
duckdb -csv -c "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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 CEN26LA164Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-180 · Corpus Christi, TXOn April 13, 2026, about 19:19 central daylight time, a Piper Cherokee PA-28-180 airplane, N317HM was destroyed when it was involved in an accident near Corpus Christi, Texas. The flight instructor and student pilot were seriously injured. The airplane was…NTSB WPR26LA158Accident · Minor injuriesClass 3 · LimitedPreliminary reportAlexander Schleicher ASH 31 MI · Williams, CAOn April 13, 2026, about 1051 Pacific standard time, an experimental Alexander Schleicher GMBH and Co., Ash 31 Mi Glider, N77UK, was substantially damaged when it was involved in an accident near Williams, California. The pilot sustained minor injuries. The…NTSB WPR26LA153Accident · Minor injuriesClass 3 · LimitedPreliminary reportRepublic RC-3 · Phoenix, AZOn April 12, 2026, about 1423 mountain standard time, a Republic RC-3 airplane, N6518K, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The pilot and two passengers were not injured. The amphibious airplane was operated as…NTSB WPR26LA155Accident · Minor injuriesClass 3 · LimitedPreliminary reportAero Vodochody L-39 · Ennis, MTOn April 10, 2026, about 1210 mountain daylight time, an Aero Vodochody L 39, N136EM, was substantially damaged when it was involved in an accident near Ennis, Montana. The flight instructor sustained minor injuries, and the pilot undergoing instruction was…NTSB ERA26LA168Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper J3C-65 · Crestview, FLOn April 10, 2026, about 1700 eastern daylight time, a Piper J3C-65, N92480 was substantially damaged when it was involved in an accident near Baker, Florida. The pilot sustained minor injuries, and the passenger was seriously injured. The airplane was…NTSB WPR26LA152Accident · No injuriesClass 3 · LimitedPreliminary reportJust Highlander · Great Falls, MTOn April 8, 2026, about 1106 mountain daylight time, an experimental amateur built Just Aircraft Highlander, N563JA, was substantially damaged when it was involved in an accident near Great Falls, Montana. The pilot was not injured. The airplane was operated…NTSB WPR26LA150Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150G · Phoenix, AZOn April 8, 2026, about 1033 mountain standard time, a Cessna 150G, N4714X, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor and student pilot were not injured. The airplane was being operated as a…NTSB ERA26LA156Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Philadelphia, PAOn April 1, 2026, about 1541 eastern daylight time, a Piper PA-28-181, N494LA, was substantially damaged when it was involved in an accident near Philadelphia, Pennsylvania. The flight instructor received minor injuries, and the student pilot received serious…NTSB CEN26LA149Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA28 · Atlanta, TXOn March 26, 2026, about 0720 central daylight time, a Piper PA28-140 airplane, N1653J, was substantially damaged when it was involved in an accident near Atlanta, Texas. The pilot was not injured. The flight was operated under the provisions of Title 14 Code…NTSB GAA26WA133Accident · No injuriesClass 3 · ForeignCessna C180 · El Cerrito, ColombiaNTSB CEN26LA144Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20 · Northlake, TXThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB ERA26LA145Accident · Serious injuriesClass 3 · LimitedPreliminary reportRockwell International 114 · Whitmire, SCOn March 10, 2026, about 1915 eastern daylight time, a Rockwell International 114 airplane, N4832W, was substantially damaged when it was involved in an accident near Whitmire, South Carolina. The flight instructor received minor injuries. The pilot receiving…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 WPR26FA120Accident · 2 fatalClass 3 · FieldPreliminary reportColumbia Aircraft Mfg LC41-550FG · Albuquerque, NMOn March 6, 2026, about 1136 mountain standard time (MST), a Columbia Aircraft LC41-550FG, N2516S, was substantially damaged when it was involved in an accident in Albuquerque, New Mexico. The airplane was on an instrument flight rules flight plan from…NTSB WPR26FA119Accident · Serious injuriesClass 3 · FieldPreliminary reportPiper PA-28-140 · Phoenix, AZOn March 4, 2026, about 0721 mountain standard time, a Piper PA-28-140, N7744T, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor was seriously injured, and the student pilot and one person on the…NTSB ERA26LA134Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172N · Newburgh, NYOn March 2, 2026, at 1910 eastern standard time, a Cessna 172N, N1560E, was substantially damaged when it was involved in an accident near Newberg, New York. The flight instructor and student pilot incurred minor injuries. The airplane was operated as a Title…NTSB WPR26LA115Accident · No injuriesClass 4 · LimitedFinal reportMightyfly MF-100 · Atwater, CAA control system anomaly, which resulted in the overload and failure of one of the propulsion motor systems during the transition from hover to forward flight.NTSB CEN26LA128Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Larose, LAThe pilot’s improper fuel planning and his failure to adequately monitor the fuel level during flight, which resulted in fuel exhaustion, and a total loss of engine power. Contributing to the accident was the pilot’s lack of attention performing the task,…NTSB GAA26WA121Accident · No injuriesClass 5 · ForeignCessna 172 · Barreirinhas, BrazilNTSB CEN26FA126Accident · 1 fatalClass 3 · FieldPreliminary reportPeck JODEL-F12 · Rogers, AROn February 26, 2026, about 1330 central standard time, a Peck Jodel-F12, N30P, experimental airplane, was destroyed when it was involved in an accident near Rogers, Arkansas. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code…NTSB GAA26WA115Accident · No injuriesClass 5 · ForeignPiper PA-28-140 · Abbots Bromley, United KingdomNTSB CEN26LA123Accident · No injuriesClass 3 · LimitedPreliminary reportGrumman AA5 · Admire, KSOn February 23, 2026, about 0958 central standard time, a Grumman AA-5A airplane, N9939U, was substantially damaged when it was involved in an accident near Admire, Kansas. The pilot and passenger were not injured. The airplane operated under the provisions…NTSB WPR26FA103Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 210B · Camarillo, CAOn February 15, 2026, about 1805 Pacific standard time, a Cessna 210B, N9735X, was substantially damaged when it was involved in an accident near Camarillo, California. The pilot was fatally injured and the passenger sustained serious injuries. The airplane…NTSB ERA26LA116Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182G · Quail Heights, FLOn February 16, 2026, at 1020 eastern standard time a Cessna 182G, N515CL, was substantially damaged when it was involved in an accident near Quail Heights, Florida. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code…NTSB ERA26LA109Accident · Minor injuriesClass 3 · LimitedPreliminary reportHawker Beechcraft G36 · Gainesville, GAOn February 09, 2026, about 1732 eastern standard time, a Beechcraft G36, N229TT, was substantially damaged when it was involved in an accident near Gainesville, Georgia. The pilot and flight instructor were uninjured, and two occupants of separate…NTSB ERA26FA110Accident · Serious injuriesClass 3 · FieldPreliminary reportPipistrel Taurus 503 · Boynton Beach, FLOn February 9, 2026, about 1514 eastern standard time, a Pipistrel Taurus 503 motorglider, N414HG, was substantially damaged when it was involved in an accident at Willis Gliderport (FA44), Boynton Beach, Florida. The pilot was seriously injured. The…NTSB GAA26WA108Accident · Minor injuriesClass 5 · ForeignCessna 172M · Mangalur, IndiaNTSB GAA26WA110Incident · No injuriesClass 5 · ForeignAir Tractor AT502 · Paranatinga, BrazilNTSB GAA26WA096Accident · No injuriesClass 5 · ForeignCessna 150M · San Salvador, El SalvadorNTSB ERA26FA106Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR22 · Lexington, SCOn February 6, 2026, at 0921 eastern standard time, a Cirrus Design Corp SR22, N705CD, was substantially damaged when it was involved in an accident near Lexington, South Carolina. The commercial pilot sustained serious injuries and the passenger was fatally…NTSB CEN26FA109Accident · 1 fatalClass 3 · FieldPreliminary reportRobert G Elves Tarragon (Tarr) · Shawmut, AZOn February 6, 2026, at 1532 mountain standard time, a Tarragon airplane, N35RR, was substantially damaged when it was involved in an accident near Shawmut, Arizona. The pilot was fatally injured and the passenger received serious injuries. The airplane was…NTSB ERA26LA105Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C · Brimfield, OHThe pilot’s failure to use carburetor heat during descent in cold temperatures, which resulted in a total loss of engine power at an altitude too low for recovery.NTSB GAA26WA106Accident · Minor injuriesClass 5 · ForeignCessna 182 · Carumba, BrazilNTSB ERA26LA098Accident · Minor injuriesClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA 40 NG · Bay Minette, ALOn January 27, 2026 at 1439 central standard time, a Diamond Aircraft Ind. Inc. DA-40 NG, N708BL, was substantially damaged when it was involved in an accident near Bay Minette, Alabama. The flight instructor and student pilot sustained minor injuries. The…NTSB GAA26WA080Accident · Minor injuriesClass 5 · ForeignAir Tractor AT401 · Planalto da Serra, BrazilNTSB GAA26WA077Accident · Serious injuriesClass 5 · ForeignCessna T-206H · Saltillo, Coahuila, MexicoNTSB CEN26LA094Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172K · Amery, WIOn January 16, 2026, about 1130 central standard time, a Cessna 172 airplane, N79118, was substantially damaged when it was involved in an accident near Amery, Wisconsin. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 172E · Kingman, AZThe pilot’s failure to use a pre-takeoff checklist, which resulted in the fuel selector being in the off position, and subsequent loss of engine power during takeoff.NTSB GAA26WA079Accident · No injuriesClass 5 · ForeignAir Tractor AT502 · Barreiras, BrazilNTSB ERA26LA093Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 177 · Ocoee, TNOn January 13, 2026, about 1530 eastern standard time, a Cessna 177B, N34959, was substantially damaged when it was involved in an accident near Ocoee, Tennessee. The pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA091Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-180 · Port St. Lucie, FLOn January 10, 2026, about 1925 eastern standard time, a Piper PA-28-180, N6516J was substantially damaged when it was involved in an accident near Port St. Lucie, Florida. The pilot and passenger sustained serious injuries. The airplane was operated as a…NTSB DCA26WA092Incident · No injuriesClass 5 · ForeignSaab SF340 · Auckland, New ZealandNTSB WPR26LA078Accident · No injuriesClass 3 · LimitedPreliminary reportBeech K35 · Prescott, AZOn January 7, 2026, at about 0809 mountain standard time, a Beech K35, N6010E, was substantially damaged when it was involved in an accident near Prescott, Arizona. The pilot and flight instructor were not injured. The airplane was operated as a Title 14 Code…NTSB CEN26LA079Accident · No injuriesClass 3 · LimitedPreliminary reportCanard Aero SW-51 Mustang · Fredericksburg, TXOn January 5, 2026, about 1545 central standard time, a Canard Aero LLC (Scalewings) SW-51 Mustang, N351MT, was substantially damaged when it was involved in an accident near Fredericksburg, Texas. The pilot was not injured. The airplane was operated as a…NTSB GAA26WA065Accident · Serious injuriesClass 5 · ForeignNavion 145 · San Antonio Oeste, ArgentinaNTSB GAA26WA061Accident · No injuriesClass 5 · ForeignCessna T188 · Biobio Region, ChileNTSB CEN26LA074Accident · Minor injuriesClass 3 · LimitedFinal reportPitts S1S · Carbondale, ILA loss of engine power due to fuel starvation resulting from an uncommanded change to the fuel servo mixture position due to the improperly installed mixture cable.NTSB ERA26LA078Accident · Serious injuriesClass 3 · LimitedPreliminary reportBeech B90 · Atlanta, GAOn December 28, 2025, about 0935 eastern standard time, a Beech B90 airplane, N40BA, was substantially damaged when it was involved in an accident near Atlanta, Georgia. The pilot received minor injuries, and the copilot was seriously injured. The airplane…NTSB CEN26LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Taylor, TXThe pilot’s inadequate preflight inspection that resulted in a loss of engine power due to water contamination.NTSB CEN26LA082Accident · No injuriesClass 3 · LimitedPreliminary reportWag Aero Cuby · Wimberley, TXOn December 26, 2025, about 1630 central standard time, a Wag Aero Cuby airplane, N437WT, was substantially damaged when it was involved in an accident near Wimberley, Texas. The airplane was operated as a Title 14 Code of Federal Regulations Part 91 personal…