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 WPR26LA072Accident · No injuriesClass 4 · LimitedFinal reportZenith 750 · Yacolt, WAA loss of engine power for undetermined reasons.NTSB GAA26WA055Accident · No injuriesClass 5 · ForeignCessna A188 · Chuy, UruguayNTSB ERA26LA073Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172P · Browns Corner, VAOn December 20, 2025, at 1415 eastern standard time, a Cessna 172P airplane, N54576, was substantially damaged when it was involved in an accident near Quinton, Virginia. The private pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB CEN26LA066Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Springfield, MOOn December 20, 2025, about 1302 central standard time, a Cirrus SR22 airplane, N242AZ, was substantially damaged when it was involved in an accident near Springfield, Missouri. The pilot and passenger were not injured. The airplane was operated as a Title 14…NTSB GAA26WA056AccidentClass 5 · ForeignCessna 172 · Port Harcourt, NigeriaNTSB GAA26WA050Accident · No injuriesClass 5 · ForeignCessna 172 · Waterford, IrelandNTSB GAA26WA048Accident · Minor injuriesClass 5 · ForeignCessna 172N · Serakseevo township, RussiaNTSB GAA26WA049Accident · Minor injuriesClass 5 · ForeignPiper PA-28-160 · Lake Mavrovo, North MacedoniaNTSB CEN26LA060Accident · Serious injuriesClass 3 · LimitedPreliminary reportSonerai II · Cresson, TXOn December 12, 2025, about 1431 central standard time, a Sonerai II airplane, registration N28MD, was substantially damaged when it was involved in an accident near Cresson, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code…NTSB GAA26WA186AccidentClass 5 · ForeignCessna 208 · Kalumburu, AustraliaNTSB GAA26WA047Accident · Minor injuriesClass 5 · ForeignCessna 172 · Trinidad, BoliviaNTSB DCA26WA138Incident · No injuriesClass 5 · ForeignATR ATR42 · Hakodate, JapanNTSB ERA26LA065Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Cocoa, FLThe flight crew’s failure to adequately manage the available fuel onboard the airplane, which resulted in a total loss of power due to fuel starvation.NTSB ERA26LA063Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · DeLand, FLThe flight instructor’s inadequate fuel quantity inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB DCA26WA075IncidentClass 5 · ForeignBoeing 737 · Balice, PolandNTSB GAA26WA042Accident · No injuriesClass 5 · ForeignPiper PA32RT · Maracaibo, VenezuelaNTSB ERA26LA061Accident · Minor injuriesClass 3 · LimitedPreliminary reportMooney M20K · Foley, ALOn December 3, 2025, about 1600 central standard time, a Mooney Aircraft Corp. M20K, N57229, was substantially damaged when it was involved in an accident near Foley, Alabama. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB ERA26LA056Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-24-180 · South Brooksville, FLOn November 24, 2025, about 1427 eastern standard time, a Piper PA-24-180, N8328P, was substantially damaged during a forced landing near South Brooksville, Florida. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code…NTSB ERA26LA052Accident · No injuriesClass 3 · LimitedPreliminary reportToomey Long EZ · Beaufort, SCOn November 19, 2025, about 1630 eastern standard time, an experimental, amateur-built Long EZ, N82MT, was substantially damaged when it was involved in an accident near Beaufort, South Carolina. The private pilot was not injured. The airplane was operated as…NTSB ERA26LA050Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 401 · Eureka, NCOn November 18, 2025, at 12:30 eastern standard time, a Cessna 401A, N6255Q, was substantially damaged when it was involved in an accident near Eureka, North Carolina. The commercial pilot received minor injuries. The airplane was operated as a Title 14 Code…NTSB GAA26WA028Accident · No injuriesClass 5 · ForeignPiper PA28 · Cambridgeshire, United KingdomNTSB ERA26LA040Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-32R-301T · Woodfin Mill, GAOn November 16, 2025, about 0845 eastern standard time, a Piper Pa-32R-301T, N327HP, was substantially damaged when it was involved in an accident near Woodfin Mill, Georgia. The commercial pilot sustained minor injuries. The airplane was operated as a Title…NTSB GAA26WA026AccidentClass 5 · ForeignRobinson R-66 · Wellington, New ZealandNTSB ERA26LA055Accident · No injuriesClass 3 · LimitedPreliminary reportPerry William Lancair IV P · Savannah, GAOn November 13, 2025, at 1949 eastern standard time, an experimental amateur-built Lancair IV-P, N163BR, was substantially damaged when it was involved in an accident near Savannah, Georgia. The pilot and passenger were uninjured. The airplane was operated as…NTSB CEN26LA046Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Teague, TXOn November 13, 2025, about 1430 central standard time, a Cirrus SR22 airplane, N79EM, was substantially damaged when it was involved in an accident near Teague, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB CEN26LA042Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-235 · Castle Rock, COOn November 10, 2025, about 1815 mountain standard time, a Piper PA-28-235 airplane, N9143W, was substantially damaged when it was involved in an accident near Castle Rock, Colorado. The pilot and one passenger reported no injuries. A second passenger…NTSB ANC26LA006Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-14 · Talkeetna, AKOn November 8, 2025 about 1300 Alaska standard time, a Piper PA-14 airplane, N5188H, was substantially damaged when it was involved in an accident near Talkeetna, Alaska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA26WA020Accident · No injuriesClass 5 · ForeignCessna 172 · Trinidad, BoliviaNTSB CEN26FA034Accident · 1 fatalClass 3 · FieldPreliminary reportFunk B85C · Anderson, INOn November 4, 2025, about 12:45 eastern standard time, a Funk B85C airplane, N24157 was destroyed when it was involved in an accident near Anderson, Indiana. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of…NTSB WPR26LA036Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Sedona, AZOn November 3, 2025, about 0830 mountain standard time, a Cirrus SR-22, N237RJ, sustained substantial damage when it was involved in an accident near Sedona, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB ERA26FA027Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20E · Ballston Spa, NYOn October 31, 2025, about 1035 eastern daylight time, a Mooney M20E, N79338, was destroyed when it was involved in an accident near Ballston Spa, New York. The pilot was fatally injured, and the flight instructor was seriously injured. The airplane was…NTSB WPR26LA037Accident · No injuriesClass 3 · LimitedPreliminary reportGrumman American Avn. AA-5B · Santa Ynez, CAOn October 29, 2025, about 1820 Pacific daylight time, a Grumman American AA-5B, N74323, was substantially damaged when it was involved in an accident near Santa Ynez, California. The commercial pilot was not injured. The airplane was operated as a Title 14…NTSB WPR26LA034Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28R-200 · La Verne, CAOn October 28, 2025, about 1845 Pacific daylight time, a Piper Arrow PA-28R-200, N5107S, sustained substantial damage when it was involved in an accident near Upland, California. The pilot and passenger were not injured. The airplane was operated as a Title…NTSB CEN26LA031Accident · No injuriesClass 3 · LimitedPreliminary reportDenney Kitfox · Chilton, TXOn October 27, 2025, about 0530 central daylight time, a Denney Kitfox III airplane, N5241N, was substantially damaged when it was involved in an accident near Chilton, Texas. The pilot and passenger were not injured. The airplane was operated as a Title 14…NTSB CEN26LA030Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-46-310P · El Paso, TXOn October 26, 2025, about 918 mountain daylight time, a Piper PA46-310P, N46CR, was substantially damaged when it was involved in an accident near El Paso, Texas. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA024Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Somerville, TNOn October 24, 2025, about 1815 central daylight time, a Piper PA-28-140, N3905F, was substantially damaged when it was involved in an accident at Fayette County Airport (FYE), Somerville, Tennessee. The pilot sustained minor injuries. The airplane was…NTSB CEN26LA029Accident · Serious injuriesClass 3 · LimitedPreliminary reportBeech 35-33 · Flippin, AROn October 23, 2025, about 1713 central daylight time, a Beech 35-33 airplane, N864R, was substantially damaged when it was involved in an accident near Flippin, Arkansas. The pilot sustained serious injuries. The airplane was operated as a Title 14 Code of…NTSB WPR26LA030Accident · Serious injuriesClass 3 · LimitedPreliminary reportRutan Long-EZ · Long Beach, CAOn October 20, 2025, about 1603 Pacific daylight time, an experimental amateur-built Rutan Long-EZ, N8183K, was substantially damaged when it was involved in an accident in Long Beach, California. The pilot was seriously injured, and a pedestrian on the…NTSB WPR26LA023Accident · Minor injuriesClass 4 · LimitedFinal reportHawker Hawker Hunter MK.58 · Big Sur, CAA complete loss of engine power for reasons that could not be determined.NTSB DCA26WA056Incident · No injuriesClass 3 · ForeignBoeing 737 · Buenos Aires, ArgentinaNTSB ERA26LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · North Lauderdale, FLA total loss of engine power due to a fuel delivery system leak, which allowed air to enter the fuel system. The source of the leak could not be determined based on the available evidence.NTSB WPR26LA012Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA24 · Vineyard, UTOn October 7, 2025, about 1825 mountain daylight time, a Piper PA24 airplane, N7946P, was substantially damaged in an accident near Vineyard, Utah. The pilot and pilot-rated passenger were not injured. The flight was conducted under Title 14 Code of Federal…NTSB GAA26WA005AccidentClass 5 · ForeignRobinson R44 · Horn Island, AustraliaNTSB ANC26LA001Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Petersburg, AKOn October 7, 2025, at 1456 Alaska daylight time, a Cessna 172 airplane, N80628, was substantially damaged when it was involved in an accident near Petersburg, Alaska. The student pilot and flight instructor were not injured. The airplane was operated as a…NTSB ERA26LA004Accident · No injuriesClass 3 · LimitedPreliminary reportPitts S1C · Mount Washington, KYOn October 6, 2025, about 1415 eastern daylight time, a Pitts S-1C Special, C-FAZJ, was substantially damaged when it was involved in an accident in Mt. Washington, Kentucky. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA008Accident · Serious injuriesClass 3 · LimitedPreliminary reportLancair 320 · Huron, INOn October 4, 2025, about 2130 central daylight time, a Lancair 320 airplane, N431M, was destroyed when it was involved in an accident near Huron, Indiana. The pilot was seriously injured. The airplane was operated under Title 14 Code of Federal Regulations…NTSB ERA26LA002Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260 · Parkland, FLThe pilot’s failure to retract the amphibious airplane’s landing gear before conducting a forced landing on the water, which resulted in a nose over.NTSB ERA26LA001Accident · Minor injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Talladega, ALOn October 2, 2025, at 1126 central daylight time, a Cirrus SR22, N812SE, was substantially damaged when it was involved in an accident near Talladega, Alabama. The commercial pilot sustained minor injuries, and the two passengers were not injured. The…NTSB GAA26WA001Incident · No injuriesClass 5 · ForeignCessna F172 · Durup, DenmarkNTSB CEN26LA003Accident · No injuriesClass 4 · LimitedFinal reportQuartz Mountain Aerospace 11E · Earlham, IAThe flight instructor’s inadequate fuel management which resulted in the total loss of engine power due to fuel exhaustion.